Odd MySQL processlist results

General
1

Greeting to all - I hope you’re enjoying your Christmas!

I run Orthanc in it’s own container, connecting to another (MySQL) container. I’ve noticed that the MySQL container is running for a lengthy period at close to 100%. U use show processlist; to show me what it’s doing and I see the following on the Orthanc DB : DELETE FROM Resources WHERE internalId IN (SELECT internalId FROM DeletedResources)

However, when I change to the Orthanc database, there is no DeletedResources table (there is a Resources table).

Has my database become corrupt somehow - should there be a DeletedResources table?

2

Also just noticed this …

SHOW processlist;

which resulted in…

CREATE TEMPORARY TABLE DeletedResources SELECT * FROM (SELECT internalId, resourceType, publicId FRO...

I also managed to see this posted:

DELETE FROM Metadata WHERE (id=1143199 AND type=5) OR (id=1271047 AND type=5) OR (id=1273070 AND typ...

This appears to be running consistently?

3

And

CALL CreateInstance(?, ?, ?, ?, @isNewPatient, @isNewStudy, @isNewSeries, @isNewInstance, @patientKe
4

Hi Dave,

The DeletedResources is indeed a temporary table that is created only for the duration of a transaction. That’s why you see it in the process list but not in the schema.

And yes, this seems all consistent.

Best regards,

Alain.