Postgres still dying on insert

From: Michael Richards <miker(at)scifair(dot)acadiau(dot)ca>
To: questions(at)postgresql(dot)org, hackers(at)postgresql(dot)org
Subject: Postgres still dying on insert
Date: 1998-04-27 22:31:25
Message-ID: Pine.BSF.3.96.980427191501.12623A-100000@scifair.acadiau.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have tried almost everything I can think of, put postgres keepy dying.
I am running on a FreeBSD 2.2.5 system. It was complaining about not
enough shared memory. I bumped the shared mem to 16mb (the system has 128)
now it doesn't complain, it just dumps core.
The numbers are different this time, but today, the command I am trying to
execute is:
INSERT INTO word_detail VALUES (131730,18596,1)
now word_detail is:
| word_id | int4 | 4 |
| url_id | int4 | 4 |
| word_count | int2 | 2 |

and it has non-unique indexes on word_id and url_id
sc=> select count(*) from word_detail;
Field| Value
-- RECORD 0 --
count| 637466

There is quite a bit of data here as well...
sc=> INSERT INTO word_detail VALUES (131730,18596,1);
PQexec() -- Request was sent to backend, but backend closed the channel
before responding.
This probably means the backend terminated abnormally before or
while processing the request.

No debugging comes out in the log either:
FindBackend: found "/usr/local/pgsql/bin/postgres" using argv[0]
---debug info---
Quiet = f
Noversion = f
timings = f
dates = Normal
bufsize = 256
sortmem = 4096
query echo = t
DatabaseName = [sc]
----------------

InitPostgres()..
StartTransactionCommand() at Mon Apr 27 19:46:41 1998

ProcessQuery() at Mon Apr 27 19:46:41 1998

I even tried selecting this into another table and re-building the
indexes.

It allowed me to insert about 50 more values in before it started crapping
out again. Any ideas? The binaries compiled normally and passed all the
tests.

-Mike

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message t-ishii 1998-04-28 00:52:19 Re: [HACKERS] multi-byte aware char_length() etc.
Previous Message Bruce Stephens 1998-04-27 19:19:11 Re: [HACKERS] Re: [QUESTIONS] Practical SQL Handbook - demo script for postgreSQL