Re: [Gnumed-bugs] [Gnumed-devel] 1.0.rc5 release

[Jim Busser]

On 2011-10-04, at 8:23 AM, Karsten Hilbert wrote:

> I have uploaded the latest Release Candidate 1.0.rc5.
> 
>       http://www.gnumed.de/downloads/client/1.0/
>       http://www.gnumed.de/downloads/server/v16/
> 
> Please test and report bugs !


I get an error on trying to upgrade the database v15 --> v16

end of log appended

-- Jim

drop index idx_ref_atc_fk_data_src cascade
2011-10-04 10:59:20  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#241): ../sql/v15-v16/dynamic/v16-ref-atc-dynamic.sql:40: index 
"idx_ref_atc_fk_data_src" does not exist
2011-10-04 10:59:20  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#233): 
drop index idx_ref_atc_code_unique_per_system cascade
2011-10-04 10:59:20  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#241): ../sql/v15-v16/dynamic/v16-ref-atc-dynamic.sql:41: index 
"idx_ref_atc_code_unique_per_system" does not exist
2011-10-04 10:59:20  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#233): 
drop index idx_ref_atc_term_unique_per_system cascade
2011-10-04 10:59:20  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#241): ../sql/v15-v16/dynamic/v16-ref-atc-dynamic.sql:42: index 
"idx_ref_atc_term_unique_per_system" does not exist
2011-10-04 10:59:21  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#233): 
alter table ref.atc drop constraint atc_fk_data_source_fkey cascade
2011-10-04 10:59:21  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#241): ../sql/v15-v16/dynamic/v16-ref-atc-dynamic.sql:51: constraint 
"atc_fk_data_source_fkey" of relation "atc" does not exist
2011-10-04 10:59:21  INFO      gm.bootstrapper 
(./bootstrap_gm_db_system.py::_import_schema() #1325): successfully imported 
[../sql/v15-v16/dynamic/v16-ref-atc-dynamic.sql]
2011-10-04 10:59:21  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#233): drop trigger tr_upd_ref_code_tbl_check_backlink on ref.loinc
2011-10-04 10:59:21  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#241): ../sql/v15-v16/dynamic/v16-ref-loinc-dynamic.sql:11: trigger 
"tr_upd_ref_code_tbl_check_backlink" for table "loinc" does not exist
2011-10-04 10:59:21  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#233): 
drop trigger tr_del_ref_code_tbl_check_backlink on ref.loinc
2011-10-04 10:59:21  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#241): ../sql/v15-v16/dynamic/v16-ref-loinc-dynamic.sql:12: trigger 
"tr_del_ref_code_tbl_check_backlink" for table "loinc" does not exist
2011-10-04 10:59:21  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#233): 
drop index idx_ref_loinc_fk_data_src cascade
2011-10-04 10:59:21  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#241): ../sql/v15-v16/dynamic/v16-ref-loinc-dynamic.sql:28: index 
"idx_ref_loinc_fk_data_src" does not exist
2011-10-04 10:59:21  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#233): 
drop index idx_ref_loinc_code_unique_per_system cascade
2011-10-04 10:59:21  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#241): ../sql/v15-v16/dynamic/v16-ref-loinc-dynamic.sql:29: index 
"idx_ref_loinc_code_unique_per_system" does not exist
2011-10-04 10:59:21  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#233): 
drop index idx_ref_loinc_term_unique_per_system cascade
2011-10-04 10:59:21  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#241): ../sql/v15-v16/dynamic/v16-ref-loinc-dynamic.sql:30: index 
"idx_ref_loinc_term_unique_per_system" does not exist
2011-10-04 10:59:26  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#233): 
alter table ref.loinc drop constraint atc_fk_data_source_fkey cascade
2011-10-04 10:59:26  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#241): ../sql/v15-v16/dynamic/v16-ref-loinc-dynamic.sql:39: constraint 
"atc_fk_data_source_fkey" of relation "loinc" does not exist
2011-10-04 10:59:26  DEBUG     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#233): 
alter table ref.loinc
        add foreign key (fk_data_source)
                references ref.data_source(pk)
                on update cascade
                on delete restrict
2011-10-04 10:59:26  ERROR     gm.bootstrapper 
(/Users/djb/Downloads/gnumed-server.16.rc5/Gnumed/pycommon/gmPsql.py::run() 
#238): ../sql/v15-v16/dynamic/v16-ref-loinc-dynamic.sql:46: insert or update on 
table "loinc" violates foreign key constraint 
"loinc_fk_data_source_fkey"DETAIL:  Key (fk_data_source)=(9) is not present in 
table "data_source".
2011-10-04 10:59:26  ERROR     gm.bootstrapper 
(./bootstrap_gm_db_system.py::_import_schema() #1327): failed to import 
[../sql/v15-v16/dynamic/v16-ref-loinc-dynamic.sql]
2011-10-04 10:59:26  ERROR     gm.bootstrapper 
(./bootstrap_gm_db_system.py::bootstrap() #1175): Cannot import schema 
definition for bundle [v15-v16-dynamic] into database [gnumed_v16].
2011-10-04 10:59:26  ERROR     gm.bootstrapper 
(./bootstrap_gm_db_system.py::exit_with_msg() #1340): Cannot bootstrap bundles.
2011-10-04 10:59:26  INFO      gm.bootstrapper 
(./bootstrap_gm_db_system.py::exit_with_msg() #1341): shutdown