Gavin Sherry wrote:
> There are still some things Jie and I have not gotten to yet:
> ...
> o Test WAL replay more thoroughly.
Found one WAL related bug:
postgres=# CREATE TABLE test (i int);
CREATE TABLE
postgres=# INSERT INTO test SELECT a FROM generate_series(1,10) a;
INSERT 0 10
postgres=# CREATE INDEX mdx ON test USING bitmap(i);
CREATE INDEX
postgres=# INSERT INTO test VALUES (11);
INSERT 0 1
postgres=# \q
killall -9 postgres, and restart. Redo fails with:
PANIC: bm_insert_redo: LOV item is not inserted in pos 2(requested 12)
CONTEXT: xlog redo insert a new LOV item: rel 1663/10817/16388
I haven't dug deeper yet.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com