All Questions

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

unable to add a range to a tag using sh.addTagRange command

Have setup a 4 node test shard cluster: 1- mongos 1- config server 2- shard nodes hosting 1 shard each for a collection. Cluster is working perfectly, but when trying to run the following command: ...
-1 votes
2 answers
51 views

I want to find out how much is my database using and how much CPU are the function on that database is using

As I stated in the title, I want to find out how much cpu time my database is using VS how much cpu time all of the functions on that database are using. I want to show that the functions that are ...
3 votes
1 answer
874 views

How to install Distributed Replay (dreplay.exe) for SQL Server 2017

In SQL Server 2014, dreplay.exe was available under "Management Tools – Basic" feature. However, in SQL Server 2017 that feature no longer exists (Enterprise edition) and it doesn't come with SSMS ...
2 votes
1 answer
540 views

DB_CHAINING lost on on planned Availability Group failover for SQL Server 2019 cumulative update

I'm looking for ideas on how to determine a plausible root cause for DB_CHAINNG problems encountered when we recently performed a planned AG failover. We're using SQL Server 2019 Standard Edition with ...
0 votes
1 answer
342 views

Will purging listener_scan1.log, listener_scan2.log, listener_scan3.log in Oracle 12C RAC Configuration not affect database services negatively

I have a got a oracle 12c database configuration where there is RAC configuration for DB01 on one server and DB02 on another server. The issue i have is that the listener_scan1.log, listener_scan2....
0 votes
1 answer
534 views

Schema of unstructured data can be defined at query time

I am looking for an example to understand the following statement: Schema of unstructured data can be defined at query time
0 votes
1 answer
18 views

Routing List Empty, and cant add using SQL either

Question: Why is my routing list empty? I have removed the secondary from the AG and re-added back, everything is healthy and synchronized. lets assume for the example that server1 is currently the ...
1 vote
1 answer
132 views

Performance degradation after migrating from SQL Server 2016 to SQL Server 2022

I have migrated our load test environment from SQL Server 2016 to SQL Server 2022 (Developer edition). Here are some findings: Changed compatibility level of databases to 160 (for SQL Server 2022) - ...
0 votes
0 answers
37 views

Can my database LDF and MDF files go into this directory?

Is there a way to determine, given a drive and a directory, if a CREATE DATABASE command would succeed? There are basically two questions here. 1. How do you determine if a simple command like this ...
0 votes
1 answer
18 views

Is there a way to verify if a SSIS instance was configured as a cluster resource or not?

We had 2 servers in a cluster ( no aoag ) with SQL + SSIS. one of the cluster nodes died and we removed it. we are in the plan to create a new cluster node and configure SQL engine normally on it as a ...
0 votes
1 answer
26 views

Changes to MSSQL System databases from Cumulative Updates

What sort of changes are made to System tables (master / model / msdb) by Cumulative Updates? For context, I have SQL servers that have AlwaysOn Groups, and am looking at a way to roll back updates if ...
1 vote
1 answer
3k views

PostgreSQL - Update not working inside function

I am creating a web app that handles coupons. When a user claims a coupon the coupon batch count "should" be updated, and a new coupon is created. For some reason the UPDATE query does not work ...
0 votes
1 answer
420 views

Oracle linked server invalid table name

i have created a linked server from sql server and i am now trying to access the table in oracle using the following trigger to insert data into oracle. i cannot refer the table name in oracle. ...
1 vote
1 answer
302 views

Mongodb tree structure questions and answers

I'm looking to build a question answer survey system where some questions will be based on the answer of the parent question. The hierarchy level of the questions can go any number of depth based on ...
1 vote
2 answers
295 views

MySQL consuming a lot of CPU

I’m having trouble with a new server. I installed the optimized configuration for Ubuntu server with EasyEngine of VirtuBox. When migrating my website with template newspaper, the CPU consumption is ...
2 votes
1 answer
735 views

Chunks not splitting on MongoDB sharded clusters

I have created 2 shard servers named rs1 and rs2. Now in the database collection there are multiple records those should split on these 2 servers in chunks. The sharding key is TxnMonth. It is not ...
0 votes
1 answer
366 views

Optimize MariaDB 10.6

I am not a database guru. But here's the matter with which I'd like some help. I have a relatively freshly-minted server running AlmaLinux 8.7, with 64GB RAM and a pair of terabyte SSDs. After ...
0 votes
2 answers
57 views

Finalize GroupAggregate parent using Partial HashAggregate child nodes in Postgres query plan

I have seen in some query plans that the parent is a Finalize GroupAggregate but its child nodes are Partial HashAggregates. When does this make sense? As an example, I have a query that resembles ...
0 votes
1 answer
300 views

table is full in innodb

One of the table t_keyword_stat_ga in the my DB on server(currently the master) was set as INT for a column id. This column is also set as the auto_increment. As noticed today the INT column reached ...
0 votes
1 answer
979 views

problem to import load data infile

I am trying to load data into mysql database form text file. LOAD DATA LOCAL INFILE 'P:\file.txt' INTO TABLE table_january FIELDS TERMINATED BY '\t' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ...
2 votes
1 answer
2k views

Out of memory in MySQL error log

What should I check to solve this error that appears in the error log? Do I need to add RAM to the server or adjust some configuration variable? I copy part of the log: 180102 10:45:53 InnoDB: ...
1 vote
1 answer
63 views

how can I see how many records have been affected by a transaction before it is committed? or how costly would be the rollback if I have to kill it?

I am using sqlwatch to monitor some of my servers and it has a job that deletes in batch from a table called dbo.sqlwatch_logger_snapshot_header I had lots of problems of locking and blocking as this ...
0 votes
1 answer
1k views

How do I change the usage of a device_fragment?

As can be seen below an index device_fragment usage is log only when it should be data only, and a log device_fragment usage is data only when it should be log only. name db_size owner ...
3 votes
2 answers
3k views

Not able to Create Database or Restore Database on the Azure SQL Managed Instance

I am trying to restore database on the Azure SQL Managed Instance using Azure blob container URL. Reference CREATE CREDENTIAL [https://zzdevbackup.blob.core.windows.net/dbbackup] WITH IDENTITY = '...
0 votes
1 answer
471 views

Heavy performance drop on Progress query, looks like based on string character inside table

I'm launching following query on a Rel 11.6 Progress database: FIND FIRST Table1 WHERE Table1.Field1 = 1 AND Table1.Field2 >= 2 AND TRUE ...
3 votes
2 answers
551 views

Specific changes to glibc 2.28 that affect PostgreSQL

I am preparing for upgrading a PostgreSQL server to Debian 10 (Buster) with the warning from Debian release notes about changes to gclibc affecting PostgreSQL in mind. The PostgreSQL wiki provides two ...
0 votes
1 answer
23 views

MySQL services fails to start successfully after copying MySQL Data Directory from another server

Purpose 1 - The running application should not be stopped and run 24*7 while backup or copy MySQL data directory (/var/lib/mysql). Purpose 2 - To backup MySQL files directly and copy on another server ...
0 votes
2 answers
2k views

MongoDB Replica Set Sync data by Copying Data Files from Another Member

I used MongoDB 3.6 and was following MongoDB documentation: https://docs.mongodb.com/manual/tutorial/resync-replica-set-member to do a full copy of data from Primary node to another mongod instance....
0 votes
0 answers
24 views

Updates and Row Level Security - No Difference Issue

We are using RLS (row level security) in SQL Server 2016, yet we're seeing no difference in effect with using BEFORE versus AFTER in our update block predicate. Using the below code as an example for ...
0 votes
0 answers
41 views

Are SERIALIZABLE deadlocks avoided or just detected?

SERIALIZABLE is the highest standard isolation level. It avoids dirty reads, phantoms,... by ensuring that, whatever happens, the ultimate result of a transaction schedule is equal to the result of a ...
-2 votes
1 answer
33 views

Best Practice for full backup and transaction log truncation [closed]

I am new to SQL Server DB. Could someone please let me know what would be the best practice to do a full backup and truncate the transaction log. If you could please let me know the strategy you are ...
0 votes
1 answer
4k views

Partitioning with AUTO_INCREMENT primary key

I am looking to partition a MySQL table by the month of the entry timestamp column (time that the row was inserted). The table in question uses an AUTO_INCREMENT column as a primary key as this table ...
1 vote
2 answers
655 views

RDS Replication Error (Apply Error 1406 / Truncation)

I have a MySQL RDS instance as a master, created a Read Replica from it, and ran some schema change operations on it. To be specific, I changed the charset and collation of all the tables and columns ...
1 vote
3 answers
55 views

Need a Role that can CREATE USER but not allowed to GRANT Predefined Roles in PostgreSQL <16

We are administrating DB in kubernetes to our customers. For each new cluster, we create a new user with CREATE ROLE and CREATE DB roles given to them, so that they can create their own databases and ...
0 votes
1 answer
793 views

Problem calling Postgres function

I wrote this function: create or replace function field_summaries(gap interval , _tbl anyelement, _col text) returns table(hour text, average numeric, minimum numeric, ...
4 votes
1 answer
2k views

Why would a query return oracle.sql.NUMBER@[hex value] in place of a numeric value?

I'm seeing some odd behavior in an Oracle 11gR2 database. When I select from a particular table, using SQL Developer, certain rows of the result set include non-numeric results in a NUMBER column (...
2 votes
2 answers
2k views

MySQL db optimization error on innodb tables

I have a database named 'mysql' which is being used on RHEL 8 server running MySQL 8.0.32. When trying to optimize the entire database using the mysqlcheck command 'mysqlcheck -o mysql' the below ...
0 votes
2 answers
400 views

How to know the locale that has been used to initialize a Postgres server?

I need it in order to create a new database with initdb with the same locale, otherwise pg_upgrade will fail.
0 votes
2 answers
27 views

PostgreSQL plan cache and variable number of arguments

Query: select * from table where col in ( values (?), (?), (?) ) The query text is generated, and number of (?) is variable and up to 10000. It works just fine, just wondering, whether Postgres ...
1 vote
2 answers
363 views

The UPDATE queries is 50x slower than its SELECT query

The UPDATE queries is 50x slower than its SELECT query. I have a table named sync_read and the have the following columns id club_id created_at user_id queue_id The table have the following Indexes: ...
0 votes
2 answers
1k views

Error on updating a field with binary values

I have a problem on emoji showing on webpage after migration to new DB Server. But I have a workaround. I will get the binary values of a certain field of TABLE1 on our OLD DB Server. Then update the ...
5 votes
1 answer
2k views

Replication stops with GTID_NEXT error after creation/drop of memory table in mysql5.6

We have recently upgraded to mysql5.6.25 from mysql5.5.x/mysql5.1.x on our mysql-cluster. Below is a brief snapshot of our architecture. Since we have upgraded and enabled gtid-mode we have been ...
1 vote
1 answer
490 views

Aggregate values over time in temporal table

Recently we started using temporal tables feature in MSSQL. Now our analytics department wants to write query aggregating data on per month basis. Let's say we have table +----+-------+----------...
0 votes
1 answer
2k views

Transfer data from MS SQL to PostgreSQL with SSIS ODBC destination

I try to sync data from MS SQL to postgres with SSIS. I configure ODBC destination using psqlodbc_12_01 driver downloaded from here My SSIS package has a single data flow task which just gets data ...
0 votes
2 answers
21 views

List of characters managed by a collation

I'm migrating to MySQL 8.0.33. We are changing character set to utf8mb4. For collation, I'm wondering among different options. I'm looking for documentation to review the list of characters that are &...
1 vote
1 answer
46 views

Can the plan cache be used to diagnose a lack of RAM?

I have learned a few good ways to diagnose a lack of RAM on a SQL Server and I am wondering if I should add the plan cache to this toolbox. A sign of lacking RAM is that the plan cache doesn't live ...
0 votes
3 answers
2k views

Huge mysqldump import

I have a 200+GB mysql dump file that I need to import into the local sql server running on my development machine. I attempted a naive dump restore using the mysql < db_backup.sql approach and ...
2 votes
1 answer
7k views

Haproxy + Mysql Lost connection to MySQL server during query

I have setup a master-slave replication and added a haproxy before them. #HA-Proxy version 1.4.24 global log /dev/log local0 log /dev/log local1 notice chroot /var/lib/haproxy ...
0 votes
1 answer
314 views

Recovering MySQL database from crashed drive - innodb tables

I have a machine that crashed that contained a VERY important MySQL crash. My automated daily backups were in one of the locations where the data was fragged. So all I have is my physical /var/lib/...
0 votes
1 answer
25 views

How to store historical correlation matrices?

Every day we calculate the correlation between ~40 different financial instruments and want to be able to store them in our PostgreSQL database. What would be the best way of storing these values? We ...

15 30 50 per page