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 |
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 |