sar-sql - it collects MySQL runtime and configuration information

Running option --variables crashes on line 436

Reported by Tom Krouper on 2009-10-19
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySAR
High
seattlegaucho

Bug Description

I ran across this while trying to use --variables. Using the --status option completes successfully.

$ ./mysar.pl --user mysar --pass secret --variables
 * mysar v0.6-alpha - Gerardo Narvaja
 * Developed at Pythian Inc. http://www.pythian.com
 * Use "perldoc mysar.pl" for usage information
User: mysar
*** Sampled at: 2009-10-19 18:18:07
Will retrieve all variables
*** Retrieving configuration variables from the DB
Undefined subroutine &main::execute called at ./mysar.pl line 436 (#1)
    (F) The subroutine indicated hasn't been defined, or if it was, it has
    since been undefined.

Uncaught exception from user code:
        Undefined subroutine &main::execute called at ./mysar.pl line 436.
 at ./mysar.pl line 436
        main::get_all_vars() called at ./mysar.pl line 519
## Here is the user that was created on MySQL.
$ mysql -B --skip-column-names -e'show grants for mysar'
GRANT CREATE, PROCESS ON *.* TO 'mysar'@'%' IDENTIFIED BY PASSWORD '*...'
GRANT ALL PRIVILEGES ON `mysar`.* TO 'mysar'@'%'

Related branches

seattlegaucho (gnarvaja) on 2009-10-20
Changed in mysar:
status: New → In Progress
importance: Undecided → High
assignee: nobody → seattlegaucho (gnarvaja)
seattlegaucho (gnarvaja) wrote :

The issue on line #436 was a typo where "=" should've been a "->".

Fixed it and pushed a new build: #13) into the trunk along with a couple of other bug fixes. The revision can be downloaded from http://bazaar.launchpad.net/~gnarvaja/mysar/trunk/files

Changed in mysar:
milestone: none → alpha-2
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers