Page MenuHomeMiraheze
Paste P380

MySQL crash logs for db11 (2021-02-06 ~20:46)
ActivePublic

Authored by Paladox on Feb 6 2021, 21:02.
Tags
None
Referenced Files
F1389343: raw-paste-data.txt
Feb 6 2021, 21:02
Subscribers
None
2021-02-06 20:45:00 0 [Note] InnoDB: Using Linux native AIO
2021-02-06 20:45:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-02-06 20:45:00 0 [Note] InnoDB: Uses event mutexes
2021-02-06 20:45:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-06 20:45:00 0 [Note] InnoDB: Number of pools: 1
2021-02-06 20:45:00 0 [Note] InnoDB: Using generic crc32 instructions
2021-02-06 20:45:00 0 [Note] mysqld: O_TMPFILE is not supported on /srv/tmp (disabling future attempts)
2021-02-06 20:45:00 0 [Note] InnoDB: Initializing buffer pool, total size = 3G, instances = 3, chunk size = 128M
2021-02-06 20:45:00 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-06 20:45:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-02-06 20:45:00 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=692554365539
2021-02-06 20:45:00 0 [Note] InnoDB: Transaction 725129425 was in the XA prepared state.
2021-02-06 20:45:00 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo
2021-02-06 20:45:00 0 [Note] InnoDB: Trx id counter is 725129426
2021-02-06 20:45:00 0 [Note] InnoDB: Starting final batch to recover 117 pages from redo log.
2021-02-06 20:45:01 0 [Note] InnoDB: Last binlog file '/srv/mariadb/mysql-bin.000817', position 969737923
2021-02-06 20:45:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-06 20:45:56 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
2021-02-06 20:45:56 0 [Note] InnoDB: Rollback of non-prepared transactions completed
2021-02-06 20:45:56 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-02-06 20:45:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-06 20:45:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-02-06 20:45:56 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-02-06 20:45:56 0 [Note] InnoDB: Waiting for purge to start
2021-02-06 20:45:56 0 [Note] InnoDB: 10.4.15 started; log sequence number 692554401897; transaction id 725129428
2021-02-06 20:45:56 0 [Note] InnoDB: Loading buffer pool(s) from /srv/mariadb/ib_buffer_pool
2021-02-06 20:45:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-02-06 20:45:56 0 [Note] Recovering after a crash using /srv/mariadb/mysql-bin
2021-02-06 20:45:57 0 [Note] Starting crash recovery...
2021-02-06 20:45:57 0 [Note] InnoDB: Starting recovery for XA transactions...
2021-02-06 20:45:57 0 [Note] InnoDB: Transaction 725129425 in prepared state after recovery
2021-02-06 20:45:57 0 [Note] InnoDB: Transaction contains changes to 1 rows
2021-02-06 20:45:57 0 [Note] InnoDB: 1 transactions in prepared state after recovery
2021-02-06 20:45:57 0 [Note] Found 1 prepared transaction(s) in InnoDB
2021-02-06 20:45:57 0 [Note] Crash recovery finished.
2021-02-06 20:45:57 0 [Note] Server socket created on IP: '::'.
2021-02-06 20:45:57 0 [Note] Reading of all Master_info entries succeeded
2021-02-06 20:45:57 0 [Note] Added new Master_info '' to hash table
2021-02-06 20:45:57 0 [Note] /usr/sbin/mysqld: ready for connections.

Event Timeline

RhinosF1 changed the title of this paste from untitled to MySQL crash logs for db11 (2021-02-06 ~20:46).