--- Previous mail was in HTML and possibly not readable --- Hi,
We seem to be suffering from a bug in the (trigger) code that updates the ACCT_STAT.sz0 counter, in particular if an existing file is updated while/to having zero content. Try: > touch /lustre_fs/somefile > rbh-report --user-info -S --szprof > echo "test" > /lustre_fs/somefile > rbh-report --user-info -S --szprof > truncate -s 0 /lustre_fs/somefile > rbh-report --user-info -S --szprof and note that in the last report, the sz0 counter for the active user/group is decreased instead of increased. If the counter drops below zero, robinhood starts throwing "Unhandled error 1264: default conversion to DB_REQUEST_FAILED" errors which prevent the database from being updated, resulting in mismatches between rbh and lustre metadata (this was how the problem first became apparent to us). Taking a closer look at the UPDATE trigger code in the database, the following line: sz0=CAST(sz0 as SIGNED)-CAST(((OLD.size=0)+(NEW.size=0)) as SIGNED), should probably be something like: sz0=CAST(sz0 as SIGNED)-CAST((OLD.size=0) as SIGNED + CAST((NEW.size=0) as SIGNED), Cheers, Hanno ------------------------------------------------------------------------------ _______________________________________________ robinhood-support mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/robinhood-support
