[Postgres-xl-general] orphan temp tables
Pavan Deolasee
pavan.deolasee at gmail.com
Thu Nov 13 21:42:48 PST 2014
Hi Aaron,
We fixed a bug in the master branch which could cause such errors. I wonder
if the code that you're running has that fix.
commit 70c6306f2c0e3ede6c9348659cf0840f4ca7f087
Author: Pavan Deolasee <pavan.deolasee at gmail.com>
Date: Mon Oct 20 16:26:15 2014 +0530
Handle TEMP relations appropriately.
There were couple of places where the check for MyCoordId was missing.
This was
leaving buffers of temporary tables in the buffer cache, even after a
table is
dropped/truncated. Later when the buffer is chosen for eviction, it
will fail
to write the buffer and report an error. Similar issues can also lead
to fsync
failure.
Per report from Jov. Investigation and fixes by me
Thanks,
Pavan
On Fri, Nov 14, 2014 at 8:13 AM, Aaron Jackson <ajackson at revionics.com>
wrote:
> A colleague of mine was creating temp tables on a XL cluster
> and noticed that after running his process several times, he would start
> getting error messages of the following form:
>
> could not open file "base/27028/41153": No such file or directory
> Severity: ERROR
> Code: 58P01
>
> After doing a little research, this appears to be an error that occurs
> with orphaned temp tables. Is it possible that the pooled nature of the
> coordinators to datanodes leaves a lingering effect after the temporary
> table has been presumably dropped?
>
> *Aaron*
>
>
> ------------------------------------------------------------------------------
> Comprehensive Server Monitoring with Site24x7.
> Monitor 10 servers for $9/Month.
> Get alerted through email, SMS, voice calls or mobile push notifications.
> Take corrective actions from your mobile device.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xl-general mailing list
> Postgres-xl-general at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/postgres-xl-general
>
>
--
Pavan Deolasee
http://www.linkedin.com/in/pavandeolasee
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20141114/e3954f5c/attachment.htm>
More information about the postgres-xl-general
mailing list