need db health check #16
Description
This problem occur in windows os.
need db health check.
PS C:\Users\mineg\myworking\0000dev> git clone https://github.com/support-project/docker-knowledge.git
Cloning into 'docker-knowledge'...
remote: Enumerating objects: 325, done.
Receiving objects: 100% (325/325), 38.70 KiB | 19.35 MiB/s, done.
remote: Total 325 (delta 0), reused 0 (delta 0), pack-reused 325
Resolving deltas: 100% (108/108), done.
PS C:\Users\mineg\myworking\0000dev> ls
ディレクトリ: C:\Users\mineg\myworking\0000dev
Mode LastWriteTime Length Name
---- ------------- ------ ----
d----- 2023/05/19 15:40 awsomedocker
d----- 2023/05/19 15:38 cl
d----- 2023/05/22 10:39 docker-knowledge
d----- 2023/05/18 10:12 elephant_in_the_refrigerator
PS C:\Users\mineg\myworking\0000dev> cd .\docker-knowledge\
PS C:\Users\mineg\myworking\0000dev\docker-knowledge> ls
ディレクトリ: C:\Users\mineg\myworking\0000dev\docker-knowledge
Mode LastWriteTime Length Name
---- ------------- ------ ----
d----- 2023/05/22 10:39 volumes
-a---- 2023/05/22 10:39 97 .gitignore
-a---- 2023/05/22 10:39 625 docker-compose.yml
-a---- 2023/05/22 10:39 536 Dockerfile
-a---- 2023/05/22 10:39 863 README.md
PS C:\Users\mineg\myworking\0000dev\docker-knowledge> docker-compose up
[+] Running 2/0
✔ Container docker-knowledge-db-1 Created 0.0s
✔ Container docker-knowledge-app-1 Created 0.0s
Attaching to docker-knowledge-app-1, docker-knowledge-db-1
docker-knowledge-db-1 | The files belonging to this database system will be owned by user "postgres".
docker-knowledge-db-1 | This user must also own the server process.
docker-knowledge-db-1 |
docker-knowledge-db-1 | The database cluster will be initialized with locale "en_US.utf8".
docker-knowledge-db-1 | The default database encoding has accordingly been set to "UTF8".
docker-knowledge-db-1 | The default text search configuration will be set to "english".
docker-knowledge-db-1 |
docker-knowledge-db-1 | Data page checksums are disabled.
docker-knowledge-db-1 |
docker-knowledge-db-1 | fixing permissions on existing directory /var/lib/postgresql/data ... ok
docker-knowledge-db-1 | creating subdirectories ... ok
docker-knowledge-db-1 | selecting default max_connections ... 100
docker-knowledge-db-1 | selecting default shared_buffers ... 128MB
docker-knowledge-db-1 | selecting default timezone ... Etc/UTC
docker-knowledge-db-1 | selecting dynamic shared memory implementation ... posix
docker-knowledge-db-1 | creating configuration files ... ok
docker-knowledge-app-1 | 22-May-2023 01:40:22.688 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.32
docker-knowledge-app-1 | 22-May-2023 01:40:22.689 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Jun 20 2018 19:50:35 UTC
docker-knowledge-app-1 | 22-May-2023 01:40:22.689 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.32.0
docker-knowledge-app-1 | 22-May-2023 01:40:22.689 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux
docker-knowledge-app-1 | 22-May-2023 01:40:22.689 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 5.15.90.1-microsoft-standard-WSL2
docker-knowledge-app-1 | 22-May-2023 01:40:22.689 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
docker-knowledge-app-1 | 22-May-2023 01:40:22.689 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /usr/lib/jvm/java-8-openjdk-amd64/jre
docker-knowledge-app-1 | 22-May-2023 01:40:22.689 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_171-8u171-b11-1~deb9u1-b11
docker-knowledge-app-1 | 22-May-2023 01:40:22.689 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
docker-knowledge-app-1 | 22-May-2023 01:40:22.689 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /usr/local/tomcat
docker-knowledge-app-1 | 22-May-2023 01:40:22.689 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /usr/local/tomcat
docker-knowledge-app-1 | 22-May-2023 01:40:22.689 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/usr/local/tomcat/conf/logging.properties
docker-knowledge-app-1 | 22-May-2023 01:40:22.689 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
docker-knowledge-app-1 | 22-May-2023 01:40:22.689 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
docker-knowledge-app-1 | 22-May-2023 01:40:22.690 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
docker-knowledge-app-1 | 22-May-2023 01:40:22.690 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
docker-knowledge-app-1 | 22-May-2023 01:40:22.690 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
docker-knowledge-app-1 | 22-May-2023 01:40:22.690 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/usr/local/tomcat
docker-knowledge-app-1 | 22-May-2023 01:40:22.690 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/local/tomcat
docker-knowledge-app-1 | 22-May-2023 01:40:22.690 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/usr/local/tomcat/temp
docker-knowledge-app-1 | 22-May-2023 01:40:22.690 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library [1.2.17] using APR version [1.5.2].
docker-knowledge-app-1 | 22-May-2023 01:40:22.690 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
docker-knowledge-app-1 | 22-May-2023 01:40:22.690 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
docker-knowledge-app-1 | 22-May-2023 01:40:22.692 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.1.0f 25 May 2017]
docker-knowledge-app-1 | 22-May-2023 01:40:22.730 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
docker-knowledge-app-1 | 22-May-2023 01:40:22.735 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
docker-knowledge-app-1 | 22-May-2023 01:40:22.738 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
docker-knowledge-app-1 | 22-May-2023 01:40:22.739 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
docker-knowledge-app-1 | 22-May-2023 01:40:22.740 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 220 ms
docker-knowledge-app-1 | 22-May-2023 01:40:22.751 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
docker-knowledge-app-1 | 22-May-2023 01:40:22.751 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.32
docker-knowledge-app-1 | 22-May-2023 01:40:22.766 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [/usr/local/tomcat/webapps/ROOT.war]
docker-knowledge-db-1 | running bootstrap script ... ok
docker-knowledge-app-1 | 22-May-2023 01:40:27.843 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.
docker-knowledge-app-1 | Env [KNOWLEDGE_HOME] was not found.
docker-knowledge-app-1 | INFO 2023-05-22 01:40:28,045 GlobalInitializationListener(36) [APP LOG] /root/.knowledge/logs/app.log
docker-knowledge-app-1 | INFO 2023-05-22 01:40:28,114 DBConnenctionLogic(45) Custom connection setting is exists.
docker-knowledge-app-1 | 22-May-2023 01:40:28.269 SEVERE [localhost-startStop-1] org.postgresql.Driver.connect Connection error:
docker-knowledge-app-1 | org.postgresql.util.PSQLException: Connection to db:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
docker-knowledge-app-1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:265)
docker-knowledge-app-1 | at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
docker-knowledge-app-1 | at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
docker-knowledge-app-1 | at org.postgresql.Driver.makeConnection(Driver.java:450)
docker-knowledge-app-1 | at org.postgresql.Driver.connect(Driver.java:252)
docker-knowledge-app-1 | at java.sql.DriverManager.getConnection(DriverManager.java:664)
docker-knowledge-app-1 | at java.sql.DriverManager.getConnection(DriverManager.java:247)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.newConnection(ConnectionPoolImpl.java:123)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.getCon(ConnectionPoolImpl.java:105)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.getConnection(ConnectionPoolImpl.java:66)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.getConnection(ConnectionPoolImpl.java:60)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionManager.getConnection(ConnectionManager.java:281)
docker-knowledge-app-1 | at org.support.project.ormapping.transaction.TransactionManager.start(TransactionManager.java:64)
docker-knowledge-app-1 | at org.support.project.ormapping.transaction.Transaction.invoke(Transaction.java:39)
docker-knowledge-app-1 | at org.support.project.aop.Intercepter.invoke(Intercepter.java:174)
docker-knowledge-app-1 | at org.support.project.web.dao.SystemsDao_$$_jvst421_0.selectOnKey(SystemsDao_$$_jvst421_0.java)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.InitDB.init(InitDB.java:127)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.InitializationListener.contextInitialized(InitializationListener.java:41)
docker-knowledge-app-1 | at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
docker-knowledge-app-1 | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
docker-knowledge-app-1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
docker-knowledge-app-1 | at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
docker-knowledge-app-1 | at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
docker-knowledge-app-1 | at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
docker-knowledge-app-1 | at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
docker-knowledge-app-1 | at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
docker-knowledge-app-1 | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
docker-knowledge-app-1 | at java.util.concurrent.FutureTask.run(FutureTask.java:266)
docker-knowledge-app-1 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
docker-knowledge-app-1 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
docker-knowledge-app-1 | at java.lang.Thread.run(Thread.java:748)
docker-knowledge-app-1 | Caused by: java.net.ConnectException: Connection refused (Connection refused)
docker-knowledge-app-1 | at java.net.PlainSocketImpl.socketConnect(Native Method)
docker-knowledge-app-1 | at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
docker-knowledge-app-1 | at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
docker-knowledge-app-1 | at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
docker-knowledge-app-1 | at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
docker-knowledge-app-1 | at java.net.Socket.connect(Socket.java:589)
docker-knowledge-app-1 | at org.postgresql.core.PGStream.<init>(PGStream.java:68)
docker-knowledge-app-1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
docker-knowledge-app-1 | ... 30 more
docker-knowledge-app-1 |
docker-knowledge-app-1 | ERROR 2023-05-22 01:40:28,271 ConnectionPoolImpl(127) Can't create a new connection for jdbc:postgresql://db/knowledge_production
docker-knowledge-app-1 | org.postgresql.util.PSQLException: Connection to db:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
docker-knowledge-app-1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:265)
docker-knowledge-app-1 | at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
docker-knowledge-app-1 | at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
docker-knowledge-app-1 | at org.postgresql.Driver.makeConnection(Driver.java:450)
docker-knowledge-app-1 | at org.postgresql.Driver.connect(Driver.java:252)
docker-knowledge-app-1 | at java.sql.DriverManager.getConnection(DriverManager.java:664)
docker-knowledge-app-1 | at java.sql.DriverManager.getConnection(DriverManager.java:247)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.newConnection(ConnectionPoolImpl.java:123)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.getCon(ConnectionPoolImpl.java:105)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.getConnection(ConnectionPoolImpl.java:66)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.getConnection(ConnectionPoolImpl.java:60)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionManager.getConnection(ConnectionManager.java:281)
docker-knowledge-app-1 | at org.support.project.ormapping.transaction.TransactionManager.start(TransactionManager.java:64)
docker-knowledge-app-1 | at org.support.project.ormapping.transaction.Transaction.invoke(Transaction.java:39)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.InitDB.init(InitDB.java:127)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.InitializationListener.contextInitialized(InitializationListener.java:41)
docker-knowledge-app-1 | at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
docker-knowledge-app-1 | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
docker-knowledge-app-1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
docker-knowledge-app-1 | at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
docker-knowledge-app-1 | at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
docker-knowledge-app-1 | at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
docker-knowledge-app-1 | at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
docker-knowledge-app-1 | at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
docker-knowledge-app-1 | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
docker-knowledge-app-1 | at java.util.concurrent.FutureTask.run(FutureTask.java:266)
docker-knowledge-app-1 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
docker-knowledge-app-1 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
docker-knowledge-app-1 | at java.lang.Thread.run(Thread.java:748)
docker-knowledge-app-1 | Caused by: java.net.ConnectException: Connection refused (Connection refused)
docker-knowledge-app-1 | at java.net.PlainSocketImpl.socketConnect(Native Method)
docker-knowledge-app-1 | at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
docker-knowledge-app-1 | at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
docker-knowledge-app-1 | at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
docker-knowledge-app-1 | at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
docker-knowledge-app-1 | at java.net.Socket.connect(Socket.java:589)
docker-knowledge-app-1 | at org.postgresql.core.PGStream.<init>(PGStream.java:68)
docker-knowledge-app-1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
docker-knowledge-app-1 | ... 28 more
docker-knowledge-app-1 | INFO 2023-05-22 01:40:28,276 Intercepter(218) [ERROR] class org.support.project.web.dao.SystemsDao_$$_jvst421_0 : selectOnKey : コネクションの生成に失敗しました。 [cause] Connection to db:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
docker-knowledge-app-1 | ----- SQL Infomation -----
docker-knowledge-app-1 |
docker-knowledge-app-1 | INFO 2023-05-22 01:40:28,277 Intercepter(220) <Cause>
docker-knowledge-app-1 | org.postgresql.util.PSQLException: Connection to db:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
docker-knowledge-app-1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:265)
docker-knowledge-app-1 | at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
docker-knowledge-app-1 | at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
docker-knowledge-app-1 | at org.postgresql.Driver.makeConnection(Driver.java:450)
docker-knowledge-app-1 | at org.postgresql.Driver.connect(Driver.java:252)
docker-knowledge-app-1 | at java.sql.DriverManager.getConnection(DriverManager.java:664)
docker-knowledge-app-1 | at java.sql.DriverManager.getConnection(DriverManager.java:247)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.newConnection(ConnectionPoolImpl.java:123)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.getCon(ConnectionPoolImpl.java:105)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.getConnection(ConnectionPoolImpl.java:66)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.getConnection(ConnectionPoolImpl.java:60)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionManager.getConnection(ConnectionManager.java:281)
docker-knowledge-app-1 | at org.support.project.ormapping.transaction.TransactionManager.start(TransactionManager.java:64)
docker-knowledge-app-1 | at org.support.project.ormapping.transaction.Transaction.invoke(Transaction.java:39)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.InitDB.init(InitDB.java:127)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.InitializationListener.contextInitialized(InitializationListener.java:41)
docker-knowledge-app-1 | at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
docker-knowledge-app-1 | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
docker-knowledge-app-1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
docker-knowledge-app-1 | at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
docker-knowledge-app-1 | at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
docker-knowledge-app-1 | at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
docker-knowledge-app-1 | at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
docker-knowledge-app-1 | at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
docker-knowledge-app-1 | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
docker-knowledge-app-1 | at java.util.concurrent.FutureTask.run(FutureTask.java:266)
docker-knowledge-app-1 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
docker-knowledge-app-1 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
docker-knowledge-app-1 | at java.lang.Thread.run(Thread.java:748)
docker-knowledge-app-1 | Caused by: java.net.ConnectException: Connection refused (Connection refused)
docker-knowledge-app-1 | at java.net.PlainSocketImpl.socketConnect(Native Method)
docker-knowledge-app-1 | at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
docker-knowledge-app-1 | at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
docker-knowledge-app-1 | at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
docker-knowledge-app-1 | at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
docker-knowledge-app-1 | at java.net.Socket.connect(Socket.java:589)
docker-knowledge-app-1 | at org.postgresql.core.PGStream.<init>(PGStream.java:68)
docker-knowledge-app-1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
docker-knowledge-app-1 | ... 28 more
docker-knowledge-app-1 | 22-May-2023 01:40:28.280 SEVERE [localhost-startStop-1] org.postgresql.Driver.connect Connection error:
docker-knowledge-app-1 | org.postgresql.util.PSQLException: Connection to db:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
docker-knowledge-app-1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:265)
docker-knowledge-app-1 | at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
docker-knowledge-app-1 | at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
docker-knowledge-app-1 | at org.postgresql.Driver.makeConnection(Driver.java:450)
docker-knowledge-app-1 | at org.postgresql.Driver.connect(Driver.java:252)
docker-knowledge-app-1 | at java.sql.DriverManager.getConnection(DriverManager.java:664)
docker-knowledge-app-1 | at java.sql.DriverManager.getConnection(DriverManager.java:247)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.newConnection(ConnectionPoolImpl.java:123)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.getCon(ConnectionPoolImpl.java:105)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.getConnection(ConnectionPoolImpl.java:66)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.getConnection(ConnectionPoolImpl.java:60)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionManager.getConnection(ConnectionManager.java:281)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionManager.getConnection(ConnectionManager.java:244)
docker-knowledge-app-1 | at org.support.project.ormapping.dao.AbstractDao.getConnection(AbstractDao.java:108)
docker-knowledge-app-1 | at org.support.project.ormapping.dao.AbstractDao.executeUpdate(AbstractDao.java:458)
docker-knowledge-app-1 | at org.support.project.knowledge.dao.gen.DatabaseControlDao.dropAllTable(DatabaseControlDao.java:77)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.v0_0_1.InitializeSystem.createTables(InitializeSystem.java:95)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.v0_0_1.InitializeSystem.doMigrate(InitializeSystem.java:32)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.InitDB.doMigrate(InitDB.java:199)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.InitDB.doInit(InitDB.java:121)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.InitDB.init(InitDB.java:136)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.InitializationListener.contextInitialized(InitializationListener.java:41)
docker-knowledge-app-1 | at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
docker-knowledge-app-1 | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
docker-knowledge-app-1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
docker-knowledge-app-1 | at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
docker-knowledge-app-1 | at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
docker-knowledge-app-1 | at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
docker-knowledge-app-1 | at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
docker-knowledge-app-1 | at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
docker-knowledge-app-1 | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
docker-knowledge-app-1 | at java.util.concurrent.FutureTask.run(FutureTask.java:266)
docker-knowledge-app-1 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
docker-knowledge-app-1 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
docker-knowledge-app-1 | at java.lang.Thread.run(Thread.java:748)
docker-knowledge-app-1 | Caused by: java.net.ConnectException: Connection refused (Connection refused)
docker-knowledge-app-1 | at java.net.PlainSocketImpl.socketConnect(Native Method)
docker-knowledge-app-1 | at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
docker-knowledge-app-1 | at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
docker-knowledge-app-1 | at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
docker-knowledge-app-1 | at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
docker-knowledge-app-1 | at java.net.Socket.connect(Socket.java:589)
docker-knowledge-app-1 | at org.postgresql.core.PGStream.<init>(PGStream.java:68)
docker-knowledge-app-1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
docker-knowledge-app-1 | ... 34 more
docker-knowledge-app-1 |
docker-knowledge-app-1 | ERROR 2023-05-22 01:40:28,280 ConnectionPoolImpl(127) Can't create a new connection for jdbc:postgresql://db/knowledge_production
docker-knowledge-app-1 | org.postgresql.util.PSQLException: Connection to db:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
docker-knowledge-app-1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:265)
docker-knowledge-app-1 | at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
docker-knowledge-app-1 | at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
docker-knowledge-app-1 | at org.postgresql.Driver.makeConnection(Driver.java:450)
docker-knowledge-app-1 | at org.postgresql.Driver.connect(Driver.java:252)
docker-knowledge-app-1 | at java.sql.DriverManager.getConnection(DriverManager.java:664)
docker-knowledge-app-1 | at java.sql.DriverManager.getConnection(DriverManager.java:247)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.newConnection(ConnectionPoolImpl.java:123)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.getCon(ConnectionPoolImpl.java:105)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.getConnection(ConnectionPoolImpl.java:66)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionPoolImpl.getConnection(ConnectionPoolImpl.java:60)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionManager.getConnection(ConnectionManager.java:281)
docker-knowledge-app-1 | at org.support.project.ormapping.connection.ConnectionManager.getConnection(ConnectionManager.java:244)
docker-knowledge-app-1 | at org.support.project.ormapping.dao.AbstractDao.getConnection(AbstractDao.java:108)
docker-knowledge-app-1 | at org.support.project.ormapping.dao.AbstractDao.executeUpdate(AbstractDao.java:458)
docker-knowledge-app-1 | at org.support.project.knowledge.dao.gen.DatabaseControlDao.dropAllTable(DatabaseControlDao.java:77)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.v0_0_1.InitializeSystem.createTables(InitializeSystem.java:95)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.v0_0_1.InitializeSystem.doMigrate(InitializeSystem.java:32)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.InitDB.doMigrate(InitDB.java:199)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.InitDB.doInit(InitDB.java:121)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.InitDB.init(InitDB.java:136)
docker-knowledge-app-1 | at org.support.project.knowledge.deploy.InitializationListener.contextInitialized(InitializationListener.java:41)
docker-knowledge-app-1 | at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
docker-knowledge-app-1 | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
docker-knowledge-app-1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
docker-knowledge-app-1 | at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
docker-knowledge-app-1 | at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
docker-knowledge-app-1 | at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
docker-knowledge-app-1 | at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
docker-knowledge-app-1 | at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
docker-knowledge-app-1 | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
docker-knowledge-app-1 | at java.util.concurrent.FutureTask.run(FutureTask.java:266)
docker-knowledge-app-1 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
docker-knowledge-app-1 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
docker-knowledge-app-1 | at java.lang.Thread.run(Thread.java:748)
docker-knowledge-app-1 | Caused by: java.net.ConnectException: Connection refused (Connection refused)
docker-knowledge-app-1 | at java.net.PlainSocketImpl.socketConnect(Native Method)
docker-knowledge-app-1 | at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
docker-knowledge-app-1 | at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
docker-knowledge-app-1 | at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
docker-knowledge-app-1 | at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
docker-knowledge-app-1 | at java.net.Socket.connect(Socket.java:589)
docker-knowledge-app-1 | at org.postgresql.core.PGStream.<init>(PGStream.java:68)
docker-knowledge-app-1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
docker-knowledge-app-1 | ... 34 more
docker-knowledge-app-1 | 22-May-2023 01:40:28.285 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
docker-knowledge-app-1 | 22-May-2023 01:40:28.317 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [] startup failed due to previous errors
docker-knowledge-app-1 | INFO 2023-05-22 01:40:28,321 CronListener(239) finish batch processes.
docker-knowledge-app-1 | 22-May-2023 01:40:28.328 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/usr/local/tomcat/webapps/ROOT.war] has finished in [5,561] ms
docker-knowledge-app-1 | 22-May-2023 01:40:28.328 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/usr/local/tomcat/webapps/examples]
docker-knowledge-app-1 | 22-May-2023 01:40:28.405 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/usr/local/tomcat/webapps/examples] has finished in [77] ms
docker-knowledge-app-1 | 22-May-2023 01:40:28.405 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/usr/local/tomcat/webapps/manager]
docker-knowledge-app-1 | 22-May-2023 01:40:28.418 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/usr/local/tomcat/webapps/manager] has finished in [13] ms
docker-knowledge-app-1 | 22-May-2023 01:40:28.418 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/usr/local/tomcat/webapps/host-manager]
docker-knowledge-app-1 | 22-May-2023 01:40:28.427 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/usr/local/tomcat/webapps/host-manager] has finished in [9] ms
docker-knowledge-app-1 | 22-May-2023 01:40:28.427 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/usr/local/tomcat/webapps/docs]
docker-knowledge-app-1 | 22-May-2023 01:40:28.435 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/usr/local/tomcat/webapps/docs] has finished in [8] ms
docker-knowledge-app-1 | 22-May-2023 01:40:28.440 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
docker-knowledge-app-1 | 22-May-2023 01:40:28.451 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
docker-knowledge-app-1 | 22-May-2023 01:40:28.458 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 5718 ms
docker-knowledge-db-1 | performing post-bootstrap initialization ... ok
docker-knowledge-db-1 |
docker-knowledge-db-1 | WARNING: enabling "trust" authentication for local connections
docker-knowledge-db-1 | You can change this by editing pg_hba.conf or using the option -A, or
docker-knowledge-db-1 | --auth-local and --auth-host, the next time you run initdb.
docker-knowledge-db-1 | syncing data to disk ... ok
docker-knowledge-db-1 |
docker-knowledge-db-1 | Success. You can now start the database server using:
docker-knowledge-db-1 |
docker-knowledge-db-1 | pg_ctl -D /var/lib/postgresql/data -l logfile start
docker-knowledge-db-1 |
docker-knowledge-db-1 | waiting for server to start....LOG: database system was shut down at 2023-05-22 01:40:33 UTC
docker-knowledge-db-1 | LOG: MultiXact member wraparound protections are now enabled
docker-knowledge-db-1 | LOG: autovacuum launcher started
docker-knowledge-db-1 | LOG: database system is ready to accept connections
docker-knowledge-db-1 | done
docker-knowledge-db-1 | server started
docker-knowledge-db-1 | CREATE DATABASE
docker-knowledge-db-1 |
docker-knowledge-db-1 |
docker-knowledge-db-1 | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
docker-knowledge-db-1 |
docker-knowledge-db-1 | LOG: received fast shutdown request
docker-knowledge-db-1 | waiting for server to shut down...LOG: aborting any active transactions
docker-knowledge-db-1 | LOG: autovacuum launcher shutting down
docker-knowledge-db-1 | LOG: shutting down
docker-knowledge-db-1 | .LOG: database system is shut down
docker-knowledge-db-1 | done
docker-knowledge-db-1 | server stopped
docker-knowledge-db-1 |
docker-knowledge-db-1 | PostgreSQL init process complete; ready for start up.
docker-knowledge-db-1 |
docker-knowledge-db-1 | LOG: database system was shut down at 2023-05-22 01:40:42 UTC
docker-knowledge-db-1 | LOG: MultiXact member wraparound protections are now enabled
docker-knowledge-db-1 | LOG: database system is ready to accept connections
docker-knowledge-db-1 | LOG: autovacuum launcher started