<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"><channel><category>pcsoft.us.windev</category><copyright>Copyright 2026, PC SOFT</copyright><lastBuildDate>24 Apr 2018 06:50:00 Z</lastBuildDate><pubDate>15 Apr 2018 13:05:00 Z</pubDate><description>Hi All&#13;
&#13;
I eventually found out why the timer procedure is bombing out. After not writing to MyTable for a length of time, in other words, it is idle on the MySQL side so I suspect the channel is being closed, I get the error below:&#13;
&#13;
//native MySQL access error.&#13;
&#13;
//Unable to open or read &lt;MyTable&gt; file.&#13;
&#13;
//Error Number = 22&#13;
&#13;
//The following error was returned by the &lt;123.123.123.123&gt; database:&#13;
&#13;
//Error number = &lt;2006&gt;.&#13;
&#13;
//Error message:&#13;
&#13;
//MySQL server has gone away - Failed To Reset MyTable&#13;
&#13;
This happens on an HReset(MyTable)&#13;
&#13;
I am confused as HOpenConnection returns true. I am going to try and open the connection in this procedure if any writing is to be done or ignore it. And close it when leaving the procedure if it was opened.&#13;
&#13;
Any other ideas?&#13;
&#13;
Cheers&#13;
André</description><ttl>30</ttl><generator>WEBDEV</generator><language>en_US</language><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65229-mysql-server-has-gone-away/read.awp</link><title>MySQL Server Has Gone Away</title><managingEditor>moderateur@pcsoft.fr (El moderador)</managingEditor><webMaster>webmaster@pcsoft.fr (El webmaster)</webMaster><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65229-mysql-server-has-gone-away-65299/read.awp</comments><pubDate>24 Apr 2018 06:50:00 Z</pubDate><description>Hi Stefano&#13;
&#13;
Nice solution. Thanks.&#13;
&#13;
Cheers&#13;
André</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65229-mysql-server-has-gone-away-65299/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65229-mysql-server-has-gone-away-65299/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65229-mysql-server-has-gone-away/read.awp">MySQL Server Has Gone Away</source><title>Re: MySQL Server Has Gone Away</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65229-mysql-server-has-gone-away-65236/read.awp</comments><pubDate>15 Apr 2018 23:07:00 Z</pubDate><description>We experienced the same issue.&#13;
&#13;
Our solution is 1 hopenconnection when starting the application and no hcloseconnection.&#13;
We k…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65229-mysql-server-has-gone-away-65236/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65229-mysql-server-has-gone-away-65236/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65229-mysql-server-has-gone-away/read.awp">MySQL Server Has Gone Away</source><title>Re: MySQL Server Has Gone Away</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65229-mysql-server-has-gone-away-65232/read.awp</comments><pubDate>15 Apr 2018 16:09:00 Z</pubDate><description>Hi All&#13;
&#13;
Update so far.&#13;
&#13;
It appears that the target Db was disconnecting and WX was not connecting again when the next bunch …</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65229-mysql-server-has-gone-away-65232/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65229-mysql-server-has-gone-away-65232/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65229-mysql-server-has-gone-away/read.awp">MySQL Server Has Gone Away</source><title>Re: MySQL Server Has Gone Away</title></item></channel></rss>
