2012/11/18 Andres Freund <andres@2ndquadrant.com>
> On 2012-11-18 18:53:13 +0200, Igor wrote:
> > ..
> >
> > > Could you give a bit more context about when exactly that error is
> > > happening?
> > > It would also be helpful if you could set log_error_verbosity =
> > > 'verbose'; in the config file and report back with the complete error
> > > message, including line numbers.
> > >
> > >
> > I try to restart DB and seems get this situation:
> >
> > ===
> > 2012-11-18 18:30:25 EET pid:93744 LOG: received SIGHUP, reloading
> > configuration files
> > 2012-11-18 18:30:25 EET pid:93744 LOG: 00000: parameter
> > "log_error_verbosity" changed to "verbose"
> > 2012-11-18 18:30:25 EET pid:93744 LOCATION: ProcessConfigFile,
> > guc-file.l:318
> > 2012-11-18 18:36:45 EET pid:93744 LOG: 00000: received fast shutdown
> > request
> > 2012-11-18 18:36:45 EET pid:93744 LOCATION: pmdie, postmaster.c:2187
> > 2012-11-18 18:36:45 EET pid:93744 LOG: 00000: aborting any active
> > transactions
> > 2012-11-18 18:36:45 EET pid:93744 LOCATION: pmdie, postmaster.c:2211
> > 2012-11-18 18:36:45 EET pid:93749 LOG: 00000: autovacuum launcher
> > shutting down
> > 2012-11-18 18:36:45 EET pid:93749 LOCATION: AutoVacLauncherMain,
> > autovacuum.c:767
> > 2012-11-18 18:36:45 EET pid:93746 LOG: 00000: shutting down
> > 2012-11-18 18:36:45 EET pid:93746 LOCATION: ShutdownXLOG,
> xlog.c:7560
> > 2012-11-18 18:36:45 EET pid:93746 LOG: 00000: database system is
> shut
> > down
> > 2012-11-18 18:36:45 EET pid:93746 LOCATION: ShutdownXLOG,
> xlog.c:7582
> > 2012-11-18 18:36:46 EET pid:95528 FATAL: XX000: poll() failed:
> Invalid
> > argument
> > 2012-11-18 18:36:46 EET pid:95528 LOCATION: WaitLatchOrSocket,
> > pg_latch.c:296
> > ===
>
> Ok, this is already helpful. Do you have anything the log that shows
> what process pid 95528 is? Could you grep for it?
>
No, this string - is the last string in the log for this event.
I think, I finished the process 95528 by kill -3 (or -2) signal. I did this
after unsuccessfully report of the pg_ctl (rc.d script).
> Are you able to recompile postgres with other compilation options and/or
> some debugging patches applied?
>
Will try. Give me this patches.
> The first thing would be to recompile postgres with --enable-cassert...
>
That all ?
Do you understand my english ? :)
--
Regards
System and web developer.
<http://amkmobile.com>