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

Test hangs with "transaction_isolation=SERIALIZABLE"

    XMLWordPrintable

Details

    Description

      start mariadb with:
      transaction_isolation=READ-UNCOMMITTED
      transaction_isolation=READ-COMMITTED
      transaction_isolation=REPEATABLE-READ
      transaction_isolation=SERIALIZABLE
      respectively, and innodb_lock_wait_timeout=3600000 then run:

      ./mysql-test-run.pl \
      --extern socket=/var/run/mysqld/mysqld.sock \
      --report-times \
      --max-connections=16 \
      --max-test-fail=0 \
      --retry-failure=0 \
      --testcase-timeout=60 \
      --force \
      --repeat=10 \
      main.deadlock_innodb
      

      I got the results shown in Figure_1.png. I checked for 'top' and observe trival CPU/mem pressure (may be a deadlock). While I expect this won't happen even though 'SERIALIZABLE' provide the best isolation level among the four.

      In MySQL-8.0.19, I got the results shown in Figure_2.png (repeat=100). Thouth the time spent is not stable, test finally got finished.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Tim He Tim He
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.