cea-hpc / robinhood

Robinhood Policy Engine : a versatile tool to monitor filesystem contents and schedule actions on filesystem entries.
http://robinhood.sf.net
Other
177 stars 60 forks source link

listmgr: fix missing CAST(as SIGNED) for size computation #141

Closed flydt closed 1 month ago

flydt commented 1 month ago

MySQL operations with any unsigned int (either on left-hand side or the right-hand side) are unsigned, so size needs to be explicitly CAST()'ed to SIGNED to avoid conversion errors.

This should fix errors like these:

Out of range value for column 'size' at row 3

You will need to drop and repopulate the accounting table to totally get rid of the errors because some ACCT fields may contain invalid values. You can do this using "rbh-config reset_acct". On next startup, robinhood will populate the ACCT table with the right information (this may take a few hours depending on the filesystem size).