[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: |
|
| 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…
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. |