MariaDB

Всё о языках программирования, таких как PHP и Perl; вебсерверах, CGI, базах данных и языке SQL.

Все про мови програмування, такі як PHP та Perl; вебсервери, CGI, бази даних та мову SQL.
ozhina
Сообщения: 7
Зарегистрирован: Вс авг 02, 2015 4:42 pm
Пол: Не указан

MariaDB

Сообщение ozhina »

Доброго времени суток всем! При установке MySQL столкнулся со следующей проблемой:
[root@localhost Peter]# systemctl status mariadb.service
● mariadb.service - MariaDB 10.0 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled)
Drop-In: /usr/lib/systemd/system/mariadb.service.d
└─mysql-compat.conf
Active: failed (Result: exit-code) since Пн 2015-08-03 06:16:51 EEST; 28min ago
Process: 27663 ExecStartPost=/usr/libexec/mysql-wait-ready $MAINPID (code=exited, status=1/FAILURE)
Process: 27662 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
Process: 27629 ExecStartPre=/usr/libexec/mysql-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Process: 27605 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
Main PID: 27662 (code=exited, status=0/SUCCESS)

авг 03 06:16:48 localhost.localdomain mysqld_safe[27662]: 150803 06:16:48 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
авг 03 06:16:48 localhost.localdomain mysqld_safe[27662]: 150803 06:16:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
авг 03 06:16:51 localhost.localdomain mysqld_safe[27662]: 150803 06:16:51 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
авг 03 06:16:51 localhost.localdomain systemd[1]: mariadb.service: control process exited, code=exited status=1
авг 03 06:16:51 localhost.localdomain systemd[1]: Failed to start MariaDB 10.0 database server.
авг 03 06:16:51 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
авг 03 06:16:51 localhost.localdomain systemd[1]: mariadb.service failed.
.
Подскажите, пожалуйста, как решить эту проблему на Fedora21!!
Заранее благодарен!
pahanzt
Сообщения: 9
Зарегистрирован: Сб июл 18, 2015 1:23 pm
Пол: Не указан

Re: MariaDB

Сообщение pahanzt »

Добрый день. Покажите, пожалуйста, содержимое /var/log/mariadb/mariadb.log . В логе могут и быть найдены причины того, почему не получается установить.
ozhina
Сообщения: 7
Зарегистрирован: Вс авг 02, 2015 4:42 pm
Пол: Не указан

Re: MariaDB

Сообщение ozhina »

Вот, как-то так:
150802 8:52:37 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150802 8:52:37 [Note] InnoDB: The InnoDB memory heap is disabled
150802 8:52:37 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150802 8:52:37 [Note] InnoDB: Memory barrier is not used
150802 8:52:37 [Note] InnoDB: Compressed tables use zlib 1.2.8
150802 8:52:37 [Note] InnoDB: Using Linux native AIO
150802 8:52:37 [Note] InnoDB: Not using CPU crc32 instructions
150802 8:52:37 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150802 8:52:37 [Note] InnoDB: Completed initialization of buffer pool
150802 8:52:37 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
150802 8:52:37 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
150802 8:52:37 [Note] InnoDB: Database physically writes the file full: wait...
150802 8:52:38 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
150802 8:52:40 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
150802 8:52:42 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
150802 8:52:42 [Warning] InnoDB: New log files created, LSN=45781
150802 8:52:42 [Note] InnoDB: Doublewrite buffer not found: creating new
150802 8:52:42 [Note] InnoDB: Doublewrite buffer created
150802 8:52:42 [Note] InnoDB: 128 rollback segment(s) are active.
150802 8:52:42 [Warning] InnoDB: Creating foreign key constraint system tables.
150802 8:52:42 [Note] InnoDB: Foreign key constraint system tables created
150802 8:52:42 [Note] InnoDB: Creating tablespace and datafile system tables.
150802 8:52:42 [Note] InnoDB: Tablespace and datafile system tables created.
150802 8:52:42 [Note] InnoDB: Waiting for purge to start
150802 8:52:42 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 0
150802 8:52:47 [Note] InnoDB: FTS optimize thread exiting.
150802 8:52:47 [Note] InnoDB: Starting shutdown...
150802 8:52:48 [Note] InnoDB: Shutdown completed; log sequence number 1616697
150802 8:52:49 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150802 8:52:49 [Note] InnoDB: The InnoDB memory heap is disabled
150802 8:52:49 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150802 8:52:49 [Note] InnoDB: Memory barrier is not used
150802 8:52:49 [Note] InnoDB: Compressed tables use zlib 1.2.8
150802 8:52:49 [Note] InnoDB: Using Linux native AIO
150802 8:52:49 [Note] InnoDB: Not using CPU crc32 instructions
150802 8:52:49 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150802 8:52:49 [Note] InnoDB: Completed initialization of buffer pool
150802 8:52:49 [Note] InnoDB: Highest supported file format is Barracuda.
150802 8:52:49 [Note] InnoDB: 128 rollback segment(s) are active.
150802 8:52:49 [Note] InnoDB: Waiting for purge to start
150802 8:52:49 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 1616697
150802 8:52:49 [Note] InnoDB: FTS optimize thread exiting.
150802 8:52:49 [Note] InnoDB: Starting shutdown...
150802 8:52:51 [Note] InnoDB: Shutdown completed; log sequence number 1616707
150802 08:52:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
:
150802 8:52:52 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 9814 ...
150802 8:52:52 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150802 8:52:52 [Note] InnoDB: The InnoDB memory heap is disabled
150802 8:52:52 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150802 8:52:52 [Note] InnoDB: Memory barrier is not used
150802 8:52:52 [Note] InnoDB: Compressed tables use zlib 1.2.8
150802 8:52:52 [Note] InnoDB: Using Linux native AIO
150802 8:52:52 [Note] InnoDB: Not using CPU crc32 instructions
150802 8:52:52 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150802 8:52:52 [Note] InnoDB: Completed initialization of buffer pool
150802 8:52:52 [Note] InnoDB: Highest supported file format is Barracuda.
150802 8:52:52 [Note] InnoDB: 128 rollback segment(s) are active.
150802 8:52:52 [Note] InnoDB: Waiting for purge to start
150802 8:52:52 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 1616707
150802 8:52:52 [Note] Plugin 'FEEDBACK' is disabled.
150802 8:52:52 [Note] Server socket created on IP: '::'.
150802 8:52:52 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
150802 8:52:52 [ERROR] Do you already have another mysqld server running on port: 3306 ?
150802 8:52:52 [ERROR] Aborting

150802 8:52:52 [Note] InnoDB: FTS optimize thread exiting.
150802 8:52:52 [Note] InnoDB: Starting shutdown...
150802 8:52:54 [Note] InnoDB: Shutdown completed; log sequence number 1616717
150802 8:52:55 [Note] /usr/libexec/mysqld: Shutdown complete

150802 08:52:55 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
150802 09:13:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150802 9:13:38 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 12824 ...
150802 9:13:38 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150802 9:13:38 [Note] InnoDB: The InnoDB memory heap is disabled
150802 9:13:38 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150802 9:13:38 [Note] InnoDB: Memory barrier is not used
150802 9:13:38 [Note] InnoDB: Compressed tables use zlib 1.2.8
150802 9:13:38 [Note] InnoDB: Using Linux native AIO
150802 9:13:38 [Note] InnoDB: Not using CPU crc32 instructions
150802 9:13:38 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150802 9:13:38 [Note] InnoDB: Completed initialization of buffer pool
150802 9:13:38 [Note] InnoDB: Highest supported file format is Barracuda.
150802 9:13:38 [Note] InnoDB: 128 rollback segment(s) are active.
150802 9:13:38 [Note] InnoDB: Waiting for purge to start
150802 9:13:38 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 1616717
150802 9:13:38 [Note] Plugin 'FEEDBACK' is disabled.
150802 9:13:38 [Note] Server socket created on IP: '::'.
150802 9:13:38 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
150802 9:13:38 [ERROR] Do you already have another mysqld server running on port: 3306 ?
:
150802 9:13:38 [ERROR] Aborting

150802 9:13:38 [Note] InnoDB: FTS optimize thread exiting.
150802 9:13:38 [Note] InnoDB: Starting shutdown...
150802 9:13:40 [Note] InnoDB: Shutdown completed; log sequence number 1616727
150802 9:13:40 [Note] /usr/libexec/mysqld: Shutdown complete

150802 09:13:41 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
150802 09:18:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150802 9:18:24 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 13649 ...
150802 9:18:24 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150802 9:18:24 [Note] InnoDB: The InnoDB memory heap is disabled
150802 9:18:24 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150802 9:18:24 [Note] InnoDB: Memory barrier is not used
150802 9:18:24 [Note] InnoDB: Compressed tables use zlib 1.2.8
150802 9:18:24 [Note] InnoDB: Using Linux native AIO
150802 9:18:24 [Note] InnoDB: Not using CPU crc32 instructions
150802 9:18:24 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150802 9:18:24 [Note] InnoDB: Completed initialization of buffer pool
150802 9:18:24 [Note] InnoDB: Highest supported file format is Barracuda.
150802 9:18:25 [Note] InnoDB: 128 rollback segment(s) are active.
150802 9:18:25 [Note] InnoDB: Waiting for purge to start
150802 9:18:25 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 1616727
150802 9:18:25 [Note] Plugin 'FEEDBACK' is disabled.
150802 9:18:25 [Note] Server socket created on IP: '::'.
150802 9:18:25 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
150802 9:18:25 [ERROR] Do you already have another mysqld server running on port: 3306 ?
150802 9:18:25 [ERROR] Aborting

150802 9:18:25 [Note] InnoDB: FTS optimize thread exiting.
150802 9:18:25 [Note] InnoDB: Starting shutdown...
150802 9:18:27 [Note] InnoDB: Shutdown completed; log sequence number 1616737
150802 9:18:27 [Note] /usr/libexec/mysqld: Shutdown complete

150802 09:18:27 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
150802 20:42:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150802 20:42:31 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 25956 ...
150802 20:42:31 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150802 20:42:31 [Note] InnoDB: The InnoDB memory heap is disabled
150802 20:42:31 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150802 20:42:31 [Note] InnoDB: Memory barrier is not used
150802 20:42:31 [Note] InnoDB: Compressed tables use zlib 1.2.8
150802 20:42:31 [Note] InnoDB: Using Linux native AIO
150802 20:42:31 [Note] InnoDB: Not using CPU crc32 instructions
150802 20:42:31 [Note] InnoDB: Initializing buffer pool, size = 128.0M
:
150802 20:42:31 [Note] InnoDB: Completed initialization of buffer pool
150802 20:42:31 [Note] InnoDB: Highest supported file format is Barracuda.
150802 20:42:32 [Note] InnoDB: 128 rollback segment(s) are active.
150802 20:42:32 [Note] InnoDB: Waiting for purge to start
150802 20:42:32 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 1616737
150802 20:42:32 [Note] Plugin 'FEEDBACK' is disabled.
150802 20:42:32 [Note] Server socket created on IP: '::'.
150802 20:42:32 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
150802 20:42:32 [ERROR] Do you already have another mysqld server running on port: 3306 ?
150802 20:42:32 [ERROR] Aborting

150802 20:42:32 [Note] InnoDB: FTS optimize thread exiting.
150802 20:42:32 [Note] InnoDB: Starting shutdown...
150802 20:42:34 [Note] InnoDB: Shutdown completed; log sequence number 1616747
150802 20:42:34 [Note] /usr/libexec/mysqld: Shutdown complete

150802 20:42:34 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
150803 05:48:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150803 5:48:24 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 27188 ...
150803 5:48:24 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150803 5:48:24 [Note] InnoDB: The InnoDB memory heap is disabled
150803 5:48:24 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150803 5:48:24 [Note] InnoDB: Memory barrier is not used
150803 5:48:24 [Note] InnoDB: Compressed tables use zlib 1.2.8
150803 5:48:24 [Note] InnoDB: Using Linux native AIO
150803 5:48:24 [Note] InnoDB: Not using CPU crc32 instructions
150803 5:48:24 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150803 5:48:24 [Note] InnoDB: Completed initialization of buffer pool
150803 5:48:24 [Note] InnoDB: Highest supported file format is Barracuda.
150803 5:48:25 [Note] InnoDB: 128 rollback segment(s) are active.
150803 5:48:25 [Note] InnoDB: Waiting for purge to start
150803 5:48:25 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 1616747
150803 5:48:25 [Note] Plugin 'FEEDBACK' is disabled.
150803 5:48:25 [Note] Server socket created on IP: '::'.
150803 5:48:25 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
150803 5:48:25 [ERROR] Do you already have another mysqld server running on port: 3306 ?
150803 5:48:25 [ERROR] Aborting

150803 5:48:25 [Note] InnoDB: FTS optimize thread exiting.
150803 5:48:25 [Note] InnoDB: Starting shutdown...
150803 5:48:27 [Note] InnoDB: Shutdown completed; log sequence number 1616757
150803 5:48:27 [Note] /usr/libexec/mysqld: Shutdown complete

150803 05:48:27 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
150803 06:12:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
:
150803 6:12:30 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 27568 ...
150803 6:12:30 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150803 6:12:30 [Note] InnoDB: The InnoDB memory heap is disabled
150803 6:12:30 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150803 6:12:30 [Note] InnoDB: Memory barrier is not used
150803 6:12:30 [Note] InnoDB: Compressed tables use zlib 1.2.8
150803 6:12:30 [Note] InnoDB: Using Linux native AIO
150803 6:12:30 [Note] InnoDB: Not using CPU crc32 instructions
150803 6:12:30 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150803 6:12:30 [Note] InnoDB: Completed initialization of buffer pool
150803 6:12:31 [Note] InnoDB: Highest supported file format is Barracuda.
150803 6:12:31 [Note] InnoDB: 128 rollback segment(s) are active.
150803 6:12:31 [Note] InnoDB: Waiting for purge to start
150803 6:12:31 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 1616757
150803 6:12:31 [Note] Plugin 'FEEDBACK' is disabled.
150803 6:12:32 [Note] Server socket created on IP: '::'.
150803 6:12:32 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
150803 6:12:32 [ERROR] Do you already have another mysqld server running on port: 3306 ?
150803 6:12:32 [ERROR] Aborting

150803 6:12:32 [Note] InnoDB: FTS optimize thread exiting.
150803 6:12:32 [Note] InnoDB: Starting shutdown...
150803 6:12:34 [Note] InnoDB: Shutdown completed; log sequence number 1616767
150803 6:12:34 [Note] /usr/libexec/mysqld: Shutdown complete

150803 06:12:34 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
150803 06:16:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150803 6:16:48 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 27776 ...
150803 6:16:48 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150803 6:16:48 [Note] InnoDB: The InnoDB memory heap is disabled
150803 6:16:48 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150803 6:16:48 [Note] InnoDB: Memory barrier is not used
150803 6:16:48 [Note] InnoDB: Compressed tables use zlib 1.2.8
150803 6:16:48 [Note] InnoDB: Using Linux native AIO
150803 6:16:48 [Note] InnoDB: Not using CPU crc32 instructions
150803 6:16:48 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150803 6:16:48 [Note] InnoDB: Completed initialization of buffer pool
150803 6:16:48 [Note] InnoDB: Highest supported file format is Barracuda.
150803 6:16:48 [Note] InnoDB: 128 rollback segment(s) are active.
150803 6:16:48 [Note] InnoDB: Waiting for purge to start
150803 6:16:48 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 1616767
150803 6:16:48 [Note] Plugin 'FEEDBACK' is disabled.
150803 6:16:48 [Note] Server socket created on IP: '::'.
150803 6:16:48 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
150803 6:16:48 [ERROR] Do you already have another mysqld server running on port: 3306 ?
:
150803 6:16:48 [ERROR] Aborting

150803 6:16:48 [Note] InnoDB: FTS optimize thread exiting.
150803 6:16:48 [Note] InnoDB: Starting shutdown...
150803 6:16:51 [Note] InnoDB: Shutdown completed; log sequence number 1616777
150803 6:16:51 [Note] /usr/libexec/mysqld: Shutdown complete

150803 06:16:51 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
150803 07:20:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150803 7:20:26 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 15215 ...
150803 7:20:27 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150803 7:20:27 [Note] InnoDB: The InnoDB memory heap is disabled
150803 7:20:27 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150803 7:20:27 [Note] InnoDB: Memory barrier is not used
150803 7:20:27 [Note] InnoDB: Compressed tables use zlib 1.2.8
150803 7:20:27 [Note] InnoDB: Using Linux native AIO
150803 7:20:27 [Note] InnoDB: Not using CPU crc32 instructions
150803 7:20:27 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150803 7:20:27 [Note] InnoDB: Completed initialization of buffer pool
150803 7:20:27 [Note] InnoDB: Highest supported file format is Barracuda.
150803 7:20:27 [Note] InnoDB: 128 rollback segment(s) are active.
150803 7:20:27 [Note] InnoDB: Waiting for purge to start
150803 7:20:28 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 1616777
150803 7:20:28 [Note] Plugin 'FEEDBACK' is disabled.
150803 7:20:28 [Note] Server socket created on IP: '::'.
150803 7:20:28 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
150803 7:20:28 [ERROR] Do you already have another mysqld server running on port: 3306 ?
150803 7:20:28 [ERROR] Aborting

150803 7:20:28 [Note] InnoDB: FTS optimize thread exiting.
150803 7:20:28 [Note] InnoDB: Starting shutdown...
150803 7:20:30 [Note] InnoDB: Shutdown completed; log sequence number 1616787
150803 7:20:30 [Note] /usr/libexec/mysqld: Shutdown complete

150803 07:20:30 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
150803 07:21:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150803 7:21:05 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 25667 ...
150803 7:21:05 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150803 7:21:05 [Note] InnoDB: The InnoDB memory heap is disabled
150803 7:21:05 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150803 7:21:05 [Note] InnoDB: Memory barrier is not used
150803 7:21:05 [Note] InnoDB: Compressed tables use zlib 1.2.8
150803 7:21:05 [Note] InnoDB: Using Linux native AIO
150803 7:21:05 [Note] InnoDB: Not using CPU crc32 instructions
150803 7:21:05 [Note] InnoDB: Initializing buffer pool, size = 128.0M
:
150803 7:21:05 [Note] InnoDB: Completed initialization of buffer pool
150803 7:21:05 [Note] InnoDB: Highest supported file format is Barracuda.
150803 7:21:06 [Note] InnoDB: 128 rollback segment(s) are active.
150803 7:21:06 [Note] InnoDB: Waiting for purge to start
150803 7:21:06 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 1616787
150803 7:21:06 [Note] Plugin 'FEEDBACK' is disabled.
150803 7:21:06 [Note] Server socket created on IP: '::'.
150803 7:21:06 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
150803 7:21:06 [ERROR] Do you already have another mysqld server running on port: 3306 ?
150803 7:21:06 [ERROR] Aborting

150803 7:21:06 [Note] InnoDB: FTS optimize thread exiting.
150803 7:21:06 [Note] InnoDB: Starting shutdown...
150803 7:21:08 [Note] InnoDB: Shutdown completed; log sequence number 1616797
150803 7:21:08 [Note] /usr/libexec/mysqld: Shutdown complete

150803 07:21:08 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
150803 07:22:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150803 7:22:43 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 18083 ...
150803 7:22:43 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150803 7:22:43 [Note] InnoDB: The InnoDB memory heap is disabled
150803 7:22:43 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150803 7:22:43 [Note] InnoDB: Memory barrier is not used
150803 7:22:43 [Note] InnoDB: Compressed tables use zlib 1.2.8
150803 7:22:43 [Note] InnoDB: Using Linux native AIO
150803 7:22:43 [Note] InnoDB: Not using CPU crc32 instructions
150803 7:22:43 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150803 7:22:43 [Note] InnoDB: Completed initialization of buffer pool
150803 7:22:43 [Note] InnoDB: Highest supported file format is Barracuda.
150803 7:22:43 [Note] InnoDB: 128 rollback segment(s) are active.
150803 7:22:43 [Note] InnoDB: Waiting for purge to start
150803 7:22:44 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 1616797
150803 7:22:44 [Note] Plugin 'FEEDBACK' is disabled.
150803 7:22:44 [Note] Server socket created on IP: '::'.
150803 7:22:44 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
150803 7:22:44 [ERROR] Do you already have another mysqld server running on port: 3306 ?
150803 7:22:44 [ERROR] Aborting

150803 7:22:44 [Note] InnoDB: FTS optimize thread exiting.
150803 7:22:44 [Note] InnoDB: Starting shutdown...
150803 7:22:46 [Note] InnoDB: Shutdown completed; log sequence number 1616807
150803 7:22:46 [Note] /usr/libexec/mysqld: Shutdown complete

150803 07:22:46 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
150803 07:24:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
:
150803 7:24:31 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 13944 ...
150803 7:24:31 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150803 7:24:31 [Note] InnoDB: The InnoDB memory heap is disabled
150803 7:24:31 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150803 7:24:31 [Note] InnoDB: Memory barrier is not used
150803 7:24:31 [Note] InnoDB: Compressed tables use zlib 1.2.8
150803 7:24:31 [Note] InnoDB: Using Linux native AIO
150803 7:24:31 [Note] InnoDB: Not using CPU crc32 instructions
150803 7:24:31 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150803 7:24:31 [Note] InnoDB: Completed initialization of buffer pool
150803 7:24:31 [Note] InnoDB: Highest supported file format is Barracuda.
150803 7:24:31 [Note] InnoDB: 128 rollback segment(s) are active.
150803 7:24:31 [Note] InnoDB: Waiting for purge to start
150803 7:24:31 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 1616807
150803 7:24:31 [Note] Plugin 'FEEDBACK' is disabled.
150803 7:24:31 [Note] Server socket created on IP: '::'.
150803 7:24:31 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
150803 7:24:31 [ERROR] Do you already have another mysqld server running on port: 3306 ?
150803 7:24:31 [ERROR] Aborting

150803 7:24:31 [Note] InnoDB: FTS optimize thread exiting.
150803 7:24:31 [Note] InnoDB: Starting shutdown...
150803 7:24:33 [Note] InnoDB: Shutdown completed; log sequence number 1616817
150803 7:24:34 [Note] /usr/libexec/mysqld: Shutdown complete

150803 07:24:34 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
(END)
pahanzt
Сообщения: 9
Зарегистрирован: Сб июл 18, 2015 1:23 pm
Пол: Не указан

Re: MariaDB

Сообщение pahanzt »

150803 7:22:44 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
150803 7:22:44 [ERROR] Do you already have another mysqld server running on port: 3306 ?
В логе сказано о том, что адрес уже используется. У Вас есть сервер, который уже работает? Если да, то для начала остановите его.

Чтобы проверить, работает ли сервер, воспользуйтесь коммандой ps -ef|grep mysqld or telnet 127.0.0.1 3306 и сообщите о результате.
ozhina
Сообщения: 7
Зарегистрирован: Вс авг 02, 2015 4:42 pm
Пол: Не указан

Re: MariaDB

Сообщение ozhina »

Выдает следующее:
# ps -ef|grep mysqld or telnet 127.0.0.1 3306
grep: or: Нет такого файла или каталога
grep: telnet: Нет такого файла или каталога
grep: 127.0.0.1: Нет такого файла или каталога
grep: 3306: Нет такого файла или каталога
pahanzt
Сообщения: 9
Зарегистрирован: Сб июл 18, 2015 1:23 pm
Пол: Не указан

Re: MariaDB

Сообщение pahanzt »

ozhina писал(а):Выдает следующее:
# ps -ef|grep mysqld or telnet 127.0.0.1 3306
grep: or: Нет такого файла или каталога
grep: telnet: Нет такого файла или каталога
grep: 127.0.0.1: Нет такого файла или каталога
grep: 3306: Нет такого файла или каталога
Это две разные комманды ("or" в этом случае в роли в роли выбора между вариантами комманд ). Прошу прощения, если произошло недоразумение :D .

ps -ef|grep mysqld
telnet 127.0.0.1 3306
ozhina
Сообщения: 7
Зарегистрирован: Вс авг 02, 2015 4:42 pm
Пол: Не указан

Re: MariaDB

Сообщение ozhina »

:D не только у меня мозг плавится...
вот результаты:
ps -ef|grep mysqld
root 1952 7138 0 15:30 pts/2 00:00:00 grep --color=auto mysqld
root 7000 1 0 авг02 ? 00:00:00 /bin/sh /opt/lampp/bin/mysqld_safe --datadir=/opt/lampp/var/mysql --pid-file=/opt/lampp/var/mysql/localhost.localdomain.pid
mysql 7359 7000 0 авг02 ? 00:00:21 /opt/lampp/sbin/mysqld --basedir=/opt/lampp --datadir=/opt/lampp/var/mysql --plugin-dir=/opt/lampp/lib/mysql/plugin/ --user=mysql --log-error=/opt/lampp/var/mysql/localhost.localdomain.err --pid-file=/opt/lampp/var/mysql/localhost.localdomain.pid --socket=/opt/lampp/var/mysql/mysql.sock --port=3306
Peter 21988 21986 0 авг02 ? 00:01:13 /usr/libexec/mysqld --defaults-file=/home/Peter/.local/share/akonadi/mysql.conf --datadir=/home/Peter/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-Peter.0KtauP/mysql.socket
[root@localhost Peter]# elnet 127.0.0.1 3306
bash: elnet: команда не найдена

telnet 127.0.0.1 3306
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
J
5.6.25y59_Sbq�EB]/m[aRYH;0mysql_native_passwordConnection closed by foreign host.
pahanzt
Сообщения: 9
Зарегистрирован: Сб июл 18, 2015 1:23 pm
Пол: Не указан

Re: MariaDB

Сообщение pahanzt »

Сперва остановите полностью MySQL сервер. Затем пробуйте запустить mariadb.
ozhina
Сообщения: 7
Зарегистрирован: Вс авг 02, 2015 4:42 pm
Пол: Не указан

Re: MariaDB

Сообщение ozhina »

Пропишите, пожалуйста, команды с помощью которых это выполняется!
pahanzt
Сообщения: 9
Зарегистрирован: Сб июл 18, 2015 1:23 pm
Пол: Не указан

Re: MariaDB

Сообщение pahanzt »

ozhina писал(а):Пропишите, пожалуйста, команды с помощью которых это выполняется!
Ознакомьтесь, пожалуйста, с информацией по этой ссылке и по этой
Ответить

Вернуться в «PHP, CGI, SQL»