Questions tagged [linux]
A widely-used open-source operating system that is particularly popular on servers.
1,016 questions
0
votes
0
answers
21
views
The repository 'https://apt.postgresql.org/pub/repos/apt jammy-pgdg InRelease' is not signed - Error while installing Postgres14 in Ubuntu 22.04
I was trying to install PostgreSQL 14 database in Ubuntu 22.04 version as per the steps provided in the official Postgres site. But while updating the package list, I'm getting an error message. Could ...
- 377
0
votes
0
answers
29
views
PostgreSQL 13 logical replication keeps dying
For some time now I keep facing the same issue on PostggreSQL 13.14 cluster - there are 6 replication slots, 5 for one client server (different tables, same target db) one for other client (some ...
1
vote
0
answers
40
views
cryptographic errors seen when using FIPS enabled OS with AO Availability Group
I'm looking for some help here to figure out the problem I'm facing with AOAG and FIPS enabled OS.
SqlServer version:
Microsoft SQL Server 2022 (RTM-CU15-GDR) (KB5046059) - 16.0.4150.1 (X64)
...
2
votes
1
answer
140
views
How to prevent the 'default_native_password is deprecated' error in mysql?
I have the default password functionality enabled in mysql version 8.3.0.
I am intentionally using this functionality.
MySQL is writing to the error log:
''mysql_native_password' is deprecated and ...
0
votes
0
answers
40
views
Understanding MySQL Memory Usage
I’m trying to understand MySQL’s memory usage on a Linux server. Here's the memory information from my server:
Total Memory: 123GB
Memory Used: 57GB
Output from free -h :
total ...
- 21
0
votes
0
answers
253
views
MySQL failes to start due to Failed to initialize DD Storage Engine
This is the error code got in mysql error log, MySQL failes to start due to Failed to initialize DD Storage Engine. Please tell
[System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.39) starting ...
iamsaranraj
0
votes
0
answers
61
views
Auto_increment doesn't change after alter table
We switched servers and hosting, and on the new server after writing:
ALTER TABLE table_name AUTO_INCREMENT=some_number;
we see notification that it's changed and everything ok, but when we check it ...
2
votes
1
answer
337
views
MariaDB *M!999999 error on 11.5.2 preventing import of sql dump
I recently upgraded to MariaDB 11.5.2. The database was also updated via the update command and I ensured the version I was running.
I exported using the MariaDB-dump (i also ensured this was the same ...
- 51
0
votes
0
answers
83
views
SQL Server on Linux - Error while loading libraries
I'm trying to install SQL Server on Linux.
I'm running Ubuntu 22.04.3 LTS installed on WSL 2.
I try to start SQL Server with the following command:
/opt/mssql/bin/sqlservr
I get the following error ...
3
votes
2
answers
537
views
Getting "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'" when attempting to setup log shipping on Linux for a SQL Server database
We have a SQL Server instance installed on an AWS EC2 instance with a Linux operating system (no idea why this would be done) with hundreds of databases that need moving to a better place. In the ...
- 172
1
vote
1
answer
67
views
Difference between flushing and synchronisation and writing to disk (MySQL)
I get confused with the terminology such as flushing and writing to disk and synchronising to the disk. Could someone please explain me what is the difference between flushing and writing and ...
- 226
1
vote
0
answers
42
views
mydumper packages availability for graviton aarch64
I am trying to implement mydumper for mysql community server (8.0), in absence of xtrabackup for graviton aarch64 architecture.
Unfortunately packages are not available for graviton aarch64 ...
- 226
0
votes
0
answers
27
views
Percona xtrabackup and percona toolkit for aarch64 Graviton Amazon Linux 2 machines
In my organisation, it was decided to move all the MySQL infrastructure (Amazon EC2 machines) to Graviton (aarch64) servers from AMD (x86_64).
All are MySQL Community Servers.
I need percona-...
- 226
0
votes
1
answer
42
views
How can I find or log inbound traffic connecting to a PostgreSQL database instance?
I have a postgres instance where I need to find out who/what is connecting. The installed version of postgres is 9.0.1. The instance sits on a linux box, SUSE I believe. Where could I look if it is ...
- 680
0
votes
1
answer
216
views
Problem with many connections from RHEL 8.10 to SQL Server
I have simple script:
for i in {1..1000}
do
isql -v -k "Driver={ODBC Driver 17 for SQL Server};Server=mssqlserver,1282;Database=dbname;UID=user;PWD=xxx;Encrypt=no" >> aaa.log &
...
- 11
1
vote
0
answers
31
views
Restoring of OLTP In-Memory DBs in SQL 2022 on Ubuntu really slow
We've started using OLTP In-Memory tables (schema durability only) in a small DB (DB properties show 137 MB of Row data, 1GB of In-Memory data, BAK size of 152MB) and the recovery times (either ...
- 11
0
votes
2
answers
729
views
How to Restore RMAN Backup at Specific Date
I have daily backups of my test system which is taken daily full backups and also hourly arch backups. I need to restore one of these backups to another linux server. I've completed all steps until ...
- 127
0
votes
0
answers
135
views
Cannot connect PSQL to local Postgres database
PSQL is failing to connect to Postgres 16 running on the local Fedora 40 Linux server.
I can connect from a remote server or through PGAdmin using pqsl, but not locally. I get the same error when ...
- 1
1
vote
0
answers
11
views
mysql build error on Raspberry Pi Model 3A+ with Raspbian
I am building MySQL version 8.0.37 on a Raspberry Pi Model 3A+ with the Raspbian OS.
I have encountered several build errors regarding missing dependancies and resolved them. I am now faced with an ...
- 21
0
votes
2
answers
82
views
How to rename hostname in a Mongodb replica set
I need to know how I can rename my hosts belonging to my replica environment in mongodb, I currently have the following configuration:
rs.conf()
{
"_id" : "myreplicaset01",
...
- 169
0
votes
0
answers
97
views
What do wal_sync_method options mean?
I was reading this doc about wal_sync_method:
https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-WAL-SYNC-METHOD And also this: https://www.postgresql.org/docs/current/wal-reliability....
- 121
1
vote
1
answer
242
views
MySQL processes consuming too much VIRT and RES memory
i have over 100 wordpress websites on a server with 64GB ram and 16 processors
I recently isolated 5 of them with PHP-FPM pool, but in the process also migrated them from php7.4-fpm to php8.3-fpm.
Now ...
Zhivko Apostoloski
1
vote
1
answer
379
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:
...
- 11
1
vote
2
answers
195
views
mysql threads connected more than processlist and established connectios
Recently we have been facing an issue with MySQL. We use Percona MySQL 8.0.21 and set max_connectios to 7000. Sometimes in peak times, we reach 7000 connections and when we run show status like '...
- 11
0
votes
0
answers
27
views
Skip Deleterows_v1 event errors MariaDB on replication slave
So i'm running an custom HA setup for CyberPanel.
Now their is an issue that stops the replication: skip Could not execute Deleterows_v1 event error mariadb
I wanna skip these errors. How can i do ...
1
vote
1
answer
402
views
Non-yielding Scheduler Error in SQL Server 2019 on Docker with CDC Enabled
I have deployed an instance of SQL Server 2019 on Kubernetes, and I’ve enabled Change Data Capture (CDC) on the SQL server.
Periodically, I encounter a “Non-yielding Scheduler” error in the logs, ...
- 31
2
votes
1
answer
360
views
Postgres hugepages, at what point will it actually use hugepages?
I enabled hugepages on a new Postgres 13 DB, running on EL8 Linux (huge_pages=try), and noticed that Shmem is still growing and no hugepages are being used yet (but I see that the hugepages are set). ...
- 125
0
votes
0
answers
25
views
cassandra stress test results showing dropped performance in C* version 4.1.3 compare to 4.0.5
we are planning to upgrade our cassandra cluster running on version 4.0.5 to 4.1.3.
Before upgrade, we performed stress-test on both version.
steps we followed :-
created 3 node cassandra cluster ...
0
votes
0
answers
64
views
Bitnami mongod fails with 'MongoServerSelectionError'
Bitnami's Mongo image launched under virtualbox works and brings up the text console (debian11 so no X11). Debian instance starts the listener correctly according to ss -atpn. But starting mongosh ...
0
votes
0
answers
58
views
Postgres DISK IO very high
I have very little experience in database administration, so I would like to ask you for help. I'm working on a home project that collects product information from one of the marketplaces.
I'm ...
- 9
0
votes
0
answers
381
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 ...
- 101
0
votes
1
answer
63
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 ...
- 101
0
votes
0
answers
101
views
Error connecting to MySQL server after creating a Docker container
Working on a Ubuntu 22.04 system with MySQL 8. I have a legacy collection of MySQL data/dbs on an external harddrive that I used a Docker container and MySQL image to connect to and export. This ...
- 191
0
votes
0
answers
15
views
Quicker & automated way to replicate mysql from master to slave
I want to replicate around 60 databases from master to slave server. I've read this guide https://dev.mysql.com/blog-archive/get-mysql-replication-up-and-running-in-5-minutes/ and few other. It's ...
- 101
0
votes
2
answers
201
views
Help with high CPU on Oracle Rac node caused by Oracle processes with *_so and *_ag in the process command name
I have one node in a RAC cluster that is seeing very high CPU and it seems to be caused by several Oracle processes ending with _ag and _so in the process command name. The other node is not seeing ...
- 31
0
votes
0
answers
27
views
I need to install MySQL 5.0.9 on a CentOS
I need to install MySQL 5.0.9 on a CentOS. But I'm failing. I realize that the installation is different from MySQL 5.7. Some help?
- 1
0
votes
0
answers
87
views
PostgreSQL: How and Why does the WAL (Write-Ahead Log) Grow?
I have a problem with the growing number of WAL files, and they just keep increasing. How can I influence this? I have already deleted old transactions and unnecessary replication slots, which ...
0
votes
0
answers
66
views
mariaDB master/slave do not replicate
I'm having problems creating an infrastructure for mariaDB, master/slave.
I followed this guide:
https://hevodata.com/learn/mariadb-replication-easy-steps/
everything seems to have gone well until the ...
-2
votes
1
answer
202
views
MariaDB InnoDb & Columnstore
I have a DB mariadb with innodb tables with one, two million records.
I checked online and saw that Columnstore is faster.
I created a Columnstore table in my DB and put all the contents of the Innodb ...
- 7
1
vote
0
answers
36
views
GridDB on Oracle Linux
I need to install GridDB on an Oracle Linux 7.9 machine. There are 3 GridDB distributions, for:
CentOS 7.9
Ubuntu 18.04
openSUSE 15.1
I am ruling out Ubuntu as being the farthest from Oracle Linux, ...
- 111
0
votes
1
answer
99
views
Reading data from PostgreSQL backup directory
Let's say I have a backup directory containing PostgreSQL data from some other system. By default, the data is stored at /var/lib/postgresql. After changing the default data directory to the path of ...
- 1
1
vote
2
answers
2k
views
How to configure the location of the Oracle password file?
When I start an Oracle instance with sqlplus the paths to the datafiles are stored in the control files, the control file name is stored in the control_files initialization parameter. The ...
- 7,751
0
votes
1
answer
309
views
Reset root password in MySQL
I am logging in with root user in MySQL, and the server has been hardened, so this parameter is set default-authentication-plugin=caching_sha2_password, and this is currently the only user I have.
...
1
vote
0
answers
90
views
MySQL crashed and process in zombie state
MySQL server crashed and was in a zombie state. Attempted to send kill -s SIGCHLD to the parent process but failed. Killing the parent was not an option since it was the init process and I was forced ...
- 129
-1
votes
1
answer
773
views
How do i fix "InnoDB Plugin initialization aborted with error Generic Error"
i am running a Nextcloud Server on a Ubuntu 20.04 which was running fine. I wanted to upgrade the Nextcloud Version and make a backup before. This is what i did:
plugged in a external harddrive (/dev/...
Ruben247
0
votes
0
answers
235
views
MS SQL server runs slowly on new Linux server
I am running a relatively small Access application with an SQL server 2019 backend, and have recently updated my ~10+yr old Linux system that is running the server. I was surprised to find that SQL ...
- 1
0
votes
0
answers
284
views
I can't create tablespace in Oracle
I have deployed an oracle database running on docker and use navicat to connect to the oracle database. But when I tried to created a tablespace, I failed to make it.
sql : Create tablespace tbs ...
CodeRabbit
0
votes
0
answers
73
views
Mount MariaDB data in a separate directory on RHEL 8?
We are migrating from a CentOS 7 server (physical server) to RHEL 8 (Azure server). This server was setup by someone else, and admittedly I know enough to install/configure LAMP. I am not a sysadmin.
...
0
votes
1
answer
29
views
migrate mysql dbs from old linux drive
I have an intact file system with a nonworkable old installation of linux. All the mysql pieces are there fine, I can see all the data files, but I can't figure out how to access them. I've tried a ...
- 101
0
votes
1
answer
55
views
MSSQL 2019 CU16 on Linux: virtual_address_space_committed_kb vs RSS
I am running SQL Server 2019 CU15 on Linux in kubernetes and trying to investigate why SQL Server pod gets killed by OOMKiller. I see some inconsistency in reporting of memory consumption. SQL Server ...
