Req #79137 [NEW]: Add request parameters to slow log script report
| From: | nadavkav at gmail dot com | 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