Forum OpenACS Development: Postgresql brokes when try install OpenACS-4

From the last time I did an update of openacs-4 I'm getting this mesage :

NOTICE:  Adding missing FROM-clause entry for table "acs_object_id_seq"

Server process (pid 16220) exited with status 11 at Sun May  6 09:01:29 2001

Terminating any active server processes...

NOTICE:  Message from PostgreSQL backend:


        The Postmaster has informed me that some other backend  died abnormally and possibly corrupted shared memory.


        I have rolled back the current transaction and am      going to terminate your database system connection and exit.


        Please reconnect to the database system and repeat your query.

NOTICE:  Message from PostgreSQL backend:


        The Postmaster has informed me that some other backend  died abnormally and possibly corrupted shared memory.


        I have rolled back the current transaction and am      going to terminate your database system connection and exit.


        Please reconnect to the database system and repeat your query.

Server processes were terminated at Sun May  6 09:01:29 2001

Reinitializing shared memory and semaphores

The Data Base System is starting up

DEBUG:  database system was interrupted at 2001-05-06 09:00:27 CEST

DEBUG:  CheckPoint record at (0, 291538508)

DEBUG:  Redo record at (0, 291538508); Undo record at (0, 0); Shutdown TRUE

DEBUG:  NextTransactionId: 384623; NextOid: 558566

DEBUG:  database system was not properly shut down; automatic recovery in progress...

DEBUG:  redo starts at (0, 291538572)

DEBUG:  ReadRecord: record with zero len at (0, 293896064)

DEBUG:  redo done at (0, 293896028)

DEBUG:  database system is in production state

and in aolserver log:

[06/May/2001:09:01:29][16216.4101][-conn0-] Notice: Querying 'begin transaction;'

[06/May/2001:09:01:29][16216.4101][-conn0-] Notice: Ns_PgExec: Entering transaction

[06/May/2001:09:01:29][16216.4101][-conn0-] Notice: dbinit: sql(localhost::wwwrun): 'begin transaction'

[06/May/2001:09:01:29][16216.4101][-conn0-] Notice: QD = proc_name is -apm_file_add-

[06/May/2001:09:01:29][16216.4101][-conn0-] Notice: TEMP - QD: proc_name is apm_file_add

[06/May/2001:09:01:29][16216.4101][-conn0-] Notice: TEMP - QD: local_name is apm_file_add

[06/May/2001:09:01:29][16216.4101][-conn0-] Notice: QD= generated fullname of dbqd.acs-tcl.tcl.apm-file-procs.apm_file_add.apm_file_add

[06/May/2001:09:01:29][16216.4101][-conn0-] Notice: PLPGSQL: bypassed anon function

[06/May/2001:09:01:29][16216.4101][-conn0-] Notice: PRE-QD: the SQL is


        begin


        :1 := apm_package_version.add_file(


                file_id => :file_id,


                version_id => :version_id,


                path => :path,


                file_type => :file_type,


                db_type => :db_type


                );


        end;


    for dbqd.acs-tcl.tcl.apm-file-procs.apm_file_add.apm_file_add

[06/May/2001:09:01:29][16216.4101][-conn0-] Notice: POST-QD: the SQL is





        select apm_package_version__add_file(


                :file_id,


                :version_id,


                :path,


                :file_type,


                :db_type


                )

[06/May/2001:09:01:29][16216.4101][-conn0-] Notice: Querying '





        select apm_package_version__add_file(


                NULL,


                '5',


                'acs-kernel.info',


                'package_spec',


                NULL


                );'

[06/May/2001:09:01:29][16216.4101][-conn0-] Notice: Ns_PgExec: Trying to reopen database connection[06/May/2001:09:01:29][16216.4101][-conn0-] Notice: Opening wwwrun on localhost

[06/May/2001:09:01:29][16216.4101][-conn0-] Error: Ns_PgOpenDb(postgres):  Could not connect to localhost::wwwrun:  The Data Base System is starting up

[06/May/2001:09:01:29][16216.4101][-conn0-] Notice: Ns_PgExec: In transaction, conn died, error returned

[06/May/2001:09:01:29][16216.4101][-conn0-] Error: dbinit: error(localhost::wwwrun,pqReadData() --

backend closed the channel unexpectedly.


        This probably means the backend terminated abnormally


        before or while processing the request.

Someone else is having the same problem ?

I was using the postgresql 7.1.1 it seems to have a bug I reisntalled the postgresql 7.1 and it works fine !
Collapse
Posted by Don Baccus on
Uh-oh, there's a thread on the standard OpenACS forum in which someone describes PG 7.1.1 crashing on their attempts to install 3.2.5.

Uh-oh.

Uh-oh.

I'll be back in town late tomorrow, in effect back to work Tuesday.  If no one's contacted the PG developers about this by then (or if they've not run into it themselves) I'll ping Tom Lane then.

Uh-oh...

Today I've did an update on postgresql  7.1.1 and it seems to work again, at least it goes through the whole install process for openacs 3.2.5 and openacs 4 as well, only openacs4 seems to have some problems with the last commits because after installation we get an error from the tcl code.

Request Error

Server startup failed: Error during bootstrapping





    bad level "-2"


        while executing


    "info level [expr "-1 - $added_stack_num""


        (procedure "db_qd_get_fullname" line 10)


        invoked from within


    "db_qd_get_fullname $statement_name"


        (procedure "db_list" line 5)


        invoked from within


    "db_list package_keys_select {


            select package_key from apm_enabled_package_versions


        }"





                                                              AOLserver/3.2+ad12 on http://tais:8000

Ack! That was me, fixing something without testing. Give me a few minutes....
Collapse
Posted by Don Baccus on
As far as PG 7.1.1 goes, yes, Tom Lane fixed the bug yesterday.  There  will be a PG 7.1.2 in a few days.
Ok, I've fixed the problem I caused. Sorry for the inconvenience.