Cannot stop mariadb service

runtomaker · 2019-03-11 16:32:01

Hello, I trying stopping mariadb service when waiting to long. System when shutdown waiting to stop mariadb service.

Status service:

● mariadb.service - MariaDB 10.3.13 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: deactivating (stop-sigterm) since Mon 2019-03-11 19:28:21 +03; 7s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 566 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 614 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 662 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 627 (mysqld)
   Status: "Waiting for page cleaner"
    Tasks: 16 (limit: 4915)
   Memory: 101.4M
   CGroup: /system.slice/mariadb.service
           └─627 /usr/bin/mysqld

Mar 11 22:23:33 arch mysqld[627]: 2019-03-11 22:23:33 0 [Note] /usr/bin/mysqld: ready for connections.
Mar 11 22:23:33 arch mysqld[627]: Version: '10.3.13-MariaDB'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Source distribution
Mar 11 22:23:33 arch systemd[1]: Started MariaDB 10.3.13 database server.
Mar 11 19:28:21 arch mysqld[627]: 2019-03-11 19:28:21 0 [Note] /usr/bin/mysqld (initiated by: unknown): Normal shutdown
Mar 11 19:28:21 arch systemd[1]: Stopping MariaDB 10.3.13 database server...
Mar 11 19:28:21 arch mysqld[627]: 2019-03-11 19:28:21 0 [Note] Event Scheduler: Purging the queue. 0 events
Mar 11 19:28:21 arch mysqld[627]: 2019-03-11 19:28:21 0 [Note] InnoDB: FTS optimize thread exiting.
Mar 11 19:28:21 arch mysqld[627]: 2019-03-11 19:28:21 0 [Note] InnoDB: Starting shutdown...
Mar 11 19:28:21 arch mysqld[627]: 2019-03-11 19:28:21 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Mar 11 19:28:21 arch mysqld[627]: 2019-03-11 19:28:21 0 [Note] InnoDB: Buffer pool(s) dump completed at 190311 19:28:21

Last edited by runtomaker (2019-03-19 00:01:38)

jasonwryan · 2019-03-11 16:52:52

Not a Pacman issue. moving to NC...

runtomaker · 2019-03-11 17:00:23

jasonwryan wrote:

Not a Pacman issue. moving to NC...

Thanks.

Last edited by runtomaker (2019-03-11 17:00:42)

runtomaker · 2019-03-11 17:04:55

Extra logs. In loops this stopping event.

Mar 11 19:54:25 arch mysqld[627]: 2019-03-11 19:54:25 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
Mar 11 19:55:25 arch mysqld[627]: 2019-03-11 19:55:25 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
Mar 11 19:56:25 arch mysqld[627]: 2019-03-11 19:56:25 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
Mar 11 19:57:25 arch mysqld[627]: 2019-03-11 19:57:25 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
Mar 11 19:58:26 arch mysqld[627]: 2019-03-11 19:58:26 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
Mar 11 19:59:26 arch mysqld[627]: 2019-03-11 19:59:26 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
Mar 11 20:00:26 arch mysqld[627]: 2019-03-11 20:00:26 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
Mar 11 20:01:26 arch mysqld[627]: 2019-03-11 20:01:26 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
Mar 11 20:02:26 arch mysqld[627]: 2019-03-11 20:02:26 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
Mar 11 20:03:26 arch mysqld[627]: 2019-03-11 20:03:26 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool

Last edited by runtomaker (2019-03-11 19:08:40)

WorMzy · 2019-03-11 17:40:37

Please don't multi-post. If you are the last person to post, use the edit button to append more information. You also forgot to use code tags in your last post; please edit the post and add them in.

Last edited by WorMzy (2019-03-11 19:10:48)

Trilby · 2019-03-11 19:00:35

Did you google that error at all? I get a lot of results, many with what look to be solutions. Which ones have you tried?

Last edited by Trilby (2019-03-11 19:00:47)

runtomaker · 2019-03-11 19:06:49

Trilby wrote:

Did you google that error at all? I get a lot of results, many with what look to be solutions. Which ones have you tried?

I no found any solution. You can share solutions ?

Last edited by runtomaker (2019-03-11 19:07:23)

runtomaker · 2019-03-12 17:19:12

Reinstalled database and problem are solved.

In: https://wiki.archlinux.org/index.php/MariaDB

# mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

# mysql_secure_installation

Last edited by runtomaker (2019-03-12 17:19:35)

WorMzy · 2019-03-12 17:36:37

Please remember to mark your thread as solved by editing the first post and amending the topic title.

runtomaker · 2019-03-19 00:00:59

Same issue there. This issue not fixed...

redacted for mariadb

jasonwryan · 2019-03-19 00:19:15

Don't do that. It's trolling. Final warning.

https://wiki.archlinux.org/index.php/Co … o_trolling

Closing

Arch Linux

#1 2019-03-11 16:32:01

Cannot stop mariadb service

#2 2019-03-11 16:52:52

Re: Cannot stop mariadb service

#3 2019-03-11 17:00:23

Re: Cannot stop mariadb service

#4 2019-03-11 17:04:55

Re: Cannot stop mariadb service

#5 2019-03-11 17:40:37

Re: Cannot stop mariadb service

#6 2019-03-11 19:00:35

Re: Cannot stop mariadb service

#7 2019-03-11 19:06:49

Re: Cannot stop mariadb service

#8 2019-03-12 17:19:12

Re: Cannot stop mariadb service

#9 2019-03-12 17:36:37

Re: Cannot stop mariadb service

#10 2019-03-19 00:00:59

Re: Cannot stop mariadb service

#11 2019-03-19 00:19:15

Re: Cannot stop mariadb service

Board footer