PDA

View Full Version : PostgresSql timeout



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

fozzy71
06-30-2009, 04:40 PM
What version of HM? What operating system? If it's Vista, you must turn off UAC and set all the poker EXE's to 'Run As Administrator. What Firewall? Have you tried uninstalling the Firewall?


See if either of these FAQs help.

http://www.holdemmanager.net/faq/?f=34

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171


I will forward this on for some further assistance from the support manager.

telemac73
06-30-2009, 05:05 PM
Hm 1.09 beta 8

Vista, UAC is turned off, I start holdemmager.exe as admin but i cannot set "run as administrator" in the properties (turrning off UAC have disabled this option ...)

I use bitdefender total security as firewall, i have disabled it and try to restart psql (after psql crash) , the only way to restart psql service is to reboot.

Thanks

fozzy71
06-30-2009, 05:51 PM
OK, Thanks for the info. Not that it will help any for your PostgreSQL issue, but the current version (just released) is 1.09 beta 10 - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

I have asked fabio to take a look at this thread and see if he can offer any suggestions. I will let you know once I have been able to talk to him about it.

fozzy71
06-30-2009, 07:06 PM
.......

I use bitdefender total security as firewall, i have disabled it and try to restart psql (after psql crash) , the only way to restart psql service is to reboot.

Thanks

Can you please try to add psql and holdemmanager to the firewall's exception list, or else uninstall the firewall completely and reboot -

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171