BUG #9741: Mininal case for the BUG #9735: Error: "ERROR: tuple offset out of range: 0" during bitmap scan
От | maxim.boguk@gmail.com |
---|---|
Тема | BUG #9741: Mininal case for the BUG #9735: Error: "ERROR: tuple offset out of range: 0" during bitmap scan |
Дата | |
Msg-id | 20140327093357.13967.98197@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #9741: Mininal case for the BUG #9735: Error: "ERROR:
tuple offset out of range: 0" during bitmap scan
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 9741 Logged by: Maxim Boguk Email address: maxim.boguk@gmail.com PostgreSQL version: 9.3.3 Operating system: Linux (Ubuntu) Description: Hi, How situation with the BUG #9735 become even more curious. One query successfully executing on master db but doesn't work on both streaming replicas. After much digging I located problem and produced it in pretty simple way: gate_platbox=# set enable_indexscan to 0; SET (force bitmap scan) gate_platbox=# explain analyze select * from transactions where id=53265020; ERROR: tuple offset out of range: 0 This tuple had been frozen not that long time ago: gate_platbox=# select id,xmin,xmax,cmin,cmax,ctid from transactions where id=53265020; id | xmin | xmax | cmin | cmax | ctid ----------+------+------+------+------+------------- 53265020 | 2 | 0 | 1 | 1 | (2413168,1) pageinspect over used index also show nothing suspicious: select gs.i,t.* from (select generate_series(1,94961) as i) as gs, bt_page_items('transactions_pkey', i) as t where ctid::text='(2413168,1)'; i | itemoffset | ctid | itemlen | nulls | vars | data -------+------------+-------------+---------+-------+------+------------------------- 88472 | 93 | (2413168,1) | 16 | f | f | 7c c2 2c 03 00 00 00 00 Any ideas what's can be wrong with the database?
В списке pgsql-bugs по дате отправления: