search

ssypchenko / cs2-gungame

GunGame mode on Counter Strike Sharp
MIT License
23 stars 4 forks source link

[BUG] [v1.0.9] Server 30 second hang on player connect (v1.0.8 works fine) #11

Closed kus closed 7 months ago

kus commented 7 months ago

Hi,

With v1.0.9 there is a weird issue where when you connect your game hangs for about 30 seconds before you are able to choose your team and the screen looks like this:

cs2-gungame-hang

It happens each time you connect, even if you disconnect after choosing team and reconnect.

Metamod:Source 2.0.0-1284
CounterStrikeSharp 204

Downgrading to v1.0.8 gets rid of the issue.

As you must have changed to database schema I had to delete my old SQLite db to get the server to work first. It would be really nice if you could update the database so we don't have to delete our databases every time you make a schema change #8.

I've captured the server log for you of what happens when the client hangs:

Client #1 "Kus" connected @ X.X.X.X:58439
ClientPutInServer create new player controller [Kus]
Client 1 'Kus' setting rate to 786432
Client 1 'Kus' signon state SIGNONSTATE_CONNECTED -> SIGNONSTATE_NEW
Client 1 'Kus' signon state SIGNONSTATE_NEW -> SIGNONSTATE_PRESPAWN
Client 1 'Kus' signon state SIGNONSTATE_PRESPAWN -> SIGNONSTATE_SPAWN
SV:  "Kus<1><[U:1:112100]><>" STEAM USERID validated
[#2187683733 UDP steamid:76561197960377828@X.X.X.X:58439 'Kus'] recv queue overflow 1000 messages already queued.
[#2187683733 UDP steamid:76561197960377828@X.X.X.X:58439 'Kus'] recv queue overflow 1000 messages already queued.
[#2187683733 UDP steamid:76561197960377828@X.X.X.X:58439 'Kus'] recv queue overflow 1000 messages already queued.
[#2187683733 UDP steamid:76561197960377828@X.X.X.X:58439 'Kus'] recv queue overflow 1000 messages already queued.
[#2187683733 UDP steamid:76561197960377828@X.X.X.X:58439 'Kus'] recv queue overflow 1000 messages already queued.
[#2187683733 UDP steamid:76561197960377828@X.X.X.X:58439 'Kus'] recv queue overflow 1000 messages already queued.
[#2187683733 UDP steamid:76561197960377828@X.X.X.X:58439 'Kus'] recv queue overflow 1000 messages already queued.
[#2187683733 UDP steamid:76561197960377828@X.X.X.X:58439 'Kus'] recv queue overflow 1000 messages already queued.
[#2187683733 UDP steamid:76561197960377828@X.X.X.X:58439 'Kus'] recv queue overflow 1000 messages already queued.
[#2187683733 UDP steamid:76561197960377828@X.X.X.X:58439 'Kus'] recv queue overflow 1000 messages already queued.
[#2187683733 UDP steamid:76561197960377828@X.X.X.X:58439 'Kus'] recv queue overflow 1000 messages already queued.
[#2187683733 UDP steamid:76561197960377828@X.X.X.X:58439 'Kus'] recv queue overflow 1000 messages already queued.
[#2187683733 UDP steamid:76561197960377828@X.X.X.X:58439 'Kus'] recv queue overflow 1000 messages already queued.
[#2187683733 UDP steamid:76561197960377828@X.X.X.X:58439 'Kus'] recv queue overflow 1000 messages already queued.
07:58:00 [INFO] (plugin:CS2_GunGame) [GunGame_Stats - FATAL] GetPlayerWins(2): An error occurred: SQLite Error 5: 'database is locked'.
07:58:00 [INFO] (plugin:CS2_GunGame) Set au language for Kus
07:58:00 [INFO] (plugin:CS2_GunGame) [GunGame_Stats] Kus wins 0, sound 1

When this message shows 07:58:00 [INFO] (plugin:CS2_GunGame) [GunGame_Stats - FATAL] GetPlayerWins(2): An error occurred: SQLite Error 5: 'database is locked'. everything goes back to normal. So potentially on player connect you are doing a database operation which hangs until an error is thrown which is locking up the server.

ssypchenko commented 7 months ago

Yes, it is an error with the SQLite database, I'm sorry. If you can use MySQL, it will work correctly. I'll try to fix SQLite as soon as possible.

ssypchenko commented 7 months ago

SQLite database fixed.