Hi,
- We had upgraded SonarQube version from 8.9 LTS to 9.9 LTS, still it is throwing same error as invalid azure URL or personal access token, attaching Trace logs, please find it below.
- Created SonarQube service end point on azure DevOps to configure the Prepare analysis SonarQube task, this task is identifying SonarQube Server IP address and Port number in build pipeline. Attaching Prepare Analysis task Log.
- Can you guide me to use any other authentication method instead of PAT to integration between sonar and Azure Devops?
Could you please help me on this.
Thanks.,
##[debug]Agent.ProxyUrl=undefined
##[debug]Agent.CAInfo=undefined
##[debug]Agent.ClientCert=undefined
##[debug]Agent.SkipCertValidation=undefined
##[debug]SonarQube=150f9856-763c-4bed-99c5-1442595b4bb9
##[debug]150f9856-763c-4bed-99c5-1442595b4bb9=http://Servername:9000/
##[debug]150f9856-763c-4bed-99c5-1442595b4bb9 auth param apitoken = undefined
##[debug]150f9856-763c-4bed-99c5-1442595b4bb9 auth param username = ***
##[debug]150f9856-763c-4bed-99c5-1442595b4bb9 auth param password = undefined
##[debug]organization=undefined
##[debug]scannerMode=Other
##[debug][SQ] API GET: '/api/server/version' with query "undefined"
##[debug][SQ] API GET '/api/server/version' failed, error was: {"errno":"ETIMEDOUT","code":"ETIMEDOUT","syscall":"connect","address":"<SonarQube serverIp>","port":9000}
##[debug]task result: Failed
##[error][SQ] API GET '/api/server/version' failed, error was: {"errno":"ETIMEDOUT","code":"ETIMEDOUT","syscall":"connect","address":"<SonarQube serverIp>","port":9000}
INFO web[AYZUCIDyFPLx75neAAFS][o.s.s.l.ServerLogging] Level of logs changed to INFO
ERROR web[][o.s.a.c.a.AzureDevOpsHttpClient] Unable to contact Azure DevOps server for request [https://ServerName/DefaultCollection/_apis/projects?api-version=3.0]: [PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target]
INFO web[AYZUCIDyFPLx75neAAFU][o.s.s.l.ServerLogging] Level of logs changed to TRACE
TRACE web[][o.s.c.p.PriorityBeanFactory] Returning cached instance of singleton bean 'jdk.internal.loader.ClassLoaders$AppClassLoader@659e0bfd-org.sonar.server.platform.web.requestid.RequestIdGeneratorImpl'
TRACE web[AYZUCIDyFPLx75neAAFV][o.s.c.p.PriorityBeanFactory] Returning cached instance of singleton bean 'jdk.internal.loader.ClassLoaders$AppClassLoader@659e0bfd-org.sonar.db.DBSessionsImpl'
TRACE web[AYZUCIDyFPLx75neAAFV][o.s.c.p.PriorityBeanFactory] Returning cached instance of singleton bean 'jdk.internal.loader.ClassLoaders$AppClassLoader@659e0bfd-org.sonar.server.setting.ThreadLocalSettings'
TRACE web[AYZUCIDyFPLx75neAAFV][o.s.c.p.PriorityBeanFactory] Returning cached instance of singleton bean 'jdk.internal.loader.ClassLoaders$AppClassLoader@659e0bfd-org.sonar.server.authentication.UserSessionInitializer'
TRACE web[AYZUCIDyFPLx75neAAFV][o.s.s.p.w.UserSessionFilter] Thread[http-nio-0.0.0.0-9000-exec-6,5,main] serves /api/system/info
TRACE web[AYZUCIDyFPLx75neAAFV][sql] time=1ms | sql=select st.uuid as uuid, st.user_uuid as "userUuid", st.expiration_date as "expirationDate", st.created_at as "createdAt", st.updated_at as "updatedAt" from session_tokens st where st.uuid=? | params=AYZUCShkswD3vT-QxwG7
TRACE web[AYZUCIDyFPLx75neAAFV][sql] time=0ms | sql=SELECT u.uuid as uuid, u.login as login, u.name as name, u.email as email, u.active as "active", u.scm_accounts as "scmAccounts", u.salt as "salt", u.crypted_password as "cryptedPassword", u.hash_method as "hashMethod", u.external_id as "externalId", u.external_login as "externalLogin", u.external_identity_provider as "externalIdentityProvider", u.user_local as "local", u.reset_password as "resetPassword", u.homepage_type as "homepageType", u.homepage_parameter as "homepageParameter", u.last_connection_date as "lastConnectionDate", u.last_sonarlint_connection as "lastSonarlintConnectionDate", u.created_at as "createdAt", u.updated_at as "updatedAt" FROM users u WHERE u.uuid=? | params=AYZUB5vnswD3vT-QxmNZ
TRACE web[AYZUCIDyFPLx75neAAFV][sql] time=0ms | sql=select 1
TRACE web[AYZUCIDyFPLx75neAAFV][tracer] curl -iX GET 'http://127.0.0.1:9001/_cluster/health?master_timeout=30s&level=cluster&timeout=30s'\n# HTTP/1.1 200 OK\n# X-elastic-product: Elasticsearch\n# content-type: application/json; charset=UTF-8\n# content-length: 387\n#\n#
TRACE web[AYZUCIDyFPLx75neAAFV][tracer] curl -iX GET 'http://127.0.0.1:9001/_cluster/health?master_timeout=30s&level=cluster&timeout=30s'\n# HTTP/1.1 200 OK\n# X-elastic-product: Elasticsearch\n# content-type: application/json; charset=UTF-8\n# content-length: 387\n#\n# {"cluster_name":"sonarqube","status":"green","timed_out":false,"number_of_nodes":1,"number_of_data_nodes":1,"active_primary_shards":24,"active_shards":24,"relocating_shards":0,"initializing_shards":0,"unassigned_shards":0,"delayed_unassigned_shards":0,"number_of_pending_tasks":0,"number_of_in_flight_fetch":0,"task_max_waiting_in_queue_millis":0,"active_shards_percent_as_number":100.0}
TRACE web[AYZUCIDyFPLx75neAAFV][es] ES cluster health request | time=2ms
TRACE web[AYZUCIDyFPLx75neAAFV][tracer] curl -iX GET 'http://127.0.0.1:9001/_stats?level=shards'\n# HTTP/1.1 200 OK\n# X-elastic-product: Elasticsearch\n# content-type: application/json; charset=UTF-8\n# content-length: 107673\n#\n# {"_shards":{"total":24,"successful":24,"failed":0},"_all":{"primaries":{"docs":{"count":9673,"deleted":10},"shard_stats":{"total_count":24},"store":{"size_in_bytes":11141674,"total_data_set_size_in_bytes":11141674,"reserved_in_bytes":0},"indexing":{"index_total":9689,"index_time_in_millis":4547,"index_current":0,"index_failed":0,"delete_total":5,"delete_time_in_millis":13,"delete_current":0,"noop_update_total":0,"is_throttled":false,"throttle_time_in_millis":0},"get":{"total":11,"time_in_millis":65,"exists_total":10,"exists_time_in_millis":58,"missing_total":1,"missing_time_in_millis":7,"current":0},"search":{"open_contexts":0,"query_total":77,"query_time_in_millis":525,"query_current":0,"fetch_total":15,"fetch_time_in_millis":19,"fetch_current":0,"scroll_total":2,"scroll_time_in_millis":35,"scroll_current":0,"suggest_total":0,"suggest_time_in_millis":0,"suggest_current":0},"merges":{"current":0,"current_docs":0,"current_size_in_bytes":0,"total":6,"total_time_in_millis":1175,"total_docs":2463,"total_size_in_bytes":648767,"total_stopped_time_in_millis":0,"total_throttled_time_in_millis":0,"total_auto_throttle_in_bytes":503316480},"refresh":{"total":244,"total_time_in_millis":14513,"external_total":233,"external_total_time_in_millis":15127,"listeners":0},"flush":{"total":30,"periodic":0,"total_time_in_millis":544},"warmer":{"current":0,"total":114,"total_time_in_millis":544},"query_cache":{"memory_size_in_bytes":0,"total_count":0,"hit_count":0,"miss_count":0,"cache_size":0,"cache_count":0,"evictions":0},"fielddata":{"memory_size_in_bytes":4700,"evictions":0},"completion":{"size_in_bytes":0},"segments":{"count":27,"memory_in_bytes":60404,"terms_memory_in_bytes":42720,"stored_fields_memory_in_bytes":13336,"term_vectors_memory_in_bytes":488,"norms_memory_in_bytes":320,"points_memory_in_bytes":0,"doc_values_memory_in_bytes":3540,"index_writer_memory_in_bytes":0,"version_map_memory_in_bytes":0,"fixed_bit_set_memory_in_bytes":192,"max_unsafe_auto_id_timestamp":-1,"file_sizes":{}},"translog":{"operations":0,"size_in_bytes":1320,"uncommitted_operations":0,"uncommitted_size_in_bytes":1320,"earliest_last_modified_age":4321538},"request_cache":{"memory_size_in_bytes":0,"evictions":0,"hit_count":0,"miss_count":0},"recovery":{"current_as_source":0,"current_as_target":0,"throttle_time_in_millis":0}},"total":{"docs":{"count":9673,"deleted":10},"shard_stats":{"total_count":24},"store":{"size_in_bytes":11141674,"total_data_set_size_in_bytes":11141674,"reserved_in_bytes":0},"indexing":{"index_total":9689,"index_time_in_millis":4547,"index_current":0,"index_failed":0,"delete_total":5,"delete_time_in_millis":13,"delete_current":0,"noop_update_total":0,"is_throttled":false,"throttle_time_in_millis":0},"get":{"total":11,"time_in_millis":65,"exists_total":10,"exists_time_in_millis":58,"missing_total":1,"missing_time_in_millis":7,"current":0},"search":{"open_contexts":0,"query_total":77,"query_time_in_millis":525,"query_current":0,"fetch_total":15,"fetch_time_in_millis":19,"fetch_current":0,"scroll_total":2,"scroll_time_in_millis":35,"scroll_current":0,"suggest_total":0,"suggest_time_in_millis":0,"suggest_current":0},"merges":{"current":0,"current_docs":0,"current_size_in_bytes":0,"total":6,"total_time_in_millis":1175,"total_docs":2463,"total_size_in_bytes":648767,"total_stopped_time_in_millis":0,"total_throttled_time_in_millis":0,"total_auto_throttle_in_bytes":503316480},"refresh":{"total":244,"total_time_in_millis":14513,"external_total":233,"external_total_time_in_millis":15127,"listeners":0},"flush":{"total":30,"periodic":0,"total_time_in_millis":544},"warmer":{"current":0,"total":114,"total_time_in_millis":544},"query_cache":{"memory_size_in_bytes":0,"total_count":0,"hit_count":0,"miss_count":0,"cache_size":0,"cache_count":0,"evictions":0},"fielddata":{"memory_size_in_bytes":4700,"evictions":0},"completion":{"size_in_bytes":0},"segments":{"count":27,"memory_in_bytes":60404,"terms_memory_in_bytes":42720,"stored_fields_memory_in_bytes":13336,"term_vectors_memory_in_bytes":488,"norms_memory_in_bytes":320,"points_memory_in_bytes":0,"doc_values_memory_in_bytes":3540,"index_writer_memory_in_bytes":0,"version_map_memory_in_bytes":0,"fixed_bit_set_memory_in_bytes":192,"max_unsafe_auto_id_timestamp":-1,"file_sizes":{}},"translog":{"operations":0,"size_in_bytes":1320,"uncommitted_operations":0,"uncommitted_size_in_bytes":1320,"earliest_last_modified_age":4321538},"request_cache":{"memory_size_in_bytes":0,"evictions":0,"hit_count":0,"miss_count":0},"recovery":{"current_as_source":0,"current_as_target":0,"throttle_time_in_millis":0}}},"indices":{"components":{"uuid":"AMek0yGcRcq1MZpqsuTKQw","primaries":{"docs":{"count":2,"deleted":0},"shard_stats":{"total_count":5},"store":{"size_in_bytes":21377,"total_data_set_size_in_bytes":21377,"reserved_in_bytes":0},"indexing":{"index_total":4,"index_time_in_millis":17,"index_current":0,"index_failed":0,"delete_total":2,"delete_time_in_millis":9,"delete_current":0,"noop_update_total":0,"is_throttled":false,"throttle_time_in_millis":0},"get":{"total":0,"time_in_millis":0,"exists_total":0,"exists_time_in_millis":0,"missing_total":0,"missing_time_in_millis":0,"current":0},"search":{"open_contexts":0,"query_total":3,"query_time_in_millis":5,"query_current":0,"fetch_total":3,"fetch_time_in_millis":0,"fetch_current":0,"scroll_total":1,"scroll_time_in_millis":29,"scroll_current":0,"suggest_total":0,"suggest_time_in_millis":0,"suggest_current":0},"merges":{"current":0,"current_docs":0,"current_size_in_bytes":0,"total":0,"total_time_in_millis":0,"total_docs":0,"total_size_in_bytes":0,"total_stopped_time_in_millis":0,"total_throttled_time_in_millis":0,"total_auto_throttle_in_bytes":104857600},"refresh":{"total":52,"total_time_in_millis":704,"external_total":50,"external_total_time_in_millis":708,"listeners":0},"flush":{"total":7,"periodic":0,"total_time_in_millis":115},"warmer":{"current":0,"total":11,"total_time_in_millis":2},"query_cache":{"memory_size_in_bytes":0,"total_count":0,"hit_count":0,"miss_count":0,"cache_size":0,"cache_count":0,"evictions":0},"fielddata":{"memory_size_in_bytes":168,"evictions":0},"completion":{"size_in_bytes":0},"segments":{"count":4,"memory_in_bytes":8664,"terms_memory_in_bytes":5856,"stored_fields_memory_in_bytes":1952,"term_vectors_memory_in_bytes":488,"norms_memory_in_bytes":64,"points_memory_in_bytes":0,"doc_values_memory_in_bytes":304,"index_writer_memory_in_bytes":0,"version_map_memory_in_bytes":0,"fixed_bit_set_memory_in_bytes":0,"max_unsafe_auto_id_timestamp":-1,"file_sizes":{}},"translog":{"operations":0,"size_in_bytes":275,"uncommitted_operations":0,"uncommitted_size_in_bytes":275,"earliest_last_modified_age":4321541},"request_cache":{"memory_size_in_bytes":0,"evictions":0,"hit_count":0,"miss_count":0},"recovery":{"current_as_source":0,"current_as_target":0,"throttle_time_in_millis":0}},"total":{"docs":{"count":2,"deleted":0},"shard_stats":{"total_count":5},"store":{"size_in_bytes":21377,"total_data_set_size_in_bytes":21377,"reserved_in_bytes":0},"indexing":{"index_total":4,"index_time_in_millis":17,"index_current":0,"index_failed":0,"delete_total":2,"delete_time_in_millis":9,"delete_current":0,"noop_update_total":0,"is_throttled":false,"throttle_time_in_millis":0},"get":{"total":0,"time_in_millis":0,"exists_total":0,"exists_time_in_millis":0,"missing_total":0,"missing_time_in_millis":0,"current":0},"search":{"open_contexts":0,"query_total":3,"query_time_in_millis":5,"query_current":0,"fetch_total":3,"fetch_time_in_millis":0,"fetch_current":0,"scroll_total":1,"scroll_time_in_millis":29,"scroll_current":0,"suggest_total":0,"suggest_time_in_millis":0,"suggest_current":0},"merges":{"current":0,"current_docs":0,"current_size_in_bytes":0,"total":0,"total_time_in_millis":0,"total_docs":0,"total_size_in_bytes":0,"total_stopped_time_in_millis":0,"total_throttled_time_in_millis":0,"total_auto_throttle_in_bytes":104857600},"refresh":{"total":52,"total_time_in_millis":704,"external_total":50,"external_total_time_in_millis":708,"listeners":0},"flush":{"total":7,"periodic":0,"total_time_in_millis":115},"warmer":{"current":0,"total":11,"total_time_in_millis":2},"query_cache":{"memory_size_in_bytes":0,"total_count":0,"hit_count":0,"miss_count":0,"cache_size":0,"cache_count":0,"evictions":0},"fielddata":{"memory_size_in_bytes":168,"evictions":0},"completion":{"size_in_bytes":0},"segments":{"count":4,"memory_in_bytes":8664,"terms_memory_in_bytes":5856,"stored_fields_memory_in_bytes":1952,"term_vectors_memory_in_bytes":488,"norms_memory_in_bytes":64,"points_memory_in_bytes":0,"doc_values_memory_in_bytes":304,"index_writer_memory_in_bytes":0,"version_map_memory_in_bytes":0,"fixed_bit_set_memory_in_bytes":0,"max_unsafe_auto_id_timestamp":-1,"file_sizes":{}},"translog":{"operations":0,"size_in_bytes":275,"uncommitted_operations":0,"uncommitted_size_in_bytes":275,"earliest_last_modified_age":4321541},"request_cache":{"memory_size_in_bytes":0,"evictions":0,"hit_count":0,"miss_count":0},"recovery":{"current_as_source":0,"current_as_target":0,"throttle_time_in_millis":0}},"shards":{"0":[{"routing":{"state":"STARTED","primary":true,"node":"fPTWQDm9T1KJbiWPw-KeJg","relocating_node":null},"docs":{"count":2,"deleted":0},"shard_stats":{"total_count":1},"store":{"size_in_bytes":20473,"total_data_set_size_in_bytes":20473,"reserved_in_bytes":0},"indexing":{"index_total":4,"index_time_in_millis":17,"index_current":0,"index_failed":0,"delete_total":2,"delete_time_in_millis":9,"delete_current":0,"noop_update_total":0,"is_throttled":false,"throttle_time_in_millis":0},"get":{"total":0,"time_in_millis":0,"exists_total":0,"exists_time_in_millis":0,"missing_total":0,"missing_time_in_millis":0,"current":0},"search":{"open_contexts":0,"query_total":3,"query_time_in_millis":5,"query_current":0,"fetch_total":3,"fetch_time_in_millis":0,"fetch_current":0,"scroll_total":1,"scroll_time_in_millis":29,"scroll_current":0,"suggest_total":0,"suggest_time_in_millis":0,"suggest_current":0},"merges":{"current":0,"current_docs":0,"current_size_in_bytes":0,"total":0,"total_time_in_millis":0,"total_docs":0,"total_size_in_bytes":0,"total_stopped_time_in_millis":0,"total_throttled_time_in_millis":0,"total_auto_throttle_in_bytes":20971520},"refresh":{"total":12,"total_time_in_millis":704,"external_total":10,"external_total_time_in_millis":708,"listeners":0},"flush":{"total":3,"periodic":0,"total_time_in_millis":115},"warmer":{"current":0,"total":7,"total_time_in_millis":2},"query_cache":{"memory_size_in_bytes":0,"total_count":0,"hit_count":0,"miss_count":0,"cache_size":0,"cache_count":0,"evictions":0},"fielddata":{"memory_size_in_bytes":168,"evictions":0},"completion":{"size_in_bytes":0},"segments":{"count":4,"memory_in_bytes":8664,"terms_memory_in_bytes":5856,"stored_fields_memory_in_bytes":1952,"term_vectors_memory_in_bytes":488,"norms_memory_in_bytes":64,"points_memory_in_bytes":0,"doc_values_memory_in_bytes":304,"index_writer_memory_in_bytes":0,"version_map_memory_in_bytes":0,"fixed_bit_set_memory_in_bytes":0,"max_unsafe_auto_id_timestamp":-1,"file_sizes":{}},"translog":{"operations":0,"size_in_bytes":55,"uncommitted_operations":0,"uncommitted_size_in_bytes":55,"earliest_last_modified_age":4321541},"request_cache":{"memory_size_in_bytes":0,"evictions":0,"hit_count":0,"miss_count":0},"recovery":{"current_as_source":0,"current_as_target":0,"throttle_time_in_millis":0},"commit":{"id":"UnyylzqBmDeNMxcsLMytpw==","generation":4,"user_data":{"local_checkpoint":"5","max_unsafe_auto_id_timestamp":"-1","min_retained_seq_no":"2","translog_uuid":"mGeRhVFPQBWjQGEA5EPNKQ","es_version":"7.17.8","history_uuid":"BNnZyjSSSo-A9Z8W8TW4cQ","max_seq_no":"5"},"num_docs":2},"seq_no":{"max_seq_no":5,"local_checkpoint":5,"global_checkpoint":5},"retention_leases":{"primary_term":1,"version":4,"leases":[{"id":"peer_recovery/fPTWQDm9T1KJbiWPw-KeJg","retaining_seq_no":6,"timestamp":1676447879584,"source":"peer recovery"}]},"shard_path":{"state_path":"D:\\SonarQube\\sonarqube-9.9.0.65466\\data\\es7\\nodes\\0","data_path":"D:\\SonarQube\\sonarqube-9.9.0.65466\\data\\es7\\nodes\\0","is_custom_data_path":false}}],"1":[{"routing":{"state":"STARTED","primary":true,"node":"fPTWQDm9T1KJbiWPw-KeJg","relocating_node":null},"docs":{"count":0,"deleted":0},"shard_stats":{"total_count":1},"store":{"size_in_bytes":226,"total_data_set_size_in_bytes":226,"reserved_in_bytes":0},"indexing":{"index_total":0,"index_time_in_millis":0,"index_current":0,"index_failed":0,"delete_total":0,"delete_time_in_millis":0,"delete_current":0,"noop_update_total":0,"is_throttled":false,"throttle_time_in_millis":0},"get":{"total":0,"time_in_millis":0,"exists_total":0,"exists_time_in_millis":0,"missing_total":0,"missing_time_in_millis":0,"current":0},"search":{"open_contexts":0,"query_total":0,"query_time_in_millis":0,"query_current":0,"fetch_total":0,"fetch_time_in_millis":0,"fetch_current":0,"scroll_total":0,"scroll_time_in_millis":0,"scroll_current":0,"suggest_total":0,"suggest_time_in_millis":0,"suggest_current":0},"merges":{"current":0,"current_docs":0,"current_size_in_bytes":0,"total":0,"total_time_in_millis":0,"total_docs":0,"total_size_in_bytes":0,"total_stopped_time_in_millis":0,"total_throttled_time_in_millis":0,"total_auto_throttle_in_bytes":20971520},"refresh":{"total":10,"total_time_in_millis":0,"external_total":10,"external_total_time_in_millis":0,"listeners":0},"flush":{"total":1,"periodic":0,"total_time_in_millis":0},"warmer":{"current":0,"total":1,"total_time_in_millis":0},"query_cache":{"memory_size_in_bytes":0,"total_count":0,"hit_count":0,"miss_count":0,"cache_size":0,"cache_count":0,"evictions":0},"fielddata":{"memory_size_in_bytes":0,"evictions":0},"completion":{"size_in_bytes":0},"segments":{"count":0,"memory_in_bytes":0,"terms_memory_in_bytes":0,"stored_fields_memory_in_bytes":0,"term_vectors_memory_in_bytes":0,"norms_memory_in_bytes":0,"points_memory_in_bytes":0,"doc_values_memory_in_bytes":0,"index_writer_memory_in_bytes":0,"version_map_memory_in_bytes":0,"fixed_bit_set_memory_in_bytes":0,"max_unsafe_auto_id_timestamp":-1,"file_sizes":{}},"translog":{"operations":0,"size_in_bytes":55,"uncommitted_operations":0,"uncommitted_size_in_bytes":55,"earliest_last_modified_age":5441047},"request_cache":{"memory_size_in_bytes":0,"evictions":0,"hit_count":0,"miss_count":0},"recovery":{"current_as_source":0,"current_as_target":0,"throttle_time_in_millis":0},"commit":{"id":"UnyylzqBmDeNMxcsLMyrww==","generation":2,"user_data":{"local_checkpoint":"-1","max_unsafe_auto_id_timestamp":"-1","translog_uuid":"5yejYrPORlyDMbyaXrRzOw","es_version":"7.17.8","history_uuid":"liz-mxp4R3CoVVQyfW69tA","max_seq_no":"-1"},"num_docs":0},"seq_no":{"max_seq_no":-1,"local_checkpoint":-1,"global_checkpoint":-1},"retention_leases":{"primary_term":1,"version":1,"leases":[{"id":"peer_recovery/fPTWQDm9T1KJbiWPw-KeJg","retaining_seq_no":0,"timestamp":1676447039725,"source":"peer recovery"}]},"shard_path":{"state_path":"D:\\SonarQube\\sonarqube-9.9.0.65466\\data\\es7\\nodes\\0","data_path":"D:\\SonarQube\\sonarqube-9.9.0.65466\\data\\es7\\nodes\\0","is_custom_data_path":false}}],
"metadatas":{"uuid":"BHGFsmixQImS9KGmAKenwA","primaries":{"docs":{"count":17,"deleted":10},"shard_stats":{"total_count":1},"store":{"size_in_bytes":34156,"total_data_set_size_in_bytes":34156,"reserved_in_bytes":0},"indexing":{"index_total":27,"index_time_in_millis":150,"index_current":0,"index_failed":0,"delete_total":0,"delete_time_in_millis":0,"delete_current":0,"noop_update_total":0,"is_throttled":false,"throttle_time_in_millis":0},"get":{"total":11,"time_in_millis":65,"exists_total":10,"exists_time_in_millis":58,"missing_total":1,"missing_time_in_millis":7,"current":0},"search":{"open_contexts":0,"query_total":0,"query_time_in_millis":0,"query_current":0,"fetch_total":0,"fetch_time_in_millis":0,"fetch_current":0,"scroll_total":0,"scroll_time_in_millis":0,"scroll_current":0,"suggest_total":0,"suggest_time_in_millis":0,"suggest_current":0},"merges":{"current":0,"current_docs":0,"current_size_in_bytes":0,"total":2,"total_time_in_millis":228,"total_docs":20,"total_size_in_bytes":64687,"total_stopped_time_in_millis":0,"total_throttled_time_in_millis":0,"total_auto_throttle_in_bytes":20971520},"refresh":{"total":30,"total_time_in_millis":3164,"external_total":29,"external_total_time_in_millis":3190,"listeners":0},"flush":{"total":1,"periodic":0,"total_time_in_millis":85},"warmer":{"current":0,"total":28,"total_time_in_millis":3},"query_cache":{"memory_size_in_bytes":0,"total_count":0,"hit_count":0,"miss_count":0,"cache_size":0,"cache_count":0,"evictions":0},"fielddata":{"memory_size_in_bytes":0,"evictions":0},"completion":{"size_in_bytes":0},"segments":{"count":9,"memory_in_bytes":8100,"terms_memory_in_bytes":2592,"stored_fields_memory_in_bytes":4424,"term_vectors_memory_in_bytes":0,"norms_memory_in_bytes":0,"points_memory_in_bytes":0,"doc_values_memory_in_bytes":1084,"index_writer_memory_in_bytes":0,"version_map_memory_in_bytes":0,"fixed_bit_set_memory_in_bytes":0,"max_unsafe_auto_id_timestamp":-1,"file_sizes":{}},"translog":{"operations":0,"size_in_bytes":55,"uncommitted_operations":0,"uncommitted_size_in_bytes":55,"earliest_last_modified_age":5091715},"request_cache":{"memory_size_in_bytes":0,"evictions":0,"hit_count":0,"miss_count":0},"recovery":{"current_as_source":0,"current_as_target":0,"throttle_time_in_millis":0}},"total":{"docs":{"count":17,"deleted":10},"shard_stats":{"total_count":1},"store":{"size_in_bytes":34156,"total_data_set_size_in_bytes":34156,"reserved_in_bytes":0},"indexing":{"index_total":27,"index_time_in_millis":150,"index_current":0,"index_failed":0,"delete_total":0,"delete_time_in_millis":0,"delete_current":0,"noop_update_total":0,"is_throttled":false,"throttle_time_in_millis":0},"get":{"total":11,"time_in_millis":65,"exists_total":10,"exists_time_in_millis":58,"missing_total":1,"missing_time_in_millis":7,"current":0},"search":{"open_contexts":0,"query_total":0,"query_time_in_millis":0,"query_current":0,"fetch_total":0,"fetch_time_in_millis":0,"fetch_current":0,"scroll_total":0,"scroll_time_in_millis":0,"scroll_current":0,"suggest_total":0,"suggest_time_in_millis":0,"suggest_current":0},"merges":{"current":0,"current_docs":0,"current_size_in_bytes":0,"total":2,"total_time_in_millis":228,"total_docs":20,"total_size_in_bytes":64687,"total_stopped_time_in_millis":0,"total_throttled_time_in_millis":0,"total_auto_throttle_in_bytes":20971520},"refresh":{"total":30,"total_time_in_millis":3164,"external_total":29,"external_total_time_in_millis":3190,"listeners":0},"flush":{"total":1,"periodic":0,"total_time_in_millis":85},"warmer":{"current":0,"total":28,"total_time_in_millis":3},"query_cache":{"memory_size_in_bytes":0,"total_count":0,"hit_count":0,"miss_count":0,"cache_size":0,"cache_count":0,"evictions":0},"fielddata":{"memory_size_in_bytes":0,"evictions":0},"completion":{"size_in_bytes":0},"segments":{"count":9,"memory_in_bytes":8100,"terms_memory_in_bytes":2592,"stored_fields_memory_in_bytes":4424,"term_vectors_memory_in_bytes":0,"norms_memory_in_bytes":0,"points_memory_in_bytes":0,"doc_values_memory_in_bytes":1084,"index_writer_memory_in_bytes":0,"version_map_memory_in_bytes":0,"fixed_bit_set_memory_in_bytes":0,"max_unsafe_auto_id_timestamp":-1,"file_sizes":{}},"translog":{"operations":0,"size_in_bytes":55,"uncommitted_operations":0,"uncommitted_size_in_bytes":55,"earliest_last_modified_age":5091715},"request_cache":{"memory_size_in_bytes":0,"evictions":0,"hit_count":0,"miss_count":0},"recovery":{"current_as_source":0,"current_as_target":0,"throttle_time_in_millis":0}},"shards":{"0":[{"routing":{"state":"STARTED","primary":true,"node":"fPTWQDm9T1KJbiWPw-KeJg","relocating_node":null},"docs":{"count":17,"deleted":10},"shard_stats":{"total_count":1},"store":{"size_in_bytes":34156,"total_data_set_size_in_bytes":34156,"reserved_in_bytes":0},"indexing":{"index_total":27,"index_time_in_millis":150,"index_current":0,"index_failed":0,"delete_total":0,"delete_time_in_millis":0,"delete_current":0,"noop_update_total":0,"is_throttled":false,"throttle_time_in_millis":0},"get":{"total":11,"time_in_millis":65,"exists_total":10,"exists_time_in_millis":58,"missing_total":1,"missing_time_in_millis":7,"current":0},"search":{"open_contexts":0,"query_total":0,"query_time_in_millis":0,"query_current":0,"fetch_total":0,"fetch_time_in_millis":0,"fetch_current":0,"scroll_total":0,"scroll_time_in_millis":0,"scroll_current":0,"suggest_total":0,"suggest_time_in_millis":0,"suggest_current":0},"merges":{"current":0,"current_docs":0,"current_size_in_bytes":0,"total":2,"total_time_in_millis":228,"total_docs":20,"total_size_in_bytes":64687,"total_stopped_time_in_millis":0,"total_throttled_time_in_millis":0,"total_auto_throttle_in_bytes":20971520},"refresh":{"total":30,"total_time_in_millis":3164,"external_total":29,"external_total_time_in_millis":3190,"listeners":0},"flush":{"total":1,"periodic":0,"total_time_in_millis":85},"warmer":{"current":0,"total":28,"total_time_in_millis":3},"query_cache":{"memory_size_in_bytes":0,"total_count":0,"hit_count":0,"miss_count":0,"cache_size":0,"cache_count":0,"evictions":0},"fielddata":{"memory_size_in_bytes":0,"evictions":0},"completion":{"size_in_bytes":0},"segments":{"count":9,"memory_in_bytes":8100,"terms_memory_in_bytes":2592,"stored_fields_memory_in_bytes":4424,"term_vectors_memory_in_bytes":0,"norms_memory_in_bytes":0,"points_memory_in_bytes":0,"doc_values_memory_in_bytes":1084,"index_writer_memory_in_bytes":0,"version_map_memory_in_bytes":0,"fixed_bit_set_memory_in_bytes":0,"max_unsafe_auto_id_timestamp":-1,"file_sizes":{}},"translog":{"operations":0,"size_in_bytes":55,"uncommitted_operations":0,"uncommitted_size_in_bytes":55,"earliest_last_modified_age":5091715},"request_cache":{"memory_size_in_bytes":0,"evictions":0,"hit_count":0,"miss_count":0},"recovery":{"current_as_source":0,"current_as_target":0,"throttle_time_in_millis":0},"commit":{"id":"UnyylzqBmDeNMxcsLMytag==","generation":3,"user_data":{"local_checkpoint":"26","max_unsafe_auto_id_timestamp":"-1","min_retained_seq_no":"0","translog_uuid":"IiflYiTbRLmcSX20N12Jcw","es_version":"7.17.8","history_uuid":"8BnN1VvPSimVHUA36hR0bw","max_seq_no":"26"},"num_docs":17},"seq_no":{"max_seq_no":26,"local_checkpoint":26,"global_checkpoint":26},"retention_leases":{"primary_term":1,"version":3,"leases":[{"id":"peer_recovery/fPTWQDm9T1KJbiWPw-KeJg","retaining_seq_no":27,"timestamp":1676447098010,"source":"peer recovery"}]},"shard_path":{"state_path":"D:\\SonarQube\\sonarqube-9.9.0.65466\\data\\es7\\nodes\\0","data_path":"D:\\SonarQube\\sonarqube-9.9.0.65466\\data\\es7\\nodes\\0","is_custom_data_path":false}}]}
"projectmeasures":{"uuid":"vsLwzHAJSu2cB_Hu2m_18w","primaries":{"docs":{"count":2,"deleted":0},"shard_stats":{"total_count":5},"store":{"size_in_bytes":19994,"total_data_set_size_in_bytes":19994,"reserved_in_bytes":0},"indexing":{"index_total":4,"index_time_in_millis":8,"index_current":0,"index_failed":0,"delete_total":2,"delete_time_in_millis":3,"delete_current":0,"noop_update_total":0,"is_throttled":false,"throttle_time_in_millis":0},"get":{"total":0,"time_in_millis":0,"exists_total":0,"exists_time_in_millis":0,"missing_total":0,"missing_time_in_millis":0,"current":0},"search":{"open_contexts":0,"query_total":72,"query_time_in_millis":520,"query_current":0,"fetch_total":10,"fetch_time_in_millis":19,"fetch_current":0,"scroll_total":0,"scroll_time_in_millis":0,"scroll_current":0,"suggest_total":0,"suggest_time_in_millis":0,"suggest_current":0},"merges":{"current":0,"current_docs":0,"current_size_in_bytes":0,"total":0,"total_time_in_millis":0,"total_docs":0,"total_size_in_bytes":0,"total_stopped_time_in_millis":0,"total_throttled_time_in_millis":0,"total_auto_throttle_in_bytes":104857600},"refresh":{"total":52,"total_time_in_millis":627,"external_total":50,"external_total_time_in_millis":635,"listeners":0},"flush":{"total":7,"periodic":0,"total_time_in_millis":115},"warmer":{"current":0,"total":11,"total_time_in_millis":6},"query_cache":{"memory_size_in_bytes":0,"total_count":0,"hit_count":0,"miss_count":0,"cache_size":0,"cache_count":0,"evictions":0},"fielddata":{"memory_size_in_bytes":452,"evictions":0},"completion":{"size_in_bytes":0},"segments":{"count":4,"memory_in_bytes":7440,"terms_memory_in_bytes":5184,"stored_fields_memory_in_bytes":1952,"term_vectors_memory_in_bytes":0,"norms_memory_in_bytes":0,"points_memory_in_bytes":0,"doc_values_memory_in_bytes":304,"index_writer_memory_in_bytes":0,"version_map_memory_in_bytes":0,"fixed_bit_set_memory_in_bytes":192,"max_unsafe_auto_id_timestamp":-1,"file_sizes":{}},"translog":{"operations":0,"size_in_bytes":275,"uncommitted_operations":0,"uncommitted_size_in_bytes":275,"earliest_last_modified_age":4321538},"request_cache":{"memory_size_in_bytes":0,"evictions":0,"hit_count":0,"miss_count":0},"recovery":{"current_as_source":0,"current_as_target":0,"throttle_time_in_millis":0}},"total":{"docs":{"count":2,"deleted":0},"shard_stats":{"total_count":5},"store":{"size_in_bytes":19994,"total_data_set_size_in_bytes":19994,"reserved_in_bytes":0},"indexing":{"index_total":4,"index_time_in_millis":8,"index_current":0,"index_failed":0,"delete_total":2,"delete_time_in_millis":3,"delete_current":0,"noop_update_total":0,"is_throttled":false,"throttle_time_in_millis":0},"get":{"total":0,"time_in_millis":0,"exists_total":0,"exists_time_in_millis":0,"missing_total":0,"missing_time_in_millis":0,"current":0},"search":{"open_contexts":0,"query_total":72,"query_time_in_millis":520,"query_current":0,"fetch_total":10,"fetch_time_in_millis":19,"fetch_current":0,"scroll_total":0,"scroll_time_in_millis":0,"scroll_current":0,"suggest_total":0,"suggest_time_in_millis":0,"suggest_current":0},"merges":{"current":0,"current_docs":0,"current_size_in_bytes":0,"total":0,"total_time_in_millis":0,"total_docs":0,"total_size_in_bytes":0,"total_stopped_time_in_millis":0,"total_throttled_time_in_millis":0,"total_auto_throttle_in_bytes":104857600},"refresh":{"total":52,"total_time_in_millis":627,"external_total":50,"external_total_time_in_millis":635,"listeners":0},"flush":{"total":7,"periodic":0,"total_time_in_millis":115},"warmer":{"current":0,"total":11,"total_time_in_millis":6},"query_cache":{"memory_size_in_bytes":0,"total_count":0,"hit_count":0,"miss_count":0,"cache_size":0,"cache_count":0,"evictions":0},"fielddata":{"memory_size_in_bytes":452,"evictions":0},"completion":{"size_in_bytes":0},"segments":{"count":4,"memory_in_bytes":7440,"terms_memory_in_bytes":5184,"stored_fields_memory_in_bytes":1952,"term_vectors_memory_in_bytes":0,"norms_memory_in_bytes":0,"points_memory_in_bytes":0,"doc_values_memory_in_bytes":304,"index_writer_memory_in_bytes":0,"version_map_memory_in_bytes":0,"fixed_bit_set_memory_in_bytes":192,"max_unsafe_auto_id_timestamp":-1,"file_sizes":{}},"translog":{"operations":0,"size_in_bytes":275,"uncommitted_operations":0,"uncommitted_size_in_bytes":275,"earliest_last_modified_age":4321538},"request_cache":{"memory_size_in_bytes":0,"evictions":0,"hit_count":0,"miss_count":0},"recovery":{"current_as_source":0,"current_as_target":0,"throttle_time_in_millis":0}},"shards":{"0":[{"routing":{"state":"STARTED","primary":true,"node":"fPTWQDm9T1KJbiWPw-KeJg","relocating_node":null},"docs":{"count":2,"deleted":0},"shard_stats":{"total_count":1},"store":{"size_in_bytes":19090,"total_data_set_size_in_bytes":19090,"reserved_in_bytes":0},"indexing":{"index_total":4,"index_time_in_millis":8,"index_current":0,"index_failed":0,"delete_total":2,"delete_time_in_millis":3,"delete_current":0,"noop_update_total":0,"is_throttled":false,"throttle_time_in_millis":0},"get":{"total":0,"time_in_millis":0,"exists_total":0,"exists_time_in_millis":0,"missing_total":0,"missing_time_in_millis":0,"current":0},"search":{"open_contexts":0,"query_total":20,"query_time_in_millis":145,"query_current":0,"fetch_total":10,"fetch_time_in_millis":19,"fetch_current":0,"scroll_total":0,"scroll_time_in_millis":0,"scroll_current":0,"suggest_total":0,"suggest_time_in_millis":0,"suggest_current":0},"merges":{"current":0,"current_docs":0,"current_size_in_bytes":0,"total":0,"total_time_in_millis":0,"total_docs":0,"total_size_in_bytes":0,"total_stopped_time_in_millis":0,"total_throttled_time_in_millis":0,"total_auto_throttle_in_bytes":20971520},"refresh":{"total":12,"total_time_in_millis":627,"external_total":10,"external_total_time_in_millis":635,"listeners":0},"flush":{"total":3,"periodic":0,"total_time_in_millis":115},"warmer":{"current":0,"total":7,"total_time_in_millis":6},"query_cache":{"memory_size_in_bytes":0,"total_count":0,"hit_count":0,"miss_count":0,"cache_size":0,"cache_count":0,"evictions":0},"fielddata":{"memory_size_in_bytes":452,"evictions":0},"completion":{"size_in_bytes":0},"segments":{"count":4,"memory_in_bytes":7440,"terms_memory_in_bytes":5184,"stored_fields_memory_in_bytes":1952,"term_vectors_memory_in_bytes":0,"norms_memory_in_bytes":0,"points_memory_in_bytes":0,"doc_values_memory_in_bytes":304,"index_writer_memory_in_bytes":0,"version_map_memory_in_bytes":0,"fixed_bit_set_memory_in_bytes":192,"max_unsafe_auto_id_timestamp":-1,"file_sizes":{}},"translog":{"operations":0,"size_in_bytes":55,"uncommitted_operations":0,"uncommitted_size_in_bytes":55,"earliest_last_modified_age":4321538},"request_cache":{"memory_size_in_bytes":0,"evictions":0,"hit_count":0,"miss_count":0},"recovery":{"current_as_source":0,"current_as_target":0,"throttle_time_in_millis":0},"commit":{"id":"UnyylzqBmDeNMxcsLMytqQ==","generation":4,"user_data":{"local_checkpoint":"5","max_unsafe_auto_id_timestamp":"-1","min_retained_seq_no":"2","translog_uuid":"47tWo1WYTbSk3TXOBT3aoA","es_version":"7.17.8","history_uuid":"7Kb5G1QwQUS1DuIb8kr4fw","max_seq_no":"5"},"num_docs":2},"seq_no":{"max_seq_no":5,"local_checkpoint":5,"global_checkpoint":5},"retention_leases":{"primary_term":1,"version":4,"leases":[{"id":"peer_recovery/fPTWQDm9T1KJbiWPw-KeJg","retaining_seq_no":6,"timestamp":1676447880588,"source":"peer recovery"}]},"shard_path":{"state_path":"D:\\SonarQube\\sonarqube-9.9.0.65466\\data\\es7\\nodes\\0","data_path":"D:\\SonarQube\\sonarqube-9.9.0.65466\\data\\es7\\nodes\\0","is_custom_data_path":false}}]
TRACE web[AYZUCIDyFPLx75neAAFe][es] ES indices stats request | time=9ms
TRACE web[AYZUCIDyFPLx75neAAFe][sql] time=0ms | sql=select p.prop_key as "key", p.is_empty as empty, p.text_value as textValue, p.clob_value as clobValue, p.component_uuid as componentUuid, p.user_uuid as userUuid from properties p where p.component_uuid is null and p.user_uuid is null
RACE web[AYZUCIDyFPLx75neAAFe][sql] time=0ms | sql=SELECT ncp.uuid, ncp.project_uuid as projectUuid, ncp.branch_uuid as branchUuid, ncp.type, ncp.value, ncp.updated_at as updatedAt, ncp.created_at as createdAt FROM new_code_periods ncp WHERE ncp.project_uuid is null AND ncp.branch_uuid is null
TRACE web[AYZUCIDyFPLx75neAAFe][sql] time=0ms | sql=select a.kee as "key", a.uuid as "uuid", a.alm_id as "rawAlm", a.url as "url", a.app_id as "appId", a.private_key as "privateKey", a.pat as "personalAccessToken", a.client_id as "clientId", a.client_secret as "clientSecret", a.created_at as "createdAt", a.updated_at as "updatedAt", a.webhook_secret as "webhookSecret" from alm_settings a
TRACE web[AYZUCIDyFPLx75neAAFe][tracer] curl -iX GET 'http://127.0.0.1:9001/_cluster/health?master_timeout=30s&level=cluster&timeout=30s'\n# HTTP/1.1 200 OK\n# X-elastic-product: Elasticsearch\n# content-type: application/json; charset=UTF-8\n# content-length: 387\n#\n# {"cluster_name":"sonarqube","status":"green","timed_out":false,"number_of_nodes":1,"number_of_data_nodes":1,"active_primary_shards":24,"active_shards":24,"relocating_shards":0,"initializing_shards":0,"unassigned_shards":0,"delayed_unassigned_shards":0,"number_of_pending_tasks":0,"number_of_in_flight_fetch":0,"task_max_waiting_in_queue_millis":0,"active_shards_percent_as_number":100.0}
TRACE web[AYZUCIDyFPLx75neAAFe][es] ES cluster health request | time=2ms
TRACE web[AYZUCIDyFPLx75neAAFe][tracer] curl -iX GET 'http://127.0.0.1:9001/_nodes/stats/fs,process,jvm,indices,breaker'\n# HTTP/1.1 200 OK\n# X-elastic-product: Elasticsearch\n# content-type: application/json; charset=UTF-8\n# content-length: 5104\n#\n# {"_nodes":{"total":1,"successful":1,"failed":0},"cluster_name":"sonarqube","nodes":{"fPTWQDm9T1KJbiWPw-KeJg":{"timestamp":1676452589170,"name":"sonarqube","transport_address":"127.0.0.1:60813","host":"127.0.0.1","ip":"127.0.0.1:60813","roles":["data","data_cold","data_content","data_frozen","data_hot","data_warm","ingest","master","remote_cluster_client"],"attributes":{"rack_id":"sonarqube"},"indices":{"docs":{"count":9673,"deleted":10},"shard_stats":{"total_count":24},"store":{"size_in_bytes":11141674,"total_data_set_size_in_bytes":11141674,"reserved_in_bytes":0},"indexing":{"index_total":9689,"index_time_in_millis":4547,"index_current":0,"index_failed":0,"delete_total":5,"delete_time_in_millis":13,"delete_current":0,"noop_update_total":0,"is_throttled":false,"throttle_time_in_millis":0},"get":{"total":11,"time_in_millis":65,"exists_total":10,"exists_time_in_millis":58,"missing_total":1,"missing_time_in_millis":7,"current":0},"search":{"open_contexts":0,"query_total":77,"query_time_in_millis":525,"query_current":0,"fetch_total":15,"fetch_time_in_millis":19,"fetch_current":0,"scroll_total":2,"scroll_time_in_millis":35,"scroll_current":0,"suggest_total":0,"suggest_time_in_millis":0,"suggest_current":0},"merges":{"current":0,"current_docs":0,"current_size_in_bytes":0,"total":6,"total_time_in_millis":1175,"total_docs":2463,"total_size_in_bytes":648767,"total_stopped_time_in_millis":0,"total_throttled_time_in_millis":0,"total_auto_throttle_in_bytes":503316480},"refresh":{"total":244,"total_time_in_millis":14513,"external_total":233,"external_total_time_in_millis":15127,"listeners":0},"flush":{"total":30,"periodic":0,"total_time_in_millis":544},"warmer":{"current":0,"total":114,"total_time_in_millis":544},"query_cache":{"memory_size_in_bytes":0,"total_count":0,"hit_count":0,"miss_count":0,"cache_size":0,"cache_count":0,"evictions":0},"fielddata":{"memory_size_in_bytes":4700,"evictions":0},"completion":{"size_in_bytes":0},"segments":{"count":27,"memory_in_bytes":60404,"terms_memory_in_bytes":42720,"stored_fields_memory_in_bytes":13336,"term_vectors_memory_in_bytes":488,"norms_memory_in_bytes":320,"points_memory_in_bytes":0,"doc_values_memory_in_bytes":3540,"index_writer_memory_in_bytes":0,"version_map_memory_in_bytes":0,"fixed_bit_set_memory_in_bytes":192,"max_unsafe_auto_id_timestamp":-1,"file_sizes":{}},"translog":{"operations":0,"size_in_bytes":1320,"uncommitted_operations":0,"uncommitted_size_in_bytes":1320,"earliest_last_modified_age":4429999},"request_cache":{"memory_size_in_bytes":0,"evictions":0,"hit_count":0,"miss_count":0},"recovery":{"current_as_source":0,"current_as_target":0,"throttle_time_in_millis":0}},"process":{"timestamp":1676452589185,"open_file_descriptors":-1,"max_file_descriptors":-1,"cpu":{"percent":0,"total_in_millis":105921},"mem":{"total_virtual_in_bytes":843489280}},"jvm":{"timestamp":1676452589185,"uptime_in_millis":5586543,"mem":{"heap_used_in_bytes":199810896,"heap_used_percent":37,"heap_committed_in_bytes":536870912,"heap_max_in_bytes":536870912,"non_heap_used_in_bytes":119589144,"non_heap_committed_in_bytes":122683392,"pools":{"young":{"used_in_bytes":98566144,"max_in_bytes":0,"peak_used_in_bytes":309329920,"peak_max_in_bytes":0},"old":{"used_in_bytes":86639104,"max_in_bytes":536870912,"peak_used_in_bytes":86639104,"peak_max_in_bytes":536870912},"survivor":{"used_in_bytes":14605648,"max_in_bytes":0,"peak_used_in_bytes":33554432,"peak_max_in_bytes":0}}},"threads":{"count":97,"peak_count":103},"gc":{"collectors":{"young":{"collection_count":11,"collection_time_in_millis":84},"old":{"collection_count":0,"collection_time_in_millis":0}}},"buffer_pools":{"mapped":{"count":39,"used_in_bytes":11104597,"total_capacity_in_bytes":11104597},"direct":{"count":68,"used_in_bytes":4477010,"total_capacity_in_bytes":4477009},"mapped - 'non-volatile memory'":{"count":0,"used_in_bytes":0,"total_capacity_in_bytes":0}},"classes":{"current_loaded_count":15801,"total_loaded_count":15801,"total_unloaded_count":0}},"fs":{"timestamp":1676452589186,"total":{"total_in_bytes":322103668736,"free_in_bytes":317704413184,"available_in_bytes":317704413184},"data":[{"path":"D:\\SonarQube\\sonarqube-9.9.0.65466\\data\\es7\\nodes\\0","mount":"DATA (D:)","type":"NTFS","total_in_bytes":322103668736,"free_in_bytes":317704413184,"available_in_bytes":317704413184}]},"breakers":{"request":{"limit_size_in_bytes":322122547,"limit_size":"307.1mb","estimated_size_in_bytes":0,"estimated_size":"0b","overhead":1.0,"tripped":0},"fielddata":{"limit_size_in_bytes":214748364,"limit_size":"204.7mb","estimated_size_in_bytes":4700,"estimated_size":"4.5kb","overhead":1.03,"tripped":0},"in_flight_requests":{"limit_size_in_bytes":536870912,"limit_size":"512mb","estimated_size_in_bytes":0,"estimated_size":"0b","overhead":2.0,"tripped":0},"accounting":{"limit_size_in_bytes":536870912,"limit_size":"512mb","estimated_size_in_bytes":60004,"estimated_size":"58.5kb","overhead":1.0,"tripped":0},"parent":{"limit_size_in_bytes":510027366,"limit_size":"486.3mb","estimated_size_in_bytes":199810896,"estimated_size":"190.5mb","overhead":1.0,"tripped":0}}}}}
TRACE web[AYZUCIDyFPLx75neAAFe][es] time=18ms
TRACE web[AYZUCIDyFPLx75neAAFe][sql] time=0ms | sql=select p.prop_key as "key", p.is_empty as empty, p.text_value as textValue, p.clob_value as clobValue, p.component_uuid as componentUuid, p.user_uuid as userUuid from properties p where p.prop_key=? and p.component_uuid is null and p.user_uuid is null | params=sonar.core.id
TRACE web[AYZUCIDyFPLx75neAAFe][sql] time=0ms | sql=select sum(sumncloc.maxncloc) from ( select b.project_uuid as projectUuid, max(lm.value) as maxncloc from live_measures lm inner join metrics m on m.uuid = lm.metric_uuid inner join project_branches b on b.uuid = lm.component_uuid inner join projects p on p.uuid = b.project_uuid and p.qualifier = 'TRK' WHERE m.name = ? group by b.project_uuid ) sumncloc | params=ncloc
TRACE web[AYZUCIDyFPLx75neAAFe][sql] time=1ms | sql=select p.prop_key as "key", p.is_empty as empty, p.text_value as textValue, p.clob_value as clobValue, p.component_uuid as componentUuid, p.user_uuid as userUuid from properties p where p.prop_key=? and p.component_uuid is null and p.user_uuid is null | params=sonar.auth.github.enabled
TRACE web[AYZUCIDyFPLx75neAAFe][sql] time=1ms | sql=select p.prop_key as "key", p.is_empty as empty, p.text_value as textValue, p.clob_value as clobValue, p.component_uuid as componentUuid, p.user_uuid as userUuid from properties p where p.prop_key=? and p.component_uuid is null and p.user_uuid is null | params=sonar.auth.saml.enabled
TRACE web[AYZUCIDyFPLx75neAAFe][sql] time=0ms | sql=select p.prop_key as "key", p.is_empty as empty, p.text_value as textValue, p.clob_value as clobValue, p.component_uuid as componentUuid, p.user_uuid as userUuid from properties p where p.prop_key=? and p.component_uuid is null and p.user_uuid is null | params=sonar.auth.gitlab.enabled
TRACE web[AYZUCIDyFPLx75neAAFe][sql] time=0ms | sql=select p.prop_key as "key", p.is_empty as empty, p.text_value as textValue, p.clob_value as clobValue, p.component_uuid as componentUuid, p.user_uuid as userUuid from properties p where p.prop_key=? and p.component_uuid is null and p.user_uuid is null | params=sonar.auth.bitbucket.enabled
TRACE web[AYZUCIDyFPLx75neAAFe][sql] time=1ms | sql=select p.prop_key as "key", p.is_empty as empty, p.text_value as textValue, p.clob_value as clobValue, p.component_uuid as componentUuid, p.user_uuid as userUuid from properties p where p.prop_key=? and p.component_uuid is null and p.user_uuid is null | params=sonar.forceAuthentication
TRACE web[AYZUCIDyFPLx75neAAFe][s.n.w.p.h.HttpURLConnection] ProxySelector Request for http://127.0.0.1:61054/systemInfo
TRACE web[AYZUCIDyFPLx75neAAFe][s.n.w.p.h.HttpURLConnection] Proxy used: DIRECT
DEBUG web[AYZUCIDyFPLx75neAAFe][s.n.w.p.h.HttpURLConnection] sun.net.www.MessageHeader@76010ad65 pairs: {GET /systemInfo HTTP/1.1: null}{User-Agent: SonarQube 9.9.0.65466 # 147B411E-AYZUB6IkswD3vT-QxmNt Java/17.0.5}{Host: 127.0.0.1:61054}{Accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2}{Connection: keep-alive}
2023.02.15 04:16:29 TRACE web[AYZUCIDyFPLx75neAAFe][s.n.w.p.h.HttpURLConnection] KeepAlive stream used: http://127.0.0.1:61054/systemInfo
DEBUG web[AYZUCIDyFPLx75neAAFe][s.n.w.p.h.HttpURLConnection] sun.net.www.MessageHeader@32cce1c76 pairs: {null: HTTP/1.1 200 OK}{Date: Wed, 15 Feb 2023 09:16:29 GMT}{Server: Apache-HttpCore/1.1}{Content-Length: 3474}{Content-Type: application/x-protobuf}{Connection: keep-alive}
TRACE web[AYZUCIDyFPLx75neAAFd][s.n.w.p.h.HttpURLConnection] Proxy used: DIRECT
ERROR web[AYZUCIDyFPLx75neAAFd][o.s.s.p.UpdateCenterClient] Fail to connect to update center
org.sonar.api.utils.SonarException: Fail to download: https://update.sonarsource.org/update-center.properties (no proxy)
at org.sonar.core.util.DefaultHttpDownloader.failToDownload(DefaultHttpDownloader.java:157)
..
..
at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: java.net.SocketException: Connection reset
at java.base/sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:323)
..
..
at org.sonar.core.util.DefaultHttpDownloader.readString(DefaultHttpDownloader.java:113)
... 149 common frames omitted
TRACE web[][o.s.c.p.PriorityBeanFactory] Returning cached instance of singleton bean 'jdk.internal.loader.ClassLoaders$AppClassLoader@659e0bfd-org.sonar.server.platform.web.requestid.RequestIdGeneratorImpl'
TRACE web[AYZUCIDyFPLx75neAAFf][o.s.c.p.PriorityBeanFactory] Returning cached instance of singleton bean 'jdk.internal.loader.ClassLoaders$AppClassLoader@659e0bfd-org.sonar.db.DBSessionsImpl'
TRACE web[AYZUCIDyFPLx75neAAFf][o.s.c.p.PriorityBeanFactory] Returning cached instance of singleton bean 'jdk.internal.loader.ClassLoaders$AppClassLoader@659e0bfd-org.sonar.server.setting.ThreadLocalSettings'
TRACE web[AYZUCIDyFPLx75neAAFf][o.s.c.p.PriorityBeanFactory] Returning cached instance of singleton bean 'jdk.internal.loader.ClassLoaders$AppClassLoader@659e0bfd-org.sonar.server.authentication.UserSessionInitializer'
TRACE web[AYZUCIDyFPLx75neAAFf][o.s.s.p.w.UserSessionFilter] Thread[http-nio-0.0.0.0-9000-exec-9,5,main] serves /api/system/logs
TRACE web[AYZUCIDyFPLx75neAAFf][sql] time=1ms | sql=select st.uuid as uuid, st.user_uuid as "userUuid", st.expiration_date as "expirationDate", st.created_at as "createdAt", st.updated_at as "updatedAt" from session_tokens st where st.uuid=? | params=AYZUCShkswD3vT-QxwG7
TRACE web[AYZUCIDyFPLx75neAAFf][sql] time=0ms | sql=SELECT u.uuid as uuid, u.login as login, u.name as name, u.email as email, u.active as "active", u.scm_accounts as "scmAccounts", u.salt as "salt", u.crypted_password as "cryptedPassword", u.hash_method as "hashMethod", u.external_id as "externalId", u.external_login as "externalLogin", u.external_identity_provider as "externalIdentityProvider", u.user_local as "local", u.reset_password as "resetPassword", u.homepage_type as "homepageType", u.homepage_parameter as "homepageParameter", u.last_connection_date as "lastConnectionDate", u.last_sonarlint_connection as "lastSonarlintConnectionDate", u.created_at as "createdAt", u.updated_at as "updatedAt" FROM users u WHERE u.uuid=? | params=AYZUB5vnswD3vT-QxmNZ
TRACE web[AYZUCIDyFPLx75neAAFf][sql] time=1ms | sql=select gr.role from group_roles gr inner join groups_users gu on gr.group_uuid=gu.group_uuid where gr.component_uuid is null and gu.user_uuid=? union select gr.role from group_roles gr where gr.group_uuid is null and gr.component_uuid is null union select ur.role from user_roles ur where ur.user_uuid=? and ur.component_uuid is null | params=AYZUB5vnswD3vT-QxmNZ, AYZUB5vnswD3vT-QxmNZ
TRACE web[][tracer] curl -iX GET 'http://127.0.0.1:9001/_cluster/health?master_timeout=30s&level=cluster&timeout=30s'\n# HTTP/1.1 200 OK\n# X-elastic-product: Elasticsearch\n# content-type: application/json; charset=UTF-8\n# content-length: 387\n#\n# {"cluster_name":"sonarqube","status":"green","timed_out":false,"number_of_nodes":1,"number_of_data_nodes":1,"active_primary_shards":24,"active_shards":24,"relocating_shards":0,"initializing_shards":0,"unassigned_shards":0,"delayed_unassigned_shards":0,"number_of_pending_tasks":0,"number_of_in_flight_fetch":0,"task_max_waiting_in_queue_millis":0,"active_shards_percent_as_number":100.0}
TRACE web[][es] ES cluster health request | time=2ms
Make sure you 