Purge Hands?

[Seimon]

Is it possible to purge Hands?

Yesterday following happend:
Auto Import had an error and missed some hands.
So i purged the session and manually imported it.
Then there were a lot of errors. (Think i forgot to purge players and hands from others then me maybe??)
So i purged all sessions and all players and reimported it all.
Worked fine but not for the last 2 sessions. There were duplicates.
I saw the sessions in the session view but it said "0 hands" amount won "0" but below there was a the list of the played hands with winnings and all.
I did it again (purge all, import) but without the last 2 sessions.

Situation now:
The old sessions are all fine.
I see the hands of the 2 sessions in the hands view and in the summary and in the graph.
In the session view i dont see them.
I cannot set currency for them.
If i try to import them again i get the duplicates, cause they are somewhere there.
-> I have hands without sessions in my DB.

So my question:
Is it possible to purge this certain hands?
Or at least possible to purge _all_ hands? (Purgin all sessions seems not to do this ?? )

[kraada]

It's not possible to purge individual hands but you can purge hands by session, limit, or date - see the Tutorial: Selective Purge for details on how to use these functions.

[Seimon]

I've done exactly this.

Purge by date. All hands since 15.2.
Vaccuum, analyze, rebuild cache.
Refresh data.

The hands are still there. Even the hands from 16.2.


I think it doesnt work, cause it says "purge sessions" even in the advanced tab. And the hands dont belong to any session.

[kraada]

How large is this database in total?

[Seimon]

23304 hands (the orphan hands included. without 21998) so quite small.

[kraada]

Given a database that small what might be easiest is exporting the hands and reimporting them - it should only take a few minutes to reimport and perform housekeeping on a database that size. If those hands aren't in a session they shouldn't be caught in an export by session either.

[Seimon]

trial version

i would make a new db and import all hands, but i cant.

so how do can i clean my db with the trial version? and why would dont you allow that???

[Seimon]

Ok, think i figured it out.
I have a problem with 2 Hand Historys.

I cleaned my DB:
TRUNCATE TABLE holdem_cache;
TRUNCATE TABLE holdem_hand_histories;
TRUNCATE TABLE holdem_hand_player_combinations;
TRUNCATE TABLE holdem_hand_player_detail;
TRUNCATE TABLE holdem_hand_player_statistics;
TRUNCATE TABLE holdem_hand_summary;
TRUNCATE TABLE holdem_limit;
TRUNCATE TABLE holdem_table;
TRUNCATE TABLE holdem_table_session_summary;

Imported all the "old" HH. Worked fine again. No orphan hands.
Imported the 2 "new" HH. Lots of Errors.

Cleaned all again and inserted only the "new".

postgresql log says:

2012-02-16 20:47:34 CET ERROR: numeric field overflow
2012-02-16 20:47:34 CET DETAIL: A field with precision 9, scale 2 must round to an absolute value less than 10^7.
2012-02-16 20:47:34 CET STATEMENT: BEGIN;INSERT INTO holdem_table_session_summary VALUES(
[...]
INSERT INTO holdem_table_session_summary VALUES(71, 100, 68, 68, 1, 1, '2012/02/16 01:19:29', '2012/02/16 01:44:44', 26, 3, 485516.00, 33400.00, 0.00, 0.00, 22, 7, 122, 0, FALSE, 0);COMMIT;
2012-02-16 20:47:34 CET ERROR: current transaction is aborted, commands ignored until end of transaction block
2012-02-16 20:47:34 CET STATEMENT: BEGIN;COMMIT;
2012-02-16 20:47:43 CET NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "holdem_cache_primary_key" for table "holdem_cache"
2012-02-16 20:47:44 CET ERROR: duplicate key value violates unique constraint "settings_primary_key"
2012-02-16 20:47:44 CET STATEMENT: INSERT INTO settings VALUES('cache_update:holdem', '667');
2012-02-16 20:47:52 CET ERROR: current transaction is aborted, commands ignored until end of transaction block



Shall I create a support ticket? Its about 1300 Hands.

[Seimon]

Ok, so now i fixed it.

From:

Code: Select all

CREATE TABLE holdem_table_session_summary
(
  id_session integer NOT NULL,
  id_site smallint,
  id_player integer,
  id_player_real integer,
  id_limit integer,
  id_table integer,
  date_start timestamp without time zone,
  date_end timestamp without time zone,
  cnt_minutes integer,
  seat integer,
  amt_pot numeric(9,2),
  amt_won numeric(9,2),
  amt_rake numeric(9,2),
  amt_mgr numeric(9,2),
  cnt_hands integer,
  cnt_hands_won integer,
  cnt_ttl_players integer,
  cnt_ttl_players_flop integer,
  flg_note boolean,
  val_curr_conv numeric(12,8) DEFAULT 0,
  CONSTRAINT holdem_table_session_summary_primary_key PRIMARY KEY (id_session)
)
WITH (OIDS=FALSE);
ALTER TABLE holdem_table_session_summary OWNER TO postgres;

I changed the 4 Columns from:

Code: Select all

  amt_pot numeric(9,2),
  amt_won numeric(9,2),
  amt_rake numeric(9,2),
  amt_mgr numeric(9,2),

to:

Code: Select all

  amt_pot numeric(11,2),
  amt_won numeric(11,2),
  amt_rake numeric(11,2),
  amt_mgr numeric(11,2),

Then i could import the 2 sessions and now everthing is fine :)

I'm not sure what the problem was, cause the biggest pot was "only" 380.000 .
Whatever, if you want to know what happened here, tell me what you need.

[Seimon]

And finally I solved the last "riddle".
The problem was the column "amt_pot" (is this the sum of all pots at this table?) which was about 13Million at both sessions, an therefore bigger then 10^7.