Forum OpenACS Development: Response to Snapshot installation problems
I now got a lot of 'CREATE', some 'COMMENT', some table output (from select's) and ended up with 'Done ....' (I don't remember exact phrase), but the system was still accessing the database and finally the aolserver log ended up with:
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Notice: Querying 'begin transaction;'
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Notice: Ns_PgExec: Entering transaction
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Notice: dbinit: sql(ljserv.local.leifjensen.com::leifjensen): 'begin transaction'
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Notice: Querying '
select apm_package_version__add_file(
NULL,
'5',
'acs-kernel.info',
'package_spec',
NULL
);'
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Notice: Ns_PgExec: Trying to reopen database connection
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Notice: Opening leifjensen on ljserv.local.leifjensen.com, port
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Error: Ns_PgOpenDb(postgres): Could not connect to ljserv.local.leifjensen.com::leifjensen: The Data Base System is starting up
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Notice: Ns_PgExec: In transaction, conn died, error retu
rned
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Error: dbinit: error(ljserv.local.leifjensen.com::leifje
nsen,pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
): '
select apm_package_version__add_file(
NULL,
'5',
'acs-kernel.info',
'package_spec',
NULL
)
'
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Notice: Querying 'abort transaction;'
Killed
-----------------------------------------------------
Looking in the postmaster log, yes, the postmaster had dropped out:
DEBUG: connection: host=[local] user=leif database=leifjensen
DEBUG: InitPostgres
DEBUG: StartTransactionCommand
DEBUG: query: SELECT usesuper FROM pg_user WHERE usename = 'leif'
DEBUG: ProcessQuery
DEBUG: CommitTransactionCommand
DEBUG: StartTransactionCommand
DEBUG: query: select apm_package_version__add_file(NULL, '5', 'acs-kernel.info', 'packaage_spec', N
ULL);
DEBUG: ProcessQuery
DEBUG: query: SELECT file_id from apm_package_files where version_id = $1 and path = $2
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 2125 exited with status 139
Server process (pid 2125) exited with status 139 at Wed Sep 12 01:32:57 2001
Terminating any active server processes...
Server processes were terminated at Wed Sep 12 01:32:57 2001
Reinitializing shared memory and semaphores
invoking IpcMemoryCreate(size=1236992)
postmaster: ServerLoop: handling reading 5
postmaster: ServerLoop: handling reading 5
DEBUG: database system was interrupted at 2001-09-12 01:31:33 CEST
DEBUG: CheckPoint record at (0, 28229264)
DEBUG: Redo record at (0, 28229264); Undo record at (0, 0); Shutdown TRUE
------------------------------------------------------------------
I tried to execute this 'select apm_package_version__add_file...' thing manually in psql and quite right, the connection dropped out 😟.
I am using PostgreSQL version 7.1.1. I tried this a couple of times, dropping/recreating the database with the same result. I scanned for the apm_package_version__add_file function, but I couldn't find it anywhere, though it must be there since it was in the database.
Please help, what am I doing wrong?
Leif
