Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

Script errors - Wrapped org.springframework.dao.CannotAcquireLockException


  • Off late getting a lot of error like the one below

    'calculated_data': Script error in point "Temp_Outside_5minAvg": sun.org.mozilla.javascript.WrappedException: Wrapped org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [select pv.dataType, pv.pointValue, pva.textPointValueShort, pva.textPointValueLong, pv.ts, pva.sourceType, pva.sourceId from pointValues pv left join pointValueAnnotations pva on pv.id = pva.pointValueId where pv.dataPointId=? and pv.ts >= ? and pv.ts#1) in at line number 1 in at line number 1

    They go away after bouncing tomcat, but again reoccur after some time. please advise on resolution ?


  • Is there any pattern to when these errors occur, such as a specific time each day?


  • @mlohbihler said:

    Is there any pattern to when these errors occur, such as a specific time each day?

    no not really. I got fed up with them and migrated to mysql, seems to have stopped after that. Overall system performance is also much better.


  • Ah, i didn't know you were using Derby. Could have been just a load issue?