Skip to main content

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
2 answers
23 views

MySQL 5.1 Time format of the 6-digit string

What time format is the 6-digit string in? Or is a transaction ID of some sort? MySQL server is 5.1. Errors log 240110 9:00:01 [ERROR] /usr/libexec/mysqld: Deadlock found when trying to get lock; try ...
supmethods's user avatar
0 votes
0 answers
63 views

Pgbouncer: got packet 'E' from server when not linked

Does anyone knows what this error below means? We running pgbouncer 1.21 on centos using transaction pooling mode. 2024-04-29 15:00:02.378 CST [9680] WARNING S-0x197b028: db/[email protected]:5432 got ...
mediocre's user avatar
  • 168
1 vote
0 answers
232 views

auto restart mariadb.service if oom-kill killed main process

I need some help trying to figure out why my mariadb service isn't automatically restarting upon crashing, likely due to insufficient memory on the server. Essentially, my server operates at around 75%...
Ryan H's user avatar
  • 111
0 votes
1 answer
68 views

MongoDB: What cause bytesRead in insert operation?

Recently we had high CPU/Memory and I/O usage on our MongoDB. While checking the logs all I found is some insert during this period. While inspecting logs I noticed most of the insert logs have ...
mediocre's user avatar
  • 168
0 votes
0 answers
15 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 ...
mediocre's user avatar
  • 168
0 votes
0 answers
111 views

Master-Slave replication in mysql error connecting to master 'replicator@xxx:3306' Can't connect to server on 'xxx' (111 "Connection refused")

Hi i am trying to make a connection between my Primary Server and backup server to have Master-slave mysql connection this is my Primary server ip = xxx and this is my Backup server ip = yyy both of ...
Matthew's user avatar
0 votes
0 answers
136 views

Intermittent database connection issues and errors following MariaDB upgrade in cPanel on Cloudlinux 7

I am experiencing intermittent database connection issues on my cPanel server running on CentOS 7, following an upgrade of MariaDB from version 10.5 to 10.6. Despite the upgrade process completing ...
user avatar
-2 votes
1 answer
49 views

Database Select statment not tatking input from html input field

Traceback (most recent call last): File "/home/will/.local/lib/python3.6/site-packages/flask/app.py", line 2073, in wsgi_app response = self.full_dispatch_request() File "/home/will/....
tvandiver's user avatar
1 vote
0 answers
179 views

Mariadb keeps crashing after sometime

I am getting a weird problem with Mariadb server. After starting the service after few mins the service will go down automatically. Upon checking status this is what I find. mariadb.service - MariaDB ...
Hari's user avatar
  • 11
1 vote
0 answers
16 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. ...
Mr.spark's user avatar
3 votes
1 answer
8k views

Is there any way to pg_upgrade PostgreSQL 12 to 15 over network?

My situation is a little bit complicated. I have an older version of PostgreSQL 12.9 installed on an older Centos Stream 8 machine. There are about five custom databases created under the roof, say ...
cidy.long's user avatar
  • 133
1 vote
2 answers
906 views

Apache Cassandra 3.11.2 unable to start Centos 7

I am trying to start Apache Cassandra 3.11.2 on Centos 7 and I get error Exception: ERROR [main] 2023-02-22 11:19:03,067 NativeLibraryLinux.java:64 - Failed to link the C library against JNA. Native ...
Dmitrij's user avatar
  • 23
0 votes
0 answers
339 views

MS SQL Edge running on Docker randomly quits within an hour of starting

I set up a new CentOS 7 VM (1GB of RAM, x86-64) and installed the latest version of Docker as instructed on the Docker website. After following the instructions on Microsoft's website to create an ...
meowbie's user avatar
2 votes
0 answers
87 views

PostgreSQL, how to include the linux hostname inside the postgresql.conf

I'm looking for a way to include the linux hostname at the end a a postgres log event. I did some changes in the log_line_prefix section inside the postgresql.conf but I'm unable to include the ...
GTGabaaron's user avatar
0 votes
1 answer
189 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 ...
Chris Strickland's user avatar
3 votes
1 answer
1k views

Postgres 13/14 JIT execution increase execution time of query considerably

I have a complex DB query that I run on different systems with identical specs, but different OS (CentOS7 vs. Debian 11). The Postgres version is 13.7, but I also tried with 14.4. I get vastly ...
spa's user avatar
  • 213
0 votes
0 answers
22 views

Error installing xtradb percona cluster

I have 2 nodes to join percona cluster . I installed them successfully , node 1 was able to start working . when I switched to node 2 configuration, I fixed the file my.cnf cat >>/etc/my.cnf<&...
jonny hieu nguyen's user avatar
0 votes
0 answers
271 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
419 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 ...
Nuno's user avatar
  • 829
-2 votes
1 answer
4k 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: ...
Miguel Guzmán 's user avatar
0 votes
0 answers
742 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 ...
EmiliOrtega's user avatar
0 votes
1 answer
160 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 ...
Christoforos's user avatar
0 votes
1 answer
767 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 ...
Erfun's user avatar
  • 103
0 votes
0 answers
250 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 ...
Glen G's user avatar
  • 3
-1 votes
1 answer
382 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
2k 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 ...
Nuno's user avatar
  • 829
0 votes
1 answer
168 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 ...
vPilot's user avatar
  • 47
1 vote
1 answer
37 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 ...
Jintor's user avatar
  • 113
0 votes
1 answer
296 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-...
step's user avatar
  • 101
9 votes
4 answers
28k 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-...
zaidwaqi's user avatar
  • 191
0 votes
1 answer
244 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 ...
huangxy's user avatar
0 votes
1 answer
63 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 ...
nik's user avatar
  • 1
0 votes
1 answer
301 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 ...
Manoj R's user avatar
  • 101
1 vote
1 answer
517 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 ...
buddinggeek's user avatar
0 votes
0 answers
150 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
3k 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 ...
Lloyd Thomas's user avatar
0 votes
0 answers
2k 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/...
WOWOWOWOW's user avatar
1 vote
1 answer
2k 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 ...
John Doe's user avatar
0 votes
0 answers
23 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" ...
K8sN0v1c3's user avatar
0 votes
0 answers
326 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": ...
Lloyd Thomas's user avatar
0 votes
1 answer
383 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 ...
王奕然's user avatar
  • 111
-1 votes
1 answer
1k 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
901 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=...
Cpt.Whale's user avatar
  • 155
2 votes
1 answer
184 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 ...
Alex Drago's user avatar
1 vote
0 answers
4k 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 ...
I'm Root James's user avatar
0 votes
1 answer
91 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 &...
Ciccio Pasticcio's user avatar
0 votes
2 answers
2k 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 ...
user987376746090's user avatar
0 votes
1 answer
887 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-...
user987376746090's user avatar
0 votes
1 answer
299 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 ...
bioplanet's user avatar
0 votes
0 answers
124 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 ...
Gustavo Ramos's user avatar