Uploaded image for project: 'MusicBrainz Virtual Machines'
  1. MusicBrainz Virtual Machines
  2. MBVM-34

bin/reindex crash with ERROR: column w.language does not exist

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Invalid
    • Icon: Normal 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...

            rob Robert Kaye
            invisibleman78 Invisible Man
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package