Uploaded image for project: 'MusicBrainz Search Server'
  1. MusicBrainz Search Server
  2. SEARCH-429

Index building hangs while building place index after upgrading to schema version 23

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2018-05-06 Last Lucene
    • None
    • None
    • None

      I upgraded my non-replicated private database (used for testing purposes) using upgrade.sh

      After upgrading to DATABASE SCHEMA VERSION 23, index building hangs while building the place index.

      SEARCH Server version:
      sme@nrl ~/search $ git branch -v

      • master e11706f Re-enable init flag to check for deciding between mmp and nfio

      sme@nrl ~ $ java -Xmx512M -jar search/index/target/index-2.0-SNAPSHOT-jar-with-dependencies.jar ....
      .....
      .....
      place:Started at 15:56:32
      Exception in thread "main" org.postgresql.util.PSQLException: ERROR: type "earth" 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:336)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:235)
      at org.musicbrainz.search.index.PlaceIndex.getMaxId(PlaceIndex.java:73)
      at org.musicbrainz.search.index.IndexBuilder.buildDatabaseIndex(IndexBuilder.java:266)
      at org.musicbrainz.search.index.IndexBuilder.main(IndexBuilder.java:164)
      area:1 db rows:1 lucene docs
      area:Finished Optimization:0.0 secs

            rob Robert Kaye
            akhma Kinira Pura
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                2018-05-06 Last Lucene