Questions tagged [linux]
A widely-used open-source operating system that is particularly popular on servers.
986
questions
0
votes
2
answers
2k
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 ...
- 1
0
votes
1
answer
179
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 ...
- 101
0
votes
1
answer
183
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&...
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
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
3
votes
1
answer
4k
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 (...
1
vote
1
answer
406
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 ...
chandan
0
votes
1
answer
553
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 ...
- 103
0
votes
1
answer
82
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 ...
J0hn311d
0
votes
1
answer
287
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....
- 19
0
votes
0
answers
101
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
...
- 121
1
vote
2
answers
357
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 ...
- 13
0
votes
1
answer
393
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 ...
- 9
1
vote
1
answer
528
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/...
- 19
0
votes
0
answers
455
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 ...
- 1
-1
votes
1
answer
1k
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
...
- 1,417
0
votes
1
answer
345
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 ...
0
votes
2
answers
2k
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 ...
- 51
2
votes
1
answer
2k
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 ...
0
votes
1
answer
2k
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 ...
Udishan
1
vote
0
answers
124
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....
- 772
0
votes
1
answer
183
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 ...
0
votes
1
answer
113
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/...
- 103
4
votes
1
answer
2k
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 ...
- 141
1
vote
1
answer
677
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 ...
Mahmoud Moussa
0
votes
1
answer
675
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 ...
0
votes
1
answer
33
views
MySql Important Linux System Configuration [closed]
Last month I'm trying to find a "formula" for optimal Linux system configuration for MySql installation. But I didn't find anything related in those fields:
Should I disable swapping ?
...
- 101
1
vote
1
answer
1k
views
SQL Server in a Linux Docker Container: Maximum size recommendation
Total docker noob here. Please forgive me for the lengthy post.
We are currently use SQL Server 2019 on Windows for our database. In an effort to "dockerize" the applications and database in ...
- 11
1
vote
1
answer
33
views
Mysql 8 which linux / Unix Distro would have better performance (2021 topic) [closed]
I want to setup a mysql 8 with MyRocks engine and BUILD from source with my custom parameters.
Is there any recommendation on which linux / unix distro would have better performances ?
CentOS stream
...
- 113
3
votes
2
answers
1k
views
Importing a 16 GB MySQL file silently fails
I've looked at a lot answers here MySQL any way to import a huge (32 GB) sql dump faster? and on Server Fault but haven't found a solution to not being able to import a 16 GB MySQL file completely; it ...
- 83
0
votes
2
answers
776
views
JDBC oracle listener random port
I have an issue with our listener trying to assign random ports to JDBC connections.
We have a 19c oracle db running on a RHEL server with two ports opened 1523 and 1524. When application tries to ...
dragont
0
votes
0
answers
231
views
Is it neccesary to shutdown the oracle database before uninstalling
I have a requirement of deleting/uninstalling a installed oracle 11g database on a Linux machine and I follow the below steps to uninstall the database.
Kill all processes runs with user oracle.
...
- 101
0
votes
1
answer
6k
views
How to configure Oracle19c to use case-insensitive passwords?
How can I make Oracle19c accept case-insensitive passwords? That is, I want "mypAsswOrd" password to serve as "MyPaSsWoRd" or "MyPassword".
Pepo
1
vote
2
answers
411
views
DB2 Linux authentication fails
I have DB2 Express-C v10.5 instance configured to authenticate against LDAP. The LDAP sever is going to be shutdown and I should configure the same DB2 instance to use Linux authentication.
I copied ...
- 111
2
votes
2
answers
5k
views
GRANT command not working on MySQL 8.0.25
I'm attempting to grant a user privileges within a database, and I'm receiving the error
#1410 - You are not allowed to create a user with GRANT
I'm executing the following:
GRANT ALL PRIVILEGES ON `...
- 41
0
votes
1
answer
958
views
PostgreSQL + how to clean pg_xlog log without damage the PostgreSQL service
we are using postgresql for ambari DB , in our linux server - rhel 7.2
postgres -V postgres (PostgreSQL) 9.2.13
we noticed that pg_xlog folder consuming 198g , and its gives /var to get 100% size
so ...
- 113
0
votes
2
answers
562
views
How to set user-based .psql_history in linux?
If use postgres in linux, it has a postgres user. So when use psql from this user, it will generate a .psql_history file under this user - /home/postgres/.psql_history.
When set many users on the ...
- 167
0
votes
0
answers
276
views
Cannot change MySQL tmpdir, error on MySQL Restart
This morning I attempted to Optimize a large database (3gb+, 10m rows+). My /tmp folder filled as it was only 600mb. Now my table is corrupt and inaccessible until I repair the table.
I've read that I ...
- 141
1
vote
1
answer
164
views
Oracle Linux 6.10 - Changing the Oracle user's ID & GID
OS: Oracle Linux 6.10
DB vers: 12cR1
I will backup and restore from NFS shared disk for a preprod server. However, the ID and GID of the oracle user on the production server (shared disk on ...
- 29
0
votes
1
answer
4k
views
psql: warning: extra command-line argument "postgres.dolphin.com" ignored
when I using this command to copy table video from database dolphin to database acientbay in Fedora 32, shows error like this:
/usr/share/postgresql-13/bin/pg_dump -v -t video -h postgres.dolphin.com -...
- 755
0
votes
1
answer
692
views
Oracle 11g TDE wallet autologin
I have setup Oracle TDE for my 11.2.0.4 database. I created the wallet. I created the autologin wallet and everything looked good.
{ORACLE_HOME}/bin/orapki wallet create -wallet cwallet.sso -...
- 51
0
votes
1
answer
162
views
Oracle 11g Encryption
Can somebody please tell me how to encrypt an existing tablespace in 11g? The wallet has been setup and the sqlnet.ora points to it.
SQL> select STATUS FROM V$ENCRYPTION_WALLET;
STATUS
-----------...
- 51
1
vote
2
answers
411
views
How to create SQL Server backup from Windows Server to Linux Client with SQLCMD?
I've got sqlcmd installed on an Ubuntu LTS instance and I'm able to connect successfully to Windows SQL Server and do queries and such.
sqlcmd -S 192.168.0.100 -U SA -P secret
I need to be able to ...
- 111
1
vote
1
answer
3k
views
Column count of mysql.proc is wrong
Im attempting to deal with a corrupted database with little success, when I try to alter this table I am giving the error
Column count of mysql.proc is wrong
Looking up this error online gives me ...
- 23
0
votes
1
answer
53
views
Mysql 8 tables size
We have a problem with an unreasonably large table size on the server, for example:
Yesterday, a table with partitions was created, data began to be written to a specific partition.
mysql> show ...
- 1
1
vote
0
answers
77
views
TDE error when attempting to encrypt a datafile
I'm encountering error
ORA-28374: typed master key not found in wallet
when attempting to run
alter database datafile '+DATA/testdb/datafile/users.2514.1233355332' encrypt;
against an 11g database ...
- 51
0
votes
1
answer
230
views
How do I know my Oracle database is correctly configured and running?
I've installed a fresh Oracle 19.3 on Linux CentOS 8.3. I used the install steps (manual install) from this official Oracle guide.
I tried to start the DB using the standard script:
[oracle@localhost ...
- 11
0
votes
1
answer
530
views
Reset Root Password MySQL on Ubuntu
I know there are tons of posts about this on here but nothing seems to work. I have tried every command I could find it will not work.
I just recently setup mysql on Ubuntu (SQL version is 8.0.23-...
- 1
0
votes
1
answer
713
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:...
-1
votes
1
answer
406
views
Database not showing
I create a database in the terminal linux ubuntu,gave it all privileges,created the table,inserted the rows.When I open phpmyadmin the database isn't showing how do I connect them?
I did use mysql -u ...
- 1