Skip to main content
The 2024 Developer Survey results are live! See the results

Questions tagged [linux]

A widely-used open-source operating system that is particularly popular on servers.

Filter by
Sorted by
Tagged with
1 vote
0 answers
23 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 ...
Avinash Pawar's user avatar
0 votes
0 answers
13 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-...
Avinash Pawar's user avatar
0 votes
1 answer
33 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 ...
Eric Swiggum's user avatar
0 votes
0 answers
70 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 & ...
Juraj 's user avatar
0 votes
0 answers
19 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 ...
Hugh Clark's user avatar
0 votes
0 answers
26 views

DB2 on CIS Amazon Linux 2023 Benchmark - Level 1

By following an tutorial blog of installing DB2 on Amazon Linux, after solving many dependencies error, in the end I'm facing an issue where I can't start the DB2. Some troubleshooting steps I did on ...
Yitasha's user avatar
0 votes
2 answers
68 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 ...
postgresnewbie's user avatar
0 votes
0 answers
54 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 ...
Kyle's user avatar
  • 1
1 vote
0 answers
9 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 ...
user10709800's user avatar
0 votes
1 answer
18 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", ...
miguel ramires's user avatar
0 votes
0 answers
29 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....
Pavel Orekhov's user avatar
1 vote
1 answer
77 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 ...
user avatar
1 vote
1 answer
80 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: ...
Ahmad's user avatar
  • 11
1 vote
2 answers
73 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 '...
Ssaf's user avatar
  • 11
0 votes
0 answers
21 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 ...
KelvinCodes's user avatar
1 vote
1 answer
173 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, ...
Макс Самшит's user avatar
1 vote
1 answer
120 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). ...
Gregg Leventhal's user avatar
0 votes
0 answers
20 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 ...
Vivek Kumar 's user avatar
0 votes
0 answers
44 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 ...
ArrowInTree's user avatar
0 votes
0 answers
34 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 ...
Dudoserg's user avatar
0 votes
0 answers
199 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 ...
Vaughn's user avatar
  • 101
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 ...
Pablo Arriola's user avatar
0 votes
0 answers
71 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 ...
Chris's user avatar
  • 191
0 votes
0 answers
11 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 ...
Raymond's user avatar
  • 101
0 votes
2 answers
138 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 ...
jmichaelwDBA's user avatar
0 votes
0 answers
21 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?
f8neto's user avatar
  • 1
0 votes
0 answers
67 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 ...
Andrei Lagutin's user avatar
0 votes
0 answers
45 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 ...
Pasquale Meo's user avatar
-2 votes
1 answer
131 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 ...
kali's user avatar
  • 7
1 vote
0 answers
34 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, ...
jedison's user avatar
  • 111
0 votes
0 answers
24 views

SSMS. Anyway to connect via AWS session-manager to an mssql instance?

I have a sqlserver (express) instance running on an ubuntu server ec2 instance. This is on an AWS private subnet so I cannot just open port 1433 for sql access. We use AWS session manager to connect ...
Jamie GF's user avatar
0 votes
1 answer
71 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 ...
0xD4rky's user avatar
0 votes
0 answers
15 views

How to expand storage in Single node Elasticsearch

We need to increase storage capacity for Elasticsearch working on a Single CentOS node. Even if Elasticsearch support multiple path I don't think it's useful and they also suggest not to use it. Other ...
goodfella's user avatar
  • 168
1 vote
2 answers
1k 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 ...
miracle173's user avatar
  • 7,735
0 votes
0 answers
20 views

Postgresql in Colab using the wrong link

So I am trying to set up Django and PostgreSQL in Google Colab but I ran into an error when trying to test postgres. I created the user, password and the database and it says that my db called "...
Ran123's user avatar
  • 11
0 votes
1 answer
116 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. ...
datascinalyst's user avatar
0 votes
0 answers
16 views

Geting ORA-01017 after copying oracle home directory to different linux server

-- Oracle V 12c I have two different servers. I have copied the entire oracle directory from one server to another, and now I am using made relevant changes in .bash_profile. when executing sqlplus, ...
datascinalyst's user avatar
0 votes
0 answers
68 views

MySQL access denied problem - random, sudden password changes?

It looks as if my MySQL password is randomly changing after some time. I lose access - i can't log in with the password. I have to set it up again for it to work, and after about one hour do it again. ...
Kiler_630's user avatar
1 vote
0 answers
74 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 ...
supmethods's user avatar
-1 votes
1 answer
612 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/...
user avatar
0 votes
0 answers
180 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 ...
D Lepp's user avatar
  • 1
0 votes
0 answers
55 views

MySQL 5.7 - could not establish connection (every 2 months or so) - how to log / ID issue?

I have a v5.7.42 MySQL server (community) running on Ubuntu 20.04.6 LTS - My issue is about every two months or so , the site will show could not establish connection to database, service mysql status ...
James Gaul's user avatar
0 votes
0 answers
212 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 ...
user avatar
0 votes
0 answers
60 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. ...
Joel Firestone's user avatar
0 votes
1 answer
25 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 ...
hedgedandlevered's user avatar
0 votes
1 answer
40 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 ...
Oleg Lavrov's user avatar
1 vote
2 answers
871 views

Assigning multiple IP addresses to MongoDB 7.0 on Ubuntu

The Problem I am trying but failing, in MongoDB 7.0, on Ubuntu, to bind multiple IP addresses to net.bindIp in mongod.conf What I have tried I have tried 127.0.0.1,x.x.x.x, 127.0.0.1;x.x.x.x, [127.0.0....
Yenmangu's user avatar
0 votes
1 answer
81 views

Postgres keeps forgetting my data

I'm fairly new to Postgres, having spent years with MySQL/MariaDB. I have a Postgres 14.9 database for development with two schemas in it. When I lose power, both of the schemas still exist in the ...
aswine's user avatar
  • 143
0 votes
0 answers
1k views

PostgreSQL Server Timeout Issue with pgAdmin, pgAdmin Web, and DBeaver

I am using PostgreSQL 15.4 on Ubuntu 22.04. Initially, I used pgAdmin 4 for managing the database. However, I've been facing an issue where pgAdmin stops responding after some time. This issue seems ...
Purushottam Nawale's user avatar
0 votes
3 answers
2k views

Installing DBD:Oracle on RedHat 8.8

I am trying to install DBD:Oracle. I'm in the following environment: Red Hat Enterprise Linux release 8.8 (Ootpa) Perl v5.26.3 Our DBA installed the Oracle 19 client in this location: /u01/app/oracle/...
Stev's user avatar
  • 1

1
2 3 4 5
21