Repeatable bug: SQLite errors when running a concordance on NABRE

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.
This is my personal Faithlife account. On 1 March 2022, I started working for Faithlife, and have a new 'official' user account. Posts on this account shouldn't be taken as official Faithlife views!
Comments
-
I've reported this bug.
0 -
Any news? This bug still exists!
0 -
I'm having this problem too and now it is May of 2017.
0 -
I get a failure on this resource also along with RSVCE, RSV2CE, complaining of UNIQUE constraint failed.
4300.Logos Log Files-NABRE.zip
0 -
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?
0 -
BUMP
0 -
Good luck! I gave up on this, and on reporting any other bugs to FL, , a LONG time ago.
0