Questions tagged [linux]

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

Filter by
Sorted by
Tagged with
1 vote
1 answer
4 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
11 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 votes
0 answers
12 views

MariaDB Issue Starting

I have MariaDB installed but I am unable to get it to run, this is what I am getting when I try to run it: [andy@andy-laptop ~]$ sudo systemctl status mysqld × mariadb.service - MariaDB 11.3.2 ...
Andrew Na's user avatar
1 vote
1 answer
58 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
12 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
37 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
25 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
81 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
33 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
34 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
10 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
64 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
19 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
51 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
35 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
85 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
33 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
20 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
48 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 ...
mediocre's user avatar
1 vote
2 answers
671 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,662
0 votes
0 answers
17 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
66 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
51 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
59 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
409 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
132 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
51 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
172 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
56 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
24 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
32 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
600 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
63 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
2 answers
1k 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 vote
0 answers
40 views

Why does mysqld use much more memory than expected?

Running MySQL 8.0.24, I have been recently seeing frequent instances where the RHEL7 OS will kill the mysqld process as the system memory gets all used up. The server has 65 GB of memory, and I think ...
TFR3's user avatar
  • 11
0 votes
0 answers
24 views

Access MySQL remotely with terminal and PHPMyAdmin

First I must say that it's the first time I'm doing this kind of stuff, I'm a bit confused. I've uploaded a MySQL database to a website I bought few hours ago which I can access through PHPMyAdmin. I'...
Zep's user avatar
  • 1
0 votes
0 answers
45 views

MongoDB replication fails around 1900 GB with error-Too many open files

My MongoDB replicaset running in cloud and onprem on version 2.6.12. The replication between the two is failing everytime it reaches around 1900 GB. I have tried the below steps but the replication ...
Abhinav Kumar's user avatar
0 votes
0 answers
54 views

How to create replica set of mongodb in ubuntu and enable it?

I am using MongoDB community edition in Ubuntu 22.04. How can I make replica set in my local machine and how can I enable it to use in my node js application?
user avatar
0 votes
1 answer
349 views

Cannot restore MySQL into existing DB - get ERROR 1050 (42S01): Table 'blahblah' already exists

I can restore from mysqldump wordpress-db > mysqldump-wpdb.sql to new DB fine with $ sudo mysql wordpress-db001 < mysqldump-wpdb.sql But if the DB already exists (as they generally do with a ...
TickboxPhil's user avatar
0 votes
1 answer
125 views

How to restore a SQL Server bak file (Enabled FileStream ) to Docker version SQL Server?

I have SQL Server 2014 installed on Windows and enabled the FileStream feature. I backed up the database to a .bak file. Now I want to restore the file to my Docker container of SQL Server 2019. ...
XBruce's user avatar
  • 1
-1 votes
1 answer
110 views

How to make sqlplus parse stdin?

I have the data in the following form: 10334,99.4,4241 14354,99.5,6018 16807,93.9,2279 22042,97.5,70341 22117,96.4,70335 22138,95.7,70332 23869,94.4,135649 23937,97.5,135642 23982,96.6,135638 24055,95....
Nikita Kipriyanov's user avatar
0 votes
3 answers
801 views

How can I purge MySQL binlogs if MySQL is turned off

I am using Digital Ocean droplets for my WordPress Site. There are more than 60 binlog files in /var/lib/mysql. Most of the solutions say that I should purge them from MySQL. The storage is so full ...
Sky Lurk's user avatar
  • 101
4 votes
2 answers
3k views

How can I get a list of locales in PostgreSQL?

I want to change number and currency format using something like: SET lc_numeric='en_AU.UTF-8' SET lc_money='en_AU.UTF-8' I tried a number of formats for, say, Dutch, but nothing works. It appears ...
Manngo's user avatar
  • 2,819
2 votes
1 answer
1k views

psql \set an environment variable from the existing shell environment

I want to set up a psql variable from an existing shell environment variable that I can use in later psql commands. I found the \set meta-command, but I'm not able to make it use an existing ...
s.k's user avatar
  • 362
0 votes
1 answer
40 views

Does the order in which vms are shutdown impact the postgresql replication environment?

I have the following environment: A postgres server (rhel8, postgresql v14) as master and another as standby. I need to do a maintenance task on the infrastructure and for this reason both vms need to ...
miguel ramires's user avatar
6 votes
2 answers
545 views

MSSQL Server 2022 on Linux: sys.* tables very slow for non-db_owner users

Querying sys-tables, for instance sys.columns, sys.indexes or sys.tables, has become significantly slower on SQL Server 2022 on Linux for users which are not db_owner. To reproduce, take a SQL Server ...
final's user avatar
  • 325
2 votes
1 answer
123 views

SQL Server on LInux - OpenRowSet function only has access to files in /var/opt/mssql directory?

I have a file I want to import into an SQL Server 2019 database running on Ubuntu 20.04. The file resides in the /proc directory and I have done a chmod 777 on that file. However, when trying to read ...
Dean Richards's user avatar

1
2 3 4 5
21