Re: [robinhood-support] rbh 2.5 db errors

Fri, 13 Dec 2013 05:52:01 -0800 

Hi Brock,
I'm pleased to see how your DB requests are batched in single transactions, as the INSERT requests shows. good! 

About your issue:

> grep 1205 /usr/include/mysql/mysqld_error.h
#define ER_LOCK_WAIT_TIMEOUT 1205


It seams the request timed out because a table is locked, perhaps by a 
long running request.



- do you run external tools that perform long SQL request on robinhood 
database?
    => I recommend running such requests with "READ UNCOMMITTED" 
isolation level to avoid locking robinhood tables.

Example:
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
START TRANSACTION;
SELECT ...
COMMIT;

- do you run robinhood policies (purge, ...)?
- do you execute rbh-report commands that take a long time?
- did you set a value for commit_behavior in robinhood config?
- did you set a value for innodb_flush_log_at_trx_commit in /etc/my.cnf?


When the problem occurs, you can run the following SQL command to know 
what's going on:

show processlist;
It displays the current request and for how long they are running.

HTH,
Thomas


On 12/12/13 18:11, Brock Palen wrote:

I have version 2.5 up and running.  I twas scanning find by now I see many 
errors in the log files:
Any thoughts what might cause this?

2013/12/12 12:09:40 robinhood@flux-xfer1[25340/7]: ListMgr | DB query failed in 
ListMgr_BatchInsert line 267: code=7:
2013/12/12 12:09:40 robinhood@flux-xfer1[25340/10]: ListMgr | DB query failed 
in ListMgr_BatchInsert line 267: code=7:
2013/12/12 12:09:40 robinhood@flux-xfer1[25340/7]: EntryProc | Error 7 
performing batch database operation.
2013/12/12 12:09:40 robinhood@flux-xfer1[25340/10]: EntryProc | Error 7 
performing batch database operation.
2013/12/12 12:10:35 robinhood@flux-xfer1[25340/12]: ListMgr | Unhandled error 
1205: default conversion to DB_REQUEST_FAILED
2013/12/12 12:10:35 robinhood@flux-xfer1[25340/13]: ListMgr | Unhandled error 
1205: default conversion to DB_REQUEST_FAILED
2013/12/12 12:10:35 robinhood@flux-xfer1[25340/12]: ListMgr | Error 1 executing query 
'INSERT INTO 
ENTRIES(id,owner,gr_name,size,blocks,last_access,last_mod,type,mode,nlink,md_update,invalid,release_class,rel_cl_update)
 VALUES 
('483A93D8:3C2A4652','tsurma','chem',217300,432,1368541226,1367435409,'file',420,1,1386868165,0,'@default@',1386868165),('483A93D8:347E4380','tsurma','chem',217300,432,1370891082,1361301663,'file',420,1,1386868165,0,'@default@',1386868165),('483A93D8:E4DBE36','tsurma','chem',217300,432,1371056025,1362183131,'file',420,1,1386868165,0,'@default@',1386868165),('483A93D8:5B499DC7','tsurma','chem',217300,432,1371162008,1363399269,'file',420,1,1386868165,0,'@default@',1386868165),('483A93D8:3B638944','tsurma','chem',217300,432,1366390280,1365556977,'file',420,1,1386868165,0,'@default@',1386868165),('483A93D8:4D46F45','tsurma','chem',217300,432,1364568182,1364147613,'file',420,1,1386868165,0,'@default@',1386868165),('483A93D8:34701C7F','tsurma','chem',217300,432,1370891082,1361132304,'file',420,1,1386868165,0,'@default@',1386868165),('483A93D8:EAD8FD8','tsurma','chem',217300,432,1371056025,1362292647,'file',420,1,1386868165,0,'@default@',1386868165),('483A93D8:4DA410D','tsurma','chem',217300,432,1364568183,1364253065,'file',420,1,1386868165,0,'@default@',1386868165),('483A93D8:3B5BF664','tsurma','chem',217300,432,1366390272,1365537100,'file',420,1,1386868165,0,'@default@',1386868165),('483A93D8:5B49E1FD','tsurma','chem',217300,432,1371162009,1363425511,'file',420,1,1386868165,0,'@default@',1386868165),('483A93D8:E6D99AE','tsurma','chem',217300,432,1371056026,1362218974,'file',420,1,1386868165,0,'@default@',1386868165),('483A93D8:348E2FE4','tsurma','chem',217300,432,1370891082,1361343903,'file',420,1,1386868165,0,'@default@',1386868165),('483A93D8:3B63E110','tsurma','chem',217300,432,1366390238,1365649768,'file',420,1,1386868165,0,'@default@',1386868165),('483A93D8:4F25415','tsurma','chem',217300,432,1364568183,1364399293,'file',420,1,1386868165,0,'@default@',1386868165),('483A93D8:4451F970','tsur...
 <Line truncated. Real size=60069>
2013/12/12 12:10:35 robinhood@flux-xfer1[25340/12]: ListMgr | Unhandled error 
1205: default conversion to DB_REQUEST_FAILED


Brock Palen
www.umich.edu/~brockp
CAEN Advanced Computing
XSEDE Campus Champion
[email protected]
(734)936-1985





------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk


_______________________________________________
robinhood-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/robinhood-support



------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
robinhood-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/robinhood-support






















					Reply via email to