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?
[postg...@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 > [email protected] > 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. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
