Hi, This is exception is not from Lucene, it is from H2. If you have a reproducible test case where such a corrupt database can be created, that would be great. At least I would need to know the database URL, the size of the database file, the Java version, and the stack trace.
Regards, Thomas On Wednesday, March 1, 2017, Sylvain Pointeau <[email protected]> wrote: > Hi Dmitry, > > Yes thank you it works :-) > > Do you know if this is reliable to use Lucene in H2? I just had an > exception this morning. (from a database 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.newIl > legalStateException(DataUtils.java:765) > > Best regards, > Sylvain > > > > > On Wed, Mar 1, 2017 at 12:37 PM, Дмитрий Моряков <[email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > >> Sylvain, if you are using direct SQL query, you may try smth like that: >> SELECT QUERY, SCORE FROM FTL_SEARCH('search string', 1000, 0) ORDER BY >> SCORE DESC >> where 1000 - number of rows to fetch, 0 - offset >> >> HTH >> >> Regards, >> -- >> Dmitry >> >> -- >> 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] >> <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> >> . >> To post to this group, send email to [email protected] >> <javascript:_e(%7B%7D,'cvml','[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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[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.
