Questions tagged [linux]
A widely-used open-source operating system that is particularly popular on servers.
238
questions with no upvoted or accepted answers
5
votes
1
answer
1k
views
Full database backup using xtrabackup stream
I'm new to Percona XtraBackup. I've been trying to perform a full backup stream from my local ( test server around 600GB ) to remote server.
I just have some questions and I need guides, and I think ...
- 51
5
votes
1
answer
301
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 ...
- 315
4
votes
1
answer
806
views
MSSQL Ubuntu Unexpected call to legacy ABI
We recently had a Ubuntu 16.04 server loose power. After restarting the server I noticed that MSSQL Server was no longer running due to a an error Unexpected call to legacy ABI. After researching for ...
- 143
4
votes
1
answer
4k
views
InnoDB: Error: Table “mysql”.“mysql.transaction_registry” not found after upgrade to mariadb 10.3
I've upgraded the mariadb to 10.3 packages on my Debian 10, however something went wrong and I ended in the same issue which is mentioned several times
Cannot open table mysql/innodb_index_stats [...
- 153
4
votes
0
answers
136
views
How to analyze postgres client process/session memory
Is there a way to check how much of process memory is allocated for the specific buffer for a running postgres session (work memory, temp buffers, plan cache etc ... )?
I'm asking because i want to ...
- 41
4
votes
0
answers
4k
views
Getting: Possible index corruption detected. Run DBCC CHECKDB
When I connect to the database and run a command on some catalogs, I get Msg 9100, Level 23
1> SELECT * FROM sys.databases;
2> GO
Msg 9100, Level 23, State 2, Server x230, Line 1
Possible index ...
- 62.1k
4
votes
0
answers
2k
views
BCP neither gives results nor outputs anything when using valid statements but it does throw errors when passing invalid parameters
I have to use bcp command-line tool to export data from an SQL Server database to a file in a Red Hat server.
I am (apparently) using valid statements but bcp is not producing any kind of output/...
- 141
4
votes
0
answers
1k
views
postgresql + pgbouncer, idle server and high cl_waiting
I have such a setup:
OpenSUSE 13.1 64-bit
Linux kernel 3.11.10
PostgreSQL 9.0 + PgBouncer 1.5.4 (libevent-2.0)
16 core AMD, 128 GB RAM
PostgreSQL config:
max_connections = 1500
shared_buffers = 4GB
...
- 6,449
3
votes
1
answer
407
views
Solution for the deletion of old Database Backups for Linux SQL Server 2017 after Backups created with Ola Hallengren scripts?
I have a problem when I want to delete older backups, I've created with Ola Halengreen scripts.
USE Maintenance
EXECUTE dbo.DatabaseBackup
@Databases = 'USER_DATABASES',
@Directory ='/mssql/backup/'...
- 31
3
votes
1
answer
344
views
How to lock a MSSQL (2017 Linux) account after N unsuccessful login attempts
I have to configure account lock after N unsuccessful login attempts on MSSQL 2017 Linux. That is standalone server and is not in AD.
I couln'd find any valuable information so far unfortunately. ...
- 31
3
votes
0
answers
557
views
Replication doesn't resume once it fails to connect
We have MySQL replication running for our application. Right now the slave fails to resume if it fails to connect to the server for some time.
We get the error below:
[ERROR] Slave I/O: error ...
- 89
3
votes
0
answers
811
views
What happen when Postgresql tablespace is null?
I'm facing a DWH on postgresql with no DBA (I'm not one) so I turn to you with hope to figure this issue/s.
Long story short, when I check the disk usage per tablespace, I get different distribution ...
- 141
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
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
2
votes
1
answer
39
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 ...
- 21
2
votes
1
answer
6k
views
postgresql: Invalid data directory | Can't open PID file /var/run/postgresql/10-main.pid (yet?) after start: No such file or directory
This error is showing after running this command: sudo systemctl status [email protected]
[email protected] - PostgreSQL Cluster 10-main
Loaded: loaded (/lib/systemd/system/...
- 121
2
votes
1
answer
2k
views
I have 600% high CPU usage mysqld
I have an insane usage of cpu mysqld +600% here is the file my cnf
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an ...
Alfredo
2
votes
0
answers
12k
views
InnoDB Failing to start / MySQL not loading plugins
I installed MariaDB on my system (Debian 9), however, upon running sudo service mysql start, I get these errors:
Sep 22 12:32:37 bremea mariadbd[30151]: 2020-09-22 12:32:37 0 [Note] /usr/sbin/mariadbd ...
- 21
2
votes
1
answer
203
views
mssql suddenly cannot access physical file
SQL server 2019 on Centos 7 x86_64. It was running fine for quite long time, then got broken.
I was not doing anything special, neither update or restart or whatever. At some point the database went ...
- 21
2
votes
0
answers
2k
views
How to install PLV8 in PostgreSQL 11 in Ubuntu 16?
I am trying to install PLV8 extension (JavaScript Procedural Language for PostgreSQL) in my PostgreSQL 11 Ubuntu Server 16 and having a hard time. The PostgreSQL 11 was installed using PostgreSQL's ...
2
votes
0
answers
785
views
MongoDB Fails due to permission error even though its setup
Attempting to start my MongoDB server using service mongod start fails for the reason: exception in initAndListen: IllegalOperation: Attempted to create a lock file on a read-only directory: /var/lib/...
- 21
2
votes
0
answers
324
views
Asynchronous availability groups not synchronizing on SQL Server on Ubuntu
I installed SQL Server 2017 on Ubuntu and setup an availability group with cluster type = "None".
I set the "Availability" Mode to "Synchronous commit" and tested it. It works fine. All transactions ...
- 3,088
2
votes
0
answers
272
views
2 SQL 2019 Servers with High Availability Linux with a shared Linux SQL Express 2019 Witness
Is it possible to have two SQL Always on High Availability servers in datacentre A replicating to two servers in datacentre B with one Witness using Express with two availability groups (one for each ...
- 129
2
votes
0
answers
1k
views
SQL Server stored procedure not throwing certain kind of error
I noticed an issue in my app recently where an database insert that occurred in a stored procedure was failing, but no exception was getting thrown. The insert failed because a column that doesn't ...
- 151
2
votes
0
answers
610
views
How to enable remote debugging of Stored Procs with MSSQL Linux Docker container?
I'm running the latest SQL Server docker container from DockerHub in a Linux environment. Port 1433 is forwarded from my container, and everything is working fine.
However, when I have tried to ...
- 121
2
votes
0
answers
317
views
SQL Server 2017 Failover Cluster on RHEL Linux
I am trying to create Failover Cluster on SQL Server 2017 on RHEL 7.3 Linux, following this document from Microsoft:
https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-shared-disk-cluster-...
- 397
2
votes
0
answers
539
views
MySql Database stopped working LAMP
After making system update (my SO is Ubuntu 18.04) and reboot, the mysql doesn't start on Xampp.
Here is the sudo /opt/lampp/lampp start :
Starting XAMPP for Linux 7.2.7-0...
XAMPP: Starting Apache.....
- 121
2
votes
0
answers
759
views
Can't install SQL SERVER 2017 on Centos 7.4 - mssql-conf setup error
I'm trying to install the lastest SQL Server 2017 on a Centos 7.4 VM (Vmware). I get the following error when I try running:
sudo /opt/mssql/bin/mssql-conf setup
using Bash shell. The error:
...
2
votes
1
answer
721
views
Chunks not splitting on MongoDB sharded clusters
I have created 2 shard servers named rs1 and rs2.
Now in the database collection there are multiple records those should split on these 2 servers in chunks. The sharding key is TxnMonth. It is not ...
- 21
2
votes
1
answer
206
views
lat, long based search with $near shutdown my mongodb on Linux server
Hey guys i am stuck on critical problem & unable to resolve it. I have a project where there is a collection of UK postcodes having 18,00,000 sample postcode records. I have a search query where i ...
Maktwick
2
votes
1
answer
238
views
Search and Replace in multiple MySQL databases
I have multiple MySQL databases(50+) and I want to replace a string in all of them, is there anyway to search and replace in all the databases?
Server is CentOS and I have SSH root access.
2
votes
0
answers
46
views
Bandwidth-efficient, fail-safe database resync with long backlogs
I'm looking for a DB system that allows slaves to resync even if there exists a long backlog. In addition these resyncs must be as bandwidth-efficent as possible as the nodes are connected over GSM/...
- 21
2
votes
0
answers
433
views
mysql innodb - strange data loss
I am running a mysql database on linux with several InnoDB tables. At some point, the ibdata1 file got quite big and I wanted to delete it. So I made a dump, deleted the file and restarted the server.
...
- 121
2
votes
0
answers
2k
views
How to start MySQL after the year 2038?
I am using MySQL 5.5. For some reason, I need to change the date of my system to after 2038. Unfortunately, the MySQL service won't start after the year 2038:
root@sd-84962:~# date
Sat Sep 24 18:41:...
- 129
2
votes
1
answer
5k
views
How to restore database from /var/lib/mysql
I have a database folder from a crashed server called gain_wordpress. I'm trying to put that database on a new server but I'm not able to do it successfully. I don't have a .sql dump, all I have is ...
- 156
2
votes
0
answers
3k
views
upgrading posgresql 9.0 to 9.4 with pg_upgrade on CentOS 6.6
I'm trying to upgrade a postgres v9.0 database to v9.4 with pg_upgrade on CentOS 6.6, but I keep hitting a wall.
I am calling pg_upgrade thru a shell script as postgres, first exporting the needed ...
- 121
2
votes
0
answers
1k
views
Pass a URI as a pgAdmin parameter
I can connect to Heroku with psql passing a URI:
$ psql postgres://user:[email protected]:5432/d7xkxididkdi
I want to do the same with pgAdmin:
$ pgadmin3 -qc ...
- 1,135
2
votes
0
answers
2k
views
Incorrect information in .frm file after a power outage?
CentOS release 6.3 (Final)
x86_64
mysql Ver 14.14 Distrib 5.5.31, for Linux (x86_64) using readline 5.1
SHOW SLAVE STATUS\G:
Slave_IO_Running: Yes
Slave_SQL_Running: No
...
- 1,006
2
votes
0
answers
2k
views
Index usage for database server
How can i fix the Index usage on one of our database server?
It says from our Nagios control panel that:
Service: DB Index Usage
Host: MySQL Cluster
Address: ( our IP )
State: CRITICAL
Additional ...
- 21
2
votes
1
answer
2k
views
Environmental Variables for OracleDB 12 in Oracle Linux are Overriding Each Other with SQLPlus Variables
I want to set the environmental variables for OracleDB and SqlPlus properly. However, they are overriding each other. I'm doing something wrong, and I would like to get a hand finding where I went ...
- 19
2
votes
1
answer
3k
views
Restore a SQL Server bacpac file in Linux
I'm working to move an Azure database to an open source DB under Linux. I've received a .bacpac file and, to start with, I thought I'd try to install MS/SQL in Linux and restore the .bacpac file so I ...
- 121
1
vote
0
answers
23
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
1
vote
1
answer
78
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
1
answer
235
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
vote
1
answer
248
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
452
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
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
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
1
vote
1
answer
423
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
0
answers
205
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) ...
- 19