You're not alone though
aelwell@bravo:~$ grep 'Unhandled error 1264: default conversion to
DB_REQUEST_FAILED' /var/log/robinhood/scratch.log | wc -l
1777
and that was on a freshly dropped and recreated DB (enabled changelogs
and then kicked off a full scan)
and it looks pretty similar to these:
2018/12/14 06:48:18 robinhood@bravo[5084/5] ListMgr | Unhandled error
1264: default conversion to DB_REQUEST_FAILED
2018/12/14 06:48:18 robinhood@bravo[5084/5] ListMgr | Error 7
executing query 'DELETE M.*,A.*,I.*,S.* FROM ENTRIES M LEFT JOIN
ANNEX_INFO A ON M.id = A.id LEFT JOIN STRIPE_INFO I ON M.id = I.id
LEFT JOIN STRIPE_ITEMS S ON M.id = S.id WHERE
M.id='0x2187873f7:0x1662a:0x0'': Out of range value for column 'sz0'
at row 1
2018/12/14 06:48:18 robinhood@bravo[5084/5] EntryProc | Error 7
performing database operation: request error.
2018/12/14 06:48:19 robinhood@bravo[5084/6] ListMgr | Unhandled error
1264: default conversion to DB_REQUEST_FAILED
2018/12/14 06:48:19 robinhood@bravo[5084/6] ListMgr | Error 7
executing query 'DELETE M.*,A.*,I.*,S.* FROM ENTRIES M LEFT JOIN
ANNEX_INFO A ON M.id = A.id LEFT JOIN STRIPE_INFO I ON M.id = I.id
LEFT JOIN STRIPE_ITEMS S ON M.id = S.id WHERE
M.id='0x2187873f7:0x16629:0x0'': Out of range value for column 'sz0'
at row 1
2018/12/14 06:48:19 robinhood@bravo[5084/6] EntryProc | Error 7
performing database operation: request error.
2018/12/14 06:48:20 robinhood@bravo[5084/7] ListMgr | Unhandled error
1264: default conversion to DB_REQUEST_FAILED
2018/12/14 06:48:20 robinhood@bravo[5084/7] ListMgr | Error 7
executing query 'DELETE M.*,A.*,I.*,S.* FROM ENTRIES M LEFT JOIN
ANNEX_INFO A ON M.id = A.id LEFT JOIN STRIPE_INFO I ON M.id = I.id
LEFT JOIN STRIPE_ITEMS S ON M.id = S.id WHERE
M.id='0x218787424:0x6acf:0x0'': Out of range value for column 'sz0' at
row 1
2018/12/14 06:48:20 robinhood@bravo[5084/7] EntryProc | Error 7
performing database operation: request error.
2018/12/14 06:48:21 robinhood@bravo[5084/8] ListMgr | Unhandled error
1264: default conversion to DB_REQUEST_FAILED
2018/12/14 06:48:21 robinhood@bravo[5084/8] ListMgr | Error 7
executing query 'DELETE M.*,A.*,I.*,S.* FROM ENTRIES M LEFT JOIN
ANNEX_INFO A ON M.id = A.id LEFT JOIN STRIPE_INFO I ON M.id = I.id
LEFT JOIN STRIPE_ITEMS S ON M.id = S.id WHERE
M.id='0x218787424:0x6ace:0x0'': Out of range value for column 'sz0' at
row 1
2018/12/14 06:48:21 robinhood@bravo[5084/8] EntryProc | Error 7
performing database operation: request error.
2018/12/14 06:48:22 robinhood@bravo[5084/9] ListMgr | Unhandled error
1264: default conversion to DB_REQUEST_FAILED
2018/12/14 06:48:22 robinhood@bravo[5084/9] ListMgr | Error 7
executing query 'UPDATE ENTRIES SET
uid='amir_ariff',gid='pawsey0134',size=4973,blocks=16,last_access=1544741229,last_mod=1544741228,last_mdchange=1544741228,type='file',mode=420,nlink=1,md_update=1544741302
WHERE id='0x21878730d:0x178da:0x0'': Out of range value for column
'sz0' at row 1
2018/12/14 06:48:22 robinhood@bravo[5084/9] EntryProc | Error 7
performing database operation: request error.
2018/12/14 06:48:22 robinhood@bravo[5084/10] ListMgr | Unhandled error
1264: default conversion to DB_REQUEST_FAILED
2018/12/14 06:48:22 robinhood@bravo[5084/10] ListMgr | Error 7
executing query 'INSERT INTO
ENTRIES(id,uid,gid,size,blocks,last_access,last_mod,last_mdchange,type,mode,nlink,md_update)
VALUES
('0x2187873f1:0x18ad3:0x0','amir_ariff','pawsey0134',1529,8,1544741227,1544741227,1544741227,'file',420,1,1544741302),('0x2187873de:0x1b4b7:0x0','amir_ariff','pawsey0134',1529,8,1544741225,1544741225,1544741225,'file',420,1,1544741302),('0x218787387:0x6ca3:0x0','amir_ariff','pawsey0134',1537,8,1544741233,1544741233,1544741233,'file',420,1,1544741302),('0x218787302:0x18b53:0x0','amir_ariff','pawsey0134',1529,8,1544741170,1544741170,1544741170,'file',420,1,1544741302),('0x218787399:0x6dd7:0x0','amir_ariff','pawsey0134',4973,16,1544741240,1544741238,1544741238,'file',420,1,1544741302)
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),type=VALUES(type),mode=VALUES(mode),nlink=VALUES(nlink),md_update=VALUES(md_update)':
Out of range value for column 'sz0' at row 1
2018/12/14 06:48:22 robinhood@bravo[5084/10] ListMgr | DB query failed
in ListMgr_BatchInsert line 342: code=7: Out of range value for column
'sz0' at row 1
2018/12/14 06:48:22 robinhood@bravo[5084/10] EntryProc | Error 7
performing batch database operation: request error.
2018/12/14 06:48:22 robinhood@bravo[5084/11] ListMgr | Unhandled error
1264: default conversion to DB_REQUEST_FAILED
2018/12/14 06:48:22 robinhood@bravo[5084/11] ListMgr | Error 7
executing query 'INSERT INTO
ENTRIES(id,uid,gid,size,blocks,last_access,last_mod,last_mdchange,type,mode,nlink,md_update)
VALUES
('0x2187873f3:0x18ad5:0x0','amir_ariff','pawsey0134',1528,8,1544741235,1544741235,1544741235,'file',420,1,1544741302),('0x21878731a:0x17913:0x0','amir_ariff','pawsey0134',0,16,1544741245,1544741245,1544741245,'file',420,1,1544741302),('0x21878730b:0x17a48:0x0','amir_ariff','pawsey0134',1529,8,1544741227,1544741227,1544741227,'file',420,1,1544741302),('0x2187873fa:0x838c:0x0','amir_ariff','pawsey0134',4973,16,1544741246,1544741246,1544741246,'file',420,1,1544741302)
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),type=VALUES(type),mode=VALUES(mode),nlink=VALUES(nlink),md_update=VALUES(md_update)':
Out of range value for column 'sz0' at row 1
and it still seems to be happening
2018/12/15 19:33:24 robinhood@bravo[5321/27] ListMgr | Unhandled error
1264: default conversion to DB_REQUEST_FAILED
2018/12/15 19:33:24 robinhood@bravo[5321/27] ListMgr | Error 7
executing query 'INSERT INTO
ENTRIES(id,uid,gid,size,blocks,last_access,last_mod,last_mdchange,type,mode,nlink,md_update,invalid)
VALUES
('0x218786e2e:0x162a1:0x0','lchen','pawsey0224',152854,304,1544812311,1544748792,1544748792,'file',420,1,1544873598,0),('0x2187873dc:0x12fba:0x0','lchen','pawsey0224',4096,8,1544865120,1544865120,1544865120,'dir',1517,4,1544873598,0)
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),type=VALUES(type),mode=VALUES(mode),nlink=VALUES(nlink),md_update=VALUES(md_update),invalid=VALUES(invalid)':
Out of range value for column 'sz0' at row 1
aelwell@bravo:~$ /usr/sbin/robinhood --version
Product: robinhood
Version: 3.1.4-1
Build: 2018-11-07 13:52:42
Compilation switches:
Lustre filesystems
Lustre Version: 2.10
Address entries by FID
MDT Changelogs supported
Database binding: MySQL
Report bugs to: <robinhood-support@lists.sourceforge.net>
Andrew
_______________________________________________
robinhood-support mailing list
robinhood-support@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/robinhood-support
