MySQL Cannot Update/Write to any database table solution

This happened on Centos for no apparent reason with no obvious issue in the logs.  Data could be read fine but not written (possibly due to some corruption or out of memory issue in the OpenVZ container is the best guess).

 

All mysql update and insert queries failed freezing without any error log on any database and table.

Tried to restart:

service mysqld restart
Timeout error occurred trying to stop MySQL Daemon.
Stopping mysqld:                                           [FAILED]
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]




#manually kill mysqld and mysqld_safe

ps aux|grep mysqld
root       876  0.0  0.0   3732   584 ?        S     2017   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql     1322  2.3  4.2 484384 269240 ?       Sl    2017 12779:34 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root      2423  0.0  0.0   2360   692 pts/2    S+   13:28   0:00 grep mysqld

After manually killing everything seemed to work OK after that point.


Tags:

mysql, update, database, solutionthis, centos, apparent, logs, corruption, openvz, container, insert, queries, restart, mysqld, timeout, daemon, manually, mysqld_safe, ps, aux, grep, bin, sh, usr, datadir, var, lib, socket, pid, basedir, user, sl, libexec, plugin, dir, pts, ok,

Latest Articles

  • Unable to mount location Failed to retrieve share list from server: Connection timed out - Samba/Linux Filesharing Not working Ubuntu Mint Linux Solution
  • How To Resize, Reduce a Video to a Specific Size and Quality Ubuntu Linux using ffmpeg
  • vi how to delete all lines in the file
  • Linux Mint / Ubuntu 20 Intel I219 NIC disconnects
  • Linux can't boot/grub boot loader screen with no options solution
  • EFI PXE grub2 Howto guide for Linux EFI PXE Booting on Debian, Mint, Ubuntu, RHEL
  • Aruba/HP/Dell IAP Wireless Controller Common Default Passwords
  • Debian, Mint Ubuntu how to remove package and associated config files
  • Linux Grub not booting the intended kernel solution in Debian, Mint, Ubuntu how to specify which kernel to boot by default
  • QEMU KVM Keyboard Problems Not Working Right Repeating Characters, Ctrl+C Copy and Paste not working right when using PS2 mouse in guests Solution
  • Linux how to compile binary with static sharedobjects embedded instead of dynamic to use on multi-distributions and avoid glibc compatiblity issues
  • /bin/sh: msgfmt: not found error solution on Linux Compilation Ubuntu Debian Mint Centos
  • Mikrotik RouterOS CHR/ISO Basic and Quick Setup Howto Guide
  • qemu 4 compilation options
  • CentOS 7 8 PXEBoot Netinstall Not Working Solution "Pane is dead "new value non-exisetnt xfs filesystem is not valid as a default fs type"
  • CentOS 6 EOL yum repo won't work Error: Cannot find a valid baseurl for repo: base Solution
  • CentOS 7 8 How To Disable SELinux
  • Wordpress How To Add Featured Image To Post in Hueman Theme
  • kdenlive full reset how to erase all config files
  • CentOS 7 8 yum error Trying other mirror. To address this issue please refer to the below wiki article