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.
414
questions
0
votes
0answers
23 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
1answer
14 views
how to make error log visible in ubuntu
despite starting mysql
sudo service mysqld start
How to give permission to var/lib/mysql
0
votes
0answers
16 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
14 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
20 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
0answers
5 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
23 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
31 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
25 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
71 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
20 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
39 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 ...
2
votes
1answer
365 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
20 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
104 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
39 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
39 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
84 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
18 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
32 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
21 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
79 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
24 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
30 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
97 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
106 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
141 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
313 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
309 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
14 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
68 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
44 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 ...
1
vote
0answers
30 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
16 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
149 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
205 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
55 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/...
0
votes
1answer
269 views
How to set up signed SSL Root and Leaf certificates on a PostgreSQL 11 database on Ubuntu and Windows 10 Power BI plus PostgreSQL?
I have Power BI and PostgreSQL 11 installed on Windows 10 and my primary PostgreSQL 11 database on Ubuntu 18.10 Linux. I edited the postgresql.conf and pg_hba.conf files correctly to the IP Adresses ...
0
votes
1answer
21 views
What are each of the separate mongodb-org packages for ubuntu?
I am installing mongodb on a local ubuntu vm and I'm using the official Mongo supported packages per the official instructions. However, I don't know what each of these packages contain. I know this ...
1
vote
3answers
343 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
2answers
187 views
How to change the expiration date of binlog files?
I have a server with Ubuntu 18.04 and MySQL 8.0.11
I have binlog files in /var/lib/mysql that make several GO and my server will soon saturate.
How to change the expiration date of binlog files ?
...
0
votes
1answer
96 views
My disk is full of binlog files
I just realized that my server is growing by 2 GB per day, which is not normal.
I looked at my folder and the folder / var / lib / mysql reached 26 GB
Normally it should be about 4 GB
A month ago I ...
0
votes
1answer
26 views
Mariadb times out on startup after system reboot
This is continued from:
https://stackoverflow.com/q/55071021/8644833
Mariadb shuts down after running for a minute or two. If I remove Mariadb and reinstall (keeping my databases), everything works ...
0
votes
0answers
73 views
MariaDB Galera journalctl
I've noticed something weird.
I have 3 nodes galera cluster, installed using mariadb.
I'm pretty sure that I did all three nodes installations exactly the same.
All three nodes display their --...
1
vote
2answers
333 views
Mysql could not be started because unknown variable 'log-syslog=1'
Platform System： WSL（ubuntu 18.04）.
when installed mysql-server 8.0 sucess， i try to start mysql. But it's fail to start.Then checked the error.log.
2019-02-26T03:13:51.609895Z 0 [ERROR] [MY-000067] ...
1
vote
1answer
307 views
max_stack_depth not changed even stack changed in limits.conf
The attempt of making changes to max_stack_depth using select set_config('max_stack_depth', '512MB', false); because of the error shown in postgresql log:
DETAIL: "max_stack_depth" must not exceed ...
1
vote
1answer
984 views
Oracle-xe on Ubuntu 18.04 - Installation and impdp
Setup:
10 GB partition ext3 mounted at /u01
5 GB swap
Oracle-xe oracle-xe-11.2.0-1.0.x86_64.rpm - installed with alien and then dpkg
Followed instructions from https://community.oracle.com/thread/...
2
votes
1answer
2k views
Error Code: 1728. Cannot load from mysql.db. The table is probably corrupted
Whenever I try to do a DB query with a particular DB user (myuser) I get the following error:
Access denied for user 'myuser'@'localhost' to database 'mydatabase' [1044]
I decided to check the ...
2
votes
1answer
791 views
This installation of MySQL is already upgraded to 5.7.25?
I used sudo apt upgrade and got this:
E: dpkg was interrupted, you must manually run 'sudo dpkg --configure -a' to correct the problem.
So I did it and I see this for more than an hour.
Setting up ...
