Обсуждение: PGSQL 8.1.4 on Win2003 at istanbul :), could not access status of transaction xxxxx , could not open file "pg_subtrans/000A": Invalid argument
Hi There is a new installed PostgreSQL 8.1.4 running on Windows2003. Last 3 days we get error message below incidentally. After first error, we get the error frequently. After restart the service, the error gone. 2006-07-13 19:43:57.218 192.168.3.14(1093) test user SELECTLOG: duration: 15.000 ms statement: select * from personaldetails where masterid=215 2006-07-13 19:43:57.234 192.168.3.14(1093) test user SELECTERROR: could not access status of transaction 679109 2006-07-13 19:43:57.234 192.168.3.14(1093) test user SELECTDETAIL: could not open file "pg_subtrans/000A": Invalid argument 2006-07-13 19:43:57.250 192.168.3.12(1048) test user2 SELECTLOG: duration: 63.000 ms statement: select id,dueamount(id),payment(id),allocatedtotal id),balance(id) from personaldetails where id =1142 limit 1 Regards, Ali �EL�K
"AL� �EL�K" <ali@verus.com.tr> writes:
> There is a new installed PostgreSQL 8.1.4 running on Windows2003.
> 2006-07-13 19:43:57.234 192.168.3.14(1093) test user SELECTERROR: could
> not access status of transaction 679109
> 2006-07-13 19:43:57.234 192.168.3.14(1093) test user SELECTDETAIL: could
> not open file "pg_subtrans/000A": Invalid argument
A lot of people have traced "impossible" errors like this one to badly
written antivirus software. If you have any AV code in place, try
deinstalling it (remove it, not just disable it) and see if that helps.
If so, get some other AV system, or switch to a less vulnerable OS.
regards, tom lane
Hi There is NOD32 Antivirus on the system but it is not scanning PostgreSQL folder. I have checked disk but no errors. Regards Ali �EL�K "Tom Lane" <tgl@sss.pgh.pa.us>, haber iletisinde �unlar� yazd�:27296.1153589681@sss.pgh.pa.us... > "AL� �EL�K" <ali@verus.com.tr> writes: >> There is a new installed PostgreSQL 8.1.4 running on Windows2003. > >> 2006-07-13 19:43:57.234 192.168.3.14(1093) test user SELECTERROR: could >> not access status of transaction 679109 >> 2006-07-13 19:43:57.234 192.168.3.14(1093) test user SELECTDETAIL: >> could >> not open file "pg_subtrans/000A": Invalid argument > > A lot of people have traced "impossible" errors like this one to badly > written antivirus software. If you have any AV code in place, try > deinstalling it (remove it, not just disable it) and see if that helps. > If so, get some other AV system, or switch to a less vulnerable OS. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >
ALÝ ÇELÝK wrote: > Hi > > There is NOD32 Antivirus on the system but it is not scanning PostgreSQL > folder. I have checked disk but no errors. Uninstall it and try again. In some cases, even inactive antiviruses (i.e. one installed but not running at all) have been reported to cause problems. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support