Hello I'm trying to install SQLite on the STM32F405 platform using LittleFS as the file system. I would use NOR flash memory to save the data. Creating a database and creating a table work OK. The problem arises when I go to enter data into the database. The software reads 4096 bytes from the database from address 0, and reports a "database disk image is malformed" error. The error occurs in line 67003. The log file is attached. Using the TFTP protocol, I copied the database to a PC and checked it. The database was created correctly and the "Cars" table was created correctly. I compared the 4096 bytes read when trying to write data to the table with the first 4096 bytes from the database. They are the same, no difference. The driver read the data correctly. Line 67003 is located in the SQlite3BTreeCursor function.

SQLITE_PRIVATE int sqlite3BtreeCursor( Btree p, / The btree / int iTable, / Root page of table to open / int wrFlag, / 1 to write. 0 read-only / struct KeyInfo *pKeyInfo, / First arg to xCompare() / BtCursor *pCur / Write new cursor here */ ){ int rc; if( iTable<1 ){ rc = SQLITE_CORRUPT_BKPT; //*********ERROR CODE, value of iTable is 0 }else{ sqlite3BtreeEnter(p); rc = btreeCursor(p, iTable, wrFlag, pKeyInfo, pCur); sqlite3BtreeLeave(p); }

The log file is:

------------------ SQLITE OPEN TESTSQL.DB vfsFullPathName TESTSQL.DB vfsOpen name=TESTSQL.DB flags=262 vfsSectorSize vfsSectorSize vfsRead - iAmt = 100 iOfst = 0 vfsFlushBuffer vfsRead - Short Read Error = 0 File Handle = 2000edac

------------------ PRAGMA journal_mode=OFF vfsAccess - *pResOut=0 vfsFlushBuffer vfsFileSize - filesize=0 journal_mode = off

------------------ CREATE TABLE Cars vfsDirectWrite - iAmt = 4096 iOfst = 0 vfsDirectWrite - iAmt = 4096 iOfst = 4096 vfsFlushBuffer vfsSync - retval=0

------------------ INSERT INTO Cars vfsRead - iAmt = 4096 iOfst = 0 vfsFlushBuffer vfsRead = 0 File Handle = 2000edac !!!!!!!!!!!!!! errorLogCallback funkcija (11) database corruption at line 67003 of [fb90e7189a] !!!!!!!!!!!!!! errorLogCallback funkcija (11) statement aborts at 1: [INSERT INTO Cars VALUES(1, 'Audi', 52642);] database disk image is malformed

Does anyone have any idea where the problem is.