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
Email : mzhao@insight-tec.co.jp WWW : http://www.insight-tec.com
-----------------------------------------------------------------------------------
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 по дате отправления: