search

monitoringartist / dockbix-xxl

:whale: Dockerized Zabbix - server, web, proxy, java gateway, snmpd with additional extensions
https://hub.docker.com/u/monitoringartist/
GNU General Public License v2.0
377 stars 139 forks source link

problems with mariadb #83

Closed vmedek closed 7 years ago

vmedek commented 7 years ago

Hi,

I tried to run mariadb image, but I have folowing problem : 

170403 09:12:36 mysqld_safe Logging to '/var/lib/mysql/error.log'.
170403 09:12:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170403 09:12:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170403  9:12:36 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --log_slow_queries is not set
170403  9:12:36 [Note] /usr/sbin/mysqld (mysqld 10.0.30-MariaDB) starting as process 254 ...
170403  9:12:36 [Warning] Could not increase number of max_open_files to more than 4096 (request: 4407)
170403  9:12:36 [Note] InnoDB: Using mutexes to ref count buffer pool pages
170403  9:12:36 [Note] InnoDB: The InnoDB memory heap is disabled
170403  9:12:36 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
170403  9:12:36 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
170403  9:12:36 [Note] InnoDB: Compressed tables use zlib 1.2.7
170403  9:12:36 [Note] InnoDB: Using Linux native AIO
170403  9:12:36 [Note] InnoDB: Using CPU crc32 instructions
170403  9:12:36 [Note] InnoDB: Initializing buffer pool, size = 768.0M
170403  9:12:36 [Note] InnoDB: Completed initialization of buffer pool
170403  9:12:36 [Note] InnoDB: Highest supported file format is Barracuda.
170403  9:12:36 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 49463 in the ib_logfiles!
170403  9:12:36 [Note] InnoDB: Database was not shutdown normally!
170403  9:12:36 [Note] InnoDB: Starting crash recovery.
170403  9:12:36 [Note] InnoDB: Reading tablespace information from the .ibd files...
170403  9:12:36 [Note] InnoDB: Restoring possible half-written data pages
170403  9:12:36 [Note] InnoDB: from the doublewrite buffer...
170403  9:12:36 [Note] InnoDB: Creating tablespace and datafile system tables.
170403  9:12:36 [Note] InnoDB: Tablespace and datafile system tables created.
170403  9:12:36 [Note] InnoDB: 1 rollback segment(s) are active.
170403  9:12:36 [Warning] InnoDB: Creating foreign key constraint system tables.
170403  9:12:36 [Note] InnoDB: Foreign key constraint system tables created
170403  9:12:36 [Note] InnoDB: Waiting for purge to start
170403  9:12:36 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 49463
170403  9:12:36 [Note] Plugin 'FEEDBACK' is disabled.
170403  9:12:36 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
170403  9:12:36 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
170403  9:12:36 [Note] Server socket created on IP: '0.0.0.0'.
170403  9:12:36 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
170403 09:12:36 mysqld_safe mysqld from pid file /var/lib/mysql/mysql.pid ended
Still waiting for DB service...
Still waiting for DB service...
Still waiting for DB service...

I used "default" configuration : 

docker run \
    -d \
    --name zabbix-db \
    -v /backups:/backups \
    -v /etc/localtime:/etc/localtime:ro \
    --volumes-from zabbix-db-storage \
    --env="MARIADB_USER=zabbix" \
    --env="MARIADB_PASS=zabbix" \
    monitoringartist/zabbix-db-mariadb
jangaraj commented 7 years ago

Did you create zabbix-db-storage container for --volumes-from zabbix-db-storage? Could you provide output from docker info please?

vmedek commented 7 years ago

Yes, I started it, and it exited with no logs docker info:

root@xxxx:~# docker info
Containers: 2
 Running: 1
 Paused: 0
 Stopped: 1
Images: 4
Server Version: 17.03.1-ce
Storage Driver: aufs
 Root Dir: /var/lib/docker/aufs
 Backing Filesystem: extfs
 Dirs: 23
 Dirperm1 Supported: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
 Volume: local
 Network: bridge host macvlan null overlay
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 4ab9917febca54791c5f071a9d1f404867857fcc
runc version: 54296cf40ad8143b62dbcaa1d90e520a2136ddfe
init version: 949e6fa
Kernel Version: 3.16.0-4-amd64
Operating System: Debian GNU/Linux 8 (jessie)
OSType: linux
Architecture: x86_64
CPUs: 1
Total Memory: 999 MiB
Name: ip-10-125-224-10
ID: 4RP6:FGBJ:D6ZS:22HQ:6HFG:OCFA:DHZE:XPBW:NZSG:R4PB:TIIU:7QSZ
Docker Root Dir: /var/lib/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
WARNING: No memory limit support
WARNING: No swap limit support
WARNING: No kernel memory limit support
WARNING: No oom kill disable support
WARNING: No cpu cfs quota support
WARNING: No cpu cfs period support
Experimental: false
Insecure Registries:
 127.0.0.0/8
Live Restore Enabled: false

root@xxxx:~# docker ps -a
CONTAINER ID        IMAGE                                COMMAND             CREATED             STATUS                      PORTS               NAMES
02b2f3dd076e        monitoringartist/zabbix-db-mariadb   "/run.sh"           11 minutes ago      Up 11 minutes               3306/tcp            zabbix-db
ddc8180723f8        busybox:latest                       "sh"                27 minutes ago      Exited (0) 27 minutes ago                       zabbix-db-storage
jangaraj commented 7 years ago

I guess you don't have enough memory (999MB). Add more memory or try to play with DB_innodb_buffer_pool_size.

vmedek commented 7 years ago

Still same result with 4GB

170403 09:43:41 mysqld_safe Logging to '/var/lib/mysql/error.log'.
170403 09:43:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170403 09:43:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170403  9:43:41 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --log_slow_queries is not set
170403  9:43:41 [Note] /usr/sbin/mysqld (mysqld 10.0.30-MariaDB) starting as process 257 ...
170403  9:43:41 [Warning] Could not increase number of max_open_files to more than 4096 (request: 4407)
170403  9:43:41 [Note] InnoDB: Using mutexes to ref count buffer pool pages
170403  9:43:41 [Note] InnoDB: The InnoDB memory heap is disabled
170403  9:43:41 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
170403  9:43:41 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
170403  9:43:41 [Note] InnoDB: Compressed tables use zlib 1.2.7
170403  9:43:41 [Note] InnoDB: Using Linux native AIO
170403  9:43:41 [Note] InnoDB: Using CPU crc32 instructions
170403  9:43:41 [Note] InnoDB: Initializing buffer pool, size = 768.0M
170403  9:43:41 [Note] InnoDB: Completed initialization of buffer pool
170403  9:43:41 [Note] InnoDB: Highest supported file format is Barracuda.
170403  9:43:41 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 49463 in the ib_logfiles!
170403  9:43:41 [Note] InnoDB: Database was not shutdown normally!
170403  9:43:41 [Note] InnoDB: Starting crash recovery.
170403  9:43:41 [Note] InnoDB: Reading tablespace information from the .ibd files...
170403  9:43:41 [Note] InnoDB: Restoring possible half-written data pages
170403  9:43:41 [Note] InnoDB: from the doublewrite buffer...
170403  9:43:41 [Note] InnoDB: Creating tablespace and datafile system tables.
170403  9:43:41 [Note] InnoDB: Tablespace and datafile system tables created.
170403  9:43:41 [Note] InnoDB: 1 rollback segment(s) are active.
170403  9:43:41 [Warning] InnoDB: Creating foreign key constraint system tables.
170403  9:43:41 [Note] InnoDB: Foreign key constraint system tables created
170403  9:43:41 [Note] InnoDB: Waiting for purge to start
170403  9:43:41 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 49463
170403  9:43:41 [Note] Plugin 'FEEDBACK' is disabled.
170403  9:43:41 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
170403  9:43:41 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
170403  9:43:41 [Note] Server socket created on IP: '0.0.0.0'.
170403  9:43:41 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
Still waiting for DB service...
170403 09:43:42 mysqld_safe mysqld from pid file /var/lib/mysql/mysql.pid ended
Still waiting for DB service...

Containers: 2
 Running: 1
 Paused: 0
 Stopped: 1
Images: 4
Server Version: 17.03.1-ce
Storage Driver: aufs
 Root Dir: /var/lib/docker/aufs
 Backing Filesystem: extfs
 Dirs: 23
 Dirperm1 Supported: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
 Volume: local
 Network: bridge host macvlan null overlay
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 4ab9917febca54791c5f071a9d1f404867857fcc
runc version: 54296cf40ad8143b62dbcaa1d90e520a2136ddfe
init version: 949e6fa
Kernel Version: 3.16.0-4-amd64
Operating System: Debian GNU/Linux 8 (jessie)
OSType: linux
Architecture: x86_64
CPUs: 2
Total Memory: 3.87 GiB

Name: ip-10-125-224-10
ID: 4RP6:FGBJ:D6ZS:22HQ:6HFG:OCFA:DHZE:XPBW:NZSG:R4PB:TIIU:7QSZ
Docker Root Dir: /var/lib/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
WARNING: No memory limit support
WARNING: No swap limit support
WARNING: No kernel memory limit support
WARNING: No oom kill disable support
WARNING: No cpu cfs quota support
WARNING: No cpu cfs period support
Experimental: false
Insecure Registries:
 127.0.0.0/8
Live Restore Enabled: false
jangaraj commented 7 years ago

Could you provide your solution, please?

vmedek commented 7 years ago

I am not sure what helped. I deleted all 3 containers and installed again.