BUG #15010: Sequence ID is getting skipped

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15010: Sequence ID is getting skipped
Дата
Msg-id 20180115064341.3633.39800@wrigleys.postgresql.org
обсуждение исходный текст
Ответы BUG #15010: Sequence ID is getting skipped  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15010
Logged by:          Anil Kumar G V
Email address:      anilkumar.gv@gmail.com
PostgreSQL version: 9.3.0
Operating system:   Ubuntu
Description:

Sometime sequence ID is getting skipped by 32 numbers. Here is some sample
sequence definition. 

  Column     |  Type   |        Value         
---------------+---------+----------------------
 sequence_name | name    | audit_logid_sequence
 last_value    | bigint  | 425585242
 start_value   | bigint  | 1
 increment_by  | bigint  | 1
 max_value     | bigint  | 9223372036854775807
 min_value     | bigint  | 1
 cache_value   | bigint  | 1
 log_cnt       | bigint  | 24
 is_cycled     | boolean | f
 is_called     | boolean | t


      Sequence "nmc.mrno_number_seq"
    Column     |  Type   |        Value        
---------------+---------+---------------------
 sequence_name | name    | mrno_number_seq
 last_value    | bigint  | 12
 start_value   | bigint  | 1
 increment_by  | bigint  | 1
 max_value     | bigint  | 9223372036854775807
 min_value     | bigint  | 1
 cache_value   | bigint  | 1
 log_cnt       | bigint  | 0
 is_cycled     | boolean | f
 is_called     | boolean | t




В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15009: connection to server
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #14999: pg_rewind corrupts control file global/pg_control