Mysql will nicht mehr unkown option --2

MySQL, PostgreSQL, SQLite
rǃppz
Posts: 127
Joined: 2003-04-02 14:14

Mysql will nicht mehr unkown option --2

Post by rǃppz » 2004-08-09 22:53

Hallo,

habe den Server neugestartet und habe mich gewundert warum mysql nicht mehr geht also mysqld als error bekomm ich:

mysqld: ERROR: unknown option '--2'

Ich nutze Debian woody und auch rein apt-get remove und install auch mit purge hat nix gebracht auch der Versuch von 4.0.20 auf 0.18 zu wechseln hat nichts gebracht ein strace gibt folgendes aus:
~# strace mysqld
execve("/usr/sbin/mysqld", ["mysqld"], [/* 14 vars */]) = 0
uname({sys="Linux", node="server1", ...}) = 0
brk(0) = 0x841af28
open("/etc/ld.so.preload", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=0, ...}) = 0
close(3) = 0
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=12780, ...}) = 0
old_mmap(NULL, 12780, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40014000
close(3) = 0
open("/lib/librt.so.1", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\030031"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=23388, ...}) = 0
old_mmap(NULL, 69012, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40018000
mprotect(0x4001e000, 44436, PROT_NONE) = 0
old_mmap(0x4001e000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x5000) = 0x4001e000
old_mmap(0x4001f000, 40340, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x4001f000
close(3) = 0
open("/lib/libwrap.so.0", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\0@ \0\000"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=24328, ...}) = 0
old_mmap(NULL, 29092, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40029000
mprotect(0x4002f000, 4516, PROT_NONE) = 0
old_mmap(0x4002f000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x5000) = 0x4002f000
old_mmap(0x40030000, 420, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40030000
close(3) = 0
open("/lib/libdl.so.2", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\0T27\0\000"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=8008, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40031000
old_mmap(NULL, 11004, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40032000
mprotect(0x40034000, 2812, PROT_NONE) = 0
old_mmap(0x40034000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x1000) = 0x40034000
close(3) = 0
open("/usr/lib/libssl.so.0.9.6", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\0260215"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=182084, ...}) = 0
old_mmap(NULL, 182848, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40035000
mprotect(0x4005f000, 10816, PROT_NONE) = 0
old_mmap(0x4005f000, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x2a000) = 0x4005f000
close(3) = 0
open("/usr/lib/libcrypto.so.0.9.6", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\024036"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=771908, ...}) = 0
old_mmap(NULL, 783840, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40062000
mprotect(0x40114000, 54752, PROT_NONE) = 0
old_mmap(0x40114000, 45056, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0xb2000) = 0x40114000
old_mmap(0x4011f000, 9696, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x4011f000
close(3) = 0
open("/lib/libpthread.so.0", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\0`C\0\000"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=102172, ...}) = 0
old_mmap(NULL, 81316, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40122000
mprotect(0x4012f000, 28068, PROT_NONE) = 0
old_mmap(0x4012f000, 28672, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0xd000) = 0x4012f000
close(3) = 0
open("/usr/lib/libz.so.1", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\020030"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=55432, ...}) = 0
old_mmap(NULL, 54460, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40136000
mprotect(0x40142000, 5308, PROT_NONE) = 0
old_mmap(0x40142000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0xc000) = 0x40142000
close(3) = 0
open("/lib/libcrypt.so.1", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\0320t\0"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=19136, ...}) = 0
old_mmap(NULL, 182044, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40144000
mprotect(0x40149000, 161564, PROT_NONE) = 0
old_mmap(0x40149000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x4000) = 0x40149000
old_mmap(0x4014a000, 157468, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x4014a000
close(3) = 0
open("/lib/libnsl.so.1", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\0 ;\0\000"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=69472, ...}) = 0
old_mmap(NULL, 80988, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40171000
mprotect(0x40182000, 11356, PROT_NONE) = 0
old_mmap(0x40182000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x10000) = 0x40182000
old_mmap(0x40183000, 7260, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40183000
close(3) = 0
open("/usr/lib/libstdc++-libc6.2-2.so.3", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\0P2331"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=288540, ...}) = 0
old_mmap(NULL, 296708, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40185000
mprotect(0x401bb000, 75524, PROT_NONE) = 0
old_mmap(0x401bb000, 69632, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x36000) = 0x401bb000
old_mmap(0x401cc000, 5892, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x401cc000
close(3) = 0
open("/lib/libm.so.6", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\02007\0"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=130088, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x401ce000
old_mmap(NULL, 132708, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x401cf000
mprotect(0x401ef000, 1636, PROT_NONE) = 0
old_mmap(0x401ef000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x1f000) = 0x401ef000
close(3) = 0
open("/lib/libc.so.6", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\030222"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0755, st_size=1153784, ...}) = 0
old_mmap(NULL, 1166560, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x401f0000
mprotect(0x40303000, 40160, PROT_NONE) = 0
old_mmap(0x40303000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x113000) = 0x40303000
old_mmap(0x40309000, 15584, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40309000
close(3) = 0
munmap(0x40014000, 12780) = 0
getrlimit(0x3, 0xbffffbfc) = 0
setrlimit(RLIMIT_STACK, {rlim_cur=2044*1024, rlim_max=RLIM_INFINITY}) = 0
getpid() = 3191
uname({sys="Linux", node="server1", ...}) = 0
rt_sigaction(SIGRTMIN, {0x4012a480, [], 0x4000000}, NULL, 8) = 0
rt_sigaction(SIGRT_1, {0x4012a508, [], 0x4000000}, NULL, 8) = 0
rt_sigaction(SIGRT_2, {0x4012a608, [], 0x4000000}, NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [RTMIN], NULL, 8) = 0
_sysctl({{CTL_KERN, KERN_VERSION}, 2, 0xbffffa04, 34, (nil), 0}) = 0
brk(0) = 0x841af28
brk(0x841af58) = 0x841af58
brk(0x841b000) = 0x841b000
brk(0x841c000) = 0x841c000
open("/etc/localtime", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=837, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40014000
read(3, "TZif\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\010\0\0\010"..., 4096) = 837
close(3) = 0
munmap(0x40014000, 4096) = 0
time(NULL) = 1092084510
uname({sys="Linux", node="server1", ...}) = 0
stat64("/etc/mysql/my.cnf", {st_mode=S_IFREG|0644, st_size=2663, ...}) = 0
open("/etc/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=2663, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40014000
read(3, "#n# The MySQL database server co"..., 4096) = 2663
read(3, "", 4096) = 0
close(3) = 0
munmap(0x40014000, 4096) = 0
stat64("/var/lib/mysql/my.cnf", {st_mode=S_IFREG|0644, st_size=48, ...}) = 0
open("/var/lib/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=48, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40014000
read(3, "# This file must exist - CAN-200"..., 4096) = 48
read(3, "", 4096) = 0
close(3) = 0
munmap(0x40014000, 4096) = 0
stat64("/root/.my.cnf", {st_mode=S_IFREG|0644, st_size=2661, ...}) = 0
open("/root/.my.cnf", O_RDONLY|O_LARGEFILE) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=2661, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40014000
read(3, "#n# The MySQL database server co"..., 4096) = 2661
read(3, "", 4096) = 0
close(3) = 0
munmap(0x40014000, 4096) = 0
write(2, "mysqld: ERROR: unknown option '-"..., 36mysqld: ERROR: unknown option '--2'
) = 36
_exit(2) = ?
Am anfang existierte die /root/.my.ncf nicht, da hab die von /etc/mysql/my.cnf genutzt:
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "/var/lib/mysql/my.cnf" to set server-specific options or
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
[client]
#password = my_password
port = 3306
socket = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
err-log = /var/log/mysql/mysql.err
socket = /var/run/mysqld/mysqld.sock

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
#
# You can also put it into /var/log/mysql/mysql.log but I leave it in /var/log
# for backward compatibility. Both location gets rotated by the cronjob.
#log = /var/log/mysql.log
log = /var/log/mysql/mysql.log
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-locking
#
# The skip-networking option will no longer be set via debconf menu.
# You have to manually change it if you want networking i.e. the server
# listening on port 3306. The default is "disable" - for security reasons.
skip-networking
#key_buffer = 16M
#max_allowed_packet = 32M
#thread_stack = 128K
2
# Query Cache Configuration
#
query_cache_limit = 1048576
query_cache_size = 26214400
query_cache_type = 1
#
# Here you can see queries with especially long duration
#log-slow-queries = /var/log/mysql/mysql-slow.log
#
# The following can be used as easy to replay backup logs or for replication
#server-id = 1
#log-bin = /var/log/mysql/mysql-bin.log
#binlog-do-db = include_database_name
#binlog-ignore-db = include_database_name
#
# Read the manual if you want to enable InnoDB!
skip-innodb
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# If you want to enable SSL support (recommended) read the manual or my
# HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



#[mysqldump]
#quick
#max_allowed_packet = 50M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 16M
Leider hab ich nix gefunden was die Ursache sein könnte.

oxygen
Posts: 2138
Joined: 2002-12-15 00:10
Location: Bergheim

Re: Mysql will nicht mehr unkown option --2

Post by oxygen » 2004-08-09 23:23

Deine Config ist kaputt. Sie enthält in einer Zeile nur "2" (über dem Query Cache Abschnitt) MySQL interpretiert das als Option, die es natürlich nicht kennt und deshalb abbricht.

rǃppz
Posts: 127
Joined: 2003-04-02 14:14

Re: Mysql will nicht mehr unkown option --2

Post by rǃppz » 2004-08-09 23:59

Vielen Dank für die schnelle Hilfe hab das ganz übersehen.

Vielen Dank