Bug #44790 mysqladmin -r extended-status only runs once, reports high negative values

• Submitted: 11 May 15:29
• Modified: 12 May 10:47
• Reporter: Kai Voigt
• Status: Duplicate
• Category: Client
• Severity: S2 (Serious)
• Version: 5.1.34
• OS: Linux

[11 May 15:29] Kai Voigt

Description:
"mysqladmin -r -i 1 extended-status" doesn't work the expected way. It only reports
values once, then stops. Also, the reported numbers show some high negative values

How to repeat:
sles10sp2-c2-15:/usr/local/mysql/data # mysqladmin -V
mysqladmin  Ver 8.42 Distrib 5.1.34, for pc-linux-gnu on i686
sles10sp2-c2-15:/usr/local/mysql/data # uname -a
Linux sles10sp2-c2-15 2.6.16.60-0.21-default #1 Tue May 6 12:41:02 UTC 2008 i686 i686
i386 GNU/Linux
sles10sp2-c2-15:/usr/local/mysql/data # mysqladmin -r -i 1 extended-status
+-----------------------------------+------------+
| Variable_name                     | Value      |
+-----------------------------------+------------+
| Aborted_clients                   | 0          |
| Aborted_connects                  | 0          |
| Binlog_cache_disk_use             | 0          |
...
| Sort_range                        | 0          |
| Sort_rows                         | 0          |
| Sort_scan                         | 0          |
| Ssl_accept_renegotiates           | -185542587187200|
| Ssl_accepts                       | 0          |
| Ssl_callback_cache_hits           | 0          |
| Ssl_cipher                        | 0          |
| Ssl_cipher_list                   | 0          |
| Ssl_client_connects               | -17179869184|
| Ssl_connect_renegotiates          | -4294967296|
| Ssl_ctx_verify_depth              | -1         |
| Ssl_ctx_verify_mode               | 0          |
| Ssl_default_timeout               | -1         |
| Ssl_finished_accepts              | -15461882265600|
| Ssl_finished_connects             | 0          |
| Ssl_session_cache_hits            | 0          |
...
| Threads_cached                    | 0          |
| Threads_connected                 | 2          |
| Threads_created                   | 4807       |
| Threads_running                   | 1          |
| Uptime                            | 4379       |
| Uptime_since_flush_status         | 4379       |
+-----------------------------------+------------+
sles10sp2-c2-15:/usr/local/mysql/data #

[11 May 16:22] Valeriy Kravchuk

I can not repeat this with recent 5.1.35 from bzr (64-bit) on Mac OS X.

[11 May 17:08] Miguel Solorzano

I can't repeat too in Ubuntu 9.04 64-bit with bzr source server.

[11 May 17:48] Shane Bester

this is a 32-bit issue.

[12 May 10:47] Sveta Smirnova

Please do not submit the same bug more than once. An existing bug report already describes
this very problem. Even if you feel that your issue is somewhat different, the resolution
is likely
to be the same. Because of this, we hope you add your comments to the original bug
instead.

Thank you for your interest in MySQL.

Duplicate of bug #40395