beta 7 crashes during stats processing

[dgmt]

pt3 starts, but when i click "holdem" it creeze after few seconds, beta 6 worked fine

log:
[quotew3x]
2008/03/30 00:41:07.750: [- Main -][System] PokerTracker v3.00 beta 7
2008/03/30 00:41:08.546: [00003612][QueryManager] Loading stats
2008/03/30 00:41:11.406: [00003612][QueryManager] Stats loaded.
2008/03/30 00:41:11.437: [00003612][QueryManager] Loading queries
2008/03/30 00:41:11.453: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Aliases.xml.pte
2008/03/30 00:41:11.468: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Hand-Detail.xml.pte
2008/03/30 00:41:11.578: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Hand-Summary.xml.pte
2008/03/30 00:41:11.609: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Notes.xml.pte
2008/03/30 00:41:11.625: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Players.xml.pte
2008/03/30 00:41:11.656: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-BBWon.xml.pte
2008/03/30 00:41:11.687: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-MoneyWon.xml.pte
2008/03/30 00:41:11.734: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-ShowdownNoShowdown.xml.pte
2008/03/30 00:41:11.781: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Players.xml.pte
2008/03/30 00:41:11.859: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-Hands-Graph.xml.pte
2008/03/30 00:41:11.953: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph-Month.xml.pte
2008/03/30 00:41:12.000: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph.xml.pte
2008/03/30 00:41:12.078: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer-Detail.xml.pte
2008/03/30 00:41:12.343: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer.xml.pte
2008/03/30 00:41:12.468: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Graphs-MoneyWon.xml.pte
2008/03/30 00:41:12.609: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Players.xml.pte
2008/03/30 00:41:12.703: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Tournaments-Hands-Graph.xml.pte
2008/03/30 00:41:12.765: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Winnings-Daily.xml.pte
2008/03/30 00:41:12.843: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer-Detail.xml.pte
2008/03/30 00:41:12.968: [00003612][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer.xml.pte
2008/03/30 00:41:13.109: [00003612][QueryManager] Queries loaded.
2008/03/30 00:41:13.390: [00003612][StatManager] Stats and reports loaded.
2008/03/30 00:41:13.453: [00003612][FilterManager] Loading filters...
2008/03/30 00:41:13.703: [00003612][FilterManager] Filters loaded.
2008/03/30 00:41:13.796: [00003612][LayoutManager] Loading layouts...
2008/03/30 00:41:13.875: [00003612][LayoutManager] Layouts loaded.
2008/03/30 00:41:13.968: [00003612][PostgresConnection] Connecting to database: PT3_2008_03_02_214351
2008/03/30 00:41:15.062: [00003612][PostgresConnection] Successfully connected to: PT3_2008_03_02_214351 [27402688]
2008/03/30 00:41:15.109: [00003612][ConnectionManager] Database Version: 300025
2008/03/30 00:41:15.203: [00003612][PostgresConnection] Connecting to database: PT3_2008_03_02_214351
2008/03/30 00:41:15.343: [00003612][PostgresConnection] Successfully connected to: PT3_2008_03_02_214351 [28276472]
2008/03/30 00:41:15.359: [00003612][PostgresConnection] Connecting to database: PT3_2008_03_02_214351
2008/03/30 00:41:15.468: [00003612][PostgresConnection] Successfully connected to: PT3_2008_03_02_214351 [28227712]
2008/03/30 00:41:15.484: [00003612][PostgresConnection] Connecting to database: PT3_2008_03_02_214351
2008/03/30 00:41:15.593: [00003612][PostgresConnection] Successfully connected to: PT3_2008_03_02_214351 [28279928]
2008/03/30 00:41:23.250: [- Main -][Query] Executing SQL: SELECT DISTINCT player.id_player, player.id_site, player.player_name, player.player_name_search, player.val_icon FROM holdem_hand_player_statistics, player, holdem_table_session_summary WHERE player.id_player > 0 AND player.id_player_alias = 0 AND player.id_player = holdem_table_session_summary.id_player AND holdem_hand_player_statistics.id_player = holdem_table_session_summary.id_player AND holdem_table_session_summary.id_session = holdem_hand_player_statistics.id_session AND ((( holdem_table_session_summary.id_site in (100) )AND ( holdem_hand_player_statistics.id_limit in (3) ))) ORDER BY player.player_name_search asc;
[/quotew3x]

[APerfect10]

Is that the entire log file?

-Derek

[Strom]

I have the same problem and my log file ends with the same query. (That query executes just fine when I use pgAdmin.)

[dgmt]

[quote="APerfect10"v3u]Is that the entire log file?

-Derek[/quotev3u]

yes

i'm running win xp btw

[APerfect10]

I'll have to see what Josh says...I've marked the thread for his attention.

-Derek

[gogeta97]

I have the same problem, here's my log file:

[code0il]2008/03/30 03:11:48.578: [- Main -][System] PokerTracker v3.00 beta 7
2008/03/30 03:11:50.921: [00003540][QueryManager] Loading stats
2008/03/30 03:11:53.671: [00003540][QueryManager] Stats loaded.
2008/03/30 03:11:53.828: [00003540][QueryManager] Loading queries
2008/03/30 03:11:54.000: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Aliases.xml.pte
2008/03/30 03:11:54.250: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Hand-Detail.xml.pte
2008/03/30 03:11:54.484: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Hand-Summary.xml.pte
2008/03/30 03:11:54.609: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Notes.xml.pte
2008/03/30 03:11:54.734: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Players.xml.pte
2008/03/30 03:11:54.828: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-BBWon.xml.pte
2008/03/30 03:11:54.984: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-MoneyWon.xml.pte
2008/03/30 03:11:55.140: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-ShowdownNoShowdown.xml.pte
2008/03/30 03:11:55.281: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Players.xml.pte
2008/03/30 03:11:55.453: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-Hands-Graph.xml.pte
2008/03/30 03:11:55.640: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer-Detail.xml.pte
2008/03/30 03:11:56.046: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer.xml.pte
2008/03/30 03:11:56.265: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph-Month.xml.pte
2008/03/30 03:11:56.421: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph.xml.pte
2008/03/30 03:11:56.500: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Graphs-MoneyWon.xml.pte
2008/03/30 03:11:56.625: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Players.xml.pte
2008/03/30 03:11:56.765: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Tournaments-Hands-Graph.xml.pte
2008/03/30 03:11:56.890: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer-Detail.xml.pte
2008/03/30 03:11:57.218: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer.xml.pte
2008/03/30 03:11:57.375: [00003540][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Winnings-Daily.xml.pte
2008/03/30 03:11:57.500: [00003540][QueryManager] Queries loaded.
2008/03/30 03:11:58.406: [00003540][StatManager] Stats and reports loaded.
2008/03/30 03:11:58.515: [00003540][FilterManager] Loading filters...
2008/03/30 03:11:59.093: [00003540][FilterManager] Filters loaded.
2008/03/30 03:11:59.171: [00003540][LayoutManager] Loading layouts...
2008/03/30 03:11:59.218: [00003540][LayoutManager] Layouts loaded.
2008/03/30 03:11:59.312: [00003540][PostgresConnection] Connecting to database: PT3 Beta DB1
2008/03/30 03:12:00.859: [00003540][PostgresConnection] Successfully connected to: PT3 Beta DB1 [27761384]
2008/03/30 03:12:02.156: [00003540][ConnectionManager] Database Version: 300025
2008/03/30 03:12:02.296: [00003540][PostgresConnection] Connecting to database: PT3 Beta DB1
2008/03/30 03:12:02.406: [00003540][PostgresConnection] Successfully connected to: PT3 Beta DB1 [28801960]
2008/03/30 03:12:02.437: [00003540][PostgresConnection] Connecting to database: PT3 Beta DB1
2008/03/30 03:12:02.546: [00003540][PostgresConnection] Successfully connected to: PT3 Beta DB1 [28694112]
2008/03/30 03:12:02.562: [00003540][PostgresConnection] Connecting to database: PT3 Beta DB1
2008/03/30 03:12:02.656: [00003540][PostgresConnection] Successfully connected to: PT3 Beta DB1 [28790584]
2008/03/30 03:12:08.265: [- Main -][Query] Executing SQL: SELECT DISTINCT player.id_player, player.id_site, player.player_name, player.player_name_search, player.val_icon FROM player, holdem_table_session_summary WHERE player.id_player > 0 AND player.id_player_alias = 0 AND player.id_player = holdem_table_session_summary.id_player ORDER BY player.player_name_search asc;
[/code0il]

edit: After a brief glance through, it looks identical to the log posted earlier. I'll still leave it up in case something is subtly different.

[Josh]

What version of windows are you guys running and what version of PostgreSQL?

[rubbishaka80]

Same problem, XP and postgresql 8.3 here.

[dgmt]

xp, 8.3

[Josh]

Does anyone happen to have 8.2.5 installed alongside 8.3? I'm wondering if this is a PostgreSQL problem or if it's something else.