Questions tagged [linux]

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

Filter by
Sorted by
Tagged with
-1 votes
0 answers
21 views

Postgresql 14: Optimizing Database

My machine have following specs. 24 CORE 100GB RAM Flow Users 3k Database Postgresql 14 how i can optimized my buffer/cache auto full. i do not fixed any manual setting. please help me i am unable to ...
user avatar
0 votes
0 answers
19 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:...
user avatar
-3 votes
0 answers
14 views

BASH shell is not working properly after editing PS1

I recently added some color to my bash prompt, and now when I type a command the text doesn't wrap properly. Here is an example: MacBook-Pro:~ williamgiles$ long commandwilliamgiles$ this is a really ...
user avatar
0 votes
0 answers
40 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 ...
user avatar
0 votes
0 answers
22 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-...
user avatar
0 votes
0 answers
115 views

postgres fatal external connect error no encryption

I want to external connect to my postgresql database. so I use psql -h IP -p Port -U username -d databasename but it shows me error psql error : connection to server at "IP", port 5432 ...
user avatar
0 votes
0 answers
9 views

How do I write MariaDB query results to several different outfiles on client side?

I have MariaDB server and client 10.5.12 both running on the same Debian 11 PC. I am running several SQL queries from a file that I pass to the MariaDB shell client: mysql < autoreport.sql I would ...
user avatar
  • 1
0 votes
1 answer
51 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 ...
user avatar
  • 1
-1 votes
1 answer
196 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: ...
user avatar
0 votes
1 answer
37 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 ...
user avatar
0 votes
1 answer
63 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 &...
user avatar
0 votes
0 answers
21 views

replicate_rewrite_db not working on create table

I'm trying to set up replication on Mariadb 10.6 on Debian 9. I'd like to replicate database "DB" on master to database "DB1" on slave. I've configured the following on the slave : ...
user avatar
  • 1
2 votes
1 answer
94 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 ...
user avatar
  • 21
0 votes
2 answers
40 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 ...
user avatar
0 votes
0 answers
54 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 `...
user avatar
1 vote
1 answer
35 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 ...
user avatar
  • 133
0 votes
1 answer
47 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 ...
user avatar
  • 1
1 vote
1 answer
65 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 ...
user avatar
1 vote
3 answers
99 views

Permission Denied when trying to import an sql file on my linux system

I'm trying to import a table to a database called 'test' that I've already created as the postgres superuser. The file i.e. the table is in a drive/filesystem that's already mounted. *I'm logged into ...
user avatar
0 votes
1 answer
68 views

SQL Server on Linux caps the memorylimitmb setting

I have a 64GiB Ubuntu machine with SQL Server 2017 installed. Setting memory.memorylimitmb to anything higher than 63695 megabytes is ignored. Setting it to 67000 megabytes (which is 62.3 GiB roughly) ...
user avatar
  • 635
0 votes
2 answers
187 views

Is it safe to use the address 0.0.0.0 on a Postgres database?

I'm following a guide on how to setup a Postgres database with remote access (using pgAdmin 4). If I want to use the remote access with success then I have to change the configs and one of them is to ...
user avatar
0 votes
1 answer
45 views

Remote connecting to Asterisk mysql database from internet issue

I can connect to Asterisk MySQL database (asteriskcdrdb) and everything is okay. Asterisk server located in my LAN network. I can to connect to this database from my computer with Mysql client ...
user avatar
  • 101
0 votes
0 answers
58 views

MySQL server control database corrupted after MariaDB migration

I migrated the MySQL in my server from MySQL 5.7 to MariaDB 10.3 and the MySQL database, the one that controls users and passwords corrupted. It has several tables that in the column "collation&...
user avatar
2 votes
1 answer
24 views

MariaDB index chosen differs on ARM and x64 based procesors

When I have been using mariaDB on apple M1 chip, I discovered some diference between index chosen in select statement versus x64 server linux system with this query: explain SELECT z.id_hlavni AS ...
user avatar
1 vote
0 answers
62 views

Why do some SQL Server databases go into a "Recovery Pending" state after shutting down / restarting on Linux?

I built a secondary PC from old parts as a server for SQL Server databases and I went with Linux/Ubuntu 20.04 because it's free. I knew it would not be easy to set this up (I'm rather a Windows user) ...
user avatar
  • 19
2 votes
1 answer
390 views

pg_dump is not the same version as psql

I updated postgres to version 14 with sudo apt upgrade. psql --version psql (PostgreSQL) 14.1 (Ubuntu 14.1-2.pgdg20.04+1) But pg_dump did not upgrade with everything else: pg_dump --version pg_dump (...
user avatar
0 votes
1 answer
50 views

Removing router from MySQL InnoDB cluster

Currently I have configured 3 node MYSQL InnoDB Cluster with two routers. Is it possible to remove one of the router from cluster? what are the implications ? using cluster.listRouters() I could see ...
user avatar
0 votes
1 answer
35 views

Adding disk space to a running MySQL Server

I'm running a MySQL (5.7) on a Centos7 server which also has a replica (slave) on another machine. The problem is that the master instance is running out of space and I need to extend its disk space ...
user avatar
  • 103
0 votes
0 answers
53 views

Failed global initialization: FileRenameFailed: Could not rename preexisting log file

I get this error while trying to launch mongo deamon. CONTROL [main] Failed global initialization: FileRenameFailed: Could not rename preexisting log file "/var/lib/mongodb/log/mongod.log" ...
user avatar
0 votes
1 answer
29 views

Linux MySQL Optimization

Hey we moved to a much bigger Server and we want to optimize our performance from MySQL. Does anyone know how to increase the performance? Or like a config generator or something like that. I don't ...
user avatar
0 votes
1 answer
64 views

Will purging listener_scan1.log, listener_scan2.log, listener_scan3.log in Oracle 12C RAC Configuration not affect database services negatively

I have a got a oracle 12c database configuration where there is RAC configuration for DB01 on one server and DB02 on another server. The issue i have is that the listener_scan1.log, listener_scan2....
user avatar
  • 19
0 votes
0 answers
49 views

SQL Server 2019 Express for Linux on Ubuntu 20.04 - Bug - CU 13 - c0000005 EXCEPTION_ACCESS_VIOLATION when specifying @wkt in Table-valued function

Pretty sure I've found a bug in SQL Server 2019 (Express) for Linux (CU 13, version 15.0.4178.1 running on Ubuntu 20.04 LTS). After the following table-valued function dbo.bTest is created: use devdb ...
user avatar
  • 121
1 vote
2 answers
69 views

Make running MySQL with InnoDB flush everything to file to allow file-level live backup

A client has a file-level backup, where every relevant file of a critical webserver is synced to another webserver around 1am. This includes the /var/lib/mysql directory where the databases of that ...
user avatar
  • 13
0 votes
0 answers
261 views

MySQL Error: Multiple files found for the same tablespace ID

Today my MySQL started giving me this error when I try to start the MySQL Service: [ERROR] [MY-012209] [InnoDB] Multiple files found for the same tablespace ID [ERROR] [MY-012202] [InnoDB] Tablespace ...
user avatar
0 votes
1 answer
75 views

Listener oracle in pacemaker cluster

I need some help. I have created a cluster with 2 nodes. I created all resources, but listener has errors and the pacemaker cluster status shows Oracle Listener has stopped. In the web interface I ...
user avatar
1 vote
1 answer
24 views

How can i see the location of Oracle Datafiles, query result set is returning a direct that starts with (+) e.g +DG_DATA/lv_vcpdata4

I am trying to find the location of oracle data files in Linux and after querying the database, i find results where the data file path starts with a (+) as below: +DG_DATA/lv_vcpdata4 +DG_DATA/...
user avatar
  • 19
0 votes
0 answers
98 views

Error uninstalling, updating and re-installing MySQL on Ubuntu 20.04

I'm trying to uninstall and remove MySQL on Ubuntu 20.04. If I try to install a new package, in my case sudo apt-get install putty, remove or update a package, the terminal complains with You might ...
user avatar
  • 1
0 votes
0 answers
63 views

MS SQL 2019 operator in k8s is ready for production?

ITNOA I am searching about MS SQL Server 2019 K8s operator very much, but I don't find any comprehensive documentations or help pages I just found Availability Groups on Kubernetes in SQL Server 2019 ...
user avatar
0 votes
0 answers
9 views

How to check if a new Oracle PDB has been replicated successfully to the standby side?

How can I check if a newly plugged in 19c PDB on the primary has been replicated successfully (automatically) to the DataGuarded standby side?
user avatar
  • 29
-2 votes
1 answer
312 views

Why SQL Server docker image uses high CPU all the time, and how to fix it?

Using this docker-compose.yml I have created a container: version: "3.9" services: database: image: mcr.microsoft.com/mssql/server user: root restart: always ...
user avatar
0 votes
1 answer
41 views

logical replication. How do I change the subscriber to new master?

I'm migrating Linux distros and need to migrate the Postgres 11 to new master. I can do a streaming replication and have little to no downtime or do a dump. That I got down. My problem is how do I ...
user avatar
0 votes
2 answers
420 views

Rebuilding an Oracle 19c Standby Database after plugging in a new PDB

I have an Oracle 19c Dataguarded physical standby DB setup running on Linux 7. The container DB had one PDB but I've now just plugged a new PDB into the primary. What do I need to do to get this new ...
user avatar
  • 29
2 votes
1 answer
204 views

How do I identify the users on Oracle database who uses OS authentication?

I'm trying to audit the privileged users on Oracle Db and see there are users for whom the last login column appears to be blank, however, I'm aware that those user accounts are used for certain ...
user avatar
0 votes
1 answer
164 views

Oracle database startup leads to errors

Used the Oracle Linux Server 8.2 and its terminal shows below errors. ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination ...
user avatar
1 vote
0 answers
49 views

Tracking Read/Write latency for SQL server on linux

Hello i want to track SQL server read/write latency for the SQL servers i monitor running on linux host. I checked and found disk related metrics would not work here for linux if fetched from sys....
user avatar
0 votes
1 answer
87 views

RAM overflow in MYSQL

I have a server with a database in MYSQL 5.7.34 MySQL Community Server (GPL) on weekends has a very high tractability so it has been responding very slowly, I saw the logs and it gave me the following ...
user avatar
0 votes
1 answer
25 views

Postgresql log uploading service on Ubuntu Linux

I am trying to create a systemctl service to collect + upload logs for Postgresql 12 on Ubuntu Linux. However, I am expert at none of the two. While I have set up the server modifying /etc/postgresql/...
user avatar
3 votes
1 answer
209 views

Backup MSSQL database to local machine on Linux command line

What is the mssql-cli (or other tool options?) equivalent of this? mysqldump --host servername dbname > dbname.sql As far as I can tell, logging-in to the SQL Server with mssql-cli and running ...
user avatar
  • 131
0 votes
1 answer
196 views

Wordpress crash on slow queries related to wp_term and wp_term_taxonomy

I have a WordPress blog with around 90K articles. The problem is I get frequent crashes on the server and browsing is slow due to some slow queries on the website. I am suspecting the problem is with ...
user avatar
0 votes
1 answer
87 views

Deleting hundreds milion of rows in single MySQL query

we have a project with a huge MySQL table (MySQL version 5.7.35-0 on Ubuntu 18.04.1 using InnoDB) table. By Huge I mean approximately 100M of rows 300GB. I want to do some pruning there. This can be ...
user avatar

1
2 3 4 5
19