Issue Bug Closed

#80566Loggin in Scheduler fails if Executed Task Throws an Exception

Christian Wolff 03/30/17, 09:44 updated 10/17/17, 23:29

Description

If a Scheduler Tasks Throws an Exception the Scheduler Tries to log the Exception->code into sys_log.details_nr which fails

see the following message:

caller => "TYPO3\CMS\Core\Database\DatabaseConnection::exec_INSERTquery" (60 chars)
   ERROR => "Out of range value for column 'details_nr' at row 1" (51 chars)
   lastBuiltQuery => "INSERT INTO sys_log (userid,type,action,error,details_nr,details,log_data,ta
      blename,recuid,IP,tstamp,event_pid,NEWid,workspace) VALUES ('98','4','0','1'
      ,'1486473158327','[scheduler]: Task failed to execute successfully. Class: T
      YPO3\\CMS\\Extbase\\Scheduler\\Task, UID: 8. Required Option apiUrl not set
      in Mindscreen\\UserKimauth\\Configuration\\AbstractConfigurationOption','a:0
      :{}','','0','','1490782502','-1','','0')

details_nr is defined as tinyint(3) which is to short if you exception contains a longer code (like the development timestamp())
Suggested solution: log move the Exception code to the log message.

Reviews 4