[pgpool-general: 3131] OID sequence difference after online recovery

[Michel Kirstein]

Hi,

I'm running a dedicated pgpool server (pgpoool-II version 3.3.2) with 3
dedicated postgresql-cluster( PostgreSQL 9.1.12) in replication mode with
loadbalancing.

I test if the Database is synchronized through a short script:
- Create database
- get oids for new db from nodes
- Drop database

I've started testing with all nodes attached and in sync.
Next I created a new database on pgsql3 and just dropped it again.
This advanced the db-oid sequence by just one.
I then detach node 3 from pgpool and start online-recovery.
After the successful online-recovery I run the synctest.script.
This time the oid of the databse on node 3 has advanced by something just
over 8000.
Whatever I do, I cannot get the node back in sync with the other two.
>From the logs I'd guess that the oids don't get flushed to log, but I can't
figure it out.

What am I missing?

I have attached the log files of all three nodes of a recovery run and the
log of my synctest.
any help will be appreciated.

sincerely 
Michel Kirstein


-------------- next part --------------
A non-text attachment was scrubbed...
Name: Node1.log
Type: application/octet-stream
Size: 27307 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20140902/89e56497/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Node2.log
Type: application/octet-stream
Size: 7624 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20140902/89e56497/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Node3.log
Type: application/octet-stream
Size: 6279 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20140902/89e56497/attachment-0002.obj>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: synctest.txt
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20140902/89e56497/attachment.txt>