Reports until 12:18, Tuesday 09 January 2018
H1 CDS
patrick.thomas@LIGO.ORG - posted 12:18, Tuesday 09 January 2018 - last comment - 06:53, Wednesday 10 January 2018(40054)
Conlog crash on attempted insert of invalid JSON text 
conlog-master.log:
2018-01-09T19:52:31.208080Z	    4 Execute	INSERT INTO events (pv_name, time_stamp, event_type, has_data, data) VALUES('H1:SQZ-SPARE_FLIPPER_1_NAME', '1515527550857386596', 'update', 1, '{"type":"DBR_STS_STRING","count":1,"value":["��'�"],"alarm_status":"NO_ALARM","alarm_severity":"NO_ALARM"}')
2018-01-09T19:52:31.208301Z	    4 Query	rollback

syslog:
Jan  9 11:52:31 conlog-master systemd[1]: Unit conlog.service entered failed state.

conlog.log:
Jan  9 11:52:31 conlog-master conlogd[10598]: terminate called after throwing an instance of 'sql::SQLException'
Jan  9 11:52:31 conlog-master conlogd[10598]: what():  Invalid JSON text: "Invalid escape character in string." at position 44 in value for column 'events.data'.
Comments related to this report
patrick.thomas@LIGO.ORG - 12:26, Tuesday 09 January 2018 (40055)
Link 

Suspect that it occurred with a Beckhoff restart.
patrick.thomas@LIGO.ORG - 13:26, Tuesday 09 January 2018 (40057)
Link 

Restarted and updated channel list. 59 channels added. 25 channels removed. List attached.
Non-image files attached to this comment
patrick.thomas@LIGO.ORG - 06:53, Wednesday 10 January 2018 (40072)
Link 

Found it crashed again, same issue, different channel:

2018-01-10T00:32:45.744823Z	    5 Execute	INSERT INTO events (pv_name, time_stamp, event_type, has_data, data) VALUES('H1:SQZ-LO_FLIPPER_NAME', '1515544365629095108', 'update', 1, '{"type":"DBR_STS_STRING","count":1,"value":["@@@e?@@@j�"],"alarm_status":"NO_ALARM","alarm_severity":"NO_ALARM"}')