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

[Busser, Jim]

On 2013-07-14, at 12:08 PM, Karsten Hilbert <address@hidden> wrote:

> I have pushed this whole shebang of coding frenzy into the
> public repository. It should be stress-tested for bugs.

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

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