mysql - Grails hibernate/Searchable 通过给出以下异常来停止服务器启动

Question

我们在我们的 Grails 应用程序中使用 Grails 2.1.1 和 Searchable 插件 0.6.4，并在下面用所有映射指示的某些域上实现了可搜索。

class User {
      .....
      static hasMany = [userEducations : UserEducations , userWorkings : UserWorkings ]
      ......
      static searchable = {
        content: spellCheck 'include'
        all termVector: "yes"
        userEducations  component: true
        userWorkings component: true
      }
      ......
}

class UserEducations {
    .....
    Schools schools 
    .....
    static belongsTo = [user : User ]
    ......
    static searchable = {
        content: spellCheck 'include'
        all termVector: "yes"
        schools  component: true
    }
      ......
}

class UserWorkings {
      .....
      Organizations organizations 
      .....
     static belongsTo = [user : User ]
     ....
     static searchable = {
        content: spellCheck 'include'
        all termVector: "yes"
        organizations  component: true
     }
     ......
}

class Schools {
      ......
      static searchable = true
      ......
}

class Organizations {
      ......
       static searchable = true
      ......
}

使用正确的映射和约束成功保存数据。

当我们在具有关系的表 user 中出现下面的 drowslike 时，问题就开始了

用户 a1 -> UserEducations b1 -> 学校 d1

和

用户 a2 -> UserEducations b2 -> 学校 d1

或

用户 a1 -> UserWorkings c1 -> 组织 e1

和

用户 a2 -> UserWorkings c2 -> 组织 e1

(我们不确定以上事实可能是由于数据量大导致的问题。)

然后当我们尝试启动服务器时，我们收到以下异常并且服务器无法启动

我们已经尝试删除可搜索索引并重新启动，但它也无法启动。

只有当我们截断对应于以上 5 个域的表时，服务器才会启动。

18:30:54,133 [Compass Gps Index [pool-5-thread-5]] ERROR indexer.ScrollableHibernateIndexEntitiesIndexer  - {hibernate}: Failed to index the database
org.compass.core.engine.SearchEngineException: Processor [4]: Failed to add job [Job Create [alias [Organizations] uid [Organizations#456#]] Resource [{Organizations} [stored/uncompressed,indexed,omitNorms<alias:Organizations>],[stored/uncompressed,indexed,omitNorms,omitTf<$/Organizations/id:456>],[stored/uncompressed,indexed<active:true>],[stored/uncompressed,indexed<dateCreated:2013-02-28-14-03-05-0-PM>],[stored/uncompressed,indexed,tokenized<aaa:109122482450911>],[stored/uncompressed,indexed<lastUpdated:2013-02-28-14-03-05-0-PM>],[stored/uncompressed,indexed,tokenized<name:Asc>],[stored/uncompressed,indexed<version:0>],[stored/uncompressed,indexed,omitNorms,omitTf<$/uid:Bs#456#>]]] after [10000ms] and backlog size [100]
        at org.compass.core.lucene.engine.transaction.support.AbstractConcurrentTransactionProcessor$Processor.addJob(AbstractConcurrentTransactionProcessor.java:496)
        at org.compass.core.lucene.engine.transaction.support.AbstractConcurrentTransactionProcessor.create(AbstractConcurrentTransactionProcessor.java:158)
        at org.compass.core.lucene.engine.LuceneSearchEngine.createOrUpdate(LuceneSearchEngine.java:290)
        at org.compass.core.lucene.engine.LuceneSearchEngine.create(LuceneSearchEngine.java:268)
        at org.compass.core.impl.DefaultCompassSession.create(DefaultCompassSession.java:413)
        at org.compass.core.impl.DefaultCompassSession.create(DefaultCompassSession.java:397)
        at org.compass.core.impl.ExistingCompassSession.create(ExistingCompassSession.java:305)
        at org.compass.gps.device.hibernate.indexer.ScrollableHibernateIndexEntitiesIndexer$RowBuffer.flush(ScrollableHibernateIndexEntitiesIndexer.java:212)
        at org.compass.gps.device.hibernate.indexer.ScrollableHibernateIndexEntitiesIndexer$RowBuffer.close(ScrollableHibernateIndexEntitiesIndexer.java:206)
        at org.compass.gps.device.hibernate.indexer.ScrollableHibernateIndexEntitiesIndexer.performIndex(ScrollableHibernateIndexEntitiesIndexer.java:151)
        at org.compass.gps.device.support.parallel.ConcurrentParallelIndexExecutor$1$1.doInCompassWithoutResult(ConcurrentParallelIndexExecutor.java:104)
        at org.compass.core.CompassCallbackWithoutResult.doInCompass(CompassCallbackWithoutResult.java:29)
        at org.compass.core.CompassTemplate.execute(CompassTemplate.java:133)
        at org.compass.gps.impl.SingleCompassGps.executeForIndex(SingleCompassGps.java:147)
        at org.compass.gps.device.support.parallel.ConcurrentParallelIndexExecutor$1.call(ConcurrentParallelIndexExecutor.java:102)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:679)

我们的问题类似于下面的帖子

http://grails.1312388.n4.nabble.com/hibernate-Searchable-failing-to-index-on-program-start-td4119566.html

我们已尽力解决问题，但没有成功。请帮助我们解决这个问题。

Answer 1

转到您的控制台并输入:

grails install-searchable-config

然后打开 myproject/grails-app/conf/Searchable.groovy 并搜索以下内容并按照我指出的更改值。

mirrorChanges = false
bulkIndexOnStartup = false

在 Bootstrap.groovy 中:

class BootStrap {
   def searchableService

   def init = { servletContext ->
      // do any data loading you would normally do

      // Manually start the mirroring process to ensure that it comes after the automated migrations.
      println "Performing bulk index"
      searchableService.reindex()
      println "Starting mirror service"
      searchableService.startMirroring()
   }
}