Questions tagged [linux]

A widely-used open-source operating system that is particularly popular on servers.

Filter by
Sorted by
Tagged with
1
vote
1answer
20 views

MariaDB Parallel Replication Drifting at random times

I have recently been thrown in the deep-end to manage our Database servers since our DBA left. The current set-up is Mariadb (mariadb Ver 15.1 Distrib 10.1.38-MariaDB, for debian-linux-gnu), InnoDB (...
1
vote
0answers
138 views

Exception; Collection does not have UUID in KVCatalog

I have installed Mongodb 4.2 through this guide] and when running sudo service mongod start|restart It does not start the server and I have the log below in mongod.log file. Exception in ...
-1
votes
2answers
52 views

Need a shell script that can run a oracle query and produce output in .csv format

Can you please help- need a shell script that will have a oracle query inside it and produce a .csv format output in specific location, that script should be a scheduled in a cron job which runs, the ...
0
votes
0answers
11 views

SQL Server - Change AuditLevel on Linux hosted instance

just wondering if it's possible to change the AuditLevel on SQL Server 15.0.1800.32 (2019) hosted on Linux to "Failed logins only". Currently it's set to audit failed and successful logins and I ...
0
votes
0answers
29 views

ORACLE timed Datapump on Linux? (No crontab)

what is the best way to create a timed Datapump Dump of a PDB on a Linux System? No Crontab. And how do I implement it?
0
votes
0answers
11 views

Unable to connect with MongoDB when giving mongod command in Cli

I'm trying to install mongoDb on centos VM and followed few sites like https://linuxize.com/post/how-to-install-mongodb-on-centos-7/ , https://www.digitalocean.com/community/tutorials/how-to-install-...
0
votes
0answers
24 views

PostgreSQL + pg_xlog folder with very old files and how to purge pg_xlog files

Under folder - /var/lib/pgsql/DB/pg_xlog We have very old files as the following: -rw------- 1 postgres postgres 56 May 31 2018 00000002.history -rw------- 1 postgres postgres 331 Oct 14 ...
0
votes
3answers
30 views

Postgres Initial Setup and User Login

Full disclosure, new to postgres and new to linux. I am having trouble understanding the user management side of postgresql. I installed on a Ubuntu 19.04 based os using sudo apt update sudo apt ...
0
votes
0answers
17 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
1answer
37 views

How to install mysql/mariadb on NIXOS?

I installed mariadb via configuration.nix. For the installation I made the following entries in my configurastions.nix. services.mysql.enable = true; services.mysql.package = pkgs.mariadb; ...
0
votes
0answers
74 views

One database on my MS SQL Server wont start OS error: 5(Access is denied.)

I am running MS-SQL server for Linux. There are several databases on this machine, but one of them refuses to start up. The error log shows: 2019-07-30 16:29:36.76 spid19s SQL Server is now ready ...
0
votes
0answers
156 views

Error Code: 1129 Host 'xxx.xxx.xx.xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

For the past few days, I am getting this error every morning when I tried to connect to the MySQL database using the MySQL workbench and also through some applications. So, every day I log onto the ...
0
votes
2answers
60 views

How to get a new pid file of Mysql and restart Mysql Successfully?

Due to lost of pid file of my server, I can't stop mysql using normal commands like service mysql stop which will show ERROR! MySQL server PID file could not be found! So I try to stop all mysql ...
0
votes
1answer
25 views

LOAD_FILE() works on SELECT, but returns NULL on insert

I'm having troubles using the LOAD_FILE() function in my environment. I'm trying to add a file to a BLOB field but whenever I try to insert or update this field with LOAD_FILE(), this field is being ...
0
votes
0answers
51 views

sudo systemctl restart mssql-server hangs

When installing Red Hat Enterprise Linux Server release 7.6 (VM) minimal install, I followed these steps for MS SQL installation: sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages....
0
votes
0answers
11 views

IO scheduler for Oracle RAC on Linux

All the documentation I have seen says that Oracle recommends the deadline scheduler. This seems very counter-intuitive when using a mini-SAN (with persistent write caching) - in such a scenario, and ...
1
vote
2answers
41 views

Virtual Environment for learning [closed]

I am a new DBA and my friend told me the best way to learn about becoming a DBA is to setup your own server (virtually or physically). I don't have a spare machine laying around so I will need to set ...
2
votes
1answer
109 views

How to install pgcrypto?

While trying to answer Create integer id columns from existing string columns (integer coding?) it turned out that I needed my own version of postgres to play with. I already had a decent postgres ...
1
vote
1answer
40 views

ORA-00904: “GET_JAVA_PROPERTY”: invalid identifier - 11gR2

In Oracle DB 11.2.0.4, linux 6.7 single instance select get_java_property('java.version') from dual; SQL> show user USER is "SYS" SQL> select get_java_property('java.version') from dual; ...
0
votes
1answer
45 views

T-SQL is not working on DBeaver on Linux [closed]

I am trying to run a basic T-SQL script DECLARE @temptable TABLE( abilityTypeId BIGINT NOT NULL, companyId BIGINT NOT NULL ); INSERT INTO @temptable(abilityTypeId, companyId) ...
0
votes
0answers
22 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 ...
1
vote
2answers
46 views

Is it possible to change the SQL Server errorlog file number on Linux?

Everything is in the title. We can change the number of errorlog files using the registry on Windows, does anybody know if it is possible on Linux? I see no mssql-conf option for this. Thanks
0
votes
0answers
49 views

SQL Server on Linux

While running "sudo /opt/mssql/bin/mssql-conf setup" to configure sql server i keep getting the error "sudo: Please use single character options". I am running the above command as root user.
0
votes
0answers
37 views

Corrupted InnoDB still won't start even after removing corrupted tables

My MySQL server stopped working randomly and upon checking log files I found this: 190622 23:45:10 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer ...
0
votes
1answer
25 views

Backing up and restoring all databases in MySQL on linux

I plan to dump all databases on one computer and restore them on another using the following 2 commands:- mysqldump -u username -p --all-databases > dump.sql mysql -u username -p < dump.sql ...
0
votes
1answer
27 views

Mysql, linux, autocompletion

I need autocompletion for mysql console in Linux. I found this solution. Add this to .my.cnf. file in home folder. [mysql] auto-rehash But it doesn't work, for ubuntu 19.04 and mysql 14.14. And ...
0
votes
0answers
17 views

How to change root password of mysql community server in fedora 30

okay so i have changed to custom password as per the password policy but i want to set a short password say, 4 letter password only as a root password for mysql but i am unable to do it, i am using ...
8
votes
1answer
81 views

initdata: No memory for kernel buffers

I recently upgraded my SQL Server 2017 Developer Edition on RedHat Enterprise Linux 7.6 to SQL Server 2019 CTP 3.0. The mssql-server service will no longer start. /var/opt/mssql/log/errorlog shows ...
1
vote
1answer
51 views

SQL Server Linux Disable Remote Connections

What is the best way to disable remote connections on a SQL Server Install on Linux (CentOS 7)? I.E. force SSH Tunneling to connect over localhost. I typically block ports explicitly with IPTables/...
0
votes
0answers
213 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
27 views

MySQL(5.7.23) starting automatically with skip-grant-tables

I recently installed MySQL 5.7.23 and started mysql service later ran mysql_secure_installation but while changing the password ran into any issue where it says that i cannot change the password as ...
1
vote
0answers
55 views

MongoDB Fails due to permission error even though its setup

Attempting to start my MongoDB server using service mongod start fails for the reason: exception in initAndListen: IllegalOperation: Attempted to create a lock file on a read-only directory: /var/lib/...
1
vote
0answers
29 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 ...
3
votes
1answer
167 views

Cannot systemctl start/stop mssql. mssql-server stuck in script upgrade mode. Cannot login either

I'm having trouble getting my mssql-server back online. Apparently it got stuck between an upgrade and a bad database restore, and now it is stuck, and I nothing I've tried has helped to unstuck it. ...
1
vote
1answer
53 views

SQL Server Management Studio Doesn't do “Full” Backup

Very new to SQL Server. I'm trying to bring a backup from one our clients Windows 2012 Server Install to our Linux Install. We have the site working perfectly on Linux, but can't seem to do an ...
1
vote
1answer
346 views

Does Oracle 11gR2 is supported on RHEL 8 or Oracle Linux 8? [closed]

Oracle (afaik) did not updated their compatibility matrix yet. Can I run Oracle 11gR2 (which still is in extended suporte) in the new OS?
0
votes
0answers
37 views

drop_cache effects on database

I have several machines with: databse: db2 10.5 OS: CentOS 6.9 on some of machines cached memory is high and i need to run this command to free some memory: echo 3 > /proc/sys/vm/drop_caches ...
0
votes
1answer
60 views

Master Master replication rows not sync properly

I have a wordpress website that run on 3 machines Machine1 | Machine 2 {nginx+lsyncd+mysql} visitor > cloudflare > haproxy ------ ...
1
vote
2answers
89 views

Possible make mysql faster

Process 3 Million rows data for every 5 minutes. Data flow: LoadData from network to tmp table. Do some kind of group up and save to ~10 different table. Max 7 session running for saving data to ...
0
votes
2answers
54 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
24 views

Using AMMM or Huge Pages for Oracle 11g R2 Database

I'm running an Oracle production 11gR2 database which has around 65Gb of data, running with a 4Gb SGA & 40Mb PGA using ASMM. Now, I have a memory increase up to 32Gb. I'm planning to increase ...
0
votes
0answers
39 views

SQL Server 2019 Developer Edition on Ubuntu 18.05 Linux seems to only use one processor

I set up this db on an old server that has Ubuntu 18.04 in order to test some new features of SQL Server 2019. First time running SQL Server on Linux. I am running an intense query and happened to ...
4
votes
1answer
528 views

best way to run sql server management studio on linux

I'm using ubuntu 18.04.2 on my desktop and running sql server 2017 from docker. I want to use sql server management studio to manage the server. SO far now, I have a windows 7 enterprise with with ...
0
votes
2answers
124 views

Issue migrating from SQL Server 2008 R2 to SQL Server 2017 Standard (on Linux)

I am currently trying to carry out a database migration from SQL Server 2008 to SQL Server 2017 (Linux) using the DMA tool. I get the all green after running the assessment, however I get hit with ...
1
vote
1answer
74 views

Linux SQL Standard Edition being killed by OOM killer

We have launched Linux with SQL Server standard edition for production environment, but the memory restriction feature in SQL Server is not working properly. The server has a total of 32 GB of RAM. ...
0
votes
2answers
90 views

MySQL performance tuning related connection

I am running openstack cloud and it use mysql database which is MariaDB 10.1.30 I am sometime seeing connection reset from multiple clients, to trying to find out what is going on in database, I am ...
0
votes
0answers
28 views

SSL certificate is not sent to MySql Server while connecting from MySql C connector

I am writing a C program to communicate to MySql server (running on linux) as root, for whom REQUIRE SSL is set. In this program I am using following function call (from libmysqlclient.so) to set SSL ...
0
votes
0answers
23 views

mysql pointing to 0:-1 partition

We have a Galera cluster on 3 nodes. On one of the nodes with SAN storage we experienced slowness in the cluster. iotop in the node with SAN storage shows that mysqld pointing to 00000...:-1 ...
3
votes
1answer
179 views

How to lock a MSSQL (2017 Linux) account after N unsuccessful login attempts

I have to configure account lock after N unsuccessful login attempts on MSSQL 2017 Linux. That is standalone server and is not in AD. I couln'd find any valuable information so far unfortunately. ...
-1
votes
1answer
402 views

Restore database - Operating system error 5(Access is denied.) on Linux

I try to restore SQL Server 2017 Express database using sqlcmd tool on Ubuntu 16 Server. My SQL command is: RESTORE DATABASE [xxxxx] FROM DISK = N'/home/xxxxxx/DBBackups/xxxx.bak' WITH NORECOVERY, ...