{Solved} MySQL ERROR

[LaunchHost]

HI,

I have a problem. My vestaCP server gives this problem:


root@websrv:~# systemctl status mysql.service -l
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql)
Active: failed (Result: exit-code) since Wed 2016-06-15 20:37:06 EDT; 4min 26s ago
Process: 7791 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

Jun 15 20:37:06 websrv.launchhost.net mysql[7791]: Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed!
Jun 15 20:37:06 websrv.launchhost.net systemd[1]: mysql.service: control process exited, code=exited status=1
Jun 15 20:37:06 websrv.launchhost.net systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Jun 15 20:37:06 websrv.launchhost.net systemd[1]: Unit mysql.service entered failed state.

Can help everbody my please?

The mysql server don't want start after a backup image form the disk image imported on the server. The web server works fine the websites are online but the mysql server don't work only. Anthor things works fine!

[joem]

HI,

I have a problem. My vestaCP server gives this problem:


root@websrv:~# systemctl status mysql.service -l
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql)
Active: failed (Result: exit-code) since Wed 2016-06-15 20:37:06 EDT; 4min 26s ago
Process: 7791 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

Jun 15 20:37:06 websrv.launchhost.net mysql[7791]: Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed!
Jun 15 20:37:06 websrv.launchhost.net systemd[1]: mysql.service: control process exited, code=exited status=1
Jun 15 20:37:06 websrv.launchhost.net systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Jun 15 20:37:06 websrv.launchhost.net systemd[1]: Unit mysql.service entered failed state.

Can help everbody my please?

The mysql server don't want start after a backup image form the disk image imported on the server. The web server works fine the websites are online but the mysql server don't work only. Anthor things works fine!

you can try,

Code: Select all

chown mysql:mysql /var/lib/mysql

Then reboot mysql

[skurudo]

Some errors in mysql error log?
https://vestacp.com/docs/#config-log-lo ... ian-ubuntu

[LaunchHost]

Hi,

the command don't work.

But the error log:
160617 14:45:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160616 14:45:02 [Note] /usr/sbin/mysqld (mysqld 5.5.49-0+deb8u1) starting as process 30774 ...
160616 14:45:02 [Note] Plugin 'FEDERATED' is disabled.
160616 14:45:02 InnoDB: The InnoDB memory heap is disabled
160616 14:45:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160616 14:45:02 InnoDB: Compressed tables use zlib 1.2.8
160616 14:45:02 InnoDB: Using Linux native AIO
160616 14:45:02 InnoDB: Initializing buffer pool, size = 128.0M
160616 14:45:02 InnoDB: Completed initialization of buffer pool
160616 14:45:02 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
160616 14:45:02 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Warning: a page in the doublewrite buffer is not within space
InnoDB: bounds; space id 100 page number 13, page 48 in doublewrite buf.
160616 14:45:03 InnoDB: Error: page 7 log sequence number 49134153
InnoDB: is in the future! Current system log sequence number 1595916.
"/var/log/mysql/error.log" 2086 lines, 128260 characters

[LaunchHost]

And this error:


160616 14:45:04 InnoDB: Error: page 366 log sequence number 115166166
InnoDB: is in the future! Current system log sequence number 1595916.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/ ... overy.html
InnoDB: for more information.

[LaunchHost]

Can help any body my?

[LaunchHost]

Can any body help my please?

[joem]

Can any body help my please?

How much ram do you have? The best guide I found on how to fix your issue is http://blackbird.si/mysql-corrupted-inn ... tep-guide/

[LaunchHost]

Hi,

I have started the mysql but. VestaCP can't connect with the localhost.

this problem: http://prntscr.com/bhgv5r
And roundcube are done: http://prntscr.com/bhgvgz

[LaunchHost]

Can any body help my please?

How much ram do you have? The best guide I found on how to fix your issue is http://blackbird.si/mysql-corrupted-inn ... tep-guide/

and i have 2 GB ram for the server.