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.

Filter by
Sorted by
Tagged with
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 ...
user avatar
-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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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. ...
user avatar
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 ...
user avatar
  • 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?
user avatar
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....
user avatar
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 ...
user avatar
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), ...
user avatar
  • 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/...
user avatar
  • 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'...
user avatar
  • 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=...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 … $ ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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) ...
user avatar
  • 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" ...
user avatar
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?
user avatar
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-...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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/+...
user avatar
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 ...
user avatar
  • 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?
user avatar
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 ...
user avatar
  • 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/...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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, ...
user avatar
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 ...
user avatar
-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. ...
user avatar
  • 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 ...
user avatar

1
2 3 4 5
11