Hello Alvaro, >> AH> Is there any way to figure out what "exit code -1073741819" means? >> >> Yes, -1073741819 is 0xc0000005 aka "Access Violation". > >Oh, OK. How can this happen? I don't know much about Windows.
Like Magnus already wrote: accessing memory outside your adress space gives you an Access Violation on Windows. However, most of the time this means a NULL pointer was dereferenced. >Maybe you have some antivirus is checking the file at the same time Autovac is >checking it? Yes this could be possible. The postgres server is running on my developer machine together with an Antivirus software. But like I said this machine was running now since May without any problems (i.e. Postgres never crashed). >Also, it would be good to have a more complete report of what happenned. >Can you reproduce this problem? No. The server and the 2 programs accessing the server were happily running for several weeks without any problem. >If so, please provide the whole ERROR report (change log_min_messages I >guess). >Did it fail trying to open a file? What I can do is adjust log_min_messages and report back if Autovacuum should ever crash again. What value do you want it to be? And should I also adjust log_min_error_statement or any other setting (I have enough space left on the log partition, so there shouldn't be a problem). Rainer ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
