Forum Debian Users Gang

maciejka89 · 2017-10-21 16:01:18

Witam wszystkich odwiedzających ten post,
pod nie obecność administratora serwerów dziś nie może uruchomić się na Debian Server usługa mysql.
W tym momencie przy próbie uruchomienia serwera otrzymuję taki komunikat:

Kod:

Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details

Po wpisaniu komendy systemctl status mysql.service, otrzymuję komunikat:

Kod:

mysql.service - LSB: Start and stop the mysql database server daemon
Active: failed (Result: exit-code) since Sat 2017-10-21 15:40:53 CEST; 10min ago
Process: 12649 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

mysql[12649]: Starting MySQL database server: mysqld . . . ....ed!
mysql.service: control process exited, code=exit...s=1
Failed to start LSB: Start and stop the mysql da...on
Unit mysql.service entered failed stat

Natomiast w /var/log/mysql/error.log - mam następujący błąd teraz:

Kod:

171021 15:40:23 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
171021 15:40:23 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
171021 15:40:23 [Note] Plugin 'FEDERATED' is disabled.
171021 15:40:23 InnoDB: The InnoDB memory heap is disabled
171021 15:40:23 InnoDB: Mutexes and rw_locks use GCC atomic builtins
171021 15:40:23 InnoDB: Compressed tables use zlib 1.2.8
171021 15:40:23 InnoDB: Using Linux native AIO
171021 15:40:23 InnoDB: Initializing buffer pool, size = 7.0G
171021 15:40:23 InnoDB: Completed initialization of buffer pool
171021 15:40:23 InnoDB: highest supported file format is Barracuda.
InnoDB: No valid checkpoint found.
InnoDB: If you are attempting downgrade from MySQL 5.7.9 or later,
InnoDB: please refer to http://dev.mysql.com/doc/refman/5.5/en/upgrading-downgrading.html
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/error-creating-innodb.html
171021 15:40:23 [ERROR] Plugin 'InnoDB' init function returned error.
171021 15:40:23 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
171021 15:40:23 [ERROR] Unknown/unsupported storage engine: InnoDB
171021 15:40:23 [ERROR] Aborting

171021 15:40:23 [Note] /usr/sbin/mysqld: Shutdown complete

Jeśli przez przeglądarkę chcę zalogować się do aplikacji to pojawia się komunikat:

Kod:

SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Czy ktoś może pomóc ? Z góry bardzo dziękuje.

Jacekalex · 2017-10-21 16:15:28

Kod:
InnoDB: please refer to http://dev.mysql.com/doc/refman/5.5/en/upgrading-downgrading.html
[/quote]
W demokracji każdy naród ma taką władzę, na jaką zasługuje ;)
Si vis pacem para bellum ;) | Pozdrawiam :)

Time (s)	Query
0.00014	SET CHARSET latin2
0.00004	SET NAMES latin2
0.00124	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='3.144.38.184' WHERE u.id=1
0.00085	REPLACE INTO punbb_online (user_id, ident, logged) VALUES(1, '3.144.38.184', 1732701950)
0.00058	SELECT * FROM punbb_online WHERE logged<1732701650
0.00104	DELETE FROM punbb_online WHERE ident='18.222.98.29'
0.00081	SELECT topic_id FROM punbb_posts WHERE id=314924
0.00088	SELECT id FROM punbb_posts WHERE topic_id=29992 ORDER BY posted
0.00061	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=29992 AND t.moved_to IS NULL
0.00006	SELECT search_for, replace_with FROM punbb_censoring
0.00085	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=29992 ORDER BY p.id LIMIT 0,25
0.00082	UPDATE punbb_topics SET num_views=num_views+1 WHERE id=29992
Total query time: 0.00792 s

Forum Debian Users Gang

Ogłoszenie

#1 2017-10-21 16:01:18

maciejka89 - Użytkownik

Nie mogę uruchomić usługi mysql - Debian Server

Kod:

Kod:

Kod:

Kod:

#2 2017-10-21 16:15:28

Jacekalex - Podobno człowiek...;)

Re: Nie mogę uruchomić usługi mysql - Debian Server

Kod:

#3 2017-10-21 16:25:45

maciejka89 - Użytkownik

Re: Nie mogę uruchomić usługi mysql - Debian Server

#4 2017-10-21 16:37:02

Jacekalex - Podobno człowiek...;)

Re: Nie mogę uruchomić usługi mysql - Debian Server

#5 2017-10-21 16:39:31

maciejka89 - Użytkownik

Re: Nie mogę uruchomić usługi mysql - Debian Server

#6 2017-10-21 16:42:44

Jacekalex - Podobno człowiek...;)

Re: Nie mogę uruchomić usługi mysql - Debian Server

#7 2017-10-21 16:44:36

maciejka89 - Użytkownik

Re: Nie mogę uruchomić usługi mysql - Debian Server

#8 2017-10-21 16:52:25

Jacekalex - Podobno człowiek...;)

Re: Nie mogę uruchomić usługi mysql - Debian Server

Stopka forum

Informacje debugowania