BUG #7566: Sequences not properly replicated
От | stefan.proels@pharmatechnik.de |
---|---|
Тема | BUG #7566: Sequences not properly replicated |
Дата | |
Msg-id | E1TGQFR-00081W-Gf@wrigleys.postgresql.org обсуждение исходный текст |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 7566 Logged by: Stefan Pr=C3=B6ls Email address: stefan.proels@pharmatechnik.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. =3D=3D=3DMaster:=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D $ 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 =3D=3D=3DSlave:=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D $ 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 =3D=3D=3DMaster:=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D $ 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 =3D=3D=3DSlave:=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D $ 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 =3D=3D=3DMaster:=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D $ 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 =3D=3D=3DSlave:=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D $ 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 =
В списке pgsql-bugs по дате отправления:
Предыдущее
От: s.proels@pharmatechnik.deДата:
Сообщение: BUG #7567: Sequences not properly replicated