>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?
And what is in the postgresql.log? That would be your biggest clue as to the cause of the problem. Melvin Davidson ________________________________ From: roctaiwan <[email protected]> To: [email protected] Sent: Monday, September 28, 2009 2:17:00 AM Subject: Re: [Slony1-general] copying large file won't get replicate 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
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
