Zeos hangs on Connect attempt to non-existent MySQL DB

The alpha/beta tester's forum for ZeosLib 7.0.x series

Report problems concerning our Delphi 2009+ version and new Zeoslib 7.0 features here.

This is a forum that will be removed once the 7.X version goes into stable!!

Moderators: gto, EgonHugeist, olehs

cmatrix
Junior Boarder
Junior Boarder
Posts: 29
Joined: 20.10.2005, 21:43
Contact:

Zeos hangs on Connect attempt to non-existent MySQL DB

Postby cmatrix » 30.11.2012, 17:46

If a Zeos app tries to connect to a non-existent MySQL DB it will hang indefinitely. This does not happen with ADO/MS SQL.

Adding a Timeout to the connection properties does nothing.

Looking through the previous posts this is a known issue. Anyone find a workaround?

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 01.12.2012, 01:26

cmatrix,

a good hint. But this is implemented by MySQL and here Zeos can't handle that AFAIK.

http://stackoverflow.com/questions/2436 ... n-in-mysql

execute 'SHOW VARIABLES LIKE 'wait_timeout';'. The defaults are 28800 secs. So if you would be more patiance.. 8hours then...((((:

Follow these instructions. Or do i musunderstand your question?
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

cmatrix
Junior Boarder
Junior Boarder
Posts: 29
Joined: 20.10.2005, 21:43
Contact:

Postby cmatrix » 01.12.2012, 03:44

EgonHugeist wrote:cmatrix,

a good hint. But this is implemented by MySQL and here Zeos can't handle that AFAIK.

http://stackoverflow.com/questions/2436 ... n-in-mysql

execute 'SHOW VARIABLES LIKE 'wait_timeout';'. The defaults are 28800 secs. So if you would be more patiance.. 8hours then...((((:

Follow these instructions. Or do i musunderstand your question?


No, that is good. Thank you.

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 01.12.2012, 23:55

cmatrix,

it would be nice if you can confirm my suggestion eventually? I couldn't test it by my selves..
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 03.01.2013, 14:28

I wonder if previous proposals did work.
Without having tried it mysqlf I would guess http://dev.mysql.com/doc/refman/5.5/en/ ... tions.html will be of more use. Because I think it's not a server side problem. It's the connection library that's waiting too long before concluding it doesn't succeed in making the connection.
Does adding 'MYSQL_OPT_CONNECT_TIMEOUT=5' to the connection properties help?

Mark
Image


Return to “ZeosLib 7.0 Beta Forum”

Who is online

Users browsing this forum: Bing [Bot] and 1 guest