Skip to content

Sweeping !1356 from master to devel: fix (StorageUsageDB): fix bad string formatting which lead to exception

LHCbDIRAC Bot requested to merge cherry-pick-c58d38f9e-devel into devel 
2023-02-08 12:09:28 UTC DataManagement/StorageHistoryAgent/DataManagement/StorageHistoryAgent ERROR: Agent exception while calling method <bound method StorageHistoryAgent.execute of <LHCbDIRAC.DataManagementSystem.Agent.StorageHistoryAgent.StorageHistoryAgent object at 0x7f811e36d280>>
Traceback (most recent call last):
  File "/opt/dirac/versions/v11.0.2-1674644139/Linux-x86_64/lib/python3.9/site-packages/DIRAC/Core/Base/AgentModule.py", line 311, in am_secureCall
    result = functor(*args)
  File "/opt/dirac/versions/v11.0.2-1674644139/Linux-x86_64/lib/python3.9/site-packages/LHCbDIRAC/DataManagementSystem/Agent/StorageHistoryAgent.py", line 355, in execute
    self.userStorageAccounting()
  File "/opt/dirac/versions/v11.0.2-1674644139/Linux-x86_64/lib/python3.9/site-packages/LHCbDIRAC/DataManagementSystem/Agent/StorageHistoryAgent.py", line 118, in userStorageAccounting
    result = self.__stDB.getUserSummaryPerSE()
  File "/opt/dirac/versions/v11.0.2-1674644139/Linux-x86_64/lib/python3.9/site-packages/LHCbDIRAC/DataManagementSystem/DB/StorageUsageDB.py", line 693, in getUserSummaryPerSE
    sqlCmd = "SELECT {: } FROM `su_Directory` AS d, `su_SEUsage` AS su WHERE {} GROUP BY {}".format(
ValueError: Space not allowed in string format specifier

BEGINRELEASENOTES

*DMS

FIX: fix bad formatting in StorageUsageDB

ENDRELEASENOTES

Merge request reports