database error WordPress-Datenbank-Fehler Server shutdown in progress f\xc3\xbc

  • Resolved juergenke

    (@juergenke)


    10 years, 1 month ago

    Hi,

    i get a database error int he last few days very often – actually up to 20 times a day with this error message:

    [Fri Feb 13 10:37:33 2015] [error] [client 91.34.210.222] WordPress-Datenbank-Fehler Server shutdown in progress f\xc3\xbcr Abfrage SELECT * FROM k0ilxkcgr1_wppa_albums WHERE a_parent = ’34’ von require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/arthemia/page.php’), the_content, apply_filters(‘the_content’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, wppa_shortcodes, wppa_albums, wppa_theme, wppa_album_cover, wppa_album_cover_default, wppa_the_album_title, wppa_is_album_new

    The database-server restarts mostly after this error and sometimes databases crash (for example wppa_fotos) and i have to repair them manually.

    Have >22.000 Photos online and albums with 500 and more photos in it.

    https://neuburg-events.de

    Any idea?

    Thanks a lot!

    https://www.ads-software.com/plugins/wp-photo-album-plus/

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Jacob N. Breetvelt

    (@opajaap)

    There is nothing wrong with the query:
    SELECT * FROM k0ilxkcgr1_wppa_albums WHERE a_parent = '34'

    WPPA can problemless handle system with up to 450.000 photos and 3500 albums; If the server memory is 128Mb there is a known problem with slideshows when the album has over 25000 photos, so you do have not a capacity problem.

    Maybe the db server is a bit overloaded?

    Can you please tick the box in Table IX-A3: Allow WPPA+ Debugging, then i can see more, also timings etc.

    Thread Starter juergenke

    (@juergenke)

    Thanks so far,

    i just activated Debugging.

    Best regards

    Thread Starter juergenke

    (@juergenke)

    by the way: Is there a shortcode available to show only the last 10 albums on a page with [wppa]?

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    [wppa type="cover" album="#last,0,3"]Any comment[/wppa] shows you the covers of the 3 most recently modified albums with parent 0, so, the 3 albums that have most recently uploaded photos in it, and with parent = —none—

    See also: https://wppa.opajaap.nl/shortcode-reference/ :

    #last,p,k The k most recently modified albums with parent album p. These are most likely the albums that have the most recently uploaded photos. Parent p may also be an album name preceded by a $ sign.

    Note: Uploading a photo to an album as well as changing album info renewes the dat/time modified, and bumps it up in this list.

    —–

    It is – to my opinion – NOT possible, but can you verify that there is no circular reference in album parent pointers? I.E. a situation where a parent’s parent’s … parent is the album you start with?
    The program can not create such situation, but you may accidently craeted it by manually modifying the wppa_album db table.

    Does the errormessage refer to the same album every time? or is it a random album number that causes the problem. If every time the same, check this album and its parents/children for the sketched problem.

    Thread Starter juergenke

    (@juergenke)

    The database error happens at different, random albums.
    Did you get any debug-information that could help?

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Not really yet, takes some more testing. I will look further tomorrow. Please leave the debug switch on. It does no harm and is no security vulnerability.

    Thread Starter juergenke

    (@juergenke)

    Ok, just another quick question:
    Can i gloabally deactivate the slideshow function, so that only pics in “thumbs” modus are shown, but clicking (and switch to slideshow modus) is disabled?
    Would be enough for my readers to see the thumbs….

    Thread Starter juergenke

    (@juergenke)

    Ignore my last question, found it by myslef, thanks ??

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    I did several tests, but i can not find any strange behaviour.
    If you still have the issue, ask your hosting provider to see if there is a performance or overload problem on the database server.

    Thread Starter juergenke

    (@juergenke)

    Thanks a lot,

    since i deactivated the links to the slideshow inside the albums, i had no more crashes…..
    For me thats ok, i will only use previews without slideshows in future, that seems to work now.

    Thank you and best regards

    Jürgen

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘database error WordPress-Datenbank-Fehler Server shutdown in progress f\xc3\xbc’ is closed to new replies.