Re: BUG #15076: postmaster crashes unexpectedly when using up arrowkey in psql command

Поиск
Список
Период
Сортировка
От 趙明春
Тема Re: BUG #15076: postmaster crashes unexpectedly when using up arrowkey in psql command
Дата
Msg-id CAGwivJF=0Fga6tjdeh+1p4mQAgHNp1azf1SmgkTrUPfY0dR8Vg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #15076: postmaster crashes unexpectedly when using up arrowkey in psql command  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: BUG #15076: postmaster crashes unexpectedly when using up arrow key in psql command
Список pgsql-bugs
Hi, Michael, Thanks. I got what you mean.

Anyway, the postmaster was received signal 2 in step 5 as below.

(1) run psql.exe in a Windows Command Prompt
(2) execute a SQL with more than one page of results, e.g. `show all;`
(3) press Ctrl + C to break it on the first page
(4) press up arrow key to try to execute the previous SQL of the step(2) again
(5) Occasionally, it will show you nothing about the SQL, then you can try to input a character ';' and press Enter key, the PostgreSQL will crash unexpectedly

So, Let me change my question:
If I started the PostgreSQL by pg_ctl command in the same Windows command prompt,
Is it possible that pressing Ctrl + C on psql to break query(not session) will send SIGINT to postmaster process unexpectedly?

Best Regards,
Mingchun

-----------------------------------------------------------------------------------
 Insight Technology, Inc.  Mingchun Zhao,  趙 明春(チョウ メイシュン)
  EbisBusinessTower 5F, 1-19-19, Shibuya-ku, Tokyo
  TEL  : +81-3-5475-1452            FAX : +81-3-5475-1451
-----------------------------------------------------------------------------------


2018-02-22 16:57 GMT+09:00 Michael Paquier <michael@paquier.xyz>:
On Thu, Feb 22, 2018 at 03:57:53PM +0900, 趙明春 wrote:
> You mean that the up-arrow key operation in psql.exe may send a SIGINT(or
> SIGTERM) signal to server(postmaster) unexpectedly?

No.  What Tom means here is that you are likely mistaking what you think
is a server crash by a client crash, and that the version of libreadline
your psql version is linked to is buggy and unable to handle that
properly.  psql has no control on the server itself.
--
Michael

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #15076: postmaster crashes unexpectedly when using up arrowkey in psql command
Следующее
От: Christoph Berg
Дата:
Сообщение: Re: BUG #15061: Cannot use TEMP TABLE ON COMMIT DROP in extension