Re: "cancelling statement due to user request error" occurs but the transaction has committed.

Поиск
Список
Период
Сортировка
Искать
От
Naoya Anzai
Тема
Re: "cancelling statement due to user request error" occurs but the transaction has committed.
Дата
Msg-id
116262CF971C844FB6E793F8809B51C6BB6BDD@BPXM02GP.gisp.nec.co.jp
Ответ на
Список
Дерево обсуждения
"cancelling statement due to user request error" occurs but the transaction has committed. Naoya Anzai <anzai-naoya@mxu.nes.nec.co.jp>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Amit Kapila <amit.kapila16@gmail.com>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Naoya Anzai <anzai-naoya@mxu.nes.nec.co.jp>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Robert Haas <robertmhaas@gmail.com>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Kevin Grittner <kgrittn@ymail.com>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Tom Lane <tgl@sss.pgh.pa.us>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Robert Haas <robertmhaas@gmail.com>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Bruce Momjian <bruce@momjian.us>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Bruce Momjian <bruce@momjian.us>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Robert Haas <robertmhaas@gmail.com>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Bruce Momjian <bruce@momjian.us>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Robert Haas <robertmhaas@gmail.com>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Bruce Momjian <bruce@momjian.us>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Tom Lane <tgl@sss.pgh.pa.us>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Bruce Momjian <bruce@momjian.us>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Bruce Momjian <bruce@momjian.us>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Tom Lane <tgl@sss.pgh.pa.us>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Bruce Momjian <bruce@momjian.us>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Tom Lane <tgl@sss.pgh.pa.us>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Robert Haas <robertmhaas@gmail.com>
Re: "cancelling statement due to user request error" occurs but the transaction has committed. Naoya Anzai <anzai-naoya@mxu.nes.nec.co.jp>
Hi,

> Well, the only other principled fix I can see is to add a new reponse
> along the lines of ERRORBUTITCOMMITTED, which does not seem attractive
> either, since all clients will have to be taught to understand it.

+1

I think current specification hard to understand for many users.
It is really good if PostgreSQL gave us a message such as a replication abort warning:
###
WARNING:  canceling wait for synchronous replication due to user request
DETAIL:  The transaction has already committed locally, but might not have been replicated to the standby.
###

Regards,

Naoya

---
Naoya Anzai
Engineering Department
NEC Solution Inovetors, Ltd.
E-Mail: anzai-naoya@mxu.nes.nec.co.jp
---


В списке pgsql-hackers по дате отправления
От: Fujii Masao
Дата:
Сообщение: Audit of logout
От: Jochem van Dieten
Дата:
FAQ