Re: [Gnumed-bugs] Problem in git bootstrapping v18 to v19 db

[Karsten Hilbert]

On Tue, Jul 16, 2013 at 12:11:10AM +0000, Jim Busser wrote:

> Does the v18 --> v19 db upgrade SQL have a bug?

Which PostgreSQL version is that ?

Karsten

> I can't run it successfully to completion.
> 
> It ends:
> 
> 2013-07-15 14:28:55  DEBUG     gm.bootstrapper 
> (/Users/djb/git/gnumed/gnumed/gnumed/Gnumed/pycommon/gmPsql.py::run() #233): 
> select gm.log_script_insertion('v19-gm-schema_revision_handling.sql', '19.0')
> 2013-07-15 14:28:55  ERROR     gm.bootstrapper 
> (/Users/djb/git/gnumed/gnumed/gnumed/Gnumed/pycommon/gmPsql.py::run() #238): 
> ../sql/v18-v19/dynamic/v19-gm-schema_revision_handling.sql:181: column 
> tbl.convalidated does not existLINE 1: ...ntdef(tbl.oid, true), ' ', '_') || 
> '::active=' || tbl.conval...                                                  
>            ^QUERY:   select * from (select tbl.contype, 'CONSTRAINT:type=' || 
> tbl.contype || ':' || replace(pg_catalog.pg_get_constraintdef(tbl.oid, true), 
> ' ', '_') || '::active=' || tbl.convalidated as condef from 
> pg_catalog.pg_constraint tbl where tbl.conrelid = ( $1  || '.' ||  $2 
> )::regclass ) as FKs order by FKs.contype, decode(md5(FKs.condef), 
> 'hex')CONTEXT:  PL/pgSQL function "concat_table_structure_v19_and_up" line 69 
> at FOR over SELECT rowsSQL statement "select 
> gm.concat_table_structure_v19_and_up()"PL/pgSQL function 
> "concat_table_structure" line 4 at SQL statementSQL statement "select 
> md5(gm.concat_table_structure())"PL/pgSQL function "log_script_insertion" 
> line 14 at SQL statement
> 2013-07-15 14:28:55  ERROR     gm.bootstrapper 
> (./bootstrap_gm_db_system.py::_import_schema() #1327): failed to import 
> [../sql/v18-v19/dynamic/v19-gm-schema_revision_handling.sql]
> 2013-07-15 14:28:55  ERROR     gm.bootstrapper 
> (./bootstrap_gm_db_system.py::bootstrap() #1175): Cannot import schema 
> definition for bundle [v18-v19-dynamic] into database [gnumed_v19].
> 2013-07-15 14:28:55  ERROR     gm.bootstrapper 
> (./bootstrap_gm_db_system.py::exit_with_msg() #1340): Cannot bootstrap 
> bundles.
> 2013-07-15 14:28:55  INFO      gm.bootstrapper 
> (./bootstrap_gm_db_system.py::exit_with_msg() #1341): shutdown
> 
> Let me know if you want the whole log 
> 
> -- Jim

-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346