Questions tagged [linux]
A widely-used open-source operating system that is particularly popular on servers.
979
questions
0
votes
0
answers
14
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 ...
0
votes
0
answers
17
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
29
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
18
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
23
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 ...
0
votes
1
answer
66
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....
- 1
0
votes
1
answer
26
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 ...
- 143
0
votes
0
answers
92
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
138
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
1
vote
0
answers
19
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 ...
- 11
0
votes
0
answers
8
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'...
- 1
0
votes
0
answers
28
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
21
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?
Tanzim Ahmed
0
votes
1
answer
51
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 ...
- 138
0
votes
1
answer
62
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
-1
votes
1
answer
63
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
0
answers
116
views
MySQL CPU 200% - 300% Help me!
Good morning everyone,
I write to you because I'm desperate and I can't find the solution:
I have mysql CPU going over 200-400% causing me to slow down and almost crash the only website hosting the ...
user274959
0
votes
3
answers
130
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 ...
- 101
2
votes
2
answers
847
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,709
2
votes
1
answer
401
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 ...
- 342
0
votes
1
answer
21
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 ...
- 149
2
votes
1
answer
81
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
26
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 ...
- 54
1
vote
2
answers
46
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 ' ...
1
vote
1
answer
49
views
[[FATAL]] [[DBT-06103]] The port (5,500) is already in use in Docker Container
I'm trying to use Oracle 19c DB Container for my test cases in Jenkins Job but DB Container is intermittently failing with this error
[FATAL] [DBT-06103] The port (5,500) is already in use.
ACTION: ...
1
vote
0
answers
88
views
PostgreSQL data_directory doesn't match value set in postgresql.conf [closed]
I've recently updated from version 14 to 15 and I can't figure out why it's still using the data directory for 14.
I've verified that I'm using version 15.
$ sudo -u postgres psql -V
psql (PostgreSQL) ...
- 111
1
vote
2
answers
361
views
Issue configuring Postgresql for remote connection: 'Job for postgresql.service failed'
I'm trying to configure Postgresql 14.7 for remote connections in a SLES15 environment. I've been following the instructions from Postgres for Zypper installation supplemented with these instructions ...
- 113
0
votes
0
answers
222
views
Mongoexport query using date range on Linux
I'm trying to run mongoexport using this query:
mongoexport --db=database --username=user --password=pass --collection=coll --type=csv --fields=Name --query='{ "Date" : { "$gte" : {...
Fernanda Andretto
0
votes
0
answers
54
views
Linux PostgreSQL backup single schemas + data into individual files
Is there a way to backup only the schemas (plus their relative data) of a PostgreSQL DB individually, into single dedicated files?
I'm on Linux CentOS 7, hopefully there's some way to automate this so ...
0
votes
0
answers
150
views
MSSQL replication snapshot agent fails
I'm using MS SQL server 2019 on Linux. I'm trying to create a transactional replication.
The problem is that when I create a publication, the snapshot agent can not start.
Basically, I'm getting this ...
- 1
1
vote
1
answer
61
views
Oracle ASM for data files - "not recommended" - why not
I've been supporting a lot of Oracle databases (not full-time; I'm a programmer 90% of the time) and I just happened to see in the Oracle 19 Linux Installation document that storing Oracle data files ...
- 1,113
0
votes
1
answer
103
views
mysqld how to only listen on unix socket?
how do i make mysqld not use ip at all, only listening on an unix socket? if i do
mysqld --socket=mysql.sock
it still opens port 3306, and if i do
mysqld --bind-address='' --socket=mysql.sock
it ...
- 103
1
vote
1
answer
1k
views
Cannot connect on psql specifying connection string postgres
On my Ubuntu machine, I have installed postgres 15. I created a new superuser called "test" (with password "test"). Then, I created a database called "test" as well and ...
- 111
0
votes
0
answers
201
views
MSSQL error when creating publication
I'm using one MSSQL server (SQL server 2019 on Linux, to be precise, on Kubernetes) as a distributor and publisher. I tried to configure it as a transactional publication using SSMS.
The problem that ...
- 1
1
vote
1
answer
345
views
PostgreSQL uses huge amount of memory
When executing a query containing WITH and more than a thousand UNION ALL, PostgreSQL version 14 or higher uses all server memory until it enters recovery mode. In tests with version 11, this behavior ...
1
vote
1
answer
210
views
Allow connection to mongo only from my server droplet
Recently I created a server with MongoDB preinstalled on a DigitalOcean droplet following these tutorials
DigitalOcean - Initial server setup
DigitalOcean - How to secure MongoDB on Ubuntu
Medium - ...
- 11
-1
votes
1
answer
717
views
Why MariaDB server is consuming SWAP when there is available memory?
I have a dedicated server for MariaDB 10.8.3 and the features as follows:
248GB free disk space.
innodb_buffer_pool_size = 12286766080
binlog_cache_size=8M
Memory results:
[root@server user]# free -h
...
- 129
0
votes
1
answer
430
views
Mysql Replication Error: Waiting for master to send event
My replica db can't update master update.
When I write on my replica
Show slave status\g
its result:
*************************** 1. row ***************************
Slave_IO_State: ...
furkan aydınlı
1
vote
2
answers
415
views
Apache Cassandra 3.11.2 unable to start Centos 7
I am trying to start Apache Cassandra 3.11.2 on Centos 7 and I get error Exception:
ERROR [main] 2023-02-22 11:19:03,067 NativeLibraryLinux.java:64 - Failed to link the C library against JNA. Native ...
- 23
0
votes
0
answers
102
views
bitnami /opt/bitnami/mysql/data increases in size by itself
how are you? I have been trying to solve this for a long time and I have not been able to, the case is like this.
I have an instance in amazon lightsail it was 1 GB RAM, 1 vCPU, 40 GB SSD
but due to ...
1
vote
1
answer
171
views
high CPU with high user connection, mysql database
I use a VPS with 56 CPU cores and 64 GB of memory, a with MySQL database, but the CPU usage is always high for my apps - user 10.000.
This is in my mysqld.cnf. What's wrong with my settings?
...
1
vote
0
answers
345
views
After creating a table in postgres with psql, \dt gives "Did not find any relations"
I'm working with postgres14 in a docker container on a remote Rocky Linux VM. After a little bit of pain I managed to access the database from outside the container, at which point I wanted to create ...
- 11
0
votes
1
answer
246
views
sqlplus: command not found Using SSH on Windows to VMware linux
I have oracle Database 12c in a virtual machine with the database working normally in a linux environment (Centos).
Through windows, using ssh I was able to connect to the linux virtual machine. But ...
- 3
0
votes
2
answers
130
views
Command line command to read Oracle Database export Success Message In log File
We have several oracle 19c servers with daily exports. I would like to find a way to run a command to read the export log file to find the success message for the day. e.g. I would like to putty into ...
- 1
0
votes
0
answers
70
views
Linux PostgreSQL 9.4 to Windows PostgreSQL 13
I had to switch from PostgreSQL 9.4 on Linux to PostgreSQL 13 on Windows
Normal restore was not successful.
Can somebody share experience with such case?
EDIT 1:
On linux I use:
pg_dump -c -O -U ...
- 119
0
votes
0
answers
566
views
PostgreSQL connection accepted without providing SSL certificates
Hopefully someone might be able to shed a light on this problem.
I've configured two servers, both of them have the same problem.
I've implemented SSL configuration, on PostgreSQL 11.18, I have ...
0
votes
0
answers
41
views
remove unix user named postgres after complete uninstallation of postgresql
I'm running MX Linux 21 and recently installed PostgreSQL-13; I wanted postgres to have read, write and execute access to a certain folder therefore I added the unix user postgres to the group of ...
- 101
2
votes
1
answer
180
views
Is there a short and proven linux shell command or script to safely perform a major-release upgrade on a mariadb docker container?
The question is basically in the title already. At first I thought about a one-liner but maybe a short script is fine as well.
The command or script is meant to initiate all updating on the actual ...
- 123
0
votes
1
answer
266
views
Unable to connect to server following phpMyAdmin upgrade from 5.1 to 5.2
Not sure to post on the right StackExchange forum. If not, let me know!
Working environment:
OpenSUSE Leap 15.4
MariaDB : mariadb Ver 15.1 Distrib 10.7.7-MariaDB
PHP 8.0.25 (cli) (built: Oct 31 2022 ...
- 317
0
votes
0
answers
334
views
Application can't connect to MongoDB server through IP address
I have a java application that connects to mongoDB 4.0.2 replicaSet with one node (Primary). I upgraded the database to mongoDB 4.2.20. Even though, after making tests I decided to downgrade to 4.0.2. ...
- 129