I'm having a problem, both through JDBC and through psql (so I reckon
the problem is in the core database) whereby if I put a value into a
timestamp field which has a non-unique index on it, I get a "back-end
has died unexpectedly" error.
It's consistently happening on the same column in the same table, even
after destroying and recreating the databases. There is another
timestamp column, also indexed, in the same table which behaves
perfectly I'm flummoxed. Help!
More data:
The table is of the form:
create table my_table (id int not null, startdate timestamp, enddate
timestamp);
create unique index id_idx on my_table (id);
create index startdate_idx on my_table (startdate datetime_ops);
create index enddate_idx on my_table (enddate datetime_ops);
insert into my_table (id, startdate) values (1, 'now');
this works fine then:
insert into my_table (id, enddate) values (2, 'now');
this fails with backend-death. If I drop the index on enddate I can
insert values fine, but then the backend dies if I subsequently create
the index.
The debugging output, with debuglevel set to 3 is:
StartTransactionCommand
query: insert into cat_entries (ent_id, ent_code, ent_enddate,
ent_tmg_id, ent_is_group) values (455, 'wibble', 'now', 1, 0);
ProcessQuery
/usr/lib/pgsql/bin/postmaster: reaping dead processes...
/usr/lib/pgsql/bin/postmaster: CleanupProc: pid 11763 exited with status
11
/usr/lib/pgsql/bin/postmaster: CleanupProc: reinitializing shared memory
and semaphores
shmem_exit(0) [#0]
binding ShmemCreate(key=52e389, size=1063936)
and psql exits with:
mydb=> insert into cat_entries (ent_id, ent_code, ent_enddate,
ent_tmg_id, ent_is_group) values (455, 'wibble', 'now', 1, 0);
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is
impossible.
Terminating.
What's happening? :-) And is it something known about fixed in a later
version?
(I'm on Postgresql 6.5.1 as supplied with SuSE Linux 6.3)
[PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]
--
Rachel
