Bumped by Community user

occurred Sep 4, 2022 at 10:03

Bumped by Community user

occurred May 1, 2022 at 19:02

Bumped by Community user

occurred Dec 31, 2021 at 7:03

Bumped by Community user

occurred Aug 20, 2021 at 21:01

language fix and formatting change

Source Link

edited Sep 18, 2019 at 10:33

András Váczi

31.6k
13
101
149

I have two MySQL servers in replication (master -> slave).

I updated them with apt-get upgrade. It runs well on both except the I get some replication errors on slave now.

Last_Errno: 1005 Last_Error: Error 'Can't create table performance_schema.cond_instances

(errno: 131 "Command not supported by database")' on query.

Default database: 'mysql'.

Query: 'CREATE TABLE performance_schema.cond_instances(NAME VARCHAR(128) not null,OBJECT_INSTANCE_BEGIN BIGINT not null)ENGINE=PERFORMANCE_SCHEMA'

Server versions are as below:

Master
Server type: MySQL
Server version: 5.5.62-0+deb8u1-log - (Debian)

Slave
Server type: MariaDB
Server version: 10.1.26-MariaDB-0+deb9u1 - Debian 9.1

I have two MySQL servers in replication (master -> slave).

I updated them with apt-get upgrade. It runs well on both except the I get some replication errors on slave now.

Last_Errno: 1005 Last_Error: Error 'Can't create table performance_schema.cond_instances (errno: 131 "Command not supported by database")' on query. Default database: 'mysql'. Query: 'CREATE TABLE performance_schema.cond_instances(NAME VARCHAR(128) not null,OBJECT_INSTANCE_BEGIN BIGINT not null)ENGINE=PERFORMANCE_SCHEMA'

Server versions are as below:

Master
Server type: MySQL
Server version: 5.5.62-0+deb8u1-log - (Debian)

Slave
Server type: MariaDB
Server version: 10.1.26-MariaDB-0+deb9u1 - Debian 9.1

I have two MySQL servers in replication (master -> slave).

I updated them with apt-get upgrade. It runs well on both except the I get some replication errors on slave now.

Last_Errno: 1005 Last_Error: Error 'Can't create table performance_schema.cond_instances

(errno: 131 "Command not supported by database")' on query.

Default database: 'mysql'.

Query: 'CREATE TABLE performance_schema.cond_instances(NAME VARCHAR(128) not null,OBJECT_INSTANCE_BEGIN BIGINT not null)ENGINE=PERFORMANCE_SCHEMA'

Server versions are as below:

Master
Server type: MySQL
Server version: 5.5.62-0+deb8u1-log - (Debian)

Slave
Server type: MariaDB
Server version: 10.1.26-MariaDB-0+deb9u1 - Debian 9.1

language fix and formatting change

Source Link

edit approved Sep 18, 2019 at 10:33

Madhur Bhaiya

412
5
15

I have two mysql serverMySQL servers in replication (master -> slave).

I updated them with apt-get upgrade. It runs well on both except the I get some replication errors on slave now.

Last_Errno: 1005
                   Last_Error: Error 'Can't create table `performance_schema`.`cond_instances` (errno: 131 "Command not supported by database")' on query. Default database: 'mysql'. Query: 'CREATE TABLE performance_schema.cond_instances(NAME VARCHAR(128) not null,OBJECT_INSTANCE_BEGIN BIGINT not null)ENGINE=PERFORMANCE_SCHEMA'

Last_Errno: 1005 Last_Error: Error 'Can't create table performance_schema.cond_instances (errno: 131 "Command not supported by database")' on query. Default database: 'mysql'. Query: 'CREATE TABLE performance_schema.cond_instances(NAME VARCHAR(128) not null,OBJECT_INSTANCE_BEGIN BIGINT not null)ENGINE=PERFORMANCE_SCHEMA'

Server versions are as below:

Master
Server type: MySQL
Server version: 5.5.62-0+deb8u1-log - (Debian)

Slave
Server type: MariaDB
Server version: 10.1.26-MariaDB-0+deb9u1 - Debian 9.1

I have two mysql server in replication (master -> slave).

I updated them with apt-get upgrade. It runs well on both except the I get some replication errors on slave now.

Last_Errno: 1005
                   Last_Error: Error 'Can't create table `performance_schema`.`cond_instances` (errno: 131 "Command not supported by database")' on query. Default database: 'mysql'. Query: 'CREATE TABLE performance_schema.cond_instances(NAME VARCHAR(128) not null,OBJECT_INSTANCE_BEGIN BIGINT not null)ENGINE=PERFORMANCE_SCHEMA'

Master
Server type: MySQL
Server version: 5.5.62-0+deb8u1-log - (Debian)

Slave
Server type: MariaDB
Server version: 10.1.26-MariaDB-0+deb9u1 - Debian 9.1

I have two MySQL servers in replication (master -> slave).

I updated them with apt-get upgrade. It runs well on both except the I get some replication errors on slave now.

Last_Errno: 1005 Last_Error: Error 'Can't create table performance_schema.cond_instances (errno: 131 "Command not supported by database")' on query. Default database: 'mysql'. Query: 'CREATE TABLE performance_schema.cond_instances(NAME VARCHAR(128) not null,OBJECT_INSTANCE_BEGIN BIGINT not null)ENGINE=PERFORMANCE_SCHEMA'

Server versions are as below:

Master
Server type: MySQL
Server version: 5.5.62-0+deb8u1-log - (Debian)

Slave
Server type: MariaDB
Server version: 10.1.26-MariaDB-0+deb9u1 - Debian 9.1

Source Link

asked Sep 18, 2019 at 5:05

Charles

101
2

Slave error after master upgrade

I have two mysql server in replication (master -> slave).

I updated them with apt-get upgrade. It runs well on both except the I get some replication errors on slave now.

Last_Errno: 1005
                   Last_Error: Error 'Can't create table `performance_schema`.`cond_instances` (errno: 131 "Command not supported by database")' on query. Default database: 'mysql'. Query: 'CREATE TABLE performance_schema.cond_instances(NAME VARCHAR(128) not null,OBJECT_INSTANCE_BEGIN BIGINT not null)ENGINE=PERFORMANCE_SCHEMA'

Master
Server type: MySQL
Server version: 5.5.62-0+deb8u1-log - (Debian)

Slave
Server type: MariaDB
Server version: 10.1.26-MariaDB-0+deb9u1 - Debian 9.1

Stack Exchange Network

Return to Question

Slave error after master upgrade