[MDEV-6423] Progress status in processlist provides false informations Created: 2014-07-07  Updated: 2019-03-31  Resolved: 2019-03-31

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table
Affects Version/s: 10.0.12
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Cédric PEINTRE Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None
Environment:

Ubuntu 12.04.4 LTS
MariaDB 10.0.12 with TokuDB


 Description   

Hello,

When altering a table to change engine from InnoDB to TokuDB, the progress status in "show processlist" indicates 100% but the alter is still in progress:

Id      User    Host    db      Command Time    State   Info    Progress
 
612     root    localhost       NULL    Query   2238    Verifying index uniqueness: Checked 23020000 of 0 rows in key-XXXXX_idx.     alter table T1 engine='TokuDB'     100.000



 Comments   
Comment by Elena Stepanova [ 2014-07-07 ]

Could you please paste SHOW CREATE TABLE for the table (preferably before ALTER, but if you don't have it, whatever it became afterwards) and a an approximate number of rows in the table.

How long does this 'Verifying index..' step take?

Did you try to query INFORMATION_SCHEMA.PROCESSLIST ? It gives a bit more information, namely the current stage number, it could help.

Comment by Cédric PEINTRE [ 2014-07-09 ]

Hi Elena, I can't reveal the table creation order here.
The table has approximately 400 millions of rows.
The index verification step took a very long time but I don't know exactly how much time.
No, I didn't have a look in information_schema database.

Generated at Thu Feb 08 07:11:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.