Questions tagged [ubuntu]
Ubuntu is a desktop and server operating system based on Debian GNU/Linux. Note that http://askubuntu.com is specifically dedicated to Ubuntu questions.
604
questions
0
votes
0
answers
2
views
Version incompatibility error between the SQL-Server database backup and the SQL Server running in the Docker container on my Ubuntu 20.04 VPS
I have installed Docker and run a container on my Ubuntu VPS for resolving the version incompatibility between SQL Server and the backup file but even docker has not solved. During restoring the ...
0
votes
0
answers
12
views
Force postgres to drop connections on machine shutdown?
I am using Postgres (10) on Ubuntu server (18), and I see that when the Ubuntu server is shutting down, there is a long wait for Postgres to close connections (more than 10mins with estimated time 1h+)...
1
vote
1
answer
72
views
How to start the PostgreSQL cluster using sudo systemctl while running as postgres user that has no password?
I am new to PostgreSQL world and I am facing this issue:
When I try to start postgres 14 cluster using the following command:
pg_ctlcluster 14 testcluster start
It starts but gives me the hint that:
...
1
vote
0
answers
28
views
Ubuntu How to change the username PGAdmin tries to use to login
I uninstalled Postgresql and PGAdmin4 from ubuntu and installed them back but, now, when I open PGAdmin and click on servers/local, it requests for the password of a user no longer exists and there's ...
0
votes
1
answer
44
views
SQL and Management Nodes on same server in NDB cluster. SQL Nodes not connecting
I've setup a ndb cluster with 7 nodes. 3 data nodes on their own servers, and 2 management nodes that each have a sql node on them on 2 servers.
I've narrowed down what I think my issue is. My cluster ...
0
votes
1
answer
48
views
Mongod starting issue on ubuntu
When I try to check the status of mongodb I get the following:
× mongod.service - MongoDB Database Server
Loaded: loaded (/lib/systemd/system/mongod.service; enabled; vendor preset: enabled)
...
0
votes
0
answers
22
views
Why does removing `skip-grant-tables` cause resource conflict error for mysqld?
After hours of searching, I have managed to narrow a mysqld issue down to a point, which I cannot find reason for.
I am attempting to launch multiple instances of mysqld on my Ubuntu server. When ...
0
votes
0
answers
34
views
How do I convert master-slave to multimaster database replication in MySQL?
Currently, I have one master and two slaves in my setup. How can I convert it so that I have three masters instead? I need all three nodes to be writable and to update each other accordingly.
Most of ...
0
votes
3
answers
208
views
Mariadb threads blocking randomly
We have a mariadb instance hosted on Ubuntu 22.04. We are regularly seeing some threads getting stalled on relatively high activity tables(although the tables are not huge ones). Once stuck, it never ...
0
votes
0
answers
197
views
Moving MysQL data directory error: Can't create test file mysqld_tmp_file_case_insensitive_test.lower-test
I'm trying to move mysql datadir to another location on external drive which is formatted with ext4. I'm betting following error:
# lsblk -f
..
sdb ...
1
vote
0
answers
31
views
Failed to start MySQL Community Server on Ubuntu 20
I'm currently facing an issue with starting MySQL on my Ubuntu system. Upon attempting to restart the MySQL service, an error message stating 'Failed to start MySQL Community Server' appeared. As part ...
0
votes
1
answer
42
views
Ram usage increases in MySQL after backup
I have a mysql 8.0.31 running in docker form (the server is running ubuntu)
the problem i am having is that after each backup that i run (i run it every hour) the ram consumption increases and never ...
1
vote
1
answer
122
views
How should I troubleshoot a very slow MySQL server droplet?
I'm new to the DBA forum, but not SO, and I've searched for answers on this, and tried what I've found.
We have a Rails app that lives on a Digital Ocean droplet, and a bigger and more powerful ...
0
votes
1
answer
33
views
mysql configuration file order of read
I was reading about my.cnf in mysql docs and I dont understand this part
On Unix and Unix-like systems, MySQL programs read startup options from the files shown in the following table, in the ...
1
vote
0
answers
47
views
PostgreSQL isn't using all available vCPUs of the VM
Running some procedures takes too much time and if I check htop I can see just one vCPU of the Ubuntu VM that is running and the others aren't:
postgresql.conf
max_connections = 50
shared_buffers = ...