pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedxlog related error
6+ messages / 3 participants
[nested] [flat]
* xlog related error
@ 2007-04-04 19:16 Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Rajesh Kumar Mallah @ 2007-04-04 19:16 UTC (permalink / raw)
To: pgsql-admin
Hi,
A friend of mine getting following error
Error: xlog flush request 0/797FED50/ is not satisfied -- flushed only
to 0/797FC1D8
CONTEXT: writing block 681 of relation 1663/10819/16520
Detail: Multiple failures -- write error may be permanent
can anyone pls suggest if its indicative of some certain
situation.
regds
mallah.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: xlog related error
@ 2007-04-04 20:10 Tom Lane <tgl@sss.pgh.pa.us>
parent: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Tom Lane @ 2007-04-04 20:10 UTC (permalink / raw)
To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>; +Cc: pgsql-admin
"Rajesh Kumar Mallah" <mallah.rajesh@gmail.com> writes:
> A friend of mine getting following error
> Error: xlog flush request 0/797FED50/ is not satisfied -- flushed only
> to 0/797FC1D8
> CONTEXT: writing block 681 of relation 1663/10819/16520
Which PG version exactly? Has he had any crashes lately? The message
means that that block contains an LSN that's past the current end of WAL,
which is a pretty suspicious situation.
The message will go away pretty soon (as soon as another 10K or so of
WAL is generated) but this looks like a symptom of a bug to me. Details
would be good.
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: xlog related error
@ 2007-04-05 03:32 Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Rajesh Kumar Mallah @ 2007-04-05 03:32 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
On 4/5/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com> writes:
> > A friend of mine getting following error
>
> > Error: xlog flush request 0/797FED50/ is not satisfied -- flushed only
> > to 0/797FC1D8
> > CONTEXT: writing block 681 of relation 1663/10819/16520
>
> Which PG version exactly? Has he had any crashes lately? The message
> means that that block contains an LSN that's past the current end of WAL,
> which is a pretty suspicious situation.
>
> The message will go away pretty soon (as soon as another 10K or so of
> WAL is generated) but this looks like a symptom of a bug to me. Details
> would be good.
The person "Ashwin" might contact the list directly.
If he does'nt i shall try my best to get the details
regds mallah.
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: xlog related error
@ 2007-04-05 06:40 Bellur Ashwin <bell_ashwin@yahoo.com>
parent: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Bellur Ashwin @ 2007-04-05 06:40 UTC (permalink / raw)
To: pgsql-admin
--- Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
wrote:
> On 4/5/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>
> writes:
> > > A friend of mine getting following error
> >
> > > Error: xlog flush request 0/797FED50/ is not
> satisfied -- flushed only
> > > to 0/797FC1D8
> > > CONTEXT: writing block 681 of relation
> 1663/10819/16520
> >
> > Which PG version exactly? Has he had any crashes
> lately? The message
> > means that that block contains an LSN that's past
> the current end of WAL,
> > which is a pretty suspicious situation.
> >
> > The message will go away pretty soon (as soon as
> another 10K or so of
> > WAL is generated) but this looks like a symptom of
> a bug to me. Details
> > would be good.
>
> The person "Ashwin" might contact the list directly.
> If he does'nt i shall try my best to get the details
>
> regds mallah.
>
> >
> > regards, tom lane
> >
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
I am using postgres-8.2.3, i have changed my
postgres.c file, in the function PostgresMain in the
case P of processing the command so that, whenever i
see a word say "tiger" as the first word of the
query, i will generate 10,000 inserts into a table and
execute them using exec_simple.
I will fire one query through jdbc beginning with the
same word "tiger".
Here after inserting 5600 inserts i get the above
ERROR message.
Any idea how to succesfully insert all those values.
Regards,
Ashwin
__________________________________________________________
Yahoo! India Answers: Share what you know. Learn something new
http://in.answers.yahoo.com/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: xlog related error
@ 2007-04-09 12:38 Bellur Ashwin <bell_ashwin@yahoo.com>
0 siblings, 1 reply; 6+ messages in thread
From: Bellur Ashwin @ 2007-04-09 12:38 UTC (permalink / raw)
To: pgsql-admin
>Rajesh Kumar Mallah <mallah ( dot ) rajesh ( at ) gmail ( dot ) com>
>wrote:
>> On 4/5/07, Tom Lane <tgl ( at ) sss ( dot ) pgh ( dot ) pa ( dot ) us> wrote:
>> > "Rajesh Kumar Mallah" <mallah ( dot ) rajesh ( at ) gmail ( dot ) com>
>> writes:
>> > > A friend of mine getting following error
>> >
>> > > Error: xlog flush request 0/797FED50/ is not
>> satisfied -- flushed only
>> > > to 0/797FC1D8
>> > > CONTEXT: writing block 681 of relation
>> 1663/10819/16520
>> >
>> > Which PG version exactly? Has he had any crashes
>> lately? The message
>> > means that that block contains an LSN that's past
>> the current end of WAL,
>> > which is a pretty suspicious situation.
>> >
>> > The message will go away pretty soon (as soon as
>> another 10K or so of
>> > WAL is generated) but this looks like a symptom of
>> a bug to me. Details
> > would be good.
> >
>> The person "Ashwin" might contact the list directly.
>> If he does'nt i shall try my best to get the details
>>
>> regds mallah.
>>
>> >
>> > regards, tom lane
>> >
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 2: Don't 'kill -9' the postmaster
>>
>I am using postgres-8.2.3, i have changed my
>postgres.c file, in the function PostgresMain in the
>case P of processing the command so that, whenever i
>see a word say "tiger" as the first word of the
>query, i will generate 10,000 inserts into a table and
>execute them using exec_simple.
>I will fire one query through jdbc beginning with the
>same word "tiger".
>Here after inserting 5600 inserts i get the above
>ERROR message.
>Any idea how to succesfully insert all those values.
>Regards,
>Ashwin
I have done pg_restore as i found in some website about this error.
Now i am not getting the error but now my postgres stops after inserting
5600(+/- 50) rows. I cant find out where the problem is
Regards,
Ashwin
__________________________________________________________
Yahoo! India Answers: Share what you know. Learn something new
http://in.answers.yahoo.com/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: xlog related error
@ 2007-04-09 14:53 Tom Lane <tgl@sss.pgh.pa.us>
parent: Bellur Ashwin <bell_ashwin@yahoo.com>
0 siblings, 0 replies; 6+ messages in thread
From: Tom Lane @ 2007-04-09 14:53 UTC (permalink / raw)
To: Bellur Ashwin <bell_ashwin@yahoo.com>; +Cc: pgsql-admin
Bellur Ashwin <bell_ashwin@yahoo.com> writes:
>> I am using postgres-8.2.3, i have changed my
>> postgres.c file, in the function PostgresMain in the
>> case P of processing the command so that, whenever i
>> see a word say "tiger" as the first word of the
>> query, i will generate 10,000 inserts into a table and
>> execute them using exec_simple.
>> I will fire one query through jdbc beginning with the
>> same word "tiger".
>> Here after inserting 5600 inserts i get the above
>> ERROR message.
>> Any idea how to succesfully insert all those values.
The odds seem extremely high that you broke something while changing
postgres.c. pgsql-admin is hardly the place to ask about hacking
backend innards...
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2007-04-09 14:53 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-04-04 19:16 xlog related error Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
2007-04-04 20:10 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-04-05 03:32 ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
2007-04-05 06:40 ` Bellur Ashwin <bell_ashwin@yahoo.com>
2007-04-09 12:38 Re: xlog related error Bellur Ashwin <bell_ashwin@yahoo.com>
2007-04-09 14:53 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox