Bug #66580 mysql restars in middle of long run query
Submitted: 28 Aug 2012 16:33 Modified: 28 Aug 2012 17:12
Reporter: ramakrishna v Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version: OS:Linux
Assigned to: CPU Architecture:Any
Tags: mysql restars in middle of long run query

[28 Aug 2012 16:33] ramakrishna v
The error in mysqld.log file

120828 10:16:04 mysqld_safe Number of processes running now: 0
120828 10:16:04 mysqld_safe mysqld restarted
120828 10:16:05 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --log_slow_queries is not set
120828 10:16:05 [Note] Plugin 'FEDERATED' is disabled.
120828 10:16:05 InnoDB: The InnoDB memory heap is disabled
120828 10:16:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120828 10:16:05 InnoDB: Compressed tables use zlib 1.2.3
120828 10:16:05 InnoDB: Using Linux native AIO
120828 10:16:05 InnoDB: Initializing buffer pool, size = 128.0M
120828 10:16:05 InnoDB: Completed initialization of buffer pool
120828 10:16:05 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 44701062348
120828 10:16:05  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 44701163503
InnoDB: 3 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 4664 row operations to undo
InnoDB: Trx id counter is AD1000

How to repeat:
I am using Kettle BI Tool to load data from one database to another database .

I am using Connection pool with multiple connections.
 Data is loading to target table upto 2 lakh records properly .
 After that error occurs and mysql shutdown and log is shown in Description.
[28 Aug 2012 16:34] ramakrishna v
i edited the my.cnf file with
 innodb buffer log size ,max allowed packet size increased
[28 Aug 2012 16:36] ramakrishna v
how can i make the mysql database to be run for long time
[28 Aug 2012 17:12] Valeriy Kravchuk
This is a duplicate of your older Bug #66564.