Nie jesteś zalogowany.
Jeśli nie posiadasz konta, zarejestruj je już teraz! Pozwoli Ci ono w pełni korzystać z naszego serwisu. Spamerom dziękujemy!
Ogłoszenie
Prosimy o pomoc dla małej Julki — przekaż 1% podatku na Fundacji Dzieciom zdazyć z Pomocą.
Więcej informacji na dug.net.pl/pomagamy/.
Strony: 1
- Forum Debian Users Gang
- » Instalacja i podstawowa konfiguracja
- » Błąd przetwarzania pakietu mysql-server
#1 2017-05-03 16:47:13
mike26 - 
Użytkownik
- mike26
- Użytkownik
- Skąd: ~/
- Zarejestrowany: 2013-10-16
Błąd przetwarzania pakietu mysql-server
Przy próbie aktualizacji lub instalacji jakiegokolwiek programu pojawia mi się błąd dotyczący mysql-server.
Problem może być spowodowany tym że kiedyś chciałem zaktualizować cups do wersji 2.2, niby się zainstalowała ale w liście programów widoczna jest wersja 1.75.
Kod:
The following partially installed packages will be configured: mysql-server mysql-server-5.5 No packages will be installed, upgraded, or removed. 0 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Need to get 0 B of archives. After unpacking 0 B will be used. Setting up mysql-server-5.5 (5.5.55-0+deb8u1) ... insserv: warning: script 'K01minidlna' missing LSB tags and overrides insserv: warning: script 'K36cups' missing LSB tags and overrides insserv: warning: script 'cups' missing LSB tags and overrides insserv: warning: script 'minidlna' missing LSB tags and overrides insserv: There is a loop between service smbd and mountnfs if started insserv: loop involving service mountnfs at depth 4 insserv: loop involving service networking at depth 3 insserv: There is a loop between service cups and udev if started insserv: loop involving service udev at depth 1 insserv: There is a loop between service smbd and mountnfs if started insserv: There is a loop between service cups and mountall if started insserv: loop involving service mountall at depth 4 insserv: loop involving service checkfs at depth 3 insserv: There is a loop between service cups and mountall-bootclean if started insserv: loop involving service mountall-bootclean at depth 5 insserv: loop involving service urandom at depth 7 insserv: loop involving service kbd at depth 6 insserv: There is a loop between service cups and mountall if started insserv: loop involving service mountnfs-bootclean at depth 6 insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: loop involving service cups at depth 5 insserv: loop involving service smbd at depth 4 insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: There is a loop at service rmnologin if started insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: There is a loop between service smbd and mountdevsubfs if started insserv: loop involving service mountdevsubfs at depth 1 insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: loop involving service hdparm at depth 3 insserv: loop involving service mountkernfs at depth 1 insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Max recursions depth 99 reached insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: exiting now without changing boot order! update-rc.d: error: insserv rejected the script header dpkg: error processing package mysql-server-5.5 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.5; however: Package mysql-server-5.5 is not configured yet. dpkg: error processing package mysql-server (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mysql-server-5.5 mysql-server E: Sub-process /usr/bin/dpkg returned an error code (1) Failed to perform requested operation on package. Trying to recover: Setting up mysql-server-5.5 (5.5.55-0+deb8u1) ... insserv: warning: script 'K01minidlna' missing LSB tags and overrides insserv: warning: script 'K36cups' missing LSB tags and overrides insserv: warning: script 'cups' missing LSB tags and overrides insserv: warning: script 'minidlna' missing LSB tags and overrides insserv: There is a loop between service smbd and mountnfs if started insserv: loop involving service mountnfs at depth 4 insserv: loop involving service networking at depth 3 insserv: There is a loop between service cups and udev if started insserv: loop involving service udev at depth 1 insserv: There is a loop between service smbd and mountnfs if started insserv: There is a loop between service cups and mountall if started insserv: loop involving service mountall at depth 4 insserv: loop involving service checkfs at depth 3 insserv: There is a loop between service cups and mountall-bootclean if started insserv: loop involving service mountall-bootclean at depth 5 insserv: loop involving service urandom at depth 7 insserv: loop involving service kbd at depth 6 insserv: There is a loop between service cups and mountall if started insserv: loop involving service mountnfs-bootclean at depth 6 insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: loop involving service cups at depth 5 insserv: loop involving service smbd at depth 4 insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: There is a loop at service rmnologin if started insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: There is a loop between service smbd and mountdevsubfs if started insserv: loop involving service mountdevsubfs at depth 1 insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: loop involving service hdparm at depth 3 insserv: loop involving service mountkernfs at depth 1 insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Max recursions depth 99 reached insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true! insserv: exiting now without changing boot order! update-rc.d: error: insserv rejected the script header dpkg: error processing package mysql-server-5.5 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.5; however: Package mysql-server-5.5 is not configured yet. dpkg: error processing package mysql-server (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mysql-server-5.5 mysql-server
Próbowałem dpkg --configure -a; reinstalacja cups, mysql, mysql-server,
polecenie aptitude keep-all
Nie mam pojęcia jak to naprawić.
Kod:
uname -a Linux OpiPC 3.4.113-sun8i #10 SMP PREEMPT Thu Feb 23 19:55:00 CET 2017 armv7l GNU/Linux
Kod:
lsb_release -a No LSB modules are available. Distributor ID: Debian Description: Debian GNU/Linux 8.7 (jessie) Release: 8.7 Codename: jessie
Offline
#2 2017-05-03 16:57:28
yossarian - Szczawiożerca
- yossarian
- Szczawiożerca
- Skąd: Shangri-La
- Zarejestrowany: 2011-04-25
Re: Błąd przetwarzania pakietu mysql-server
To nie ma nic wspólnego z mysql-server.
Komunikaty o tym jasno mówią.
Poczytaj o nagłówkach skryptów startowch. Albo je od razu przepisz na usługi systemd.
Offline
#3 2017-05-04 03:02:24
Jacekalex - Podobno człowiek...;)
- Jacekalex
- Podobno człowiek...;)
- Skąd: /dev/urandom
- Zarejestrowany: 2008-01-07
Re: Błąd przetwarzania pakietu mysql-server
Mysql-5 już dawno ustąpił miejsca serwerowi Mariadb, stał się w ten sposób malutkim anachronizmem, pewnie dlatego ma nieaktualne skrypty instalacyjne w paczce.
Powinieneś zainstalować to:
Kod:
mariadb-server:
...
10.0.30-0+deb8u1 500
500 http://security.debian.org stable/updates/main amd64 Packages
500 http://security.debian.org stable/updates/main i386 PackagesPozdro
Ostatnio edytowany przez Jacekalex (2017-05-04 03:04:01)
W demokracji każdy naród ma taką władzę, na jaką zasługuje ;)
Si vis pacem para bellum ;) | Pozdrawiam :)
Offline
#4 2017-05-06 12:21:42
mike26 - Użytkownik
- mike26
- Użytkownik
- Skąd: ~/
- Zarejestrowany: 2013-10-16
Re: Błąd przetwarzania pakietu mysql-server
Mówiąc o nagłówkach startowych chodzi ci o to?
Kod:
# Provides: mysql # Required-Start: $remote_fs $syslog # Required-Stop: $remote_fs $syslog # Should-Start: $network $time # Should-Stop: $network $time # Default-Start: 2 3 4 5 # Default-Stop: 0 1 6 # Short-Description: Start and stop the mysql database server daemon # Description: Controls the main MySQL database server daemon "mysqld" # and its wrapper script "mysqld_safe".
Kod:
systemctl start mysql.service Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.
Kod:
systemctl status mysql.service ● mysql.service - LSB: Start and stop the mysql database server daemon Loaded: loaded (/etc/init.d/mysql) Active: failed (Result: exit-code) since Sat 2017-05-06 12:10:39 CEST; 15s ago Process: 3693 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE) May 06 12:10:39 OpiPC mysql[3693]: Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed! May 06 12:10:39 OpiPC systemd[1]: mysql.service: control process exited, code=exited status=1 May 06 12:10:39 OpiPC systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon. May 06 12:10:39 OpiPC systemd[1]: Unit mysql.service entered failed state.
Kod:
journalctl -xn -- Logs begin at Sat 2017-05-06 12:02:30 CEST, end at Sat 2017-05-06 12:14:24 CEST. -- May 06 12:13:50 OpiPC systemd[1]: Starting LSB: Start and stop the mysql database server daemon... -- Subject: Unit mysql.service has begun with start-up -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysql.service has begun starting up. May 06 12:14:24 OpiPC /etc/init.d/mysql[5579]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in May 06 12:14:24 OpiPC /etc/init.d/mysql[5579]: [61B blob data] May 06 12:14:24 OpiPC /etc/init.d/mysql[5579]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' May 06 12:14:24 OpiPC /etc/init.d/mysql[5579]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! May 06 12:14:24 OpiPC /etc/init.d/mysql[5579]: May 06 12:14:24 OpiPC mysql[4841]: Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed! May 06 12:14:24 OpiPC systemd[1]: mysql.service: control process exited, code=exited status=1 May 06 12:14:24 OpiPC systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon. -- Subject: Unit mysql.service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysql.service has failed. -- -- The result is failed. May 06 12:14:24 OpiPC systemd[1]: Unit mysql.service entered failed state.
Kod:
cat /etc/init.d/mysql
#!/bin/bash
#
### BEGIN INIT INFO
# Provides: mysql
# Required-Start: $remote_fs $syslog
# Required-Stop: $remote_fs $syslog
# Should-Start: $network $time
# Should-Stop: $network $time
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: Start and stop the mysql database server daemon
# Description: Controls the main MySQL database server daemon "mysqld"
# and its wrapper script "mysqld_safe".
### END INIT INFO
#
set -e
set -u
${DEBIAN_SCRIPT_DEBUG:+ set -v -x}
test -x /usr/bin/mysqld_safe || exit 0
. /lib/lsb/init-functions
SELF=$(cd $(dirname $0); pwd -P)/$(basename $0)
CONF=/etc/mysql/my.cnf
MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"
# priority can be overriden and "-s" adds output to stderr
ERR_LOGGER="logger -p daemon.err -t /etc/init.d/mysql -i"
# Safeguard (relative paths, core dumps..)
cd /
umask 077
# mysqladmin likes to read /root/.my.cnf. This is usually not what I want
# as many admins e.g. only store a password without a username there and
# so break my scripts.
export HOME=/etc/mysql/
## Fetch a particular option from mysql's invocation.
#
# Usage: void mysqld_get_param option
mysqld_get_param() {
/usr/sbin/mysqld --print-defaults \
| tr " " "\n" \
| grep -- "--$1" \
| tail -n 1 \
| cut -d= -f2
}
## Do some sanity checks before even trying to start mysqld.
sanity_checks() {
# check for config file
if [ ! -r /etc/mysql/my.cnf ]; then
log_warning_msg "$0: WARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz"
echo "WARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz" | $ERR_LOGGER
fi
# check for diskspace shortage
datadir=`mysqld_get_param datadir`
if LC_ALL=C BLOCKSIZE= df --portability $datadir/. | tail -n 1 | awk '{ exit ($4>4096) }'; then
log_failure_msg "$0: ERROR: The partition with $datadir is too full!"
echo "ERROR: The partition with $datadir is too full!" | $ERR_LOGGER
exit 1
fi
}
## Checks if there is a server running and if so if it is accessible.
#
# check_alive insists on a pingable server
# check_dead also fails if there is a lost mysqld in the process list
#
# Usage: boolean mysqld_status [check_alive|check_dead] [warn|nowarn]
mysqld_status () {
ping_output=`$MYADMIN ping 2>&1`; ping_alive=$(( ! $? ))
ps_alive=0
pidfile=`mysqld_get_param pid-file`
if [ -f "$pidfile" ] && ps `cat $pidfile` >/dev/null 2>&1; then ps_alive=1; fi
if [ "$1" = "check_alive" -a $ping_alive = 1 ] ||
[ "$1" = "check_dead" -a $ping_alive = 0 -a $ps_alive = 0 ]; then
return 0 # EXIT_SUCCESS
else
if [ "$2" = "warn" ]; then
echo -e "$ps_alive processes alive and '$MYADMIN ping' resulted in\n$ping_output\n" | $ERR_LOGGER -p daemon.debug
fi
return 1 # EXIT_FAILURE
fi
}
#
# main()
#
case "${1:-''}" in
'start')
sanity_checks;
# Start daemon
log_daemon_msg "Starting MySQL database server" "mysqld"
if mysqld_status check_alive nowarn; then
log_progress_msg "already running"
log_end_msg 0
else
# Could be removed during boot
test -e /var/run/mysqld || install -m 755 -o mysql -g root -d /var/run/mysqld
# Start MySQL!
/usr/bin/mysqld_safe > /dev/null 2>&1 &
# 6s was reported in #352070 to be too few when using ndbcluster
# 14s was reported in #736452 to be too few with large installs
for i in $(seq 1 30); do
sleep 1
if mysqld_status check_alive nowarn ; then break; fi
log_progress_msg "."
done
if mysqld_status check_alive warn; then
log_end_msg 0
# Now start mysqlcheck or whatever the admin wants.
output=$(/etc/mysql/debian-start)
[ -n "$output" ] && log_action_msg "$output"
else
log_end_msg 1
log_failure_msg "Please take a look at the syslog"
fi
fi
;;
'stop')
# * As a passwordless mysqladmin (e.g. via ~/.my.cnf) must be possible
# at least for cron, we can rely on it here, too. (although we have
# to specify it explicit as e.g. sudo environments points to the normal
# users home and not /root)
log_daemon_msg "Stopping MySQL database server" "mysqld"
if ! mysqld_status check_dead nowarn; then
set +e
shutdown_out=`$MYADMIN shutdown 2>&1`; r=$?
set -e
if [ "$r" -ne 0 ]; then
log_end_msg 1
[ "$VERBOSE" != "no" ] && log_failure_msg "Error: $shutdown_out"
log_daemon_msg "Killing MySQL database server by signal" "mysqld"
killall -15 mysqld
server_down=
for i in 1 2 3 4 5 6 7 8 9 10; do
sleep 1
if mysqld_status check_dead nowarn; then server_down=1; break; fi
done
if test -z "$server_down"; then killall -9 mysqld; fi
fi
fi
if ! mysqld_status check_dead warn; then
log_end_msg 1
log_failure_msg "Please stop MySQL manually and read /usr/share/doc/mysql-server-5.5/README.Debian.gz!"
exit -1
else
log_end_msg 0
fi
;;
'restart')
set +e; $SELF stop; set -e
$SELF start
;;
'reload'|'force-reload')
log_daemon_msg "Reloading MySQL database server" "mysqld"
$MYADMIN reload
log_end_msg 0
;;
'status')
if mysqld_status check_alive nowarn; then
log_action_msg "$($MYADMIN version)"
else
log_action_msg "MySQL is stopped."
exit 3
fi
;;
*)
echo "Usage: $SELF start|stop|restart|reload|force-reload|status"
exit 1
;;
esacKod:
aptitude -f install The following partially installed packages will be configured: mysql-server mysql-server-5.5 No packages will be installed, upgraded, or removed. 0 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Need to get 0 B of archives. After unpacking 0 B will be used. Setting up mysql-server-5.5 (5.5.55-0+deb8u1) ... Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details. invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing package mysql-server-5.5 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.5; however: Package mysql-server-5.5 is not configured yet. dpkg: error processing package mysql-server (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mysql-server-5.5 mysql-server E: Sub-process /usr/bin/dpkg returned an error code (1) Failed to perform requested operation on package. Trying to recover: Setting up mysql-server-5.5 (5.5.55-0+deb8u1) ... Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details. invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing package mysql-server-5.5 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.5; however: Package mysql-server-5.5 is not configured yet. dpkg: error processing package mysql-server (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mysql-server-5.5 mysql-server
[b]@Jacekalex[/b]
W tej chwili ani zainstalować ani odinstalować. Jak wszystko będzie działało można pomyśleć nad mariadb.
Offline
#5 2017-05-06 13:49:26
Jacekalex - Podobno człowiek...;)
- Jacekalex
- Podobno człowiek...;)
- Skąd: /dev/urandom
- Zarejestrowany: 2008-01-07
Re: Błąd przetwarzania pakietu mysql-server
Jak wszystko będzie działało?
Wywal w tej chwili Mysql-server i w jego miejsce zainstaluj Mariadb-server, to praktycznie taki sam serwer, poza tym, że Mariadb ma dużo lepsze wsparcie po tym, jak Orable przejęło Sun Microsystems i zaczęło majstrować przy projekcie Mysql.
Z tego samego powodu Libreoffice wyparł Openoffce.
MariaDB w akcji:
Kod:
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 17 Server version: 10.0.30-MariaDB Source distribution Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> \s; -------------- mysql Ver 15.1 Distrib 10.0.30-MariaDB, for Linux (x86_64) using readline 6.3 Connection id: 17 Current database: Current user: root@localhost SSL: Cipher in use is DHE-RSA-AES256-SHA Current pager: /usr/bin/less Using outfile: '' Using delimiter: ; Server: MariaDB Server version: 10.0.30-MariaDB Source distribution Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 2 hours 36 min 24 sec Threads: 11 Questions: 24 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 64 Queries per second avg: 0.002 Note that you are running in safe_update_mode: UPDATEs and DELETEs that don't use a key in the WHERE clause are not allowed. (One can force an UPDATE/DELETE by adding LIMIT # at the end of the command.) SELECT has an automatic 'LIMIT 1000' if LIMIT is not used. Max number of examined row combination in a join is set to: 1000000
Ostatnio edytowany przez Jacekalex (2017-05-06 13:51:19)
W demokracji każdy naród ma taką władzę, na jaką zasługuje ;)
Si vis pacem para bellum ;) | Pozdrawiam :)
Offline
Strony: 1
- Forum Debian Users Gang
- » Instalacja i podstawowa konfiguracja
- » Błąd przetwarzania pakietu mysql-server
Informacje debugowania
| Time (s) | Query |
|---|---|
| 0.00011 | SET CHARSET latin2 |
| 0.00003 | SET NAMES latin2 |
| 0.00068 | SELECT u.*, g.*, o.logged FROM punbb_users AS u INNER JOIN punbb_groups AS g ON u.group_id=g.g_id LEFT JOIN punbb_online AS o ON o.ident='18.117.94.77' WHERE u.id=1 |
| 0.00150 | UPDATE punbb_online SET logged=1733365348 WHERE ident='18.117.94.77' |
| 0.00028 | SELECT * FROM punbb_online WHERE logged<1733365048 |
| 0.00093 | DELETE FROM punbb_online WHERE ident='3.16.76.102' |
| 0.00047 | SELECT topic_id FROM punbb_posts WHERE id=310588 |
| 0.00107 | SELECT id FROM punbb_posts WHERE topic_id=29551 ORDER BY posted |
| 0.00080 | SELECT t.subject, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, 0 FROM punbb_topics AS t INNER JOIN punbb_forums AS f ON f.id=t.forum_id LEFT JOIN punbb_forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=3) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id=29551 AND t.moved_to IS NULL |
| 0.00010 | SELECT search_for, replace_with FROM punbb_censoring |
| 0.00180 | SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM punbb_posts AS p INNER JOIN punbb_users AS u ON u.id=p.poster_id INNER JOIN punbb_groups AS g ON g.g_id=u.group_id LEFT JOIN punbb_online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.topic_id=29551 ORDER BY p.id LIMIT 0,25 |
| 0.00089 | UPDATE punbb_topics SET num_views=num_views+1 WHERE id=29551 |
| Total query time: 0.00866 s | |