Tue Nov 15 04:39:27 PST 2011
- Previous message: [Slony1-general] (no subject)
- Next message: [Slony1-general] drop table error
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi all, We have a master and a slave DB server (both PostgreSQL 8.3, Slony 2.0.1). Maybe we were hasty, because we delete ~18 million rows from a table on master with one SQL command. Slony log and transfer jobs/transactions to the slave node, but on the slave node the slony can't do this job. Slony starts the transaction, but after ~7 million delete commands the server close the connection. We found this in the Slony log: 2011-11-15 11:39:25 CET DEBUG4 remoteHelperThread_1_1: fetch from cursor 2011-11-15 11:39:25 CET ERROR remoteHelperThread_1_1: "fetch 500 from LOG; " server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. 2011-11-15 11:39:25 CET DEBUG4 remoteHelperThread_1_1: return 50 unused line buffers 2011-11-15 11:39:25 CET ERROR remoteWorkerThread_1: "close LOG; " PGRES_FATAL_ERROR 2011-11-15 11:39:25 CET ERROR remoteWorkerThread_1: "rollback transaction; set enable_seqsca n = default; set enable_indexscan = default; " PGRES_FATAL_ERROR 2011-11-15 11:39:25 CET DEBUG1 remoteHelperThread_1_1: 2850.992 seconds until close cursor 2011-11-15 11:39:25 CET INFO remoteHelperThread_1_1: inserts=0 updates=0 deletes=7220000 We tried to tuning the PostgreSQL and now two times faster, but every transaction stop after ~ 7 million rows. We couldn't find error message in the PostgreSQL log. Why stop the transaction? What should we do? Thank you in advance, Kyp -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20111115/a5272fbc/attachment.htm
- Previous message: [Slony1-general] (no subject)
- Next message: [Slony1-general] drop table error
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list