Questions tagged [debian]
The debian tag has no usage guidance.
109
questions
1
vote
1
answer
101
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 ...
-1
votes
1
answer
975
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 ...
- 3
1
vote
0
answers
420
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 ...
- 21
1
vote
0
answers
280
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 ...
- 121
0
votes
0
answers
236
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
...
- 1
1
vote
0
answers
809
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 ...
5
votes
2
answers
2k
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 "...
- 91
2
votes
1
answer
412
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 ...
- 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, ...
- 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 ...
- 203
0
votes
1
answer
212
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
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 ...
0
votes
0
answers
539
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, ...
2
votes
3
answers
511
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 ...
- 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 ...
1
vote
2
answers
894
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 ...
- 2,126
0
votes
0
answers
599
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
1
answer
166
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
1
answer
733
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'...
- 125
0
votes
0
answers
37
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
...
- 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 ...
1
vote
1
answer
537
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 ...
- 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 ...
- 11
1
vote
2
answers
410
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
0
votes
1
answer
2k
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
...
- 1,437
0
votes
1
answer
578
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, ...
- 157
0
votes
2
answers
376
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
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 `...
- 41
2
votes
1
answer
350
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
495
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] ...
- 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 ...
- 101
0
votes
1
answer
850
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
238
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
423
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 = ...
- 147
0
votes
0
answers
655
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 ...
- 23
1
vote
2
answers
559
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
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 ...
- 123
3
votes
3
answers
4k
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 ...
- 153
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 ...
- 21
1
vote
0
answers
276
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
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), ...
- 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
...
- 111
0
votes
1
answer
871
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 ...
- 314
1
vote
1
answer
389
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 ...
- 61
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/...
- 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:
...
- 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
- 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 ...
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
2
answers
580
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 ...
- 358