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...
Show quoted text
"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 argumentA 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