Unsupported Screen Size: The viewport size is too small for the theme to render properly.

The Server Understood The Request, But Will Not Fulfill It.

forums forums SQLyog SQLyog Comments The Server Understood The Request, But Will Not Fulfill It.

Tagged: ,

  • This topic is empty.
Viewing 3 reply threads
  • Author
    • #13413

      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?

    • #35488

      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).

    • #35489

      Hi Peter


      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.

    • #35490

      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.

Viewing 3 reply threads
  • You must be logged in to reply to this topic.