Details
-
Type:
Bug
-
Status:
Reopened
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: freeswitch-core
-
Labels:None
-
Environment:W2K8
-
Platform:Win32_64/VS
-
Uname:NA
-
CPU Info:NA
-
GCC Version:NA
-
FreeSWITCH GIT Revision:992e05667cbf72251504d93625f0c01ef20ac792
-
Reproduced with GIT HEAD?:Yes
Description
Hi,
I encountered SQLite database corruption several times. In that case, DB queries work but any modification fails with an error "database disk image is malformed".
This is a deadlock situation, because FS continues to run, but fails in almost every operation. Even a FS restart doesn't solve the problem.
The attached patch uses SQLite integrity_check on startup to detect this corruption, and if corrupted it deletes the DB file and recreates a new empty DB.
Thanks,
Ron
I encountered SQLite database corruption several times. In that case, DB queries work but any modification fails with an error "database disk image is malformed".
This is a deadlock situation, because FS continues to run, but fails in almost every operation. Even a FS restart doesn't solve the problem.
The attached patch uses SQLite integrity_check on startup to detect this corruption, and if corrupted it deletes the DB file and recreates a new empty DB.
Thanks,
Ron