telemac73
06-30-2009, 04:23 PM
Hi,
I can import 4 to 8 sng after postgressql crash (i need to reboot , service wont restart manually)
I have tested 8.2 to 8.3.7
Psql log :
2009-06-30 14:51:44 CEST ERROR: duplicate key value violates unique constraint "playerhandsflop_pkey"
2009-06-30 14:51:44 CEST STATEMENT: EXECUTE PHTourneyKeyEXECUTE(17604,573,to_timestamp('06/30/2009 14:51:14','MM/DD/YYYY HH24:MI:SS'),5,1372,6,4,0,0,0,0,0,0,False,False,4, 0,0,0,0,0,0,0,0,0,False,False,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,200906302658,0,0,0); EXECUTE PHTourneyMiscEXECUTE(573,101700.00,101700.00,2,1,-1,False,-1,0,0,0,0,0,-1,-1,False,False,False,False,False,False,False,0,4.76 888888888889); EXECUTE PHTourneyKeyEXECUTE(17604,574,to_timestamp('06/30/2009 14:51:14','MM/DD/YYYY HH24:MI:SS'),5,977,6,5,0,0,0,0,0,0,False,False,4,0 ,0,0,0,0,0,0,0,0,False,False,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,200906302658,-1,0,0); EXECUTE PHTourneyMiscEXECUTE(574,335500.00,335500.00,3,0,-1,False,-1,0,0,0,0,0,-1,-1,False,False,False,False,False,False,False,0,4.76 888888888889); EXECUTE PHTourneyKeyEXECUTE(17604,575,to_timestamp('06/30/2009 14:51:14','MM/DD/YYYY HH24:MI:SS'),5,919,6,0,0,0,0,0,-7500,0,False,False,4,0,0,0,0,0,0,0,0,0,False,False ,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,200906302658,-1,0,0); EXECUTE PHTourneyMiscEXECUTE(575,433500.00,371000.00,4,5,-1,False,-1,0,0,7500,0,0,-1,-1,False,False,False,False,False,False,False,0,4.76 888888888889); EXECUTE PVPExecute(919,1375,17604,-7500,1); EXECUTE PHTourneyKeyEXECUTE(17604,576,to_timestamp('06/30/2009 14:51:14','MM/DD/YYYY HH24:MI:SS'),5,970,6,1,0,0,0,0,-15000,0,False,False,4,0,0,0,0,0,0,0,0,0,False,Fals e,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,200906302658,-1,0,0); EXECUTE PHTourneyMiscEXECUTE(576,371000.00,136000.00,7,4,-1,False,-1,0,0,15000,0,0,-1,-1,False,False,False,False,False,False,False,0,4.76 888888888889); EXECUTE PVPExecute(970,1375,17604,-15000,1); EXECUTE PKHHeroEXECUTE(17604,1647207545,7,to_timestamp('06/30/2009 14:51:14','MM/DD/YYYY HH24:MI:SS'),132,5,6,2,2,2,2,3,48,34,6,43,45,26710 0,0,267100,267100,267100,267100,0,0,32,1,2,False,3 ,0,0,0,9,9,9,-1,2,-1,0); EXECUTE PHTourneyKeyEXECUTE(17604,577,to_timestamp('06/30/2009 14:51:14','MM/DD/YYYY HH24:MI:SS'),5,1115,6,2,13,38,104,0,-122300,1,True,True,0,3,4,0,0,0,0,0,0,88,False,Fals e,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,200906302658,152,0,0); EXECUTE PHTourneyKeyHeroEXECUTE(17604,577,to_timestamp('06/30/2009 14:51:14','MM/DD/YYYY HH24:MI:SS'),5,1115,6,2,13,38,104,0,-122300,1,True,True,0,3,4,0,0,0,0,0,0,88,False,Fals e,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,200906302658,152,0,0); EXECUTE PHTourneyMiscEXECUTE(577,122300.00,122300.00,8,3,3 0,True,2,122300,0,0,1,0,-1,-1,False,False,False,False,False,False,False,4.7688 8888888889,0); EXECUTE PHTourneyMiscHeroEXECUTE(577,122300.00,122300.00,8 ,3,30,True,2,122300,0,0,1,0,-1,-1,False,False,False,False,False,False,False,4.7688 8888888889,0); EXECUTE ALLINEXECUTE(577,402,-14824); EXECUTE ALLINHeroEXECUTE(577,402,-14824); EXECUTE PHFlopExecute(577,0,0,False,False,False,-1,0,0,0,0,False,False,10,0,0,0); EXECUTE PHFlopHeroExecute(577,0,0,False,False,False,-1,0,0,0,0,False,False,10,0,0,0); EXECUTE PHTurnExecute(577,0,0,False,False,False,-1,0,0,0,0,False,False,10,0,0,0); EXECUTE PHTurnHeroExecute(577,0,0,False,False,False,-1,0,0,0,0,False,False,10,0,0,0); EXECUTE PHRiverExecute(577,0,0,False,False,False,-1,0,0,0,0,False,False,30,0); EXECUTE PHRiverHeroExecute(577,0,0,False,False,False,-1,0,0,0,0,False,False,30,0); EXECUTE PVPExecute(1115,1375,17604,-122300,1); EXECUTE PVPHeroExecute(1115,1375,17604,-122300,1); EXECUTE PHTourneyKeyEXECUTE(17604,578,to_timestamp('06/30/2009 14:51:14','MM/DD/YYYY HH24:MI:SS'),5,1375,6,3,11,40,94,0,144800,1,True,F alse,3,2,4,0,0,0,0,0,0,66,False,False,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,200906302658,-150,0,0); EXECUTE PHTourneyMiscEXECUTE(578,136000.00,136000.00,9,2,3 0,False,1,0,122300,0,0,1,-1,-1,False,False,False,False,False,False,False,0,4.76 888888888889); EXECUTE ALLINEXECUTE(578,598,37324); EXECUTE PHFlopExecute(578,0,0,False,False,True,-1,0,0,0,0,False,False,10,0,0,0); EXECUTE PHTurnExecute(578,0,0,False,False,True,-1,0,0,0,0,False,False,10,0,0,0); EXECUTE PHRiverExecute(578,0,0,False,False,True,-1,0,0,0,0,False,False,30,0); EXECUTE PVPExecute(1375,919,17604,7500,1); EXECUTE PVPExecute(1375,970,17604,15000,1); EXECUTE PVPExecute(1375,1115,17604,122300,1);
2009-06-30 14:51:51 CEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-06-30 14:52:10 CEST LOG: could not receive data from client: Unknown winsock error 10061
2009-06-30 14:52:10 CEST LOG: unexpected EOF on client connection
2009-06-30 14:52:10 CEST LOG: could not receive data from client: Unknown winsock error 10061
2009-06-30 14:52:10 CEST LOG: unexpected EOF on client connection
2009-06-30 14:52:16 CEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-06-30 14:52:16 CEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-06-30 14:52:16 CEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-06-30 14:52:24 CEST LOG: could not receive data from client: Unknown winsock error 10061
2009-06-30 14:52:24 CEST LOG: unexpected EOF on client connection
2009-06-30 14:52:24 CEST LOG: could not receive data from client: Unknown winsock error 10061
2009-06-30 14:52:24 CEST LOG: unexpected EOF on client connection
2009-06-30 14:52:24 CEST LOG: could not receive data from client: Unknown winsock error 10061
2009-06-30 14:52:24 CEST LOG: unexpected EOF on client connection
2009-06-30 17:27:59 CEST FATAL: n'a pas pu dupliquer la socket 872 pour le serveur : code d'erreur 10022
Thanks
I can import 4 to 8 sng after postgressql crash (i need to reboot , service wont restart manually)
I have tested 8.2 to 8.3.7
Psql log :
2009-06-30 14:51:44 CEST ERROR: duplicate key value violates unique constraint "playerhandsflop_pkey"
2009-06-30 14:51:44 CEST STATEMENT: EXECUTE PHTourneyKeyEXECUTE(17604,573,to_timestamp('06/30/2009 14:51:14','MM/DD/YYYY HH24:MI:SS'),5,1372,6,4,0,0,0,0,0,0,False,False,4, 0,0,0,0,0,0,0,0,0,False,False,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,200906302658,0,0,0); EXECUTE PHTourneyMiscEXECUTE(573,101700.00,101700.00,2,1,-1,False,-1,0,0,0,0,0,-1,-1,False,False,False,False,False,False,False,0,4.76 888888888889); EXECUTE PHTourneyKeyEXECUTE(17604,574,to_timestamp('06/30/2009 14:51:14','MM/DD/YYYY HH24:MI:SS'),5,977,6,5,0,0,0,0,0,0,False,False,4,0 ,0,0,0,0,0,0,0,0,False,False,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,200906302658,-1,0,0); EXECUTE PHTourneyMiscEXECUTE(574,335500.00,335500.00,3,0,-1,False,-1,0,0,0,0,0,-1,-1,False,False,False,False,False,False,False,0,4.76 888888888889); EXECUTE PHTourneyKeyEXECUTE(17604,575,to_timestamp('06/30/2009 14:51:14','MM/DD/YYYY HH24:MI:SS'),5,919,6,0,0,0,0,0,-7500,0,False,False,4,0,0,0,0,0,0,0,0,0,False,False ,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,200906302658,-1,0,0); EXECUTE PHTourneyMiscEXECUTE(575,433500.00,371000.00,4,5,-1,False,-1,0,0,7500,0,0,-1,-1,False,False,False,False,False,False,False,0,4.76 888888888889); EXECUTE PVPExecute(919,1375,17604,-7500,1); EXECUTE PHTourneyKeyEXECUTE(17604,576,to_timestamp('06/30/2009 14:51:14','MM/DD/YYYY HH24:MI:SS'),5,970,6,1,0,0,0,0,-15000,0,False,False,4,0,0,0,0,0,0,0,0,0,False,Fals e,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,200906302658,-1,0,0); EXECUTE PHTourneyMiscEXECUTE(576,371000.00,136000.00,7,4,-1,False,-1,0,0,15000,0,0,-1,-1,False,False,False,False,False,False,False,0,4.76 888888888889); EXECUTE PVPExecute(970,1375,17604,-15000,1); EXECUTE PKHHeroEXECUTE(17604,1647207545,7,to_timestamp('06/30/2009 14:51:14','MM/DD/YYYY HH24:MI:SS'),132,5,6,2,2,2,2,3,48,34,6,43,45,26710 0,0,267100,267100,267100,267100,0,0,32,1,2,False,3 ,0,0,0,9,9,9,-1,2,-1,0); EXECUTE PHTourneyKeyEXECUTE(17604,577,to_timestamp('06/30/2009 14:51:14','MM/DD/YYYY HH24:MI:SS'),5,1115,6,2,13,38,104,0,-122300,1,True,True,0,3,4,0,0,0,0,0,0,88,False,Fals e,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,200906302658,152,0,0); EXECUTE PHTourneyKeyHeroEXECUTE(17604,577,to_timestamp('06/30/2009 14:51:14','MM/DD/YYYY HH24:MI:SS'),5,1115,6,2,13,38,104,0,-122300,1,True,True,0,3,4,0,0,0,0,0,0,88,False,Fals e,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,200906302658,152,0,0); EXECUTE PHTourneyMiscEXECUTE(577,122300.00,122300.00,8,3,3 0,True,2,122300,0,0,1,0,-1,-1,False,False,False,False,False,False,False,4.7688 8888888889,0); EXECUTE PHTourneyMiscHeroEXECUTE(577,122300.00,122300.00,8 ,3,30,True,2,122300,0,0,1,0,-1,-1,False,False,False,False,False,False,False,4.7688 8888888889,0); EXECUTE ALLINEXECUTE(577,402,-14824); EXECUTE ALLINHeroEXECUTE(577,402,-14824); EXECUTE PHFlopExecute(577,0,0,False,False,False,-1,0,0,0,0,False,False,10,0,0,0); EXECUTE PHFlopHeroExecute(577,0,0,False,False,False,-1,0,0,0,0,False,False,10,0,0,0); EXECUTE PHTurnExecute(577,0,0,False,False,False,-1,0,0,0,0,False,False,10,0,0,0); EXECUTE PHTurnHeroExecute(577,0,0,False,False,False,-1,0,0,0,0,False,False,10,0,0,0); EXECUTE PHRiverExecute(577,0,0,False,False,False,-1,0,0,0,0,False,False,30,0); EXECUTE PHRiverHeroExecute(577,0,0,False,False,False,-1,0,0,0,0,False,False,30,0); EXECUTE PVPExecute(1115,1375,17604,-122300,1); EXECUTE PVPHeroExecute(1115,1375,17604,-122300,1); EXECUTE PHTourneyKeyEXECUTE(17604,578,to_timestamp('06/30/2009 14:51:14','MM/DD/YYYY HH24:MI:SS'),5,1375,6,3,11,40,94,0,144800,1,True,F alse,3,2,4,0,0,0,0,0,0,66,False,False,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,200906302658,-150,0,0); EXECUTE PHTourneyMiscEXECUTE(578,136000.00,136000.00,9,2,3 0,False,1,0,122300,0,0,1,-1,-1,False,False,False,False,False,False,False,0,4.76 888888888889); EXECUTE ALLINEXECUTE(578,598,37324); EXECUTE PHFlopExecute(578,0,0,False,False,True,-1,0,0,0,0,False,False,10,0,0,0); EXECUTE PHTurnExecute(578,0,0,False,False,True,-1,0,0,0,0,False,False,10,0,0,0); EXECUTE PHRiverExecute(578,0,0,False,False,True,-1,0,0,0,0,False,False,30,0); EXECUTE PVPExecute(1375,919,17604,7500,1); EXECUTE PVPExecute(1375,970,17604,15000,1); EXECUTE PVPExecute(1375,1115,17604,122300,1);
2009-06-30 14:51:51 CEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-06-30 14:52:10 CEST LOG: could not receive data from client: Unknown winsock error 10061
2009-06-30 14:52:10 CEST LOG: unexpected EOF on client connection
2009-06-30 14:52:10 CEST LOG: could not receive data from client: Unknown winsock error 10061
2009-06-30 14:52:10 CEST LOG: unexpected EOF on client connection
2009-06-30 14:52:16 CEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-06-30 14:52:16 CEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-06-30 14:52:16 CEST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-06-30 14:52:24 CEST LOG: could not receive data from client: Unknown winsock error 10061
2009-06-30 14:52:24 CEST LOG: unexpected EOF on client connection
2009-06-30 14:52:24 CEST LOG: could not receive data from client: Unknown winsock error 10061
2009-06-30 14:52:24 CEST LOG: unexpected EOF on client connection
2009-06-30 14:52:24 CEST LOG: could not receive data from client: Unknown winsock error 10061
2009-06-30 14:52:24 CEST LOG: unexpected EOF on client connection
2009-06-30 17:27:59 CEST FATAL: n'a pas pu dupliquer la socket 872 pour le serveur : code d'erreur 10022
Thanks