>
> > 2012-05-22 21:20:27.868 CEST,,,23804,,4fbbe69e.5cfc,130,,2012-05-22
> > 21:18:54 CEST,1/0,0,FATAL,XX000,"out-of-order XID insertion in
> > KnownAssignedXids","xlog redo running xacts: nextXid 3674728633
> > latestCompletedXid 3674728632 oldestRunningXid 3674726497; 4 xacts:
> > 367472704
On Wed, May 23, 2012 at 5:50 AM, Edmund Horner wrote:
> On 22 May 2012 18:49, Craig Ringer wrote:
>> When you shut down the 9.1.3 cluster did you make absolutely certain there
>> were no postgres.exe processes lurking around when you tested? Given the
>> incredible thouroughness of your report I
Cannot strace or gdb on a production system under heavy load (about 100
transactions per second).
It's in kernel space not user, so we are unable to anything at this
particular moment (sometimes even the ssh connection seems to hang for a
while).
We suspect neither autovacuum (although suspected pr
On Wednesday, May 23, 2012 12:30:31 PM Valentine Gogichashvili wrote:
> > > CEST,,0,LOG,0,"startup process (PID 23804) exited with exit code
> > > 1",""
> > > 2012-05-22 21:20:27.939 CEST,,,23793,,4fbbe69e.5cf1,2,,2012-05-22
> > > 21:18:54 CEST,,0,LOG,0,"terminating any other activ
On Wednesday, May 23, 2012 06:27:48 PM Andres Freund wrote:
> On Wednesday, May 23, 2012 12:30:31 PM Valentine Gogichashvili wrote:
> > > > CEST,,0,LOG,0,"startup process (PID 23804) exited with exit code
> > > > 1",""
> > > > 2012-05-22 21:20:27.939 CEST,,,23793,,4fbbe69e.5cf1,2,,2012-
On Wednesday, May 23, 2012 12:30:31 PM Valentine Gogichashvili wrote:
> > > 2012-05-22 21:20:27.868 CEST,,,23804,,4fbbe69e.5cfc,130,,2012-05-22
> > > 21:18:54 CEST,1/0,0,FATAL,XX000,"out-of-order XID insertion in
> > > KnownAssignedXids","xlog redo running xacts: nextXid 3674728633
> > > lates
Hello Andres,
Do you have both, longrunning transactions and transactions with many
> subtransactions?
>
> Yes long running plane SQL queries as well as many short SQL queries
running one after another in one long spanning transaction (we are working
on eliminating this kind of behavior, but it is
Sorry for the late reply. But after comparing output results of pg_dump and
other tools in SQL format, I think it will helpful if an another switch is
provided in pg_dump to output data and definition of objects of only given
type.
e.g.
pg_dump --type views
It will export only views in given form
On Wed, May 23, 2012 at 5:29 AM, Andrzej Krawiec
wrote:
> Cannot strace or gdb on a production system under heavy load (about 100
> transactions per second).
> It's in kernel space not user, so we are unable to anything at this
> particular moment (sometimes even the ssh connection seems to hang f
On Wed, May 23, 2012 at 03:20:30PM +0200, Magnus Hagander wrote:
> On Wed, May 23, 2012 at 5:50 AM, Edmund Horner wrote:
> > On 22 May 2012 18:49, Craig Ringer wrote:
> >> When you shut down the 9.1.3 cluster did you make absolutely certain there
> >> were no postgres.exe processes lurking around
On 24 May 2012 12:33, Bruce Momjian wrote:
> I have applied the attached patch which should fix the problem. How
> can we get Edmund a copy of a new binary for testing? Does he have to
> wait for beta2?
My uneducated guess is that your patch will fix the problem.
But I don't think I'm up to c
11 matches
Mail list logo
