Streaming replication stacked.

From: y-tsukada(at)xseed(dot)co(dot)jp
To: pgsql-general(at)postgresql(dot)org
Subject: Streaming replication stacked.
Date: 2016-01-04 12:08:16
Message-ID: JX201601042108163.40361951@xseed.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I use streaming replication on systems.
But I have an problem.
I need your support.

The system sometimes stacks Postgres process.
So, postgresql data isn't syncing.

I checkd process that it was stacked "waiting" status on slave server.

e.g.) postgres: startup process recovering 0000000100000xxxxxxxxxx
waiting

And I think Master Server completed to transfer wal files but Slave
server couldn't read wal files.
In addition once about 10 hours later , suddenly waiting process
started .

Below is the replication status.

-----------------------------------------
state | streaming
sent_location | A3C/10D51570
write_location | A3C/10D51570
flush_location | A3C/10D51570
replay_location | A3C/10D4A4B8
sync_priority | 0
sync_state | async
-----------------------------------------

Replay_location was stopping and Other location was active.

And There is System Version.
-----------------------------------------
- PostgreSQL Version : 9.4
- OS : CentOS6.4
- Replicaion Type : async
-----------------------------------------

And Below is the Postgres configration.
-----------------------------------------
++ Master :
wal_level = hot_standby
wal_buffers = 16MB
checkpoint_segments = 32
checkpoint_completion_target = 0.7
archive_mode = on
archive_command = 'cp %p /var/lib/pgsql/9.4/data/archive_log/%f'
max_wal_senders = 3
wal_keep_segments = 32
wal_sender_timeout = 20s
hot_standby = on
max_standby_archive_delay = -1
max_standby_streaming_delay = -1
wal_receiver_status_interval = 5s
hot_standby_feedback = on

++ Slave :
wal_level = hot_standby
wal_buffers = 16MB
checkpoint_segments = 32
checkpoint_completion_target = 0.7
archive_mode = on
archive_command = 'cp %p /var/lib/pgsql/9.4/data/archive_log/%f'
max_wal_senders = 3
wal_keep_segments = 32
wal_sender_timeout = 20s
hot_standby = on
max_standby_archive_delay = -1
max_standby_streaming_delay = -1
wal_receiver_status_interval = 5s
hot_standby_feedback = on
-----------------------------------------

Do you have any solution?

Thanks in advance for any help.

Yoji Tsukada.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2016-01-04 12:28:10 Re: Streaming replication stacked.
Previous Message Nicolas Paris 2016-01-04 09:14:00 Re: PostgreSQL GUI tools