Questions tagged [linux]
A widely-used open-source operating system that is particularly popular on servers.
989
questions
0
votes
0
answers
112
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
249
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
453
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
370
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
164
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
80
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
745
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
49
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
213
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
299
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
357
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
-1
votes
1
answer
463
views
database eror localhost
ask for a solution xampp linux error like this?
Error : The user specified as a definer ('mariadb.sys'@'localhost') does not exist
error : Corrupt
Phase 4/7: Running 'mysql_fix_privilege_tables'
...
0
votes
0
answers
84
views
My postgres has a strange userDB as superuser. I can't remove this user
Yesterday, my postgres had 4 superuser like shown in the first image, but today it has a strange user (cloudsqladmin_user) as superuser and the other users have lost the attributes. I don't know what ...
- 1
0
votes
1
answer
9k
views
Mysql replication fails when the master's binary log increments
I am currently running 2 instances of 8.0.31 MySQL Community Server on two virtual machines. These are set up with one way replication. The replication runs fine once set up, but at some point it ...
0
votes
1
answer
48
views
Is it recommended changing the file /sys/kernel/mm/transparent_hugepage/enabled for MariaDB node?
Is it recommended changing the file /sys/kernel/mm/transparent_hugepage/enabled from 'always' to 'never' for a MariaDB Galera node?
- 129
0
votes
1
answer
360
views
Recover deleted redo log files
I have the following problem: all redo log files from an Oracle 19C database have been deleted while the database was running. The database is running on a Linux server. When I try to connecting to ...
- 228
1
vote
0
answers
453
views
Why when a Mongodb second secondary node is unreacheable, the cluster is affected?
I have the following MongoDB 4.0.2 cluster with the following information:
rs.conf()
{
IP:192.168.1.26, // Primary, in New York branch
priority:10
},
{
IP:192.168.1.24, // Second Secondary, in ...
- 129
0
votes
0
answers
706
views
psql: FATAL: no pg_hba.conf entry for host "x.x.x.x", user "postgres", database "cis", SSL off
Please help to resolve below error.
psql: FATAL: no pg_hba.conf entry for host "x.x.x.x", user "postgres", database "abc", SSL off
pg_hba.conf:
host all ...
- 31
2
votes
1
answer
3k
views
Postgresql memory use invokes OOM killer
I am using Debian 9 on a device with 512 MB of RAM and an 8 GB disk.
I have installed PostgreSQL 9.6.22 with the extension TimescaleDB 1.7.1.
PostgreSQL memory-related parameters are the following:
...
- 123
0
votes
0
answers
170
views
mysqldump extreme export slowness
I'm using MySql 5.7.33 on VmWare Vsphere Vm with 20GB RAM and 8 cores.
These are my MySql settins
slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 1
...
-1
votes
1
answer
141
views
How to upgrade from psql 9.5 to 12 with short downtime and no corruption
We have two databases in two different servers with PostgreSQL 9.5
One database size is 800GB and the other is 1.8 TB.
What would be the most efficient and safe way of upgrading both clusters from ...
- 1
0
votes
1
answer
285
views
Reliable way(s) of finding home directory of Sybase DB (ASE) on Linux and Windows
I need to write a script that finds Sybase installation on a system if there's any.
For testing I've installed ASE 16 on CentOS system, but the installer is apparently based on InstallAnywhere (Java).
...
- 503
0
votes
1
answer
1k
views
Offline install of Oracle 12c on Oracle Linux 8 without yum or GUI access
I am trying to install Oracle 12c on Oracle Linux 8. I have the relevant files (linuxamd64_12102_database_1of2 and linuxamd64_12102_database_2of2), but the installer uses a GUI, which I can't do (I ...
2
votes
1
answer
8k
views
PostgreSQL 14 server not running locally on Ubuntu 22.04
So yesterday I updated my Ubuntu OS from 20 LTS to 22.04 LTS and installed PostgreSQL from this source. Running, psql -V, I get this:
(PostgreSQL) 14.5 (Ubuntu 14.5-1.pgdg22.04+1)
Initialized the ...
- 31
0
votes
1
answer
371
views
High memory usage on SQL Server running on Linux
I've had SQL Server running on a VM Linux box running lubuntu (20.04) without problems for over 2 years. For some reason my VM reset to only run on 1 Core. I fixed it (run 4 cores), my memory usage ...
0
votes
1
answer
205
views
I can not install mariadb through dnf
I use "sudo dnf install mariadb" to install mariadb on fedora36 but it showed me this error:
" file /etc/my.cnf from install of MariaDB-common-10.9.2-1.fc36.x86_64 conflicts with file ...
Amirhossein
1
vote
0
answers
79
views
How To Transfer Postgres Data That Doesn't Have a .s.PGSQL.5432 Socket or /var/lib/pg_data Mount?
The End Goal
To somehow combat the issues listed so I can transfer stored data from the old database node (that has an improper postgres mount) to the new one that is currently bringing in new data (...
- 11
0
votes
0
answers
141
views
"Too many" requests seem to break Oracle server
We're using a vendor-provided (closed-source) software, which consists of multiple processes (not threads) on multiple computers performing the calculations.
The application is written to ask each &...
- 136
2
votes
1
answer
897
views
Too many errors with Mysql to proceed
I've got an issue I've never run across nor seen before, And to be honest, I'm not confident enough to proceed without some input from someone who may have experience with it.
I was trying to ...
- 21
1
vote
1
answer
2k
views
Can't Use Newly Created User to Run Postgres createdb Command
Short Version:
I get:
error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: Peer authentication failed for user "admin"
when I try to createdb ...
- 143
3
votes
2
answers
1k
views
1st process writes, 2nd one reads -- " SQLITE_BUSY: database is locked "
I have 2 processes that use the same Sqlite3 database.
1st one -- in NodeJs, is a program which constractly writes data into a database, with the frequency of around 1 write / 1 second. It only ...
- 47
0
votes
2
answers
195
views
How to recover MongoDB prompt from '>' to secondary node prompt?
I got three test servers using MongoDB 4 with cluster resultset. I stopped the primary node and MongoDB prompt on secondary node changed from 'rsExample:SECONDARY>' to '>'. Then, I started the ...
- 129
-3
votes
1
answer
501
views
Is it possible to access a Windows MSSQL server from an instance of Linux?
I'm trying to assess the viability of using Linux within a very-much Windows environment for bash/scripting utilities to be performed. From the documentation I could find, ubuntu access is possible ...
0
votes
0
answers
351
views
MySQL reading speed is much slower on a more powerful server
I have recently provisioned two new servers:
Server 1: AMD EPYC 7320P, 128GB DDR4, 7.68TB Micron 5300 SSD
Server 2: Intel E2388G, 128GB DDR4, 2x 6TB SATA HDD in software RAID1
Both are running ...
- 101
2
votes
3
answers
431
views
How to monitor slow queries time on Mariadb
I have multiple MariaDB instances that I monitor with mysql exporter on grafana. I have spotted some slow queries recently which took more than 300 seconds by looking at the process list of the ...
- 131
0
votes
0
answers
74
views
Is there a max limit of ibdata files I can add to innodb?
As the title suggests I was supposed to add an additional ibdata file for our mysql archive server since it was near full. Its an old server and I just stumbled on it today. As I checked it, the my....
0
votes
0
answers
119
views
Why won't this config use DECLARE / FETCH on Amazon Redshift?
In my home directory I have created:
.odbcinst.ini
[ODBC Drivers]
Amazon Redshift (x64)=Installed
[Amazon Redshift (x64)]
Description=Amazon Redshift ODBC Driver(64-bit)
Driver=/opt/amazon/...
- 304
0
votes
0
answers
161
views
Сan't automatically connect to RDS via the script?
I'm using script on ec2 user data, that connects to rds. But the script doesn`t work.
#! /bin/bash
yum update -y
yum install -y httpd
service httpd start
usermod -a -G apache centos
chown -R centos:...
0
votes
0
answers
616
views
Can't use ODBC to connect to MariaDB
Linux Mint 20 (Ubuntu 20).
MariaDB version:
"mariadb Ver 15.1 Distrib 10.7.3-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2"
LibreOffice 6.4.7.2.
I want to run LibreOffice Base ...
- 111
0
votes
0
answers
168
views
How to access a VPN client directly from VPN server via IP address
I am running a MariaDB server and an OpenVPN server (SoftEther in this case) on an Ubuntu 20.04 LTS machine.
On my Raspberry Pi, I am running a MariaDB server aswell.
My goal is to enable a Master-...
cmoe
0
votes
1
answer
258
views
understanding parallel replication in MySQL 5.7
I am currently experimenting with parallel replication in MySQL (5.7).
I have set up a replication between master and slave (MyISAM, statement based) and did also set the following settings for ...
- 1
-2
votes
1
answer
3k
views
pg_dump - aborting because of server version mismatch
El error se genero tratando de generar el DUMP:
pg_dump -h 192.168.0.56 --no-owner -U user name_db > /var/tmp/dump.sql
Output:
pg_dump: server version: 12.3; pg_dump version: 9.2.24
pg_dump: ...
0
votes
1
answer
120
views
Restoring SQL Server database on Windows instance from Linux SQLCMD
I have a SQL Server that is running under Windows. And I have a Linux client. AFAIK SQLCMD requires "local" (server-related) path to backup files. So the question is - how to specify windows ...
- 1
0
votes
1
answer
2k
views
SQL Server on Linux, an issue with filesystem privileges for a backup creation
I'm trying to backup SQL Server to a directory that different users should have access to. To do this, I create a user group, and include the mssql user there - but when I try to create a backup, an &...
- 495
2
votes
1
answer
608
views
MySQL 5.7.37 is consuming CPU and High memory ( 90-95% )
I have a problem with my MySQL database.
RAM usage is too high, CPU too.
Does it come from my configuration ?
Here's my configuration :
auto_generate_certs ON
auto_increment_increment 1
...
- 21
0
votes
2
answers
360
views
Silent Installation of Oracle 11gR2 Fails During NETCA setup in Redhat Linux 8
I am trying to install Oracle 11gR2 in Rhel 8. There was a few incidents of missing packages here and there which I managed to fix during the SOFTWARE ONLY installation. But now I am completely stuck ...
- 13
0
votes
0
answers
206
views
MySQL Insert query takes around 100-300ms
I have installed MySQL version 8.0.27-0ubuntu0.20.04.1 on Ubuntu LTS.
The exact same setup is installed on a cheap VPS for 5$/year.
If I execute the following query on Server A.
INSERT INTO `...
- 101
1
vote
1
answer
153
views
mariadb lock tables from linux bash
I have all codes that I need to do a backup (lvm snapshot) for our MariaDB Database on Linux. These are my commands in terminal:
mysql
flush tables read lock; (in database)
exit
...
- 159
1
vote
1
answer
424
views
Mariadb replication - Ignore users changes
I posted this question on ServerFault but was told to ask it here.
I need to set up multi-source replication (3 masters and 1 slave). I'd like to avoid replicating users' changes on the slave because ...
- 131
1
vote
1
answer
229
views
Mysql optimization advice
I don't understand very well about servers and mysql, I just have an android application running, and when it reaches 1800 simultaneous users the server slows down. I don't know if it's normal or if I ...
Guilherme Ribeiro