Thread: ERROR: lock 9 is not held

ERROR: lock 9 is not held

From
"er"
Date:
9.3devel / AMD FX-8120 8-core  / centos 6.2 / Linux 2.6.32-279.11.1.el6.x86_64

Hi,

I made a test setup of 9.3devel synchronous replication (git-master as of a few hours ago):
two instances on 1 machine: master: 93_1  port 6664 slave:  93_2  port 6665

I do nothing on either server.  I get these logs (note the ERROR-lines in the slave log, every 5
minutes) :

$ tail -F /home/aardvark/pg_stuff/pg_installations/pgsql.93_1/data/../logfile.93_1
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
LOG:  received smart shutdown request
LOG:  autovacuum launcher shutting down
LOG:  shutting down
LOG:  database system is shut down
2012-11-09 09:42:49.717 CET 6279 LOG:  database system was shut down at 2012-11-09 09:42:49 CET
2012-11-09 09:42:49.823 CET 6283 LOG:  autovacuum launcher started
2012-11-09 09:42:49.824 CET 6278 LOG:  database system is ready to accept connections
2012-11-09 09:42:53.244 CET 6329 LOG:  standby "wal_receiver_01" is now the synchronous standby
with priority 1

$ tail -F /home/aardvark/pg_stuff/pg_installations/pgsql.93_2/data/../logfile.93_2
cp: cannot stat `/home/aardvark/pg_stuff/archive_dir/000000010000000000000004': No such file or
directory
2012-11-09 09:42:53.144 CET 6328 LOG:  streaming replication successfully connected to primary
2012-11-09 09:49:01.124 CET 6323 ERROR:  lock 9 is not held
2012-11-09 09:53:02.427 CET 6323 ERROR:  lock 9 is not held
2012-11-09 09:58:03.845 CET 6323 ERROR:  lock 9 is not held
2012-11-09 10:03:05.239 CET 6323 ERROR:  lock 9 is not held
2012-11-09 10:07:51.620 CET 6323 ERROR:  lock 9 is not held
2012-11-09 10:12:53.019 CET 6323 ERROR:  lock 9 is not held
2012-11-09 10:17:54.416 CET 6323 ERROR:  lock 9 is not held
2012-11-09 10:22:55.811 CET 6323 ERROR:  lock 9 is not held


Master configuration:

data_directory = '/home/aardvark/pg_stuff/pg_installations/pgsql.93_1/data'
listen_addresses = '*'
max_connections = 100
shared_buffers = 128MB
wal_level = hot_standby
synchronous_commit = on
checkpoint_segments = 50
archive_mode = on
archive_command = 'cp %p /home/aardvark/pg_stuff/archive_dir/%f < /dev/null'
max_wal_senders = 3
synchronous_standby_names = '*'


Slave configuration:

data_directory = '/home/aardvark/pg_stuff/pg_installations/pgsql.93_2/data'
listen_addresses = '*'
port = 6665
max_connections = 100
shared_buffers = 128MB
wal_level = hot_standby
synchronous_commit = on
checkpoint_segments = 50
archive_mode = on
archive_command = 'cp %p /home/aardvark/pg_stuff/archive_dir/%f < /dev/null'
max_wal_senders = 3
synchronous_standby_names = ''
hot_standby = on
wal_receiver_status_interval = 59


It's just an ERROR-line in the log, and it may not be a real problem, but in any case I'd like to
know how it is caused

(I ought to add that I had not run these build-scripts for testing syncrep for a few weeks/months
so I may have missed some developments in setup/config)

thanks,

Erik Rijkers