Questions tagged [docker]
The container software docker. https://www.docker.com
2
votes
0answers
10 views
Where should I put my system databases in WindowsCore container
We're looking into migrating our SQL Server environment to use containers.
I've successfully built a WindowsCore image with SQL Server installed. The instance is accessible with the data files using ...
-1
votes
0answers
46 views
Mariadb docker container SQLSTATE[HY000] [2002] No such file or directory error [on hold]
I have developed an web application that consists of a app, a website and a mariadb database. I put them together in a docker-compose file and tested it on my local computer and it works fine. I tried ...
0
votes
1answer
26 views
connecting to Postgres running inside docker container 'posgres' does not exist
I want to connect to Postgres (running in a container) using psql
What I've done:
docker pull postgres
docker run -p5432:5432 --name mydb -e POSTGRES_PASSWORD=pass123 -d postgres
Trying to connect ...
0
votes
0answers
10 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
110 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
61 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
50 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
1answer
71 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
25 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
83 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 ...
2
votes
3answers
697 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
116 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
18 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
40 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
737 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
256 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
265 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
88 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
558 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
437 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
662 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
137 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 \
...
2
votes
1answer
1k 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
3answers
645 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
131 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
246 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
331 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
87 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
312 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
102 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
31 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
306 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
578 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
5k 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
122 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
296 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
672 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
212 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
630 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
94 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
979 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
3k 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
797 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
178 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
36 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 ...
0
votes
1answer
135 views
What are the cons of having a database server in a Docker container for production purposes? [closed]
MySQL/Oracle/Postgres installed on a Docker container, in production, being referenced by other apps. What are the cons on doing this?
1
vote
1answer
3k views
mongodb limit server memory consumption
I'm testing running monbodb on the kubernetes platform where I can limit the resources used by the running container.
Say I set the memory limit to 256Mb. The problem is that for example while making ...
