Postgres Crashes and Leaves PT3; AHK unstable.

[stillnaive]

just got finished testing it again -- i lowered my total number of tables down to 5 and it crashed at 900 hands. i didn't use ahk hud, but i did use a few other ahk scripts -- which i realized after i was done with my session. i'm dumb and dave has me addicted to ahk, apparently!

error message as follows:

[quotevf0]2008-03-04 20:11:56 STATEMENT: COPY holdem_hand_summary FROM STDIN;
2008-03-04 20:13:10 WARNING: there is no transaction in progress
2008-03-04 20:25:21 LOG: could not open temporary statistics file "global/pgstat.tmp": Invalid argument
2008-03-04 20:26:03 LOG: server process (PID 3896) exited with exit code -1073741523
2008-03-04 20:26:03 LOG: terminating any other active server processes
2008-03-04 20:26:03 WARNING: terminating connection because of crash of another server process
2008-03-04 20:26:03 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2008-03-04 20:26:03 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2008-03-04 20:26:03 WARNING: terminating connection because of crash of another server process
2008-03-04 20:26:03 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2008-03-04 20:26:03 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2008-03-04 20:26:03 WARNING: terminating connection because of crash of another server process
2008-03-04 20:26:03 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2008-03-04 20:26:03 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2008-03-04 20:26:03 WARNING: terminating connection because of crash of another server process
2008-03-04 20:26:03 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2008-03-04 20:26:03 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2008-03-04 20:26:03 WARNING: terminating connection because of crash of another server process
2008-03-04 20:26:03 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2008-03-04 20:26:03 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2008-03-04 20:26:03 WARNING: terminating connection because of crash of another server process
2008-03-04 20:26:03 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2008-03-04 20:26:03 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2008-03-04 20:26:03 WARNING: terminating connection because of crash of another server process
2008-03-04 20:26:03 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2008-03-04 20:26:03 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2008-03-04 20:26:03 WARNING: terminating connection because of crash of another server process
2008-03-04 20:26:03 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2008-03-04 20:26:03 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2008-03-04 20:26:03 WARNING: terminating connection because of crash of another server process
2008-03-04 20:26:03 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2008-03-04 20:26:03 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2008-03-04 20:26:04 WARNING: terminating connection because of crash of another server process
2008-03-04 20:26:04 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2008-03-04 20:26:04 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2008-03-04 20:26:04 LOG: all server processes terminated; reinitializing
2008-03-04 20:26:04 LOG: database system was interrupted at 2008-03-04 20:24:04
2008-03-04 20:26:04 LOG: checkpoint record is at 0/97A6EC30
2008-03-04 20:26:04 LOG: redo record is at 0/97A6EC30; undo record is at 0/0; shutdown FALSE
2008-03-04 20:26:04 LOG: next transaction ID: 0/973318; next OID: 64238
2008-03-04 20:26:04 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2008-03-04 20:26:04 LOG: database system was not properly shut down; automatic recovery in progress
2008-03-04 20:26:04 LOG: redo starts at 0/97A6EC80
2008-03-04 20:26:06 LOG: record with zero length at 0/97ACDE28
2008-03-04 20:26:06 LOG: redo done at 0/97ACDDF8
LOG: unrecognized win32 error code: 1455
FATAL: could not reattach to shared memory (key=5432001, addr=01340000): Invalid argument
2008-03-04 20:26:09 LOG: database system is ready
2008-03-04 20:27:09 LOG: CreateProcess call failed: A blocking operation was interrupted by a call to WSACancelBlockingCall.
(error code 1816)
2008-03-04 20:27:09 LOG: could not fork autovacuum process: A blocking operation was interrupted by a call to WSACancelBlockingCall.
2008-03-04 20:28:09 LOG: CreateProcess call failed: A blocking operation was interrupted by a call to WSACancelBlockingCall.
(error code 1816)
2008-03-04 20:28:09 LOG: could not fork autovacuum process: A blocking operation was interrupted by a call to WSACancelBlockingCall.
2008-03-04 20:29:09 LOG: CreateProcess call failed: A blocking operation was interrupted by a call to WSACancelBlockingCall.
(error code 1816)
2008-03-04 20:29:09 LOG: could not fork autovacuum process: A blocking operation was interrupted by a call to WSACancelBlockingCall.
2008-03-04 20:30:10 LOG: received fast shutdown request
2008-03-04 20:30:11 LOG: shutting down
2008-03-04 20:30:11 LOG: database system is shut down
2008-03-04 20:30:12 LOG: logger shutting down
[/quotevf0]

PT error message:

[quotevf0]2008/03/04 20:25:51.156: [00002604][ImportAuto] Adding message: PokerStars: Hand Imported (#15745788485)
2008/03/04 20:26:02.828: [00002928][ImportAuto] Adding message: PokerStars: Hand Imported (#15745781562)
2008/03/04 20:26:16.843: [00002604][PostgresConnection (Error)] Connection Lost to Database: PT3_2008_02_13_170624
2008/03/04 20:26:16.937: [00002604][ImportAuto] Adding message: Connection Lost to Database: PT3_2008_02_13_170624(Line #4659)
2008/03/04 20:26:27.406: [00002604][ImportAuto] Adding message: PokerStars: Stopping auto-import.
2008/03/04 20:26:27.531: [00002604][HandHistoryFeederText] Moving file 'C:\Program Files\PokerStars\HandHistory\\stillnaive\HH20080304 Shapleya no all-in - $0.05-$0.10 - No Limit Hold'em.txt' to 'C:\Documents and Settings\Mark\My Documents\mined ap hands\HH20080304 Shapleya no all-in - $0.05-$0.10 - No Limit Hold'em_1.txt'
2008/03/04 20:26:27.625: [00002604][HandHistoryFeederText] Moving file 'C:\Program Files\PokerStars\HandHistory\\stillnaive\HH20080304 Electra IV no all-in - $0.05-$0.10 - No Limit Hold'em.txt' to 'C:\Documents and Settings\Mark\My Documents\mined ap hands\HH20080304 Electra IV no all-in - $0.05-$0.10 - No Limit Hold'em.txt'
2008/03/04 20:26:27.703: [00002604][HandHistoryFeederText] Moving file 'C:\Program Files\PokerStars\HandHistory\\stillnaive\HH20080304 Sadalmelik no all-in - $0.05-$0.10 - No Limit Hold'em.txt' to 'C:\Documents and Settings\Mark\My Documents\mined ap hands\HH20080304 Sadalmelik no all-in - $0.05-$0.10 - No Limit Hold'em.txt'
2008/03/04 20:26:27.765: [00002604][HandHistoryFeederText] Moving file 'C:\Program Files\PokerStars\HandHistory\\stillnaive\HH20080304 Ibarruri II no all-in - $0.05-$0.10 - No Limit Hold'em.txt' to 'C:\Documents and Settings\Mark\My Documents\mined ap hands\HH20080304 Ibarruri II no all-in - $0.05-$0.10 - No Limit Hold'em.txt'
2008/03/04 20:26:27.875: [00002604][HandHistoryFeederText] Moving file 'C:\Program Files\PokerStars\HandHistory\\stillnaive\HH20080304 Piazzia II no all-in - $0.05-$0.10 - No Limit Hold'em.txt' to 'C:\Documents and Settings\Mark\My Documents\mined ap hands\HH20080304 Piazzia II no all-in - $0.05-$0.10 - No Limit Hold'em.txt'
2008/03/04 20:26:27.937: [00002604][HandHistoryFeederText] Moving file 'C:\Program Files\PokerStars\HandHistory\\stillnaive\HH20080304 Hadar no all-in - $0.05-$0.10 - No Limit Hold'em.txt' to 'C:\Documents and Settings\Mark\My Documents\mined ap hands\HH20080304 Hadar no all-in - $0.05-$0.10 - No Limit Hold'em.txt'
2008/03/04 20:26:28.015: [00002604][HandHistoryFeederText] Moving file 'C:\Program Files\PokerStars\HandHistory\\stillnaive\HH20080304 Caph no all-in - $0.05-$0.10 - No Limit Hold'em.txt' to 'C:\Documents and Settings\Mark\My Documents\mined ap hands\HH20080304 Caph no all-in - $0.05-$0.10 - No Limit Hold'em.txt'
2008/03/04 20:28:57.250: [- Main -][App] Shutting down subsystems...
2008/03/04 20:28:57.437: [- Main -][PostgresConnection] Disconnecting from database: PT3_2008_02_13_170624
2008/03/04 20:28:57.468: [- Main -][PostgresConnection] Disconnecting from database: PT3_2008_02_13_170624
2008/03/04 20:28:57.531: [- Main -][PostgresConnection] Disconnecting from database: PT3_2008_02_13_170624
2008/03/04 20:28:57.609: [- Main -][PostgresConnection] Disconnecting from database: PT3_2008_02_13_170624
2008/03/04 20:28:57.671: [- Main -][PostgresConnection] Disconnecting from database: PT3_2008_02_13_170624
2008/03/04 20:28:57.703: [- Main -][PostgresConnection] Disconnecting from database: PT3_2008_02_13_170624
2008/03/04 20:28:57.765: [- Main -][PostgresConnection] Disconnecting from database: PT3_2008_02_13_170624
2008/03/04 20:28:57.859: [- Main -][System] Application exiting
[/quotevf0]

i am very confident pt3 isn't the cause of my system crash; it's almost definitely postgres. when the postgres crash occurs, the problem actually takes my entire computer down; i can't open any application, including notepad to look at the error logs. this is kinda alarming to me, and it makes me wonder a bit if the problem is my windows build, but i'd prefer not to reformat if it can be avoided.

[stillnaive]

i'm now datamining ftp to test

[_dave_]

I certainly would not worry about any other AHKs influencing things - although just to satisfy others I may try without any, although it would be horribly painful and labour intensive to play ~1K hands AHK is very widely tested and very stable - I'm sure AP10 only wondered about AHK HUD because it is interacting with the PT3 database unlike anything else you may be running.

looks to me like this is the trigger point:

[quote1g7]
2008-03-04 20:25:21 LOG: could not open temporary statistics file "global/pgstat.tmp": Invalid argument
[/quote1g7]

We need to know what is causing this (or if it is actually the problem).

[stillnaive]

well, hopefully we'll know soon -- i'm importing headsup ftp tables, lol

[stillnaive]

with nothing but pt3 and ft running importing observed hands (i don't actually play ft, so i can't tell if that made a difference), it was rock solid through 8k hands imported and about the same amount of time running.

[stillnaive]

i think i figured out the issue; my hard drive was in its last days.

i had my page file set to my backup hd, and the hd just died on me last night. since ahkhud does have a fairly large memory footprint, it's pretty easy to imagine that it was taking up page file resources. i think now that i put the page file onto my main (stable) drive, hopefully these problems should subside.

[APerfect10]

Good deal. Please keep us updated to ensure that this resolves the problem...if it does that would be very good news!

Best regards,

Derek