Description:
Hi,
I have changed default data dir location from
/var/lib/mysql to /service/lib/mysql
where /service is another disk partition.
I copied all files from /var/lib/mysql to /service/lib/mysql
ibdata1 file was cut-pasted due to disk space issue.
Since then i am receiving error as below on /var/log/mysqld.log
120730 13:42:08 InnoDB: Warning: purge reached the head of the history list,
InnoDB: but its length is still reported as 114875! Make a detailed bug
InnoDB: report, and submit it to http://bugs.mysql.com
===========================================================================
mysql_log_30july2012.log
===========================================================================
120730 13:45:10 InnoDB: Warning: purge reached the head of the history list,
InnoDB: but its length is still reported as 114879! Make a detailed bug
InnoDB: report, and submit it to http://bugs.mysql.com
120730 13:46:11 InnoDB: Warning: purge reached the head of the history list,
InnoDB: but its length is still reported as 114880! Make a detailed bug
InnoDB: report, and submit it to http://bugs.mysql.com
120730 13:47:11 InnoDB: Warning: purge reached the head of the history list,
InnoDB: but its length is still reported as 114881! Make a detailed bug
InnoDB: report, and submit it to http://bugs.mysql.com
120730 13:48:12 InnoDB: Warning: purge reached the head of the history list,
InnoDB: but its length is still reported as 114883! Make a detailed bug
InnoDB: report, and submit it to http://bugs.mysql.com
120730 13:49:12 InnoDB: Warning: purge reached the head of the history list,
InnoDB: but its length is still reported as 114884! Make a detailed bug
InnoDB: report, and submit it to http://bugs.mysql.com
120730 13:50:13 InnoDB: Warning: purge reached the head of the history list,
InnoDB: but its length is still reported as 114885! Make a detailed bug
InnoDB: report, and submit it to http://bugs.mysql.com
120730 13:51:14 InnoDB: Warning: purge reached the head of the history list,
InnoDB: but its length is still reported as 114887! Make a detailed bug
InnoDB: report, and submit it to http://bugs.mysql.com
===========================================================================
my.cnf
===========================================================================
[mysqld]
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
slow_query_log = 1
slow_query_log_file = /service/lib/mysql/staging1.server.slow.log
long_query_time=3
query_cache_type=0
#query_cache_limit=1M
#query_cache_size=8M
sort_buffer_size=256K
read_buffer_size=256K
read_rnd_buffer_size=4M
innodb_buffer_pool_size=16M
# new location due to insufficient disk space
datadir=/service/lib/mysql
socket=/service/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
===========================================================================
mysql_datadir_new.txt
===========================================================================
/service/lib/mysql
total 13G
drwx------ 2 mysql mysql 4.0K Jun 18 15:49 ep_accounting
drwxr-xr-x 2 mysql mysql 4.0K Jun 18 11:23 ep_achievements
drwxr-xr-x 2 mysql mysql 4.0K Jun 18 11:23 ep_bet
drwxr-xr-x 2 mysql mysql 4.0K Jun 20 14:06 ep_necasino
drwxr-xr-x 2 mysql mysql 4.0K Jun 18 11:23 ep_ongamenetwork
drwxr-xr-x 2 mysql mysql 4.0K Jun 18 11:23 ep_payments
drwxr-xr-x 2 mysql mysql 4.0K Jul 30 13:09 ep_points
drwxr-xr-x 2 mysql mysql 4.0K Jun 18 11:25 ep_referfriend
drwxr-xr-x 2 mysql mysql 4.0K Jul 27 10:03 ep_retention
drwx------ 2 mysql mysql 4.0K Jul 27 13:27 ep_stats
drwxr-xr-x 2 mysql mysql 4.0K Jun 18 11:23 ep_test
drwxr-xr-x 2 mysql mysql 4.0K Jul 27 15:50 europoker_com
-rwxr-xr-x 1 mysql mysql 13G Jul 30 13:57 ibdata1
-rwxr-xr-x 1 mysql mysql 5.0M Jul 30 13:57 ib_logfile0
-rwxr-xr-x 1 mysql mysql 5.0M Jul 30 13:08 ib_logfile1
drwxr-xr-x 6 mysql mysql 4.0K Jun 18 11:50 mysql
srwxrwxrwx 1 mysql mysql 0 Jul 27 11:30 mysql.sock
drwxr-xr-x 2 mysql mysql 4.0K Jun 18 11:25 pa_notification
drwx------ 2 mysql mysql 4.0K Jun 18 14:36 pokeraffiliate
-rw-rw---- 1 mysql mysql 504M Jul 30 13:22 staging1.server.slow.log
-rw-rw---- 1 mysql mysql 123K Jul 23 13:55 staging1.slow.log
drwxr-xr-x 2 mysql mysql 4.0K Jun 18 11:23 test
===========================================================================
mysql_datadir_old.txt
===========================================================================
/var/lib/mysql
total 11M
drwxrwxrwx 2 mysql mysql 4.0K Jun 5 15:19 ep_achievements
drwxrwxrwx 2 mysql mysql 4.0K Jun 5 15:19 ep_bet
drwxrwxrwx 2 mysql mysql 4.0K Jun 6 12:30 ep_necasino
drwxrwxrwx 2 mysql mysql 4.0K Jun 5 15:20 ep_ongamenetwork
drwxrwxrwx 2 mysql mysql 4.0K Jun 5 15:21 ep_payments
drwxrwxrwx 2 mysql mysql 4.0K Jun 5 15:22 ep_points
drwxrwxrwx 2 mysql mysql 4.0K Jun 5 15:24 ep_referfriend
drwxrwxrwx 2 mysql mysql 4.0K Jun 5 15:25 ep_retention
drwxrwxrwx 2 mysql mysql 4.0K Jun 6 08:54 ep_test
drwxrwxrwx 2 mysql mysql 4.0K Jun 15 15:05 europoker_com
-rwxrwxrwx 1 mysql mysql 5.0M Jun 18 11:34 ib_logfile0
-rwxrwxrwx 1 mysql mysql 5.0M Jun 18 11:33 ib_logfile1
drwxrwxrwx 2 mysql mysql 4.0K Jun 4 15:45 mysql
lrwxrwxrwx 1 root root 29 Jun 18 13:01 mysql.sock -> /service/lib/mysql/mysql.sock
drwxrwxrwx 2 mysql mysql 4.0K Jun 5 15:27 pa_notification
drwxrwxrwx 2 mysql mysql 4.0K Jun 15 16:48 pokeraffiliate
drwxrwxrwx 2 mysql mysql 4.0K Jun 4 15:45 test
===========================================================================
OS : Linux 2.6.32-220.7.1.el6.x86_64 #1 SMP Wed Mar 7 00:52:02 GMT 2012 x86_64 x86_64 x86_64 GNU/Linux
MySQL version: 5.1.61
Kindly advise, how to resolve this warning.
Regards,
Aarya
How to repeat:
1.MySQl 5.1.61
2.Change default data dir location to some other location.
3.Copy ibdata1 file to new datadir location.
4.Edit my.cnf to set datadir to new location.
5.Restart MySQL server.