Skip site navigation (1) Skip section navigation (2)

BUG #3799: csvlog skips some logs

From: "depesz" <depesz(at)depesz(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3799: csvlog skips some logs
Date: 2007-12-05 20:34:49
Message-ID: 200712052034.lB5KYnB8062975@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
The following bug has been logged online:

Bug reference:      3799
Logged by:          depesz
Email address:      depesz(at)depesz(dot)com
PostgreSQL version: 8.3 HEAD
Operating system:   linux, 32bit
Description:        csvlog skips some logs
Details: 

when settings are set to:
# select name, setting, unit from pg_settings where name ilike 'log%' order
by name;
            name             |            setting             |  unit
-----------------------------+--------------------------------+--------
 log_autovacuum_min_duration | 0                              | ms
 log_checkpoints             | on                             | [null]
 log_connections             | on                             | [null]
 log_destination             | stderr                         | [null]
 log_directory               | pg_log                         | [null]
 log_disconnections          | off                            | [null]
 log_duration                | off                            | [null]
 log_error_verbosity         | default                        | [null]
 log_executor_stats          | off                            | [null]
 log_filename                | postgresql-%Y-%m-%d_%H%M%S.log | [null]
 logging_collector           | on                             | [null]
 log_hostname                | off                            | [null]
 log_line_prefix             | [%t] [%p] <%u(at)%d>              | [null]
 log_lock_waits              | off                            | [null]
 log_min_duration_statement  | 0                              | ms
 log_min_error_statement     | error                          | [null]
 log_min_messages            | notice                         | [null]
 log_parser_stats            | off                            | [null]
 log_planner_stats           | off                            | [null]
 log_rotation_age            | 1440                           | min
 log_rotation_size           | 102400                         | kB
 log_statement               | none                           | [null]
 log_statement_stats         | off                            | [null]
 log_temp_files              | -1                             | kB
 log_timezone                | Poland                         | [null]
 log_truncate_on_rotation    | off                            | [null]
(26 rows)

running faulty query in psql gives this output:
# select * from (select * from test);
ERROR:  subquery in FROM must have an alias
HINT:  For example, FROM (SELECT ...) [AS] foo.

and this is logged to logfile:
[2007-12-05 21:29:27 CET] [23689] <depesz(at)depesz> ERROR:  subquery in FROM
must have an alias
[2007-12-05 21:29:27 CET] [23689] <depesz(at)depesz> HINT:  For example, FROM
(SELECT ...) [AS] foo.
[2007-12-05 21:29:27 CET] [23689] <depesz(at)depesz> STATEMENT:  select * from
(select * from test);


but when i change settings to:
# select name, setting, unit from pg_settings where name ilike 'log%' order
by name;
            name             |            setting             |  unit
-----------------------------+--------------------------------+--------
 log_autovacuum_min_duration | 0                              | ms
 log_checkpoints             | on                             | [null]
 log_connections             | on                             | [null]
 log_destination             | csvlog                         | [null]
 log_directory               | pg_log                         | [null]
 log_disconnections          | off                            | [null]
 log_duration                | off                            | [null]
 log_error_verbosity         | default                        | [null]
 log_executor_stats          | off                            | [null]
 log_filename                | postgresql-%Y-%m-%d_%H%M%S.log | [null]
 logging_collector           | on                             | [null]
 log_hostname                | off                            | [null]
 log_line_prefix             | [%t] [%p] <%u(at)%d>              | [null]
 log_lock_waits              | off                            | [null]
 log_min_duration_statement  | 0                              | ms
 log_min_error_statement     | error                          | [null]
 log_min_messages            | notice                         | [null]
 log_parser_stats            | off                            | [null]
 log_planner_stats           | off                            | [null]
 log_rotation_age            | 1440                           | min
 log_rotation_size           | 102400                         | kB
 log_statement               | none                           | [null]
 log_statement_stats         | off                            | [null]
 log_temp_files              | -1                             | kB
 log_timezone                | Poland                         | [null]
 log_truncate_on_rotation    | off                            | [null]
(26 rows)
(only log_destination changed), and issue the same query only this gets
logged:

2007-12-05 21:30:42.148
CET,"depesz","depesz",47570a4e.5cfb,[local],23803,5,"idle",2007-12-05
21:30:06 CET,1/4,0,ERROR,42601,"subquery in FROM must have an alias"

output on console is the same:
# select * from (select * from test);
ERROR:  subquery in FROM must have an alias
HINT:  For example, FROM (SELECT ...) [AS] foo.


documentation doesn't inform about this kind of change (i.e. skiping parts
of logs), so it looks like a bug.

depesz

Responses

pgsql-hackers by date

Next:From: Oleg BartunovDate: 2007-12-05 20:36:59
Subject: Re: Open items for 8.3
Previous:From: Andrew DunstanDate: 2007-12-05 20:27:49
Subject: Re: buildenv.pl/buildenv.bat

pgsql-bugs by date

Next:From: Michael HanDate: 2007-12-05 23:52:05
Subject: BUG #3800: Java/Postgres PreparedStatement returns stale data
Previous:From: Tom LaneDate: 2007-12-05 03:07:44
Subject: Re: BUG #3790: pg_restore error canceling statement due touser request

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group