Questions tagged [debian]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
73 views

Fatal error 1408 when installing mariadb-server / mariadb-upgrade

I recently upgraded my Debian 10 server running MySQL 5.7 to Debian 11 and MariaDB 10.3. That upgrade went smoothly. I then decided to upgrade to Debian 12 and MariaDB 10.11. While performing that ...
Curtis Spencer's user avatar
-1 votes
1 answer
780 views

Postgres Service cannot restart after crash (Killed by OOM)

I use below Postgres on my Debian. PostgreSQL 13.8 (Debian 13.8-0+deb11u1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit Sometimes OOM kill Postgres process. here ...
A.F.N's user avatar
  • 3
1 vote
0 answers
344 views

How to restart postgresql automatically in case of difficulties

I have a postgresql (13) server installed under debian (started with systemd) which sometimes has difficulties to start due to disk space problems which seem ephemeral. In such cases I would like to ...
NorbertK's user avatar
0 votes
0 answers
37 views

Recompiling stored procedures result in error "function SHASH_HMAC is not defined. module name or entrypoint could not be found."

I want to migrate database to new server, and I have problem with stored procedures compilation. I have error like this: Invalid token. invalid request BLR at offset 588. function SHASH_HMAC is not ...
MarekOadmin's user avatar
1 vote
0 answers
260 views

Changing root and user passwords in MariaDB 10.5?

We have a few MariaDB servers (MariaDB 10.5, running on Debian 11/bullseye) where we need to change the passwords for the DB root user and for other user accounts in the DB system (by which I mean ...
dave559's user avatar
  • 121
0 votes
0 answers
227 views

Data loss and Table 'xxxx.xxx' doesn't exist in engine

I have a weird problem that is driving me crazy. Let's see if someone can help me. This is my stage. /# cat /etc/os-release PRETTY_NAME="Debian GNU/Linux 9 (stretch)" /# mysql --version ...
xabikip's user avatar
1 vote
0 answers
748 views

Unable to initialize a DB cluster and if initialized, pg_ctl does recognize active PostgreSQL services?

I am running [email protected] via wsl2 on Windows 11. I got a few issues. One - I am unable to initialize a PostgreSQL DB cluster Below are my bash configurations that I edited using sudo nano. ~/.bashrc ...
iCantFindaGoodUsername's user avatar
5 votes
2 answers
1k views

how to match pg_repack binary and db version

I am using this command sudo apt-get install postgresql-11-repack to install pg_repack(default to 1.4.8). postgresql-11-repack is already the newest version (1.4.8-1.pgdg20.04+1). when i run "...
Falcon's user avatar
  • 91
2 votes
1 answer
388 views

MariaDB 10.3 on Debian 10 ignores long_query_time value

I have enabled the Slow Query Log on a Mariadb 10.3 server on Debian 10. Below is the implemented configuration MariaDB [(none)]> show session variables like '%slow%'; MariaDB [(none)]> show ...
MJJ's user avatar
  • 23
0 votes
1 answer
1k views

Setting custom MariaDB max_allowed_packet value in Debian 11?

[This is more of an OS config file question, but I have had no response on Unix.SE, so I am hoping that the 'join' of DB admins and sysadmins here may result in better luck…] Our Moodle server, ...
dave559's user avatar
  • 121
2 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
  • 203
0 votes
1 answer
202 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 ...
Asher's user avatar
  • 11
3 votes
0 answers
3k 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 ...
Peter Brunton's user avatar
0 votes
0 answers
521 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, ...
Francois J's user avatar
2 votes
3 answers
485 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 ...
Ror's user avatar
  • 131
0 votes
1 answer
3k 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 ...
M.Barbara's user avatar
1 vote
2 answers
851 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 ...
IGGt's user avatar
  • 2,086
0 votes
0 answers
567 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 ...
Alex Pantea's user avatar
0 votes
1 answer
159 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....
rcbijhamrwwksk's user avatar
1 vote
1 answer
699 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'...
cstork's user avatar
  • 123
0 votes
0 answers
35 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 ...
Zephyrus's user avatar
  • 301
1 vote
1 answer
83 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 ...
Chris Douglas's user avatar
1 vote
1 answer
499 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 ...
Ror's user avatar
  • 131
1 vote
1 answer
2k 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 ...
jr91's user avatar
  • 11
1 vote
2 answers
390 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]. (&...
heuri's user avatar
  • 23
-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 ...
Saeed Neamati's user avatar
0 votes
1 answer
543 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, ...
klor's user avatar
  • 157
0 votes
2 answers
354 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-...
Stephen's user avatar
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 `...
Firav's user avatar
  • 41
2 votes
1 answer
317 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 ...
jorgon's user avatar
  • 21
0 votes
0 answers
476 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] ...
jvndev's user avatar
  • 101
0 votes
1 answer
49 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 ...
harry young's user avatar
0 votes
1 answer
780 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 ...
dotSpokane's user avatar
1 vote
1 answer
235 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 ...
gmelis's user avatar
  • 113
0 votes
1 answer
421 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 = ...
clarkk's user avatar
  • 147
0 votes
0 answers
638 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 ...
plisken's user avatar
  • 23
1 vote
2 answers
538 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 ...
mbouzahir's user avatar
  • 111
2 votes
0 answers
2k 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 ...
zumba's user avatar
  • 123
3 votes
3 answers
3k 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 ...
Fabrizio Ferrari's user avatar
2 votes
1 answer
14k 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 ...
LOM's user avatar
  • 21
1 vote
0 answers
269 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 ...
newbie's user avatar
  • 111
2 votes
1 answer
3k 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), ...
toydarian's user avatar
  • 201
0 votes
1 answer
7k 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 ...
Ajeetkumar's user avatar
0 votes
1 answer
831 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 ...
Leonardo Lacerda's user avatar
1 vote
1 answer
378 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 ...
nosilver4u's user avatar
2 votes
1 answer
2k 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/...
Ayush's user avatar
  • 121
1 vote
0 answers
1k 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: ...
raphael75's user avatar
  • 244
1 vote
2 answers
2k 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
Fabian's user avatar
  • 11
1 vote
0 answers
19 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 ...
Matthew Neirynck's user avatar
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 ...
ccoutinho's user avatar
  • 166