[SOLVED] mysql-server-5.0 question (squeeze)

radiodee1 · 09-09-2009, 05:05 AM

While doing updates recently I found that the package 'mysql-server' was being held back. I decided that I wanted 'mysql-server-5.1' which was the package 'mysql-server' depended on. I tried to install it and it failed. Therefore I had to reinstall mysql, and I couldn't get mysql 5.1 to work, so I reinstalled 5.0. It works BUT I get an annoying message during boot up (and whenever I restart the mysql server). It looks like this:

Code:

computer:/home/me# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
computer:/home/me# Warning: option 'select_limit': unsigned value 18446744073709551615 adjusted to 4294967295
Warning: option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
Warning: option 'select_limit': unsigned value 18446744073709551615 adjusted to 4294967295
... many repititions ...
Warning: option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
Warning: option 'select_limit': unsigned value 18446744073709551615 adjusted to 4294967295

I've tried purging and reinstalling the package mysql-server-5.0. That doesn't seem to do anything. Does anyone have a clue why this would happen?? So far it doesn't seem to effect the operation of apps that depend on mysql.

cardy · 09-09-2009, 06:47 AM

It seems this could be related to this bug.

http://bugs.mysql.com/bug.php?id=35346

Have you checked to ensure that all the mysql RPMs are the same version ?

radiodee1 · 09-22-2009, 12:02 PM

This bug report accurately describes the problem and the solution.

http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=545751

You must comment out the line that reads:

Quote:

skip-bdb

That fixes it. After that I was able to upgrade to mysql-server-5.1 and the exceedingly long messages about "max_join_size" and "select_limit" disappeared.

cardy · 09-30-2009, 09:53 AM

Interesting as the sizes listed in the original problem are an indication that you had a 64 bit and have now installed the 32 bit packages. The limits that are reduced

Quote:

Warning: option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
Warning: option 'select_limit': unsigned value 18446744073709551615 adjusted to 4294967295

The limit 18446744073709551615 is only available in 64 Bit MySQL, the default for 32 bit is the value to which it has reduced ie. 4294967295.

The other problem you have listed above may also be an issue however it seems you may have switched from 64 to 32 bit packages for the MySQL server.