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

Run regular crash recovery tests for Aria tables (system and user tables)

Details

    • Task
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • N/A
    • Tests
    • None

    Description

      We have crash recovery tests, but those mainly target InnoDB. Aria is only involved in 10.4 to the extent that the server with Aria system tables starts after the crash.

      We'll run similar tests but with Aria tables instead of InnoDB. Data creation needs to be adjusted, pre-crash DML can remain basically the same, after-recovery checks might need to be adjusted, post-crash DML/DDL can remain the same.

      The tests are to be run in Travis regularly (daily at first, weekly after GA) along with other various tests.

      MDEV-16421 - Make system tables crash safe

      Attachments

        Issue Links

          Activity

            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Description We have crash recovery tests, but those mainly target InnoDB. Aria is only involved in 10.4 to the extent that the server with Aria system tables starts after the crash.

            We'll run similar tests but with Aria tables instead of InnoDB. Data creation needs to be adjusted, pre-crash DML can remain basically the same, after-recovery checks might need to be adjusted, post-crash DML/DDL can remain the same.

            The tests are to be run in [Travis|https://travis-ci.org/elenst/travis-tests/branches] regularly (daily at first, weekly after GA) along with other various tests.
            We have crash recovery tests, but those mainly target InnoDB. Aria is only involved in 10.4 to the extent that the server with Aria system tables starts after the crash.

            We'll run similar tests but with Aria tables instead of InnoDB. Data creation needs to be adjusted, pre-crash DML can remain basically the same, after-recovery checks might need to be adjusted, post-crash DML/DDL can remain the same.

            The tests are to be run in [Travis|https://travis-ci.org/elenst/travis-tests/branches] regularly (daily at first, weekly after GA) along with other various tests.

            MDEV-16421 - Make system tables crash safe
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            elenst Elena Stepanova added a comment - - edited

            Added a first small set of tests:

                - --grammar=conf/mariadb/oltp-transactional.yy --gendata=conf/mariadb/oltp-aria.zz
                - --grammar=conf/mariadb/oltp.yy --gendata=conf/mariadb/oltp-aria.zz
                - --grammar=conf/mariadb/generic-dml.yy --gendata=conf/mariadb/oltp-aria.zz
                - --grammar=conf/engines/engine_stress.yy --gendata=conf/engines/engine_stress.zz --engine=Aria
            

            each in 3 variations:

            - as is
            - --gendata-advanced --vcols --default-storage-engine=Aria
            - --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin
            

            all with CrashRestart reporter.

            Also need to add encrypted version.

            elenst Elena Stepanova added a comment - - edited Added a first small set of tests: - --grammar=conf/mariadb/oltp-transactional.yy --gendata=conf/mariadb/oltp-aria.zz - --grammar=conf/mariadb/oltp.yy --gendata=conf/mariadb/oltp-aria.zz - --grammar=conf/mariadb/generic-dml.yy --gendata=conf/mariadb/oltp-aria.zz - --grammar=conf/engines/engine_stress.yy --gendata=conf/engines/engine_stress.zz --engine=Aria each in 3 variations: - as is - --gendata-advanced --vcols --default-storage-engine=Aria - --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin all with CrashRestart reporter. Also need to add encrypted version.
            elenst Elena Stepanova made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]

            CrashRestart reporter didn't work well, switched to CrashUpgrade scenario (same basedir), adjusted configuration, added runs with encryption and group commit.

            elenst Elena Stepanova added a comment - CrashRestart reporter didn't work well, switched to CrashUpgrade scenario (same basedir), adjusted configuration, added runs with encryption and group commit.
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -

            Tests are being run regularly and are mostly saturated due to the amount of existing bugs (see MDEV-19813 for more details).

            elenst Elena Stepanova added a comment - Tests are being run regularly and are mostly saturated due to the amount of existing bugs (see MDEV-19813 for more details).
            elenst Elena Stepanova made changes -
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 90966 ] MariaDB v4 [ 133774 ]

            People

              elenst Elena Stepanova
              elenst Elena Stepanova
              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.