Skip to content
This repository has been archived by the owner on Jun 19, 2019. It is now read-only.

Exceptions and Errors #27

Closed
mictadlo opened this issue Jul 4, 2018 · 48 comments
Closed

Exceptions and Errors #27

mictadlo opened this issue Jul 4, 2018 · 48 comments

Comments

@mictadlo
Copy link

mictadlo commented Jul 4, 2018

Hi,
I set up docker-apollo inside a docker-compose.yml file:

apollo:
  image: quay.io/gmod/docker-apollo:latest
  restart: always
  ports:
    - "8888:8080"
  volumes:
    - ./data//jbrowse:/data
    - ./data/postgres-data:/var/lib/postgresql

While starting up I got the following Errors and Exceptions:

...


apollo_1          | WARNING: enabling "trust" authentication for local connections
apollo_1          | You can change this by editing pg_hba.conf or using the option -A, or
apollo_1          | --auth-local and --auth-host, the next time you run initdb.
apollo_1          | Starting PostgreSQL 9.6 database server: main.
apollo_1          | WEBAPOLLO_HOST_FLAG: 
apollo_1          | CHADO_HOST_FLAG: 
apollo_1          | Waiting for DB
apollo_1          | /var/run/postgresql:5432 - accepting connections
apollo_1          | Postgres is up, configuring database
apollo_1          | psql: FATAL:  Peer authentication failed for user "apollo-lqt"
apollo_1          | Apollo database not found, creating...
apollo_1          | CREATE ROLE
apollo_1          | GRANT
apollo_1          | Configuring Chado
apollo_1          | psql: FATAL:  Peer authentication failed for user "apollo"
apollo_1          | Chado database not found, creating...
apollo_1          | ERROR:  role "apollo" already exists
apollo_1          | GRANT
apollo_1          | Loading Chado

...

apollo_1          | CREATE EXTENSION
apollo_1          | psql:/chado.sql:49: ERROR:  must be owner of extension plpgsql
apollo_1          | SET

...

apollo_1          | ALTER TABLE
apollo_1          | SET
apollo_1          | psql:/chado.sql:2637928: ERROR:  function create_point(integer, bigint) does not exist
apollo_1          | LINE 1: SELECT box (create_point(0, $1), create_point($2,500000000))
apollo_1          |                     ^
apollo_1          | HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
apollo_1          | QUERY:  SELECT box (create_point(0, $1), create_point($2,500000000))
apollo_1          | CONTEXT:  SQL function "boxrange" during inlining
apollo_1          | CREATE INDEX

...

apollo_1          | Loaded Chado
apollo_1          | Restarting tomcat with /usr/local/tomcat/
apollo_1          | Jul 04, 2018 10:25:47 AM org.apache.catalina.startup.Catalina stopServer
apollo_1          | SEVERE: Could not contact [localhost:[8005]]. Tomcat may not be running.
apollo_1          | Jul 04, 2018 10:25:47 AM org.apache.catalina.startup.Catalina stopServer
apollo_1          | SEVERE: Catalina.stop: 
apollo_1          | java.net.ConnectException: Connection refused (Connection refused)
apollo_1          | 	at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1          | 	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1          | 	at java.net.Socket.connect(Socket.java:589)
apollo_1          | 	at java.net.Socket.connect(Socket.java:538)
apollo_1          | 	at java.net.Socket.<init>(Socket.java:434)
apollo_1          | 	at java.net.Socket.<init>(Socket.java:211)
apollo_1          | 	at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:497)
apollo_1          | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apollo_1          | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apollo_1          | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apollo_1          | 	at java.lang.reflect.Method.invoke(Method.java:498)
apollo_1          | 	at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:406)
apollo_1          | 	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:495)
apollo_1          | 
apollo_1          | Tomcat started.

...

apollo_1          | Shiro Configured
apollo_1          | 2018-07-04 10:26:36,175 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table allele add constraint FK_ssx0gv6xbtu3tbwt6ekkmn4iw foreign key (variant_id) references feature
apollo_1          | 2018-07-04 10:26:36,179 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: constraint "fk_ssx0gv6xbtu3tbwt6ekkmn4iw" for relation "allele" already exists
apollo_1          | 2018-07-04 10:26:43,169 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table chadoprop add column cvterm_id int8 not null
apollo_1          | 2018-07-04 10:26:43,169 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: column "cvterm_id" contains null values
apollo_1          | 2018-07-04 10:26:49,561 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table chadoprop add constraint FK_8twb5n8vjmldyy3eeyq7sppc3 foreign key (cvterm_id) references cvterm
apollo_1          | 2018-07-04 10:26:49,561 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: column "cvterm_id" referenced in foreign key constraint does not exist
apollo_1          | Starting Quartz Scheduler in QuartzFactoryBean
apollo_1   

...

apollo_1          | 2018-07-04 10:27:47,437 [http-nio-8080-exec-6] WARN  apollo.PreferenceService  - No user present, so using the client token
apollo_1          | 2018-07-04 10:27:47,486 [http-nio-8080-exec-3] ERROR apollo.PermissionService  - Username not supplied so can not authenticate.
apollo_1          | 2018-07-04 10:27:47,495 [http-nio-8080-exec-3] ERROR apollo.PermissionService  - User null does not exist in the database.
apollo_1          | 2018-07-04 10:27:47,549 [http-nio-8080-exec-10] ERROR authenticator.UsernamePasswordAuthenticatorService  - Problem authenticating: java.lang.IllegalArgumentException: Method argumet (authentication token) cannot be null.
apollo_1          | 2018-07-04 10:27:47,550 [http-nio-8080-exec-10] WARN  apollo.PermissionService  - Failed to authenticate user
apollo_1          | 2018-07-04 10:27:47,550 [http-nio-8080-exec-10] ERROR apollo.UserController  - Failed to authenticate

What did I miss?

Thank you in advance.

Michal

@nathandunn
Copy link

nathandunn commented Jul 4, 2018 via email

@mictadlo
Copy link
Author

mictadlo commented Jul 5, 2018

Hi,
What do you mean by any advanced features of Apollo?

We try to set up a portal which contains blast server (sequenceserver), our own webpage, Apollo for annotation and jbrowse for displaying the data. Furthermore, we thinking to include more web tools.

Our current docker-compose.yml is:

phpapache:
    build: php-apache
    restart: always
    ports:
        - "8080:80"
    links:
        - db
    volumes:
        - ./html/:/var/www/html

db:
  image: mariadb
  restart: always
  environment:
    - MYSQL_ROOT_PASSWORD=xxxx
    - MYSQL_DATABASE=ben
    - MYSQL_USER=ben
    - MYSQL_PASSWORD=xxxx
  ports:
    - "3306:3306" 
  volumes:
    - ./mysql/:/docker-entrypoint-initdb.d 

phpmyadmin:
  image: phpmyadmin/phpmyadmin
  restart: always
  links:
    - db
  ports:
    - 8183:80
  environment:
    PMA_USER: root
    PMA_PASSWORD: xxx
    PMA_ARBITRARY: 1

sequenceserver:
  build: sequenceserver
  restart: always
  ports:
    - "4567:4567"
  volumes:
    - ./data/sequenceserver:/dbs

apollo:
  image: quay.io/gmod/docker-apollo:latest 
  restart: always
  ports:
    - "8888:8080"
  volumes:
    - ./data//jbrowse:/data 
    - ./data/postgres-data:/var/lib/postgresql

I assume apollo-only would work, too. Do you have any recommendations on how to set it up?

Thank you in advance,

Michal

@nathandunn
Copy link

By "advanced-features" I think I meant Chado export, but that's not really an advanced feature. Sorry for the red herring.

For doing what you are doing, I what look more closely at https://github.com/galaxy-genome-annotation/docker-galaxy-genome-annotation and use the apollo-only target with modifications (you should fork this project). If you look closely at the dockererized version of gmod/apollo:latest you can see it does a lot of configuraiton of database, etc. You can also configure Apollo to use BLAST (though may not be what you want) and you Apollo to show BLAST results in addition to JBrowse (they can both use the same directory).

@mictadlo
Copy link
Author

mictadlo commented Jul 8, 2018

I changed it to ENV WEBAPOLLO_VERSION 6189ff9e2973e1523ddcdbeee9d258c435c42a54 but I still got:

apollo_1          | Restarting tomcat with /usr/local/tomcat/
apollo_1          | Jul 08, 2018 8:51:22 PM org.apache.catalina.startup.Catalina stopServer
apollo_1          | SEVERE: Could not contact [localhost:[8005]]. Tomcat may not be running.
apollo_1          | Jul 08, 2018 8:51:22 PM org.apache.catalina.startup.Catalina stopServer
apollo_1          | SEVERE: Catalina.stop: 
apollo_1          | java.net.ConnectException: Connection refused (Connection refused)
apollo_1          | 	at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1          | 	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1          | 	at java.net.Socket.connect(Socket.java:589)
apollo_1          | 	at java.net.Socket.connect(Socket.java:538)
apollo_1          | 	at java.net.Socket.<init>(Socket.java:434)
apollo_1          | 	at java.net.Socket.<init>(Socket.java:211)
apollo_1          | 	at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:497)
apollo_1          | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apollo_1          | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apollo_1          | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apollo_1          | 	at java.lang.reflect.Method.invoke(Method.java:498)
apollo_1          | 	at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:406)
apollo_1          | 	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:495)
apollo_1          | 
apollo_1          | Tomcat started.

What did I miss?

The docker-galaxy-genome-annotation looks nice.

Thank you in advance.

Michal

@nathandunn
Copy link

I updated the apollo-only target. If you can provide me with a repo to debug that would be great.

So, you should (in a few minutes from this post), be able to use:

apollo:
  image: quay.io/gmod/docker-apollo:apollo-only 
  restart: always
  ports:
    - "8888:8080"
  volumes:
    - ./data//jbrowse:/data 
    - ./data/postgres-data:/var/lib/postgresql

However, I would also explore, though they may be less up-to-date (though possibly sufficient for what you need):

If you're interested in joining that group, it might be a great forum to ask questions, as well.

@mictadlo
Copy link
Author

mictadlo commented Jul 9, 2018

I used this one.

@nathandunn
Copy link

@mictadlo That should be fine, but where did you use it? Where is it pulling the build from?

@mictadlo
Copy link
Author

mictadlo commented Jul 9, 2018

I clone it and modified locally.

@nathandunn
Copy link

I see. So, that is a different then the docker-compose file above?

If you could provide me with that either off-line or here, that would be ideal so that we are on the same page for building.

The difference is that the apollo-only branch builds only apollo whereas the master branch builds that plus postgresql, etc. Though, that being said, maybe you want the master branch anyway looking at your compose script. Either way, its hard for me to test without having your system.

However, if you are able to get on your running system and provide logs for both tomcat and postgresql, that would be helpful.

@mictadlo
Copy link
Author

mictadlo commented Jul 11, 2018

I think this looks the best because it has all built in.

However, I do not understand why it is required to have two of the same images:

jbrowse:
  image: erasche/jbrowse:1.12.0
  volumes_from:
      - "galaxy:ro"

jbrowse-graphql:
  image: erasche/jbrowse:1.12.0
  volumes:
      - "./jbgraphql:/data"

apollo-only casused the following problems some of them are related that I did not have postgresql in my docker-compose file:

Digest: sha256:c0c55e5c2dcff1f2b9c1ef33819af3eda274087d02f0a4843f4f576384a061ac
Status: Downloaded newer image for quay.io/gmod/docker-apollo:apollo-only
benthgenome_sequenceserver_1 is up-to-date
Recreating benthgenome_apollo_1
benthgenome_db_1 is up-to-date
benthgenome_phpmyadmin_1 is up-to-date
benthgenome_phpapache_1 is up-to-date
Attaching to benthgenome_sequenceserver_1, benthgenome_db_1, benthgenome_phpmyadmin_1, benthgenome_phpapache_1, benthgenome_apollo_1
apollo_1          | Stopping tomcat with /usr/local/tomcat/
apollo_1          | Jul 11, 2018 2:00:50 PM org.apache.catalina.startup.Catalina stopServer
apollo_1          | SEVERE: Could not contact [localhost:[8005]]. Tomcat may not be running.
apollo_1          | Jul 11, 2018 2:00:50 PM org.apache.catalina.startup.Catalina stopServer
apollo_1          | SEVERE: Catalina.stop: 
apollo_1          | java.net.ConnectException: Connection refused (Connection refused)
apollo_1          | 	at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1          | 	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1          | 	at java.net.Socket.connect(Socket.java:589)
apollo_1          | 	at java.net.Socket.connect(Socket.java:538)
apollo_1          | 	at java.net.Socket.<init>(Socket.java:434)
apollo_1          | 	at java.net.Socket.<init>(Socket.java:211)
apollo_1          | 	at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:497)
apollo_1          | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apollo_1          | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apollo_1          | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apollo_1          | 	at java.lang.reflect.Method.invoke(Method.java:498)
apollo_1          | 	at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:406)
apollo_1          | 	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:495)
apollo_1          | 
apollo_1          | Starting tomcat with /usr/local/tomcat/
...
apollo_1          | 11-Jul-2018 14:00:51.764 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/8.5.32
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Jun 20 2018 19:50:35 UTC
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         8.5.32.0
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Linux
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            3.10.0-862.3.2.el7.x86_64
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /usr/lib/jvm/java-8-openjdk-amd64/jre
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_171-8u171-b11-1~deb9u1-b11
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /usr/local/tomcat
apollo_1          | 11-Jul-2018 14:00:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /usr/local/tomcat
apollo_1          | 11-Jul-2018 14:00:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/usr/local/tomcat//conf/logging.properties
apollo_1          | 11-Jul-2018 14:00:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
apollo_1          | 11-Jul-2018 14:00:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
apollo_1          | 11-Jul-2018 14:00:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
apollo_1          | 11-Jul-2018 14:00:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
apollo_1          | 11-Jul-2018 14:00:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
apollo_1          | 11-Jul-2018 14:00:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/usr/local/tomcat/
apollo_1          | 11-Jul-2018 14:00:51.768 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/local/tomcat/
apollo_1          | 11-Jul-2018 14:00:51.768 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/usr/local/tomcat//temp
apollo_1          | 11-Jul-2018 14:00:51.768 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library [1.2.17] using APR version [1.5.2].
apollo_1          | 11-Jul-2018 14:00:51.768 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
apollo_1          | 11-Jul-2018 14:00:51.768 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
apollo_1          | 11-Jul-2018 14:00:51.772 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.1.0f  25 May 2017]
apollo_1          | 11-Jul-2018 14:00:51.907 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
apollo_1          | 11-Jul-2018 14:00:51.927 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
apollo_1          | 11-Jul-2018 14:00:51.934 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
apollo_1          | 11-Jul-2018 14:00:51.936 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
apollo_1          | 11-Jul-2018 14:00:51.936 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1069 ms
apollo_1          | 11-Jul-2018 14:00:51.977 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
apollo_1          | 11-Jul-2018 14:00:51.978 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.32
apollo_1          | 11-Jul-2018 14:00:52.042 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [/usr/local/tomcat/webapps/ROOT.war]
apollo_1          | 11-Jul-2018 14:01:06.004 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
apollo_1          | log4j:WARN No appenders could be found for logger (org.codehaus.groovy.grails.commons.cfg.ConfigurationHelper).
apollo_1          | log4j:WARN Please initialize the log4j system properly.
apollo_1          | log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
apollo_1          | 
apollo_1          | Configuring Shiro ...
apollo_1          | 
apollo_1          | Shiro Configured
apollo_1          | 11-Jul-2018 14:01:17.396 SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
apollo_1          |  org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
apollo_1          | 	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
apollo_1          | 	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52)
apollo_1          | 	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:216)
apollo_1          | 	at org.postgresql.Driver.makeConnection(Driver.java:404)
apollo_1          | 	at org.postgresql.Driver.connect(Driver.java:272)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:712)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:646)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:145)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
apollo_1          | 	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.afterPropertiesSet(LazyConnectionDataSourceProxy.java:162)
apollo_1          | 	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.<init>(LazyConnectionDataSourceProxy.java:106)
apollo_1          | 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
apollo_1          | 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
apollo_1          | 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
apollo_1          | 	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
apollo_1          | 	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147)
apollo_1          | 	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122)
apollo_1          | 	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:267)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          | 	at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:648)
apollo_1          | 	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:382)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157)
apollo_1          | 	at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634)
apollo_1          | 	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1          | 	at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74)
apollo_1          | 	at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1591)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1559)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1          | 	at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:199)
apollo_1          | 	at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:616)
apollo_1          | 	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:465)
apollo_1          | 	at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156)
apollo_1          | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.initializeContext(GrailsRuntimeConfigurator.java:188)
apollo_1          | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:168)
apollo_1          | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127)
apollo_1          | 	at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:126)
apollo_1          | 	at org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener.initWebApplicationContext(GrailsContextLoaderListener.java:109)
apollo_1          | 	at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
apollo_1          | 	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
apollo_1          | 	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
apollo_1          | 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
apollo_1          | 	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
apollo_1          | 	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
apollo_1          | 	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
apollo_1          | 	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
apollo_1          | 	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
apollo_1          | 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1          | 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1          | 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1          | 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1          | 	at java.lang.Thread.run(Thread.java:748)
apollo_1          | Caused by: java.net.ConnectException: Connection refused (Connection refused)
apollo_1          | 	at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1          | 	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1          | 	at java.net.Socket.connect(Socket.java:589)
apollo_1          | 	at org.postgresql.core.PGStream.<init>(PGStream.java:61)
apollo_1          | 	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
apollo_1          | 	... 109 more
apollo_1          | 
apollo_1          | 11-Jul-2018 14:01:17.403 SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
apollo_1          |  org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
apollo_1          | 	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
apollo_1          | 	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52)
apollo_1          | 	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:216)
apollo_1          | 	at org.postgresql.Driver.makeConnection(Driver.java:404)
apollo_1          | 	at org.postgresql.Driver.connect(Driver.java:272)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:712)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:646)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:145)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
apollo_1          | 	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.afterPropertiesSet(LazyConnectionDataSourceProxy.java:162)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1631)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1568)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          | 	at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:648)
apollo_1          | 	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:382)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157)
apollo_1          | 	at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634)
apollo_1          | 	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1          | 	at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74)
apollo_1          | 	at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1591)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1559)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1          | 	at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:199)
apollo_1          | 	at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:616)
apollo_1          | 	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:465)
apollo_1          | 	at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156)
apollo_1          | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.initializeContext(GrailsRuntimeConfigurator.java:188)
apollo_1          | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:168)
apollo_1          | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127)
apollo_1          | 	at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:126)
apollo_1          | 	at org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener.initWebApplicationContext(GrailsContextLoaderListener.java:109)
apollo_1          | 	at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
apollo_1          | 	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
apollo_1          | 	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
apollo_1          | 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
apollo_1          | 	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
apollo_1          | 	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
apollo_1          | 	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
apollo_1          | 	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
apollo_1          | 	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
apollo_1          | 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1          | 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1          | 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1          | 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1          | 	at java.lang.Thread.run(Thread.java:748)
apollo_1          | Caused by: java.net.ConnectException: Connection refused (Connection refused)
apollo_1          | 	at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1          | 	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1          | 	at java.net.Socket.connect(Socket.java:589)
apollo_1          | 	at org.postgresql.core.PGStream.<init>(PGStream.java:61)
apollo_1          | 	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
apollo_1          | 	... 101 more
apollo_1          | 
apollo_1          | 11-Jul-2018 14:01:17.901 SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
apollo_1          |  org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
apollo_1          | 	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
apollo_1          | 	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52)
apollo_1          | 	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:216)
apollo_1          | 	at org.postgresql.Driver.makeConnection(Driver.java:404)
apollo_1          | 	at org.postgresql.Driver.connect(Driver.java:272)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:712)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:646)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:145)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
apollo_1          | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
apollo_1          | 	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.getTargetConnection(LazyConnectionDataSourceProxy.java:403)
apollo_1          | 	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:376)
apollo_1          | 	at com.sun.proxy.$Proxy44.getMetaData(Unknown Source)
apollo_1          | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apollo_1          | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apollo_1          | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apollo_1          | 	at java.lang.reflect.Method.invoke(Method.java:498)
apollo_1          | 	at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:240)
apollo_1          | 	at com.sun.proxy.$Proxy44.getMetaData(Unknown Source)
apollo_1          | 	at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:126)
apollo_1          | 	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111)
apollo_1          | 	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234)
apollo_1          | 	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206)
apollo_1          | 	at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1887)
apollo_1          | 	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1845)
apollo_1          | 	at org.codehaus.groovy.grails.orm.hibernate.cfg.GrailsAnnotationConfiguration.buildSessionFactory(GrailsAnnotationConfiguration.java:372)
apollo_1          | 	at org.codehaus.groovy.grails.orm.hibernate.ConfigurableLocalSessionFactoryBean.doBuildSessionFactory(ConfigurableLocalSessionFactoryBean.java:479)
apollo_1          | 	at org.codehaus.groovy.grails.orm.hibernate.ConfigurableLocalSessionFactoryBean.buildSessionFactory(ConfigurableLocalSessionFactoryBean.java:473)
apollo_1          | 	at org.codehaus.groovy.grails.orm.hibernate.ConfigurableLocalSessionFactoryBean.afterPropertiesSet(ConfigurableLocalSessionFactoryBean.java:387)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1631)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1568)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:382)
apollo_1          | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157)
apollo_1          | 	at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634)
apollo_1          | 	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1          | 	at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74)
apollo_1          | 	at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1591)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1559)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1          | 	at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:199)
apollo_1          | 	at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:616)
apollo_1          | 	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:465)
apollo_1          | 	at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156)
apollo_1          | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.initializeContext(GrailsRuntimeConfigurator.java:188)
apollo_1          | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:168)
apollo_1          | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127)
apollo_1          | 	at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:126)
apollo_1          | 	at org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener.initWebApplicationContext(GrailsContextLoaderListener.java:109)
apollo_1          | 	at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
apollo_1          | 	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
apollo_1          | 	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
apollo_1          | 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
apollo_1          | 	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
apollo_1          | 	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
apollo_1          | 	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
apollo_1          | 	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
apollo_1          | 	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
apollo_1          | 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1          | 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1          | 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1          | 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1          | 	at java.lang.Thread.run(Thread.java:748)
apollo_1          | Caused by: java.net.ConnectException: Connection refused (Connection refused)
apollo_1          | 	at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1          | 	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1          | 	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1          | 	at java.net.Socket.connect(Socket.java:589)
apollo_1          | 	at org.postgresql.core.PGStream.<init>(PGStream.java:61)
apollo_1          | 	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
apollo_1          | 	... 97 more
apollo_1          | 
apollo_1          | 2018-07-11 14:01:17,927 [localhost-startStop-1] ERROR context.GrailsContextLoaderListener  - Error initializing the application: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          | org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          | 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1          | 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1          | 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1          | 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1          | 	at java.lang.Thread.run(Thread.java:748)
apollo_1          | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          | 	... 5 more
apollo_1          | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          | 	... 5 more
apollo_1          | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          | 	... 5 more
apollo_1          | Caused by: java.lang.NullPointerException
apollo_1          | 	... 5 more
apollo_1          | 2018-07-11 14:01:17,929 [localhost-startStop-1] ERROR context.GrailsContextLoaderListener  - Error initializing Grails: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          | org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          | 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1          | 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1          | 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1          | 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1          | 	at java.lang.Thread.run(Thread.java:748)
apollo_1          | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          | 	... 5 more
apollo_1          | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          | 	... 5 more
apollo_1          | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          | 	... 5 more
apollo_1          | Caused by: java.lang.NullPointerException
apollo_1          | 	... 5 more
apollo_1          | 11-Jul-2018 14:01:17.930 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
apollo_1          | 11-Jul-2018 14:01:17.949 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [] startup failed due to previous errors
apollo_1          | 11-Jul-2018 14:01:17.969 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [ROOT] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
apollo_1          | 11-Jul-2018 14:01:17.994 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/usr/local/tomcat/webapps/ROOT.war] has finished in [25,951] ms
apollo_1          | 11-Jul-2018 14:01:17.996 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
apollo_1          | 11-Jul-2018 14:01:18.010 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
apollo_1          | 11-Jul-2018 14:01:18.015 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 26078 ms

What did I miss?

Thank you in advance.

Michal

@nathandunn
Copy link

The error is because its trying to connect to a postgresql server and its either not there, or the connection credentials are misconfigured. These are typically passed is as variables in the example you gave.

My advice would be to fork their project and get it running and then add your pieces. I think it would be easier to have both postgresql and mysql running, at least for now, so you don't have to reconfigure it. If you have trouble, those guys are docker / configuration experts and very willing to help.

@mictadlo
Copy link
Author

Thank you for your help. I did what you suggested galaxy-genome-annotation/dockerized-gmod-deployment#8

@mictadlo
Copy link
Author

Hi Nathan,
I decided that I only need apollo and postgresql without chado. This is the new docker-compose.yml file:

apollo:
  image: quay.io/gmod/docker-apollo:apollo-only
  restart: always
  links:
    - apollo_db
  ports:
    - "8888:8080"
  environment:
    - WEBAPOLLO_DB_USERNAME=postgres
    - WEBAPOLLO_DB_PASSWORD=password
    - WEBAPOLLO_DB_DRIVER="org.postgresql.Driver"
    - WEBAPOLLO_DB_DIALECT="org.hibernate.dialect.PostgresPlusDialect"
    - WEBAPOLLO_DB_URI="jdbc:postgresql://db/postgres"
  volumes:
    - ./data/jbrowse:/data
    - ./data/postgres-data:/var/lib/postgresql

apollo_db:
  image: postgres:latest
  environment:
    - POSTGRES_PASSWORD=postgres

However, I have got the following Errors and Exceptions:

Attaching to docker-apollo-only_apollo_db_1, docker-apollo-only_apollo_1
apollo_db_1  | The files belonging to this database system will be owned by user "postgres".
apollo_db_1  | This user must also own the server process.
apollo_db_1  | 
apollo_db_1  | The database cluster will be initialized with locale "en_US.utf8".
apollo_db_1  | The default database encoding has accordingly been set to "UTF8".
apollo_db_1  | The default text search configuration will be set to "english".
apollo_db_1  | 
apollo_db_1  | Data page checksums are disabled.
apollo_db_1  | 
apollo_db_1  | fixing permissions on existing directory /var/lib/postgresql/data ... ok
apollo_db_1  | creating subdirectories ... ok
apollo_db_1  | selecting default max_connections ... 100
apollo_db_1  | selecting default shared_buffers ... 128MB
apollo_db_1  | selecting dynamic shared memory implementation ... posix
apollo_1     | Stopping tomcat with /usr/local/tomcat/
apollo_db_1  | creating configuration files ... ok
apollo_db_1  | running bootstrap script ... ok
apollo_1     | Jul 25, 2018 9:29:29 PM org.apache.catalina.startup.Catalina stopServer
apollo_1     | SEVERE: Could not contact [localhost:[8005]]. Tomcat may not be running.
apollo_1     | Jul 25, 2018 9:29:29 PM org.apache.catalina.startup.Catalina stopServer
apollo_1     | SEVERE: Catalina.stop: 
apollo_1     | java.net.ConnectException: Connection refused (Connection refused)
apollo_1     | 	at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1     | 	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1     | 	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1     | 	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1     | 	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1     | 	at java.net.Socket.connect(Socket.java:589)
apollo_1     | 	at java.net.Socket.connect(Socket.java:538)
apollo_1     | 	at java.net.Socket.<init>(Socket.java:434)
apollo_1     | 	at java.net.Socket.<init>(Socket.java:211)
apollo_1     | 	at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:497)
apollo_1     | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apollo_1     | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apollo_1     | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apollo_1     | 	at java.lang.reflect.Method.invoke(Method.java:498)
apollo_1     | 	at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:406)
apollo_1     | 	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:495)
apollo_1     | 
apollo_1     | Starting tomcat with /usr/local/tomcat/
apollo_1     | Tomcat started.
apollo_db_1  | performing post-bootstrap initialization ... ok
apollo_db_1  | syncing data to disk ... ok
apollo_db_1  | 
apollo_db_1  | WARNING: enabling "trust" authentication for local connections
apollo_db_1  | You can change this by editing pg_hba.conf or using the option -A, or
apollo_db_1  | --auth-local and --auth-host, the next time you run initdb.
apollo_db_1  | 
apollo_db_1  | Success. You can now start the database server using:
apollo_db_1  | 
apollo_db_1  |     pg_ctl -D /var/lib/postgresql/data -l logfile start
apollo_db_1  | 
apollo_db_1  | waiting for server to start....2018-07-25 21:29:31.478 UTC [38] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
apollo_db_1  | 2018-07-25 21:29:31.574 UTC [39] LOG:  database system was shut down at 2018-07-25 21:29:30 UTC
apollo_db_1  | 2018-07-25 21:29:31.647 UTC [38] LOG:  database system is ready to accept connections
apollo_db_1  |  done
apollo_db_1  | server started
apollo_db_1  | ALTER ROLE
apollo_db_1  | 
apollo_db_1  | 
apollo_db_1  | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
apollo_db_1  | 
apollo_db_1  | waiting for server to shut down....2018-07-25 21:29:32.400 UTC [38] LOG:  received fast shutdown request
apollo_db_1  | 2018-07-25 21:29:32.409 UTC [38] LOG:  aborting any active transactions
apollo_db_1  | 2018-07-25 21:29:32.418 UTC [38] LOG:  worker process: logical replication launcher (PID 45) exited with exit code 1
apollo_db_1  | 2018-07-25 21:29:32.420 UTC [40] LOG:  shutting down
apollo_db_1  | 2018-07-25 21:29:32.535 UTC [38] LOG:  database system is shut down
apollo_db_1  |  done
apollo_db_1  | server stopped
apollo_db_1  | 
apollo_db_1  | PostgreSQL init process complete; ready for start up.
apollo_db_1  | 
apollo_db_1  | 2018-07-25 21:29:32.653 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
apollo_db_1  | 2018-07-25 21:29:32.653 UTC [1] LOG:  listening on IPv6 address "::", port 5432
apollo_db_1  | 2018-07-25 21:29:32.690 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
apollo_db_1  | 2018-07-25 21:29:32.757 UTC [56] LOG:  database system was shut down at 2018-07-25 21:29:32 UTC
apollo_db_1  | 2018-07-25 21:29:32.784 UTC [1] LOG:  database system is ready to accept connections
apollo_1     | 25-Jul-2018 21:29:33.501 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/8.5.32
apollo_1     | 25-Jul-2018 21:29:33.505 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Jun 20 2018 19:50:35 UTC
apollo_1     | 25-Jul-2018 21:29:33.505 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         8.5.32.0
apollo_1     | 25-Jul-2018 21:29:33.505 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Linux
apollo_1     | 25-Jul-2018 21:29:33.506 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            4.9.87-linuxkit-aufs
apollo_1     | 25-Jul-2018 21:29:33.507 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
apollo_1     | 25-Jul-2018 21:29:33.507 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /usr/lib/jvm/java-8-openjdk-amd64/jre
apollo_1     | 25-Jul-2018 21:29:33.508 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_171-8u171-b11-1~deb9u1-b11
apollo_1     | 25-Jul-2018 21:29:33.508 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
apollo_1     | 25-Jul-2018 21:29:33.509 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /usr/local/tomcat
apollo_1     | 25-Jul-2018 21:29:33.509 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /usr/local/tomcat
apollo_1     | 25-Jul-2018 21:29:33.510 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/usr/local/tomcat//conf/logging.properties
apollo_1     | 25-Jul-2018 21:29:33.511 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
apollo_1     | 25-Jul-2018 21:29:33.511 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
apollo_1     | 25-Jul-2018 21:29:33.512 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
apollo_1     | 25-Jul-2018 21:29:33.512 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
apollo_1     | 25-Jul-2018 21:29:33.513 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
apollo_1     | 25-Jul-2018 21:29:33.513 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/usr/local/tomcat/
apollo_1     | 25-Jul-2018 21:29:33.514 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/local/tomcat/
apollo_1     | 25-Jul-2018 21:29:33.515 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/usr/local/tomcat//temp
apollo_1     | 25-Jul-2018 21:29:33.515 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library [1.2.17] using APR version [1.5.2].
apollo_1     | 25-Jul-2018 21:29:33.516 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
apollo_1     | 25-Jul-2018 21:29:33.516 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
apollo_1     | 25-Jul-2018 21:29:33.561 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.1.0f  25 May 2017]
apollo_1     | 25-Jul-2018 21:29:34.115 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
apollo_1     | 25-Jul-2018 21:29:34.243 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
apollo_1     | 25-Jul-2018 21:29:34.281 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
apollo_1     | 25-Jul-2018 21:29:34.283 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
apollo_1     | 25-Jul-2018 21:29:34.286 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 3085 ms
apollo_1     | 25-Jul-2018 21:29:34.440 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
apollo_1     | 25-Jul-2018 21:29:34.440 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.32
apollo_1     | 25-Jul-2018 21:29:34.566 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [/usr/local/tomcat/webapps/ROOT.war]
apollo_1     | 25-Jul-2018 21:30:02.932 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
apollo_1     | log4j:WARN No appenders could be found for logger (org.codehaus.groovy.grails.commons.cfg.ConfigurationHelper).
apollo_1     | log4j:WARN Please initialize the log4j system properly.
apollo_1     | log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
apollo_1     | 
apollo_1     | Configuring Shiro ...
apollo_1     | 
apollo_1     | Shiro Configured
apollo_1     | 25-Jul-2018 21:30:46.187 SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
apollo_1     |  org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
apollo_1     | 	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
apollo_1     | 	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52)
apollo_1     | 	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:216)
apollo_1     | 	at org.postgresql.Driver.makeConnection(Driver.java:404)
apollo_1     | 	at org.postgresql.Driver.connect(Driver.java:272)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:712)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:646)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:145)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
apollo_1     | 	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.afterPropertiesSet(LazyConnectionDataSourceProxy.java:162)
apollo_1     | 	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.<init>(LazyConnectionDataSourceProxy.java:106)
apollo_1     | 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
apollo_1     | 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
apollo_1     | 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
apollo_1     | 	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
apollo_1     | 	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147)
apollo_1     | 	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122)
apollo_1     | 	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:267)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     | 	at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:648)
apollo_1     | 	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:382)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157)
apollo_1     | 	at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634)
apollo_1     | 	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1     | 	at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74)
apollo_1     | 	at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1591)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1559)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1     | 	at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:199)
apollo_1     | 	at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:616)
apollo_1     | 	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:465)
apollo_1     | 	at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156)
apollo_1     | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.initializeContext(GrailsRuntimeConfigurator.java:188)
apollo_1     | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:168)
apollo_1     | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127)
apollo_1     | 	at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:126)
apollo_1     | 	at org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener.initWebApplicationContext(GrailsContextLoaderListener.java:109)
apollo_1     | 	at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
apollo_1     | 	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
apollo_1     | 	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
apollo_1     | 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
apollo_1     | 	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
apollo_1     | 	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
apollo_1     | 	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
apollo_1     | 	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
apollo_1     | 	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
apollo_1     | 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1     | 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1     | 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1     | 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1     | 	at java.lang.Thread.run(Thread.java:748)
apollo_1     | Caused by: java.net.ConnectException: Connection refused (Connection refused)
apollo_1     | 	at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1     | 	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1     | 	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1     | 	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1     | 	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1     | 	at java.net.Socket.connect(Socket.java:589)
apollo_1     | 	at org.postgresql.core.PGStream.<init>(PGStream.java:61)
apollo_1     | 	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
apollo_1     | 	... 109 more
apollo_1     | 
apollo_1     | 25-Jul-2018 21:30:46.223 SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
apollo_1     |  org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
apollo_1     | 	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
apollo_1     | 	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52)
apollo_1     | 	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:216)
apollo_1     | 	at org.postgresql.Driver.makeConnection(Driver.java:404)
apollo_1     | 	at org.postgresql.Driver.connect(Driver.java:272)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:712)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:646)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:145)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
apollo_1     | 	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.afterPropertiesSet(LazyConnectionDataSourceProxy.java:162)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1631)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1568)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     | 	at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:648)
apollo_1     | 	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:382)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157)
apollo_1     | 	at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634)
apollo_1     | 	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1     | 	at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74)
apollo_1     | 	at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1591)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1559)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1     | 	at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:199)
apollo_1     | 	at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:616)
apollo_1     | 	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:465)
apollo_1     | 	at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156)
apollo_1     | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.initializeContext(GrailsRuntimeConfigurator.java:188)
apollo_1     | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:168)
apollo_1     | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127)
apollo_1     | 	at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:126)
apollo_1     | 	at org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener.initWebApplicationContext(GrailsContextLoaderListener.java:109)
apollo_1     | 	at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
apollo_1     | 	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
apollo_1     | 	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
apollo_1     | 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
apollo_1     | 	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
apollo_1     | 	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
apollo_1     | 	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
apollo_1     | 	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
apollo_1     | 	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
apollo_1     | 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1     | 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1     | 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1     | 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1     | 	at java.lang.Thread.run(Thread.java:748)
apollo_1     | Caused by: java.net.ConnectException: Connection refused (Connection refused)
apollo_1     | 	at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1     | 	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1     | 	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1     | 	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1     | 	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1     | 	at java.net.Socket.connect(Socket.java:589)
apollo_1     | 	at org.postgresql.core.PGStream.<init>(PGStream.java:61)
apollo_1     | 	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
apollo_1     | 	... 101 more
apollo_1     | 
apollo_1     | 25-Jul-2018 21:30:47.890 SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
apollo_1     |  org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
apollo_1     | 	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
apollo_1     | 	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52)
apollo_1     | 	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:216)
apollo_1     | 	at org.postgresql.Driver.makeConnection(Driver.java:404)
apollo_1     | 	at org.postgresql.Driver.connect(Driver.java:272)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:712)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:646)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:145)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
apollo_1     | 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
apollo_1     | 	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.getTargetConnection(LazyConnectionDataSourceProxy.java:403)
apollo_1     | 	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:376)
apollo_1     | 	at com.sun.proxy.$Proxy44.getMetaData(Unknown Source)
apollo_1     | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apollo_1     | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apollo_1     | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apollo_1     | 	at java.lang.reflect.Method.invoke(Method.java:498)
apollo_1     | 	at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:240)
apollo_1     | 	at com.sun.proxy.$Proxy44.getMetaData(Unknown Source)
apollo_1     | 	at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:126)
apollo_1     | 	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111)
apollo_1     | 	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234)
apollo_1     | 	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206)
apollo_1     | 	at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1887)
apollo_1     | 	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1845)
apollo_1     | 	at org.codehaus.groovy.grails.orm.hibernate.cfg.GrailsAnnotationConfiguration.buildSessionFactory(GrailsAnnotationConfiguration.java:372)
apollo_1     | 	at org.codehaus.groovy.grails.orm.hibernate.ConfigurableLocalSessionFactoryBean.doBuildSessionFactory(ConfigurableLocalSessionFactoryBean.java:479)
apollo_1     | 	at org.codehaus.groovy.grails.orm.hibernate.ConfigurableLocalSessionFactoryBean.buildSessionFactory(ConfigurableLocalSessionFactoryBean.java:473)
apollo_1     | 	at org.codehaus.groovy.grails.orm.hibernate.ConfigurableLocalSessionFactoryBean.afterPropertiesSet(ConfigurableLocalSessionFactoryBean.java:387)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1631)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1568)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:382)
apollo_1     | 	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157)
apollo_1     | 	at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634)
apollo_1     | 	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1     | 	at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74)
apollo_1     | 	at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1591)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1559)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1     | 	at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:199)
apollo_1     | 	at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:616)
apollo_1     | 	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:465)
apollo_1     | 	at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156)
apollo_1     | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.initializeContext(GrailsRuntimeConfigurator.java:188)
apollo_1     | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:168)
apollo_1     | 	at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127)
apollo_1     | 	at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:126)
apollo_1     | 	at org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener.initWebApplicationContext(GrailsContextLoaderListener.java:109)
apollo_1     | 	at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
apollo_1     | 	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
apollo_1     | 	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
apollo_1     | 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
apollo_1     | 	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
apollo_1     | 	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
apollo_1     | 	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
apollo_1     | 	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
apollo_1     | 	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
apollo_1     | 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1     | 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1     | 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1     | 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1     | 	at java.lang.Thread.run(Thread.java:748)
apollo_1     | Caused by: java.net.ConnectException: Connection refused (Connection refused)
apollo_1     | 	at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1     | 	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1     | 	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1     | 	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1     | 	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1     | 	at java.net.Socket.connect(Socket.java:589)
apollo_1     | 	at org.postgresql.core.PGStream.<init>(PGStream.java:61)
apollo_1     | 	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
apollo_1     | 	... 97 more
apollo_1     | 
apollo_1     | 2018-07-25 21:30:47,946 [localhost-startStop-1] ERROR context.GrailsContextLoaderListener  - Error initializing the application: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     | org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     | 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1     | 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1     | 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1     | 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1     | 	at java.lang.Thread.run(Thread.java:748)
apollo_1     | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     | 	... 5 more
apollo_1     | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     | 	... 5 more
apollo_1     | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     | 	... 5 more
apollo_1     | Caused by: java.lang.NullPointerException
apollo_1     | 	... 5 more
apollo_1     | 2018-07-25 21:30:47,950 [localhost-startStop-1] ERROR context.GrailsContextLoaderListener  - Error initializing Grails: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     | org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     | 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1     | 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1     | 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1     | 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1     | 	at java.lang.Thread.run(Thread.java:748)
apollo_1     | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     | 	... 5 more
apollo_1     | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     | 	... 5 more
apollo_1     | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     | 	... 5 more
apollo_1     | Caused by: java.lang.NullPointerException
apollo_1     | 	... 5 more
apollo_1     | 25-Jul-2018 21:30:47.965 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
apollo_1     | 25-Jul-2018 21:30:48.040 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [] startup failed due to previous errors
apollo_1     | 25-Jul-2018 21:30:48.155 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [ROOT] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
apollo_1     | 25-Jul-2018 21:30:48.226 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/usr/local/tomcat/webapps/ROOT.war] has finished in [73,658] ms
apollo_1     | 25-Jul-2018 21:30:48.238 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
apollo_1     | 25-Jul-2018 21:30:48.349 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
apollo_1     | 25-Jul-2018 21:30:48.354 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 74067 ms

What did I miss?

Thank you in advance.

Michal

@nathandunn
Copy link

nathandunn commented Jul 25, 2018 via email

@mictadlo
Copy link
Author

Do you mean quay.io/gmod/docker-apollo rather quay.io/gmod/docker-apollo:apollo-only?

@nathandunn
Copy link

Yes. It has everything baked in, and I've tested it already.

@mictadlo
Copy link
Author

I still got some errors and I just wonder whether this is correct.

docker run -it -v /Users/lorencm/projects/docker-apollo-only/data/jbrowse:/data -v /Users/lorencm/projects/docker-apollo-only/data/postgres-data:/var/lib/postgresql -p 8888:8080 quay.io/gmod/docker-apollo:latest
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "C.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/9.6/main ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

psql: FATAL:  Peer authentication failed for user "apollo-lqt"
Apollo database not found, creating...
CREATE ROLE
GRANT
Configuring Chado
psql: FATAL:  Peer authentication failed for user "apollo"
Chado database not found, creating...
ERROR:  role "apollo" already exists
GRANT
Loading Chado

psql:/chado.sql:49: ERROR:  must be owner of extension plpgsql



SET
psql:/chado.sql:2637928: ERROR:  function create_point(integer, bigint) does not exist
LINE 1: SELECT box (create_point(0, $1), create_point($2,500000000))
              ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  SELECT box (create_point(0, $1), create_point($2,500000000))
CONTEXT:  SQL function "boxrange" during inlining


Loaded Chado
Restarting tomcat with /usr/local/tomcat/
Using CATALINA_BASE:   /usr/local/tomcat/
Using CATALINA_HOME:   /usr/local/tomcat/
Using CATALINA_TMPDIR: /usr/local/tomcat//temp
Using JRE_HOME:        /docker-java-home/jre
Using CLASSPATH:       /usr/local/tomcat//bin/bootstrap.jar:/usr/local/tomcat//bin/tomcat-juli.jar
Jul 26, 2018 12:02:15 AM org.apache.catalina.startup.Catalina stopServer
SEVERE: Could not contact [localhost:[8005]]. Tomcat may not be running.
Jul 26, 2018 12:02:15 AM org.apache.catalina.startup.Catalina stopServer
SEVERE: Catalina.stop: 
java.net.ConnectException: Connection refused (Connection refused)
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
	at java.net.Socket.connect(Socket.java:589)
	at java.net.Socket.connect(Socket.java:538)
	at java.net.Socket.<init>(Socket.java:434)
	at java.net.Socket.<init>(Socket.java:211)
	at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:497)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:406)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:495)

Using CATALINA_BASE:   /usr/local/tomcat/
Using CATALINA_HOME:   /usr/local/tomcat/
Using CATALINA_TMPDIR: /usr/local/tomcat//temp
Using JRE_HOME:        /docker-java-home/jre
Using CLASSPATH:       /usr/local/tomcat//bin/bootstrap.jar:/usr/local/tomcat//bin/tomcat-juli.jar
Tomcat started.
26-Jul-2018 00:02:17.412 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/8.5.31
26-Jul-2018 00:02:17.414 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Apr 27 2018 20:24:25 UTC
26-Jul-2018 00:02:17.414 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         8.5.31.0
26-Jul-2018 00:02:17.414 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Linux
26-Jul-2018 00:02:17.415 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            4.9.87-linuxkit-aufs
26-Jul-2018 00:02:17.415 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
26-Jul-2018 00:02:17.415 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /usr/lib/jvm/java-8-openjdk-amd64/jre
26-Jul-2018 00:02:17.415 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_171-8u171-b11-1~deb9u1-b11
26-Jul-2018 00:02:17.415 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
26-Jul-2018 00:02:17.415 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /usr/local/tomcat
26-Jul-2018 00:02:17.415 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /usr/local/tomcat
26-Jul-2018 00:02:17.418 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/usr/local/tomcat//conf/logging.properties
26-Jul-2018 00:02:17.418 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
26-Jul-2018 00:02:17.419 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
26-Jul-2018 00:02:17.419 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
26-Jul-2018 00:02:17.419 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
26-Jul-2018 00:02:17.419 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
26-Jul-2018 00:02:17.419 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/usr/local/tomcat/
26-Jul-2018 00:02:17.419 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/local/tomcat/
26-Jul-2018 00:02:17.420 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/usr/local/tomcat//temp
26-Jul-2018 00:02:17.420 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library [1.2.16] using APR version [1.5.2].
26-Jul-2018 00:02:17.420 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
26-Jul-2018 00:02:17.420 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
26-Jul-2018 00:02:17.425 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.1.0f  25 May 2017]
26-Jul-2018 00:02:17.998 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
26-Jul-2018 00:02:18.122 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
26-Jul-2018 00:02:18.149 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
26-Jul-2018 00:02:18.152 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
26-Jul-2018 00:02:18.153 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 2120 ms
26-Jul-2018 00:02:18.273 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
26-Jul-2018 00:02:18.273 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.31
26-Jul-2018 00:02:18.377 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [/usr/local/tomcat/webapps/ROOT.war]
26-Jul-2018 00:02:33.245 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
log4j:WARN No appenders could be found for logger (org.codehaus.groovy.grails.commons.cfg.ConfigurationHelper).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.

Configuring Shiro ...

Shiro Configured
2018-07-26 00:03:09,920 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table allele add constraint FK_ssx0gv6xbtu3tbwt6ekkmn4iw foreign key (variant_id) references feature
2018-07-26 00:03:09,922 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: constraint "fk_ssx0gv6xbtu3tbwt6ekkmn4iw" for relation "allele" already exists
2018-07-26 00:03:25,137 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table chadoprop add column cvterm_id int8 not null
2018-07-26 00:03:25,137 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: column "cvterm_id" contains null values
2018-07-26 00:03:39,307 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table chadoprop add constraint FK_8twb5n8vjmldyy3eeyq7sppc3 foreign key (cvterm_id) references cvterm
2018-07-26 00:03:39,307 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: column "cvterm_id" referenced in foreign key constraint does not exist
Starting Quartz Scheduler in QuartzFactoryBean
26-Jul-2018 00:04:20.601 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/usr/local/tomcat/webapps/ROOT.war] has finished in [122,221] ms
26-Jul-2018 00:04:22.327 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
26-Jul-2018 00:04:22.342 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
26-Jul-2018 00:04:22.346 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 124192 ms

Thank you in advance,

Michal

@nathandunn
Copy link

  1. I would initially try doing it without the database mount (obviously there will be problems persisting after the container goes down). If that works then I would

  2. I would clear out the database volume you are mounting (for now, backing up what is there.). That might work (if the directory exists). If it does not, try doing a pg_init on the mounted directory (from within the container or externally) and make sure its the same version. It looks like 9.6.

If those steps don't work, I can create a container without Chado, but this has worked in the past for me. My guess is that the older containers might be causing problems.

@mictadlo
Copy link
Author

I clean up the volumes and started again docker with apollo but I got the same error. I do not know how can I remove from your docker image the database mount.

@nathandunn
Copy link

  • docker kill $(docker ps -q)
  • docker rm $(docker ps -a -q)
  • docker rmi $(docker images -q)

@nathandunn
Copy link

and then run:

  • docker run -it -p 8888:8080 gmod/apollo:latest

@nathandunn
Copy link

I am running this on a mac:

docker -v
Docker version 18.06.0-ce, build 0ffa825

@mictadlo
Copy link
Author

I followed your instructions and I get the same errors with docker -v
Docker version 18.03.1-ce, build 9ee9f40

What did I miss?

@nathandunn
Copy link

You ran all 4 of those instructions as typed and you still got:

psql:/chado.sql:49: ERROR:  must be owner of extension plpgsql



SET
psql:/chado.sql:2637928: ERROR:  function create_point(integer, bigint) does not exist
LINE 1: SELECT box (create_point(0, $1), create_point($2,500000000))
              ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  SELECT box (create_point(0, $1), create_point($2,500000000))
CONTEXT:  SQL function "boxrange" during inlining

?

@mictadlo
Copy link
Author

Yes, I still get the same errors. Do you get them, too?

@nathandunn
Copy link

nathandunn commented Jul 26, 2018 via email

@mictadlo
Copy link
Author

Yes, I am using a Mac and I tried in on Centos 7. Both provide me with same error.

@nathandunn
Copy link

nathandunn commented Jul 27, 2018 via email

@nathandunn
Copy link

Okay @mictadlo seeing the same error. Will try to get a fix.

@nathandunn
Copy link

@mictadlo If you do use apollo-only, you have to set the environmental variables accordingly, which means setting up an external postgresql server via docker-compose.

https://github.com/GMOD/docker-apollo/blob/apollo-only/apollo-config.groovy

I haven't tested it yet, but am still working on bringing up the default image.

@nathandunn
Copy link

@mictadlo I'm pushing another fix on latest:

5ad4368

Looked like there were some issues with tomcat8

@nathandunn
Copy link

Re-open if it doesn't fix it, though.

@nathandunn
Copy link

I'll retest the build as well

@mictadlo
Copy link
Author

Hi Nathan,
I ran the following commands and I still got the errors.

docker kill $(docker ps -q)
docker rm $(docker ps -a -q)
docker rmi $(docker images -q)
docker run -it -p 8888:8080 gmod/apollo:latest

Did I miss anything?

Thank you in advance,

Michal

@nathandunn
Copy link

nathandunn commented Jul 30, 2018 via email

@nathandunn
Copy link

though, if you remove the local images, it should try to fetch the newest, so not sure what's up. I haven't tested with the remotely built images.

@mictadlo
Copy link
Author

I tried those commands and still, I have the same errors:

docker kill $(docker ps -q)
docker rm $(docker ps -a -q)
docker rmi $(docker images -q)
docker pull gmod/apollo:latest
docker run -it -p 8888:8080 gmod/apollo:latest

@nathandunn
Copy link

Just ran this on a a new machine that didn't have docker installed on it before. Is that something you could try (or run it within virtualbox, etc.?).

Here is my output (feel free to post all of yours here as well):

docker run -it -p 8888:8080 gmod/apollo:latest

Unable to find image 'gmod/apollo:latest' locally
latest: Pulling from gmod/apollo
55cbf04beb70: Pull complete 
1607093a898c: Extracting [=>                                                 ]  393.2kB/10.74MB
1607093a898c: Extracting [============================================>      ]  9.568MB/10.74MB
1607093a898c: Pull complete 
9a8ea045c926: Pull complete 
1290813abd9d: Pull complete 
8a6b982ad6d7: Pull complete 
abb029e68402: Pull complete 
8cd067dc06dc: Pull complete 
1b9ce2097b98: Pull complete 
d6db5874b692: Pull complete 
25b4aa3d52c5: Pull complete 
53ec227dabf0: Pull complete 
242938ace8b4: Pull complete 
cccfd5ca2886: Pull complete 
556c79d510d8: Pull complete 
088e36d94df4: Pull complete 
84ed40888353: Pull complete 
58bf9a9c111f: Pull complete 
f819b75fffce: Pull complete 
9c19d2ce2392: Pull complete 
c1bc0e0ba881: Pull complete 
03a98c5440c6: Pull complete 
0c0563c5fac0: Pull complete 
9b44a5f2ff85: Pull complete 
25edebefcde4: Pull complete 
271da51aeefa: Pull complete 
dfd59686cdb4: Pull complete 
32e06ebc8b95: Pull complete 
Digest: sha256:630edc1f651e566f755ce623bd8dcd4e95cca276e5d23ec9b319a4cd58eaca40
Status: Downloaded newer image for gmod/apollo:latest


[ ok ] Starting PostgreSQL 9.6 database server: main.
WEBAPOLLO_HOST_FLAG: 
CHADO_HOST_FLAG: 
Waiting for DB
/var/run/postgresql:5432 - accepting connections
Postgres is up, configuring database
psql: FATAL:  Peer authentication failed for user "apollo-lqt"
Apollo database not found, creating...
CREATE ROLE
GRANT
Configuring Chado
psql: FATAL:  Peer authentication failed for user "apollo"
Chado database not found, creating...
ERROR:  role "apollo" already exists
GRANT
Loading Chado
SET
SET
SET
SET
SET
SET
SET
SET
CREATE SCHEMA
CREATE SCHEMA
CREATE SCHEMA
CREATE EXTENSION
psql:/chado.sql:49: ERROR:  must be owner of extension plpgsql
SET
CREATE TYPE

...

ALTER TABLE
ALTER TABLE
Loaded Chado
Restarting tomcat with /var/lib/tomcat8
[FAIL] Starting Tomcat servlet engine: tomcat8 failed!
30-Jul-2018 05:22:31.495 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/share/tomcat8
30-Jul-2018 05:22:31.495 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/tmp/tomcat8-tomcat8-tmp
30-Jul-2018 05:22:31.496 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/java/packages/lib/amd64:/usr/lib/x86_64-linux-gnu/jni:/lib/x86_64-linux-gnu:/usr/lib/x86_64-linux-gnu:/usr/lib/jni:/lib:/usr/lib
30-Jul-2018 05:22:31.576 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
30-Jul-2018 05:22:31.589 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
30-Jul-2018 05:22:31.591 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 473 ms
30-Jul-2018 05:22:31.614 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service Catalina
30-Jul-2018 05:22:31.614 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.14 (Debian)
30-Jul-2018 05:22:31.624 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
30-Jul-2018 05:22:31.654 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 63 ms
30-Jul-2018 05:22:41.639 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive /var/lib/tomcat8/webapps/ROOT.war
30-Jul-2018 05:22:54.853 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
log4j:WARN No appenders could be found for logger (org.codehaus.groovy.grails.commons.cfg.ConfigurationHelper).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.

Configuring Shiro ...

Shiro Configured
2018-07-30 05:23:19,773 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table allele add constraint FK_ssx0gv6xbtu3tbwt6ekkmn4iw foreign key (variant_id) references feature
2018-07-30 05:23:19,774 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: constraint "fk_ssx0gv6xbtu3tbwt6ekkmn4iw" for relation "allele" already exists

2018-07-30 05:23:24,786 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table chadoprop add column cvterm_id int8 not null
2018-07-30 05:23:24,787 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: column "cvterm_id" contains null values
2018-07-30 05:23:27,335 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table chadoprop add constraint FK_8twb5n8vjmldyy3eeyq7sppc3 foreign key (cvterm_id) references cvterm
2018-07-30 05:23:27,335 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: column "cvterm_id" referenced in foreign key constraint does not exist
Starting Quartz Scheduler in QuartzFactoryBean
30-Jul-2018 05:23:41.383 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive /var/lib/tomcat8/webapps/ROOT.war has finished in 59,744 ms

@mictadlo
Copy link
Author

mictadlo commented Jul 30, 2018

I'm confused your output has psql:/chado.sql:49: ERROR: must be owner of extension plpgsql and may the other one too.

@nathandunn
Copy link

@mictadlo Tomcat should be fixed (which was the prior problem). Its possible that chado is still not functioning properly, but I want to make sure this works for you, first.

If, after running docker run -it -p 8888:8080 gmod/apollo:latest if you can't connect to http://localhost:8888/ let me know and paste the entire output.

@nathandunn nathandunn reopened this Jul 30, 2018
@mictadlo
Copy link
Author

Apollo starts at http://localhost:8888/, but what it is about the above errors.

@nathandunn
Copy link

nathandunn commented Jul 30, 2018 via email

@mictadlo
Copy link
Author

No, at the moment I do no need Chado. Will the above error effect Apollo?

@nathandunn
Copy link

nathandunn commented Jul 30, 2018 via email

@mictadlo
Copy link
Author

OK, When do you think you would have time to fix chado?

@nathandunn
Copy link

nathandunn commented Jul 30, 2018 via email

@nathandunn
Copy link

@mictadlo I think that chado should be working now that I look at it more closely. The error that you are seeing is generated on the COMMENT line, but it still continues with the load:

screen shot 2018-08-02 at 2 43 21 pm

And when I run this docker image it comes up indicating that it has a working chado database connected:

screen shot 2018-08-02 at 2 40 28 pm

Let me know if a chado export doesn't work for you.

Also, if you have could provide me some additional context of what you are trying to do either here or off-line, I might be better able to provide you with advice as there are a lot of folks that've done this integration.

@nathandunn
Copy link

Re-open if you need to.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants