Could not execute JDBC batch update; SQL


(Jonathan Bisson) #1

I am the only one getting those exeptions? As soon as I try to edit an app on the mobile, there is a loading spinner and after a while, ièm getting an error saving page. Tried to reboot my hub and still experiencing the same issue.

Is there some issue with the platform???

org.springframework.dao.CannotAcquireLockException: Hibernate operation: Could not execute JDBC batch update; SQL [insert into event_subscription (version, data, date_created, device_id, filter_events, handler, hub_id, installed_smart_app_id, last_updated, location_id, name, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; (conn:4306861) Lock wait timeout exceeded; try restarting transaction
Query is : insert into event_subscription (version, data, date_created, device_id, filter_events, handler, hub_id, installed_smart_app_id, last_updated, location_id, name, id) values (0, ‘mode’, ‘2017-03-16 23:32:21.537’, , 1, ‘modeChange’, , ‘52f114c1-bfa4-4584-8409-be5028b78873’, ‘2017-03-16 23:32:21.537’, ‘fb277590-fa21-4e4e-b045-421434d0c0e6’, , ‘647c873c-0b43-4516-aa0b-e0505f14ed2b’); nested exception is java.sql.BatchUpdateException: (conn:4306861) Lock wait timeout exceeded; try restarting transaction