Problem with starting the Docker version

[Goatmaster]

Hey,

I have problems with the newest version of commafeed.

I am using it with docker compose an it worked fine before. The latest verison that worked for me was 5.2.0. I skipped the 5.3.0 and tried it now with version 5.3.1.

Now I get a "unable to connect" error.

Here is my docker-compose.yml file.

services:
  commafeed:
    image: athou/commafeed:latest-postgresql
    restart: unless-stopped
    environment:
      - QUARKUS_DATASOURCE_JDBC_URL=jdbc:postgresql://postgresql:5432/commafeed
      - QUARKUS_DATASOURCE_USERNAME=commafeed
      - QUARKUS_DATASOURCE_PASSWORD=commafeed
    deploy:
      resources:
        limits:
          memory: 256M
    ports:
      - 8082:8082

  postgresql:
    image: postgres:latest
    restart: unless-stopped
    environment:
      POSTGRES_USER: commafeed
      POSTGRES_PASSWORD: commafeed
      POSTGRES_DB: commafeed
    volumes:
      - /path/to/commafeed/db:/var/lib/postgresql/data

Would be nice to get it running again.

Thank you.

[Athou]

With so little information it's very hard to help you.

Now I get a "unable to connect" error.

It'd help if you could at least supply the exact error and in what log file you're reading it from.

[Goatmaster]

Where can I find the logs?

[Athou]

You're using docker compose, so you should get the logs with docker compose logs commafeed.

[Goatmaster]

Okay, here is the log.

commafeed-1  |

commafeed-1  |      .',,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,..

commafeed-1  |     ';;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;.

commafeed-1  |    .;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;.

commafeed-1  |    ';;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;.

commafeed-1  |    ';;;;;;;;;;;;;;;''''',,,;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;:;.           .':clllc;.

commafeed-1  |    ';;;;;;;;;;;;;.           ..',;;;;;;;;;;;;;;;;;;;;;;;;;;:;.         .:dd:'...,lxo.

commafeed-1  |    ';;;;;;;;;;;:,.                .',;;;;;;;;;;;;;;;;;;;;;;:;.        .lx:.       ,o:     .....     .   ...    ....    .  ....    ...        .....
commafeed-1  |    ';;;;;;;;;;;;;'                   .';;;;;;;;;;;;;;;;;;;;:;.        ;ko               ;oocccoo,  .ooclcldd;:llcoxc. 'doclcldo;:lllod:   .ldlccldc.
commafeed-1  |    ';;;;;;;;;;;;;;;,'''....             .,;;;;;;;;;;;;;;;;;:;.        ck:              lx;     :xc .dk;   .dkc.   cx; ,xx,   'xk:.  .ox'  ,:.    ;x:
commafeed-1  |    ';;;;;;;;;;;;;;;;;;;;;;;;;,..          .,;;;;;;;;;;;;;;;:;.        :kc             'xl.     .ox..do.   .ox.    ;x; ,xc    .dd.    cx,  .':ccccok:
commafeed-1  |    ';;;;;;;;;;;;;;,.....',,;;;;;;'.         .;;;;;;;;;;;;;;:;.        .dx'        .cc.'xo.     .ox..do.   .ox.    ;x; ,xc    .dd.    cx, .dd,.   ;x:
commafeed-1  |    ';;;;;;;;;;;;;.          .',;;;;,.        .,;;;;;;;;;;;;:;.         'dx:.    .'ox;  cx:.   .:x: .do.   .ox.    ;x; ,xc    .dd.    cx, ;xc    .ok:
commafeed-1  |    ';;;;;;;;;;;;,.             .';;;;,.       .,;;;;;;;;;;;:;.          .,lodooodoc.    ,lolclol,  .oc     co.    ,d, 'o:    .ol.    :d' .:dolllccdc
commafeed-1  |    ';;;;;;;;;;;;;'.              .';;;;.       .,;;;;;;;;;;:;.              .....          ...
                                   ...
commafeed-1  |    ';;;;;;;;;;;;;;;;,,,'..         .;;;;'       .;;;;;;;;;;:;.

commafeed-1  |    ';;;;;;;;;;;;;;;;;;;;;;,.        .;;;;.       ';;;;;;;;;:;.         .;ccccccccc:.
             .:.
commafeed-1  |    ';;;;;;;;;;;;,'......';;;,.       .;;;,.      .;;;;;;;;;:;.        .okc,''''''''
             ;x:
commafeed-1  |    ';;;;;;;;;;;.         .,;;;.      .,;;;.       ,;;;;;;;;:;.        .dx.             ....         ....        ....  ;x:
commafeed-1  |    ';;;;;;;;;;'           .;;;'       ';;;'       ';;;;;;;;:;.        .dx.          .;ol::coc.   .coc::lo:.   'lolcccclx:
commafeed-1  |    ';;;;;;;;;;.           .,;;,.      ,;;;,.      ,;;;;;;;;:;.        .dkdollllll:..od'    .od. .do.    'do. ,xl.    'dk:
commafeed-1  |    ';;;;;;;;;;,.          .;;;;,.   .';;;;;,.   .,;;;;;;;;;:;.        .dx'         ;xxlcccccdx;.ckdlccccldd'.ox.      ;x:
commafeed-1  |    ';;;;;;;;;;;;'.       .,;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;:;.        .dx.         ,xl........  :x:........  lx'      :x:
commafeed-1  |    ';;;;;;;;;;;;;;;'.   .;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;:;.        .dx.         .ld,    .:l. .oo.    .cc. ,xo.    ,dk:
commafeed-1  |    ';;;;;;;;;;;;;;,. .';;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;:;.        .lo.          .;oocclol'   .:olccloc.   .ldlcclccd;
commafeed-1  |    ';;;;;;;;;;;;;;,,;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;:;.                         ....         ....         ...
commafeed-1  |    ';;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;:;.

commafeed-1  |    .;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;,.

commafeed-1  |     .,;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;,.

commafeed-1  |       ..''''''''''''''''''''''''''''''''''''''''''''''''...

commafeed-1  |

commafeed-1  |
                    Powered by Quarkus 3.15.1
commafeed-1  | 2024-10-16 11:50:35,055 WARN  [io.agr.pool] (agroal-11) Datasource '<default>': Connection to postgresql:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
commafeed-1  | 2024-10-16 11:50:35,059 ERROR [io.qua.run.Application] (main) Failed to start application: java.lang.RuntimeException: Failed to start quarkus
commafeed-1  |  at io.quarkus.runner.ApplicationImpl.doStart(Unknown Source)
commafeed-1  |  at io.quarkus.runtime.Application.start(Application.java:101)
commafeed-1  |  at io.quarkus.runtime.ApplicationLifecycleManager.run(ApplicationLifecycleManager.java:119)
commafeed-1  |  at io.quarkus.runtime.Quarkus.run(Quarkus.java:71)
commafeed-1  |  at io.quarkus.runtime.Quarkus.run(Quarkus.java:44)
commafeed-1  |  at io.quarkus.runtime.Quarkus.run(Quarkus.java:124)
commafeed-1  |  at io.quarkus.runner.GeneratedMain.main(Unknown Source)
commafeed-1  | Caused by: java.lang.IllegalStateException: Error starting Liquibase
commafeed-1  |  at io.quarkus.liquibase.runtime.LiquibaseRecorder.doStartActions(LiquibaseRecorder.java:93)
commafeed-1  |  at io.quarkus.deployment.steps.LiquibaseProcessor$startLiquibase1744275855.deploy_0(Unknown Source)
commafeed-1  |  at io.quarkus.deployment.steps.LiquibaseProcessor$startLiquibase1744275855.deploy(Unknown Source)
commafeed-1  |  ... 7 more
commafeed-1  | Caused by: java.lang.IllegalStateException: org.postgresql.util.PSQLException: Connection to postgresql:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
commafeed-1  |  at io.quarkus.liquibase.LiquibaseFactory.createLiquibase(LiquibaseFactory.java:138)
commafeed-1  |  at io.quarkus.liquibase.LiquibaseFactory_1d48OwssPZoQytD2p8kGRAP54yY_Synthetic_ClientProxy.createLiquibase(Unknown Source)
commafeed-1  |  at io.quarkus.liquibase.runtime.LiquibaseRecorder.doStartActions(LiquibaseRecorder.java:70)
commafeed-1  |  ... 9 more
commafeed-1  | Caused by: org.postgresql.util.PSQLException: Connection to postgresql:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
commafeed-1  |  at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:352)
commafeed-1  |  at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54)
commafeed-1  |  at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:273)
commafeed-1  |  at org.postgresql.Driver.makeConnection(Driver.java:446)
commafeed-1  |  at org.postgresql.Driver.connect(Driver.java:298)
commafeed-1  |  at io.agroal.pool.ConnectionFactory.createConnection(ConnectionFactory.java:225)
commafeed-1  |  at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:580)
commafeed-1  |  at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:561)
commafeed-1  |  at java.base@21.0.4/java.util.concurrent.FutureTask.run(FutureTask.java:317)
commafeed-1  |  at io.agroal.pool.util.PriorityScheduledExecutor.beforeExecute(PriorityScheduledExecutor.java:75)
commafeed-1  |  at java.base@21.0.4/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
commafeed-1  |  at java.base@21.0.4/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
commafeed-1  |  at java.base@21.0.4/java.lang.Thread.runWith(Thread.java:1596)
commafeed-1  |  at java.base@21.0.4/java.lang.Thread.run(Thread.java:1583)
commafeed-1  |  at org.graalvm.nativeimage.builder/com.oracle.svm.core.thread.PlatformThreads.threadStartRoutine(PlatformThreads.java:896)
commafeed-1  |  at org.graalvm.nativeimage.builder/com.oracle.svm.core.thread.PlatformThreads.threadStartRoutine(PlatformThreads.java:872)
commafeed-1  | Caused by: java.net.ConnectException: Connection refused
commafeed-1  |  at java.base@21.0.4/sun.nio.ch.Net.pollConnect(Native Method)
commafeed-1  |  at java.base@21.0.4/sun.nio.ch.Net.pollConnectNow(Net.java:682)
commafeed-1  |  at java.base@21.0.4/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
commafeed-1  |  at java.base@21.0.4/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:592)
commafeed-1  |  at java.base@21.0.4/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
commafeed-1  |  at java.base@21.0.4/java.net.Socket.connect(Socket.java:751)
commafeed-1  |  at org.postgresql.core.PGStream.createSocket(PGStream.java:260)
commafeed-1  |  at org.postgresql.core.PGStream.<init>(PGStream.java:121)
commafeed-1  |  at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:140)
commafeed-1  |  at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:268)
commafeed-1  |  ... 15 more
commafeed-1  |

[Athou]

Connection to postgresql:5432 refused.

Your PostgreSQL instance is not accessible. Use docker compose logs postgresql to check the pgsql logs.

[Goatmaster]

Ah, looks like a Problem with the postgressql version. I will try a older one.

postgresql-1  |
postgresql-1  | PostgreSQL Database directory appears to contain a database; Skipping initialization
postgresql-1  |
postgresql-1  | 2024-10-16 11:50:36.506 UTC [1] FATAL:  database files are incompatible with server
postgresql-1  | 2024-10-16 11:50:36.506 UTC [1] DETAIL:  The data directory was initialized by PostgreSQL version 16, which is not compatible with this version 17.0 (Debian 17.0-1.pgdg120+1).

[Goatmaster]

I switched back to postgressql version 16.4 and now it is working. Thank you for the help. I am still learning how to work with docker.

best