Orthanc 1.9.4 problem with MySQL for Index

[Jay Sridhar]

We have setup an Orthanc server using MySQL for the index. After storing some files (by transferring from another Orthanc server using ImportDicomFiles.py in the distribution), we are getting the following results when looking for changes with http://server:8043/changes.

Note that date and ID are interchanged in the output. 

"Changes" :

   [

      {

         "ChangeType" : "NewInstance",

         "Date" : "c9380cf1-c6ac9d91-bfe3d34a-b44be77d-6df6a6f9",

         "ID" : "20210721T075532",

         "Path" : "/instances/20210721T075532",

         "ResourceType" : "Instance",

         "Seq" : 1

      },

      {

         "ChangeType" : "NewSeries",

         "Date" : "643820ed-a1a196ca-3fcb3829-d15ca4d0-fe4d3137",

         "ID" : "20210721T075532",

         "Path" : "/series/20210721T075532",

         "ResourceType" : "Series",

         "Seq" : 2

      },

...

Any reason why this might be happening? This did not happen with the default SQLite index.

Thanks in advance.

[Alain Mazy]

Hi Jay,

I confirm your findings and I've logged the issue in our bug tracker: https://bugs.orthanc-server.com/show_bug.cgi?id=200

Right now, v 4.1 of the plugin does not seem to be affected by the issue.

Please note that it is holiday season for Sébastien and myself so it's hard to tell when we'll look at it.

Best regards,

Alain.

--
You received this message because you are subscribed to the Google Groups "Orthanc Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orthanc-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orthanc-users/62cc2944-01f4-45f9-b4f3-e975b4838cban%40googlegroups.com.

[Sébastien Jodogne]

Hello,

Thanks for the report. The issue is now fixed in the mainline by the following changeset:

https://hg.orthanc-server.com/orthanc-databases/rev/4454545bb265

I will do my best to provide a quick MySQL 4.3 release in the next few hours, but I will not be able to make a full release of macOS and Windows packages before August.

Sébastien-

[Jay Sridhar]

Fantastic! Thanks. I will wait for the 4.2 fix, and in the meantime try with 4.1

[Alain Mazy]

Hi Jay,

The plugin MySQL 4.3 has now been released and is available in Docker images osimis/orthanc:21.7.4.

Best regards,

Alain

To view this discussion on the web visit https://groups.google.com/d/msgid/orthanc-users/d0348833-9fc9-4ecf-aca2-d9e30b211017n%40googlegroups.com.

[Jay Sridhar]

Great! I downloaded the earlier MySQL 4.3 plugin, and it worked fine. So I will now upgrade to the released version.

Thanks once again! Great work.