Hello Marcel.
Sorry, this is all there is in the previous log files....but please read on.
Interesting thing is, that when I "fixed" the issue with another system trying to store images with already existing images from another patient on the same image UID then the system is no longer getting up to 100% cpu.
This Conquest server is used as backup for Carestream System 5 server that keeps retrying to send the studies over until it manages to do so successfully. Since it never managed to get a success when sending those over, it kept trying, and in this process it seems to have used up 1 core for every retry. The server has now been running 24 hours and is still at "0%" cpu use. (before I fixed the issue with the studies it would be at 100% after 24 hours for sure)
I managed to replicate this
I did the same change in Carestream System as before, that is, merge a study to another patient. Doing so seems to change the patient name and ID of the images, without changing the UID.
First I tested with US images, and I would not get any cpu load when sending them over to Conquest.
Then I tested with MG images like those that caused the problem before and "hurray" it worked.... eh that is.. it fails...
Each time the Carestream system tryes to send this "merged" study over, it will "freeze" one CPU core.
I did this with test images so I could send them to you for testing. I hope you dont mind, but I uploaded them.
During the test I enabled Debug logging and this is the result of trying to send one "changed" study over.
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 32768
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] 0000,0002 28 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.1.6.1"
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] 0000,1000 54 UI AffectedSOPInstanceU "1.2.392.200036.9116.7.8.6.48513238.5.0.144489515531440"
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] Where : SOPInstanc = '1.2.392.200036.9116.7.8.6.48513238.5.0.144489515531440' AND ImagePat = '123454321'
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] Columns: SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, AcqDate, AcqTime, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, OperatorsN, DeviceSeri, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] Values: '1.2.392.200036.9116.7.8.6.48513238.5.0.144489515531440', '1.2.840.10008.5.1.4.1.1.6.1', '1', '20080625', '233523.859000', '20080625', '233523.859000', '3', 'RGB', '537', '716', '8', 'ORIGINAL\\PRIMARY\\US IMAGE\\0001', 'ABH', '48513238', '123454321', '1.2.392.200036.9116.7.8.6.48513238.5.0.144591745501573', 1243732832, '123454321\\1.2.392.200036.9116.7.8.6.48513238.5.0.144591745501573_0001_000001_1243732851005c.v2', 'MAG0'
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] ***Failed MYSQLExec : INSERT INTO DICOMImages (SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, AcqDate, AcqTime, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, OperatorsN, DeviceSeri, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName) VALUES ('1.2.392.200036.9116.7.8.6.48513238.5.0.144489515531440', '1.2.840.10008.5.1.4.1.1.6.1', '1', '20080625', '233523.859000', '20080625', '233523.859000', '3', 'RGB', '537', '716', '8', 'ORIGINAL\\PRIMARY\\US IMAGE\\0001', 'ABH', '48513238', '123454321', '1.2.392.200036.9116.7.8.6.48513238.5.0.144591745501573', 1243732832, '123454321\\1.2.392.200036.9116.7.8.6.48513238.5.0.144591745501573_0001_000001_1243732851005c.v2', 'MAG0')
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] ***Error: Duplicate entry '1.2.392.200036.9116.7.8.6.48513238.5.0.144489515531440' for key 'PRIMARY'
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] ***SQL: INSERT INTO DICOMImages (SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, AcqDate, AcqTime, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, OperatorsN, DeviceSeri, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName) VALUES ('1.2.392.200036.9116.7.8.6.48513238.5.0.144489515531440', '1.2.840.10008.5.1.4.1.1.6.1', '1', '20080625', '233523.859000', '20080625', '233523.859000', '3', 'RGB', '537', '716', '8', 'ORIGINAL\\PRIMARY\\US IMAGE\\0001', 'ABH', '48513238', '123454321', '1.2.392.200036.9116.7.8.6.48513238.5.0.144591745501573', 1243732832, '123454321\\1.2.392.200036.9116.7.8.6.48513238.5.0.144591745501573_0001_000001_1243732851005c.v2', 'MAG0')
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] ***Error: Duplicate entry '1.2.392.200036.9116.7.8.6.48513238.5.0.144489515531440' for key 'PRIMARY'
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] ***Error saving to SQL: 123454321\1.2.392.200036.9116.7.8.6.48513238.5.0.144591745501573_0001_000001_1243732851005c.v2
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] 0000,0002 28 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.1.1.6.1"
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] 0000,1000 54 UI AffectedSOPInstanceU "1.2.392.200036.9116.7.8.6.48513238.5.0.144491974184786"
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] Where : SOPInstanc = '1.2.392.200036.9116.7.8.6.48513238.5.0.144491974184786' AND ImagePat = '123454321'
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] Columns: SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, AcqDate, AcqTime, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, OperatorsN, DeviceSeri, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] Values: '1.2.392.200036.9116.7.8.6.48513238.5.0.144491974184786', '1.2.840.10008.5.1.4.1.1.6.1', '3', '20080625', '233541.515000', '20080625', '233541.515000', '3', 'RGB', '537', '716', '8', 'ORIGINAL\\PRIMARY\\US IMAGE\\0011', 'ABH', '48513238', '123454321', '1.2.392.200036.9116.7.8.6.48513238.5.0.144591745501573', 1243732832, '123454321\\1.2.392.200036.9116.7.8.6.48513238.5.0.144591745501573_0001_000003_1243732851005d.v2', 'MAG0'
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] ***Failed MYSQLExec : INSERT INTO DICOMImages (SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, AcqDate, AcqTime, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, OperatorsN, DeviceSeri, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName) VALUES ('1.2.392.200036.9116.7.8.6.48513238.5.0.144491974184786', '1.2.840.10008.5.1.4.1.1.6.1', '3', '20080625', '233541.515000', '20080625', '233541.515000', '3', 'RGB', '537', '716', '8', 'ORIGINAL\\PRIMARY\\US IMAGE\\0011', 'ABH', '48513238', '123454321', '1.2.392.200036.9116.7.8.6.48513238.5.0.144591745501573', 1243732832, '123454321\\1.2.392.200036.9116.7.8.6.48513238.5.0.144591745501573_0001_000003_1243732851005d.v2', 'MAG0')
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] ***Error: Duplicate entry '1.2.392.200036.9116.7.8.6.48513238.5.0.144491974184786' for key 'PRIMARY'
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] ***SQL: INSERT INTO DICOMImages (SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, AcqDate, AcqTime, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, OperatorsN, DeviceSeri, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName) VALUES ('1.2.392.200036.9116.7.8.6.48513238.5.0.144491974184786', '1.2.840.10008.5.1.4.1.1.6.1', '3', '20080625', '233541.515000', '20080625', '233541.515000', '3', 'RGB', '537', '716', '8', 'ORIGINAL\\PRIMARY\\US IMAGE\\0011', 'ABH', '48513238', '123454321', '1.2.392.200036.9116.7.8.6.48513238.5.0.144591745501573', 1243732832, '123454321\\1.2.392.200036.9116.7.8.6.48513238.5.0.144591745501573_0001_000003_1243732851005d.v2', 'MAG0')
5/31/2009 1:20:51 AM [ICSREMOTEBACKUP] ***Error: Duplicate entry '1.2.392.200036.9116.7.8.6.48513238.5.0.144491974184786' for key 'PRIMARY'
Unfortunately for the progress of this matter, but fortunately for me I am going on 2 weeks holiday now. (I will leave on monday afternoon)
During my holiday I can not connect into the server, but still can answer some questions.
Thanks for the help and for Conquest, it certainly is great dicom server.
Best regards
Steini.