postgres 7.0 beta 2 segfaulting [linux i386]

Started by Ragnar Hojland Espinosaalmost 26 years ago2 messagesbugs
Jump to latest
#1Ragnar Hojland Espinosa
ragnar@macula.net

Offending query:

select template_id from cm_templates intersect select max(version) from
cm_templates group by (key);

Log:

Server process (pid 13279) exited with status 11 at Thu Apr 27 14:10:40 2000
Terminating any active server processes...
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend died
abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am going to terminate
your database system connection and exit.
Please reconnect to the database system and repeat your query.

(repeated ~7 times .. one per connection, I guess)

Some relevant data:

 template_id         | integer      | not null default
nextval('cm_templates_template_id_seq'::text)
 key                 | varchar(30)  | not null
 version             | integer      | not null
 adp                 | text         | 
 info_table          | varchar(30)  | not null
 info_sql            | varchar(250) | 
 last_modified       | timestamp    | not null
 last_modifying_user | integer      | not null
 Index: cm_templates_template_id_key

template_id | key | version
-------------+-----+---------
6 | nnn | 0
7 | nnn | 1
8 | nnn | 2
9 | nn | 0
10 | nn | 1
(5 rows)

Repeatable:

Yeppers.

--
____/| Ragnar H�jland Freedom - Linux - OpenGL Fingerprint 94C4B
\ o.O| 2F0D27DE025BE2302C
=(_)= "Thou shalt not follow the NULL pointer for 104B78C56 B72F0822
U chaos and madness await thee at its end." hkp://keys.pgp.com

Handle via comment channels only.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Ragnar Hojland Espinosa (#1)
Re: postgres 7.0 beta 2 segfaulting [linux i386]

Ragnar Hojland Espinosa <ragnar@macula.net> writes:

select template_id from cm_templates intersect select max(version) from
cm_templates group by (key);

Fixed. Thanks for the example.

regards, tom lane