DIRACGrid / DIRAC

DIRAC Grid
http://diracgrid.org
GNU General Public License v3.0
113 stars 176 forks source link

Prevent upload of files with names which are too long for the DFC #7602

Closed chrisburr closed 5 months ago

chrisburr commented 6 months ago

We had a user upload files with extremely long LFNs that resulted in requests which couldn't be processed due to a MySQL issue:

ID=217409110
LFN='/lhcb/user/x/xxxxxxx/2024_05/877947/877947554/13000GeV__Z__POWHEGPythia__8245ptmaxmatch2__NNPDF31_nlo_as_0118__0__as0.118000_IKT1.000000_s2tw0.233000_mz91.153500__evts20__seed2__lhcbacc.root'
Status='Waiting'
Checksum='91d143ba'
Error='failed to register LFN: {'FileCatalog': "MySQL Error ( 1131 : Execution failed.: ( 1406: Data too long for column 'FileName' at row 1 ))"}'
Attempts=70

This should probably be caught by the client before even trying to upload the file.