Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 2F39764FE9F for ; Tue, 2 Dec 2008 18:32:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 99067-04 for ; Tue, 2 Dec 2008 18:32:51 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web39708.mail.mud.yahoo.com (web39708.mail.mud.yahoo.com [209.191.106.54]) by mail.postgresql.org (Postfix) with SMTP id CCC2B64FE0F for ; Tue, 2 Dec 2008 18:32:50 -0400 (AST) Received: (qmail 57549 invoked by uid 60001); 2 Dec 2008 22:32:49 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=ddV1Pbc77sfnA2sfmCm6b7Z+qV/sg0CnQKJzkN8izoRMuzDFciVqVNPnEOqPlbfSNd5IDkbRHa6vYHSo/SUo8+1Phemb8/l8nqjQarvyeWekTylgR+ovMBOLVPvFb6Kcf2uWxPHbZ3fTFNy4xS9l3rFO+6lbHW6dEiJFd8gX3lg=; X-YMail-OSG: M9dlnooVM1mr4fqiGwh4KbCjeSnlduH.YNEjo7XgSFK8s66xEUPpo7Rza3EKMs_SPWUmuIa45dKaXALSKU9Mwsq0k1k2SNoVb5BBiQfUDSnwGQKSIso8q.DKLEplL3TqiuQJ1Iz_tEQ8Hf2.dUhCahlYKMdyFJpMmtBg3sxwlkgaNLGbMO7lfbfh1E4- Received: from [65.200.157.178] by web39708.mail.mud.yahoo.com via HTTP; Tue, 02 Dec 2008 14:32:48 PST X-Mailer: YahooMailWebService/0.7.260.1 Date: Tue, 2 Dec 2008 14:32:48 -0800 (PST) From: Bob Lunney Reply-To: bob_lunney@yahoo.com Subject: Re: PostgreSQL Database freezes during backup then generates drwtsn.exe process To: pgsql-admin@postgresql.org, Ward Eaton In-Reply-To: <04A6DB42D2BA534FAC77B90562A6A03DB91F47@server.rad-con.local> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-870768935-1228257168=:57051" Message-ID: <245622.57051.qm@web39708.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200812/17 X-Sequence-Number: 30850 --0-870768935-1228257168=:57051 Content-Type: text/plain; charset=iso-8859-7 Content-Transfer-Encoding: quoted-printable Ward, I've experienced the exact problem you describe.=A0 The two machines where = identical in every way: make, model, disk layout, OS, etc., and this scenar= io happens regardless of which machine was the primary and which was the wa= rm-standby.=A0 Note I was not running pgAgent. I was using pg_standby to implement copying of WAL files between machines.= =A0 It would copy the WAL file to a network shared directory, where the war= m-standby would pick up the file and use it, until the fatal error you desc= ribe happened. I had discovered that during a copy operation Windows will allocate the ent= ire file size on the target prior to completing the file copy.=A0 This diff= ers from Unix, and may have something to do with the errors we are seeing.= =A0 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 nece= ssarily the case with Windows. I know some folks recommend rsync, but that requires installing cygwin and = my client isn't happy with that idea.=A0 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.=A0= I haven't tried it yet, but I'm moving in that direction. Regards, Bob Lunney --- On Tue, 12/2/08, Ward Eaton wrote: From: Ward Eaton Subject: [ADMIN] PostgreSQL Database freezes during backup then generates d= rwtsn.exe process To: pgsql-admin@postgresql.org Date: Tuesday, December 2, 2008, 9:01 AM =20 =20 =20 =20 I=A2m running PostgreSQL 8.3 on a Windows 2003 machine (pgAgent service is also installed and running).=A0 The system is running as a redundant database server.=A0 Thus,= backing up from one machine to another, and transferring over WAL logs.=A0 In the p= ostageSQL log files there are several error messages that read:=20 =A1could not rename file, no such file or directory=A2=A0 =20 =A0=20 Eventually, postgreSQL =A1freezes=A2, I=A2m unable to access the database, and there is no logging.=A0 I find a drwtsn.= exe process running under the postgres account in Task Manager.=A0 If I kill th= e drwtsn PostgreSQL service will stop.=A0 I can then restart it and the datab= ase will run as expected for a few days.=A0 =20 =A0=20 Has anyone encountered this problem before?=A0 If so, were you able to find a solution?=20 =A0=20 Thanks for any help in advance.=20 =A0=20 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=20 =A0=20 =20 =0A=0A=0A --0-870768935-1228257168=:57051 Content-Type: multipart/related; boundary="0-1719689203-1228257168=:57051" --0-1719689203-1228257168=:57051 Content-Type: text/html; charset=iso-8859-7 Content-Transfer-Encoding: quoted-printable
Ward,

I've experienced the exact probl= em you describe.  The two machines where identical in every way: make,= model, disk layout, OS, etc., and this scenario happens regardless of whic= h machine was the primary and which was the warm-standby.  Note I was = not running pgAgent.

I was using pg_stan= dby to implement copying of WAL files between machines.  It wou= ld 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 happe= ned.

I had discovered that during a copy operation Windows will allo= cate the entire file size on the target prior to completing the file copy.&= nbsp; 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, whic= h is not necessarily the case with Windows.

I know some folks recomm= end rsync, but that requires installing cygwin and my client isn't happy wi= th 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 f= ile descriptor and don't reallocate any disk space.  I haven't tried i= t yet, but I'm moving in that direction.

Regards,

Bob Lunney<= br>
--- 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 bac= kup then generates drwtsn.exe process
To: pgsql-admin@postgresql.org
Date: Tuesday, December 2, 2008, 9:01 AM
=
=20 =20 =20 =20

I=A2m 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 th= e postageSQL log files there are several error messages that read:

=20

=A1could not rename file, no such file or = directory=A2 

=20

 

=20

Eventually, postgreSQL =A1freezes=A2, I=A2= m unable to access the database, and there is no logging.  I find a drwt= sn.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 da= tabase will run as expected for a few days. 

=20

 

=20

Has anyone encountered this problem before= ?  If so, were you able to find a solution?

=20

 

=20

Thanks for any help in advance.

=20

 

=20

Ward Eaton
Project Engineer Automation

RAD-CON Inc.
TECHNOLOGY: Innovative &a= mp; Proven
Office: +1.216.706.8927
Fax: +1.216.221.1135
Website: www.RAD-CON.com
E-mail: Ward.Eaton@RAD-CON.com

=20

 

=20
=20

=0A=0A=0A=0A --0-1719689203-1228257168=:57051 Content-Type: image/jpeg; name="image002.jpg" Content-Transfer-Encoding: base64 Content-Id: <1.2598094968@web39708.mail.mud.yahoo.com> Content-Description: image002.jpg /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIf IiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8SDc9Pjv/2wBDAQoLCw4NDhwQEBw7KCIoOzs7Ozs7 Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozv/wAARCAAuAIwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD0Pxb4 mj8M2a3EhJaT5IYgMmWTsvt9awx4q8akD/ilUHH/AD9r/hVf4vcWukf9fq/yNb979s+wS/2eYhd7 P3JmGU3e/tQbJRjBSavcw7rxn4ws7Z7ibwsPLQZYrchiB64ArHh+Luq3M6Qw6PEzyMFQef1J/wCA 12GlHUI7IHV5bY3CsSzW6kIF/H9a8x8M21vqXxBL2oBtEuZZkwONoJxj2oOvDwo1FLmjsr7naT+M fGUETyyeHI1SNSzH7SOABk9qztO+J3iHV5jFY6NDK6pvI88Dj8q7GSEOCjDKuCD9DXm3gG0Np4ov 7N1wYEdMfRsfyxQZ0Y0pwm3HVK+508njTxnEhZvDcbAdlnBP8qyW+MGrROUk0eJWU4KtKQR+G2t3 VfEGnaLf2tnd+arXQyrqmVXnHP41kePtBjutOTUYY1F1FKkbN03oxxz9CRQFB0pSSqR0ZCPjHqXf SIT/ANt//sacnxj1FmCLokbMxwAJzk/+O1zn/CA+I84+xp/3+Wup+HXh1bSS8vL2JftcM5t1Bwdh HXHvz1oO+rRwUIOS1+Zpw+NvF80fmR+DZGXHebH6baz734q61p0gjvvDJt3PQSzFc/T5a1tQ+I2g 6XqcthKbqaSFtsrwx7lRu4znnHtVG9m0bx74l0RbW5+02trHNLcRkFSPu7QQfU0HDCML3nT935k2 neO/FWrQCey8JmSE9HNxtB+mV5qlqPxR13SZ/Jv/AA0bZz0Ek/X6Hbg10viLxbpPhNLeK6WV5JR+ 6t7dAWCDv1AAp9xFpfjbwwSmJre5QmJiMPG46H2INBEXTvzOHumPZ+M/F+oWkV3aeFElhmGUcXYw R69Ko2PxN8Q6nqE2nWfhpZLqDPmRG5wVwcHqPWui8FIy+DtMRxh1iKsPQhiD/Kol8PLbeOzrtuoE d5bNHcD0kBGG/EUEN0uZq3oVLfx1qkeqxabrumDSprqNmtT5nmiRh2OBxXUeHNRm1bw9Y39xhZZ4 g7hRxmuA8b/8lC8MYP8AC/8A6Ea7fwP/AMiXpX/XAfzNBlJKyfc5X4wnFlpB/wCn1f5GtDxRdXFl 4Tv7q1laGeKDcki9VORyKzPjMWGm6WVOG+1jBPY4NQXug+MdTsJLG616ya3nXa6i0wcemaDWKvCN 31NTwZrF1regJdXu1p0kaNmUY347ketY/g3TIrXxb4haFcR28phjH90Md1O0rwx4p0ezFrp+t2kU RYtta1L8n3NSWXhvxXYz3c9tr1msl5L5szGzzubGPwFBtJxjKfI1ZnUJcStqFxbG2kWOFEZZiMLI TnIH04rk9Mtmg+KGsDHEtuJV9wdtOg8LeLYNTl1BPEkZuJs7t8TFOfRDwOnanf8ACO+LBqh1Qa7a famh8nf9k42ZzjFBEI8t1zLVGhrHha11rVLS8upZALVSBEoGH5zyazfiBq0dhoyWishu7mVGRD2R W3FiPTgCp303xs6Ff+EjtVz/ABLZjIrAm+HGq3Fw9xc6ss88n3pJFZmNBVGMHKKqzXKjP/4WL4iz n/Qf+/B/xrofh/4hN7JfWt06C7mna5VV4DZxnA9sdKyD8Nr4f8xCHr/zzakT4e38ciumpRo6HKsi MCD7Gg76scDKDUHZnR33w70u/wBTmvPtk8IncyPGoBG49SCaiki0jwF4j0doA0cF4ksNzLI2T/Dt Y+wNMh0/xhDGEXxJEwHeS33H86oaj4N17WJUk1HXluWjBCBoyAoPXAH0oOSE5StCpU9067xN4Qsf FMlvcTXEkE0K7VliwwdDzj/A1cB07wf4bJEgis7OMkFzyzf1JNcppnh/xdpVsLex8RRCAfcjlgMg X6Z6VV1XwP4l1x1bU/ECXOzlEMbBE+ijj8aDG17U3P3UdX4Olkk8GadI7fO8TOx9yxP8zTPCviQe I9ES5JAuYmMdwgP3WHf6Ec1xt7ceK/CcdvpUWr2zQx2ckyAW3RUPI5781j2NvrHhW6lltdTjiSfe ryJCZQwTaSQvrlsY7c07E+yi7u/odN4zb/ivfDZz0R+/+1Xe+B/+RK0r/r3H8zXi8Orapq3jLTjq cwma2laONhD5YI78V7T4H/5EvSv+vcUMirFxUUzj/jWT/ZGnYB4uckjtwa8rj1bUS4DaleY/6+G/ xr33xdpV/qdusVqtlJFIpjmS6LDIPoVrjB8OZx/zDNF4/wCm09Ctaxvh68IK01c89/tHUB01K8/8 CH/xq7b3F3Jp087ajfs8efu3ZUIMZyQTzk8cV2//AAr67/6Bui/9/p6P+FfXJPOmaIcdP3s9I7Z4 zDSVows/RHKxwXf2+eJ9T1B40t/Nh2XhDTHC8A59SR+FQK0rWFrOdZvVknnEBi+1ElDuO4nnoFxg +prsj8Pp/wDoE6H/AN/Z/wDCgfD+4B/5Beif9/p6DD6zR7fgjkLuG9R74W9/qGbZl2K95kyLkgv1 6YFKsMgksBLr11ifi623RJhO3cO/p+tdd/wr6bGP7I0P/v8AT/4UH4f3OMf2XomP+us9AfWqVrW/ BHIvCUguXOt3biKNGEgujt5QtkjOTyAMdcmq8KXDWUstzqN5HKoLEfaSBGNm4EgnJ3dBiu1/4V7c /wDQL0T1/wBbP/hTT8PLtuTp+iZPrLN/hQL6zTSa/RHGXIMPmeXrFyxSLf8A69vlOEODzz949PSp JkdL+3gGrXipKzqS11nIH3XGDwGPrXXH4d3v/Pjov/fyb/Ck/wCFdXmTix0UZ6/vJuf0oBYmjf8A 4COPgW5OpJbzapfLGUG4pdHO/aCV6+9RW322bVjbza3dQ2iM+6f7WcbVOODn1wK7b/hXN3jB0/RS P+uk3+FH/CuZ++maIf8AtrPTViZYik+n4I80u5NQ8zddXU0h+eIM8xbIB5Gc9KiW8uUkEi3MyurF gwc5BPU/U16gPhzMP+YXonT/AJ7T0v8Awrmf/oGaL/3+nquZFxxVJK3Kee+HGlk8SWG5pH2yluST jOcmvfPA/wDyJWlf9e4rkNP8H6rpLySWFnosDypsZvMmPH4iu38O6dLpPh6x093SRreIIzDOCfap bucdepGpK8VY/9k= --0-1719689203-1228257168=:57051-- --0-870768935-1228257168=:57051--