You are not logged in.

Pages: 1

#1 2015-03-20 01:47:03

whitetimer
Member
Registered: 2010-05-23
Posts: 207

[SOLVED] MariaDB systemctl

Hi...I have just installed a clean mariadb on a fresh arch install and ran the command  sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql which returned the following

Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
150320 22:33:36 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150320 22:33:36 [Note] InnoDB: The InnoDB memory heap is disabled
150320 22:33:36 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150320 22:33:36 [Note] InnoDB: Memory barrier is not used
150320 22:33:36 [Note] InnoDB: Compressed tables use zlib 1.2.8
150320 22:33:36 [Note] InnoDB: Using Linux native AIO
150320 22:33:36 [Note] InnoDB: Using CPU crc32 instructions
150320 22:33:36 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150320 22:33:36 [Note] InnoDB: Completed initialization of buffer pool
150320 22:33:36 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
150320 22:33:36 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
150320 22:33:36 [Note] InnoDB: Database physically writes the file full: wait...
150320 22:33:36 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
150320 22:33:37 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
150320 22:33:38 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
150320 22:33:38 [Warning] InnoDB: New log files created, LSN=45781
150320 22:33:38 [Note] InnoDB: Doublewrite buffer not found: creating new
150320 22:33:38 [Note] InnoDB: Doublewrite buffer created
150320 22:33:38 [Note] InnoDB: 128 rollback segment(s) are active.
150320 22:33:38 [Warning] InnoDB: Creating foreign key constraint system tables.
150320 22:33:38 [Note] InnoDB: Foreign key constraint system tables created
150320 22:33:38 [Note] InnoDB: Creating tablespace and datafile system tables.
150320 22:33:38 [Note] InnoDB: Tablespace and datafile system tables created.
150320 22:33:38 [Note] InnoDB: Waiting for purge to start
150320 22:33:38 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 0
150320 22:33:38 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
150320 22:33:42 [Note] InnoDB: FTS optimize thread exiting.
150320 22:33:42 [Note] InnoDB: Starting shutdown...
150320 22:33:44 [Note] InnoDB: Shutdown completed; log sequence number 1616697
OK
Filling help tables...
150320 22:33:45 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150320 22:33:45 [Note] InnoDB: The InnoDB memory heap is disabled
150320 22:33:45 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150320 22:33:45 [Note] InnoDB: Memory barrier is not used
150320 22:33:45 [Note] InnoDB: Compressed tables use zlib 1.2.8
150320 22:33:45 [Note] InnoDB: Using Linux native AIO
150320 22:33:45 [Note] InnoDB: Using CPU crc32 instructions
150320 22:33:45 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150320 22:33:45 [Note] InnoDB: Completed initialization of buffer pool
150320 22:33:45 [Note] InnoDB: Highest supported file format is Barracuda.
150320 22:33:45 [Note] InnoDB: 128 rollback segment(s) are active.
150320 22:33:45 [Note] InnoDB: Waiting for purge to start
150320 22:33:45 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 1616697
150320 22:33:45 [Note] InnoDB: FTS optimize thread exiting.
150320 22:33:45 [Note] InnoDB: Starting shutdown...
150320 22:33:47 [Note] InnoDB: Shutdown completed; log sequence number 1616707
OK

Then I tried systemctl start mysqld and got this error 

Subject: Unit mysqld.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mysqld.service has failed.
-- 
-- The result is failed.
Mar 20 22:42:26 Julian-Notebook systemd[1]: Unit mysqld.service entered failed state.
Mar 20 22:42:26 Julian-Notebook systemd[1]: mysqld.service failed.
Mar 20 22:42:26 Julian-Notebook systemd[1]: mysqld.service holdoff time over, scheduling restart.
Mar 20 22:42:26 Julian-Notebook systemd[1]: Stopping MariaDB database server...
-- Subject: Unit mysqld.service has begun shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mysqld.service has begun shutting down.
Mar 20 22:42:26 Julian-Notebook systemd[1]: Starting MariaDB database server...
-- Subject: Unit mysqld.service has begun with start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mysqld.service has begun starting up.
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] InnoDB: The InnoDB memory heap is disabled
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] InnoDB: Memory barrier is not used
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] InnoDB: Compressed tables use zlib 1.2.8
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] InnoDB: Using Linux native AIO
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] InnoDB: Using CPU crc32 instructions
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] InnoDB: Completed initialization of buffer pool
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] InnoDB: Highest supported file format is Barracuda.
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] InnoDB: 128 rollback segment(s) are active.
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] InnoDB: Waiting for purge to start
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence n
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] Plugin 'FEEDBACK' is disabled.
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] Server socket created on IP: '::'.
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] Event Scheduler: Loaded 0 events
Mar 20 22:42:26 Julian-Notebook mysqld[712]: 150320 22:42:26 [Note] /usr/bin/mysqld: ready for connections.
Mar 20 22:42:26 Julian-Notebook mysqld[712]: Version: '10.0.17-MariaDB-log'  socket: '/run/mysqld/mysqld.sock'  port: 3306  MariaDB Server

If I look in journalctl -xe i have this message 

● mysqld.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: activating (start-post) since Fri 2015-03-20 22:43:59 ACDT; 50s ago
 Main PID: 1379 (mysqld);         : 1380 (mysqld-post)
   CGroup: /system.slice/mysqld.service
           ├─1379 /usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid
           └─control
             ├─1380 /bin/sh /usr/bin/mysqld-post
             └─1766 sleep 1

Mar 20 22:43:59 Julian-Notebook mysqld[1379]: 150320 22:43:59 [Note] InnoDB: Completed initial...ool
Mar 20 22:43:59 Julian-Notebook mysqld[1379]: 150320 22:43:59 [Note] InnoDB: Highest supported...da.
Mar 20 22:43:59 Julian-Notebook mysqld[1379]: 150320 22:43:59 [Note] InnoDB: 128 rollback segm...ve.
Mar 20 22:43:59 Julian-Notebook mysqld[1379]: 150320 22:43:59 [Note] InnoDB: Waiting for purge...art
Mar 20 22:43:59 Julian-Notebook mysqld[1379]: 150320 22:43:59 [Note] InnoDB:  Percona XtraDB (...737
Mar 20 22:43:59 Julian-Notebook mysqld[1379]: 150320 22:43:59 [Note] Plugin 'FEEDBACK' is disabled.
Mar 20 22:43:59 Julian-Notebook mysqld[1379]: 150320 22:43:59 [Note] Server socket created on ...:'.
Mar 20 22:43:59 Julian-Notebook mysqld[1379]: 150320 22:43:59 [Note] Event Scheduler: Loaded 0...nts
Mar 20 22:43:59 Julian-Notebook mysqld[1379]: 150320 22:43:59 [Note] /usr/bin/mysqld: ready fo...ns.
Mar 20 22:43:59 Julian-Notebook mysqld[1379]: Version: '10.0.17-MariaDB-log'  socket: '/run/my...ver
Hint: Some lines were ellipsized, use -l to show in full.

Any suggestions as to why the service wont start ?

Many thanks

Last edited by whitetimer (2015-03-20 22:07:23)

Offline

#2 2015-03-20 01:56:16

nullified
Member
From: Massachusetts, USA
Registered: 2013-12-09
Posts: 468

Re: [SOLVED] MariaDB systemctl

I ran into a similar issue when first installing, and it turned out to be a permissions problem: https://wiki.archlinux.org/index.php/My … nnot_start

Have you checked the permissions as the wiki advises?

"We may say most aptly, that the Analytical Engine weaves algebraical patterns just as the Jacquard-loom weaves flowers and leaves." - Ada Lovelace

Offline

#3 2015-03-20 02:35:02

karol
Archivist
Registered: 2009-05-06
Posts: 25,440

Re: [SOLVED] MariaDB systemctl

Are you sure you're reading the logs right? It says it's loaded and activating.


A bit OT, but I've noticed https://bbs.archlinux.org/viewtopic.php?id=193292 is marked as solved, even though I can't find the solution in there ...

Offline

#4 2015-03-20 03:45:06

whitetimer
Member
Registered: 2010-05-23
Posts: 207

Re: [SOLVED] MariaDB systemctl

After 3 hours is still activating

Last edited by whitetimer (2015-03-20 03:46:03)

Offline

#5 2015-03-20 03:48:28

nullified
Member
From: Massachusetts, USA
Registered: 2013-12-09
Posts: 468

Re: [SOLVED] MariaDB systemctl

Did you see my post? Also, what is the output of 

systemctl status mysqld.service

"We may say most aptly, that the Analytical Engine weaves algebraical patterns just as the Jacquard-loom weaves flowers and leaves." - Ada Lovelace

Offline

#6 2015-03-20 07:28:33

whitetimer
Member
Registered: 2010-05-23
Posts: 207

Re: [SOLVED] MariaDB systemctl

nullified wrote:

Did you see my post? Also, what is the output of 

systemctl status mysqld.service

Yes I did and this is still the output 

 mysqld.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: activating (start-post) since Fri 2015-03-20 18:03:05 ACDT; 17s ago
 Main PID: 4266 (mysqld);         : 4267 (mysqld-post)
   CGroup: /system.slice/mysqld.service
           ├─4266 /usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid
           └─control
             ├─4267 /bin/sh /usr/bin/mysqld-post
             └─4418 sleep 1

Mar 20 18:03:05 Julian-Notebook mysqld[4266]: 150320 18:03:05 [Note] InnoDB: Completed initialization of buffer pool
Mar 20 18:03:05 Julian-Notebook mysqld[4266]: 150320 18:03:05 [Note] InnoDB: Highest supported file format is Barracuda.
Mar 20 18:03:05 Julian-Notebook mysqld[4266]: 150320 18:03:05 [Note] InnoDB: 128 rollback segment(s) are active.
Mar 20 18:03:05 Julian-Notebook mysqld[4266]: 150320 18:03:05 [Note] InnoDB: Waiting for purge to start
Mar 20 18:03:05 Julian-Notebook mysqld[4266]: 150320 18:03:05 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 1616963
Mar 20 18:03:05 Julian-Notebook mysqld[4266]: 150320 18:03:05 [Note] Plugin 'FEEDBACK' is disabled.
Mar 20 18:03:05 Julian-Notebook mysqld[4266]: 150320 18:03:05 [Note] Server socket created on IP: '::'.
Mar 20 18:03:05 Julian-Notebook mysqld[4266]: 150320 18:03:05 [Note] Event Scheduler: Loaded 0 events
Mar 20 18:03:05 Julian-Notebook mysqld[4266]: 150320 18:03:05 [Note] /usr/bin/mysqld: ready for connections.
Mar 20 18:03:05 Julian-Notebook mysqld[4266]: Version: '10.0.17-MariaDB-log'  socket: '/run/mysqld/mysqld.sock'  port: 3306  MariaDB Server

Offline

Pages: 1

Board footer

Powered by FluxBB