Mon Sep 28 00:17:00 PDT 2009
- Previous message: [Slony1-general] copying large file won't get replicate
- Next message: [Slony1-general] copying large file won't get replicate
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Just got this error when I am running the COPY again today. This error appear about 20 mins after whole 10M records inserted to Master. what does it mean? [postgres at Slave-DB1-Slony-I ~]$ WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. NOTICE: Slony-I: cleanup stale sl_nodelock entry for pid=925 CONTEXT: SQL statement "SELECT "_sql_cluster".cleanupNodelock()" PL/pgSQL function "cleanupevent" line 77 at PERFORM Jan Wieck wrote: > > On 9/25/2009 6:36 AM, roctaiwan wrote: >> Here is my concern. I copying both 10k and 1million of records with >> success, >> but why can't 10Million records? Is this has something to do with my >> memory >> size, which loading 10Million of records is too much for my server to >> handle? > > How long does it take Slony to copy those 1M rows? > > Are there any error messages in the slon log? > > > Jan > > -- > Anyone who trades liberty for security deserves neither > liberty nor security. -- Benjamin Franklin > _______________________________________________ > Slony1-general mailing list > Slony1-general at lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general > > -- View this message in context: http://www.nabble.com/copying-large-file-won%27t-get-replicate-tp25609853p25641479.html Sent from the Slony-I -- General mailing list archive at Nabble.com.
- Previous message: [Slony1-general] copying large file won't get replicate
- Next message: [Slony1-general] copying large file won't get replicate
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list