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 @OLD_COMPLETION_TYPE=@@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 COMPLETION_TYPE=@OLD_COMPLETION_TYPE/;
/!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0/;