Recently rebuilt my Postgresql + Postgis database, and populate the sample metadata in the Administration page. However, I did not see any metadata records when loading the page http://localhost:8080/srv/eng/search. Looking at the log file 'catalina.out', I found the following error message, which complained "spatialindex.the_geom" does not exist. But the table 'spatialindex' and the column 'the_geom' both exist in the 'geonetwork' database. What may be wrong, and how to fix it? Thanks in advance.
2015-05-22 11:34:50,715 INFO [jeeves.request] - HTML Request (from 127.0.0.1) : /geonetwork/srv/eng/metadata.admin.index.rebuild
2015-05-22 11:34:50,716 INFO [jeeves.service] - Dispatching : metadata.admin.index.rebuild
May 22, 2015 11:34:51 AM org.geotools.data.postgis.PostGISDialect getOptimizedBounds
WARNING: Failed to use ST_Estimated_Extent, falling back on envelope aggregation
org.postgresql.util.PSQLException: ERROR: stats for "spatialindex.the_geom" do not exist
Where: SQL function "st_estimated_extent" statement 2
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.geotools.data.postgis.PostGISDialect.getOptimizedBounds(PostGISDialect.java:282)