pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSeqno. is not btree?
2+ messages / 2 participants
[nested] [flat]
* Seqno. is not btree?
@ 2003-06-30 10:53 Anagha Joshi <ajoshi@nulinkinc.com>
2003-06-30 14:26 ` Re: Seqno. is not btree? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Anagha Joshi @ 2003-06-30 10:53 UTC (permalink / raw)
To: pgsql-sql
Hi,
I use Postgresql-7.2.4
I've created following table:
create table vchar (
seqno SERIAL,
col_var character varying (8192)
);
After as many as 2412081 records are inserted, I shutdown my server.
My every record was inserted programatically by :
insert into vchar (col_var) values ('VVV')......(VVV' char sequence was
8192 times long. i.e. in one row 8192 V's are present.)
Next day,I tried the following:
test=# select count(*) from vchar;
count
-------
2568
(1 row)
test=# insert into vchar (col_var) values ('VV');
ERROR: Index vchar_seqno_key is not a btree
What does this error mean? My server log shows 2412081 records inserted
but actual count(*) shows only 2568 records.
Pls. help.
Thx.,
Anagha
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Seqno. is not btree?
2003-06-30 10:53 Seqno. is not btree? Anagha Joshi <ajoshi@nulinkinc.com>
@ 2003-06-30 14:26 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2003-06-30 14:26 UTC (permalink / raw)
To: Anagha Joshi <ajoshi@nulinkinc.com>; +Cc: pgsql-sql
"Anagha Joshi" <ajoshi@nulinkinc.com> writes:
> After as many as 2412081 records are inserted, I shutdown my server.
> Next day,I tried the following:
> test=3D# select count(*) from vchar;
> count
> -------
> 2568
> (1 row)
> test=3D# insert into vchar (col_var) values ('VV');
> ERROR: Index vchar_seqno_key is not a btree
It sounds to me like you've got serious disk problems --- losing a
couple hundred thousand rows is not normal :-(. The index complaint
also suggests on-disk corruption --- it means that the btree version
information that's stored in the first page of a btree index wasn't
right.
How exactly did you "shut down the server"? Have you noticed any other
evidence of disk problems, outside Postgres?
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-06-30 14:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-06-30 10:53 Seqno. is not btree? Anagha Joshi <ajoshi@nulinkinc.com>
2003-06-30 14:26 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox