Last week I've got the assertion:

*** ERROR *** Assertion failed: 201501 (11.0.1.2303)
Page 0x2:0x1 for requested record not a table page

I was able to start database after that. But several hours later DB
crashed again with same assertion.

I successfully rebuild database (it take me 4 days - database is quite
large) and upgraded to EBF 2324. Today I've got same assertion . Any
clues what might cause it?

===
Andrei

I resolve the assertion. The problem was in 1 table:
CREATE TABLE "company"."Foo" (
"foo_id" LONG VARCHAR NOT NULL,
"content" LONG BINARY COMPRESSED NOT NULL,
PRIMARY KEY ( "foo_id" ASC )
) IN "system";

The assertion gone after I do the following:
1) Create new table with same columns but turn of compression
CREATE TABLE "company"."Foo2" (
"foo_id" LONG VARCHAR NOT NULL,
"content" LONG BINARY NOT NULL,
PRIMARY KEY ( "foo_id" ASC )
) IN "system";

2) Populate new table with manually compressed blob:

insert into Foo2(foo_id,content) select foo_id,Compress(content,'gzip')
from foo;

3) I changed the client application code to manually compress blob-field
before inserting/updating 'content'-field.

So I'm pretty sure there is some bug in SA 11.0.1 in processing
compressed column.

What is strange I had no problem for almost 1 month since I started
populate DB. I was able insert about 4.5 millions rows until I faced the
problem with that assertion. As I mentioned early reloading DB did not
help ( i tried both -an and external reload, run dbvalid - no errors).

By the way, using -u switch speed up reloading DB by a factor of 10 (in
my case). Why this switch should not be default?

=====
Andrei


Andrei Iliev wrote: