Created
October 23, 2014 20:39
-
-
Save shadowhand/aeded18883fefd6365de to your computer and use it in GitHub Desktop.
MariaDB falling apart with corrupt mysql.proc table
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Installing MariaDB/MySQL system tables in '/usr/local/var/mysql' ... | |
141023 15:38:30 [Note] InnoDB: Using mutexes to ref count buffer pool pages | |
141023 15:38:30 [Note] InnoDB: The InnoDB memory heap is disabled | |
141023 15:38:30 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
141023 15:38:30 [Note] InnoDB: Memory barrier is not used | |
141023 15:38:30 [Note] InnoDB: Compressed tables use zlib 1.2.5 | |
141023 15:38:30 [Note] InnoDB: Using CPU crc32 instructions | |
141023 15:38:30 [Note] InnoDB: Initializing buffer pool, size = 128.0M | |
141023 15:38:30 [Note] InnoDB: Completed initialization of buffer pool | |
141023 15:38:30 [Note] InnoDB: Highest supported file format is Barracuda. | |
141023 15:38:30 [Note] InnoDB: 128 rollback segment(s) are active. | |
141023 15:38:30 [Note] InnoDB: Waiting for purge to start | |
141023 15:38:30 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.20-68.0 started; log sequence number 2233848336 | |
141023 15:38:30 [ERROR] Incorrect definition of table mysql.proc: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT | |
','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB | |
2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TA | |
BLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVA | |
141023 15:38:30 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCA | |
T','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','D | |
B2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_T | |
ABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECED | |
ENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FUL | |
L_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS',' | |
MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A | |
ERROR: 1136 Column count doesn't match value count at row 1 | |
141023 15:38:31 [ERROR] Aborting |
Run mysql_upgrade from root user and then check.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
How did you fix this issue?? I tried installing Mairadb on mac and I am getting the same problem.