Mysql Aborting


#1

Hello, I can’t Starting MySQL I use latest version of EasyEngin 3.7

moe@ubuntu:~$ sudo /usr/sbin/mysqld 2016-07-01 0:18:24 3069003776 [Note] /usr/sbin/mysqld (mysqld 10.1.14-MariaDB-1~xenial) starting as process 4450 … 2016-07-01 0:18:24 3069003776 [ERROR] mysqld: File ‘/var/lib/mysql/aria_log_control’ not found (Errcode: 13 “Permission denied”) 2016-07-01 0:18:24 3069003776 [ERROR] mysqld: Got error ‘Can’t open file’ when trying to use aria control file ‘/var/lib/mysql/aria_log_control’ 2016-07-01 0:18:24 3069003776 [ERROR] Plugin ‘Aria’ init function returned error. 2016-07-01 0:18:24 3069003776 [ERROR] Plugin ‘Aria’ registration as a STORAGE ENGINE failed. 2016-07-01 0:18:24 3069003776 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2016-07-01 0:18:24 3069003776 [Note] InnoDB: The InnoDB memory heap is disabled 2016-07-01 0:18:24 3069003776 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-07-01 0:18:24 3069003776 [Note] InnoDB: Memory barrier is not used 2016-07-01 0:18:24 3069003776 [Note] InnoDB: Compressed tables use zlib 1.2.8 2016-07-01 0:18:24 3069003776 [Note] InnoDB: Using Linux native AIO 2016-07-01 0:18:24 3069003776 [Note] InnoDB: Using generic crc32 instructions 2016-07-01 0:18:24 3069003776 [Note] InnoDB: Initializing buffer pool, size = 256.0M 2016-07-01 0:18:24 3069003776 [Note] InnoDB: Completed initialization of buffer pool 2016-07-01 0:18:24 3069003776 [ERROR] InnoDB: ./ibdata1 can’t be opened in read-write mode 2016-07-01 0:18:24 3069003776 [ERROR] InnoDB: The system tablespace must be writable! 2016-07-01 0:18:24 3069003776 [ERROR] Plugin ‘InnoDB’ init function returned error. 2016-07-01 0:18:24 3069003776 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed. 2016-07-01 0:18:24 3069003776 [Note] Plugin ‘FEEDBACK’ is disabled. 2016-07-01 0:18:24 3069003776 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded 2016-07-01 0:18:24 3069003776 [ERROR] Unknown/unsupported storage engine: InnoDB 2016-07-01 0:18:24 3069003776 [ERROR] Aborting


#2

It seems you are running out of RAM. What are the specs of your server?


#3

Hello, I don’t think so :

moe@ubuntu:~$ free -m total used free shared buff/cache available Mem: 3018 70 2713 24 234 2631 Swap: 3060 0 3060

moe@ubuntu:~$ sudo /usr/sbin/mysqld [sudo] password for moe: 2016-07-01 2:32:39 3068278784 [Note] /usr/sbin/mysqld (mysqld 10.1.14-MariaDB-1 ~xenial) starting as process 1322 … 2016-07-01 2:32:39 3068278784 [ERROR] mysqld: File ‘/var/lib/mysql/aria_log_con trol’ not found (Errcode: 13 “Permission denied”) 2016-07-01 2:32:39 3068278784 [ERROR] mysqld: Got error ‘Can’t open file’ when trying to use aria control file ‘/var/lib/mysql/aria_log_control’ 2016-07-01 2:32:39 3068278784 [ERROR] Plugin ‘Aria’ init function returned erro r. 2016-07-01 2:32:39 3068278784 [ERROR] Plugin ‘Aria’ registration as a STORAGE E NGINE failed. 2016-07-01 2:32:39 3068278784 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2016-07-01 2:32:39 3068278784 [Note] InnoDB: The InnoDB memory heap is disabled 2016-07-01 2:32:39 3068278784 [Note] InnoDB: Mutexes and rw_locks use GCC atomi c builtins 2016-07-01 2:32:39 3068278784 [Note] InnoDB: Memory barrier is not used 2016-07-01 2:32:39 3068278784 [Note] InnoDB: Compressed tables use zlib 1.2.8 2016-07-01 2:32:39 3068278784 [Note] InnoDB: Using Linux native AIO 2016-07-01 2:32:39 3068278784 [Note] InnoDB: Using generic crc32 instructions 2016-07-01 2:32:39 3068278784 [Note] InnoDB: Initializing buffer pool, size = 2 56.0M 2016-07-01 2:32:39 3068278784 [Note] InnoDB: Completed initialization of buffer pool 2016-07-01 2:32:39 3068278784 [ERROR] InnoDB: ./ibdata1 can’t be opened in read -write mode 2016-07-01 2:32:39 3068278784 [ERROR] InnoDB: The system tablespace must be wri table! 2016-07-01 2:32:39 3068278784 [ERROR] Plugin ‘InnoDB’ init function returned er ror. 2016-07-01 2:32:39 3068278784 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed. 2016-07-01 2:32:39 3068278784 [Note] Plugin ‘FEEDBACK’ is disabled. 2016-07-01 2:32:39 3068278784 [ERROR] Could not open mysql.plugin table. Some p lugins may be not loaded 2016-07-01 2:32:39 3068278784 [ERROR] Unknown/unsupported storage engine: InnoD B 2016-07-01 2:32:39 3068278784 [ERROR] Aborting


#4

am still need help, I tried to re-install ee but it didn’t fix the issue … it was running fine I didn’t know what happened

regards,


#5

Hi @moe

To debug the issue we will require some more logs.

Can you verify the permission of /var/lib/mysql directory. It need to be as mysql user.

ls -la /var/lib/mysql

Also when you try service mysql start, please provide us the syslog also.

tail -n100 /var/log/syslog

As it is an mysql DB issue, reinstalling EE won’t fix this.


#6

Thank you for supporting I re install OS and fix the issue Reagrds,


#7