Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6423

Progress status in processlist provides false informations

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.0.12
        • Fix Version/s: None
        • Component/s: None
        • 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

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                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.

                Show
                elenst Elena Stepanova added a comment - 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.
                Hide
                Permalink
                CEPE Cédric PEINTRE added a comment -

                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.

                Show
                CEPE Cédric PEINTRE added a comment - 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.

                  People

                  • Assignee:
                    elenst Elena Stepanova
                    Reporter:
                    CEPE Cédric PEINTRE
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated: