MySQL could not be started

6 posts / 0 new
Last post
n6osb
n6osb's picture
MySQL could not be started

A while back I did a fresh Linux install on my computer and moved over my home directory. Ever since then I haven't been able to get into my log. If I run CQRLOG from a different username I can run CQRLOG with no problems.

Please help. Thanks!

I get the following error message:

Error during connection to database: TMySQL57Connection : Server connect failed.

Bellow is a copy of my mysql.err file:

2017-01-01T02:01:12.109959Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
2017-01-01T02:01:12.110044Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-01-01T02:01:12.112040Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.16-0ubuntu0.16.04.1) starting as process 3621 ...
2017-01-01T02:01:12.120437Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-01-01T02:01:12.120487Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-01T02:01:12.120496Z 0 [Note] InnoDB: Uses event mutexes
2017-01-01T02:01:12.120501Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-01-01T02:01:12.120506Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-01-01T02:01:12.120511Z 0 [Note] InnoDB: Using Linux native AIO
2017-01-01T02:01:12.120879Z 0 [Note] InnoDB: Number of pools: 1
2017-01-01T02:01:12.121039Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-01-01T02:01:12.122996Z 0 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2017-01-01T02:01:12.130679Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-01-01T02:01:12.132559Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-01-01T02:01:12.142645Z 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2017-01-01T02:01:12.142927Z 0 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
2017-01-01T02:01:12.331623Z 0 [Note] InnoDB: File './ibdata1' size is now 12 MB.
2017-01-01T02:01:12.332184Z 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2017-01-01T02:01:12.839736Z 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2017-01-01T02:01:13.639529Z 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2017-01-01T02:01:13.639656Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-01-01T02:01:13.639683Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-01-01T02:01:13.639761Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-01-01T02:01:13.814632Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-01-01T02:01:13.815243Z 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2017-01-01T02:01:14.015094Z 0 [Note] InnoDB: Doublewrite buffer created
2017-01-01T02:01:14.028957Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-01-01T02:01:14.029053Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-01-01T02:01:14.029808Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-01-01T02:01:14.030681Z 0 [Note] InnoDB: Foreign key constraint system tables created
2017-01-01T02:01:14.030723Z 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2017-01-01T02:01:14.031043Z 0 [Note] InnoDB: Tablespace and datafile system tables created.
2017-01-01T02:01:14.031064Z 0 [Note] InnoDB: Creating sys_virtual system tables.
2017-01-01T02:01:14.031211Z 0 [Note] InnoDB: sys_virtual table created
2017-01-01T02:01:14.031396Z 0 [Note] InnoDB: Waiting for purge to start
2017-01-01T02:01:14.081561Z 0 [Note] InnoDB: 5.7.16 started; log sequence number 0
2017-01-01T02:01:14.082092Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-01-01T02:01:14.082318Z 0 [ERROR] unknown variable 'innodb_additional_mem_pool_size=1M'
2017-01-01T02:01:14.082330Z 0 [ERROR] Aborting

2017-01-01T02:01:14.082340Z 0 [Note] Binlog end
2017-01-01T02:01:14.082393Z 0 [Note] Shutting down plugin 'ngram'
2017-01-01T02:01:14.082403Z 0 [Note] Shutting down plugin 'ARCHIVE'
2017-01-01T02:01:14.082409Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2017-01-01T02:01:14.082415Z 0 [Note] Shutting down plugin 'partition'
2017-01-01T02:01:14.082421Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-01-01T02:01:14.082604Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2017-01-01T02:01:14.082612Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-01-01T02:01:14.082618Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-01-01T02:01:14.082624Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-01-01T02:01:14.082630Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-01-01T02:01:14.082635Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-01-01T02:01:14.082642Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-01-01T02:01:14.082648Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-01-01T02:01:14.082653Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-01-01T02:01:14.082659Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-01-01T02:01:14.082665Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-01-01T02:01:14.082671Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-01-01T02:01:14.082677Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-01-01T02:01:14.082682Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-01-01T02:01:14.082688Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-01-01T02:01:14.082694Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-01-01T02:01:14.082700Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2017-01-01T02:01:14.082706Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2017-01-01T02:01:14.082712Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-01-01T02:01:14.082717Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-01-01T02:01:14.082723Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-01-01T02:01:14.082729Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-01-01T02:01:14.082735Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-01-01T02:01:14.082741Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-01-01T02:01:14.082746Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-01-01T02:01:14.082752Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-01-01T02:01:14.082758Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2017-01-01T02:01:14.082764Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-01-01T02:01:14.082769Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-01-01T02:01:14.082775Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2017-01-01T02:01:14.082781Z 0 [Note] Shutting down plugin 'InnoDB'
2017-01-01T02:01:14.082910Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-01-01T02:01:14.083188Z 0 [Note] InnoDB: Starting shutdown...
2017-01-01T02:01:14.083306Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/gmoreno/.config/cqrlog/database/ib_buffer_pool
2017-01-01T02:01:14.083543Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 161231 18:01:14
2017-01-01T02:01:15.953274Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1209961
2017-01-01T02:01:15.955679Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-01-01T02:01:15.955728Z 0 [Note] Shutting down plugin 'CSV'
2017-01-01T02:01:15.955734Z 0 [Note] Shutting down plugin 'MyISAM'
2017-01-01T02:01:15.955749Z 0 [Note] Shutting down plugin 'MEMORY'
2017-01-01T02:01:15.955754Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2017-01-01T02:01:15.955759Z 0 [Note] Shutting down plugin 'sha256_password'
2017-01-01T02:01:15.955762Z 0 [Note] Shutting down plugin 'mysql_native_password'
2017-01-01T02:01:15.955911Z 0 [Note] Shutting down plugin 'binlog'
2017-01-01T02:01:15.956051Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2017-01-07T02:53:46.746424Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
2017-01-07T02:53:46.746508Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-01-07T02:53:46.748733Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.16-0ubuntu0.16.04.1) starting as process 6146 ...
2017-01-07T02:53:46.767937Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-01-07T02:53:46.768007Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-07T02:53:46.768021Z 0 [Note] InnoDB: Uses event mutexes
2017-01-07T02:53:46.768037Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-01-07T02:53:46.768050Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-01-07T02:53:46.768061Z 0 [Note] InnoDB: Using Linux native AIO
2017-01-07T02:53:46.768841Z 0 [Note] InnoDB: Number of pools: 1
2017-01-07T02:53:46.769151Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-01-07T02:53:46.773073Z 0 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2017-01-07T02:53:46.784761Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-01-07T02:53:46.786972Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-01-07T02:53:46.836480Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-01-07T02:53:46.836625Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2017-01-07T02:53:46.836649Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2017-01-07T02:53:46.836661Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-01-07T02:53:47.437450Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-01-07T02:53:47.437507Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-01-07T02:53:47.437517Z 0 [ERROR] Failed to initialize plugins.
2017-01-07T02:53:47.437524Z 0 [ERROR] Aborting

2017-01-07T02:53:47.437533Z 0 [Note] Binlog end
2017-01-07T02:53:47.437594Z 0 [Note] Shutting down plugin 'CSV'
2017-01-07T02:53:47.437604Z 0 [Note] Shutting down plugin 'MyISAM'
2017-01-07T02:53:47.438023Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2017-12-30T01:17:15.699049Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
2017-12-30T01:17:15.699236Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-12-30T01:17:15.709989Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.20-0ubuntu0.16.04.1) starting as process 22351 ...
2017-12-30T01:17:15.884115Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-12-30T01:17:15.884189Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-30T01:17:15.884198Z 0 [Note] InnoDB: Uses event mutexes
2017-12-30T01:17:15.884206Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-12-30T01:17:15.884215Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-12-30T01:17:15.884222Z 0 [Note] InnoDB: Using Linux native AIO
2017-12-30T01:17:15.887299Z 0 [Note] InnoDB: Number of pools: 1
2017-12-30T01:17:15.889441Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-12-30T01:17:15.905984Z 0 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2017-12-30T01:17:15.915408Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-12-30T01:17:15.917740Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-12-30T01:17:15.969974Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-30T01:17:15.971448Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2017-12-30T01:17:15.971503Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2017-12-30T01:17:15.971513Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-12-30T01:17:16.572152Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-12-30T01:17:16.572200Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-12-30T01:17:16.572207Z 0 [ERROR] Failed to initialize plugins.
2017-12-30T01:17:16.572211Z 0 [ERROR] Aborting

2017-12-30T01:17:16.572246Z 0 [Note] Binlog end
2017-12-30T01:17:16.573174Z 0 [Note] Shutting down plugin 'CSV'
2017-12-30T01:17:16.573218Z 0 [Note] Shutting down plugin 'MyISAM'
2017-12-30T01:17:16.574673Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2017-12-30 9:11:59 139684298037440 [ERROR] mysqld: File '/home/gmoreno/.config/cqrlog/database/' not found (Errcode: 13 "Permission denied")
2017-12-30 9:11:59 139684298037440 [ERROR] mysqld: Can't create/write to file '/home/gmoreno/.config/cqrlog/database/aria_log_control' (Errcode: 13 "Permission denied")
2017-12-30 9:11:59 139684298037440 [ERROR] mysqld: Got error 'Can't create file' when trying to use aria control file '/home/gmoreno/.config/cqrlog/database/aria_log_control'
2017-12-30 9:11:59 139684298037440 [ERROR] Plugin 'Aria' init function returned error.
2017-12-30 9:11:59 139684298037440 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2017-12-30 9:11:59 139684298037440 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-30 9:11:59 139684298037440 [Note] InnoDB: Uses event mutexes
2017-12-30 9:11:59 139684298037440 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-12-30 9:11:59 139684298037440 [Note] InnoDB: Using Linux native AIO
2017-12-30 9:11:59 139684298037440 [Note] InnoDB: Number of pools: 1
2017-12-30 9:11:59 139684298037440 [Note] InnoDB: Using generic crc32 instructions
2017-12-30 9:11:59 139684298037440 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2017-12-30 9:11:59 139684298037440 [Note] InnoDB: Completed initialization of buffer pool
2017-12-30 9:11:59 139683851884288 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-12-30 9:11:59 139684298037440 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-30 9:11:59 139684298037440 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2017-12-30 9:11:59 139684298037440 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2017-12-30 9:11:59 139684298037440 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-12-30 9:12:00 139684298037440 [Note] InnoDB: Starting shutdown...
2017-12-30 9:12:00 139684298037440 [ERROR] Plugin 'InnoDB' init function returned error.
2017-12-30 9:12:00 139684298037440 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-12-30 9:12:00 139684298037440 [Note] Plugin 'FEEDBACK' is disabled.
2017-12-30 9:12:00 139684298037440 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_additional_mem_pool_size=1M'
2017-12-30 9:12:00 139684298037440 [ERROR] Aborting

2017-12-30 9:12:58 139625338460352 [ERROR] mysqld: Got error 'Size of control file is smaller than expected' when trying to use aria control file '/home/gmoreno/.config/cqrlog/database/aria_log_control'
2017-12-30 9:12:58 139625338460352 [ERROR] Plugin 'Aria' init function returned error.
2017-12-30 9:12:58 139625338460352 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2017-12-30 9:12:58 139625338460352 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-30 9:12:58 139625338460352 [Note] InnoDB: Uses event mutexes
2017-12-30 9:12:58 139625338460352 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-12-30 9:12:58 139625338460352 [Note] InnoDB: Using Linux native AIO
2017-12-30 9:12:58 139625338460352 [Note] InnoDB: Number of pools: 1
2017-12-30 9:12:58 139625338460352 [Note] InnoDB: Using generic crc32 instructions
2017-12-30 9:12:58 139625338460352 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2017-12-30 9:12:58 139625338460352 [Note] InnoDB: Completed initialization of buffer pool
2017-12-30 9:12:58 139624888375040 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-12-30 9:12:58 139625338460352 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-30 9:12:59 139625338460352 [Note] InnoDB: Upgrading redo log: 2*50331648 bytes; LSN=1589339
2017-12-30 9:12:59 139625338460352 [Note] InnoDB: Starting to delete and rewrite log files.
2017-12-30 9:12:59 139625338460352 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes
2017-12-30 9:12:59 139625338460352 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes
2017-12-30 9:12:59 139625338460352 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2017-12-30 9:12:59 139625338460352 [Note] InnoDB: New log files created, LSN=1589339
2017-12-30 9:12:59 139625338460352 [Note] InnoDB: Creating tablespace and datafile system tables.
2017-12-30 9:12:59 139625338460352 [Note] InnoDB: 128 out of 128 rollback segments are active.
2017-12-30 9:12:59 139625338460352 [Note] InnoDB: Creating sys_virtual system tables.
2017-12-30 9:12:59 139625338460352 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-12-30 9:12:59 139625338460352 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-12-30 9:12:59 139625338460352 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-12-30 9:12:59 139625338460352 [Note] InnoDB: Waiting for purge to start
2017-12-30 9:12:59 139625338460352 [Note] InnoDB: 5.7.20 started; log sequence number 0
2017-12-30 9:12:59 139624722708224 [Note] InnoDB: Loading buffer pool(s) from /home/gmoreno/.config/cqrlog/database/ib_buffer_pool
2017-12-30 9:12:59 139625338460352 [Note] Plugin 'FEEDBACK' is disabled.
2017-12-30 9:12:59 139625338460352 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_additional_mem_pool_size=1M'
2017-12-30 9:12:59 139625338460352 [ERROR] Aborting

2017-12-31 8:27:06 139825108863168 [ERROR] mysqld: Got error 'Size of control file is smaller than expected' when trying to use aria control file '/home/gmoreno/.config/cqrlog/database/aria_log_control'
2017-12-31 8:27:06 139825108863168 [ERROR] Plugin 'Aria' init function returned error.
2017-12-31 8:27:06 139825108863168 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2017-12-31 8:27:06 139825108863168 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-31 8:27:06 139825108863168 [Note] InnoDB: Uses event mutexes
2017-12-31 8:27:06 139825108863168 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-12-31 8:27:06 139825108863168 [Note] InnoDB: Using Linux native AIO
2017-12-31 8:27:06 139825108863168 [Note] InnoDB: Number of pools: 1
2017-12-31 8:27:06 139825108863168 [Note] InnoDB: Using generic crc32 instructions
2017-12-31 8:27:06 139825108863168 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2017-12-31 8:27:06 139825108863168 [Note] InnoDB: Completed initialization of buffer pool
2017-12-31 8:27:06 139824663070464 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-12-31 8:27:06 139825108863168 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-31 8:27:07 139825108863168 [Note] InnoDB: 128 out of 128 rollback segments are active.
2017-12-31 8:27:07 139825108863168 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-12-31 8:27:07 139825108863168 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-12-31 8:27:07 139825108863168 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-12-31 8:27:07 139825108863168 [Note] InnoDB: Waiting for purge to start
2017-12-31 8:27:07 139825108863168 [Note] InnoDB: 5.7.20 started; log sequence number 1596245
2017-12-31 8:27:07 139824497403648 [Note] InnoDB: Loading buffer pool(s) from /home/gmoreno/.config/cqrlog/database/ib_buffer_pool
2017-12-31 8:27:07 139825108863168 [Note] Plugin 'FEEDBACK' is disabled.
2017-12-31 8:27:07 139825108863168 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2017-12-31 8:27:07 139825108863168 [ERROR] Aborting

2017-12-31 8:36:11 140456298211520 [ERROR] mysqld: Got error 'Size of control file is smaller than expected' when trying to use aria control file '/home/gmoreno/.config/cqrlog/database/aria_log_control'
2017-12-31 8:36:11 140456298211520 [ERROR] Plugin 'Aria' init function returned error.
2017-12-31 8:36:11 140456298211520 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2017-12-31 8:36:11 140456298211520 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-31 8:36:11 140456298211520 [Note] InnoDB: Uses event mutexes
2017-12-31 8:36:11 140456298211520 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-12-31 8:36:11 140456298211520 [Note] InnoDB: Using Linux native AIO
2017-12-31 8:36:11 140456298211520 [Note] InnoDB: Number of pools: 1
2017-12-31 8:36:11 140456298211520 [Note] InnoDB: Using generic crc32 instructions
2017-12-31 8:36:11 140456298211520 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2017-12-31 8:36:11 140456298211520 [Note] InnoDB: Completed initialization of buffer pool
2017-12-31 8:36:11 140455855257344 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-12-31 8:36:11 140456298211520 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-31 8:36:11 140456298211520 [Note] InnoDB: 128 out of 128 rollback segments are active.
2017-12-31 8:36:11 140456298211520 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-12-31 8:36:11 140456298211520 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-12-31 8:36:11 140456298211520 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-12-31 8:36:11 140456298211520 [Note] InnoDB: Waiting for purge to start
2017-12-31 8:36:11 140456298211520 [Note] InnoDB: 5.7.20 started; log sequence number 1596264
2017-12-31 8:36:11 140455614338816 [Note] InnoDB: Loading buffer pool(s) from /home/gmoreno/.config/cqrlog/database/ib_buffer_pool
2017-12-31 8:36:11 140455614338816 [Note] InnoDB: Buffer pool(s) load completed at 171231 8:36:11
2017-12-31 8:36:11 140456298211520 [Note] Plugin 'FEEDBACK' is disabled.
2017-12-31 8:36:11 140456298211520 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2017-12-31 8:36:11 140456298211520 [ERROR] Aborting

ok2cqr
ok2cqr's picture
Re: MySQL could not be started

What version of CQRLOG and distribution are you using? What is the result of cqrlog --debug=1 in a console? Thanks!

73 Petr, OK7AN

n6osb
n6osb's picture
I'm running version 2.2.0

I'm running version 2.2.0

Here's the print out you requested:
**** DEBUG LEVEL 1 ****

SSL libraries:
/lib/x86_64-linux-gnu/libssl.so.1.0.0
/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Loaded 72238 LoTW users
Loaded 82030 eQSL users
Loaded 45646 SCP calls
*
User home directory: /home/gmoreno/
Program home directory: /home/gmoreno/.config/cqrlog/
Data directory: /home/gmoreno/.config/cqrlog/database/
Memebers directory: /usr/share/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.7
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/gmoreno/.config/cqrlog/database/mysql.cnf --datadir=/home/gmoreno/.config/cqrlog/database/ --socket=/home/gmoreno/.config/cqrlog/database/sock --port=64000
Trying to connect to database
2017-12-31 10:32:10 140531923572928 [Note] /usr/sbin/mysqld (mysqld 10.2.11-MariaDB-10.2.11+maria~xenial) starting as process 13885 ...
TMySQL57Connection : Server connect failed.
Trying:1
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:2
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:3
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:4
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:5
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:6
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:7
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:8
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Invalid file handle
Closing dDXCC
Closing dData
Closing ini file ...

Thanks for your help.

n6osb
n6osb's picture
I deleted the file below and

I deleted the file below and I'm back in business.
/home/gmoreno/.config/cqrlog/database/aria_log_control

Thanks.

kc0gu
Similar error MySQL could not be started

New install Ubuntu 17.10, added PPA per website instruction.
Error Log:
**** DEBUG LEVEL 1 ****

SSL libraries:
/lib/x86_64-linux-gnu/libssl.so.1.0.0
/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient:
FATAL ERROR: Can not get MySQL client library version version!
Setting to default version (5.1)
**********************************
MySQL version assigned: 5.1
**********************************
Loaded 93636 LoTW users
Loaded 98114 eQSL users
Loaded 48268 SCP calls
/home/wgaspar/.config/cqrlog/database/KC0GU-LT.pid
Command:
kill 8820
*
User home directory: /home/wgaspar/
Program home directory: /home/wgaspar/.config/cqrlog/
Data directory: /home/wgaspar/.config/cqrlog/database/
Memebers directory: /usr/share/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.1
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/wgaspar/.config/cqrlog/database/mysql.cnf --datadir=/home/wgaspar/.config/cqrlog/database/ --socket=/home/wgaspar/.config/cqrlog/database/sock --port=64000
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:1
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:2
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:3
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:4
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:5
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:6
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:7
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:8

MySQL 5.7 is loaded

PopUp ERROR window says:
Error during connection to database: Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.

Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package libmysqlclient.so.16
E: Couldn't find any package by glob 'libmysqlclient.so.16'
E: Couldn't find any package by regex 'libmysqlclient.so.16'

Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package libmysqlclient.so
E: Couldn't find any package by glob 'libmysqlclient.so'
E: Couldn't find any package by regex 'libmysqlclient.so'

I have tried this on several versions of Mint 18 with the same results.

Tnx for any help,

Warren
KC0GU

oh1kh
Hi

Hi
See this message:
https://cqrlog.com/comment/5976#comment-5976

--
Saku
OH1KH

--
Saku
OH1KH