Bug #81152 error 1778 couldn`t execute statement with implicit commit
Description:
# at 12433
#160420 9:28:21 server id 1000 end_log_pos 8567874 CRC32 0x1c6032ec GTID last_committed=13647 sequence_number=13648
SET @@SESSION.GTID_NEXT= '936028d7-04b9-11e6-ac6d-d4ae52cbf622:4432'/*!*/;
# at 12498
#160420 9:28:21 server id 1000 end_log_pos 8567937 CRC32 0xbdb35e0f Query thread_id=55 exec_time=4294966951 error_code=0
SET TIMESTAMP=1461133701/*!*/;
BEGIN
/*!*/;
# at 12561
#160420 9:28:21 server id 1000 end_log_pos 8568029 CRC32 0xc33a03cc Table_map: `abc`.`warehouses_stocks_log_data` mapped to number 1116
# at 12653
#160420 9:28:21 server id 1000 end_log_pos 8568110 CRC32 0xd4ef04f8 Table_map: `abc`.`warehouses_stocks` mapped to number 1104
# at 12734
#160420 9:28:21 server id 1000 end_log_pos 8568274 CRC32 0x5f985084 Update_rows: table id 1104
# at 12898
#160420 9:28:21 server id 1000 end_log_pos 8568392 CRC32 0xcad285fc Write_rows: table id 1116 flags: STMT_END_F
### UPDATE `abc`.`warehouses_stocks`
### WHERE
### @1=100000000000052850
### @2=100000060446
### @3=20924
### @4=30
### @5=0
### @6=1
### @7=1461069345
### @8=NULL
### @9='HQ WAREHOUSE'
### @10='ASHIK'
### @11=1
### SET
### @1=100000000000052850
### @2=100000060446
### @3=20924
### @4=23
### @5=0
### @6=1
### @7=1461069345
### @8=1461133701
### @9='HQ WAREHOUSE'
### @10='ASHIK'
### @11=3
### INSERT INTO `abc`.`warehouses_stocks_log_data`
### SET
### @1='16741875484626780330'
### @2=100000060446
### @3=20924
### @4=30
### @5=0
### @6=23
### @7=0
### @8='HQ WAREHOUSE'
### @9=1461133701
### @10='ASHIK'
### @11=2
### @12=3
# at 13016
#160420 9:28:21 server id 1000 end_log_pos 8568423 CRC32 0x09fc098b Xid = 162044
COMMIT/*!*/;
# at 13047
#160420 9:28:21 server id 1000 end_log_pos 8568488 CRC32 0xec9cd354 GTID last_committed=13648 sequence_number=13649
SET @@SESSION.GTID_NEXT= '936028d7-04b9-11e6-ac6d-d4ae52cbf622:4433'/*!*/;
# at 13112
#160420 9:28:21 server id 1000 end_log_pos 8568551 CRC32 0x2b059bc7 Query thread_id=55 exec_time=4294966951 error_code=0
SET TIMESTAMP=1461133701/*!*/;
BEGIN
/*!*/;
this is correptued relay log
after restart server it work
every 1 hour i need to restart server due to channel stopped displaying error 1778
error 1778 couldn`t execute statement with implicit commit
this is conf file
sync_master_info = 1
sync_relay_log = 1
sync_relay_log_info = 1
master-info-file = master.info
replicate-do-db = abc
enforce_gtid_consistency = ON
log-bin = ph2-bin
binlog_format = ROW
master_info_repository = TABLE
log_slave_updates
group_concat_max_len = 2048
sync_binlog = 1
max_heap_table_size = 2097152000
collation-server = utf8_unicode_ci
binlog-do-db = abc
gtid-mode = ON
relay-log-info-repository = TABLE
relay_log_purge
relay_log_recovery
sync_binlog = 1
How to repeat:
error 1778 couldn`t execute statement with implicit commit
Suggested fix:
i don`t know
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
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.