v9.1.13

[integration]

*DataManagementSystem

CHANGE: (#8674) only use the multiple file/replica insertion path when there are more than one
FIX: (#8665) Parameterise SQL in DatasetManager
FIX: (#8664) Parameterise SQL in DirectoryTreeBase
FIX: (#8663) Parameterise SQL in DirectorySimpleTree
FIX: (#8662) Parameterise SQL in DataIntegrityDB
FIX: (#8662) Parameterise SQL in DirectoryClosure
FIX: (#8662) Parameterise SQL in FileManagerPs
FIX: (#8661) Parameterise SQL in DirectoryLevelTree
FIX: (#8660) Parameterise SQL in FileManagerFlat
FIX: (#8659) Parameterise SQL in FileManagerBase
FIX: (#8658) Parameterise SQL in DirectoryMetadata
FIX: (#8657) Parameterise SQL in DirectoryTreeFlat
FIX: (#8655) Parameterise SQL in DirectoryNodeTree
FIX: (#8646) Parameterise SQL in DMS FileMetadata
FIX: (#8643) Parameterise SQL in DMS SEManager & UserAndGroupManager

*All

FIX: (#8672) Replace sqlalchemy imports to remove deprecations
FIX: (#8654) Check XML module usage for bandit

*Core

FIX: (#8671) Bandit fixups for MySQL
FIX: (#8670) Fix asserts in ElasticSearchDB
FIX: (#8645) Replace escape_string with alternatives
FIX: (#8642) Catch ValueError when formatting SQL statement logs
FIX: (#8634) Tiny typo in Test_X509Chain
NEW: (#8625) Add MySQL checking functions for identifiers & types
CHANGE: (#8584) Add cleanDirectory utility function for general directory clean-up

*WorkloadManagement

FIX: (#8668) Tidy up parameterised SQL in JobDB
FIX: (#8622) Parameterise SQL in WMS JobDB
FIX: (#8619) Move watchdog flag cleanup to correct place
FIX: (#8618) Parameterise SQL in WMS SandboxMetadata
FIX: (#8616) Parameterise SQL in WMS JobLogging
FIX: (#8615) Parameterise SQL in WMS JobParameters

*FrameworkSystem

FIX: (#8667) Parameterise SQL in ProxyDB
FIX: (#8666) Parameterise SQL in UserProfileDB

*WorkloadManagementSystem

FIX: (#8652) move getPilotOutput and getPilotLoggingInfo to WebAppHandler
CHANGE: (#8638) Do not put empty strings in log message in the JobAgent

*Workflow

FIX: (#8635) Don't apply saferEval default length cap to workflow substitution
FIX: (#8628) increased saferEval limit to 1 MiB for Workflow XML handling

FIX: (#8633) Minor documentation typo

*StorageManagamentSystem

FIX: (#8623) Parameterise SQL in StorageManagement

*ProductionSystem

FIX: (#8614) Parameterise SQL in ProductionSystem

*TransformationSystem

FIX: (#8613) Parameterise SQL in TransformationSystem

*RequestManagementSystem

CHANGE: (#8598) optimize REA by using lock and call the DB directly

v9.0.23

[rel-v9r0]

*Core

FIX: (#8647) Replace escape_string with alternatives
FIX: (#8593) Find writeable cgroup2 in tree

*TransformationSystem

FIX: (#8647) Parameterise SQL in TransformationSystem

*Workflow

FIX: (#8630) increased saferEval limit to 1 MiB for Workflow XML handling

*WorkloadManagement

FIX: (#8586) Add missing pilotID column back in web pilot lookup

v8.0.81

[rel-v8r0]

*Core

FIX: (#8648) Replace escape_string with alternatives
FIX: (#8590) MySQL - avoid massive warnings with newer versions of MySQL and MariaDB
FIX: (#8589) Use python3.11 for flynt pre-commit module

*TransformationSystem

FIX: (#8648) Parameterise SQL in TransformationSystem

*Workflow

FIX: (#8629) increased saferEval limit to 1 MiB for Workflow XML handling

v9.1.12

[integration]

*DataManagement/WorkloadManagement

FIX: (#8612) Tidy up log entries using phrase 'delete from'

*Core

FIX: (#8611) Improve mysql logging
FIX: (#8609) Use a random cookie secret
FIX: (#8606) Check use of exec
CHANGE: (#8601) Remove unused discoverInterfaces function

*All

FIX: (#8610) More bandit related checks
FIX: (#8608) Tidy up bandit warnings for edge cases
FIX: (#8605) Check more subprocess usage
FIX: (#8600) Check pickle usage

*Core/Resources

FIX: (#8604) Remove other/group permissions in chmod

*TransformationSystem

FIX: (#8599) Tidy up https use in runjoblocal

v9.1.11

[integration]

*WorkloadManagement

FIX: (#8592) AREX issue decoding the JSON, use error instead of exception
FIX: (#8581) Add missing pilotID column back in web pilot lookup
CHANGE: (#8569) improve PilotStatusAgent performances and refactor duplicated code

*docs

FIX: (#8591) add a note about the Site Director for overriding the DIRAC version installed in the pilot

*Core

FIX: (#8588) Find writeable cgroup2 in tree
FIX: (#8582) Catch NoSuchProcess in Profiler child loops
FIX: (#8580) Update fixed time conversion window in GraphUtilities

*Tests

FIX: (#8585) Tidy up a few files left by unit tests

*All

FIX: (#8579) Use systemCall instead of shellCall wherever possible
FIX: (#8578) Check hardcoded /tmp usage.
CHANGE: (#8566) Check for ignored broad except
CHANGE: (#8565) Check for hardcoded passwords

*FrameworkSystem

CHANGE: (#8563) SystemAdministrator parses /proc directly instead of using lsof for perf reasons

v9.1.10

[integration]

*Core

FIX: (#8574) Update profiler test to make it more reliable
FIX: (#8542) Use truncated sha256 for proxy hash (caching) rather than md5.
CHANGE: (#8536) New eval helper function
CHANGE: (#8535) Allow args parameter in MySQL _query calls

*RequestManagementSystem

FIX: (#8571) REA iterate over a copy of the keys
FIX: (#8539) Speed up Client_RequestTasks test path gen

*WorkloadManagement

FIX: (#8570) get job parameters the right way in StalledJobAgent

*CI

NEW: (#8567) Add diracx RSS DB to the CI environment
FIX: (#8545) the not-working pixi workaround
FIX: (#8540) CI workaround for pixi 0.68

*All

FIX: (#8564) Remove asserts from non-test code.
CHANGE: (#8562) Check all random module usage
CHANGE: (#8562) Increase proxy serial length
FIX: (#8543) Ensure all requests calls have a timeout
FIX: (#8542) Mark md5/sha1 usage as not used for security where appropriate.

*FrameworkSystem

FIX: (#8560) Use sargable query for ProxyDB.purgeLogs
FIX: (#8541) BundleDelivery: adding the owner-write bit to bundled files

*DataManagementSystem

FIX: (#8544) correct default type for catalog metadata in ConsistencyInspector
FIX: (#8529) Use existing connection for all updates in FileManager

*Deps

FIX: (#8530) fix typo for types-pyyaml dependency

v9.0.22

[rel-v9r0]

*All

FIX: (#8554) Various backports from integration

*Core

CHANGE: (#8552) Allow args parameter in MySQL _query calls
CHANGE: (#8552) New eval helper function

v8.0.80

[rel-v8r0]

v8.0.79

[rel-v8r0]

*docs

FIX: (#8546) lost dirac-dms-add-file lost documentation

*Core

CHANGE: (#8538) New eval helper function
CHANGE: (#8537) Allow args parameter in MySQL _query calls
CHANGE: (#8492) use importlib instead of pkg_resources

v9.0.21

[rel-v9r0]