WordPress 5.9 breaks MySQL server “Database Update Required”

  • I have no idea what you have done with “Database Update Required” its impossible to get past it without you crashing the MariaDB.

    I upgraded my WordPress website to 5.9, it gives me “Database Update Required” No matter what I do, it 500 times out and the only way to bring my website back up is to restart MariaDB.

      I rebooted the VPS
      I increased Maximum packet size in MariaDB
      I have increased PHP memory to 128M
      I have increased PHP upload size to 10mb
      I have increased PHP execution time to 300 seconds
      I have disabled all plugins
      I have run the database upgrade from wp-cli
      I have disabled zend.ze1_compatibility_mode from a random blog post

    What on earth are you doing. Why can I not progress past “Database Update Required” with a VPS, massive increase in settings from CLI or web.

    What, have, you, done, you are breaking mariadb and the only fix is to restart it, it breaks all my other websites too.

    This needs to be fixed.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    I’m running several sites on Maria 10.x and the update went successfully. On the one site I updated manually (just unzipped and rsync’d files), I got a prompt to update the database, but that went OK. This isn’t a giant, global error, but something peculiar to your environment.

    Are there any errors in the logs? On my system, it’s /var/log/mariadb/mariadb.log

    I’m also wondering if the upgrade is causing problems due to some error in one of your tables, so use PHPMYADMIN or use mysqlcheck from the command line to check the integrity of the db and tables and repair what’s necessary.

    Thread Starter Tom

    (@godsdead)

    @sterndata Right, more digging and I found the issue but have no idea how to fix it.

    I do not seem to have any logs created for cat: /var/log/mariadb/mariadb.log: No such file or directory.

    I repaired and optimised the database as you said, then out of curiosity I looked at SHOW VARIABLES LIKE 'max_connections'; and then show status where variable_name = 'threads_connected'; Turns out that this process is filling up all the max_connections, so I increased it from 151 to 512, ran it again, and it never completes, it constantly keeps creating more and more and more and more threads until it finally reaches 512.
    Nearly all of them are Waiting for table level lock | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'

    But just before that there is this that seems to be stuck in perminant processing.

    
| 53764 | wordpress_db | localhost       | dbusername | Query   | 3220 | Sending data                 | DELETE a, b FROM wp_options a, wp_options b
				WHERE a.option_name LIKE '\\_site\\_transient\\_%'
	 |    0.000 |

    heres the full output:
    https://gist.github.com/TomLewis/af884179358406d2ea4d7c7d65a5523a

    • This reply was modified 3 years, 2 months ago by Tom.
    Thread Starter Tom

    (@godsdead)

    I have no idea what actually fixed it, but I tried again and it randomly worked.

    View post on imgur.com

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WordPress 5.9 breaks MySQL server “Database Update Required”’ is closed to new replies.