From: | "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Possibly corrupted shared memory, PostgreSQL 8.1 beta2, Windows 2000 |
Date: | 2005-10-05 21:16:22 |
Message-ID: | di15a5$1ca1$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
""Jean-Pierre Pelletier"" <pelletier_32(at)sympatico(dot)ca> wrote in message
news:003801c5c9b0$03e08500$6401a8c0(at)JP(dot)(dot)(dot)
>
> Yes, there is an antivirus software on the machine, a reboot is needed
> when it's turned off,
> I'll be allowed to reboot it tonight or I'll do it sooner if it crashes
> before that.
>
> There are around 15 connections to PostgreSQL when it crashes but most are
> idle
> there may be a few inserts but no bulk inserts, the biggest load would
> come from
> select statements.
>
We haven't identified that the failed read/write are caused by anti-virus
software or intensive read/write. If you can compile the source, can you
patch smgrread()/smgrwrite() like this to capture the native windows error:
void
smgrwrite(SMgrRelation reln, BlockNumber blocknum, char *buffer, bool
isTemp)
{
if (!(*(smgrsw[reln->smgr_which].smgr_write)) (reln, blocknum, buffer,
isTemp))
ereport(ERROR,
(errcode_for_file_access(),
errmsg("could not write block %u of relation %u/%u/%u:%d: %m",
blocknum,
reln->smgr_rnode.spcNode,
reln->smgr_rnode.dbNode,
reln->smgr_rnode.relNode,
GetLastError())));
}
Regards,
Qingqing
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2005-10-05 22:40:38 | Re: Bug?: Text after right paren in query is ignored |
Previous Message | Jean-Pierre Pelletier | 2005-10-05 18:58:35 | Re: Possibly corrupted shared memory, PostgreSQL 8.1 beta2, Windows 2000 |