Hi
I have been having a few MySQL issues, insofar as some backups (mysqldump), running in cron have not been completing. Additionally, occasionally when we go to a site Moodle 2.9 (not upgraded), it reverts back to the installation screens and then fails with errors relating to the BINARY_LOG_FORMAT
If I go to the notifications screen there is no notifications for the DB such as Barracuda upgrade
I have run
sudo php mysql_compressed_rows.php --list
And it returns that some tables need updating
mdl_data Compact (needs fixing)
mdl_data_fields Compact (needs fixing)
mdl_enrol_paypal Compact (needs fixing)
mdl_lti Compact (needs fixing)
mdl_user Compact (needs fixing)
mdl_user_info_field Compact (needs fixing)
But I am not sure this has anything to do with the dump issues or the re-upgrading problems
We do have a number of errors in the error.log which are at the same time as the dump is sheduled for
160922 3:00:16 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
160922 3:00:16 [Note] Plugin 'FEDERATED' is disabled.
160922 3:00:16 InnoDB: The InnoDB memory heap is disabled
160922 3:00:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160922 3:00:16 InnoDB: Compressed tables use zlib 1.2.8
160922 3:00:16 InnoDB: Using Linux native AIO
160922 3:00:17 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
160922 3:00:17 InnoDB: Completed initialization of buffer pool
160922 3:00:17 InnoDB: Fatal error: cannot allocate memory for the buffer pool
160922 3:00:17 [ERROR] Plugin 'InnoDB' init function returned error.
160922 3:00:17 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160922 3:00:17 [ERROR] Unknown/unsupported storage engine: innodb
160922 3:00:17 [ERROR] Aborting
160922 3:00:17 [Note] /usr/sbin/mysqld: Shutdown complete
160922 3:00:24 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
160922 3:00:24 [Note] Plugin 'FEDERATED' is disabled.
160922 3:00:24 InnoDB: The InnoDB memory heap is disabled
160922 3:00:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160922 3:00:24 InnoDB: Compressed tables use zlib 1.2.8
160922 3:00:24 InnoDB: Using Linux native AIO
160922 3:00:26 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
160922 3:00:26 InnoDB: Completed initialization of buffer pool
160922 3:00:26 InnoDB: Fatal error: cannot allocate memory for the buffer pool
160922 3:00:26 [ERROR] Plugin 'InnoDB' init function returned error.
160922 3:00:26 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160922 3:00:26 [ERROR] Unknown/unsupported storage engine: innodb
160922 3:00:26 [ERROR] Aborting
Any Ideas
Cheers
Albert