All Questions

Filter by
Sorted by
Tagged with
0 votes
1 answer
1k views

How can Amazon RDS grant CREATE EXTENSION to their RDS_SUPERUSER role?

I've been trying for some time to allow ordinary, non-superuser users to create extensions. While reading across RDS documentation, I find that their internal "master user", rds_superuser, ...
0 votes
1 answer
152 views

Why is restored database faster than original?

I ran this explain analyse in my PostgreSQL 13.7 database: explain(analyze, verbose, buffers, settings) select * from main_table; Seq Scan on public.main_table (cost=0.00..10246.15 rows=220715 width=...
1 vote
2 answers
3k views

Setup VIP for PostgreSQL Replication

I have been assigned a task to setup Streaming replication in Postgresql. I am not a DBA by profession, doing this thing for the first time. I have set up replication, now as we don't want to change ...
0 votes
0 answers
38 views

Probably missing something simple, source of ERROR 1146 (42S02): Table doesn't exist error

Looking to import a mysqldump .sql file into a new db. Have tried both via command line and directly within a mysql session. The following call gives the assocaited error: chris@chris-X1C6:/media/...
0 votes
1 answer
289 views

MySQL server connection is hitting limit of magical number 4832

Have been monitoring mysql server for year, I notice the mysql database max_used_connections cannot get pass 4832. Once hitting 4832, MySQL begins to show slowness, while the loads/cpu usage/memory ...
2 votes
2 answers
171 views

What SQL Server server-level roles allow you to add users to database-level roles?

In SQL Server 2022 (on-premise), I have a login (call it 'UserManager') which I have added to the ##MS_DatabaseConnector##, ##MS_DatabaseManager## and ##MS_LoginManager## fixed server-level roles. The ...
0 votes
1 answer
2k views

mysql on Mac Monterey not working regardless what I do

I am running a Mac on Monterey v 12.4 with an M1 Max. I tried to install mysql on my Mac but I never get it to work regardless what I do. The first thing I tried to do is: $ brew install mysql Then I ...
2 votes
2 answers
2k views

SELECT inside SELECT in Redshift

select t.col1, t.col2, a.col1, b.somecolumn VQ.a, VQ.b, VQ.e, VQ.d, VQ.f, (select t.status as a, p.id as b, p.permit as c, p.des as d, p.error_code ...
0 votes
1 answer
57 views

SQL Server - moving databases to an earlier version - options

I have inherited a vendor product. It’s currently very old, having been installed in 2013 and never updated in the 11 years since. The database server it’s using for its 3 database is SQL Server 2008 ...
1 vote
2 answers
673 views

How to change default mongo port on a bitnami instance

I am running a bitnami instance of mongodb for our pre-production. The default port for mongo is 27017. But for security reasons i want to change it but it is not possible. I have tried these things: ...
0 votes
2 answers
420 views

SQL server alwayson 3 Node Primary Down

I am using three node alwayson Availability Group SQL 2012 Enterprise Edition. 2 Node in DC with File Share Witness quorum also in DC and third node to be setup in DR I need to perform a DR switchover ...
1 vote
2 answers
163 views

PosgtreSQL — Is it possible to specify a sequence name in a GENERATED BY DEFAULT AS IDENTITY column?

When using PHP’s lastInsertId() method with PostgreSQL, it’s necessary to know the name of the sequence. If I defined the column using GENERATED BY DEFAULT AS IDENTITY, I know I can get the sequence ...
0 votes
1 answer
534 views

Why could pgloader fail with 'undocumented reason' while migrating large MySQL database to PostgreSQL?

The database I would like to import is approximately 55GB in binary format, about 36 GB exported by mysqldump. But as we know even the postgres compatible mysqldump is not 100% compatible, so I'm ...
0 votes
1 answer
42 views

How to delete "SQL Server Agent" logs from "Log File Viewer"?

On "SQL Server 2019" on Windows 2019: I have opened Microsoft SQL Server Management Studio. I logged into database server. I clicked on "SQL Server Agent" and clicked on "...
0 votes
0 answers
24 views

Using redis keyspace notifications to know which member was added to or removed from a set

My use case is that whenever a member is added to or removed from a set, a keyspace notification should be triggered that has information about what member was added or removed and put that pub/sub ...
0 votes
2 answers
506 views

Always on, SQL Server Enterprise 2022, 3 node cluster: cannot run with only one node up

I have a new 3 node Windows 2022, SQL Enterprise 2022 cluster with file share witness. I am testing this before it goes fullly into production. I was hoping that it would run from only one node, but ...
0 votes
1 answer
2k views

Help with Galera Cluster Auto_Increment

We're currently running a Galera cluster of 3 DB nodes. The way we're set up (due to ORM and automagical locking), we only have one of the 3 DB nodes being written to, and the other two provisioned ...
1 vote
1 answer
2k views

CREATE ROLE if not exists (several users) in postgres

PostgeSQL: create role/user if not exists? says do $$ begin if not exists (select * from pg_user where usename = 'new_role') then create role new_role password '...'; end if; end $$ ; I ...
0 votes
1 answer
972 views

Insert into DynamoDB when data has different attributes

Is there any way dynamodb can handle dynamic attributes? Depending on the request, I need to store different web query parameters in the same table. What I want to do is like this, if I make a java ...
34 votes
5 answers
22k views

Is it bad to have index space larger than data space?

Often I need to run queries against large tables that don't have the right index. So I ask the DBA to create such index. The first thing he does is look at the table statistics and see the index space ...
0 votes
1 answer
44 views

How to set Account for SQL Server service in configuration file?

I want to install SQL Server 2017 by configuration file and I cannot find as can I set into Account for SQL Server service {SQLSVCACCOUNT = ?} value that will select log on as Local System account. Is ...
user avatar
0 votes
1 answer
290 views

Oracle19c container cannot startup after turning on archive log

I'm running oracle19c container. This is the docker-compose file: version: '3.7' services: oracle: image: container-registry.oracle.com/database/enterprise:19.3.0.0 container_name: oracle19c ...
1 vote
1 answer
1k views

How to troubleshoot "Encryption not supported on the client OLE DB provider "SQLNCLI11" for linked server" error

We are using LocalDb for integration/unit testing of a .NET Core application. I have been using this solution for months and recently started getting sporadic errors. It seems to happen the first time ...
1 vote
1 answer
85 views

how to find out the free space inside a database file when the database is not online?

Normally when the database is online I use the following query and get how much space is free inside each file: SELECT CONVERT (decimal(12,2) , (CONVERT(...
0 votes
0 answers
72 views

Incorrect Next Run on Monthly Agent Job

Users have reported that a job on a recurring schedule has not been firing. This is also evident in the execution history. After some experimentation, it looks like it might be a bug in the SQL Agent. ...
2 votes
1 answer
2k views

Issues with enabling pg_stat_statements

I am having issues quering pg_stat_statements and puzzled what else I missed? See below what I have done. I still have issues when I query pg_stat_statements! I got error saying the libraries is not ...
0 votes
2 answers
38 views

Mysql count Same Two or More Same Record as One and Summarize It

Good Afternoon all, I have two same data record or more in MySql table. How i can counting the same data as one and zero if have only one data based on flag status pair. Below is an example of data: ...
-1 votes
0 answers
23 views

Oracle: How to figure out why my query is slow?

I have a query causing me some headaches. I'm a Dev and not SQL expert which mostly means no experience reading and understanding explain plans. On top of that due to proprietary data I can't share ...
0 votes
1 answer
21 views

Clarifications on Maintenance jobs & CDC on upgrade to ENTERPRISE EDITION

Raising these on behalf of our DBA team. We are looking at moving to ENTERPRISE SQL SERVER 2022 soon and would need help clarifying a few things: We are looking at a 3-NODE setup: (1) NODE-1: Primary (...
-1 votes
1 answer
64 views

MySQL design and best design practices

I am designing my first database for a mobile application, which is also planned to be developed into a web application. The photo shows the part responsible for user authentication and information ...
1 vote
2 answers
623 views

One application only cannot connect to a given SQL Server, all others can

I am encountering a very strange issue with SQL Server on a customer's machines and can't find any resources online regarding my exact issue. We publish an application that uses a SQL Server database ...
0 votes
1 answer
40 views

Can I password protect a specific ms sql database view?

I have an MS SQL database with a View that contains sensitive data in one column. Typically, users will consume this View in Power BI. As additional security, is it possible to password protect the ...
1 vote
2 answers
646 views

Dimension for Product Properties based on Product Type - Sparse Dimension?

I am creating dimension of product properties for sales facts. Property of product depend of product type. For example: - Type = smartphone. Properties = model, OS, size - Type = book. Properties = ...
0 votes
1 answer
36 views

ORA-19504: failed to create file "bh2jk0h7_1_1"

I want to create a script to get incremental backup of the remote Oracle database every week. I save this command in rman_command.sh and give permission to it: BACKUP INCREMENTAL LEVEL 0 DATABASE ...
0 votes
1 answer
2k views

How to Store a Many-to-Many Relationship Between Fact Tables in a Data Warehouse

What are some structures and models to store many-to-many relational data between two fact tables in a data warehouse? Currently, I am using a mapping table which includes the primary keys from both ...
0 votes
1 answer
2k views

Forcing a sequential scan over the index scan

I have this query select s_acctbal,s_name,n_name,p_partkey,p_mfgr,s_address,s_phone,s_comment from part,supplier,partsupp,nation,region where p_partkey=ps_partkey and s_suppkey=...
2 votes
1 answer
3k views

grant permission to SHOW FIELDS

I create a user to make a dump twice a week but when I try to execute mysqldump I have this error mysqldump: Couldn't execute 'SHOW FIELDS FROM `contabilidad_amortizaciones_completas_por_id_vista`': ...
0 votes
2 answers
21 views

How to query two tables and get the rows from one mask the ones from the other?

WHAT I HAVE I have two tables with the same structure. We can say that one is the main table, while the other is a side table, meaning that each row tracks an edit to a corresponding row from the main ...
1 vote
1 answer
388 views

Disk space is not released after compaction

We have deleted some of the partionons of some tables in cassandra database. But after the delete space was not recliamed becuase of size-tiered compaction . Manualy compacted tables with -s options. ...
0 votes
0 answers
11 views

How to migrate from Oracle 11g Single Instance residing on a Azure Linux VM to Oracle 19c RAC?

What are the different ways to migrate from Oracle 11g Single Instance residing on a Azure Linux VM to Oracle 19c RAC on Azure VMs?
2 votes
1 answer
6k views

MySQL "Out of sort memory" error on a simple GROUP_CONCAT query

I have a (what it seems to me) simple query which fails to run on a simple table, the error is: Out of sort memory, consider increasing server sort buffer size These are the SQL statements which I'...
-1 votes
0 answers
12 views

Detailed steps for taking backup from Enterprisedb and restore to Community version Postgresql

Could you please provide detailed steps for taking a backup from EnterpriseDB(V 11.13.23) and restoring to the Community version (V 12.18) Postgresql
0 votes
1 answer
565 views

Mysql join query improvement and GROUP_CONCAT on GROUP BY

I have two tables which I need to perform a left outer join on to get the result set I want. The query I have now works but its taking too long to process. Any suggestions? Query: SELECT Date_format(a....
2 votes
2 answers
473 views

MySQL Upgrade on Windows

I am having MySQL 5.1 installed on windows box. Now I would like to upgrade to latest MySQL 5.6 version. I am planning to install MySQL 5.6 in the same server with same port 3306. After installation, ...
1 vote
2 answers
740 views

MongoDB - Slow aggregate query

It takes around 6min to get the result from MongoDB, when I use the following aggregate query. db.barcodes.aggregate([ { $lookup: { from: 'company', localField: '...
0 votes
1 answer
722 views

How do I truncate performance_schema tables on a read replica?

On occasion, you have to truncate events_statements_summary_by_digest, when it's hit the row limit. On a write master, this is easy, but on a read replica, there doesn't seem to be a way to do it. The ...
0 votes
1 answer
2k views

unable to change secure_file_priv in my.cnf

I have problems loading in a csv file, secure_file_priv is set to NULL, and that prevents me from reading in the csv file. I am trying to change secure_file_priv in my my.cnf file, but my changes don'...
0 votes
1 answer
333 views

Exporting multiple TSQL result sets into one spreadsheet using Powershell

I have to load a lot of CSV files into a DB (3 at a time, resulting in one table per CSV, named as the file name and headers are). I then run about 12 different stored procedures using those table ...
0 votes
1 answer
682 views

Galera cluster replication stalls when using wsrep_provider_options repl.commit_order=2

we are currently testing if moving from mariaDB master/slave replication to a 3-node-galera-cluster is an option for us. General replication in the cluster works fine like expected. Load test shows ...
1 vote
1 answer
1k views

MariaDB FULLTEXT search with short / mandatory words

Just checking I'm understanding this correctly: CREATE TABLE customer ( id INT NOT NULL AUTO_INCREMENT, name TINYTEXT NOT NULL, PRIMARY KEY (id), FULLTEXT (name) ) ENGINE = InnoDB; ...

15 30 50 per page
1
3 4
5
6 7
2055