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.

165 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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 ...
DessDess's user avatar
  • 101
4 votes
2 answers
863 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 ...
DDiamond's user avatar
  • 143
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 ...
frankr6591's user avatar
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 ...
necroface's user avatar
  • 139
3 votes
0 answers
6k views

Postgres 9.6.10 pg_hba.conf altered

We have an Ubuntu dedicated server. A couple of weeks ago we started to notice that when the postgresql service restarts, the directory /var/lib/postgresql turns readonly. We changed the permissions ...
Cesar Barron's user avatar
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 --------...
user133385's user avatar
3 votes
0 answers
890 views

Recovering data from postgresql xlog

I lost a lot of data in my postgresql database and do not have a dump file to restore backup from, but I heard that in /var/lib/postgresql/9.4/main there are pg_xlog and pg_clog and that those ...
HellOfACode's user avatar
2 votes
1 answer
133 views

MySQL suddenly blocks access from particular IP

I'm using MySQL 5.7.40 on Ubuntu 18.04.6 LTS (GNU/Linux 4.15.0 x86_64) I didn't make any changes since weeks. My websites are on another server. So it's a remote connection. Since some hours ago my ...
David's user avatar
  • 121
2 votes
0 answers
1k views

Unable to locate package postgresql-server-dev-15 while installing PostgreSQL 15 using pdpg?

I am trying to upgrade PostgreSQL to version 15 but some packages from 14 seems to be missing. There was postgresql-server-dev-14 in PostgreSQL 14. Trying to upgrade, I tried: sudo apt install ...
tinlyx's user avatar
  • 3,500
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....
user avatar
2 votes
0 answers
1k views

Postgresql pg_logical sequence replication not synchronized

I'm testing pg_logical extension for Postgresql because we need to replicate some clusters with Postgresql 9.6 before upgrading them to newer version, where logical replication is a core feature. I've ...
EAmez's user avatar
  • 145
2 votes
0 answers
917 views

Trying to restore InnoDB tables

I've reinstalled MySQL but when I copy the data dir from the old instance: maicol07@maicol07$ sudo mysqld --user=root 2020-07-14T13:07:34.031447Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (...
maicol07's user avatar
  • 121
2 votes
0 answers
704 views

Backing up Time Series Database (PostgreSQL/TimescaleDB) where old data will never be updated

If a PostgreSQL (using TimescaleDB extension) database that holds time series data is continuously growing in size, what is the recommended backup strategy if we do not want to continuously create ...
Nyxynyx's user avatar
  • 1,121
2 votes
0 answers
4k views

MySQL Service won't start with error [ERROR] InnoDB: Trying to access page number 4294963199 in space 0

My MySQL installation on Ubuntu 18.04 crashed and now won't start. The error log says Trying to access page number 4294963199 in space 0, space name innodb_system, which is outside the ...
SE1986's user avatar
  • 1,960
2 votes
0 answers
2k views

How to install PLV8 in PostgreSQL 11 in Ubuntu 16?

I am trying to install PLV8 extension (JavaScript Procedural Language for PostgreSQL) in my PostgreSQL 11 Ubuntu Server 16 and having a hard time. The PostgreSQL 11 was installed using PostgreSQL's ...
Tiago Stapenhorst's user avatar
2 votes
0 answers
335 views

Asynchronous availability groups not synchronizing on SQL Server on Ubuntu

I installed SQL Server 2017 on Ubuntu and setup an availability group with cluster type = "None". I set the "Availability" Mode to "Synchronous commit" and tested it. It works fine. All transactions ...
Dominique Boucher's user avatar
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 ...
bebobalula's user avatar
2 votes
0 answers
3k views

MySql Workbench Couldn't find section mysqld in the remote config file /etc/mysql/my.cnf

if you get this trying to connect to your remote server using MySql Workbench, then try to (on your remote server) navigate to /etc/mysql/my.cnf and add [mysqld] then it should look like: !...
Nils Riga's user avatar
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 ...
vishnu's user avatar
  • 41
2 votes
0 answers
799 views

Unable to start PostgreSQL Ubuntu 16.04

I use Lubuntu 16.04 64 bit and I tried to install PostgreSQL using the Ubuntu software service. I'm unable to run the server. Many found the same problem and solved their issues. I tried to follow ...
ilFonta's user avatar
  • 131
2 votes
0 answers
723 views

Server Doesn't Listen Error when connecting to PostgreSQL from Client

I have done a lot of research through the Google and have not been able to come up with a solution. I installed PostgreSQL 9.5 and PostGIS 2.1.8 On Ubunutu Server 14.04 and configured PostgreSQL as ...
LandArch's user avatar
2 votes
0 answers
300 views

how to convert mongodb(2.4.10) startup2 to primary

I have standalone bitnami mongodb(2.4.10). The output of rs.status() command is below : rs.status() { "set" : "test", "date" : ISODate("2015-11-13T08:07:41Z"), "myState" : 5, "members"...
singh's user avatar
  • 21
1 vote
0 answers
22 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
52 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 ...
nimmolo's user avatar
  • 111
1 vote
0 answers
45 views

PostgreSQL isn't using all available vCPUs of the VM

Running some procedures takes too much time and if I check htop I can see just one vCPU of the Ubuntu VM that is running and the others aren't: postgresql.conf max_connections = 50 shared_buffers = ...
Saad elMoustarhfir's user avatar
1 vote
0 answers
41 views

How would I connect to a SQL Server (running in a VM using Ubuntu Server), using Access or Visual Studio on my host?

I have tried to connect various ways already and have not been successful. I need a more specific guide on how to/if you can connect this way. I have specific limitations that you need to account for, ...
Vividlee's user avatar
1 vote
0 answers
65 views

Odoo 16 restoring 350 MB database Ubuntu Nginx

What I am trying: I am trying to restore Odoo 16 enterprise database with size 350MBs and I am using Digitaloceans and Nginx as a proxy. Error I am getting: Error Code: 413 Request Entity Too Large ...
Tele oceans's user avatar
1 vote
1 answer
265 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 - ...
Fernando's user avatar
1 vote
0 answers
798 views

Getting error as "ERROR: permission denied for schema public" while executing a sql script in Postgres sql

I am using ubuntu 18.04 and running postgres sql in a docker container running on port 5432 on a VM powered by GCP. First of all I entered sudo -u postgres psql to enter into the database as ...
Talib's user avatar
  • 11
1 vote
0 answers
6k views

How to install postgis on Postgres 15?

i do not find a postgis package for postgres 15 on ubuntu. There are tons of blog posts out there showing all the same line: sudo apt install postgis postgresql-x-postgis-3 x stand for the postgresql ...
Richard's user avatar
  • 11
1 vote
0 answers
253 views

Which MariaDB-Galera Node Should I Start After Cluster Crushing or Failing?

Sometimes my 3-Node GaleraCluster fails and doesn't serve. When I check I see all of them are activated but two of them are not working, so I check log files I see one of them could not operate an ...
prenses_mahmut's user avatar
1 vote
1 answer
773 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 ...
ITnewbie's user avatar
  • 111
1 vote
0 answers
216 views

SELECT INTO OUTFILE giving OS errno 13

We recently migrated from MySQL5.6.51 to MySQL8.0.28 (Ubuntu 20.04.3 LTS) and we have started noticing some differences. One of the problems has been recreated using a sample database, with a table ...
Sandeep's user avatar
  • 255
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 ...
TurboProgram's user avatar
1 vote
0 answers
1k views

Is it possible to update Mac mysqldump version to same version as what's available for Ubuntu?

I run the following command on Mac Big Sur mysqldump --column-statistics=0 -v -h my host -u myuser -P 3306 -pmypass mydb my_table > /tmp/dump.sql Which uses the following version of mysqldump … $ ...
Dave's user avatar
  • 663
1 vote
0 answers
224 views

Why do some SQL Server databases go into a "Recovery Pending" state after shutting down / restarting on Linux?

I built a secondary PC from old parts as a server for SQL Server databases and I went with Linux/Ubuntu 20.04 because it's free. I knew it would not be easy to set this up (I'm rather a Windows user) ...
Ha'gel's user avatar
  • 19
1 vote
1 answer
286 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 ...
aecend's user avatar
  • 111
1 vote
0 answers
598 views

Postgres stops about every 2-3 weeks. Says it was shutdown by an admin but I'm the only admin

Postgresql 12.8 on Ubuntu 20.04.1 This system is running a single java application that talks to the database. Only one user can log into the system (expedite) and only that user runs anything. No ...
Bruce's user avatar
  • 11
1 vote
0 answers
566 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 ...
ollie10's user avatar
  • 111
1 vote
0 answers
401 views

WSL2 Docker Oracle volume mapping: how to switch from Windows to Linux file system

I am running Oracle (V19, V18, and V12) instances under WSL2 (Windows 10 version 2004). For persistence, my Oracle data files are mapped to a folder on my Windows host. I can run the containers from ...
MonteChristo's user avatar
1 vote
0 answers
186 views

Xtrabackup 8.0 Error

I'm using Percona MySQL 8.0.20 running on Ubuntu 18.04 on an AWS ec2 m5.2xlarge instance. The Xtrabackup version being used is 8.0.14. While testing the restore process, I'm getting the error as ...
Deb's user avatar
  • 115
1 vote
1 answer
775 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 ...
Amogh's user avatar
  • 111
1 vote
1 answer
178 views

mysql data node not connecting to node manager on AWS EC2

I am trying to setup mySql manager + data node + sql server (Server A) and another data node cluster on (Server B). Both running on Ubuntu 16.04 amd_64 Server A /etc/hosts also on Server B Both ...
mohamed tebry's user avatar
1 vote
0 answers
2k views

PostgreSQL is missing after reboot

I am running Atlassian Jira software and using Postgresql as its database server. We have a power interruption which turned off the host server and therefore the vm's didn't shut down correctly. ...
sundance_actual's user avatar
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 ...
Ekkai Imwe's user avatar
1 vote
0 answers
69 views

virtual MySql server with mounted RAID array

I have a Ubuntu 16.04 server with an 18TB RAID array. I am running virtual servers on the server using Wok/Kimchi and am wondering if it is reasonable to run a MySQL virtual server and set the data ...
cuxcrider's user avatar
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"...
user avatar
1 vote
0 answers
477 views

MongoDB Warning impossible to clear

I'm using Ubuntu 16.04 and MongoDB 4.0.1. When I use mongo shell I got this : I STORAGE [initandlisten] I STORAGE [initandlisten] ** WARNING: Using the XFS filesystem is strongly recommended with ...
John's user avatar
  • 111
1 vote
0 answers
462 views

Can't add new node to Galera Cluster

I have a 5 node Galera 3 Cluster running MySQL 5.6 on Ubuntu 16.04 (I tried running 5.7 but ran into the AppArmor issue). I'm trying to add another node to the cluster but it continually fails. The ...
Adam Evers's user avatar
1 vote
0 answers
500 views

DPKG error: uninstall percona xtradb server 5.7

Trying to uninstall percona, as I broke installation. No luck: >$ sudo apt remove percona-xtradb-cluster-server-5.7 Reading package lists... Done Building dependency tree Reading state ...
Vedran Mile Tomljanovic's user avatar