[wp-testers] 3.2 You do not have permission to do that Error

Tue Jun 21 07:22:05 UTC 2011

Hey Guys,

I apologize for delays. The error came back, however I could not catch it in
time and just for precaution e-mail was sent to HostGator to check if they
have any issues. And it turns out they do.

For educational purposes this is what happend.

xxxx = db and dbuser

The servers are limited at 25 DB connections per user and 150
max_connections server wide. When you see that message it's because the
mysql server is unavailable to users due to having exceeded
max_connections.

We have a script in place that kills slow queries, a slow query is any query
taking longer than 2 seconds to complete. We then log these entries. I'm
seeing several entries for your user

[ Fri Jun 17 20:39:01 2011 ] [ DELAYED ] [ 9570957 ] [ 23 ] [ xxxx ] [
Delayed insert ] [ KILLED ] [ 'gator1255.hostgator.com' ] [ ]
[ Fri Jun 17 23:06:01 2011 ] [ DELAYED ] [ 9653518 ] [ 22 ] [ xxxx ] [
Delayed insert ] [ KILLED ] [ 'gator1255.hostgator.com' ] [ ]
[ Sat Jun 18 11:51:01 2011 ] [ DELAYED ] [ 10135464 ] [ 37 ] [ xxxx ] [
Delayed insert ] [ KILLED ] [ 'gator1255.hostgator.com' ] [ ]
[ Sat Jun 18 12:54:01 2011 ] [ DELAYED ] [ 10173762 ] [ 26 ] [ xxxx ] [
Delayed insert ] [ KILLED ] [ 'gator1255.hostgator.com' ] [ ]
[ Sat Jun 18 17:21:02 2011 ] [ DELAYED ] [ 10343846 ] [ 36 ] [ xxxx ] [
Delayed insert ] [ KILLED ] [ 'gator1255.hostgator.com' ] [ ]
[ Sat Jun 18 21:06:01 2011 ] [ DELAYED ] [ 10470286 ] [ 40 ] [ xxxx ] [
Delayed insert ] [ KILLED ] [ 'gator1255.hostgator.com' ] [ ]
[ Sun Jun 19 15:24:01 2011 ] [ xxxx ] [ 11161205 ] [ 46 ] [ xxxx ] [ Query ]
[ KILLED ] [ 'gator1255.hostgator.com' ] [ INSERT INTO wp_who_is_online (ip,
user_id, botname, path, first_visit, last_visit, view_count) VALUE ]
[ Sun Jun 19 15:24:01 2011 ] [ xxxx ] [ 11161239 ] [ 37 ] [ xxxx ] [ Query ]
[ KILLED ] [ 'gator1255.hostgator.com' ] [ DELETE FROM wp_who_is_online
WHERE (1308515004-300) > last_visit ]
[ Sun Jun 19 15:24:01 2011 ] [ xxxx ] [ 11161294 ] [ 26 ] [ xxxx ] [ Query ]
[ KILLED ] [ 'gator1255.hostgator.com' ] [ DELETE FROM wp_who_is_online
WHERE (1308515015-300) > last_visit ]
[ Sun Jun 19 15:24:01 2011 ] [ xxxx ] [ 11161322 ] [ 19 ] [ xxxx ] [ Query ]
[ KILLED ] [ 'gator1255.hostgator.com' ] [ DELETE FROM wp_who_is_online
WHERE (1308515022-300) > last_visit ]
[ Sun Jun 19 20:42:01 2011 ] [ DELAYED ] [ 11346486 ] [ 24 ] [ xxxx ] [
Delayed insert ] [ KILLED ] [ ] [ ]
[ Mon Jun 20 00:42:01 2011 ] [ xxxx ] [ 11470299 ] [ 114 ] [ xxxx ] [ Query
] [ KILLED ] [ 'gator1255.hostgator.com' ] [ INSERT INTO wp_who_is_online
(ip, user_id, botname, path, first_visit, last_visit, view_count) VALUE ]
[ Mon Jun 20 00:42:01 2011 ] [ xxxx ] [ 11470410 ] [ 91 ] [ xxxx ] [ Query ]
[ KILLED ] [ 'gator1255.hostgator.com' ] [ DELETE FROM wp_who_is_online
WHERE (1308548430-300) > last_visit ]
[ Mon Jun 20 00:42:01 2011 ] [ xxxx ] [ 11470503 ] [ 75 ] [ xxxx ] [ Query ]
[ KILLED ] [ 'gator1255.hostgator.com' ] [ DELETE FROM wp_who_is_online
WHERE (1308548446-300) > last_visit ]
[ Mon Jun 20 00:42:01 2011 ] [ xxxx ] [ 11470507 ] [ 74 ] [ xxxx ] [ Query ]
[ KILLED ] [ 'gator1255.hostgator.com' ] [ DELETE FROM wp_who_is_online
WHERE (1308548447-300) > last_visit ]
[ Mon Jun 20 00:42:01 2011 ] [ xxxx ] [ 11470511 ] [ 75 ] [ xxxx ] [ Query ]
[ KILLED ] [ 'gator1255.hostgator.com' ] [ DELETE FROM wp_who_is_online
WHERE (1308548446-300) > last_visit ]

This is for the xxxx database. In my limited experience, any 'tracker' type
plugins that make database writes based on visits are inefficient and cause
these type of issues.

Now the only tracker that I have is Jetpack and nothing else. The FlexiCache
plugin was recommended by HostGator to improve the speed and prevent this
from happening in the future and as you can see that it did not prevent
anything at all.

By the way this is a shared hosting so called Business Plan with *Unlimited*
everything but DB connections. HG Linux Admin blames WordPress for
connecting with DB each time the page is refreshed and as usual that none of
this is their fault ;)

Sorry for the false alarm,
Emil

----
*Emil Uzelac* | ThemeID | T: 224-444-0006 | Twitter: @EmilUzelac | E:
emil at themeid.com | http://themeid.com
Make everything as simple as possible, but not simpler. - Albert Einstein

On Mon, Jun 20, 2011 at 7:04 PM, Emil Uzelac <emil at themeid.com> wrote:

> Will do and here are some additional information:
>
> Site: http://themeid.com (I am working on redesign please excuse the dust)
> This is a very basic Theme.
>
> Browser: Google Chrome 12
> Browser Settings: Default
> OS: OS X 10.6.7
> Plugins: Activated: FlexiCache, Jetpack, Maintenance Mode, WordPress
> Importer, WordPress Beta Tester, WordPress SEO (Yoast). Deactivated: Log
> Notices, Theme Check, Debogger.
> WP_DEBUG: False
>
> The steps to this "error" are simple: Opened the page and started editing
> and writing new content for already published About Us page. As I was going
> back and forward over my Chrome tabs, came back to About Us and voila, the
> error was there. Now the thing is that even without the "Update" button the
> message fades away after 30 secs or so.
>
> And I was logged in and not sure why or if I was logged out by the system.
>
> Cheers,
> Emil
> PS I am going to pick up my daughter and when I come back
> the additional test will be done as well.
>
> ----
> *Emil Uzelac* | ThemeID | T: 224-444-0006 | Twitter: @EmilUzelac | E:
> emil at themeid.com | http://themeid.com
> Make everything as simple as possible, but not simpler. - Albert Einstein
>
>
>
> On Mon, Jun 20, 2011 at 6:45 PM, Andrew Nacin <wp at andrewnacin.com> wrote:
>
>> On Jun 20, 2011 6:51 PM, "Emil Uzelac" <emil at themeid.com> wrote:
>> >
>> > Few moments ago the same error showed up again, this time the entire
>> content
>> > on that specific page was gone (blank white page in editor only). After
>> I
>> > clicked on the "Update" button, everything came back. Should I create a
>> > ticket for this or not?
>> >
>> > Cheers,
>> > Emil
>>
>> We just don't have enough information here. When this happens again,
>> please
>> inspect the HTTP calls, specifically XHR ones. If necessary re-trigger an
>> autosave via the console and see what the response is.
>>
>> What browser? Cookie, JS settings all normal? Seems like you might be
>> getting logged out. Default theme, no plugins?
>>
>> Nacin
>> _______________________________________________
>> wp-testers mailing list
>> wp-testers at lists.automattic.com
>> http://lists.automattic.com/mailman/listinfo/wp-testers
>>
>
>