kalmanolah/OKB3 — Issue #4: Huge Memory leak!
Author: Kostronor
Created: 2012-01-17 15:46:11+00:00
State: open

Issuing a new useless query every 30 Seconds, since the issu is in a synchronous thread, a delay in it causes the whole server to lagg!
Proof:

With the code:
[millisecondsdifference]Action
2012-01-17 16:40:42 [INFO] Done (5.064s)!
2012-01-17 16:40:57 [INFO] [0]Issued query
2012-01-17 16:40:57 [INFO] [0]Issued connection
2012-01-17 16:40:57 [INFO] [137]Connection done
2012-01-17 16:40:57 [INFO] [14]First Statement done
2012-01-17 16:40:57 [INFO] [14]Second Statement done
2012-01-17 16:41:27 [INFO] [0]Issued query
2012-01-17 16:41:27 [INFO] [0]Issued connection
2012-01-17 16:41:28 [INFO] [137]Connection done
2012-01-17 16:41:28 [INFO] [13]First Statement done
2012-01-17 16:41:28 [INFO] [12]Second Statement done
2012-01-17 16:41:57 [INFO] [0]Issued query
2012-01-17 16:41:57 [INFO] [0]Issued connection
2012-01-17 16:41:57 [INFO] [134]Connection done
2012-01-17 16:41:57 [INFO] [13]First Statement done
2012-01-17 16:41:57 [INFO] [14]Second Statement done
2012-01-17 16:42:04 [INFO] Kostronor logged in with entity id 401 at
2012-01-17 16:42:04 [INFO] [31m[Admin][37m Kostronor[33m has joined the game.[0m
2012-01-17 16:42:04 [INFO] [0]Issued query
2012-01-17 16:42:04 [INFO] [0]Issued connection
2012-01-17 16:42:05 [INFO] [145]Connection done
2012-01-17 16:42:05 [INFO] [15]First Statement done
2012-01-17 16:42:05 [INFO] [16]Second Statement done
2012-01-17 16:42:05 [INFO] [OKB3] [SYNC] Kostronor's ranks successfully updated.
2012-01-17 16:42:27 [INFO] [0]Issued query
2012-01-17 16:42:27 [INFO] [0]Issued connection
2012-01-17 16:42:27 [INFO] [134]Connection done
2012-01-17 16:42:27 [INFO] [13]First Statement done
2012-01-17 16:42:27 [INFO] [13]Second Statement done
2012-01-17 16:42:57 [INFO] [0]Issued query
2012-01-17 16:42:57 [INFO] [1]Issued connection
2012-01-17 16:42:57 [INFO] [137]Connection done
2012-01-17 16:42:57 [INFO] [13]First Statement done
2012-01-17 16:42:57 [INFO] [13]Second Statement done
2012-01-17 16:43:27 [INFO] [0]Issued query
2012-01-17 16:43:27 [INFO] [0]Issued connection
2012-01-17 16:43:27 [INFO] [132]Connection done
2012-01-17 16:43:27 [INFO] [15]First Statement done
2012-01-17 16:43:27 [INFO] [13]Second Statement done
2012-01-17 16:43:47 [INFO] Connection reset
2012-01-17 16:43:47 [INFO] Kostronor lost connection: disconnect.quitting
2012-01-17 16:43:48 [INFO] [31m[Admin][37m Kostronor[33m has left the game.[0m
2012-01-17 16:43:57 [INFO] [0]Issued query
2012-01-17 16:43:57 [INFO] [0]Issued connection
2012-01-17 16:43:57 [INFO] [131]Connection done
2012-01-17 16:43:57 [INFO] [13]First Statement done
2012-01-17 16:43:57 [INFO] [14]Second Statement done

Without:
2012-01-17 16:44:54 [INFO] Done (5.142s)!
2012-01-17 16:45:08 [INFO] Kostronorogged in with entity id 409 at (
2012-01-17 16:45:09 [INFO] [31m[Admin][37m Kostronor[33m has joined the game.[0m
2012-01-17 16:45:09 [INFO] [0]Issued query
2012-01-17 16:45:09 [INFO] [0]Issued connection
2012-01-17 16:45:09 [INFO] [154]Connection done
2012-01-17 16:45:09 [INFO] [15]First Statement done
2012-01-17 16:45:09 [INFO] [15]Second Statement done
2012-01-17 16:45:09 [INFO] [OKB3] [SYNC] Kostronor's ranks successfully updated.