sql error

[dakky316]

please see image



Uploaded with ImageShack.us

[kraada]

Unfortunately the image you posted does not show the error text in full. Please restart PT3 using the Logging Enabled link on your start menu, reproduce and report this problem and we'll look into what is going on here for you. Your log file will give us the error message in full which will help considerably in figuring out what the appropriate next step is for you.

[dakky316]

thanks kraada. The error seems to be "Reason: Fatal Error (ERROR: invalid page header in block 364 of relation "tourney_holdem_hand_summary_primary_key" )"


2012/04/24 17:57:22.394: [- Main -][System] PokerTracker v3.13.4 beta
2012/04/24 17:57:22.442: [- Main -][SystemInfo] OS: Windows NT 6.1 (build 7600)
2012/04/24 17:57:22.444: [- Main -][SystemInfo] Windows Version: 6.1 build 7600 (platform 2)
2012/04/24 17:57:22.445: [- Main -][SystemInfo] Current Code Page: 1252 Locale: 0409
2012/04/24 17:57:22.446: [- Main -][SystemInfo] Total Logical Processing Units: 4
2012/04/24 17:57:22.448: [- Main -][SystemInfo] Processor Info: Numa: 1 Pkg: 1 Cores: 2 PUs: 4 (L1: 2, L2: 2, L3: 1)
2012/04/24 17:57:22.449: [- Main -][SystemInfo] Processor 1: Speed: 2.53 GHz Name: Intel(R) Core(TM) i5 CPU M 460 @ 2.53GHz
2012/04/24 17:57:22.451: [- Main -][SystemInfo] Processor 2: Speed: 2.53 GHz Name: Intel(R) Core(TM) i5 CPU M 460 @ 2.53GHz
2012/04/24 17:57:22.452: [- Main -][SystemInfo] Processor 3: Speed: 2.53 GHz Name: Intel(R) Core(TM) i5 CPU M 460 @ 2.53GHz
2012/04/24 17:57:22.453: [- Main -][SystemInfo] Processor 4: Speed: 2.53 GHz Name: Intel(R) Core(TM) i5 CPU M 460 @ 2.53GHz
2012/04/24 17:57:22.454: [- Main -][SystemInfo] C:\ Disk Space: 290,143 mb total; 286,627 mb used; 3,517 mb free
2012/04/24 17:57:22.461: [- Main -][SystemInfo] Physical Memory: 3,959 mb (1,773 mb available) Virtual Memory: 2,048 mb (1,930 mb available) Page File: 4,096 mb (2,004 mb available)
2012/04/24 17:57:22.466: [- Main -][System Info] Video[0]: ATI Mobility Radeon HD 5470 (\\.\DISPLAY1)
2012/04/24 17:57:22.467: [- Main -][System Info] Video[5]: LogMeIn Mirror Driver (\\.\DISPLAYV4)
2012/04/24 17:57:22.583: [- Main -][SystemInfo] Adobe Flash: 11.1.102.55 Plugin: 10.3.181.14 AIR: 3.1.0.4880
2012/04/24 17:57:22.603: [- Main -][SystemInfo] Configuration: [WindowInfo]\nMainPos=185,0\nMainSize=1015,728\nMainMaximized=Y\n\n\n[General]\nLogging=N\nBuildDate=2012/04/05\nRegistrationCode=*** REG CODE REMOVED ***\nBestHudPerformance=N\nInvalidText=#C0C0C0:NA\nUseCardImages=Y\nColorPositiveText=009900\nColorPositiveRow=EBFFEB\nColorNegativeText=AA0000\nColorNegativeRow=FFEBEB\n\n\n[Import]\nBeepOnCompletion=Y\nClusterOnCompletion=Y\nVacuumOnCompletion=Y\nAnalyzeOnCompletion=Y\nUpCacheOnCompletion=Y\nAutoStart.1400=N\nAutoStart.1300=N\nAutoStart.700=N\nAutoStart.1200=N\nAutoStart.800=N\nAutoStart.1000=N\nAutoStart.500=N\nAutoStart.300=Y\nAutoStart.400=N\nAutoStart.2100=N\nAutoStart.1100=N\nAutoStart.600=N\nAutoStart.900=N\nAutoStart.200=N\nAutoStart.100=Y\nAutoStart.2200=N\nAutoStart.1800=N\nForceSetupWizard=N\nIncludeSubDirectories=Y\nCloseOnCompletion=N\nStartHud=Y\nDetectOnCompletion=Y\nOverwriteTournamentSummary=N\nPriority=2\n\n\n\n[Database]\nDefault.Postgres.Server=localhost\nDefault.Postgres.Port=5432\nDefault.Postgres.User=postgres\nDefault.Postgres.Password=dbpass\nDB1.Name=PokerTracker 3 Database\nDB1.Type=postgres\nDB1.Postgres.Database=PT3 DB\nDB1.Postgres.Server=localhost\nDB1.Postgres.Port=5432\nDB1.Postgres.User=postgres\nDB1.Postgres.Password=dbpass\nDB1.Default=Y\n\n\n[ReportInfo]\n\n\n[HandReplayer]\n\n[Site.FullTilt]\nRushHud=Y\nHandHistoryDirectory=C:\Program Files (x86)\Full Tilt Poker\HandHistory\n[Site.Betfair]\nHandHistoryDirectories=-\n[Site.Boss]\nHandHistoryDirectories=-;\n[Site.Cake]\nHandHistoryDirectories=-\n[Site.Cereus]\nHandHistoryDirectories=-\n[Site.Entraction]\nHandHistoryDirectories=-\n[Site.Everest]\nHandHistoryDirectories=-\n[Site.iPoker]\nHandHistoryDirectories=C:\Poker\Betfred Poker\History;C:\Poker\BetMost Poker\History;C:\Poker\Paddy Power Poker\History;C:\Poker\William Hill Poker\History;C:\Poker\Black Belt Poker\History;\n[Site.Merge]\nHandHistoryDirectories=-\n[Site.MicroGaming]\nHandHistoryDatabases=-\n[Site.OnGame]\nHandHistoryDirectories=-;\n[Site.Pacific]\nHandHistoryDirectories=-\n[Site.Party]\nHandHistoryDirectories=-\n[Hud]\nMuckedCards.Display=Y\nMuckedCards.Length=5\nMuckedCards.Translucency=20\nNotes.Translucency=20\nMinHands=1\nCurrentLimit=N\nCurrentBlind=N\nSessionStats=Y\nLastXHands=0\nRefreshRates=0,25,1|25,100,5|100,200,10|200,100000,20|\nNotesSize=450,152\n[Tabs]\nLast:WindowMain=1\nLast:WindowImport=0\nLast:WindowStats:Holdem=1\nLast:WindowStatsTab:holdem-cash=8\nLast:WindowStatsTab:holdem-tourney=2\nLast:WindowStats:Omaha=0\nLast:WindowStatsTab:omaha-cash=0\nLast:WindowStatsTab:omaha-tourney=0\n[TableTracker]\nGameIndex=0\nHideTablesNoStats=N\n[Messages]\nOptOut:99f7ba05d2216ef45d6109c13c89b4f4=Y\nOptOut:1ab4c8e72d3d58a327deeadb1bbc88a9=Y\nOptOut:218b96d1c4038f78923963117951eceb=Y\n[Site.PokerStars]\nHandHistoryDirectory=C:\Users\Sam\AppData\Local\PokerStars\HandHistory\;\n
2012/04/24 17:57:22.663: [- Main -][System] Getting String: 1058-F257-16AB-DC8E-E726-AD9D-CC44-09CB
2012/04/24 17:57:22.684: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/regcheck.php
2012/04/24 17:57:22.685: [- Main -][wxThreadedRead] Starting read thread ...
2012/04/24 17:57:22.688: [00001D70][ConnectorReadThread] Thread [0x00001D70]: Begin
2012/04/24 17:57:22.689: [00001D70][ConnectorReadThread::Entry] Beginning thread.
2012/04/24 17:57:22.691: [00001D70][ConnectorReadThread] Creating socket...
2012/04/24 17:57:22.692: [00001D70][ConnectorReadThread] DNS lookup...
2012/04/24 17:57:22.728: [00001D70][ConnectorReadThread] Socket connect...
2012/04/24 17:57:23.595: [00001D70][ConnectorReadThread] Sending request...
2012/04/24 17:57:23.916: [00001D70][ConnectorReadThread] Reading response...
2012/04/24 17:57:23.920: [00001D70][ConnectorReadThread] Read complete.
2012/04/24 17:57:23.921: [00001D70][ConnectorReadThread] Returning.
2012/04/24 17:57:23.939: [- Main -][wxThreadedRead] Getting data ...
2012/04/24 17:57:23.946: [- Main -][Registration] License written to C:\Program Files (x86)\PokerTracker 3/Data/Config/PokerTracker.lic
2012/04/24 17:57:23.951: [- Main -][System] Registered: true
2012/04/24 17:57:23.953: [- Main -][System] HelpMessages v1.01 is up to date.
2012/04/24 17:57:23.954: [- Main -][System] FullTilt v1.15 is up to date.
2012/04/24 17:57:23.983: [- Main -][System] 888 v1.1 is up to date.
2012/04/24 17:57:23.985: [- Main -][System] Currencies v1.01 is up to date.
2012/04/24 17:57:24.012: [- Main -][System] TournamentDetect v1.90 is up to date.
2012/04/24 17:57:24.038: [- Main -][System] TRP Status: TH: false; TO: false; RH: true; RO: false; PH: true; PO: false;
2012/04/24 17:57:24.160: [- Main -][WindowSplash] Beginning load process
2012/04/24 17:57:24.165: [0000154C][WindowSplash::Worker::Entry] Beginning thread.
2012/04/24 17:57:24.168: [0000154C][WindowSplash::Worker] Thread [0x0000154C]: Begin
2012/04/24 17:57:24.218: [0000154C][CurrencyManager] Rates are 2 days old
2012/04/24 17:57:24.219: [0000154C][System] Attempting to connect to: https://www.ptrackupdate.com/currencyRates.php
2012/04/24 17:57:24.219: [0000154C][wxThreadedRead] Starting read thread ...
2012/04/24 17:57:24.220: [00001AD0][ConnectorReadThread] Thread [0x00001AD0]: Begin
2012/04/24 17:57:24.221: [00001AD0][ConnectorReadThread::Entry] Beginning thread.
2012/04/24 17:57:24.222: [00001AD0][ConnectorReadThread] Creating socket...
2012/04/24 17:57:24.223: [00001AD0][ConnectorReadThread] DNS lookup...
2012/04/24 17:57:24.223: [00001AD0][ConnectorReadThread] Socket connect...
2012/04/24 17:57:24.556: [00001AD0][ConnectorReadThread] Sending request...
2012/04/24 17:57:24.698: [00001AD0][ConnectorReadThread] Reading response...
2012/04/24 17:57:24.702: [00001AD0][ConnectorReadThread] Read complete.
2012/04/24 17:57:24.704: [00001AD0][ConnectorReadThread] Returning.
2012/04/24 17:57:24.721: [0000154C][wxThreadedRead] Getting data ...
2012/04/24 17:57:24.723: [0000154C][QueryManager] Loading queries
2012/04/24 17:57:24.816: [0000154C][StatManager] CacheRebuildPercent: 90.0%
2012/04/24 17:57:24.849: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Aliases.xml.pte
2012/04/24 17:57:24.898: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Hand-Detail.xml.pte
2012/04/24 17:57:24.952: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Hand-Summary.xml.pte
2012/04/24 17:57:25.006: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Notes.xml.pte
2012/04/24 17:57:25.020: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Hand-Detail.xml.pte
2012/04/24 17:57:25.061: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Hand-Summary.xml.pte
2012/04/24 17:57:25.121: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Players.xml.pte
2012/04/24 17:57:25.136: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-BBWon.xml.pte
2012/04/24 17:57:25.166: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-EV-AllinPerformance.xml.pte
2012/04/24 17:57:25.205: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-MoneyWon.xml.pte
2012/04/24 17:57:25.227: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-ShowdownNoShowdown.xml.pte
2012/04/24 17:57:25.285: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Player-Details.xml.pte
2012/04/24 17:57:25.317: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Players.xml.pte
2012/04/24 17:57:25.333: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-Hands-Graph.xml.pte
2012/04/24 17:57:25.396: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-More-Details.xml.pte
2012/04/24 17:57:25.433: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Summary-Site.xml.pte
2012/04/24 17:57:25.449: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer-Detail.xml.pte
2012/04/24 17:57:25.543: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer.xml.pte
2012/04/24 17:57:25.617: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph-Month.xml.pte
2012/04/24 17:57:25.678: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph.xml.pte
2012/04/24 17:57:25.685: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Graphs-MoneyWon.xml.pte
2012/04/24 17:57:25.720: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Player-Details.xml.pte
2012/04/24 17:57:25.736: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Players.xml.pte
2012/04/24 17:57:25.752: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Summary-Site.xml.pte
2012/04/24 17:57:25.796: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Tournaments-Hands-Graph.xml.pte
2012/04/24 17:57:25.824: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer-Detail.xml.pte
2012/04/24 17:57:25.914: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer.xml.pte
2012/04/24 17:57:25.980: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-BBWon.xml.pte
2012/04/24 17:57:26.065: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-EV-AllinPerformance.xml.pte
2012/04/24 17:57:26.120: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-MoneyWon.xml.pte
2012/04/24 17:57:26.171: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-ShowdownNoShowdown.xml.pte
2012/04/24 17:57:26.197: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Player-Details.xml.pte
2012/04/24 17:57:26.217: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Players.xml.pte
2012/04/24 17:57:26.225: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Sessions-Hands-Graph.xml.pte
2012/04/24 17:57:26.248: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Sessions-More-Details.xml.pte
2012/04/24 17:57:26.253: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Summary-Site.xml.pte
2012/04/24 17:57:26.262: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\vsPlayer-Detail.xml.pte
2012/04/24 17:57:26.311: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\vsPlayer.xml.pte
2012/04/24 17:57:26.394: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Winnings-Graph-Month.xml.pte
2012/04/24 17:57:26.432: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Winnings-Graph.xml.pte
2012/04/24 17:57:26.437: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Graphs-MoneyWon.xml.pte
2012/04/24 17:57:26.456: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Player-Details.xml.pte
2012/04/24 17:57:26.465: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Players.xml.pte
2012/04/24 17:57:26.473: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Summary-Site.xml.pte
2012/04/24 17:57:26.489: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Tournaments-Hands-Graph.xml.pte
2012/04/24 17:57:26.500: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\vsPlayer-Detail.xml.pte
2012/04/24 17:57:26.583: [0000154C][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\vsPlayer.xml.pte
2012/04/24 17:57:26.625: [0000154C][QueryManager] Queries loaded.
2012/04/24 17:57:26.630: [0000154C][StatManager] Loading stats and reports...
2012/04/24 17:57:28.206: [0000154C][StatManager] Stats and reports loaded. Load: 1.56s, Custom: 0.0651ms, Dupe: 21728655677486929000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.00m
2012/04/24 17:57:28.225: [0000154C][FilterManager] Loading filters...
2012/04/24 17:57:31.063: [0000154C][FilterManager] Filters loaded.
2012/04/24 17:57:31.064: [0000154C][LayoutManager] Loading layouts...
2012/04/24 17:57:31.260: [0000154C][StatManager] Loading stats and reports...
2012/04/24 17:57:32.593: [0000154C][StatManager] Stats and reports loaded. Load: 1.33s, Custom: 0.0643ms, Dupe: 0.0000ms
2012/04/24 17:57:32.593: [0000154C][LayoutManager] Layouts loaded.
2012/04/24 17:57:32.595: [0000154C][PostgresConnection] Connecting to database: PT3 DB
2012/04/24 17:57:34.157: [0000154C][PostgresConnection] [06944670] Successfully connected to: PT3 DB [0x06944310] (ver = 80309, autotune = N)
2012/04/24 17:57:35.188: [0000154C][ConnectionManager] Database Version: 300049
2012/04/24 17:57:35.310: [0000154C][PostgresConnection] Connecting to database: PT3 DB
2012/04/24 17:57:35.797: [0000154C][PostgresConnection] [06954230] Successfully connected to: PT3 DB [0x06951860] (ver = 80309, autotune = N)
2012/04/24 17:57:35.837: [0000154C][PostgresConnection] Connecting to database: PT3 DB
2012/04/24 17:57:36.333: [0000154C][PostgresConnection] [06951AD0] Successfully connected to: PT3 DB [0x06955470] (ver = 80309, autotune = N)
2012/04/24 17:57:36.382: [0000154C][PostgresConnection] Connecting to database: PT3 DB
2012/04/24 17:57:36.853: [0000154C][PostgresConnection] [06955720] Successfully connected to: PT3 DB [0x06956c00] (ver = 80309, autotune = N)
2012/04/24 17:57:36.897: [0000154C][WindowSplash::Worker::Entry] Ending thread.
2012/04/24 17:57:36.925: [- Main -][WindowSplash::winNotify] Notified of worker completion.
2012/04/24 17:57:36.926: [- Main -][WindowSplash::checkProgress] Worker complete.
2012/04/24 17:57:37.458: [- Main -][EverleafOptions] Found INI File:
2012/04/24 17:57:37.542: [- Main -][FullTiltOptions] Using FullTiltPoker: C:\Users\Sam\AppData\Local\FullTiltPoker
2012/04/24 17:57:37.973: [- Main -][PokerStarsOptions] Found INI File: C:\Users\Sam\AppData\Local\PokerStars\user.ini
2012/04/24 17:57:38.004: [- Main -][PokerStars] Install Path: C:\Program Files (x86)\PokerStars
2012/04/24 17:57:38.073: [- Main -][WPEXOptions] Unable to access registry key
2012/04/24 17:57:38.074: [- Main -][WPEXOptions] Found INI File:
2012/04/24 17:57:38.274: [- Main -][Players] Buddies:
2012/04/24 17:57:38.275: [- Main -][Players] 0 buddies found
2012/04/24 17:57:42.253: [- Main -][System] Getting String: ; Avg Exec Time: PSMG=2012/04/15 19:18
2012/04/24 17:57:42.572: [- Main -][WindowStatsTab] Refreshing active player: false
2012/04/24 17:57:42.644: [- Main -][WindowStatsTab] Refreshing active player: false
2012/04/24 17:57:49.544: [- Main -][WindowMain] Database: PokerTracker 3 Database Size: 3611 MB
2012/04/24 17:57:50.629: [- Main -][WindowMain] Database: PokerTracker 3 Database Cache Status: Holdem: 100% Holdem Tourney: 100%
2012/04/24 17:57:50.670: [000019F4][ThreadPool] Thread [07F35A50]: Created
2012/04/24 17:57:50.671: [000019F4][Query::QueryThread] Thread [0x000019F4]: Begin
2012/04/24 17:57:50.672: [000019F4][Query] Connecting to database: PokerTracker 3 Database
2012/04/24 17:57:50.673: [000019F4][Query] Executing SQL (Thread): SELECT player.id_player, player.id_site, player.player_name, player.val_icon FROM player WHERE player.id_player > 0 AND player.id_player_alias = 0 AND player.id_player in ( SELECT DISTINCT tourney_holdem_hand_player_statistics.id_player FROM tourney_holdem_hand_player_statistics WHERE 1=1 ) ORDER BY player.player_name_search asc
2012/04/24 17:58:13.919: [000019F4][Query] Query execution time: 23242.42209892 ms
2012/04/24 17:58:14.022: [000019F4][QueryReportCtrl::Populate] Thread [0x000019F4]: Begin
2012/04/24 17:58:20.474: [000019F4][QueryReportCtrl] Query 1: Populate: 6431.3212 ms, 62877 rows, 6 cols, 0.0170 ms/col (time log: Query 1: t0: 0.0780 ms, t1: 105.0241 ms, t2: 6326.1585 ms, t3: 0.0000 ms, t4: 0.0437 ms, t5: 0.0040 ms, t6: 0.0004 ms)
2012/04/24 17:58:22.342: [000019F4][Query::QueryThread] Thread [0x000019F4]: Begin
2012/04/24 17:58:22.343: [000019F4][Query] Connecting to database: PokerTracker 3 Database
2012/04/24 17:58:22.344: [000019F4][Query] Executing SQL (Thread): SELECT (tourney_holdem_hand_player_statistics.id_holecard) as "id_holecard", (sum((case when(tourney_holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))) as "cnt_hands", (sum((case when(tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "cnt_won_hand", (sum(tourney_holdem_hand_player_statistics.amt_won)) as "amt_won", (sum( (CASE WHEN ( (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult)) <> 0 THEN ((tourney_holdem_hand_player_statistics.amt_won * 1.0 )/( (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult))) ELSE 0 END) )) as "amt_bb_won", (sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_b OR tourney_holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))) as "cnt_blind", (sum((case when(tourney_holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))) as "cnt_p_ccall", (sum( (case when( NOT(NOT(tourney_holdem_hand_player_statistics.flg_p_face_raise) OR (tourney_holdem_hand_player_statistics.flg_p_limp) OR (tourney_holdem_hand_player_statistics.flg_p_first_raise)) AND (tourney_holdem_hand_player_detail.amt_blind=0)) then 1 else 0 end) )) as "cnt_p_ccall_opp", (sum((case when(tourney_holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))) as "cnt_vpip", (sum((case when(tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "cnt_f_saw_won", (sum((case when(tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))) as "cnt_f_saw", (sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))) as "cnt_pfr", (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end)) ) as "cnt_p_raise_first_in", (sum((case when(tourney_holdem_hand_player_statistics.flg_p_open_opp) then 1 else 0 end))) as "cnt_p_open_opp", (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_open = false AND tourney_holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))) as "cnt_prev_callers_limp", (sum( (case when( ((NOT tourney_holdem_hand_player_statistics.flg_p_face_raise) OR tourney_holdem_hand_player_statistics.flg_p_limp OR tourney_holdem_hand_player_statistics.flg_p_first_raise) AND NOT tourney_holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action <> '') then 1 else 0 end) )) as "cnt_p_facing_limpers", (sum((case when(tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))) as "cnt_wtsd", (sum( (case when(tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) as "cnt_wtsd_won" FROM tourney_holdem_hand_player_statistics , tourney_holdem_hand_player_detail, lookup_actions lookup_actions_p, tourney_holdem_blinds WHERE (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (lookup_actions_p.id_action=tourney_holdem_hand_player_detail.id_action_p) AND (tourney_holdem_hand_player_statistics.id_player = 27) AND (((tourney_holdem_hand_player_statistics.id_holecard) > 0)) GROUP BY (tourney_holdem_hand_player_statistics.id_holecard)
2012/04/24 17:59:00.870: [000019F4][Query] Query execution time: 38479.13361463 ms
2012/04/24 17:59:00.876: [000019F4][QueryReportCtrl::Populate] Thread [0x000019F4]: Begin
2012/04/24 17:59:00.985: [000019F4][QueryReportCtrl] Query 2: Populate: 108.5156 ms, 169 rows, 14 cols, 0.0459 ms/col (time log: Query 2: t0: 0.4895 ms, t1: 0.3662 ms, t2: 106.9675 ms, t3: 0.0000 ms, t4: 0.2724 ms, t5: 0.4046 ms, t6: 0.0012 ms)
2012/04/24 17:59:01.210: [000019F4][Query::QueryThread] Thread [0x000019F4]: Begin
2012/04/24 17:59:01.211: [000019F4][Query] Connecting to database: PokerTracker 3 Database
2012/04/24 17:59:01.212: [000019F4][Query] Executing SQL (Thread): SELECT (tourney_holdem_hand_summary.id_hand) as "id_hand", (tourney_holdem_hand_summary.id_site) as "id_site", (tourney_holdem_hand_summary.hand_no) as "hand_no", (tourney_holdem_hand_summary.flg_note) as "flg_note", (tourney_holdem_hand_player_statistics.id_holecard) as "id_holecard", (tourney_holdem_hand_summary.id_blinds) as "id_blinds", (tourney_holdem_hand_summary.date_played) as "date_played", (tourney_holdem_hand_player_statistics.flg_blind_s) as "flg_blind_s", (tourney_holdem_hand_player_statistics.flg_blind_b) as "flg_blind_b", (tourney_holdem_hand_player_statistics.flg_p_ccall) as "flg_p_ccall", (tourney_holdem_hand_player_statistics.amt_won) as "amt_won", (tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb * tourney_holdem_blinds.val_nlpl_mult)) as "amt_bb_won", (tourney_holdem_hand_player_detail.holecard_1) as "id_holecard1", (tourney_holdem_hand_player_detail.holecard_2) as "id_holecard2", (tourney_holdem_hand_player_statistics.flg_f_saw) as "flg_f_saw", (tourney_holdem_hand_summary.card_1) as "id_flop1", (tourney_holdem_hand_summary.card_2) as "id_flop2", (tourney_holdem_hand_summary.card_3) as "id_flop3", (tourney_holdem_hand_summary.card_4) as "id_turn", (tourney_holdem_hand_summary.card_5) as "id_river", (tourney_holdem_hand_player_statistics.id_final_hand) as "id_final_hand", (tourney_holdem_hand_player_statistics.flg_showed) as "flg_showed", (tourney_holdem_hand_player_statistics.enum_folded) as "enum_folded", (player_winner.player_name) as "str_winner", (tourney_holdem_hand_summary.id_win_hand) as "id_win_hand" FROM tourney_holdem_hand_player_statistics , tourney_holdem_hand_player_detail, tourney_holdem_hand_summary, player player_winner, tourney_holdem_blinds WHERE (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (player_winner.id_player = tourney_holdem_hand_summary.id_winner) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) AND (tourney_holdem_hand_player_statistics.id_player = 27) AND (((tourney_holdem_hand_player_statistics.id_holecard) = 1))
2012/04/24 17:59:05.451: [000019F4][PostgresConnection (Error)] Unable to execute query: SELECT (tourney_holdem_hand_summary.id_hand) as "id_hand", (tourney_holdem_hand_summary.id_site) as "id_site", (tourney_holdem_hand_summary.hand_no) as "hand_no", (tourney_holdem_hand_summary.flg_note) as "flg_note", (tourney_holdem_hand_player_statistics.id_holecard) as "id_holecard", (tourney_holdem_hand_summary.id_blinds) as "id_blinds", (tourney_holdem_hand_summary.date_played) as "date_played", (tourney_holdem_hand_player_statistics.flg_blind_s) as "flg_blind_s", (tourney_holdem_hand_player_statistics.flg_blind_b) as "flg_blind_b", (tourney_holdem_hand_player_statistics.flg_p_ccall) as "flg_p_ccall", (tourney_holdem_hand_player_statistics.amt_won) as "amt_won", (tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb * tourney_holdem_blinds.val_nlpl_mult)) as "amt_bb_won", (tourney_holdem_hand_player_detail.holecard_1) as "id_holecard1", (tourney_holdem_hand_player_detail.holecard_2) as "id_holecard2", (tourney_holdem_hand_player_statistics.flg_f_saw) as "flg_f_saw", (tourney_holdem_hand_summary.card_1) as "id_flop1", (tourney_holdem_hand_summary.card_2) as "id_flop2", (tourney_holdem_hand_summary.card_3) as "id_flop3", (tourney_holdem_hand_summary.card_4) as "id_turn", (tourney_holdem_hand_summary.card_5) as "id_river", (tourney_holdem_hand_player_statistics.id_final_hand) as "id_final_hand", (tourney_holdem_hand_player_statistics.flg_showed) as "flg_showed", (tourney_holdem_hand_player_statistics.enum_folded) as "enum_folded", (player_winner.player_name) as "str_winner", (tourney_holdem_hand_summary.id_win_hand) as "id_win_hand" FROM tourney_holdem_hand_player_statistics , tourney_holdem_hand_player_detail, tourney_holdem_hand_summary, player player_winner, tourney_holdem_blinds WHERE (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (player_winner.id_player = tourney_holdem_hand_summary.id_winner) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) AND (tourney_holdem_hand_player_statistics.id_player = 27) AND (((tourney_holdem_hand_player_statistics.id_holecard) = 1)) ; Reason: Fatal Error (ERROR: invalid page header in block 364 of relation "tourney_holdem_hand_summary_primary_key" )
2012/04/24 17:59:05.453: [000019F4][Query] Query execution time: 4240.22485017 ms

[kraada]

This troubleshooting guide explains how to fix that error.

[dakky316]

thank you very much sir, shall try that!

[gavind]

thank you very much sir, shall try that!

Hi buddy, were you able to sort this out by any chance?