Dropping ACCT_STAT table as Thomas suggested didn't help.
We're still getting
2018/12/15 06:44:05 robinhood@r-rh01[117653/3] ListMgr | Unhandled error
1264: default conversion to DB_REQUEST_FAILED
2018/12/15 06:44:05 robinhood@r-rh01[117653/3] ListMgr | Error 7
executing query 'UPDATE ENTRIES SET
uid='baltzar',gid='folk',size=0,blocks=0,last_access=1544852624,last_mod=1544852624,last_mdchange=1544852624,mode=420,nlink=1,md_update=1544852645,fileclass='+files_0b+',class_update=1544852645
WHERE id='0x2001bb528:0x3b0:0x0'': Out of range value for column 'sz0'
at row 1
2018/12/15 06:44:05 robinhood@r-rh01[117653/3] EntryProc | Error 7
performing database operation: request error.
2018/12/15 06:44:05 robinhood@r-rh01[117653/4] ListMgr | Unhandled error
1264: default conversion to DB_REQUEST_FAILED
2018/12/15 06:44:05 robinhood@r-rh01[117653/4] ListMgr | Error 7
executing query 'INSERT INTO
ENTRIES(id,uid,gid,size,blocks,last_access,last_mod,last_mdchange,mode,nlink,md_update,fileclass,class_update)
VALUES
('0x2001bb528:0x3c8:0x0','baltzar','folk',0,96,1544852624,1544852624,1544852624,420,1,1544852645,'+files_0b+',1544852645),('0x2001bae8c:0x13fc6:0x0','olsson','folk',402776,792,1544852624,1544852624,1544852624,420,1,1544852645,'+files_256kto512k+',1544852645)
ON DUPLICATE KEY UPDATE
uid=VALUES(uid),gid=VALUES(gid),size=VALUES(size),blocks=VALUES(blocks),last_access=VALUES(last_access),last_mod=VALUES(last_mod),last_mdchange=VALUES(last_mdchange),mode=VALUES(mode),nlink=VALUES(nlink),md_update=VALUES(md_update),fileclass=VALUES(fileclass),class_update=VALUES(class_update)':
Out of range value for column 'sz0' at row 1
2018/12/15 06:44:05 robinhood@r-rh01[117653/4] ListMgr | DB query failed
in ListMgr_BatchInsert line 342: code=7:
Any ideas?
On 12/13/18 11:02 AM, Åke Sandgren wrote:
Hi!
We're getting this type of errors repeatedly, any idea why?
2018/12/13 10:41:23 robinhood@r-rh01[934235/10] ListMgr | Error 7
executing query 'INSERT INTO
ENTRIES(id,uid,gid,size,blocks,last_access,last_mod,last_mdchange,mode,nlink,md_update,fileclass,class_update)
VALUES
('0x2001b3d15:0x1916f:0x0','jlma','folk',370071,728,1544694083,1544694083,1544694083,420,1,1544694083,'+files_256kto512k+',1544694083),('0x2001bb18f:0x1a875:0x0','johkl85','folk',30136306,58920,1544694083,1544694083,1544694083,420,1,1544694083,'+files_16Mto32M+',1544694083),('0x2001bb18f:0x1a838:0x0','johkl85','folk',3483188376,6803440,1544694083,1544694083,1544694083,420,1,1544694083,'+files_2Gto4G+',1544694083)
ON DUPLICATE KEY UPDATE
uid=VALUES(uid),gid=VALUES(gid),size=VALUES(size),blocks=VALUES(blocks),last_access=VALUES(last_access),last_mod=VALUES(last_mod),last_mdchange=VALUES(last_mdchange),mode=VALUES(mode),nlink=VALUES(nlink),md_update=VALUES(md_update),fileclass=VALUES(fileclass),class_update=VALUES(class_update)':
Out of range value for column 'sz0' at row 1
