Database crash with `mysqld got signal 11`

[Michael_Coburn]

Looks like the database was running a purge, yes you’ll need to be using innodb_force_recovery

@krystalcode

mysqld(_Z28trx_undo_rec_get_partial_rowPKhP12dict_index_tPP8dtuple_tmP16mem_block_info_t+0x38a)[0x11364da]
mysqld(_Z14row_purge_stepP9que_thr_t+0xb30)[0x10ccbe0]
mysqld(_Z15que_run_threadsP9que_thr_t+0xc94)[0x1077f24]
mysqld(_Z9trx_purgemmb+0x400)[0x11347e0]
mysqld(srv_purge_coordinator_thread+0xb7d)[0x11048ad]

Looks like the database resolved the InnoDB crashing transaction, but got blocked due to a new error:

@krystalcode

2021-08-09T22:45:03.749566Z 0 [Note] Server socket created on IP: '::'.
2021-08-09T22:45:03.749599Z 0 [ERROR] Unix socket lock file is empty /var/lib/mysql/mysql.sock.lock.
2021-08-09T22:45:03.749602Z 0 [ERROR] Unable to setup unix socket lock file.
2021-08-09T22:45:03.749603Z 0 [ERROR] Aborting

2021-08-09T22:45:03.749609Z 0 [Note] Binlog end

You should check to see if you have a file already at /var/lib/mysql/mysql.sock.lock