Version naming *-log

Asked by vangelis

Hi

One some Ubuntu 10.04 LTS, I get a mysql version (in the mysql client with SELECT VERSION() ) of
5.1.72-0ubuntu0.10.04.1-log

whereas in some other systems I get a version
5.1.72-0ubuntu0.10.04.1

What does the "-log" signifies?

Regards
Vangelis

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu mysql-dfsg-5.1 Edit question
Assignee:
No assignee Edit question
Solved by:
vangelis
Solved:
Last query:
Last reply:
Revision history for this message
Manfred Hampl (m-hampl) said :
#1

What is the output of the command

apt-cache policy mysql-*

on these different systems?

Revision history for this message
vangelis (vkatsikaros) said :
#2

Hi I couldn't do apt-cache policy mysql-* instead I did:

================================================================================
From the 5.1.72-0ubuntu0.10.04.1-log

apt-cache policy mysql-server mysql-server-5.1 mysql-server-core-5.1 mysql-client mysql-client-5.1 mysql-client-core-5.1 mysql-common

mysql-server:
  Installed: 5.1.72-0ubuntu0.10.04.1
  Candidate: 5.1.72-0ubuntu0.10.04.1
  Version table:
 *** 5.1.72-0ubuntu0.10.04.1 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://security.ubuntu.com/ubuntu/ lucid-security/main Packages
        100 /var/lib/dpkg/status
     5.1.69-0ubuntu0.10.04.1 0
        500 http://old-releases.ubuntu.com/ubuntu/ lucid-updates/main Packages
     5.1.41-3ubuntu12.10 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://old-releases.ubuntu.com/ubuntu/ lucid-updates/main Packages
     5.1.41-3ubuntu12.7 0
        500 http://security.ubuntu.com/ubuntu/ lucid-security/main Packages
     5.1.41-3ubuntu12 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid/main Packages
        500 http://old-releases.ubuntu.com/ubuntu/ lucid/main Packages
mysql-server-5.1:
  Installed: 5.1.72-0ubuntu0.10.04.1
  Candidate: 5.1.72-0ubuntu0.10.04.1
  Version table:
 *** 5.1.72-0ubuntu0.10.04.1 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://security.ubuntu.com/ubuntu/ lucid-security/main Packages
        100 /var/lib/dpkg/status
     5.1.69-0ubuntu0.10.04.1 0
        500 http://old-releases.ubuntu.com/ubuntu/ lucid-updates/main Packages
     5.1.41-3ubuntu12 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid/main Packages
        500 http://old-releases.ubuntu.com/ubuntu/ lucid/main Packages
mysql-server-core-5.1:
  Installed: 5.1.72-0ubuntu0.10.04.1
  Candidate: 5.1.72-0ubuntu0.10.04.1
  Version table:
 *** 5.1.72-0ubuntu0.10.04.1 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://security.ubuntu.com/ubuntu/ lucid-security/main Packages
        100 /var/lib/dpkg/status
     5.1.69-0ubuntu0.10.04.1 0
        500 http://old-releases.ubuntu.com/ubuntu/ lucid-updates/main Packages
     5.1.41-3ubuntu12 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid/main Packages
        500 http://old-releases.ubuntu.com/ubuntu/ lucid/main Packages
mysql-client:
  Installed: 5.1.72-0ubuntu0.10.04.1
  Candidate: 5.1.72-0ubuntu0.10.04.1
  Version table:
 *** 5.1.72-0ubuntu0.10.04.1 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://security.ubuntu.com/ubuntu/ lucid-security/main Packages
        100 /var/lib/dpkg/status
     5.1.69-0ubuntu0.10.04.1 0
        500 http://old-releases.ubuntu.com/ubuntu/ lucid-updates/main Packages
     5.1.41-3ubuntu12.10 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://old-releases.ubuntu.com/ubuntu/ lucid-updates/main Packages
     5.1.41-3ubuntu12.7 0
        500 http://security.ubuntu.com/ubuntu/ lucid-security/main Packages
     5.1.41-3ubuntu12 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid/main Packages
        500 http://old-releases.ubuntu.com/ubuntu/ lucid/main Packages
mysql-client-5.1:
  Installed: 5.1.72-0ubuntu0.10.04.1
  Candidate: 5.1.72-0ubuntu0.10.04.1
  Version table:
 *** 5.1.72-0ubuntu0.10.04.1 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://security.ubuntu.com/ubuntu/ lucid-security/main Packages
        100 /var/lib/dpkg/status
     5.1.69-0ubuntu0.10.04.1 0
        500 http://old-releases.ubuntu.com/ubuntu/ lucid-updates/main Packages
     5.1.41-3ubuntu12 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid/main Packages
        500 http://old-releases.ubuntu.com/ubuntu/ lucid/main Packages
mysql-client-core-5.1:
  Installed: 5.1.72-0ubuntu0.10.04.1
  Candidate: 5.1.72-0ubuntu0.10.04.1
  Version table:
 *** 5.1.72-0ubuntu0.10.04.1 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://security.ubuntu.com/ubuntu/ lucid-security/main Packages
        100 /var/lib/dpkg/status
     5.1.69-0ubuntu0.10.04.1 0
        500 http://old-releases.ubuntu.com/ubuntu/ lucid-updates/main Packages
     5.1.41-3ubuntu12 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid/main Packages
        500 http://old-releases.ubuntu.com/ubuntu/ lucid/main Packages
mysql-common:
  Installed: 5.1.72-0ubuntu0.10.04.1
  Candidate: 5.1.72-0ubuntu0.10.04.1
  Version table:
 *** 5.1.72-0ubuntu0.10.04.1 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://security.ubuntu.com/ubuntu/ lucid-security/main Packages
        100 /var/lib/dpkg/status
     5.1.69-0ubuntu0.10.04.1 0
        500 http://old-releases.ubuntu.com/ubuntu/ lucid-updates/main Packages
     5.1.41-3ubuntu12.10 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://old-releases.ubuntu.com/ubuntu/ lucid-updates/main Packages
     5.1.41-3ubuntu12.7 0
        500 http://security.ubuntu.com/ubuntu/ lucid-security/main Packages
     5.1.41-3ubuntu12 0
        500 http://gr.archive.ubuntu.com/ubuntu/ lucid/main Packages
        500 http://old-releases.ubuntu.com/ubuntu/ lucid/main Packages

================================================================================
From the 5.1.72-0ubuntu0.10.04.1

apt-cache policy mysql-server mysql-server-5.1 mysql-server-core-5.1 mysql-client mysql-client-5.1 mysql-client-core-5.1 mysql-common
mysql-server:
  Installed: 5.1.72-0ubuntu0.10.04.1
  Candidate: 5.1.72-0ubuntu0.10.04.1
  Version table:
 *** 5.1.72-0ubuntu0.10.04.1 0
        500 http://archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://archive.ubuntu.com/ubuntu/ lucid-security/main Packages
        100 /var/lib/dpkg/status
     5.1.41-3ubuntu12.10 0
        500 http://archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
     5.1.41-3ubuntu12.7 0
        500 http://archive.ubuntu.com/ubuntu/ lucid-security/main Packages
     5.1.41-3ubuntu12 0
        500 http://archive.ubuntu.com/ubuntu/ lucid/main Packages
mysql-server-5.1:
  Installed: 5.1.72-0ubuntu0.10.04.1
  Candidate: 5.1.72-0ubuntu0.10.04.1
  Version table:
 *** 5.1.72-0ubuntu0.10.04.1 0
        500 http://archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://archive.ubuntu.com/ubuntu/ lucid-security/main Packages
        100 /var/lib/dpkg/status
     5.1.41-3ubuntu12 0
        500 http://archive.ubuntu.com/ubuntu/ lucid/main Packages
mysql-server-core-5.1:
  Installed: 5.1.72-0ubuntu0.10.04.1
  Candidate: 5.1.72-0ubuntu0.10.04.1
  Version table:
 *** 5.1.72-0ubuntu0.10.04.1 0
        500 http://archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://archive.ubuntu.com/ubuntu/ lucid-security/main Packages
        100 /var/lib/dpkg/status
     5.1.41-3ubuntu12 0
        500 http://archive.ubuntu.com/ubuntu/ lucid/main Packages
mysql-client:
  Installed: (none)
  Candidate: 5.1.72-0ubuntu0.10.04.1
  Version table:
     5.1.72-0ubuntu0.10.04.1 0
        500 http://archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://archive.ubuntu.com/ubuntu/ lucid-security/main Packages
     5.1.41-3ubuntu12.10 0
        500 http://archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
     5.1.41-3ubuntu12.7 0
        500 http://archive.ubuntu.com/ubuntu/ lucid-security/main Packages
     5.1.41-3ubuntu12 0
        500 http://archive.ubuntu.com/ubuntu/ lucid/main Packages
mysql-client-5.1:
  Installed: 5.1.72-0ubuntu0.10.04.1
  Candidate: 5.1.72-0ubuntu0.10.04.1
  Version table:
 *** 5.1.72-0ubuntu0.10.04.1 0
        500 http://archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://archive.ubuntu.com/ubuntu/ lucid-security/main Packages
        100 /var/lib/dpkg/status
     5.1.41-3ubuntu12 0
        500 http://archive.ubuntu.com/ubuntu/ lucid/main Packages
mysql-client-core-5.1:
  Installed: 5.1.72-0ubuntu0.10.04.1
  Candidate: 5.1.72-0ubuntu0.10.04.1
  Version table:
 *** 5.1.72-0ubuntu0.10.04.1 0
        500 http://archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://archive.ubuntu.com/ubuntu/ lucid-security/main Packages
        100 /var/lib/dpkg/status
     5.1.41-3ubuntu12 0
        500 http://archive.ubuntu.com/ubuntu/ lucid/main Packages
mysql-common:
  Installed: 5.1.72-0ubuntu0.10.04.1
  Candidate: 5.1.72-0ubuntu0.10.04.1
  Version table:
 *** 5.1.72-0ubuntu0.10.04.1 0
        500 http://archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://archive.ubuntu.com/ubuntu/ lucid-security/main Packages
        100 /var/lib/dpkg/status
     5.1.41-3ubuntu12.10 0
        500 http://archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
     5.1.41-3ubuntu12.7 0
        500 http://archive.ubuntu.com/ubuntu/ lucid-security/main Packages
     5.1.41-3ubuntu12 0
        500 http://archive.ubuntu.com/ubuntu/ lucid/main Packages

Revision history for this message
Manfred Hampl (m-hampl) said :
#3

I do not see anything that could cause the version to be displayed differently.
Next idea would be to search for differences in config files, or the command lines used for starting the mysql server, but to be honest, I do not have a clue where to best start searching.

Revision history for this message
vangelis (vkatsikaros) said :
#4

One thing I didn't mention is that these machines are managed by chef, and they do install the latest apt available mysql. We use Opscode's standard mysql recipe. I don't know if this affect something.

I started looking at a the command lines used for starting the mysql server and I did found there were some differences from the file in the deb package. Still I don't know if they justify the change in the version name.

==============================================
/etc/init.d/mysql from http://security.ubuntu.com/ubuntu/pool/main/m/mysql-dfsg-5.1/mysql-server-5.1_5.1.72-0ubuntu0.10.04.1_amd64.deb

#!/bin/sh -e
# upstart-job
#
# Symlink target for initscripts that have been converted to Upstart.

set -e

INITSCRIPT="$(basename "$0")"
JOB="${INITSCRIPT%.sh}"

if [ "$JOB" = "upstart-job" ]; then
    if [ -z "$1" ]; then
        echo "Usage: upstart-job JOB COMMAND" 1>&2
 exit 1
    fi

    JOB="$1"
    INITSCRIPT="$1"
    shift
else
    if [ -z "$1" ]; then
        echo "Usage: $0 COMMAND" 1>&2
 exit 1
    fi
fi

COMMAND="$1"
shift

if [ -z "$DPKG_MAINTSCRIPT_PACKAGE" ]; then
 ECHO=echo
else
 ECHO=:
fi

$ECHO "Rather than invoking init scripts through /etc/init.d, use the service(8)"
$ECHO "utility, e.g. service $INITSCRIPT $COMMAND"

# Only check if jobs are disabled if the currently _running_ version of
# Upstart (which may be older than the latest _installed_ version)
# supports such a query.
#
# This check is necessary to handle the scenario when upgrading from a
# release without the 'show-config' command (introduced in
# Upstart for Ubuntu version 0.9.7) since without this check, all
# installed packages with associated Upstart jobs would be considered
# disabled.
#
# Once Upstart can maintain state on re-exec, this change can be
# dropped (since the currently running version of Upstart will always
# match the latest installed version).

UPSTART_VERSION_RUNNING=$(initctl version|awk '{print $3}'|tr -d ')')

if dpkg --compare-versions "$UPSTART_VERSION_RUNNING" ge 0.9.7
then
    initctl show-config -e "$JOB"|grep -q '^ start on' || DISABLED=1
fi

case $COMMAND in
status)
    $ECHO
    $ECHO "Since the script you are attempting to invoke has been converted to an"
    $ECHO "Upstart job, you may also use the $COMMAND(8) utility, e.g. $COMMAND $JOB"
    $COMMAND "$JOB"
    ;;
start|stop)
    $ECHO
    $ECHO "Since the script you are attempting to invoke has been converted to an"
    $ECHO "Upstart job, you may also use the $COMMAND(8) utility, e.g. $COMMAND $JOB"
    if status "$JOB" 2>/dev/null | grep -q ' start/'; then
        RUNNING=1
    fi
    if [ -z "$RUNNING" ] && [ "$COMMAND" = "stop" ]; then
        exit 0
    elif [ -n "$RUNNING" ] && [ "$COMMAND" = "start" ]; then
        exit 0
    elif [ -n "$DISABLED" ] && [ "$COMMAND" = "start" ]; then
        exit 0
    fi
    $COMMAND "$JOB"
    ;;
restart)
    $ECHO
    $ECHO "Since the script you are attempting to invoke has been converted to an"
    $ECHO "Upstart job, you may also use the stop(8) and then start(8) utilities,"
    $ECHO "e.g. stop $JOB ; start $JOB. The restart(8) utility is also available."
    if status "$JOB" 2>/dev/null | grep -q ' start/'; then
        RUNNING=1
    fi
    if [ -n "$RUNNING" ] ; then
        stop "$JOB"
    fi
    # If the job is disabled and is not currently running, the job is
    # not restarted. However, if the job is disabled but has been forced into the
    # running state, we *do* stop and restart it since this is expected behaviour
    # for the admin who forced the start.
    if [ -n "$DISABLED" ] && [ -z "$RUNNING" ]; then
        exit 0
    fi
    start "$JOB"
    ;;
reload|force-reload)
    $ECHO
    $ECHO "Since the script you are attempting to invoke has been converted to an"
    $ECHO "Upstart job, you may also use the reload(8) utility, e.g. reload $JOB"
    reload "$JOB"
    ;;
*)
    $ECHO
    $ECHO "The script you are attempting to invoke has been converted to an Upstart" 1>&2
    $ECHO "job, but $COMMAND is not supported for Upstart jobs." 1>&2
    exit 1
esac

==============================================
/etc/init.d/mysql from my local machine: I know I haven't done any modifications manually, but still there are differences

#!/bin/sh -e
# upstart-job
#
# Symlink target for initscripts that have been converted to Upstart.

set -e

INITSCRIPT="$(basename "$0")"
JOB="${INITSCRIPT%.sh}"

if [ "$JOB" = "upstart-job" ]; then
    if [ -z "$1" ]; then
        echo "Usage: upstart-job JOB COMMAND" 1>&2
 exit 1
    fi

    JOB="$1"
    INITSCRIPT="$1"
    shift
else
    if [ -z "$1" ]; then
        echo "Usage: $0 COMMAND" 1>&2
 exit 1
    fi
fi

COMMAND="$1"
shift

if [ -z "$DPKG_MAINTSCRIPT_PACKAGE" ]; then
 ECHO=echo
else
 ECHO=:
fi

$ECHO "Rather than invoking init scripts through /etc/init.d, use the service(8)"
$ECHO "utility, e.g. service $INITSCRIPT $COMMAND"

case $COMMAND in
status)
    $ECHO
    $ECHO "Since the script you are attempting to invoke has been converted to an"
    $ECHO "Upstart job, you may also use the $COMMAND(8) utility, e.g. $COMMAND $JOB"
    $COMMAND "$JOB"
    ;;
start|stop|restart)
    $ECHO
    $ECHO "Since the script you are attempting to invoke has been converted to an"
    $ECHO "Upstart job, you may also use the $COMMAND(8) utility, e.g. $COMMAND $JOB"
    PID=$(status "$JOB" 2>/dev/null | awk '/[0-9]$/ { print $NF }')
    if [ -z "$PID" ] && [ "$COMMAND" = "stop" ]; then
        exit 0
    elif [ -n "$PID" ] && [ "$COMMAND" = "start" ]; then
        exit 0
    elif [ -z "$PID" ] && [ "$COMMAND" = "restart" ]; then
        start "$JOB"
        exit 0
    fi
    $COMMAND "$JOB"
    ;;
reload|force-reload)
    $ECHO
    $ECHO "Since the script you are attempting to invoke has been converted to an"
    $ECHO "Upstart job, you may also use the $COMMAND(8) utility, e.g. $COMMAND $JOB"
    reload "$JOB"
    ;;
*)
    $ECHO
    $ECHO "The script you are attempting to invoke has been converted to an Upstart" 1>&2
    $ECHO "job, but $COMMAND is not supported for Upstart jobs." 1>&2
    exit 1
esac

Revision history for this message
vangelis (vkatsikaros) said :
#5

I did overlook the documentation http://dev.mysql.com/doc/refman/5.1/en/information-functions.html#function_version that directs to http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_version for details.

It clearly states that "-log indicates that one or more of the general log, slow query log, or binary log are enabled. ". I haven't noticed that before, but the solution to my question was there...