>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 <nettreeinc at gmail.com>
To: slony1-general at lists.slony.info
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?

[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.

_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090928/9f4e0e4f/attachment.htm