[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gnumed-bugs] Problem in git bootstrapping v18 to v19 db
From: |
Busser, Jim |
Subject: |
[Gnumed-bugs] Problem in git bootstrapping v18 to v19 db |
Date: |
Tue, 16 Jul 2013 00:11:10 +0000 |
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
- [Gnumed-bugs] Problem in git bootstrapping v18 to v19 db,
Busser, Jim <=
- Re: [Gnumed-bugs] Problem in git bootstrapping v18 to v19 db, Karsten Hilbert, 2013/07/16
- [Gnumed-bugs] database version requirement switch: 9.1, was: Problem in git bootstrapping v18 to v19 db, Karsten Hilbert, 2013/07/17
- Re: [Gnumed-bugs] [Gnumed-devel] database version requirement switch: 9.1, was: Problem in git bootstrapping v18 to v19 db, Busser, Jim, 2013/07/17
- Re: [Gnumed-bugs] [Gnumed-devel] database version requirement switch: 9.1, was: Problem in git bootstrapping v18 to v19 db, Karsten Hilbert, 2013/07/17
- Re: [Gnumed-bugs] [Gnumed-devel] database version requirement switch: 9.1, was: Problem in git bootstrapping v18 to v19 db, Busser, Jim, 2013/07/17
- Re: [Gnumed-bugs] [Gnumed-devel] database version requirement switch: 9.1, was: Problem in git bootstrapping v18 to v19 db, Karsten Hilbert, 2013/07/18
- Re: [Gnumed-bugs] [Gnumed-devel] database version requirement switch: 9.1, was: Problem in git bootstrapping v18 to v19 db, Busser, Jim, 2013/07/18
- Re: [Gnumed-bugs] [Gnumed-devel] database version requirement switch: 9.1, was: Problem in git bootstrapping v18 to v19 db, Karsten Hilbert, 2013/07/18