2022 Developer Survey is open! Take survey.

Questions tagged [centos]

CentOS is a Linux operating system. Questions with this tag should be about administering a database management platform on the CentOS operating system.

Filter by
Sorted by
Tagged with
0 votes
0 answers
42 views

Why mysql 8.0.17 is clean after crash

I was working with my website and after I started a very huge process in the server (CentOS 8.5.2111), the server can not allocate more tasks because memory full, and MySQL (8.0.17) started with ...
user avatar
0 votes
1 answer
22 views

Why is there a big gap in the actual Table space? (calculated vs information_schema vs file size)

I have a InnoDB table with the following columns: BIGINT -> 8 bytes BIGINT -> 8 bytes ENUM(0,1) -> 1 byte MEDIUMINT -> 3 bytes INT -> 4 bytes = 24 bytes per row It contains 10454004 ...
user avatar
  • 599
-1 votes
1 answer
215 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
0 answers
126 views

postgresql suddenly stopped working "incomplete startup packet error"

I've searched and read a lot about these kind of errors, but none of them solved my question. Why does this error happens all of a sudden ? could this to be a problem of memory on the server ? (I ...
user avatar
0 votes
1 answer
22 views

Maria db false size

I am using maria db on a centos 7.5 VM with 150G disk. Df command shows me 30G free. I've 2 large dbs about 20G each. That is a sum of 40G. I have 3 smaller dbs let's say 20G more, so I have a total ...
user avatar
0 votes
0 answers
26 views

WHM MySQL not restarting

we have an issue with WHM and MySQL. The server cannot restart MySQL. we have tried to repair the database without any joy. We believe the issue was caused when a process caused the server to run out ...
user avatar
0 votes
1 answer
43 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
192 views

ERROR: Error when fetching backup: pg_basebackup exited with code=1 when start patroni service for a replica

I created a cluster including 3 servers via Patroni. Everything was alright like failover, switchover... but when I try to add another replica server I am getting an error like this: Eki 25 13:19:22 ...
user avatar
0 votes
0 answers
33 views

MariaDB rotated logs are empty on CentOS7

I've been having the same problem for a couple of weeks now. I have the following /etc/logrotate.d/mariadb file configuration: /var/log/mariadb/*.log { create 600 mysql mysql ...
user avatar
  • 3
-1 votes
1 answer
48 views

How to create a cronjob backup for mysql slave?

There are few other threads about this question using mysqldump but however i tend to not use mysqldump but instead backup the whole files in /mysql. I would like to create a cronjob in mysql slave ...
user avatar
0 votes
1 answer
93 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 ...
user avatar
  • 599
0 votes
1 answer
27 views

Need to Alter PostgreSQL Startup on CentOS 7?

I am planning a move of Postgres' data directory from one disk to another on a CentOS 7 server. All of the data and configuration files reside in /var/lib/pgsql/12/data/. I have previously migrated ...
user avatar
  • 37
1 vote
1 answer
22 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 ...
user avatar
  • 113
0 votes
1 answer
112 views

MariaDB 10.5.9 every day from 0:00 to 1:00 each 5 minutes shutdown

Log looks like: 2021-04-29 0:00:01 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown 2021-04-29 0:05:02 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown 2021-...
user avatar
  • 101
4 votes
3 answers
3k views

postgresql-setup --initdb with custom data directory

I am trying to setup Postgres 12 on Centos 8. Postgres shall be installed in the default directory i.e. /var/lib/pgsql, however I want the data directory to be in /data/pgsql I want to use postgresql-...
user avatar
  • 141
0 votes
1 answer
75 views

Can I copy installed mysql from ubuntu to centos7 directly without installation?

I'm trying to copy an installed MySQL from Ubuntu to Centos7 because I do not want an installation on Centos7 any more. This looks like it works but I'm not sure if there any potential issues which I ...
user avatar
0 votes
1 answer
38 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 ...
user avatar
  • 1
0 votes
1 answer
75 views

sqlcmd is running but database shown no running query

We are facing this weird issue on our Azure setup. The database is SQLServer and client is CentOS. We fire queries using sqlcmd. Sometimes it happens that you see the sqlcmd running, but there is no ...
user avatar
  • 101
1 vote
1 answer
162 views

Linux Volumes for SQL Server + Docker on Linux [closed]

I am testing out a POC project for SQL on Docker containers on Linux and wanted some background info on how to request the storage on the Linux VM. The plan is to spin up 10 containers with SQL 2019 ...
user avatar
0 votes
0 answers
44 views

Restore specific date from mysql dump file

i have a big mysql dump-file since 2015 i want to restore all data form 2020 and 2021 Note : schema have a lot of tables and every table have it's own data and we didn't want all table we need only 3 ...
user avatar
1 vote
1 answer
1k views

Ident authentication failed for user "postgres"

I am using PostgreSQL12 on Cent0S8, and I am able to connect to PostgreSQL using the command: sudo -u postgres psql However, when I attempt to connect using: psql -U postgres -h localhost I recieve ...
user avatar
0 votes
0 answers
797 views

Cannot start new MySQL process - Linux

I have created a new MySQL cluster by this: mysqld --initialize-insecure --basedir=/var/lib --datadir=/var/lib/mysql2 --defaults-file=/etc/my2.cnf chown -R mysql:mysql /var/lib/mysql2 chmod 777 /var/...
user avatar
0 votes
0 answers
25 views

Install MySQL from CentOS repository

I googled for the solutions of installing MySQL in CentOS stream, all the pages I got told me to add the repository of MySQL. The problem is, why do I have to add MySQL's repository instead of ...
user avatar
0 votes
1 answer
246 views

How would I sync tables in two separate servers in mysql?

DB: mysql Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1 I have two separate servers running MariaDB 5.5, both in production. Both setups are live, and users might access any ...
user avatar
0 votes
0 answers
15 views

How do I enable pgadmin4 (PostgreSQL12) to read and write files in directories of other Linux Users on RHEL8/CentOS8 [duplicate]

While trying to export a query result set from PGAdmin4 on PostgreSQL12 to a CSV I am encountering the following error: ERROR: could not open file "/home/linuxusername/Downloads/data.csv" ...
user avatar
0 votes
0 answers
175 views

CentOS 8 Unable to connect to PostgreSQL 12 Server

When I attempt to connect to postgres in from my linux command line, I receive the following error: [lloyd@localhost ~]$ sudo -u postgres psql could not change directory to "/home/lloyd": ...
user avatar
0 votes
1 answer
193 views

Encounter installation problems on postgres 12

i install postgres-12,but report this error,i have execute sudo systemctl restart postgresql-12 ,and follow this install postgres12 on centos 7, and when i step into Step 5: Enable remote access,and ...
user avatar
  • 111
-1 votes
1 answer
670 views

mysqld crashing almost every hour - mysqld invoked oom-killer - [duplicate]

I am running wordpress on a centOS digital ocean droplet my mysql keeps crashing almost every hour -- with an out of memory error manually restarting mysqld brings it back up via sudo service mysqld ...
user avatar
0 votes
1 answer
398 views

db2cli license file not being used

I'm using the db2 driver for CLI and ODBC to configure an ODBC connection to DB2 on IBM i/OS from CentOS. I'm trying the following command: db2cli execsql -connstring "protocol=TCPIP;database=...
user avatar
  • 155
1 vote
1 answer
59 views

Adjusting the my.cnf file for DB servers after an instance resize

I am trying to optimize the DB server of one of our production environments (MySQL DB, centos7), and I've noticed that there is a very high memory consumption of the DB. After further investigation I ...
user avatar
0 votes
0 answers
3k views

Remote Access in Centos 8 and MySQL 8

I cannot access MySQL 8.0 on a Centos 8 server remotely with an error: ERROR 2026 (HY000): SSL connection error: unknown error number I can see port 3306 when doing a port scan remotely using nmap ...
user avatar
0 votes
1 answer
34 views

Strange PostgreSQL behaviour on service start

Centos 8.3, postgresql 12 (i tried even 10, same thing). I have set the permission of the data directory to postgres:postgres. If I start the service from systemctl, it gives me the error message &...
user avatar
0 votes
2 answers
692 views

Unable to import DMP file that is made in 11g2 to Oracle 18c

My OS=CENTOS 7 Oracle=18c XE I am trying to import a DMP file that is exported from XE 11g2 and now trying to import it in 18c XE. Here are the errors: [root@linux gsw]# impdp user/pass ...
user avatar
0 votes
1 answer
135 views

Not able to access Oracle manager online. Port 5500 is closed [closed]

I am using Oracle 18c XE on CentOS 7. The database installed successfully but not able to bring it online to my hostname. what I did is: Added port 5500 in firewall: firewall-cmd --permanent --add-...
user avatar
0 votes
1 answer
54 views

Connection issue to Mysql from Apache server

I am operating on Centos7 and Mysql 5.6.46. I needed to move the default datadir location to an encrypted partition and I changed my default /etc/my.cnf file accordingly: # For advice on how to ...
user avatar
0 votes
0 answers
46 views

RSA Certificate Error Starting MySQL 5.7 on CentOS 6

We've been getting some trouble installing MySQL 5.7 on a CentOS 6 box. Information about the environment is available below: CentOS Version: [root@ip-10-0-0-73 ~]# cat /etc/centos-release CentOS ...
user avatar
0 votes
0 answers
207 views

Maximum concurrent users on linux server

I have a dedicated server with these info: 128G RAM 6 cores/12 threads CPU, 3.4GHz 512 SSD storage WHM/Cpanel latest Apache/MySQL Centos 7.x I have a single website on this server which have heavy ...
user avatar
1 vote
1 answer
449 views

Postgres initialization of pg_basebackup

Hi Im running on a centos 7 machine, Im in the process of migrating an old postgres database to the new server, it has like 10TB of data so Im trying it with pg_basebackup. The new server has an ...
user avatar
  • 767
0 votes
1 answer
45 views

MariaDB: Connecting from LAN on Centos

I have a working MariaDB 10.2 running on my CentOS 6 server. I can connect to the DB from another machine on the LAN. Out of curiosity, I wanted to revisit how this was made possible. Everything I ...
user avatar
  • 2,337
0 votes
0 answers
22 views

after running Galera Replication for MariaDB , performance (TPS) does huge diffrence [duplicate]

I have two VM machines (with exact hardware-software configuration on two ESXI Servers in same rack and same subnet too) that is running with nginx + PHP-FPM + and MariaDB 10.4. in each ESXI server I ...
user avatar
1 vote
1 answer
702 views

How to dedicate server to MySQL for max performance?

I am using MariaDB 10.5, I see this in MySQLTuner report Dedicate this server to your database for highest performance. How do I do this? My server is on Centos 8.
user avatar
  • 13
0 votes
1 answer
300 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 ...
user avatar
0 votes
2 answers
197 views

MariaDB 5.5 InnoDB keeps opening files up to 200k until system hangs

MariaDB 5.5 is installed on CentOS and serves a database in the total volume of around 40GBs (as measured per database files on a disk) and 506 tables. This database is being queried by php-fpm, and ...
user avatar
  • 101
-2 votes
1 answer
217 views

Deleted oradata folder under oracle home by accident

While setting up a new server, I accidentally deleted the oradata folder in the working Database server. I have no backup of the working database, I googled and found flashback option to recover, but ...
user avatar
  • 1
0 votes
2 answers
6k views

Unable to install Oracle XE 18c on Centos 8

I am trying to install Oracle 18 on Centos 8 64 Bit. I have been able to install the prerequiste component, that in itself requires pre-requisites, but the Oracle install itself fails. Any ...
user avatar
  • 31
0 votes
0 answers
1k views

Error Code: 1129 Host 'xxx.xxx.xx.xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

For the past few days, I am getting this error every morning when I tried to connect to the MySQL database using the MySQL workbench and also through some applications. So, every day I log onto the ...
user avatar
1 vote
2 answers
7k views

How to get a new pid file of Mysql and restart Mysql Successfully?

Due to lost of pid file of my server, I can't stop mysql using normal commands like service mysql stop which will show ERROR! MySQL server PID file could not be found! So I try to stop all mysql ...
user avatar
1 vote
1 answer
1k views

Change mariadb's log directory

MariaDB was installed using yum on Centos7 using repository http://yum.mariadb.org/10.3/centos7-amd64. MariaDB's log files are sent to directory /var/lib/mysql. How can I change the location to ...
user avatar
0 votes
0 answers
541 views

Restoring MySQL database data from ibdata1 and ib_logfile

I am trying to restore a MySQL database. I have the following: ibdata1 ib_logfile0 ib_logfile1 .frm files restored as I have a backup of the structure. Is it possible to restore the data for the ...
user avatar
  • 1
0 votes
0 answers
57 views

CentOS7 Virtual Machine postgres10 not initializing

I had postgres9.6 installed and working the other day but the version wasn't compatible. I used YUM REMOVE to remove that one and then followed the instructions here https://www.postgresql.org/...
user avatar