0

I have two production Mariadb servers running on Ubuntu 16.04 that have a second instance running on them on port 3307. I've set up up a third instance to run on port 3309. I've created a new data directory and given ownership to the mysql user. I initialized the new instances with:

sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/data/cluster --defaults-file=/etc/mysql/conf.d/cluster.cnf

When I try to start the instances with mysqld_multi start 400 I get the same errors on both of them:

2019-06-07 11:34:03 139746831079616 [Note] InnoDB: 5.7.19 started; log sequence number 1603704
2019-06-07 11:34:03 139745711597312 [Note] InnoDB: Loading buffer pool(s) from /data/cluster/mysql/ib_buffer_pool
2019-06-07 11:34:03 139745711597312 [Note] InnoDB: Cannot open '/data/cluster/mysql/ib_buffer_pool' for reading: No such file or directory
2019-06-07 11:34:03 139746831079616 [Note] Plugin 'FEEDBACK' is disabled.
2019-06-07 11:34:03 139746831079616 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-06-07 11:34:03 139746831079616 [Note] Recovering after a crash using corvex-bin
2019-06-07 11:34:03 139746831079616 [Note] Starting crash recovery...
2019-06-07 11:34:03 139746831079616 [Note] Crash recovery finished.
2019-06-07 11:34:03 139746319828736 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
2019-06-07 11:34:03 139746831079616 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2019-06-07 11:34:03 139746831079616 [Note] Server socket created on IP: '0.0.0.0'.
2019-06-07 11:34:03 139746831079616 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist.

Everything I've seen relates this error to having recently upgraded mariadb, however this is not the case. These servers haven't been upgraded, I'm simply adding another instance to be invoked with mysqld_multi.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.