Req #79137 [NEW]: Add request parameters to slow log script report

From: Date: Sun, 19 Jan 2020 11:32:43 +0000
Subject: Req #79137 [NEW]: Add request parameters to slow log script report
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-224990@lists.php.net to get a copy of this message
From: nadavkav at gmail dot com Operating system: GNU/Linux RedHat 7 PHP version: 7.3.13 Package: FPM related Bug Type: Feature/Change Request Bug description:Add request parameters to slow log script report Description: ------------ Reading the slow log report entry, I am missing important information that was passed as request parameters to the script, so I can emulate the request when I analyze the reason for that slow query. All I see now is: [19-Jan-2020 04:04:31] [pool www] pid 56016 script_filename = /var/www/moodle/index.php [0x00007fccca813b80] query() /var/www/moodle/lib/dml/mysqli_native_moodle_database.php:1257 [0x00007fccca813a20] insert_record_raw() /var/www/moodle/lib/dml/mysqli_native_moodle_database.php:1305 [0x00007fccca813920] insert_record() /var/www/moodle/lib/classes/session/manager.php:431 [0x00007fccca813880] add_session_record() /var/www/moodle/lib/classes/session/manager.php:408 [0x00007fccca8136e0] initialise_user_session() /var/www/moodle/lib/classes/session/manager.php:82 [0x00007fccca813620] start() /var/www/moodle/lib/setup.php:785 But I have no idea what parameters were passed to the query: GET https://my-web-site/index.php which could help me re-query and investigate the reason for the slow script. Please see if you can add to the slow log also the request query parameters. Expected result: ---------------- Add query parameters to the slow log report: (see: request query params = ['id' => 5, 'param' => value1] ) [19-Jan-2020 04:04:31] [pool www] pid 56016 script_filename = /var/www/moodle/index.php request query params = ['id' => 5, 'param' => value1] [0x00007fccca813b80] query() /var/www/moodle/lib/dml/mysqli_native_moodle_database.php:1257 [0x00007fccca813a20] insert_record_raw() /var/www/moodle/lib/dml/mysqli_native_moodle_database.php:1305 [0x00007fccca813920] insert_record() /var/www/moodle/lib/classes/session/manager.php:431 [0x00007fccca813880] add_session_record() /var/www/moodle/lib/classes/session/manager.php:408 [0x00007fccca8136e0] initialise_user_session() /var/www/moodle/lib/classes/session/manager.php:82 [0x00007fccca813620] start() /var/www/moodle/lib/setup.php:785 -- Edit bug report at https://bugs.php.net/bug.php?id=79137&edit=1 -- Fix committed: https://bugs.php.net/fix.php?id=79137&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=79137&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=79137&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=79137&r=needscript Try newer version: https://bugs.php.net/fix.php?id=79137&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=79137&r=support Expected behavior: https://bugs.php.net/fix.php?id=79137&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=79137&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=79137&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=79137&r=globals PHP version support discontinued: https://bugs.php.net/fix.php?id=79137&r=phptooold Daylight Savings: https://bugs.php.net/fix.php?id=79137&r=dst IIS Stability: https://bugs.php.net/fix.php?id=79137&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=79137&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=79137&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=79137&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=79137&r=mysqlcfg

« previous php.bugs (#224990) next »