"ERROR: concurrent delete in progress" during CLUSTER operat

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

"ERROR: concurrent delete in progress" during CLUSTER operat

Postby Azrael1018 » Thu Dec 03, 2009 6:59 pm

when I do housekeeping, the housekeeping appears to go through all 4 stages (4 hours worth), then I get the error mentioned in header with reference to the Cluster operation (sorry, right now I am not going to go through another 4 hours to get exact wording!)

This has happened for quite a while.

I just tried purging players with no hands using the latest PT3 version (3.00 beta 29.1). After many hours, finished with no errors. Then I tried housekeeping again to see how it helped my DB and once again got the error.

I decided to try using PgAdmin III (1.8.4) to individually cluster each table. Every table CLUSTERed successfully withe exception of the player table. I got an error in the messages window stating
----------------------
ERROR: concurrent delete in progress

********** Error **********

ERROR: concurrent delete in progress
SQL state: XX000
--------------------

. My player table show 358924 rows. Is that the number of players in my DB? I was hoping the purge would get rid of some. Maybe if I can get the cluster to work, it will :)

I am using PostgreSQL ver 8.3, Windows XP SP3

Help!
Azrael1018
 
Posts: 9
Joined: Mon Mar 17, 2008 7:15 pm

Re: "ERROR: concurrent delete in progress" during CLUSTER operat

Postby WhiteRider » Fri Dec 04, 2009 4:50 am

Please attach the files from the relevent time in the C:/Program Files/PostgreSQL/8.3/data/pg_log folder to a Support ticket so that we can investigate.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: "ERROR: concurrent delete in progress" during CLUSTER operat

Postby Azrael1018 » Fri Dec 04, 2009 11:24 am

Logs submitted with reference to:

http://www.pokertracker.com/support/tic ... t_id=75909

David
Azrael1018
 
Posts: 9
Joined: Mon Mar 17, 2008 7:15 pm

Re: "ERROR: concurrent delete in progress" during CLUSTER operat

Postby kraada » Fri Dec 04, 2009 11:32 am

Thanks, we'll get back to you in your ticket.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 19 guests

cron
highfalutin