Sonar failing to update project key

version: 7.7.0.23042
error:

2019.06.06 16:22:48 ERROR web[AWstiLG6M3uJBsvGAAGN][o.s.s.w.WebServiceEngine] Fail to process request http://sonarqube.company.com:9000/api/projects/update_key
java.lang.NullPointerException: null
	at org.sonar.db.component.ComponentKeyUpdaterDao.runBatchUpdateForAllResources(ComponentKeyUpdaterDao.java:171)
	at org.sonar.db.component.ComponentKeyUpdaterDao.updateKey(ComponentKeyUpdaterDao.java:78)
	at org.sonar.server.component.ComponentService.updateKey(ComponentService.java:65)
	at org.sonar.server.project.ws.UpdateKeyAction.handle(UpdateKeyAction.java:110)
	at org.sonar.server.ws.WebServiceEngine.execute(WebServiceEngine.java:110)
	at org.sonar.server.ws.WebServiceFilter.doFilter(WebServiceFilter.java:88)
	at org.sonar.server.platform.web.MasterServletFilter$GodFilterChain.doFilter(MasterServletFilter.java:126)
	at org.sonar.server.platform.web.MasterServletFilter.doFilter(MasterServletFilter.java:95)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.sonar.server.user.UserSessionFilter.doFilter(UserSessionFilter.java:87)
	at org.sonar.server.user.UserSessionFilter.doFilter(UserSessionFilter.java:71)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.sonar.server.platform.web.CacheControlFilter.doFilter(CacheControlFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.sonar.server.platform.web.SecurityServletFilter.doHttpFilter(SecurityServletFilter.java:76)
	at org.sonar.server.platform.web.SecurityServletFilter.doFilter(SecurityServletFilter.java:48)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.sonar.server.platform.web.RedirectFilter.doFilter(RedirectFilter.java:61)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.sonar.server.platform.web.requestid.RequestIdFilter.doFilter(RequestIdFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.sonar.server.platform.web.RootFilter.doFilter(RootFilter.java:62)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at ch.qos.logback.access.tomcat.LogbackValve.invoke(LogbackValve.java:256)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)

No clue what the steps to reproduce are. This only occurs with a single project, our largest project in sonar. This happens when we try to update the key to a new key. I’ve verified that no other project exists with that key.

It appears it might be related to a branch that is somehow undeletable.

when I try to delete it I get the error:

Component 'com.promontech.loanplatform.server... on branch 'bug/TA-227' not found

Trace level on the logs. Steps: Try to update key, then navigate to branches and try to delete the TA-227 branch.

2019.06.06 20:30:06 ERROR web[AWsuaOlQAn62Y59NAAEU][o.s.s.w.WebServiceEngine] Fail to process request http://sonarqube.corp.company.com:9000/api/projects/update_key
java.lang.NullPointerException: null
	at org.sonar.db.component.ComponentKeyUpdaterDao.runBatchUpdateForAllResources(ComponentKeyUpdaterDao.java:171)
	at org.sonar.db.component.ComponentKeyUpdaterDao.updateKey(ComponentKeyUpdaterDao.java:78)
	at org.sonar.server.component.ComponentService.updateKey(ComponentService.java:65)
	at org.sonar.server.project.ws.UpdateKeyAction.handle(UpdateKeyAction.java:110)
	at org.sonar.server.ws.WebServiceEngine.execute(WebServiceEngine.java:110)
	at org.sonar.server.ws.WebServiceFilter.doFilter(WebServiceFilter.java:88)
	at org.sonar.server.platform.web.MasterServletFilter$GodFilterChain.doFilter(MasterServletFilter.java:126)
	at org.sonar.server.platform.web.MasterServletFilter.doFilter(MasterServletFilter.java:95)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.sonar.server.user.UserSessionFilter.doFilter(UserSessionFilter.java:87)
	at org.sonar.server.user.UserSessionFilter.doFilter(UserSessionFilter.java:71)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.sonar.server.platform.web.CacheControlFilter.doFilter(CacheControlFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.sonar.server.platform.web.SecurityServletFilter.doHttpFilter(SecurityServletFilter.java:76)
	at org.sonar.server.platform.web.SecurityServletFilter.doFilter(SecurityServletFilter.java:48)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.sonar.server.platform.web.RedirectFilter.doFilter(RedirectFilter.java:61)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.sonar.server.platform.web.requestid.RequestIdFilter.doFilter(RequestIdFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.sonar.server.platform.web.RootFilter.doFilter(RootFilter.java:62)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at ch.qos.logback.access.tomcat.LogbackValve.invoke(LogbackValve.java:256)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEV][o.s.s.u.UserSessionFilter] Thread[http-nio-0.0.0.0-9000-exec-3,5,main] serves /api/settings/values
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEV][sql] time=30ms | sql=SELECT u.id as id, 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.is_root as "root", u.onboarded as "onboarded", u.homepage_type as "homepageType", u.homepage_parameter as "homepageParameter", u.organization_uuid as organizationUuid, u.last_connection_date as "lastConnectionDate", u.created_at as "createdAt", u.updated_at as "updatedAt" FROM users u WHERE u.uuid=? | params=tyler.thrailkill@company.com
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEV][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.resource_id as resourceId, p.user_id as userId from properties p where p.prop_key in ( ? ) and p.resource_id is null and p.user_id is null order by p.id | params=sonar.dbcleaner.daysBeforeDeletingInactiveShortLivingBranches
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEV][sql] time=1ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=organization.enabled
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEV][sql] time=1ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=organization.default
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEV][sql] time=1ms | sql=select org.uuid as "uuid", org.kee as "key", org.name as "name", org.description as "description", org.default_quality_gate_uuid as "defaultQualityGateUuid", org.url as "url", org.avatar_url as "avatarUrl", org.guarded as "guarded", org.subscription as "subscription", org.created_at as "createdAt", org.updated_at as "updatedAt" from organizations org where org.uuid = ? | params=AWVpQ12wv3ZX7gCqRK3c
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEV][sql] time=1ms | sql=select gr.role from group_roles gr inner join groups_users gu on gr.group_id=gu.group_id where gr.organization_uuid=? and gr.resource_id is null and gu.user_id=? union select gr.role from group_roles gr where gr.organization_uuid=? and gr.group_id is null and gr.resource_id is null union select ur.role from user_roles ur where ur.organization_uuid=? and ur.user_id=? and ur.resource_id is null | params=AWVpQ12wv3ZX7gCqRK3c, 10, AWVpQ12wv3ZX7gCqRK3c, AWVpQ12wv3ZX7gCqRK3c, 10
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEW][o.s.s.u.UserSessionFilter] Thread[http-nio-0.0.0.0-9000-exec-6,5,main] serves /api/settings/values
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEW][sql] time=1ms | sql=SELECT u.id as id, 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.is_root as "root", u.onboarded as "onboarded", u.homepage_type as "homepageType", u.homepage_parameter as "homepageParameter", u.organization_uuid as organizationUuid, u.last_connection_date as "lastConnectionDate", u.created_at as "createdAt", u.updated_at as "updatedAt" FROM users u WHERE u.uuid=? | params=tyler.thrailkill@company.com
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEW][sql] time=1ms | sql=SELECT p.id, p.organization_uuid as organizationUuid, p.uuid as uuid, p.uuid_path as uuidPath, p.project_uuid as projectUuid, p.module_uuid as moduleUuid, p.module_uuid_path as moduleUuidPath, p.main_branch_project_uuid as mainBranchProjectUuid, p.kee as kee, p.name as name, p.long_name as longName, p.description as description, p.tags as tagsString, p.qualifier as qualifier, p.scope as scope, p.language as language, p.root_uuid as rootUuid, p.path as path, p.enabled as enabled, p.copy_component_uuid as copyComponentUuid, p.private as isPrivate, p.created_at as createdAt FROM projects p where p.kee=? | params=com.company.platform.server:product-root
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEW][sql] time=1ms | sql=SELECT p.id, p.organization_uuid as organizationUuid, p.uuid as uuid, p.uuid_path as uuidPath, p.project_uuid as projectUuid, p.module_uuid as moduleUuid, p.module_uuid_path as moduleUuidPath, p.main_branch_project_uuid as mainBranchProjectUuid, p.kee as kee, p.name as name, p.long_name as longName, p.description as description, p.tags as tagsString, p.qualifier as qualifier, p.scope as scope, p.language as language, p.root_uuid as rootUuid, p.path as path, p.enabled as enabled, p.copy_component_uuid as copyComponentUuid, p.private as isPrivate, p.created_at as createdAt FROM projects p where p.uuid=? | params=AWIGFzI6U_ZCKl8b-Z0y
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEW][sql] time=1ms | sql=select ur.role from user_roles ur inner join projects p on p.id = ur.resource_id where p.uuid = ? and p.organization_uuid = ur.organization_uuid and ur.user_id = ? union select gr.role from group_roles gr inner join groups_users gu on gr.group_id = gu.group_id inner join projects p on p.id = gr.resource_id where p.uuid = ? and p.organization_uuid = gr.organization_uuid and gu.user_id = ? union select gr.role from group_roles gr inner join projects p on p.id = gr.resource_id where p.uuid = ? and p.organization_uuid = gr.organization_uuid and gr.group_id is null | params=AWIGFzI6U_ZCKl8b-Z0y, 10, AWIGFzI6U_ZCKl8b-Z0y, 10, AWIGFzI6U_ZCKl8b-Z0y
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEW][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.resource_id as resourceId, p.user_id as userId from properties p where p.prop_key in ( ? ) and p.resource_id is null and p.user_id is null order by p.id | params=sonar.branch.longLivedBranches.regex
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEW][sql] time=1ms | sql=select p.id, p.organization_uuid as organizationUuid, p.uuid as uuid, p.uuid_path as uuidPath, p.project_uuid as projectUuid, p.module_uuid as moduleUuid, p.module_uuid_path as moduleUuidPath, p.main_branch_project_uuid as mainBranchProjectUuid, p.kee as kee, p.name as name, p.long_name as longName, p.description as description, p.tags as tagsString, p.qualifier as qualifier, p.scope as scope, p.language as language, p.root_uuid as rootUuid, p.path as path, p.enabled as enabled, p.copy_component_uuid as copyComponentUuid, p.private as isPrivate, p.created_at as createdAt from projects p where p.uuid in ( ? ) | params=AWIGFzI6U_ZCKl8b-Z0y
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEW][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.resource_id as resourceId, p.user_id as userId from properties p where p.prop_key in ( ? ) and p.resource_id in ( ? ) and p.user_id is null | params=sonar.branch.longLivedBranches.regex, 61639
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEW][sql] time=1ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=organization.enabled
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEW][sql] time=1ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=organization.default
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEW][sql] time=1ms | sql=select org.uuid as "uuid", org.kee as "key", org.name as "name", org.description as "description", org.default_quality_gate_uuid as "defaultQualityGateUuid", org.url as "url", org.avatar_url as "avatarUrl", org.guarded as "guarded", org.subscription as "subscription", org.created_at as "createdAt", org.updated_at as "updatedAt" from organizations org where org.uuid = ? | params=AWVpQ12wv3ZX7gCqRK3c
2019.06.06 20:30:10 TRACE web[AWsuaOlQAn62Y59NAAEW][sql] time=1ms | sql=select gr.role from group_roles gr inner join groups_users gu on gr.group_id=gu.group_id where gr.organization_uuid=? and gr.resource_id is null and gu.user_id=? union select gr.role from group_roles gr where gr.organization_uuid=? and gr.group_id is null and gr.resource_id is null union select ur.role from user_roles ur where ur.organization_uuid=? and ur.user_id=? and ur.resource_id is null | params=AWVpQ12wv3ZX7gCqRK3c, 10, AWVpQ12wv3ZX7gCqRK3c, AWVpQ12wv3ZX7gCqRK3c, 10
2019.06.06 20:30:14 TRACE web[AWsuaOlQAn62Y59NAAEX][o.s.s.u.UserSessionFilter] Thread[http-nio-0.0.0.0-9000-exec-2,5,main] serves /api/project_branches/delete
2019.06.06 20:30:14 TRACE web[AWsuaOlQAn62Y59NAAEX][sql] time=1ms | sql=SELECT u.id as id, 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.is_root as "root", u.onboarded as "onboarded", u.homepage_type as "homepageType", u.homepage_parameter as "homepageParameter", u.organization_uuid as organizationUuid, u.last_connection_date as "lastConnectionDate", u.created_at as "createdAt", u.updated_at as "updatedAt" FROM users u WHERE u.uuid=? | params=tyler.thrailkill@company.com
2019.06.06 20:30:15 TRACE web[AWsuaOlQAn62Y59NAAEX][sql] time=4ms | sql=SELECT p.id, p.organization_uuid as organizationUuid, p.uuid as uuid, p.uuid_path as uuidPath, p.project_uuid as projectUuid, p.module_uuid as moduleUuid, p.module_uuid_path as moduleUuidPath, p.main_branch_project_uuid as mainBranchProjectUuid, p.kee as kee, p.name as name, p.long_name as longName, p.description as description, p.tags as tagsString, p.qualifier as qualifier, p.scope as scope, p.language as language, p.root_uuid as rootUuid, p.path as path, p.enabled as enabled, p.copy_component_uuid as copyComponentUuid, p.private as isPrivate, p.created_at as createdAt FROM projects p where p.kee=? | params=com.company.platform.server:product-root
2019.06.06 20:30:15 TRACE web[AWsuaOlQAn62Y59NAAEX][sql] time=24ms | sql=SELECT p.id, p.organization_uuid as organizationUuid, p.uuid as uuid, p.uuid_path as uuidPath, p.project_uuid as projectUuid, p.module_uuid as moduleUuid, p.module_uuid_path as moduleUuidPath, p.main_branch_project_uuid as mainBranchProjectUuid, p.kee as kee, p.name as name, p.long_name as longName, p.description as description, p.tags as tagsString, p.qualifier as qualifier, p.scope as scope, p.language as language, p.root_uuid as rootUuid, p.path as path, p.enabled as enabled, p.copy_component_uuid as copyComponentUuid, p.private as isPrivate, p.created_at as createdAt FROM projects p where p.uuid=? | params=AWIGFzI6U_ZCKl8b-Z0y
2019.06.06 20:30:15 TRACE web[AWsuaOlQAn62Y59NAAEX][sql] time=19ms | sql=select ur.role from user_roles ur inner join projects p on p.id = ur.resource_id where p.uuid = ? and p.organization_uuid = ur.organization_uuid and ur.user_id = ? union select gr.role from group_roles gr inner join groups_users gu on gr.group_id = gu.group_id inner join projects p on p.id = gr.resource_id where p.uuid = ? and p.organization_uuid = gr.organization_uuid and gu.user_id = ? union select gr.role from group_roles gr inner join projects p on p.id = gr.resource_id where p.uuid = ? and p.organization_uuid = gr.organization_uuid and gr.group_id is null | params=AWIGFzI6U_ZCKl8b-Z0y, 10, AWIGFzI6U_ZCKl8b-Z0y, 10, AWIGFzI6U_ZCKl8b-Z0y
2019.06.06 20:30:15 TRACE web[AWsuaOlQAn62Y59NAAEX][sql] time=1ms | sql=select pb.uuid as uuid, pb.project_uuid as projectUuid, pb.kee as kee, pb.key_type as keyType, pb.branch_type as branchType, pb.merge_branch_uuid as mergeBranchUuid, pb.pull_request_binary as pullRequestBinary, pb.manual_baseline_analysis_uuid as manualBaseline from project_branches pb where pb.project_uuid = ? and pb.kee = ? and pb.key_type = ? | params=AWIGFzI6U_ZCKl8b-Z0y, bug/TA-227, BRANCH
2019.06.06 20:30:15 TRACE web[AWsuaOlQAn62Y59NAAEX][sql] time=2ms | sql=select p.id, p.organization_uuid as organizationUuid, p.uuid as uuid, p.uuid_path as uuidPath, p.project_uuid as projectUuid, p.module_uuid as moduleUuid, p.module_uuid_path as moduleUuidPath, p.main_branch_project_uuid as mainBranchProjectUuid, p.kee as kee, p.name as name, p.long_name as longName, p.description as description, p.tags as tagsString, p.qualifier as qualifier, p.scope as scope, p.language as language, p.root_uuid as rootUuid, p.path as path, p.enabled as enabled, p.copy_component_uuid as copyComponentUuid, p.private as isPrivate, p.created_at as createdAt from projects p inner join project_branches pb on pb.uuid = p.project_uuid where (p.kee=? OR p.kee=?) and pb.kee=? and (pb.branch_type='LONG' or pb.branch_type='SHORT') | params=com.company.platform.server:product-root:BRANCH:bug/TA-227, com.company.platform.server:product-root, bug/TA-227
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEZ][o.s.s.u.UserSessionFilter] Thread[http-nio-0.0.0.0-9000-exec-4,5,main] serves /api/settings/list_definitions
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEa][o.s.s.u.UserSessionFilter] Thread[http-nio-0.0.0.0-9000-exec-3,5,main] serves /api/plugins/pending
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEY][o.s.s.u.UserSessionFilter] Thread[http-nio-0.0.0.0-9000-exec-1,5,main] serves /api/navigation/settings
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEa][sql] time=3ms | sql=SELECT u.id as id, 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.is_root as "root", u.onboarded as "onboarded", u.homepage_type as "homepageType", u.homepage_parameter as "homepageParameter", u.organization_uuid as organizationUuid, u.last_connection_date as "lastConnectionDate", u.created_at as "createdAt", u.updated_at as "updatedAt" FROM users u WHERE u.uuid=? | params=tyler.thrailkill@company.com
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEY][sql] time=0ms | sql=SELECT u.id as id, 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.is_root as "root", u.onboarded as "onboarded", u.homepage_type as "homepageType", u.homepage_parameter as "homepageParameter", u.organization_uuid as organizationUuid, u.last_connection_date as "lastConnectionDate", u.created_at as "createdAt", u.updated_at as "updatedAt" FROM users u WHERE u.uuid=? | params=tyler.thrailkill@company.com
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEZ][sql] time=1ms | sql=SELECT u.id as id, 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.is_root as "root", u.onboarded as "onboarded", u.homepage_type as "homepageType", u.homepage_parameter as "homepageParameter", u.organization_uuid as organizationUuid, u.last_connection_date as "lastConnectionDate", u.created_at as "createdAt", u.updated_at as "updatedAt" FROM users u WHERE u.uuid=? | params=tyler.thrailkill@company.com
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEa][sql] time=1ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=organization.enabled
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEY][sql] time=0ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=organization.enabled
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEZ][sql] time=1ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=organization.enabled
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEa][sql] time=1ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=organization.default
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEY][sql] time=1ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=organization.default
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEZ][sql] time=0ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=organization.default
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEa][sql] time=1ms | sql=select org.uuid as "uuid", org.kee as "key", org.name as "name", org.description as "description", org.default_quality_gate_uuid as "defaultQualityGateUuid", org.url as "url", org.avatar_url as "avatarUrl", org.guarded as "guarded", org.subscription as "subscription", org.created_at as "createdAt", org.updated_at as "updatedAt" from organizations org where org.uuid = ? | params=AWVpQ12wv3ZX7gCqRK3c
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEY][sql] time=1ms | sql=select org.uuid as "uuid", org.kee as "key", org.name as "name", org.description as "description", org.default_quality_gate_uuid as "defaultQualityGateUuid", org.url as "url", org.avatar_url as "avatarUrl", org.guarded as "guarded", org.subscription as "subscription", org.created_at as "createdAt", org.updated_at as "updatedAt" from organizations org where org.uuid = ? | params=AWVpQ12wv3ZX7gCqRK3c
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEZ][sql] time=1ms | sql=select org.uuid as "uuid", org.kee as "key", org.name as "name", org.description as "description", org.default_quality_gate_uuid as "defaultQualityGateUuid", org.url as "url", org.avatar_url as "avatarUrl", org.guarded as "guarded", org.subscription as "subscription", org.created_at as "createdAt", org.updated_at as "updatedAt" from organizations org where org.uuid = ? | params=AWVpQ12wv3ZX7gCqRK3c
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEa][sql] time=1ms | sql=select gr.role from group_roles gr inner join groups_users gu on gr.group_id=gu.group_id where gr.organization_uuid=? and gr.resource_id is null and gu.user_id=? union select gr.role from group_roles gr where gr.organization_uuid=? and gr.group_id is null and gr.resource_id is null union select ur.role from user_roles ur where ur.organization_uuid=? and ur.user_id=? and ur.resource_id is null | params=AWVpQ12wv3ZX7gCqRK3c, 10, AWVpQ12wv3ZX7gCqRK3c, AWVpQ12wv3ZX7gCqRK3c, 10
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEZ][sql] time=16ms | sql=select gr.role from group_roles gr inner join groups_users gu on gr.group_id=gu.group_id where gr.organization_uuid=? and gr.resource_id is null and gu.user_id=? union select gr.role from group_roles gr where gr.organization_uuid=? and gr.group_id is null and gr.resource_id is null union select ur.role from user_roles ur where ur.organization_uuid=? and ur.user_id=? and ur.resource_id is null | params=AWVpQ12wv3ZX7gCqRK3c, 10, AWVpQ12wv3ZX7gCqRK3c, AWVpQ12wv3ZX7gCqRK3c, 10
2019.06.06 20:30:17 TRACE web[AWsuaOlQAn62Y59NAAEY][sql] time=16ms | sql=select gr.role from group_roles gr inner join groups_users gu on gr.group_id=gu.group_id where gr.organization_uuid=? and gr.resource_id is null and gu.user_id=? union select gr.role from group_roles gr where gr.organization_uuid=? and gr.group_id is null and gr.resource_id is null union select ur.role from user_roles ur where ur.organization_uuid=? and ur.user_id=? and ur.resource_id is null | params=AWVpQ12wv3ZX7gCqRK3c, 10, AWVpQ12wv3ZX7gCqRK3c, AWVpQ12wv3ZX7gCqRK3c, 10
2019.06.06 20:30:18 TRACE web[AWsuaOlQAn62Y59NAAEb][o.s.s.u.UserSessionFilter] Thread[http-nio-0.0.0.0-9000-exec-2,5,main] serves /api/settings/values
2019.06.06 20:30:18 TRACE web[AWsuaOlQAn62Y59NAAEb][sql] time=1ms | sql=SELECT u.id as id, 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.is_root as "root", u.onboarded as "onboarded", u.homepage_type as "homepageType", u.homepage_parameter as "homepageParameter", u.organization_uuid as organizationUuid, u.last_connection_date as "lastConnectionDate", u.created_at as "createdAt", u.updated_at as "updatedAt" FROM users u WHERE u.uuid=? | params=tyler.thrailkill@company.com
2019.06.06 20:30:18 TRACE web[AWsuaOlQAn62Y59NAAEb][sql] time=2ms | sql=select p.prop_key as "key", p.is_empty as empty, p.text_value as textValue, p.clob_value as clobValue, p.resource_id as resourceId, p.user_id as userId from properties p where p.prop_key in ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) and p.resource_id is null and p.user_id is null order by p.id | params=email.from, email.fromName, email.prefix, email.smtp_host.secured, email.smtp_password.secured, email.smtp_port.secured, email.smtp_secure_connection.secured, email.smtp_username.secured, sonar.branch.longLivedBranches.regex, sonar.builtInQualityProfiles.disableNotificationOnUpdate, sonar.core.serverBaseURL, sonar.cpd.cross_project, sonar.dbcleaner.daysBeforeDeletingClosedIssues, sonar.dbcleaner.daysBeforeDeletingInactiveShortLivingBranches, sonar.dbcleaner.hoursBeforeKeepingOnlyOneSnapshotByDay, sonar.dbcleaner.weeksBeforeDeletingAllSnapshots, sonar.dbcleaner.weeksBeforeKeepingOnlyAnalysesWithVersion, sonar.dbcleaner.weeksBeforeKeepingOnlyOneSnapshotByMonth, sonar.dbcleaner.weeksBeforeKeepingOnlyOneSnapshotByWeek, sonar.issues.defaultAssigneeLogin, sonar.leak.period, sonar.lf.aboutText, sonar.lf.enableGravatar, sonar.lf.gravatarServerUrl, sonar.lf.logoUrl, sonar.lf.logoWidthPx
2019.06.06 20:30:18 TRACE web[AWsuaOlQAn62Y59NAAEb][sql] time=1ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=organization.enabled
2019.06.06 20:30:18 TRACE web[AWsuaOlQAn62Y59NAAEb][sql] time=0ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=organization.default
2019.06.06 20:30:18 TRACE web[AWsuaOlQAn62Y59NAAEb][sql] time=1ms | sql=select org.uuid as "uuid", org.kee as "key", org.name as "name", org.description as "description", org.default_quality_gate_uuid as "defaultQualityGateUuid", org.url as "url", org.avatar_url as "avatarUrl", org.guarded as "guarded", org.subscription as "subscription", org.created_at as "createdAt", org.updated_at as "updatedAt" from organizations org where org.uuid = ? | params=AWVpQ12wv3ZX7gCqRK3c
2019.06.06 20:30:18 TRACE web[AWsuaOlQAn62Y59NAAEb][sql] time=1ms | sql=select gr.role from group_roles gr inner join groups_users gu on gr.group_id=gu.group_id where gr.organization_uuid=? and gr.resource_id is null and gu.user_id=? union select gr.role from group_roles gr where gr.organization_uuid=? and gr.group_id is null and gr.resource_id is null union select ur.role from user_roles ur where ur.organization_uuid=? and ur.user_id=? and ur.resource_id is null | params=AWVpQ12wv3ZX7gCqRK3c, 10, AWVpQ12wv3ZX7gCqRK3c, AWVpQ12wv3ZX7gCqRK3c, 10
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEc][o.s.s.u.UserSessionFilter] Thread[http-nio-0.0.0.0-9000-exec-1,5,main] serves /api/system/upgrades
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEc][sql] time=1ms | sql=SELECT u.id as id, 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.is_root as "root", u.onboarded as "onboarded", u.homepage_type as "homepageType", u.homepage_parameter as "homepageParameter", u.organization_uuid as organizationUuid, u.last_connection_date as "lastConnectionDate", u.created_at as "createdAt", u.updated_at as "updatedAt" FROM users u WHERE u.uuid=? | params=tyler.thrailkill@company.com
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][o.s.s.u.UserSessionFilter] Thread[http-nio-0.0.0.0-9000-exec-3,5,main] serves /api/system/info
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][sql] time=0ms | sql=SELECT u.id as id, 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.is_root as "root", u.onboarded as "onboarded", u.homepage_type as "homepageType", u.homepage_parameter as "homepageParameter", u.organization_uuid as organizationUuid, u.last_connection_date as "lastConnectionDate", u.created_at as "createdAt", u.updated_at as "updatedAt" FROM users u WHERE u.uuid=? | params=tyler.thrailkill@company.com
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][sql] time=0ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=organization.enabled
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][sql] time=0ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=organization.default
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][sql] time=1ms | sql=select org.uuid as "uuid", org.kee as "key", org.name as "name", org.description as "description", org.default_quality_gate_uuid as "defaultQualityGateUuid", org.url as "url", org.avatar_url as "avatarUrl", org.guarded as "guarded", org.subscription as "subscription", org.created_at as "createdAt", org.updated_at as "updatedAt" from organizations org where org.uuid = ? | params=AWVpQ12wv3ZX7gCqRK3c
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][sql] time=0ms | sql=select gr.role from group_roles gr inner join groups_users gu on gr.group_id=gu.group_id where gr.organization_uuid=? and gr.resource_id is null and gu.user_id=? union select gr.role from group_roles gr where gr.organization_uuid=? and gr.group_id is null and gr.resource_id is null union select ur.role from user_roles ur where ur.organization_uuid=? and ur.user_id=? and ur.resource_id is null | params=AWVpQ12wv3ZX7gCqRK3c, 10, AWVpQ12wv3ZX7gCqRK3c, AWVpQ12wv3ZX7gCqRK3c, 10
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][sql] time=0ms | sql=select 1
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][es] ES cluster stats request | time=6ms
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][es] ES indices stats request | time=8ms
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][sql] time=2ms | sql=select p.prop_key as "key", p.is_empty as empty, p.text_value as textValue, p.clob_value as clobValue, p.resource_id as resourceId, p.user_id as userId from properties p where p.resource_id is null and p.user_id is null
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][es] ES cluster stats request | time=5ms
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][es] ES nodes stats request | time=6ms
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][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.resource_id as resourceId, p.user_id as userId from properties p where p.prop_key=? and p.resource_id is null and p.user_id is null | params=sonar.core.id
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][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.resource_id as resourceId, p.user_id as userId from properties p where p.prop_key=? and p.resource_id is null and p.user_id is null | params=sonar.forceAuthentication
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][s.n.w.p.h.HttpURLConnection] ProxySelector Request for http://127.0.0.1:39416/systemInfo
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][s.n.w.p.h.HttpURLConnection] Proxy used: DIRECT
2019.06.06 20:30:19 DEBUG web[AWsuaOlQAn62Y59NAAEd][s.n.w.p.h.HttpURLConnection] sun.net.www.MessageHeader@3ab7a7f45 pairs: {GET /systemInfo HTTP/1.1: null}{User-Agent: SonarQube 7.7.0.23042 # A0AC3C2E-AWVpQ2uHv3ZX7gCqRLMx Java/1.8.0_131}{Host: 127.0.0.1:39416}{Accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2}{Connection: keep-alive}
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][s.n.w.p.h.HttpURLConnection] KeepAlive stream used: http://127.0.0.1:39416/systemInfo
2019.06.06 20:30:19 DEBUG web[AWsuaOlQAn62Y59NAAEd][s.n.w.p.h.HttpURLConnection] sun.net.www.MessageHeader@43da8be65 pairs: {null: HTTP/1.1 200 OK}{Content-Type: application/x-protobuf}{Date: Thu, 6 Jun 2019 20:30:19 GMT}{Connection: keep-alive}{Content-Length: 8716}
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][sql] time=1ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=sonarsource.license
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][es] ES search request 'SearchRequest{searchType=QUERY_THEN_FETCH, indices=[users], indicesOptions=IndicesOptions[ignore_unavailable=false, allow_no_indices=true, expand_wildcards_open=true, expand_wildcards_closed=false, allow_aliases_to_multiple_indices=true, forbid_closed_indices=true, ignore_aliases=false, ignore_throttled=true], types=[user], routing='null', preference='null', requestCache=null, scroll=null, maxConcurrentShardRequests=0, batchedReduceSize=512, preFilterShardSize=128, allowPartialSearchResults=null, source={"from":0,"size":1,"query":{"bool":{"must":[{"match_all":{"boost":1.0}}],"filter":[{"bool":{"must":[{"term":{"active":{"value":true,"boost":1.0}}}],"adjust_pure_negative":true,"boost":1.0}}],"adjust_pure_negative":true,"boost":1.0}},"sort":[{"name":{"order":"asc"}}]}}' on indices '[users]' on types '[user]' | time=3ms
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][es] ES search request 'SearchRequest{searchType=QUERY_THEN_FETCH, indices=[projectmeasures], indicesOptions=IndicesOptions[ignore_unavailable=false, allow_no_indices=true, expand_wildcards_open=true, expand_wildcards_closed=false, allow_aliases_to_multiple_indices=true, forbid_closed_indices=true, ignore_aliases=false, ignore_throttled=true], types=[auth], routing='null', preference='null', requestCache=null, scroll=null, maxConcurrentShardRequests=0, batchedReduceSize=512, preFilterShardSize=128, allowPartialSearchResults=null, source={"size":0,"query":{"bool":{"adjust_pure_negative":true,"boost":1.0}},"_source":false,"aggregations":{"languages":{"terms":{"field":"languages","size":500,"min_doc_count":1,"shard_min_doc_count":0,"show_term_doc_count_error":false,"order":[{"_count":"desc"},{"_key":"asc"}]}},"nclocLanguageDistribution":{"nested":{"path":"nclocLanguageDistribution"},"aggregations":{"nclocLanguageDistribution_terms":{"terms":{"field":"nclocLanguageDistribution.language","size":500,"min_doc_count":1,"shard_min_doc_count":0,"show_term_doc_count_error":false,"order":[{"_count":"desc"},{"_key":"asc"}]},"aggregations":{"nclocLanguageDistribution.ncloc":{"sum":{"field":"nclocLanguageDistribution.ncloc"}}}}}},"ncloc":{"nested":{"path":"measures"},"aggregations":{"ncloc_filter":{"filter":{"term":{"measures.key":{"value":"ncloc","boost":1.0}}},"aggregations":{"ncloc_filter_sum":{"sum":{"field":"measures.value"}}}}}}}}}' on indices '[projectmeasures]' on types '[auth]' | time=3ms
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][sql] time=1ms | sql=select count(pb.uuid) from project_branches pb where pb.uuid <> pb.project_uuid
2019.06.06 20:30:19 TRACE web[AWsuaOlQAn62Y59NAAEd][sql] time=4ms | 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.id = lm.metric_id inner join projects p on p.uuid = lm.component_uuid inner join project_branches b on b.uuid = p.uuid WHERE m.name = ? and p.enabled = true and p.scope = 'PRJ' and p.qualifier = 'TRK' and p.copy_component_uuid is null and p.organization_uuid = ? and b.branch_type = ? and b.key_type = ? group by b.project_uuid ) sumncloc | params=ncloc, AWVpQ12wv3ZX7gCqRK3c, LONG, BRANCH
2019.06.06 20:30:22 TRACE web[AWsuaOlQAn62Y59NAAEe][o.s.s.u.UserSessionFilter] Thread[http-nio-0.0.0.0-9000-exec-4,5,main] serves /api/system/change_log_level
2019.06.06 20:30:22 TRACE web[AWsuaOlQAn62Y59NAAEe][sql] time=1ms | sql=SELECT u.id as id, 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.is_root as "root", u.onboarded as "onboarded", u.homepage_type as "homepageType", u.homepage_parameter as "homepageParameter", u.organization_uuid as organizationUuid, u.last_connection_date as "lastConnectionDate", u.created_at as "createdAt", u.updated_at as "updatedAt" FROM users u WHERE u.uuid=? | params=tyler.thrailkill@company.com
2019.06.06 20:30:22 TRACE web[AWsuaOlQAn62Y59NAAEe][sql] time=1ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=organization.enabled
2019.06.06 20:30:22 TRACE web[AWsuaOlQAn62Y59NAAEe][sql] time=0ms | sql=select kee as "key", is_empty as empty, text_value as value, created_at as createdAt from internal_properties where kee in ( ? ) | params=organization.default
2019.06.06 20:30:22 TRACE web[AWsuaOlQAn62Y59NAAEe][sql] time=1ms | sql=select org.uuid as "uuid", org.kee as "key", org.name as "name", org.description as "description", org.default_quality_gate_uuid as "defaultQualityGateUuid", org.url as "url", org.avatar_url as "avatarUrl", org.guarded as "guarded", org.subscription as "subscription", org.created_at as "createdAt", org.updated_at as "updatedAt" from organizations org where org.uuid = ? | params=AWVpQ12wv3ZX7gCqRK3c
2019.06.06 20:30:22 TRACE web[AWsuaOlQAn62Y59NAAEe][sql] time=1ms | sql=select gr.role from group_roles gr inner join groups_users gu on gr.group_id=gu.group_id where gr.organization_uuid=? and gr.resource_id is null and gu.user_id=? union select gr.role from group_roles gr where gr.organization_uuid=? and gr.group_id is null and gr.resource_id is null union select ur.role from user_roles ur where ur.organization_uuid=? and ur.user_id=? and ur.resource_id is null | params=AWVpQ12wv3ZX7gCqRK3c, 10, AWVpQ12wv3ZX7gCqRK3c, AWVpQ12wv3ZX7gCqRK3c, 10
2019.06.06 20:30:22 INFO  web[AWsuaOlQAn62Y59NAAEe][o.s.s.l.ServerLogging] Level of logs changed to INFO

I’m not sure how that component got in the state it is in, but it appears that the problem lies in this section of code.

resources is able to contain null elements, since they are not filtered out. Then later no check is done to see if the element is null before attempting to access it

Fun fact, this is something Kotlin would prevent! :smiley: (just messing with ya)

Any steps to get around this until this is fixed in sonar’s source would be helpful. Do I need to dig in and delete that component manually using SQL?

Hello Tyler,

Could you share your path to SQ 7.7.0.23042 please?
Is it the first version you installed? Did you migrate to some previous version? versions?
This information may help us track where the undeletable branch is coming from.

Thanks!

Hi Sébastien,

What do you mean by path? And yes we recently migrated from an older version of sonar. Let me see if I can get our devops engineer in here. He has a bit more information.

The path we have the service installed in is /opt/services/sonar/

We migrated from 6.7.5 LTS to 7.7.0 on May 9, 2019 and this is the first issue we’ve had with it since the upgrade.

Hi guys,

He’s not looking for your file system path, rather he’s asking whether your 7.7 is a fresh install or you upgraded to it (your metaphorical path/journey to 7.7 :slight_smile:).

 
Ann

Hi Phil,

Thanks for responding with the right info even though my question wasn’t so clear (and thanks @ganncamp for clarifying it).

I’m investigating the cause of this “undeletable branch”. I also believe this “undeletable branch” is the cause of the error when updating the project key. Kudos to @Tyler_Thrailkill for his great investigation.

This investigation is tracked by SONAR-12146 and will be fixed in 7.8.

Cheers,

Thanks for the link to that issue @sns-seb.

We ran the sql query here and deleted the rows that it provided. This appears to have solved the issue we were having.

1 Like