cqrlog will not execute but reports a MYSQL error..

2 posts / 0 new
Last post
kt6l
cqrlog will not execute but reports a MYSQL error..

At a loss - have installed cqrlog per Petr's instructions which specify that all dependencies are satisfied. Running Ubuntu MATE 16.04.2 on Apple MacBook with duo intel, 2 GB RAM.

What is lacking? What else must one do to get operational?
Many thanks in advance.

73

Here are the last lines in the MYSQL error file :

017-06-06T01:08:48.926007Z 0 [Note] InnoDB: Foreign key constraint system tables created
2017-06-06T01:08:48.926057Z 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2017-06-06T01:08:48.926436Z 0 [Note] InnoDB: Tablespace and datafile system tables created.
2017-06-06T01:08:48.926471Z 0 [Note] InnoDB: Creating sys_virtual system tables.
2017-06-06T01:08:48.926712Z 0 [Note] InnoDB: sys_virtual table created
2017-06-06T01:08:48.927054Z 0 [Note] InnoDB: Waiting for purge to start
2017-06-06T01:08:48.977266Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 0

[FIRST SIGN OF TROUBLE]
-->>2017-06-06T01:08:48.978100Z 0 [Note] Plugin 'FEDERATED' is disabled.
-->>2017-06-06T01:08:48.978523Z 0 [ERROR] unknown variable 'innodb_additional_mem_pool_size=1M'
-->>2017-06-06T01:08:48.978543Z 0 [ERROR] Aborting

2017-06-06T01:08:48.978573Z 0 [Note] Binlog end
2017-06-06T01:08:48.978629Z 0 [Note] Shutting down plugin 'ngram'
2017-06-06T01:08:48.978645Z 0 [Note] Shutting down plugin 'ARCHIVE'
2017-06-06T01:08:48.978659Z 0 [Note] Shutting down plugin 'partition'
2017-06-06T01:08:48.978672Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2017-06-06T01:08:48.978686Z 0 [Note] Shutting down plugin 'MEMORY'
2017-06-06T01:08:48.978726Z 0 [Note] Shutting down plugin 'MyISAM'
2017-06-06T01:08:48.978752Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-06-06T01:08:48.978863Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2017-06-06T01:08:48.978877Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2017-06-06T01:08:48.978890Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-06-06T01:08:48.978903Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-06-06T01:08:48.978915Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-06-06T01:08:48.978928Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-06-06T01:08:48.978941Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-06-06T01:08:48.978954Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-06-06T01:08:48.978967Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-06-06T01:08:48.978980Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-06-06T01:08:48.978992Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-06-06T01:08:48.979005Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-06-06T01:08:48.979018Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-06-06T01:08:48.979031Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-06-06T01:08:48.979044Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-06-06T01:08:48.979057Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-06-06T01:08:48.979070Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-06-06T01:08:48.979083Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2017-06-06T01:08:48.979095Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2017-06-06T01:08:48.979108Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-06-06T01:08:48.979121Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-06-06T01:08:48.979134Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-06-06T01:08:48.979147Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-06-06T01:08:48.979159Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-06-06T01:08:48.979172Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-06-06T01:08:48.979185Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-06-06T01:08:48.979197Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-06-06T01:08:48.979210Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2017-06-06T01:08:48.979223Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-06-06T01:08:48.979236Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-06-06T01:08:48.979249Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2017-06-06T01:08:48.979261Z 0 [Note] Shutting down plugin 'InnoDB'
2017-06-06T01:08:48.979330Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-06-06T01:08:48.979554Z 0 [Note] InnoDB: Starting shutdown...
2017-06-06T01:08:49.079985Z 0 [Note] InnoDB: Dumping buffer pool(s) to /home/grant/.config/cqrlog/database/ib_buffer_pool
2017-06-06T01:08:49.080277Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170605 18:08:49
2017-06-06T01:08:50.976451Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1209961
2017-06-06T01:08:50.981276Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-06-06T01:08:50.981314Z 0 [Note] Shutting down plugin 'CSV'
2017-06-06T01:08:50.981330Z 0 [Note] Shutting down plugin 'sha256_password'
2017-06-06T01:08:50.981342Z 0 [Note] Shutting down plugin 'mysql_native_password'
2017-06-06T01:08:50.981650Z 0 [Note] Shutting down plugin 'binlog'
2017-06-06T01:08:50.981897Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2017-06-06T01:10:06.216507Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
2017-06-06T01:10:06.216624Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-06-06T01:10:06.220360Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-0ubuntu0.16.04.1) starting as process 12913 ...
2017-06-06T01:10:06.227100Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-06-06T01:10:06.227163Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-06-06T01:10:06.227177Z 0 [Note] InnoDB: Uses event mutexes
2017-06-06T01:10:06.227191Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-06-06T01:10:06.227204Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-06-06T01:10:06.227217Z 0 [Note] InnoDB: Using Linux native AIO
2017-06-06T01:10:06.227712Z 0 [Note] InnoDB: Number of pools: 1
2017-06-06T01:10:06.227886Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-06-06T01:10:06.230438Z 0 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2017-06-06T01:10:06.243107Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-06-06T01:10:06.245416Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-06-06T01:10:06.319566Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-06-06T01:10:06.319769Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2017-06-06T01:10:06.319819Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2017-06-06T01:10:06.319849Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-06-06T01:10:06.920587Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-06-06T01:10:06.920663Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-06-06T01:10:06.920686Z 0 [ERROR] Failed to initialize plugins.
2017-06-06T01:10:06.920703Z 0 [ERROR] Aborting

2017-06-06T01:10:06.920741Z 0 [Note] Binlog end
2017-06-06T01:10:06.920813Z 0 [Note] Shutting down plugin 'CSV'
2017-06-06T01:10:06.921454Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

kt6l
After reinstalling cqrlog,

After reinstalling cqrlog, twice, the installation went EXCEPT that no password was required at the end of the install.

Seems to work ok now. Still have to install the HamLibs for full function.

Petr - many thanks for the excellent work and product you guys have produced and offered to the Ham World - Ochen priyatno ! Dobsche.

73 de KT6L