라이믹스 설치에 db error 빨강 글씨 나타나서 다음으로 넘어 갈수 없어요
XE 설치하면 에러 없이 설치 잘 됩니다;
무엇이 문제 일까요??
라이믹스 설치에 db error 빨강 글씨 나타나서 다음으로 넘어 갈수 없어요
XE 설치하면 에러 없이 설치 잘 됩니다;
무엇이 문제 일까요??
db 부팅하면 xe 문제 없지만 ... ERROR! MySQL server PID file could not be found! 메세지 나오네요
171114 01:49:42 mysqld_safe mysqld from pid file /var/lib/mysql/li1206-222.members.linode.com.pid ended
171114 01:51:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-11-14 1:51:09 139848772724768 [Note] /usr/sbin/mysqld (mysqld 10.1.28-MariaDB) starting as process 13352 ...
2017-11-14 01:51:09 7f31146ba820 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2017-11-14 1:51:09 139848772724768 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-11-14 1:51:09 139848772724768 [Note] InnoDB: The InnoDB memory heap is disabled
2017-11-14 1:51:09 139848772724768 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-11-14 1:51:09 139848772724768 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-11-14 1:51:09 139848772724768 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-11-14 1:51:09 139848772724768 [Note] InnoDB: Using Linux native AIO
2017-11-14 1:51:09 139848772724768 [Note] InnoDB: Using SSE crc32 instructions
2017-11-14 1:51:09 139848772724768 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2017-11-14 1:51:09 139848772724768 [Note] InnoDB: Completed initialization of buffer pool
2017-11-14 1:51:09 139848772724768 [Note] InnoDB: Highest supported file format is Barracuda.
InnoDB: No valid checkpoint found.
InnoDB: A downgrade from MariaDB 10.2.2 or later is not supported.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/error-creating-innodb.html
2017-11-14 1:51:09 139848772724768 [ERROR] Plugin 'InnoDB' init function returned error.
2017-11-14 1:51:09 139848772724768 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-11-14 1:51:09 139848772724768 [Note] Plugin 'FEEDBACK' is disabled.
2017-11-14 1:51:09 139848772724768 [Note] Server socket created on IP: '::'.
2017-11-14 1:51:09 139848771733248 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'
2017-11-14 1:51:09 139848772724768 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.28-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
다운그레이드하면 안된다고 에러메시지에 나오네요. 대부분의 프로그램들은 다운그레이드하면 무슨 일이 생길지 모릅니다. 데이터 폴더까지 완전히 지우고 다시 설치해야 할 수도 있습니다.
MariaDB 10.2에서 문제가 생긴다면 sql_mode 기본값이 바뀌어서 그럴 가능성이 높습니다. my.cnf에서 그것만 고쳐 주시면 됩니다. (MySQL 5.7도 마찬가지입니다.)