Error to acces "Measures" page

SonarQube LTS 8.9.10
PostgresSQL 13

In my sonarqbe 8.9.10 when i try acces to Measures page I get the following error above

And int the browser console

Also I looked in the web.log and this is the information that appears

2023.02.01 16:26:19 INFO  web[][o.s.s.p.Platform] WebServer is operational
2023.02.01 16:26:19 INFO  web[][o.s.s.a.p.ExpiredSessionsCleaner] Purge of expired session tokens has removed 0 elements
2023.02.01 16:26:19 INFO  web[][o.s.s.a.p.ExpiredSessionsCleaner] Purge of expired SAML message ids has removed 0 elements
2023.02.01 16:27:00 ERROR web[AYYNlf7/t6eBlMC8AAAw][o.s.s.w.WebServiceEngine] Fail to process request http://localhost:29000/api/measures/component_tree?additionalFields=metrics&ps=500&asc=false&metricSort=new_duplicated_lines_density&s=metricPeriod&metricSortFilter=withMeasuresOnly&metricPeriodSort=1&component=SSMCLOUD-Backend&metricKeys=new_duplicated_lines_density%2Cnew_duplicated_lines&strategy=leaves
org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: la página no es válida en el bloque 579 de la relación base/16396/17209
### The error may exist in org.sonar.db.measure.LiveMeasureMapper
### The error may involve org.sonar.db.measure.LiveMeasureMapper.selectTreeByQuery-Inline
### The error occurred while setting parameters
### SQL: select       lm.component_uuid as componentUuid,     lm.project_uuid as projectUuid,     lm.metric_uuid as metricUuid,     lm.value as value,     lm.text_value as textValue,     lm.measure_data as data,     lm.variation as variation     from live_measures lm     inner join components p on p.uuid = lm.component_uuid                inner join components base on base.project_uuid = p.project_uuid and base.uuid = ?               and p.uuid_path like ? ESCAPE '/'                  WHERE lm.metric_uuid in         (?,?)              and p.enabled = true                and p.qualifier in         (           ?         ,           ?         )       -- Add measures of base component     union all     select       lm.component_uuid as componentUuid,     lm.project_uuid as projectUuid,     lm.metric_uuid as metricUuid,     lm.value as value,     lm.text_value as textValue,     lm.measure_data as data,     lm.variation as variation     from live_measures lm     inner join components p on p.uuid = lm.component_uuid and lm.component_uuid = ?      WHERE lm.metric_uuid in         (?,?)              and p.enabled = true                and p.qualifier in         (           ?         ,           ?         )
### Cause: org.postgresql.util.PSQLException: ERROR: la página no es válida en el bloque 579 de la relación base/16396/17209
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.select(DefaultSqlSession.java:171)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.select(DefaultSqlSession.java:157)
	at org.apache.ibatis.binding.MapperMethod.executeWithResultHandler(MapperMethod.java:136)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:77)
	at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85)
	at com.sun.proxy.$Proxy70.selectTreeByQuery(Unknown Source)
	at org.sonar.db.measure.LiveMeasureDao.selectTreeByQuery(LiveMeasureDao.java:92)
	at org.sonar.server.measure.ws.ComponentTreeAction.searchMeasuresByComponentUuidAndMetric(ComponentTreeAction.java:516)
	at org.sonar.server.measure.ws.ComponentTreeAction.load(ComponentTreeAction.java:423)
	at org.sonar.server.measure.ws.ComponentTreeAction.doHandle(ComponentTreeAction.java:264)
	at org.sonar.server.measure.ws.ComponentTreeAction.handle(ComponentTreeAction.java:259)
	at org.sonar.server.ws.WebServiceEngine.execute(WebServiceEngine.java:110)
	at org.sonar.server.platform.web.WebServiceFilter.doFilter(WebServiceFilter.java:84)
	at org.sonar.server.platform.web.MasterServletFilter$GodFilterChain.doFilter(MasterServletFilter.java:139)
	at org.sonar.server.platform.web.SonarLintConnectionFilter.doFilter(SonarLintConnectionFilter.java:66)
	at org.sonar.server.platform.web.MasterServletFilter$GodFilterChain.doFilter(MasterServletFilter.java:139)
	at org.sonar.server.platform.web.MasterServletFilter.doFilter(MasterServletFilter.java:108)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
	at org.sonar.server.platform.web.UserSessionFilter.doFilter(UserSessionFilter.java:81)
	at org.sonar.server.platform.web.UserSessionFilter.doFilter(UserSessionFilter.java:68)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
	at org.sonar.server.platform.web.CacheControlFilter.doFilter(CacheControlFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
	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:194)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
	at org.sonar.server.platform.web.RedirectFilter.doFilter(RedirectFilter.java:58)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
	at org.sonar.server.platform.web.RequestIdFilter.doFilter(RequestIdFilter.java:66)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
	at org.sonar.server.platform.web.RootFilter.doFilter(RootFilter.java:62)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
	at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
	at ch.qos.logback.access.tomcat.LogbackValve.invoke(LogbackValve.java:256)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:364)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:624)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1651)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.postgresql.util.PSQLException: ERROR: la página no es válida en el bloque 579 de la relación base/16396/17209
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:166)
	at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:155)
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
	at org.apache.ibatis.executor.ReuseExecutor.doQuery(ReuseExecutor.java:60)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.select(DefaultSqlSession.java:169)
	... 59 common frames omitted

ERROR ### Cause: org.postgresql.util.PSQLException: ERROR: la página no es válida en el bloque 579 de la relación base/16396/17209 (### Cause: org.postgresql.util.PSQLException: ERROR: page is invalid in block 579 of relation base/16396/17209)

What is happening to me? In other project it works correctly and in this in particular it doesn’t

Regards
Salva

Hey there.

This looks like some data corruption on your database server., and probably your best options would be:

  • Restore from a backup
  • Try executing a new analysis of the project to see if it knocks the data into place
  • Delete the project and recreate it

The latter two options don’t guarantee that there isn’t an issue with other data in your database.

Hello,

Finally I have deleted the database and I have started again with the latest LTS version and with the projects that interested me.

Regards.

1 Like