<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:tahoma,new york,times,serif;font-size:12pt">>Just got this error when I am running the COPY again today. This error appear<br>>about 20 mins after whole 10M records inserted to Master. what does it mean?<br><div><br>And what is in the postgresql.log? That would be your biggest clue as to the cause of the problem.<br><br></div><div id="RTEContent"><font size="4"><span style="font-weight: bold; font-family: arial; color: rgb(0, 0, 255);">Melvin Davidson </span></font><br><font size="3"><span style="font-weight: bold; font-family: courier;"><br></span></font></div><div><br></div><div style="font-family: tahoma,new york,times,serif; font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> roctaiwan
<nettreeinc@gmail.com><br><b><span style="font-weight: bold;">To:</span></b> slony1-general@lists.slony.info<br><b><span style="font-weight: bold;">Sent:</span></b> Monday, September 28, 2009 2:17:00 AM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [Slony1-general] copying large file won't get replicate<br></font><br>
<br>Just got this error when I am running the COPY again today. This error appear<br>about 20 mins after whole 10M records inserted to Master. what does it mean?<br><br>[postgres@Slave-DB1-Slony-I ~]$ WARNING: terminating connection because of<br>crash of another server process<br>DETAIL: The postmaster has commanded this server process to roll back the<br>current transaction and exit, because another server process exited<br>abnormally and possibly corrupted shared memory.<br>HINT: In a moment you should be able to reconnect to the database and<br>repeat your command.<br>WARNING: terminating connection because of crash of another server process<br>DETAIL: The postmaster has commanded this server process to roll back the<br>current transaction and exit, because another server process exited<br>abnormally and possibly corrupted shared memory.<br>HINT: In a moment you should be able to reconnect to the database
and<br>repeat your command.<br>NOTICE: Slony-I: cleanup stale sl_nodelock entry for pid=925<br>CONTEXT: SQL statement "SELECT "_sql_cluster".cleanupNodelock()"<br>PL/pgSQL function "cleanupevent" line 77 at PERFORM<br><br><br><br><br>Jan Wieck wrote:<br>> <br>> On 9/25/2009 6:36 AM, roctaiwan wrote:<br>>> Here is my concern. I copying both 10k and 1million of records with<br>>> success,<br>>> but why can't 10Million records? Is this has something to do with my<br>>> memory<br>>> size, which loading 10Million of records is too much for my server to<br>>> handle?<br>> <br>> How long does it take Slony to copy those 1M rows?<br>> <br>> Are there any error messages in the slon log?<br>> <br>> <br>> Jan<br>> <br>> -- <br>> Anyone who trades liberty for security deserves neither<br>> liberty nor security. -- Benjamin Franklin<br>>
_______________________________________________<br>> Slony1-general mailing list<br>> <a ymailto="mailto:Slony1-general@lists.slony.info" href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br><span>> <a target="_blank" href="http://lists.slony.info/mailman/listinfo/slony1-general">http://lists.slony.info/mailman/listinfo/slony1-general</a></span><br>> <br>> <br><br>-- <br><span>View this message in context: <a target="_blank" href="http://www.nabble.com/copying-large-file-won%27t-get-replicate-tp25609853p25641479.html">http://www.nabble.com/copying-large-file-won%27t-get-replicate-tp25609853p25641479.html</a></span><br>Sent from the Slony-I -- General mailing list archive at <a target="_blank" href="http://Nabble.com">Nabble.com</a>.<br><br>_______________________________________________<br>Slony1-general mailing list<br><a ymailto="mailto:Slony1-general@lists.slony.info"
href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br><a href="http://lists.slony.info/mailman/listinfo/slony1-general" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br></div></div></div><br>
</body></html>