MySQLアップグレード時の libtoolT エラー - MONO*LOG

MySQLアップグレード時の libtoolT エラー

MySQL 5.1.48 にアップグレードをしようとしたら、configure の終了間際に変わったエラーが出力されていた。

config.status: executing libtool commands
/bin/rm: cannot remove `libtoolT': No such file or directory


libtoolsのバグのようだが、下記手順にて configure を再生成する。(パスは適宜変更すること)

$ libtoolize --force
Using `AC_PROG_RANLIB' is rendered obsolete by `AC_PROG_LIBTOOL'
You should update your `aclocal.m4' by running aclocal.
$ aclocal
$ cp -p BUILD/compile-pentium-max compile
$ autoreconf
$ ./configure --prefix=/usr/local/mysql --enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --with-mysqld-user=mysql --with-charset=utf8 --with-collation=utf8_general_ci --with-extra-charsets=all --with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock --with-libwrap --with-pthread --without-libedit --without-readline --with-plugins=max-no-ndb


これで無事、エラーは解決した。
既存の MySQL をアップグレードした場合、いくつかの my.cnf のシンタックスが変更になっているので起動時ログをチェックすること。

100720 16:44:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
100720 16:44:40 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
100720 16:44:40 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
100720 16:44:40 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
100720 16:44:40 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
100720 16:44:40  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100720 16:44:40  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
100720 16:44:41  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
100720 16:44:41  InnoDB: Started; log sequence number 0 0
100720 16:44:41 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_Z
100720 16:44:41 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
100720 16:44:41 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/usr/local/mysql/tmp/mysql.sock'  port: 3306  Source distribution


ログによって mysql データベースに変更があったことがわかったので、以下のコマンドを実行する。(パスは適宜変更すること)

$ mysql_upgrade --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var -uroot -p

コメントする

アーカイブ