Can you try again? Same link. Wanted to get rid of sqlite_sequence
and need to verify that I didn’t break anything.
Nothing broken in that respect.
openhab> openhab:jdbc tables list
Table Row Count Item Status
-------- --------- -------------------------------------------------------------- ----------------------
item0001 1 DCCSmartMeters__gasconsumptionTariffStandingCharge Item missing
item0002 1 DCCSmartMeters__gasconsumptionTariffPerUnitCharge Item missing
item0003 0 DCCSmartMeters__GasConsumption Item missing
item0004 0 DCCSmartMeters__ElectricityConsumption Item missing
item0005 0 DCCSmartMeters__GasCost Item missing
item0006 0 DCCSmartMeters__Electricitycost Item missing
item0007 1 DCCSmartMeters__electricityconsumptionTariffStandingCharge Item missing
item0008 1 DCCSmartMeters__electricityconsumptionTariffPerUnitChargeTier1 Item missing
but there are no jdbc entries in the log when I change an item!
Debug logging is enabled and there are entries occurring for jdbc, for example from the above tables list
2022-12-04 11:40:21.908 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::getItemTables
2022-12-04 11:40:21.911 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::doGetItemTables sql=SELECT name AS table_name FROM sqlite_master WHERE type='table' AND name NOT IN ('items','sqlite_sequence')
2022-12-04 11:40:21.941 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::doGetRowCount sql=SELECT COUNT(*) FROM item0001
2022-12-04 11:40:21.946 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::doGetRowCount sql=SELECT COUNT(*) FROM item0002
2022-12-04 11:40:21.949 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::doGetRowCount sql=SELECT COUNT(*) FROM item0003
2022-12-04 11:40:21.953 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::doGetRowCount sql=SELECT COUNT(*) FROM item0004
2022-12-04 11:40:21.959 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::doGetRowCount sql=SELECT COUNT(*) FROM item0005
2022-12-04 11:40:21.965 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::doGetRowCount sql=SELECT COUNT(*) FROM item0006
2022-12-04 11:40:21.968 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::doGetRowCount sql=SELECT COUNT(*) FROM item0007
2022-12-04 11:40:21.972 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::doGetRowCount sql=SELECT COUNT(*) FROM item0008