Thanks alot, log_statement = all shows where come the errors.
On 4 mai, 10:49, [EMAIL PROTECTED] (Heikki Linnakangas) wrote:
> DNS wrote:
> > Even desactivate Auto-vacuum didn't fix my issue. Is there any place
> > where I can see past transactions or transactions in queue that hasn't
> > been pro
DNS escribió:
> Even desactivate Auto-vacuum didn't fix my issue.
I don't think anybody ever suggested that autovacuum had something to do
with it.
> Is there any place
> where I can see past transactions or transactions in queue that hasn't
> been processed ?
Why are you bothering with investig
DNS wrote:
Even desactivate Auto-vacuum didn't fix my issue. Is there any place
where I can see past transactions or transactions in queue that hasn't
been processed ?
You could put log_statement = all to your postgresql.conf. That'll log
every statement sent to the server to the log file.
T
Even desactivate Auto-vacuum didn't fix my issue. Is there any place
where I can see past transactions or transactions in queue that hasn't
been processed ?
Thank you,
On 2 mai, 10:02, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
> DNS escribió:
>
> > On 27 avr, 19:17, [EMAIL PROTECTED] (Tom Lane)
DNS escribió:
> On 27 avr, 19:17, [EMAIL PROTECTED] (Tom Lane) wrote:
>
> > This is just a warning, which most likely is there only because somebody
> > typed COMMIT or ABORT unnecessarily. What problem are you actually having?
>
> No one is working on the database when come up the warning. The
On 27 avr, 19:17, [EMAIL PROTECTED] (Tom Lane) wrote:
> This is just a warning, which most likely is there only because somebody
> typed COMMIT or ABORT unnecessarily. What problem are you actually having?
No one is working on the database when come up the warning. The
warning makes us worrier a
DNS <[EMAIL PROTECTED]> writes:
> 3- In pgsql log, I have this message:
> 2007-04-27 14:15:05 EDT user database WARNING: 25P01: there is no
> transaction in progress
This is just a warning, which most likely is there only because somebody
typed COMMIT or ABORT unnecessarily. What problem are yo
I forget to add, it's PGSQL version 8.1 . Thank you!
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hello,
I have the following Warning with Postgresql, can anybody helps:
1- My server is crashing suddenbly
2- I do a cold reboot
3- In pgsql log, I have this message:
2007-04-27 14:15:05 EDT user database WARNING: 25P01: there is no
transaction in progress
2007-04-27 14:15:05 EDT user database
