Bug #47318 mysql starts with Warning: option 'max_join_size': unsigned value
Submitted: 15 Sep 2009 11:24 Modified: 15 Oct 2009 11:27
Reporter: mateusz koss Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Options Severity:S2 (Serious)
Version:5.0.51a-24+lenny2 (Debian) OS:Linux (Debian 32bits with Lenny)
Assigned to: CPU Architecture:Any
Tags: Max_join_size, select_limit

[15 Sep 2009 11:24] mateusz koss 
Description:
Mysql server started suddenly to produce:

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

adjustments of values
max_join_size
select_limit
 
in my.cnf didn't help at all. 

How to repeat:
/usr/sbin# mysql -u root -p
Warning: option 'select_limit': unsigned value 18446744073709551615 adjusted to 4294967295
Warning: option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 28
Server version: 5.0.51a-24+lenny2 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
[15 Sep 2009 11:27] Valeriy Kravchuk 
Looks like a duplicate of http://bugs.mysql.com/bug.php?id=35346. Please, check.
[15 Oct 2009 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[5 Nov 2009 16:57] Lei Li 
I am having this issue, since I upgrade MySql on my Ubuntu virtual machine. 

user@vm9:/var/backup$ mysql -uroot
Warning: option 'select_limit': unsigned value 18446744073709551615 adjusted to 4294967295
Warning: option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1645
Server version: 5.0.86-classic MySQL Classic Server (Commercial)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>