UBQ - if something goes wrong, "null value in column \"appname\" violates not-null constraint" error in log
Instead of writting into ubq_runstat
, the following error appears in log:
20180802 17520044 " + rest/ubq_messages/executeSchedulerTask?async=true
20180802 17520044 " http 127.0.0.1 -> POST rest/ubq_messages/executeSchedulerTask?async=true
20180802 17520044 " http {"schedulerName":"mail","command":null,"module":"./ubqMailJob","singleton":true,"logSuccessful":false}
20180802 17520044 " auth Session expire (timeout) admin/1564574407/127.0.0.1
20180802 17520044 " auth admin/1564574424
20180802 17520044 " call endpoint rest
20180802 17520044 " info Call JS method: UB.UBQ.sendQueueMail
20180802 17520044 " + ubMixinClasses.TubStorageMixin(00007FBA6291CC40).MixinMethod
20180802 17520044 " debug ubq_messages.select(TubStorageMixin)
20180802 17520044 " + ubApp.TubDataStore(00007FBA46463B00).Init
20180802 17520044 " + ubApp.TubApp(00007FBA6293ECE0).DBExecute
20180802 17520044 " + ubApp.TubApp(00007FBA6293ECE0).TubApp.InternalDBExecute
20180802 17520044 " debug P1: String(4) mail
20180802 17520044 " + SynDBZeos.TSQLDBZEOSStatement(00007FBA5D54CCE0).ExecutePrepared
20180802 17520044 " SQL SynDBZeos.TSQLDBZEOSStatement(00007FBA5D54CCE0) SELECT A01.ID,A01.queueCode,A01.msgCmd,A01.msgData FROM ubq_messages A01 WHERE A01.queueCode=? AND A01.completeDate IS NULL LIMIT 100 OFFSET 0
20180802 17520044 " - 00.000.333
20180802 17520044 " - 00.000.385
20180802 17520044 " - 00.000.423
20180802 17520044 " debug Query result for entity "ubq_messages" into data name "": row count=0
20180802 17520044 " - 00.000.472
20180802 17520044 " - 00.000.784
20180802 17520050 " + ubMixinClasses.TubStorageMixin(00007FBA6291CC40).MixinMethod
20180802 17520050 " debug ubq_runstat.beforeinsert(TubStorageMixin)
20180802 17520050 " - 00.000.025
20180802 17520050 " + ubMixinClasses.TubStorageMixin(00007FBA6291CC40).MixinMethod
20180802 17520050 " debug ubq_runstat.insert(TubStorageMixin)
20180802 17520050 " + ubApp.TubDataStore(00007FBA4E9299E0).TubDataStore.ExecuteInsertFromList
20180802 17520050 " + ubApp.TubDataStore(00007FBA4E9299E0).TubDataStore.ExecuteInsertFromSQL
20180802 17520050 " + ubApp.TubApp(00007FBA6293ECE0).DBExecute
20180802 17520050 " + ubApp.TubApp(00007FBA6293ECE0).TubApp.InternalDBExecute
20180802 17520050 " debug P1: String(4) mail
20180802 17520050 " debug P2: DateTime 2018-08-02T17:52:00
20180802 17520050 " debug P3: DateTime 2018-08-02T17:52:00
20180802 17520050 " debug P4: Int64 1
20180802 17520050 " debug P5: String(41) Error: Login not complete: Host not found
20180802 17520050 " debug P6: Int64 3000000254036
20180802 17520050 " DB StartTransaction for connection "main"
20180802 17520050 " + SynDBZeos.TSQLDBZEOSStatement(00007FBA5D54CB80).ExecutePrepared
20180802 17520050 " SQL SynDBZeos.TSQLDBZEOSStatement(00007FBA5D54CB80) INSERT INTO ubq_runstat (schedulerName,startTime,endTime,resultError,resultErrorMsg,ID) VALUES (?,?,?,?,?,?)
20180802 17520050 " EXC EZSQLException ("SQL Error: ERROR: null value in column \"appname\" violates not-null constraint\nDETAIL: Failing row contains (3000000254036, null, mail, 2018-08-02 17:52:00.708, 2018-08-02 17:52:00.814, null, 1, Error: Login not complete: Host not found).") at 009B24E2 009AE5EE 009AD239 008A7C32 004C1924 004C2014 004CBDAA 004CD6A8 004CD312 0049D302 004997CB 004C82F9 004C7EC5 004CDD83 0051943F 00007FBA611502F8
20180802 17520050 " - 00.001.362
20180802 17520050 " - 00.001.801
20180802 17520050 " - 00.001.823
20180802 17520050 " - 00.002.185
20180802 17520050 " - 00.002.266
20180802 17520050 " - 00.002.472
20180802 17520050 " EXC /usr/local/lib/app/node_modules/@unitybase/ubq/ubq_messages.js:179\n\nError: SQL Error: ERROR: null value in column \"appname\" violates not-null constraint\nDETAIL: Failing row contains (3000000254036, null, mail, 2018-08-02 17:52:00.708, 2018-08-02 17:52:00.814, null, 1, Error: Login not complete: Host not found).\n