Thread: 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