Questions tagged [docker]
The container software docker. https://www.docker.com
67
questions
0
votes
0answers
21 views
Restoring database created with Ola's tools from Azure blob
I'm exploring using Ola Hallengren's excellent backup tools to backup to an azure blob. Is there a simple way to do a restore of the latest backups on a fresh MSSQL 2017 database directly from azure ...
0
votes
0answers
22 views
Docker MariaDB lost data
I was using the official mariadb 10.3 image as a database with innodb and file per table turned on. A few months ago I pulled the image for a minor release and let it run. This as I now found out did ...
0
votes
1answer
24 views
(macOS/Docker) “Cannot bulk load. The file path does not exist or you don't have file access rights.”
I am running SQL Server from a Docker container on macOS. All queries except for the loading of the csv file is getting executed. The column names etc are correct. Any ideas?
error:
Cannot bulk ...
1
vote
0answers
27 views
how to access hadoop slaves which have the same IP address but different port numbers
My question is, I'm wondering if it's possible Hadoop can do ssh access with a different port number(not 22) for slaves when it makes a Hadoop cluster.
Detail)
I tried to make Hadoop cluster with two ...
0
votes
1answer
43 views
MySQL replication slave using percona and docker
I am trying to run a MySQL replication slave in a docker container. We are running MySQL 5.7.24-27-log in production and it's from the percona repository (Ubuntu 18.04).
I have used xtrabackup to ...
0
votes
1answer
171 views
Can't solve MongoParseError: Invalid connection string
I'm not able to solve MongoParseError.
First my I tried this
mongoose.connect(`mongodb://${process.env.DB_USER}:${process.env.DB_PASSWORD}@db:27017/${process.env.DB_NAME}`, {useNewUrlParser: true});
...
2
votes
1answer
59 views
SQL Server Demo Environment on Docker Desktop (Win 10): DB storage und upgrade paths
I would like to run SQL Server 2019 on my work as well as my private machine (both running Windows 10 Pro). Thus I thought Docker Desktop would be a nice option.
However I would like to keep the ...
0
votes
0answers
20 views
What database should I use locally if I'm going to use Aurora Serverless?
I'm planning to use Aurora Serverless in QA/PROD and then a docker container for running a compatible engine locally. Should I use MariaDB 10.0 or MySQL 5.6?
Database need is low, we're not doing ...
0
votes
0answers
66 views
MongoDB 3.4.10 queries getting very slow after couple hours/days of running
We have a MongoDB pod running on CGP Kubernates with 2 replicas. Microservices are written in Java and use Mophia to access MongoDB. The database only has 6 million data. One collection, in particular,...
2
votes
0answers
12 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 ...
0
votes
1answer
356 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
11 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
851 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
134 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
119 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
231 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]
...
1
vote
0answers
49 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
168 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
1k 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
441 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
24 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
67 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
2k 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
1answer
395 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
362 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
131 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
736 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
617 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
942 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
203 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 \
...
4
votes
1answer
2k 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
834 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 ...
1
vote
1answer
300 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
368 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 ...
9
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
116 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 (...
1
vote
1answer
489 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 ...
1
vote
1answer
39 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
370 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
669 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 | ...
10
votes
2answers
6k 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
133 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
333 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
3k 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
787 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
309 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
687 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
97 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
1k 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? ...
