From f0ba2a8484759d178c5c037f901e2d63a6c97192 Mon Sep 17 00:00:00 2001 From: Kyle Hall Date: Thu, 21 Jul 2022 13:12:06 -0400 Subject: [PATCH] Bug 29579: Show saved SQL report ID in database query When trying to figure out which saved SQL report caused too much load, it's useful to have the report id show in the mysql process list. This patch adds the saved SQL ID number as a comment line in front of the SQL before passing it to the database. Test Plan: 1) Apply this patch 2) Restart all the things! 3) Create a long running query like: SELECT * FROM borrowers a, borrowers b, borrowers c, borrowers d 4) Connect to the database using koha-mysql 5) Execute "show processlist;" 6) Note the Info column looks something like: SELECT * FROM borrowers a, borrowers b, borrowers c, borrowers d /* saved_sql.id: 1 */ Signed-off-by: David Nind Signed-off-by: Jonathan Druart Signed-off-by: Tomas Cohen Arazi --- Koha/Report.pm | 2 ++ 1 file changed, 2 insertions(+) diff --git a/Koha/Report.pm b/Koha/Report.pm index 176fb6e253..35d46c4c21 100644 --- a/Koha/Report.pm +++ b/Koha/Report.pm @@ -182,6 +182,8 @@ sub prep_report { } $sql =~ s/<<$split[$i*2+1]>>/$quoted/; } + + $sql = "$sql /* saved_sql.id: ${\( $self->id )} */"; return $sql, $headers; } -- 2.39.5