search

ismop / dap

3 stars 0 forks source link

Measurement table trigger violates CHECK constraint in child tables #94

Closed nowakowski closed 8 years ago

nowakowski commented 8 years ago

Due to DATETIME conversion mechanics the trigger does not correctly handle measurements which occur in the first hour following CT switchover (i.e. the first hour of each month - e.g. 2016-03-01 00:30:00). Observed by @mkasztelnik on dap-dev

nowakowski commented 8 years ago

Fixed in latest iteration of #85 (commit f31d9dd).

nowakowski commented 8 years ago

@bwilk I had to repartition the measurements table. Could you check that flume-dev still works correctly (i.e. inserts records into measurements on dap-dev)?

bwilk commented 8 years ago

for me it looks OK - measurements are being stored correctly

bwilk commented 8 years ago

@nowakowski can this issue be closed?