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.
0
votes
0answers
4 views
Need some help, mysql won't start and I have no idea how to recover
I had a scheduled cron job that would delete 6 million records. At some point during that cron job the server went down. Now mysql won't restart. I get this error in the log file /var/log/mysql/error....
0
votes
1answer
27 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....
1
vote
1answer
34 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
76 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
12 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
21 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
18 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
21 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
13 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
2answers
114 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
45 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
51 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
62 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
20 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
130 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
81 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
44 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
20 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
39 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 --...
0
votes
2answers
126 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
132 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
316 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/...
1
vote
1answer
459 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
466 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 ...
3
votes
1answer
85 views
When I run mssql-cli, I get “No module named mssqlcli”
I just installed mssql-cli with pip,
pip3 install mssql-cli
Then I try to run mssql-cli and I get
$ mssql-cli
/usr/bin/python: No module named mssqlcli
1
vote
0answers
54 views
Impdp (Oracle 12c) on Ubuntu 16.04
I am trying to import a dump into Oracle 12c by using the below command:
impdp SROUSER/<password> directory=dump_dir dumpfile=SROUSER.dmp logfile=dp.log full=yes
Which is resulting in the ...
-2
votes
1answer
54 views
PostgreSQL won't start [closed]
I installed Postgresql on Ubuntu 18.10 (on a VPN) and was unable to connect to it. At this point I did:
ps -f -u postgres
and got the shocking result of.... absolutely nothing. I ran htop to double ...
0
votes
0answers
64 views
Can not move MySQL data folderto external storage
OS Ubuntu 18.04, laptop, ssd partitioned for two OS (win8 and linux), second drive mounted with permissions. Line from fstab:
UUID={UUID} /media/iam/storage ntfs-3g permissions 0 1
I created dir db/ ...
1
vote
0answers
15 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 ...
0
votes
0answers
16 views
mysql cluster with 1 master 1 node and 2 slave
My Query is I want to set up MySQL cluster with 1 Master 1 Node and 2 Slave with Auto failover. If my master is down node should assign slave as a master.
Can anyone suggest me an idea to do that? As ...
1
vote
1answer
44 views
Error while restoring the table dump
ERROR 1067 (42000) at line 25: Invalid default value for 'created_on'
I'm getting this error while restoring a table after taking the dump(remotely). I have used
mysqldump -h (hostname) -u -p (...
1
vote
1answer
423 views
Error while installing Oracle 11g in Ubuntu 18.04
Also getting a runfixup.sh script which is also giving error
root@szh-server:/tmp/CVU_11.2.0.1.0_zuman# ./runfixup.sh
Response file being used is :./fixup.response
Enable file being used is :./fixup....
2
votes
1answer
233 views
SQL Server 2019 CTP 2.1 on Ubuntu fails after powering off
I've installed Microsoft SQL Server 2019 (CTP2.1) - 15.0.1100.94 (X64) on my VirtualBox Ubuntu 16.04.5 LTS. Everything seemed to work properly until I've powered off the machine. Since then SQL Server ...
0
votes
1answer
520 views
Installation of PostgreSQL-11: Depends: libllvm6.0 (>= 1:6.0~svn298832-1~) but it is not installable
I've added the official repository to my sources.list,
deb http://apt.postgresql.org/pub/repos/apt/ cosmic-pgdg main 11
When I try to install PostgreSQL-11 on Ubuntu Cosmic (18.10), I get the ...
1
vote
1answer
56 views
Should I stop my PostgreSQL server before reboot?
Every week I do an apt-get upgrade and dist-upgrade on the server where my PostgreSQL is running. After that, I do a sudo reboot now.
Should I stop the PostgreSQL service before this reboot?
0
votes
1answer
25 views
VIM returns “Error detected while processing” and “Sorry, the command is not available in this version”
When I run VIM with \e inside of psql, I get
Error detected while processing /home/ecarroll/.vimrc:
line 11:
E319: Sorry, the command is not available in this version: call plug#begin('~/.vim/...
1
vote
1answer
1k views
Mysql (MariaDB 10.3.9) can not start
I updated my mysql 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" and "...
2
votes
1answer
3k views
Failed to start MySQL Community Server
A lot of stuff stopped working on my server because the sda3 partition became full. After fixing that issue, I cannot start the mysql service:
root@abcd:~# sudo service mysql start
Job for mysql....
0
votes
1answer
1k views
MariaDB startup failure on Ubuntu 18.04
I have installed MariaDb hundreds of times on previous Ubuntu versions, but on Ubuntu 18.04 I'm struggling. After the installation finishes, once I restart the PC, MariaDB starts for around 2 minutes ...
1
vote
1answer
270 views
I can not get Postgres to listen on anything but localhost
I have been on this for MANY hours and can not understand why Postgres will not listen on anything other than localhost. I an running on Ubuntu 18.04 clean install + Django, Postgres and nginx. All up ...
0
votes
1answer
595 views
Workbench freezes on connecting after Ubuntu 18.04 upgrade
I recently upgraded to Ubuntu 18.04 and started having this issue, I can connect to my local mysql server via the terminal fine using
mysql -u root -p
however when I try to use mysql workbench it ...
2
votes
0answers
720 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 ...
1
vote
0answers
177 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 ...
-2
votes
2answers
158 views
pg_ctl still pointing to 9.5.4 after upgrade to postgres 10 [closed]
I have updated postgres from 9.5.4 to the latest 10.4 on Ubuntu 14.
But after installing postgres 10 I am seeing
support@platform1:/usr/bin$ ls -lah pg_ctl
lrwxrwxrwx 1 root root 34 Jun 13 08:59 ...
1
vote
0answers
50 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 ...
0
votes
2answers
619 views
Ubuntu cannot open shared library mysqlx.so
MySQL Server version:
Ubuntu: 5.7.23-0ubuntu0.18.04.1-log (Ubuntu)
MySQL installed using apt-get.
When installing a plugin with the following command:
mysql> INSTALL PLUGIN mysqlx SONAME '...
1
vote
1answer
120 views
error connecting to master 'replica@192.168.57.10: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 ...
0
votes
1answer
198 views
MariaDB Galera Cluster on Ubuntu 16.04 does not start after rebooting [closed]
I've installed a MariaDB Galera Cluster on Ubuntu 16.04 in 2 nodes.
Here the info from node1:
root@localhost:~# sudo more /etc/mysql/conf.d/galera.cnf
[mysqld]
binlog_format=ROW
default-storage-...
1
vote
1answer
846 views
Why is MySQL slow on the Ubuntu dedicated machine while fast on the Ubuntu VM?
I have a dedicated machine with intel i5, 8GB RAM, 7200RPM HDD with Ubuntu 18.04 OS. I have installed only MySQL-5.7.22 in it, see the configuration file's content at the end of this question. I ...
2
votes
1answer
2k views
Installing SQL Server, I get unmet dependencies libc++1 and libjemalloc1 but it is not installable
Here is the output,
$ sudo apt install -y mssql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may ...
