java.sql.SQLException: Cannot get a connection, pool error: Pool exhausted

Post here your questions about SFS2X. Here we discuss all server-side matters. For client API questions see the dedicated forums.

Moderators: Lapo, Bax

TwineApps
Posts: 80
Joined: 10 Nov 2016, 18:39

java.sql.SQLException: Cannot get a connection, pool error: Pool exhausted

Postby TwineApps » 30 Apr 2017, 11:34

Hi,

Code: Select all

30 apr 2017 | 13:04:44,961 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | STATE: WAIT_NEW_PACKET
30 apr 2017 | 13:04:44,961 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | NORMAL SIZED PACKET: 134
30 apr 2017 | 13:04:44,962 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | <<< PACKET COMPLETE >>>
30 apr 2017 | 13:04:44,962 | DEBUG | SFSWorker:Sys:2 | v2.protocol.SFSProtocolCodec |     |
   (sfs_object) p:
      (sfs_object) p:
         (int) minUsers: 1
         (int) maxUsers: 50
         (int) user_trophy: 99999
         (utf_string) location:
         (utf_string) text:
         (int) minTrophy: 0
         
      
      (int) r: 3
      (utf_string) c: findclan
      
   
   (short) a: 13
   (byte) c: 1
   

30 apr 2017 | 13:04:44,963 | DEBUG | SFSWorker:Ext:2 | controllers.v290.ExtensionReqController |     | [Req Type: (Tcp), Sender: { Id: 1, Type: DEFAULT, Logged: Yes, IP: 127.0.0.1:62657 }]
30 apr 2017 | 13:04:44,964 | DEBUG | SFSWorker:Ext:2 | controllers.v290.ExtensionReqController |     |
   (sfs_object) p:
      (int) minUsers: 1
      (int) maxUsers: 50
      (int) user_trophy: 99999
      (utf_string) location:
      (utf_string) text:
      (int) minTrophy: 0
      
   
   (int) r: 3
   (utf_string) c: findclan
   

30 apr 2017 | 13:04:44,964 | INFO  | SFSWorker:Ext:2 | Extensions |     | {Server}: Sto chiedendo al server di trovare un clan con i miei parametri
30 apr 2017 | 13:04:44,964 | INFO  | SFSWorker:Ext:2 | Extensions |     | {Server}: Ho fatto l'accesso per richiedere al server la mia query
30 apr 2017 | 13:04:44,964 | INFO  | SFSWorker:Ext:2 | Extensions |     | {Server}: query con boolean = true
30 apr 2017 | 13:04:44,966 | DEBUG | SFSWorker:Ext:2 | v2.db.SFSDBManager |     | Execute Query SQL: com.mysql.jdbc.JDBC42PreparedStatement@67ef3d2c: SELECT * FROM guesswho.Clan where clan_name Like '%%' and position Like '%%' and maxUsers <= 50 and minUsers >= 1 and min_trofei >= 0 and min_trofei <= 99999  and (tipo = 'Public' or tipo = 'Invito') order by trofei_total desc, clan_name
30 apr 2017 | 13:04:44,968 | DEBUG | SFSWorker:Ext:2 | v2.protocol.SFSProtocolCodec |     | {OUT}: CallExtension
30 apr 2017 | 13:04:44,969 | DEBUG | SFSWorker:Ext:2 | protocol.binary.BinaryIoHandler |     | Binary size: 251
12 00 03 00 01 70 12 00 03 00 01 70 12 00 01 00    .....p.....p....
07 73 75 63 63 65 73 73 11 00 01 12 00 0A 00 09    .success........
63 6C 61 6E 5F 6E 61 6D 65 08 00 09 43 6C 61 6E    clan_name...Clan
50 72 6F 76 61 00 08 6D 61 78 55 73 65 72 73 04    Prova..maxUsers.
00 00 00 14 00 08 6D 69 6E 55 73 65 72 73 04 00    ......minUsers..
00 00 01 00 06 73 74 65 6D 6D 61 04 00 00 00 00    .....stemma.....
00 0B 64 65 73 63 72 69 7A 69 6F 6E 65 08 00 0B    ..descrizione...
49 6C 20 6D 69 6F 20 63 6C 61 6E 00 0A 6D 69 6E    Il.mio.clan..min
5F 74 72 6F 66 65 69 04 00 00 00 00 00 04 74 69    _trofei.......ti
70 6F 08 00 06 50 75 62 6C 69 63 00 07 69 64 5F    po...Public..id_
63 6C 61 6E 04 00 00 00 29 00 08 70 6F 73 69 74    clan....)..posit
69 6F 6E 08 00 0D 49 6E 74 65 72 6E 61 74 69 6F    ion...Internatio
6E 61 6C 00 10 75 74 65 6E 74 65 5F 66 6F 6E 64    nal..utente_fond
61 74 6F 72 65 04 00 00 00 1C 00 01 72 04 00 00    atore.......r...
00 03 00 01 63 08 00 08 66 69 6E 64 63 6C 61 6E    ....c...findclan
00 01 61 03 00 0D 00 01 63 02 01                   ..a.....c..     

30 apr 2017 | 13:04:44,970 | DEBUG | SFSWorker:Ext:2 | controllers.v290.ExtensionReqController |     | Extension call executed in: 7.745739
30 apr 2017 | 13:04:45,143 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | Binary size: 137
80 00 86 12 00 03 00 01 63 02 01 00 01 61 03 00    ........c....a..
0D 00 01 70 12 00 03 00 01 63 08 00 08 66 69 6E    ...p.....c...fin
64 63 6C 61 6E 00 01 72 04 00 00 00 03 00 01 70    dclan..r.......p
12 00 06 00 04 74 65 78 74 08 00 00 00 08 6C 6F    .....text.....lo
63 61 74 69 6F 6E 08 00 00 00 08 6D 69 6E 55 73    cation.....minUs
65 72 73 04 00 00 00 01 00 08 6D 61 78 55 73 65    ers.......maxUse
72 73 04 00 00 00 32 00 09 6D 69 6E 54 72 6F 70    rs....2..minTrop
68 79 04 00 00 00 00 00 0B 75 73 65 72 5F 74 72    hy.......user_tr
6F 70 68 79 04 00 01 86 9F                         ophy.....       

30 apr 2017 | 13:04:45,144 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | STATE: WAIT_NEW_PACKET
30 apr 2017 | 13:04:45,144 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | NORMAL SIZED PACKET: 134
30 apr 2017 | 13:04:45,144 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | <<< PACKET COMPLETE >>>
30 apr 2017 | 13:04:45,145 | DEBUG | SFSWorker:Sys:3 | v2.protocol.SFSProtocolCodec |     |
   (sfs_object) p:
      (sfs_object) p:
         (int) minUsers: 1
         (int) maxUsers: 50
         (int) user_trophy: 99999
         (utf_string) location:
         (utf_string) text:
         (int) minTrophy: 0
         
      
      (int) r: 3
      (utf_string) c: findclan
      
   
   (short) a: 13
   (byte) c: 1
   

30 apr 2017 | 13:04:45,146 | DEBUG | SFSWorker:Ext:3 | controllers.v290.ExtensionReqController |     | [Req Type: (Tcp), Sender: { Id: 1, Type: DEFAULT, Logged: Yes, IP: 127.0.0.1:62657 }]
30 apr 2017 | 13:04:45,146 | DEBUG | SFSWorker:Ext:3 | controllers.v290.ExtensionReqController |     |
   (sfs_object) p:
      (int) minUsers: 1
      (int) maxUsers: 50
      (int) user_trophy: 99999
      (utf_string) location:
      (utf_string) text:
      (int) minTrophy: 0
      
   
   (int) r: 3
   (utf_string) c: findclan
   

30 apr 2017 | 13:04:45,147 | INFO  | SFSWorker:Ext:3 | Extensions |     | {Server}: Sto chiedendo al server di trovare un clan con i miei parametri
30 apr 2017 | 13:04:45,147 | INFO  | SFSWorker:Ext:3 | Extensions |     | {Server}: Ho fatto l'accesso per richiedere al server la mia query
30 apr 2017 | 13:04:45,147 | INFO  | SFSWorker:Ext:3 | Extensions |     | {Server}: query con boolean = true
30 apr 2017 | 13:04:45,149 | DEBUG | SFSWorker:Ext:3 | v2.db.SFSDBManager |     | Execute Query SQL: com.mysql.jdbc.JDBC42PreparedStatement@33b967e0: SELECT * FROM guesswho.Clan where clan_name Like '%%' and position Like '%%' and maxUsers <= 50 and minUsers >= 1 and min_trofei >= 0 and min_trofei <= 99999  and (tipo = 'Public' or tipo = 'Invito') order by trofei_total desc, clan_name
30 apr 2017 | 13:04:45,152 | DEBUG | SFSWorker:Ext:3 | v2.protocol.SFSProtocolCodec |     | {OUT}: CallExtension
30 apr 2017 | 13:04:45,153 | DEBUG | SFSWorker:Ext:3 | protocol.binary.BinaryIoHandler |     | Binary size: 251
12 00 03 00 01 70 12 00 03 00 01 70 12 00 01 00    .....p.....p....
07 73 75 63 63 65 73 73 11 00 01 12 00 0A 00 09    .success........
63 6C 61 6E 5F 6E 61 6D 65 08 00 09 43 6C 61 6E    clan_name...Clan
50 72 6F 76 61 00 08 6D 61 78 55 73 65 72 73 04    Prova..maxUsers.
00 00 00 14 00 08 6D 69 6E 55 73 65 72 73 04 00    ......minUsers..
00 00 01 00 06 73 74 65 6D 6D 61 04 00 00 00 00    .....stemma.....
00 0B 64 65 73 63 72 69 7A 69 6F 6E 65 08 00 0B    ..descrizione...
49 6C 20 6D 69 6F 20 63 6C 61 6E 00 0A 6D 69 6E    Il.mio.clan..min
5F 74 72 6F 66 65 69 04 00 00 00 00 00 04 74 69    _trofei.......ti
70 6F 08 00 06 50 75 62 6C 69 63 00 07 69 64 5F    po...Public..id_
63 6C 61 6E 04 00 00 00 29 00 08 70 6F 73 69 74    clan....)..posit
69 6F 6E 08 00 0D 49 6E 74 65 72 6E 61 74 69 6F    ion...Internatio
6E 61 6C 00 10 75 74 65 6E 74 65 5F 66 6F 6E 64    nal..utente_fond
61 74 6F 72 65 04 00 00 00 1C 00 01 72 04 00 00    atore.......r...
00 03 00 01 63 08 00 08 66 69 6E 64 63 6C 61 6E    ....c...findclan
00 01 61 03 00 0D 00 01 63 02 01                   ..a.....c..     

30 apr 2017 | 13:04:45,155 | DEBUG | SFSWorker:Ext:3 | controllers.v290.ExtensionReqController |     | Extension call executed in: 8.542849
30 apr 2017 | 13:04:45,303 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | Binary size: 137
80 00 86 12 00 03 00 01 63 02 01 00 01 61 03 00    ........c....a..
0D 00 01 70 12 00 03 00 01 63 08 00 08 66 69 6E    ...p.....c...fin
64 63 6C 61 6E 00 01 72 04 00 00 00 03 00 01 70    dclan..r.......p
12 00 06 00 04 74 65 78 74 08 00 00 00 08 6C 6F    .....text.....lo
63 61 74 69 6F 6E 08 00 00 00 08 6D 69 6E 55 73    cation.....minUs
65 72 73 04 00 00 00 01 00 08 6D 61 78 55 73 65    ers.......maxUse
72 73 04 00 00 00 32 00 09 6D 69 6E 54 72 6F 70    rs....2..minTrop
68 79 04 00 00 00 00 00 0B 75 73 65 72 5F 74 72    hy.......user_tr
6F 70 68 79 04 00 01 86 9F                         ophy.....       

30 apr 2017 | 13:04:45,304 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | STATE: WAIT_NEW_PACKET
30 apr 2017 | 13:04:45,304 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | NORMAL SIZED PACKET: 134
30 apr 2017 | 13:04:45,305 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | <<< PACKET COMPLETE >>>
30 apr 2017 | 13:04:45,305 | DEBUG | SFSWorker:Sys:4 | v2.protocol.SFSProtocolCodec |     |
   (sfs_object) p:
      (sfs_object) p:
         (int) minUsers: 1
         (int) maxUsers: 50
         (int) user_trophy: 99999
         (utf_string) location:
         (utf_string) text:
         (int) minTrophy: 0
         
      
      (int) r: 3
      (utf_string) c: findclan
      
   
   (short) a: 13
   (byte) c: 1
   

30 apr 2017 | 13:04:45,307 | DEBUG | SFSWorker:Ext:4 | controllers.v290.ExtensionReqController |     | [Req Type: (Tcp), Sender: { Id: 1, Type: DEFAULT, Logged: Yes, IP: 127.0.0.1:62657 }]
30 apr 2017 | 13:04:45,308 | DEBUG | SFSWorker:Ext:4 | controllers.v290.ExtensionReqController |     |
   (sfs_object) p:
      (int) minUsers: 1
      (int) maxUsers: 50
      (int) user_trophy: 99999
      (utf_string) location:
      (utf_string) text:
      (int) minTrophy: 0
      
   
   (int) r: 3
   (utf_string) c: findclan
   

30 apr 2017 | 13:04:45,309 | INFO  | SFSWorker:Ext:4 | Extensions |     | {Server}: Sto chiedendo al server di trovare un clan con i miei parametri
30 apr 2017 | 13:04:45,310 | INFO  | SFSWorker:Ext:4 | Extensions |     | {Server}: Ho fatto l'accesso per richiedere al server la mia query
30 apr 2017 | 13:04:45,310 | INFO  | SFSWorker:Ext:4 | Extensions |     | {Server}: query con boolean = true
30 apr 2017 | 13:04:45,312 | DEBUG | SFSWorker:Ext:4 | v2.db.SFSDBManager |     | Execute Query SQL: com.mysql.jdbc.JDBC42PreparedStatement@16c3b1c8: SELECT * FROM guesswho.Clan where clan_name Like '%%' and position Like '%%' and maxUsers <= 50 and minUsers >= 1 and min_trofei >= 0 and min_trofei <= 99999  and (tipo = 'Public' or tipo = 'Invito') order by trofei_total desc, clan_name
30 apr 2017 | 13:04:45,314 | DEBUG | SFSWorker:Ext:4 | v2.protocol.SFSProtocolCodec |     | {OUT}: CallExtension
30 apr 2017 | 13:04:45,315 | DEBUG | SFSWorker:Ext:4 | protocol.binary.BinaryIoHandler |     | Binary size: 251
12 00 03 00 01 70 12 00 03 00 01 70 12 00 01 00    .....p.....p....
07 73 75 63 63 65 73 73 11 00 01 12 00 0A 00 09    .success........
63 6C 61 6E 5F 6E 61 6D 65 08 00 09 43 6C 61 6E    clan_name...Clan
50 72 6F 76 61 00 08 6D 61 78 55 73 65 72 73 04    Prova..maxUsers.
00 00 00 14 00 08 6D 69 6E 55 73 65 72 73 04 00    ......minUsers..
00 00 01 00 06 73 74 65 6D 6D 61 04 00 00 00 00    .....stemma.....
00 0B 64 65 73 63 72 69 7A 69 6F 6E 65 08 00 0B    ..descrizione...
49 6C 20 6D 69 6F 20 63 6C 61 6E 00 0A 6D 69 6E    Il.mio.clan..min
5F 74 72 6F 66 65 69 04 00 00 00 00 00 04 74 69    _trofei.......ti
70 6F 08 00 06 50 75 62 6C 69 63 00 07 69 64 5F    po...Public..id_
63 6C 61 6E 04 00 00 00 29 00 08 70 6F 73 69 74    clan....)..posit
69 6F 6E 08 00 0D 49 6E 74 65 72 6E 61 74 69 6F    ion...Internatio
6E 61 6C 00 10 75 74 65 6E 74 65 5F 66 6F 6E 64    nal..utente_fond
61 74 6F 72 65 04 00 00 00 1C 00 01 72 04 00 00    atore.......r...
00 03 00 01 63 08 00 08 66 69 6E 64 63 6C 61 6E    ....c...findclan
00 01 61 03 00 0D 00 01 63 02 01                   ..a.....c..     

30 apr 2017 | 13:04:45,317 | DEBUG | SFSWorker:Ext:4 | controllers.v290.ExtensionReqController |     | Extension call executed in: 10.357301
30 apr 2017 | 13:04:45,475 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | Binary size: 137
80 00 86 12 00 03 00 01 63 02 01 00 01 61 03 00    ........c....a..
0D 00 01 70 12 00 03 00 01 63 08 00 08 66 69 6E    ...p.....c...fin
64 63 6C 61 6E 00 01 72 04 00 00 00 03 00 01 70    dclan..r.......p
12 00 06 00 04 74 65 78 74 08 00 00 00 08 6C 6F    .....text.....lo
63 61 74 69 6F 6E 08 00 00 00 08 6D 69 6E 55 73    cation.....minUs
65 72 73 04 00 00 00 01 00 08 6D 61 78 55 73 65    ers.......maxUse
72 73 04 00 00 00 32 00 09 6D 69 6E 54 72 6F 70    rs....2..minTrop
68 79 04 00 00 00 00 00 0B 75 73 65 72 5F 74 72    hy.......user_tr
6F 70 68 79 04 00 01 86 9F                         ophy.....       

30 apr 2017 | 13:04:45,476 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | STATE: WAIT_NEW_PACKET
30 apr 2017 | 13:04:45,476 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | NORMAL SIZED PACKET: 134
30 apr 2017 | 13:04:45,476 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | <<< PACKET COMPLETE >>>
30 apr 2017 | 13:04:45,477 | DEBUG | SFSWorker:Sys:1 | v2.protocol.SFSProtocolCodec |     |
   (sfs_object) p:
      (sfs_object) p:
         (int) minUsers: 1
         (int) maxUsers: 50
         (int) user_trophy: 99999
         (utf_string) location:
         (utf_string) text:
         (int) minTrophy: 0
         
      
      (int) r: 3
      (utf_string) c: findclan
      
   
   (short) a: 13
   (byte) c: 1
   

30 apr 2017 | 13:04:45,478 | DEBUG | SFSWorker:Ext:1 | controllers.v290.ExtensionReqController |     | [Req Type: (Tcp), Sender: { Id: 1, Type: DEFAULT, Logged: Yes, IP: 127.0.0.1:62657 }]
30 apr 2017 | 13:04:45,478 | DEBUG | SFSWorker:Ext:1 | controllers.v290.ExtensionReqController |     |
   (sfs_object) p:
      (int) minUsers: 1
      (int) maxUsers: 50
      (int) user_trophy: 99999
      (utf_string) location:
      (utf_string) text:
      (int) minTrophy: 0
      
   
   (int) r: 3
   (utf_string) c: findclan
   

30 apr 2017 | 13:04:45,480 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: Sto chiedendo al server di trovare un clan con i miei parametri
30 apr 2017 | 13:04:45,480 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: Ho fatto l'accesso per richiedere al server la mia query
30 apr 2017 | 13:04:45,480 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: query con boolean = true
30 apr 2017 | 13:04:45,482 | DEBUG | SFSWorker:Ext:1 | v2.db.SFSDBManager |     | Execute Query SQL: com.mysql.jdbc.JDBC42PreparedStatement@c424ddf: SELECT * FROM guesswho.Clan where clan_name Like '%%' and position Like '%%' and maxUsers <= 50 and minUsers >= 1 and min_trofei >= 0 and min_trofei <= 99999  and (tipo = 'Public' or tipo = 'Invito') order by trofei_total desc, clan_name
30 apr 2017 | 13:04:45,485 | DEBUG | SFSWorker:Ext:1 | v2.protocol.SFSProtocolCodec |     | {OUT}: CallExtension
30 apr 2017 | 13:04:45,485 | DEBUG | SFSWorker:Ext:1 | protocol.binary.BinaryIoHandler |     | Binary size: 251
12 00 03 00 01 70 12 00 03 00 01 70 12 00 01 00    .....p.....p....
07 73 75 63 63 65 73 73 11 00 01 12 00 0A 00 09    .success........
63 6C 61 6E 5F 6E 61 6D 65 08 00 09 43 6C 61 6E    clan_name...Clan
50 72 6F 76 61 00 08 6D 61 78 55 73 65 72 73 04    Prova..maxUsers.
00 00 00 14 00 08 6D 69 6E 55 73 65 72 73 04 00    ......minUsers..
00 00 01 00 06 73 74 65 6D 6D 61 04 00 00 00 00    .....stemma.....
00 0B 64 65 73 63 72 69 7A 69 6F 6E 65 08 00 0B    ..descrizione...
49 6C 20 6D 69 6F 20 63 6C 61 6E 00 0A 6D 69 6E    Il.mio.clan..min
5F 74 72 6F 66 65 69 04 00 00 00 00 00 04 74 69    _trofei.......ti
70 6F 08 00 06 50 75 62 6C 69 63 00 07 69 64 5F    po...Public..id_
63 6C 61 6E 04 00 00 00 29 00 08 70 6F 73 69 74    clan....)..posit
69 6F 6E 08 00 0D 49 6E 74 65 72 6E 61 74 69 6F    ion...Internatio
6E 61 6C 00 10 75 74 65 6E 74 65 5F 66 6F 6E 64    nal..utente_fond
61 74 6F 72 65 04 00 00 00 1C 00 01 72 04 00 00    atore.......r...
00 03 00 01 63 08 00 08 66 69 6E 64 63 6C 61 6E    ....c...findclan
00 01 61 03 00 0D 00 01 63 02 01                   ..a.....c..     

30 apr 2017 | 13:04:45,487 | DEBUG | SFSWorker:Ext:1 | controllers.v290.ExtensionReqController |     | Extension call executed in: 9.015385
30 apr 2017 | 13:04:45,640 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | Binary size: 137
80 00 86 12 00 03 00 01 63 02 01 00 01 61 03 00    ........c....a..
0D 00 01 70 12 00 03 00 01 63 08 00 08 66 69 6E    ...p.....c...fin
64 63 6C 61 6E 00 01 72 04 00 00 00 03 00 01 70    dclan..r.......p
12 00 06 00 04 74 65 78 74 08 00 00 00 08 6C 6F    .....text.....lo
63 61 74 69 6F 6E 08 00 00 00 08 6D 69 6E 55 73    cation.....minUs
65 72 73 04 00 00 00 01 00 08 6D 61 78 55 73 65    ers.......maxUse
72 73 04 00 00 00 32 00 09 6D 69 6E 54 72 6F 70    rs....2..minTrop
68 79 04 00 00 00 00 00 0B 75 73 65 72 5F 74 72    hy.......user_tr
6F 70 68 79 04 00 01 86 9F                         ophy.....       

30 apr 2017 | 13:04:45,641 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | STATE: WAIT_NEW_PACKET
30 apr 2017 | 13:04:45,641 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | NORMAL SIZED PACKET: 134
30 apr 2017 | 13:04:45,641 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | <<< PACKET COMPLETE >>>
30 apr 2017 | 13:04:45,642 | DEBUG | SFSWorker:Sys:2 | v2.protocol.SFSProtocolCodec |     |
   (sfs_object) p:
      (sfs_object) p:
         (int) minUsers: 1
         (int) maxUsers: 50
         (int) user_trophy: 99999
         (utf_string) location:
         (utf_string) text:
         (int) minTrophy: 0
         
      
      (int) r: 3
      (utf_string) c: findclan
      
   
   (short) a: 13
   (byte) c: 1
   

30 apr 2017 | 13:04:45,643 | DEBUG | SFSWorker:Ext:3 | controllers.v290.ExtensionReqController |     | [Req Type: (Tcp), Sender: { Id: 1, Type: DEFAULT, Logged: Yes, IP: 127.0.0.1:62657 }]
30 apr 2017 | 13:04:45,643 | DEBUG | SFSWorker:Ext:3 | controllers.v290.ExtensionReqController |     |
   (sfs_object) p:
      (int) minUsers: 1
      (int) maxUsers: 50
      (int) user_trophy: 99999
      (utf_string) location:
      (utf_string) text:
      (int) minTrophy: 0
      
   
   (int) r: 3
   (utf_string) c: findclan
   

30 apr 2017 | 13:04:45,644 | INFO  | SFSWorker:Ext:3 | Extensions |     | {Server}: Sto chiedendo al server di trovare un clan con i miei parametri
30 apr 2017 | 13:04:45,644 | INFO  | SFSWorker:Ext:3 | Extensions |     | {Server}: Ho fatto l'accesso per richiedere al server la mia query
30 apr 2017 | 13:04:45,645 | INFO  | SFSWorker:Ext:3 | Extensions |     | {Server}: query con boolean = true
30 apr 2017 | 13:04:45,646 | DEBUG | SFSWorker:Ext:3 | v2.db.SFSDBManager |     | Execute Query SQL: com.mysql.jdbc.JDBC42PreparedStatement@2a4fbeea: SELECT * FROM guesswho.Clan where clan_name Like '%%' and position Like '%%' and maxUsers <= 50 and minUsers >= 1 and min_trofei >= 0 and min_trofei <= 99999  and (tipo = 'Public' or tipo = 'Invito') order by trofei_total desc, clan_name
30 apr 2017 | 13:04:45,649 | DEBUG | SFSWorker:Ext:3 | v2.protocol.SFSProtocolCodec |     | {OUT}: CallExtension
30 apr 2017 | 13:04:45,650 | DEBUG | SFSWorker:Ext:3 | protocol.binary.BinaryIoHandler |     | Binary size: 251
12 00 03 00 01 70 12 00 03 00 01 70 12 00 01 00    .....p.....p....
07 73 75 63 63 65 73 73 11 00 01 12 00 0A 00 09    .success........
63 6C 61 6E 5F 6E 61 6D 65 08 00 09 43 6C 61 6E    clan_name...Clan
50 72 6F 76 61 00 08 6D 61 78 55 73 65 72 73 04    Prova..maxUsers.
00 00 00 14 00 08 6D 69 6E 55 73 65 72 73 04 00    ......minUsers..
00 00 01 00 06 73 74 65 6D 6D 61 04 00 00 00 00    .....stemma.....
00 0B 64 65 73 63 72 69 7A 69 6F 6E 65 08 00 0B    ..descrizione...
49 6C 20 6D 69 6F 20 63 6C 61 6E 00 0A 6D 69 6E    Il.mio.clan..min
5F 74 72 6F 66 65 69 04 00 00 00 00 00 04 74 69    _trofei.......ti
70 6F 08 00 06 50 75 62 6C 69 63 00 07 69 64 5F    po...Public..id_
63 6C 61 6E 04 00 00 00 29 00 08 70 6F 73 69 74    clan....)..posit
69 6F 6E 08 00 0D 49 6E 74 65 72 6E 61 74 69 6F    ion...Internatio
6E 61 6C 00 10 75 74 65 6E 74 65 5F 66 6F 6E 64    nal..utente_fond
61 74 6F 72 65 04 00 00 00 1C 00 01 72 04 00 00    atore.......r...
00 03 00 01 63 08 00 08 66 69 6E 64 63 6C 61 6E    ....c...findclan
00 01 61 03 00 0D 00 01 63 02 01                   ..a.....c..     

30 apr 2017 | 13:04:45,652 | DEBUG | SFSWorker:Ext:3 | controllers.v290.ExtensionReqController |     | Extension call executed in: 8.559954
30 apr 2017 | 13:04:45,824 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | Binary size: 137
80 00 86 12 00 03 00 01 63 02 01 00 01 61 03 00    ........c....a..
0D 00 01 70 12 00 03 00 01 63 08 00 08 66 69 6E    ...p.....c...fin
64 63 6C 61 6E 00 01 72 04 00 00 00 03 00 01 70    dclan..r.......p
12 00 06 00 04 74 65 78 74 08 00 00 00 08 6C 6F    .....text.....lo
63 61 74 69 6F 6E 08 00 00 00 08 6D 69 6E 55 73    cation.....minUs
65 72 73 04 00 00 00 01 00 08 6D 61 78 55 73 65    ers.......maxUse
72 73 04 00 00 00 32 00 09 6D 69 6E 54 72 6F 70    rs....2..minTrop
68 79 04 00 00 00 00 00 0B 75 73 65 72 5F 74 72    hy.......user_tr
6F 70 68 79 04 00 01 86 9F                         ophy.....       

30 apr 2017 | 13:04:45,825 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | STATE: WAIT_NEW_PACKET
30 apr 2017 | 13:04:45,825 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | NORMAL SIZED PACKET: 134
30 apr 2017 | 13:04:45,825 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | <<< PACKET COMPLETE >>>
30 apr 2017 | 13:04:45,825 | DEBUG | SFSWorker:Sys:3 | v2.protocol.SFSProtocolCodec |     |
   (sfs_object) p:
      (sfs_object) p:
         (int) minUsers: 1
         (int) maxUsers: 50
         (int) user_trophy: 99999
         (utf_string) location:
         (utf_string) text:
         (int) minTrophy: 0
         
      
      (int) r: 3
      (utf_string) c: findclan
      
   
   (short) a: 13
   (byte) c: 1
   

30 apr 2017 | 13:04:45,827 | DEBUG | SFSWorker:Ext:4 | controllers.v290.ExtensionReqController |     | [Req Type: (Tcp), Sender: { Id: 1, Type: DEFAULT, Logged: Yes, IP: 127.0.0.1:62657 }]
30 apr 2017 | 13:04:45,827 | DEBUG | SFSWorker:Ext:4 | controllers.v290.ExtensionReqController |     |
   (sfs_object) p:
      (int) minUsers: 1
      (int) maxUsers: 50
      (int) user_trophy: 99999
      (utf_string) location:
      (utf_string) text:
      (int) minTrophy: 0
      
   
   (int) r: 3
   (utf_string) c: findclan
   

30 apr 2017 | 13:04:45,828 | INFO  | SFSWorker:Ext:4 | Extensions |     | {Server}: Sto chiedendo al server di trovare un clan con i miei parametri
30 apr 2017 | 13:04:45,829 | INFO  | SFSWorker:Ext:4 | Extensions |     | {Server}: Ho fatto l'accesso per richiedere al server la mia query
30 apr 2017 | 13:04:45,829 | INFO  | SFSWorker:Ext:4 | Extensions |     | {Server}: query con boolean = true
30 apr 2017 | 13:04:45,831 | DEBUG | SFSWorker:Ext:4 | v2.db.SFSDBManager |     | Execute Query SQL: com.mysql.jdbc.JDBC42PreparedStatement@3a5474fa: SELECT * FROM guesswho.Clan where clan_name Like '%%' and position Like '%%' and maxUsers <= 50 and minUsers >= 1 and min_trofei >= 0 and min_trofei <= 99999  and (tipo = 'Public' or tipo = 'Invito') order by trofei_total desc, clan_name
30 apr 2017 | 13:04:45,834 | DEBUG | SFSWorker:Ext:4 | v2.protocol.SFSProtocolCodec |     | {OUT}: CallExtension
30 apr 2017 | 13:04:45,835 | DEBUG | SFSWorker:Ext:4 | protocol.binary.BinaryIoHandler |     | Binary size: 251
12 00 03 00 01 70 12 00 03 00 01 70 12 00 01 00    .....p.....p....
07 73 75 63 63 65 73 73 11 00 01 12 00 0A 00 09    .success........
63 6C 61 6E 5F 6E 61 6D 65 08 00 09 43 6C 61 6E    clan_name...Clan
50 72 6F 76 61 00 08 6D 61 78 55 73 65 72 73 04    Prova..maxUsers.
00 00 00 14 00 08 6D 69 6E 55 73 65 72 73 04 00    ......minUsers..
00 00 01 00 06 73 74 65 6D 6D 61 04 00 00 00 00    .....stemma.....
00 0B 64 65 73 63 72 69 7A 69 6F 6E 65 08 00 0B    ..descrizione...
49 6C 20 6D 69 6F 20 63 6C 61 6E 00 0A 6D 69 6E    Il.mio.clan..min
5F 74 72 6F 66 65 69 04 00 00 00 00 00 04 74 69    _trofei.......ti
70 6F 08 00 06 50 75 62 6C 69 63 00 07 69 64 5F    po...Public..id_
63 6C 61 6E 04 00 00 00 29 00 08 70 6F 73 69 74    clan....)..posit
69 6F 6E 08 00 0D 49 6E 74 65 72 6E 61 74 69 6F    ion...Internatio
6E 61 6C 00 10 75 74 65 6E 74 65 5F 66 6F 6E 64    nal..utente_fond
61 74 6F 72 65 04 00 00 00 1C 00 01 72 04 00 00    atore.......r...
00 03 00 01 63 08 00 08 66 69 6E 64 63 6C 61 6E    ....c...findclan
00 01 61 03 00 0D 00 01 63 02 01                   ..a.....c..     

30 apr 2017 | 13:04:45,836 | DEBUG | SFSWorker:Ext:4 | controllers.v290.ExtensionReqController |     | Extension call executed in: 8.995714
30 apr 2017 | 13:04:45,977 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | Binary size: 137
80 00 86 12 00 03 00 01 63 02 01 00 01 61 03 00    ........c....a..
0D 00 01 70 12 00 03 00 01 63 08 00 08 66 69 6E    ...p.....c...fin
64 63 6C 61 6E 00 01 72 04 00 00 00 03 00 01 70    dclan..r.......p
12 00 06 00 04 74 65 78 74 08 00 00 00 08 6C 6F    .....text.....lo
63 61 74 69 6F 6E 08 00 00 00 08 6D 69 6E 55 73    cation.....minUs
65 72 73 04 00 00 00 01 00 08 6D 61 78 55 73 65    ers.......maxUse
72 73 04 00 00 00 32 00 09 6D 69 6E 54 72 6F 70    rs....2..minTrop
68 79 04 00 00 00 00 00 0B 75 73 65 72 5F 74 72    hy.......user_tr
6F 70 68 79 04 00 01 86 9F                         ophy.....       

30 apr 2017 | 13:04:45,978 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | STATE: WAIT_NEW_PACKET
30 apr 2017 | 13:04:45,978 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | NORMAL SIZED PACKET: 134
30 apr 2017 | 13:04:45,978 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | <<< PACKET COMPLETE >>>
30 apr 2017 | 13:04:45,979 | DEBUG | SFSWorker:Sys:4 | v2.protocol.SFSProtocolCodec |     |
   (sfs_object) p:
      (sfs_object) p:
         (int) minUsers: 1
         (int) maxUsers: 50
         (int) user_trophy: 99999
         (utf_string) location:
         (utf_string) text:
         (int) minTrophy: 0
         
      
      (int) r: 3
      (utf_string) c: findclan
      
   
   (short) a: 13
   (byte) c: 1
   

30 apr 2017 | 13:04:45,980 | DEBUG | SFSWorker:Ext:1 | controllers.v290.ExtensionReqController |     | [Req Type: (Tcp), Sender: { Id: 1, Type: DEFAULT, Logged: Yes, IP: 127.0.0.1:62657 }]
30 apr 2017 | 13:04:45,981 | DEBUG | SFSWorker:Ext:1 | controllers.v290.ExtensionReqController |     |
   (sfs_object) p:
      (int) minUsers: 1
      (int) maxUsers: 50
      (int) user_trophy: 99999
      (utf_string) location:
      (utf_string) text:
      (int) minTrophy: 0
      
   
   (int) r: 3
   (utf_string) c: findclan
   

30 apr 2017 | 13:04:45,982 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: Sto chiedendo al server di trovare un clan con i miei parametri
30 apr 2017 | 13:04:45,982 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: Ho fatto l'accesso per richiedere al server la mia query
30 apr 2017 | 13:04:45,983 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: query con boolean = true
30 apr 2017 | 13:04:45,985 | DEBUG | SFSWorker:Ext:1 | v2.db.SFSDBManager |     | Execute Query SQL: com.mysql.jdbc.JDBC42PreparedStatement@791d22d: SELECT * FROM guesswho.Clan where clan_name Like '%%' and position Like '%%' and maxUsers <= 50 and minUsers >= 1 and min_trofei >= 0 and min_trofei <= 99999  and (tipo = 'Public' or tipo = 'Invito') order by trofei_total desc, clan_name
30 apr 2017 | 13:04:45,988 | DEBUG | SFSWorker:Ext:1 | v2.protocol.SFSProtocolCodec |     | {OUT}: CallExtension
30 apr 2017 | 13:04:45,989 | DEBUG | SFSWorker:Ext:1 | protocol.binary.BinaryIoHandler |     | Binary size: 251
12 00 03 00 01 70 12 00 03 00 01 70 12 00 01 00    .....p.....p....
07 73 75 63 63 65 73 73 11 00 01 12 00 0A 00 09    .success........
63 6C 61 6E 5F 6E 61 6D 65 08 00 09 43 6C 61 6E    clan_name...Clan
50 72 6F 76 61 00 08 6D 61 78 55 73 65 72 73 04    Prova..maxUsers.
00 00 00 14 00 08 6D 69 6E 55 73 65 72 73 04 00    ......minUsers..
00 00 01 00 06 73 74 65 6D 6D 61 04 00 00 00 00    .....stemma.....
00 0B 64 65 73 63 72 69 7A 69 6F 6E 65 08 00 0B    ..descrizione...
49 6C 20 6D 69 6F 20 63 6C 61 6E 00 0A 6D 69 6E    Il.mio.clan..min
5F 74 72 6F 66 65 69 04 00 00 00 00 00 04 74 69    _trofei.......ti
70 6F 08 00 06 50 75 62 6C 69 63 00 07 69 64 5F    po...Public..id_
63 6C 61 6E 04 00 00 00 29 00 08 70 6F 73 69 74    clan....)..posit
69 6F 6E 08 00 0D 49 6E 74 65 72 6E 61 74 69 6F    ion...Internatio
6E 61 6C 00 10 75 74 65 6E 74 65 5F 66 6F 6E 64    nal..utente_fond
61 74 6F 72 65 04 00 00 00 1C 00 01 72 04 00 00    atore.......r...
00 03 00 01 63 08 00 08 66 69 6E 64 63 6C 61 6E    ....c...findclan
00 01 61 03 00 0D 00 01 63 02 01                   ..a.....c..     

30 apr 2017 | 13:04:45,992 | DEBUG | SFSWorker:Ext:1 | controllers.v290.ExtensionReqController |     | Extension call executed in: 10.524934
30 apr 2017 | 13:04:47,339 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | Binary size: 67
80 00 40 12 00 03 00 01 63 02 01 00 01 61 03 00    ..@.....c....a..
0D 00 01 70 12 00 03 00 01 63 08 00 0A 63 6C 61    ...p.....c...cla
6E 64 65 74 61 69 6C 00 01 72 04 00 00 00 03 00    ndetail..r......
01 70 12 00 01 00 07 63 6C 61 6E 5F 69 64 04 00    .p.....clan_id..
00 00 29                                           ..)             

30 apr 2017 | 13:04:47,339 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | STATE: WAIT_NEW_PACKET
30 apr 2017 | 13:04:47,340 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | NORMAL SIZED PACKET: 64
30 apr 2017 | 13:04:47,340 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | <<< PACKET COMPLETE >>>
30 apr 2017 | 13:04:47,340 | DEBUG | SFSWorker:Sys:2 | v2.protocol.SFSProtocolCodec |     |
   (sfs_object) p:
      (sfs_object) p:
         (int) clan_id: 41
         
      
      (int) r: 3
      (utf_string) c: clandetail
      
   
   (short) a: 13
   (byte) c: 1
   

30 apr 2017 | 13:04:47,341 | DEBUG | SFSWorker:Ext:3 | controllers.v290.ExtensionReqController |     | [Req Type: (Tcp), Sender: { Id: 1, Type: DEFAULT, Logged: Yes, IP: 127.0.0.1:62657 }]
30 apr 2017 | 13:04:47,342 | DEBUG | SFSWorker:Ext:3 | controllers.v290.ExtensionReqController |     |
   (sfs_object) p:
      (int) clan_id: 41
      
   
   (int) r: 3
   (utf_string) c: clandetail
   

30 apr 2017 | 13:04:47,343 | INFO  | SFSWorker:Ext:3 | Extensions |     | {Server}: Sto richiedendo al server i dettagli di un clan
30 apr 2017 | 13:04:47,343 | INFO  | SFSWorker:Ext:3 | Extensions |     | {Server}: Ho fatto l'accesso per richiedere al server la mia query
30 apr 2017 | 13:04:47,345 | DEBUG | SFSWorker:Ext:3 | v2.db.SFSDBManager |     | Execute Query SQL: com.mysql.jdbc.JDBC42PreparedStatement@594ef38d: select users.id_user,users.username, users.trofei, users.position, guesswho.clan.* from users inner join guesswho.clan on guesswho.users.id_user = guesswho.clan.utente_fondatore    or guesswho.users.id_user = guesswho.clan.utente_2 or guesswho.users.id_user = guesswho.clan.utente_3 or guesswho.users.id_user = guesswho.clan.utente_4 or guesswho.users.id_user = guesswho.clan.utente_5 or guesswho.users.id_user = guesswho.clan.utente_6 or guesswho.users.id_user = guesswho.clan.utente_7 or guesswho.users.id_user = guesswho.clan.utente_8 or guesswho.users.id_user = guesswho.clan.utente_9 or guesswho.users.id_user = guesswho.clan.utente_10 or guesswho.users.id_user = guesswho.clan.utente_11 or guesswho.users.id_user = guesswho.clan.utente_12 or guesswho.users.id_user = guesswho.clan.utente_13 or guesswho.users.id_user = guesswho.clan.utente_14 or guesswho.users.id_user = guesswho.clan.utente_15 or guesswho.users.id_user = guesswho.clan.utente_16 or guesswho.users.id_user = guesswho.clan.utente_17 or guesswho.users.id_user = guesswho.clan.utente_18 or guesswho.users.id_user = guesswho.clan.utente_19 or guesswho.users.id_user = guesswho.clan.utente_20 where id_clan = 41 order by users.trofei desc
30 apr 2017 | 13:04:47,350 | DEBUG | SFSWorker:Ext:3 | v2.protocol.SFSProtocolCodec |     | {OUT}: CallExtension
30 apr 2017 | 13:04:47,351 | DEBUG | SFSWorker:Ext:3 | protocol.binary.BinaryIoHandler |     | Binary size: 300
12 00 03 00 01 70 12 00 03 00 01 70 12 00 01 00    .....p.....p....
07 73 75 63 63 65 73 73 11 00 01 12 00 0D 00 09    .success........
63 6C 61 6E 5F 6E 61 6D 65 08 00 09 43 6C 61 6E    clan_name...Clan
50 72 6F 76 61 00 08 6D 61 78 55 73 65 72 73 04    Prova..maxUsers.
00 00 00 14 00 04 74 69 70 6F 08 00 06 50 75 62    ......tipo...Pub
6C 69 63 00 07 69 64 5F 63 6C 61 6E 04 00 00 00    lic..id_clan....
29 00 07 69 64 5F 75 73 65 72 04 00 00 00 1C 00    )..id_user......
10 75 74 65 6E 74 65 5F 66 6F 6E 64 61 74 6F 72    .utente_fondator
65 04 00 00 00 1C 00 08 6D 69 6E 55 73 65 72 73    e.......minUsers
04 00 00 00 01 00 0A 6D 69 6E 5F 74 72 6F 66 65    .......min_trofe
69 04 00 00 00 00 00 0B 64 65 73 63 72 69 7A 69    i.......descrizi
6F 6E 65 08 00 0B 49 6C 20 6D 69 6F 20 63 6C 61    one...Il.mio.cla
6E 00 06 73 74 65 6D 6D 61 04 00 00 00 00 00 06    n..stemma.......
74 72 6F 66 65 69 04 00 00 00 00 00 08 70 6F 73    trofei.......pos
69 74 69 6F 6E 08 00 0D 49 6E 74 65 72 6E 61 74    ition...Internat
69 6F 6E 61 6C 00 08 75 73 65 72 6E 61 6D 65 08    ional..username.
00 07 70 6F 69 70 6F 69 32 00 01 72 04 00 00 00    ..poipoi2..r....
03 00 01 63 08 00 0A 63 6C 61 6E 64 65 74 61 69    ...c...clandetai
6C 00 01 61 03 00 0D 00 01 63 02 01                l..a.....c..   

30 apr 2017 | 13:04:47,353 | DEBUG | SFSWorker:Ext:3 | controllers.v290.ExtensionReqController |     | Extension call executed in: 10.808028
30 apr 2017 | 13:04:48,425 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | Binary size: 103
80 00 64 12 00 03 00 01 63 02 01 00 01 61 03 00    ..d.....c....a..
0D 00 01 70 12 00 03 00 01 63 08 00 09 65 6E 74    ...p.....c...ent
65 72 63 6C 61 6E 00 01 72 04 00 00 00 03 00 01    erclan..r.......
70 12 00 03 00 07 63 6C 61 6E 5F 69 64 04 00 00    p.....clan_id...
00 29 00 09 63 6C 61 6E 5F 6E 61 6D 65 08 00 09    .)..clan_name...
43 6C 61 6E 50 72 6F 76 61 00 07 75 73 65 72 5F    ClanProva..user_
69 64 04 00 00 00 13                               id.....         

30 apr 2017 | 13:04:48,426 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | STATE: WAIT_NEW_PACKET
30 apr 2017 | 13:04:48,426 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | NORMAL SIZED PACKET: 100
30 apr 2017 | 13:04:48,426 | DEBUG | SocketReader | protocol.binary.BinaryIoHandler |     | <<< PACKET COMPLETE >>>
30 apr 2017 | 13:04:48,426 | DEBUG | SFSWorker:Sys:3 | v2.protocol.SFSProtocolCodec |     |
   (sfs_object) p:
      (sfs_object) p:
         (utf_string) clan_name: ClanProva
         (int) user_id: 19
         (int) clan_id: 41
         
      
      (int) r: 3
      (utf_string) c: enterclan
      
   
   (short) a: 13
   (byte) c: 1
   

30 apr 2017 | 13:04:48,428 | DEBUG | SFSWorker:Ext:1 | controllers.v290.ExtensionReqController |     | [Req Type: (Tcp), Sender: { Id: 1, Type: DEFAULT, Logged: Yes, IP: 127.0.0.1:62657 }]
30 apr 2017 | 13:04:48,428 | DEBUG | SFSWorker:Ext:1 | controllers.v290.ExtensionReqController |     |
   (sfs_object) p:
      (utf_string) clan_name: ClanProva
      (int) user_id: 19
      (int) clan_id: 41
      
   
   (int) r: 3
   (utf_string) c: enterclan
   

30 apr 2017 | 13:04:48,429 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: Sto chiedendo di registrare uno user dentro un clan al server
30 apr 2017 | 13:04:48,431 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: sono entrato nel primo try per verificare che lo user non abbia già clan
30 apr 2017 | 13:04:48,482 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 
30 apr 2017 | 13:04:48,482 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: se l'utente non ha clan ora vediamo se il clan selezionato è Public
30 apr 2017 | 13:04:48,483 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}:  stampiamo il tipoPublic
30 apr 2017 | 13:04:48,483 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: Verifichiamo che quel clan non abbia già max users
30 apr 2017 | 13:04:48,484 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,484 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,484 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: prepariamo l'inserimento dello user
30 apr 2017 | 13:04:48,485 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,486 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,486 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,486 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,486 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,486 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,486 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,487 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,487 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,487 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,487 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,487 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,487 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,487 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,488 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,488 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,488 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,488 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,488 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: 0
30 apr 2017 | 13:04:48,536 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: utente2 inserito nel clan
30 apr 2017 | 13:04:48,537 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: select id_clan, clan_name, trofei_total,stemma, position from guesswho.clan where id_clan = ? 
30 apr 2017 | 13:04:48,541 | INFO  | SFSWorker:Ext:1 | Extensions |     | {Server}: java.sql.SQLException: Cannot get a connection, pool error: Pool exhausted
30 apr 2017 | 13:04:48,542 | DEBUG | SFSWorker:Ext:1 | controllers.v290.ExtensionReqController |     | Extension call executed in: 114.184756


When I make a normal request I have no problems, but when I make a request that involves changing the room many times, I get out of "pool error: Pool exhausted" because I have this error?
User avatar
Lapo
Site Admin
Posts: 23026
Joined: 21 Mar 2005, 09:50
Location: Italy

Re: java.sql.SQLException: Cannot get a connection, pool error: Pool exhausted

Postby Lapo » 01 May 2017, 13:35

Do you use DBManager.getConnection() in your code?
In other words do you manage connection manually?

thanks
Lapo
--
gotoAndPlay()
...addicted to flash games
TwineApps
Posts: 80
Joined: 10 Nov 2016, 18:39

Re: java.sql.SQLException: Cannot get a connection, pool error: Pool exhausted

Postby TwineApps » 01 May 2017, 18:37

Yes, i use DBManager.getConnection() in my extension code.
User avatar
Lapo
Site Admin
Posts: 23026
Joined: 21 Mar 2005, 09:50
Location: Italy

Re: java.sql.SQLException: Cannot get a connection, pool error: Pool exhausted

Postby Lapo » 02 May 2017, 06:56

Ok, then make sure to handle exceptions correctly as explained in the documentation here:
http://smartfoxserver.com/blog/custom-l ... -database/

See the "Handling Exceptions" section

cheers
Lapo

--

gotoAndPlay()

...addicted to flash games
TwineApps
Posts: 80
Joined: 10 Nov 2016, 18:39

Re: java.sql.SQLException: Cannot get a connection, pool error: Pool exhausted

Postby TwineApps » 02 May 2017, 10:39

work it!! thank's

Return to “SFS2X Questions”

Who is online

Users browsing this forum: No registered users and 73 guests