ERROR: index "idx_event_time" contains unexpected zero page at block xxxx

Issue

• We are getting the following error:

WARN  [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (default task-7) IJ000305: Connection error occured: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@e3e33b33[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@ connection handles=1 lastReturned=1653499758700 lastValidated=1653499307069 lastCheckedOut=1653499758769 trackByTx=true pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@333eb888 mcp=SemaphoreConcurrentLinkedQueueManagedConnectionPool@3333fd1b[pool=sso_psql] xaResource=XAResourceWrapperImpl@1f22e333[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@3cbb44c5 pad=false overrideRmValue=null productName=PostgreSQL productVersion=9.5.14 jndiName=java:jboss/datasources/KeycloakDS] txSync=TransactionSynchronization@123456789{tx=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffff0a0112c3:-45cc6adf:789e1234:1234 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) wasTrackByTx=true enlisted=true cancel=false}]: org.postgresql.util.PSQLException: ERROR: index "idx_event_time" contains unexpected zero page at block 2809
  Hint: Please REINDEX it.
    at org.postgresql@42.2.3//org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
    at org.postgresql@42.2.3//org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
    at org.postgresql@42.2.3//org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
    at org.postgresql@42.2.3//org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
    at org.postgresql@42.2.3//org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
    at org.postgresql@42.2.3//org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:150)
    at org.postgresql@42.2.3//org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:127)
    at jdk.internal.reflect.GeneratedMethodAccessor515.invoke(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.postgresql@42.2.3//org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:428)
    at org.postgresql@42.2.3//com.sun.proxy.$Proxy97.executeUpdate(Unknown Source)
    at org.jboss.ironjacamar.jdbcadapters@1.4.22.Final-redhat-00001//org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537)
    at org.hibernate@5.3.20.Final-redhat-00001//org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)
    at org.hibernate@5.3.20.Final-redhat-00001//org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3192)
    ...