Not the answer you need?
Register and ask your own question!

GRA_*.log

vietcgivietcgi EntrantCurrent User Role Beginner
Hi there,

We have a cluster of 3 servers and I've found quite a few GRA files with the debug logs below. The query looks very abnormal "DROP TABLE `#Tableau_01_sid_003CB13E_1_Conn". We dont' have any tables called Tableau in our exchange database. I wonder how to get rid of those errors.

Thanks

/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!50003 SET @[email protected]@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#140113 11:12:42 server id 3 end_log_pos 120 CRC32 0xe6f1f7fe Start: binlog v 4, server v 5.6.15-log created 140113 11:12:42 at startup
ROLLBACK/*!*/;
BINLOG '
qjrUUg8DAAAAdAAAAHgAAAAAAAQANS42LjE1LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAACqOtRSEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAf73
8eY=
'/*!*/;
# at 120
#140113 11:12:43 server id 3 end_log_pos 143 CRC32 0x26e85337 Stop
# at 143
#180709 11:35:53 server id 2 end_log_pos 114 CRC32 0x60746365 Query thread_id=3977534 exec_time=0 error_code=0
use `exchange`/*!*/;
SET TIMESTAMP=1531161353/*!*/;
SET @@session.pseudo_thread_id=3977534/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1436549120/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=224/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
DROP TABLE `#Tableau_01_sid_003CB13E_1_Conn
/*!*/;
SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/;
DELIMITER ;
# End of log file
/*!50003 SET [email protected]_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    This is result of how DDLs are replicated in Galera. Even if you do DDL against a non existing table, so ineffective on the node you work on, it will still get replicated to the other nodes, and these nodes will produce GRA files due to being unable to apply those DDLs.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.