queries getting stuck in "Opening table" state

I'm having problems on several similarly-configured Windows Server
2003 servers using various revisions of MySQL 4.1. Several times a
day, a query will get stuck, and MySQL is basically useless until it
is restarted. I can't shutdown mysqld-nt.exe with "mysqladmin
shutdown" (it doesn't give me any errors, it just doesn't shut it
down) or with "net stop mysql." I have to kill it with Task Manager.
Until I do this, MySQL generally accepts incoming connections, but
queries just get stuck, and the process list grows and grows.

Very often, but not always, the query that gets stuck is "SHOW TABLE
STATUS FROM ..." or "SHOW FULL COLUMNS FROM ..." This could be
coincidental, though, since phpMyAdmin generates quite a few queries
like this.

This is a production web server which serves many customers, so there
are lots of different applications accessing MySQL, including PHP,
ColdFusion, and .NET.

I would consider upgrading to MySQL 5 if these issues have been
resolved, but I'm still concerned about incompatibilities for our
customers.

Thanks in advance.

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: queries getting stuck in "Opening table" state

On 12/23/05, Dan Fulbright wrote:
> I'm having problems on several similarly-configured Windows Server
> 2003 servers using various revisions of MySQL 4.1. Several times a

What are the exact versions? I had a similar problem with MySQL
4.1.xx, it was just annoying, simple queries with LIMIT, GROUP BY,
just SELECTs use to get stuck, the problem gone away when I upgraded
to MySQL 4.1.17, guess it was a bug of some kind.

> day, a query will get stuck, and MySQL is basically useless until it
> is restarted. I can't shutdown mysqld-nt.exe with "mysqladmin
> shutdown" (it doesn't give me any errors, it just doesn't shut it
> down) or with "net stop mysql." I have to kill it with Task Manager.
> Until I do this, MySQL generally accepts incoming connections, but
> queries just get stuck, and the process list grows and grows.

Maybe you should try switching from mysqld-nt to mysqld or mysqld-opt,
check the Manual for the differences between them and test it.

>
> Very often, but not always, the query that gets stuck is "SHOW TABLE
> STATUS FROM ..." or "SHOW FULL COLUMNS FROM ..." This could be
> coincidental, though, since phpMyAdmin generates quite a few queries
> like this.
>
> This is a production web server which serves many customers, so there
> are lots of different applications accessing MySQL, including PHP,
> ColdFusion, and .NET.
>
> I would consider upgrading to MySQL 5 if these issues have been
> resolved, but I'm still concerned about incompatibilities for our
> customers.

Well, I didn't see a reson so far to upgrade mine, so, I'm not going
to tell anyone to do it. ;)

>
> Thanks in advance.
>

Good luck,

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: queries getting stuck in "Opening table" state

> > I'm having problems on several similarly-configured Windows Server
> > 2003 servers using various revisions of MySQL 4.1. Several times a
>
> What are the exact versions? I had a similar problem with MySQL
> 4.1.xx, it was just annoying, simple queries with LIMIT, GROUP BY,
> just SELECTs use to get stuck, the problem gone away when I upgraded
> to MySQL 4.1.17, guess it was a bug of some kind.

Doing a spot check on three of the servers that have this problem, I
see that one is running MySQL 4.1.11, and two are running 4.1.15.

You mentioned 4.1.17, however the GA release is 4.1.16. Do you know
something I don't know? :-) I'll try upgrading to 4.1.16 and see if
that fixes it.


> > day, a query will get stuck, and MySQL is basically useless until it
> > is restarted. I can't shutdown mysqld-nt.exe with "mysqladmin
> > shutdown" (it doesn't give me any errors, it just doesn't shut it
> > down) or with "net stop mysql." I have to kill it with Task Manager.
> > Until I do this, MySQL generally accepts incoming connections, but
> > queries just get stuck, and the process list grows and grows.
>
> Maybe you should try switching from mysqld-nt to mysqld or mysqld-opt,
> check the Manual for the differences between them and test it.

That's something I haven't tried. Thanks for the suggestion.

I'll give both your suggestions a try and report back here with the
results.

Thanks again.

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: queries getting stuck in "Opening table" state

On 12/23/05, Dan Fulbright wrote:
> > > I'm having problems on several similarly-configured Windows Server
> > > 2003 servers using various revisions of MySQL 4.1. Several times a
> >
> > What are the exact versions? I had a similar problem with MySQL
> > 4.1.xx, it was just annoying, simple queries with LIMIT, GROUP BY,
> > just SELECTs use to get stuck, the problem gone away when I upgraded
> > to MySQL 4.1.17, guess it was a bug of some kind.
>
> Doing a spot check on three of the servers that have this problem, I
> see that one is running MySQL 4.1.11, and two are running 4.1.15.
>
> You mentioned 4.1.17, however the GA release is 4.1.16. Do you know
> something I don't know? :-) I'll try upgrading to 4.1.16 and see if
> that fixes it.
>

Now, that scared me, just entered MySQL site and noticed that too, but
one of my win servers is running 4.1.18, along with both lin servers.
What happened? Where are the other releases?! Someone?! Ok, I've been
working a lot, but downloading 2 "inexistent" packages with higher
versions... Nah.

>
> > > day, a query will get stuck, and MySQL is basically useless until it
> > > is restarted. I can't shutdown mysqld-nt.exe with "mysqladmin
> > > shutdown" (it doesn't give me any errors, it just doesn't shut it
> > > down) or with "net stop mysql." I have to kill it with Task Manager.
> > > Until I do this, MySQL generally accepts incoming connections, but
> > > queries just get stuck, and the process list grows and grows.
> >
> > Maybe you should try switching from mysqld-nt to mysqld or mysqld-opt,
> > check the Manual for the differences between them and test it.
>
> That's something I haven't tried. Thanks for the suggestion.
>
> I'll give both your suggestions a try and report back here with the
> results.
>
> Thanks again.
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: queries getting stuck in "Opening table" state

Are you guys sure you don't mix 4.0 and 4.1 ?
Sorry, just a tought ... :-)

Markus

Merry Christmas & Happy New Year. to everybody on this list !



----- Original Message -----
From: "Daniel da Veiga"
To:
Sent: Friday, December 23, 2005 2:13 PM
Subject: Re: queries getting stuck in "Opening table" state


On 12/23/05, Dan Fulbright wrote:
> > > I'm having problems on several similarly-configured Windows Server
> > > 2003 servers using various revisions of MySQL 4.1. Several times a
> >
> > What are the exact versions? I had a similar problem with MySQL
> > 4.1.xx, it was just annoying, simple queries with LIMIT, GROUP BY,
> > just SELECTs use to get stuck, the problem gone away when I upgraded
> > to MySQL 4.1.17, guess it was a bug of some kind.
>
> Doing a spot check on three of the servers that have this problem, I
> see that one is running MySQL 4.1.11, and two are running 4.1.15.
>
> You mentioned 4.1.17, however the GA release is 4.1.16. Do you know
> something I don't know? :-) I'll try upgrading to 4.1.16 and see if
> that fixes it.
>

Now, that scared me, just entered MySQL site and noticed that too, but
one of my win servers is running 4.1.18, along with both lin servers.
What happened? Where are the other releases?! Someone?! Ok, I've been
working a lot, but downloading 2 "inexistent" packages with higher
versions... Nah.

>
> > > day, a query will get stuck, and MySQL is basically useless until it
> > > is restarted. I can't shutdown mysqld-nt.exe with "mysqladmin
> > > shutdown" (it doesn't give me any errors, it just doesn't shut it
> > > down) or with "net stop mysql." I have to kill it with Task Manager.
> > > Until I do this, MySQL generally accepts incoming connections, but
> > > queries just get stuck, and the process list grows and grows.
> >
> > Maybe you should try switching from mysqld-nt to mysqld or mysqld-opt,
> > check the Manual for the differences between them and test it.
>
> That's something I haven't tried. Thanks for the suggestion.
>
> I'll give both your suggestions a try and report back here with the
> results.
>
> Thanks again.
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=markus.grossrieder@alba-s ystems.com




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: queries getting stuck in "Opening table" state

Hi!

This is this bug:

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

in the MS Visual C++ runtime library. A workaround appeared on Friday in
MySQL-5.0.18, and will also be in 4.1.17.

Best regards,

Heikki

Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php


......................
I'm having problems on several similarly-configured Windows Server
2003 servers using various revisions of MySQL 4.1. Several times a
day, a query will get stuck, and MySQL is basically useless until it
is restarted. I can't shutdown mysqld-nt.exe with "mysqladmin
shutdown" (it doesn't give me any errors, it just doesn't shut it
down) or with "net stop mysql." I have to kill it with Task Manager.
Until I do this, MySQL generally accepts incoming connections, but
queries just get stuck, and the process list grows and grows.

Very often, but not always, the query that gets stuck is "SHOW TABLE
STATUS FROM ..." or "SHOW FULL COLUMNS FROM ..." This could be
coincidental, though, since phpMyAdmin generates quite a few queries
like this.

This is a production web server which serves many customers, so there
are lots of different applications accessing MySQL, including PHP,
ColdFusion, and .NET.

I would consider upgrading to MySQL 5 if these issues have been
resolved, but I'm still concerned about incompatibilities for our
customers.

Thanks in advance.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: queries getting stuck in "Opening table" state

Hi,

I can confirm that the bug is still there in the version:
mysqladmin Ver 8.41 Distrib 5.0.17, for Win32 on ia32.
I'm using a Perl script which does a "show columns FROM table"-query and
from time to time, the MySQL server hangs.
Only a reboot helps.

David


-----Original Message-----
From: Heikki Tuuri [mailto:heikki.tuuri@oracle.com]=20
Sent: 01 January 2006 15:28
To: win32@lists.mysql.com
Subject: Re: queries getting stuck in "Opening table" state

Hi!

This is this bug:

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

in the MS Visual C++ runtime library. A workaround appeared on Friday in
MySQL-5.0.18, and will also be in 4.1.17.

Best regards,

Heikki

Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
MyISAM tables http://www.innodb.com/order.php


......................
I'm having problems on several similarly-configured Windows Server
2003 servers using various revisions of MySQL 4.1. Several times a
day, a query will get stuck, and MySQL is basically useless until it
is restarted. I can't shutdown mysqld-nt.exe with "mysqladmin
shutdown" (it doesn't give me any errors, it just doesn't shut it
down) or with "net stop mysql." I have to kill it with Task Manager.
Until I do this, MySQL generally accepts incoming connections, but
queries just get stuck, and the process list grows and grows.

Very often, but not always, the query that gets stuck is "SHOW TABLE
STATUS FROM ..." or "SHOW FULL COLUMNS FROM ..." This could be
coincidental, though, since phpMyAdmin generates quite a few queries
like this.

This is a production web server which serves many customers, so there
are lots of different applications accessing MySQL, including PHP,
ColdFusion, and .NET.

I would consider upgrading to MySQL 5 if these issues have been
resolved, but I'm still concerned about incompatibilities for our
customers.

Thanks in advance.=20


--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=3Ddappeltans@axway.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org