From: | Jesse Hathaway <jesse(dot)hathaway(at)getbraintree(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Long select query breaks walsending on sync slave? |
Date: | 2012-11-01 22:55:38 |
Message-ID: | loom.20121101T234217-216@post.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Would it be possible for a long running select query on a standby to prevent the
standby from sending status updates? This seemed to occur and consequently the
master broke the connection:
### Master:
2012-10-31 00:56:44 UTC replicator 5057 192.168.1.20(45690) database
[[unknown]] LOG: terminating walsender process due to replication
timeout
### Slave:
2012-10-31 00:56:47 UTC 12834 database[] FATAL: could not send data
to WAL stream: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
2012-10-31 00:57:02 UTC johndoe 27599 192.168.1.30(46426) database[main]
LOG: duration: 65886.667 ms statement: select...
### Replication Config
replication_timeout = 5s
wal_receiver_status_interval = 2s
Thanks, Jesse Hathaway
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2012-11-01 23:32:54 | Re: role does not exist |
Previous Message | Steve Crawford | 2012-11-01 22:15:51 | Re: Where is 'createdb'? |