Diese Website existiert nur weil wir Werbung mit AdSense ausliefern.
Bitte den AdBlocker daher auf dieser Website ausschalten! Danke.

[gelöst]MySQL --> Fehler nicht spezifiziert!

Alles rund um die Systemverwaltung, die Administration und Konfiguration Eures Linuxsystems

Moderator: Moderatoren

Antworten
Arno L
Newbie
Newbie
Beiträge: 31
Registriert: 29. Jan 2007, 22:07

[gelöst]MySQL --> Fehler nicht spezifiziert!

Beitrag von Arno L » 10. Aug 2007, 23:11

Hallo zusammen,
seit kurzem kann ich MySQL nicht mehr starten.
Einzig um Runlevel-Editor bekam ich beim Startversuch folgende Meldung präsentiert:

Code: Alles auswählen

/etc/init.d/mysql start gab 1 (Fehler nicht spezifiziert) zurück:
Starting service MySQL..failed
Neuinstallation oder ältere Versionen brachten keine Hilfe.

Wer kann mir weiterhelfen?

Danke Arno

Werbung:
Benutzeravatar
nbkr
Guru
Guru
Beiträge: 2857
Registriert: 10. Jul 2004, 15:47

Beitrag von nbkr » 11. Aug 2007, 00:11

Such mal in der /etc/init.d/mysql nach "exit 1" und schau dir an warum das ausgelöst wird.
Kann gar nicht sein, ich bin gefürchtet Wald aus, Wald ein.

Arno L
Newbie
Newbie
Beiträge: 31
Registriert: 29. Jan 2007, 22:07

Beitrag von Arno L » 11. Aug 2007, 14:13

Hallo nbkr,
ich kann da leider nichts erkennen aber vielleicht siehst du mehr:

Code: Alles auswählen

#!/bin/sh
# Copyright (c) 1995-2002 SuSE Linux AG Nuernberg, Germany.
#
# Author: Lenz Grimmer <feedback@suse.de>
#
# /etc/init.d/mysql
#
#   and its symbolic link
#
# /usr/sbin/rcmysql
#
### BEGIN INIT INFO
# Provides:       mysql
# Required-Start: $network $remote_fs
# Required-Stop:
# Default-Start:  2 3 5
# Default-Stop:
# Description:    Start the MySQL database server
### END INIT INFO

# Shell functions sourced from /etc/rc.status:
#      rc_check         check and set local and overall rc status
#      rc_status        check and set local and overall rc status
#      rc_status -v     ditto but be verbose in local rc status
#      rc_status -v -r  ditto and clear the local rc status
#      rc_failed        set local and overall rc status to failed
#      rc_failed <num>  set local and overall rc status to <num>
#      rc_reset         clear local rc status (overall remains)
#      rc_exit          exit appropriate to overall rc status
. /etc/rc.status

# First reset status of this service
rc_reset

# Return values acc. to LSB for all commands but status:
# 0 - success
# 1 - generic or unspecified error
# 2 - invalid or excess argument(s)
# 3 - unimplemented feature (e.g. "reload")
# 4 - insufficient privilege
# 5 - program is not installed
# 6 - program is not configured
# 7 - program is not running
# 
# Note that starting an already running service, stopping
# or restarting a not-running service as well as the restart
# with force-reload (in case signalling is not supported) are
# considered a success.

# Test, if mysqld or mysql-max actually exist
unset MYSQLD
if test -x /usr/sbin/mysqld-max
then
        MYSQLD=/usr/sbin/mysqld-max
elif test -x /usr/sbin/mysqld
then
        MYSQLD=/usr/sbin/mysqld
fi
test "$MYSQLD" || { echo "Nor /usr/sbin/mysqld nor /usr/sbin/mysqld-max exists"; rc_failed 5; rc_status -v; rc_exit; }

# The following section has been taken from
# the original MySQL init script
basedir=/usr
datadir=/var/lib/mysql
mysql_daemon_user=mysql
mysql_daemon_group=mysql
pid_file=/var/lib/mysql/mysqld.pid
socket=/var/lib/mysql/mysql.sock
MYADMIN=/usr/bin/mysqladmin
export TMPDIR=/var/lib/mysql/tmp
if test -z "$basedir"
then
  basedir=/usr
  bindir=/usr/bin
else
  bindir="$basedir/bin"
fi

if test -z "$pid_file"
then
  pid_file=$datadir/`/bin/hostname`.pid
else
  case "$pid_file" in
    /* ) ;;
    * )  pid_file="$datadir/$pid_file" ;;
  esac
fi

mode=$1 # start or stop

parse_arguments() {
  for arg do
    case "$arg" in
      --basedir=*)  basedir=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
      --datadir=*)  datadir=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
      --pid-file=*) pid_file=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
	  --socket=*)   socket=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
    esac
  done
}

# Get arguments from the my.cnf file, groups [mysqld] and [mysql_server]
if test -x ./bin/my_print_defaults
then
  print_defaults="./bin/my_print_defaults"
elif test -x $bindir/my_print_defaults
then
  print_defaults="$bindir/my_print_defaults"
elif test -x $bindir/mysql_print_defaults
then
  print_defaults="$bindir/mysql_print_defaults"
else
  # Try to find basedir in /etc/my.cnf
  conf=/etc/my.cnf
  print_defaults=
  if test -r $conf
  then
    subpat='^[^=]*basedir[^=]*=\(.*\)$'
    dirs=`sed -e "/$subpat/!d" -e 's//\1/' $conf`
    for d in $dirs
    do
      d=`echo $d | sed -e 's/[ 	]//g'`
      if test -x "$d/bin/my_print_defaults"
      then
        print_defaults="$d/bin/my_print_defaults"
        break
      fi
      if test -x "$d/bin/mysql_print_defaults"
      then
        print_defaults="$d/bin/mysql_print_defaults"
        break
      fi
    done
  fi

  # Hope it's in the PATH ... but I doubt it
  test -z "$print_defaults" && print_defaults="my_print_defaults"
fi

parse_arguments `$print_defaults $defaults mysqld mysql_server`

# Safeguard (relative paths, core dumps..)
cd $basedir

case "$1" in
    start)
	# exit gracefully, if we are already running
	checkproc $MYSQLD && echo -n "Starting service MySQL " && \
	rc_status -v && rc_exit

	# Test, if safe_mysqld actually exists
	SAFE_MYSQLD=/usr/bin/mysqld_safe
	test -x $SAFE_MYSQLD || { echo "$SAFE_MYSQLD does not exist "; rc_failed 5; rc_status -v; rc_exit; }

    # check for ISAM tables
    tables=`find $datadir -name '*.ISM' | sed "s@$datadir/*@@; s@.ISM@@; s@/@.@;"`
    if test "$tables" ; then
        echo
        echo "Some tables still use ISAM format, please convert them to something "
        echo "better (eg. MyISAM). ISAM support will be dropped in future releases. "
        echo "You can use mysql_convert_table_format script to do this conversion. "
        echo
        echo "Tables using ISAM are: "
        echo "  $tables "
        echo
    fi

    # this file was used in past, but it's batter to place it youtside database directory
    if test -f $datadir/mysql/stamp-4.1 ; then
        rm $datadir/mysql/stamp-4.1
    fi

	# We assume a fresh install if the directory $datadir/mysql
	# does not exist and create the privilege database
	if ! ls $datadir/update-stamp-* >/dev/null 2>&1 ; then
		echo "Creating/Updating MySQL privilege database... "
		mysql_install_db --user=$mysql_daemon_user --datadir=$datadir || rc_failed
	fi
	if test ! -f $datadir/update-stamp-5.0 ; then
		echo "Updating MySQL privilege database... "

	echo "Fixing privilege tables... "
        (echo 'USE mysql;'; cat /usr/share/mysql/mysql_fix_privilege_tables.sql) \
		| sed '/^---\? /D; s/#.*//; s/;$/#/' | tr '\n' ' ' | tr '#' '\n' \
		| /usr/sbin/mysqld \
            --bootstrap \
            --skip-innodb \
            --skip-bdb \
            --skip-grant-tables \
            --user=$mysql_daemon_user \
            --pid-file=$pid_file \
            --socket=$socket \
            --datadir=$datadir 2>/dev/null

	rm -f $datadir/update-stamp-4.1
	touch $datadir/update-stamp-5.0
		
		# Fix ownerships and permissions for $datadir
		chmod 755 $datadir
		chown -R $mysql_daemon_user.$mysql_daemon_group $datadir
	fi

	echo -n "Starting service MySQL "

	$SAFE_MYSQLD \
	    --user=$mysql_daemon_user \
	    --pid-file=$pid_file \
	    --socket=$socket \
	    --datadir=$datadir &>/dev/null &

	for((i=0; i<50; i++)); do
	   sleep 0.2
           test -S $socket && i='' && break
        done

	test -z "$i" || rc_failed

	# Rmember status and be verbose
	rc_status -v
	;;

    stop)
	echo -n "Shutting down service MySQL "
	killproc -p $pid_file -TERM $MYSQLD

	# Remember status and be verbose
	rc_status -v
	;;

    try-restart)
	## Stop the service and if this succeeds (i.e. the 
	## service was running before), start it again.
	## Note: try-restart is not (yet) part of LSB (as of 0.7.5)
	$0 status >/dev/null &&  $0 restart

	# Remember status and be quiet
	rc_status
	;;

    restart|force-reload)
	echo "Restarting service MySQL "
	$0 stop
	$0 start

	rc_status
	;;

	reload)
	echo -n "Reloading service MySQL "
	killproc -p $pid_file -HUP $MYSQLD
	touch $pid_file
	rc_status -v
	;;
	
    check|status)
	echo -n "Checking for service MySQL: "
	## Check status with checkproc(8), if process is running
	## checkproc will return with exit status 0.

	# Status has a slightly different for the status command:
	# 0 - service running
	# 1 - service dead, but /var/run/  pid  file exists
	# 2 - service dead, but /var/lock/ lock file exists
	# 3 - service not running

	# NOTE: checkproc returns LSB compliant status values.
	checkproc $MYSQLD
	rc_status -v
	;;

    *)
	echo "Usage: $0 {start|stop|status|reload|restart|try-restart|force-reload}"
	exit 1
	;;
esac
rc_exit

# vim: ft=sh

Benutzeravatar
nbkr
Guru
Guru
Beiträge: 2857
Registriert: 10. Jul 2004, 15:47

Beitrag von nbkr » 11. Aug 2007, 15:16

Schau mal ob unter /var/run oder /var/lock irgendeine Datei mit dem Namen "mysql" liegt. Wenn ja, diese in einen anderen Ordner verschieben und dann versuchen MySQL neuzustarten. Ansonsten: Was sagen die Logfiles zu dem Startversuch?
Kann gar nicht sein, ich bin gefürchtet Wald aus, Wald ein.

Arno L
Newbie
Newbie
Beiträge: 31
Registriert: 29. Jan 2007, 22:07

Beitrag von Arno L » 11. Aug 2007, 18:14

alles negativ!
genannte Datei gibt es nicht und "mysqld.log" existiert ebenfalls nicht(Link in "/var/log/" zeigt auf nicht vorhandene Datei).
Kann es sein, dass MySQL durch einen anderen Dienst blockiert wird?
Wenn ja, welch kommt da in Frage?

Gruß
Arno

Benutzeravatar
panamajo
Guru
Guru
Beiträge: 2587
Registriert: 12. Feb 2005, 22:45

Beitrag von panamajo » 11. Aug 2007, 21:00

Fehler sollten in der Datei /var/lib/mysql/mysqld.err stehen
Arno L hat geschrieben:Kann es sein, dass MySQL durch einen anderen Dienst blockiert wird?
Wenn ja, welch kommt da in Frage?
mysqld :mrgreen:

Arno L
Newbie
Newbie
Beiträge: 31
Registriert: 29. Jan 2007, 22:07

Beitrag von Arno L » 11. Aug 2007, 21:20

panamajo hat geschrieben:Fehler sollten in der Datei /var/lib/mysql/mysqld.err stehen
mysqld :mrgreen:
schön wenn es das tut, nur gibts auch diese bei mir nicht, ebensowenig wie den Dienst mysqld !

Habe mir übergangsweise XAMPP installiert und arbeite damit.
Das sollte aber keine Dauerlösung sein.
In XAMPP geht MySQL!

Arno

Nilres
Member
Member
Beiträge: 222
Registriert: 13. Jun 2006, 18:02
Wohnort: Achim
Kontaktdaten:

Beitrag von Nilres » 11. Aug 2007, 22:51

Wie wärs wenn du ALLES killst was an diensten läuft oder noch besser es erst garnicht starten lässt und dann guckst ob sich was besser..... :D

jengelh
Guru
Guru
Beiträge: 4039
Registriert: 20. Nov 2004, 17:42
Kontaktdaten:

Beitrag von jengelh » 11. Aug 2007, 23:27

Code: Alles auswählen

bash -ex /etc/init.d/mysql start
Damit man nicht nach dem exit 1 suchen muss. Ist vielleicht ein Haufen Output, aber kann hilfreich sein. Und sonst...

Code: Alles auswählen

strace -fe execve,exit_group /etc/init.d/mysql start
um die Exit-Status zu sehen, die so hin und her gegeben werden.

Arno L
Newbie
Newbie
Beiträge: 31
Registriert: 29. Jan 2007, 22:07

Beitrag von Arno L » 12. Aug 2007, 00:05

zu
bash -ex /etc/init.d/mysql start

Code: Alles auswählen

++ test 80 -eq 0
++ export LINES COLUMNS
++ case ":$PATH:" in
++ test -t 1 -a xterm '!=' raw -a xterm '!=' dumb
++ stty size
+++ echo -en '\033'
++ esc=$'\E'
++ extd=''
++ warn=''
++ done=''
++ attn=''
+++ echo -en '\017'
++ norm=''
+++ echo -en '\015                                                                      '
++ stat='                                                             '
++ rc_done='                                                          done'
++ rc_running='                                                       running'
++ rc_failed='                                                        failed'
++ rc_missed='                                                        missing'
++ rc_skipped='                                                       skipped'
++ rc_dead='                                                          dead'
++ rc_unused='                                                        unused'
++ rc_unknown='                                                       failed''
++ rc_reset=''p='
++ rc_save=''
++ rc_restor'='
++ _rc_service=/etc/init.d/mysql
++ _rc_status=0
++ _rc_status_all=0
++ _rc_todo=start
++ test start = status
++ test -n start
+ rc_reset
+ _rc_status=0
+ _rc_status_all=0
+ rc_check
+ _rc_status_ret=0
+ test 0 -eq 0
+ test 0 -eq 0
+ return
+ return 0
+ unset MYSQLD
+ test -x /usr/sbin/mysqld-max
+ test -x /usr/sbin/mysqld
+ MYSQLD=/usr/sbin/mysqld
+ test /usr/sbin/mysqld
+ basedir=/usr
+ datadir=/var/lib/mysql
+ mysql_daemon_user=mysql
+ mysql_daemon_group=mysql
+ pid_file=/var/lib/mysql/mysqld.pid
+ socket=/var/lib/mysql/mysql.sock
+ MYADMIN=/usr/bin/mysqladmin
+ export TMPDIR=/var/lib/mysql/tmp
+ TMPDIR=/var/lib/mysql/tmp
+ test -z /usr
+ bindir=/usr/bin
+ test -z /var/lib/mysql/mysqld.pid
+ case "$pid_file" in
+ mode=start
+ test -x ./bin/my_print_defaults
+ test -x /usr/bin/my_print_defaults
+ print_defaults=/usr/bin/my_print_defaults
++ /usr/bin/my_print_defaults mysqld mysql_server
+ parse_arguments --port=3306 --socket=/var/lib/mysql/mysql.sock --skip-locking --key_buffer=16M --max_allowed_packet=1M --table_cache=64 --sort_buffer_size=512K --net_buffer_length=8K --read_buffer_size=256K --read_rnd_buffer_size=512K --myisam_sort_buffer_size=8M --server-id=1
+ for arg in '"$@"'
+ case "$arg" in
+ for arg in '"$@"'
+ case "$arg" in
++ echo --socket=/var/lib/mysql/mysql.sock
++ sed -e 's/^[^=]*=//'
+ socket=/var/lib/mysql/mysql.sock
+ for arg in '"$@"'
+ case "$arg" in
+ for arg in '"$@"'
+ case "$arg" in
+ for arg in '"$@"'
+ case "$arg" in
+ for arg in '"$@"'
+ case "$arg" in
+ for arg in '"$@"'
+ case "$arg" in
+ for arg in '"$@"'
+ case "$arg" in
+ for arg in '"$@"'
+ case "$arg" in
+ for arg in '"$@"'
+ case "$arg" in
+ for arg in '"$@"'
+ case "$arg" in
+ for arg in '"$@"'
+ case "$arg" in
+ cd /usr
+ case "$1" in
+ checkproc /usr/sbin/mysqld
+ SAFE_MYSQLD=/usr/bin/mysqld_safe
+ test -x /usr/bin/mysqld_safe
++ find /var/lib/mysql -name '*.ISM'
++ sed 's@/var/lib/mysql/*@@; s@.ISM@@; s@/@.@;'
+ tables=
+ test ''
+ test -f /var/lib/mysql/mysql/stamp-4.1
+ ls /var/lib/mysql/update-stamp-5.0
+ test '!' -f /var/lib/mysql/update-stamp-5.0
+ echo -n 'Starting service MySQL '
Starting service MySQL + /usr/bin/mysqld_safe --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql
+ (( i=0 ))
+ (( i<50 ))
+ sleep 0.2
+ test -S /var/lib/mysql/mysql.sock
+ (( i++ ))
+ (( i<50 ))
+ sleep 0.2
+ test -S /var/lib/mysql/mysql.sock

ab hier wiederholt sich das bis:

+ sleep 0.2
+ test -S /var/lib/mysql/mysql.sock
+ (( i++ ))
+ (( i<50 ))
+ test -z 50
+ rc_failed
+ rc_reset
+ _rc_status=0
+ _rc_status_all=0
+ rc_check
+ _rc_status_ret=0
+ test 0 -eq 0
+ test 0 -eq 0
+ return
+ return 0
+ case "$1" in
+ _rc_status=1
+ rc_check
+ _rc_status_ret=0
+ test 0 -eq 0
+ test 1 -eq 0
+ _rc_status_all=1
+ return
+ return 1

zu
strace -fe execve,exit_group /etc/init.d/mysql start

Code: Alles auswählen

execve("/etc/init.d/mysql", ["/etc/init.d/mysql", "start"], [/* 86 vars */]) = 0
Process 14991 attached
Process 14992 attached
Process 14993 attached
Process 14991 suspended
[pid 14992] execve("/bin/stty", ["stty", "size"], [/* 87 vars */]) = 0
[pid 14992] exit_group(1)               = ?
Process 14991 resumed
Process 14992 detached
Process 14991 suspended
[pid 14993] exit_group(0)               = ?
Process 14991 resumed
Process 14993 detached
[pid 14991] --- SIGCHLD (Child exited) @ 0 (0) ---
[pid 14991] exit_group(0)               = ?
Process 14991 detached
--- SIGCHLD (Child exited) @ 0 (0) ---
Process 14994 attached
Process 14990 suspended
[pid 14994] execve("/bin/stty", ["stty", "size"], [/* 89 vars */]) = 0
[pid 14994] exit_group(0)               = ?
Process 14990 resumed
Process 14994 detached
--- SIGCHLD (Child exited) @ 0 (0) ---
Process 14995 attached
[pid 14995] exit_group(0)               = ?
Process 14995 detached
--- SIGCHLD (Child exited) @ 0 (0) ---
Process 14996 attached
[pid 14996] exit_group(0)               = ?
Process 14996 detached
--- SIGCHLD (Child exited) @ 0 (0) ---
Process 14997 attached
[pid 14997] exit_group(0)               = ?
Process 14997 detached
--- SIGCHLD (Child exited) @ 0 (0) ---
Process 14998 attached
[pid 14998] execve("/usr/bin/my_print_defaults", ["/usr/bin/my_print_defaults", "mysqld", "mysql_server"], [/* 90 vars */]) = 0
[pid 14998] exit_group(0)               = ?
Process 14998 detached
--- SIGCHLD (Child exited) @ 0 (0) ---
Process 14999 attached
Process 15000 attached
Process 15001 attached
Process 14999 suspended
[pid 15000] exit_group(0)               = ?
Process 14999 resumed
Process 15000 detached
Process 14999 suspended
[pid 15001] execve("/usr/bin/sed", ["sed", "-e", "s/^[^=]*=//"], [/* 90 vars */]) = 0
[pid 15001] exit_group(0)               = ?
Process 14999 resumed
Process 15001 detached
[pid 14999] --- SIGCHLD (Child exited) @ 0 (0) ---
[pid 14999] exit_group(0)               = ?
Process 14999 detached
--- SIGCHLD (Child exited) @ 0 (0) ---
Process 15002 attached
Process 14990 suspended
[pid 15002] execve("/sbin/checkproc", ["checkproc", "/usr/sbin/mysqld"], [/* 91 vars */]) = 0
[pid 15002] exit_group(3)               = ?
Process 14990 resumed
Process 15002 detached
--- SIGCHLD (Child exited) @ 0 (0) ---
Process 15003 attached
Process 15004 attached
Process 15005 attached
Process 15003 suspended
[pid 15004] execve("/usr/bin/find", ["find", "/var/lib/mysql", "-name", "*.ISM"], [/* 91 vars */]) = 0
[pid 15005] execve("/usr/bin/sed", ["sed", "s@/var/lib/mysql/*@@; s@.ISM@@; "...], [/* 91 vars */]) = 0
[pid 15004] exit_group(0)               = ?
Process 15003 resumed
Process 15004 detached
Process 15003 suspended
[pid 15005] exit_group(0)               = ?
Process 15003 resumed
Process 15005 detached
[pid 15003] --- SIGCHLD (Child exited) @ 0 (0) ---
[pid 15003] exit_group(0)               = ?
Process 15003 detached
--- SIGCHLD (Child exited) @ 0 (0) ---
Process 15006 attached
Process 14990 suspended
[pid 15006] execve("/bin/ls", ["ls", "/var/lib/mysql/update-stamp-5.0"], [/* 91 vars */]) = 0
[pid 15006] exit_group(0)               = ?
Process 14990 resumed
Process 15006 detached
--- SIGCHLD (Child exited) @ 0 (0) ---
Starting service MySQL Process 15007 attached
[pid 15007] execve("/usr/bin/mysqld_safe", ["/usr/bin/mysqld_safe", "--user=mysql", "--pid-file=/var/lib/mysql/mysqld"..., "--socket=/var/lib/mysql/mysql.so"..., "--datadir=/var/lib/mysql"], [/* 91 vars */]) = 0
Process 15008 attached
Process 14990 suspended
[pid 15008] execve("/bin/sleep", ["sleep", "0.2"], [/* 91 vars */]) = 0
Process 15009 attached
[pid 15009] exit_group(0)               = ?
Process 15009 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15010 attached
[pid 15010] execve("./bin/my_print_defaults", ["./bin/my_print_defaults", "--loose-verbose", "mysqld", "server"], [/* 91 vars */]) = 0
[pid 15010] exit_group(0)               = ?
Process 15010 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15011 attached
Process 15012 attached
Process 15013 attached
Process 15011 suspended
[pid 15012] exit_group(0)               = ?
Process 15011 resumed
Process 15012 detached
Process 15011 suspended
[pid 15013] execve("/usr/bin/sed", ["sed", "-e", "s;--port=;;"], [/* 91 vars */]) = 0
[pid 15013] exit_group(0)               = ?
Process 15011 resumed
Process 15013 detached
[pid 15011] --- SIGCHLD (Child exited) @ 0 (0) ---
[pid 15011] exit_group(0)               = ?
Process 15011 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15014 attached
Process 15015 attached
Process 15016 attached
Process 15014 suspended
[pid 15015] exit_group(0)               = ?
Process 15014 resumed
Process 15015 detached
Process 15014 suspended
[pid 15016] execve("/usr/bin/sed", ["sed", "-e", "s;--socket=;;"], [/* 91 vars */]) = 0
[pid 15016] exit_group(0)               = ?
Process 15014 resumed
Process 15016 detached
[pid 15014] --- SIGCHLD (Child exited) @ 0 (0) ---
[pid 15014] exit_group(0)               = ?
Process 15014 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15017 attached
[pid 15017] execve("./bin/my_print_defaults", ["./bin/my_print_defaults", "--loose-verbose", "mysqld_safe", "safe_mysqld"], [/* 91 vars */]) = 0
[pid 15017] exit_group(0)               = ?
Process 15017 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15018 attached
Process 15019 attached
Process 15020 attached
Process 15018 suspended
[pid 15019] exit_group(0)               = ?
Process 15018 resumed
Process 15019 detached
Process 15018 suspended
[pid 15020] execve("/usr/bin/sed", ["sed", "-e", "s;--err-log=;;"], [/* 91 vars */]) = 0
[pid 15020] exit_group(0)               = ?
Process 15018 resumed
Process 15020 detached
[pid 15018] --- SIGCHLD (Child exited) @ 0 (0) ---
[pid 15018] exit_group(0)               = ?
Process 15018 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15021 attached
Process 15022 attached
Process 15023 attached
Process 15021 suspended
[pid 15023] execve("/usr/bin/sed", ["sed", "-e", "s;--[^=]*=;;"], [/* 91 vars */]) = 0
[pid 15022] exit_group(0)               = ?
Process 15021 resumed
Process 15022 detached
Process 15021 suspended
[pid 15023] exit_group(0)               = ?
Process 15021 resumed
Process 15023 detached
[pid 15021] --- SIGCHLD (Child exited) @ 0 (0) ---
[pid 15021] exit_group(0)               = ?
Process 15021 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15024 attached
Process 15025 attached
Process 15026 attached
Process 15024 suspended
[pid 15025] exit_group(0)               = ?
Process 15024 resumed
Process 15025 detached
Process 15024 suspended
[pid 15026] execve("/usr/bin/sed", ["sed", "-e", "s;--pid-file=;;"], [/* 91 vars */]) = 0
[pid 15026] exit_group(0)               = ?
Process 15024 resumed
Process 15026 detached
[pid 15024] --- SIGCHLD (Child exited) @ 0 (0) ---
[pid 15024] exit_group(0)               = ?
Process 15024 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15027 attached
Process 15028 attached
Process 15029 attached
Process 15027 suspended
[pid 15029] execve("/usr/bin/sed", ["sed", "-e", "s;--socket=;;"], [/* 91 vars */]) = 0
[pid 15028] exit_group(0)               = ?
Process 15027 resumed
Process 15028 detached
Process 15027 suspended
[pid 15029] exit_group(0)               = ?
Process 15027 resumed
Process 15029 detached
[pid 15027] --- SIGCHLD (Child exited) @ 0 (0) ---
[pid 15027] exit_group(0)               = ?
Process 15027 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15030 attached
Process 15031 attached
Process 15032 attached
Process 15030 suspended
[pid 15031] exit_group(0)               = ?
Process 15030 resumed
Process 15031 detached
Process 15030 suspended
[pid 15032] execve("/usr/bin/sed", ["sed", "-e", "s;--datadir=;;"], [/* 91 vars */]) = 0
[pid 15032] exit_group(0)               = ?
Process 15030 resumed
Process 15032 detached
[pid 15030] --- SIGCHLD (Child exited) @ 0 (0) ---
[pid 15030] exit_group(0)               = ?
Process 15030 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15033 attached
[pid 15033] execve("/usr/bin/dirname", ["dirname", "/var/lib/mysql/mysql.sock"], [/* 91 vars */]) = 0
[pid 15033] exit_group(0)               = ?
Process 15033 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15034 attached
Process 15007 suspended
[pid 15034] execve("/usr/bin/nohup", ["nohup", "nice"], [/* 91 vars */]) = 0
[pid 15034] execve("/opt/kde3/bin/nice", ["nice"], [/* 91 vars */]) = -1 ENOENT (No such file or directory)
[pid 15034] execve("/home/arno/bin/nice", ["nice"], [/* 91 vars */]) = -1 ENOENT (No such file or directory)
[pid 15034] execve("/usr/local/bin/nice", ["nice"], [/* 91 vars */]) = -1 ENOENT (No such file or directory)
[pid 15034] execve("/usr/bin/nice", ["nice"], [/* 91 vars */]) = 0
[pid 15034] exit_group(0)               = ?
Process 15007 resumed
Process 15034 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15035 attached
[pid 15035] execve("/usr/bin/nice", ["nice"], [/* 91 vars */]) = 0
[pid 15035] exit_group(0)               = ?
Process 15035 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15036 attached
[pid 15036] execve("/usr/bin/nohup", ["nohup", "nice"], [/* 91 vars */]) = 0
[pid 15036] execve("/opt/kde3/bin/nice", ["nice"], [/* 91 vars */]) = -1 ENOENT (No such file or directory)
[pid 15036] execve("/home/arno/bin/nice", ["nice"], [/* 91 vars */]) = -1 ENOENT (No such file or directory)
[pid 15036] execve("/usr/local/bin/nice", ["nice"], [/* 91 vars */]) = -1 ENOENT (No such file or directory)
[pid 15036] execve("/usr/bin/nice", ["nice"], [/* 91 vars */]) = 0
[pid 15036] exit_group(0)               = ?
Process 15036 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15037 attached
[pid 15037] execve("/usr/bin/expr", ["expr", "0", "-", "0"], [/* 91 vars */]) = 0
[pid 15037] exit_group(1)               = ?
Process 15037 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15038 attached
Process 15007 suspended
[pid 15038] execve("/usr/bin/touch", ["touch", "/var/lib/mysql/mysqld.log"], [/* 91 vars */]) = 0
[pid 15038] exit_group(1)               = ?
Process 15007 resumed
Process 15038 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15039 attached
Process 15007 suspended
[pid 15039] execve("/bin/chown", ["chown", "mysql.mysql", "/var/lib/mysql/mysqld.log"], [/* 91 vars */]) = 0
[pid 15039] exit_group(1)               = ?
Process 15007 resumed
Process 15039 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15040 attached
[pid 15040] execve("/bin/date", ["date", "+%y%m%d %H:%M:%S  mysqld started"...], [/* 91 vars */]) = 0
Process 15007 suspended
[pid 15040] exit_group(0)               = ?
Process 15007 resumed
Process 15040 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15041 attached
Process 15007 suspended
[pid 15041] execve("/bin/rm", ["rm", "-f", "/var/lib/mysql/mysql.sock", "/var/lib/mysql/mysqld.pid"], [/* 91 vars */]) = 0
[pid 15041] exit_group(0)               = ?
Process 15007 resumed
Process 15041 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15042 attached
Process 15007 suspended
[pid 15042] exit_group(1)               = ?
Process 15007 resumed
Process 15042 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15043 attached
Process 15044 attached
Process 15007 suspended
Process 15045 attached
[pid 15044] execve("/usr/bin/tee", ["tee", "-a", "/var/lib/mysql/mysqld.log"], [/* 91 vars */]) = 0
[pid 15045] execve("/bin/date", ["date", "+%y%m%d %H:%M:%S"], [/* 91 vars */]) = 0
[pid 15045] exit_group(0)               = ?
Process 15045 detached
[pid 15043] --- SIGCHLD (Child exited) @ 0 (0) ---
[pid 15043] exit_group(0)               = ?
Process 15007 resumed
Process 15043 detached
[pid 15008] exit_group(0)               = ?
Process 14990 resumed
Process 15008 detached
[pid 14990] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15046 attached
Process 14990 suspended
[pid 15046] execve("/bin/sleep", ["sleep", "0.2"], [/* 91 vars */]) = 0
Process 15007 suspended
[pid 15044] exit_group(1)               = ?
Process 15007 resumed
Process 15044 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
Process 15047 attached
Process 15048 attached
Process 15007 suspended
[pid 15047] exit_group(0)               = ?
Process 15007 resumed
Process 15047 detached
Process 15007 suspended
[pid 15048] execve("/usr/bin/tee", ["tee", "-a", "/var/lib/mysql/mysqld.log"], [/* 91 vars */]) = 0
[pid 15048] exit_group(1)               = ?
Process 15007 resumed
Process 15048 detached
[pid 15007] --- SIGCHLD (Child exited) @ 0 (0) ---
[pid 15007] exit_group(1)               = ?
Process 14990 resumed
Process 15007 detached
Process 14990 suspended
[pid 15046] exit_group(0)               = ?
Process 14990 resumed
Process 15046 detached
--- SIGCHLD (Child exited) @ 0 (0) ---
Process 15049 attached
Process 14990 suspended
[pid 15049] execve("/bin/sleep", ["sleep", "0.2"], [/* 91 vars */]) = 0
[pid 15049] exit_group(0)               = ?
Process 14990 resumed
Process 15049 detached
--- SIGCHLD (Child .....

hier wiederholt sich alles bis:
Process 14990 resumed
Process 15099 detached
--- SIGCHLD (Child exited) @ 0 (0) ---
Process 15100 attached
Process 14990 suspended
[pid 15100] execve("/bin/sleep", ["sleep", "0.2"], [/* 91 vars */]) = 0
[pid 15100] exit_group(0)               = ?
Process 14990 resumed
Process 15100 detached
--- SIGCHLD (Child exited) @ 0 (0) ---
                                                                      failed
exit_group(1)                           = ?
Process 14990 detached
Viel Glück

Arno

Arno L
Newbie
Newbie
Beiträge: 31
Registriert: 29. Jan 2007, 22:07

[gelöst] MySQL --> Fehler nicht spezifiziert!

Beitrag von Arno L » 22. Aug 2007, 23:07

ich hab heute mal wieder nach langer Zeit getestet ob das Problem noch besteht und siehe da:
es geht wieder.

Bitte fragt nicht warum.
Ich weiß es nicht!
Die letzten Tage habe ich mit smart so manches aktualisiert (nicht mysql!), sehr wahrscheinlich hatte sich da was nicht vertragen und ist mit letzter Aktion aus dem Weg oder einfach anders besser..............

trotzdem Danke

Arno

Benutzeravatar
whois
Administrator
Administrator
Beiträge: 16599
Registriert: 11. Okt 2004, 08:50
Wohnort: Aachen
Kontaktdaten:

Beitrag von whois » 23. Aug 2007, 06:45

Hi

Kannst du uns denn sagen was du genau aktualisiert hast?
Würde mich echt mal interessieren woran das lag.

cu

Arno L
Newbie
Newbie
Beiträge: 31
Registriert: 29. Jan 2007, 22:07

Beitrag von Arno L » 23. Aug 2007, 11:31

whois hat geschrieben: Kannst du uns denn sagen was du genau aktualisiert hast?
Würde mich echt mal interessieren woran das lag.
da liegt das Problem: ich hab das komplette System aktualisiert (10.1).
Von Kernel bis Amarok.

:cry: Schade, dass ich da nicht mehr helfen kann!

Arno

Benutzeravatar
whois
Administrator
Administrator
Beiträge: 16599
Registriert: 11. Okt 2004, 08:50
Wohnort: Aachen
Kontaktdaten:

Beitrag von whois » 23. Aug 2007, 11:33

Hi

Naja Hauptsache alles funktioniert wieder,war vielleicht irgendwelche Abhängigkeiten die nicht gepasst haben. :wink:

cu

Antworten

Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 3 Gäste