Hello, we are using Orthanc 22.12.2 for Windows. Our MySQL database ‘orthanc_db’ has 1.52 TB in studies. The database is functioning since I can access it normally with MySQL-Front. However, the ORTHANC service does not start. The log shows the following line: ‘E1214 08:06:57.308056 main.cpp:2074] Uncaught exception, stopping now: [Error with the database engine] (code 11) W1214 08:06:57.308056 main.cpp:2105] Orthanc has stopped.’ Can someone help me? Thank you very much
Hi Alberto,
Why don’t you share and analyse your full logs and not only the last 2 lines ?
Regards,
Alain
this log:
W1214 08:06:53.480500 main.cpp:2017] Orthanc version: 1.11.2
W1214 08:06:53.480500 OrthancConfiguration.cpp:107] Scanning folder “Configuration” for configuration files
W1214 08:06:53.480500 OrthancConfiguration.cpp:56] Reading the configuration from: “Configuration\azure.json”
W1214 08:06:53.480500 OrthancConfiguration.cpp:56] Reading the configuration from: “Configuration\delayed-deletion.json”
W1214 08:06:53.480500 OrthancConfiguration.cpp:56] Reading the configuration from: “Configuration\dicomweb.json”
W1214 08:06:53.480500 OrthancConfiguration.cpp:56] Reading the configuration from: “Configuration\housekeeper.json”
W1214 08:06:53.480500 OrthancConfiguration.cpp:56] Reading the configuration from: “Configuration\indexer.json”
W1214 08:06:53.480500 OrthancConfiguration.cpp:56] Reading the configuration from: “Configuration\mysql.json”
W1214 08:06:53.480500 OrthancConfiguration.cpp:56] Reading the configuration from: “Configuration\odbc.json”
W1214 08:06:53.480500 OrthancConfiguration.cpp:56] Reading the configuration from: “Configuration\orthanc-explorer-2.json”
W1214 08:06:53.480500 OrthancConfiguration.cpp:56] Reading the configuration from: “Configuration\orthanc.json”
W1214 08:06:53.480500 OrthancConfiguration.cpp:56] Reading the configuration from: “Configuration\postgresql.json”
W1214 08:06:53.480500 OrthancConfiguration.cpp:56] Reading the configuration from: “Configuration\serve-folders.json”
W1214 08:06:53.480500 OrthancConfiguration.cpp:56] Reading the configuration from: “Configuration\stone-webviewer.json”
W1214 08:06:53.480500 OrthancConfiguration.cpp:56] Reading the configuration from: “Configuration\tcia.json”
W1214 08:06:53.480500 OrthancConfiguration.cpp:56] Reading the configuration from: “Configuration\transfers.json”
W1214 08:06:53.480500 OrthancConfiguration.cpp:56] Reading the configuration from: “Configuration\webviewer.json”
W1214 08:06:53.480500 OrthancConfiguration.cpp:56] Reading the configuration from: “Configuration\worklists.json”
W1214 08:06:53.683601 main.cpp:911] Loading plugin(s) from: C:\Program Files\Orthanc Server\Plugins
W1214 08:06:53.683601 PluginsManager.cpp:258] Registering plugin ‘connectivity-checks’ (version 1.11.2)
W1214 08:06:53.683601 PluginsManager.cpp:258] Registering plugin ‘delayed-deletion’ (version 1.11.2)
W1214 08:06:53.683601 PluginsManager.cpp:157] DelayedDeletion - plugin is loaded but disabled (check your “DelayedDeletion.Enable” configuration)
W1214 08:06:53.683601 PluginsManager.cpp:258] Registering plugin ‘housekeeper’ (version 1.11.2)
W1214 08:06:53.683601 PluginsManager.cpp:157] Housekeeper plugin is initializing
W1214 08:06:53.683601 PluginsManager.cpp:157] Housekeeper plugin is disabled by the configuration file
W1214 08:06:53.683601 PluginsManager.cpp:258] Registering plugin ‘stone-webviewer’ (version 2.5)
W1214 08:06:53.683601 PluginsManager.cpp:258] Registering plugin ‘worklists’ (version 1.11.2)
W1214 08:06:53.683601 PluginsManager.cpp:157] Sample worklist plugin is initializing
W1214 08:06:53.683601 PluginsManager.cpp:157] Worklist server is disabled by the configuration file
W1214 08:06:53.683601 PluginsManager.cpp:258] Registering plugin ‘authorization’ (version 0.4.1)
W1214 08:06:53.683601 PluginsManager.cpp:157] Initializing the authorization plugin
W1214 08:06:53.683601 PluginsManager.cpp:157] No section “Authorization” in the configuration file, the authorization plugin is disabled
W1214 08:06:53.683601 PluginsManager.cpp:258] Registering plugin ‘Azure Blob Storage’ (version 2.1.2)
W1214 08:06:53.683601 PluginsManager.cpp:157] Azure Blob Storage plugin is initializing
W1214 08:06:53.683601 PluginsManager.cpp:157] Azure Blob Storage: no “AzureBlobStorage” section found in configuration, plugin is disabled
W1214 08:06:53.683601 PluginsManager.cpp:258] Registering plugin ‘dicom-web’ (version 1.12)
W1214 08:06:53.683601 PluginsManager.cpp:157] URI to the DICOMweb REST API: /dicom-web/
W1214 08:06:53.683601 PluginsManager.cpp:157] DICOMWeb PublicRoot: /dicom-web/
W1214 08:06:53.683601 PluginsManager.cpp:157] URI to the WADO-URI API: /wado
W1214 08:06:53.683601 PluginsManager.cpp:258] Registering plugin ‘orthanc-explorer-2’ (version 0.5.1)
W1214 08:06:53.699227 PluginsManager.cpp:157] Root URI to the Orthanc-Explorer 2 application: /ui/
W1214 08:06:53.699227 PluginsManager.cpp:258] Registering plugin ‘gdcm’ (version 1.5)
W1214 08:06:53.699227 PluginsManager.cpp:157] Version of GDCM: 3.0.10
W1214 08:06:53.699227 PluginsManager.cpp:157] GDCM throttling is disabled
W1214 08:06:53.699227 PluginsManager.cpp:258] Registering plugin ‘indexer’ (version 1.0)
W1214 08:06:53.699227 PluginsManager.cpp:157] OrthancIndexer is disabled
W1214 08:06:53.699227 PluginsManager.cpp:258] Registering plugin ‘mysql-index’ (version 4.3)
W1214 08:06:53.714843 PluginsManager.cpp:157] The index plugin will use 1 connection(s) to the database, and will retry up to 10 time(s) in the case of a collision
W1214 08:06:53.714843 PluginsManager.cpp:258] Registering plugin ‘mysql-storage’ (version 4.3)
W1214 08:06:53.714843 PluginsManager.cpp:157] Your MySQL server cannot store DICOM files larger than 512MB
W1214 08:06:53.714843 PluginsManager.cpp:157] => Consider increasing “max_allowed_packet” in “my.cnf” if this limit is insufficient for your use
W1214 08:06:53.714843 PluginsManager.cpp:157] The storage area plugin will retry up to 10 time(s) in the case of a collision
W1214 08:06:53.714843 PluginsManager.cpp:258] Registering plugin ‘neuro’ (version 1.0)
W1214 08:06:53.714843 PluginsManager.cpp:258] Registering plugin ‘odbc-index’ (version 1.1)
W1214 08:06:53.714843 PluginsManager.cpp:157] The ODBC index is currently disabled, set “EnableIndex” to “true” in the “Odbc” section of the configuration file of Orthanc
W1214 08:06:53.714843 PluginsManager.cpp:258] Registering plugin ‘odbc-storage’ (version 1.1)
W1214 08:06:53.714843 PluginsManager.cpp:157] The ODBC storage area is currently disabled, set “EnableStorage” to “true” in the “Odbc” section of the configuration file of Orthanc
W1214 08:06:53.714843 PluginsManager.cpp:258] Registering plugin ‘postgresql-index’ (version 4.0)
W1214 08:06:53.714843 PluginsManager.cpp:157] The PostgreSQL index is currently disabled, set “EnableIndex” to “true” in the “PostgreSQL” section of the configuration file of Orthanc
W1214 08:06:53.714843 PluginsManager.cpp:258] Registering plugin ‘postgresql-storage’ (version 4.0)
W1214 08:06:53.714843 PluginsManager.cpp:157] The PostgreSQL storage area is currently disabled, set “EnableStorage” to “true” in the “PostgreSQL” section of the configuration file of Orthanc
W1214 08:06:53.714843 PluginsManager.cpp:258] Registering plugin ‘tcia’ (version 1.1)
W1214 08:06:53.730465 PluginsManager.cpp:258] Registering plugin ‘transfers’ (version 1.3)
W1214 08:06:53.730465 PluginsManager.cpp:258] Registering plugin ‘web-viewer’ (version 2.8)
W1214 08:06:53.730465 PluginsManager.cpp:157] Initializing the Web viewer
W1214 08:06:53.730465 PluginsManager.cpp:157] Web viewer using 6 threads for the decoding of the DICOM images
W1214 08:06:53.730465 PluginsManager.cpp:157] Storing the cache of the Web viewer in folder: e:\Orthanc\WebViewerCache
W1214 08:06:53.730465 PluginsManager.cpp:157] Web viewer using a cache of 100 MB
W1214 08:06:53.730465 PluginsManager.cpp:258] Registering plugin ‘wsi’ (version 1.1)
W1214 08:06:53.730465 PluginsManager.cpp:157] The whole-slide imaging plugin will use at most 12 threads to transcode the tiles
W1214 08:06:53.746086 PluginsManager.cpp:258] Registering plugin ‘osimis-web-viewer’ (version 1.4.2.0-9d9eff4)
W1214 08:06:53.746086 PluginsManager.cpp:157] Initializing the Web viewer
W1214 08:06:53.746086 PluginsManager.cpp:157] Using GDCM instead of the DICOM decoder that is built in Orthanc
W1214 08:06:53.746086 PluginsManager.cpp:258] Registering plugin ‘serve-folders’ (version 1.11.2)
W1214 08:06:53.746086 PluginsManager.cpp:157] ServeFolders: Empty configuration file: No additional folder will be served!
W1214 08:06:53.746086 main.cpp:1685] Using a custom database from plugins
W1214 08:06:53.746086 main.cpp:1696] Using a custom storage area from plugins
E1214 08:06:53.761680 PluginsManager.cpp:153] MySQL plugin is incompatible with database schema revision: 7
W1214 08:06:53.761680 PluginsManager.cpp:208] Unregistering plugin ‘Azure Blob Storage’ (version 2.1.2)
W1214 08:06:53.761680 PluginsManager.cpp:157] Azure Blob Storage plugin is finalizing
W1214 08:06:53.761680 PluginsManager.cpp:208] Unregistering plugin ‘authorization’ (version 0.4.1)
W1214 08:06:53.761680 PluginsManager.cpp:208] Unregistering plugin ‘connectivity-checks’ (version 1.11.2)
W1214 08:06:53.761680 PluginsManager.cpp:208] Unregistering plugin ‘delayed-deletion’ (version 1.11.2)
W1214 08:06:53.761680 PluginsManager.cpp:208] Unregistering plugin ‘dicom-web’ (version 1.12)
W1214 08:06:53.761680 PluginsManager.cpp:208] Unregistering plugin ‘gdcm’ (version 1.5)
W1214 08:06:53.777300 PluginsManager.cpp:208] Unregistering plugin ‘housekeeper’ (version 1.11.2)
W1214 08:06:53.777300 PluginsManager.cpp:157] Housekeeper plugin is finalizing
W1214 08:06:53.777300 PluginsManager.cpp:208] Unregistering plugin ‘indexer’ (version 1.0)
W1214 08:06:53.777300 PluginsManager.cpp:157] Folder indexer plugin is finalizing
W1214 08:06:53.777300 PluginsManager.cpp:208] Unregistering plugin ‘mysql-index’ (version 4.3)
W1214 08:06:53.777300 PluginsManager.cpp:157] MySQL index is finalizing
W1214 08:06:53.777300 PluginsManager.cpp:208] Unregistering plugin ‘mysql-storage’ (version 4.3)
W1214 08:06:53.777300 PluginsManager.cpp:157] MySQL storage area is finalizing
W1214 08:06:53.777300 PluginsManager.cpp:208] Unregistering plugin ‘neuro’ (version 1.0)
W1214 08:06:53.777300 PluginsManager.cpp:208] Unregistering plugin ‘odbc-index’ (version 1.1)
W1214 08:06:53.777300 PluginsManager.cpp:157] ODBC index is finalizing
W1214 08:06:53.777300 PluginsManager.cpp:208] Unregistering plugin ‘odbc-storage’ (version 1.1)
W1214 08:06:53.777300 PluginsManager.cpp:157] ODBC storage area is finalizing
W1214 08:06:53.777300 PluginsManager.cpp:208] Unregistering plugin ‘orthanc-explorer-2’ (version 0.5.1)
W1214 08:06:53.777300 PluginsManager.cpp:208] Unregistering plugin ‘osimis-web-viewer’ (version 1.4.2.0-9d9eff4)
W1214 08:06:53.777300 PluginsManager.cpp:157] Finalizing the Web viewer
W1214 08:06:53.777300 PluginsManager.cpp:208] Unregistering plugin ‘postgresql-index’ (version 4.0)
W1214 08:06:53.777300 PluginsManager.cpp:157] PostgreSQL index is finalizing
W1214 08:06:53.777300 PluginsManager.cpp:208] Unregistering plugin ‘postgresql-storage’ (version 4.0)
W1214 08:06:53.777300 PluginsManager.cpp:157] PostgreSQL storage area is finalizing
W1214 08:06:53.777300 PluginsManager.cpp:208] Unregistering plugin ‘serve-folders’ (version 1.11.2)
W1214 08:06:53.777300 PluginsManager.cpp:208] Unregistering plugin ‘stone-webviewer’ (version 2.5)
W1214 08:06:53.777300 PluginsManager.cpp:208] Unregistering plugin ‘tcia’ (version 1.1)
W1214 08:06:53.777300 PluginsManager.cpp:157] TCIA plugin is finalizing
W1214 08:06:53.777300 PluginsManager.cpp:208] Unregistering plugin ‘transfers’ (version 1.3)
W1214 08:06:53.777300 PluginsManager.cpp:157] Transfers accelerator plugin is finalizing
W1214 08:06:53.777300 PluginsManager.cpp:208] Unregistering plugin ‘web-viewer’ (version 2.8)
W1214 08:06:53.777300 PluginsManager.cpp:157] Finalizing the Web viewer
W1214 08:06:57.308056 PluginsManager.cpp:208] Unregistering plugin ‘worklists’ (version 1.11.2)
W1214 08:06:57.308056 PluginsManager.cpp:157] Sample worklist plugin is finalizing
W1214 08:06:57.308056 PluginsManager.cpp:208] Unregistering plugin ‘wsi’ (version 1.1)
E1214 08:06:57.308056 main.cpp:2074] Uncaught exception, stopping now: [Error with the database engine] (code 11)
W1214 08:06:57.308056 main.cpp:2105] Orthanc has stopped
Hello Alberto.
Update the MySQL plugin to version 5.1, you can download it from the following link: Orthanc downloads
I recently encountered a similar problem when I was experimenting with connecting two Orthanc to one database, and updating the plugin helped me.
To complement @Potopchin response:
This instance of Orthanc is running MySQL version 4.3 while it seems that another Orthanc with MySQL version 5.0 or higher has already run on this DB. Therefore, the schemas are not compatible anymore → all Orthanc instances shall run the same version of the MySQL plugin (in this case 5.0 or 5.1 - they both use the same schema)
I am using XAMPP v.3.3.0 and we haven’t modified anything. The question is: can I install the latest version of Orthanc by deleting the Orthanc Server folder manually and configuring Configuration.Json and Mysql.Json with the initial configuration we made, without losing the data stored in the database?"
That is how it is supposed to work but, since you have observed strange behaviors and do not seem to have 100% control on what happens, I would backup the data before…
Thank you for your help. I’ve tried everything, and I haven’t been able to access the stored images. While I can see the tables in the MySQL database, I can’t get it to work. I’ve chosen to reinstall the entire software and, from external sources, upload the images again, but with storage outside the database.