abnormal exits: what am I overlooking?
От | Andrew Sullivan |
---|---|
Тема | abnormal exits: what am I overlooking? |
Дата | |
Msg-id | 20020227150347.I16547@mail.libertyrms.com обсуждение исходный текст |
Ответы |
Re: abnormal exits: what am I overlooking?
|
Список | 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@libertyrms.info> M6K 3E3 +1 416 646 3304 x110
Вложения
В списке pgsql-general по дате отправления: