Hi Thomas, Additionally I just noticed that FTL_SEARCH(_DATA) returns only 100 records. is it something we can configure? I did not see any information in H2 documentation or google
Best regards, Sylvain On Wed, Mar 1, 2017 at 10:58 AM, Sylvain Pointeau < [email protected]> wrote: > Hi Thomas, > > Thank you for your reply, this morning, I re-opened my DB (created > yesterday) > > [2017-03-01 10:10:41] [HY000][50000] General error: > "java.lang.IllegalStateException: > Chunk 5451 no longer exists [1.4.193/9]" [50000-193] > [2017-03-01 10:10:41] java.lang.IllegalStateException: Chunk 5451 no > longer exists [1.4.193/9] > [2017-03-01 10:10:41] at org.h2.mvstore.DataUtils. > newIllegalStateException(DataUtils.java:765) > [2017-03-01 10:10:41] at org.h2.mvstore.MVStore. > getChunkIfFound(MVStore.java:955) > [2017-03-01 10:10:41] at org.h2.mvstore.MVStore. > getChunk(MVStore.java:937) > [2017-03-01 10:10:41] at org.h2.mvstore.MVStore. > readPage(MVStore.java:1945) > [2017-03-01 10:10:41] at org.h2.mvstore.MVMap.readPage(MVMap.java:736) > [2017-03-01 10:10:41] at org.h2.mvstore.Page. > getChildPage(Page.java:217) > [2017-03-01 10:10:41] at org.h2.mvstore.Cursor. > fetchNext(Cursor.java:150) > [2017-03-01 10:10:41] at org.h2.mvstore.Cursor.next(Cursor.java:50) > [2017-03-01 10:10:41] at org.h2.mvstore.MVMap$2$1.next(MVMap.java:879) > [2017-03-01 10:10:41] at org.h2.mvstore.MVMap$2$1.next(MVMap.java:870) > [2017-03-01 10:10:41] at org.h2.store.LobStorageMap. > init(LobStorageMap.java:107) > [2017-03-01 10:10:41] at org.h2.engine.Database.open( > Database.java:790) > [2017-03-01 10:10:41] at org.h2.engine.Database. > openDatabase(Database.java:273) > [2017-03-01 10:10:41] at org.h2.engine.Database.<init>( > Database.java:267) > ... > > I am not sure I can really use the FTS if the DB is not reliable anymore... > > Best regards, > Sylvain > > > On Wed, Mar 1, 2017 at 7:46 AM, Thomas Mueller Graf < > [email protected]> wrote: > >> Hi, >> >> Patches to upgrade Lucene are welcome. >> >> Regards, >> Thomas >> >> >> On Tuesday, February 28, 2017, Sylvain Pointeau < >> [email protected]> wrote: >> >>> Hello, >>> >>> I tried using the native full text search on my db but from 2 GB, it >>> grew up to +12GB, I had to stop the index creation. >>> So I tried Lucene and the database grew up to almost 6GB. Advantage of >>> Lucene is that we can query with wildcards. >>> >>> now my question: why are you still using version 3.6.2? they are now up >>> to the version 6. >>> Is it possible to upgrade somehow? >>> >>> Best regards, >>> Sylvain >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "H2 Database" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at https://groups.google.com/group/h2-database. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at https://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
