Questions tagged [debian]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
0answers
24 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 ...
0
votes
1answer
187 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,...
0
votes
0answers
16 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] ...
0
votes
1answer
14 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
0answers
22 views

What's the easiest way to automate Mongodb backups, for offline storage? [duplicate]

So, I'm almost finished building my first major production web app, and am wondering how to manage backups. Weekly cold snapshot backups via my vps online admin seem ideal - but weekly downtime sounds ...
0
votes
1answer
39 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 ...
46
votes
7answers
110k views

Disable MySQL binary logging with log_bin variable

Default MySQL config file /etc/mysql/my.cnf installed by some debian package using APT often set log_bin variable, so binlog are enabled: log_bin = /var/log/mysql/mysql-bin.log When I want to ...
4
votes
6answers
57k views

Problem with new MySQL Workbench connection

I'm working on Debian 8 and wanted to create database using MySQL Workbench. I did everything in this tutorial, but when I created a new MySQL Connection, the program returned: Failed to Connect ...
0
votes
1answer
456 views

What to do when MySQL is not generating any logs at all on Debian?

The problem I'm having is that MySQL (5.5.46-0+deb7u1) is not generating log files. This on Debian Wheezy. The my.cfg file has been updated according to the required config for logging ALL queries (...
4
votes
6answers
140k views

“Table doesn't exist in engine” after moving tables from one VPS to another

I have two VPS's running right now. One, which I will refer to as the "old" server, runs on Debian 7 and gives this output for mysql --version: mysql Ver 14.14 Distrib 5.5.44, for debian-linux-gnu (...
0
votes
1answer
1k 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
vote
1answer
167 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
1answer
54 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 ...
2
votes
1answer
879 views

Repmgr: Error to promote Standby Cluster to Master Cluster in failover

I maked the configuration of the failover system based in Repmgr, but i don't haved success to promote the Standby Cluster to Master Cluster in case of failover. Following my configurations, this ...
0
votes
1answer
134 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 = ...
1
vote
1answer
75 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 ...
0
votes
0answers
48 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 ...
0
votes
0answers
50 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 ...
0
votes
0answers
9 views

what is the statistics part of a query profile?

I'm using Neor Profile SQL to check some bottlenecks in my DB execution queries and trying to profile a single one to understand how to improve it. The query SELECT COUNT(DISTINCT e.entity_id) FROM `...
1
vote
0answers
236 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 ...
1
vote
0answers
240 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/...
2
votes
3answers
159 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 ...
1
vote
0answers
29 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 ...
0
votes
0answers
37 views

Postgres symbol lookup error : undefined symbol: ing

I have a Docker container running PostgreSQL 12, and on container start-up I had a symbol look-up error. Starting the container again failed, but rebooting the host did lead to recovery. I didn't have ...
1
vote
1answer
432 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), ...
0
votes
1answer
781 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
1answer
190 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 ...
2
votes
1answer
113 views

MySQL perfomance

I have 2 main tables on the server. They have the same structure, but hold different data. Table #1: 214 million rows, size 40GB (25gb indexes) Table #2: 26 million rows, size 5.5GB (3.5gb indexes) ...
1
vote
0answers
318 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: ...
1
vote
2answers
287 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
1
vote
0answers
10 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
0answers
281 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 ...
7
votes
3answers
6k 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: ...
2
votes
1answer
74 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 ...
3
votes
0answers
2k 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 [...
0
votes
1answer
17 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.
-1
votes
1answer
543 views

PSQL copy-paste tab-completion and inserting errant parenthesis

Note, I use tabs. Frequently, when I write answers on this site, I write them in vim with the assistance of vim-surround, especially when I'm migrating a fixed-width table/grid to a DDL. Here is an ...
0
votes
1answer
138 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
1answer
62 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 ...
1
vote
1answer
60 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 ...
1
vote
1answer
1k 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, ...
0
votes
1answer
556 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 ...
0
votes
1answer
1k 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 ...
3
votes
2answers
6k views

MySql/MariaDB cannot change default datadir on Debian 9.1 server

I have a problem to move the default datadir of Maria DB to another partition, it appears to be very common but i tried everything I can without luck. Mysql is installed as Mariadb 10.1.26 with the ...
0
votes
1answer
575 views

Unable to start the mongo services on debian server

Mongo DB keep on crashing automatically and all database and collection remove automatically.This is happening randomly and when I check mongod.log I can see it's automatically dropped. Today I got ...
1
vote
0answers
25 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 ...
13
votes
1answer
49k views

PgAdmin 4 installation on Debian/Ubuntu [closed]

PgAdmin 4 1.0 has been just released, but on the download page for Linux there is only a link to a yum installer. Anybody knows if there are plans to create a deb installer? Or if there is already ...
2
votes
3answers
11k views

using tnsnames.ora and sqlplus client without installing oracle 11g server on linux client [closed]

I want to create a connection to remote Oracle server using SQLplus client and tnsnames.ora without installing Oracle 11g server on the Linux client. I used debian and bash script to generate reports ...
-1
votes
1answer
212 views

Is mysql using some kind of auto repair due to “check table” warnings?

Today i noticed a "strange" behaviour of MySQL when using "CHECK TABLE" on a crashed table. First i got a warning like "Size of datafile is: * ... Should be: *" but i could still "insert into / select ...
8
votes
3answers
17k views

Install SQL Server on Debian

I want to install SQL Server on Linux. From MS site I read that Red Hat, SUSE, and Ubuntu are supported but I want to use it under Debian. Since Ubuntu is based on Debian, is there a chance to succeed ...