LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 01-21-2020, 03:20 AM   #16
kajlaajay
LQ Newbie
 
Registered: Jan 2020
Posts: 9

Original Poster
Rep: Reputation: Disabled

Quote:
Originally Posted by berndbausch View Post
I should have told you to redirect the journalctl output to a file in order to obtain full lines. When you run journalctl at the command prompt, it truncates lines to the width of the terminal by default.

Still, I think the important part is
Code:
Jan 21 09:59:05 mysqld[1759]: InnoDB: If you get repeated assertion failures or crashes, even
Jan 21 09:59:05 mysqld[1759]: InnoDB: immediately after the mysqld startup, there may be
Jan 21 09:59:05 mysqld[1759]: InnoDB: corruption in the InnoDB tablespace. Please refer to
Jan 21 09:59:05 mysqld[1759]: InnoDB: http://dev.mysql.com/doc/refman/5.6/...-recovery.html
Jan 21 09:59:05 mysqld[1759]: InnoDB: about forcing recovery.
Since you do get repeated crashes, see if the referenced web page https://dev.mysql.com/doc/refman/5.6...-recovery.html helps.

Personally, my MySQL/MariaDB/InnoDB skill level is not really high, so that I am not sure what precisely is wrong here.
Hi before that copy paste data is not good at all so i did copy all log data to txt file and now few of them is these.
Check maybe you can find any problem.

Jan 21 13:40:20 systemd[1]: Starting MariaDB 10.1.36 database server...
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [Note] /usr/sbin/mysqld (mysqld 10.1.36-MariaDB) starting as process 5672 ...
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [Note] InnoDB: The InnoDB memory heap is disabled
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [Note] InnoDB: Compressed tables use zlib 1.2.7
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [Note] InnoDB: Using Linux native AIO
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [Note] InnoDB: Using SSE crc32 instructions
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [Note] InnoDB: Completed initialization of buffer pool
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 0 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [ERROR] Plugin 'InnoDB' init function returned error.
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [Note] Plugin 'FEEDBACK' is disabled.
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [ERROR] Unknown/unsupported storage engine: InnoDB
Jan 21 13:40:20 mysqld[5672]: 2020-01-21 13:40:20 140117621954816 [ERROR] Aborting
Jan 21 13:40:21 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Jan 21 13:40:21 systemd[1]: Failed to start MariaDB 10.1.36 database server.
Jan 21 13:40:21 systemd[1]: Unit mariadb.service entered failed state.
Jan 21 13:40:21 systemd[1]: mariadb.service failed.
Jan 21 13:40:53 systemd[1]: Starting MariaDB 10.1.36 database server...
Jan 21 13:40:53 mysqld[5780]: 2020-01-21 13:40:53 140358232692992 [Note] /usr/sbin/mysqld (mysqld 10.1.36-MariaDB) starting as process 5780 ...
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [Note] InnoDB: The InnoDB memory heap is disabled
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [Note] InnoDB: Compressed tables use zlib 1.2.7
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [Note] InnoDB: Using Linux native AIO
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [Note] InnoDB: Using SSE crc32 instructions
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [Note] InnoDB: Completed initialization of buffer pool
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 0 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [ERROR] Plugin 'InnoDB' init function returned error.
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [Note] Plugin 'FEEDBACK' is disabled.
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [ERROR] Unknown/unsupported storage engine: InnoDB
Jan 21 13:40:54 mysqld[5780]: 2020-01-21 13:40:54 140358232692992 [ERROR] Aborting
Jan 21 13:40:54 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Jan 21 13:40:54 systemd[1]: Failed to start MariaDB 10.1.36 database server.
Jan 21 13:40:54 systemd[1]: Unit mariadb.service entered failed state.
Jan 21 13:40:54 systemd[1]: mariadb.service failed.
Jan 21 13:42:21 systemd[1]: Starting MariaDB 10.1.36 database server...
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [Note] /usr/sbin/mysqld (mysqld 10.1.36-MariaDB) starting as process 6079 ...
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [Note] InnoDB: Started in read only mode
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [Note] InnoDB: The InnoDB memory heap is disabled
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [Note] InnoDB: Compressed tables use zlib 1.2.7
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [Note] InnoDB: Using Linux native AIO
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [Note] InnoDB: Using SSE crc32 instructions
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [Note] InnoDB: Disabling background IO write threads.
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [Note] InnoDB: Completed initialization of buffer pool
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 0 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [ERROR] Plugin 'InnoDB' init function returned error.
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [Note] Plugin 'FEEDBACK' is disabled.
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [ERROR] Unknown/unsupported storage engine: InnoDB
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [ERROR] Aborting
Jan 21 13:42:21 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Jan 21 13:42:21 systemd[1]: Failed to start MariaDB 10.1.36 database server.
Jan 21 13:42:21 systemd[1]: Unit mariadb.service entered failed state.
Jan 21 13:42:21 systemd[1]: mariadb.service failed.
Jan 21 13:45:02 systemd[1]: Starting MariaDB 10.1.36 database server...
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [Note] /usr/sbin/mysqld (mysqld 10.1.36-MariaDB) starting as process 6666 ...
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [Note] InnoDB: Started in read only mode
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [Note] InnoDB: The InnoDB memory heap is disabled
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [Note] InnoDB: Compressed tables use zlib 1.2.7
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [Note] InnoDB: Using Linux native AIO
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [Note] InnoDB: Using SSE crc32 instructions
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [Note] InnoDB: Disabling background IO write threads.
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [Note] InnoDB: Completed initialization of buffer pool
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 0 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [ERROR] Plugin 'InnoDB' init function returned error.
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [Note] Plugin 'FEEDBACK' is disabled.
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [ERROR] Unknown/unsupported storage engine: InnoDB
Jan 21 13:45:03 mysqld[6666]: 2020-01-21 13:45:03 139698683406592 [ERROR] Aborting
Jan 21 13:45:03 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Jan 21 13:45:03 systemd[1]: Failed to start MariaDB 10.1.36 database server.
Jan 21 13:45:03 systemd[1]: Unit mariadb.service entered failed state.
Jan 21 13:45:03 systemd[1]: mariadb.service failed.
Jan 21 13:45:04 systemd[1]: Starting MariaDB 10.1.36 database server...
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [Note] /usr/sbin/mysqld (mysqld 10.1.36-MariaDB) starting as process 6715 ...
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [Note] InnoDB: Started in read only mode
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [Note] InnoDB: The InnoDB memory heap is disabled
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [Note] InnoDB: Compressed tables use zlib 1.2.7
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [Note] InnoDB: Using Linux native AIO
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [Note] InnoDB: Using SSE crc32 instructions
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [Note] InnoDB: Disabling background IO write threads.
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [Note] InnoDB: Completed initialization of buffer pool
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 0 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [ERROR] Plugin 'InnoDB' init function returned error.
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [Note] Plugin 'FEEDBACK' is disabled.
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [ERROR] Unknown/unsupported storage engine: InnoDB
Jan 21 13:45:04 mysqld[6715]: 2020-01-21 13:45:04 139899987421440 [ERROR] Aborting
Jan 21 13:45:06 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Jan 21 13:45:06 systemd[1]: Failed to start MariaDB 10.1.36 database server.
Jan 21 13:45:06 systemd[1]: Unit mariadb.service entered failed state.
Jan 21 13:45:06 systemd[1]: mariadb.service failed.
Jan 21 13:50:53 systemd[1]: Starting MariaDB 10.1.36 database server...
Jan 21 13:50:53 mysqld[7966]: 2020-01-21 13:50:53 139911771351296 [Note] /usr/sbin/mysqld (mysqld 10.1.36-MariaDB) starting as process 7966 ...
Jan 21 13:50:53 mysqld[7966]: 2020-01-21 13:50:53 139911771351296 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
Jan 21 13:50:54 mysqld[7966]: 2020-01-21 13:50:54 139911771351296 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Jan 21 13:50:54 mysqld[7966]: 2020-01-21 13:50:54 139911771351296 [Note] InnoDB: The InnoDB memory heap is disabled
Jan 21 13:50:54 mysqld[7966]: 2020-01-21 13:50:54 139911771351296 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jan 21 13:50:54 mysqld[7966]: 2020-01-21 13:50:54 139911771351296 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Jan 21 13:50:54 mysqld[7966]: 2020-01-21 13:50:54 139911771351296 [Note] InnoDB: Compressed tables use zlib 1.2.7
Jan 21 13:50:54 mysqld[7966]: 2020-01-21 13:50:54 139911771351296 [Note] InnoDB: Using Linux native AIO
Jan 21 13:50:54 mysqld[7966]: 2020-01-21 13:50:54 139911771351296 [Note] InnoDB: Using SSE crc32 instructions
Jan 21 13:50:54 mysqld[7966]: 2020-01-21 13:50:54 139911771351296 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Jan 21 13:50:54 mysqld[7966]: 2020-01-21 13:50:54 139911771351296 [Note] InnoDB: Completed initialization of buffer pool
Jan 21 13:50:54 mysqld[7966]: 2020-01-21 13:50:54 139911771351296 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 0 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
Jan 21 13:50:54 mysqld[7966]: 2020-01-21 13:50:54 139911771351296 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
Jan 21 13:50:54 mysqld[7966]: 2020-01-21 13:50:54 139911771351296 [ERROR] Plugin 'InnoDB' init function returned error.
Jan 21 13:50:54 mysqld[7966]: 2020-01-21 13:50:54 139911771351296 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jan 21 13:50:54 mysqld[7966]: 2020-01-21 13:50:54 139911771351296 [Note] Plugin 'FEEDBACK' is disabled.
Jan 21 13:50:54 mysqld[7966]: 2020-01-21 13:50:54 139911771351296 [ERROR] Unknown/unsupported storage engine: InnoDB
Jan 21 13:50:54 mysqld[7966]: 2020-01-21 13:50:54 139911771351296 [ERROR] Aborting
Jan 21 13:50:54 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Jan 21 13:50:54 systemd[1]: Failed to start MariaDB 10.1.36 database server.
Jan 21 13:50:54 systemd[1]: Unit mariadb.service entered failed state.
Jan 21 13:50:54 systemd[1]: mariadb.service failed.
Jan 21 14:00:01 systemd[1]: Starting MariaDB 10.1.36 database server...
Jan 21 14:00:01 systemd[1]: Stopped MariaDB 10.1.36 database server.
Jan 21 14:00:03 systemd[1]: Starting MariaDB 10.1.36 database server...
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [Note] /usr/sbin/mysqld (mysqld 10.1.36-MariaDB) starting as process 9849 ...
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [Note] InnoDB: The InnoDB memory heap is disabled
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [Note] InnoDB: Compressed tables use zlib 1.2.7
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [Note] InnoDB: Using Linux native AIO
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [Note] InnoDB: Using SSE crc32 instructions
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [Note] InnoDB: Completed initialization of buffer pool
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 0 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [ERROR] Plugin 'InnoDB' init function returned error.
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [Note] Plugin 'FEEDBACK' is disabled.
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [Note] Server socket created on IP: '::'.
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217302784 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'
Jan 21 14:00:03 mysqld[9849]: 2020-01-21 14:00:03 140602217711872 [Note] /usr/sbin/mysqld: ready for connections.
Jan 21 14:00:03 mysqld[9849]: Version: '10.1.36-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
Jan 21 14:00:03 systemd[1]: Started MariaDB 10.1.36 database server.
 
Old 01-21-2020, 03:44 AM   #17
berndbausch
LQ Addict
 
Registered: Nov 2013
Location: Tokyo
Distribution: Mostly Ubuntu and Centos
Posts: 6,316

Rep: Reputation: 2002Reputation: 2002Reputation: 2002Reputation: 2002Reputation: 2002Reputation: 2002Reputation: 2002Reputation: 2002Reputation: 2002Reputation: 2002Reputation: 2002
The problem is that InnoDB crashes in the way I described. In my opinion, all other errors are consequences of the crashed InnoDB.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: KDE Participating in Google Summer of Code 2019, MariaDB Releasing New Open-Source MariaDB Enterprise Server, CentOS Celebrates 15th B LXer Syndicated Linux News 0 02-28-2019 06:50 AM
starting MariaDB 10.1.30 in CentOS 7 server mkomid Linux - Server 14 02-17-2018 08:26 PM
MariaDB Galera Cluster Starting Issue blakk Red Hat 2 03-05-2015 02:17 PM
When Centos 6.3 starting,All services starting OK and starting Atd: OK .And stop scr. DeSouffle Linux - General 4 08-29-2013 12:46 AM
[SOLVED] Starting File System .. Starting File System .. Starting File System .. Starting File rmknox Linux - Newbie 3 08-15-2010 11:30 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 02:06 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration