Page MenuHomeMiraheze

MySQL crashed on db11 2021-02-06 ~20:46
Closed, ResolvedPublic

Description

See

12021-02-06 20:45:00 0 [Note] InnoDB: Using Linux native AIO
22021-02-06 20:45:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
32021-02-06 20:45:00 0 [Note] InnoDB: Uses event mutexes
42021-02-06 20:45:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
52021-02-06 20:45:00 0 [Note] InnoDB: Number of pools: 1
62021-02-06 20:45:00 0 [Note] InnoDB: Using generic crc32 instructions
72021-02-06 20:45:00 0 [Note] mysqld: O_TMPFILE is not supported on /srv/tmp (disabling future attempts)
82021-02-06 20:45:00 0 [Note] InnoDB: Initializing buffer pool, total size = 3G, instances = 3, chunk size = 128M
92021-02-06 20:45:00 0 [Note] InnoDB: Completed initialization of buffer pool
102021-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().
112021-02-06 20:45:00 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=692554365539
122021-02-06 20:45:00 0 [Note] InnoDB: Transaction 725129425 was in the XA prepared state.
132021-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
142021-02-06 20:45:00 0 [Note] InnoDB: Trx id counter is 725129426
152021-02-06 20:45:00 0 [Note] InnoDB: Starting final batch to recover 117 pages from redo log.
162021-02-06 20:45:01 0 [Note] InnoDB: Last binlog file '/srv/mariadb/mysql-bin.000817', position 969737923
172021-02-06 20:45:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
182021-02-06 20:45:56 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
192021-02-06 20:45:56 0 [Note] InnoDB: Rollback of non-prepared transactions completed
202021-02-06 20:45:56 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
212021-02-06 20:45:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
222021-02-06 20:45:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
232021-02-06 20:45:56 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
242021-02-06 20:45:56 0 [Note] InnoDB: Waiting for purge to start
252021-02-06 20:45:56 0 [Note] InnoDB: 10.4.15 started; log sequence number 692554401897; transaction id 725129428
262021-02-06 20:45:56 0 [Note] InnoDB: Loading buffer pool(s) from /srv/mariadb/ib_buffer_pool
272021-02-06 20:45:56 0 [Note] Plugin 'FEEDBACK' is disabled.
282021-02-06 20:45:56 0 [Note] Recovering after a crash using /srv/mariadb/mysql-bin
292021-02-06 20:45:57 0 [Note] Starting crash recovery...
302021-02-06 20:45:57 0 [Note] InnoDB: Starting recovery for XA transactions...
312021-02-06 20:45:57 0 [Note] InnoDB: Transaction 725129425 in prepared state after recovery
322021-02-06 20:45:57 0 [Note] InnoDB: Transaction contains changes to 1 rows
332021-02-06 20:45:57 0 [Note] InnoDB: 1 transactions in prepared state after recovery
342021-02-06 20:45:57 0 [Note] Found 1 prepared transaction(s) in InnoDB
352021-02-06 20:45:57 0 [Note] Crash recovery finished.
362021-02-06 20:45:57 0 [Note] Server socket created on IP: '::'.
372021-02-06 20:45:57 0 [Note] Reading of all Master_info entries succeeded
382021-02-06 20:45:57 0 [Note] Added new Master_info '' to hash table
392021-02-06 20:45:57 0 [Note] /usr/sbin/mysqld: ready for connections.
- Needs investigation and IR.

User impact reported by 3 users.

Event Timeline

RhinosF1 triaged this task as High priority.Feb 6 2021, 21:04
RhinosF1 created this task.

Thanks for the add, @RhinosF1

Oh, heh, you can transclude pastes...nice! Didn't know that. :D

John moved this task from Incoming to Short Term on the Infrastructure (SRE) board.
John subscribed.

Can you do the incident report as the primary responder?