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

TRANSACTION sometimes stay in "KILLLED' STATE for inifinitve time!

    XMLWordPrintable

    Details

      Description

      Hi dudes, after upgrade from mariadb 10.1 to 10.2.8, some simple transaction is running for infinitive times...

      SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST where Time > 9000\G
      

      I have 19 transaction that is running for this time

      they won't die with kill command..

                 ID: 10245887
               USER: novid
               HOST: 
                 DB: api
            COMMAND: Killed
               TIME: 106767
              STATE: NULL
               INFO: insert into `driver_status_changelog` (`status`, `driver_id`, `updated_at`, `created_at`) values ('4', '65767', '2017-09-06 09:22:04', '2017-09-06 09:22:04')
            TIME_MS: 106767343.552
              STAGE: 0
          MAX_STAGE: 0
           PROGRESS: 0.000
        MEMORY_USED: 92848
      EXAMINED_ROWS: 0
           QUERY_ID: 300183941
        INFO_BINARY: insert into `driver_status_changelog` (`status`, `driver_id`, `updated_at`, `created_at`) values ('4', '65767', '2017-09-06 09:22:04', '2017-09-06 09:22:04')
                TID: 15109
      

      and with SHOW ENGINE INNODB STATUS\G

      ---TRANSACTION 46385651188, ACTIVE 107004 sec
      8 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 4
      MySQL thread id 10245887, OS thread handle 0x7f898dcb6700, query id 300183941 api
      insert into `driver_status_changelog` (`status`, `driver_id`, `updated_at`, `created_at`) values ('4', '65767', '2017-09-06 09:22:04', '2017-09-06 09:22:04')
      Trx read view will not see trx with id >= 46385651191, sees < 46385650307
      

      changing in these transaction is so small (2 or 3) so waiting is not for transaction rollback.

      Thread stay in killed state and so some record is lock for infinitive time

        Attachments

        1. 42003.gdb
          97 kB
        2. 43205.gdb
          114 kB
        3. after.gdb
          92 kB
        4. after-restart.gdb
          67 kB
        5. before.gdb
          92 kB
        6. before-restart.gdb
          90 kB
        7. innodb-status
          48 kB
        8. my.cnf
          6 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              novid novid
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: