Quote:
Originally Posted by PokerTracker
Sounds like you did not update your database when you were asked to by the warning message. To be safe:
1) Restart your computer
2) Start PT4
3) When the Update Database dialog appears, click ok to update your database
when this is complete, lets do some basic maintenance just to be safe
1) From the Database Menu select Database Management
2) Click Housekeeping, Select Vacuum & Analyze
3) When this is complete, click Housekeeping and select Reindex
4) Finally click Rebuild Cache
Whatever caused this issue should now be solved, and your database should be in great working order once again!
- TT
Hi TT,
When updating the database, the following message popped up:
Error updating database: PokerTracker 4 Database
Error:
Unable to execute query: ALTER TABLE cash_hand_summary DROP CONSTRAINT cash_hand_summary_primary_key;
ALTER TABLE cash_hand_summary ADD CONSTRAINT cash_hand_summary_primary_key PRIMARY KEY(id_hand, id_limit);
ALTER TABLE cash_hand_summary DROP CONSTRAINT "ohs-unique_hand_no";
ALTER TABLE cash_hand_summary ADD CONSTRAINT "ohs-unique_hand_no" UNIQUE(hand_no, id_site);
DROP INDEX "ohs:idx3-hand_no";
CREATE INDEX "chs:idx3-id_winner" ON cash_hand_summary USING btree (id_winner);
DROP INDEX "chps:idx4-id_limit";
CREATE INDEX "chps:idx4-id_limit" ON cash_hand_player_statistics USING btree (id_limit);
ALTER TABLE cash_hand_player_statistics CLUSTER ON "chps:idx2-id_player";
ALTER TABLE cash_table_session_summary CLUSTER ON cash_table_session_summary_primary_key;
DROP INDEX "chps:idx8-date_played_utc"
; Reason: Fatal Error (ERROR: out of memory DETAIL: Failed on request of size 268435456. )
What´s going on and what can I do?
Thanks,
Ben
EDIT:
Also, I just tried to do housekeeping / vaccum and analyze, and I now got this message:
Unable to execute query: VACUUM ANALYZE;; Reason: Fatal Error (ERROR: out of memory DETAIL: Failed on request of size 536870910. )
Last edited by boywonder; 07-10-2012 at 09:32 AM.