Re: BUG #7670: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument" - Mailing list pgsql-bugs

From Igor
Subject Re: BUG #7670: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"
Date
Msg-id CALdM5eoDkn2d6yApKAEmGpfb+UZaRVMX0kOKSz+_N1F0ZKdQSg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #7670: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: BUG #7670: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"
List pgsql-bugs
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>

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #7670: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"
Next
From: Tom Lane
Date:
Subject: Re: BUG #7670: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"