same old error...plus a new one! YAY!

[themightyjim2k]

this what I'm getting:

2008/08/09 17:17:52: Connection Lost to Database: PT3 DB(Line #79)
2008/08/09 17:17:52: Connection Lost to Database: PT3 DB(Line #95)
2008/08/09 17:17:52: Full Tilt: Unable to import hand (#7578936850). Reason: Unable to execute query: COPY holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (PANIC: right sibling's left-link doesn't match CONTEXT: COPY holdem_hand_player_statistics, line 4: "760438 14593 14593 0 30 73668 2008/08/09 20:52:26 1 f f 0 f 0 f t f f f 0 f 0 f f f f f 0 f 0 f f f ..." )


and PT3 is stopping the autimport and often freezing. wheeeeeee

[WhiteRider]

Ooh, that's a good one!
Are you able to use the main window reports?
Have you got a back up of your hand history files, just in case?
You might want to try cluster/vacuum/analyse your database - that seems to fix some of these type of issues.

[themightyjim2k]

yeah I am.

i just did the old, cluster, vaccuum, analyze thing two days ago, so i really dont want to do it again oh well

[WhiteRider]

Were you having problems before that? Did it help?
There may be something else that can be done, but that seems to be able to repair corrupt indexes and stuff like that..

[themightyjim2k]

i was having the COPY error, but not the disconnecting from db error.

afterwards it ran well for about a day. and then started giving me crap again today.

[APerfect10]

Try creating a new database and re-importing your hands. I think that will resolve the issue.

We are still looking into this problem but I *think* it is due to the altering of the database with Beta 15.

Best regards,

Derek