Buy Percona ServicesBuy Now!

GRA_*.log

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • GRA_*.log

    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 '
    qjrUUg8DAAAAdAAAAHgAAAAAAAQANS42LjE1LWxvZwAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAA
    AAAAAAAAAAAAAAAAAACqOtRSEzgNAAgAEgAEBAQEEgAAXAAEGg gAAAAICAgCAAAACgoKGRkAAf73
    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.collat ion_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*/;

  • #2
    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.

    Comment

    Working...
    X