From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | anilkumar(dot)gv(at)gmail(dot)com |
Subject: | BUG #15010: Sequence ID is getting skipped |
Date: | 2018-01-15 06:43:41 |
Message-ID: | 20180115064341.3633.39800@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: 15010
Logged by: Anil Kumar G V
Email address: anilkumar(dot)gv(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2018-01-15 07:25:37 | Re: BUG #14999: pg_rewind corrupts control file global/pg_control |
Previous Message | PG Bug reporting form | 2018-01-14 10:33:22 | BUG #15009: connection to server |