[MDEV-23930] i have a rollback running for over 30 hours Created: 2020-10-08  Updated: 2021-06-04

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Critical
Reporter: Michael Necklas Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Attachments: Microsoft Word pxads.docx    

 Description   

the client was running a create table and decided to kill it off. this was yesterday morning. the rollback is still running accumulating time. the backup last night got hung on it so that was canceled. this is from the show processlist…

+--------+-------------+------------------------------+------+------------+--------+--------------------+-------------------------------------------------------------------------------------+----------+ 
 | Id | User | Host | db | Command | Time | State | Info | Progress | 
 +--------+-------------+------------------------------+------+------------+--------+---------------------+------------------------------------------------------------------------------------+----------+ 
 | 302993 | js345e | % | prc | Killed | 91827 | Rollback | create table x_qm_trx_stg (primary key (std_addr_id,sfdc_sp_acct_id,product | 0.000 | 

in addition this is from the instance log...

2020-10-07 10:58:07 302993 [Note] InnoDB: Deferring DROP TABLE `prc`.`x_qm_trx_stg`; renaming to prc/#sql-ib12219315

He says it had been running between 1-2 hours before he killed it.

I've attached the process which keeps accumulating time to it.

we won't try taking another backup till it completes or you tell me how to stop it.


Generated at Thu Feb 08 09:26:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.