Bug #80566

Loggin in Scheduler fails if Executed Task Throws an Exception

Added by Christian Wolff over 4 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
Should have
Category:
scheduler
Target version:
Start date:
2017-03-30
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
7
PHP Version:
7.0
Tags:
Complexity:
easy
Is Regression:
No
Sprint Focus:

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.

#1

Updated by Thomas Hohn over 4 years ago

  • Target version set to 8 LTS
#2

Updated by Thomas Hohn over 4 years ago

  • Description updated (diff)
#3

Updated by Gerrit Code Review over 4 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52279

#4

Updated by Gerrit Code Review over 4 years ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52279

#5

Updated by Gerrit Code Review over 4 years ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52279

#6

Updated by Gerrit Code Review over 4 years ago

Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52279

#7

Updated by Christian Wolff over 4 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
#8

Updated by Gerrit Code Review over 4 years ago

  • Status changed from Resolved to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52284

#9

Updated by Gerrit Code Review over 4 years ago

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52286

#10

Updated by Markus Klein over 4 years ago

  • Status changed from Under Review to Resolved
#11

Updated by Gerrit Code Review over 4 years ago

  • Status changed from Resolved to Under Review

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52286

#12

Updated by Gerrit Code Review over 4 years ago

Patch set 1 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52292

#13

Updated by Christian Wolff over 4 years ago

  • Status changed from Under Review to Resolved
#14

Updated by Riccardo De Contardi about 4 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF