Bug #59579 rw_lock_debug_print outputs to stderr, not to SHOW ENGINE INNODB STATUS

• Submitted: 18 Jan 2011 10:04
• Modified: 11 Feb 2011 0:26
• Reporter: Marko Mäkelä
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: all
• OS: Any
• Assigned to: Marko Mäkelä
• CPU Architecture: Any
• Tags: UNIV_SYNC_DEBUG

[18 Jan 2011 10:04] Marko Mäkelä

Description:
When running InnoDB with UNIV_DEBUG and UNIV_SYNC_DEBUG, issuing a SHOW ENGINE INNODB STATUS command will produce this kind of output in the error log, while it should go to the client connection:

Locked: thread 2984545136 file .../row/row0ins.c line 2142  S-LOCK

How to repeat:
Compile InnoDB with UNIV_DEBUG and UNIV_SYNC_DEBUG.
Run SHOW ENGINE INNODB STATUS.
Watch the output in the error log.

Suggested fix:
Add a FILE* parameter to rw_lock_debug_print().

[30 Jan 2011 16:59] Bugs System

Pushed into mysql-5.1 5.1.56 (revid:[e-mail]-20110130164158-1q99a41kb2wvkw3a) (version source revid:[e-mail]-20110130164158-1q99a41kb2wvkw3a) (merge vers: 5.1.56) (pib:24)

[30 Jan 2011 16:59] Bugs System

Pushed into mysql-trunk 5.6.2 (revid:[e-mail]-20110130165639-1pr3opz839b98q5j) (version source revid:[e-mail]-20110130165522-m0o6al0pn5ig9kv3) (merge vers: 5.6.2) (pib:24)

[30 Jan 2011 17:00] Bugs System

Pushed into mysql-5.5 5.5.10 (revid:[e-mail]-20110130165343-he9art47agq1a3gr) (version source revid:[e-mail]-20110130165137-5lvzsq9j29j0hp1s) (merge vers: 5.5.10) (pib:24)