canceling statement due to user request
От | Spangler, Todd |
---|---|
Тема | canceling statement due to user request |
Дата | |
Msg-id | 7E5D8C50942FE5459735F324EFAD8A140D5B533E@CORPEX00.comsysusi.com обсуждение исходный текст |
Ответы |
Re: canceling statement due to user request
|
Список | pgsql-bugs |
Dear PostgreSQL, I have been working with a web application that allows saving of reports to a text file using PostgreSQL. The application has worked fine for about 6 months and now we are getting the following 2 error messages: =20 canceling statement due to statement timeout canceling statement due to user request =20 In development, I seem to have been able to keep the timeout messagebox from showing up by adding a timeout to the connectionstring, but the other error I cannot seem to fix. =20 I have read that this may have something to do with the Autovacuum feature. We are using PostgreSQL version 8.3. I'm testing with 8.4 on another server and still am getting the messages above. It seems the errors do not happen every time. If this is the Autovacuum feature, is there a way that I can disable this feature and then re-enable it when I am done with the creation of my report? Also, when we receive these errors, it does not save any information to the text file like it normally would without the error message, so we do not get the report we need when these errors occur. Another thought would be for us to allow the Autovacuum to be turned on only at certain times. That would be fine for our situation. =20 I have read that these messages are by design and I am fine with that, but I need an easy to use workaround that will allow the reports to work. These reports are very important to the company.=20 =20 We are using Windows Servers and Windows XP, C#.Net 2008 - ASP.Net, and PostgreSQL 8.3. =20 Thank you for your time, =20 Todd Spangler COMSYS - A Manpower Company 804-521-5288 =20
В списке pgsql-bugs по дате отправления: