Newest Questions

1 vote

1 answer

13 views

I'm working with a Firebird 2.5 database and recently I caught a "wrong practice" which was using binary blobs (sub type 0) to store big texts. Even though there is not actually a problem ...

0 votes

0 answers

14 views

I’m using CNPG Postgres with 2 node availability. There’s a primary and secondary. The primary uses synchronous replication. I am using Change Data Capture with debezium. It creates a replication slot,...

0 votes

0 answers

4 views

I am trying to configure Oracle 19c EE to use Softhsm2 for TDE. I have created the wallet folder and can see "ewallet.p12" file in it. I have initialized one token and can see it. The ...

0 votes

3 answers

17 views

I am trying to do a daily backup of a MySQL DB hosted on Stackhero (on Heroku) to a Google Cloud Storage bucket. We need to backup tables individually so that if data is corrupted / lost in a specific ...

0 votes

1 answer

26 views

I have an Oracle Database running in a production environment, and it’s currently under load. I need to add a new datafile to an existing tablespace. Is it safe to do this operation while the database ...

-1 votes

0 answers

36 views

I forgot which textbook told me to add suffixes. Is this still recommended best-practice? Using PostgreSQL FWIW

2 votes

1 answer

148 views

I have a SQL Server database that is in SIMPLE recovery model and every now and then, the transaction log is growing, despite its actual usage being well below the capacity of the file. Below is a ...

-1 votes

2 answers

52 views

when I'm querying select * from sys.dm_hadr_database_replica_states I see 11k seconds ( 3hrs ). But when I go to the AOAG dashboard and select the "estimated data loss time" column, it ...

0 votes

0 answers

21 views

I tried installing Oracle 12c on my desktop. It progressed to 94%, but an error message was output. [INS-20802] Oracle Database Configuration Assistant failed. When I opened the log file, it contained ...

0 votes

1 answer

51 views

I was looking into some deadlock logs on my system today and saw one I didn't understand - deadlocks on Sch-M and Sch-S locks. The documentation said it had to do with schema definition changes, ...

0 votes

0 answers

11 views

In shorts cassandra_2 keeps failing to start because it can't resolve cassandra_1 as its CASSANDRA_SEEDS. this is my docker stack yml services: cassandra_1: image: cassandra:5.0.5-jammy ...

6 votes

1 answer

978 views

While reading the docs here and there on SQL Server, I saw this request: SELECT ROW_NUMBER() OVER(ORDER BY name ASC) AS Row#, name, recovery_model_desc FROM sys.databases WHERE database_id < ...

0 votes

0 answers

23 views

I'm running into unexpected behavior when trying to use prepared statements with TimescaleDB through PgBouncer in transaction pooling mode. According to the Psycopg3 docs on prepared statements and ...

0 votes

0 answers

22 views

We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We have enabled the error, general & slow logging in the config file, but the logs are not being written even in case of ...

0 votes

1 answer

12 views

I have a 24-node cluster that receives 400k to 600k ops/s at a latency of approximately 15ms-20ms at the 99th percentile. I haven't found the reason why after restarting the nodes, writes increase to ...