Tue Dec 22 11:03:33 PST 2015
- Previous message: [Slony1-general] Slony with Amazon's RDS service?
- Next message: [Slony1-general] SLONY initial sync (PostgreSQL 9.2 master, PostgreSQL 9.4 slave) producing out of memory and invalid byte sequence errors in the postgres log
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi All; We are replicating from a PostgreSQL 9.2 database (our Master) to a PostgreSQL 9.4 database (our slave) - server encoding is UTF8 The slon process for the slave has this entry: 2015-12-22 11:28:31 CST ERROR remoteWorkerThread_1: PQputCopyData() - server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. 2015-12-22 11:28:31 CST WARN remoteWorkerThread_1: data copy for set 1 failed 1 times - sleep 15 seconds FATAL: invalid frontend message type 166 2015-12-22 11:28:31 CST ERROR remoteWorkerThread_1: "rollback transaction" PGRES_FATAL_ERROR 2015-12-22 11:28:31 CST CONFIG slon: child terminated signal: 9; pid: 12450, current worker pid: 12450 2015-12-22 11:28:31 CST CONFIG slon: restart of worker in 10 seconds The process then begins to copy seemingly successful initial table sync's however the postgresql log file has entries like this: 2015-12-22 14:56:05 UTC /*[db name] [cluster name]*/ ERROR: out of memory 2015-12-22 14:56:05 UTC /*[db name] [cluster name]*/ DETAIL: Cannot enlarge string buffer containing 0 bytes by 1572761385 more bytes. 2015-12-22 14:56:05 UTC /*[db name] [cluster name]*/ CONTEXT: COPY /*[table name] */, line 2332808 2015-12-22 14:56:05 UTC /*[db name] [cluster name]*/ STATEMENT: select "_/*[schema name]*/".prepareTableForCopy(11); copy "public"."/*[table name]*/" /*...*/ from stdin; 2015-12-22 14:56:05 UTC /*[db name] [cluster name]*/ LOG: could not send data to client: Broken pipe 2015-12-22 14:56:05 UTC /*[db name] [cluster name]*/ FATAL: connection to client lost 2015-12-22 14:56:10 UTC /*[db name] [cluster name]*/ LOG: could not send data to client: Broken pipe 2015-12-22 14:56:10 UTC /*[db name] [cluster name]*/ FATAL: connection to client lost 2015-12-22 17:28:50 UTC /*[db name] [cluster name]*/ ERROR: invalid byte sequence for encoding "UTF8": 0x9d 2015-12-22 17:28:50 UTC /*[db name] [cluster name]*/ CONTEXT: COPY transcript_indices, line 35227547 2015-12-22 17:28:50 UTC /*[db name] [cluster name]*/ STATEMENT: select "_/*[schema name]*/".prepareTableForCopy(7); copy "public"."/*[table name]*/" /*...*/ from stdin; 2015-12-22 17:28:54 UTC /*[db name] [cluster name]*/ FATAL: invalid frontend message type 166 Thoughts? Thanks in advance... -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20151222/537435e3/attachment.htm
- Previous message: [Slony1-general] Slony with Amazon's RDS service?
- Next message: [Slony1-general] SLONY initial sync (PostgreSQL 9.2 master, PostgreSQL 9.4 slave) producing out of memory and invalid byte sequence errors in the postgres log
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list