From: | Ragnar Hojland Espinosa <ragnar(at)macula(dot)net> |
---|---|
To: | bugs(at)postgreSQL(dot)org |
Subject: | postgres 7.0 beta 2 segfaulting [linux i386] |
Date: | 2000-04-27 12:21:39 |
Message-ID: | 20000427142139.A13396@macula.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Renters | 2000-04-27 16:04:11 | bug report |
Previous Message | Eko Purwanto | 2000-04-27 02:10:40 | Bug Report : updated |