SQL ERROR help us please

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
image

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

1 Like

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

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

You might find an explanation and an answer there.

e.g. Search: error code 11

/sds

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…

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.

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 ?

Hello,

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

Kind Regards,
Sébastien-

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

2 Likes