Unable to execute query

[pokerplayer7]

The following error occurs from time to time when clustering after importing from a text file of pokerstars.

Unable to execute query: SELECT val_icon FROM player
WHERE id_player=2;; Reason: Fatal Error (ERROR:
could not open relation with OID 55612 )

Have to kill the pokertracker process, restart pokertracker, Vacuum Active Database, Analyze Active database so that the cluster
database can be completed without error. This only happens in v3.00 beta 15.

[WhiteRider]

Please enable logging, and next time you see this attach your PokerTracker.log file to a ticket on the Support system , and link to this thread.

[pokerplayer7]

Please enable logging, and next time you see this attach your PokerTracker.log file to a ticket on the Support system , and link to this thread.

2008/08/11 23:46:54.597: [- Main -][System] PokerTracker v3.00 beta 15
2008/08/11 23:46:54.657: [- Main -][SystemInfo] Windows Version: 5.0 build 2195 (platform 2) Service Pack 4
2008/08/11 23:46:54.717: [- Main -][SystemInfo] C:\ Disk Space: 78,160 mb total; 63,708 mb used; 14,452 mb free
2008/08/11 23:46:54.967: [- Main -][SystemInfo] Processor 1: Speed: 0.94 GHz
2008/08/11 23:46:55.027: [- Main -][SystemInfo] Configuration: [WindowInfo]\nMainMaximized=Y\n\n\n[General]\nLogging=Y\n\n\n[Import]\nBeepOnCompletion=Y\nClusterOnCompletion=Y\nMoveProcessedFilesDirectory=C:\Program Files\PokerTracker 3\Processed\nIncludeSubDirectories=Y\nAnalyzeOnCompletion=Y\nCloseOnCompletion=N\nStartHud=Y\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]\nAutoPlayHands=N\nShowKnownCards=Y\n\n[Tabs]\nLast:WindowMain=1\nLast:WindowImport=1\nLast:WindowStats:Holdem=0\nLast:WindowStatsTab:holdem-cash=1\nLast:WindowStatsTab:holdem-tourney=0\n[TableTracker]\nMinPlayers=1\nMaxPlayers=10\nHideTablesNoStats=Y\n[Directories]\nManualImportFile=C:\Program Files\PokerStars\HandHistory\ChrisConroe\*\n
2008/08/11 23:46:55.077: [- Main -][System] Getting String: 2C02-FF6F
2008/08/11 23:46:55.668: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/regcheck.php
2008/08/11 23:46:55.718: [00009264][ConnectorThread::Entry] Beginning thread.
2008/08/11 23:47:00.695: [- Main -][Registration] Unable to communicate with server
2008/08/11 23:47:00.806: [- Main -][System] Registered: false
2008/08/11 23:47:07.035: [00009272][WindowSplash::Worker::Entry] Beginning thread.
2008/08/11 23:47:07.065: [00009272][QueryManager] Loading stats
2008/08/11 23:47:21.385: [00009272][QueryManager] Stats loaded.
2008/08/11 23:47:21.425: [00009272][QueryManager] Loading queries
2008/08/11 23:47:21.505: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Aliases.xml.pte
2008/08/11 23:47:21.585: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Hand-Detail.xml.pte
2008/08/11 23:47:21.826: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Hand-Summary.xml.pte
2008/08/11 23:47:21.956: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Notes.xml.pte
2008/08/11 23:47:22.026: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Players.xml.pte
2008/08/11 23:47:26.242: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-BBWon.xml.pte
2008/08/11 23:47:26.412: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-MoneyWon.xml.pte
2008/08/11 23:47:26.573: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-ShowdownNoShowdown.xml.pte
2008/08/11 23:47:26.753: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Players.xml.pte
2008/08/11 23:47:26.853: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-Hands-Graph.xml.pte
2008/08/11 23:47:26.983: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Summary-Site.xml.pte
2008/08/11 23:47:27.093: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer-Detail.xml.pte
2008/08/11 23:47:27.824: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer.xml.pte
2008/08/11 23:47:28.205: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph-Month.xml.pte
2008/08/11 23:47:28.275: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph.xml.pte
2008/08/11 23:47:28.335: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Graphs-MoneyWon.xml.pte
2008/08/11 23:47:28.485: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Players.xml.pte
2008/08/11 23:47:28.576: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Tournaments-Hands-Graph.xml.pte
2008/08/11 23:47:28.706: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer-Detail.xml.pte
2008/08/11 23:47:29.327: [00009272][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer.xml.pte
2008/08/11 23:47:29.767: [00009272][QueryManager] Queries loaded.
2008/08/11 23:47:29.797: [00009272][StatManager] Loading stats and reports...
2008/08/11 23:47:30.739: [00009272][StatManager] Stats and reports loaded.
2008/08/11 23:47:30.779: [00009272][FilterManager] Loading filters...
2008/08/11 23:47:31.530: [00009272][FilterManager] Filters loaded.
2008/08/11 23:47:31.570: [00009272][LayoutManager] Loading layouts...
2008/08/11 23:47:31.590: [00009272][LayoutManager] Layouts loaded.
2008/08/11 23:47:31.620: [00009272][StatManager] Loading stats and reports...
2008/08/11 23:47:32.431: [00009272][StatManager] Stats and reports loaded.
2008/08/11 23:47:32.471: [00009272][PostgresConnection] Connecting to database: PT3 DB
2008/08/11 23:47:34.224: [00009272][PostgresConnection] [0x02b9a258] Successfully connected to: PT3 DB [42605024]
2008/08/11 23:47:37.268: [00009272][ConnectionManager] Database Version: 300030
2008/08/11 23:47:37.608: [00009272][PostgresConnection] Connecting to database: PT3 DB
2008/08/11 23:47:40.643: [00009272][PostgresConnection] [0x02bb1fb8] Successfully connected to: PT3 DB [45817104]
2008/08/11 23:47:40.683: [00009272][PostgresConnection] Connecting to database: PT3 DB
2008/08/11 23:47:41.784: [00009272][PostgresConnection] [0x02bb15b0] Successfully connected to: PT3 DB [42605544]
2008/08/11 23:47:41.835: [00009272][PostgresConnection] Connecting to database: PT3 DB
2008/08/11 23:47:42.836: [00009272][PostgresConnection] [0x02ba3750] Successfully connected to: PT3 DB [45758728]
2008/08/11 23:48:01.733: [00009372][Query] Connecting to database: PokerTracker 3 Database
2008/08/11 23:48:01.783: [00009372][Query] Executing SQL: SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in ( SELECT DISTINCT holdem_table_session_summary.id_player FROM holdem_table_session_summary WHERE 1=1 ) ORDER BY player_name_search asc
2008/08/11 23:48:06.019: [00009372][Query] Query execution time: 4196.35596144 ms : SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in ( SELECT DISTINCT holdem_table_session_summary.id_player FROM holdem_table_session_summary WHERE 1=1 ) ORDER BY player_name_search asc
2008/08/11 23:48:14.992: [00009244][ImportManual::ImportManualFeeder::Entry] Beginning thread.
2008/08/11 23:48:15.032: [00009244][ImportManual] Message: Import beginning
2008/08/11 23:48:15.112: [00009244][HandHistoryDatabaseImport::DatabaseVariables] Getting connections
2008/08/11 23:48:19.779: [00009388][HandHistoryDatabaseImport::DatabaseVariables::Entry] Beginning thread.
2008/08/11 23:48:19.879: [00009244][ImportManual] Message: Import file: C:\Program Files\PokerStars\HandHistory\ChrisConroe\HH20080811 Watsonia III fast, no all-in - $0.05-$0.10 - No Limit Hold'em.txt
2008/08/11 23:48:25.307: [00009244][ImportManual] Message: + Complete (37 hands, 0 errors, 0 duplicates)
2008/08/11 23:48:25.337: [00009244][ImportManual] Message: Import file: C:\Program Files\PokerStars\HandHistory\ChrisConroe\HH20080811 Amaryllis fast, no all-in - $0.05-$0.10 - No Limit Hold'em.txt
2008/08/11 23:48:30.515: [00009244][ImportManual] Message: + Complete (58 hands, 0 errors, 0 duplicates)
2008/08/11 23:48:30.565: [00009244][ImportManual] Message: Import file: C:\Program Files\PokerStars\HandHistory\ChrisConroe\HH20080811 Amherstia no all-in - $0.02-$0.05 - No Limit Hold'em.txt
2008/08/11 23:48:31.426: [00009244][ImportManual] Message: + Complete (11 hands, 0 errors, 0 duplicates)
2008/08/11 23:48:31.486: [00009244][ImportManual] Message: Import file: C:\Program Files\PokerStars\HandHistory\ChrisConroe\HH20080811 Feronia III no all-in - $0.02-$0.05 - No Limit Hold'em.txt
2008/08/11 23:48:31.887: [00009244][ImportManual] Message: + Complete (5 hands, 0 errors, 0 duplicates)
2008/08/11 23:48:32.057: [00009244][ImportManual] Message: Import file: C:\Program Files\PokerStars\HandHistory\ChrisConroe\HH20080811 Gemma IV fast, no all-in - $0.05-$0.10 - No Limit Hold'em.txt
2008/08/11 23:48:34.510: [00009244][ImportManual] Message: + Complete (58 hands, 0 errors, 0 duplicates)
2008/08/11 23:48:34.590: [00009244][ImportManual] Message: Import file: C:\Program Files\PokerStars\HandHistory\ChrisConroe\HH20080811 Meissa no all-in - $0.02-$0.05 - No Limit Hold'em.txt
2008/08/11 23:48:36.964: [00009244][ImportManual] Message: + Complete (18 hands, 0 errors, 0 duplicates)
2008/08/11 23:48:37.084: [00009244][ImportManual] Message: Import file: C:\Program Files\PokerStars\HandHistory\ChrisConroe\HH20080811 Radegast no all-in - $0.02-$0.05 - No Limit Hold'em.txt
2008/08/11 23:48:38.296: [00009244][ImportManual] Message: + Complete (17 hands, 0 errors, 0 duplicates)
2008/08/11 23:48:38.426: [00009244][ImportManual] Message: Import file: C:\Program Files\PokerStars\HandHistory\ChrisConroe\HH20080811 Tergeste II fast, no all-in - $0.05-$0.10 - No Limit Hold'em.txt
2008/08/11 23:48:46.608: [00009244][ImportManual] Message: + Complete (84 hands, 0 errors, 0 duplicates)
2008/08/11 23:48:46.668: [00009244][ImportManual] Message: Import file: C:\Program Files\PokerStars\HandHistory\ChrisConroe\HH20080811 Utopia fast, no all-in - $0.02-$0.05 - No Limit Hold'em.txt
2008/08/11 23:48:50.413: [00009244][ImportManual] Message: + Complete (91 hands, 0 errors, 0 duplicates)
2008/08/11 23:48:50.463: [00009244][ImportManual] Message: Import file: C:\Program Files\PokerStars\HandHistory\ChrisConroe\HH20080811 Alhena fast, no all-in - $0.02-$0.05 - No Limit Hold'em.txt
2008/08/11 23:48:51.735: [00009244][ImportManual] Message: + Complete (21 hands, 0 errors, 0 duplicates)
2008/08/11 23:48:51.775: [00009244][ImportManual] Message: Import complete. 400 hands in 10 files were imported. (0 errors, 0 duplicates)
2008/08/11 23:48:52.136: [00009388][DatabaseVariables::Entry] 0 queries remain.
2008/08/11 23:48:52.336: [00009244][ImportManualWorker] Feeder exiting.
2008/08/11 23:48:52.546: [00009388][PostgresConnection] Cluster Executing: BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;
2008/08/11 23:48:52.586: [00009388][PostgresConnection] Cluster Executing: LOCK TABLE "holdem_hand_player_combinations", "holdem_hand_player_detail", "holdem_hand_player_statistics", "holdem_hand_summary", "holdem_table_session_summary", "player" IN ACCESS EXCLUSIVE MODE;
2008/08/11 23:48:52.606: [00009388][PostgresConnection] Cluster Executing: CREATE TABLE "new_holdem_hand_player_combinations" AS SELECT * FROM "holdem_hand_player_combinations" ORDER BY id_player DESC, id_hand DESC;
2008/08/11 23:48:52.696: [00009384][QueryReportCtrl] Query load time: 45145 ms
2008/08/11 23:48:52.917: [00009400][ThreadDestroyer::Entry] Beginning thread.
2008/08/11 23:49:05.074: [00009388][PostgresConnection] Cluster Executing: DROP TABLE "holdem_hand_player_combinations";
2008/08/11 23:49:05.315: [00009388][PostgresConnection] Cluster Executing: ALTER TABLE "new_holdem_hand_player_combinations" RENAME TO "holdem_hand_player_combinations";
2008/08/11 23:49:05.395: [00009388][PostgresConnection] Cluster Executing: CREATE INDEX "hhpc:idx1-id_hand" ON "holdem_hand_player_combinations" USING btree (id_hand);
2008/08/11 23:49:07.578: [00009388][PostgresConnection] Cluster Executing: CREATE INDEX "hhpc:idx2-id_player" ON "holdem_hand_player_combinations" USING btree (id_player);
2008/08/11 23:49:08.880: [00009388][PostgresConnection] Cluster Executing: ALTER TABLE "holdem_hand_player_combinations" ADD CONSTRAINT holdem_hand_player_combinations_primary_key PRIMARY KEY (id_hand, id_player), OWNER TO "postgres";
2008/08/11 23:49:10.562: [00009388][PostgresConnection] Cluster Executing: CREATE TABLE "new_holdem_hand_player_detail" AS SELECT * FROM "holdem_hand_player_detail" ORDER BY id_player DESC, id_hand DESC;
2008/08/11 23:50:47.071: [00009388][PostgresConnection] Cluster Executing: DROP TABLE "holdem_hand_player_detail";
2008/08/11 23:50:47.361: [00009388][PostgresConnection] Cluster Executing: ALTER TABLE "new_holdem_hand_player_detail" RENAME TO "holdem_hand_player_detail";
2008/08/11 23:50:47.411: [00009388][PostgresConnection] Cluster Executing: CREATE INDEX "hhpd:idx1-id_hand" ON "holdem_hand_player_detail" USING btree (id_hand);
2008/08/11 23:51:02.143: [00009388][PostgresConnection] Cluster Executing: CREATE INDEX "hhpd:idx2-id_player" ON "holdem_hand_player_detail" USING btree (id_player);
2008/08/11 23:51:17.154: [00009388][PostgresConnection] Cluster Executing: ALTER TABLE "holdem_hand_player_detail" ADD CONSTRAINT holdem_hand_player_detail_primary_key PRIMARY KEY (id_player, id_hand),OWNER TO "postgres";
2008/08/11 23:51:41.649: [00009388][PostgresConnection] Cluster Executing: CREATE TABLE "new_holdem_hand_player_statistics" AS SELECT * FROM "holdem_hand_player_statistics" ORDER BY id_player DESC, id_session DESC, id_hand DESC;
2008/08/11 23:52:45.321: [00009388][PostgresConnection] Cluster Executing: DROP TABLE "holdem_hand_player_statistics";
2008/08/11 23:52:45.581: [00009388][PostgresConnection] Cluster Executing: ALTER TABLE "new_holdem_hand_player_statistics" RENAME TO "holdem_hand_player_statistics";
2008/08/11 23:52:45.681: [00009388][PostgresConnection] Cluster Executing: CREATE INDEX "hhps:idx1-id_hand" ON "holdem_hand_player_statistics" USING btree (id_hand);
2008/08/11 23:52:56.777: [00009388][PostgresConnection] Cluster Executing: CREATE INDEX "hhps:idx2-id_player" ON "holdem_hand_player_statistics" USING btree (id_player);
2008/08/11 23:53:07.954: [00009388][PostgresConnection] Cluster Executing: CREATE INDEX "hhps:idx3-id_limit" ON "holdem_hand_player_statistics" USING btree (id_limit);
2008/08/11 23:53:22.234: [00009388][PostgresConnection] Cluster Executing: CREATE INDEX "hhps:idx4-date_played" ON "holdem_hand_player_statistics" USING btree (date_played);
2008/08/11 23:53:35.934: [00009388][PostgresConnection] Cluster Executing: CREATE INDEX "hhps:idx5-id_session" ON "holdem_hand_player_statistics" USING btree (id_session);
2008/08/11 23:53:51.166: [00009388][PostgresConnection] Cluster Executing: CREATE INDEX "hhps:idx6-position" ON "holdem_hand_player_statistics" USING btree ("position");
2008/08/11 23:54:04.735: [00009388][PostgresConnection] Cluster Executing: ALTER TABLE "holdem_hand_player_statistics" ADD CONSTRAINT holdem_hand_player_statistics_primary_key PRIMARY KEY (id_player, id_hand), OWNER TO "postgres";
2008/08/11 23:54:22.601: [00009388][PostgresConnection] Cluster Executing: CREATE TABLE "new_holdem_hand_summary" AS SELECT * FROM "holdem_hand_summary" ORDER BY id_site, id_limit, id_table, id_hand DESC;
2008/08/11 23:54:27.578: [00009388][PostgresConnection] Cluster Executing: DROP TABLE "holdem_hand_summary";
2008/08/11 23:54:27.918: [00009388][PostgresConnection] Cluster Executing: ALTER TABLE "new_holdem_hand_summary" RENAME TO "holdem_hand_summary";
2008/08/11 23:54:27.969: [00009388][PostgresConnection] Cluster Executing: CREATE INDEX "hhs:idx1-date_played" ON "holdem_hand_summary" USING btree (date_played);
2008/08/11 23:54:30.452: [00009388][PostgresConnection] Cluster Executing: CREATE INDEX "hhs:idx2-id_limit" ON "holdem_hand_summary" USING btree (id_limit);
2008/08/11 23:54:31.844: [00009388][PostgresConnection] Cluster Executing: CREATE INDEX "hhs:idx3-hand_no" ON "holdem_hand_summary" USING btree (hand_no);
2008/08/11 23:54:33.927: [00009388][PostgresConnection] Cluster Executing: ALTER TABLE "holdem_hand_summary" ADD CONSTRAINT holdem_hand_summary_primary_key PRIMARY KEY (id_hand), ADD CONSTRAINT "hhs-unique_hand_no" UNIQUE (id_site, hand_no), OWNER TO "postgres";
2008/08/11 23:54:37.192: [00009388][PostgresConnection] Cluster Executing: CREATE TABLE "new_holdem_table_session_summary" AS SELECT * FROM "holdem_table_session_summary" ORDER BY id_player DESC, id_session DESC;
2008/08/11 23:54:38.193: [00009388][PostgresConnection] Cluster Executing: DROP TABLE "holdem_table_session_summary";
2008/08/11 23:54:38.283: [00009388][PostgresConnection] Cluster Executing: ALTER TABLE "new_holdem_table_session_summary" RENAME TO "holdem_table_session_summary";
2008/08/11 23:54:38.313: [00009388][PostgresConnection] Cluster Executing: CREATE INDEX "htss:idx1-id_player" ON "holdem_table_session_summary" USING btree (id_player);
2008/08/11 23:54:38.594: [00009388][PostgresConnection] Cluster Executing: CREATE INDEX "htss:idx2-id_table" ON "holdem_table_session_summary" USING btree (id_table);
2008/08/11 23:54:38.884: [00009388][PostgresConnection] Cluster Executing: ALTER TABLE "holdem_table_session_summary" ADD CONSTRAINT holdem_table_session_summary_primary_key PRIMARY KEY (id_session), OWNER TO "postgres";
2008/08/11 23:54:39.265: [00009388][PostgresConnection] Cluster Executing: CREATE TABLE "new_player" AS SELECT * FROM "player" ORDER BY id_site, id_player DESC;
2008/08/11 23:54:39.926: [00009388][PostgresConnection] Cluster Executing: DROP TABLE "player";
2008/08/11 23:54:39.996: [00009388][PostgresConnection] Cluster Executing: ALTER TABLE "new_player" RENAME TO "player";
2008/08/11 23:54:40.046: [00009388][PostgresConnection] Cluster Executing: CREATE INDEX "idx1:player_name_search" ON "player" USING btree (player_name_search);
2008/08/11 23:54:41.017: [00009388][PostgresConnection] Cluster Executing: ALTER TABLE "player" ADD CONSTRAINT player_primary_key PRIMARY KEY (id_player), OWNER TO "postgres";
2008/08/11 23:54:41.338: [00009388][PostgresConnection] Cluster Executing: COMMIT;
2008/08/11 23:54:41.618: [- Main -][PostgresConnection (Error)] Unable to execute query: SELECT val_icon FROM player WHERE id_player=2;; Reason: Fatal Error (ERROR: could not open relation with OID 63802 )

[WhiteRider]

Thanks - did you create a ticket for this too?
Please do, to make sure this doesn't get missed.