[foon]

Im wondering, when you make a connection to a database and you lose connection to it, will it auto-reconnect on the next map start, or do I have to connect again?

Example, do I have to do this or can I get rid of the "OnMapStart()"?

Database g_hDatabase = null;

public void OnPluginStart()
{
	Database.Connect(SQL_Connection, "db");
}

public void OnMapStart()
{
	if (g_hDatabase == null)
	{
		Database.Connect(SQL_Connection, "db");
	}
}


public void SQL_Connection(Database hDatabase, const char[] sError, int iData)
{
	if (hDatabase == null)
	{
		ThrowError(sError);
	}
	else
	{
		g_hDatabase = hDatabase;
		
		PrintToServer("[SQL] Connected to DB.");
		return;
	}
}

[Balimbanana]

I usually check it on the query to INSERT or UPDATE callback for the sError or INVALID_HANDLE.

public void SQL_QueryCB(Database hDatabase, const char[] sError, int iData)
{
	if ((StrContains(sError, "lost connection", false) != -1) || (StrContains(sError, "unknown mysql server host", false) != -1) || (StrContains(sError, "Can't connect to", false) != -1) || (hndl == INVALID_HANDLE))
	{
		PrintToServer("[SQL] retry connection: %s",sError);
		Database.Connect(SQL_Connection, "db");
		return;
	}
	//Anything else to run for a successful query
	return;
}

You may also want to have a maximum attempts to connect and possibly a failover to sourcemod-local database with a retry after some amount of time so it doesn't loop forever if the database is down.

[Dragokas]

I do it on OnConfigsExecuted(), but it never helped me to reconnect (even after 1 min.), dunno why.

https://forums.alliedmods.net/showthread.php?t=320326

[Bacardi]

Shouldn't sql connections work temporary ? Not leave connection open whole time ?

You open connection, do your stuff, close connection.

[zipcore]

I don't see any reason why zou should close such connections just to reopen them later when they are using within a plugin which isn't sending a single query once. It only consumes a bit more memory on you database server which is only a problem when you don't have enough RAM on there. It isn't even unsecure to leave those connections alive.

But I don't see the point of reconnecting to a database on errors or losing the handle. I can't remember a single incidence where this would have helped. Useally you lose connection when a query fails and it needs to be fixed then anyways.