[MDL-74182] showcrondebugging not obeyed by scheduled task cli tool - Moodle Tracker

XML

Word

Printable

Details

Type: Bug
Status: Closed
Priority: Minor
Resolution: Fixed
Affects Version/s: 3.11.5
Fix Version/s: 3.11.8, 4.0.2
Component/s: Tasks
Labels:
- ci
- triaged

Affected Branches:
MOODLE_311_STABLE
Fixed Branches:
MOODLE_311_STABLE, MOODLE_400_STABLE
Pull from Repository:
https://github.com/ericmerrill/moodle.git
Pull 3.11 Branch:
~~MDL-74182~~-311
Pull 3.11 Diff URL:
https://github.com/ericmerrill/moodle/compare/4f5ad93e83...MDL-74182-311
Pull Master Branch:
~~MDL-74182~~-master
Pull Master Diff URL:
https://github.com/ericmerrill/moodle/compare/967d9b2546...MDL-74182-master

Testing Instructions:

Hide

Create some forums and posts in those

Run

php admin/cli/scheduled_task.php --execute=\\mod_forum\\task\\cron_task --showsql

Observe SQL output something like:

SELECT pg_advisory_unlock($1, $2) AS unlocked

[array (

  0 => -831030149,

  1 => 2127591,

)]

--------------------------------

Query took: 0.00011992454528809 seconds.

--------------------------------

Run

php admin/cli/scheduled_task.php --execute=\\mod_forum\\task\\cron_task

Check the SQL output now doesn't display any SQL query

Edit config.php and set $CFG->showcronsql = true; run

php admin/cli/scheduled_task.php --execute=\\mod_forum\\task\\cron_task

Check that you still can see SQL output

Show

Create some forums and posts in those Run php admin/cli/scheduled_task.php --execute=\\mod_forum\\task\\cron_task --showsql Observe SQL output something like: SELECT pg_advisory_unlock($ 1 , $ 2 ) AS unlocked [array ( 0 => - 831030149 , 1 => 2127591 , )] -------------------------------- Query took: 0.00011992454528809 seconds. -------------------------------- Run php admin/cli/scheduled_task.php --execute=\\mod_forum\\task\\cron_task Check the SQL output now doesn't display any SQL query Edit config.php and set $CFG->showcronsql = true; run php admin/cli/scheduled_task.php --execute=\\mod_forum\\task\\cron_task Check that you still can see SQL output

Description

The scheduled_task CLI tool does not obey $CFG->showcrondebugging and showcronsql. While it does have separate flags that can enable it, adhoc_task.php does follow the $CFG values, while scheduled.php does not.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

MDL-74182_step 4.png
51 kB
08/Jun/22 5:25 PM
MDL-74182_step 6.png
91 kB
08/Jun/22 5:25 PM

Activity

People

Assignee:: Eric Merrill

Reporter:: Eric Merrill

Peer reviewer:: Simey Lameze

Integrator:: Sara Arjona (@sarjona)

Tester:: Angelia Dela Cruz

Participants:: Angelia Dela Cruz, CiBoT, Eric Merrill, Ilya Tregubov, Sara Arjona (@sarjona), Simey Lameze

Component watchers:: David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 12/Mar/22 3:37 AM

Updated:: 10/Jun/22 11:47 PM

Resolved:: 10/Jun/22 11:47 PM

Fix Release Date:: 11/Jul/22

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

1h 6m