Version naming *-log
Hi
One some Ubuntu 10.04 LTS, I get a mysql version (in the mysql client with SELECT VERSION() ) of
5.1.72-
whereas in some other systems I get a version
5.1.72-
What does the "-log" signifies?
Regards
Vangelis
Question information
- Language:
- English Edit question
- Status:
- Solved
- Assignee:
- No assignee Edit question
- Solved by:
- vangelis
- Solved:
- Last query:
- Last reply:
Revision history for this message
|
#1 |
What is the output of the command
apt-cache policy mysql-*
on these different systems?
Revision history for this message
|
#2 |
Hi I couldn't do apt-cache policy mysql-* instead I did:
=======
From the 5.1.72-
apt-cache policy mysql-server mysql-server-5.1 mysql-server-
mysql-server:
Installed: 5.1.72-
Candidate: 5.1.72-
Version table:
*** 5.1.72-
500 http://
500 http://
100 /var/lib/
5.
500 http://
5.
500 http://
500 http://
5.
500 http://
5.
500 http://
500 http://
mysql-server-5.1:
Installed: 5.1.72-
Candidate: 5.1.72-
Version table:
*** 5.1.72-
500 http://
500 http://
100 /var/lib/
5.
500 http://
5.
500 http://
500 http://
mysql-server-
Installed: 5.1.72-
Candidate: 5.1.72-
Version table:
*** 5.1.72-
500 http://
500 http://
100 /var/lib/
5.
500 http://
5.
500 http://
500 http://
mysql-client:
Installed: 5.1.72-
Candidate: 5.1.72-
Version table:
*** 5.1.72-
500 http://
500 http://
100 /var/lib/
5.
500 http://
5.
500 http://
500 http://
5.
500 http://
5.
500 http://
500 http://
mysql-client-5.1:
Installed: 5.1.72-
Candidate: 5.1.72-
Version table:
*** 5.1.72-
500 http://
500 http://
100 /var/lib/
5.
500 http://
5.
500 http://
500 http://
mysql-client-
Installed: 5.1.72-
Candidate: 5.1.72-
Version table:
*** 5.1.72-
500 http://
500 http://
100 /var/lib/
5.
500 http://
5.
500 http://
500 http://
mysql-common:
Installed: 5.1.72-
Candidate: 5.1.72-
Version table:
*** 5.1.72-
500 http://
500 http://
100 /var/lib/
5.
500 http://
5.
500 http://
500 http://
5.
500 http://
5.
500 http://
500 http://
=======
From the 5.1.72-
apt-cache policy mysql-server mysql-server-5.1 mysql-server-
mysql-server:
Installed: 5.1.72-
Candidate: 5.1.72-
Version table:
*** 5.1.72-
500 http://
500 http://
100 /var/lib/
5.
500 http://
5.
500 http://
5.
500 http://
mysql-server-5.1:
Installed: 5.1.72-
Candidate: 5.1.72-
Version table:
*** 5.1.72-
500 http://
500 http://
100 /var/lib/
5.
500 http://
mysql-server-
Installed: 5.1.72-
Candidate: 5.1.72-
Version table:
*** 5.1.72-
500 http://
500 http://
100 /var/lib/
5.
500 http://
mysql-client:
Installed: (none)
Candidate: 5.1.72-
Version table:
5.
500 http://
500 http://
5.
500 http://
5.
500 http://
5.
500 http://
mysql-client-5.1:
Installed: 5.1.72-
Candidate: 5.1.72-
Version table:
*** 5.1.72-
500 http://
500 http://
100 /var/lib/
5.
500 http://
mysql-client-
Installed: 5.1.72-
Candidate: 5.1.72-
Version table:
*** 5.1.72-
500 http://
500 http://
100 /var/lib/
5.
500 http://
mysql-common:
Installed: 5.1.72-
Candidate: 5.1.72-
Version table:
*** 5.1.72-
500 http://
500 http://
100 /var/lib/
5.
500 http://
5.
500 http://
5.
500 http://
Revision history for this message
|
#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
|
#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://
#!/bin/sh -e
# upstart-job
#
# Symlink target for initscripts that have been converted to Upstart.
set -e
INITSCRIPT=
JOB="${
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_
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_
if dpkg --compare-versions "$UPSTART_
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|
$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=
JOB="${
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_
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|
$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
|
#5 |
I did overlook the documentation http://
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...