Questions tagged [debian]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
2 answers
40 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 ...
user avatar
  • 1,920
0 votes
0 answers
25 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 ...
user avatar
0 votes
0 answers
9 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 ...
user avatar
  • 1
0 votes
1 answer
25 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....
user avatar
1 vote
0 answers
66 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'...
user avatar
  • 121
0 votes
0 answers
21 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 : ...
user avatar
  • 1
0 votes
0 answers
18 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 ...
user avatar
  • 181
1 vote
1 answer
30 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 ...
user avatar
0 votes
1 answer
47 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 ...
user avatar
  • 1
1 vote
1 answer
528 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 ...
user avatar
  • 11
1 vote
2 answers
107 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]. (&...
user avatar
  • 23
-2 votes
1 answer
313 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 ...
user avatar
0 votes
1 answer
79 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, ...
user avatar
  • 155
1 vote
0 answers
80 views

debain execute msyql_install_db failed. mysqld: Got error 'Can't create file' when trying to use aria control file

Question I want to run a mysql server standalone. When I try to initialize a new mysql data directory by run msyql_install_db --defaults-file=my.conf --user=mysql, It said that I have no enough ...
user avatar
0 votes
1 answer
56 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-...
user avatar
1 vote
2 answers
682 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 `...
user avatar
  • 31
2 votes
1 answer
89 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 ...
user avatar
  • 21
0 votes
0 answers
133 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] ...
user avatar
  • 1
0 votes
1 answer
30 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 ...
user avatar
0 votes
1 answer
89 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 ...
user avatar
1 vote
1 answer
110 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 ...
user avatar
  • 113
0 votes
1 answer
259 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 = ...
user avatar
  • 123
0 votes
0 answers
257 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 ...
user avatar
0 votes
0 answers
74 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 ...
user avatar
1 vote
2 answers
230 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 ...
user avatar
  • 111
1 vote
0 answers
995 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 ...
user avatar
  • 113
2 votes
3 answers
954 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 ...
user avatar
0 votes
1 answer
5k 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 ...
user avatar
  • 1
1 vote
0 answers
97 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 ...
user avatar
  • 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), ...
user avatar
  • 171
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 ...
user avatar
0 votes
1 answer
409 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 ...
user avatar
1 vote
1 answer
260 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 ...
user avatar
1 vote
0 answers
706 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/...
user avatar
  • 111
1 vote
0 answers
627 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: ...
user avatar
  • 234
1 vote
2 answers
729 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
user avatar
  • 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 ...
user avatar
0 votes
0 answers
938 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 ...
user avatar
  • 166
3 votes
1 answer
131 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 ...
user avatar
  • 268
0 votes
1 answer
365 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,...
user avatar
4 votes
0 answers
3k 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 [...
user avatar
  • 155
0 votes
1 answer
18 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.
user avatar
0 votes
1 answer
234 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 ...
user avatar
0 votes
1 answer
104 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 ...
user avatar
8 votes
3 answers
8k views

Unable to start mongodb as a service - Exception; Collection does not have UUID in KVCatalog

I have installed Mongodb 4.2 and when running sudo service mongod start|restart It does not start the server and I have the log below in mongod.log file. Exception in initAndListen: MustDowngrade: ...
user avatar
  • 183
1 vote
1 answer
104 views

Run out of disc space on Debian server due to postgresql database

I recently run out of disc space no my server due to implementing some audit tools on Postgresql database. Two tables holding data about changes made by users quickly reached 16GB each, and totally ...
user avatar
  • 11
1 vote
1 answer
2k views

Mariadb won't start (can't change dir, errcode 13: permission denied)

I moved my MariaDB database to /media/user/extdrive1/mysql, updated the conf files, and changed chown for the drive to 7777 for user mysql.mysql. Despite all this, sudo systemctl start mysqld fails, ...
user avatar
  • 21
0 votes
1 answer
637 views

How to use 'mysql -uroot -pXXXX' on Debain 9.8?

My apologies for this lame question. Debian 9.8 changed some things and mysql is broke but I can't seem to fix it. I installed MySQL on Debian 9.8, which now installs MariaDB 10.1. After install I ...
user avatar
0 votes
1 answer
2k views

Access denied for user 'root'@'localhost' What proces is causing this?

I got this connections constantly in logs, how to trace what app is trying to connect? root@localhost is allowed to connect and working for some apps. I think there is some app without changed ...
user avatar
1 vote
0 answers
29 views

MySQL not starting when shut down with mysqladmin

MySQL server 5.5 fails to start when I use the mysqladmin shutdown command to stop the server. The only option to start MySQL server is to reboot the machine. Is there is any option so that I can ...
user avatar