Skip to content

Instantly share code, notes, and snippets.

Created January 28, 2015 09:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/8c9645f54c5a787e85ed to your computer and use it in GitHub Desktop.
Save anonymous/8c9645f54c5a787e85ed to your computer and use it in GitHub Desktop.
MySQL crash log
Jan 27 15:06:36 adserver mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Jan 27 15:06:36 adserver mysqld: 150127 15:06:36 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Jan 27 15:06:36 adserver mysqld: 150127 15:06:36 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
Jan 27 15:06:36 adserver mysqld: 150127 15:06:36 [Note] Plugin 'FEDERATED' is disabled.
Jan 27 15:06:36 adserver mysqld: 150127 15:06:36 InnoDB: The InnoDB memory heap is disabled
Jan 27 15:06:36 adserver mysqld: 150127 15:06:36 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jan 27 15:06:36 adserver mysqld: 150127 15:06:36 InnoDB: Compressed tables use zlib 1.2.7
Jan 27 15:06:36 adserver mysqld: 150127 15:06:36 InnoDB: Using Linux native AIO
Jan 27 15:06:36 adserver mysqld: 150127 15:06:36 InnoDB: Initializing buffer pool, size = 128.0M
Jan 27 15:06:36 adserver mysqld: 150127 15:06:36 InnoDB: Completed initialization of buffer pool
Jan 27 15:06:36 adserver mysqld: 150127 15:06:36 InnoDB: highest supported file format is Barracuda.
Jan 27 15:06:36 adserver mysqld: InnoDB: The log sequence number in ibdata files does not match
Jan 27 15:06:36 adserver mysqld: InnoDB: the log sequence number in the ib_logfiles!
Jan 27 15:06:36 adserver mysqld: 150127 15:06:36 InnoDB: Database was not shut down normally!
Jan 27 15:06:36 adserver mysqld: InnoDB: Starting crash recovery.
Jan 27 15:06:36 adserver mysqld: InnoDB: Reading tablespace information from the .ibd files...
Jan 27 15:06:36 adserver mysqld: InnoDB: Restoring possible half-written data pages from the doublewrite
Jan 27 15:06:36 adserver mysqld: InnoDB: buffer...
Jan 27 15:06:36 adserver mysqld: 150127 15:06:36 InnoDB: Waiting for the background threads to start
Jan 27 15:06:37 adserver mysqld: 150127 15:06:37 InnoDB: 5.5.37 started; log sequence number 2260240
Jan 27 15:06:37 adserver mysqld: 150127 15:06:37 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
Jan 27 15:06:37 adserver mysqld: 150127 15:06:37 [Note] - '127.0.0.1' resolves to '127.0.0.1';
Jan 27 15:06:37 adserver mysqld: 150127 15:06:37 [Note] Server socket created on IP: '127.0.0.1'.
Jan 27 15:06:37 adserver mysqld: 150127 15:06:37 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
Jan 27 15:06:37 adserver mysqld: 150127 15:06:37 [Warning] Checking table: './mysql/user'
Jan 27 15:06:37 adserver mysqld: 150127 15:06:37 [ERROR] 1 client is using or hasn't closed the table properly
Jan 27 15:06:37 adserver mysqld: 150127 15:06:37 [ERROR] /usr/sbin/mysqld: Table './mysql/db' is marked as crashed and should be repaired
Jan 27 15:06:37 adserver mysqld: 150127 15:06:37 [Warning] Checking table: './mysql/db'
Jan 27 15:06:37 adserver mysqld: 150127 15:06:37 [ERROR] 1 client is using or hasn't closed the table properly
Jan 27 15:06:37 adserver mysqld: 150127 15:06:37 [Note] Event Scheduler: Loaded 0 events
Jan 27 15:06:37 adserver mysqld: 150127 15:06:37 [Note] /usr/sbin/mysqld: ready for connections.
Jan 27 15:06:37 adserver mysqld: Version: '5.5.37-0+wheezy1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
Jan 27 15:06:38 adserver /etc/mysql/debian-start[4998]: Upgrading MySQL tables if necessary.
Jan 27 15:06:38 adserver /etc/mysql/debian-start[5002]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Jan 27 15:06:38 adserver /etc/mysql/debian-start[5002]: Looking for 'mysql' as: /usr/bin/mysql
Jan 27 15:06:38 adserver /etc/mysql/debian-start[5002]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Jan 27 15:06:38 adserver /etc/mysql/debian-start[5002]: This installation of MySQL is already upgraded to 5.5.37, use --force if you still need to run mysql_upgrade
Jan 27 15:06:38 adserver /etc/mysql/debian-start[5085]: Checking for insecure root accounts.
Jan 27 15:06:38 adserver /etc/mysql/debian-start[5090]: Triggering myisam-recover for all MyISAM tables
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [ERROR] /usr/sbin/mysqld: Table './revive/ox_accounts' is marked as crashed and should be repaired
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Warning] Checking table: './revive/ox_accounts'
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Warning] Recovering table: './revive/ox_accounts'
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Note] Retrying repair of: './revive/ox_accounts' with keycache
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Note] Found 43 of 46 rows when repairing './revive/ox_accounts'
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [ERROR] /usr/sbin/mysqld: Table './revive/ox_acls' is marked as crashed and should be repaired
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Warning] Checking table: './revive/ox_acls'
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Warning] Recovering table: './revive/ox_acls'
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Note] Retrying repair of: './revive/ox_acls' with keycache
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [ERROR] /usr/sbin/mysqld: Table './revive/ox_acls_channel' is marked as crashed and should be repaired
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Warning] Checking table: './revive/ox_acls_channel'
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Warning] Recovering table: './revive/ox_acls_channel'
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Note] Retrying repair of: './revive/ox_acls_channel' with keycache
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [ERROR] /usr/sbin/mysqld: Table './revive/ox_ad_zone_assoc' is marked as crashed and should be repaired
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Warning] Checking table: './revive/ox_ad_zone_assoc'
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Warning] Recovering table: './revive/ox_ad_zone_assoc'
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Note] Retrying repair of: './revive/ox_ad_zone_assoc' with keycache
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [ERROR] /usr/sbin/mysqld: Table './revive/ox_application_variable' is marked as crashed and should be repaired
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Warning] Checking table: './revive/ox_application_variable'
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Warning] Recovering table: './revive/ox_application_variable'
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Note] Retrying repair of: './revive/ox_application_variable' with keycache
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [ERROR] /usr/sbin/mysqld: Table './revive/ox_audit' is marked as crashed and should be repaired
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Warning] Checking table: './revive/ox_audit'
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:38 adserver mysqld: 150127 15:06:38 [Warning] Recovering table: './revive/ox_audit'
Jan 27 15:06:39 adserver mysqld: 150127 15:06:39 [Note] Retrying repair of: './revive/ox_audit' with keycache
Jan 27 15:06:39 adserver kernel: igb: eth0 NIC Link is Up 1000 Mbps Full Duplex, Flow Control: RX
Jan 27 15:06:39 adserver kernel: IPv6: ADDRCONF(NETDEV_CHANGE): eth0: link becomes ready
Jan 27 15:06:40 adserver kernel: TCP: TCP: Possible SYN flooding on port 80. Sending cookies. Check SNMP counters.
Jan 27 15:06:41 adserver mysqld: 150127 15:06:41 [ERROR] /usr/sbin/mysqld: Table './revive/ox_zones' is marked as crashed and should be repaired
Jan 27 15:06:41 adserver mysqld: 150127 15:06:41 [ERROR] /usr/sbin/mysqld: Table './revive/ox_zones' is marked as crashed and should be repaired
Jan 27 15:06:41 adserver mysqld: 150127 15:06:41 [Warning] Checking table: './revive/ox_zones'
Jan 27 15:06:41 adserver mysqld: 150127 15:06:41 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:41 adserver mysqld: 150127 15:06:41 [Warning] Recovering table: './revive/ox_zones'
Jan 27 15:06:41 adserver mysqld: 150127 15:06:41 [Note] Retrying repair of: './revive/ox_zones' with keycache
Jan 27 15:06:41 adserver mysqld: 150127 15:06:41 [Note] Found 98 of 101 rows when repairing './revive/ox_zones'
Jan 27 15:06:41 adserver mysqld: 150127 15:06:41 [ERROR] /usr/sbin/mysqld: Table './revive/ox_banners' is marked as crashed and should be repaired
Jan 27 15:06:41 adserver mysqld: 150127 15:06:41 [ERROR] /usr/sbin/mysqld: Table './revive/ox_banners' is marked as crashed and should be repaired
Jan 27 15:06:41 adserver mysqld: 150127 15:06:41 [Warning] Checking table: './revive/ox_banners'
Jan 27 15:06:41 adserver mysqld: 150127 15:06:41 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:41 adserver mysqld: 150127 15:06:41 [Warning] Recovering table: './revive/ox_banners'
Jan 27 15:06:41 adserver ntpdate[4057]: the NTP socket is in use, exiting
Jan 27 15:06:41 adserver ntpdate[4019]: the NTP socket is in use, exiting
Jan 27 15:06:41 adserver ntpdate[4094]: the NTP socket is in use, exiting
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Note] Retrying repair of: './revive/ox_banners' with keycache
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [ERROR] /usr/sbin/mysqld: Table './revive/ox_campaigns' is marked as crashed and should be repaired
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [ERROR] /usr/sbin/mysqld: Table './revive/ox_campaigns' is marked as crashed and should be repaired
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [ERROR] /usr/sbin/mysqld: Table './revive/ox_campaigns' is marked as crashed and should be repaired
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Warning] Checking table: './revive/ox_campaigns'
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Warning] Recovering table: './revive/ox_campaigns'
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Note] Retrying repair of: './revive/ox_campaigns' with keycache
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [ERROR] /usr/sbin/mysqld: Table './revive/ox_channel' is marked as crashed and should be repaired
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [ERROR] /usr/sbin/mysqld: Table './revive/ox_channel' is marked as crashed and should be repaired
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [ERROR] /usr/sbin/mysqld: Table './revive/ox_channel' is marked as crashed and should be repaired
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Warning] Checking table: './revive/ox_channel'
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Warning] Recovering table: './revive/ox_channel'
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Note] Retrying repair of: './revive/ox_channel' with keycache
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [ERROR] /usr/sbin/mysqld: Table './revive/ox_clients' is marked as crashed and should be repaired
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Warning] Checking table: './revive/ox_clients'
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Warning] Recovering table: './revive/ox_clients'
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Note] Retrying repair of: './revive/ox_clients' with keycache
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Note] Found 32 of 34 rows when repairing './revive/ox_clients'
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [ERROR] /usr/sbin/mysqld: Table './revive/ox_data_bkt_c' is marked as crashed and should be repaired
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Warning] Checking table: './revive/ox_data_bkt_c'
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [ERROR] /usr/sbin/mysqld: Table './revive/ox_data_bkt_m' is marked as crashed and should be repaired
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Warning] Checking table: './revive/ox_data_bkt_m'
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Warning] Recovering table: './revive/ox_data_bkt_m'
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Note] Retrying repair of: './revive/ox_data_bkt_m' with keycache
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [ERROR] /usr/sbin/mysqld: Table './revive/ox_data_intermediate_ad' is marked as crashed and should be repaired
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Warning] Checking table: './revive/ox_data_intermediate_ad'
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:42 adserver mysqld: 150127 15:06:42 [Warning] Recovering table: './revive/ox_data_intermediate_ad'
Jan 27 15:06:43 adserver ntpd[4404]: Listen normally on 5 eth0 2001:41d0:a:553f:: UDP 123
Jan 27 15:06:43 adserver ntpd[4404]: Listen normally on 6 eth0 fe80::ec4:7aff:fe02:5778 UDP 123
Jan 27 15:06:43 adserver ntpd[4404]: peers refreshed
Jan 27 15:06:43 adserver mysqld: 150127 15:06:43 [ERROR] /usr/sbin/mysqld: Table './revive/ox_log_maintenance_statistics' is marked as crashed and should be repaired
Jan 27 15:06:43 adserver mysqld: 150127 15:06:43 [Warning] Checking table: './revive/ox_log_maintenance_statistics'
Jan 27 15:06:47 adserver mysqld: 150127 15:06:47 [Note] Retrying repair of: './revive/ox_data_intermediate_ad' with keycache
Jan 27 15:06:51 adserver mysqld: 150127 15:06:51 [ERROR] /usr/sbin/mysqld: Table './revive/ox_data_summary_ad_hourly' is marked as crashed and should be repaired
Jan 27 15:06:51 adserver mysqld: 150127 15:06:51 [Warning] Checking table: './revive/ox_data_summary_ad_hourly'
Jan 27 15:06:52 adserver mysqld: 150127 15:06:52 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:52 adserver mysqld: 150127 15:06:52 [Warning] Recovering table: './revive/ox_data_summary_ad_hourly'
Jan 27 15:06:54 adserver mysqld: 150127 15:06:54 [Note] Retrying repair of: './revive/ox_data_summary_ad_hourly' with keycache
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [ERROR] /usr/sbin/mysqld: Table './revive/ox_log_maintenance_priority' is marked as crashed and should be repaired
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [Warning] Checking table: './revive/ox_log_maintenance_priority'
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [Warning] Recovering table: './revive/ox_log_maintenance_priority'
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [Note] Retrying repair of: './revive/ox_log_maintenance_priority' with keycache
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [ERROR] /usr/sbin/mysqld: Table './revive/ox_password_recovery' is marked as crashed and should be repaired
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [Warning] Checking table: './revive/ox_password_recovery'
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [Warning] Recovering table: './revive/ox_password_recovery'
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [Note] Found 0 of 1 rows when repairing './revive/ox_password_recovery'
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [ERROR] /usr/sbin/mysqld: Table './revive/ox_session' is marked as crashed and should be repaired
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [Warning] Checking table: './revive/ox_session'
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [Warning] Recovering table: './revive/ox_session'
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [ERROR] /usr/sbin/mysqld: Table './revive/ox_upgrade_action' is marked as crashed and should be repaired
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [Warning] Checking table: './revive/ox_upgrade_action'
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [ERROR] /usr/sbin/mysqld: Table './revive/ox_userlog' is marked as crashed and should be repaired
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [Warning] Checking table: './revive/ox_userlog'
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [ERROR] Got an error from unknown thread, /build/mysql-5.5-cLBGf7/mysql-5.5-5.5.37/storage/myisam/ha_myisam.cc:912
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [Warning] Recovering table: './revive/ox_userlog'
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [Note] Retrying repair of: './revive/ox_userlog' with keycache
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [ERROR] /usr/sbin/mysqld: Table './revive/ox_users' is marked as crashed and should be repaired
Jan 27 15:06:57 adserver mysqld: 150127 15:06:57 [Warning] Checking table: './revive/ox_users'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment