]>
granicus.if.org Git - pgbadger/log
Gilles Darold [Wed, 31 Aug 2016 20:26:08 +0000 (22:26 +0200)]
Fix duplicate copy icon in locks report.
Gilles Darold [Wed, 31 Aug 2016 17:29:51 +0000 (19:29 +0200)]
Forgot to update the README with embedded truetype font change.
Gilles Darold [Wed, 31 Aug 2016 17:27:56 +0000 (19:27 +0200)]
Replace embedded fontawesome-webfont.ttf with FontAwesome.otf. Thanks to Christoph Berg for the report.
Gilles Darold [Wed, 31 Aug 2016 14:35:16 +0000 (16:35 +0200)]
Merge branch 'master' of github.com:dalibo/pgbadger
Gilles Darold [Wed, 31 Aug 2016 14:34:58 +0000 (16:34 +0200)]
Fix missing chart on histogram of session time. Thanks to Guillaume Lelarge for the report.
Darold [Wed, 31 Aug 2016 11:27:50 +0000 (13:27 +0200)]
Merge pull request #300 from credativ/resource-licenses
Add LICENSE file noting the licenses used by the resource files
Christoph Berg [Wed, 31 Aug 2016 11:23:46 +0000 (13:23 +0200)]
Add LICENSE file noting the licenses used by the resource files
Darold [Wed, 31 Aug 2016 10:16:40 +0000 (12:16 +0200)]
Merge pull request #299 from credativ/updt_embedded_rsc
Minor fixes to the updt_embedded_rsc mechanism
Christoph Berg [Wed, 31 Aug 2016 10:01:28 +0000 (12:01 +0200)]
Minor fixes to the updt_embedded_rsc mechanism
Don't add a new newline before __DATA__ (and remove the newlines
accumulated so far); create resources/min/ for temporary files (and add
it to .gitignore); fix a typo.
Gilles Darold [Tue, 30 Aug 2016 17:25:51 +0000 (19:25 +0200)]
Add patch to jqplot library to fix an infinite loop when trying to download
some charts. Thanks to Julien Tachoires for the help to solve this issue.
Script tools/updt_embedded_rsc.pl will apply the patch to resource file
resources/jquery.jqplot.js and doesn't complain if it has already been
applied.
Gilles Darold [Tue, 30 Aug 2016 15:11:34 +0000 (17:11 +0200)]
Remove single last comma at end of piechart dataset. Thanks to Julien Tachoires for the report.
Gilles Darold [Tue, 30 Aug 2016 15:09:52 +0000 (17:09 +0200)]
Change display of normalized error
Gilles Darold [Tue, 30 Aug 2016 12:52:05 +0000 (14:52 +0200)]
Remove unused or autogenerated files
Gilles Darold [Tue, 30 Aug 2016 12:44:05 +0000 (14:44 +0200)]
Update all resources files (js+css) and create a directory to include
source of javascript libraries used in pgbadger. There is also a new
script tools/updt_embedded_rsc.pl the can be used to generate the
minified version of those files and embedded them into pgbadger.
This script will also embedded the fontawesome-webfont.ttf truetype
font into the fontawesome.css file. At this point it still need some
works especialy for backward compatibility with old version of the
badger.
Thanks to Christoph Berg for the feature request.
Gilles Darold [Sat, 27 Aug 2016 08:17:13 +0000 (10:17 +0200)]
Update ChangeLog and version to 8.3.
Gilles Darold [Thu, 18 Aug 2016 16:25:59 +0000 (18:25 +0200)]
Add replication command message statistics to the Events reports. Thanks to Michael Paquier for the feature request.
Gilles Darold [Thu, 18 Aug 2016 16:15:10 +0000 (18:15 +0200)]
Fix autodetection of stderr format with timestamp as epoch (%n).
Gilles Darold [Thu, 18 Aug 2016 14:18:36 +0000 (16:18 +0200)]
Fix histogram over multiples days to be cumulative per hour, not an average of the number of event per day.
Gilles Darold [Thu, 18 Aug 2016 13:46:32 +0000 (15:46 +0200)]
Fix parsing of remote file that was failing when the file does not exists locally. Thanks to clomdd for the report.
Darold [Thu, 18 Aug 2016 12:42:56 +0000 (14:42 +0200)]
Merge pull request #294 from jacksonfoz/master
Detect timezones like GMT+3 on CSV logs
jacksonfoz [Thu, 18 Aug 2016 12:31:27 +0000 (09:31 -0300)]
Detect timezones like GMT+3 on CSV logs
During the execution of pgbadger lines like this are not autodetected as csv:
2016-08-18 08:31:00.365 GMT+3,"user_project","devdb",16576,"172.17.43.32:59633",
57b59c74 .40c0,2,"",2016-08-18 08:31:00 GMT+3,,0,FATAL,57P03,"the database system is shutting down",,,,,,,,,""
Gilles Darold [Thu, 11 Aug 2016 14:51:15 +0000 (16:51 +0200)]
Update Changelog and version to 8.2
Gilles Darold [Thu, 11 Aug 2016 12:27:32 +0000 (14:27 +0200)]
Fix report of database system messages.
Gilles Darold [Wed, 10 Aug 2016 18:01:20 +0000 (20:01 +0200)]
Fix report of deadlock and error with detail+statement and pl/pgSQL statement.
Gilles Darold [Wed, 10 Aug 2016 16:44:53 +0000 (18:44 +0200)]
Fix multiline statement concatenation after an error.
Fix box size for report of queries generatin the most
temporary files and the most waiting queries.
Gilles Darold [Mon, 8 Aug 2016 20:18:40 +0000 (22:18 +0200)]
Rewrite code to better handle temporary file queries with multiline queries.
Gilles Darold [Fri, 5 Aug 2016 15:58:28 +0000 (17:58 +0200)]
Put all work on syslog and stderr orphan lines in a single method parse_orphan_line().
Gilles Darold [Fri, 5 Aug 2016 11:27:48 +0000 (13:27 +0200)]
Fix garbage in event examples queries in error only mode (-w). Thanks to Thomas Reiss for the report.
Darold [Fri, 5 Aug 2016 09:15:32 +0000 (11:15 +0200)]
Merge pull request #293 from tom--bo/auto_explain
Fix getting dataset related to query duration when using auto_explain…
tom--bo [Fri, 5 Aug 2016 08:56:50 +0000 (17:56 +0900)]
Fix getting dataset related to query duration when using auto_explain logs.
Gilles Darold [Thu, 4 Aug 2016 15:41:04 +0000 (17:41 +0200)]
Download of graph are now done through a modal dialog window.
Darold Gilles [Mon, 1 Aug 2016 09:30:32 +0000 (11:30 +0200)]
Fix compiled prefix when a log line prefix is specified, this issue is related to the last parsed mechanism rewrite.
Gilles Darold [Fri, 29 Jul 2016 22:29:29 +0000 (00:29 +0200)]
Huge rewrite of the incremental mechanism applied to log files to handle PostgreSQL and pgbouncer logs at the same time. Multiprocess can now be used with pgbouncer log.
Gilles Darold [Thu, 28 Jul 2016 13:57:13 +0000 (15:57 +0200)]
Revert "Fix description of -l | --last-parsed option."
This reverts commit
1463129df1ff0961249a3ea6a0645f1489033e9b .
Gilles Darold [Thu, 28 Jul 2016 13:26:00 +0000 (15:26 +0200)]
Fix description of -l | --last-parsed option.
Gilles Darold [Tue, 5 Jul 2016 15:23:19 +0000 (17:23 +0200)]
Add code to remove remaining $$PGBGYA$$ tags.
Darold Gilles [Fri, 1 Jul 2016 13:00:34 +0000 (15:00 +0200)]
Remove a debug line.
Darold Gilles [Thu, 30 Jun 2016 09:44:58 +0000 (11:44 +0200)]
Fix an other possible case of truncated date in LAST_PARSED file. Thanks to brafaeloliveira for the report.
Darold Gilles [Wed, 22 Jun 2016 10:50:08 +0000 (12:50 +0200)]
Set default scale to 1 in pretty_print_number() javascript function.
Darold Gilles [Wed, 22 Jun 2016 10:25:25 +0000 (12:25 +0200)]
Fix autodetection of PgBouncer files containing only stats lines. Thanks to Glyn Astill for the patch.
Darold Gilles [Wed, 15 Jun 2016 13:56:00 +0000 (15:56 +0200)]
Add date to samples of queries generating most temporary files.
Gilles Darold [Fri, 10 Jun 2016 16:27:56 +0000 (18:27 +0200)]
Fix other case of warning message of empty file.
Gilles Darold [Fri, 10 Jun 2016 16:24:50 +0000 (18:24 +0200)]
Merge branch 'master' of github.com:dalibo/pgbadger
Gilles Darold [Fri, 10 Jun 2016 16:24:26 +0000 (18:24 +0200)]
DOn not display warning message of empty log when quiet mode is enable.
Darold [Thu, 9 Jun 2016 20:43:53 +0000 (22:43 +0200)]
Merge pull request #282 from robertvargason/read_from_stdin_hotfix
Fix reading from stdin by disabling pgbouncer file format detection
Robert Vargason [Thu, 9 Jun 2016 08:41:34 +0000 (10:41 +0200)]
Fix reading from stdin by disabling pgbouncer file format detection
Gilles Darold [Thu, 9 Jun 2016 07:35:47 +0000 (09:35 +0200)]
Fix case of duplicate normalyzed error message with "nonstandard use of ...".
Darold Gilles [Sat, 4 Jun 2016 09:42:12 +0000 (20:42 +1100)]
Fix storage of current temporary file related request.
Darold [Mon, 23 May 2016 20:32:26 +0000 (07:32 +1100)]
Merge pull request #278 from komeda-shinji/master
We should use the mnemonic rather than a signal number.
KOMEDA Shinji [Mon, 23 May 2016 11:06:08 +0000 (20:06 +0900)]
We should use the mnemonic rather than a signal number.
Gilles Darold [Thu, 21 Apr 2016 14:05:38 +0000 (16:05 +0200)]
Update ChangeLog and version to 8.1.
Darold Gilles [Mon, 18 Apr 2016 17:15:01 +0000 (19:15 +0200)]
Fix case where pid file remain after dying.
Darold Gilles [Mon, 18 Apr 2016 08:07:49 +0000 (10:07 +0200)]
Add requirement of log_error_verbosity = default to documentation.
Darold Gilles [Thu, 31 Mar 2016 16:34:50 +0000 (18:34 +0200)]
Report message "LOG: using stale statistics instead of current ones because stats collector is not responding" in events view.
Darold Gilles [Fri, 25 Mar 2016 08:51:53 +0000 (09:51 +0100)]
Remove obsolte days when we are in binary mode with noreport
Darold Gilles [Tue, 22 Mar 2016 14:16:52 +0000 (15:16 +0100)]
Fix wrong report of statements responsible of temporary files. Thanks to Luan Nicolini Marcondes for the report. This patch also exclude lien with log level LOCATION to be parsed.
Darold Gilles [Thu, 17 Mar 2016 15:01:05 +0000 (16:01 +0100)]
Fix limit on number of sample at report generation and remove pending LAST_PARSED.tmp file.
Darold Gilles [Thu, 17 Mar 2016 12:37:44 +0000 (13:37 +0100)]
Add tool to export errors statistics rport in docuwiki format.
Darold Gilles [Thu, 17 Mar 2016 12:35:57 +0000 (13:35 +0100)]
Update load_stat() function and global variables to support pgbouncer statistics. Update version to 2.0.
Darold [Mon, 14 Mar 2016 15:04:14 +0000 (16:04 +0100)]
Merge pull request #267 from rjuju/expand_query_type
Handle more kind or query types.
Julien Rouhaud [Mon, 14 Mar 2016 14:22:56 +0000 (15:22 +0100)]
Handle more kind or query types.
Darold Gilles [Mon, 14 Mar 2016 13:44:44 +0000 (14:44 +0100)]
Fix pgbouncer log parser to handle message: FATAL: the database system is shutting down
Darold Gilles [Sat, 12 Mar 2016 11:02:30 +0000 (12:02 +0100)]
Merge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Sat, 12 Mar 2016 11:02:16 +0000 (12:02 +0100)]
Fix whitespace placed in between the E and the quote character. Thanks to clijunky for the report.
Darold Gilles [Wed, 24 Feb 2016 15:24:07 +0000 (16:24 +0100)]
Merge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Wed, 24 Feb 2016 15:23:50 +0000 (16:23 +0100)]
Fix a major issue introduced with support to pgbouncer that prevent parsing of compressed PostgreSQL log files. Thanks to Levente Birta for the report.
Darold Gilles [Mon, 22 Feb 2016 11:12:44 +0000 (12:12 +0100)]
Update ChangeLog and version to 8.0
Darold Gilles [Mon, 22 Feb 2016 11:09:48 +0000 (12:09 +0100)]
Update documentation about new options and pgbouncer reports.
Darold Gilles [Mon, 22 Feb 2016 11:04:25 +0000 (12:04 +0100)]
Fix typo in pgbouncer report.
Darold Gilles [Fri, 19 Feb 2016 19:32:49 +0000 (20:32 +0100)]
Add report about Most used reserved pools
Darold Gilles [Fri, 19 Feb 2016 13:47:44 +0000 (14:47 +0100)]
Fix progress bar with pgbouncer (only events are increased).
Darold Gilles [Fri, 19 Feb 2016 10:44:29 +0000 (11:44 +0100)]
Add reports on pgBouncer log file.
Darold Gilles [Sun, 14 Feb 2016 09:24:32 +0000 (10:24 +0100)]
fix an other operator order issue.
Darold [Sun, 14 Feb 2016 09:21:08 +0000 (10:21 +0100)]
Merge pull request #265 from nginfo/master
Sort %SYMBOLS hashtable to remove "!=" / "=" bug.
Nicolas [Sat, 13 Feb 2016 19:30:49 +0000 (20:30 +0100)]
Sort %SYMBOLE hashtable for remove "!=" / "=" bug.
Darold Gilles [Sat, 6 Feb 2016 09:56:21 +0000 (10:56 +0100)]
Fix incorrect numbers on positional parameters in queries-generating-most-temporary-files. Thanks to Oskar Wiksten for the report.
Darold Gilles [Sat, 6 Feb 2016 09:27:06 +0000 (10:27 +0100)]
Update operators list in SQL code beautifier with last update in pgFormatter. Thanks to Laurenz Albe for the report and the list of missing operators.
Darold Gilles [Tue, 19 Jan 2016 22:21:48 +0000 (23:21 +0100)]
Cosmetic change to code and add some more debug information.
Darold Gilles [Tue, 19 Jan 2016 20:13:21 +0000 (21:13 +0100)]
Add --rebuild option to be able to rebuild all html reports in an incremental output directory where there is binary data files.
Darold Gilles [Mon, 18 Jan 2016 20:45:17 +0000 (21:45 +0100)]
Fix an other major bug introduced with journalctl code that prevent the use of the multiprocess.
Darold Gilles [Mon, 18 Jan 2016 10:22:37 +0000 (11:22 +0100)]
Update changelog and version to 7.3
Darold Gilles [Mon, 18 Jan 2016 09:11:51 +0000 (10:11 +0100)]
Automatically remove obsolete pid file when there is no other pgbadger process running (unix only)
Darold Gilles [Fri, 15 Jan 2016 23:17:05 +0000 (00:17 +0100)]
Update documentation about the --timezone command line option.
Darold Gilles [Fri, 15 Jan 2016 23:14:43 +0000 (00:14 +0100)]
Add --timezone=+/-HH to control the timezone used in charts. The javascript library runs at client side so the timezone used is the browser timezone so the displayed time in the charts can be different from the time in the log file. Thanks to CZAirwolf for the report.
Darold Gilles [Fri, 15 Jan 2016 21:49:39 +0000 (22:49 +0100)]
Fix Histogram of session times when there is no data.
Darold Gilles [Fri, 15 Jan 2016 21:45:58 +0000 (22:45 +0100)]
Fix unclosed test file.
Darold Gilles [Fri, 15 Jan 2016 21:38:16 +0000 (22:38 +0100)]
Fix an other case where pgbadger.pid was not removed.
Darold Gilles [Fri, 15 Jan 2016 21:35:05 +0000 (22:35 +0100)]
Always display slides part on connections report even if there is no data.
Darold Gilles [Fri, 15 Jan 2016 21:33:23 +0000 (22:33 +0100)]
Fix some label on sessions reports
Darold Gilles [Fri, 15 Jan 2016 21:29:35 +0000 (22:29 +0100)]
Add remove of pid file at normal ending.
Darold Gilles [Fri, 15 Jan 2016 13:04:18 +0000 (14:04 +0100)]
Fix wrong size/offset of log files that was breaking incremental mode. Thanks a lot to CZAirwolf for the report and the help to find the problem.
Darold Gilles [Fri, 15 Jan 2016 13:01:40 +0000 (14:01 +0100)]
Revert "Fix wrong size/offset of log files with unicode characters that was breaking incremental mode. Thanks a lot to CZAirwolf for the report and the help to find the problem."
This reverts commit
8775053eb06a2c2bf8fd6995e1f42ea82e3c88b3 .
Darold Gilles [Fri, 15 Jan 2016 12:46:33 +0000 (13:46 +0100)]
Fix wrong size/offset of log files with unicode characters that was breaking incremental mode. Thanks a lot to CZAirwolf for the report and the help to find the problem.
Darold Gilles [Thu, 14 Jan 2016 21:17:33 +0000 (22:17 +0100)]
Add command line option --pid-dir to be able to run two pgbadger at the same time
by setting an alternate path to the directory where the pid file will be written.
Darold Gilles [Thu, 14 Jan 2016 21:11:37 +0000 (22:11 +0100)]
Add pgbadger.pid file to prevent cron jobs overlaping on same log files.
Darold Gilles [Thu, 14 Jan 2016 15:48:36 +0000 (16:48 +0100)]
Report information about "LOG: skipping analyze of ..." into events reports.
Darold Gilles [Thu, 14 Jan 2016 14:12:52 +0000 (15:12 +0100)]
Report information about "LOG: sending cancel to blocking autovacuum" into events reports. Usefull to know which queries generate autovacuum kill do to a lock issue.
Darold Gilles [Wed, 13 Jan 2016 15:02:41 +0000 (16:02 +0100)]
Add more debug information about check log parsing decision.
Darold Gilles [Wed, 6 Jan 2016 08:37:02 +0000 (09:37 +0100)]
Update version to 7.2
Darold Gilles [Tue, 5 Jan 2016 19:40:11 +0000 (20:40 +0100)]
Update ChangeLog and version to 7.2