fact-project / shifthelper

So we can sleep at night.
4 stars 0 forks source link

developer call, due to missing table; just once. #221

Closed dneise closed 7 years ago

dneise commented 7 years ago

got this exception only once .. worked afterwards ... not sure what might be the reason.

Exception while running check ParkingChecklistFilled: (pymysql.err.ProgrammingError) (1146, "Table 'shifthelper.factdata_Schedule' doesn't exist") [SQL: '\n        SELECT * FROM factdata_Schedule AS S\n        WHERE\n            S.fMeasurementTypeKey = 6\n        AND\n            S.fStart < "2017-03-06 10:43:54"\n        ORDER BY S.fStart DESC\n        LIMIT 1\n        ']
maxnoe commented 7 years ago

Got this also last night, might be that the request was done right during the cloning?

dneise commented 7 years ago

Might be ... I've no idea how long the time-out or retry-time for this check is, we should increase it maybe ...

maxnoe commented 7 years ago

There is no retry at all for the request to the cloned db

dneise commented 7 years ago

okay, maybe we should set one up then ...

dneise commented 7 years ago

Isn't this fixed since #225; #226 ?

maxnoe commented 7 years ago

Yes.