{"action":"created","issue":{"url":"https://api.github.com/repos/pgracio/dhis2-docker/issues/1","labels_url":"https://api.github.com/repos/pgracio/dhis2-docker/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/pgracio/dhis2-docker/issues/1/comments","events_url":"https://api.github.com/repos/pgracio/dhis2-docker/issues/1/events","html_url":"https://github.com/pgracio/dhis2-docker/issues/1","id":58991960,"number":1,"title":"Error during initial fig up - `ERROR:  table \"XXXX\" does not exist`","user":{"login":"jcfr","id":219043,"avatar_url":"https://avatars.githubusercontent.com/u/219043?v=3","gravatar_id":"","url":"https://api.github.com/users/jcfr","html_url":"https://github.com/jcfr","followers_url":"https://api.github.com/users/jcfr/followers","following_url":"https://api.github.com/users/jcfr/following{/other_user}","gists_url":"https://api.github.com/users/jcfr/gists{/gist_id}","starred_url":"https://api.github.com/users/jcfr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jcfr/subscriptions","organizations_url":"https://api.github.com/users/jcfr/orgs","repos_url":"https://api.github.com/users/jcfr/repos","events_url":"https://api.github.com/users/jcfr/events{/privacy}","received_events_url":"https://api.github.com/users/jcfr/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-02-26T00:06:01Z","updated_at":"2015-03-12T20:11:07Z","closed_at":null,"body":"Thanks for putting this together. \r\n\r\nWhile this is not an issue to connect to dhis2, I noticed there are some error during the `fig up` process. You will find below the associated log where I remove some of the error messages to keep it shorter.\r\n\r\n```\r\n$ fig up\r\nCreating dhis2docker_db_1...\r\nPulling image pgracio/dhis2-db...\r\n2afff7d266cd: Download complete\r\n511136ea3c5a: Download complete\r\n27d47432a69b: Download complete\r\n5f92234dcf1e: Download complete\r\n51a9c7c1f8bb: Download complete\r\n5ba9dab47459: Download complete\r\n522f983b4df3: Download complete\r\n4ecdef27066f: Download complete\r\n0556798a536e: Download complete\r\nbcebed36cfc8: Download complete\r\nfa393e7f7e3d: Download complete\r\n8a142b98bd3f: Download complete\r\nb235e8799f8b: Download complete\r\n7c9218c963f6: Download complete\r\n8bb854090ec7: Download complete\r\n211c9ddca344: Download complete\r\n829220a5aef5: Download complete\r\nStatus: Downloaded newer image for pgracio/dhis2-db\r\nCreating dhis2docker_web_1...\r\nPulling image pgracio/dhis2-web...\r\nb84b5722af8c: Download complete\r\n511136ea3c5a: Download complete\r\n27d47432a69b: Download complete\r\n5f92234dcf1e: Download complete\r\n51a9c7c1f8bb: Download complete\r\n5ba9dab47459: Download complete\r\n522f983b4df3: Download complete\r\na3260890735a: Download complete\r\nada26aea72ef: Download complete\r\na05ae2b8827c: Download complete\r\n1ec6acd751e4: Download complete\r\nce440737cba3: Download complete\r\n6cdd30fc0d27: Download complete\r\nafd9c01368d3: Download complete\r\nbed10edab247: Download complete\r\n97ada575b597: Download complete\r\n957b8be3b81b: Download complete\r\n918ec662a013: Download complete\r\nStatus: Downloaded newer image for pgracio/dhis2-web\r\nAttaching to dhis2docker_db_1, dhis2docker_web_1\r\ndb_1  | 2015-02-25 23:40:56 UTC [5-1] LOG:  database system was interrupted; last known up at 2015-02-14 19:45:11 UTC\r\ndb_1  | 2015-02-25 23:40:56 UTC [5-2] LOG:  database system was not properly shut down; automatic recovery in progress\r\ndb_1  | 2015-02-25 23:40:56 UTC [5-3] LOG:  redo starts at 0/1782F68\r\ndb_1  | 2015-02-25 23:40:56 UTC [5-4] LOG:  record with zero length at 0/1782FA8\r\ndb_1  | 2015-02-25 23:40:56 UTC [5-5] LOG:  redo done at 0/1782F68\r\ndb_1  | 2015-02-25 23:40:56 UTC [5-6] LOG:  last completed transaction was at log time 2015-02-14 19:45:11.808319+00\r\ndb_1  | 2015-02-25 23:40:57 UTC [1-1] LOG:  database system is ready to accept connections\r\ndb_1  | 2015-02-25 23:40:57 UTC [9-1] LOG:  autovacuum launcher started\r\nweb_1 | Tomcat started.\r\nweb_1 | Tomcat started\r\nweb_1 | Feb 25, 2015 11:42:12 PM org.apache.catalina.startup.ClassLoaderFactory validateFile\r\nweb_1 | WARNING: Problem with directory [/usr/share/tomcat7/common/classes], exists: [false], isDirectory: [false], canRead: [false]\r\nweb_1 | Feb 25, 2015 11:42:12 PM org.apache.catalina.startup.ClassLoaderFactory validateFile\r\nweb_1 | WARNING: Problem with directory [/usr/share/tomcat7/common], exists: [false], isDirectory: [false], canRead: [false]\r\nweb_1 | Feb 25, 2015 11:42:12 PM org.apache.catalina.startup.ClassLoaderFactory validateFile\r\nweb_1 | WARNING: Problem with directory [/usr/share/tomcat7/server/classes], exists: [false], isDirectory: [false], canRead: [false]\r\nweb_1 | Feb 25, 2015 11:42:12 PM org.apache.catalina.startup.ClassLoaderFactory validateFile\r\nweb_1 | WARNING: Problem with directory [/usr/share/tomcat7/server], exists: [false], isDirectory: [false], canRead: [false]\r\nweb_1 | Feb 25, 2015 11:42:12 PM org.apache.catalina.startup.ClassLoaderFactory validateFile\r\nweb_1 | WARNING: Problem with directory [/usr/share/tomcat7/shared/classes], exists: [false], isDirectory: [false], canRead: [false]\r\nweb_1 | Feb 25, 2015 11:42:12 PM org.apache.catalina.startup.ClassLoaderFactory validateFile\r\nweb_1 | WARNING: Problem with directory [/usr/share/tomcat7/shared], exists: [false], isDirectory: [false], canRead: [false]\r\nweb_1 | Feb 25, 2015 11:42:12 PM org.apache.coyote.AbstractProtocol init\r\nweb_1 | INFO: Initializing ProtocolHandler [\"http-bio-8080\"]\r\nweb_1 | Feb 25, 2015 11:42:12 PM org.apache.catalina.startup.Catalina load\r\nweb_1 | INFO: Initialization processed in 544 ms\r\nweb_1 | Feb 25, 2015 11:42:12 PM org.apache.catalina.core.StandardService startInternal\r\nweb_1 | INFO: Starting service Catalina\r\nweb_1 | Feb 25, 2015 11:42:12 PM org.apache.catalina.core.StandardEngine startInternal\r\nweb_1 | INFO: Starting Servlet Engine: Apache Tomcat/7.0.52 (Ubuntu)\r\nweb_1 | Feb 25, 2015 11:42:13 PM org.apache.catalina.startup.HostConfig deployWAR\r\nweb_1 | INFO: Deploying web application archive /opt/dhis2/tomcat7/webapps/ROOT.war\r\nweb_1 | * INFO  2015-02-25 23:43:01,035 System property dhis2.home not set (DefaultLocationManager.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:01,037 Environment variable DHIS2_HOME points to /opt/dhis2/config (DefaultLocationManager.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:02,390 Hibernate configuration loaded, using dialect: org.hibernate.dialect.PostgreSQLDialect (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:16,711 Found the following message senders: [org.hisp.dhis.message.EmailMessageSender@37a287d5, org.hisp.dhis.sms.SmsMessageSender@7a847aa3] (DefaultMessageService.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:27,627 Detected apps: [] (DefaultAppManager.java [localhost-startStop-1])\r\nweb_1 | * WARN  2015-02-25 23:43:30,878 RP discovery / realm validation disabled;  (RealmVerifier.java [localhost-startStop-1])\r\ndb_1  | 2015-02-25 23:43:31 UTC [22-1] dhis@dhis2 ERROR:  column \"displayonallorgunit\" of relation \"program\" does not exist\r\ndb_1  | 2015-02-25 23:43:31 UTC [22-2] dhis@dhis2 STATEMENT:  ALTER TABLE program DROP COLUMN displayonallorgunit\r\nweb_1 | * INFO  2015-02-25 23:43:31,437 Executing startup routine [1 of 14, runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:31,536 Executing startup routine [2 of 14, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:31,657 Executing startup routine [3 of 14, runlevel 2]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:31,750 Added default category (DataElementDefaultDimensionPopulator.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:31,757 Linked default category with default concept (DataElementDefaultDimensionPopulator.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:31,770 Executing startup routine [4 of 14, runlevel 3]: TrackerIdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])\r\ndb_1  | 2015-02-25 23:43:32 UTC [25-1] dhis@dhis2 ERROR:  table \"categoryoptioncomboname\" does not exist\r\ndb_1  | 2015-02-25 23:43:32 UTC [25-2] dhis@dhis2 STATEMENT:  DROP TABLE categoryoptioncomboname\r\ndb_1  | 2015-02-25 23:43:32 UTC [26-1] dhis@dhis2 ERROR:  table \"orgunitgroupsetstructure\" does not exist\r\ndb_1  | 2015-02-25 23:43:32 UTC [26-2] dhis@dhis2 STATEMENT:  DROP TABLE orgunitgroupsetstructure\r\ndb_1  | 2015-02-25 23:43:32 UTC [27-1] dhis@dhis2 ERROR:  table \"orgunitstructure\" does not exist\r\ndb_1  | 2015-02-25 23:43:32 UTC [27-2] dhis@dhis2 STATEMENT:  DROP TABLE orgunitstructure\r\ndb_1  | 2015-02-25 23:43:32 UTC [28-1] dhis@dhis2 ERROR:  table \"orgunithierarchystructure\" does not exist\r\ndb_1  | 2015-02-25 23:43:32 UTC [28-2] dhis@dhis2 STATEMENT:  DROP TABLE orgunithierarchystructure\r\ndb_1  | 2015-02-25 23:43:32 UTC [29-1] dhis@dhis2 ERROR:  table \"orgunithierarchy\" does not exist\r\ndb_1  | 2015-02-25 23:43:32 UTC [29-2] dhis@dhis2 STATEMENT:  DROP TABLE orgunithierarchy\r\n[...]\r\nweb_1 | * INFO  2015-02-25 23:43:36,681 Executing startup routine [8 of 14, runlevel 4]: IdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:37,064 Executing startup routine [9 of 14, runlevel 5]: TableCreator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:37,082 Created table/index messageconversation_lastmessage (TableCreator.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:37,088 Created table/index interpretation_lastupdated (TableCreator.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:37,089 Executing startup routine [10 of 14, runlevel 7]: MapViewUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])\r\ndb_1  | 2015-02-25 23:43:37 UTC [728-1] dhis@dhis2 ERROR:  column \"bounds\" of relation \"mapview\" does not exist\r\ndb_1  | 2015-02-25 23:43:37 UTC [728-2] dhis@dhis2 STATEMENT:  alter table mapview drop column bounds\r\ndb_1  | 2015-02-25 23:43:37 UTC [729-1] dhis@dhis2 ERROR:  column \"code\" of relation \"mapview\" does not exist\r\ndb_1  | 2015-02-25 23:43:37 UTC [729-2] dhis@dhis2 STATEMENT:  alter table mapview drop column code\r\ndb_1  | 2015-02-25 23:43:37 UTC [730-1] dhis@dhis2 ERROR:  column \"periodtypeid\" of relation \"mapview\" does not exist\r\ndb_1  | 2015-02-25 23:43:37 UTC [730-2] dhis@dhis2 STATEMENT:  alter table mapview drop column periodtypeid\r\ndb_1  | 2015-02-25 23:43:37 UTC [732-1] dhis@dhis2 ERROR:  column \"valuetype\" does not exist at character 50\r\ndb_1  | 2015-02-25 23:43:37 UTC [732-2] dhis@dhis2 STATEMENT:  update mapview set valuetype='dataElement' where valuetype='dataelement'\r\ndb_1  | 2015-02-25 23:43:37 UTC [735-1] dhis@dhis2 ERROR:  column \"name\" does not exist at character 19\r\ndb_1  | 2015-02-25 23:43:37 UTC [735-2] dhis@dhis2 STATEMENT:  select mapviewid, name, userid, longitude, latitude, zoom from mapview where mapviewid not in (select mapviewid from mapmapviews)\r\nweb_1 | * INFO  2015-02-25 23:43:37,179 Executing startup routine [11 of 14, runlevel 7]: DataEntryFormUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:37,183 Upgraded custom case entry form identifiers (DataEntryFormUpgrader.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:37,184 Executing startup routine [12 of 14, runlevel 8]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:37,197 Executing startup routine [13 of 14, runlevel 9]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:37,206 Executing startup routine [14 of 14, runlevel 9]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:37,302 Populated default locales (I18nLocalePopulator.java [localhost-startStop-1])\r\nweb_1 | * INFO  2015-02-25 23:43:37,302 All startup routines done (DefaultStartupRoutineExecutor.java [localhost-startStop-1])\r\nweb_1 | * WARN  2015-02-25 23:43:43,436 Did not find any ViewResolvers to delegate to; please configure them using the 'viewResolvers' property on the ContentNegotiatingViewResolver (ContentNegotiatingViewResolver.java [localhost-startStop-1])\r\nweb_1 | * WARN  2015-02-25 23:43:44,614 Did not find any ViewResolvers to delegate to; please configure them using the 'viewResolvers' property on the ContentNegotiatingViewResolver (ContentNegotiatingViewResolver.java [localhost-startStop-1])\r\nweb_1 | Feb 25, 2015 11:43:44 PM org.apache.coyote.AbstractProtocol start\r\nweb_1 | INFO: Starting ProtocolHandler [\"http-bio-8080\"]\r\nweb_1 | Feb 25, 2015 11:43:44 PM org.apache.catalina.startup.Catalina start\r\nweb_1 | INFO: Server startup in 91880 ms\r\n```"},"comment":{"url":"https://api.github.com/repos/pgracio/dhis2-docker/issues/comments/78594941","html_url":"https://github.com/pgracio/dhis2-docker/issues/1#issuecomment-78594941","issue_url":"https://api.github.com/repos/pgracio/dhis2-docker/issues/1","id":78594941,"user":{"login":"jcfr","id":219043,"avatar_url":"https://avatars.githubusercontent.com/u/219043?v=3","gravatar_id":"","url":"https://api.github.com/users/jcfr","html_url":"https://github.com/jcfr","followers_url":"https://api.github.com/users/jcfr/followers","following_url":"https://api.github.com/users/jcfr/following{/other_user}","gists_url":"https://api.github.com/users/jcfr/gists{/gist_id}","starred_url":"https://api.github.com/users/jcfr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jcfr/subscriptions","organizations_url":"https://api.github.com/users/jcfr/orgs","repos_url":"https://api.github.com/users/jcfr/repos","events_url":"https://api.github.com/users/jcfr/events{/privacy}","received_events_url":"https://api.github.com/users/jcfr/received_events","type":"User","site_admin":false},"created_at":"2015-03-12T20:11:07Z","updated_at":"2015-03-12T20:11:07Z","body":"Hi, \r\n\r\nThanks for your answer.\r\n\r\nEverything works fine afterward. Wasn't sure if this was expected or not. In case there was an easy to shut down these errors/warnings, i guess it would be nice to do it."}}