See
1 | 2021-02-06 20:45:00 0 [Note] InnoDB: Using Linux native AIO |
---|---|
2 | 2021-02-06 20:45:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins |
3 | 2021-02-06 20:45:00 0 [Note] InnoDB: Uses event mutexes |
4 | 2021-02-06 20:45:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 |
5 | 2021-02-06 20:45:00 0 [Note] InnoDB: Number of pools: 1 |
6 | 2021-02-06 20:45:00 0 [Note] InnoDB: Using generic crc32 instructions |
7 | 2021-02-06 20:45:00 0 [Note] mysqld: O_TMPFILE is not supported on /srv/tmp (disabling future attempts) |
8 | 2021-02-06 20:45:00 0 [Note] InnoDB: Initializing buffer pool, total size = 3G, instances = 3, chunk size = 128M |
9 | 2021-02-06 20:45:00 0 [Note] InnoDB: Completed initialization of buffer pool |
10 | 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(). |
11 | 2021-02-06 20:45:00 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=692554365539 |
12 | 2021-02-06 20:45:00 0 [Note] InnoDB: Transaction 725129425 was in the XA prepared state. |
13 | 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 |
14 | 2021-02-06 20:45:00 0 [Note] InnoDB: Trx id counter is 725129426 |
15 | 2021-02-06 20:45:00 0 [Note] InnoDB: Starting final batch to recover 117 pages from redo log. |
16 | 2021-02-06 20:45:01 0 [Note] InnoDB: Last binlog file '/srv/mariadb/mysql-bin.000817', position 969737923 |
17 | 2021-02-06 20:45:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active. |
18 | 2021-02-06 20:45:56 0 [Note] InnoDB: Starting in background the rollback of recovered transactions |
19 | 2021-02-06 20:45:56 0 [Note] InnoDB: Rollback of non-prepared transactions completed |
20 | 2021-02-06 20:45:56 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" |
21 | 2021-02-06 20:45:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables |
22 | 2021-02-06 20:45:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... |
23 | 2021-02-06 20:45:56 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. |
24 | 2021-02-06 20:45:56 0 [Note] InnoDB: Waiting for purge to start |
25 | 2021-02-06 20:45:56 0 [Note] InnoDB: 10.4.15 started; log sequence number 692554401897; transaction id 725129428 |
26 | 2021-02-06 20:45:56 0 [Note] InnoDB: Loading buffer pool(s) from /srv/mariadb/ib_buffer_pool |
27 | 2021-02-06 20:45:56 0 [Note] Plugin 'FEEDBACK' is disabled. |
28 | 2021-02-06 20:45:56 0 [Note] Recovering after a crash using /srv/mariadb/mysql-bin |
29 | 2021-02-06 20:45:57 0 [Note] Starting crash recovery... |
30 | 2021-02-06 20:45:57 0 [Note] InnoDB: Starting recovery for XA transactions... |
31 | 2021-02-06 20:45:57 0 [Note] InnoDB: Transaction 725129425 in prepared state after recovery |
32 | 2021-02-06 20:45:57 0 [Note] InnoDB: Transaction contains changes to 1 rows |
33 | 2021-02-06 20:45:57 0 [Note] InnoDB: 1 transactions in prepared state after recovery |
34 | 2021-02-06 20:45:57 0 [Note] Found 1 prepared transaction(s) in InnoDB |
35 | 2021-02-06 20:45:57 0 [Note] Crash recovery finished. |
36 | 2021-02-06 20:45:57 0 [Note] Server socket created on IP: '::'. |
37 | 2021-02-06 20:45:57 0 [Note] Reading of all Master_info entries succeeded |
38 | 2021-02-06 20:45:57 0 [Note] Added new Master_info '' to hash table |
39 | 2021-02-06 20:45:57 0 [Note] /usr/sbin/mysqld: ready for connections. |
User impact reported by 3 users.