In the Selfhosted SQ (docker) version, the docker logs continuously log this error (by Postgres db container):
FATAL: role "root" does not exist
It is logged about every 5 seconds.
Can this be fixed?
Thanks!
In the Selfhosted SQ (docker) version, the docker logs continuously log this error (by Postgres db container):
FATAL: role "root" does not exist
It is logged about every 5 seconds.
Can this be fixed?
Thanks!
Hi,
Can you share a bit more of the log context?
Thx,
Ann
Its just that one error repeated over and over again.
sonarpostgresql | 2025-04-25 14:14:47.082 UTC [121186] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:14:57.236 UTC [121194] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:15:07.386 UTC [121203] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:15:17.528 UTC [121211] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:15:27.681 UTC [121220] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:15:37.824 UTC [121229] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:15:47.975 UTC [121238] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:15:58.129 UTC [121247] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:16:08.280 UTC [121255] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:16:18.450 UTC [121263] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:16:28.591 UTC [121272] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:16:38.736 UTC [121281] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:16:48.879 UTC [121289] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:16:59.031 UTC [121298] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:17:09.184 UTC [121306] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:17:19.330 UTC [121314] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:17:29.489 UTC [121324] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:17:39.635 UTC [121333] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:17:49.783 UTC [121341] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:17:59.938 UTC [121350] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:18:10.093 UTC [121359] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:18:20.236 UTC [121368] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:18:30.408 UTC [121377] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:18:40.564 UTC [121386] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:18:50.718 UTC [121394] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:19:00.889 UTC [121403] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:19:11.035 UTC [121411] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:19:21.179 UTC [121420] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:19:31.324 UTC [121429] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:19:41.476 UTC [121438] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:19:51.631 UTC [121446] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:20:01.789 UTC [121455] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:20:11.940 UTC [121464] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:20:22.099 UTC [121473] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:20:32.264 UTC [121481] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:20:42.429 UTC [121490] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:20:52.573 UTC [121498] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:21:02.721 UTC [121508] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:21:12.866 UTC [121516] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:21:23.025 UTC [121525] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:21:33.189 UTC [121533] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:21:43.349 UTC [121542] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:21:53.505 UTC [121550] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:22:03.645 UTC [121559] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:22:13.794 UTC [121567] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:22:23.937 UTC [121576] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:22:34.089 UTC [121584] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:22:44.231 UTC [121593] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:22:54.409 UTC [121601] FATAL: role "root" does not exist
sonarpostgresql | 2025-04-25 14:23:04.566 UTC [121610] FATAL: role "root" does not exist
Hi,
There’s nothing before this?
Ann
Nope, its thousands of lines of that.
If you want logs before this, I literally would have to shut down/spin up again the container, and there is nothing unusual there.
From when I spun it up, the error first appears here:
sonarqube | 2025.04.23 22:39:39 INFO app[][o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/sonarqube/temp
sonarqube | 2025.04.23 22:39:39 INFO app[][o.s.a.es.EsSettings] Elasticsearch listening on [HTTP: 127.0.0.1:9001, TCP: 127.0.0.1:{}]
sonarqube | 2025.04.23 22:39:39 INFO app[][o.s.a.ProcessLauncherImpl] Launch process[ELASTICSEARCH] from [/opt/sonarqube/elasticsearch]: /opt/java/openjdk/bin/java -Xms4m -Xmx64m -XX:+UseSerialGC -Dcli.name=server -Dcli.script=./bin/elasticsearch -Dcli.libs=lib/tools/server-cli -Des.path.home=/opt/sonarqube/elasticsearch -Des.path.conf=/opt/sonarqube/temp/conf/es -Des.distribution.type=tar -cp /opt/sonarqube/elasticsearch/lib/*:/opt/sonarqube/elasticsearch/lib/cli-launcher/* org.elasticsearch.launcher.CliToolLauncher
sonarqube | 2025.04.23 22:39:39 INFO app[][o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
sonarqube | Standard Commons Logging discovery in action with spring-jcl: please remove commons-logging.jar from classpath in order to avoid potential conflicts
sonarqube | Apr 23, 2025 10:39:44 PM sun.util.locale.provider.LocaleProviderAdapter <clinit>
sonarqube | WARNING: COMPAT locale provider will be removed in a future release
sonarqube | 2025.04.23 22:39:45 INFO es[][o.e.n.j.JdkVectorLibrary] vec_caps=1
sonarqube | 2025.04.23 22:39:45 INFO es[][o.e.n.NativeAccess] Using native vector library; to disable start with -Dorg.elasticsearch.nativeaccess.enableVectorLibrary=false
sonarqube | 2025.04.23 22:39:45 INFO es[][o.e.n.NativeAccess] Using [jdk] native provider and native methods for [Linux]
sonarqube | 2025.04.23 22:39:45 WARN es[][o.a.l.i.v.VectorizationProvider] Java vector incubator module is not readable. For optimal vector performance, pass --add-modules jdk.incubator.vector to enable Vector API.
sonarqube | 2025.04.23 22:39:46 INFO es[][o.e.n.Node] version[8.16.3], pid[151], build[tar/2eb78bceb86e182dc8f45ab76a704b1bfd352c9d/2025-01-10T10:08:28.587559883Z], OS[Linux/6.8.0-54-generic/amd64], JVM[Eclipse Adoptium/OpenJDK 64-Bit Server VM/21.0.7/21.0.7+6-LTS]
sonarqube | 2025.04.23 22:39:46 INFO es[][o.e.n.Node] JVM home [/opt/java/openjdk], using bundled JDK [false]
sonarqube | 2025.04.23 22:39:46 INFO es[][o.e.n.Node] JVM arguments [-Des.networkaddress.cache.ttl=60, -Des.networkaddress.cache.negative.ttl=10, -Djava.security.manager=allow, -XX:+AlwaysPreTouch, -Xss1m, -Djava.awt.headless=true, -Dfile.encoding=UTF-8, -Djna.nosys=true, -XX:-OmitStackTraceInFastThrow, -Dio.netty.noUnsafe=true, -Dio.netty.noKeySetOptimization=true, -Dio.netty.recycler.maxCapacityPerThread=0, -Dlog4j.shutdownHookEnabled=false, -Dlog4j2.disable.jmx=true, -Dlog4j2.formatMsgNoLookups=true, -Djava.locale.providers=SPI,COMPAT, --enable-native-access=org.elasticsearch.nativeaccess,org.apache.lucene.core, -XX:ReplayDataFile=logs/replay_pid%p.log, -Des.distribution.type=tar, -XX:+UseG1GC, -Djava.io.tmpdir=/opt/sonarqube/temp, -XX:ErrorFile=/opt/sonarqube/logs/es_hs_err_pid%p.log, -Xlog:disable, -Des.networkaddress.cache.ttl=60, -Des.networkaddress.cache.negative.ttl=10, -XX:+AlwaysPreTouch, -Xss1m, -Djava.awt.headless=true, -Dfile.encoding=UTF-8, -Djna.nosys=true, -Djna.tmpdir=/opt/sonarqube/temp, -XX:-OmitStackTraceInFastThrow, -Dio.netty.noUnsafe=true, -Dio.netty.noKeySetOptimization=true, -Dio.netty.recycler.maxCapacityPerThread=0, -Dio.netty.allocator.numDirectArenas=0, -Dlog4j.shutdownHookEnabled=false, -Dlog4j2.disable.jmx=true, -Dlog4j2.formatMsgNoLookups=true, -Djava.locale.providers=COMPAT, -Des.enforce.bootstrap.checks=true, -Xmx512m, -Xms512m, -XX:MaxDirectMemorySize=256m, -XX:+HeapDumpOnOutOfMemoryError, -XX:G1HeapRegionSize=4m, -XX:InitiatingHeapOccupancyPercent=30, -XX:G1ReservePercent=15, --module-path=/opt/sonarqube/elasticsearch/lib, --add-modules=jdk.net, --add-modules=ALL-MODULE-PATH, -Djdk.module.main=org.elasticsearch.server]
sonarqube | 2025.04.23 22:39:46 INFO es[][o.e.n.Node] Default Locale [en_US]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [rest-root]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [x-pack-core]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [x-pack-redact]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [reindex]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [x-pack-security]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [x-pack-geoip-enterprise-downloader]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [x-pack-esql-core]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [x-pack-apm-data]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [parent-join]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [old-lucene-versions]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [lang-painless]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [counted-keyword]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [logsdb]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [x-pack-inference]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [analysis-common]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [health-shards-availability]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [dot-prefix-validation]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [transport-netty4]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [x-pack-otel-data]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [aggregations]
sonarqube | 2025.04.23 22:39:49 INFO es[][o.e.p.PluginsService] loaded module [apm]
sonarqube | 2025.04.23 22:39:51 INFO es[][o.e.e.NodeEnvironment] using [1] data paths, mounts [[/opt/sonarqube/data (/dev/nvme0n1p2)]], net usable_space [321.9gb], net total_space [456.8gb], types [ext4]
sonarqube | 2025.04.23 22:39:51 INFO es[][o.e.e.NodeEnvironment] heap size [512mb], compressed ordinary object pointers [true]
sonarqube | 2025.04.23 22:39:51 INFO es[][o.e.n.Node] node name [sonarqube], node ID [P37iemvMSW-0iKlwh55igQ], cluster name [sonarqube], roles [transform, data_hot, ml, data_frozen, ingest, data_cold, data, remote_cluster_client, master, data_warm, data_content]
sonarqube | 2025.04.23 22:39:55 INFO es[][o.e.i.r.RecoverySettings] using rate limit [40mb] with [default=40mb, read=0b, write=0b, max=0b]
sonarqube | 2025.04.23 22:39:55 INFO es[][o.e.f.FeatureService] Registered local node features [desired_node.version_deprecated, features_supported, file_settings, flattened.ignore_above_support, geoip.downloader.database.configuration, get_database_configuration_action.multi_node, health.extended_repository_indicator, knn_retriever_supported, license-trial-independent-version, mapper.boolean_dimension, mapper.flattened.ignore_above_with_arrays_support, mapper.ignore_above_index_level_setting, mapper.index_sorting_on_nested, mapper.keyword_dimension_ignore_above, mapper.keyword_normalizer_synthetic_source, mapper.pass_through_priority, mapper.query_index_mode, mapper.range.null_values_off_by_one_fix, mapper.segment_level_fields_stats, mapper.source.synthetic_source_copy_to_fix, mapper.source.synthetic_source_copy_to_inside_objects_fix, mapper.source.synthetic_source_fallback, mapper.source.synthetic_source_stored_fields_advance_fix, mapper.source.synthetic_source_with_copy_to_and_doc_values_false, mapper.subobjects_auto, mapper.subobjects_auto_fixes, mapper.synthetic_source_keep, mapper.track_ignored_source, mapper.vectors.bbq, mapper.vectors.bit_vectors, mapper.vectors.int4_quantization, put_database_configuration_action.ipinfo, random_reranker_retriever_supported, repositories.supports_usage_stats, rest.capabilities_action, rest.local_only_capabilities, retrievers_supported, routing.boolean_routing_path, routing.multi_value_routing_path, script.hamming, script.term_stats, search.vectors.k_param_supported, security.migration_framework, security.role_mapping_cleanup, security.roles_metadata_flattened, semantic_text.search_inference_id, simulate.component.template.substitutions, simulate.index.template.substitutions, simulate.mapping.validation, simulate.mapping.validation.templates, standard_retriever_supported, stats.include_disk_thresholds, text_similarity_reranker_retriever_composition_supported, text_similarity_reranker_retriever_supported, tsdb.ts_routing_hash_doc_value_parse_byte_ref, unified_highlighter_matched_fields, usage.data_tiers.precalculate_stats]
sonarqube | 2025.04.23 22:39:55 INFO es[][o.e.c.m.DataStreamGlobalRetentionSettings] Updated default factory retention to [null]
sonarqube | 2025.04.23 22:39:55 INFO es[][o.e.c.m.DataStreamGlobalRetentionSettings] Updated max factory retention to [null]
sonarqube | 2025.04.23 22:39:55 INFO es[][o.e.x.s.Security] Security is disabled
sonarqube | 2025.04.23 22:39:55 INFO es[][o.e.x.a.APMPlugin] APM ingest plugin is enabled
sonarqube | 2025.04.23 22:39:55 INFO es[][o.e.x.c.t.YamlTemplateRegistry] apm index template registry is enabled
sonarqube | 2025.04.23 22:39:56 INFO es[][o.e.x.o.OTelPlugin] OTel ingest plugin is enabled
sonarqube | 2025.04.23 22:39:56 INFO es[][o.e.x.c.t.YamlTemplateRegistry] OpenTelemetry index template registry is enabled
sonarqube | 2025.04.23 22:39:56 INFO es[][o.e.t.a.APM] Sending apm metrics is disabled
sonarqube | 2025.04.23 22:39:56 INFO es[][o.e.t.a.APM] Sending apm tracing is disabled
sonarqube | 2025.04.23 22:39:56 INFO es[][o.e.t.n.NettyAllocator] creating NettyAllocator with the following configs: [name=unpooled, suggested_max_allocation_size=1mb, factors={es.unsafe.use_unpooled_allocator=null, g1gc_enabled=true, g1gc_region_size=4mb, heap_size=512mb}]
sonarqube | 2025.04.23 22:39:56 INFO es[][o.e.d.DiscoveryModule] using discovery type [single-node] and seed hosts providers [settings]
sonarqube | 2025.04.23 22:39:57 INFO es[][o.e.n.Node] initialized
sonarqube | 2025.04.23 22:39:57 INFO es[][o.e.n.Node] starting ...
sonarqube | 2025.04.23 22:39:57 INFO es[][o.e.t.TransportService] publish_address {127.0.0.1:45477}, bound_addresses {127.0.0.1:45477}
sonarqube | 2025.04.23 22:39:58 INFO es[][o.e.b.BootstrapChecks] explicitly enforcing bootstrap checks
sonarqube | 2025.04.23 22:39:58 INFO es[][o.e.c.c.ClusterBootstrapService] this node is locked into cluster UUID [Rc4fACCbSUq2xyIwkr2IwA] and will not attempt further cluster bootstrapping
sonarqube | 2025.04.23 22:39:58 INFO es[][o.e.c.s.MasterService] elected-as-master ([1] nodes joined in term 5)[_FINISH_ELECTION_, {sonarqube}{P37iemvMSW-0iKlwh55igQ}{oK38c1w-RnWIf72W2sUTCg}{sonarqube}{127.0.0.1}{127.0.0.1:45477}{cdfhilmrstw}{8.16.3}{7000099-8518000} completing election], term: 5, version: 121, delta: master node changed {previous [], current [{sonarqube}{P37iemvMSW-0iKlwh55igQ}{oK38c1w-RnWIf72W2sUTCg}{sonarqube}{127.0.0.1}{127.0.0.1:45477}{cdfhilmrstw}{8.16.3}{7000099-8518000}]}
sonarqube | 2025.04.23 22:39:58 INFO es[][o.e.c.s.ClusterApplierService] master node changed {previous [], current [{sonarqube}{P37iemvMSW-0iKlwh55igQ}{oK38c1w-RnWIf72W2sUTCg}{sonarqube}{127.0.0.1}{127.0.0.1:45477}{cdfhilmrstw}{8.16.3}{7000099-8518000}]}, term: 5, version: 121, reason: Publication{term=5, version=121}
sonarqube | 2025.04.23 22:39:58 INFO es[][o.e.c.c.NodeJoinExecutor] node-join: [{sonarqube}{P37iemvMSW-0iKlwh55igQ}{oK38c1w-RnWIf72W2sUTCg}{sonarqube}{127.0.0.1}{127.0.0.1:45477}{cdfhilmrstw}{8.16.3}{7000099-8518000}] with reason [completing election]
sonarqube | 2025.04.23 22:39:58 INFO es[][o.e.h.AbstractHttpServerTransport] publish_address {127.0.0.1:9001}, bound_addresses {127.0.0.1:9001}
sonarqube | 2025.04.23 22:39:58 INFO es[][o.e.n.Node] started {sonarqube}{P37iemvMSW-0iKlwh55igQ}{oK38c1w-RnWIf72W2sUTCg}{sonarqube}{127.0.0.1}{127.0.0.1:45477}{cdfhilmrstw}{8.16.3}{7000099-8518000}{rack_id=sonarqube, xpack.installed=true}
sonarqube | 2025.04.23 22:39:59 INFO es[][o.e.l.ClusterStateLicenseService] license [f2582942-41a4-4f9d-8b63-91a8605353b0] mode [basic] - valid
sonarqube | 2025.04.23 22:39:59 INFO es[][o.e.c.f.AbstractFileWatchingService] starting file watcher ...
sonarqube | 2025.04.23 22:39:59 INFO es[][o.e.c.f.AbstractFileWatchingService] file settings service up and running [tid=66]
sonarqube | 2025.04.23 22:39:59 INFO es[][o.e.r.s.FileSettingsService] setting file [/opt/sonarqube/temp/conf/es/operator/settings.json] not found, initializing [file_settings] as empty
sonarqube | 2025.04.23 22:39:59 INFO es[][o.e.g.GatewayService] recovered [6] indices into cluster_state
sonarqube | 2025.04.23 22:39:59 INFO es[][o.e.h.n.s.HealthNodeTaskExecutor] Node [{sonarqube}{P37iemvMSW-0iKlwh55igQ}] is selected as the current health node.
sonarqube | 2025.04.23 22:40:00 INFO es[][o.e.c.r.a.AllocationService] current.health="GREEN" message="Cluster health status changed from [RED] to [GREEN] (reason: [shards started [[metadatas][0]]])." previous.health="RED" reason="shards started [[metadatas][0]]"
sonarqube | 2025.04.23 22:40:00 INFO app[][o.s.a.SchedulerImpl] Process[es] is up
sonarqube | 2025.04.23 22:40:00 INFO app[][o.s.a.ProcessLauncherImpl] Launch process[WEB_SERVER] from [/opt/sonarqube]: /opt/java/openjdk/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/opt/sonarqube/temp -XX:-OmitStackTraceInFastThrow --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED --add-exports=java.base/jdk.internal.ref=ALL-UNNAMED --add-opens=java.base/java.nio=ALL-UNNAMED --add-opens=java.base/sun.nio.ch=ALL-UNNAMED --add-opens=java.management/sun.management=ALL-UNNAMED --add-opens=jdk.management/com.sun.management.internal=ALL-UNNAMED -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/sonar-application-25.4.0.105899.jar:/opt/sonarqube/lib/jdbc/postgresql/postgresql-42.7.5.jar org.sonar.server.app.WebServer /opt/sonarqube/temp/sq-process5624260439021299024properties
sonarqube | 2025.04.23 22:40:01 INFO web[][o.s.p.ProcessEntryPoint] Starting Web Server
sonarqube | 2025.04.23 22:40:01 INFO web[][o.s.s.a.TomcatHttpConnectorFactory] Starting Tomcat on port 9000
sonarqube | Standard Commons Logging discovery in action with spring-jcl: please remove commons-logging.jar from classpath in order to avoid potential conflicts
sonarqube | 2025.04.23 22:40:02 INFO web[][o.s.s.p.LogServerVersion] SonarQube Server / 25.4.0.105899 / 39bfa48c57cda385d6a8af426776e9b6a5442bdb
sonarqube | 2025.04.23 22:40:03 INFO web[][o.s.d.DefaultDatabase] Create JDBC data source for jdbc:postgresql://db:5432/sonar
sonarqube | 2025.04.23 22:40:03 INFO web[][c.z.h.HikariDataSource] HikariPool-1 - Starting...
sonarqube | 2025.04.23 22:40:03 INFO web[][c.z.h.p.HikariPool] HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@15ac59c2
sonarqube | 2025.04.23 22:40:03 INFO web[][c.z.h.HikariDataSource] HikariPool-1 - Start completed.
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonarqube
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.d.m.h.MigrationHistoryTableImpl] Creating table schema_migrations
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy C# Code Quality and Security / 10.7.0.110445 / 691dea82a819f1c3499d48b83a09a9913674a420
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy Clean as You Code / 2.4.0.2018 / c2f7910f6ecac6faa73001eeac4bd79a2db98cd3
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy Flex Code Quality and Security / 2.14.0.5032 / 005476cddc54a18b78eca55d10338702eb31e4b0
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy Go Code Quality and Security / 1.21.1.1670 / d626c49023cbe02c416fd876d51864d461dd85d6
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy HTML Code Quality and Security / 3.19.0.5695 / 4d6d79c1783726575bb4d5bd72f4873e46a99e5f
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy IaC Code Quality and Security / 1.44.0.14670 / null
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy JaCoCo / 1.3.0.1538 / 74a7798c7cea687c72ed9df40c93eb7ea2a58c49
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy Java Advanced Code Quality Analyzer / 8.11.0.38440 / f78aa00ce21b83ade1888b48a22abb5c2305fd9d
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy Java Code Quality and Security / 8.11.0.38440 / f78aa00ce21b83ade1888b48a22abb5c2305fd9d
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy JavaScript/TypeScript/CSS Code Quality and Security / 10.21.1.30825 / 9d9a065b76d20669ebce90c4654042a3548ca212
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy Kotlin Code Quality and Security / 3.0.1.6889 / 527b6dc4f3d5bc70e4eec4f19118c84ae9e1120f
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy PHP Code Quality and Security / 3.45.0.12991 / null
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy Python Code Quality and Security / 5.2.0.20808 / 41375fe8eacc75892d776f22c64335c3e5927d3e
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy Ruby Code Quality and Security / 1.18.0.234 / 1f01fec0f8f7f5dc1b81463c09c41099674e04c0
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy Scala Code Quality and Security / 1.18.0.266 / 74ab5c801fc5876ffde218d96e74e87f43efee85
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy Text Code Quality and Security / 2.21.1.5779 / null
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy VB.NET Code Quality and Security / 10.7.0.110445 / 691dea82a819f1c3499d48b83a09a9913674a420
sonarqube | 2025.04.23 22:40:05 INFO web[][o.s.s.p.ServerPluginManager] Deploy XML Code Quality and Security / 2.12.0.5749 / 67cf0668dd25562b98d230d08013e9f08861f79a
sonarqube | 2025.04.23 22:40:07 INFO web[][o.s.s.p.d.m.c.PostgresCharsetHandler] Verify that database charset supports UTF8
sonarqube | 2025.04.23 22:40:08 INFO web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [http://localhost:9001]
sonarqube | 2025.04.23 22:40:08 INFO web[][o.s.s.p.d.m.AutoDbMigration] Automatically perform DB migration on fresh install
sonarqube | 2025.04.23 22:40:08 INFO web[][DbMigrations] Executing 41 DB migrations...
sonarqube | 2025.04.23 22:40:08 INFO web[][DbMigrations] 1/41 #1 'Create initial schema'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 1/41 #1 'Create initial schema': success | time=644ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 2/41 #2 'Populate initial schema'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 2/41 #2 'Populate initial schema': success | time=82ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 3/41 #202501000 'Rename 'sonar.portfolios.confidential.header' property to 'sonar.pdf.confidential.header.enabled''...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 3/41 #202501000 'Rename 'sonar.portfolios.confidential.header' property to 'sonar.pdf.confidential.header.enabled'': success | time=4ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 4/41 #202501001 'Delete removed complexity measures from 'project_measures' table'...
sonarqube | 2025.04.23 22:40:09 INFO web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 4/41 #202501001 'Delete removed complexity measures from 'project_measures' table': success | time=10ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 5/41 #202501002 'Delete removed complexity metrics from 'metrics' table'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 5/41 #202501002 'Delete removed complexity metrics from 'metrics' table': success | time=5ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 6/41 #202501003 'Create index on 'rule_tags' table'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 6/41 #202501003 'Create index on 'rule_tags' table': success | time=21ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 7/41 #202501004 'Rename 'Sonar Way' without 0 new issues condition to 'Sonar Way(legacy)''...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 7/41 #202501004 'Rename 'Sonar Way' without 0 new issues condition to 'Sonar Way(legacy)'': success | time=6ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 8/41 #202501005 'Create 'user_ai_tool_usages' table'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 8/41 #202501005 'Create 'user_ai_tool_usages' table': success | time=15ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 9/41 #202501006 'Add 'detected_ai_code' column to 'projects' table'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 9/41 #202501006 'Add 'detected_ai_code' column to 'projects' table': success | time=19ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 10/41 #202501007 'Create table 'migration_logs''...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 10/41 #202501007 'Create table 'migration_logs'': success | time=14ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 11/41 #202501008 'Log message if SAML configuration is not valid'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 11/41 #202501008 'Log message if SAML configuration is not valid': success | time=5ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 12/41 #202501009 'Add 'inline_annotations_enabled' column to 'project_alm_settings' table'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 12/41 #202501009 'Add 'inline_annotations_enabled' column to 'project_alm_settings' table': success | time=14ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 13/41 #202501010 'Populate 'inline_annotations_enabled' column for Azure'...
sonarqube | 2025.04.23 22:40:09 INFO web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 13/41 #202501010 'Populate 'inline_annotations_enabled' column for Azure': success | time=7ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 14/41 #202501011 'Update default admin password if still hashed with BCRYPT'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 14/41 #202501011 'Update default admin password if still hashed with BCRYPT': success | time=6ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 15/41 #202501012 'Log message if users are still relying on BCRYPT hashed passwords'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 15/41 #202501012 'Log message if users are still relying on BCRYPT hashed passwords': success | time=6ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 16/41 #202502000 'Drop 'issues_dependency' table'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 16/41 #202502000 'Drop 'issues_dependency' table': success | time=10ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 17/41 #202502001 'Drop 'cve_cwe' table'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 17/41 #202502001 'Drop 'cve_cwe' table': success | time=8ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 18/41 #202502002 'Drop 'cves' table'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 18/41 #202502002 'Drop 'cves' table': success | time=7ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 19/41 #202502003 'Create table for SCA releases'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 19/41 #202502003 'Create table for SCA releases': success | time=12ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 20/41 #202502004 'Create index for SCA releases component'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 20/41 #202502004 'Create index for SCA releases component': success | time=14ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 21/41 #202502005 'Create table for SCA dependencies'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 21/41 #202502005 'Create table for SCA dependencies': success | time=12ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 22/41 #202502006 'Create index for SCA dependencies to releases'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 22/41 #202502006 'Create index for SCA dependencies to releases': success | time=13ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 23/41 #202502007 'Create table for SCA issues'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 23/41 #202502007 'Create table for SCA issues': success | time=12ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 24/41 #202502008 'Create unique index on SCA issues'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 24/41 #202502008 'Create unique index on SCA issues': success | time=14ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 25/41 #202502009 'Create table for vulnerability subtype of SCA issues'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 25/41 #202502009 'Create table for vulnerability subtype of SCA issues': success | time=11ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 26/41 #202502010 'Create table for SCA issues to releases'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 26/41 #202502010 'Create table for SCA issues to releases': success | time=11ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 27/41 #202502011 'Create index for SCA issues to releases to SCA issues'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 27/41 #202502011 'Create index for SCA issues to releases to SCA issues': success | time=14ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 28/41 #202502012 'Create index for SCA issues to releases to SCA releases'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 28/41 #202502012 'Create index for SCA issues to releases to SCA releases': success | time=14ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 29/41 #202502013 'Create unique index for SCA issues to releases'...
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 29/41 #202502013 'Create unique index for SCA issues to releases': success | time=14ms
sonarqube | 2025.04.23 22:40:09 INFO web[][DbMigrations] 30/41 #202502014 'Add new_in_pull_request column to SCA releases'...
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 30/41 #202502014 'Add new_in_pull_request column to SCA releases': success | time=12ms
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 31/41 #202502015 'Add new_in_pull_request column to SCA dependencies'...
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 31/41 #202502015 'Add new_in_pull_request column to SCA dependencies': success | time=15ms
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 32/41 #202502016 'Insert default AI Codefix provider key and modelKey properties'...
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 32/41 #202502016 'Insert default AI Codefix provider key and modelKey properties': success | time=8ms
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 33/41 #202502017 'Add table 'architecture_graphs''...
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 33/41 #202502017 'Add table 'architecture_graphs'': success | time=14ms
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 34/41 #202502018 'Drop 'sca_releases_comp_uuid' index'...
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 34/41 #202502018 'Drop 'sca_releases_comp_uuid' index': success | time=12ms
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 35/41 #202502019 'Create 'sca_releases_comp_uuid_uuid' index'...
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 35/41 #202502019 'Create 'sca_releases_comp_uuid_uuid' index': success | time=16ms
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 36/41 #202502020 'Add 'sca_dependencies.production_scope' column'...
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 36/41 #202502020 'Add 'sca_dependencies.production_scope' column': success | time=14ms
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 37/41 #202502021 'Add declared_license_expression to SCA releases'...
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 37/41 #202502021 'Add declared_license_expression to SCA releases': success | time=11ms
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 38/41 #202502022 'Create 'uq_idx_ag_branch_type_source' for architecture graphs'...
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 38/41 #202502022 'Create 'uq_idx_ag_branch_type_source' for architecture graphs': success | time=14ms
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 39/41 #202503000 'Add known_package column to SCA releases'...
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 39/41 #202503000 'Add known_package column to SCA releases': success | time=13ms
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 40/41 #202503001 'Populate known_package column to SCA releases'...
sonarqube | 2025.04.23 22:40:10 INFO web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 40/41 #202503001 'Populate known_package column to SCA releases': success | time=5ms
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 41/41 #202503002 'Update known_package on SCA release to be not nullable'...
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] 41/41 #202503002 'Update known_package on SCA release to be not nullable': success | time=9ms
sonarqube | 2025.04.23 22:40:10 INFO web[][DbMigrations] Executed 41/41 DB migrations: success | time=1231ms
sonarqube | 2025.04.23 22:40:10 INFO web[][o.s.s.p.Platform] Database has been automatically updated
sonarqube | 2025.04.23 22:40:10 INFO web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceFilter@64a1116a [pattern=UrlPattern{inclusions=[/api/system/migrate_db.*, ...], exclusions=[/api/components/update_key, ...]}]
sonarqube | 2025.04.23 22:40:10 INFO web[][o.s.s.p.DetectPluginChange] Detect plugin changes
sonarqube | 2025.04.23 22:40:10 INFO web[][o.s.s.s.PropertiesDBCleaner] Clean up properties from db
sonarqube | 2025.04.23 22:40:12 INFO web[][o.h.v.i.util.Version] HV000001: Hibernate Validator null
sonarqube | 2025.04.23 22:40:13 INFO web[][o.s.s.s.LogServerId] Server ID: 243B8A4D-AZZkzwJfrVZVS0Q3WuEw
sonarqube | 2025.04.23 22:40:14 INFO web[][o.o.c.c.InitializationService] Initializing OpenSAML using the Java Services API
sonarqube | 2025.04.23 22:40:15 INFO web[][o.o.x.a.AlgorithmRegistry] Algorithm failed runtime support check, will not be usable: http://www.w3.org/2001/04/xmlenc#ripemd160
sonarqube | 2025.04.23 22:40:15 INFO web[][o.o.x.a.AlgorithmRegistry] Algorithm failed runtime support check, will not be usable: http://www.w3.org/2001/04/xmldsig-more#hmac-ripemd160
sonarqube | 2025.04.23 22:40:15 INFO web[][o.o.x.a.AlgorithmRegistry] Algorithm failed runtime support check, will not be usable: http://www.w3.org/2001/04/xmldsig-more#rsa-ripemd160
sonarqube | 2025.04.23 22:40:15 WARN web[][o.s.s.a.LogOAuthWarning] For security reasons, OAuth authentication should use HTTPS. You should set the property 'Administration > Configuration > Server base URL' to an HTTPS URL.
sonarqube | 2025.04.23 22:40:15 INFO web[][o.s.s.p.UpdateCenterClient] Update center: https://downloads.sonarsource.com/sonarqube/update/update-center.properties
sonarqube | 2025.04.23 22:40:17 INFO web[][o.s.s.a.p.ExpiredSessionsCleaner] Purge of expired session tokens has removed 0 elements
sonarqube | 2025.04.23 22:40:17 INFO web[][o.s.s.a.p.ExpiredSessionsCleaner] Purge of expired SAML message ids has removed 0 elements
sonarqube | 2025.04.23 22:40:17 INFO web[][o.s.s.n.NotificationDaemon] Notification service started (delay 60 sec.)
sonarqube | 2025.04.23 22:40:17 INFO web[][o.s.t.TelemetryDaemon] Sharing of SonarQube statistics is enabled.
sonarqube | 2025.04.23 22:40:19 INFO web[][o.s.s.r.r.RulesRegistrant] Register rules
sonarpostgresql | The files belonging to this database system will be owned by user "postgres".
sonarpostgresql | This user must also own the server process.
sonarpostgresql |
sonarpostgresql | The database cluster will be initialized with locale "en_US.utf8".
sonarpostgresql | The default database encoding has accordingly been set to "UTF8".
sonarpostgresql | The default text search configuration will be set to "english".
sonarpostgresql |
sonarpostgresql | Data page checksums are disabled.
sonarpostgresql |
sonarpostgresql | fixing permissions on existing directory /var/lib/postgresql/data ... ok
sonarpostgresql | creating subdirectories ... ok
sonarpostgresql | selecting dynamic shared memory implementation ... posix
sonarpostgresql | selecting default "max_connections" ... 100
sonarpostgresql | selecting default "shared_buffers" ... 128MB
sonarpostgresql | selecting default time zone ... Etc/UTC
sonarpostgresql | creating configuration files ... ok
sonarpostgresql | running bootstrap script ... ok
sonarpostgresql | performing post-bootstrap initialization ... ok
sonarpostgresql | syncing data to disk ... ok
sonarpostgresql |
sonarpostgresql |
sonarpostgresql | Success. You can now start the database server using:
sonarpostgresql |
sonarpostgresql | pg_ctl -D /var/lib/postgresql/data -l logfile start
sonarpostgresql |
sonarpostgresql | initdb: warning: enabling "trust" authentication for local connections
sonarpostgresql | initdb: hint: 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.
sonarpostgresql | waiting for server to start....2025-04-23 22:39:28.662 UTC [49] LOG: starting PostgreSQL 17.4 (Debian 17.4-1.pgdg120+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
sonarpostgresql | 2025-04-23 22:39:28.664 UTC [49] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
sonarpostgresql | 2025-04-23 22:39:28.669 UTC [52] LOG: database system was shut down at 2025-04-23 22:39:28 UTC
sonarpostgresql | 2025-04-23 22:39:28.678 UTC [49] LOG: database system is ready to accept connections
sonarpostgresql | done
sonarpostgresql | server started
sonarpostgresql | CREATE DATABASE
sonarpostgresql |
sonarpostgresql |
sonarpostgresql | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
sonarpostgresql |
sonarpostgresql | 2025-04-23 22:39:28.893 UTC [49] LOG: received fast shutdown request
sonarpostgresql | waiting for server to shut down....2025-04-23 22:39:28.894 UTC [49] LOG: aborting any active transactions
sonarpostgresql | 2025-04-23 22:39:28.897 UTC [49] LOG: background worker "logical replication launcher" (PID 55) exited with exit code 1
sonarpostgresql | 2025-04-23 22:39:28.897 UTC [50] LOG: shutting down
sonarpostgresql | 2025-04-23 22:39:28.898 UTC [50] LOG: checkpoint starting: shutdown immediate
sonarpostgresql | 2025-04-23 22:39:28.946 UTC [50] LOG: checkpoint complete: wrote 921 buffers (5.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.023 s, sync=0.023 s, total=0.049 s; sync files=301, longest=0.001 s, average=0.001 s; distance=4238 kB, estimate=4238 kB; lsn=0/1908970, redo lsn=0/1908970
sonarpostgresql | 2025-04-23 22:39:28.957 UTC [49] LOG: database system is shut down
sonarpostgresql | done
sonarpostgresql | server stopped
sonarpostgresql |
sonarpostgresql | PostgreSQL init process complete; ready for start up.
sonarpostgresql |
sonarpostgresql | 2025-04-23 22:39:29.042 UTC [1] LOG: starting PostgreSQL 17.4 (Debian 17.4-1.pgdg120+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
sonarpostgresql | 2025-04-23 22:39:29.042 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
sonarpostgresql | 2025-04-23 22:39:29.042 UTC [1] LOG: listening on IPv6 address "::", port 5432
sonarpostgresql | 2025-04-23 22:39:29.047 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
sonarpostgresql | 2025-04-23 22:39:29.053 UTC [65] LOG: database system was shut down at 2025-04-23 22:39:28 UTC
sonarpostgresql | 2025-04-23 22:39:29.063 UTC [1] LOG: database system is ready to accept connections
sonarpostgresql | 2025-04-23 22:39:37.771 UTC [76] FATAL: role "root" does not exist
Above part of the log from when it spun up
Note, this was the initial test I made, meanwhile server is on HTTPS and different URL etc, but the same error still appears.
PS: I am not sure all the data in above log is OK to share publicly, please, if you are aware of something in it that should be removed, can you delete my post or let me know?
Thank you.
Hi,
The docker-compose example is a bit wrong. In the database healthcheck the correct command should be:
test: [ "CMD-SHELL", "pg_isready -d $${POSTGRES_DB} -U $${POSTGRES_USER}" ]
Changing this will fix the issue.
That did the trick, I submitted a PR to Update docker-compose.yml by smileBeda · Pull Request #767 · SonarSource/docker-sonarqube · GitHub, in case it helps.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.