Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-04-29, 01:47:00

Author Topic: My database was down but Lxguard was unable to restart it  (Read 2986 times)

0 Members and 1 Guest are viewing this topic.

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 4,050
  • Karma: +1/-0
    • View Profile
I got tons of these:

Quote
Host: backup.xxx.pl
Date: Aug-12 01:23
Port: 3306
Action: sh /script/restart-mysql --force >/dev/null 2>&1

When I restarted with /etc/init.d/mysql restart it worked instantly. Why ?

I'm using MariaDB.

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: My database was down but Lxguard was unable to restart it
« Reply #1 on: 2015-08-12, 13:47:46 »
Inform here 'dir -l /etc/my.cnf.d; cat /etc/my.cnf.d/server.cnf'
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 4,050
  • Karma: +1/-0
    • View Profile
Re: My database was down but Lxguard was unable to restart it
« Reply #2 on: 2015-08-12, 22:16:57 »
Inform here 'dir -l /etc/my.cnf.d; cat /etc/my.cnf.d/server.cnf'

[root@backup ~]# dir -l /etc/my.cnf.d
razem 28
-rw-r--r--  1 root root  295 08-05 20:11 client.cnf
-rw-r--r--  1 root root  232 08-05 20:11 mysql-clients.cnf
-rw-r--r--. 1 root root 1564 05-06 00:14 server.cnf
-rw-r--r--. 1 root root 1475 2014-03-17  server.cnf.backup
-rw-r--r--. 1 root root  725 2013-11-05  server.cnf.rpmnew
-rw-r--r--. 1 root root 1475 2014-03-17  server.cnf.rpmsave
-rw-r--r--  1 root root  285 08-05 20:11 tokudb.cnf
[root@backup ~]# cat /etc/my.cnf.d/server.cnf
[mysqld]
#skip-networking
#bind-address = 0.0.0.0
#server-id=1
#log-bin = mysql-bin
#skip-name-resolve
#skip-grant-tables
datadir=/var/lib/mysql
tmpdir=/dev/shm
socket=/var/lib/mysql/mysql.sock
user=mysql
#log_warnings=2
skip-external-locking
query_cache_limit=32M
query_cache_size=64M
query_cache_type=1
max_connections=1000
#max_user_connections=50
max_connect_errors=100
#wait_timeout=180
thread_handling = pool-of-threads
thread_cache_size=2
key_cache_segments=2
key_buffer=384M
innodb-buffer-pool-instances=2
innodb_buffer_pool_size = 256M
innodb_thread_concurrency = 8
innodb_log_file_size=64M
innodb_log_buffer_size = 8M
innodb_lock_wait_timeout = 100
innodb_flush_log_at_trx_commit = 2
innodb_support_xa=0
innodb_read_io_threads = 2
innodb_write_io_threads = 2
innodb_max_dirty_pages_pct = 90
innodb_file_per_table=1
innodb_use_native_aio=1
innodb_doublewrite=1
innodb_use_fallocate=1
innodb_use_atomic_writes=0
innodb_flush_method = O_DIRECT
innodb_file_format=barracuda
innodb_lru_scan_depth=2000
innodb_io_capacity=200
innodb_io_capacity_max=500
sync_binlog=0
join_buffer_size=1M
max_allowed_packet=32M
table_open_cache=1024
table_cache=4k
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=1M
max_connect_errors=100
tmp_table_size=32M
max_heap_table_size=1M
long_query_time=2
myisam_sort_buffer_size=16M
max_write_lock_count = 1
default-storage-engine=MyISAM

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
plugin-load=archive=ha_archive.so;blackhole=ha_blackhole.so

[mysqldump]
quick
max_allowed_packet=16M

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: My database was down but Lxguard was unable to restart it
« Reply #3 on: 2015-08-13, 02:41:20 »
Configure is not 'normal' setting, except '1000' so high. What's about log inside /var/lib/mysql?.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 4,050
  • Karma: +1/-0
    • View Profile
Re: My database was down but Lxguard was unable to restart it
« Reply #4 on: 2015-08-17, 09:17:29 »
The same for pdns today !

Kloxo was executing:
Quote
Host: xxx
Date: Aug-17 08:19
Port: 53
Action: sh /script/restart-dns --force >/dev/null 2>&1

but server was still down. When I just runned /etc/init.d/pdns restart it instantly restarted !

It seems Kloxo does not have permissions to run these scripts...
« Last Edit: 2015-08-17, 09:44:02 by Spacedust »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: My database was down but Lxguard was unable to restart it
« Reply #5 on: 2015-08-17, 11:08:34 »
Not lxguard but watchdog.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 4,050
  • Karma: +1/-0
    • View Profile
Re: My database was down but Lxguard was unable to restart it
« Reply #6 on: 2015-08-17, 15:11:47 »

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix

Page created in 0.071 seconds with 19 queries.

web stats analysis