bjoernhaeuser bjoernhaeuser - 1 year ago 67
MySQL Question

mysqlbinarylog - uniqueness of table_id in TABLE_MAP_EVENT

I am trying to manually decode the mysql binary log ROW format. Every update/insert/delete event is preceeded by an TABLE_MAP_EVENT.

This event contains a

. I am using this id to build up an cache for the column definition of this table.

From time to time I am having errors in said cache, because mismatch of column information. I am currently not able to reproduce these problems in short living connections, only in log connections where binary log file rotation occurs.

I am suspecting that the
is only unique for one binary log file. Does anyone knows if this assumption holds true? Does anyone know where to find the documentation which declares what I can expect from the

Thanks in advance

Answer Source

Since I cannot see your actual implementation, this is just a blind guess, but take a look at the bug below, maybe that causes your headache:

        Table IDs used in replication were defined as type ulong on the 
        master and uint on the slave. In addition, the maximum value for 
        table IDs in binary log events is 6 bytes (281474976710655). This 
        combination of factors led to the following issues:

            Data could be lost on the slave when a table was assigned an 
            ID greater than uint.

            *Table IDs greater than 281474976710655 were written to the 
            binary log as 281474976710655.*
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download