search

project8 / dripline

Slow controls for medium scale physics experiments based on AMQP centralized messaging
http://www.project8.org/dripline
1 stars 0 forks source link

sensor_logger crashes on string insert #145

Closed laroque closed 9 years ago

laroque commented 9 years ago

that's not so good:

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) cannot insert into view "string_data"
HINT:  You need an unconditional ON INSERT DO INSTEAD rule or an INSTEAD OF INSERT trigger.
 [SQL: 'INSERT INTO public.string_data (endpoint_name, timestamp, value_raw) VALUES (%(endpoint_name)s, %(timestamp)s, %(value_raw)s)'] [parameters: {'timestamp': '2015-10-26T20:53:18Z', 'value_raw': '', 'endpoint_name': 'top_coil_relay_status'}]
laroque commented 9 years ago

This issue is now part of dragonfly so I'm moving it to issue #3 there