From: | stefan(dot)proels(at)pharmatechnik(dot)de |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #7566: Sequences not properly replicated |
Date: | 2012-09-25 08:12:05 |
Message-ID: | E1TGQFR-00081W-Gf@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 7566
Logged by: Stefan Pröls
Email address: stefan(dot)proels(at)pharmatechnik(dot)de
PostgreSQL version: 9.1.3
Operating system: OpenSUSE 11.4 32-Bit
Description:
Scenario:
1 Master, 1 Hot-Standby Slave, asynchronous streaming replication, both
servers PostgreSQL 9.1.3.
===Master:================================================================================================================================
$ CREATE SEQUENCE t_seq;
$ SELECT * FROM t_seq;
sequence_name | last_value | start_value | increment_by | max_value
| min_value | cache_value | log_cnt | is_cycled | is_called
---------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
t_seq | 1 | 1 | 1 |
9223372036854775807 | 1 | 1 | 1 | f | f
===Slave:=================================================================================================================================
$ SELECT * FROM t_seq;
sequence_name | last_value | start_value | increment_by | max_value
| min_value | cache_value | log_cnt | is_cycled | is_called
---------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
t_seq | 1 | 1 | 1 |
9223372036854775807 | 1 | 1 | 0 | f | t
===Master:================================================================================================================================
$ SELECT nextval('t_seq');
nextval
---------
1
$ SELECT * FROM t_seq;
sequence_name | last_value | start_value | increment_by | max_value
| min_value | cache_value | log_cnt | is_cycled | is_called
---------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
t_seq | 1 | 1 | 1 |
9223372036854775807 | 1 | 1 | 0 | f | t
===Slave:=================================================================================================================================
$ SELECT * FROM t_seq;
sequence_name | last_value | start_value | increment_by | max_value
| min_value | cache_value | log_cnt | is_cycled | is_called
---------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
t_seq | 1 | 1 | 1 |
9223372036854775807 | 1 | 1 | 0 | f | t
===Master:================================================================================================================================
$ SELECT nextval('t_seq');
nextval
---------
2
$ SELECT * FROM t_seq;
sequence_name | last_value | start_value | increment_by | max_value
| min_value | cache_value | log_cnt | is_cycled | is_called
---------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
t_seq | 2 | 1 | 1 |
9223372036854775807 | 1 | 1 | 32 | f | t
===Slave:=================================================================================================================================
$ SELECT * FROM t_seq;
sequence_name | last_value | start_value | increment_by | max_value
| min_value | cache_value | log_cnt | is_cycled | is_called
---------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
t_seq | 34 | 1 | 1 |
9223372036854775807 | 1 | 1 | 0 | f | t
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2012-09-25 08:35:47 | Re: BUG #7533: Client is not able to connect cascade standby incase basebackup is taken from hot standby |
Previous Message | mcashokkumar | 2012-09-25 07:48:28 | BUG #7565: not able to install |