- This topic is empty.
September 16, 2015 at 9:45 pm #13413sarahkMember
For the last few years I’ve done a daily backup of a number of sites but suddenly one of them “fails” with the error on a specific table
The server understood the request, but will not fulfill it.
The backup works for everything but the affected table. The table looks fine and I can “optimize” but it looks like something may be locking it, perhaps?
Is there an easy explanation for this?
September 17, 2015 at 7:55 am #35488peterlaursenParticipant
This happens with HTTP tunnel, I think?
Anyway, if you have SUPER privilege then try to SHOW FULL PROCESSLIST and kill threads having been idle for very long time (or restart MySQL would also terminate any locks, it this is the problem).
September 21, 2015 at 5:51 am #35489sarahkMember
Yes it’s tunnelling.
SHOW FULL PROCESSLIST returns a one line result with the time column showing zero.
The site is on shared hosting so I have no ability to get in and restart mysql etc.
The backup runs and the remaining tables back up ok.
September 22, 2015 at 12:09 pm #35490peterlaursenParticipant
hmmmm .. one idea and a few more questions
1) Try lowering CHUNKS and/or BULKS. Refer http://faq.webyog.com/content/24/101/en/about-chunks-and-bulks.html. Note that the setting in ‘preferences’ has no effect for ‘scheduled backup’. The settings are in the wizard – please see image [attachment=2043:chunkbulk.jpg].
2) Can you view the table in SQLyog “Data” tab?
3) Is it a very big table?
If 1) does not help. I think you will have to contact your hosting support for help with this. There may be some permissions issue or some setting on this server allowing only small amounts of data to be processed per query.
- You must be logged in to reply to this topic.