Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package pgbadger for openSUSE:Leap:16.0 checked in at 2025-08-05 09:57:01 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Leap:16.0/pgbadger (Old) and /work/SRC/openSUSE:Leap:16.0/.pgbadger.new.1085 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "pgbadger" Tue Aug 5 09:57:01 2025 rev:2 rq:1297538 version:13.1 Changes: -------- --- /work/SRC/openSUSE:Leap:16.0/pgbadger/pgbadger.changes 2025-03-19 11:54:31.941363057 +0100 +++ /work/SRC/openSUSE:Leap:16.0/.pgbadger.new.1085/pgbadger.changes 2025-08-05 09:57:04.841207112 +0200 @@ -1,0 +2,95 @@ +Sun Jul 27 16:34:43 UTC 2025 - Andreas Stieger <andreas.stie...@gmx.de> + +- fix build on Tumbleweed - add pgbadger-13.1-precedence.patch + +------------------------------------------------------------------- +Mon Mar 17 22:20:37 UTC 2025 - Marcus Rueckert <mrueck...@suse.de> + +- update to 13.1 + This is a maintenance release of pgBadger that fixes issues + reported by users since last release and adds some new features: + + - Add new report about vacuum throughput with a graph about + vacuum per table that consume the more CPU. The table output + reports I/O timing read and write per table as well as the CPU + time elapsed on the table. Thanks to Ales Zeleny for the + feature request. This patch also adds frozen pages and tuples + to the Vacuums per Table report. + - Add --no-fork option for debugging purpose to not fork + processes at all. Thanks to Ales Zeleny for the feature + request. + - Add millisecond to the raw csv output. Thanks to Henrietta + Dombrovskaya for the feature request. + - Add log filename to sample reports when multiple file are + processed. Thanks to Adrien Nayrat for the feature request. + + Here is the complete list of changes and acknowledgments: + + - Fix bind parameters parsing. Thanks to Thomas Kotzian for the + patch + - Apply query filter on multi-lines queries. Thanks to Benjamin + Jacobs for the patch + - Update test result for log filename storage changes + - Fix ERROR vs LOG message level in json output. Thanks to + Philippe Viegas for the report. + - Remove import of tmpdir not exported method from File::Temp. + Thanks to kmoradha for the report. + +------------------------------------------------------------------- +Sun Dec 8 08:36:50 UTC 2024 - Marcus Rueckert <mrueck...@suse.de> + +- update to 13.0 + This is a major release of pgBadger that fixes issues reported by + users since last release and adds some new features: + + - Add two new option to be able to redefined inbound of query and + session histogram. Thanks to JosefMachytkaNetApp for the + feature request. + --histogram-query VAL : use custom inbound for query + times histogram. + Default inbound in milliseconds: + 0,1,5,10,25,50,100,500,1000,10000 + --histogram-session VAL : use custom inbound for session + times histogram. + Default inbound in milliseconds: + 0,500,1000,30000,60000,600000, + 1800000,3600000,28800000 + - Add support of auto_explain plan for csv and json log formats. + Thanks to zxwsbg and to Alexander Rumyantsev for the report. + - Add three LOG message that was not reported as events: + unexpected EOF, incomplete startup packet and detected deadlock + while waiting for. Thanks to dottle for the report. + + Backward compatibility issues: + - Change the way LOG level events reported in the Events reports + are stored. Some of them was still reported and counted as + errors instead as LOG level entries. The fix is to stored and + report them as EVENTLOG to differentiate them from queries. + This change introduce a backward compatibility break when + pgbadger is used in incremental mode. You will just have the + double behavior during the week of the upgrade. Thanks to Matti + Linnanvuori for the report. + + Bug fixes: + - Fix non reported queries generating the most cancellation due + to statement_timeout. + - Update regression tests + - Fix formatting of explain plan when extracted from csv log + format. + - Fix jsonlog missing autovacuum data reports: Average Autovacuum + Duration, Tuples removed per table and vacuums by hour in + autovacuum activity report. Thanks to Ales Zeleny for the + patch. + - Fix orphan line not associated to the time consuming bind + queries. Thanks to Henrietta Dombrovskaya for the report. Fix + use of uninitialized value in pattern match. Thanks to Junior + Dias for the patch. + - Apply option --csv-separator to raw export to CSV. Default + separator is semicolon (;). Thanks to Henrietta Dombrovskaya + for the feature request. + - Raw csv output: do not add double quote to parameters and + application name if they are empty. + - Add double quotes when queries have a semi colon in raw csv + output. Thanks to Henrietta Dombrovskaya for the report. + +------------------------------------------------------------------- Old: ---- pgbadger-12.4.tar.gz New: ---- pgbadger-13.1-precedence.patch pgbadger-13.1.tar.gz ----------(New B)---------- New: - fix build on Tumbleweed - add pgbadger-13.1-precedence.patch ----------(New E)---------- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ pgbadger.spec ++++++ --- /var/tmp/diff_new_pack.6oAMP4/_old 2025-08-05 09:57:05.137219557 +0200 +++ /var/tmp/diff_new_pack.6oAMP4/_new 2025-08-05 09:57:05.137219557 +0200 @@ -1,7 +1,9 @@ # # spec file for package pgbadger # +# Copyright (c) 2025 SUSE LLC # Copyright (c) 2013-2015 Lars Vogdt +# Copyright (c) 2025 Andreas Stieger <andreas.stie...@gmx.de> # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed @@ -12,9 +14,10 @@ # license that conforms to the Open Source Definition (Version 1.9) # published by the Open Source Initiative. -# Please submit bugfixes or comments via http://bugs.opensuse.org/ +# Please submit bugfixes or comments via https://bugs.opensuse.org/ # + %if 0%{?is_opensuse} %bcond_without jsonxs %else @@ -28,45 +31,46 @@ %endif Name: pgbadger -Version: 12.4 +Version: 13.1 Release: 0 License: MIT Summary: A fast PostgreSQL log analyzer -Url: https://pgbadger.darold.net/ +URL: https://pgbadger.darold.net/ Group: System/Monitoring Source0: https://github.com/darold/%{name}/archive/refs/tags/v%{version}.tar.gz#/%{name}-%{version}.tar.gz Source1: %{name}-cron Source2: %{name}.timer Source3: %{name}.service Source4: README.SUSE +Patch0: pgbadger-13.1-precedence.patch BuildRequires: cron BuildRequires: perl +BuildRequires: perl(Benchmark) +BuildRequires: perl(File::Basename) BuildRequires: perl(Getopt::Long) BuildRequires: perl(IO::File) BuildRequires: perl(Pod::Markdown) -BuildRequires: perl(Benchmark) -BuildRequires: perl(File::Basename) -BuildRequires: perl(Time::Local) BuildRequires: perl(Text::CSV_XS) +BuildRequires: perl(Time::Local) %if %{with jsonxs} BuildRequires: perl(JSON::XS) %endif BuildRequires: sed -Requires: perl(Getopt::Long) -Requires: perl(IO::File) +Requires: perl = %{perl_version} Requires: perl(Benchmark) +Requires: perl(Encode) Requires: perl(File::Basename) -Requires: perl(Storable) Requires: perl(File::Spec) Requires: perl(File::Temp) +Requires: perl(FileHandle) +Requires: perl(Getopt::Long) +Requires: perl(IO::File) Requires: perl(IO::Handle) Requires: perl(IO::Pipe) -Requires: perl(FileHandle) Requires: perl(Socket) -Requires: perl(Encode) +Requires: perl(Storable) Requires: perl(Text::Wrap) Requires: perl(Time::Local) -Requires: perl = %{perl_version} %{?systemd_ordering} %if %{with cron} ++++++ pgbadger-13.1-precedence.patch ++++++ >From 6c388d02d2ac48fbcef742e417dd490308250595 Mon Sep 17 00:00:00 2001 From: Gilles Darold <gil...@darold.net> Date: Fri, 18 Jul 2025 23:52:36 +0200 Subject: [PATCH] Fix possible precedence problem between ! and string eq. Thanks to Adrien Nayrat for the report. --- pgbadger | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/pgbadger b/pgbadger index 5ed62d1..11bd290 100755 --- a/pgbadger +++ b/pgbadger @@ -20462,7 +20462,7 @@ sub highlight_code # lowercase/uppercase known functions or words followed by an open parenthesis # if the token is not a keyword, an open parenthesis or a comment if (($self->_is_function( $token, $last_token, $next_token ) && $next_token eq '(') - || (!$self->_is_keyword( $token, $next_token, $last_token ) && !$next_token eq '(' + || (!$self->_is_keyword( $token, $next_token, $last_token ) && $next_token ne '(' && $token ne '(' && !$self->_is_comment( $token )) ) { if ($self->{ 'uc_functions' } == 1) { $token = '<span class="kw2_l">' . $token . '</span>'; @@ -23062,7 +23062,7 @@ sub _add_token # if the token is not a keyword, an open parenthesis or a comment my $fct = $self->_is_function( $token, $last_token, $next_token ) || ''; if (($fct and $next_token eq '(' and defined $last_token and uc($last_token) ne 'CREATE') - or (!$self->_is_keyword( $token, $next_token, $last_token ) and !$next_token eq '(' + or (!$self->_is_keyword( $token, $next_token, $last_token ) and $next_token ne '(' and $token ne '(' and !$self->_is_comment( $token )) ) { $token =~ s/$fct/\L$fct\E/i if ( $self->{ 'uc_functions' } == 1 ); ++++++ pgbadger-12.4.tar.gz -> pgbadger-13.1.tar.gz ++++++ ++++ 2094 lines of diff (skipped)
