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

• Submitted: 11 May 2009 13:29
• Modified: 12 May 2009 8:47
• Reporter: Kai Voigt
• Status: Duplicate
• Category: MySQL Server: Command-line Clients
• Severity: S2 (Serious)
• Version: 5.1.34
• OS: Linux
• CPU Architecture: Any

[11 May 2009 13: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 2009 14:22] Valeriy Kravchuk

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

[11 May 2009 15:08] MySQL Verification Team

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

[11 May 2009 15:48] MySQL Verification Team

this is a 32-bit issue.

[12 May 2009 8: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