|
From: Yuan L. <yu...@in...> - 2012-01-18 00:34:05
|
Hi Jean-Denis, One of my colleague suggested you to try the following commands using root. GRANT [SELECT, INSERT, UPDATE] ON `mysql`.`proc` TO '<user>'@'localhost'; GRANT EXECUTE ON PROCEDURE karma.PR_OBJECT_LOCK TO '<user>'@'localhost'; Let us know how it goes. Thanks, Yuan On Mon, Jan 16, 2012 at 5:02 AM, rt...@rt... via RT < he...@da...> wrote: > A new ticket has been created and assigned an ID of [RAC RT #69474]. > <URL: https://rt.rtinfo.indiana.edu/Ticket/Display.html?id=69474 > > --- > > From: rt...@rt... <rt...@rt...> > > Submitted on Monday, January 16, 2012 - 4:41am > Submitted by anonymous user: [128.178.187.180] > Submitted values are: > > Your Name: Jean-Denis Courcol > Your Email: jea...@ep... > Subject: issue with ManageDBLock. > Message: > Dear Karma team, > I upgraded to the latest release available in the SVN repository.(rev > 1482). > For your information and for other users I had to run the following SQL > statement : > GRANT SELECT ON `mysql`.`proc` to `root`@`localhost` ; > otherwise I got this error : > "User does not have access to metadata required to determine stored > procedure > parameter types. If rights can not be granted, configure connection with > "noAccessToProcedureBodies=true" to have driver generate parameters that > represent INOUT strings irregardless of actual parameter types." during the > execution of PR_OBJECT_LOCK. > > Now I get the following error : > > Jan 2012 09:02:08,805 [AsynProc-0] ERROR > edu.indiana.dsi.karma.ingest.db.BaseDBIngester -Unable to process raw > notification with internalID 4739 > edu.indiana.dsi.karma.ingest.IngestException: Max retries 10 for the lock > reached for the object: xxxxxx > at > > edu.indiana.dsi.karma.ingest.db.BaseDBIngesterImplementer.manageDBLock(BaseDBIngesterImplementer.java:3800) > at > > edu.indiana.dsi.karma.ingest.db.BaseDBIngesterImplementer.insertEntityRecord(BaseDBIngesterImplementer.java:3752) > at > > edu.indiana.dsi.karma.ingest.db.BaseDBIngesterImplementer.saveInvocation(BaseDBIngesterImplementer.java:4073) > at > > edu.indiana.dsi.karma.ingest.db.BaseDBIngesterImplementer.saveInvocationStatus(BaseDBIngesterImplementer.java:2396) > at > > edu.indiana.dsi.karma.ingest.db.BaseDBIngesterImplementer.storeInvocationStatus(BaseDBIngesterImplementer.java:4109) > at > > edu.indiana.dsi.karma.ingest.db.BaseDBIngester.invocationStatusProcessHelper(BaseDBIngester.java:1327) > at > > edu.indiana.dsi.karma.ingest.db.BaseDBIngester.processInvokingWorkflowStatus(BaseDBIngester.java:1300) > at > > edu.indiana.dsi.karma.ingest.db.BaseDBIngester.processNotifications(BaseDBIngester.java:871) > at > > edu.indiana.dsi.karma.ingest.AsyncRawNotificationProcessor.run(AsyncRawNotificationProcessor.java:116) > at java.lang.Thread.run(Unknown Source) > I got that error for a lot of different entities. > > As a temporary workaround , I commented out the calls to manageDBLocks to > continue my tests. > > regards, > Jean-Denis > > > > > > The results of this submission may be viewed at: > https://pti.iu.edu/node/15249/submission/889 > > -- Yuan Luo School of Informatics and Computing, Indiana University Data to Insight Center, Indiana University Cell: (812)272-0208 http://www.yuanluo.net |
