wait_timeout variable no more working in MySQL 4.0.3

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.

mysql> show variables;

| version | 4.0.3-beta-log |
| wait_timeout | 28800 |


Regards,
Jocelyn Fournier



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12249@lists.mysql.com
To unsubscribe, e-mail

Re: wait_timeout variable no more working in MySQL 4.0.3

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.
>
> mysql> show variables;
>
> | version | 4.0.3-beta-log |
> | wait_timeout | 28800 |
>
>
> Regards,
> Jocelyn Fournier


Check out whether you have not set --no-defaults or --default-file or
similar in your script.

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12255@lists.mysql.com
To unsubscribe, e-mail

Re: wait_timeout variable no more working in MySQL 4.0.3

Hi,

No, I have no option like those one set. I've not changed my configuration
(excepted some variables renaming) between MySQL 4.0.2 and 4.0.3.
Moreover other variables in my my.cnf are perfectly set.

Regards,
Jocelyn
----- Original Message -----
From: "Sinisa Milivojevic"
To:
Cc:
Sent: Wednesday, July 31, 2002 12:57 PM
Subject: Re: wait_timeout variable no more working in MySQL 4.0.3


> 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.
> >
> > mysql> show variables;
> >
> > | version | 4.0.3-beta-log |
> > | wait_timeout | 28800 |
> >
> >
> > Regards,
> > Jocelyn Fournier
>
>
> Check out whether you have not set --no-defaults or --default-file or
> similar in your script.
>
> --
> Regards,
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
> /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.com
>
>
> ------------------------------------------------------------ ---------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail bugs-thread12255@lists.mysql.com
> To unsubscribe, e-mail
>
>
>
>


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12256@lists.mysql.com
To unsubscribe, e-mail

Re: wait_timeout variable no more working in MySQL 4.0.3

Hi Jocelyn,

Jocelyn Fournier writes:
> > 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.
> > >
> > > mysql> show variables;
> > >
> > > | version | 4.0.3-beta-log |
> > > | wait_timeout | 28800 |

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

(rhols221:/my/bk/mysql-4.0) mysqladmin var | grep wait_timeout
| innodb_lock_wait_timeout | 50
|
| wait_timeout | 801
------------------------------------------------------------ ----------

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

This was SuSE Linux 7.3.

Regards,

- Jani

For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Jani Tolonen
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ www.mysql.com

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12277@lists.mysql.com
To unsubscribe, e-mail

Re: wait_timeout variable no more working in MySQL 4.0.3

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;

| wait_timeout | 28800


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
------------------------------------------------------------ ----------------

Regards,
Jocelyn Fournier


----- Original Message -----
From: "Jani Tolonen"
To: "Jocelyn Fournier"
Cc: ;
Sent: Saturday, August 03, 2002 5:32 PM
Subject: Re: wait_timeout variable no more working in MySQL 4.0.3


> Hi Jocelyn,
>
> Jocelyn Fournier writes:
> > > 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.
> > > >
> > > > mysql> show variables;
> > > >
> > > > | version | 4.0.3-beta-log |
> > > > | wait_timeout | 28800 |
>
> 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
>
> (rhols221:/my/bk/mysql-4.0) mysqladmin var | grep wait_timeout
> | innodb_lock_wait_timeout | 50
> |
> | wait_timeout | 801
> ------------------------------------------------------------ ----------
>
> So either it has been already fixed in the bk tree, or something
> else was wrong..
>
> This was SuSE Linux 7.3.
>
> Regards,
>
> - Jani
>
> For technical support contracts, visit https://order.mysql.com/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Jani Tolonen
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
> /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
> <___/ www.mysql.com
>
>
>


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12278@lists.mysql.com
To unsubscribe, e-mail

Re: wait_timeout variable no more working in MySQL 4.0.3

Hi!

>>>>> "Jocelyn" == Jocelyn Fournier writes:

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



Just a note about this:

- We will try to fix the problem with the timeout varaible today.



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



These are fixed in my bk tree; I just need to do some more testing
before pushing my tree, after which we will start building a binary
release version of 4.0.3-beta.

Regards,
Monty

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12300@lists.mysql.com
To unsubscribe, e-mail

Re: wait_timeout variable no more working in MySQL 4.0.3

Hi Jocelyn,

Jocelyn Fournier writes:
> 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;
>
> | wait_timeout | 28800
>

This is ok.

The reason is that when a client is running in interactive mode,
e.g. if flag 'CLIENT_INTERACTIVE' inside the MySQL server code is
set, it will make 'wait_timeout' to get the value from variable
'interactive_timeout'.

That's why it's different in 'mysqladmin var' and mysql> show variables;

However, your report helped me to find another bug:

'mysql -e "show variables"' is running in batch mode (non-interactive)
and should report the same as 'mysqladmin var' but it did the same
as running the client in interactive mode. The fix will be in the
bk source soon.

Regards,

- Jani

For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Jani Tolonen
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ www.mysql.com

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12312@lists.mysql.com
To unsubscribe, e-mail