>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/