FATAL: role "root" does not exist

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.

4 Likes

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.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.