Hi all,
I can see that value pg_stat_database.xact_rollback for my db is instantly
growing, but I can not find a way to log these rolled back transactions
(or, may be, last statement within).
Even with

log_min_duration_statement = 0

log_statement = 'all'

there is no error messages in log.

I mean that I was expecting something like this (for example)

ERROR:  value too long for type character varying(4096)
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block


or to see ROLLBACK statement directly.

Can VACUUM be a reason of xact_rollback increasing?

Server version is 9.2.4

P.S,
Root problem is the number of wal files,  it raised up significantly (more
than 4 times) with the same workload and I do not know why.


-- 
Regards, Andrey Lizenko

Reply via email to