Re: [Gnumed-bugs] Problem with rc7 bootstrap

[Jim Busser]

On 2011-10-21, at 9:50 AM, Jim Busser wrote:

> …
> 
> I had thought I had already done the v15 fixup… is there any dependence or 
> conflict with the v15 --> v16 bootstrap depending on a prior standalone fixup 
> having been done / not done?
> 
> 2011-10-21 09:42:44  DEBUG     gm.db 
> (/Users/djb/Downloads/gnumed-server.16.rc7/Gnumed/pycommon/gmPG2.py::database_schema_compatible()
>  #469): 2011-10-18 19:37:25.307085-07 - v15.11 - 
> v15-ref-consumable_substance-trigger_fixup.sql
> 2011-10-21 09:42:44  DEBUG     gm.db 
> (/Users/djb/Downloads/gnumed-server.16.rc7/Gnumed/pycommon/gmPG2.py::database_schema_compatible()
>  #469): 2011-10-18 19:37:26.72955-07 - Revision: 1.0 - 
> v15-ref-consumable_substance-data-vbanait.sql
> 2011-10-21 09:42:44  DEBUG     gm.db 
> (/Users/djb/Downloads/gnumed-server.16.rc7/Gnumed/pycommon/gmPG2.py::database_schema_compatible()
>  #469): 2011-10-18 19:37:27.075118-07 - 15.11 - 
> v15-cfg-report_query-find_dupes.sql
> 2011-10-21 09:42:44  ERROR     gm.bootstrapper 
> (./bootstrap_gm_db_system.py::__create_db() #739): invalid template database
> 2011-10-21 09:42:44  ERROR     gm.bootstrapper 
> (./bootstrap_gm_db_system.py::__bootstrap() #586): Cannot create database.
> 2011-10-21 09:42:44  ERROR     gm.bootstrapper 
> (./bootstrap_gm_db_system.py::bootstrap() #1164): Cannot bootstrap bundle 
> [v15_fixups-pre_v16].
> Traceback (most recent call last):
>  File "./bootstrap_gm_db_system.py", line 1162, in bootstrap
>    database(aDB_alias = database_alias)
>  File "./bootstrap_gm_db_system.py", line 559, in __init__
>    raise ConstructorError, "database.__init__(): Cannot bootstrap database."
> ConstructorError: database.__init__(): Cannot bootstrap database.
> 2011-10-21 09:42:44  ERROR     gm.bootstrapper 
> (./bootstrap_gm_db_system.py::exit_with_msg() #1340): Cannot bootstrap 
> bundles.
> 2011-10-21 09:42:44  INFO      gm.bootstrapper 
> (./bootstrap_gm_db_system.py::exit_with_msg() #1341): shutdown


In spite of the complaint about invalid template, I can do

# ======================================
MacBook-2:bootstrap root# psql -U gm-dbo template1

        Password for user gm-dbo: 
        psql (8.4.8)
        Type "help" for help.

template1=> CREATE DATABASE testdatabase ;
CREATE DATABASE
template1=> DROP DATABASE testdatabase ;
DROP DATABASE
template1=>
# ======================================

and in case it would provide information, I successfully uncommented in

        v15-cfg-report_query-find_dupes.sql

the line

        set default_transaction_read_only to off; 

and ran

 ./psql -d gnumed_v15 -U gm-dbo --file 
~/Downloads/gnumed-server.16.rc7/server/sql/v14-v15/fixups/v15-cfg-report_query-find_dupes.sql

and noted in the terminal output

        Password for user gm-dbo: 
        SET
        DELETE 1
        INSERT 0 1
        DELETE 1
        INSERT 0 1
        DELETE 1
        INSERT 0 1
       log_script_insertion       
----------------------------------
 50ea1c7b5d47da196d0a2bdedfa235da
(1 row)

so I need pointers if I need to do more investigating.

-- Jim