Skip to main content

mysql not starting

aaronmeister
This morning I received several txt message notifications that mysql is down. I was unable to easily search and find a similar issue on this form. I have not performed any changes to this server myself in a few weeks. That was simply an upgrade. Restart command: [root@server mysql]# /scripts/restartsrv_mysql Waiting for "mysql" to start ""info [restartsrv_mysql] systemd failed to start the service "mysqld" (The "/usr/bin/systemctl restart mysqld.service --no-ask-password" command (process 141638) reported error number 1 when it ended.): Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details. "Unrecognized configuration options may have caused the MySQL startup errors. The system has attempted to auto-update your MySQL configuration file for your MySQL version. This should resolve any errors that stem from an outdated MySQL configuration file. info [restartsrv_mysql] systemd failed to start the service "mysqld" (The "/usr/bin/systemctl restart mysqld.service --no-ask-password" command (process 141675) reported error number 1 when it ended.): Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details. "Unrecognized configuration options may have caused the MySQL startup errors. The system has attempted to auto-update your MySQL configuration file for your MySQL version. This should resolve any errors that stem from an outdated MySQL configuration file. info [restartsrv_mysql] systemd failed to start the service "mysqld" (The "/usr/bin/systemctl restart mysqld.service --no-ask-password" command (process 141712) reported error number 1 when it ended.): Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details. "failed. Cpanel::Exception::Services::StartError Service Status undefined status from Cpanel::ServiceManager::Services::Mysql Service Error (XID zga9fg) The "mysql" service failed to start. Startup Log May 26 21:49:20 server.ominousglow.cloud systemd[1]: Stopped MySQL Server. May 26 21:49:20 server.ominousglow.cloud systemd[1]: Starting MySQL Server... May 26 21:49:23 server.ominousglow.cloud systemd[1]: Started MySQL Server. May 14 00:24:50 server.ominousglow.cloud systemd[1]: mysqld.service: Main process exited, code=exited, status=3/NOTIMPLEMENTED May 14 00:24:50 server.ominousglow.cloud systemd[1]: mysqld.service: Failed with result 'exit-code'. May 14 00:24:51 server.ominousglow.cloud systemd[1]: mysqld.service: Service RestartSec=100ms expired, scheduling restart. May 14 00:24:51 server.ominousglow.cloud systemd[1]: mysqld.service: Scheduled restart job, restart counter is at 2. May 14 00:24:51 server.ominousglow.cloud systemd[1]: Stopped MySQL Server. May 14 00:24:51 server.ominousglow.cloud systemd[1]: Starting MySQL Server... May 14 00:24:53 server.ominousglow.cloud systemd[1]: Started MySQL Server. mysql has failed. Contact your system administrator if the service does not automagically recover.
Service Status command: [root@server mysql]# systemctl status mysqld.service ? mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Drop-In: /etc/systemd/system/mysqld.service.d ??limits.conf Active: failed (Result: exit-code) since Mon 2023-07-17 16:46:39 CDT; 15s ago Docs: man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html Process: 141838 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE) Process: 141810 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS) Main PID: 141838 (code=exited, status=1/FAILURE) Status: "Server shutdown complete" Error: 13 (Permission denied) May 26 21:49:20 server.ominousglow.cloud systemd[1]: Stopped MySQL Server. May 26 21:49:20 server.ominousglow.cloud systemd[1]: Starting MySQL Server... May 26 21:49:23 server.ominousglow.cloud systemd[1]: Started MySQL Server. May 14 00:24:50 server.ominousglow.cloud systemd[1]: mysqld.service: Main process exited, code=exited, status=3/NOTIMPLEMENTED May 14 00:24:50 server.ominousglow.cloud systemd[1]: mysqld.service: Failed with result 'exit-code'. May 14 00:24:51 server.ominousglow.cloud systemd[1]: mysqld.service: Service RestartSec=100ms expired, scheduling restart. May 14 00:24:51 server.ominousglow.cloud systemd[1]: mysqld.service: Scheduled restart job, restart counter is at 2. May 14 00:24:51 server.ominousglow.cloud systemd[1]: Stopped MySQL Server. May 14 00:24:51 server.ominousglow.cloud systemd[1]: Starting MySQL Server... May 14 00:24:53 server.ominousglow.cloud systemd[1]: Started MySQL Server.
Mysql documentation notes it could be permissions, security software, or duplicate instances of mysqld. Command for mysql data folder: [root@server mysql]# ls -la /var/lib/mysql total 197132 -rw-r----- 1 mysql mysql 196608 Jul 17 08:00 '#ib_16384_0.dblwr' -rw-r----- 1 mysql mysql 8585216 Jul 17 08:00 '#ib_16384_1.dblwr' drwxr-x--- 2 mysql mysql 4096 Jul 17 08:00 '#innodb_redo' drwxr-x--- 2 mysql mysql 4096 Jul 16 02:00 '#innodb_temp' drwxr-x--x 19 mysql mysql 4096 Jul 17 16:46 . drwxr-xr-x 37 root root 4096 Apr 30 01:27 .. -rw-r----- 1 mysql mysql 56 Apr 24 2022 auto.cnf -rw------- 1 mysql mysql 1676 Apr 24 2022 ca-key.pem -rw-r--r-- 1 mysql mysql 1112 Apr 24 2022 ca.pem -rw-r--r-- 1 mysql mysql 1112 Apr 24 2022 client-cert.pem -rw------- 1 mysql mysql 1680 Apr 24 2022 client-key.pem -rw-r----- 1 mysql mysql 5009 Jul 7 21:26 ib_buffer_pool -rw-r----- 1 mysql mysql 79691776 Jul 17 08:00 ibdata1 -rw-r----- 1 mysql mysql 12582912 Jul 16 02:00 ibtmp1 drwxr-x--- 2 mysql mysql 4096 Apr 23 01:28 mysql -rw-r----- 1 mysql mysql 50331648 Jul 17 08:00 mysql.ibd srwxrwxrwx 1 mysql mysql 0 Jul 16 02:00 mysql.sock -rw-r----- 1 mysql mysql 6 Apr 23 01:28 mysql_upgrade_info drwxr-x--- 2 mysql mysql 4096 May 31 20:49 ominousglow_epw_dev drwxr-x--- 2 mysql mysql 4096 Jan 16 23:26 ominousglow_epw_qa drwxr-x--- 2 mysql mysql 4096 Oct 7 2022 ominousglow_ogc_wp drwxr-x--- 2 mysql mysql 12288 Jul 13 22:00 ominousglow_wp_aw drwxr-x--- 2 mysql mysql 4096 Jan 18 20:13 ominousglow_wp_bs drwxr-x--- 2 mysql mysql 4096 Feb 19 10:31 ominousglow_wp_cf drwxr-x--- 2 mysql mysql 4096 Jul 18 2022 ominousglow_wp_ep drwxr-x--- 2 mysql mysql 4096 Jul 12 16:56 ominousglow_wp_epw drwxr-x--- 2 mysql mysql 4096 Jun 19 16:57 ominousglow_wp_k2tcm drwxr-x--- 2 mysql mysql 4096 Oct 30 2022 ominousglow_wp_pfp drwxr-x--- 2 mysql mysql 4096 Jul 15 2022 ominousglow_wp_ps drwxr-x--- 2 mysql mysql 4096 Dec 23 2022 ominousglow_wp_xes4i drwxr-x--- 2 mysql mysql 4096 Apr 23 01:28 performance_schema -rw------- 1 mysql mysql 1680 Apr 24 2022 private_key.pem -rw-r--r-- 1 mysql mysql 452 Apr 24 2022 public_key.pem -rw-r--r-- 1 mysql mysql 1112 Apr 24 2022 server-cert.pem -rw------- 1 mysql mysql 1676 Apr 24 2022 server-key.pem drwxr-x--- 2 mysql mysql 4096 Apr 24 2022 sys -rw-r----- 1 mysql mysql 33554432 Jul 17 08:00 undo_001 -rw-r----- 1 mysql mysql 16777216 Jul 17 08:00 undo_002 [root@server mysql]#
Everything is mysql:mysql. And ps shows no instances of mysqld. At this point, I'm out of ideas, and I don't know what type of security software cpanel is running to go any further than this. EDIT: formatting.

Comments

4 comments

Date Votes
  • bellwood
    What is the output of journalctl -xe? What errors, if any, are logged? Check the .err log corresponding to your hostname in /var/lib/mysql/
    0
  • cPanelWilliam
    Hello! I recommend reviewing the MySQL error log to see if it can provide further insight. As @bellwood stated, this log would usually be located in /var/lib/mysql
    , but it can also have other locations:
    0
  • aaronmeister
    journalctl -xe output: Jul 16 02:00:25 server.ominousglow.cloud p0f[557]: [!] WARNING: Too many tracked connections, deleting 101. Use -m to adjust. Jun 04 02:00:32 server.ominousglow.cloud dovecot[294612]: auth-worker(375834): Error: conn unix:auth-worker (pid=370290,uid=97): auth-worker<11>: dict(ent,46.148.40.199): Failed to lookup key shared/dovecot_userdb-smtp/ent:> Jul 09 02:00:24 server.ominousglow.cloud p0f[530]: [!] WARNING: Too many tracked connections, deleting 101. Use -m to adjust. Jul 16 02:00:26 server.ominousglow.cloud crond[333908]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 16 02:00:26 server.ominousglow.cloud CROND[333922]: (root) CMD (/usr/local/cpanel/scripts/dcpumon-wrapper >/dev/null 2>&1) Jul 16 02:00:26 server.ominousglow.cloud crond[333906]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 16 02:00:26 server.ominousglow.cloud crond[333904]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 16 02:00:26 server.ominousglow.cloud CROND[333926]: (root) CMD (systemctl --force --force reboot) Jul 16 02:00:26 server.ominousglow.cloud crond[333907]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 16 02:00:26 server.ominousglow.cloud crond[333909]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 16 02:00:26 server.ominousglow.cloud CROND[333928]: (root) CMD (/usr/local/cpanel/bin/backup) Jul 16 02:00:26 server.ominousglow.cloud CROND[333927]: (root) CMD (/usr/local/cpanel/scripts/shrink_modsec_ip_database -x 2>&1) Jul 16 02:00:26 server.ominousglow.cloud crond[333905]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 16 02:00:26 server.ominousglow.cloud crond[333901]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 16 02:00:26 server.ominousglow.cloud crond[333900]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 16 02:00:26 server.ominousglow.cloud crond[333903]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 16 02:00:26 server.ominousglow.cloud crond[333902]: pam_systemd(crond:session): Failed to create session: Connection timed out Jun 04 02:00:33 server.ominousglow.cloud dovecot[294612]: auth-worker(375834): Error: conn unix:auth-worker (pid=370290,uid=97): auth-worker<12>: dict(sj,46.148.40.117): Failed to lookup key shared/dovecot_userdb-smtp/sj: n> Jul 09 02:00:26 server.ominousglow.cloud crond[389959]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 09 02:00:26 server.ominousglow.cloud CROND[389974]: (root) CMD (systemctl --force --force reboot) Jul 09 02:00:26 server.ominousglow.cloud crond[389955]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 09 02:00:26 server.ominousglow.cloud crond[389958]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 09 02:00:26 server.ominousglow.cloud crond[389960]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 09 02:00:26 server.ominousglow.cloud crond[389953]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 09 02:00:26 server.ominousglow.cloud CROND[389975]: (ominousglow) CMD (/usr/local/bin/php /home/ominousglow/public_html/positivedevelopment.net/wp-cron.php >/dev/null 2>&1) Jul 09 02:00:26 server.ominousglow.cloud CROND[389976]: (ominousglow) CMD (/usr/local/bin/php /home/ominousglow/public_html/eastonparkwiki.com/wp-cron.php >/dev/null 2>&1) Jul 09 02:00:26 server.ominousglow.cloud CROND[389977]: (root) CMD (/usr/local/cpanel/scripts/shrink_modsec_ip_database -x 2>&1) Jul 09 02:00:26 server.ominousglow.cloud crond[389957]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 09 02:00:26 server.ominousglow.cloud crond[389961]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 09 02:00:26 server.ominousglow.cloud crond[389962]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 09 02:00:26 server.ominousglow.cloud crond[389954]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 09 02:00:26 server.ominousglow.cloud CROND[389978]: (ominousglow) CMD (/usr/local/bin/php /home/ominousglow/public_html/cinemafunk.com/wp-cron.php >/dev/null 2>&1) Jul 09 02:00:26 server.ominousglow.cloud crond[389956]: pam_systemd(crond:session): Failed to create session: Connection timed out Jul 09 02:00:26 server.ominousglow.cloud CROND[389982]: (ominousglow) CMD (/usr/local/bin/php /home/ominousglow/public_html/aaronweiss.me/wp-cron.php >/dev/null 2>&1) Jul 09 02:00:26 server.ominousglow.cloud CROND[389984]: (root) CMD (/usr/local/cpanel/bin/backup) Jul 09 02:00:26 server.ominousglow.cloud CROND[389981]: (root) CMD (/usr/local/cpanel/scripts/dcpumon-wrapper >/dev/null 2>&1) Jul 09 02:00:26 server.ominousglow.cloud CROND[389985]: (ominousglow) CMD (/usr/local/bin/php /home/ominousglow/public_html/progsnobs.com/wp-cron.php >/dev/null 2>&1) Jul 09 02:00:26 server.ominousglow.cloud CROND[389983]: (ominousglow) CMD (/usr/local/bin/php /home/ominousglow/public_html/bunkseo.com/wp-cron.php >/dev/null 2>&1) Jun 04 02:00:44 server.ominousglow.cloud dbus-daemon[143]: [system] Failed to activate service 'org.freedesktop.systemd1': timed out (service_start_timeout=25000ms) Jun 04 02:00:44 server.ominousglow.cloud sudo[375960]: wp-toolkit : TTY=unknown ; PWD=/usr/local/cpanel/3rdparty/wp-toolkit/scripts ; USER=root ; COMMAND=/bin/test -e /etc/apache2/conf.d/userdata/ssl/2_4/ominousglow/homelab> Jun 04 02:00:44 server.ominousglow.cloud systemd-logind[153]: Failed to start session scope session-c5658.scope: Failed to activate service 'org.freedesktop.systemd1': timed out (service_start_timeout=25000ms) Jun 04 02:00:44 server.ominousglow.cloud CROND[375980]: (root) CMD (/usr/local/cpanel/scripts/shrink_modsec_ip_database -x 2>&1) Jun 04 02:00:44 server.ominousglow.cloud CROND[375978]: (ominousglow) CMD (/usr/local/bin/php /home/ominousglow/public_html/eastonparkwiki.com/wp-cron.php >/dev/null 2>&1) Jun 04 02:00:44 server.ominousglow.cloud CROND[375979]: (root) CMD (/usr/local/cpanel/bin/backup) Jun 04 02:00:44 server.ominousglow.cloud sudo[375963]: wp-toolkit : TTY=unknown ; PWD=/usr/local/cpanel/3rdparty/wp-toolkit/scripts ; USER=root ; COMMAND=/bin/sh -c whmapi1 get_domain_info --output=json Jun 04 02:00:44 server.ominousglow.cloud CROND[375973]: (ominousglow) CMD (/usr/local/bin/php /home/ominousglow/public_html/positivedevelopment.net/wp-cron.php >/dev/null 2>&1) Jun 04 02:00:44 server.ominousglow.cloud CROND[375974]: (ominousglow) CMD (/usr/local/bin/php /home/ominousglow/public_html/progsnobs.com/wp-cron.php >/dev/null 2>&1) Jun 04 02:00:44 server.ominousglow.cloud CROND[375975]: (root) CMD (systemctl --force --force reboot) Jun 04 02:00:44 server.ominousglow.cloud CROND[375976]: (root) CMD (/usr/local/cpanel/scripts/dcpumon-wrapper >/dev/null 2>&1) Jun 04 02:00:44 server.ominousglow.cloud CROND[375977]: (ominousglow) CMD (/usr/local/bin/php /home/ominousglow/public_html/aaronweiss.me/wp-cron.php >/dev/null 2>&1) Jun 04 02:00:44 server.ominousglow.cloud CROND[375971]: (ominousglow) CMD (/usr/local/bin/php /home/ominousglow/public_html/cinemafunk.com/wp-cron.php >/dev/null 2>&1) Jun 04 02:00:44 server.ominousglow.cloud CROND[375972]: (ominousglow) CMD (/usr/local/bin/php /home/ominousglow/public_html/bunkseo.com/wp-cron.php >/dev/null 2>&1)
    My mysql log was located in /var/log/mysql. The main log was empty but the mysqld.log-bak (I'm assuming the backup log) is 12GB! [root@server log]# ls -lha | grep mysql -rw-r--r-- 1 root root 0 Jul 17 13:36 mysqld.log -rw-r----- 1 mysql mysql 12G Jul 17 13:36 mysqld.log-back
    My tail of the backup log file: [root@server log]# tail -n 50 mysqld.log-back 2023-07-17T18:36:10.595783Z 1 [ERROR] [MY-011906] [InnoDB] Database page corruption on disk or a failed file read of page [page id: space=0, page number=5]. You may have to recover from a backup. len 16384; hex 2ab411ae000000050000000000000000000000451a7ae03d00070000000000000000000000000000000002414901000000000000000200f20000000000000006ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000241494500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000204b21fffbd5f00000040000000801fffbd5f00000040000000806a5073aa000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006f741bfc1a7adfcf; asc * E z = AI AIE _ @ _ @ jPs ot z ; InnoDB: End of page dump InnoDB: Page may be a transaction system page 2023-07-17T18:36:10.662782Z 1 [ERROR] [MY-011899] [InnoDB] [FATAL] Unable to read page [page id: space=0, page number=5] into the buffer pool after 100 attempts. The most probable cause of this error may be that the table has been corrupted. Or, the table was compressed with with an algorithm that is not supported by this instance. If it is not a decompress failure, you can try to fix this problem by using innodb_force_recovery. Please see http://dev.mysql.com/doc/refman/8.0/en/ for more details. Aborting... 2023-07-17T18:36:10.662800Z 1 [ERROR] [MY-013183] [InnoDB] Assertion failure: buf0buf.cc:4054:ib::fatal triggered thread 139711479568128 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 2023-07-17T18:36:10Z UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. BuildID[sha1]=2322a98ee785d298cbc399f95a31b9671531a40b Thread pointer: 0x64df660 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7f111d1c4ba0 thread_stack 0x100000 /usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x2124331] /usr/sbin/mysqld(print_fatal_signal(int)+0x2a2) [0xfe7bc2] /usr/sbin/mysqld(my_server_abort()+0x75) [0xfe7e05] /usr/sbin/mysqld(my_abort()+0xe) [0x211e1be] /usr/sbin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x309) [0x236ae89] /usr/sbin/mysqld(ib::fatal::~fatal()+0xcf) [0x236d7af] /usr/sbin/mysqld(Buf_fetch::read_page()+0x1b7) [0x23c5d87] /usr/sbin/mysqld(Buf_fetch_normal::get(buf_block_t*&)+0x108) [0x23d1438] /usr/sbin/mysqld(Buf_fetch::single_page()+0x55) [0x23d1515] /usr/sbin/mysqld(buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, Page_fetch, ut::Location, mtr_t*, bool)+0x292) [0x23d23c2] /usr/sbin/mysqld(Double_write::get(mtr_t*)+0x53) [0x23d5ea3] /usr/sbin/mysqld(Double_write::init_v1(unsigned int&, unsigned int&)+0xf4) [0x23d7bd4] /usr/sbin/mysqld(dblwr::v1::init()+0x1b) [0x23d7e5b] /usr/sbin/mysqld(srv_start(bool)+0xfa4) [0x231c7a4] /usr/sbin/mysqld() [0x21691e5] /usr/sbin/mysqld(dd::bootstrap::DDSE_dict_init(THD*, dict_init_mode_t, unsigned int)+0xca) [0x1ec842a] /usr/sbin/mysqld(dd::upgrade_57::do_pre_checks_and_initialize_dd(THD*)+0x232) [0x20f6e72] /usr/sbin/mysqld() [0x10abcf6] /usr/sbin/mysqld() [0x2833eb4] /lib64/libpthread.so.0(+0x81ca) [0x7f111fd751ca] /lib64/libc.so.6(clone+0x43) [0x7f111e119e73] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): Connection ID (thread ID): 1 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash.
    I just don't know how this could have been corrupted. I do have backups, but I'd like to learn if this is recoverable without.
    0
  • cPRex Jurassic Moderator
    It *may* be possible to repair InnoDB data as outlined here:
    -6

Please sign in to leave a comment.

Didn't find what you were looking for?

New post