[RIJESENO] mysql nece da se pokrene

[boby]

sudo chkconfig --list
…
mysql 0:off 1:off 2:off 3:off 4:off 5:off 6:off
…

sudo /etc/init.d/mysql start:

Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql start

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the start(8) utility, e.g. start mysql
start: Job failed to start

sudo service mysql start
start: Job failed to start

Na google-u nisam nista nasao sto bi mi pomoglo. Reinstalirao sam mysql ni to nije pomoglo.

Kubuntu 10.10.

[aldin]

[quote=boby]sudo chkconfig --list
…
mysql 0:off 1:off 2:off 3:off 4:off 5:off 6:off
…

sudo /etc/init.d/mysql start:

Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql start

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the start(8) utility, e.g. start mysql
start: Job failed to start

sudo service mysql start
start: Job failed to start

Na google-u nisam nista nasao sto bi mi pomoglo. Reinstalirao sam mysql ni to nije pomoglo.

Kubuntu 10.10.[/quote]

1. sudo tail -f /var/log/messages &

2. sudo service mysql stop

2.1 ps aux|grep mysql (ako šta preživi kill -9 PID)

3. sudo service mysql start

4. fg

5. Ctrl + C

[Amar]

Osim /var/log/messages pogledaj jos i /var/log/syslog. Obavezno provjeri ovo sto ti je @nidla rekao sa ps, ako prezivi kill ga rucno. Ako i dalje ne fercera, postavi ovdje /etc/mysql/my.cnf. Cesto se zna desiti recimo da mysql ne moze da napravi .pid file ili .sock file.

Ako i dalje ne bude ferceralo, ima jedan nacin da se potpuno skine sa masine. I nije bas jednostavan, recimo na debian baziranim masinama: apt-get autoremove --purge mysql-server ne uspije sve pobrisati i prilikom nove instalacije se opet ne moze pokrenuti. Googleao sam pola dana dok na nekom opskurnom forumu nisam nasao sta se sve treba pobrisati da se mysql totalno skine sa racunara.

Uglavnom javi ove logove i eventualno config pa cemo dalje.

[bzip]

ovo :

strace -o mysql.txt service mysql start

pa nam prikazi sta je u mysql.txt?

Poz

[boby]

sudo tail -f /var/log/messages &
[1] 4774
boby@HP:~$ Jan 24 20:33:11 HP kernel: [ 20.421510] Bluetooth: SCO (Voice Link) ver 0.6
Jan 24 20:33:11 HP kernel: [ 20.421517] Bluetooth: SCO socket layer initialized
Jan 24 20:33:11 HP kernel: [ 20.521354] Bluetooth: RFCOMM TTY layer initialized
Jan 24 20:33:11 HP kernel: [ 20.521363] Bluetooth: RFCOMM socket layer initialized
Jan 24 20:33:11 HP kernel: [ 20.521365] Bluetooth: RFCOMM ver 1.11
Jan 24 20:33:11 HP kernel: [ 20.641037] vboxdrv: fAsync=1 offMin=0xeb4a0f offMax=0xeb4a0f
Jan 24 20:33:11 HP kernel: [ 20.642607] vboxdrv: TSC mode is ‘asynchronous’, kernel timer mode is ‘normal’.
Jan 24 20:36:10 HP kernel: [ 199.410174] EXT4-fs (sda1): re-mounted. Opts: errors=remount-ro,commit=0
Jan 24 20:36:10 HP kernel: [ 199.416866] EXT4-fs (sda5): re-mounted. Opts: commit=0
Jan 24 20:41:00 HP kernel: [ 490.129109] CPUFREQ: Per core ondemand sysfs interface is deprecated - ignore_nice_load

sudo service mysql stop
stop: Unknown instance:

ps aux|grep mysql
boby 1858 0.1 0.8 223580 31648 ? Sl 20:36 0:00 /usr/sbin/mysqld-akonadi --defaults-file=/home/boby/.local/share/akonadi//mysql.conf --datadir /home/boby/.local/share/akonadi/db_data/ --socket=/home/boby/.local/share/akonadi/db_misc/mysql.socket
boby 4921 0.0 0.0 90556 852 pts/1 S+ 20:47 0:00 grep --color=auto mysql

uradim sudo kill -9 1858 i nakn toga ostaje:

ps aux|grep mysql
boby 5067 0.0 0.0 90552 848 pts/1 S+ 20:48 0:00 grep --color=auto mysql koji se nikako ne da ubiti
sudo kill -9 5067
kill: No such process

4. i 5.

fg
sudo tail -f /var/log/messages
^C
boby@HP:~$ ^C

[boby]

U messages ima jedino
apparmor=“STATUS” operation=“profile_load” name="/usr/sbin/mysqld-akonadi" pid=1093 comm="apparmor_parser"
vezano za mysql

i isto to u syslog

[Amar]

ovo zadnje ne mozes ni ubiti, ovo je samo grep proces. Dakle, mysql si totalno ukinuo. Pokreni ga sa startup skriptom

i onda pogledaj /var/log/messages i /var/log/syslog sa nekim editorom jer tail ti daje samo zadnjih par linija. Mozes uraditi i:

cat /var/log/messages |grep mysql > /tmp/messages cat /var/log/syslog |grep mysql > /tmp/syslog
pa onda pogledaj ta dva file-a. Posebno pogledaj kraj.

Par pitanja:

da li je mysql prije radio pa sada odjednom nece ili se nije nikako pokretao?
koji je distro u pitanju?
koja verzija mysql-a?

P.S. postavi i ovaj strace sto je @bzip predlozio.

[maher]

od kad *ubuntu ima chkconfig ? zar to nije kod rpm based distribucija ?

uradi slijedece:

[code]sudo su

kad dobijes root uradi slijedece:

/etc/init.d/mysql stop
/etc/init.d/mysql start
tail -f /var/log/daemon.log

i

tail -f /var/log/syslog[/code]
osim svega toga nebi trebo ubijat “mysqld-akonadi” jer ti to “akonadi” kde servis koristi i to je njegova baza , a ne “sistemska” …

[Amar]

Zar je ovo na ubuntuu? Ja sam bio uvjeren da je neka RedHat based distribucija.

[Bo]

service ?

[boby]

Polako, polako. U pitanju je kubuntu 10.10 i to sam napisao u prvom postu a chkconfig sam instalirao naknadno. Drugo, nije ni radilo od pocetka jer sam tek juce instaliriao sistem uradio sve nadogradje i to je to.

@_maher:

root@HP:/home/boby# tail -f /var/log/syslog
Jan 24 23:06:12 HP avahi-daemon[1059]: Registering new address record for 192.168.1.101 on eth1.IPv4.
Jan 24 23:06:13 HP NetworkManager[1054]: (eth1): device state change: 7 -> 8 (reason 0)
Jan 24 23:06:13 HP NetworkManager[1054]: Policy set ‘Podlaci’ (eth1) as default for IPv4 routing and DNS.
Jan 24 23:06:13 HP NetworkManager[1054]: Activation (eth1) successful, device activated.
Jan 24 23:06:13 HP NetworkManager[1054]: Activation (eth1) Stage 5 of 5 (IP Configure Commit) complete.
Jan 24 23:06:15 HP ntpdate[4178]: adjust time server 91.189.94.4 offset -0.340589 sec
Jan 24 23:09:01 HP CRON[4795]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm)
Jan 24 23:09:14 HP kernel: [ 9380.995335] warning: `VirtualBox’ uses 32-bit capabilities (legacy support in use)
Jan 24 23:09:32 HP kernel: [ 9399.081087] lo: Disabled Privacy Extensions
Jan 24 23:15:24 HP init: mysql pre-start process (6487) terminated with status 1

[boby]

[quote=bzip]ovo :

strace -o mysql.txt service mysql start

pa nam prikazi sta je u mysql.txt?

Poz[/quote]
root@HP:/home/boby# strace -o mysql.txt service mysql start
start: Job failed to start
root@HP:/home/boby# ^C
root@HP:/home/boby# ls
Desktop Documents Downloads Music mysql.txt Pictures Public Templates Videos
root@HP:/home/boby# cat mysql.txt
execve("/usr/sbin/service", [“service”, “mysql”, “start”], [/* 22 vars /]) = 0
brk(0) = 0x1c99000
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f234075c000
access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=111659, …}) = 0
mmap(NULL, 111659, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f2340740000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/lib/libc.so.6", O_RDONLY) = 3
read(3, “\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240\356\1\0\0\0\0\0”…, 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=1572232, …}) = 0
mmap(NULL, 3680296, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f23401bb000
mprotect(0x7f2340335000, 2093056, PROT_NONE) = 0
mmap(0x7f2340534000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x179000) = 0x7f2340534000
mmap(0x7f2340539000, 18472, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f2340539000
close(3) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f234073f000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f234073e000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f234073d000
arch_prctl(ARCH_SET_FS, 0x7f234073e700) = 0
mprotect(0x7f2340534000, 16384, PROT_READ) = 0
mprotect(0x618000, 4096, PROT_READ) = 0
mprotect(0x7f234075e000, 4096, PROT_READ) = 0
munmap(0x7f2340740000, 111659) = 0
getpid() = 6983
rt_sigaction(SIGCHLD, {SIG_DFL, [CHLD], SA_RESTORER|SA_RESTART, 0x7f23401eec20}, {SIG_DFL, [], 0}, 8) = 0
geteuid() = 0
brk(0) = 0x1c99000
brk(0x1cba000) = 0x1cba000
getppid() = 6982
stat("/home/boby", {st_mode=S_IFDIR|0755, st_size=4096, …}) = 0
stat(".", {st_mode=S_IFDIR|0755, st_size=4096, …}) = 0
open("/usr/sbin/service", O_RDONLY) = 3
fcntl(3, F_DUPFD, 10) = 10
close(3) = 0
fcntl(10, F_SETFD, FD_CLOEXEC) = 0
rt_sigaction(SIGINT, NULL, {SIG_DFL, [], 0}, 8) = 0
rt_sigaction(SIGINT, {0x40f790, ~[RTMIN RT_1], SA_RESTORER, 0x7f23401eec20}, NULL, 8) = 0
rt_sigaction(SIGQUIT, NULL, {SIG_DFL, [], 0}, 8) = 0
rt_sigaction(SIGQUIT, {SIG_DFL, ~[RTMIN RT_1], SA_RESTORER, 0x7f23401eec20}, NULL, 8) = 0
rt_sigaction(SIGTERM, NULL, {SIG_DFL, [], 0}, 8) = 0
rt_sigaction(SIGTERM, {SIG_DFL, ~[RTMIN RT_1], SA_RESTORER, 0x7f23401eec20}, NULL, 8) = 0
read(10, “#!/bin/sh\n\n#####################”…, 8192) = 4614
pipe([3, 4]) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0x7f234073e9d0) = 6984
close(4) = 0
read(3, “service\n”, 128) = 8
read(3, “”, 128) = 0
— SIGCHLD (Child exited) @ 0 (0) —
close(3) = 0
wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0, NULL) = 6984
pipe([3, 4]) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0x7f234073e9d0) = 6985
close(4) = 0
read(3, “service\n”, 128) = 8
read(3, “”, 128) = 0
— SIGCHLD (Child exited) @ 0 (0) —
close(3) = 0
wait4(-1, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0, NULL) = 6985
chdir("/") = 0
stat("/etc/init/mysql.conf", {st_mode=S_IFREG|0644, st_size=1043, …}) = 0
geteuid() = 0
execve("/usr/local/sbin/start", [“start”, “mysql”], [/ 23 vars /]) = -1 ENOENT (No such file or directory)
execve("/usr/local/bin/start", [“start”, “mysql”], [/ 23 vars /]) = -1 ENOENT (No such file or directory)
execve("/usr/sbin/start", [“start”, “mysql”], [/ 23 vars /]) = -1 ENOENT (No such file or directory)
execve("/usr/bin/start", [“start”, “mysql”], [/ 23 vars /]) = -1 ENOENT (No such file or directory)
execve("/sbin/start", [“start”, “mysql”], [/ 23 vars /]) = 0
brk(0) = 0x7ff145ada000
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7ff1456fd000
access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=111659, …}) = 0
mmap(NULL, 111659, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7ff1456e1000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/lib/libnih.so.1", O_RDONLY) = 3
read(3, “\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0PZ\0\0\0\0\0\0”…, 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=92144, …}) = 0
mmap(NULL, 2187640, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7ff1452c8000
mprotect(0x7ff1452dd000, 2097152, PROT_NONE) = 0
mmap(0x7ff1454dd000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x7ff1454dd000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/lib/libnih-dbus.so.1", O_RDONLY) = 3
read(3, “\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\200,\0\0\0\0\0\0”…, 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=34792, …}) = 0
mmap(NULL, 2129960, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7ff1450bf000
mprotect(0x7ff1450c7000, 2093056, PROT_NONE) = 0
mmap(0x7ff1452c6000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x7000) = 0x7ff1452c6000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/lib/libdbus-1.so.3", O_RDONLY) = 3
read(3, “\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\20g\0\0\0\0\0\0”…, 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=269104, …}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7ff1456e0000
mmap(NULL, 2365056, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7ff144e7d000
mprotect(0x7ff144ebd000, 2097152, PROT_NONE) = 0
mmap(0x7ff1450bd000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x40000) = 0x7ff1450bd000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/lib/libc.so.6", O_RDONLY) = 3
read(3, “\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240\356\1\0\0\0\0\0”…, 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=1572232, …}) = 0
mmap(NULL, 3680296, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7ff144afa000
mprotect(0x7ff144c74000, 2093056, PROT_NONE) = 0
mmap(0x7ff144e73000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x179000) = 0x7ff144e73000
mmap(0x7ff144e78000, 18472, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7ff144e78000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/lib/librt.so.1", O_RDONLY) = 3
read(3, “\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\220!\0\0\0\0\0\0”…, 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=31744, …}) = 0
mmap(NULL, 2128848, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7ff1448f2000
mprotect(0x7ff1448f9000, 2093056, PROT_NONE) = 0
mmap(0x7ff144af8000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x6000) = 0x7ff144af8000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/lib/libpthread.so.0", O_RDONLY) = 3
read(3, “\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240\\0\0\0\0\0\0”…, 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=136067, …}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7ff1456df000
mmap(NULL, 2212768, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7ff1446d5000
mprotect(0x7ff1446ed000, 2093056, PROT_NONE) = 0
mmap(0x7ff1448ec000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x17000) = 0x7ff1448ec000
mmap(0x7ff1448ee000, 13216, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7ff1448ee000
close(3) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7ff1456de000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7ff1456dd000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7ff1456dc000
arch_prctl(ARCH_SET_FS, 0x7ff1456dd700) = 0
mprotect(0x7ff1448ec000, 4096, PROT_READ) = 0
mprotect(0x7ff144af8000, 4096, PROT_READ) = 0
mprotect(0x7ff144e73000, 16384, PROT_READ) = 0
mprotect(0x7ff1450bd000, 4096, PROT_READ) = 0
mprotect(0x7ff1452c6000, 4096, PROT_READ) = 0
mprotect(0x7ff1454dd000, 4096, PROT_READ) = 0
mprotect(0x7ff14591c000, 4096, PROT_READ) = 0
mprotect(0x7ff1456ff000, 4096, PROT_READ) = 0
munmap(0x7ff1456e1000, 111659) = 0
set_tid_address(0x7ff1456dd9d0) = 6983
set_robust_list(0x7ff1456dd9e0, 0x18) = 0
futex(0x7fffbff12c1c, FUTEX_WAKE_PRIVATE, 1) = 0
futex(0x7fffbff12c1c, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 1, NULL, 7ff1456dd700) = -1 EAGAIN (Resource temporarily unavailable)
rt_sigaction(SIGRTMIN, {0x7ff1446dab20, [], SA_RESTORER|SA_SIGINFO, 0x7ff1446e4b40}, NULL, 8) = 0
rt_sigaction(SIGRT_1, {0x7ff1446dabb0, [], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x7ff1446e4b40}, NULL, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
getrlimit(RLIMIT_STACK, {rlim_cur=81921024, rlim_max=RLIM_INFINITY}) = 0
brk(0) = 0x7ff145ada000
brk(0x7ff145afb000) = 0x7ff145afb000
open("/usr/lib/locale/locale-archive", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=86326736, …}) = 0
mmap(NULL, 86326736, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7ff13f481000
close(3) = 0
open("/usr/share/locale/locale.alias", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=2570, …}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7ff1456fc000
read(3, “# Locale name alias data base.\n#”…, 4096) = 2570
read(3, “”, 4096) = 0
close(3) = 0
munmap(0x7ff1456fc000, 4096) = 0
open("/usr/share/locale/en_US.UTF-8/LC_MESSAGES/upstart.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/share/locale/en_US.utf8/LC_MESSAGES/upstart.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/share/locale/en_US/LC_MESSAGES/upstart.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/share/locale/en.UTF-8/LC_MESSAGES/upstart.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/share/locale/en.utf8/LC_MESSAGES/upstart.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/share/locale/en/LC_MESSAGES/upstart.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/share/locale-langpack/en_US.UTF-8/LC_MESSAGES/upstart.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/share/locale-langpack/en_US.utf8/LC_MESSAGES/upstart.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/share/locale-langpack/en_US/LC_MESSAGES/upstart.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/share/locale-langpack/en.UTF-8/LC_MESSAGES/upstart.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/share/locale-langpack/en.utf8/LC_MESSAGES/upstart.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/share/locale-langpack/en/LC_MESSAGES/upstart.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
getuid() = 0
socket(PF_FILE, SOCK_STREAM|SOCK_CLOEXEC, 0) = 3
connect(3, {sa_family=AF_FILE, path=@"/com/ubuntu/upstart"}, 22) = 0
fcntl(3, F_GETFL) = 0x2 (flags O_RDWR)
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
geteuid() = 0
getsockname(3, {sa_family=AF_FILE, NULL}, [2]) = 0
poll([{fd=3, events=POLLOUT}], 1, 0) = 1 ([{fd=3, revents=POLLOUT}])
write(3, “\0”, 1) = 1
sendto(3, “AUTH EXTERNAL 30\r\n”, 18, MSG_NOSIGNAL, NULL, 0) = 18
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
read(3, “OK 6e513354132597a33acbbae700000”…, 2048) = 37
poll([{fd=3, events=POLLOUT}], 1, -1) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, “NEGOTIATE_UNIX_FD\r\n”, 19, MSG_NOSIGNAL, NULL, 0) = 19
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
read(3, “AGREE_UNIX_FD\r\n”, 2048) = 15
poll([{fd=3, events=POLLOUT}], 1, -1) = 1 ([{fd=3, revents=POLLOUT}])
sendto(3, “BEGIN\r\n”, 7, MSG_NOSIGNAL, NULL, 0) = 7
poll([{fd=3, events=POLLIN|POLLOUT}], 1, -1) = 1 ([{fd=3, revents=POLLOUT}])
sendmsg(3, {msg_name(0)=NULL, msg_iov(2)=[{“l\1\2\1\n\0\0\0\1\0\0\0_\0\0\0\1\1o\0\23\0\0\0/com/ubu”…, 112}, {"\5\0\0\0mysql\0", 10}], msg_controllen=0, msg_flags=0}, MSG_NOSIGNAL) = 122
poll([{fd=3, events=POLLIN}], 1, 25000) = 1 ([{fd=3, revents=POLLIN}])
recvmsg(3, {msg_name(0)=NULL, msg_iov(1)=[{“l\2\1\1#\0\0\0\1\0\0\0\17\0\0\0\5\1u\0\1\0\0\0\10\1g\0\1o\0\0”…, 2048}], msg_controllen=0, msg_flags=MSG_CMSG_CLOEXEC}, MSG_CMSG_CLOEXEC) = 67
recvmsg(3, 0x7fffbff126b0, MSG_CMSG_CLOEXEC) = -1 EAGAIN (Resource temporarily unavailable)
sendmsg(3, {msg_name(0)=NULL, msg_iov(2)=[{“l\1\2\1\10\0\0\0\2\0\0\0i\0\0\0\1\1o\0\36\0\0\0/com/ubu”…, 128}, {"\0\0\0\0\1\0\0\0", 8}], msg_controllen=0, msg_flags=0}, MSG_NOSIGNAL) = 136
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
recvmsg(3, {msg_name(0)=NULL, msg_iov(1)=[{“l\4\1\1%\0\0\0\2\0\0\0o\0\0\0\1\1o\0\36\0\0\0/com/ubu”…, 2048}], msg_controllen=0, msg_flags=MSG_CMSG_CLOEXEC}, MSG_CMSG_CLOEXEC) = 165
recvmsg(3, 0x7fffbff127c0, MSG_CMSG_CLOEXEC) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=3, events=POLLIN}], 1, -277575526) = 1 ([{fd=3, revents=POLLIN}])
recvmsg(3, {msg_name(0)=NULL, msg_iov(1)=[{“l\3\1\1\30\0\0\0\3\0\0\0?\0\0\0\4\1s\0%\0\0\0com.ubun”…, 2048}], msg_controllen=0, msg_flags=MSG_CMSG_CLOEXEC}, MSG_CMSG_CLOEXEC) = 269
recvmsg(3, 0x7fffbff127c0, MSG_CMSG_CLOEXEC) = -1 EAGAIN (Resource temporarily unavailable)
write(2, “start: Job failed to start\n”, 27) = 27
close(3) = 0
exit_group(1) = ?
root@HP:/home/boby# strace -o mysql.txt service mysql start
start: Job failed to start
root@HP:/home/boby# start: Job failed to start
No command ‘start:’ found, did you mean:
Command ‘startx’ from package ‘xinit’ (main)
Command ‘start’ from package ‘upstart’ (main)
start:: command not found

[maher]

de pogledaj daemon i debug logove u /var/log … evo ti lijepo pise sta se desilo:

Jan 24 23:15:24 HP init: mysql pre-start process (6487) terminated with status 1

ja i uninstalliraj chkconfig i prestani koristit service … koristi /etc/init.d/mysql start/stop/restart …

[boby]

[quote=Amar]ovo zadnje ne mozes ni ubiti, ovo je samo grep proces. Dakle, mysql si totalno ukinuo. Pokreni ga sa startup skriptom

i onda pogledaj /var/log/messages i /var/log/syslog sa nekim editorom jer tail ti daje samo zadnjih par linija. Mozes uraditi i:

cat /var/log/messages |grep mysql > /tmp/messages cat /var/log/syslog |grep mysql > /tmp/syslog
pa onda pogledaj ta dva file-a. Posebno pogledaj kraj.

Par pitanja:

da li je mysql prije radio pa sada odjednom nece ili se nije nikako pokretao?
koji je distro u pitanju?
koja verzija mysql-a?

P.S. postavi i ovaj strace sto je @bzip predlozio.[/quote]
Jan 24 20:08:27 HP init: mysql pre-start process (1138) terminated with status 1
Jan 24 20:09:57 HP init: mysql pre-start process (2268) terminated with status 1
Jan 24 20:10:07 HP init: mysql pre-start process (2311) terminated with status 1
Jan 24 20:13:09 HP init: mysql pre-start process (3038) terminated with status 1
Jan 24 20:13:47 HP init: mysql pre-start process (3177) terminated with status 1
Jan 24 20:24:28 HP init: mysql pre-start process (5803) terminated with status 1
Jan 24 20:24:33 HP init: mysql pre-start process (5828) terminated with status 1
Jan 24 20:24:45 HP init: mysql pre-start process (5879) terminated with status 1
Jan 24 20:27:13 HP init: mysql pre-start process (6513) terminated with status 1
Jan 24 20:28:22 HP init: mysql pre-start process (6780) terminated with status 1
Jan 24 20:31:41 HP init: mysql pre-start process (7588) terminated with status 1
Jan 24 20:33:09 HP init: mysql pre-start process (1148) terminated with status 1
Jan 24 20:37:26 HP init: mysql pre-start process (2369) terminated with status 1
Jan 24 20:49:19 HP init: mysql pre-start process (5286) terminated with status 1
Jan 24 23:15:24 HP init: mysql pre-start process (6487) terminated with status 1
Jan 24 23:17:24 HP init: mysql pre-start process (6986) terminated with status 1
Jan 24 23:17:59 HP init: mysql pre-start process (7119) terminated with status 1
Jan 24 23:19:57 HP init: mysql pre-start process (7553) terminated with status 1

ovo je za syslog a ovo ispid je za messages:

Jan 24 20:08:27 HP init: mysql pre-start process (1138) terminated with status 1
Jan 24 20:09:57 HP init: mysql pre-start process (2268) terminated with status 1
Jan 24 20:10:07 HP init: mysql pre-start process (2311) terminated with status 1
Jan 24 20:13:09 HP init: mysql pre-start process (3038) terminated with status 1
Jan 24 20:13:47 HP init: mysql pre-start process (3177) terminated with status 1
Jan 24 20:24:28 HP init: mysql pre-start process (5803) terminated with status 1
Jan 24 20:24:33 HP init: mysql pre-start process (5828) terminated with status 1
Jan 24 20:24:45 HP init: mysql pre-start process (5879) terminated with status 1
Jan 24 20:27:13 HP init: mysql pre-start process (6513) terminated with status 1
Jan 24 20:28:22 HP init: mysql pre-start process (6780) terminated with status 1
Jan 24 20:31:41 HP init: mysql pre-start process (7588) terminated with status 1
Jan 24 20:33:09 HP init: mysql pre-start process (1148) terminated with status 1
Jan 24 20:37:26 HP init: mysql pre-start process (2369) terminated with status 1
Jan 24 20:49:19 HP init: mysql pre-start process (5286) terminated with status 1
Jan 24 23:15:24 HP init: mysql pre-start process (6487) terminated with status 1
Jan 24 23:17:24 HP init: mysql pre-start process (6986) terminated with status 1
Jan 24 23:17:59 HP init: mysql pre-start process (7119) terminated with status 1
Jan 24 23:19:57 HP init: mysql pre-start process (7553) terminated with status 1

[boby]

[quote=maher_]de pogledaj daemon i debug logove u /var/log … evo ti lijepo pise sta se desilo:

Jan 24 23:15:24 HP init: mysql pre-start process (6487) terminated with status 1

ja i uninstalliraj chkconfig i prestani koristit service … koristi /etc/init.d/mysql start/stop/restart …[/quote]
Service i koristim jer start/stop/restart i nalaze da to koristim:

root@HP:/tmp# sudo /etc/init.d/mysql stop
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql stop

[boby]

u debug-u ima samo ovo vezano za mysql:
Jan 24 09:18:53 HP /etc/mysql/debian-start[1284]: Upgrading MySQL tables if necessary.

A u daemon-u:

Jan 24 23:15:24 HP init: mysql pre-start process (6487) terminated with status 1
Jan 24 23:17:24 HP init: mysql pre-start process (6986) terminated with status 1
Jan 24 23:17:59 HP init: mysql pre-start process (7119) terminated with status 1
Jan 24 23:19:57 HP init: mysql pre-start process (7553) terminated with status 1
Jan 24 23:24:01 HP init: mysql pre-start process (8454) terminated with status 1
Jan 24 23:24:12 HP init: mysql pre-start process (8500) terminated with status 1

I dalje ne kontam sta trebam uraditi

[Amar]

probaj ukinuti mysql i ponovo instalirati. I ne kontam zasto ne mozes jednostavno startati sa init.d skriptom.

[boby]

A kako da ga uklonim potpuno tj. da ne ostane nista, ni conf fajlovi pa da ga ponovo instaliram? I da li da instaliram mysql-server ili mysql-server-5.1 posto imam dvije verzije u repo-u

[Amar]

Uh, ako ti nije hitno imam negdje link ali mi je na poslu, mogu ti sutra pogledati, znam da treba ukinuti par paketa, a neki od njih nikada ne bi doveo u vezu sa mysql-om.

I mozes instalirati 5.1, ako ga vec imas u repo.

Ako ti je frka probaj:

moguce da pobrise sve.

Ako ne, javim ti se sutra.

[boby]

ok - sutra