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

learn more… | top users | synonyms

2
votes
1answer
81 views

MySQL Memory & max_connections Performance Tuning

So, our site runs WordPress and in the past few days we have been getting tons of spam comments etc. I believe that we are becoming the victims of some kind of bot army that has been crashing our ...
1
vote
1answer
35 views

MySQL innodb_log_file_size change is not being recognized

I am trying to set the innodb_log_file_size option in a MySQL 14.14 (distrib. 5.6.30) installation on Ubuntu 15.10 to solve an issue (importing a database with large BLOB fields) however the log size ...
1
vote
1answer
111 views

postgres user cannot access location of new data directory

I moved my postgresql 9.3 data directory to a different drive, however, my postgres user cannot seem to access that new drive despite my best efforts. I am running on ubuntu 14.04 LTS x64. So I ...
1
vote
1answer
317 views

How can I remove references to tables after removing .frm files?

So I had a bunch of csv files in my /var/lib/mysql/imports directory for importing into mysql tables I had created. To clean up the folder I deleted all the files in the directory (incorrectly ...
0
votes
1answer
24 views

Why doesn't MySQL installation on an Ubuntu linux 16.04 OS require user to specify LD_LIBRARY

Why doesn't MySQL installation on ubuntu 16.04's linux require the user to specify LD_LIBRARY_PATH to resolve its runtime dependencies? I tried googling to find the answer to this question, but I ...
0
votes
1answer
21 views

Incomplete installation with unsupported locale

I was installing postgresql on Ubuntu 12.04 (Digital Ocean droplet). The locale variables in my environment gets transported to the DO box. When postgres is installed via apt-get install postgresql, ...
0
votes
1answer
26 views

Problems to connect to an Oracle Database with SQLPLUS and URL-Variable, can somebody explain what I have to do?

I would like to connect to a ORACLE database via SQLplus. If I do it this way: sqlplus "user/pw@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=dbsrv01.desy.de)(PORT=1521))(ADDRESS=(PROTOCOL = TCP)(HOST = ...
0
votes
1answer
45 views

Columnar & Row Oriented DB

In a previous question, I discussed some challenges with a row-oriented table. I have two tables in this application. The first table is well-suited for row-oriented operation; the second is well-...
0
votes
1answer
141 views

PostgreSQL error moving data directory to home folder

I have a problem with the moving of my data directory of PostgreSQL. I found many different ways, but none worked. The most sensible way for me was: Stop PostgreSQL Copy data from old folder to new ...
4
votes
0answers
479 views

MySQL 5.7 + Ubuntu 14.04 eating up my RAM

I've recently installed MySQL 5.7.11 in my Ubuntu 14.04.3 system following these instructions: http://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/ Being totally empty and not being called by any ...
3
votes
0answers
117 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 ...
2
votes
0answers
167 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 ...
2
votes
0answers
27 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"...
1
vote
0answers
61 views

Postgres “could not receive data from client: Connection reset by peer.”

I have a cakephproject got a error when the project reload and it seem the error Database connection "Postgres" is missing, or could not be created. I have checked the error it will show error could ...
1
vote
0answers
58 views

Set private key password for mysql using ssl

2016-05-09T20:05:05.772747Z 0 [ERROR] SSL error: Unable to get private key from 'server-key.pem' 2016-05-09T20:05:05.772764Z 0 [Warning] Failed to set up SSL because of the following SSL library error:...
1
vote
0answers
54 views

ERROR 1 (HY000): Can't create/write to file (Errcode: 13 - Permission denied)

I've been struggling for a couple of days with this now and have been trying to use this thread amongst other google searches to resolve it but can't seem to get it to work. When I run this SELECT ...
1
vote
0answers
190 views

How to fix postgres stuck in recovery mode?

I have Jira and Confluence installed in a server. We didn't have any free disk space one day, and these services didn't started correctly, so after deleting some files we now have some free space ...
1
vote
0answers
29 views

MySQL using cpu after cancelling slow query

I had to cancel a very slow running query after it ran for a few days without completing on my ubuntu server. Since then mysql has been persistently running a process which is using 25-45% of the cpu ...
1
vote
0answers
137 views

Creating and connecting to a postgresql server on ubuntu 15.10

I have been struggling with creating a postgresql server that I can connect to externally (using pgadmin3). I am installing it on a virtual Ubuntu 15.10 x64 server. I have been following the guide ...
1
vote
0answers
185 views

Mariadb alongside MySQL Can't start the MariaDB

I'm running MySQL on ubuntu 14.04 and it works great. For development and testing before switching between the two I want to install a separate Mariadb server. I followed this (old) tutorial: ...
1
vote
0answers
354 views

Can I export a PostgreSQL database from Heroku and Import as a PostGIS database in Digital Ocean?

Disclaimer: This may be a dumb question. This is honestly way over my head... one of the pitfalls of using Heroku for too long. I have a PostgreSQL database on Heroku. Now I'm migrating to Digital ...
1
vote
0answers
254 views

Are A or D series VMs better for deploying PostgreSQL on Azure?

In Azure there are VMs that have local storage either as spinning disk (A-series) or SSD (D-series). Considering this space is wiped on reboot... Is there a benefit to choosing the SSD option for ...
1
vote
0answers
85 views

Pg_restore table size differences

What would account for the difference in table sizes between one PostgreSQL database and another restored from its dump file? On an Ubuntu 12.04 host, I'm running PostgreSQL 9.1, and I dumped my ...
1
vote
0answers
92 views

MySQL replication backup

How to take MySQL Master-Master and Master-Slave replication backup?. I have setup Master-Master replication with a separate slave for each master on Ubuntu. What happens if, I issue or schedule ...
1
vote
0answers
848 views

Why can I not start mysql server on ubuntu after change the innodb_flush_log_at_trx_commit value to be 2?

Why can I not start mysql server on ubuntu after change the innodb_flush_log_at_trx_commit value to be 2 ? updated to answer the 3 questions: mysql> show variables like 'version%'; +--------------...
0
votes
0answers
6 views

repmgr 3.0.4 and postgres 9.4 on ubuntu (ERROR: replication slot “repmgr_slot_2” does not exist)

I'm not a DBA but I have been tasked with setting up a database and streaming replication and repmgr is the tool I have decided to use. The master goes on fine and I can see it registered in the ...
0
votes
0answers
18 views

mysql needs a start after turning system off

Hii I am facing severe installation issues after installing Ubuntu 16.04. Mysql needs a start everytime system is turned ON. I have removed every available package of mysql 5.7 but after installation ...
0
votes
0answers
21 views

ORA-29327: unsupported client compatibility mode used when talking to the server

I have application created in Spring, using Hibernate. The problem is that the application has this error during working with database: ORA-29327: unsupported client compatibility mode used when ...
0
votes
0answers
11 views

MongoDB Initial Sync failing repeatedly

I have a one member mongod instance (Server1) with a very large DB with 2.5 million documents (Each document is very big) and 4 indices. Then I added another machine (Server2)to this replica set. ...
0
votes
0answers
12 views

Is it mandate to turn off huge pages in Mysql 5.6

Folks, Is it required to turn off huge pages in Mysql 5.6 server under /sys/kernel/mm/transparent_hugepage/enabled -> To never? We have a heavy transactional database and calling the data segments ...
0
votes
0answers
15 views

postgresql service fails to start after bad reboot

I have a postgresql 9.3 running on Ubuntu 14.04. For some reason, my fellow developer rebooted the server and since then postgresql service is failing to start. Also, the reboot didn't go smooth as it ...
0
votes
0answers
77 views

How to do rolling upgrade MariaDB 10.0 -> 10.1 on ubuntu 14

I'm trying to figure out how to do a rolling upgrade of our galera cluster running on MariaDB on Ubuntu 14.04. In testing, the first node I upgraded started complaining about the timestamp column in ...
0
votes
0answers
126 views

virtualbox ubuntu 14.04 MySQL access denied for user 'root'@'localhost'

I removed the mysql-server on the virtualbox ubuntu by running : sudo apt-get --purge remove mysql-server and re-installed it, but I still get Access denied with or without password when trying to ...
0
votes
0answers
648 views

How to fix: MySQL job failed to start

background: i installed mysql server on my ubuntu 14.04 aws ec2 server a few nights ago, configured it following guides from reputable sites, and populated it w/ ~80 million rows. a few times, I ...
0
votes
0answers
25 views

MySQL 5.5 client SSL connection only works when adding cipher list argument, why?

I set up the packaged MySQL server 5.5 and client on two Ubuntu VM. I configured the server to support SSL. I can connect to the server with the MySQL CLI tool between the VMs, but the connection is ...
0
votes
0answers
39 views

How to fix the MySQL 5.6 System.Security.Principal.WindowsIdentity.get_User () not implemented exception in Linux?

I would like to know if programmatic intervention is necessary to fix the following C# Runtime exception when running MySql 5.6 Connector.NET on Ubuntu Linux 15.10 instead of Windows 7. Error ...
0
votes
0answers
34 views

MySQL [Warning] IP address could not be resolved

my Server runs good, i have mysql/mariadb + amavisd-new and postfix running but i have in my logs bunch of Feb 23 11:13:55 localhost mysqld[32633]: 160223 11:13:55 [Warning] IP address '104.217.216....
0
votes
0answers
59 views

Need help with corrupted MySQL database

I could use some step by step help on using innodb to hopefully recover a corrupted MySQL database. We are running moodle on a ubuntu server which uses the LAMP stack. The database has been corrupted ...
0
votes
0answers
47 views

move a postgres cluster to another machine

I have a postgreSQL 8.3 cluster I should move onto a new machine which runs postgres 9.3 (Ubuntu 14.04) . First of all I copied my whole cluster and I pasted into /etc/postgresql/9.3/<...
0
votes
0answers
48 views

Configuring MySQL Cluster

I'm having trouble in configuring my data nodes. My setup is 1 management node, 1 SQL node and 2 data nodes. I'm running mysql-cluster-gpl-7.4.8-linux-glibc2.5-x86_64 on my cluster. My question is do ...
0
votes
0answers
41 views

Problems with MariaDB - won't resync nodes - Can we build a good diagnostic set of instructions?

I have a 3 node ubuntu server MariaDB cluster using rsync, which keeps coming un-synced. When it happens I try to add it back in, reboot, and try again, try again with bootstrap... Recently I've found ...
0
votes
0answers
621 views

Mongodb 3.0.1 in ubuntu starts but status, stop or restart show 'mongo stop/waiting'

I am relatively new to Mongo and have installed 3.0.1 on a Digital Ocean droplet (Ubuntu 14.04 LTS). The database starts without problems but I am unable to 'sudo service mongod [stop/restart/status]' ...
0
votes
0answers
35 views

How do I alter my role to be a superuser?

I'm working my way through the steps in this slide to configure Postgresql & PostGIS. I configured my user role as directed on this slide. Note, the new role should not be a superuser. That ...
0
votes
0answers
183 views

MySQL 5.5, Xubuntu 14.04 - INSERT and UPDATE bottleneck

DBAs: I have been developing and maintaining plugins for Moodle for the last ~2 years, and have recently decided to try using my local desktop again, rather than my institutions ESX VMs, as a ...
0
votes
0answers
74 views

Starting up postgres on Ubuntu for the first time

I've installed postgres on ubuntu, created a node and now I'm trying to start up that node as per the instructions: postgres --coordinator -D /usr/local/pgsql/data -p 1281 But I get the following ...
0
votes
0answers
2k views

huge size of /var/lib/postgresql/9.3/main/base/1 directory (postgresql)

i'm using postgresql 9.3.4 and real size of database is about 5.5 GB but POSTGRESQL fill disk about 256 GB !! is this POSTGRESQL Cache and what is method to clean thing issue ?
0
votes
0answers
198 views

listen_addresses set to '*' in postgresql.conf disappears every reboot of Ubuntu

I have set listen_addresses to '*' in /etc/postgresql/9.1/main/postgresql.conf and stopped/started Postgres 9.1 with /etc/init.d/postgresql to "reload" configs. This works fine and I can access my ...
0
votes
0answers
886 views

TokuDB fails to load in MariaDB, even when transparent hugepages are disabled

Earlier, I upgraded my website server to Ubuntu 14.04 LTS. I had a very nice setup with MariaDB and the TokuDB engine. However, the setup was kind of messed up when TokuDB refused to load properly, ...
0
votes
0answers
25 views

Connecting mysql on server A/ to webapp on server B/

I am connecting mysql on server A/ to a webapp located on server B/. Both servers are Ubuntu servers. For security purposes, is there any way on server B to avoid showing the full path / IP address ...
0
votes
0answers
127 views

MySQL overtaking system memory and forced to restart

I'm facing a frustrating issue. I have a MySQL Server 5.5 running on top of Ubuntu Server 12.04.3 LTS (VMWare guest w/ 16GB RAM - 8 Cores) mysqltuner.pl says [OK] Maximum possible memory usage: 6....