SEO

#1 (**permalink**) 04-18-2008, 09:11 AM

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

#2 (**permalink**) 04-18-2008, 09:12 AM

On Wed, 27 Dec 2006, Heikki Linnakangas wrote:

> 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.

Yes, there were a bunch of WAL issues we wanted to address. Jie has been
working on this too. Thanks for the feedback, we can use this as a test.

Thanks,

Gavin

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Re: On-disk bitmap index implementation