Skip site navigation (1) Skip section navigation (2)

postgres 7.0 beta 2 segfaulting [linux i386]

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 (view raw or flat)
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.

pgsql-bugs by date

Next:From: Martin RentersDate: 2000-04-27 16:04:11
Subject: bug report
Previous:From: Eko PurwantoDate: 2000-04-27 02:10:40
Subject: Bug Report : updated

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group