Hi SQLite creators, for embedded Linux 2.6.35.3 on armV5, I get memory usage not freed at close(ltib compilation environment).
with this following test ( only one connection to the database ): 1) open database 2) prepare statement 3) SQL request inside begin commit 4) finalize statement 5) close database 6 ) loop to 1 ) the return is SQLITE_OK at each step: do{ sqlite3_open_v2(...,&db,SQLITE_OPEN_READWRITE,0); sqlite3_exec(db,"PRAGMA journal_mode = MEMORY",0,0,0); sqlite3_prepare_v2(db... sqlite3_step( statement Begin //BEGIN EXCLUSIVE TRANSACTION sqlite3_reset( statement request sqlite3_step( statement request sqlite3_column_int64( statement request sqlite3_step( statement Commit sqlite3_finalize(... sqlite3_close_v2(... }while I have got memory usage not freed after the close: the sqlite3_memory_used() give 0 before open give 127376 after the first open give 133296 after the close the sqlite3_memory_used() give 133296 before open give 260624 after the second open give 266544 after the close the sqlite3_memory_used() give 266544 before open give 393872 after the third open give 399792 after the close /proc/2365/status Tgid: 2365 Pid: 2365 PPid: 1 TracerPid: 0 Uid: 0 0 0 0 Gid: 0 0 0 0 FDSize: 32 Groups: 0 1 2 3 4 6 10 VmPeak: 3316 kB VmSize: 3316 kB VmLck: 0 kB VmHWM: 2000 kB VmRSS: 2000 kB VmData: 964 kB VmStk: 136 kB VmExe: 552 kB VmLib: 1464 kB VmPTE: 6 kB VmSwap: 0 kB Threads: 1 Tgid: 2365 Pid: 2365 PPid: 1 TracerPid: 0 Uid: 0 0 0 0 Gid: 0 0 0 0 FDSize: 32 Groups: 0 1 2 3 4 6 10 VmPeak: 3580 kB VmSize: 3580 kB VmLck: 0 kB VmHWM: 2256 kB VmRSS: 2256 kB VmData: 1228 kB VmStk: 136 kB VmExe: 552 kB VmLib: 1464 kB VmPTE: 6 kB VmSwap: 0 kB Threads: 1 inside /proc/2365/fd/ a new file descriptor is added at each open database, but never deleted at close database. same behaviour with sqlite 3.9.2 and 3.18.0 ( compiled with -DSQLITE_CORE -DNDEBUG=1 -DSQLITE_THREADSAFE=2 -DSQLITE_ENABLE_ATOMIC_WRITE -DSQLITE_DEFAULT_AUTOMATIC_INDEX=0 -DSQLITE_ENABLE_MEMORY_MANAGEMENT -DSQLITE_TEMP_STORE=3) Is any workarounds are available to close the database and freed all its memories allocated by sqlite inside the same application (without restart the application process)? Regards, Stephane _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users