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 contains 2 replies, has 0 voices, and was last updated by  peterlaursen 2 years, 9 months ago.

  • Author
    Posts
  • September 16, 2015 at 9:45 pm #13413

    sarahk
    Member

    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 #35488

    peterlaursen
    Participant

    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 #35489

    sarahk
    Member

    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.

  • September 22, 2015 at 12:09 pm #35490

    peterlaursen
    Participant

    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.

  • Author
    Posts

You must be logged in to reply to this topic.