Re: [HACKERS] FATAL 1:btree: items are out of order

On Wed, 11 Jun 1997, Vadim B. Mikheev wrote:
...
> Michael, do you use chars which >= 128 ?
> If yes and you havn't USE_LOCALE defined that problems
> with text-field come from nbtcompare.c:bttextcmp() - it uses
>

Next try.
Now I compiled the source with (configuere --enable-locale).

createdb/create_table/create_index

Then:
hopp=> copy h from '/a/hopp/export/h.dmp';
FATAL 1:palloc failure: memory exhausted

(But I have 64MB Memory + 588MB Swap, which is 11% used).

After restarting psql again I try:

hopp=> drop table h;
NOTICE:AbortTransaction and not in in-progress state
NOTICE:AbortTransaction and not in in-progress state

????

Not only that.

It seems that the files h (the table) and h1 (the index) get deleted.
(As it should)
If I now recreate the table and index, I get a message that they already exist.
(But the datafiles don't).

If I do a \d, I see woth index and table, if I do a select * from h I get;
WARN:cannot write block 1 of h1 [hopp] blind

(Which is correct because the datafiles are missing).


Bye!
- ----
Michael Reifenberger
Plaut Software GmbH, R/3 Basis

------------------------------