Skip to main content

Questions tagged [ubuntu]

Ubuntu is a desktop and server operating system based on Debian GNU/Linux. Note that http://askubuntu.com is specifically dedicated to Ubuntu questions.

Filter by
Sorted by
Tagged with
4 votes
1 answer
1k views

Flask mongodb assertion 13 not authorized for query on flask_session.sessions

Need help resetting mongodb back to its original state. We have a flask app running with mongodb with authentication turned off. Running on Ubuntu with std Flask. We tried ALL sorts of combinations ...
0 votes
1 answer
1k views

pg_dump can not create directory after increase directory space

I recently run pg_dump to backup database using this command using user postgres : time pg_dump -j 4 -Fd -Z 3 db_profile -f /backup-nfs/ Previously, the size of backup-nfs was 100 G. The pg_dump ...
0 votes
1 answer
718 views

Polybase with SQL Server 2019 on Linux or Containers

I would like to install SQL Server 2019 on Linux either a full Linux server (Ubuntu 18.04) or on a Docker container with Polybase. Installing MSSQL 2019 on a Linux Server or a container is relatively ...
0 votes
1 answer
2k views

postgresql received fast shutdown request in ubuntu

I'm working on deploying my flask application on nginx and gunicorn and for a while I've been able to access the site on my mobile device but a couple of days ago it abruptly stopped. The logs showed ...
5 votes
1 answer
2k views

Mongodb crash after WiredTiger Cannot allocate memory error

I am using MongoDB (3.2.6) as storage for my application and since a couple of weeks MongoDB started to crash usually every 1 or 2 weeks. The crash seems to come from an issue during WiredTiger memory ...
1 vote
1 answer
4k views

How to repair mongodb collection when index is corrupt?

Mongo version: 2.6 I think one or more of my MongoDB index is corrupt which is not letting me delete the corrupt collection or make a backup with mongodump Below is the error i get when i try to ...
1 vote
1 answer
43 views

How to start the PostgreSQL cluster using sudo systemctl while running as postgres user that has no password?

I am new to PostgreSQL world and I am facing this issue: When I try to start postgres 14 cluster using the following command: pg_ctlcluster 14 testcluster start It starts but gives me the hint that: ...
3 votes
1 answer
2k views

mysqld node not connecting to cluster

I'm trying to set up a basic NDB cluster, the data nodes register correctly but the mysqld API node doesn't accept Connected to Management Server at: 174.138.80.168:1186 Cluster Configuration --------...
1 vote
1 answer
2k views

Mysql eat a lot of memory but innodb_buffer_pollsize is set to 50%

I don't understand why my mysql eat a lot of memory even though I set innodb_buffer_poll_size to around 50% here is my top user@Mulia-Abadi:~$ top top - 11:09:31 up 12 days, 16:30, 3 users, load ...
1 vote
0 answers
20 views

Ubuntu How to change the username PGAdmin tries to use to login

I uninstalled Postgresql and PGAdmin4 from ubuntu and installed them back but, now, when I open PGAdmin and click on servers/local, it requests for the password of a user no longer exists and there's ...
1 vote
2 answers
5k views

Mongo exception: connect failed on reboot

I have Mongo installed on Ubuntu 16.04 machine, on VMWare. I start it using "mongo" command, last week there was no problem. But recently, it gives this error: MongoDB shell version: 3.2.15 ...
0 votes
1 answer
493 views

Postgres service does not start after abrupt reboot

Postgres 9.6.1 does not start automatically after an "abrupt" reboot (Ubuntu 18.04). Postgres service is configured to start on reboot, but the server does not come up at all! The only way ...
0 votes
1 answer
31 views

SQL and Management Nodes on same server in NDB cluster. SQL Nodes not connecting

I've setup a ndb cluster with 7 nodes. 3 data nodes on their own servers, and 2 management nodes that each have a sql node on them on 2 servers. I've narrowed down what I think my issue is. My cluster ...
1 vote
2 answers
1k views

Problem importing a Dump on MariaDB (Ubuntu 20.04.4 LTS)

I am writing this post because I cannot import a dump on MariaDB (Version 15.1) using Ubuntu 20.04.4 LTS. I did this dump a few weeks ago and now trying to import it using the command mysql -u root -p ...
1 vote
1 answer
823 views

MySQL takes huge memory by ignoring buffer pool size

I am facing a very strange problem, looks like on mysql startup, mysql is taking so much memory than 4x of buffer pool size. I am using Ubuntu VM (4 Core 8 GB) with MySQL 5.6.33. /etc/mysql/my.cnf is ...
1 vote
1 answer
299 views

Intermittent SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'server.here' (110)

I'm suddenly having intermittent 2003 connection errors and I can't find anything that has changed that can explain it. These servers have been running smoothly for years and suddenly two days ago ...
1 vote
1 answer
301 views

Allow connection to mongo only from my server droplet

Recently I created a server with MongoDB preinstalled on a DigitalOcean droplet following these tutorials DigitalOcean - Initial server setup DigitalOcean - How to secure MongoDB on Ubuntu Medium - ...
1 vote
2 answers
759 views

Assigning multiple IP addresses to MongoDB 7.0 on Ubuntu

The Problem I am trying but failing, in MongoDB 7.0, on Ubuntu, to bind multiple IP addresses to net.bindIp in mongod.conf What I have tried I have tried 127.0.0.1,x.x.x.x, 127.0.0.1;x.x.x.x, [127.0.0....
0 votes
3 answers
5k views

MySQL using all RAM

I am trying to restore SQL dump file of around 750 MB on Ubuntu 16.04 VM with 1GB RAM and MySQL 5.7.21. I have configured innodb_buffer_pool_size = 768MB, innodb_buffer_pool_chunk_size = 128M and ...
0 votes
0 answers
18 views

Why does removing `skip-grant-tables` cause resource conflict error for mysqld?

After hours of searching, I have managed to narrow a mysqld issue down to a point, which I cannot find reason for. I am attempting to launch multiple instances of mysqld on my Ubuntu server. When ...
0 votes
1 answer
33 views

Mongod starting issue on ubuntu

When I try to check the status of mongodb I get the following: × mongod.service - MongoDB Database Server Loaded: loaded (/lib/systemd/system/mongod.service; enabled; vendor preset: enabled) ...
user avatar
2 votes
1 answer
666 views

Unable to use SSL Certificates in SQL Server on Linux

Hello everyone so here is the problem: SQL Server 2019 installed on Ubuntu 20.04 (working before setting SSL certificates) I was following the Official guide of Microsoft to secure my SQL server with ...
0 votes
3 answers
1k views

How can I purge MySQL binlogs if MySQL is turned off

I am using Digital Ocean droplets for my WordPress Site. There are more than 60 binlog files in /var/lib/mysql. Most of the solutions say that I should purge them from MySQL. The storage is so full ...
0 votes
0 answers
22 views

How do I convert master-slave to multimaster database replication in MySQL?

Currently, I have one master and two slaves in my setup. How can I convert it so that I have three masters instead? I need all three nodes to be writable and to update each other accordingly. Most of ...
0 votes
1 answer
637 views

Error after changing/moving mysql datadir in ubuntu sys

I followed the answer in the Q&A Moving the MySQL data directory Ubuntu 16.04. However, it's not working and gives me the following error: mysql.service - MySQL Community Server Loaded: ...
0 votes
2 answers
6k views

How to set password for PostgreSQL 14.5 on Ubuntu 22.04.1 LTS?

I follow a tutorial at https://www.digitalocean.com/community/tutorials/how-to-install-postgresql-on-ubuntu-22-04-quickstart . I buy a Virtual Private Server (VPC) what use Ubuntu 22.04 LTS , 4 GB RAM,...
1 vote
1 answer
5k views

MariaDB 10.3.9 can not start

I updated my MariaDB and I can't start it now. I try: sudo service mysql start Result: Job for mariadb.service failed because a timeout was exceeded. See "systemctl status mariadb.service"...
0 votes
2 answers
9k views

Getting current number of connections in mysql

I want to know if there is any parameter to show the current number of mysql connections (or peak value in the past 10 minutes or something else). Right now, I only see max and max_used connections. ...
0 votes
3 answers
171 views

Mariadb threads blocking randomly

We have a mariadb instance hosted on Ubuntu 22.04. We are regularly seeing some threads getting stalled on relatively high activity tables(although the tables are not huge ones). Once stuck, it never ...
0 votes
1 answer
755 views

MySQL keeps crashing - Error establishing a database connection

I had installed wordpress on ubuntu 20.04 on 2GB/2CPU and I have a problem with my MySQL server that keeps crashing. Everyday we are getting below error : error establishing a database connection and ...
0 votes
1 answer
157 views

Upgrade Pgbouncer

I need some advice for upgrading pgbouncer. I couldn't find any document which tells me how to upgrade pgbouncer. I tried the command apt install pgbouncer I wonder if there is another good, ...
1 vote
1 answer
822 views

How to re-sync the Mysql replication if Master down

I have a very simple webapp infra: FE => BE => MySQL. I have set up MySQL master-slave replication successfully. If my MySQL master node is down, I can manually point the MySQL IP to the Slave ...
4 votes
2 answers
941 views

MSSQL Ubuntu Unexpected call to legacy ABI

We recently had a Ubuntu 16.04 server loose power. After restarting the server I noticed that MSSQL Server was no longer running due to a an error Unexpected call to legacy ABI. After researching for ...
2 votes
1 answer
2k views

error connecting to master '[email protected]:3306' mac-ubuntu

Server info: Master server (Vmware): Ubuntu 18.04 IP: 192.168.57.10 Slave server1 (Vmware): Ubuntu 18.04 IP: 192.168.57.11 Slave server2 (mac): macOS High Sierra IP: 192.168.0.3 MySQL Server ...
3 votes
1 answer
2k views

mongodb keyfile permission denied

I configured in /etc/mongod.conf to enforce keyfile access control, in security option enabled, keyFile is /root/dbtest.key (the absolute path of keyfile). I already gave the ownership to mongodb user ...
0 votes
1 answer
2k views

mongoDB won't stop with shutdown or kill

Not sure If I can make the same question already made here but here it goes. I have a mongodb fork and running with high CPU usage. I'm trying to shut it down but nothing seems to work. 2729 mwon ...
0 votes
1 answer
343 views

MongoDB Server on Ubuntu Crashes again and again

The mongodb server on my ubuntu Virtual Private Server Crashes on regular basis. mongod.service - MongoDB Database Server Loaded: loaded (/lib/systemd/system/mongod.service; enabled; vendor ...
0 votes
1 answer
3k views

Import issue: Missing columns values from CSV file

I have a problem with the importing of a CSV file to my table in MySQL. The values (3) of the columns (var1, var2, dates) are not loading, as shown in the image below: First I created the table, ...
11 votes
8 answers
161k views

Oracle startup error (could not open parameter file)

I installed the Oracle 11g server on Ubuntu 12.10. But I can't start the server. When I start up the server, the following error occurs: SQL> startup ORA-01078: failure in processing system ...
1 vote
1 answer
1k views

MySQL Galera cluster can't initiate first node

I'm using Ubuntu 16.04 and installed MySQL version 5.7 via apt-get in AWS. After that, I've managed to upgrade the MySQL to Galera Cluster by following the Documentation from the official website ...
0 votes
1 answer
514 views

I can't connect MySQL (on Ubuntu 22.04 Host) connect to remote server (Ubuntu 22.04 on VMWare Guest)

I want to create new MySQL connection to remote Django server that is inside virtual machine on VMWare (located at address 127.0.0.1 on port 33061). The problem is that MySQL shows the message "...
1 vote
1 answer
767 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'...
1 vote
2 answers
5k views

Mysql upgrade 5.7.22 to 8.0, server not starting after upgrade

I followed the upgrade guide Upgrading MySQL. Already installed version of mysql is 5.7.22 Verified all Upgrade Prerequisites for MySQL 5.7 Installation SET GLOBAL innodb_fast_shutdown = 1; then ...
2 votes
1 answer
5k views

MySQL 8 Replication

I've got this error message: Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction 'ANONYMOUS' at master log mysql-bin....
0 votes
1 answer
164 views

Can't link building C++ application with pqxx library

I had to re-install my operating system and I switched from Ubuntu 22.04 to Linux Mint 21.2. I installed PostgreSQL 16 from the postgres repository. It seems to work fine. Then I downloaded libpqxx 7....
0 votes
1 answer
2k views

MySQL Group Replication stuck on RECOVERING

I'm testing MySQL Group Replication. Environment: Microsoft Azure Ubuntu 16.0.4 I've followed this guide: https://www.digitalocean.com/community/tutorials/how-to-configure-mysql-group-replication-on-...
2 votes
3 answers
1k views

Maximum possible memory usage: 3.2G (163.34% of installed RAM)

I get frequent database crashes... explainable since mysqltuner tells me mysql has an appetite for memory. Since I'm not a database expert I hope you can point me in the right direction where to look ...
0 votes
0 answers
149 views

Moving MysQL data directory error: Can't create test file mysqld_tmp_file_case_insensitive_test.lower-test

I'm trying to move mysql datadir to another location on external drive which is formatted with ext4. I'm betting following error: # lsblk -f .. sdb ...
1 vote
0 answers
30 views

Failed to start MySQL Community Server on Ubuntu 20

I'm currently facing an issue with starting MySQL on my Ubuntu system. Upon attempting to restart the MySQL service, an error message stating 'Failed to start MySQL Community Server' appeared. As part ...
user avatar
1 vote
1 answer
97 views

How should I troubleshoot a very slow MySQL server droplet?

I'm new to the DBA forum, but not SO, and I've searched for answers on this, and tried what I've found. We have a Rails app that lives on a Digital Ocean droplet, and a bigger and more powerful ...

1
2 3 4 5
13