Questions tagged [linux]
A widely-used open-source operating system that is particularly popular on servers.
1,002
questions
-1
votes
0
answers
9
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 ...
1
vote
1
answer
42
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). ...
0
votes
0
answers
11
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
32
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
24
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 ...
0
votes
0
answers
54
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 ...
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 ...
0
votes
0
answers
27
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 ...
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 ...
0
votes
2
answers
61
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 ...
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?
0
votes
0
answers
43
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
33
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
76
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 ...
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, ...
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 ...
0
votes
1
answer
44
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 ...
0
votes
0
answers
14
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 ...
1
vote
2
answers
514
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 ...
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 "...
0
votes
1
answer
56
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.
...
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, ...
0
votes
0
answers
45
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.
...
1
vote
0
answers
57
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 ...
-1
votes
1
answer
345
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/...
0
votes
0
answers
123
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 ...
0
votes
0
answers
50
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 ...
0
votes
0
answers
166
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 ...
0
votes
0
answers
53
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
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 ...
0
votes
1
answer
31
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 ...
1
vote
2
answers
542
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....
0
votes
1
answer
59
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 ...
0
votes
0
answers
949
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 ...
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/...
1
vote
0
answers
37
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 ...
0
votes
0
answers
23
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'...
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 ...
0
votes
0
answers
52
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?
0
votes
1
answer
307
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 ...
0
votes
1
answer
123
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. ...
-1
votes
1
answer
107
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....
0
votes
3
answers
723
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 ...
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 ...
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 ...
0
votes
1
answer
38
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 ...
6
votes
2
answers
503
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 ...
2
votes
1
answer
122
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 ...
0
votes
1
answer
95
views
Unable to use data pump utility in Oracle to import data to another server
I am using this command:
impdp atif/[email protected]:1521/serv1 DIRECTORY=DATA_PUMP_DIR DUMPFILE=mltpltblbkp.dmp LOGFILE=mltpltblbkp.log
to import data from one server to another.
this is my ...
1
vote
2
answers
87
views
How is cassandra 9042 port used in the context of lsof command?
I am trying to identify who is making connection to cassandra instances in my environment. The machine has ip 172.31.44.23. I ran the command sudo lsof -i -n -P | grep 9042 | grep ESTABLISHED | awk ' ...