Questions tagged [docker]
The container software docker. https://www.docker.com
86
questions
1
vote
2answers
44 views
Determining Whether Query Load is Too High for PostgreSQL Server
I just started experiencing some write-heavy load on a PostgreSQL 11.2 system running inside a Docker container on an Ubuntu 18.04 server. PostgreSQL is receiving about 1-4k INSERT queries/second.
...
0
votes
0answers
13 views
Proper way to preserve data for mariadb docker container
I am running a single mariadb container as a backend for a webapp. I restarted the container, and the only data remaining was from a long time ago. None of the recent transactions were available. They ...
1
vote
1answer
50 views
sql server in docker using 15gb of disk space [closed]
I'm following the instructions here to create my own docker container containing a sql server instance with databases and data configured.
I've added two databases, a few tables containing at most ...
1
vote
1answer
100 views
Building Oracle XE docker image in Windows 10 Pro
I'm trying to install Oracle XE 18c in a docker container in Windows 10. I have docker already installed, and I need to build the image as explained here.
I cloned the git repository, but I'm stuck ...
0
votes
0answers
18 views
Unable to connect to DB using Mysqlworkbench
I am running a Mysql db inside docker container as shown below:
Adding a new user from within the container and logging in with same user works fine within the container but the same doesnt work when ...
0
votes
1answer
33 views
Disable mysql_tzinfo_to_sql during MariaDB/MySQL installation
MariaDB run in docker container hangs during initial startup while mysql_tzinfo_to_sql running because of the issue.
I've disabled mysql_tzinfo_to_sql by setting MYSQL_INITDB_SKIP_TZINFO env. var to ...
0
votes
0answers
18 views
Postgresql strange backup message with docker
I'm trying to backing up my remote PostgreSql database into the local one.
The backup command is the following:
docker run --rm -e PGUSER=user -e PGPASSWORD=password -e PGDATABASE=db -it postgres:11....
0
votes
0answers
56 views
How to use timescale-bitnami image on Windows?
Since there are issues with collations in the default alpine-based timescaledb images, I tried to use the bitnami-image. But I get an error on startup.
docker run ^
-p 5432:5432 ^
-v tsdb-bitnami:/...
1
vote
1answer
38 views
Dockerized Sysbench could not connect to Mysql
I'm trying to follow this tutorial.
It does not give Mysql version requirements. So I'd tried to use Mysql 8.0.18 Community Server to connect to using those commands.
I've created what have been ...
1
vote
0answers
54 views
How to connect mongodb from aws ec2 ubuntu docker containers?
I have tried
mongosqld --addr localhost:3002 --mongo-uri xxxxx.com:27017
But it is throwing the following error:
unable to load MongoDB information:
failed to create admin session for ...
1
vote
2answers
228 views
psycopg2 connection with multihosts [closed]
I have 3 db servers on docker containers, and i used to connect like this from my python app:
psycopg2.connect(host="db-0", user="user", password="password", database="data") This works,but if i add ...
1
vote
1answer
197 views
Does anyone deployed a succesful SSAS on docker?
I'm trying to create a docker image that contains MS SQL server, analysis services, and restore a db (bak) and a cube (abf). The Sql server part is the easy stuff, and I imagine that the restore will ...
0
votes
1answer
151 views
Change value lower_case_table_names on a running docker container
I have a running docker image with a database where, for some reason, the columns are in camel-case. I have been searching how to change the value of lower_case_table_names to 1.
How can I make this ...
5
votes
1answer
125 views
Permissions issue in Docker SQL Server 2017 while restoring certificate
Docker SQL Server 2017 container @latest. Using master database.
The error I am facing is the following:
[S00019][15208] The certificate, asymmetric key, or private key file is not valid or does not ...
1
vote
0answers
38 views
Unable to recover MySQL 5.6 (InnoDB) database
I've tried multiple different suggestions from other questions on here, with no luck...
This is a MySQL database running version 5.6.41, using the InnoDB engine, and the instance is running out of a ...
1
vote
1answer
110 views
Postgresql cannot restore partial pg_dump “relation ”public.my_table_seq“ does not exist”
In my database I dumped some tables via the following psql command:
pg_dump -t my_table1 -t mytable2 > my_dump.sql
And I try to import it into a postgresql docker image as a standalone database ...
0
votes
0answers
48 views
Different MYSQL performances on test/prod system
I have been met with a very bizzare performance issue and wanted to see if anyone here would have any input on the problem.
To put it simply, we have hugely different query performances on our test ...
0
votes
0answers
36 views
MongoDB replica set in swarm gets very slow when one node is down
I created a 3 nodes replicaset with mongodb that I host in a swarm environment. To do so, I created 3 services mongo1, mongo2, mongo3 with the same configuration.
When I challenged the resiliency of ...
0
votes
1answer
53 views
Migrate a remote oracle database (11g) into a docker oracle XE database (11g)
I am brand new to Oracle and I am trying to migrate an existing VM that has deployment scripts run on it every release to use a docker container instead. Then I can run the release scripts and tag a ...
1
vote
1answer
116 views
Why is OracleDB locking up in Docker?
I am trying to set up an Oracle database in Docker, and once the database is up and running, I can exec into sqlplus just fine, but if I try to connect with another application like Oracle SQL ...
0
votes
1answer
549 views
Can't connect to Oracle 12c Release 1 in docker container from host
I pulled the Oracle 12.1.0.2 docker image from the Oracle Container Registry (container-registry.oracle.com/database/standard:12.1.0.2) and created a container as per the instructions, leaving the ...
0
votes
0answers
39 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
149 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
378 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
41 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
178 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
2k 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
89 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
43 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
284 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
14 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
2k 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 ...
1
vote
1answer
2k 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 / ...
1
vote
0answers
235 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
301 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
662 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
1answer
294 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
2k 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
877 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
29 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
140 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 ...
1
vote
1answer
4k 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
763 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
505 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
215 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
1k 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
24 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
921 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
1k 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
305 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 \
...
