pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL Database freezes during backup then generates drwtsn.exe process
3+ messages / 3 participants
[nested] [flat]
* PostgreSQL Database freezes during backup then generates drwtsn.exe process
@ 2008-12-02 14:01 Ward Eaton <Ward.Eaton@rad-con.com>
0 siblings, 2 replies; 3+ messages in thread
From: Ward Eaton @ 2008-12-02 14:01 UTC (permalink / raw)
To: pgsql-admin
I'm running PostgreSQL 8.3 on a Windows 2003 machine (pgAgent service is
also installed and running). The system is running as a redundant
database server. Thus, backing up from one machine to another, and
transferring over WAL logs. In the postageSQL log files there are
several error messages that read:
'could not rename file, no such file or directory'
Eventually, postgreSQL 'freezes', I'm unable to access the database, and
there is no logging. I find a drwtsn.exe process running under the
postgres account in Task Manager. If I kill the drwtsn PostgreSQL
service will stop. I can then restart it and the database will run as
expected for a few days.
Has anyone encountered this problem before? If so, were you able to
find a solution?
Thanks for any help in advance.
Ward Eaton
Project Engineer Automation
RAD-CON Inc.
TECHNOLOGY: Innovative & Proven
Office: +1.216.706.8927
Fax: +1.216.221.1135
Website: www.RAD-CON.com <http://www.rad-con.com/;
E-mail: Ward.Eaton@RAD-CON.com <mailto:Ward.Eaton@RAD-CON.com>
Attachments:
image002.jpg (image/jpeg, 2.8K) download
view image
* Re: PostgreSQL Database freezes during backup then generates drwtsn.exe process
@ 2008-12-02 20:16 Steve Crawford <scrawford@pinpointresearch.com>
parent: Ward Eaton <Ward.Eaton@rad-con.com>
1 sibling, 0 replies; 3+ messages in thread
From: Steve Crawford @ 2008-12-02 20:16 UTC (permalink / raw)
To: Ward Eaton <Ward.Eaton@rad-con.com>; +Cc: pgsql-admin
Ward Eaton wrote:
>
> I'm running PostgreSQL 8.3 on a Windows 2003 machine (pgAgent service
> is also installed and running). The system is running as a redundant
> database server. Thus, backing up from one machine to another, and
> transferring over WAL logs. In the postageSQL log files there are
> several error messages that read:
>
> 'could not rename file, no such file or directory'
>
>
>
> Eventually, postgreSQL 'freezes', I'm unable to access the database,
> and there is no logging. I find a drwtsn.exe process running under
> the postgres account in Task Manager. If I kill the drwtsn PostgreSQL
> service will stop. I can then restart it and the database will run as
> expected for a few days.
>
>
>
From back when I had to use Windows, I recall Dr. Watson as a debugging
tool that collects program crash data. But I think that is drwtsn32.exe.
It appears that drwtsn.exe is some form of malware - Google for more
info. Before proceeding with PostgreSQL troubleshooting, I'd make sure
that the machine itself is fully cleansed and checked.
Cheers,
Steve
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PostgreSQL Database freezes during backup then generates drwtsn.exe process
@ 2008-12-02 22:32 Bob Lunney <bob_lunney@yahoo.com>
parent: Ward Eaton <Ward.Eaton@rad-con.com>
1 sibling, 0 replies; 3+ messages in thread
From: Bob Lunney @ 2008-12-02 22:32 UTC (permalink / raw)
To: pgsql-admin@postgresql.org, Ward Eaton <Ward.Eaton@rad-con.com>
Ward,
I've experienced the exact problem you describe. The two machines where identical in every way: make, model, disk layout, OS, etc., and this scenario happens regardless of which machine was the primary and which was the warm-standby. Note I was not running pgAgent.
I was using pg_standby to implement copying of WAL files between machines. It would copy the WAL file to a network shared directory, where the warm-standby would pick up the file and use it, until the fatal error you describe happened.
I had discovered that during a copy operation Windows will allocate the entire file size on the target prior to completing the file copy. This differs from Unix, and may have something to do with the errors we are seeing. I'm speculating here, but I believe when the recovery code "sees" a 16 Mb file it thinks the entire file contents are available, which is not necessarily the case with Windows.
I know some folks recommend rsync, but that requires installing cygwin and my client isn't happy with that idea. Possibly copying the WAL file to a temporary location, then moving it to the target location may mitigate the problem, since move operations (on the same disk drive, anyway) in Windows simpy rejigger the file descriptor and don't reallocate any disk space. I haven't tried it yet, but I'm moving in that direction.
Regards,
Bob Lunney
--- On Tue, 12/2/08, Ward Eaton <Ward.Eaton@rad-con.com> wrote:
From: Ward Eaton <Ward.Eaton@rad-con.com>
Subject: [ADMIN] PostgreSQL Database freezes during backup then generates drwtsn.exe process
To: pgsql-admin@postgresql.org
Date: Tuesday, December 2, 2008, 9:01 AM
I¢m running PostgreSQL 8.3 on a Windows
2003 machine (pgAgent service is also installed and
running). The system is running as a redundant database server. Thus, backing
up from one machine to another, and transferring over WAL logs. In the postageSQL
log files there are several error messages that read:
¡could not rename file, no such file or directory¢
Eventually, postgreSQL ¡freezes¢, I¢m
unable to access the database, and there is no logging. I find a drwtsn.exe
process running under the postgres account in Task Manager. If I kill the
drwtsn PostgreSQL service will stop. I can then restart it and the database
will run as expected for a few days.
Has anyone encountered this problem before? If so, were you
able to find a solution?
Thanks for any help in advance.
Ward Eaton
Project
Engineer Automation
RAD-CON Inc.
TECHNOLOGY: Innovative &
Proven
Office:
+1.216.706.8927
Fax:
+1.216.221.1135
Website: www.RAD-CON.com
E-mail: Ward.Eaton@RAD-CON.com
Attachments:
image002.jpg (image/jpeg, 2.8K) download
view image
end of thread, other threads:[~2008-12-02 22:32 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-12-02 14:01 PostgreSQL Database freezes during backup then generates drwtsn.exe process Ward Eaton <Ward.Eaton@rad-con.com>
2008-12-02 20:16 ` Steve Crawford <scrawford@pinpointresearch.com>
2008-12-02 22:32 ` Bob Lunney <bob_lunney@yahoo.com>
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