Re: Idle In Transaction Session Timeout, revived

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Idle In Transaction Session Timeout, revived
Дата
Msg-id 20160204100058.GA220738@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Idle In Transaction Session Timeout, revived  (David Steele <david@pgmasters.net>)
Ответы Re: Idle In Transaction Session Timeout, revived  (David Steele <david@pgmasters.net>)
Список pgsql-hackers
David Steele wrote:

> > <...> But what I think really happens is
> > some badly-written Java application loses track of a connection
> > someplace and just never finds it again. <...>

I've seen that also, plenty of times.

> That's what I've seen over and over again.  And then sometimes it's not
> a badly-written Java application, but me, and in that case I definitely
> want the connection killed.  Without logging, if you please.

So the way to escape audit logging is to open a transaction, steal some
data, then leave the connection open so that it's not logged when it's
killed?

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Idle In Transaction Session Timeout, revived
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pgbench stats per script & other stuff