Re: BUG #3901: Received error

On Jan 25, 2008 2:23 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "Chris Hoover" <revoohc@gmail.com> writes:
> > In the noon log, I have this entry:
> > 2008-01-25 12:00:00.063 EST,,,3040,,479a01f1.be0,2,,2008-01-25 10:36:17
> > EST,,0,LOG,00000,"system logger process (PID 3041) was terminated by
> signal
> > 6: Aborted",,,,,,,,
>
> > In the 1400 log, I have this entry:
> > 2008-01-25 14:00:00.898 EST,,,3040,,479a01f1.be0,3,,2008-01-25 10:36:17
> > EST,,0,LOG,00000,"system logger process (PID 3391) was terminated by
> signal
> > 6: Aborted",,,,,,,,
>
> System logger, eh?  What are all your non-default logging parameter
> settings?
>
> The corefiles are not going to be useful to anyone else with a different
> setup.  Please use gdb to get a backtrace from them yourself.
>
>                        regards, tom lane
>

Ok, I have not done much debugging.  How do I go about getting the backtrace
for you.


Here is the config settings for the log settings:
#------------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#------------------------------------------------------------------------------

# - Where to Log -

log_destination = 'syslog,csvlog'               # Valid values are
combinations of
logging_collector = on                  # Enable capturing of stderr and
csvlog
log_directory = 'pg_log'                # directory where log files are
written,
log_truncate_on_rotation = on           # If on, an existing log file of the
log_rotation_age = 1h                   # Automatic rotation of logfiles
will
log_rotation_size = 0                   # Automatic rotation of logfiles
will
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
log_min_duration_statement = 0  # -1 is disabled, 0 logs all statements
log_checkpoints = on
log_connections = on
log_disconnections = on
log_duration = on
log_line_prefix = '%d,%p,%u,%r,%p,%m,%c,%l,%s,%v,%x,%i: '
log_lock_waits = on                     # log lock waits >= deadlock_timeout
log_statement = 'all'                   # none, ddl, mod, all

Thanks,

Chris

--
Come see how to SAVE money on fuel, decrease harmful emissions, and even
make MONEY.  Visit http://colafuelguy.mybpi.com and join the revolution!