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

[Fix included] MTR1 produces bootstrap SQL file with wrong syntax, server bootstrap fails

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.0
    • 10.0.0
    • None
    • None

    Description

      This used to be bug http://bugs.mysql.com/bug.php?id=55983 in MySQL

      While running in MTR-1 mode, MTR produces bootsrap SQL file starting with

      "use mysql-- Copyright ..."

      (no semicolon and line break after 'use mysql')

      While earlier the syntax was accepted and handled, with the new implementation of server bootstrap it is not anymore, which makes server startup fail.

      It might be a problem for those who uses runall.pl RQG script (unlike runall-new.pl, it still uses MTR1 to start server)

      How to repeat:

      export MTR_VERSION=1
      perl ./mysql-test-run.pl main.1st

      Fix (for 10.0-serg revno 3452):

      === modified file 'mysql-test/lib/v1/mysql-test-run.pl'
      --- mysql-test/lib/v1/mysql-test-run.pl 2012-01-13 14:50:02 +0000
      +++ mysql-test/lib/v1/mysql-test-run.pl 2012-10-29 01:46:12 +0000
      @@ -3223,7 +3223,7 @@
         my $bootstrap_sql_file= "$opt_vardir/tmp/bootstrap.sql";
       
         # Use the mysql database for system tables
      -  mtr_tofile($bootstrap_sql_file, "use mysql");
      +  mtr_tofile($bootstrap_sql_file, "use mysql;\n");
       
         # Add the offical mysql system tables
         # for a production system

      Attachments

        Activity

          elenst Elena Stepanova created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          serg Sergei Golubchik made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 24909 ] MariaDB v2 [ 45364 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 45364 ] MariaDB v3 [ 66028 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 66028 ] MariaDB v4 [ 146173 ]

          People

            serg Sergei Golubchik
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.