2005-05-18 08:51:22 ------------------------------------------------------------ 2005-05-18 08:51:22 [INFO] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmLog.py:address@hidden): SECURITY: initial log level is [INFO] 2005-05-18 08:51:22 [INFO] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmLog.py:address@hidden): instantiated log file /home/richard/gnumed/gnumed/server/bootstrap/redo-public.log with ID /home/richard/gnumed/gnumed/server/bootstrap/redo-public.log 2005-05-18 08:51:22 [INFO] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmCfg.py:address@hidden): $Revision: 1.26 $ 2005-05-18 08:51:22 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): $Revision: 1.4 $ 2005-05-18 08:51:22 [INFO] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmPG.py:address@hidden): $Revision: 1.47 $ 2005-05-18 08:51:22 [INFO] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmI18N.py:address@hidden): $Revision: 1.7 $ 2005-05-18 08:51:22 [ERROR] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmI18N.py:address@hidden): the system locale is not set to anything or is [C], assuming [en_EN] 2005-05-18 08:51:22 [INFO] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmI18N.py:address@hidden): text domain is "bootstrap_gm_db_system" 2005-05-18 08:51:22 [INFO] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmPG.py:address@hidden): DBMS [PostgreSQL] via DB-API module "": API level 2.0, thread safety 1, parameter style "pyformat" 2005-05-18 08:51:22 [INFO] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmPG.py:address@hidden): client encoding according to locale system: [ANSI_X3.4-1968] 2005-05-18 08:51:22 [INFO] (/home/richard/gnumed/gnumed/server/bootstrap/gmAuditSchemaGenerator.py:address@hidden): $Revision: 1.22 $ 2005-05-18 08:51:22 [INFO] (/home/richard/gnumed/gnumed/server/bootstrap/gmNotificationSchemaGenerator.py:address@hidden): $Revision: 1.11 $ 2005-05-18 08:51:22 [INFO] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmLog.py:address@hidden): SECURITY: log level change from [INFO] to [DATA] 2005-05-18 08:51:22 [INFO] (./bootstrap_gm_db_system.py:address@hidden): startup ($Revision: 1.5 $) 2005-05-18 08:51:22 [DATA] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmCfg.py:address@hidden): (, ) 2005-05-18 08:51:22 [INFO] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmCfg.py:address@hidden): ignoring command line per cfg_IGNORE_CMD_LINE 2005-05-18 08:51:22 [DATA] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmCfg.py:address@hidden): config file search order: ['/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf'] 2005-05-18 08:51:22 [INFO] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmCfg.py:address@hidden): found config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf] 2005-05-18 08:51:22 [DATA] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmCfg.py:address@hidden): parsing config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf] 2005-05-18 08:51:22 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping GnuMed database system from file [$Source: /cvsroot/gnumed/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf,v $] ($Revision: 1.1 $) 2005-05-18 08:51:22 [WARN] (./bootstrap_gm_db_system.py:address@hidden): not running as root, cannot become postmaster demon user 2005-05-18 08:51:22 [WARN] (./bootstrap_gm_db_system.py:address@hidden): may have trouble connecting as gm-dbo if IDENT auth is forced upon us 2005-05-18 08:51:26 [DATA] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmCfg.py:address@hidden): (, ) 2005-05-18 08:51:26 [INFO] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmCfg.py:address@hidden): ignoring command line per cfg_IGNORE_CMD_LINE 2005-05-18 08:51:26 [DATA] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmCfg.py:address@hidden): config file search order: ['/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf'] 2005-05-18 08:51:26 [INFO] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmCfg.py:address@hidden): found config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf] 2005-05-18 08:51:26 [DATA] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmCfg.py:address@hidden): parsing config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf] 2005-05-18 08:51:26 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping GnuMed database system from file [$Source: /cvsroot/gnumed/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf,v $] ($Revision: 1.31 $) 2005-05-18 08:51:26 [WARN] (./bootstrap_gm_db_system.py:address@hidden): not running as root, cannot become postmaster demon user 2005-05-18 08:51:26 [WARN] (./bootstrap_gm_db_system.py:address@hidden): may have trouble connecting as gm-dbo if IDENT auth is forced upon us 2005-05-18 08:51:28 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping service [config] 2005-05-18 08:51:28 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database [core] 2005-05-18 08:51:28 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping server [local host] 2005-05-18 08:51:28 [INFO] (./bootstrap_gm_db_system.py:address@hidden): connecting to template database 2005-05-18 08:51:28 [INFO] (./bootstrap_gm_db_system.py:address@hidden): DB connection to template1 on localhost as postgres 2005-05-18 08:51:28 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully connected to template database [template1] 2005-05-18 08:51:28 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database users and groups 2005-05-18 08:51:28 [WARN] (/usr/lib/python2.3/site-packages/Gnumed/pycommon/gmCfg.py:address@hidden): option not found in group [user GnuMed owner] 2005-05-18 08:51:29 [INFO] (./bootstrap_gm_db_system.py:address@hidden): User [gm-dbo] exists. 2005-05-18 08:51:29 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-doctors exists. 2005-05-18 08:51:29 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-staff_medical exists. 2005-05-18 08:51:29 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-staff_office exists. 2005-05-18 08:51:29 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-trainees_medical exists. 2005-05-18 08:51:29 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-trainees_office exists. 2005-05-18 08:51:29 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-public exists. 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): CREATE USER "any-doc" WITH PASSWORD 'any-doc' IN GROUP "gm-doctors", "gm-public" 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmPublicAccounts.sql:26: ERROR: CREATE USER: user name "any-doc" already exists 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmPublicAccounts.sql,v $', '$Revision: 1.5 $') 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmPublicAccounts.sql:30: ERROR: Relation "gm_schema_revision" does not exist 2005-05-18 08:51:30 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmPublicAccounts.sql] 2005-05-18 08:51:30 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmTestAccounts.sql] 2005-05-18 08:51:30 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping procedural languages 2005-05-18 08:51:30 [INFO] (./bootstrap_gm_db_system.py:address@hidden): installing procedural language [pg/SQL] 2005-05-18 08:51:30 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Language plpgsql exists. 2005-05-18 08:51:30 [INFO] (./bootstrap_gm_db_system.py:address@hidden): DB connection to template1 on localhost as gm-dbo 2005-05-18 08:51:30 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Database [gnumed] does not exist. 2005-05-18 08:51:30 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Database [gnumed] exists. 2005-05-18 08:51:30 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Successfully created GnuMed database [gnumed]. 2005-05-18 08:51:30 [INFO] (./bootstrap_gm_db_system.py:address@hidden): DB connection to gnumed on localhost as gm-dbo 2005-05-18 08:51:30 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmSchemaRevision.sql] 2005-05-18 08:51:30 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmServices.sql] 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_missing_translations 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmI18N.sql:225: ERROR: view "v_missing_translations" does not exist 2005-05-18 08:51:30 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmI18N.sql] 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function add_table_for_audit (name) 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit.sql:26: ERROR: RemoveFunction: function add_table_for_audit(name) does not exist 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_fields_no_ins on audit_fields cascade 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit.sql:73: ERROR: Rule "audit_fields_no_ins" not found 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_fields_no_ins 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit.sql:74: ERROR: parser: parse error at end of input 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_fields_no_upd on audit_fields cascade 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit.sql:75: ERROR: Rule "audit_fields_no_upd" not found 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_fields_no_upd 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit.sql:76: ERROR: parser: parse error at end of input 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_fields_no_del on audit_fields cascade 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit.sql:77: ERROR: Rule "audit_fields_no_del" not found 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_fields_no_del 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit.sql:78: ERROR: parser: parse error at end of input 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_trail_no_ins on audit_trail cascade 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit.sql:130: ERROR: Rule "audit_trail_no_ins" not found 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_trail_no_ins 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit.sql:131: ERROR: parser: parse error at end of input 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_trail_no_upd on audit_trail cascade 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit.sql:132: ERROR: Rule "audit_trail_no_upd" not found 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_trail_no_upd 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit.sql:133: ERROR: parser: parse error at end of input 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_trail_no_del on audit_trail cascade 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit.sql:134: ERROR: Rule "audit_trail_no_del" not found 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_trail_no_del 2005-05-18 08:51:30 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit.sql:135: ERROR: parser: parse error at end of input 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmAudit.sql] 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function add_x_db_fk_def (name, name, text, name, name) 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmCrossDB_FKs.sql:61: ERROR: RemoveFunction: function add_x_db_fk_def(name, name, text, name, name) does not exist 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmCrossDB_FKs.sql] 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_x_db_fk_violation 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmCrossDB_FK-views.sql:63: ERROR: view "v_x_db_fk_violation" does not exist 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function log_x_db_fk_violation (integer, text, text, text) 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmCrossDB_FK-views.sql:94: ERROR: RemoveFunction: function log_x_db_fk_violation(integer, text, text, text) does not exist 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmCrossDB_FK-views.sql] 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function add_table_for_scoring(name) 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmScoring.sql:30: ERROR: RemoveFunction: function add_table_for_scoring(name) does not exist 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmScoring.sql] 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function add_table_for_notifies (name) 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmNotifications.sql:28: ERROR: RemoveFunction: function add_table_for_notifies(name) does not exist 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function add_table_for_notifies (name, name) 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmNotifications.sql:29: ERROR: RemoveFunction: function add_table_for_notifies(name, name) does not exist 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmNotifications.sql] 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmHousekeeping.sql] 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): service [default] not installed here yet 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): installed PostgreSQL version: [PostgreSQL 7.3.4 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.2 (Debian)] - this is fine with me 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmconfiguration.sql] 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmConfigData.sql] 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_cfg_options 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmConfigViews.sql:13: ERROR: view "v_cfg_options" does not exist 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_cfg_opts_numeric 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmConfigViews.sql:36: ERROR: view "v_cfg_opts_numeric" does not exist 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_cfg_opts_string 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmConfigViews.sql:62: ERROR: view "v_cfg_opts_string" does not exist 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_cfg_opts_str_array 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmConfigViews.sql:88: ERROR: view "v_cfg_opts_str_array" does not exist 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_cfg_opts_data 2005-05-18 08:51:31 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmConfigViews.sql:114: ERROR: view "v_cfg_opts_data" does not exist 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmConfigViews.sql] 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Registering service [config] (GnuMed internal name: [default]). 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Service [default] resides in core database. 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): It will be automatically recognized by GnuMed. 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping service [reference] 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database [core] 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): database [core] already bootstrapped 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): service [reference] not installed here yet 2005-05-18 08:51:31 [INFO] (./bootstrap_gm_db_system.py:address@hidden): installed PostgreSQL version: [PostgreSQL 7.3.4 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.2 (Debian)] - this is fine with me 2005-05-18 08:51:32 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmReference.sql] 2005-05-18 08:51:32 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmReference-data.sql] 2005-05-18 08:51:32 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Registering service [reference] (GnuMed internal name: [reference]). 2005-05-18 08:51:32 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Service [reference] resides in core database. 2005-05-18 08:51:32 [INFO] (./bootstrap_gm_db_system.py:address@hidden): It will be automatically recognized by GnuMed. 2005-05-18 08:51:32 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping service [demographics] 2005-05-18 08:51:32 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database [core] 2005-05-18 08:51:32 [INFO] (./bootstrap_gm_db_system.py:address@hidden): database [core] already bootstrapped 2005-05-18 08:51:32 [INFO] (./bootstrap_gm_db_system.py:address@hidden): service [personalia] not installed here yet 2005-05-18 08:51:32 [INFO] (./bootstrap_gm_db_system.py:address@hidden): installed PostgreSQL version: [PostgreSQL 7.3.4 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.2 (Debian)] - this is fine with me 2005-05-18 08:51:33 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics.sql] 2005-05-18 08:51:33 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics-Grants.sql] 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_identity_dob 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:11: ERROR: index "idx_identity_dob" does not exist 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_names_last_first 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:12: ERROR: index "idx_names_last_first" does not exist 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_names_firstnames 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:13: ERROR: index "idx_names_firstnames" does not exist 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_uniq_act_name 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:27: ERROR: index "idx_uniq_act_name" does not exist 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop trigger tr_uniq_active_name on names 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:36: ERROR: DropTrigger: there is no trigger tr_uniq_active_name on relation names 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function f_uniq_active_name() 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:37: ERROR: RemoveFunction: function f_uniq_active_name() does not exist 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop trigger tr_always_active_name on names 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:39: ERROR: DropTrigger: there is no trigger tr_always_active_name on relation names 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function f_always_active_name() 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:40: ERROR: RemoveFunction: function f_always_active_name() does not exist 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop trigger TR_delete_names on identity 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:82: ERROR: DropTrigger: there is no trigger tr_delete_names on relation identity 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function F_delete_names() 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:83: ERROR: RemoveFunction: function f_delete_names() does not exist 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function add_name(integer, text, text, bool) 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:101: ERROR: RemoveFunction: function add_name(integer, text, text, boolean) does not exist 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function set_nickname(integer, text) 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:132: ERROR: RemoveFunction: function set_nickname(integer, text) does not exist 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function create_occupation(text) 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:176: ERROR: RemoveFunction: function create_occupation(text) does not exist 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function create_person_comm(integer, text, text, bool) 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:194: ERROR: RemoveFunction: function create_person_comm(integer, text, text, boolean) does not exist 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function new_pupic() cascade 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:228: ERROR: RemoveFunction: function new_pupic() does not exist 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function new_pupic() 2005-05-18 08:51:33 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:229: ERROR: RemoveFunction: function new_pupic() does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_gender_labels 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:241: ERROR: view "v_gender_labels" does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_basic_person cascade 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:259: ERROR: view "v_basic_person" does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_basic_person 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:260: ERROR: view "v_basic_person" does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_staff 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:327: ERROR: view "v_staff" does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view lnk_person2address 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:356: ERROR: view "lnk_person2address" does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view lnk_org2address 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:357: ERROR: view "lnk_org2address" does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_person_comms_flat cascade 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:370: ERROR: view "v_person_comms_flat" does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_person_comms_flat 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:371: ERROR: view "v_person_comms_flat" does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_lnk_pers2rel 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:404: ERROR: index "idx_lnk_pers2rel" does not exist 2005-05-18 08:51:34 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics-Person-views.sql] 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-data.sql:14: starting transaction 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-data.sql:30: transaction committed 2005-05-18 08:51:34 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics-Person-data.sql] 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_basic_address 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:18: ERROR: view "v_basic_address" does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): DROP FUNCTION create_urb(text, text, text, text) 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:48: ERROR: RemoveFunction: function create_urb(text, text, text, text) does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): DROP FUNCTION create_street(text, text, text, text, text) 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:96: ERROR: RemoveFunction: function create_street(text, text, text, text, text) does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): DROP FUNCTION create_address(text, text, text, text, text, text) 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:135: ERROR: RemoveFunction: function create_address(text, text, text, text, text, text) does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_zip2street cascade 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:177: ERROR: view "v_zip2street" does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_zip2street 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:178: ERROR: view "v_zip2street" does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_zip2urb 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:211: ERROR: view "v_zip2urb" does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_uniq_zipped_urbs 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:239: ERROR: view "v_uniq_zipped_urbs" does not exist 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_zip2data 2005-05-18 08:51:34 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:281: ERROR: view "v_zip2data" does not exist 2005-05-18 08:51:34 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics-GIS-views.sql] 2005-05-18 08:51:35 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics-GIS-data.sql] 2005-05-18 08:51:35 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics-Org-views.sql] 2005-05-18 08:51:35 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Registering service [demographics] (GnuMed internal name: [personalia]). 2005-05-18 08:51:35 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Service [personalia] resides in core database. 2005-05-18 08:51:35 [INFO] (./bootstrap_gm_db_system.py:address@hidden): It will be automatically recognized by GnuMed. 2005-05-18 08:51:35 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping service [clinical] 2005-05-18 08:51:35 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database [core] 2005-05-18 08:51:35 [INFO] (./bootstrap_gm_db_system.py:address@hidden): database [core] already bootstrapped 2005-05-18 08:51:35 [INFO] (./bootstrap_gm_db_system.py:address@hidden): service [historica] not installed here yet 2005-05-18 08:51:35 [INFO] (./bootstrap_gm_db_system.py:address@hidden): installed PostgreSQL version: [PostgreSQL 7.3.4 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.2 (Debian)] - this is fine with me 2005-05-18 08:51:37 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmclinical.sql] 2005-05-18 08:51:38 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): alter table test_result add constraint numval_needs_unit check ( ((val_num is not null) and (trim(coalesce(val_unit, '') != ''))) or (val_num is null) ) 2005-05-18 08:51:38 [ERROR] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmMeasurements.sql:264: ERROR: Function pg_catalog.btrim(boolean) does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts 2005-05-18 08:51:38 [ERROR] (./bootstrap_gm_db_system.py:address@hidden): failed to import [../sql/gmMeasurements.sql] 2005-05-18 08:51:38 [ERROR] (./bootstrap_gm_db_system.py:address@hidden): Cannot import schema definition for service [clinical] into database [core]. 2005-05-18 08:51:38 [ERROR] (./bootstrap_gm_db_system.py:address@hidden): Cannot bootstrap services. 2005-05-18 08:51:38 [INFO] (./bootstrap_gm_db_system.py:address@hidden): shutdown