MySQL se mi furt odpojuje a shazuje....

GIGAADAM

MAJITEL SERVERU (a Java Developer :))
Zpráv
96
Bodů
199
Místo
AVERNON.EU
Servery
play.avernon.eu
ts3.avernon.eu
www.avernon.eu
Dobrý večer,

mam tady problem, reinstaloval jsem MySQL Server na mem VPS (Ubuntu 18.04),

a kdyz upravuji dejme temu NamelessMC nebo neco jiného spadne... a nebo nekdy nespadne ale az za nějakou dobu,

Status mysql.service:

● mariadb.service - MariaDB 10.4.13 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: timeout) since Fri 2020-06-26 22:03:18 CEST; 19s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 11043 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 11034 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl
set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 11032 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 11022 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 11043 (code=exited, status=0/SUCCESS)

Jun 26 22:03:18 ns54546 mysqld[11043]: 2020-06-26T20:03:18.851836Z 0 [Note] InnoDB: Shutdown completed; log sequence number 5137530
Jun 26 22:03:18 ns54546 mysqld[11043]: 2020-06-26T20:03:18.854437Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Jun 26 22:03:18 ns54546 mysqld[11043]: 2020-06-26T20:03:18.855439Z 0 [Note] Shutting down plugin 'MEMORY'
Jun 26 22:03:18 ns54546 mysqld[11043]: 2020-06-26T20:03:18.855591Z 0 [Note] Shutting down plugin 'CSV'
Jun 26 22:03:18 ns54546 mysqld[11043]: 2020-06-26T20:03:18.855719Z 0 [Note] Shutting down plugin 'sha256_password'
Jun 26 22:03:18 ns54546 mysqld[11043]: 2020-06-26T20:03:18.855843Z 0 [Note] Shutting down plugin 'mysql_native_password'
Jun 26 22:03:18 ns54546 mysqld[11043]: 2020-06-26T20:03:18.856115Z 0 [Note] Shutting down plugin 'binlog'
Jun 26 22:03:18 ns54546 mysqld[11043]: 2020-06-26T20:03:18.856857Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
Jun 26 22:03:18 ns54546 systemd[1]: mariadb.service: Failed with result 'timeout'.
Jun 26 22:03:18 ns54546 systemd[1]: Failed to start MariaDB 10.4.13 database server.


Chyba co vyhazuje MySQL:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

předem děkuji za odpovědi a pomoc,

GigaAdamYT (Majitel serveru AVERNON)
 

GIGAADAM

MAJITEL SERVERU (a Java Developer :))
Zpráv
96
Bodů
199
Místo
AVERNON.EU
Servery
play.avernon.eu
ts3.avernon.eu
www.avernon.eu
Nevěděl by někdo jak to nějak opravovat
 

Mike8748

VIP
VIP
Zpráv
169
Bodů
379
parametry vps? mas dost ram?
hodil by se trosku delsi kus logu mariadb sluzby, v tom co si postnul je jen videt ze se server vypnul, ne proc
 

GIGAADAM

MAJITEL SERVERU (a Java Developer :))
Zpráv
96
Bodů
199
Místo
AVERNON.EU
Servery
play.avernon.eu
ts3.avernon.eu
www.avernon.eu
10GB RAM, 2 CPU, Ubuntu, a ano ramky je furt dost na mysql,

log poslu pozdeji jsem pryc

---- Automaticky sloučená zpráva ----

Něco jsem nasel:

Kód:
Jun 28 21:10:15 ns54546 sshd[4259]: error: maximum authentication attempts exceeded for root from 222.186.175.202 port 6718 ssh2 [preauth]

Jun 28 21:10:15 ns54546 sshd[4259]: Disconnecting authenticating user root 222.186.175.202 port 6718: Too many authentication failures [preauth]
Jun 28 21:10:15 ns54546 sshd[4259]: PAM 5 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=222.186.175.202  user=roo
t
Jun 28 21:10:15 ns54546 sshd[4259]: PAM service(sshd) ignoring max retries; 6 > 3
Jun 28 21:10:15 ns54546 mysqld[3969]: 2020-06-28T19:10:15.934208Z 88 [Note] Access denied for user 'mc'@'localhost' (using password: YES)
Jun 28 21:10:18 ns54546 sshd[4282]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=222.186.175.202
 user=root
Jun 28 21:10:20 ns54546 sshd[4282]: Failed password for root from 222.186.175.202 port 20486 ssh2
Jun 28 21:10:20 ns54546 mysqld[3969]: 2020-06-28T19:10:20.953769Z 89 [Note] Access denied for user 'mc'@'localhost' (using password: YES)
Jun 28 21:10:21 ns54546 sshd[4282]: Received disconnect from 222.186.175.202 port 20486:11:  [preauth]
Jun 28 21:10:21 ns54546 sshd[4282]: Disconnected from authenticating user root 222.186.175.202 port 20486 [preauth]
Jun 28 21:10:25 ns54546 mysqld[3969]: 2020-06-28T19:10:25.974405Z 92 [Note] Access denied for user 'mc'@'localhost' (using password: YES)
Jun 28 21:10:31 ns54546 mysqld[3969]: 2020-06-28T19:10:31.002879Z 103 [Note] Access denied for user 'mc'@'localhost' (using password: YES)

Jun 28 21:10:36 ns54546 mysqld[3969]: 2020-06-28T19:10:36.026712Z 108 [Note] Access denied for user 'mc'@'localhost' (using password: YES)

Jun 28 21:10:41 ns54546 mysqld[3969]: 2020-06-28T19:10:41.045516Z 111 [Note] Access denied for user 'mc'@'localhost' (using password: YES)

Jun 28 21:10:42 ns54546 sshd[4302]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=112.85.42.194  u
ser=root
Jun 28 21:10:44 ns54546 sshd[4302]: Failed password for root from 112.85.42.194 port 48615 ssh2
Jun 28 21:10:46 ns54546 mysqld[3969]: 2020-06-28T19:10:46.070383Z 116 [Note] Access denied for user 'mc'@'localhost' (using password: YES)

Jun 28 21:10:46 ns54546 sshd[4302]: Failed password for root from 112.85.42.194 port 48615 ssh2
Jun 28 21:10:48 ns54546 sshd[4302]: Failed password for root from 112.85.42.194 port 48615 ssh2
Jun 28 21:10:49 ns54546 sshd[4302]: Received disconnect from 112.85.42.194 port 48615:11:  [preauth]
Jun 28 21:10:49 ns54546 sshd[4302]: Disconnected from authenticating user root 112.85.42.194 port 48615 [preauth]
Jun 28 21:10:49 ns54546 sshd[4302]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=112.85.42.194  user=root

Jun 28 21:10:51 ns54546 mysqld[3969]: 2020-06-28T19:10:51.083044Z 119 [Note] Access denied for user 'mc'@'localhost' (using password: YES)

Jun 28 21:10:56 ns54546 mysqld[3969]: 2020-06-28T19:10:56.100810Z 122 [Note] Access denied for user 'mc'@'localhost' (using password: YES)

Jun 28 21:11:01 ns54546 mysqld[3969]: 2020-06-28T19:11:01.127150Z 134 [Note] Access denied for user 'mc'@'localhost' (using password: YES)
 
Poslední změna:

Yoshino

Stará garda
Zpráv
156
Bodů
434
Nevidim tam ziaden dovod, preco by mala cela ta sluzba spadnut. Tie oznamenia sa len tykaju toho, ze sa nepodarilo prihlasit uzivatelovi mc.
 

GIGAADAM

MAJITEL SERVERU (a Java Developer :))
Zpráv
96
Bodů
199
Místo
AVERNON.EU
Servery
play.avernon.eu
ts3.avernon.eu
www.avernon.eu
Nevidim tam ziaden dovod, preco by mala cela ta sluzba spadnut. Tie oznamenia sa len tykaju toho, ze sa nepodarilo prihlasit uzivatelovi mc.
Moc děkuji, že jsi mi odpověděl, ale furt nevim proc mi to pada, a štve měto, na MySQL jede LuckPerms, AuthMe, NamelessMC, Ticket system atd...
Tím pádem, nemuže se na serverech pracovat, jinak Yoshino, klidně ti povolím se na to podívat, třeba přes AnyDesk nebo TeamViewer, bylo by to skvělé. A moc by ti všichni děkovali :)

---- Automaticky sloučená zpráva ----

na ts3: ts3.avernon.eu

---- Automaticky sloučená zpráva ----

Ok už jsem to asi nasel:

Kód:
Jun 29 14:17:54 ns54546 systemd[1]: Starting MariaDB 10.4.13 database server...
Jun 29 14:17:55 ns54546 mysqld[14341]: my_print_defaults: [ERROR] unknown option '--mysqld'
Jun 29 14:17:57 ns54546 mysqld[14352]: 2020-06-29T12:17:56.751389Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please u
se --explicit_defaults_for_timestamp server option (see documentation for more details).
Jun 29 14:17:57 ns54546 mysqld[14352]: 2020-06-29T12:17:56.771741Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.30-0ubuntu0.18.04.1) starting as pr
ocess 14352 ...
Jun 29 14:17:57 ns54546 mysqld[14352]: 2020-06-29T12:17:57.107213Z 0 [Note] InnoDB: PUNCH HOLE support available
Jun 29 14:17:57 ns54546 mysqld[14352]: 2020-06-29T12:17:57.107256Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jun 29 14:17:57 ns54546 mysqld[14352]: 2020-06-29T12:17:57.107264Z 0 [Note] InnoDB: Uses event mutexes
Jun 29 14:17:57 ns54546 mysqld[14352]: 2020-06-29T12:17:57.107270Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory b
arrier--
Jun 29 14:17:57 ns54546 mysqld[14352]: 2020-06-29T12:17:57.107277Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Jun 29 14:17:57 ns54546 mysqld[14352]: 2020-06-29T12:17:57.107283Z 0 [Note] InnoDB: Using Linux native AIO
Jun 29 14:17:57 ns54546 mysqld[14352]: 2020-06-29T12:17:57.122841Z 0 [Note] InnoDB: Number of pools: 1
Jun 29 14:17:57 ns54546 mysqld[14352]: 2020-06-29T12:17:57.161106Z 0 [Note] InnoDB: Using CPU crc32 instructions
Jun 29 14:17:57 ns54546 mysqld[14352]: 2020-06-29T12:17:57.164311Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances =
 1, chunk size = 128M
Jun 29 14:17:57 ns54546 mysqld[14352]: 2020-06-29T12:17:57.232635Z 0 [Note] InnoDB: Completed initialization of buffer pool
Jun 29 14:17:57 ns54546 mysqld[14352]: 2020-06-29T12:17:57.241430Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner
 thread priority can be changed. See the man page of setpriority().
Jun 29 14:17:57 ns54546 mysqld[14352]: 2020-06-29T12:17:57.329798Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
Jun 29 14:17:57 ns54546 mysqld[14352]: 2020-06-29T12:17:57.970957Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Jun 29 14:17:57 ns54546 mysqld[14352]: 2020-06-29T12:17:57.971797Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writin
g the file full; Please wait ...
Jun 29 14:17:58 ns54546 mysqld[14352]: 2020-06-29T12:17:58.187577Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Jun 29 14:17:58 ns54546 mysqld[14352]: 2020-06-29T12:17:58.188652Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segm
ent(s) are active.
Jun 29 14:17:58 ns54546 mysqld[14352]: 2020-06-29T12:17:58.188666Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
Jun 29 14:17:58 ns54546 mysqld[14352]: 2020-06-29T12:17:58.189174Z 0 [Note] InnoDB: Waiting for purge to start
Jun 29 14:17:58 ns54546 mysqld[14352]: 2020-06-29T12:17:58.239375Z 0 [Note] InnoDB: 5.7.30 started; log sequence number 13256183
Jun 29 14:17:58 ns54546 mysqld[14352]: 2020-06-29T12:17:58.239986Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_poo
l
Jun 29 14:17:58 ns54546 mysqld[14352]: 2020-06-29T12:17:58.332468Z 0 [Note] Plugin 'FEDERATED' is disabled.
Jun 29 14:17:58 ns54546 mysqld[14352]: 2020-06-29T12:17:58.519570Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directo
ry. Trying to enable SSL support using them.
Jun 29 14:17:58 ns54546 mysqld[14352]: 2020-06-29T12:17:58.521266Z 0 [Note] Skipping generation of SSL certificates as certificate files are
 present in data directory.
Jun 29 14:17:58 ns54546 mysqld[14352]: 2020-06-29T12:17:58.553516Z 0 [Warning] CA certificate ca.pem is self signed.
Jun 29 14:17:58 ns54546 mysqld[14352]: 2020-06-29T12:17:58.556717Z 0 [Note] Skipping generation of RSA key pair as key files are present in
data directory.
Jun 29 14:17:58 ns54546 mysqld[14352]: 2020-06-29T12:17:58.563408Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
Jun 29 14:17:58 ns54546 mysqld[14352]: 2020-06-29T12:17:58.563808Z 0 [Note] IPv6 is available.
Jun 29 14:17:58 ns54546 mysqld[14352]: 2020-06-29T12:17:58.563954Z 0 [Note]   - '::' resolves to '::';
Jun 29 14:17:58 ns54546 mysqld[14352]: 2020-06-29T12:17:58.564123Z 0 [Note] Server socket created on IP: '::'.
Jun 29 14:17:59 ns54546 mysqld[14352]: 2020-06-29T12:17:59.160599Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200629 14:17:59
Jun 29 14:17:59 ns54546 mysqld[14352]: 2020-06-29T12:17:59.369305Z 0 [Note] Event Scheduler: Loaded 0 events
Jun 29 14:17:59 ns54546 mysqld[14352]: 2020-06-29T12:17:59.369720Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Jun 29 14:17:59 ns54546 mysqld[14352]: Version: '5.7.30-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
---- Automaticky sloučená zpráva ----

A další nález:
Kód:
Jun 29 14:32:55 ns54546 systemd[1]: mariadb.service: Start operation timed out. Terminating.
Jun 29 14:32:55 ns54546 mysqld[14352]: 2020-06-29T12:32:55.195620Z 0 [Note] Giving 91 client threads a chance to die gracefully
Jun 29 14:32:55 ns54546 mysqld[14352]: 2020-06-29T12:32:55.195775Z 0 [Note] Shutting down slave threads
Jun 29 14:32:55 ns54546 sshd[15386]: Failed password for root from 222.186.190.14 port 61315 ssh2
Jun 29 14:32:56 ns54546 sshd[15384]: Failed password for root from 112.85.42.194 port 12527 ssh2
Jun 29 14:32:56 ns54546 sshd[15386]: Failed password for root from 222.186.190.14 port 61315 ssh2
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.195862Z 0 [Note] Forcefully disconnecting 82 remaining clients
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.195902Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 6  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.195949Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 38  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.195993Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196029Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 86  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196058Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 389  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196084Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 5  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196108Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 7  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196133Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 39  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196158Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 55  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196183Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 87  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196208Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 391  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196232Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 3  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196257Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 9  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196282Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 25  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196307Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 41  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196332Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 57  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196356Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 73  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196389Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 89  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196418Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 4  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196452Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 8  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196478Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 24  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196511Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 40  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196539Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 56  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196571Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 72  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196595Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 88  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196636Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 11  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196668Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 27  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196694Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 43  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196719Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 59  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196744Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 75  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196768Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 91  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196793Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 2  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196817Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 10  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196841Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 26  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196866Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 42  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196891Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 58  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196914Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 74  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196937Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 90  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196961Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 13  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.196992Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 45  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197017Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 61  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197041Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 77  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197064Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 93  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197087Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 12  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197112Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 28  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197135Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 44  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197159Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 60  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197183Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 76  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197206Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 92  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197231Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 15  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197256Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 47  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197280Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 387  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197304Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 79  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197327Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 14  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197352Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 30  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197384Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 46  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.197408Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 78  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.199298Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 388  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.199333Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 17  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.199433Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 49  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.199521Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 390  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.199552Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 81  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.199578Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 16  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.199665Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 48  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.199694Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 392  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.199718Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 80  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.199810Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 18  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.199920Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 34  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.200012Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 50  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.200041Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 19  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.200066Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 35  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.200160Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 51  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.200190Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 394  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.200224Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 20  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.200314Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 36  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.200343Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 52  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.200368Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 386  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.200435Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 21  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.200523Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 37  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.200552Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 53  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.200645Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 393  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.200674Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 85  user: 'mc'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.200946Z 0 [Note] Event Scheduler: Purging the queue. 0 events
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.216671Z 0 [Note] Binlog end
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218806Z 0 [Note] Shutting down plugin 'ngram'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218821Z 0 [Note] Shutting down plugin 'partition'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218828Z 0 [Note] Shutting down plugin 'BLACKHOLE'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218841Z 0 [Note] Shutting down plugin 'ARCHIVE'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218848Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218891Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218899Z 0 [Note] Shutting down plugin 'MyISAM'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218908Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218918Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218925Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218930Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218935Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218939Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218944Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218949Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218954Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218959Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218964Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218968Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218973Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218978Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218982Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218987Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218992Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.218997Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.219001Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.219006Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.228008Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.228018Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.228024Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.228029Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.228034Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.228039Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.228044Z 0 [Note] Shutting down plugin 'INNODB_CMP'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.228049Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.228054Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.228060Z 0 [Note] Shutting down plugin 'INNODB_TRX'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.228065Z 0 [Note] Shutting down plugin 'InnoDB'
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.233843Z 0 [Note] InnoDB: FTS optimize thread exiting.
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.234095Z 0 [Note] InnoDB: Starting shutdown...
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.335145Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
0m
Jun 29 14:32:57 ns54546 mysqld[14352]: 2020-06-29T12:32:57.335457Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200629 14:32:57
Jun 29 14:32:58 ns54546 sshd[15384]: Failed password for root from 112.85.42.194 port 12527 ssh2
Jun 29 14:32:58 ns54546 mysqld[14352]: 2020-06-29T12:32:58.560099Z 0 [Note] InnoDB: Shutdown completed; log sequence number 13257415
Jun 29 14:32:58 ns54546 mysqld[14352]: 2020-06-29T12:32:58.573254Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Jun 29 14:32:58 ns54546 mysqld[14352]: 2020-06-29T12:32:58.573987Z 0 [Note] Shutting down plugin 'MEMORY'
Jun 29 14:32:58 ns54546 mysqld[14352]: 2020-06-29T12:32:58.574160Z 0 [Note] Shutting down plugin 'CSV'
Jun 29 14:32:58 ns54546 mysqld[14352]: 2020-06-29T12:32:58.574542Z 0 [Note] Shutting down plugin 'sha256_password'
Jun 29 14:32:58 ns54546 mysqld[14352]: 2020-06-29T12:32:58.574717Z 0 [Note] Shutting down plugin 'mysql_native_password'
Jun 29 14:32:58 ns54546 mysqld[14352]: 2020-06-29T12:32:58.575171Z 0 [Note] Shutting down plugin 'binlog'
Jun 29 14:32:58 ns54546 mysqld[14352]: 2020-06-29T12:32:58.577382Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
Jun 29 14:32:58 ns54546 sshd[15384]: Received disconnect from 112.85.42.194 port 12527:11:  [preauth]
Jun 29 14:32:58 ns54546 sshd[15384]: Disconnected from authenticating user root 112.85.42.194 port 12527 [preauth]
Jun 29 14:32:58 ns54546 sshd[15384]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=112.85.42.194  user=root

Jun 29 14:32:58 ns54546 systemd[1]: mariadb.service: Failed with result 'timeout'.
Jun 29 14:32:58 ns54546 systemd[1]: Failed to start MariaDB 10.4.13 database server.
 
Poslední změna:

Yoshino

Stará garda
Zpráv
156
Bodů
434
Bolo by mozne zaslat vacsiu cast toho logu? Nejak tam nevidim dovod toho, preco to hodi time out. Jedine, co ma trochu znepokojuje je:
Kód:
Forcefully disconnecting 82 remaining clients
 

GIGAADAM

MAJITEL SERVERU (a Java Developer :))
Zpráv
96
Bodů
199
Místo
AVERNON.EU
Servery
play.avernon.eu
ts3.avernon.eu
www.avernon.eu
No to mě také, jinak ten log je proste cely, jel jsem dal a to už nebylo mysql :/

---- Automaticky sloučená zpráva ----

Našel jsem více chyb:
Chtěl jsem stáhnout automysqlbackup a toto mi vyjelo:
Kód:
E: dpkg was interrupted, you must manually run 'dpkg --configure -a' to correct the problem.
root@ns54546:~# dpkg --configure -a
Setting up apache2 (2.4.29-1ubuntu4.13) ...
ERROR: Module mpm_prefork is enabled - cannot proceed due to conflicts. It needs to be disabled first!
dpkg: error processing package apache2 (--configure):
 installed apache2 package post-installation script subprocess returned error exit status 1
Setting up python3 (3.6.7-1~18.04) ...
running python rtupdate hooks for python3.6...
dpkg-query: package 'dh-python' is not installed
Use dpkg --info (= dpkg-deb --info) to examine archive files,
and dpkg --contents (= dpkg-deb --contents) to list their contents.
Traceback (most recent call last):
  File "/usr/bin/py3clean", line 210, in <module>
    main()
  File "/usr/bin/py3clean", line 196, in main
    pfiles = set(dpf.from_package(options.package))
  File "/usr/share/python3/debpython/files.py", line 53, in from_package
    raise Exception("cannot get content of %s" % package_name)
Exception: cannot get content of dh-python
error running python rtupdate hook dh-python
dpkg: error processing package python3 (--configure):
 installed python3 package post-installation script subprocess returned error exit status 4
Setting up mysql-server-5.7 (5.7.30-0ubuntu0.18.04.1) ...
Please enable --log-error option or set appropriate redirections for standard output and/or standard error in daemon mode.
Warning: Unable to start the server. Please restart MySQL and run mysql_upgrade to ensure the database is ready for use.
Please enable --log-error option or set appropriate redirections for standard output and/or standard error in daemon mode.
Warning: Unable to start the server.
 
Poslední změna:
Top