repeatable crash generating two column index

From: Mike Harding <mvh(at)ix(dot)netcom(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: repeatable crash generating two column index
Date: 2002-07-03 17:58:34
Message-ID: 20020703175834.E9AE21310A@netcom1.netcom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm working the example in "Postgresql Developer's Handbook", page
218. I can create an index on a single column no problem, but when I
try to create a index over two columns ->

CREATE INDEX idx_id_perftest ON perftest (id, astring);

the backend crashes every time. I see the following in the logs...

2002-07-03 08:33:29 DEBUG: server process (pid 53454) was terminated by signal 11
2002-07-03 08:33:29 DEBUG: terminating any other active server processes
2002-07-03 08:33:29 DEBUG: all server processes terminated; reinitializing shared memory and semaphores

I can create/drop a single column index after the crash/recovery no problem.

I am using FreeBSD 4.6, Postrgresql 7.2.1. I'm not including the code
because it's copyright but can forward to a debugger. The code just
generates 10 million columns with an ID, and a random number and
string...

mvh=> select * from perftest limit 10;
id | astring | anumber
----+----------+----------
1 | pIscM5Kh | 35888787
2 | b8FSfFCU | 7206043
3 | 8lkWXbbj | 48537449
4 | DqLhIiZq | 15229027
5 | ic31Ckk9 | 3910172
6 | Gskx5Fqk | 11816527
7 | saifh1ia | 26180953
8 | mlbmdya2 | 5189701
9 | jfOB6cVe | 34855048
10 | cAUg0yIo | 91032333
(10 rows)

- Mike H.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Booth, Robert 2002-07-03 18:02:00 Query Analyzing
Previous Message eunice palmeira 2002-07-03 17:56:02 temporal event