Questions tagged [docker]
The container software docker. https://www.docker.com
0
votes
0answers
8 views
How to know if a sql dump has been already imported?
I am writting a Dockerfile where the entrypoint script checks if any *.sql file present inside initdb.d dir then it import that *.sql file. However as this import mechanism is a part of entrypoint ...
1
vote
1answer
39 views
Oracle - Can't login with “/ as sysdba”, but can with “sys as sysdba”
I've been working on setting up a docker container running Oracle DB XE 18.4.0. I have the container built from Oracle's dockerfiles and it is working fine, except that I cannot login using
connect / ...
0
votes
0answers
26 views
How to enable remote debugging of Stored Procs with MSSQL Linux Docker container?
I'm running the latest SQL Server docker container from DockerHub in a Linux environment. Port 1433 is forwarded from my container, and everything is working fine.
However, when I have tried to ...
0
votes
0answers
24 views
Firebird: show tables command shows no result in different environment
I'm using firebird with docker with the image jacobalberty/firebird:2.5.8-sc
I use it in local and in the remote server. The problem is the database seems unreadable in the remote server, it says no ...
1
vote
0answers
15 views
MariaDB instance hangs [closed]
I have a MariaDB instance which was created from an official docker image. Sometimes when I try to execute many queries [like drop database, mySQL dump sourcing] via a PHP script, then the entire ...
1
vote
1answer
31 views
Unable to use cyrillic characters in mysql docker console
I'm running a MySQL docker container (latest - 8.0) with the custom configuration file containing:
======================================
[client]
default-character-set=utf8mb4
[mysqld]
...
0
votes
0answers
21 views
Mongodb default setup on Azure - default connect string from local shell
I have a new Azure VM (Ubuntu 18.04.1 LTS) which has docker.
dragam@USDockerVM:~$ IRE> docker --version
Docker version 18.09.0, build 4d60db4
Issued the command
docker pull mongo
this ran ...
0
votes
1answer
43 views
postgres - c <parameter> = <value> not working for postgres 11 in docker
I'm running a Postgres inside a docker. I want to change the default config of Postgres so I'm running :
docker container run -d postgres -c max_connections=200 -c shared_buffers = 1GB -c ...
3
votes
0answers
477 views
Not able to connect to Postgres database : no pg_hba.conf entry for host [closed]
I am trying to connect a Postgres database which resides in a docker installed on Ubuntu virtual machine. Following exception is being thrown on the console.
org.postgresql.util.PSQLException: FATAL: ...
-1
votes
0answers
29 views
MySQL not honoring binlog_format setting
I have an application that listens to the MySQL 5.6/5.7 binary log. It requires binlog_format to be set to ROW. This is working perfectly on RDS but I can't get the setting to work in a docker ...
1
vote
3answers
374 views
MYSQL database replication Error MY-002061
I've been trying to get two databases in docker containers to replicate. I've been working off this article:
https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-...
-1
votes
1answer
55 views
Postgres database on docker drops database
Dont know if its a Docker problem or a Postgres problem...
I have installed a Postgres container, installed Bitbucket container, and linked the two together. Can connect just fine.
After that I ...
1
vote
1answer
16 views
DB user restricted permissions vs Docker?
As far as I know, it's usually considered a good practice when developing websites to store in website config DB credentials of the user without ALTER/DROP permissions (so user may only select, insert,...
0
votes
0answers
29 views
dockerized postgresql listing no clusters
I'm upgrading an existing dockerized postgres:9.6 to 10. There are plenty of good Q/As on DBA and SO that go the path of pg_upgradecluster, but it is not working for me.
When I start a vanilla pg:10 ...
0
votes
1answer
372 views
Docker to Docker Oracle 12c Connection
I'm trying to run a simple exercise with two docker containers with oracle database 12c (store/oracle/database-enterprise:12.2.0.1). It's pretty straigthforward to run both containers but I haven't ...
0
votes
0answers
201 views
Error “Msg 10054, level 20, State 0, Line 0” with MSSQL under Docker
I've set up several docker containers in my Ubuntu 16.04 LTS machine. All of them have in common the same container image.
It works pretty well, but some users have reported me a common issue when ...
0
votes
0answers
220 views
Weird error when bringing up docker image for postgres
I have a docker stack using multiple images. One of them being docker image of postgres. Now, I have been working on this for couple of months but since yesterday my postgres image just started ...
1
vote
2answers
66 views
Docker for Oracle Timestamp out of sync
I have created an Oracle Database Docker Image with the help of this link
SYSTIMESTAMP shows UTC time and not my local machine's time.
kaushik:~ knayak$ date
Fri Jun 8 17:46:35 IST 2018
select ...
5
votes
1answer
471 views
Excessive Postgres Docker CPU Consumption
I'm using a Postgres container to run some small non-critical apps and sites. It's been stable for a while, but now the container has started to consume some serious CPU after it's been running for a ...
1
vote
0answers
22 views
A way to check Oracle finished sql
I've got Docker Compose cluster and one of the containers is Oracle 12c. There is schema.sql file to initialize the db. I would like my application to wait until the db executes all the sql. How can I ...
1
vote
2answers
306 views
Postgres 10.3 could not bind IPv6 address, database system was not properly shut down
I am running Postgres v10.3 through Docker (docker-compose, specifically). It is not turning back on. I get the following error message when I try to turn it on:
postgres | pg_ctl: ...
0
votes
1answer
551 views
docker and postgres: using password_file leads to no pg_hba.conf entry for host
I'm aware of the following solution for the no pg_hba.conf entry for host error: connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host
But I wonder why this error happens when using ...
1
vote
0answers
116 views
Howo specify numactl settings when running mongodb as docker swarm service?
I have a mongodb 3.6 replica set. The replica members are running in docker containers. The whole replica set was created as a docker swarm service. Something like this:
docker service create -d \
...
0
votes
0answers
27 views
How adaptable are docker containers for database?
All, We have started adopting docker containers in our organisation. As far as I understand correctly it is great for running applications with high availability and scalability but somehow I feel it ...
2
votes
1answer
876 views
Setting up replication with MariaDB 10.3.4 docker images
I'm attempting to set up replication between two docker containers, both running the stock MariaDB 10.3.4 images (which are the latest versions as of right now). When I start up the containers, I get ...
0
votes
0answers
25 views
Postgres compiling packages
I'm building a docker container with debian as base image. To keep the container small I was just wondering if e.g. bison and flex can be uninstalled after the compiling (around 100MB together).
Has ...
0
votes
3answers
510 views
MongoDB disk operations with journaling disabled
Assuming MongoDB 3.6, usage of WiredTiger, with journaling disabled:
How does mongod write data to hard drive? It performs write operation per every document? Per every chunk? And similarly: how ...
0
votes
0answers
116 views
sql server 2017 docker linux XP_cmdshell registry
I'm having difficulties reading data in my registry from sql server.
Sql server is running by docker container on a linux virtual machine.
This VM is hosted on a windows server 2012.
The registry is ...
1
vote
1answer
196 views
MongoDB sharded cluster chunks distribution
I have deployed MongoDB cluster with two shards (two replica sets) with docker-compose.
Unfortunately I'm having problems with chunks distribution between shards, I'm new to MongoDB and database ...
0
votes
1answer
306 views
Is good idea to implement ProxySQL in production with Docker?
The idea is to have solution with ProxySQL to give high availability solution with docker implementation? But this question maybe not have sense, I am to investigate alternative solution without VIP ...
8
votes
2answers
1k views
SMO, SSMS are slow for management of SQL Server in Docker when connecting to localhost
TL;DR: When connecting to my SQL Server Docker container via a name that resolves to the IPv6 loopback (::1), SMO calls are really slow. When using 127.0.0.1, they're fast.
I am trying to learn how ...
1
vote
2answers
78 views
Docker-to-docker Mysql connection
I have a 2 docker setup - one container with a MysqlDB on it and another with a web server. Both are on the same machine.
The db container has it 3306 port exposed though the hosts 3306 port (...
0
votes
1answer
239 views
mysqldump stuck at “Connecting to”
I'm having a weird problem with mysqldump. I have a docker instance of mysql (5.7) to which I can connect just fine (to any database). I can also use mysqldump to dump the databases except one - after ...
0
votes
0answers
94 views
MySql tables use 3GB, but disk usage is 40GB
I have a 48GB Linode machine. The ONLY thing this machine runs is docker with the standard mysql:8.0.3 docker image. Looking in information_schema.TABLES I can see I use in total 2.8GB.
However, when ...
1
vote
1answer
23 views
File creation dates of archived WAL files not in line with archive_timeout in PostgreSQL 9.6
I have configured archive_timeout = 5 (i.e. 5 seconds) for a PostgreSQL 9.6 database in order to conduct tests around point-in-time recovery. My archive_command invokes cp into a local archive ...
0
votes
1answer
263 views
Insert PBKDF2 hash into PostgreSQL container
I am using the PostgreSQL docker image with the following Dockerfile:
FROM postgres:10.1
COPY init-db.sh /docker-entrypoint-initdb.d/init-db.sh
and an init-db.sh script with the following content:
...
1
vote
1answer
515 views
MySQL does not follow Ubuntu System Time Zone
An Ubuntu 16.04 server has it's time zone set to America/New_York using the command
sudo timedatectl set-timezone America/New_York
This is confirmed by running the commands
timedatectl status | ...
8
votes
2answers
4k views
MongoDB terminates when it runs out of memory
I have the following configuration:
a host machine that runs three docker containers:
MongoDB
Redis
A program using the previous two containers to store data
Both Redis and MongoDB are used to ...
1
vote
0answers
115 views
mysqld slowly eats memory
Summary
My company recently deployed mysql innodb cluster as a backend database system using docker. To be exact, the cluster was deployed on Oct 3rd, so it has been almost two months. Recently, ...
0
votes
1answer
284 views
how to setup percona pmm monitoring of percona 5.7 in docker container
I want to monitor percona running in docker with the percona monitoring and management client.
I have percona monitoring and management installed, running and monitoring other percona instances (...
1
vote
2answers
2k views
How to disable mongodb connection logs?
Our mongodb relication has many logs like this:
> 2017-11-24T02:15:50.679+0000 I ACCESS [conn6537] Successfully authenticated as principal stats on stats
> 2017-11-24T02:15:50.679+...
3
votes
1answer
595 views
Unable to get Cassandra in a Docker to talk to cluster
Trying to get Cassandra running in a docker using the official docker image. When I execute the below lines of code it starts then stops the docker without connecting to the cluster. I have checked ...
1
vote
1answer
166 views
How to replicate a mongodb pod with its persistent storage (Minikube - Kubernetes)
I made these settings :
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
labels:
name: mongo-claim0
name: mongo-claim0
namespace: my-app
spec:
...
1
vote
1answer
597 views
Authenticate MongoDB shard cluster in Docker swarm
I am trying to put authentication to the mongo shard cluster which is running in docker swarm.
docker-compose.yml file:
version: "3.3"
services:
cfg1-r1:
image: mongo:3.4.9
...
1
vote
0answers
86 views
Root Privileges Moving From MySQL to Mariadb
I am experimenting with migrating my database from an older version of MySQL to a Mariadb Docker container. I am simply dumping the entire database and restoring it within Mariadb.
The only issue I'...
1
vote
0answers
888 views
How to relax file permissions conditions on postgres database folder?
Postgresql service refuses to start if the data folder (PGDATA) doesn't belong exclusively to the postgres user (i.e. permissions = 700).
Is there any way to disable or circumvent that condition? ...
1
vote
1answer
2k views
MySQL proxies_priv ignored in --skip-name-resolve mode
I'm running MySQL (MariaDB) inside docker container and with every start, it shows the following warning:
[Warning] 'proxies_priv' entry '@% root@mariadb-3702996102-qbr18' ignored in --skip-name-...
0
votes
1answer
676 views
centos container, installing mariadb server
I am trying to run a mariadb server on a docker image(CentOS Linux release 7.3.1611 (Core)).
I install mariadb with command yum install mysql. after installing complete, i try to execute command ...
1
vote
0answers
158 views
Backup postgresql docker image from WAL using wal-e
I have an image which has wal-e installed and working. It successfully on backup-push sends my WAL to the remote drive.
However when I run backup-fetch, I get the error
wal_e.main INFO MSG:...
0
votes
0answers
33 views
How to use container to do database high availability?
About traditional database high availability, the method is like:
master-master replication
master-slave replication
automatic failover
If use container to do that, we can use these ways:
Use ...
