abnormal exits: what am I overlooking?

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: PostgreSQL general list <pgsql-general(at)postgresql(dot)org>
Subject: abnormal exits: what am I overlooking?
Date: 2002-02-27 20:03:47
Message-ID: 20020227150347.I16547@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm doing some tests with 7.2 here, and I'm having trouble creating a
table. This is on Solaris 7 compiled with a 64 bit gcc; gcc -v gives

Reading specs from
/opt/OXRS/local/gcc-3.0-v9/lib/gcc-lib/sparcv9-sun-solaris2/3.0.3/specs
Configured with: ./configure --prefix=/opt/OXRS/local/gcc-3.0-v9
--enable-languages=c,c++ sparcv9-sun-solaris2 : (reconfigured)
./configure --prefix=/opt/OXRS/local/gcc-3.0-v9
--enable-languages=c,c++ --host=sparcv9-sun-solaris2 : (reconfigured)
./configure --prefix=/opt/OXRS/local/gcc-3.0-v9
--enable-languages=c,c++ --host=sparcv9-sun-solaris2
Thread model: posix
gcc version 3.0.3

Postgres passwd all its regression tests after the build.

Here's the CREATE statement:

create table epp_registrar_notification
(id integer primary key default nextval('registrar_notification_id_seq'),
registrar_id integer,
created_on timestamp default current_timestamp,
message_type char(1),
poll_status char(1),
email_status char (1),
send_to_email varchar,
copy_to_email varchar,
from_email varchar,
subject_line varchar,
message_text varchar,
expires_on timestamp not null default current_times tamp + '7 days');

The backend died with the attached in the log, debug level 1. There
was _once_ a message returned to psql, but in repeated attempts, I
haven't been able to see it again, and I didn't catch it the first
time. It was a message talking about allocation, I think, but I know
that's no help :( .

So, I thought I'd try turning up the debug level. When I turn it
to 4, the system stops responding when I try to connect. Hmm. So I
try with debug level 3. I can connect, but when I try to run the
query, it locks. Here's the end of the log:

2002-02-27 19:54:23 [28780] NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index 'epp_registrar_notification_pkey' for table
'epp_registrar_notification'
2002-02-27 19:54:23 [28780] DEBUG: parse tree:
2002-02-27 19:57:59 [28803] DEBUG: proc_exit(0)
2002-02-27 19:57:59 [28803] DEBUG: shmem_exit(0)
2002-02-27 19:57:59 [28803] DEBUG: exit(0)
2002-02-27 19:57:59 [28773] DEBUG: reaping dead processes
2002-02-27 19:57:59 [28773] DEBUG: child process (pid 28803) exited
with exit code 0

Anyone have any idea what I ought to be looking at next? Am I just
overlooking something obvious?

A

--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110

Attachment Content-Type Size
logfrag text/plain 3.4 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David A Dickson 2002-02-27 22:05:46 Re: Drawing databases
Previous Message Holger Marzen 2002-02-27 19:58:34 Re: mod_auth_pg for Apache, and LXP