[MDEV-3820] [Fix included] MTR1 produces bootstrap SQL file with wrong syntax, server bootstrap fails Created: 2012-10-29  Updated: 2012-10-29  Resolved: 2012-10-29

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.0
Fix Version/s: 10.0.0

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates

 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


Generated at Thu Feb 08 06:51:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.