SQL ERROR help us please

[Enkhsaikhan]

Hello
our pacs not working anymore how to fix please help
The server’s RAID 5 config 1 hdd is failed and we replaced it

C-FIND request handler has failed: sqlite: cannot step over a cached statement
E0621 10:51:05.516484 Statement.cpp:87] SQLite error code 10

[alainmazy]

Hi,

SQLite error code 10, as a simple web search tells you, means disk IO error or sharing conflict.
You very likely have an old Orthanc process still running with this file open.

HTH,

Alain

[Enkhsaikhan]

now its says SQLite error code 11 my english is not good can someone explain me simple words to fix this

[sdscotti]

Start by just searching the prior posts on this forum. It has the legacy Google posts present also:

Uncaught exception, stopping now: [Error with the database engine] (code 11)

HI , I am configuring MySQL database with Dicom server, for that, I changed in mysql.json file in the /server/Configuration folder .below is my file . ` { “MySQL” : { “EnableIndex” : true, “EnableStorage” : true, “Host” : “127.0.0.1”, // For TCP connections (notably Windows) “Port” : 3306, // For TCP connections (notably Windows) “UnixSocket” : “/var/run/mysqld/mysqld.sock”, // For UNIX on localhost “Database” : “orthanc”, “Username” : “orthanc”, “Password” : “orthanc”, “Lock” : fa…

You might find an explanation and an answer there.

e.g. Search: error code 11

/sds

[alainmazy]

@Enkhsaikhan

now its says SQLite error code 11 my english is not good can someone explain me simple words to fix this

Error 11 means “corrupted file”: Result and Error Codes

Besides restoring a backup or reimporting the whole DB, I don’t see a lot of options…

[Maksym_Kozub]

@alainmazy

Besides restoring a backup or reimporting the whole DB, I don’t see a lot of options…

I agree in general, but if the latest backup is not very recent etc., then I might try and use some SQLite viewer on that corrupted DB. I think there is a non-zero chance (although a small one) to recover some studies.

[Enkhsaikhan]

index file is corrupted and we’re trying to recovering them but it look like impossible do guys have any solutions on this ?
maybe we can restore it if we use ImportDicomFiles.py ?

[jodogne]

Hello,

@Enkhsaikhan

maybe we can restore it if we use ImportDicomFiles.py ?

Yes, this is exactly what you should do, as explained in the Orthanc Book.

Kind Regards,
Sébastien-

[Enkhsaikhan]

thanks to you all we’ve recovered db and bought new storage server and we are using postgresql now
thats better i think