Checking the container logs I found:
# docker logs -f zammad-docker-compose_zammad-init_1
Payload size: 0M
/opt/zammad/lib/search_index_backend.rb:36:in `info'
/opt/zammad/lib/tasks/zammad/search_index_es.rake:76:in `block (3 levels) in <main>'
/usr/local/bundle/gems/rake-13.0.6/exe/rake:27:in `<top (required)>'
/usr/local/bin/bundle:23:in `load'
/usr/local/bin/bundle:23:in `<main>'
Tasks: TOP => zammad:searchindex:rebuild => zammad:searchindex:version_supported
(See full trace by running task with --trace)
initialising / updating database...
I, [2022-12-22T12:11:19.575102 #24-7380] INFO -- : Using memcached as Rails cache store.
I, [2022-12-22T12:11:19.575249 #24-7380] INFO -- : Using Redis as web socket session store.
W, [2022-12-22T12:11:21.335417 #24-7380] WARN -- : Setting "timezone_default" is empty. Using UTC instead. Please set system timezone.
I, [2022-12-22T12:11:21.485959 #24-7380] INFO -- : Setting.set('models_searchable', ["Chat::Session", "KnowledgeBase::Answer::Translation", "Organization", "Ticket", "User"])
I, [2022-12-22T12:11:24.011477 #26-8280] INFO -- : Using memcached as Rails cache store.
I, [2022-12-22T12:11:24.011654 #26-8280] INFO -- : Using Redis as web socket session store.
W, [2022-12-22T12:11:25.819096 #26-8280] WARN -- : Setting "timezone_default" is empty. Using UTC instead. Please set system timezone.
I, [2022-12-22T12:11:25.986280 #26-8280] INFO -- : Setting.set('models_searchable', ["Chat::Session", "KnowledgeBase::Answer::Translation", "Organization", "Ticket", "User"])
changing settings...
I, [2022-12-22T12:11:28.746123 #28-7380] INFO -- : Using memcached as Rails cache store.
I, [2022-12-22T12:11:28.746300 #28-7380] INFO -- : Using Redis as web socket session store.
W, [2022-12-22T12:11:30.463246 #28-7380] WARN -- : Setting "timezone_default" is empty. Using UTC instead. Please set system timezone.
I, [2022-12-22T12:11:30.614175 #28-7380] INFO -- : Setting.set('models_searchable', ["Chat::Session", "KnowledgeBase::Answer::Translation", "Organization", "Ticket", "User"])
I, [2022-12-22T12:11:31.398368 #28-7380] INFO -- : Setting.set('es_url', "http://zammad-elasticsearch:9200")
I, [2022-12-22T12:11:33.657264 #30-7380] INFO -- : Using memcached as Rails cache store.
I, [2022-12-22T12:11:33.657344 #30-7380] INFO -- : Using Redis as web socket session store.
W, [2022-12-22T12:11:35.459170 #30-7380] WARN -- : Setting "timezone_default" is empty. Using UTC instead. Please set system timezone.
I, [2022-12-22T12:11:35.615629 #30-7380] INFO -- : Setting.set('models_searchable', ["Chat::Session", "KnowledgeBase::Answer::Translation", "Organization", "Ticket", "User"])
I, [2022-12-22T12:11:36.397897 #30-7380] INFO -- : Setting.set('es_index', "zammad")
rebuilding es searchindex...
I, [2022-12-22T12:13:48.135644 #35-8280] INFO -- : Using memcached as Rails cache store.
I, [2022-12-22T12:13:48.135737 #35-8280] INFO -- : Using Redis as web socket session store.
W, [2022-12-22T12:13:49.953426 #35-8280] WARN -- : Setting "timezone_default" is empty. Using UTC instead. Please set system timezone.
I, [2022-12-22T12:13:50.111511 #35-8280] INFO -- : Setting.set('models_searchable', ["Chat::Session", "KnowledgeBase::Answer::Translation", "Organization", "Ticket", "User"])
E, [2022-12-22T12:14:14.417374 #35-8280] ERROR -- : Unable to process GET request to elasticsearch URL 'http://zammad-elasticsearch:9200'. Check the response and payload for detailed information:
Response:
#<UserAgent::Result:0x0000559a77b32a88 @success=false, @body=nil, @data=nil, @code=0, @content_type=nil, @error="#<Net::OpenTimeout: execution expired>", @header=nil>
Payload:
null
Payload size: 0M
rake aborted!
Unable to process GET request to elasticsearch URL 'http://zammad-elasticsearch:9200'. Check the response and payload for detailed information:
Response:
#<UserAgent::Result:0x0000559a77b32a88 @success=false, @body=nil, @data=nil, @code=0, @content_type=nil, @error="#<Net::OpenTimeout: execution expired>", @header=nil>
Payload:
null
Payload size: 0M
/opt/zammad/lib/search_index_backend.rb:36:in `info'
/opt/zammad/lib/tasks/zammad/search_index_es.rake:76:in `block (3 levels) in <main>'
/usr/local/bundle/gems/rake-13.0.6/exe/rake:27:in `<top (required)>'
/usr/local/bin/bundle:23:in `load'
/usr/local/bin/bundle:23:in `<main>'
Tasks: TOP => zammad:searchindex:rebuild => zammad:searchindex:version_supported
(See full trace by running task with --trace)
initialising / updating database...
I, [2022-12-22T12:14:25.950004 #23-7380] INFO -- : Using memcached as Rails cache store.
I, [2022-12-22T12:14:25.950086 #23-7380] INFO -- : Using Redis as web socket session store.
W, [2022-12-22T12:14:27.788252 #23-7380] WARN -- : Setting "timezone_default" is empty. Using UTC instead. Please set system timezone.
I, [2022-12-22T12:14:27.943367 #23-7380] INFO -- : Setting.set('models_searchable', ["Chat::Session", "KnowledgeBase::Answer::Translation", "Organization", "Ticket", "User"])
I, [2022-12-22T12:14:30.624945 #25-8280] INFO -- : Using memcached as Rails cache store.
I, [2022-12-22T12:14:30.625188 #25-8280] INFO -- : Using Redis as web socket session store.
W, [2022-12-22T12:14:32.371594 #25-8280] WARN -- : Setting "timezone_default" is empty. Using UTC instead. Please set system timezone.
I, [2022-12-22T12:14:32.642758 #25-8280] INFO -- : Setting.set('models_searchable', ["Chat::Session", "KnowledgeBase::Answer::Translation", "Organization", "Ticket", "User"])
changing settings...
I, [2022-12-22T12:14:35.129010 #27-7380] INFO -- : Using memcached as Rails cache store.
I, [2022-12-22T12:14:35.129089 #27-7380] INFO -- : Using Redis as web socket session store.
W, [2022-12-22T12:14:36.863023 #27-7380] WARN -- : Setting "timezone_default" is empty. Using UTC instead. Please set system timezone.
I, [2022-12-22T12:14:37.029417 #27-7380] INFO -- : Setting.set('models_searchable', ["Chat::Session", "KnowledgeBase::Answer::Translation", "Organization", "Ticket", "User"])
I, [2022-12-22T12:14:37.814779 #27-7380] INFO -- : Setting.set('es_url', "http://zammad-elasticsearch:9200")
I, [2022-12-22T12:14:40.101266 #29-7380] INFO -- : Using memcached as Rails cache store.
I, [2022-12-22T12:14:40.101354 #29-7380] INFO -- : Using Redis as web socket session store.
W, [2022-12-22T12:14:41.836719 #29-7380] WARN -- : Setting "timezone_default" is empty. Using UTC instead. Please set system timezone.
I, [2022-12-22T12:14:41.992771 #29-7380] INFO -- : Setting.set('models_searchable', ["Chat::Session", "KnowledgeBase::Answer::Translation", "Organization", "Ticket", "User"])
I, [2022-12-22T12:14:42.787438 #29-7380] INFO -- : Setting.set('es_index', "zammad")
# docker logs -f zammad-docker-compose_zammad-postgresql_1
PostgreSQL init process complete; ready for start up.
2022-12-21 13:15:45.777 UTC [1] LOG: starting PostgreSQL 15.1 on x86_64-pc-linux-musl, compiled by gcc (Alpine 12.2.1_git20220924-r4) 12.2.1 20220924, 64-bit
2022-12-21 13:15:45.777 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2022-12-21 13:15:45.777 UTC [1] LOG: listening on IPv6 address "::", port 5432
2022-12-21 13:15:45.787 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-12-21 13:15:45.803 UTC [51] LOG: database system was shut down at 2022-12-21 13:15:45 UTC
2022-12-21 13:15:46.095 UTC [1] LOG: database system is ready to accept connections
2022-12-21 13:15:57.663 UTC [55] LOG: incomplete startup packet
2022-12-21 13:16:05.847 UTC [56] FATAL: database "zammad_production" does not exist
2022-12-21 13:16:05.997 UTC [58] FATAL: database "zammad_production" does not exist
2022-12-21 13:16:06.039 UTC [59] FATAL: database "zammad_production" does not exist
2022-12-21 13:16:08.074 UTC [60] FATAL: database "zammad_production" does not exist
2022-12-21 13:16:11.095 UTC [61] FATAL: database "zammad_production" does not exist
2022-12-21 13:16:11.167 UTC [63] FATAL: database "zammad_production" does not exist
2022-12-21 13:16:11.240 UTC [64] FATAL: database "zammad_production" does not exist
2022-12-21 13:16:13.455 UTC [67] ERROR: relation "settings" does not exist at character 454
2022-12-21 13:16:13.455 UTC [67] STATEMENT: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
c.collname, col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a
LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
WHERE a.attrelid = '"settings"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
2022-12-21 13:17:20.017 UTC [74] LOG: unexpected EOF on client connection with an open transaction
2022-12-21 13:17:30.932 UTC [1] LOG: received fast shutdown request
2022-12-21 13:17:30.949 UTC [1] LOG: aborting any active transactions
2022-12-21 13:17:30.956 UTC [1] LOG: background worker "logical replication launcher" (PID 54) exited with exit code 1
2022-12-21 13:17:30.957 UTC [49] LOG: shutting down
2022-12-21 13:17:30.958 UTC [49] LOG: checkpoint starting: shutdown immediate
2022-12-21 13:17:32.106 UTC [49] LOG: checkpoint complete: wrote 3771 buffers (23.0%); 0 WAL file(s) added, 0 removed, 3 recycled; write=0.293 s, sync=0.840 s, total=1.149 s; sync files=567, longest=0.025 s, average=0.002 s; distance=43695 kB, estimate=43695 kB
2022-12-21 13:17:32.129 UTC [1] LOG: database system is shut down
PostgreSQL Database directory appears to contain a database; Skipping initialization
2022-12-22 12:08:00.796 UTC [1] LOG: starting PostgreSQL 15.1 on x86_64-pc-linux-musl, compiled by gcc (Alpine 12.2.1_git20220924-r4) 12.2.1 20220924, 64-bit
2022-12-22 12:08:00.796 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2022-12-22 12:08:00.796 UTC [1] LOG: listening on IPv6 address "::", port 5432
2022-12-22 12:08:00.800 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-12-22 12:08:00.869 UTC [23] LOG: database system was shut down at 2022-12-21 13:17:32 UTC
2022-12-22 12:08:00.887 UTC [1] LOG: database system is ready to accept connections
2022-12-22 12:08:02.485 UTC [27] LOG: incomplete startup packet
2022-12-22 12:11:09.538 UTC [54] LOG: incomplete startup packet
2022-12-22 12:13:00.968 UTC [21] LOG: checkpoint starting: time
2022-12-22 12:13:05.104 UTC [21] LOG: checkpoint complete: wrote 44 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.118 s, sync=0.012 s, total=4.136 s; sync files=13, longest=0.002 s, average=0.001 s; distance=91 kB, estimate=91 kB
2022-12-22 12:14:15.906 UTC [81] LOG: incomplete startup packet
# docker logs -f zammad-docker-compose_zammad-elasticsearch_1
[2022-12-22T12:08:16,771][INFO ][o.e.h.n.s.HealthNodeTaskExecutor] [294b2c5e4186] Node [{294b2c5e4186}{TkKuKEhtT0q0PNEDAZsvpg}] is selected as the current health node.
[2022-12-22T12:08:36,808][ERROR][o.e.i.g.GeoIpDownloader ] [294b2c5e4186] exception during geoip databases update java.net.UnknownHostException: geoip.elastic.co
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:567)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:633)
at java.base/sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:304)
at java.base/sun.net.NetworkClient.doConnect(NetworkClient.java:178)
at java.base/sun.net.www.http.HttpClient.openServer(HttpClient.java:531)
at java.base/sun.net.www.http.HttpClient.openServer(HttpClient.java:636)
at java.base/sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:266)
at java.base/sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:380)
at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:193)
at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1242)
at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1128)
at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:179)
at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1665)
at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1589)
at java.base/java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:529)
at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:308)
at org.elasticsearch.ingest.geoip@8.5.1/org.elasticsearch.ingest.geoip.HttpClient.lambda$get$0(HttpClient.java:46)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:569)
at org.elasticsearch.ingest.geoip@8.5.1/org.elasticsearch.ingest.geoip.HttpClient.doPrivileged(HttpClient.java:88)
at org.elasticsearch.ingest.geoip@8.5.1/org.elasticsearch.ingest.geoip.HttpClient.get(HttpClient.java:40)
at org.elasticsearch.ingest.geoip@8.5.1/org.elasticsearch.ingest.geoip.HttpClient.getBytes(HttpClient.java:36)
at org.elasticsearch.ingest.geoip@8.5.1/org.elasticsearch.ingest.geoip.GeoIpDownloader.fetchDatabasesOverview(GeoIpDownloader.java:155)
at org.elasticsearch.ingest.geoip@8.5.1/org.elasticsearch.ingest.geoip.GeoIpDownloader.updateDatabases(GeoIpDownloader.java:143)
at org.elasticsearch.ingest.geoip@8.5.1/org.elasticsearch.ingest.geoip.GeoIpDownloader.runDownloader(GeoIpDownloader.java:274)
at org.elasticsearch.ingest.geoip@8.5.1/org.elasticsearch.ingest.geoip.GeoIpDownloaderTaskExecutor.nodeOperation(GeoIpDownloaderTaskExecutor.java:102)
at org.elasticsearch.ingest.geoip@8.5.1/org.elasticsearch.ingest.geoip.GeoIpDownloaderTaskExecutor.nodeOperation(GeoIpDownloaderTaskExecutor.java:48)
at org.elasticsearch.server@8.5.1/org.elasticsearch.persistent.NodePersistentTasksExecutor$1.doRun(NodePersistentTasksExecutor.java:42)
at org.elasticsearch.server@8.5.1/org.elasticsearch.common.util.concurrent.ThreadContext$ContextPreservingAbstractRunnable.doRun(ThreadContext.java:892)
at org.elasticsearch.server@8.5.1/org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:26)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:833)