Repeatable bug: SQLite errors when running a concordance on NABRE

Page 1 of 1 (8 items)
This post has 7 Replies | 3 Followers

Posts 13312
Forum MVP
Mark Barnes | Forum Activity | Posted: Sun, Aug 28 2016 8:38 AM

When you run the concordance on NABRE, it gets about three-quarters through then returns an error: "Unable to generate concordance". The Logos log shows SQLite errors:

2016-08-28 16:32:09.9063 32 Error ApplicationUtility SQLite Error 2067: abort at 26 in [create unique index Index_WordNumberTextRanges_WordNumberId_TextRangeId on WordNumberTextRanges (WordNumberId,TextRangeId)]: UNIQUE constraint failed: WordNumberTextRanges.WordNumberId, WordNum
2016-08-28 16:32:09.9083 32 Error ApplicationUtility SQLite Error 11: database corruption at line 57527 of [fe7d3b75fe]
2016-08-28 16:32:09.9088 32 Error ApplicationUtility SQLite Error 11: database corruption at line 57569 of [fe7d3b75fe]
2016-08-28 16:32:09.9329 32 Info ConcordanceDatabaseQuerySource (4m 28.5s) Creating concordance for LLS:NABRE 2016-03-10T02:20:28Z
2016-08-28 16:32:09.9334 32 Error ConcordanceDatabaseQuerySource Error writing to database: System.Data.SQLite.SQLiteException (0x00000013): constraint failed: UNIQUE constraint failed: WordNumberTextRanges.WordNumberId, WordNumberTextRanges.TextRangeId
at System.Data.SQLite.SQLiteDataReader.ReadAsyncCore(CancellationToken cancellationToken)
at System.Data.SQLite.SQLiteDataReader.Read()
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at Libronix.Utility.Data.PoolableConnector.CacheAndExecute[T](IConnector connector, String text, Object[] parameterNamesAndValues, Func`2 execute)
at Libronix.Utility.Data.PoolableConnector.ExecuteNonQuery(String text, Object[] parameterNamesAndValues)
at LDLS4.Concordance.ConcordanceDatabaseSchema.CreateIndexes(IList`1 indexes, IConnector connector, Action`1 updateProgress, IWorkState workState)
at LDLS4.Concordance.ConcordanceDatabase.CreateDatabase(IConnector connector, ConcordanceResourceInfo resourceInfo, ConcordanceProgressStage`1 progress, ReadOnlyCollection`1 expectedHeadingKinds, ConcordanceExternalResourceInfoManager externalResourceInfoManager, IWorkState workState)
at LDLS4.Concordance.ConcordanceDatabaseQuerySource.TryCreateDatabase(CancellationToken cancellationToken)
2016-08-28 16:32:11.5727 50 Error ApplicationUtility SQLite Error 1: no such table: Info
2016-08-28 16:32:11.5737 50 Error ConcordanceDatabaseFileManager Unable to create connection to LLS_NABRE_2016_03_10T02_20_28Z.concordance: System.Data.SQLite.SQLiteException (0x00000001): SQL logic error or missing database: no such table: Info
at System.Data.SQLite.SqliteStatementPreparer.Get(Int32 index, CancellationToken cancellationToken)
at System.Data.SQLite.SQLiteDataReader.NextResultAsyncCore(CancellationToken cancellationToken)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
at Libronix.Utility.Data.PoolableConnector.CacheAndExecute[T](IConnector connector, String text, Object[] parameterNamesAndValues, Func`2 execute)
at Libronix.Utility.Data.PoolableConnector.ExecuteReader(String text, Object[] parameterNamesAndValues)
at LDLS4.Concordance.ConcordanceDatabaseSchema.IsCurrentSchemaVersion(IConnector connector, IWorkState workState)
at LDLS4.Concordance.ConcordanceDatabase.GetDatabaseStatus(IConnector connector, ConcordanceResourceInfo resourceInfo, IWorkState workState)
at LDLS4.Concordance.ConcordanceDatabaseFileManager.GetFileStatus(String fileName, String resourceId, IWorkState workState)

This is reproducible for different users on different machines.

4336.Logos.log

Posts 7953
LogosEmployee

I've reported this bug.

Posts 408
Mark Nolette | Forum Activity | Replied: Mon, Oct 3 2016 1:52 PM

Any news? This bug still exists!

Posts 17
kd8tzc | Forum Activity | Replied: Tue, May 2 2017 9:57 AM

I'm having this problem too and now it is May of 2017.

Posts 2061
Forum MVP
Randy W. Sims | Forum Activity | Replied: Fri, Oct 6 2017 8:47 AM

I get a failure on this resource also along with RSVCE, RSV2CE, complaining of UNIQUE constraint failed.

4300.Logos Log Files-NABRE.zip

8081.Logos Log Files-RSVCE.zip

2046.Logos Log Files-RSV2CE.zip

Posts 647
Kiyah | Forum Activity | Replied: Sun, Mar 25 2018 10:26 AM

I'm getting the same error with both the RSVCE and the NABRE as of March 2018. Can someone please look into this and give us an update?

Posts 647
Kiyah | Forum Activity | Replied: Mon, Mar 26 2018 7:37 AM

BUMP

Posts 408
Mark Nolette | Forum Activity | Replied: Mon, Mar 26 2018 7:53 AM

Good luck! I gave up on this, and on reporting any other bugs to FL, , a LONG time ago. 

Page 1 of 1 (8 items) | RSS