Re: MySQL 4.1.7 connections hang with earlier clients - Gleb Paharenko - com.mysql.lists.win32

2 messages in com.mysql.lists.win32Re: MySQL 4.1.7 connections hang with...

From	Sent On	Attachments
Klaus Prückl	18 Nov 2004 05:50
Gleb Paharenko	18 Nov 2004 09:37

Subject:	Re: MySQL 4.1.7 connections hang with earlier clients
From:	Gleb Paharenko (Gleb...@ensita.net)
Date:	11/18/2004 09:37:04 AM
List:	com.mysql.lists.win32

Hello.

I've submitted a bug http://bugs.mysql.com/6701.

Klaus Prückl wrote:

Hi,

Gleb Paharenko [mailto:gleb...@ensita.net] wrote:

There were several bugs which cause server crashes on some queries.

What queries did you use? On which tables? Send us yor my.ini files

SELECT bs.ID, bs.Name, (SELECT convert(av.value, SIGNED) FROM (AttributeValues av JOIN Batches b ON av.FK_RowID = b.ID) JOIN Products
p ON p.ID = b.FK_ProductID WHERE b.FK_BatchStorageID = bs.ID AND av.Deleted = 0 AND av.FK_AttributeID IN
(77, 90, 161, 162) AND b.Deleted = 0 AND b.Completed = 0 limit 1) As Weight, (SELECT p.Name FROM Batches b JOIN Products p ON p.ID = b.FK_ProductID WHERE b.FK_BatchStorageID = bs.ID AND b.Deleted = 0 AND b.Completed = 0 limit
1) As ProductName FROM BatchStorages bs WHERE bs.Deleted = 0 AND bs.FK_OwnerPartyID = 2;

and output of show create table on tables used in your queries.

I've uploaded the my.ini and the ddl of these tables. BTW, the table statistics:

AttributeValues: 160924 rows, Batches: 1578 rows, BatchStorages: 1524 rows, Products: 66 rows

Can you produce a test case for your problems?

I've tried to reproduce the error on another machine, but the hanging
connections only appear on the MySQL instance of the (english) Windows Server
2003. On my local machine with (german) Windows XP SP2 and the same my.ini
settings (default settings for server - transactional databases only - decision
support) no problems occur.

I've also rebuilt the database on the windows server 2003 (dump and insert) with
the same result. (hanging connections if old client starts the statement).

You may upload your error log to ftp://ftp.mysql.com/pub/mysql/upload/

I've uploaded the following files: k.pr...@itpro.at - mysql 4.1.7 crash - mysql.err k.pr...@itpro.at - mysql 4.1.7 crash - my.ini k.pr...@itpro.at - mysql 4.1.7 crash - ddl.sql

Also there is a specific list for windows - win...@lists.mysql.com.

Thanks for that information!

Klaus Pr?ckl <k.pr...@itpro.at> wrote:

Hi,

we are running a MySQL 4.1.7 database on a Windows Server 2003 = configured as "server machine" with "transactional

databases only" and =

"decision support".

With this server we are experiencing troubles with old

clients (MySQL =

Control Center 0.94 and ByteFX .NET Provider 0.76) when

running a select =

statement with 2 sub-selects, converts and some joins. With

this special =

statement, the connection thread nearly always hangs and is

showing =

"Sending data" in the state field of the MySQL

Administrator. Killing =

the thread with the Administrator is not working. Canceling

the thread =

is only possible by killing mysql in the taskmanager and

restart the =

service.

The same statement executed over MyODBC 3.51.10 and Query

Browser 1.1.1 =

is always working.

I'm not sure if this is also related to crashes of mysql we are = experiencing: The mysqld-nt version always crashed when

some threads =

were hanging. Later I switched to mysqld-debug, which seems

to be more =

stable with the hanging threads and only crashed once until now. I've tried to add the debug log, but I'm not able because of a = mailinglist size-limit.=20

Is this a known bug or should I submit this at bugs.mysql.com?

[...]

Thanks in advance, Klaus