BUG #1814: Cancelling a CLUSTER changes the OID counter
От | Ian Burrell |
---|---|
Тема | BUG #1814: Cancelling a CLUSTER changes the OID counter |
Дата | |
Msg-id | 20050808212226.D3E83F0B03@svr2.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #1814: Cancelling a CLUSTER changes the OID counter
Re: BUG #1814: Cancelling a CLUSTER changes the OID counter |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 1814 Logged by: Ian Burrell Email address: ianburrell@gmail.com PostgreSQL version: 7.4.6 Operating system: RHEL 3 x86_64 Description: Cancelling a CLUSTER changes the OID counter Details: Cancelling a CLUSTER is causing the OID counter to jump forwards. In the test below, it goes from 108 million to 4286 million (close to 2^32). We recently wrapped the OID counter. vodlive=# insert into foo values (1) ; INSERT 108817614 1 Time: 0.675 ms vodlive=# select oid, * from foo ; oid | bar -----------+----- 108817614 | 1 vodlive=# CLUSTER idx_daily_by_cs_ti_wk_wk_cs_ti ON daily_xtns_by_cable_sys_title_wk ; Cancel request sent ERROR: canceling query due to user request vodlive=# abort ; ROLLBACK vodlive=# insert into foo values (1) ; INSERT 4286822632 1 Time: 0.475 ms vodlive=# select oid, * from foo ; oid | bar ------------+----- 4286822632 | 1 (1 row)
В списке pgsql-bugs по дате отправления: