[Maria-discuss] warning from binary tarball file installation.
I am installing mariadb-10.0.15 on Fedora 20 from a binary tarball file. After several changes on .my.cnf file, I minimized the installation warning to three. I am using the default my-large.cnf file from the release. How can I eliminate them, particularly the last one: Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist. Thanks, [root@dev2 mysql]# ./scripts/mysql_install_db --defaults-file=~/.my.cnf --user=mysql Installing MariaDB/MySQL system tables in './data' ... 150225 10:37:35 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150225 10:37:35 [Note] InnoDB: The InnoDB memory heap is disabled 150225 10:37:35 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150225 10:37:35 [Note] InnoDB: Memory barrier is not used 150225 10:37:35 [Note] InnoDB: Compressed tables use zlib 1.2.3 150225 10:37:35 [Note] InnoDB: Using Linux native AIO 150225 10:37:35 [Note] InnoDB: Not using CPU crc32 instructions 150225 10:37:35 [Note] InnoDB: Initializing buffer pool, size = 384.0M 150225 10:37:35 [Note] InnoDB: Completed initialization of buffer pool 150225 10:37:35 [Note] InnoDB: The first specified data file /usr/local/mysql/data/ibdata1 did not exist: a new database to be created! 150225 10:37:35 [Note] InnoDB: Setting file /usr/local/mysql/data/ibdata1 size to 2000 MB 150225 10:37:35 [Note] InnoDB: Database physically writes the file full: wait... InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 150225 10:37:42 [Note] InnoDB: Data file /usr/local/mysql/data/ibdata2 did not exist: new to be created 150225 10:37:42 [Note] InnoDB: Setting file /usr/local/mysql/data/ibdata2 size to 10 MB 150225 10:37:42 [Note] InnoDB: Database physically writes the file full: wait... 150225 10:37:42 [Note] InnoDB: Setting log file /usr/local/mysql/data/ib_logfile101 size to 100 MB InnoDB: Progress in MB: 100 150225 10:37:43 [Note] InnoDB: Setting log file /usr/local/mysql/data/ib_logfile1 size to 100 MB InnoDB: Progress in MB: 100 150225 10:37:43 [Note] InnoDB: Renaming log file /usr/local/mysql/data/ib_logfile101 to /usr/local/mysql/data/ib_logfile0 150225 10:37:43 [Warning] InnoDB: New log files created, LSN=45782 150225 10:37:43 [Note] InnoDB: Doublewrite buffer not found: creating new 150225 10:37:43 [Note] InnoDB: Doublewrite buffer created 150225 10:37:43 [Note] InnoDB: 128 rollback segment(s) are active. 150225 10:37:43 [Warning] InnoDB: Creating foreign key constraint system tables. 150225 10:37:43 [Note] InnoDB: Foreign key constraint system tables created 150225 10:37:43 [Note] InnoDB: Creating tablespace and datafile system tables. 150225 10:37:43 [Note] InnoDB: Tablespace and datafile system tables created. 150225 10:37:43 [Note] InnoDB: Waiting for purge to start 150225 10:37:43 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.21-70.0 started; log sequence number 0 150225 10:37:43 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist 150225 10:37:43 [Note] InnoDB: FTS optimize thread exiting. 150225 10:37:43 [Note] InnoDB: Starting shutdown... 150225 10:37:45 [Note] InnoDB: Shutdown completed; log sequence number 1616698 OK Filling help tables... 150225 10:37:45 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150225 10:37:45 [Note] InnoDB: The InnoDB memory heap is disabled 150225 10:37:45 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150225 10:37:45 [Note] InnoDB: Memory barrier is not used 150225 10:37:45 [Note] InnoDB: Compressed tables use zlib 1.2.3 150225 10:37:45 [Note] InnoDB: Using Linux native AIO 150225 10:37:45 [Note] InnoDB: Not using CPU crc32 instructions 150225 10:37:45 [Note] InnoDB: Initializing buffer pool, size = 384.0M 150225 10:37:45 [Note] InnoDB: Completed initialization of buffer pool 150225 10:37:45 [Note] InnoDB: Highest supported file format is Barracuda. 150225 10:37:45 [Note] InnoDB: 128 rollback segment(s) are active. 150225 10:37:45 [Note] InnoDB: Waiting for purge to start 150225 10:37:45 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.21-70.0 started; log sequence number 1616698 150225 10:37:46 [Note] InnoDB: FTS optimize thread exiting. 150225 10:37:46 [Note] InnoDB: Starting shutdown... 150225 10:37:48 [Note] InnoDB: Shutdown completed; log sequence number 1616708 OK
Am 25.02.2015 um 16:47 schrieb Peter Boston:
I am installing mariadb-10.0.15 on Fedora 20 from a binary tarball file. After several changes on .my.cnf file, I minimized the installation *warning* to three. I am using the default *my-large.cnf* file from the release.
How can I eliminate them, particularly the last one: *Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist.*
just run *always* mysql_upgrade after any update of MySQL/MariaDB mariadb-manpages-10.0.17-2.fc20.20150228.rh.x86_64 mariadb-libs-10.0.17-2.fc20.20150228.rh.x86_64 mariadb-test-10.0.17-2.fc20.20150228.rh.x86_64 mariadb-server-10.0.17-2.fc20.20150228.rh.x86_64 mariadb-10.0.17-2.fc20.20150228.rh.x86_64 mariadb-devel-10.0.17-2.fc20.20150228.rh.x86_64 _______________________________________________________ 150228 12:47:10 [Note] Server socket created on IP: '127.0.0.1'. 150228 12:47:10 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it 150228 12:47:10 [Note] Event Scheduler: Loaded 0 events 150228 12:47:10 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist 150228 12:47:10 [Note] /usr/libexec/mysqld: ready for connections. Version: '10.0.17-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 thelounge _______________________________________________________ 150228 12:49:05 [Note] Server socket created on IP: '127.0.0.1'. 150228 12:49:05 [Note] Event Scheduler: Loaded 0 events 150228 12:49:05 [Note] /usr/libexec/mysqld: ready for connections. Version: '10.0.17-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 thelounge
participants (2)
-
Peter Boston
-
Reindl Harald