MySQL Forums
Forum List  »  Replication

Slave server crashes frequently during bulk data update on master
Posted by: Abhilash Kottodi
Date: May 30, 2014 06:44AM

Hi All,
I have a master to slave replication setup configured [MySQL 5.5.22 64 bit]. But whenever I start the modules which writes data into master, the slave mysql crashes with the following error logs:

140530 11:05:28 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.001017' at position 767757919, relay log '.\SRVR-DBProc-002-relay-bin.000001' position: 4
140530 11:05:28 [Note] Slave I/O thread: connected to master 'replicator@x.x.x.x:3306',replication started in log 'mysql-bin.001017' at position 767757919
140530 11:07:23 InnoDB: Error: page 2727995 log sequence number 711146089743
InnoDB: is in the future! Current system log sequence number 711146089291.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: for more information.
140530 11:18:46 InnoDB: Assertion failure in thread 2568 in file trx0purge.c line 829
InnoDB: Failing assertion: purge_sys->purge_trx_no <= purge_sys->rseg->last_trx_no
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
InnoDB: Thread 3040 stopped in file os0sync.c line 781
InnoDB: Thread 1144 stopped in file os0sync.c line 474
InnoDB: Thread 2556 stopped in file os0sync.c line 474

Replication was up and running for some time and it was verified by updating single row on one database table. But when the bulk inserts/updates are happening, the slave server crashes as mentioned above.

On slave server, the database dump was created by copying the raw data files from master server.

Any help is highly appreciated.

Thanks.

Regards,
Abhilash

Options: ReplyQuote


Subject
Views
Written By
Posted
Slave server crashes frequently during bulk data update on master
2156
May 30, 2014 06:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.