From: | Maarten Boekhold <boekhold(at)tibco(dot)com> |
---|---|
To: | nippes(at)ums-ulm(dot)de |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: [ADMIN] Running Postgres on a HP-Ux 10.10 System |
Date: | 1999-01-27 10:22:27 |
Message-ID: | 36AEE8E3.47FBBAF5@tibco.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I don't know about the crashes, but try using 'SELECT'
instead of 'SALACT' (where the hell did you get *that*
from??).
Maarten
> I trying to run PostgreSQL 6.4 (or 6.4.2) on a HP-Ux 10.10. The
> problem is that the backend process is dieing after two SQL errors.
> When I do the following the backend will die:
>
> psql test
> => SALACT * FROM test;
> Error ....
> => SALACT * FROM test;
> Error ....
>
> Well nobody is using a database in this way nevertheless I feel that
> my something in my system is not configured the way it should be.
>
> I tried to compile version 6.4 and 6.4.2 either with gcc 2.7.2.3 and
> 2.8.1. The result is the same.
>
> The exit code of the backend process is 138.
>
> Any help welcome.
>
> Reiner Nippes
> UMS GmbH, Ulm - Germnay
>
> >From the log file:
> ProcessQuery
> CommitTransactionCommand
> StartTransactionCommand
> ERROR: pg_atoi: error in "34.5": can't parse ".5"
> AbortCurrentTransaction
> StartTransactionCommand
> query: INSERT INTO INT2_TBL(f1) VALUES ('32767');
> ProcessQuery
> CommitTransactionCommand
> StartTransactionCommand
> query: INSERT INTO INT2_TBL(f1) VALUES ('-32767');
> ProcessQuery
> CommitTransactionCommand
> StartTransactionCommand
> ERROR: pg_atoi: error reading "100000": Result too large
> AbortCurrentTransaction
> /data/app/postgres/bin/postmaster: reaping dead processes...
> /data/app/postgres/bin/postmaster: CleanupProc: pid 17725 exited with status 138
> /data/app/postgres/bin/postmaster: CleanupProc: reinitializing shared memory and semaphores
> shmem_exit(0) [#0]
--
Maarten Boekhold, boekhold(at)tibco(dot)com
TIBCO Finance Technology Inc.
The Atrium
Strawinskylaan 3051
1077 ZX Amsterdam, The Netherlands
tel: +31 20 3012158, fax: +31 20 3012358
http://www.tibco.com
From | Date | Subject | |
---|---|---|---|
Next Message | Reiner Nippes | 1999-01-27 10:43:54 | Re: [ADMIN] Running Postgres on a HP-Ux 10.10 System |
Previous Message | Oliver Elphick | 1999-01-27 10:20:51 | Re: [ADMIN] configuring pg_hba.conf... |