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.
543
questions
0
votes
0
answers
17
views
Which MariaDB-Galera Node Should I Start After Cluster Crushing or Failing?
Sometimes my 3-Node GaleraCluster fails and doesn't serve. When I check I see all of them are activated but two of them are not working, so I check log files I see one of them could not operate an ...
-2
votes
0
answers
14
views
Datagrip - Shared Keepass file not working
I'm using Datagrip under Ubuntu 20.04 to manage a lot of databases. I'm also working on three different machines, so it would be nice to just use the same .kdbx file, instead of entering every ...
- 97
0
votes
1
answer
19
views
I accidentally obfuscated all my files when using oracle sql developer. Now I can't login into my system [ubuntu]
I clicked on the obfuscate button in my root directoty in oracle sql without knowing what it does. Then my system crashed and now no matter how many times I restart, i'm stuck at a login page. It ...
0
votes
0
answers
24
views
SQL Server 2019 on Ubuntu 18.04 fails to connect to linked server after CU10
After upgrading SQL Server 2019 from CU9 to CU10 on Ubuntu 18.04.6 LTS, I can no longer connect to any linked servers. All links are native SQL Server.
When I click "test connection", the ...
- 101
1
vote
1
answer
30
views
How to re-sync the Mysql replication if Master down
I have a very simple webapp infra: FE => BE => MySQL. I have set up MySQL master-slave replication successfully. If my MySQL master node is down, I can manually point the MySQL IP to the Slave ...
ITnewbie
0
votes
2
answers
44
views
How to free up hard drive space after deleting millions upon millions of records in mariadb
We have an application where we are receiving information seconds apart, we record this information in a table that we call events, which currently weighs 240 GB, this is the largest we have so far.
...
1
vote
0
answers
14
views
SELECT INTO OUTFILE giving OS errno 13
We recently migrated from MySQL5.6.51 to MySQL8.0.28 (Ubuntu 20.04.3 LTS) and we have started noticing some differences. One of the problems has been recreated using a sample database, with a table ...
- 235
0
votes
1
answer
210
views
ERROR: could not open extension control file "/usr/share/postgresql/13/extension/postgis.control": No such file or directory
Ubuntu 21.10 , PostgreSQL 13.
I catch error
ERROR: could not open extension control file "/usr/share/postgresql/13/extension/postgis.control": No such file or directory
how to fix it?
- 111
0
votes
1
answer
79
views
MySQL 8 Replication
I've got this error message:
Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction 'ANONYMOUS' at master log mysql-bin....
Ayaa Ahmed
0
votes
2
answers
69
views
Problem importing a Dump on MariaDB (Ubuntu 20.04.4 LTS)
I am writing this post because I cannot import a dump on MariaDB (Version 15.1) using Ubuntu 20.04.4 LTS. I did this dump a few weeks ago and now trying to import it using the command
mysql -u root -p ...
0
votes
2
answers
38
views
What can malicious postgres db user do to a linux server?
Suppose I created a db user with
create role myuser login password 'xyz';
and allowed typical read and write db permissions.
If a malicious user finds these login credentials (and has access to db), ...
- 103
0
votes
1
answer
56
views
Open SQL Server data in QGIS on Ubuntu
I am trying to connect to a SQL Server (MSSQL) database from QGIS on Ubuntu.
As per the following link, I have created an odbc.ini file and the driver as per -
https://docs.microsoft.com/en-us/sql/...
- 105
1
vote
0
answers
66
views
Proper *smart* shutdown of PostgreSQL server for PGDG apt packages under Ubuntu/Debian?
I've installed PostgreSQL under Ubuntu 20.4 using the PGDG apt repository.
Each time I stop the DB server, e.g., with sudo service postgresql stop, the log says 'received fast shutdown request', but I'...
- 121
0
votes
1
answer
29
views
Why does MySQL server queries freeze on high load of connections?
Hey there I have MySQL server with the next specs:
x2 Intel Xeon XP Gold (64 cores total)
256GB of Ram
1Tb of SSD Nvme
on Ubuntu 20.04
The mysql is configured with the next settings:
[mysqld]
port=...
0
votes
0
answers
24
views
Where is mysqlpump log file in Linux/Ubuntu located
I am neither a DB administrator, nor a DevOps but I need to migrate a very large table (~500M rows) from one MySQL schema to another. For doing so, I use mysqlpumpbackup tool. Also, since the DB is an ...
- 141
2
votes
1
answer
58
views
Is there a way to install PostgreSQL using apt-get without it running initdb automatically?
I am trying to set up replication for PostgreSQL on Ubuntu 20.04 and for the stand-by node I just need to install the PostgreSQL-server and not run initdb. Cluster creation on the stand-by will be ...
- 121
0
votes
0
answers
76
views
Is it possible to update Mac mysqldump version to same version as what's available for Ubuntu?
I run the following command on Mac Big Sur
mysqldump --column-statistics=0 -v -h my host -u myuser -P 3306 -pmypass mydb my_table > /tmp/dump.sql
Which uses the following version of mysqldump …
$ ...
- 565
0
votes
0
answers
78
views
Mysql resetted after upgrading from 80025 to 80027
I was with 8.0.25-0ubuntu0.20.04.1 (as the log say), and I made apt update && apt upgrade (specially to fix some issue with other packages).
But, when upgrading, it said "Failed to ...
- 103
0
votes
1
answer
224
views
Problems with pg_upgradecluster
Friday I did an upgrade from PostgreSQL 13 to 14 with pg_upgradecluster (on Debian Buster). This worked so today I wanted to upgrade another server (Linux Mint 20.3 Cinnamon). This time it does not ...
- 3,650
0
votes
1
answer
82
views
How to backup from MySQL Ubuntu to Synology NAS MariaDB
I am facing difficulties when setting up MariaDB on Synology NAS as slave to replicate my server on Ubuntu. But there are missing commands and files (my.cnf) in the installation. Need help on any ...
- 1
0
votes
2
answers
42
views
Is there any faster methods to restore db other than mysql dump or export data
I have a db of 1.3 TB hosted in a ubuntu server. I want take backup of the db every week.
I have searched in google and many articles which suggested mysql dump or db export.
I wonder that is there ...
0
votes
0
answers
36
views
Mysql server keeps hanging when I start / restart. Stopping the server doesn't work ubuntu
This image is what happens when I try to restart MySQL. It just infinitely hangs. Above is the status, the weird thing is if I do:
mysql -u root -p
and log in It lets me interact with the server. But ...
EliteNarNar
2
votes
1
answer
60
views
MySQL Dump on Ubuntu 20.04 returns 0 byte file and runs indefinitely. Works on Ubuntu 18.04
I am using identical configs on Ubuntu 20.04 as I was previously on 18.04; however, on 20.04 the CPU shoots up to 50% usage and the process runs indefinitely, and by indefinitely I mean it was running ...
- 131
1
vote
0
answers
62
views
Why do some SQL Server databases go into a "Recovery Pending" state after shutting down / restarting on Linux?
I built a secondary PC from old parts as a server for SQL Server databases and I went with Linux/Ubuntu 20.04 because it's free. I knew it would not be easy to set this up (I'm rather a Windows user) ...
- 19
0
votes
0
answers
53
views
Failed global initialization: FileRenameFailed: Could not rename preexisting log file
I get this error while trying to launch mongo deamon.
CONTROL [main] Failed global initialization: FileRenameFailed: Could
not rename preexisting log file
"/var/lib/mongodb/log/mongod.log" ...
- 111
0
votes
0
answers
20
views
how to setup new user and password in mysql server ubuntu?
how to create a new user and password in MySQL server. And access this mysql user with multiple IP addresses by my other pc?
The most important is how to improve MySQL server security?
0
votes
3
answers
1k
views
Downgrade mysql 8.0.27 to 8.0.26 ubuntu 20.04
I set up a new AWS EC2 instance with Ubuntu 20.04, php, Apache, and mySQL. I also installed N-Able (Solarwinds) server backup.
I am able to do system and file backups but the mySQL backup fails. N-...
PeteS
0
votes
1
answer
29
views
Linux MySQL Optimization
Hey we moved to a much bigger Server and we want to optimize our performance from MySQL.
Does anyone know how to increase the performance? Or like a config generator or something like that. I don't ...
J0hn311d
0
votes
0
answers
50
views
SQL Server 2019 Express for Linux on Ubuntu 20.04 - Bug - CU 13 - c0000005 EXCEPTION_ACCESS_VIOLATION when specifying @wkt in Table-valued function
Pretty sure I've found a bug in SQL Server 2019 (Express) for Linux (CU 13, version 15.0.4178.1 running on Ubuntu 20.04 LTS). After the following table-valued function dbo.bTest is created:
use devdb
...
- 121
0
votes
2
answers
44
views
How to Check if There is Changes on a PostgreSQL DB
Is there any system table to check the changes which happened recently in a PostgreSQL DB? I have a PostgreSQL DB with just one table and once a day (time is unknown) updates happens and I want to ...
0
votes
0
answers
265
views
MySQL Error: Multiple files found for the same tablespace ID
Today my MySQL started giving me this error when I try to start the MySQL Service:
[ERROR] [MY-012209] [InnoDB] Multiple files found for the same tablespace ID
[ERROR] [MY-012202] [InnoDB] Tablespace ...
- 101
0
votes
0
answers
99
views
Error uninstalling, updating and re-installing MySQL on Ubuntu 20.04
I'm trying to uninstall and remove MySQL on Ubuntu 20.04.
If I try to install a new package, in my case sudo apt-get install putty, remove or update a package, the terminal complains with
You might ...
- 1
0
votes
0
answers
29
views
postgresql database didn't restored in ubuntu and got blank
i try to restore databse form my pc(windows) that i send it from pscp
i use this script :
sudo -u postgres pg_restore -U postgres -f /home/abura/first_backup.sql
and got blank, so i randomly click to ...
- 1
0
votes
0
answers
27
views
Where Should I Install Galera Load Balancer? On Cluster Nodes?
I want to install Galera Load Balancer for my 3-Node Galera Cluster, but where should I install the galera load balancer? Can I install on the cluster nodes or should I build a new server for galera ...
0
votes
1
answer
71
views
Create Tablespace is not working on Postgres - Ubuntu - NTFS
I cant create a new tablespace in mounted directory
psql -U sysuser -d postgres -c "CREATE TABLESPACE dadospostgres LOCATION '/media/tiago/Dados/Postgres/Bancos';"
ERROR: could not set ...
0
votes
1
answer
69
views
MariaDB Galera 3-Node Cluster Sometimes Doesn't Serves
I have 3 Node MariaDB Galera cluster. I am using "mariabackup" as the wsrep_sst_method, but the database system doesn't work properly. I can say that sometimes there are 100 connection ...
0
votes
1
answer
126
views
Install Percona Data Recovery Tool for InnoDB on Ubuntu 18
Has anyone successfully installed the Percona Data Recovery Tool for InnoDB on Ubuntu 18? I downloaded the tool here: https://launchpad.net/percona-data-recovery-tool-for-innodb/trunk/release-0.5/+...
- 133
0
votes
0
answers
254
views
Postgresql pg_logical sequence replication not synchronized
I'm testing pg_logical extension for Postgresql because we need to replicate some clusters with Postgresql 9.6 before upgrading them to newer version, where logical replication is a core feature.
I've ...
- 125
-1
votes
1
answer
40
views
Error log "[Warning] InnoDB: innodb_open_files=10 is exceeded (10) files stay open)"
I just created a new Digital Ocean VPS, and when looking at my log file it gives me this warning. I'm running a wordpress site.
Any ideas what this is? Do I need to increase this, and by how much?
- 99
1
vote
1
answer
104
views
Intermittent SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'server.here' (110)
I'm suddenly having intermittent 2003 connection errors and I can't find anything that has changed that can explain it. These servers have been running smoothly for years and suddenly two days ago ...
- 111
0
votes
1
answer
25
views
Postgresql log uploading service on Ubuntu Linux
I am trying to create a systemctl service to collect + upload logs for Postgresql 12 on Ubuntu Linux. However, I am expert at none of the two.
While I have set up the server modifying /etc/postgresql/...
- 103
0
votes
0
answers
56
views
PostgreSQL- replication server lags behind the master - memory usage too high
we have a classic physical replication with primary and secondary nodes. The two nodes are also monitored by software.
There are always lags between the primary server and secondary server when there ...
0
votes
0
answers
29
views
How to restore mysql database schemas with its data in ubuntu?
Accedednlty
one of my employees ran a script into the production server instead of the development server.
so he dropped 7 columns with its data.
i everyday backup all my server files into another ...
- 101
0
votes
1
answer
184
views
MySQL keeps crashing - Error establishing a database connection
I had installed wordpress on ubuntu 20.04 on 2GB/2CPU and I have a problem with my MySQL server that keeps crashing. Everyday we are getting below error :
error establishing a database connection and ...
1
vote
0
answers
111
views
Postgres stops about every 2-3 weeks. Says it was shutdown by an admin but I'm the only admin
Postgresql 12.8 on Ubuntu 20.04.1
This system is running a single java application that talks to the database. Only one user can log into the system (expedite) and only that user runs anything. No ...
- 11
1
vote
1
answer
67
views
restarting master and slave machines without breaking master slave MySQL replication
We need to resize the size (CPU and RAM) of two database servers having MySQL server 8: master and slave, but this operation implies that those machines will be restarted, And I think a restart of ...
- 123
1
vote
2
answers
960
views
"connection failed" error for pg_cron extension
Installed pg_cron and scheduled job, though there is connection error because job is not done and cron.job_run_details table shows connection failed error message.
As doc says:
Important: Internally, ...
- 415
0
votes
1
answer
133
views
MariaDB on Ubuntu mysteriously goes away after 15 minutes [closed]
I have an issue I've never seen before...my MariaDB goes away after 1800 seconds, despite having the default configuration for wait_timeout of 28800 seconds.
I checked all my my.cnf files, and there ...
- 581
-1
votes
1
answer
116
views
Error in Master/Master replication between Mysql 8 and Mysql 5.6
I've setup master to master replication Between a Mysql 5.6 and Mysql 8.0 server. I can get both slaves to run on both servers. Except when there is a change made on the Mysql 8.0 server (e.g. ...
- 1
0
votes
3
answers
153
views
adding the right index to a table in a MySQL Database
We are having a big problem of high CPU usage of MySQL process in our database server, after investigation we have found that a big part of slow queries are related to a specific table and a big ...
- 123