-
Bug
-
Resolution: Invalid
-
Normal
-
None
-
None
If you try to reindex some new replicated data, you get the following crash:
release:1806041 db rows:1805995 lucene docs
release:Finished Optimization:0.0 secs
Exception in thread "main" org.postgresql.util.PSQLException: ERROR: column w.language does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at org.musicbrainz.search.index.WorkIndex.indexData(WorkIndex.java:151)
at org.musicbrainz.search.index.IndexBuilder.buildDatabaseIndex(IndexBuilder.java:275)
at org.musicbrainz.search.index.IndexBuilder.main(IndexBuilder.java:164)}}
On the console you see the line:
postgresql_1 | STATEMENT: SELECT w.id as wid, w.gid, w.name as name, wt.name as type, l.iso_code_3 as language, comment FROM work AS w LEFT JOIN work_type wt ON w.type = wt.id LEFT JOIN language l on w.language = l.id WHERE w.id BETWEEN $1 AND $2 ORDER BY w.id
Therefore it is not possible to reindex the VM actually and the script deletes the old indexes before start. You end with a non working search server...
- is related to
-
SEARCH-443 ERROR: column w.language does not exist
- Closed