Description:
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.