After migrating Database I dont see quality gates or projects in the UI

sriram · June 27, 2024, 9:21pm

Hi guys,
I am using sonar version v10.5.1 deployed via helm.
I am basically trying to backup and restore. I did perform pg_dump and moved all the schemas/datas into the new DB.
I have updated Postgresql connections under values.yaml file to connect to the new database and i see successful logs for the connection.
But the projects, gates, profiles does not show up in the UI
the user has all the necessary permissions to the schema

Colin · July 2, 2024, 9:10am

It sounds like something is wrong with your SonarQube server’s elastic search index.

Have you enabled persistence?

If so, it sounds like the /data/es8 folder of the persisted volume and restart. You might also consider disabling persistency.

In any case, knowing if you have persistence enabled will be useful!

sriram · July 2, 2024, 3:03pm

hi
yes persistance was enabled before. i did try to disable it and redeploy.
Still i could not see any of gates or projects.

and I need suggestions for this as well
For now the Sonar application is connecting to public schema (by default)
is there a way I can make the application to connect to other schemas in the database.
In helm charts i only see these values
postgresqlUsername: “”
postgresqlPassword: “”
postgresqlDatabase: “”
i do not see an option to select schema

sriram · July 3, 2024, 4:53pm

attaching logs

postgresql 16:41:36.82 
postgresql 16:41:36.83 Welcome to the Bitnami postgresql container
postgresql 16:41:36.83 Subscribe to project updates by watching https://github.com/bitnami/bitnami-docker-postgresql
postgresql 16:41:36.83 Submit issues and feature requests at https://github.com/bitnami/bitnami-docker-postgresql/issues
postgresql 16:41:36.83 
postgresql 16:41:36.85 INFO  ==> ** Starting PostgreSQL setup **
postgresql 16:41:36.89 INFO  ==> Validating settings in POSTGRESQL_* env vars..
postgresql 16:41:36.90 INFO  ==> Loading custom pre-init scripts...
postgresql 16:41:36.90 INFO  ==> Initializing PostgreSQL database...
postgresql 16:41:36.93 INFO  ==> pg_hba.conf file not detected. Generating it...
postgresql 16:41:36.94 INFO  ==> Generating local authentication configuration
postgresql 16:41:38.79 INFO  ==> Starting PostgreSQL in background...
postgresql 16:41:39.19 INFO  ==> Changing password of postgres
postgresql 16:41:39.21 INFO  ==> Creating user admin1
postgresql 16:41:39.23 INFO  ==> Granting access to "admin1" to the database "database_name"
postgresql 16:41:39.27 INFO  ==> Setting ownership for the 'public' schema database "database_name" to "admin1"
postgresql 16:41:39.31 INFO  ==> Configuring replication parameters
postgresql 16:41:39.35 INFO  ==> Configuring fsync
postgresql 16:41:39.43 INFO  ==> Loading custom scripts...
postgresql 16:41:39.43 INFO  ==> Enabling remote connections
postgresql 16:41:39.45 INFO  ==> Stopping PostgreSQL...
waiting for server to shut down.... done
server stopped
postgresql 16:41:39.57 INFO  ==> ** PostgreSQL setup finished! **
postgresql 16:41:39.60 INFO  ==> ** Starting PostgreSQL **
2024-07-03 16:41:39.629 GMT [1] LOG:  pgaudit extension initialized
2024-07-03 16:41:39.629 GMT [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-07-03 16:41:39.629 GMT [1] LOG:  listening on IPv6 address "::", port 5432
2024-07-03 16:41:39.632 GMT [1] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
2024-07-03 16:41:39.646 GMT [154] LOG:  database system was shut down at 2024-07-03 16:41:39 GMT
2024-07-03 16:41:39.653 GMT [1] LOG:  database system is ready to accept connections
2024-07-03 16:41:46.730 GMT [168] LOG:  incomplete startup packet

2024.07.03 16:41:49 INFO  app[][o.s.a.AppFileSystem] Cleaning or creating temp directory /opt/sonarqube/temp
2024.07.03 16:41:49 INFO  app[][o.s.a.es.EsSettings] Elasticsearch listening on [HTTP: 127.0.0.1:9001, TCP: 127.0.0.1:41347]
2024.07.03 16:41:49 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
2024.07.03 16:41:49 INFO  app[][o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running
2024.07.03 16:42:02 INFO  es[][o.e.n.Node] version[8.11.0], pid[79], build[tar/d9ec3fa628c7b0ba3d25692e277ba26814820b20/2023-11-04T10:04:57.184859352Z], OS[Linux/5.10.217-205.860.amzn2.x86_64/amd64], JVM[Eclipse Adoptium/OpenJDK 64-Bit Server VM/17.0.11/17.0.11+9]
2024.07.03 16:42:02 INFO  es[][o.e.n.Node] JVM home [/opt/java/openjdk], using bundled JDK [false]
2024.07.03 16:42:02 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, --add-opens=java.base/java.io=org.elasticsearch.preallocate, -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, -Dcom.redhat.fips=false, -Des.enforce.bootstrap.checks=true, -Xmx512m, -Xms512m, -XX:MaxDirectMemorySize=256m, -XX:+HeapDumpOnOutOfMemoryError, -XX:G1HeapRegionSize=4m, -XX:InitiatingHeapOccupancyPercent=30, -XX:G1ReservePercent=15, -Des.distribution.type=tar, --module-path=/opt/sonarqube/elasticsearch/lib, --add-modules=jdk.net, --add-modules=ALL-MODULE-PATH, -Djdk.module.main=org.elasticsearch.server]
2024.07.03 16:42:06 INFO  es[][o.e.p.PluginsService] loaded module [lang-painless]
2024.07.03 16:42:06 INFO  es[][o.e.p.PluginsService] loaded module [x-pack-core]
2024.07.03 16:42:06 INFO  es[][o.e.p.PluginsService] loaded module [old-lucene-versions]
2024.07.03 16:42:06 INFO  es[][o.e.p.PluginsService] loaded module [parent-join]
2024.07.03 16:42:06 INFO  es[][o.e.p.PluginsService] loaded module [rest-root]
2024.07.03 16:42:06 INFO  es[][o.e.p.PluginsService] loaded module [reindex]
2024.07.03 16:42:06 INFO  es[][o.e.p.PluginsService] loaded module [x-pack-redact]
2024.07.03 16:42:06 INFO  es[][o.e.p.PluginsService] loaded module [analysis-common]
2024.07.03 16:42:06 INFO  es[][o.e.p.PluginsService] loaded module [x-pack-security]
2024.07.03 16:42:06 INFO  es[][o.e.p.PluginsService] loaded module [transport-netty4]
2024.07.03 16:42:06 INFO  es[][o.e.p.PluginsService] loaded module [aggregations]
2024.07.03 16:42:06 INFO  es[][o.e.p.PluginsService] loaded module [apm]
2024.07.03 16:42:15 INFO  es[][o.e.e.NodeEnvironment] using [1] data paths, mounts [[/opt/sonarqube/data (/dev/nvme0n1p1)]], net usable_space [94gb], net total_space [99.9gb], types [xfs]
2024.07.03 16:42:15 INFO  es[][o.e.e.NodeEnvironment] heap size [512mb], compressed ordinary object pointers [true]
2024.07.03 16:42:15 INFO  es[][o.e.n.Node] node name [sonarqube], node ID [Ydh-ZvJRSD29RFYxWWGQeA], cluster name [sonarqube], roles [data_frozen, ingest, data_cold, data, remote_cluster_client, master, data_warm, data_content, transform, data_hot, ml]
2024.07.03 16:42:18 INFO  es[][o.e.x.s.Security] Security is disabled
2024.07.03 16:42:18 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}]
2024.07.03 16:42:19 INFO  es[][o.e.i.r.RecoverySettings] using rate limit [40mb] with [default=40mb, read=0b, write=0b, max=0b]
2024.07.03 16:42:19 INFO  es[][o.e.d.DiscoveryModule] using discovery type [single-node] and seed hosts providers [settings]
2024.07.03 16:42:20 INFO  es[][o.e.n.Node] initialized
2024.07.03 16:42:20 INFO  es[][o.e.n.Node] starting ...
2024.07.03 16:42:21 INFO  es[][o.e.t.TransportService] publish_address {127.0.0.1:41347}, bound_addresses {127.0.0.1:41347}
2024.07.03 16:42:21 INFO  es[][o.e.b.BootstrapChecks] explicitly enforcing bootstrap checks
2024.07.03 16:42:21 INFO  es[][o.e.c.c.ClusterBootstrapService] this node has not joined a bootstrapped cluster yet; [cluster.initial_master_nodes] is set to [sonarqube]
2024.07.03 16:42:21 INFO  es[][o.e.c.c.Coordinator] setting initial configuration to VotingConfiguration{Ydh-ZvJRSD29RFYxWWGQeA}
2024.07.03 16:42:21 INFO  es[][o.e.c.s.MasterService] elected-as-master ([1] nodes joined in term 1)[_FINISH_ELECTION_, {sonarqube}{Ydh-ZvJRSD29RFYxWWGQeA}{td6lnug1QDKRIDBQ5WQgog}{sonarqube}{127.0.0.1}{127.0.0.1:41347}{cdfhilmrstw}{8.11.0}{7000099-8500003} completing election], term: 1, version: 1, delta: master node changed {previous [], current [{sonarqube}{Ydh-ZvJRSD29RFYxWWGQeA}{td6lnug1QDKRIDBQ5WQgog}{sonarqube}{127.0.0.1}{127.0.0.1:41347}{cdfhilmrstw}{8.11.0}{7000099-8500003}]}
2024.07.03 16:42:21 INFO  es[][o.e.c.c.CoordinationState] cluster UUID set to [8oU7kdjUQH-oHG9pwh_F0A]
2024.07.03 16:42:22 INFO  es[][o.e.c.s.ClusterApplierService] master node changed {previous [], current [{sonarqube}{Ydh-ZvJRSD29RFYxWWGQeA}{td6lnug1QDKRIDBQ5WQgog}{sonarqube}{127.0.0.1}{127.0.0.1:41347}{cdfhilmrstw}{8.11.0}{7000099-8500003}]}, term: 1, version: 1, reason: Publication{term=1, version=1}
2024.07.03 16:42:22 INFO  es[][o.e.c.f.AbstractFileWatchingService] starting file watcher ...
2024.07.03 16:42:22 INFO  es[][o.e.c.f.AbstractFileWatchingService] file settings service up and running [tid=28]
2024.07.03 16:42:22 INFO  es[][o.e.h.AbstractHttpServerTransport] publish_address {127.0.0.1:9001}, bound_addresses {127.0.0.1:9001}
2024.07.03 16:42:22 INFO  es[][o.e.n.Node] started {sonarqube}{Ydh-ZvJRSD29RFYxWWGQeA}{td6lnug1QDKRIDBQ5WQgog}{sonarqube}{127.0.0.1}{127.0.0.1:41347}{cdfhilmrstw}{8.11.0}{7000099-8500003}{xpack.installed=true, rack_id=sonarqube}
2024.07.03 16:42:22 INFO  es[][o.e.c.c.NodeJoinExecutor] node-join: [{sonarqube}{Ydh-ZvJRSD29RFYxWWGQeA}{td6lnug1QDKRIDBQ5WQgog}{sonarqube}{127.0.0.1}{127.0.0.1:41347}{cdfhilmrstw}{8.11.0}{7000099-8500003}] with reason [completing election]
2024.07.03 16:42:22 INFO  es[][o.e.g.GatewayService] recovered [0] indices into cluster_state
2024.07.03 16:42:22 INFO  es[][o.e.h.n.s.HealthNodeTaskExecutor] Node [{sonarqube}{Ydh-ZvJRSD29RFYxWWGQeA}] is selected as the current health node.
2024.07.03 16:42:23 INFO  app[][o.s.a.SchedulerImpl] Process[es] is up
2024.07.03 16:42:23 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 -Dcom.redhat.fips=false -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/sonar-application-10.5.1.90531.jar:/opt/sonarqube/lib/jdbc/postgresql/postgresql-42.7.1.jar org.sonar.server.app.WebServer /opt/sonarqube/temp/sq-process5647430676300473597properties
WARNING: A terminally deprecated method in java.lang.System has been called
WARNING: System::setSecurityManager has been called by org.sonar.process.PluginSecurityManager (file:/opt/sonarqube/lib/sonar-application-10.5.1.90531.jar)
WARNING: Please consider reporting this to the maintainers of org.sonar.process.PluginSecurityManager
WARNING: System::setSecurityManager will be removed in a future release
2024.07.03 16:42:25 INFO  web[][o.s.p.ProcessEntryPoint] Starting Web Server
2024.07.03 16:42:25 INFO  es[][o.e.l.ClusterStateLicenseService] license [4e537ff7-024a-4548-8a3b-eb5e58e1d63a] mode [basic] - valid
2024.07.03 16:42:26 INFO  web[][o.s.s.a.TomcatHttpConnectorFactory] Starting Tomcat on port 9000
2024.07.03 16:42:29 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 10.5.1.90531 / a69dd88808638ec33015277e236bca319314ce8b
2024.07.03 16:42:29 INFO  web[][o.s.d.DefaultDatabase] Create JDBC data source for jdbc:postgresql://sonarqube-postgresql:5432/database_name
2024.07.03 16:42:29 INFO  web[][c.z.h.HikariDataSource] HikariPool-1 - Starting...
2024.07.03 16:42:29 INFO  web[][c.z.h.p.HikariPool] HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@773c0293
2024.07.03 16:42:29 INFO  web[][c.z.h.HikariDataSource] HikariPool-1 - Start completed.
2024.07.03 16:42:33 INFO  web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonarqube
2024.07.03 16:42:33 INFO  web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is enabled
2024.07.03 16:42:34 INFO  web[][o.s.s.p.d.m.h.MigrationHistoryTableImpl] Creating table schema_migrations
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy C# Code Quality and Security / 9.23.2.88755 / 7727153bb92db16ac5dedac33bfbbe6bb51e9666
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Clean as You Code / 2.3.0.1782 / 1db4e32c08cf9d0b999498e7ba4fd5849583dfdd
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Flex Code Quality and Security / 2.12.0.4568 / e8b2821a05db57b79b8ae85e3db1571f5b744273
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Go Code Quality and Security / 1.15.0.4655 / 28938525c4093d5e9fa4e858535bbcb60af7f066
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy HTML Code Quality and Security / 3.15.0.5107 / 2b98639c1367f85365fef88c2ba41ae5f19dfd66
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy IaC Code Quality and Security / 1.27.0.9518 / null
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy JaCoCo / 1.3.0.1538 / 74a7798c7cea687c72ed9df40c93eb7ea2a58c49
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Java Code Quality and Security / 7.33.0.35775 / 0614cc7e6978a72c551bd3116b14036eb3ae991e
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy JavaScript/TypeScript/CSS Code Quality and Security / 10.13.2.25981 / 5950215f3a0c4790a0fa13b26d5040f60f3eab2c
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Kotlin Code Quality and Security / 2.20.0.4382 / eb22cc4ed915de84e358135dd3f2ea2080de1441
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy PHP Code Quality and Security / 3.35.0.11659 / d830de9e38c9269851c1afefe12b8324c1481baf
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Python Code Quality and Security / 4.17.0.14845 / 60c11ea38cb028885067563b4ea10f4b031c697a
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Ruby Code Quality and Security / 1.15.0.4655 / 28938525c4093d5e9fa4e858535bbcb60af7f066
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Scala Code Quality and Security / 1.15.0.4655 / 28938525c4093d5e9fa4e858535bbcb60af7f066
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy Text Code Quality and Security / 2.10.0.2188 / null
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy VB.NET Code Quality and Security / 9.23.2.88755 / 7727153bb92db16ac5dedac33bfbbe6bb51e9666
2024.07.03 16:42:34 INFO  web[][o.s.s.p.ServerPluginManager] Deploy XML Code Quality and Security / 2.10.0.4108 / 34b16ba369117f6befc0b1e0866a069a80f6db2e
2024.07.03 16:42:36 INFO  web[][o.s.s.p.d.m.c.PostgresCharsetHandler] Verify that database charset supports UTF8
2024.07.03 16:42:37 INFO  web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [http://localhost:9001]
2024.07.03 16:42:38 WARN  web[][o.s.a.s.w.WebService$Action] Description is not set on action api/monitoring/metrics
2024.07.03 16:42:38 WARN  web[][o.s.a.s.w.WebService$Action] Since is not set on action api/monitoring/metrics
2024.07.03 16:42:38 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/monitoring/metrics
2024.07.03 16:42:38 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/system/liveness
2024.07.03 16:42:38 INFO  web[][o.s.s.p.d.m.AutoDbMigration] Automatically perform DB migration on fresh install
2024.07.03 16:42:38 INFO  web[][DbMigrations] Executing DB migrations...
2024.07.03 16:42:38 INFO  web[][DbMigrations] #1 'Create initial schema'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #1 'Create initial schema': success | time=1766ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #2 'Populate initial schema'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #2 'Populate initial schema': success | time=167ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100000 'Remove orphan rules in Quality Profiles'...
2024.07.03 16:42:40 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100000 'Remove orphan rules in Quality Profiles': success | time=17ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100001 'Drop index 'projects_module_uuid' in the 'Components' table'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100001 'Drop index 'projects_module_uuid' in the 'Components' table': success | time=23ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100002 'Drop column 'module_uuid' in the 'Components' table'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100002 'Drop column 'module_uuid' in the 'Components' table': success | time=25ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100003 'Drop column 'module_uuid_path' in the 'Components' table'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100003 'Drop column 'module_uuid_path' in the 'Components' table': success | time=18ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100004 'Drop column 'b_module_uuid' in the 'Components' table'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100004 'Drop column 'b_module_uuid' in the 'Components' table': success | time=16ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100005 'Drop column 'b_module_uuid_path' in the 'Components' table'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100005 'Drop column 'b_module_uuid_path' in the 'Components' table': success | time=20ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100006 'Drop index 'projects_root_uuid' in the 'Components' table'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100006 'Drop index 'projects_root_uuid' in the 'Components' table': success | time=24ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100007 'Drop column 'root_uuid' in the 'Components' table'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100007 'Drop column 'root_uuid' in the 'Components' table': success | time=25ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100008 'Update value of 'user_local' in the 'users' table'...
2024.07.03 16:42:40 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100008 'Update value of 'user_local' in the 'users' table': success | time=67ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100009 'Make column 'user_local' not nullable in the 'users' table'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100009 'Make column 'user_local' not nullable in the 'users' table': success | time=13ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100010 'Create 'scim_groups' table'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100010 'Create 'scim_groups' table': success | time=33ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100011 'Create unique index on scim_groups.group_uuid'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100011 'Create unique index on scim_groups.group_uuid': success | time=63ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100012 'Log a warning message if 'sonar.scim.enabled' is used'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100012 'Log a warning message if 'sonar.scim.enabled' is used': success | time=12ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100013 'Drop 'sonar.scim.enabled' property'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100013 'Drop 'sonar.scim.enabled' property': success | time=16ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100014 'Drop any SCIM User provisioning, turning all users local'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100014 'Drop any SCIM User provisioning, turning all users local': success | time=10ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100015 'Add ncloc to 'Projects' table'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100015 'Add ncloc to 'Projects' table': success | time=41ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100016 'Populate ncloc in 'Projects' table'...
2024.07.03 16:42:40 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2024.07.03 16:42:40 INFO  web[][DbMigrations] #100016 'Populate ncloc in 'Projects' table': success | time=17ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #101000 'Add 'scm_accounts' table'...
2024.07.03 16:42:40 INFO  web[][DbMigrations] #101000 'Add 'scm_accounts' table': success | time=27ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #101001 'Migrate scm accounts from 'users' to 'scm_accounts' table'...
2024.07.03 16:42:40 INFO  web[][o.s.s.p.d.m.s.MassRowSplitter] 1 rows processed (0 items/sec)
2024.07.03 16:42:40 INFO  web[][DbMigrations] #101001 'Migrate scm accounts from 'users' to 'scm_accounts' table': success | time=74ms
2024.07.03 16:42:40 INFO  web[][DbMigrations] #101002 'Add index on 'scm_accounts.scm_account''...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101002 'Add index on 'scm_accounts.scm_account'': success | time=34ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101003 'Add index on 'users.email''...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101003 'Add index on 'users.email'': success | time=36ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101004 'Drop 'scm_accounts' column in 'users' table'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101004 'Drop 'scm_accounts' column in 'users' table': success | time=17ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101005 'Add column 'is_main' to 'project_branches' table'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101005 'Add column 'is_main' to 'project_branches' table': success | time=25ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101006 'Update value of 'is_main' in 'project_branches' table'...
2024.07.03 16:42:41 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101006 'Update value of 'is_main' in 'project_branches' table': success | time=14ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101007 'Alter column 'is_main' in 'project_branches' table - make it not nullable'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101007 'Alter column 'is_main' in 'project_branches' table - make it not nullable': success | time=38ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101008 'Increase size of 'internal_properties.kee' from 20 to 40 characters'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101008 'Increase size of 'internal_properties.kee' from 20 to 40 characters': success | time=8ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101009 'Create column 'project_uuid' in 'user_tokens'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101009 'Create column 'project_uuid' in 'user_tokens': success | time=25ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101010 'Remove user tokens linked to unexistent project'...
2024.07.03 16:42:41 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101010 'Remove user tokens linked to unexistent project': success | time=21ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101011 'Populate 'project_key' in 'user_tokens''...
2024.07.03 16:42:41 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101011 'Populate 'project_key' in 'user_tokens'': success | time=49ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101012 'Drop column 'project_key' in 'user_tokens'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101012 'Drop column 'project_key' in 'user_tokens': success | time=15ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101013 'Increase size of 'ce_queue.task_type' from 15 to 40 characters'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101013 'Increase size of 'ce_queue.task_type' from 15 to 40 characters': success | time=7ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101014 'Increase size of 'ce_activity.task_type' from 15 to 40 characters'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101014 'Increase size of 'ce_activity.task_type' from 15 to 40 characters': success | time=7ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101015 'Add 'external_groups' table.'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101015 'Add 'external_groups' table.': success | time=58ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101016 'Add index on 'external_groups(external_identity_provider, external_id).'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101016 'Add index on 'external_groups(external_identity_provider, external_id).': success | time=28ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101017 'Add 'code_variants' column in 'issues' table'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101017 'Add 'code_variants' column in 'issues' table': success | time=34ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101018 'Fix different uuids for subportfolios'...
2024.07.03 16:42:41 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101018 'Fix different uuids for subportfolios': success | time=32ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101019 'Add report_schedules table'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101019 'Add report_schedules table': success | time=28ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101020 'Add report_subscriptions table'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101020 'Add report_subscriptions table': success | time=37ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101021 'Add report_schedules unique index'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101021 'Add report_schedules unique index': success | time=29ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101022 'Add report_subscriptions unique index'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101022 'Add report_subscriptions unique index': success | time=28ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101023 'Rename column 'component_uuid' to 'entity_uuid' in the 'properties' table'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101023 'Rename column 'component_uuid' to 'entity_uuid' in the 'properties' table': success | time=48ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101024 'Populate report_schedules table'...
2024.07.03 16:42:41 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101024 'Populate report_schedules table': success | time=11ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101025 'Populate report_subscriptions table'...
2024.07.03 16:42:41 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101025 'Populate report_subscriptions table': success | time=11ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101026 'Remove report properties'...
2024.07.03 16:42:41 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2024.07.03 16:42:41 INFO  web[][DbMigrations] #101026 'Remove report properties': success | time=9ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102000 'Rename 'component_uuid' in 'user_roles' table to 'entity_uuid''...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102000 'Rename 'component_uuid' in 'user_roles' table to 'entity_uuid'': success | time=70ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102001 'Rename 'component_uuid' in 'group_roles' table to 'entity_uuid''...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102001 'Rename 'component_uuid' in 'group_roles' table to 'entity_uuid'': success | time=31ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102002 'Drop index 'group_roles_component_uuid' in 'group_roles''...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102002 'Drop index 'group_roles_component_uuid' in 'group_roles'': success | time=13ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102003 'Create index 'entity_uuid_user_roles' in 'group_roles' table'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102003 'Create index 'entity_uuid_user_roles' in 'group_roles' table': success | time=67ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102004 'Drop index 'user_roles_component_uuid' in 'user_roles' table'...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102004 'Drop index 'user_roles_component_uuid' in 'user_roles' table': success | time=12ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102005 'Create index 'user_roles_entity_uuid' in 'user_roles''...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102005 'Create index 'user_roles_entity_uuid' in 'user_roles'': success | time=28ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102006 'Drop index 'ce_activity_component' in 'ce_activity''...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102006 'Drop index 'ce_activity_component' in 'ce_activity'': success | time=42ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102007 'Rename 'main_component_uuid' in 'ce_activity' table to 'entity_uuid''...
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102007 'Rename 'main_component_uuid' in 'ce_activity' table to 'entity_uuid'': success | time=40ms
2024.07.03 16:42:41 INFO  web[][DbMigrations] #102008 'Create index 'ce_activity_entity_uuid' in 'ce_activity' table''...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102008 'Create index 'ce_activity_entity_uuid' in 'ce_activity' table'': success | time=34ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102009 'Drop index 'ce_queue_main_component' in 'ce_queue' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102009 'Drop index 'ce_queue_main_component' in 'ce_queue' table': success | time=13ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102010 'Rename 'main_component_uuid' in 'ce_queue' table to 'entity_uuid''...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102010 'Rename 'main_component_uuid' in 'ce_queue' table to 'entity_uuid'': success | time=32ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102011 'Create index 'ce_queue_entity_uuid' in 'ce_queue' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102011 'Create index 'ce_queue_entity_uuid' in 'ce_queue' table': success | time=25ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102012 'Drop 'project_mappings' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102012 'Drop 'project_mappings' table': success | time=13ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102013 'Drop index on 'components.main_branch_project_uuid'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102013 'Drop index on 'components.main_branch_project_uuid': success | time=15ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102014 'Drop column 'main_branch_project_uuid' in the components table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102014 'Drop column 'main_branch_project_uuid' in the components table': success | time=20ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102015 'Drop index 'component_uuid' in 'webhook_deliveries' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102015 'Drop index 'component_uuid' in 'webhook_deliveries' table': success | time=14ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102016 'Rename 'component_uuid' in 'webhook_deliveries' table to 'project_uuid''...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102016 'Rename 'component_uuid' in 'webhook_deliveries' table to 'project_uuid'': success | time=34ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102018 'Drop index 'component_uuid' in 'snapshots' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102018 'Drop index 'component_uuid' in 'snapshots' table': success | time=14ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102019 'Rename 'component_uuid' in 'snapshots' table to 'root_component_uuid''...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102019 'Rename 'component_uuid' in 'snapshots' table to 'root_component_uuid'': success | time=34ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102020 'Create index 'snapshots_root_component_uuid' in 'snapshots' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102020 'Create index 'snapshots_root_component_uuid' in 'snapshots' table': success | time=29ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102021 'Create 'purged' column in 'snapshots' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102021 'Create 'purged' column in 'snapshots' table': success | time=23ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102022 'Populate 'purged' column in 'snapshots' table'...
2024.07.03 16:42:42 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102022 'Populate 'purged' column in 'snapshots' table': success | time=21ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102023 'Make 'purged' column not nullable in 'snapshots' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102023 'Make 'purged' column not nullable in 'snapshots' table': success | time=7ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102024 'Drop 'purge_status' column in 'snapshots' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102024 'Drop 'purge_status' column in 'snapshots' table': success | time=17ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102025 'Rename 'build_date' in 'snapshots' table to 'analysis_date'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102025 'Rename 'build_date' in 'snapshots' table to 'analysis_date': success | time=31ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102030 'Create table 'anticipated_transitions''...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102030 'Create table 'anticipated_transitions'': success | time=28ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102031 'Increase size of 'ce_queue.is_last_key' from 55 to 80 characters'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102031 'Increase size of 'ce_queue.is_last_key' from 55 to 80 characters': success | time=7ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102032 'Increase size of 'ce_queue.main_is_last_key' from 55 to 80 characters'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102032 'Increase size of 'ce_queue.main_is_last_key' from 55 to 80 characters': success | time=20ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102033 'Add column 'clean_code_attribute' in 'rules' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102033 'Add column 'clean_code_attribute' in 'rules' table': success | time=23ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102034 'Populate 'clean_code_attribute' column in 'rules' table'...
2024.07.03 16:42:42 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102034 'Populate 'clean_code_attribute' column in 'rules' table': success | time=8ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102036 'Create 'rules_default_impacts' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102036 'Create 'rules_default_impacts' table': success | time=25ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102037 'Create unique constraint index on 'rules_default_impacts' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102037 'Create unique constraint index on 'rules_default_impacts' table': success | time=27ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102038 'Create 'issues_impacts' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102038 'Create 'issues_impacts' table': success | time=29ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102039 'Create unique constraint index on 'issues_impacts' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102039 'Create unique constraint index on 'issues_impacts' table': success | time=28ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102040 'Populate default impacts for existing rules'...
2024.07.03 16:42:42 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102040 'Populate default impacts for existing rules': success | time=13ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102041 'Fix sqale_index metric description in 'metrics' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102041 'Fix sqale_index metric description in 'metrics' table': success | time=11ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102042 'Create table 'github_orgs_groups''...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102042 'Create table 'github_orgs_groups'': success | time=24ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102043 'Create 'previous_non_compliant_value' in 'new_code_periods' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102043 'Create 'previous_non_compliant_value' in 'new_code_periods' table': success | time=31ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102044 'Update column 'value' and populate column 'previous_non_compliant_value' in 'new_code_periods' table'...
2024.07.03 16:42:42 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102044 'Update column 'value' and populate column 'previous_non_compliant_value' in 'new_code_periods' table': success | time=19ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102045 'Alter 'project_uuid' in 'user_dismissed_messages' - make it nullable'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102045 'Alter 'project_uuid' in 'user_dismissed_messages' - make it nullable': success | time=9ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102046 'Create index 'project_branches_project_uuid' in 'project_branches' table'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102046 'Create index 'project_branches_project_uuid' in 'project_branches' table': success | time=25ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102047 'Drop index 'idx_wbhk_dlvrs_wbhk_uuid' in 'webhook_deliveries''...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102047 'Drop index 'idx_wbhk_dlvrs_wbhk_uuid' in 'webhook_deliveries'': success | time=14ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102048 'Create index 'wb_webhook_uuid_created_at' in 'webhook_deliveries''...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102048 'Create index 'wb_webhook_uuid_created_at' in 'webhook_deliveries'': success | time=28ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102049 'Drop index 'wd_project_uuid' in 'webhook_deliveries''...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102049 'Drop index 'wd_project_uuid' in 'webhook_deliveries'': success | time=18ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102050 'Create index 'wd_project_uuid_created_at' in 'webhook_deliveries''...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102050 'Create index 'wd_project_uuid_created_at' in 'webhook_deliveries'': success | time=25ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102051 'Drop index 'ce_task_uuid' in 'webhook_deliveries''...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102051 'Drop index 'ce_task_uuid' in 'webhook_deliveries'': success | time=12ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102052 'Create index 'wd_task_uuid_created_at' in 'webhook_deliveries''...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102052 'Create index 'wd_task_uuid_created_at' in 'webhook_deliveries'': success | time=27ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102053 'Create index 'wd_created_at' in 'webhook_deliveries''...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102053 'Create index 'wd_created_at' in 'webhook_deliveries'': success | time=38ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102054 'Insert property github.userConsentementForPermissionProvisioningRequired'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #102054 'Insert property github.userConsentementForPermissionProvisioningRequired': success | time=12ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #103000 'Set 'sonar.qualityProfiles.allowDisableInheritedRules' to false for upgraded instances'...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #103000 'Set 'sonar.qualityProfiles.allowDisableInheritedRules' to false for upgraded instances': success | time=9ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #103001 'Add table 'github_perms_mapping''...
2024.07.03 16:42:42 INFO  web[][DbMigrations] #103001 'Add table 'github_perms_mapping'': success | time=22ms
2024.07.03 16:42:42 INFO  web[][DbMigrations] #103002 'Create unique index on 'github_perms_mapping''...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103002 'Create unique index on 'github_perms_mapping'': success | time=34ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103003 'Add default mappings to 'github_perms_mapping''...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103003 'Add default mappings to 'github_perms_mapping'': success | time=42ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103004 'Add 'clean_code_attribute' column in 'issues' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103004 'Add 'clean_code_attribute' column in 'issues' table': success | time=23ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103005 'Add 'creation_method' column in 'projects' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103005 'Add 'creation_method' column in 'projects' table': success | time=23ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103006 'Populate 'creation_method' column in 'projects' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103006 'Populate 'creation_method' column in 'projects' table': success | time=9ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103007 'Make 'creation_method' column in 'projects' table non-nullable'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103007 'Make 'creation_method' column in 'projects' table non-nullable': success | time=7ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103008 'Add 'rule_changes_uuid' column in 'qprofile_changes''...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103008 'Add 'rule_changes_uuid' column in 'qprofile_changes'': success | time=22ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103009 'Create table 'rule_changes''...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103009 'Create table 'rule_changes'': success | time=25ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103010 'Create table 'rule_impact_changes''...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103010 'Create table 'rule_impact_changes'': success | time=23ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103011 'Create index for 'rule_impact_changes''...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103011 'Create index for 'rule_impact_changes'': success | time=27ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103012 'Add 'sq_version' column in 'qprofile_changes' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103012 'Add 'sq_version' column in 'qprofile_changes' table': success | time=21ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103013 'Deduplicate potential records in 'properties' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103013 'Deduplicate potential records in 'properties' table': success | time=11ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103014 'Create unique index to 'properties' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #103014 'Create unique index to 'properties' table': success | time=27ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104000 'Delete redundant Failed Alerts for Applications'...
2024.07.03 16:42:43 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104000 'Delete redundant Failed Alerts for Applications': success | time=12ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104001 'Rename metric 'wont_fix_issues' to 'accepted_issues''...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104001 'Rename metric 'wont_fix_issues' to 'accepted_issues'': success | time=8ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104002 'Create table 'rules_tags''...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104002 'Create table 'rules_tags'': success | time=53ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104003 'Populate 'rule_tags' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104003 'Populate 'rule_tags' table': success | time=10ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104004 'Drop column 'tags' in the 'rules' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104004 'Drop column 'tags' in the 'rules' table': success | time=16ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104005 'Drop column 'system_tags' in the 'rules' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104005 'Drop column 'system_tags' in the 'rules' table': success | time=14ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104006 'Add 'uuid' column to 'groups_users''...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104006 'Add 'uuid' column to 'groups_users'': success | time=21ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104007 'Populate 'uuid' column in 'groups_users''...
2024.07.03 16:42:43 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 2 rows processed (0 items/sec)
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104007 'Populate 'uuid' column in 'groups_users'': success | time=16ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104008 'Make 'uuid' column in 'groups_users' table non-nullable'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104008 'Make 'uuid' column in 'groups_users' table non-nullable': success | time=7ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104009 'Create primary key on 'groups_users.uuid''...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104009 'Create primary key on 'groups_users.uuid'': success | time=19ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104010 'Set nulls in 'clean_code_attribute' column of 'rules' table for security hotspots'...
2024.07.03 16:42:43 INFO  web[][o.s.s.p.d.m.s.MassUpdate] 0 rows processed (0 items/sec)
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104010 'Set nulls in 'clean_code_attribute' column of 'rules' table for security hotspots': success | time=13ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104011 'Create 'issues_fixed' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #104011 'Create 'issues_fixed' table': success | time=24ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #105000 'Drop constraint on 'uuid' from 'issues_impacts' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #105000 'Drop constraint on 'uuid' from 'issues_impacts' table': success | time=47ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #105001 'Drop constraint on 'uuid' from 'rules_default_impacts' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #105001 'Drop constraint on 'uuid' from 'rules_default_impacts' table': success | time=32ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #105002 'Drop column 'uuid' from 'issues_impacts' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #105002 'Drop column 'uuid' from 'issues_impacts' table': success | time=14ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #105003 'Drop column 'uuid' from 'rules_default_impacts' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #105003 'Drop column 'uuid' from 'rules_default_impacts' table': success | time=15ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #105004 'Create primary key on 'issues_impacts' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #105004 'Create primary key on 'issues_impacts' table': success | time=18ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #105005 'Create primary key on 'rules_default_impacts' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #105005 'Create primary key on 'rules_default_impacts' table': success | time=13ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] #105006 'Delete 'languageSpecificParameters' property set from 'properties' table'...
2024.07.03 16:42:43 INFO  web[][DbMigrations] #105006 'Delete 'languageSpecificParameters' property set from 'properties' table': success | time=11ms
2024.07.03 16:42:43 INFO  web[][DbMigrations] Executed DB migrations: success | time=5245ms
2024.07.03 16:42:43 INFO  web[][o.s.s.p.Platform] Database has been automatically updated
2024.07.03 16:42:44 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceFilter@1b30a54e [pattern=UrlPattern{inclusions=[/api/system/migrate_db.*, ...], exclusions=[/api/components/update_key, ...]}]
2024.07.03 16:42:44 INFO  web[][o.s.s.p.DetectPluginChange] Detect plugin changes
2024.07.03 16:42:48 INFO  web[][o.h.v.i.util.Version] HV000001: Hibernate Validator null
2024.07.03 16:42:49 INFO  web[][o.s.s.e.IndexCreator] Create index [metadatas]
2024.07.03 16:42:51 INFO  es[][o.e.c.m.MetadataCreateIndexService] [metadatas] creating index, cause [api], templates [], shards [1]/[0]
2024.07.03 16:42:51 INFO  es[][o.e.i.m.MapperService] reloading search analyzers
2024.07.03 16:42:52 INFO  es[][o.e.c.r.a.AllocationService] current.health="GREEN" message="Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[metadatas][0]]])." previous.health="YELLOW" reason="shards started [[metadatas][0]]"
2024.07.03 16:42:52 INFO  web[][o.s.s.e.IndexCreator] Create mapping metadatas
2024.07.03 16:42:52 INFO  es[][o.e.c.m.MetadataMappingService] [metadatas/OGkf7BP5RbOWzVZWJDiL5g] create_mapping
2024.07.03 16:42:53 INFO  web[][o.s.s.e.IndexCreator] Create index [components]
2024.07.03 16:42:53 INFO  es[][o.e.c.m.MetadataCreateIndexService] [components] creating index, cause [api], templates [], shards [5]/[0]
2024.07.03 16:42:54 INFO  es[][o.e.i.m.MapperService] reloading search analyzers
2024.07.03 16:42:54 INFO  es[][o.e.c.r.a.AllocationService] current.health="GREEN" message="Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[components][4]]])." previous.health="YELLOW" reason="shards started [[components][4]]"
2024.07.03 16:42:55 INFO  web[][o.s.s.e.IndexCreator] Create mapping components
2024.07.03 16:42:55 INFO  es[][o.e.c.m.MetadataMappingService] [components/rYZLiVH7RA-Lx3N4bWz9NQ] create_mapping
2024.07.03 16:42:55 INFO  web[][o.s.s.e.IndexCreator] Create index [projectmeasures]
2024.07.03 16:42:55 INFO  es[][o.e.c.m.MetadataCreateIndexService] [projectmeasures] creating index, cause [api], templates [], shards [5]/[0]
2024.07.03 16:42:55 INFO  es[][o.e.i.m.MapperService] reloading search analyzers
2024.07.03 16:42:56 INFO  es[][o.e.c.r.a.AllocationService] current.health="GREEN" message="Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[projectmeasures][4]]])." previous.health="YELLOW" reason="shards started [[projectmeasures][4]]"
2024.07.03 16:42:56 INFO  web[][o.s.s.e.IndexCreator] Create mapping projectmeasures
2024.07.03 16:42:56 INFO  es[][o.e.c.m.MetadataMappingService] [projectmeasures/ttQod7voRdyaf3xKe8fAMA] create_mapping
2024.07.03 16:42:56 INFO  web[][o.s.s.e.IndexCreator] Create index [rules]
2024.07.03 16:42:57 INFO  es[][o.e.c.m.MetadataCreateIndexService] [rules] creating index, cause [api], templates [], shards [2]/[0]
2024.07.03 16:42:57 INFO  es[][o.e.i.m.MapperService] reloading search analyzers
2024.07.03 16:42:57 INFO  es[][o.e.c.r.a.AllocationService] current.health="GREEN" message="Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[rules][0]]])." previous.health="YELLOW" reason="shards started [[rules][0]]"
2024.07.03 16:42:57 INFO  web[][o.s.s.e.IndexCreator] Create mapping rules
2024.07.03 16:42:57 INFO  es[][o.e.c.m.MetadataMappingService] [rules/nPnlG2sLQDKl_GhTM4UwFw] create_mapping
2024.07.03 16:42:57 INFO  web[][o.s.s.e.IndexCreator] Create index [issues]
2024.07.03 16:42:58 INFO  es[][o.e.c.m.MetadataCreateIndexService] [issues] creating index, cause [api], templates [], shards [5]/[0]
2024.07.03 16:42:58 INFO  es[][o.e.i.m.MapperService] reloading search analyzers
2024.07.03 16:42:58 INFO  es[][o.e.c.r.a.AllocationService] current.health="GREEN" message="Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[issues][4]]])." previous.health="YELLOW" reason="shards started [[issues][4]]"
2024.07.03 16:42:58 INFO  web[][o.s.s.e.IndexCreator] Create mapping issues
2024.07.03 16:42:58 INFO  es[][o.e.c.m.MetadataMappingService] [issues/RwjqXKNHTwO4bq3Sv1pb6g] create_mapping
2024.07.03 16:42:59 INFO  web[][o.s.s.e.IndexCreator] Create index [views]
2024.07.03 16:42:59 INFO  es[][o.e.c.m.MetadataCreateIndexService] [views] creating index, cause [api], templates [], shards [5]/[0]
2024.07.03 16:42:59 INFO  es[][o.e.i.m.MapperService] reloading search analyzers
2024.07.03 16:42:59 INFO  es[][o.e.c.r.a.AllocationService] current.health="GREEN" message="Cluster health status changed from [YELLOW] to [GREEN] (reason: [shards started [[views][4]]])." previous.health="YELLOW" reason="shards started [[views][4]]"
2024.07.03 16:42:59 INFO  web[][o.s.s.e.IndexCreator] Create mapping views
2024.07.03 16:42:59 INFO  es[][o.e.c.m.MetadataMappingService] [views/zln9oKygT_CW8xcsskG_Sg] create_mapping
2024.07.03 16:43:00 INFO  web[][o.s.s.s.LogServerId] Server ID: C387ECFC-AZB5eh0JjlB065wHdtBa
2024.07.03 16:43:00 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.
2024.07.03 16:43:00 INFO  web[][o.s.s.p.UpdateCenterClient] Update center: https://downloads.sonarsource.com/sonarqube/update/update-center.properties
2024.07.03 16:43:04 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action saml/validation_init
2024.07.03 16:43:04 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/system/liveness
2024.07.03 16:43:04 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/plugins/download
2024.07.03 16:43:04 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/analysis_cache/get
2024.07.03 16:43:04 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/alm_integrations/check_pat
2024.07.03 16:43:04 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/push/sonarlint_events
2024.07.03 16:43:04 WARN  web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/dismiss_message/check
2024.07.03 16:43:04 INFO  web[][o.s.s.a.p.ExpiredSessionsCleaner] Purge of expired session tokens has removed 0 elements
2024.07.03 16:43:04 INFO  web[][o.s.s.a.p.ExpiredSessionsCleaner] Purge of expired SAML message ids has removed 0 elements
2024.07.03 16:43:04 INFO  web[][o.s.s.n.NotificationDaemon] Notification service started (delay 60 sec.)
2024.07.03 16:43:04 INFO  web[][o.s.s.t.TelemetryDaemon] Sharing of SonarQube statistics is enabled.
2024.07.03 16:43:06 INFO  web[][o.s.s.s.RegisterMetrics] Register metrics
2024.07.03 16:43:06 INFO  web[][o.s.s.q.RegisterQualityGates] Built-in quality gate's conditions of [Sonar way] has been updated
2024.07.03 16:43:06 INFO  web[][o.s.s.r.r.RulesRegistrant] Register rules
2024.07.03 16:44:29 INFO  web[][o.s.s.q.b.BuiltInQProfileRepositoryImpl] Load quality profiles
2024.07.03 16:44:29 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register quality profiles
2024.07.03 16:44:29 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile kubernetes/Sonar way
2024.07.03 16:44:30 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile css/Sonar way
2024.07.03 16:44:30 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile scala/Sonar way
2024.07.03 16:44:30 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile jsp/Sonar way
2024.07.03 16:44:30 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile js/Sonar way
2024.07.03 16:44:31 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile py/Sonar way
2024.07.03 16:44:32 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile docker/Sonar way
2024.07.03 16:44:32 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile java/Sonar way
2024.07.03 16:44:33 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile web/Sonar way
2024.07.03 16:44:34 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile xml/Sonar way
2024.07.03 16:44:34 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile flex/Sonar way
2024.07.03 16:44:35 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile json/Sonar way
2024.07.03 16:44:35 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile text/Sonar way
2024.07.03 16:44:35 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile vbnet/Sonar way
2024.07.03 16:44:37 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile cloudformation/Sonar way
2024.07.03 16:44:37 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile yaml/Sonar way
2024.07.03 16:44:37 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile kotlin/Sonar way
2024.07.03 16:44:38 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile go/Sonar way
2024.07.03 16:44:39 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile secrets/Sonar way
2024.07.03 16:44:40 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile ruby/Sonar way
2024.07.03 16:44:40 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile cs/Sonar way
2024.07.03 16:44:42 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile php/Sonar way
2024.07.03 16:44:43 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile terraform/Sonar way
2024.07.03 16:44:44 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile azureresourcemanager/Sonar way
2024.07.03 16:44:44 INFO  web[][o.s.s.q.RegisterQualityProfiles] Register profile ts/Sonar way
2024.07.03 16:44:46 INFO  web[][o.s.s.s.RegisterPermissionTemplates] Register permission templates
2024.07.03 16:44:46 INFO  web[][o.s.s.s.RenameDeprecatedPropertyKeys] Rename deprecated property keys
2024.07.03 16:44:46 INFO  web[][o.s.s.s.RegisterPlugins] Register plugins
2024.07.03 16:44:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.SonarLintConnectionFilter@35c83cd0 [pattern=UrlPattern{inclusions=[/api/*], exclusions=[/api/v2/*]}]
2024.07.03 16:44:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceFilter@1df140d3 [pattern=UrlPattern{inclusions=[/api/issues/delete_comment.*, ...], exclusions=[/api/authentication/login.*, ...]}]
2024.07.03 16:44:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.platform.web.WebServiceReroutingFilter@79b44739 [pattern=UrlPattern{inclusions=[/api/components/bulk_update_key, ...], exclusions=[]}]
2024.07.03 16:44:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.DefaultAdminCredentialsVerifierFilter@10b14988 [pattern=UrlPattern{inclusions=[/*], exclusions=[*.css, ...]}]
2024.07.03 16:44:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.InitFilter@646bd9f2 [pattern=UrlPattern{inclusions=[/sessions/init/*], exclusions=[]}]
2024.07.03 16:44:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.SamlValidationRedirectionFilter@738bea74 [pattern=UrlPattern{inclusions=[/oauth2/callback/saml], exclusions=[]}]
2024.07.03 16:44:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.OAuth2CallbackFilter@28ddf6b3 [pattern=UrlPattern{inclusions=[/oauth2/callback/*], exclusions=[]}]
2024.07.03 16:44:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ResetPasswordFilter@32ba0729 [pattern=UrlPattern{inclusions=[/*], exclusions=[*.css, ...]}]
2024.07.03 16:44:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.LoginAction@240e0561 [pattern=UrlPattern{inclusions=[/api/authentication/login], exclusions=[]}]
2024.07.03 16:44:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.LogoutAction@66ba9b49 [pattern=UrlPattern{inclusions=[/api/authentication/logout], exclusions=[]}]
2024.07.03 16:44:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.authentication.ws.ValidateAction@608bf998 [pattern=UrlPattern{inclusions=[/api/authentication/validate], exclusions=[]}]
2024.07.03 16:44:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.saml.ws.ValidationInitAction@1332b11d [pattern=UrlPattern{inclusions=[/saml/validation_init], exclusions=[]}]
2024.07.03 16:44:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.saml.ws.ValidationAction@21e000e1 [pattern=UrlPattern{inclusions=[/saml/validation], exclusions=[]}]
2024.07.03 16:44:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.user.ws.ChangePasswordAction@8a4fcc5 [pattern=UrlPattern{inclusions=[/api/users/change_password], exclusions=[]}]
2024.07.03 16:44:47 INFO  web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.plugins.PluginsRiskConsentFilter@24d06fef [pattern=UrlPattern{inclusions=[/*], exclusions=[*.css, ...]}]
2024.07.03 16:44:47 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of type [projectmeasures/auth/projectmeasure]...
2024.07.03 16:44:48 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of type [projectmeasures/auth/projectmeasure] done | time=1002ms
2024.07.03 16:44:48 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of type [components/auth/component]...
2024.07.03 16:44:49 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of type [components/auth/component] done | time=694ms
2024.07.03 16:44:49 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of type [views/view]...
2024.07.03 16:44:49 INFO  es[][o.e.c.s.IndexScopedSettings] updating [index.refresh_interval] from [30s] to [-1]
2024.07.03 16:44:49 INFO  es[][o.e.c.s.IndexScopedSettings] updating [index.refresh_interval] from [30s] to [-1]
2024.07.03 16:44:50 INFO  es[][o.e.c.s.IndexScopedSettings] updating [index.refresh_interval] from [-1] to [30s]
2024.07.03 16:44:50 INFO  es[][o.e.c.s.IndexScopedSettings] updating [index.refresh_interval] from [-1] to [30s]
2024.07.03 16:44:50 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of type [views/view] done | time=1186ms
2024.07.03 16:44:50 INFO  web[][o.s.s.e.IndexerStartupTask] Trigger asynchronous indexing of type [issues/auth/issue]...
2024.07.03 16:44:50 INFO  web[][o.s.s.i.i.AsyncIssueIndexingImpl] 0 pending indexing task found to be deleted...
2024.07.03 16:44:50 INFO  web[][o.s.s.i.i.AsyncIssueIndexingImpl] 0 completed indexing task found to be deleted...
2024.07.03 16:44:50 INFO  web[][o.s.s.i.i.AsyncIssueIndexingImpl] Indexing task deletion complete.
2024.07.03 16:44:50 INFO  web[][o.s.s.i.i.AsyncIssueIndexingImpl] Deleting tasks characteristics...
2024.07.03 16:44:50 INFO  web[][o.s.s.i.i.AsyncIssueIndexingImpl] Tasks characteristics deletion complete.
2024.07.03 16:44:50 INFO  web[][o.s.s.i.i.AsyncIssueIndexingImpl] 0 branch found in need of issue sync.
2024.07.03 16:44:50 INFO  web[][o.s.s.e.IndexerStartupTask] Trigger asynchronous indexing of type [issues/auth/issue] done | time=392ms
2024.07.03 16:44:50 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of types [components/auth],[projectmeasures/auth],[issues/auth]...
2024.07.03 16:44:51 INFO  web[][o.s.s.e.IndexerStartupTask] Indexing of types [components/auth],[projectmeasures/auth],[issues/auth] done | time=816ms
2024.07.03 16:44:51 INFO  web[][o.s.s.p.p.PlatformLevelStartup] Running Community Edition
2024.07.03 16:44:51 INFO  app[][o.s.a.SchedulerImpl] Process[web] is up
2024.07.03 16:44:51 INFO  app[][o.s.a.ProcessLauncherImpl] Launch process[COMPUTE_ENGINE] 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-exports=java.base/jdk.internal.ref=ALL-UNNAMED --add-opens=java.base/java.lang=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 -Dcom.redhat.fips=false -Xmx512m -Xms128m -XX:+HeapDumpOnOutOfMemoryError -Dhttp.nonProxyHosts=localhost|127.*|[::1] -cp ./lib/sonar-application-10.5.1.90531.jar:/opt/sonarqube/lib/jdbc/postgresql/postgresql-42.7.1.jar org.sonar.ce.app.CeServer /opt/sonarqube/temp/sq-process17833056007877635818properties
WARNING: A terminally deprecated method in java.lang.System has been called
WARNING: System::setSecurityManager has been called by org.sonar.process.PluginSecurityManager (file:/opt/sonarqube/lib/sonar-application-10.5.1.90531.jar)
WARNING: Please consider reporting this to the maintainers of org.sonar.process.PluginSecurityManager
WARNING: System::setSecurityManager will be removed in a future release
2024.07.03 16:44:56 INFO  ce[][o.s.p.ProcessEntryPoint] Starting Compute Engine
2024.07.03 16:44:57 INFO  ce[][o.s.ce.app.CeServer] Compute Engine starting up...
2024.07.03 16:44:57 WARN  app[][startup] ####################################################################################################################
2024.07.03 16:44:57 WARN  app[][startup] Default Administrator credentials are still being used. Make sure to change the password or deactivate the account.
2024.07.03 16:44:57 WARN  app[][startup] ####################################################################################################################
2024.07.03 16:44:57 INFO  web[][o.s.s.p.Platform] Web Server is operational
2024.07.03 16:45:00 INFO  ce[][o.s.d.DefaultDatabase] Create JDBC data source for jdbc:postgresql://sonarqube-postgresql:5432/database_name
2024.07.03 16:45:00 INFO  ce[][c.z.h.HikariDataSource] HikariPool-1 - Starting...
2024.07.03 16:45:00 INFO  ce[][c.z.h.p.HikariPool] HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@bee2091
2024.07.03 16:45:00 INFO  ce[][c.z.h.HikariDataSource] HikariPool-1 - Start completed.
2024.07.03 16:45:06 ERROR web[0fe37b40-ec94-457b-9902-d906c654db07][o.s.s.w.WebServiceEngine] Fail to process request http://localhost:9000/api/system/liveness
java.lang.IllegalStateException: Liveness check failed
	at org.sonar.server.platform.ws.LivenessActionSupport.checkliveness(LivenessActionSupport.java:56)
	at org.sonar.server.platform.ws.LivenessAction.handle(LivenessAction.java:51)
	at org.sonar.server.ws.WebServiceEngine.execute(WebServiceEngine.java:114)
	at org.sonar.server.platform.web.WebServiceFilter.doFilter(WebServiceFilter.java:84)
	at org.sonar.server.platform.web.MasterServletFilter$JavaxFilterAdapter.doFilter(MasterServletFilter.java:227)
	at org.sonar.server.platform.web.MasterServletFilter$GodFilterChain.doFilter(MasterServletFilter.java:198)
	at org.sonar.server.platform.web.MasterServletFilter$HttpFilterChainAdapter.doFilter(MasterServletFilter.java:241)
	at org.sonar.server.platform.web.SonarLintConnectionFilter.doFilter(SonarLintConnectionFilter.java:66)
	at org.sonar.server.platform.web.MasterServletFilter$JavaxFilterAdapter.doFilter(MasterServletFilter.java:227)
	at org.sonar.server.platform.web.MasterServletFilter$GodFilterChain.doFilter(MasterServletFilter.java:198)
	at org.sonar.server.platform.web.MasterServletFilter.doFilter(MasterServletFilter.java:146)
	at jdk.internal.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:222)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at java.base/javax.security.auth.Subject.doAsPrivileged(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:250)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:177)
	at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:138)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:137)
	at org.sonar.server.platform.web.UserSessionFilter.doFilter(UserSessionFilter.java:83)
	at org.sonar.server.platform.web.UserSessionFilter.doFilter(UserSessionFilter.java:70)
	at jdk.internal.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:222)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at java.base/javax.security.auth.Subject.doAsPrivileged(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:250)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:177)
	at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:138)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:137)
	at org.sonar.server.platform.web.CrossOriginFilter.doFilter(CrossOriginFilter.java:51)
	at jdk.internal.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:222)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at java.base/javax.security.auth.Subject.doAsPrivileged(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:250)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:177)
	at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:138)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:137)
	at org.sonar.server.platform.web.CspFilter.doFilter(CspFilter.java:63)
	at jdk.internal.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:222)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at java.base/javax.security.auth.Subject.doAsPrivileged(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:250)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:177)
	at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:138)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:137)
	at org.sonar.server.platform.web.CacheControlFilter.doFilter(CacheControlFilter.java:76)
	at jdk.internal.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:222)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at java.base/javax.security.auth.Subject.doAsPrivileged(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:250)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:177)
	at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:138)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:137)
	at org.sonar.server.platform.web.SecurityServletFilter.doHttpFilter(SecurityServletFilter.java:60)
	at org.sonar.server.platform.web.SecurityServletFilter.doFilter(SecurityServletFilter.java:47)
	at jdk.internal.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:222)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at java.base/javax.security.auth.Subject.doAsPrivileged(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:250)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:177)
	at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:138)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:137)
	at org.sonar.server.platform.web.RedirectFilter.doFilter(RedirectFilter.java:56)
	at jdk.internal.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:222)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at java.base/javax.security.auth.Subject.doAsPrivileged(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:250)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:177)
	at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:138)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:137)
	at org.sonar.server.platform.web.EndpointPathFilter.doFilter(EndpointPathFilter.java:47)
	at jdk.internal.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:222)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at java.base/javax.security.auth.Subject.doAsPrivileged(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:250)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:177)
	at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:138)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:137)
	at org.sonar.server.platform.web.RequestIdFilter.doFilter(RequestIdFilter.java:66)
	at jdk.internal.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:222)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at java.base/javax.security.auth.Subject.doAsPrivileged(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:250)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:177)
	at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:138)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:137)
	at org.sonar.server.platform.web.RootFilter.doFilter(RootFilter.java:65)
	at jdk.internal.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:222)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at java.base/javax.security.auth.Subject.doAsPrivileged(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:250)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:177)
	at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:138)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:137)
	at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:115)
	at jdk.internal.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:222)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at java.base/javax.security.auth.Subject.doAsPrivileged(Unknown Source)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:250)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:177)
	at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:138)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:137)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at ch.qos.logback.access.tomcat.LogbackValve.invoke(LogbackValve.java:267)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1786)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
	at java.base/java.lang.Thread.run(Unknown Source)
2024.07.03 16:45:07 INFO  ce[][o.s.s.p.ServerFileSystemImpl] SonarQube home: /opt/sonarqube
2024.07.03 16:45:08 INFO  ce[][o.s.c.c.CePluginRepository] Load plugins
2024.07.03 16:45:13 INFO  ce[][o.s.c.c.ComputeEngineContainerImpl] Running Community edition
2024.07.03 16:45:13 INFO  ce[][o.s.ce.app.CeServer] Compute Engine is started
2024.07.03 16:45:14 INFO  app[][o.s.a.SchedulerImpl] Process[ce] is up
2024.07.03 16:45:14 INFO  app[][o.s.a.SchedulerImpl] SonarQube is operational
2024.07.03 16:45:44 INFO  web[00f5600a-cf0c-4dbb-87a8-55680155cee0][o.s.u.c.UpdateCenter] The plugin 'cayc' version : 2.3.0.1782 has not been found on the update center.
2024.07.03 16:45:44 INFO  web[00f5600a-cf0c-4dbb-87a8-55680155cee0][o.s.u.c.UpdateCenter] The plugin 'csharp' version : 9.23.2.88755 has not been found on the update center.
2024.07.03 16:45:44 INFO  web[00f5600a-cf0c-4dbb-87a8-55680155cee0][o.s.u.c.UpdateCenter] The plugin 'flex' version : 2.12.0.4568 has not been found on the update center.
2024.07.03 16:45:44 INFO  web[00f5600a-cf0c-4dbb-87a8-55680155cee0][o.s.u.c.UpdateCenter] The plugin 'go' version : 1.15.0.4655 has not been found on the update center.
2024.07.03 16:45:44 INFO  web[00f5600a-cf0c-4dbb-87a8-55680155cee0][o.s.u.c.UpdateCenter] The plugin 'iac' version : 1.27.0.9518 has not been found on the update center.
2024.07.03 16:45:44 INFO  web[00f5600a-cf0c-4dbb-87a8-55680155cee0][o.s.u.c.UpdateCenter] The plugin 'jacoco' version : 1.3.0.1538 has not been found on the update center.
2024.07.03 16:45:44 INFO  web[00f5600a-cf0c-4dbb-87a8-55680155cee0][o.s.u.c.UpdateCenter] The plugin 'java' version : 7.33.0.35775 has not been found on the update center.
2024.07.03 16:45:44 INFO  web[00f5600a-cf0c-4dbb-87a8-55680155cee0][o.s.u.c.UpdateCenter] The plugin 'javascript' version : 10.13.2.25981 has not been found on the update center.
2024.07.03 16:45:44 INFO  web[00f5600a-cf0c-4dbb-87a8-55680155cee0][o.s.u.c.UpdateCenter] The plugin 'kotlin' version : 2.20.0.4382 has not been found on the update center.
2024.07.03 16:45:44 INFO  web[00f5600a-cf0c-4dbb-87a8-55680155cee0][o.s.u.c.UpdateCenter] The plugin 'php' version : 3.35.0.11659 has not been found on the update center.
2024.07.03 16:45:44 INFO  web[00f5600a-cf0c-4dbb-87a8-55680155cee0][o.s.u.c.UpdateCenter] The plugin 'python' version : 4.17.0.14845 has not been found on the update center.
2024.07.03 16:45:44 INFO  web[00f5600a-cf0c-4dbb-87a8-55680155cee0][o.s.u.c.UpdateCenter] The plugin 'ruby' version : 1.15.0.4655 has not been found on the update center.
2024.07.03 16:45:44 INFO  web[00f5600a-cf0c-4dbb-87a8-55680155cee0][o.s.u.c.UpdateCenter] The plugin 'sonarscala' version : 1.15.0.4655 has not been found on the update center.
2024.07.03 16:45:44 INFO  web[00f5600a-cf0c-4dbb-87a8-55680155cee0][o.s.u.c.UpdateCenter] The plugin 'text' version : 2.10.0.2188 has not been found on the update center.
2024.07.03 16:45:44 INFO  web[00f5600a-cf0c-4dbb-87a8-55680155cee0][o.s.u.c.UpdateCenter] The plugin 'vbnet' version : 9.23.2.88755 has not been found on the update center.
2024.07.03 16:45:44 INFO  web[00f5600a-cf0c-4dbb-87a8-55680155cee0][o.s.u.c.UpdateCenter] The plugin 'web' version : 3.15.0.5107 has not been found on the update center.

Colin · August 2, 2024, 3:04pm

Hey @sriram

Sorry for the very late reply.

Your logs, to me, look like a completely new database schema was created.

Is your old data sitting around somewhere at jdbc:postgresql://sonarqube-postgresql:5432/database_name? Possibly in a different schema, or belonging to a different user?

sriram · August 2, 2024, 3:20pm

hi @Colin yes I had my old external database as you mentioned.
i did update my values to point external JDBC and disable self hosted postgres in K8s and my application is working now.

For say i have Postgres enabled which will deploy an instance of rds within the K8s
how can we migrate the schemas from external Database into the posgres within the kubernetes.
do we have any documentation covering the steps.
please let me know
thanks

Colin · August 9, 2024, 11:51am

I’m sorry, but managing the database-side of things (especially migrating data) is out of my depths and probably the depths of this community.