Questions tagged [linux]
A widely-used open-source operating system that is particularly popular on servers.
993
questions
1
vote
1
answer
434
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 ...
CommunityBot
- 1
0
votes
0
answers
14
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 ...
- 1
0
votes
1
answer
16
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 ...
- 48k
0
votes
1
answer
627
views
How to install HANA DB on Oracle Linux 7?
I want to know how to install SAP HANA DB 2.0 on Oracle Linux 7 including downloading, installing and the first connection establishing to the system from network. I've spent a few hours to find out ...
CommunityBot
- 1
0
votes
0
answers
8
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 ...
- 13
-1
votes
0
answers
15
views
File path. File not found [closed]
Hi anyone can help me here.
so the problem is that the webapp can't find the file
for example.
if HelloWorld.txt is inside First_Folder, the file can be viewed.
if HelloWorld.txt is inside ...
- 1
5
votes
2
answers
353
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 ...
- 83k
1
vote
1
answer
2k
views
Oracle - Delete dmp files from ASM diskgroup
I want to delete my export files daily from ASM diskgroup with a crontab job. I want to prepare a script for it.
ASMCMD> ls
exp1.dmp
exp2.dmp
exp3.dmp
exp4.dmp
ASMCMD> pwd
+DATA/EXP
How can I ...
CommunityBot
- 1
0
votes
1
answer
617
views
After RAM upgrade on 32-bit Oracle server, ORA-04031: unable to allocate x bytes of shared memory
We are in the process of upgrading our Oracle database server at work, from SUSE Linux Enterprise Server 10.4 / Oracle 10g / 4GB RAM (Intel 32-bit) to Scientific Linux 6.4 / Oracle 12c / 8GB RAM (...
CommunityBot
- 1
33
votes
7
answers
47k
views
Does innodb_file_per_table affect mysql performance?
There are many articles exaggerating (IMHO) the need for innodb_file_per_table. I understand that with innodb_file_per_table there should be better control over individual tables, like being able to ...
- 103
2
votes
1
answer
610
views
SQL Server for Linux 2019 - Windows Authentication not working
Hoping to pick the brains of those more knowledgeable than me. I've been trying to set up a SQL Server 2019 instance on Linux; specifically on AWS using AMI amzn2-x86_64-SQL_2019_Standard-2019.11.12
...
- 5,472
0
votes
2
answers
578
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/...
CommunityBot
- 1
1
vote
2
answers
58
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 ...
- 40.4k
0
votes
0
answers
10
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 "...
- 11
0
votes
1
answer
31
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.
...
- 3,780
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 ...
CommunityBot
- 1
0
votes
0
answers
11
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
14
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.
...
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/...
CommunityBot
- 1
0
votes
1
answer
377
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 ...
CommunityBot
- 1
0
votes
0
answers
28
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 ...
- 119
2
votes
3
answers
436
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 ...
- 1,024
1
vote
4
answers
5k
views
can't execute opatch even I'm in the oinstall group with -rwx--x---
I'm in $ORACLE_HOME/OPatch directory and
I type opatch. It responds:
bash: opatch: command not found
if I do ./opatch:
/bin/sh: ./opatch: Permission denied
ls -l opatch shows -rwx--x--- so for ...
- 3,425
1
vote
2
answers
582
views
RHEL 7.4, heavy workload(s) and SWAP usage
This might not be the correct board for this, but since I'm a DBA and I'll ask here.
I have several RHEL 7.4 servers, running a mix of MariaDB (10.1, 10.2) and MongoDB (3.4). The problem was ...
CommunityBot
- 1
0
votes
1
answer
1k
views
MySQL replication stops everyday for no (obvious) reasons
i've got a problem with my MySQL master-slave replication.
It works just fine after i start it up but around 2:30am the next day it stops. Monitoring shows that the slave starts continously reading ...
CommunityBot
- 1
-1
votes
0
answers
67
views
ORA-27369: job of type EXECUTABLE failed with exit code: 5 Login executable not setuid-root
I try to run executable job in Oracle 19c and the error occurs:
ORA-27369: job of type EXECUTABLE failed with exit code: 5 Login executable not setuid-root
ORA-06512: at "SYS.DBMS_ISCHED", ...
1
vote
1
answer
471
views
SQLServer Linux: Error restoring backup of DB from Windows w/ full-text data file
I'm trying to move a Windows SQL Server database from Windows 10 to Linux.
For this, I'm following the instructions in
https://learn.microsoft.com/es-es/sql/linux/sql-server-linux-migrate-restore-...
CommunityBot
- 1
0
votes
1
answer
72
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/...
Ruben247
0
votes
1
answer
642
views
Moving mysql database to new partition with different partition "type"
Sorry, Possibly a dumb question, but something which needs clarification.
Currently mysql is stored on sda which is around 1TB. Now our DB has outgrown that, almost !!. So trying to create new ...
CommunityBot
- 1
0
votes
1
answer
740
views
barman + postgresql not start after barman retore
I use the barman for backup and restore
after some restore , we start the postgresql as the following
systemctl start postgresql.service
but postgresql not startup
from the log:
/var/lib/pgsql/...
CommunityBot
- 1
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 ...
CommunityBot
- 1
2
votes
1
answer
3k
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 ...
CommunityBot
- 1
2
votes
1
answer
724
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 ...
CommunityBot
- 1
1
vote
1
answer
1k
views
PostgreSQL WAL file database system identifier wrong
I'm having a problem restoring a copy of a PostgreSQL database to another server.
I have taken a backup using the pg_basebackup tool and can restore that but when I restore WAL logs from the archive ...
CommunityBot
- 1
0
votes
1
answer
298
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....
CommunityBot
- 1
2
votes
1
answer
611
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
...
CommunityBot
- 1
0
votes
1
answer
523
views
Why could pgloader fail with 'undocumented reason' while migrating large MySQL database to PostgreSQL?
The database I would like to import is approximately 55GB in binary format, about 36 GB exported by mysqldump. But as we know even the postgres compatible mysqldump is not 100% compatible, so I'm ...
CommunityBot
- 1
1
vote
2
answers
753
views
Struggling with MySQL character set, collation
I am facing problems with inserting Spanish characters from my application.
When I am inserting on the DB the characters are inserting properly, but when I am trying passing the same data in from the ...
CommunityBot
- 1
1
vote
1
answer
3k
views
Slave stoping with Last_SQL_Errno: 1032
I have added an extra Slave server to an existing MySQL Replication. The Master server and the old Slave server are working fine without any issue, but the newly added server is stoping with the ...
CommunityBot
- 1
0
votes
1
answer
491
views
For SSL renewal procedure in Db2 LUW , DO i need to create CSR request for each instance residing in same server?
I am trying to renew my SSL certs . Stuck here if we need to have create a Certificate Signing Request for each instance residing on the same server and send it to CA who will provide us the ...
CommunityBot
- 1
4
votes
1
answer
5k
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 [...
CommunityBot
- 1
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. ...
CommunityBot
- 1
0
votes
1
answer
538
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: ...
CommunityBot
- 1
0
votes
0
answers
75
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 ...
D Lepp
0
votes
1
answer
300
views
Connecting to MariaDB server: ERROR 2013 (HY000): Lost connection to server at 'handshake: reading initial communication packet', system error: 11 [closed]
I am trying to connect to an AWS hosted (RDS) MariaDB database (engine version 10.6.14). The database is hosted on a private subnet but it's accessible through a bastion host. I use an SSH tunnel to ...
- 77.1k
0
votes
1
answer
720
views
'Could not fsync file' while running VACUUM FULL on a table
I'm getting an error for around half of my tables in Postgres while trying to run VACUUM FULL.
For example, I have a table named 'qwerty', and when i try to vacuum it i get the following error:
ERROR:...
CommunityBot
- 1
0
votes
0
answers
36
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 ...
- 1,488
1
vote
1
answer
4k
views
How to repair mongodb collection when index is corrupt?
Mongo version: 2.6 I think one or more of my MongoDB index is corrupt which is not letting me delete the corrupt collection or make a backup with mongodump
Below is the error i get when i try to ...
CommunityBot
- 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 ...
CommunityBot
- 1
0
votes
1
answer
23
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 ...
- 77.1k