From: | "Moshe Ben-Shoham" <mosheb(at)nexperience(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Inserts hang in DB and error messages in log |
Date: | 2009-05-21 06:36:38 |
Message-ID: | 75E4C42D37E6A74E9FB57C2E9F1300D601387F26@tiger.nexperience.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Hi,
We're working with version 8.3.5-1.
Lately we started seeing insert statements hang in the DB. The
statements come from two different clients.
When it happens, I see the following messages in the log every second or
so:
2009-05-21 08:56:49 IDT ERROR: permission denied to set parameter
"log_statement"
2009-05-21 08:56:49 IDT STATEMENT: SET log_statement='none';
2009-05-21 08:56:50 IDT ERROR: permission denied to set parameter
"log_statement"
2009-05-21 08:56:50 IDT STATEMENT: SET log_statement='none';
2009-05-21 08:56:51 IDT ERROR: permission denied to set parameter
"log_statement"
2009-05-21 08:56:51 IDT STATEMENT: SET log_statement='none';
2009-05-21 08:56:52 IDT ERROR: permission denied to set parameter
"log_statement"
2009-05-21 08:56:52 IDT STATEMENT: SET log_statement='none';
2009-05-21 08:56:53 IDT ERROR: permission denied to set parameter
"log_statement"
2009-05-21 08:56:53 IDT STATEMENT: SET log_statement='none';
2009-05-21 08:56:54 IDT ERROR: permission denied to set parameter
"log_statement"
2009-05-21 08:56:54 IDT STATEMENT: SET log_statement='none';
2009-05-21 08:56:55 IDT ERROR: permission denied to set parameter
"log_statement"
2009-05-21 08:56:55 IDT STATEMENT: SET log_statement='none';
Any help (or guidelines for additional required information) is
appreciated.
Thanks,
Moshe.
The information contained in this message is proprietary to the sender, protected from disclosure, and may be privileged. The information is intended to be conveyed only to the designated recipient(s) of the message. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, use, distribution or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you.
************************************************************************************
This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals & computer viruses.
************************************************************************************
From | Date | Subject | |
---|---|---|---|
Next Message | Sofer, Yuval | 2009-05-21 08:04:55 | compilation test fails |
Previous Message | Peter Eisentraut | 2009-05-20 22:49:18 | Re: Audit Log Destination |
From | Date | Subject | |
---|---|---|---|
Next Message | Kent Tong | 2009-05-21 06:39:38 | changing the locale of the DB cluster |
Previous Message | Sam Mason | 2009-05-20 22:18:31 | Re: How should I deal with disconnects during insert? |