MySQL Forums
Forum List  »  Replication

mysql 5.7.13 replication problem with error code 1778
Posted by: Samin Munankarmi
Date: July 28, 2016 09:44PM

hello, I'm new to MySQL, we have installed MySQL database in Ubuntu 16.04,
we have one master MySQL database and 3 MySQL slave servers, in one of the MySQL slave server I found following problem and replication is stopped, the o/p of "Show slave status\G":

mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: XX.XX.XX.XX
Master_User: abcd
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000136
Read_Master_Log_Pos: 23518546
Relay_Log_File: relay-log-slave.000060
Relay_Log_Pos: 32249249
Relay_Master_Log_File: mysql-bin.000135
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1778
Last_Error: Error 'Cannot execute statements with implicit commit inside a transaction when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.' on query. Default database: 'systemx'. Query: 'BEGIN'
Skip_Counter: 0
Exec_Master_Log_Pos: 32249036
Relay_Log_Space: 128378703
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 1778
Last_SQL_Error: Error 'Cannot execute statements with implicit commit inside a transaction when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.' on query. Default database: 'systemx'. Query: 'BEGIN'
Replicate_Ignore_Server_Ids:
Master_Server_Id: 111
Master_UUID: e9c6aa57-fefd-11e5-a9a4-002590478768
Master_Info_File: /opt/db/mysql/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State:
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp: 160728 11:14:12
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set: e9c6aa57-fefd-11e5-a9a4-002590478768:6078579-7402873:7402875-7608545
Executed_Gtid_Set: e9c6aa57-fefd-11e5-a9a4-002590478768:1-7402876
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
1 row in set (0.00 sec)


the configuration of the mysqld.cnf

[mysqld_safe]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /opt/db/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
explicit_defaults_for_timestamp
log-bin=mysql-bin
server-id=212
relay-log=relay-log-slave
read-only=ON
gtid-mode=ON
enforce-gtid-consistency
binlog_format=MIXED
lower_case_table_names=1
log-slave-updates
skip-slave-start

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 0.0.0.0

log-error = /var/log/mysql/error.log

# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

Please anyone help to reason behind this issue, I searched the internet and found that this could be a possible bug of MySQL.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql 5.7.13 replication problem with error code 1778
2973
July 28, 2016 09:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.