// you’re reading...

MySQL

InnoDB lost file pointers to partitions

Recently I went through the exercise of setting up a new replicated slave host. I proceeded through my normal list of tasks to get the new host stood up. This time, something different happened. Replication crashed. Hard.

Last_SQL_Error: Could not execute Update_rows event on table core_stats.plays_hourly; 
Can't find record in 'plays_hourly', 
Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; 
the event's master log bin.014496, end_log_pos 495311588

This was a new experience for me. So being diligent, I looked at the error log for more information.

Thread pointer: 0x33f1be00
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x59f7f0f8 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x39)[0x7cdb99]
/usr/sbin/mysqld(handle_segfault+0x379)[0x500b59]
/lib64/libpthread.so.0[0x3f5b20eb10]
/lib64/libc.so.6(gsignal+0x35)[0x3f5aa30265]/lib64/libc.so.6 (abort+0x110)[0x3f5aa31d10]/usr/sbin/mysqld[0x84954a]/usr/sb in/mysqld[0x82c961]
/usr/sbin/mysqld(_ZN7handler13ha_delete_rowEPKh+0x54)[0x6917 f4]
/usr/sbin/mysqld(_ZN12ha_partition10delete_rowEPKh+0x7f)[0x9 7a05f]
/usr/sbin/mysqld(_ZN7handler13ha_delete_rowEPKh+0x54)[0x6917 f4]
/usr/sbin/mysqld(_Z12mysql_deleteP3THDP10TABLE_LISTP4ItemP10 SQL_I_ListI8st_orderEyy+0x8e8)[0x789b88]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x1aa7)[0x57 8df7]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x38 c)[0x57d6ec]
/usr/sbin/mysqld(_ZN15Query_log_event14do_apply_eventEPK14Re lay_log_infoPKcj+0xf59)[0x74e3d9]
/usr/sbin/mysqld(_Z26apply_event_and_update_posP9Log_eventP3 THDP14Relay_log_info+0x152)[0x516be2]/usr/sbin/mysqld[0x5192 f2]
/usr/sbin/mysqld(handle_slave_sql+0xc19)[0x5208f9]
/lib64/libpthread.so.0[0x3f5b20673d]
/lib64/libc.so.6(clone+0x6d)[0x3f5aad40cd]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x35d220bf): DELETE FROM [hidden schema].[hidden table] WHERE date < '2008-09-06'
Connection ID (thread ID): 11
Status: NOT_KILLED 

The solution for me was to translate "pointer" to mean INDEX. Once I made that connection, the answer was clear. Force a rebuild of the table space and indexes.

Seconds_Behind_Master: 0

Whether I was technically correct on my hypothesis, my remedy was. It's hard to argue with success.

Seconds_Behind_Master: 0

Discussion

No comments for “InnoDB lost file pointers to partitions”

Post a comment

Help support my site and buy a domain name at http://domainsemailhosting.com/

%d bloggers like this: