[Pgpool-general] [Pgpool-II PITR recovery] Serial data type "+1" after PITR recovery

[Anton Koldaev]

Hello
I have tested pgpool-II 3.0.1 and pgpool 3.0.4, PostgreSQL 8.4
In both cases I'm getting the same result: after online recovery on primary
and target nodes all 'serial' values got "+1". Other nodes enabled in pgpool
have old serial values.
Here is my commands:

> postgres at server01:~> psql -h primary_node -p 5432 -c 'create database
> serial_test'
> postgres at server01:~> psql -h primary_node -p 5432 -d serial_test -c
> 'create schema sch'
> postgres at server01:~> psql -h primary_node -p 5432 -d serial_test -c
> 'create table sch.mytable (id serial, name text);'
> postgres at server01:~> psql -h primary_node -p 5432 -d serial_test -c '\d
> sch.mytable'
>                              Table "sch.mytable"
>  Column |  Type   |                        Modifiers
>
> --------+---------+----------------------------------------------------------
>  id     | integer | not null default
> nextval('sch.mytable_id_seq'::regclass)
>  name   | text    |
> postgres at server01:~> psql -h primary_node -p 5432 -d serial_test -c
> "insert into sch.mytable (name) values ('usera')"
> postgres at server01:~> psql -h primary_node -p 5432 -d serial_test -c
> 'select * from sch.mytable'
>  id | name
> ----+-------
>   1 | usera
> postgres at server01:~> psql -h primary_node -p 5432 -d serial_test -c
> "select nextval('sch.mytable_id_seq')"
>  nextval = 2 # Thats ok
> # Online recovery via PITR (
> http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html#online-recovery
> )
> # Recover the first standby node: standby_1
> *postgres at server01:~> /opt/pgpool-II-3.0.4/pcp_recovery_node -d 1600
> localhost 9999 user pass 1 &
> *# DONE recovery
> *postgres at server01:~> psql -h primary_node -p 5433 -d serial_test -c
> "select nextval('sch.mytable_id_seq')"
> * *nextval = 4* # Where is "3"??
> *postgres at server01:~> psql -h standby_1 -p 5433 -d serial_test -c "select
> nextval('sch.mytable_id_seq')"
> * *nextval = 4* # Where is "3"??
> # Recover the second node: standby_2
> *postgres at server01:~> /opt/pgpool-II-3.0.4/pcp_recovery_node -d 1600
> localhost 9999 user pass 2 &
> *# DONE recovery
> *postgres at server01:~> psql -h primary_node -p 5433 -d serial_test -c
> "select nextval('sch.mytable_id_seq')"
>  nextval = 6* # Where is "5"?
> *postgres at server01:~> psql -h standby_1 -p 5433 -d serial_test -c "select
> nextval('sch.mytable_id_seq')"
>  nextval = 5* # Thats ok
> *postgres at server01:~> psql -h standby_2 -p 5433 -d serial_test -c "select
> nextval('sch.mytable_id_seq')"
> * *nextval = 6* # Where is "5?"
>

What am I doing wrong?

I've tried to set this options without success:

> black_function_list = 'lastval,currval,nextval,setval'

insert_lock = true


-- 
Best regards,
Koldaev Anton
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110620/3a9d962d/attachment.html>