Grails hibernate/Searchable通过给出下面的异常来停止服务器启动

Question

我们在Grails应用程序中使用Grails 2.1.1和Searchable插件0.6.4，并在一些域上实现了Searchable，这些域的所有映射如下所示。

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
      ......
}

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

当我们在table user with relationship

中有下面的drowslike时，问题就开始了

User a1 -> UserEducations b1 -> Schools d1

和

用户a2 -> UserEducations b2 -> Schools d1

或

User a1 -> UserWorkings c1 -> Organizations e1

和

User a2 -> UserWorkings c2 -> Organizations e1

(我们不确定上述事实可能是由于大no而发生的问题。的数据。)

然后当我们尝试启动服务器时，我们收到以下异常，服务器不会启动

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

服务器只在截断上述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。

mirrorChanges = false
bulkIndexOnStartup = false

在中:

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()
   }
}