pcsoft.us.windevCopyright 2026, PC SOFT24 Jul 2018 22:34:17 Z15 Apr 2016 21:17:00 ZFinally I was able to manage my own timeout in failing HOpenConnection on MySql (Native Access) with a trick and threads. And what if the connection to Mysql service fails during the normal working session, after a successful connection opening? Is there a way to prevent the 20 second standard waiting and having the program in idle for all this time after a query? In practice, for giving a real sample, I estabilish the connection with a common hopenconnection running fine. Then I run a simple query just after removing the internet cable (stopping mysql service has the same effect). Now the program hangs (window not responding) for 20 seconds before getting the error message "lost connection, error 79". A HExecuteQuery in this condition is locking. Obviously checking the connection before each query is not an option. I want to trap and manage quickly the exception. Thank you.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)BigEDpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-66349/read.awp24 Jul 2018 22:34:17 ZThis code does not work: [code:wl] c1, c2 is connection ds1, ds2 is data source HOpenConnection(C1) SQLTransaction(sqlS…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-66349/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-66349/read.awpTimeout on failed MySql queries if you lose connectionBigEDpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-66337/read.awp24 Jul 2018 16:38:26 ZYes off course, but thats nothing to do with the issue. In MySQL Native Acces all timeout parameters is ignored, so you must se…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-66337/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-66337/read.awpTimeout on failed MySql queries if you lose connectionpa_oliveirapcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-66329/read.awp24 Jul 2018 13:09:12 Zdid you try using the WD Connection Timeout and WD Command Timeout in the ExtendedInfo of the Connection . https://doc.windev.c…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-66329/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-66329/read.awpTimeout on failed MySql queries if you lose connectionBigEDpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-66328/read.awp24 Jul 2018 12:10:59 ZDid you ever find solution for that probem? Best regards!https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-66328/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-66328/read.awpTimeout on failed MySql queries if you lose connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57333/read.awp17 Apr 2016 23:14:00 ZI give up, it's no use. H functions on mysql NA hang the application until they return a result. If the mysql service goes down…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57333/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57333/read.awpTimeout on failed MySql queries if you lose connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57325/read.awp16 Apr 2016 17:07:00 ZRollback... Not solved. Inspecting MySql log i saw that each HChangeConnection("*", ConnectionName) will close the current …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57325/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57325/read.awpTimeout on failed MySql queries if you lose connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57324/read.awp16 Apr 2016 16:50:00 ZSOLVED!! HChangeConnection("*", ConnectionName) before each hanging query. I don't know why and how but this make sudden fai…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57324/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57324/read.awpTimeout on failed MySql queries if you lose connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57323/read.awp16 Apr 2016 10:24:00 ZWhen opening the connection I run the hopenconnection in a secondary thread and check its status in the main thread. Example: u…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57323/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57323/read.awpTimeout on failed MySql queries if you lose connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57321/read.awp16 Apr 2016 08:58:00 ZHi Stefano, Can you explain how you managed your timeout? And do you manage the connection error? Reconnecting instead of cr…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57321/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57321/read.awpTimeout on failed MySql queries if you lose connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57320/read.awp16 Apr 2016 08:06:00 ZI agree but it's a pos software. Having a cashier locked on sunday with a 20 people queue and the app freezed before switching …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57320/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57320/read.awpTimeout on failed MySql queries if you lose connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57319/read.awp16 Apr 2016 07:54:00 ZHi, shortening the time out time may not be good idea . specially on - Big Database the server may take long time to proce…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57319/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57317-timeout-failed-mysql-queries-you-lose-connection-57319/read.awpTimeout on failed MySql queries if you lose connection