Error Code: 122. CAL0001: Insert Failed: IDB-2009: Unable to perform the operation because DMLProc with PID 24156 is currently

3 posts / 0 new
Last post
zff
zff's picture
Offline
Last seen: 3 months 3 weeks ago
Joined: Feb 11 2014
Junior Boarder

Posts: 1

Phoebe Rain
Error Code: 122. CAL0001: Insert Failed: IDB-2009: Unable to perform the operation because DMLProc with PID 24156 is currently

Hi,

I try to execute a procedure on infiniDB4.5 and always got the same error. 

 

Error Code: 122. CAL0001: Insert Failed:  IDB-2009: Unable to perform the operation because DMLProc with PID 24156 is currently holding the table lock for session 12.  
Acutally I killed all the queries and connection through server-> clicent connections and tried disconnected to server and login again but it doesn't work.
Please help.
Thanks very much
radams
radams's picture
Offline
Last seen: 1 day 15 hours ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
Error Code: 122. CAL0001: Insert Failed: IDB-2009: Unable to per

 

When the system has a table lock, it can be checked with /usr/local/Calpont/bin/viewtablelock.

 

If the table is no longer being updated, the cleartablelock command or a shutdown and startsystem should clear.

 

Thanks,

 

Robert

 

 

grishashvili
grishashvili's picture
Offline
Last seen: 6 days 15 hours ago
Joined: May 3 2014
Junior Boarder

Posts: 4

Henry Grishashvili
I had the same problem,

I had the same problem, thanks for the answer!