[Evocator]

I lost connection to my mysql database - but sadly the code did not do its job. I think this is the bug that you tried to fix in R39-3? or am i doing it wrong?

Код:

public OnQueryError(errorid, error[], callback[], query[], connectionHandle)
{
	switch (errorid)
	{
		case CR_SERVER_GONE_ERROR:
		{
			printf(">>>>>>>>>>>>>>>>>>>> Lost connection to MYSQL, trying reconnect...");
			mysql_reconnect(connectionHandle);

			if (mysql_errno() != 0)
   			{
   				printf("Locking, no connection to database");
				// lock the server with a pass
			}
			else
			{
				printf("unlocked, we are connected again!");
				// unlock it
			}
		}
		default:
		{
			printf("[ERROR MYSQL]: errorid(%i) error(%s), callback(%s), query(%s), Handle(%i)", errorid, error, callback, query, connectionHandle);
		}
	}
	return 1;
}

LOG:

Код:

[14:08:37] [ERROR MYSQL]: errorid(2003) error(Can't connect to MySQL server on 'x.x.x.x' (111)), callback(), query(-), Handle(1)
[14:08:37] [ERROR MYSQL]: errorid(2003) error(Can't connect to MySQL server on 'x.x.x.x' (111)), callback(), query(-), Handle(1)
[14:08:37] [ERROR MYSQL]: errorid(2003) error(Can't connect to MySQL server on 'x.x.x.x' (111)), callback(), query(-), Handle(1)
[14:08:38] [ERROR MYSQL]: errorid(2003) error(Can't connect to MySQL server on 'x.x.x.x' (111)), callback(), query(-), Handle(1)
[14:08:38] [ERROR MYSQL]: errorid(2003) error(Can't connect to MySQL server on 'x.x.x.x' (111)), callback(), query(-), Handle(1)
[14:08:38] [part] jakulut has left the server (20:0)
[14:08:39] [ERROR MYSQL]: errorid(2003) error(Can't connect to MySQL server on 'x.x.x.x' (111)), callback(), query(-), Handle(1)

Mysql File:

Код:

[14:08:37] [ERROR] CMySQLQuery::Execute[] - (error #2003) Can't connect to MySQL server on 'x.x.x.x' (111)
[14:08:37] [ERROR] CMySQLQuery::Execute[] - (error #2003) Can't connect to MySQL server on 'x.x.x.x' (111)
[14:08:38] [ERROR] CMySQLQuery::Execute[] - (error #2003) Can't connect to MySQL server on 'x.x.x.x' (111)
[14:08:38] [ERROR] CMySQLQuery::Execute[] - (error #2003) Can't connect to MySQL server on 'x.x.x.x' (111)
[14:08:39] [ERROR] CMySQLQuery::Execute[] - (error #2003) Can't connect to MySQL server on 'x.x.x.x' (111)
[18:23:53] [ERROR] CMySQLQuery::Execute[] - (error #1317) Query execution was interrupted
[18:23:53] [ERROR] CMySQLQuery::Execute[] - (error #2003) Can't connect to MySQL server on 'x.x.x.x' (111)
[18:23:53] [ERROR] CMySQLQuery::Execute[] - (error #2003) Can't connect to MySQL server on 'x.x.x.x' (111)
[18:23:55] [ERROR] CMySQLQuery::Execute[] - (error #2003) Can't connect to MySQL server on 'x.x.x.x' (111)
[18:23:56] [ERROR] CMySQLQuery::Execute[] - (error #2003) Can't connect to MySQL server on 'x.x.x.x' (111)