Questions tagged [linux]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
16 views

I would like to migrate SQL SERVER 2014 to SQL SERVER 2019 on Linux using AG

I would like to migrate SQL SERVER 2014 on Windows to SQL SERVER 2019 on Linux using while running AG. Is there an option to Add the SQL SERVER 2019 to the same AG and once the time comes gracefully ...
1
vote
0answers
56 views

InnoDB: Error: Table “mysql”.“mysql.transaction_registry” not found after upgrade to mariadb 10.3

I've upgraded the mariadb to 10.3 packages on my Debian 10, however something went wrong and I ended in the same issue which is mentioned several times Cannot open table mysql/innodb_index_stats [...
1
vote
1answer
50 views

Restoring a MS SQL Server database on Linux

I am running Manjaro Linux and I am trying to restore a Microsoft SQL Server database from a .bak file. I am trying to follow the official documentation, but it doesn't seem to work! ➜ ~ sudo ...
0
votes
0answers
29 views

Restore database with .idb .frm and logfiles

I recently had an error with my SD card inside my RaspberryPi4. (I'm very inexperienced with databases as well.) So this means that I have to restore my database. What I did was copying all the files ...
0
votes
1answer
24 views

Running the .sql script in Linux to get the postgresql database table and functions

I am using Red hat Centos 7. When I use this command to run the .sql script to get postgres database table and fucntion: $sudo psql -U postgres -d tsdb -W -f /.sqlscript/location It asks for postgres ...
0
votes
0answers
30 views

Linix generic 5 install mysql server 5.6 [closed]

I need to install an old version of MySQL on Linux. My Linux version is new: Linux Mint 19.3 The error I always get is: mysql-server-5.6: Depends: initscripts but it is not installable Depends:...
0
votes
1answer
48 views

Oracle 12c installation : reference data is not available for Release “12.1” on the operating system distribution "Linux4.12.14-94.41-default

We are trying to install Oracle 12c in Suse Linux 12.4. As soon as we start the installation, it fails saying [INS-13001] Environment does not meet minimum requirements When we checked the log, we ...
0
votes
0answers
18 views

No logs generate in audit.log file with audit plugin in MySQL in Linux?

No logs generate in audit.log file, even though: SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'audit%'; gives: | PLUGIN_NAME | PLUGIN_STATUS | +----------...
0
votes
0answers
28 views

Lost data in bulk Insert on Galera Cluster

I have a 2-node fresh Galera Cluster in 2 DCs. I Import a 3GB dump into one node and the other starts to sync. After importing dump, I check the size and rows on both nodes and they are not equal. ...
0
votes
0answers
20 views

Configuring Apache with WSGI PGAdmin applicaton

I am using Apache 2.4 and I have PGAdmin service running. PgAdmin is listentning on 5050 port, so I can connect with it using http://127.0.0.1:5050/ or http://my-ip-address:5050/ BUT I'd like to use ...
0
votes
0answers
17 views

seafile-server error: sqlite3_prepare_v2 failed - disk I/O error (or http error?)

Two days ago my seafile-server (v7.0.5) stopped working, with error logs that look like below. What could be going on - not clear to me if this is an error in the database, in http-server, or in ...
1
vote
1answer
28 views

MySQL 5.7 on AWS will not start, and then keeps trying to restart

A few days ago, I tried to backup my database. It is mySQL community edition 5.7 running on an AWS EC2 instance. This has always worked. The backup command was: mysqldump -h localhost -uroot -...
1
vote
2answers
31 views

Is there any workaround to make Firebird v2.5 under Arch Linux attach existing databases and open them?

I have tried almost everything to get Firebird v2.5 under Arch Linux connect to an existing .fdb database without getting the error message: *** IBPP::SQLException *** Context: Database::Connect ...
0
votes
1answer
30 views

mariadb 5.5 innodb keeps opening files up to 200k until system hangs completely

Mariadb 5.5 is installed on CentOS and serves a database in the total volume of around 40GBs (as measured per database files on a disk) and 506 tables. This database is being queried by php-fpm, and ...
1
vote
1answer
41 views

permission denied on mongod.lock, despite it being owned by mongodb

this is my mongod.lock: -rw-r--r-- 1 mongodb mongodb 0 Dec 3 17:09 mongod.lock hence this solution doesn't apply: https://dba.stackexchange.com/a/183018 this is how I start mongodb: sudo ...
0
votes
0answers
20 views

EM Daemon is not running

I have installed Oracle Database 11gR2 on OS Oracle Linux 7.7 while i try to start server using below command its started [oracle@localhost dbhome_1]$ emctl start dbconsole Oracle Enterprise Manager ...
0
votes
1answer
48 views

RMAN log file with date and name in Oracle 11gR2 in Linux

I have a script and I want to create my log file with datetime and with unique name. It's my script: ....... ....... rman target/ LOG='/u01/backup/logs/rman.log' <<EOF ....... ....... ....... ...
0
votes
1answer
43 views

Using of delete obsolete in Oracle 11gR2 RMAN on Linux

I'm using crontab for automatic backup (full backup). It works 2 times in a day (8 AM and 23 PM). In my script I use delete obsolete but I have a question. I want to delete old backups without last 2 ...
0
votes
1answer
28 views

How do I figure out how Postgres was installed on my Linux system?

I'm using Postges 9.6 on Ubuntu Linux 16. I'm trying to figure out how the Postgres server was installed so I can figure out a command to start and stop it. It evidently isn't installed as a Linux ...
1
vote
2answers
182 views

How to force oracle accept insufficient swap size?

I want to install Oracle 12c on Oracle Linux 6.10 with 5.7803GB swap size. But one of prerequisites checked failed: INFO: ********************************************* INFO: Swap Size: This is a ...
1
vote
1answer
38 views

Dockerized Sysbench could not connect to Mysql

I'm trying to follow this tutorial. It does not give Mysql version requirements. So I'd tried to use Mysql 8.0.18 Community Server to connect to using those commands. I've created what have been ...
0
votes
0answers
189 views

Cannot start postgres service

I have postgres on my pc and I work with it every day. But today when I tried to connect to postgres, I did not manage to do it. I decide to start it by typing systemctl start postgresql@10-main, by ...
0
votes
1answer
193 views

db2 expired password but cannot reset

Has anybody encountered this problem with a db2 server? I'm running a development database and connecting to the database gives me a password expired error. Trying to reset it will give me an invalid ...
2
votes
0answers
41 views

Solution for the deletion of old Database Backups for Linux SQL Server 2017 after Backups created with Ola Hallengren scripts?

I have a problem when I want to delete older backups, I've created with Ola Halengreen scripts. USE Maintenance EXECUTE dbo.DatabaseBackup @Databases = 'USER_DATABASES', @Directory ='/mssql/backup/'...
-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....
5
votes
1answer
121 views

Permissions issue in Docker SQL Server 2017 while restoring certificate

Docker SQL Server 2017 container @latest. Using master database. The error I am facing is the following: [S00019][15208] The certificate, asymmetric key, or private key file is not valid or does not ...
0
votes
1answer
25 views

How to find out unused port on Linux server

We are trying to use port 5444 for our new PostgreSQL instance and we are not sure whether 5444 is used or unused. Could you please help us to find the answers to the below questions. We want to ...
1
vote
1answer
31 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 (...
5
votes
2answers
2k views

Unable to start mongodb as a service - 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 ...
-3
votes
2answers
65 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 ...
1
vote
0answers
13 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
33 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
27 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
83 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
76 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
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
1answer
115 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
153 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
761 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 ...
1
vote
2answers
532 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
185 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
236 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
14 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
43 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
477 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
84 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
146 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
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 ...
1
vote
2answers
61 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
52 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.