BUG #15010: Sequence ID is getting skipped - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15010: Sequence ID is getting skipped
Date
Msg-id 20180115064341.3633.39800@wrigleys.postgresql.org
Whole thread Raw
Responses BUG #15010: Sequence ID is getting skipped
List 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 by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15009: connection to server
Next
From: Michael Paquier
Date:
Subject: Re: BUG #14999: pg_rewind corrupts control file global/pg_control