Re: wait_timeout variable no more working in MySQL 4.0.3 - Jocelyn Fournier - com.mysql.lists.bugs

7 messages in com.mysql.lists.bugsRe: wait_timeout variable no more wor...

From	Sent On	Attachments
Jocelyn Fournier	30 Jul 2002 16:47
Sinisa Milivojevic	31 Jul 2002 03:56
Jocelyn Fournier	31 Jul 2002 03:59
Jani Tolonen	03 Aug 2002 08:32
Jocelyn Fournier	03 Aug 2002 09:31
Michael Widenius	06 Aug 2002 04:18
Jani Tolonen	06 Aug 2002 12:43

Subject:	Re: wait_timeout variable no more working in MySQL 4.0.3
From:	Jocelyn Fournier (jo...@presence-pc.com)
Date:	08/03/2002 09:31:09 AM
List:	com.mysql.lists.bugs

Hi,

In fact it seems it's only show processlist; which is affected by this bug :

[root@forum] /home/mysql-4.0> ./sql/mysqld --help | grep wait_timeout --innodb_lock_wait_timeout=# --wait_timeout=# The number of seconds the server waits for activity on a innodb_lock_wait_timeout 50 wait_timeout 20 [root@forum] /home/mysql-4.0> mysqladmin -uroot -p var | grep wait_timeout Enter password: | innodb_lock_wait_timeout | 50 | | wait_timeout | 20 | [root@forum] /home/mysql-4.0> mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 85105 to server version: 4.0.3-beta

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

mysql> show variables; <cut> | wait_timeout | 28800 <cut>

BTW, I'm still unable to compile 4.0.3 without the following modification :

in my set_var.cc file still refuse to compile, I have to change sys_var *find_sys_var(const char *str, uint length=0) in set_var.cc to sys_var *find_sys_var(const char *str, uint length)

set_var.cc: In function `sys_var* find_sys_var(const char*, unsigned int)': set_var.cc:1146: default argument given for parameter 2 of `sys_var* find_sys_var(const char*, unsigned int = 0)' set_var.h:416: after previous specification in `sys_var* find_sys_var(const char*, unsigned int = 0)'

I'm using the latest cset avalaible :

---------------------- Receiving the following csets ----------------------- 1.1145 1.1139.1.1 1.1144 1.1143

----------------------------------------------------------------------------

Hi Jocelyn,

Jocelyn Fournier writes:

Hi,

I'm setting wait_timeout variable through the my.cnf file. Since I've upgraded from MySQL 4.0.2 to 4.0.3 (latest bk source), this variable seems to have no effect.

How-to-repeat :

In my.cnf :

set-variable = wait_timeout=20

[root@forum] /usr/local/mysql/var> mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 345 to server version: 4.0.3-beta-log

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

I just tested with the latest source from bk and it seems to work for me, I haven't yet tested with released 4.0.2; can you please verify if it works for you similarly:

---------------------------------------------------------------------- (rhols221:/my/bk/mysql-4.0) grep wait_timeout ~/.my.cnf set-variable = wait_timeout=801 /* some odd value for testing purposes*/

(rhols221:/my/bk/mysql-4.0) ./sql/mysqld --help | grep wait_timeout --innodb_lock_wait_timeout=# --wait_timeout=# The number of seconds the server waits for activity on a innodb_lock_wait_timeout 50 wait_timeout 801

(rhols221:/my/bk/mysql-4.0) ./sql/mysqld --language=./sql/share/english/ & [1] 1987 (rhols221:/my/bk/mysql-4.0) ./sql/mysqld: ready for connections

----------------------------------------------------------------------

So either it has been already fixed in the bk tree, or something else was wrong..

This was SuSE Linux 7.3.

Regards,

- Jani