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.
425
questions
0
votes
0answers
3 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 ...
0
votes
0answers
13 views
Incompatibility between unixODBC and Firebird ODBC driver
I'm currently developing a application based in Rcode, ODBC and Firebird.
For that, first I've installed firebird server and unixODBC (both 64 bits since my machine OS is 64-bits). I tried with 32-...
1
vote
2answers
44 views
Determining Whether Query Load is Too High for PostgreSQL Server
I just started experiencing some write-heavy load on a PostgreSQL 11.2 system running inside a Docker container on an Ubuntu 18.04 server. PostgreSQL is receiving about 1-4k INSERT queries/second.
...
0
votes
1answer
35 views
Unable to Join phpMyAdmin Using MySQL Defined User
I can login to mysql via the command line just fine, but when I try to log on to phpMyAdmin with the same password that worked in the cli, it won't allow me to connect and gives me: ...
0
votes
1answer
24 views
Everything is ok and x is not disappearing
Since some time ago, I've started with MySQL so I don't know Workbench very well.
That little red x next to the number of the line that indicates an error does not disappear, even though everything ...
0
votes
0answers
25 views
MySQL cpu won't go down after query; need restart
I have a query triggered towards a MySQL server. Every time I run such a query, the cpu goes up until the query ends. After that, cpu usage goes down, but not to normal value: a little cpu is still ...
0
votes
0answers
26 views
failure to create tablespace on external drive mysql 8 ubuntu 18.04
I am pretty new to how to configure MySQL and I have bug I can't figure out. I installed MySQL 8 and I am trying to create a table in a different data directory following the instructions provided in ...
0
votes
1answer
77 views
Linux sqlcmd connecting to Windows Sql Server using kerberos
I'm pretty sure I am going to have to expand upon this a bit as I am new, and my question is probably not clear.
I have an Active Directory environment that includes a Microsoft SQL Server running ...
0
votes
1answer
147 views
MySQL [Bad handshake] error after update
I have MASTER-SLAVE configuration on 2 servers. The MySQL replication is set over SSL (I use self-signed certificates).
Everything had been working well. But today some packages (mysql also) were ...
1
vote
2answers
33 views
How to create a csv with SQLCMD which can be imported into another database system
I may be doing this all the wrong way so please point me in the right direction if I am missing something.
I have an Ubuntu server with SQLCMD installed and a Windows Server with a MSSQL database.
I ...
3
votes
1answer
110 views
Missing master.dacpac publishing dacpac Azure Devops
The problem
I have been trying to get a build pipeline to work in Azure DevOps to demo how we could build and test our databases.
I've come to the point where I want to publish my DACPAC but it ...
9
votes
1answer
396 views
CPU Usage Incorrect in sys.dm_os_ring_buffers
I'm running a cloud VPS with a SQL Server instance. Because it's for personal use, I'm using express edition (I can't use developer edition because I technically have production apps running on it and ...
0
votes
0answers
30 views
MySQL 8.0.17 memory usage increases until it crashes
I have a database with 1.3m records, my VPS has 4GM memory and 4GB swap, MySQL memory usage keeps on increasing until it goes OOM and gets killed. here are my my.cnf:
innodb_buffer_pool_size = 1500M
...
0
votes
0answers
76 views
Unable to connect to SQL server instance ubuntu 18.04 via SSMS which worked peviously
I am running SQL server on ubuntu 18.04 which I was able to connect to successfully via SSMS. But I am not able to connect anymore.
My first instinct was to check if the SQL server was running by ...
0
votes
0answers
18 views
MySQL hidden files on ubuntu taking up space
I have a weird issue where my system (ubuntu 19) is showing that MySql 8 is using up 600gb of space, when it should be closer to 250gb.
I ran ubuntu's baobab utility in sudo mode, and it as well, is ...
1
vote
0answers
21 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 ...
0
votes
1answer
56 views
Unable to start mysql on ubuntu
I have an issue with re-starting my MySQL 8 service on Ubuntu 19 after a force shutdown in normal mode.
Originally I was able to re-start the service in the save mode (had to do
...
-1
votes
1answer
9 views
Impact of changing swappiness
On one of my aws ec2 m4.10xlarge instance running Ubuntu 16.04 LTS with 160 GB memory, I want to change the swappiness from the default 60 to 10. Does changing this at runtime using
sysctl -w vm....
0
votes
1answer
82 views
MS SQL Server Error: Replication components are not installed on this server on Ubuntu
We have a Windows 10 SQL Server 2014 Standard License I'm using on our local computer. Trying to replicate a database to an Ubuntu Server 18.x with SQL Server 2018 (installed using this easy guide).
...
0
votes
2answers
37 views
Ubuntu, postgresql, show whole running sql command
System
Linux vm16745 3.13.0-77-generic #121-Ubuntu SMP Wed Jan 20 10:50:42 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux
psql (PostgreSQL) 9.3.24
Issue
I don't know if it is right section/forum, but I ...
0
votes
0answers
53 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.
...
0
votes
2answers
324 views
MySQL DBs taking up way too much disk space
I'm on Ubuntu Server 18.04 running MySQL server 5.7.27 with InnoDB. I confirmed that InnoDB file-per-table is On.
I have a mysqldump containing all of my DBs that takes up about 1.3 GB disk space.
...
0
votes
0answers
57 views
FATAL: pg_hba.conf rejects connection for host … SSL OFF
Before this issue happen, it work perfectly fine for months.
I am had try the configuration below at DO droplet:
1) Change pg_hba.conf
host all all 0.0.0.0/0 trust
2) I issue the restart commond
...
0
votes
0answers
181 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 ...
4
votes
1answer
1k views
SQL Server on Ubuntu - An existing connection was forcibly closed by the remote host after reboot
I have been running SQL Server on Ubuntu for a while and everything has been working fine but I rebooted the server and now all connections to SQL Server fail with the error:
A connection was ...
0
votes
0answers
39 views
mssql + sssd Ubuntu cannot login via AD group
I've got mssql 14.0.3192.2-2 setup unter Ubuntu; I have joined my machine to AD as described here.
The Windows login via SSMS and sqlcmd works if I add invididual AD users, but not if I add groups.
...
0
votes
0answers
284 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 ...
1
vote
1answer
75 views
How can I generate fake data that adheres to the PRIMARY KEY-FOREIGN KEY constraints of my schema?
I have a schema for which I would like to generate fake data. I can generate fake data using Python for each of the tables separately, but I don't know how to make sure the fake data generation ...
0
votes
1answer
69 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
2answers
213 views
Error when creating database using DBCA
I'm using Oracle Database 12c R2 on my Elementary OS 5.0. The install is complete without any error. Then I create listener and it started just fine.
When I create database using dbca it shows ...
0
votes
0answers
19 views
LibreOffice Base Brings in all visible databases as list of tables
I'm trying to connect to a singer database through LibreOffice Base. The connection goes fine and successful. However, when selecting tables, it's showing a list of all the visible Databases in the ...
1
vote
2answers
36 views
MariaDB writes at 500kb/s how to get it to write at normal speeds?
My ubuntu 18.04 has mariadb. I've tried mariadb 10.1, 10.2 and 10.3 all with the same symptons
When I time the harddrive, it has reasonable speeds
$ sudo hdparm -Tt /dev/sda
/dev/sda:
...
0
votes
0answers
67 views
How to switch MBR to GPT without losing any existed data originally in MBR, AWS Ubuntu EC2
I'm trying to extend my diskspace for my AWS EC2 Ubuntu instance, the partition I've started with is MBR and the maximum it can go is 2TB.
Currently the diskspace is full with important data, I need ...
0
votes
1answer
19 views
What ports should I leave open for MySQL - Ubuntu server [closed]
I'm building a database server that I want to run on a VPS. I'm planning on using IPTables to block unnecessarily opened ports. What are the ports I should be blocking if I only want to access to my ...
0
votes
1answer
139 views
Unable to restore a PostgreSQL database from a .backup file
I am using Ubuntu 18.04 and PostgreSQL. For the GUI, i am using pgadmin4 (browser version). I created a new database and when trying to restore, the following error message comes up:
<!DOCTYPE ...
0
votes
0answers
29 views
Mysql memory_global_total is smaller than memory usage in top [duplicate]
When I try top in my ubuntu the result
top - 16:03:09 up 16 days, 21:24, 2 users, load average: 3.53, 2.72, 3.46
Tasks: 395 total, 1 running, 282 sleeping, 0 stopped, 0 zombie
%Cpu(s): 10.0 ...
0
votes
1answer
31 views
100+ DBs in one instance or divide and conquer : MariaDb Ubuntu 64bits
I have a desktop app (100+ customers and more to come) running at customer's small local server, all of them have same structure in tables (different info). I'm migrating that app to web ( almost ...
1
vote
1answer
247 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 ...
0
votes
1answer
231 views
Failed to install Oracle JDeveloper 12c
I want to install Oracle JDeveloper on my Ubuntu 18.04, and I have downloaded the installer file from here, there I download the file1 and file2 to Linux.
Here is the file name for file1, and the ...
2
votes
2answers
149 views
how to improve this query performance
I have an application that's running this following query
SELECT SQL_NO_CACHE p.*,
product_shop.*,
stock.out_of_stock,
IFNULL(stock....
2
votes
1answer
609 views
Error: FATAL: no pg_hba.conf entry for host - PostgreSQL - pg_hba.conf is empty
I upgraded the PostgreSQL database from version 10 to 11. As I tried to access the database from a client pgadmin4 console, I got the below error:
I checked the two file postgresql.conf and pg_hba....
0
votes
0answers
524 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 ...
0
votes
0answers
15 views
Missing directory after MySQL 8.0 for Ubuntu installation
After installing MySQL Community Server 8.0.16-2 on Ubuntu 19.04 I have the directory /var/run/mysqld missing and the server refusing to start.
What's wrong?
0
votes
0answers
140 views
mysql 8 innodb clustering - adding instance fails with error “Unknown database 'mysql_innodb_cluster_metadata'”
I'm setting up my first mysql innodb cluster, following the instructions here:
https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-production-deployment.html
I've configured the instances ...
0
votes
1answer
98 views
System-wide startup file for Postgres 10 on Ubuntu 18.04
When I log into postgres under my personal shell account, my .psqlrc file runs a series of meta commands to set up what is for me an optimum working environment. I'd like to set that same environment ...
2
votes
0answers
41 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 ...
0
votes
1answer
17 views
MySQL Not Recovered After Running Out of Space
I've got a MySQL 5.7.26 running on Ubuntu 16.04. I'm running an app that's loading a few GB data into the database, which was running fine until I let the root volume (with MySQL on) run out of space -...
2
votes
3answers
167 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
0answers
374 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:
!...
0
votes
2answers
62 views
Error 5123 when creating a database with my SQL Server on Linux
I followed the steps of this MS Guide and I managed to run a localdb and create a Testdb with this script:
CREATE DATABASE Test
ON
(NAME='Test_DAT',
FILENAME='/home/dlag/Documentos/Proyectos/...
