[Fearts]

For some reason seemingly on all my servers at once (or at least multiple servers at once) my client cookies and databases for all my plugins get disconnected. Here are a few examples of errors:

L 04/21/2020 - 22:37:28: [SM] Exception reported: Invalid database Handle 0 (error: 4)
L 04/21/2020 - 22:37:28: [SM] Blaming: sourcebans.smx
L 04/21/2020 - 22:37:28: [SM] Call stack trace:
L 04/21/2020 - 22:37:28: [SM]   [0] SQL_TQuery
L 04/21/2020 - 22:37:28: [SM]   [1] Line 568, sourcebans.sp::sbTConnect

L 04/22/2020 - 00:25:56: [SM] Exception reported: Invalid database Handle 0 (error: 4)
L 04/22/2020 - 00:25:56: [SM] Blaming: sourcecomms.smx
L 04/22/2020 - 00:25:56: [SM] Call stack trace:
L 04/22/2020 - 00:25:56: [SM]   [0] SQL_TQuery
L 04/22/2020 - 00:25:56: [SM]   [1] Line 1213, sourcecomms.sp::sbTConnect


L 04/22/2020 - 00:25:35: [SM] Exception reported: Invalid database Handle 0 (error: 4)
L 04/22/2020 - 00:25:35: [SM] Blaming: sakurautils2.smx
L 04/22/2020 - 00:25:35: [SM] Call stack trace:
L 04/22/2020 - 00:25:35: [SM]   [0] SQL_TQuery
L 04/22/2020 - 00:25:35: [SM]   [1] Line 280, sakurautils2.sp::tc_connectCheck


L 04/21/2020 - 22:38:02: [SM] Exception reported: Client 3 cookies are not cached yet!
L 04/21/2020 - 22:38:02: [SM] Blaming: zetachatmanager.smx
L 04/21/2020 - 22:38:02: [SM] Call stack trace:
L 04/21/2020 - 22:38:02: [SM]   [0] ThrowNativeError
L 04/21/2020 - 22:38:02: [SM]   [1] Line 684, ZetaChatManager.sp::Native_SetDefault
L 04/21/2020 - 22:38:02: [SM]   [3] Zeta_SetDefault
L 04/21/2020 - 22:38:02: [SM]   [4] Line 194, tf2_trade3.sp::ZetaTrySettingDefault
L 04/21/2020 - 22:38:02: [SM]   [5] Line 168, tf2_trade3.sp::RetrievedPremiums

My Sourcebans stops connectings and all my admins lose their admin flags unless I reload admins. Everyone's user settings and cookies get reset to default for the duration of the glitch. Seems to happen to all my plugins that use a database or cookies all at once. Also, it's on and off like it will break for a few minutes then work then break again.

Resetting the server doesn't seem to fix anything while this is going on. I haven't made any major changes to my servers and this issue seems to come up sporadically sometimes with many months inbetween glitches.

Has anyone else seen a issue like this before or have any advice that might help me? I'm on Windows OS and MetaMod:Source v1.10.6-devV, Stripper v1.2.2, SourceMod v1.9.0.6226.

[8guawong]

Originally Posted by Fearts For some reason seemingly on all my servers at once (or at least multiple servers at once) my client cookies and databases for all my plugins get disconnected. Here are a few examples of errors: L 04/21/2020 - 22:37:28: [SM] Exception reported: Invalid database Handle 0 (error: 4) L 04/21/2020 - 22:37:28: [SM] Blaming: sourcebans.smx L 04/21/2020 - 22:37:28: [SM] Call stack trace: L 04/21/2020 - 22:37:28: [SM] [0] SQL_TQuery L 04/21/2020 - 22:37:28: [SM] [1] Line 568, sourcebans.sp::sbTConnect L 04/22/2020 - 00:25:56: [SM] Exception reported: Invalid database Handle 0 (error: 4) L 04/22/2020 - 00:25:56: [SM] Blaming: sourcecomms.smx L 04/22/2020 - 00:25:56: [SM] Call stack trace: L 04/22/2020 - 00:25:56: [SM] [0] SQL_TQuery L 04/22/2020 - 00:25:56: [SM] [1] Line 1213, sourcecomms.sp::sbTConnect L 04/22/2020 - 00:25:35: [SM] Exception reported: Invalid database Handle 0 (error: 4) L 04/22/2020 - 00:25:35: [SM] Blaming: sakurautils2.smx L 04/22/2020 - 00:25:35: [SM] Call stack trace: L 04/22/2020 - 00:25:35: [SM] [0] SQL_TQuery L 04/22/2020 - 00:25:35: [SM] [1] Line 280, sakurautils2.sp::tc_connectCheck L 04/21/2020 - 22:38:02: [SM] Exception reported: Client 3 cookies are not cached yet! L 04/21/2020 - 22:38:02: [SM] Blaming: zetachatmanager.smx L 04/21/2020 - 22:38:02: [SM] Call stack trace: L 04/21/2020 - 22:38:02: [SM] [0] ThrowNativeError L 04/21/2020 - 22:38:02: [SM] [1] Line 684, ZetaChatManager.sp::Native_SetDefault L 04/21/2020 - 22:38:02: [SM] [3] Zeta_SetDefault L 04/21/2020 - 22:38:02: [SM] [4] Line 194, tf2_trade3.sp::ZetaTrySettingDefault L 04/21/2020 - 22:38:02: [SM] [5] Line 168, tf2_trade3.sp::RetrievedPremiums My Sourcebans stops connectings and all my admins lose their admin flags unless I reload admins. Everyone's user settings and cookies get reset to default for the duration of the glitch. Seems to happen to all my plugins that use a database or cookies all at once. Also, it's on and off like it will break for a few minutes then work then break again. Resetting the server doesn't seem to fix anything while this is going on. I haven't made any major changes to my servers and this issue seems to come up sporadically sometimes with many months inbetween glitches. Has anyone else seen a issue like this before or have any advice that might help me? I'm on Windows OS and MetaMod:Source v1.10.6-devV, Stripper v1.2.2, SourceMod v1.9.0.6226.

your server probably lost connection to the mysql server
not sure about cookies though...

[Fearts]

Yea I get that but I think it's more than just a connection issue to the MYSQL server since cookies/clientprefs stop working properly at the same time. It's more like the sourcemods database function stopped working and connecting to any databases external or local.

[8guawong]

Originally Posted by Fearts Yea I get that but I think it's more than just a connection issue to the MYSQL server since cookies/clientprefs stop working properly at the same time. It's more like the sourcemods database function stopped working and connecting to any databases external or local.

well thats why i said i'm not sure about cookies since those are local database