Questions tagged [centos-7]
The centos-7 tag has no usage guidance.
56 questions
0
votes
0
answers
26
views
Unable to execute psql with postgres user
After a server failure I'm not able to execute psql like psql -U postgres nor like sudo -u postgres psql. In both cases I'm asked for the user password despite I've modified the pg_hba.conf files to ...
0
votes
1
answer
3k
views
Can not set ORACLE_BASE with oraenv command after install in CENTOS 7 server
Im trying to install Oracle DB version 12.1.0.2.0-1 in my customer server, my installer file name is oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm. After run this file with sudo rpm -i oracle-...
- 101
0
votes
1
answer
321
views
Mariadb upgrade problem
I upgraded mariadb on a Centos 7 box from 5.5 to 10.5 and after updating the tables, mariadb will no longer start. In /var/log/messages, I'm getting the following errors. Any help would be much ...
- 3
1
vote
0
answers
45
views
Mysterious Increase in Server Load Every Hour with MySQL 5.7.4
I have a CentOS 7 server with MySQL 5.7.4 installed. The machine has 8 cores and 16 GB of RAM, and only the MySQL service is running. The database is not very large, and there are not many queries. ...
- 23
0
votes
1
answer
277
views
mysql -V shows a different version than mysqld -V
I'm running centos 7 with mySQL 5.7.xxx. mysql -V shows Ver 14.14 Distrib 5.7.26-29, but mysqld -V shows Ver 5.7.11-4. systemctl status mysql and systemctl status mysqld both show the same running ...
- 101
3
votes
2
answers
314
views
mysql backup password without root home
What's the best way to provide a MySql root password (~/.my.cnf) to cron job without root to have the home folder?
the server I'm using is centos
- 47
0
votes
1
answer
896
views
No speedup using parallel restore with pg_restore
I need a large database like 10TB-15TB in Postgresql for benchmarking.
I've created a smaller ~100GB sample databases with pgbench like this:
pgbench -i -s 7000 --no-vacuum exampledb
However, I ...
- 513
0
votes
1
answer
3k
views
Suddenly, started getting "ERROR 2026 (HY000): Unknown SSL error"
MariaDB instance has been running well for ages, and suddenly, starting about 30 minutes ago, my apps get this error trying to connect:
# mysql
ERROR 2026 (HY000): Unknown SSL error
My certs have ...
- 839
1
vote
0
answers
41
views
Any thoughts on what crashed my database?
A few days ago, our database server, (see specs below), spiked to 4800% CPU usage. The database is about 100GB. For 3 hours we tried to figure out what the issue was. We finally figured out a feature ...
- 11
0
votes
0
answers
2k
views
ERROR 1932 (42S02): Table '....' doesn't exist in engine after upgrade mariadb
I need use JSON_OBJECT builtin mariadb function, but mariadb version in server 10.0.xx,
then we upgrade to 10.4.20-MariaDB.
Then now mariadb version is 10.4.20-MariaDB
But some table can't be accessed ...
3
votes
1
answer
30k
views
Mysql showing 100% CPU usage
We are facing problem of high cpu usage for mysql process (almost 100%). Here is the information related to server
Server Infos:
VPS - CENTOS 7.9 kvm - 6 GB RAM - 4 Core CPU - 180 GB SSD - MariaDB
And ...
1
vote
1
answer
2k
views
When changing the default port number from 5432 to 5332, why do I get a unix domain socket error?
I successfully followed the Postgres 11 installation instructions on Centos 7 found here. I am able to successfully create schemas / tables and insert data into the database over port 5432 with no ...
- 443
1
vote
2
answers
5k
views
how to change "localhost" in MariaDB
I wonder if there is any way to change localhost in MariaDB.
For example, while creating a user in database, it shows
'user'@'localhost'
I would like to know how to change localhost to any other ...
2
votes
1
answer
4k
views
MySQL InnoDB Cluster - Add instance issue with local port
I have an issue to add instance to MySQL InnoDB Cluster using MySQL Shell. Here are the steps that I have done:
Login to one DB-01 node
Run command: mysqlsh
shell.connect('username@ip-address:port');
...
- 123
0
votes
0
answers
35
views
MARIADB-10.3.14 VM OOM KILLED AND TUNING [duplicate]
DEDICATED VM FOR MARIADB -
CENTOS 7.7 \\ 16VCPU/250G - JBOD DISKS/NO SSD.
OS PARTITION AND DATABASE ARE ON DIFFERENT FILESYSTEM.
Span of every two weeks, Kernel OOM happens.
Reducing ...
- 1
0
votes
1
answer
9k
views
[[FATAL]] [[DBT-06103]] The port (5,500) is already in use [duplicate]
I am trying to install oracle 18c XE on CentOS 7. I have opened the ports:
firewall-cmd --permanent --add-port=1521/tcp
firewall-cmd --permanent --add-port=1630/tcp
firewall-cmd --permanent --add-...
1
vote
3
answers
1k
views
MySQL Optimization on my server
I have an active server running around 80-100 active websites. I would like to optimize the server and possibly reduce the amount of RAM and optimize my MySQL settings. I have 30 GB of RAM assigned ...
0
votes
1
answer
1k
views
MySQL database not loading table data
My centOS 7 server had an unexpected shutdown. For some reason one of the mysql database shows that all tables are empty, but if I browse the files in /var/lib/mysq/database I can see the files(.frm ...
- 101
0
votes
0
answers
72
views
How to find out all the postgresql database cluster data directories (running and Shutdown instances) on linux server
Could you please help us to find below details.
How to find out all the Postgresql database cluster data directories (running and Shutdown instances) on Linux server.
Regards,
Siva.
- 1
1
vote
1
answer
3k
views
Oracle Database Client Installation 12c minimal install - Centos / Red Hat 7
I'm looking at reducing the Linux package prerequisites when installing the Oracle Database Client 12c on the below headless application server / stack:
Install file: V839967-01.zip
Application ...
- 21
18
votes
3
answers
34k
views
PostgreSQL 11 error: column p.proisagg does not exist
Using phpPgAdmin v5.6 and PostgreSQL v11.2 on CentOS v7, when I try to access the Functions tab within the public schema, I get the following error:
ERROR: column p.proisagg does not exist
LINE 18: ...
- 1,815
0
votes
1
answer
356
views
MongoDB Replication Set Configuration Issue on CentOS 7
My mongodb instance will not run as standalone and I haven't been able to discover why. Its probably something simple. Please point me in the right direction.
Linux myserver 3.10.0-514.el7.x86_64 #...
- 103
0
votes
1
answer
1k
views
how to install PL/SQL Developer on centos
Can we install and run PL/SQL Developer on CentOS 7 server? I couldn't find installation documents anywhere. If the installation is possible can someone guide me on this.
- 1
0
votes
0
answers
5k
views
Newly built MySQL Galera Cluster does not start up in CentOS 7
I am setting up a 3 node MySQL Galera Cluster lab environment. All 3 nodes are CentOS 7 and followed the steps in below blog to setup mysql-wsrep-5.7
https://www.dreamvps.com/tutorials/install-...
3
votes
0
answers
1k
views
mysql 8 is failure to start after upgrade from 5.7
I've upgraded one of the slave server from mysql 5.6 to 5.7 and now 5.7 to 8.
But after up-gradation steps done when i use systemctl start mysqld.service or systemctl restart mysqld facing error and ...
1
vote
1
answer
1k
views
Oracle 11g stuck at installation in oracle linux no error msg only showing | and stuck
oracle not install on centos7 while installation it is stuck at 84% no error msg showing
0
votes
1
answer
129
views
MariaDB replication from master to slave
After doing some research around this topic, I should be attempting this task soon. However, I have two questions going around my head - could do with an experienced professional answering them.
I am ...
- 95
0
votes
1
answer
3k
views
Change in bind_ip value is not reflecting
I have mongo installed on Centos instance in AWS and I am connecting to the mongoDB server from my system. To connect from remote system we need to change bind_ip value to 0.0.0.0 in /etc/mongod.conf ...
0
votes
2
answers
82k
views
psql: FATAL: password authentication failed for user "postgres"
I am running postgresql-9.6 on Rhel7. I know that the default/root user doesnt have a password, however i will like to use phpPgAdmin to do my work. the problem is I have edited my pg_hba.conf file to ...
2
votes
1
answer
7k
views
Cannot login to postgres with newly created users
I have created a number of users in postgres using createuser --interactive --password but whenever I run sudo -i -u newuser I receive the following error:
sudo: unknown user: staging
sudo: unable to ...
- 235
1
vote
1
answer
723
views
Queries return ReadFailure exception, "Replica(s) failed to execute read"
I've a cluster consisting of 5 cassandra nodes. The cassandra version used is
cassandra-3.11.3-1.noarch
The keyspace strategy and is defined as follows:
CREATE KEYSPACE my_keyspace
WITH ...
- 111
2
votes
1
answer
227
views
Database Directory storage is full need to change link it to new Partition
My mysql Database Directory size is full. So I want to change it to another partition where there is large amount of space. The database version am using is MySQL 5.7.23 and OS is CentOS 7.
After ...
1
vote
1
answer
4k
views
Parse error in pg_hba.conf [closed]
Hope this is not as stupid a question as I think it is. But I'm in a loop and unable to find a solution.
I installed Postgres in centos machine. The installation worked fine (apparently). Now I have ...
- 13
3
votes
2
answers
882
views
SQL Server 2016 - write output file to mapped Samba share (CentOS 7)
I have a stored proc that's going through the tables, getting data, and write the result into a csv file (mainly to provide up to date data for FTP customers).
When writing it to the local D: drive, ...
- 41
1
vote
2
answers
2k
views
Unable to Restart PostgreSQL after attempting to move pg_xlog to different partition
I am having problems getting PostgreSQL back up and running on my CentOS 7 server.
Some Context:
After noticing that I was quickly running out of storage space on the /root partition of the server, I ...
- 121
1
vote
1
answer
4k
views
Binding specific ips with Mongodb
I am using Mongodb 3.6.3 on Centos 7.
I am running the below command:
sudo mongod --storageEngine wiredTiger --dbpath /data --bind_ip_all --logpath /var/log/mongodb/mongod.log --fork
and everything ...
- 235
0
votes
1
answer
787
views
Mongodb 3.6.3 disappears after 2 weeks on centos 7 ec2 instance
My Mongodb has disappeared 2 times, after 2 weeks, over the weekend within a 4 week time period.
I had a snapshot to recover from but I can't keep on recovering my db every 2 weeks. In an ec2 ...
- 235
3
votes
4
answers
2k
views
How to best store pixels in a database?
When loading data into a table, I get the following error:
ERROR: row is too big: size 8680, maximum size 8160
The table has 1000+ columns in it, which appears to be the problem. The general ...
- 133
29
votes
6
answers
198k
views
How to restart PostgreSQL server under CentOS 7
I installed PostgreSQL 10.1 under a CentOS 7.3 environment.
The service is started (postmaster.pid file present under /var/lib/pgsql/10/data), but I need to reload configuration or restart the server ...
- 1,815
2
votes
2
answers
333
views
Mysqld process not showing all options on command line in CentOs 7
Mysqld process showed all config file options on command line in CentOs 5 and CentOs 6. But it's not showing the same in CentOs 7. I am using mysql 5.7.21 on CentOs 7 example stated below and 5.7.19 ...
- 419
0
votes
1
answer
2k
views
MongoDB 3.4 Server not starting with bind error following a CentOS 7.4 security update
MongoDB 3.4 server is failing to start following a CentOS security update and reboot.
No configuration changes made. The previous update and reboot a couple of days earlier did not cause any ...
- 101
3
votes
4
answers
21k
views
How to install pgcrypto extension in postgres 10 on CentOS 7
I'm in the process of creating a postgres database for production in CentOS 7. So I already installed (yum install postgresql10-server postgresql10 after adding the repos of course) and configured ...
- 33
0
votes
1
answer
400
views
Issue with MongoDB Replication Set
I have 3 "CentOs 7" VM's in AWS environment in which I have setup MongoDB Repication Set using below command.
mongod --fork --logpath "/var/rs1/1.log" --replSet yogi --dbpath "/var/rs1/" --port 27017
...
- 121
0
votes
1
answer
4k
views
MongoDB Replication - “Failed with No route to host”
Hi,
Running MongoDB version 3.4.9 on two separate servers running Centos 7.
Trying to add a create a replica set but when ever I try to add a second server I get this error:
devshardcfgrs:PRIMARY> ...
- 1
0
votes
1
answer
2k
views
How to do PostgreSQL replication on CentOS 7?
Followed this guide to do the PostgreSQL replication:
https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-on-postgresql-on-an-ubuntu-12-04-vps
I didn't do this:
...
- 343
0
votes
1
answer
6k
views
Can't add another node from primary node with MongoDB replication set
On CentOS 7.
MongoDB version: 3.2.15
There are two nodes:
node1
node2
node1
/etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 node1
::1 localhost ...
- 343
9
votes
2
answers
26k
views
Can't run rs.initiate() when do mongodb replication set
Using CentOS 7.
MongoDB version: 3.2.15
Hostname: node1
Make directory:
mkdir /mongo-metadata
/etc/mongod.conf
# mongod.conf
# for documentation of all options, see:
# http://docs.mongodb.org/...
- 343
2
votes
1
answer
6k
views
Node unable to join a MariaDB Galera Cluster
I'm trying to setup a third node for my MariaDB cluster. I copied over the server.cnf file from my second node (which joins the cluster and can start its own cluster). The first two work fine using a ...
- 41
10
votes
3
answers
21k
views
Resolving port 5500 not free issue during Oracle 12c Release 2 Database Configuration Assistant installation on CentOS
Background
I am attempting to install Oracle 12c on CentOS 7 (deployed as a Hyper-V virtual machine) as outlined by this installation guide.
Problem
Everything with my installation goes well except ...
- 275
1
vote
1
answer
476
views
How to avoid intermittent "duplicate entry" error on slave when replicating mysql.time_zone_transition?
Rarely, but intermittently, MariaDB 5.5 fails to replicate the timezone tables onto a completely new replica (instance creation is all automated, so there's no room for missing/changed steps). We ...
- 403