Save
Saving
  • J juamonmar

    Recently I've lost all data. The error message that I've found is:
    (com.serotonin.m2m2.db.dao.PointValueDaoSQL$BatchWriteBehind.execute:994) - Error saving 383 batch inserts. Data lost.
    org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [insert into pointValues (dataPointId, dataType, pointValue, ts) values (?,?,?,?),(?,?,?,?),(?,?,?,?),............................A lock could not be obtained within the time requested; nested exception is java.sql.SQLTransactionRollbackException: A lock could not be obtained within the time requested.
    My fear is to lost all data continuously.

    posted in User help read more