Questions tagged [debian]

The tag has no usage guidance.

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

lost data after upgrading couchdb from v2 to v3

On a debian9 server I upgraded the couchdb 2.1.2 to 3.2 with : apt-get upgrade couchdb and I see no data or users database anymore. Fortunately I had made a backup of the files located in the data ...
1 vote
1 answer
66 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 ...
  • 193
0 votes
1 answer
29 views

Date missing from timestamp in mysql log

Currently, my log entries look like: time message 03:53:08 PM ERROR 05:40:32 PM ERROR ... ... I want the date included, like this: time message 06/30/2022 03:53:08 PM ERROR 06/30/2022 05:40:32 ...
  • 11
1 vote
0 answers
778 views

Replication instantly fails with 1032 error; Coordinator stopped because there were error(s) in the worker(s)

I have two databases, which I'm attempting to configure in a master-slave relationship (the eventual goal is to set them as master-master, but I'll settle for getting master-slave working at this ...
0 votes
0 answers
136 views

MySQL Workbench Migration and PostgreSQL ODBC, cannot connect

I am trying to migrate a PostgreSQL database to MySQL using the MySQL Workbench's Migration Wizard tool. I am on Debian 11 bullseye and installed MySQL Workbench 8.0.25 using Snap. It works fine, ...
0 votes
1 answer
89 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
0 votes
1 answer
359 views

MYSQL 8.0.2.8 Information_schema character set is incorrect, and I cannot find where to change it

I have a database installation where the collations look as so: As you can see, all the databases are utf8mb4, while the information schema is showing up as utf8mb3. This is causing me issues as I ...
1 vote
2 answers
214 views

how to downgrade mysql on Debian 10 from 8.029 to 8.02x

I have MySQL installed on my test server (Debian 10). I recently updated it to the newest version (8.0.29), but there are some issues with it so I want to go back to an older version (8.0.28). But I ...
  • 1,954
0 votes
0 answers
168 views

Firebird database - isql command not found

I have a problem with the firebird database. When I use docker run -it jacobalberty / firebird bash my isql command works but when i run docker exec -it firebird bash my isql command no longer works ...
0 votes
0 answers
30 views

How do I write MariaDB query results to several different outfiles on client side?

I have MariaDB server and client 10.5.12 both running on the same Debian 11 PC. I am running several SQL queries from a file that I pass to the MariaDB shell client: mysql < autoreport.sql I would ...
  • 1
0 votes
1 answer
58 views

MariaDB database has no 'max_used_connections'

I have a running MariaDB which has no max_used_connections variable. How can I see it? I got the list of all variables using the following command from the shell: SHOW VARIABLES; but it was not there....
1 vote
0 answers
207 views

Proper *smart* shutdown of PostgreSQL server for PGDG apt packages under Ubuntu/Debian?

I've installed PostgreSQL under Ubuntu 20.4 using the PGDG apt repository. Each time I stop the DB server, e.g., with sudo service postgresql stop, the log says 'received fast shutdown request', but I'...
  • 121
0 votes
0 answers
32 views

replicate_rewrite_db not working on create table

I'm trying to set up replication on Mariadb 10.6 on Debian 9. I'd like to replicate database "DB" on master to database "DB1" on slave. I've configured the following on the slave : ...
  • 1
0 votes
0 answers
21 views

How do I change to the new server version?

I have versions 13 and 14 of postgres installed on my system. When I start the server using systemctl start postgresql it always starts version 13. The client application shows version 14. # psql -V ...
  • 181
1 vote
1 answer
47 views

Potential pitfalls for upgrading PostgreSQL from 9.x/10.x to 13.x?

I have inherited from a predecessor a large number of Debian 9 systems that we are now looking at upgrading to Debian 11. Most of these run PostgreSQL 9 or 10, installed from Postgres's own ...
0 votes
1 answer
137 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 ...
  • 1
1 vote
1 answer
951 views

Unicenta opos 4.6.1 can't connect to mysql 5.7.36

Basically I can't get Unicenta opos to connect to a fresh install of mysql server on Debian 11. I have set up a user and granted privileges in mysql, created a new database named MAINDB and for some ...
  • 11
1 vote
2 answers
175 views

Multiple MySQL Instances Using systemd upgrade-safe/restart-safe?

We run MySQL 5.7.36 under Debian Buster with several instances. For this we use the feature of Systemd described at https://dev.mysql.com/doc/refman/5.7/en/using-systemd.html to work with argv[0]. (&...
  • 23
-1 votes
1 answer
540 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 ...
0 votes
1 answer
204 views

service mysql reload results 'Access denied', but service mysql start works

Using Debian 10.10. I have a MySQL problem. service mysql reload results 'Access denied' service mysql start executes correctly. All databases are working correctly after starting mysql. Strange, ...
  • 155
0 votes
2 answers
93 views

unknown variable 'file-key-management-filename'

New installation of Debian 10, with MariaDB 10.3.29. Trying to set up encryption-at-rest, but MariaDB won't start due to an error... [ERROR] /usr/sbin/mysqld: unknown variable 'file-key-management-...
1 vote
2 answers
1k 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 `...
  • 31
2 votes
1 answer
105 views

Unable to enter characters in MariaDB

I have just switched from MySQL to MariaDB and am running into a very silly problem: I cannot enter any extended characters in the database (for example, ö ä or å). The system is utf8, and I tried ...
  • 21
0 votes
0 answers
189 views

MySQL server startup error

My Issue After shutting down and starting my system up, my MySQL daemon gives me this in the logs (the pertinent snippet is as follows): 2021-05-03T12:48:32.458594Z 1 [ERROR] [MY-013183] [InnoDB] ...
  • 1
0 votes
1 answer
35 views

Does mongo *really* need a dedicated volume, if I need to back it up?

TLDR; What's the easiest way to automate a mongodb backup of a 20-gig DB? We run mongo on the same KVM (VPS) as the web app; the server runs Debian. We/I don't need/want to backup the entire fs on a ...
0 votes
1 answer
170 views

Mysqld draining memory, using way more then assigned and not giving any back

This is a production server. Whenever mysqld is restarted the memory consumption slowly builds up to about 75 to 90% of my total memory (while only 8 out of 32GB is allocated to mysqld). Sometimes ...
1 vote
1 answer
142 views

Wordpress query on MyISAM tables in MariaDB on ZFS takes too long to execute

I use a pretty common setup, some wordpress sites running on Debian 10 (Buster) with mariadb 10.3.27 on ZFS, on a decent server with SSDs and lots of RAM, pretty smooth operation with low CPU ...
  • 113
0 votes
1 answer
303 views

Can't restore master/slave replication from Percona backup (slave server)

A slave is restored from a master backup created with Percona xtrabackup On the master binlog is set to expire in 14 days and this backup is less than 24 hours old my.cnf (master) expire_logs_days = ...
  • 123
0 votes
0 answers
346 views

How can I check my config files my.cnf for example

I have 2 config files, master.cnf and slave.cnf, each containing a group [mysdql0] or [mysqld1] respectively. I have an almost identical setup across different servers and all but one work correctly ...
  • 13
0 votes
0 answers
78 views

Looking for some asistance in understanding mysql status

I have the following example for running; service mysql status and would appreciate some feedback on exactly what I am seeing. I've recently brought this system back up after a failure and things not ...
  • 13
1 vote
2 answers
295 views

MySQL hangs on SELECT from table with blob fields

I managed to create a mysql 8 InnoDB cluster with three nodes (VPS in one dedicated server, 25GB ram in each VPS, Total RAM in the server 96GB) and MySQL Router 8 everything works great but when I try ...
  • 111
1 vote
0 answers
1k views

What is the default my.cnf on debian's mariadb server?

I'm trying to set default-time-zone on mariadb server Server version: 10.3.25-MariaDB-0+deb10u1 Debian 10 To do such things, in mysql, I used to simply modify /etc/mysql/my.cnf but here I have a ...
  • 113
2 votes
3 answers
1k views

Moving from MySQL to MariaDB, better hardware but slower performance. Why?

I am in the process of migrating our servers to a new hosting provider, and they gave me exceptional hardware on the new node with the lasted Debian 10 and MariaDB 10.3.25. The database is on its own ...
0 votes
1 answer
7k views

MariaDB crashed: Unknown/unsupported storage engine: InnoDB

I've a Debian GNU/Linux 9 (4GB, 2 CPUs) on Digitalocean. Tonight (I've done nothing) my DB (mariaDB) crashed with this errors. I ran a wordpress with InnoDB and myISAM tables: 2020-10-17 0:51:18 ...
  • 1
1 vote
0 answers
154 views

How can I fix mariaDB in debian server?

I'm already too tired of trying so many different things and I can't even bypass an error which is running # mysql -u root -p when it asks for password, no matter what I type it shows Welcome to the ...
  • 111
2 votes
1 answer
2k views

Can't set root password after fresh installation of mariadb using ansible

Problem: After a fresh installation of mariadb 10.4 the root password could not be set using ansible. When installing mariadb from the debian packages by mariadb (not the official debian packages), ...
  • 181
0 votes
1 answer
3k views

Install mysql through deb file on ubuntu 20.04

Hi I've downloaded the file mysql-server_8.0.21-1ubuntu20.04_amd64.deb-bundle.tar from mysql site. I've extracted it to see below list of deb files libmysqlclient21_8.0.21-1ubuntu20.04_amd64.deb ...
0 votes
1 answer
466 views

PostgreSQL CPU 100% after configure Wal log shipping hot standby

I have configured Hight Avaliabily WAL Log Shipping Hot Standby (SSL) with one node. But after I configure, both hosts (primary and secondary) take 100% CPU usage. The most strange is because I have ...
1 vote
1 answer
290 views

Why is disk IO higher on Debian 10 (MariaDB 10.3) with MySQL replication?

I have a MySQL/MariaDB master-master replication setup that has been working well for several years, the db and tables are not very large (under 200MB for 18 tables). These were on 2 servers running ...
1 vote
0 answers
876 views

Can't enable wal2json in postgres 12 docker image

I'm trying to enable wal2json in an image extended from postgres:12 image. But i'm getting an error: postgres=# create extension wal2json; ERROR: could not open extension control file "/usr/share/...
  • 111
1 vote
0 answers
746 views

Is it possible to change the browser that pgadmin4 uses?

I have Debian 10, pgadmin4, and KDE. When I open pgadmin4, it opens with Firefox. I have several other browsers installed. If I try to paste the link in any other browser, I get this error message: ...
  • 234
1 vote
2 answers
964 views

deleted the /var/log/mysql folder

Due to a mistake i deleted the log folder for mysql. Is there a way to generate the folder and the error logs? I'm using MariaDB 10.3 on Debian 9 Stretch
  • 11
1 vote
0 answers
16 views

Upgrading Debian version of PXC production cluster

I have a 3 node PXC 5.7 cluster behind a ProxySQL instance. The cluster is still running on Debian 8. I have setup recently a testing PXC 5.7 cluster with a copy of the database on Debian 10 without ...
0 votes
0 answers
1k views

Setup certification for SQL Server running on Debian

I have successfully setup an instance of a SQL Server 2017 instance on the latest Debian release, and a domain that points to that server, and I have gotten the respective certificates by using ...
  • 166
3 votes
1 answer
172 views

Specific changes to glibc 2.28 that affect PostgreSQL

I am preparing for upgrading a PostgreSQL server to Debian 10 (Buster) with the warning from Debian release notes about changes to gclibc affecting PostgreSQL in mind. The PostgreSQL wiki provides two ...
  • 298
0 votes
1 answer
437 views

I want to delete connections in tnsnames.ora. I need to figure out which ones are currently in use, so that I don't delete them mistakenly

I'm using Oracle 12c in Debian 8 (on a vm) This question is for educational purposes only. I'm not using any production servers, so anything that you can tell me won't have consecuences To start with,...
4 votes
0 answers
4k 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 [...
  • 153
0 votes
1 answer
19 views

User called mysql in fresh mariadb install on debian

I just installed MariaDB 10.4 on Debian 10. In addition of root, there is a user called mysql. Can I remove this user ? What is the purpose of this account ? Thanks.
0 votes
1 answer
264 views

Can 2 different versions of MySQL be run side by side?

I have Debian 10 installed and have an instance of MySQL 8 running. I'd like to install 5.7 to try and bring up the database of a machine that failed, where I have the data directory fully intact, so ...
0 votes
1 answer
115 views

Mysql 8, Query on user table garbles terminal. Is this an Installation issue?

I have Mytsql 8.0.1 Community Edition installed on Debian 10.1 Preparing to restore some dump files, I'm attempting to get a remote connection and cannot ERROR 2003 (HY000): Can't connect to MySQL ...