Database Update Fails –> Error Est DB Connect

  • Resolved thburkart

    (@thburkart)


    11 years, 1 month ago

    hi,
    i am at my wits end here. for the second time in a week, i am locked out of dashboard bc of wordpress updates.

    when i try to get to wp-admin, it takes me to “Database Update Required

    WordPress has been updated! Before we send you on your way, we have to update your database to the newest version.

    The update process may take a little while, so please be patient.

    Update WordPress Database”

    This times out after 60 seconds, taking me to site 404 page. If i try to run it again, the site goes down completely with “Error Establishing Database Connection”

    STEPS TAKEN SO FAR –

    I have reviewed and implemented all the database tips in the Master guide.

    — Overwritten all WP-admin and wp-includes files and folders manually update files manually via FTP
    — deactivated all plugins
    — changed cache filenames

    PLEASE help. Bluehost not able to find a problem and cannot fix.

    Totally locked out of dashboard and admin, unable to post anything.

Viewing 1 replies (of 1 total)
  • Thread Starter thburkart

    (@thburkart)

    11 years, 1 month ago

    Hey guys,
    I have diagnosed and found a fix for this issue. It was challenging but want to share here for those with big databases who were unable to complete the latest WP update.

    — problem:

    Here is the error that apache is posting when that upgrade process is attempted to be run:
    >
    > [Fri May 08 08:37:22 2015] [error] [client 69.195.125.226] Premature end of script headers: upgrade.php, referer: http://www.example.com/wp-admin/upgrade.php?_wp_http_referer=%2Fwp-admin%2F
    > [Fri May 08 09:00:54 2015] [warn] [client 69.195.125.226] mod_fcgid: read data timeout in 40 seconds, referer: http://www.example.com/wp-admin/upgrade.php?_wp_http_referer=%2Fwp-admin%2F
    >
    > That is due to the mod_fcgid timeout limit.
    >
    > To fix this you will need to increase that timeout limit from 40 seconds to something higher, such as 90 or 120 seconds:
    >
    > FcgidIOTimeout 1234 (or whatever number of seconds you want) will need to be added to the file /usr/local/apache/conf/includes/pre_virtualhost_global.conf with the timeout setting that you desire.
    >
    > After you do this please go into whm and restart apache.

    — Where to find the mod_fcgid file to add the new code?

    Web Host Manager –> Apache Configuration –> Include Editor

    From here, you have three places you can add code. You want to add it in the “PRE” section.

    Pre VirtualHost Include –> All Versions

    Add this code:
    <IfModule mod_fcgid.c>
    FcgidProcessLifeTime 82000
    FcgidIOTimeout 82000
    FcgidConnectTimeout 4000
    FcgidMaxRequestLen 1073741824
    </IfModule>

    Hopefully this helps someone in the future.

    For me, once I had added a huge timeout limit of 82000, I could run the WP “database update required”

    It ran for a loooong time and then eventually timed out like usual. But after about an hour, i was miraculously able to get into WP dashboard with most current WP version 4.2.2.

    SIDE NOTE:
    How big is my database that this was an issue? It is HUGE. COmes in a 1.1GB. Most of that size and amount of rows was in the “postmeta” database table.

    I ran a variety of SQL cleanup scripts through MyPHPadmin. none made much difference, until i deleted all rows with “SIZE” meta key. this was 127,000 rows all by itself.

Viewing 1 replies (of 1 total)

The topic ‘Database Update Fails –> Error Est DB Connect’ is closed to new replies.