We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
"restart" "'mysql'" failed
Re: "restart" "'mysql'" failed
What's time is it? Time to show logs! )
LOG TIME - /var/log/mysql/error.log
and config - /etc/my.cnf or /etc/mysql/my.cnf
and OS version - debian / ubuntu / centos /rhel
LOG TIME - /var/log/mysql/error.log
and config - /etc/my.cnf or /etc/mysql/my.cnf
and OS version - debian / ubuntu / centos /rhel
Re: "restart" "'mysql'" failed
same problem with my server. Please help me.
This is some info (All is default when I install VestaCP):
Time Zone: America/New_York - UTC-4
/var/log/mysqld.log
/etc/my.cnf
Please let me know if you need any info.
this server, Im working with 6 domain and 2 subdomain, have 7 databases and latest Vesta version
server version:
SSD 30Gb
RAM: 1Gb
This is some info (All is default when I install VestaCP):
Time Zone: America/New_York - UTC-4
/var/log/mysqld.log
150801 03:46:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150801 3:46:00 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 11682 ...
150801 3:46:00 [Note] Plugin 'FEDERATED' is disabled.
150801 3:46:00 InnoDB: The InnoDB memory heap is disabled
150801 3:46:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150801 3:46:00 InnoDB: Compressed tables use zlib 1.2.3
150801 3:46:00 InnoDB: Using Linux native AIO
150801 3:46:00 InnoDB: Initializing buffer pool, size = 128.0M
150801 3:46:00 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
150801 3:46:00 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
150801 3:46:00 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
150801 3:46:00 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
150801 3:46:00 InnoDB: Waiting for the background threads to start
150801 3:46:01 InnoDB: 5.5.45 started; log sequence number 0
150801 3:46:01 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150801 3:46:01 [Note] - '0.0.0.0' resolves to '0.0.0.0';
150801 3:46:01 [Note] Server socket created on IP: '0.0.0.0'.
150801 3:46:01 [Note] Event Scheduler: Loaded 0 events
150801 3:46:01 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
150801 05:29:24 mysqld_safe Number of processes running now: 0
150801 05:29:24 mysqld_safe mysqld restarted
150801 5:29:24 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 32676 ...
150801 5:29:24 [Note] Plugin 'FEDERATED' is disabled.
150801 5:29:24 InnoDB: The InnoDB memory heap is disabled
150801 5:29:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150801 5:29:24 InnoDB: Compressed tables use zlib 1.2.3
150801 5:29:24 InnoDB: Using Linux native AIO
150801 5:29:24 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
150801 5:29:24 InnoDB: Completed initialization of buffer pool
150801 5:29:24 InnoDB: Fatal error: cannot allocate memory for the buffer pool
150801 5:29:24 [ERROR] Plugin 'InnoDB' init function returned error.
150801 5:29:24 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150801 5:29:24 [ERROR] Unknown/unsupported storage engine: InnoDB
150801 5:29:24 [ERROR] Aborting
150801 5:29:24 [Note] /usr/libexec/mysqld: Shutdown complete
150801 05:29:24 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150801 05:33:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150801 5:33:34 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 1638 ...
150801 5:33:34 [Note] Plugin 'FEDERATED' is disabled.
150801 5:33:34 InnoDB: The InnoDB memory heap is disabled
150801 5:33:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150801 5:33:34 InnoDB: Compressed tables use zlib 1.2.3
150801 5:33:34 InnoDB: Using Linux native AIO
150801 5:33:34 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
150801 5:33:34 InnoDB: Completed initialization of buffer pool
150801 5:33:34 InnoDB: Fatal error: cannot allocate memory for the buffer pool
150801 5:33:34 [ERROR] Plugin 'InnoDB' init function returned error.
150801 5:33:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150801 5:33:34 [ERROR] Unknown/unsupported storage engine: InnoDB
150801 5:33:34 [ERROR] Aborting
150801 5:33:34 [Note] /usr/libexec/mysqld: Shutdown complete
150801 05:33:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150801 05:33:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150801 5:33:55 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 1303 ...
150801 5:33:55 [Note] Plugin 'FEDERATED' is disabled.
150801 5:33:55 InnoDB: The InnoDB memory heap is disabled
150801 5:33:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150801 5:33:55 InnoDB: Compressed tables use zlib 1.2.3
150801 5:33:55 InnoDB: Using Linux native AIO
150801 5:33:55 InnoDB: Initializing buffer pool, size = 128.0M
150801 5:33:55 InnoDB: Completed initialization of buffer pool
150801 5:33:55 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!
150801 5:33:55 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...
150801 5:33:55 InnoDB: Waiting for the background threads to start
150801 5:33:56 InnoDB: 5.5.45 started; log sequence number 4637918
150801 5:33:56 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150801 5:33:56 [Note] - '0.0.0.0' resolves to '0.0.0.0';
150801 5:33:56 [Note] Server socket created on IP: '0.0.0.0'.
150801 5:33:56 [Note] Event Scheduler: Loaded 0 events
150801 5:33:56 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
150801 5:44:54 [Warning] IP address '223.100.49.242' could not be resolved: Temporary failure in name resolution
150801 5:44:55 [Warning] IP address '223.100.49.242' could not be resolved: Temporary failure in name resolution
150801 5:44:56 [Warning] IP address '223.100.49.242' could not be resolved: Temporary failure in name resolution
150801 5:44:56 [Warning] IP address '223.100.49.242' could not be resolved: Temporary failure in name resolution
150801 7:26:11 [Warning] IP address '121.40.117.236' could not be resolved: Name or service not known
150801 8:17:46 [Warning] IP address '43.249.11.175' could not be resolved: Name or service not known
150801 14:58:38 [Warning] IP address '180.153.42.200' could not be resolved: Name or service not known
150801 17:04:26 [Warning] IP address '218.2.0.77' could not be resolved: Name or service not known
150801 17:05:06 [Warning] IP address '121.17.17.178' could not be resolved: Name or service not known
150801 17:58:54 [Warning] IP address '122.224.6.150' could not be resolved: Name or service not known
150802 0:34:48 [Warning] IP address '222.186.30.73' could not be resolved: Name or service not known
/etc/my.cnf
OS version : centos6.5 x64[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
max_connections=200
max_user_connections=30
wait_timeout=30
interactive_timeout=50
long_query_time=5
#log-queries-not-using-indexes
#log-slow-queries=/var/log/mysql/log-slow-queries.log
#innodb_use_native_aio = 0
innodb_file_per_table
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Please let me know if you need any info.
this server, Im working with 6 domain and 2 subdomain, have 7 databases and latest Vesta version
server version:
SSD 30Gb
RAM: 1Gb
Re: "restart" "'mysql'" failed
Code: Select all
innodb_buffer_pool_size=64M