All Questions

Filter by
Sorted by
Tagged with
0 votes
0 answers
5 views

Is it possible to automate the logic of monotonically increasing and decreasing values of numbers of integer type on a set interval in PostgreSQL?

Simple task. Using the function generate_series(1,100) or another method, you need to generate monotonically increasing and decreasing values of numbers on a certain interval, for example (10) in one ...
Cyril Mikhalchenko's user avatar
0 votes
0 answers
8 views

What is the best data type for an array like structure in SQLite?

I have a table that stores tracks and I want to add sector times for each track. Each track could have a different number of sectors, the same track will always have the same number of sectors and the ...
av4625's user avatar
  • 113
0 votes
0 answers
25 views

Economical options for long term storage of MS SQL Reporting Data (Currently in Azure SQL)

We have a reporting database in Azure SQL that is passing 3TB and we need to decide what to do before we reach the 4TB limit. Azure Hyperscale SQL is not feasible as the storage cost is more than ...
nobodyofnaught's user avatar
0 votes
0 answers
18 views

Should you include the primary key in an index, if the column is used in a condition?

Let's say I have this table: create table "Sample"( "id" bigserial primary key, "source" varchar not null, "timestamp" timestamp with time zone not ...
birgersp's user avatar
  • 163
0 votes
0 answers
5 views

javax.net.ssl.SSLException in Cassandra

I see these errors in system logs for the passive DC nodes, where the nodes in the Error messages are from the other DC which is active. In active DC I don't see such errors. Could this be ...
Solver's user avatar
  • 1
0 votes
0 answers
17 views

How to track a null text session blocking a Index Maintenance job?

We have a situation where our index maintenance job is causing more issues than improvements. I know "don't reorg/rebuild, don't do index maint". We need to as it was discussed already ...
Racer SQL's user avatar
  • 7,394
-1 votes
0 answers
21 views

QueryStore plan forcing errors

We have a weekly stored procedure that ocassionaly picks up wrong execution plan that causes much longer execution times. I've tried to force correct execution plan but still every few weeks the ...
Andrzej Błoch's user avatar
0 votes
0 answers
11 views

Is MariaDB Acquiring Exclusive Lock during Delete?

There is a Spring batch job with one delete and many inserts within a transaction with isolation level READ_COMMITTED: delete * from TABLE_A; insert into TABLE_A values (...); However, when I tried ...
bboy's user avatar
  • 3
0 votes
0 answers
28 views

Efficiently get next value after range and previous value before range

I have a series of measurements ordered ascending by a Coordinate (in millimeter), but it might as well be a timestamp. The distance between 2 measurements is irregular. I need all measurements in a ...
AlpacasInSpace's user avatar
0 votes
0 answers
4 views

The backup I took with mongodb mongodump is extremely slow

I am using mongodb 7 community version. And I have a system that inserts a lot of log documents. Since I am using the Mongodb community version, I cannot use the ops manager tool used in Mongodb for ...
emreyanik's user avatar
0 votes
0 answers
47 views

A SQL Query without Key Lookups takes 5-30 seconds to execute

I've pulled a query from our production environment due to how long it takes 5-30 seconds. Initially, the execution plan revealed several key lookups, which I've managed to eliminate by adding the ...
nop's user avatar
  • 109
0 votes
0 answers
4 views

Row read lock on write

Suppose I have a Galera cluster with 3 nodes. If I start modifying a table and a client start to read the same table from another node, I want it to wait for the write on the other node to finish. The ...
Siavoshkc's user avatar
  • 101
0 votes
0 answers
8 views

dbaascli - non-interactive

How can I use dbaascli without being prompted for SYS password and TDE password? I would like to input these values from a file. If I issue this command, I am being prompted. /bin/dbaascli database ...
Bjarte Brandt's user avatar
0 votes
1 answer
25 views

Ideal VLF size - SQL Server transaction log

Is there an ideal size for the VLFs in a transaction log. This is a system with AlwaysON and Transactional replication. I was wondering if there is any cons to creating large VLF's. Eg, lets say ...
DMDM's user avatar
  • 1,738
0 votes
1 answer
20 views

Update selected columns containing 0 with NULL

I want to update all columns named with suffix '[]' in the table geochem if they have zeros (0) with NULL. This query returns all relevant column names: select c.COLUMN_NAME from information_schema....
kitchenprinzessin's user avatar
0 votes
0 answers
11 views

Mariadb is not truncating even Innodb Undo log Truncate is On

we have configured the below settings in our configuration file. --innodb_file_per_table=1 --innodb_undo_tablespaces=3 --innodb_undo_directory=/var/lib/mysql/ --innodb_undo_log_truncate=ON --...
chwajahat's user avatar
-1 votes
1 answer
11 views

How do I partition my database by rowid and query the partitions properly?

Obligatory I'm a beginner at database management. To be specific about my situation, I'm working in SQLite3 in Python as a means to an end for now for a finance project. The table is called ...
KillerDiek's user avatar
0 votes
0 answers
3 views

Temporary table information left over on InnoDB data dictionary after a db crash while a alter table was runnig

After a database crash while the system was running an alter table command I'm getting the following message during mysqld initialization: 2024-02-25 19:58:48 7fa2f9e84880 InnoDB: Operating system ...
Vaiks's user avatar
  • 1
0 votes
1 answer
18 views

When I open XAMPP and click the start MySQL button, it gives me an error

2024-02-07 7:40:50 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 1524 2024-02-07 7:40:50 0 [Note] InnoDB: Mutexes and rw_locks use ...
user avatar
-1 votes
1 answer
25 views

Relational Algebra Practice Question

I am a bit confused about the difference between a Cartesian Product and Join in a Database using Relational Algebra. If I have a table Movies that has primary key attribute Lead_Actor, foreign key ...
Jose Serra's user avatar
0 votes
0 answers
27 views

Need help to get a server to login to SQL Server database

I created a virtual machine (VM) on Azure to host Sparx Enterprise Architect cloud-based repositories using Pro Cloud Server (PCS) https://sparxsystems.com/products/procloudserver/30-min-tour/index....
sys_eng's user avatar
0 votes
0 answers
6 views

Options for automated refresh of 300GB from on-premise to cloud?

We have a requirement to move about 300GB/day of telemetry data from an on-premise collector to a Palantir Foundry Cloud system. Updates should be incremental and occur every 10 minutes. Additional ...
Dr.YSG's user avatar
  • 399
0 votes
0 answers
25 views

Do stolen pages (as in sys.dm_os_performance_counters) report anything that sys.dm_os_memory_clerks does not?

I have been under the misconception that SELECT * FROM sys.dm_os_performance_counters WHERE counter_name LIKE 'Stolen Server Memory%'; shows how much memory the OS is stealing from SQL Server. The ...
J. Mini's user avatar
  • 137
1 vote
2 answers
32 views

Merging information from multiple rows into one row

I have three tables event, person and event_person_map event: id integer PRIMARY KEY event_name text event_date date person: id integer PRIMARY KEY full_name text email_address text event_person_map:...
Lugoom485's user avatar
0 votes
0 answers
19 views

Getting OOM when trying to change id from int to bigint in MySQL w/ percona

We have 2.5tb table with id column as int in Aurora 3 (MySQL 8.0.26). We need to change it to bigint as ids will run out soon. We tested it with pt-online-schema-change and the server crashed because ...
Nir's user avatar
  • 513
0 votes
0 answers
21 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 ...
rclouder98's user avatar
0 votes
0 answers
40 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 ...
A. Darwin's user avatar
  • 119
0 votes
0 answers
7 views

Understanding User Creation in MongoDB: admin Database vs. Other Databases

I'm in the process of setting up user accounts within my MongoDB environment and I'm looking for some clarity on the best practices for where to create these user accounts—specifically, the ...
Just a learner's user avatar
-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 ...
ab san's user avatar
  • 9
0 votes
0 answers
29 views

log_reuse_time_desc is ACTIVE_BACKUP_OR_RESTORE

After dropping database replication and subscriber, the database's option log_resue_wait_desc turned from replication to ACTIVE_BACKUP_OR_RESTORE. I should I do to return it into NOTHING value
Abdelrahman Mamdouh 's user avatar
0 votes
1 answer
21 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 ...
futium's user avatar
  • 1
0 votes
0 answers
14 views

Is this a good definition of schema migration?

I'm trying to preserve the meaning of the English word 'migration' in the definition, and I think I might be able to do that without making up a fake definition. Here goes: A schema migration is the ...
Joel's user avatar
  • 1
0 votes
2 answers
55 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 ...
ahron's user avatar
  • 793
0 votes
0 answers
14 views

Sequel Ace missing list of tables component

I am using Sequel Ace (version 4.0.13 on Mac) to access a database. There used to be a list of all the tabels in the database in a component on the left side that is now missing. I cannot figure out ...
JayG's user avatar
  • 1
0 votes
0 answers
23 views

Unresponsive restore process for log shipped db having memory optimised tables

Log shipping documentation has a caution: https://learn.microsoft.com/en-us/sql/database-engine/log-shipping/about-log-shipping-sql-server?view=sql-server-ver16 Known issue: For databases with memory-...
variable's user avatar
  • 3,541
0 votes
2 answers
40 views

Point in time Postgres restore

I was trying to do Point in Time Restore, I had my placed by previously backed up WAL file in my directory to where my restore command (/var/lib/postgresql/16/main/pg_wal/wal_archive) in postgres.conf ...
Руслан Пилипюк's user avatar
1 vote
1 answer
62 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 ...
Marcello Miorelli's user avatar
0 votes
1 answer
15 views

Restoring incremental backup of Postgres

I have restored basic backup successfully of Postgres. However, after that I have tried to restore incremental backup of Postgres(it was a couple of write to test table), and it had a couple of WAL ...
Ruslan Pylypiuk's user avatar
0 votes
1 answer
17 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 ...
Racer SQL's user avatar
  • 7,394
0 votes
1 answer
15 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 ...
Vijay Singh's user avatar
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 &...
yaki_nuka's user avatar
  • 141
0 votes
1 answer
16 views

How to cancel vacuum process in AWS RDS PostgreSQL

Is there a way to cancel an automatic vacuum in rds postgresql? When running select pg_cancel_backend(...); select pg_terminate_backend(...); with a user that has the rds_superuser role an error ...
Vasileios Giannakidis's user avatar
-2 votes
0 answers
21 views

Which is the right choice for an app dating ScyllaDB or MongoDB?

How does ScyllaDB compare to MongoDB in terms of handling semi-structured data and schema flexibility? Are there any third-party solutions or workarounds needed to achieve similar functionality? How ...
Farshad's user avatar
  • 97
-1 votes
1 answer
21 views

I want to migrate a oracle database from one server to another server using datapump export utility.could you please explain it step by step

I am new to oracle and also migration but wants to learn how to migrate a oracle database from one server to anotherserver using datapump export utility.please help me with step by step explaination.
jyothi d's user avatar
0 votes
1 answer
34 views

Postgres: how to insert and delete many records and to not run out of space

I have a PostgreSQL installation deployed in Kubernetes (with the CloudNative operator) and allocated a 25GB volume for it. My architecture involves several microservices interacting with various ...
Tertium's user avatar
  • 141
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 ...
Mike Kay's user avatar
0 votes
2 answers
26 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 ...
Mikhail Boyarsky's user avatar
3 votes
2 answers
241 views

What is the effect of using different COLLATE values in a WHERE clause?

I read the documentation 'Using COLLATE in SQL Statements' https://dev.mysql.com/doc/refman/8.0/en/charset-collate.html, but it doesn't say much about the effect of using different COLLATE values to ...
Computist's user avatar
  • 163
0 votes
0 answers
15 views

Multiple resultset from mariadb procedure

I am trying to return multiple resultsets from (phpmyadmin) mariadb procedure but am failing. For example I have two tables Entities and Relations and for a test I created a procedure to select ...
user1806687's user avatar
0 votes
0 answers
15 views

Error mysqlimport loading to symlink table

Getting ERROR 1030 (HY000): Got error 168 - 'Unknown (generic) error from engine' when trying to import a .sql file produced via mysqldump. Running MySQL 8 on a Ubuntu 22.04 system. chris@chris-X1C6:/...
Chris's user avatar
  • 181

15 30 50 per page
1
2 3 4 5
2056