MySQL 2013 errors almost every time I try to edit or publish entries
Development and Programming
Mod : Split from thread
I’m having very similar experiences on my MT (gs) host. I get MySQL 2013 errors almost every time I try to edit or publish entries. Sometimes if I refresh I can finally get the edit page to come up, but then often get the same error again when publishing edits. And even when I get a blank screen or a MySQL error after saving edits NOT ALL CHANGES ARE SAVED. My EE install is practically useless for the past 2 days because of this.
I’ve contacted MT for support. They given me a free 30 day trial to move my MySQL to their MySQL Container service which get’s it out of the clogged up shared environment. However after that change no improvement at all. Still same errors all the time.
Is this most likely a server issue that my host should sort out or is there possibly something wrong with my EE install that could be causing this? I haven’t made any changes at all to any of my EE files recently but over the past few days it’s like my database just completely died. Front-end public facing pages seem to work fine almost all of the time though. What can I do!!!!???
benek,
What version and build of EE are you using?
What are the exact errors you are receiving?
Have you tried the repair and optimize database as suggested in the related thread?
Do you have any extensions installed?
What version and build of EE are you using?
1.6.8
What are the exact errors you are receiving?
I’ve received a few different versions of MySQL 2013 errors with different queries. Here are some examples below:
MySQL ERROR:
Error Number: 2013
Description: Lost connection to MySQL server during query
Query: SELECT field_fmt FROM exp_field_formatting WHERE field_id = ‘11’ AND field_fmt != ‘none’ ORDER BY field_fmt
MySQL ERROR:
Error Number: 2013
Description: Lost connection to MySQL server during query
Query: SELECT entry_id, title FROM exp_weblog_titles WHERE weblog_id = ‘4’ ORDER BY entry_date desc
There may have been others as well but they are all of that general form.
Have you tried the repair and optimize database as suggested in the related thread?
Yes. I’ve been working with a support agent from Media Temple and as part of his troubleshooting process he has done the database repair and optimize for me.
Do you have any extensions installed?
Yes, many of them:
FieldFrame (v.1.3.3) Accessible Captcha (v.1.0.3) Solspace UI (v.1.0.0) Low Seg2Cat (v.1.0.2) LG Twitter (v.2.0.2) VC Searchable Titles (v.0.2) Clone Entries (v.1.1) Tag Submit (v.2.6.4) Structure Extension (v.1.2.5) jQuery for the Control Panel (v.1.1.1) Solspace Software Update (v.1.0.1) Rating (v.2.3.2) Low NoSpam (v.1.0.4) DC Required Category (v.1.0.5)
Most of these are quite vital to the site so I don’t think I’m going to have the option of disabling all of them.
Here is a copy of the latest response I received from my MT support guy:
As a courtesy, in an attempt to troubleshoot this issue, I have; 1. increased many of the resource stats regarding MySQL performance in your GridContainer. (my.cnf editor) 2. modified your php.ini file to provide additional memory to your (gs) Grid-Service specifically for php processes. 3. run through several suggestions from the EE forums regarding performance (http://expressionengine.com/wiki/Reduce_Queries/ ). 4. thoroughly tested other php/MySQL connections confirm functionality of the GridContainer you can check with http://www.weddingwise.co.nz/mysqltest.php 5. ran the repair and optimize routines on your MySQL databases After all these attempts I am still seeing latency regarding the editing of the weblog entries and occasional dropped connections for the specific query: SELECT entry_id, title FROM exp_weblog_titles WHERE weblog_id = ‘4’ ORDER BY entry_date desc [Benek’s note: I don’t think it is just that query. I’m still getting the MySQL errors for other queries as seen in my error messages above] All other areas of the weblog entry appear to be speedy and without connection issue. This symptom ( and the numerous online recommendations I read) lead me to believe the issue is related to one of the many Extensions/Plug-ins/Modules you have enabled on this install. I would highly recommend going through these and temporarily disable all but only the absolute necessary of these add-ons (if not all of them) to determine if one of these is the culprit. I have run the query by itself within phpMyadmin and it opens the connection, queries the data, and populates the response very quickly.Ultimately, troubleshooting 3rd party applications would be outside the scope of support. We can only offer technical support for the core services related to the (gs) Grid-Service and our network.
So it looks like one of the add-on is probably to blame. However, the odd thing is that this behavior has just gotten really bad in the past 3 days but I have not made any changes to add-ons for weeks or maybe months. If it was a problem with one of my extensions why did it wait until just now to show up?
Is there any way to tell which add-on might be causing the problem without disabling them? I’d like to avoid disrupting the site as much as possible.
Would greatly appreciate any help on this. It’s become a completely site-crippling issue and we’re in an important part of the site development when we need to be publishing and editing a lot of content but we can’t do that at all right now.
Regards, Benek
Benek - if you disable all extensions temporarily (green button in the upper right of the extensions page) do these errors disappear? that is something we need to find out before we figure out where to go.
Will I lose any settings or other data if I disable them and then re-enable them?
If you use the green button to disable all extensions your data will be untouched. If you disable individual extensions, the data will be removed. So use the green button. =)
Temporarily disabled all extensions and problem appears to go away.
What’s the next step?
The next step you are not going to love.
You have to disable each individual extension (yes, that means data loss) and figure out which one it is, or if it is a conflict/collision between extensions. It would likely be best for you to do this testing on a dev server so as not to interrupt your live site.
I’m going to leave this here for now, but it will likely end up moved to the Extensions forum since it does not appear to be a problem if Extensions are disabled.
What kind of data will I lose? Is it just the extension settings?
Yes, the data connected with every extension. Your site’s data is not affected. Even so do make a db backup first.
I’m pretty sure I’ve narrowed it down to FieldFrame being the culprit. (Bummer – that’s an important one!)
I guess it’s time I head on over to Brandon Kelly’s support forums then.
Yep, and I’m going to shift this down to the Extensions forum as well.
I’ve gone through some more troubleshooting with this issue over at the FieldFrame community and narrowed the issue down to nGen File Field and it’s “get file list” feature.
Started a more targeted new thread on the subject at: http://ellislab.com/forums/viewthread/137648/