When client tries to terminate a query, the generated KILL command uses a truncated processlist id and fails to kill the statement

[Peiran Song]

version: 5.6.28-76.1-log Percona Server (GPL)

processlist is BIGINT.

To repeat the bug:

thread 1:
mysql>select sleep(5);

thread 2:
mysql> show processlist;

| 52597315592 | root | 74.217.198.254:63634 | NULL | Query | 1 | User sleep | select sleep(5) | 0 | 0 |

thread 1:
^CCtrl-C -- sending "KILL QUERY 1057708040" to server ...

Note, the thread id is 52597315592, however the Ctrl-C generated a kill command with truncated id 1057708040. Thus the client is unable to early terminate a query except manually get the processlist id.

[Muhammad Irfan (muhammad-irfan)]

Hi Peiran,

You mean to say mysql cli sends kill with process ID truncated to 32 bits ? Can you please provide exact version of client libraries & mysql cli and check if the client host is 32 bit.
This upstream https://bugs.mysql.com/bug.php?id=44167 could be related.

[Peiran Song (peiran-s)]

Hi Muhammad,

I believe the client version is the same as the server, Percona version
5.6.28-76.1, and the client host is 64 bits. It does look like related to
the upstream bug.

Thanks,
Peiran

On Sat, Apr 1, 2017 at 4:04 AM, Muhammad Irfan <email address hidden>
wrote:

> Hi Peiran,
>
> You mean to say mysql cli sends kill with process ID truncated to 32 bits
> ? Can you please provide exact version of client libraries & mysql cli and
> check if the client host is 32 bit.
> This upstream https://bugs.mysql.com/bug.php?id=44167 could be related.
>
> ** Bug watch added: MySQL Bug System #44167
> http://bugs.mysql.com/bug.php?id=44167
>
> ** Changed in: percona-server
> Status: New => Invalid
>
> ** Changed in: percona-server
> Status: Invalid => Incomplete
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1641246
>
> Title:
> When client tries to terminate a query, the generated KILL command
> uses a truncated processlist id and fails to kill the statement
>
> Status in Percona Server:
> Incomplete
>
> Bug description:
> version: 5.6.28-76.1-log Percona Server (GPL)
>
> processlist is BIGINT.
>
> To repeat the bug:
>
> thread 1:
> mysql>select sleep(5);
>
> thread 2:
> mysql> show processlist;
>
> | 52597315592 | root | 74.217.198.254:63634 | NULL
> | Query | 1 | User sleep
> | select sleep(5) | 0 | 0 |
>
> thread 1:
> ^CCtrl-C -- sending "KILL QUERY 1057708040" to server ...
>
> Note, the thread id is 52597315592, however the Ctrl-C generated a
> kill command with truncated id 1057708040. Thus the client is unable
> to early terminate a query except manually get the processlist id.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/percona-server/+bug/1641246/+subscriptions
>

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3599