Boston Linux & UNIX was originally founded in 1994 as part of The Boston Computer Society. We meet on the third Wednesday of each month, online, via Jitsi Meet.

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Discuss] mysql problem



It will disappear - it's part of tmpfs which is memory.
Is /run 755?
Do you have selinux enabled?
What does getenforce return?


-----Original Message-----
From: Discuss [mailto:discuss-bounces+joe=polcari.com at blu.org] On Behalf Of
dan moylan
Sent: Friday, February 02, 2018 2:55 PM
To: boston linux and unix (blu)
Cc: betty moylan
Subject: Re: [Discuss] mysql problem


joe polcari writes:

> What's the mysqld log say?

> -----Original Message-----

> running fc26 on acer aspire laptop
> using mariadb

> mysql been running fine for months.

> suddenly:

> # mysql

> ERROR 2002 (HY000): Can't connect to local MySQL server
> through socket '/var/lib/mysql/mysql.sock' (111 "Connection
> refused")

>     .
>     .
>     .

here's a segment of /var/log/mariadb/mariadb.log

2018-01-28 15:47:06 140045973009600 [Note] Plugin 'FEEDBACK' is disabled.
2018-01-28 15:47:07 140045973009600 [Note] Server socket created on IP:
'::'.
2018-01-28 15:47:07 140045973009600 [Note] /usr/libexec/mysqld: ready for
connections.
Version: '10.1.30-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306
MariaDB Server
2018-02-01 13:01:35 140045972228864 [Note] /usr/libexec/mysqld: Normal
shutdown
2018-02-01 13:01:47 140045972228864 [Note] Event Scheduler: Purging the
queue. 0 events
2018-02-01 13:03:09 140045266708224 [Note] InnoDB: FTS optimize thread
exiting.
2018-02-01 13:03:09 140045972228864 [Note] InnoDB: Starting shutdown...
2018-02-01 13:03:11 140045972228864 [Note] InnoDB: Waiting for page_cleaner
to finish flushing of buffer pool
2018-02-01 13:03:49 140045972228864 [Note] InnoDB: Shutdown completed; log
sequence number 1819735
2018-02-01 13:03:52 140045972228864 [Note] /usr/libexec/mysqld: Shutdown
complete

2018-02-01 14:21:28 139831392437440 [Note] InnoDB:
innodb_empty_free_list_algorithm has been changed to legacy because of small
buffer pool size. In order to use backoff, increase buffer pool at least up
to 20MB.

2018-02-01 14:21:28 139831392437440 [Note] InnoDB: Using mutexes to ref
count buffer pool pages
2018-02-01 14:21:28 139831392437440 [Note] InnoDB: The InnoDB memory heap is
disabled
2018-02-01 14:21:28 139831392437440 [Note] InnoDB: Mutexes and rw_locks use
GCC atomic builtins
2018-02-01 14:21:28 139831392437440 [Note] InnoDB: GCC builtin
__atomic_thread_fence() is used for memory barrier
2018-02-01 14:21:28 139831392437440 [Note] InnoDB: Compressed tables use
zlib 1.2.11
2018-02-01 14:21:28 139831392437440 [Note] InnoDB: Using Linux native AIO
2018-02-01 14:21:29 139831392437440 [Note] InnoDB: Using generic crc32
instructions
2018-02-01 14:21:29 139831392437440 [Note] InnoDB: Initializing buffer pool,
size = 128.0M
2018-02-01 14:21:29 139831392437440 [Note] InnoDB: Completed initialization
of buffer pool
2018-02-01 14:21:29 139831392437440 [Note] InnoDB: Highest supported file
format is Barracuda.
2018-02-01 14:21:31 139831392437440 [Note] InnoDB: 128 rollback segment(s)
are active.
2018-02-01 14:21:31 139831392437440 [Note] InnoDB: Waiting for purge to
start
2018-02-01 14:21:31 139831392437440 [Note] InnoDB:  Percona XtraDB
(http://www.percona.com) 5.6.36-82.2 started; log sequence number 1819735
2018-02-01 14:21:38 139830732252928 [Note] InnoDB: Dumping buffer pool(s)
not yet started
2018-02-01 14:21:38 139831392437440 [Note] Plugin 'FEEDBACK' is disabled.
2018-02-01 14:21:39 139831392437440 [Note] Server socket created on IP:
'::'.
2018-02-01 14:21:39 139831392271104 [ERROR] mysqld: Can't create/write to
file '/run/mariadb/mariadb.pid' (Errcode: 2 "No such file or directory")
2018-02-01 14:21:39 139831392271104 [ERROR] Can't start server: can't create
PID file: No such file or directory
2018-02-01 15:32:38 140015635989696 [Note] InnoDB:
innodb_empty_free_list_algorithm has been changed to legacy because of small
buffer pool size. In order to use backoff, increase buffer pool at least up
to 20MB.

don't quite know what to make of it.  fwiw /run/mariadb/
didn't exist so i created it, but after reboot it was gone.

tnx,
ole dan

j. daniel moylan
84 harvard ave
brookline, ma 02446-6202
617-777-0207 (cel)
jdm at moylan.us
www.moylan.us
[no html pls]
_______________________________________________
Discuss mailing list
Discuss at blu.org
http://lists.blu.org/mailman/listinfo/discuss


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus




BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org