Innodb NOT inserting rows but rows ending up in binlog

  • Filter
  • Time
  • Show
Clear All
new posts

  • Innodb NOT inserting rows but rows ending up in binlog


    We ran into an interesting problem the other day, when our production database stopped inserting row into a given table even though from the clients perspective they were inserted. What makes this even stranger is that the binlog recorded these "phantom" rows which then ended up on the slave. So the Slave actually have the valid data which was missing from the Master.

    After playing for a bit, I notice that the given table was not locked, i.e. I could insert row into it. However, these rows were inserted into the next available row in the Master database, i.e. it did not skip over these phantom row. So this leads me to believe that it is some problem with InnoDB but I cannot figure out how this could have happened. Below is the table status for the table that locked up. Thanks in advance for any help.

    Name: fileInfo
    Engine: InnoDB
    Version: 10
    Row_format: Compact
    Rows: 4366226
    Avg_row_length: 3189
    Data_length: 13925089280
    Max_data_length: 0
    Index_length: 1303396352
    Data_free: 0
    Auto_increment: 5907230
    Create_time: 2009-09-04 19:27:39
    Update_time: NULL
    Check_time: NULL
    Collation: utf8_general_ci
    Checksum: NULL
    Comment: InnoDB free: 4096 kB; (`shareId`) REFER `as_prod/share`(`id`); (`userId`) REFER

  • #2
    Do you have any errors in your error log file?

    Has the MySQL process died or has the master server rebooted during this time?

    How large is your database?
    Do you have any filesystem file size limitation that you may have hit for the InnoDB tablespace on the master?