[Postgres-xl-general] Can't drop database
ajackson at revionics.com
Fri Sep 19 21:51:12 PDT 2014
This problem appears to have reappeared. Simple process that uses about 4 threads to load data into the database concurrently. At one point, the load failed due to timeout and I began to query pg_stat_activity on the underlying datanodes.
All 6 datanodes had the following query reported ...
RESET ALL;RESET SESSION AUTHORIZATION;RESET transaction_isolation;
Coord2 and Coord3 also reported the same query. Coord1 had no such query running.
When I tried to drop the database I was told there was 1 prepared transaction using the database. Now, I will go through and hunt down the errant node and reset it but this is exactly what happened last time. And it only appears to happen when I'm doing dataload via copy on more than one table concurrently.
From: Mason Sharp [msharp at translattice.com]
Sent: Wednesday, August 20, 2014 4:19 PM
To: Aaron Jackson
Cc: postgres-xl-general at lists.sourceforge.net
Subject: Re: [Postgres-xl-general] Can't drop database
On Tue, Aug 5, 2014 at 12:42 PM, Aaron Jackson <ajackson at revionics.com<mailto:ajackson at revionics.com>> wrote:
One last note,
So, for example, you have a directory with the following files:
And corresponding tables. Assuming that B has a FK relationship with C, it will load as follows:
A|C -> B
Where A and C are done in parallel and B is done after C has completed. We use the COPY command and to my knowledge, nothing else is special.
Can you please clarify this? C refers to B, but you load C first? I am assuming that means you only load C, but do not yet create the foreign key constraint to B? Or did you actually mean that B refers to C?
Anyway, the loading in parallel should not matter. We can try to reproduce this if you clarify.
Can you provide any other details, like, is B replicated? All are hash distributed on their primary key, etc.?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgres-xl-general