All Questions
2,439 questions
0
votes
1
answer
22
views
Adding a db to an AG - full backup required prerequisite, can I use that backup for the seeding?
I had to take a db out of the AG and put it in SIMPLE recovery model to do some high volume data copying. Putting the db back into the AG using the wizard (after setting recovery back to FULL), it ...
- 85
0
votes
1
answer
19
views
How can I replicate transactions one by one in mysql?
I have one source server and one replica server. And I set source_delay 30mins, replication is gtid based, mysql version is 8.0.24
If I accidentally drop table A, Can I apply transactions just right ...
- 1
0
votes
2
answers
75
views
Why can't I restore my SQL-Server database? [closed]
I have a bunch of files: two backups and a list of transaction logs.
The backups are called:
FB20241125_233033.bak
FB20241126_233040.bak
(The filenames correspond with the date/time the backups have ...
- 377
-1
votes
1
answer
21
views
Website Content Not Displaying Correctly in Vietnamese After Restoring Database from Backup [closed]
I used the Scheduled Backups feature in Virtualmin to back up my website. My hosting setup used the latest version of Virtualmin on a VPS running Ubuntu 22.04. Unfortunately, my VPS expired because I ...
- 1
0
votes
1
answer
32
views
Where can I find more detailed MySQL deadlock logs?
We have a MySQL database in AWS RDS that was migrated recently from 5.7 to 8. One of our microservices running in ECS executes bootstrapping code at launch to iterate through a large list of table ...
GS-Scooter
0
votes
0
answers
11
views
Can you downgrade provisioned iops on gp3 for postgresql RDS?
Doing an occasional analysis on a postgreSQL RDS instance with gp3 storage.
Running out of provisioned IOPS.
Is it possible to temporarily raise the provisioned IOPS limit? e.g. just for a day or ...
- 347
0
votes
0
answers
15
views
Postrgresql Logical replication causing very high buildup of log files even though replication slots are active [ AWS RDS postgresql 16.1]
I have two rds instances and have set up logical replication between them [ publisher subscriber]. for the 3-4 days everything was working fine wal files were getting cleared but suddenly when the ...
- 1
0
votes
1
answer
31
views
Amazon Aurora RDS - invalid undo record
Context
Aurora RDS, MySQL 8.0.mysql_aurora.3.05.2
Problem
The writer instance is constantly cycling. In the AWS RDS console, under Logs & events for the writer, I see
Attempting to restart the ...
- 121
1
vote
0
answers
61
views
what server events I can use to "do something" on before restore of a database?
on this page: DDL Events you can see a complete list of the ddl events.
these events are server or database things that happen - like - create a database, alter a sequence, update statistics, create a ...
- 16.6k
0
votes
1
answer
41
views
Setting Synchronous_commit to off in Postgres in AWS RDS
0
We are experiencing significant delays in our PostgreSQL database due to LWLock:WALWrite and LWLock:WALSync waits, which are causing commits to pile up.
To address this, we have undertaken several ...
- 1
0
votes
1
answer
69
views
how to get the location of the backup too? you can use multiple columns pivoting or any other way!
I got this great query that shows the latest backup for each existing database.
SELECT
M.name,
[Recovery Model] =
M.recovery_model_desc,
[State] =
M.state_desc,
[Last ...
- 16.6k
0
votes
1
answer
69
views
sql server backups - what is physical_block_size?
we have recently changed the file server that is the repository (the place where the backups are stored) server .
I noticed the hardware specially IO is much better backup take shorter to finish, ...
- 16.6k
0
votes
1
answer
26
views
Analyzing sql query performance issues in mysql
I am new to mysql, I have few questions in regards to query performance tuning. (Note- its version 8.0.32)
I understand we use "explain analyze" to see the execution plan and it shows the ...
- 11
0
votes
0
answers
22
views
Granting Permissions To as User in Mysql
I created user-a that has the following grant privileges
SHOW GRANTS FOR 'user-a'@'%';
'GRANT INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, ...
0
votes
0
answers
15
views
MySQL 8.0 connecting to AWS RDS MySQL 5.7 with SSL/TLS CA authentication fails weirdly (Error code MY-002026)
When trying to establish TLS encrypted replication between a replication source living in AWS RDS on version 5.7.44, and a replica living in a VM on-premise on version 8.0.39, I keep getting an error:
...
- 1
0
votes
0
answers
94
views
How does RDS Postgres OldestReplicationSlotLag metric correlate to replication slot Log Sequence Number lag?
We run a Postgres 14.9 database via RDS Aurora Serverless. We have a logical replication slot consumed by a service (Fivetran) every 15 minutes.
We noticed this behavior where the reported ...
- 51
1
vote
1
answer
48
views
Collation difference in PostgreSQL on AWS RDS and local machine
I have an issue with collation in PostgreSQL when sorting a result set. We use AWS RDS PostgreSQL, and we want to sort query results in a specific way. Locally, everything works perfectly on my laptop ...
- 119
0
votes
1
answer
77
views
SSMS's GUI and dbatools produce different scripts for restoring databases in full recovery mode, what practical differences do they have?
I have a database in full recovery mode without log backups. Don't say it: I know. It fortunately isn't in an environment that I care about.
Today, disaster struck and I tried to use dbatools to ...
- 801
2
votes
1
answer
24
views
Primary Key data type suggestion for MySQL for an application that depends in a external system. unsigned bigint vs varchar data type in primary keys
I'll give you some context and then ask my question.
I'm building a database model for an ecommerce application. This application needs to communicate to another system (ERP system) to get product, ...
-1
votes
1
answer
41
views
re-seed availability group database
I am trying to fix an issue with a 2 node AG that failed over causing all sorts of problems. We were left with no choice but to remove the secondary database from the AG to get the DB working. Now I ...
- 255
0
votes
0
answers
41
views
How can I tell if SQL Server is RDS, RDS Custom, or installed manually on a VM (EC2)?
I only have direct access to the SQL Server. How can I check if it's RDS, RDS Custom (which allow to connect to the VM), or installed manually on a VM (EC2)?
- 801
0
votes
1
answer
34
views
Postgres server killed by OOM during pg_restore
I'm running Postgres 16.3 in a container with a 1 GB memory limit. When I run pg_restore with a dump file that's about 1 GB, the server will be killed by OOM and I'm guessing that this is from the ...
- 121
0
votes
0
answers
49
views
when was the last time I restored a database from a database snapshot in the current server?
I generally create a database snapshot, depending on circumstances - in order to compare data before and after changes, or for an easy way to roll back changes, like for instance, an alter table.
I ...
- 16.6k
0
votes
1
answer
85
views
How can high severity alerts be configured in Amazon RDS SQL Server?
Per the RDS documentation,
SQL Server Agent alerts and operators aren't supported.
But on any sensible SQL Server, you really want these for the high severity alerts.
So, I'm here to ask: How can ...
- 801
-1
votes
1
answer
83
views
Size of MDF file is not getting updated after adding transactional log file(s) in SQL 2022
I am working on migration of SQL Server from SQL 2016 to SQL 2022.
I have a process where after database is restored (to "Standby / Read-Only" state) from Full tape (from a third vendor), I ...
- 251
1
vote
0
answers
45
views
How can I improve the performance of a "cold" (first) run of this seemingly simple query?
I'm working on a specific query which has been slowing down an application for some time. The table in question has about 55 million rows.
A "cold" (first) run of this query usually takes ...
- 193
0
votes
0
answers
41
views
Xtrabackup restore failing
I was running an xtrabackup full backup restore, however while running restore; I’m getting below error message:
Any idea what’s wrong here? There’s no tablespace SDI or how can I avoid this error?
[...
- 362
0
votes
1
answer
153
views
RDS MySQL not using NVMe instance storage - no benefit of "Optimised Reads"
I am load testing various RDS instances trying to optimise db price/performance
I had seen this doc https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-optimized-reads.html and it sounded like ...
- 528
0
votes
0
answers
22
views
RDS Mysql replica cdc performance
I have a RDS Mysql which has high read/write volume. ~10k IOPS on an average and peaks up to 16k IOPS.
I have another RDS mysql replica of the main. We are using this replica to capture cdc logs and ...
0
votes
0
answers
46
views
How can I find what's eating so much space in Postgres in AWS RDS Aurora?
Essentially when I run
SELECT
pg_size_pretty(SUM(pg_total_relation_size(relid))) as total_size,
pg_size_pretty(SUM(pg_indexes_size(relid))) as index_size,
pg_size_pretty(SUM(pg_relation_size(...
- 101
0
votes
1
answer
38
views
Help with creating postgres databases with - in the name
I'm currently trying to script some migration of databases on a server.
As part of this process I will need to create a new database with a similar name to the existing database.
Whilst I have this ...
- 101
2
votes
1
answer
69
views
SQL Server Database I/O Consistency Error Disaster Recovery
I have a corrupted SQL Database that is inacessible by any means. It is to the point that simple commands, like USE MyDatabase, won't execute.
The error I get is: SQL Server detected a logical ...
- 23
0
votes
0
answers
192
views
How to grant SYSTEM_VARIABLES_ADMIN permission to master MySQL user or rds_superuser_role from MySQL Workbench hosted on RDS?
Using MySQL 8.0.39 on an AWS RDS insteance, for troubleshooting purposes we want to be able to Enable/Disable the global general_log setting , being able to turn it on and off easily and quickly from ...
- 9
1
vote
2
answers
62
views
Does regular truncate & insert hurt performance?
We have a large (5 TB) PostgreSQL 15 RDS that acts as a data warehouse, data comes in through regular pipelines and then ~20 users run analytic queries on it.
Our infrastructure people have access to ...
- 559
0
votes
0
answers
11
views
How to see number of storage volumes on AWS RDS MySQL?
According to https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html, for "400–65,536 GiB" storage MySQL RDS will use "Number of volumes provisioned = 4".
I have ...
1
vote
2
answers
101
views
How to work around "row is too big" for role definitions without recreating the database?
I am running into the row is too big (ERROR: 54000: row is too big: size 9976, maximum size 8160) error in Postgres related to role permissions on a couple of my instances. I understand that after ...
- 11
1
vote
1
answer
32
views
Why free storage space dip on MySQL replica?
I have AWS RDS MySQL 8.0.36 primary-replica setup. I see this storage free space dip on the replica only. Any ideas why it happened?
-1
votes
1
answer
124
views
How to restore database (daily) with multiple bak files using a T-SQL script?
I am trying to restore a database on a daily basis from multiple bak files that I get from a vendor.
I tried using GUI, and it worked.
I basically followed the same procedure as shared on the this ...
- 251
2
votes
0
answers
76
views
AWS RDS PostgreSQL -
We have an AWS RDS PostgreSQL (v14.10) instance running on a db.t3.micro instance. Randomly throughout the day (some days more than others), our .NET Core application starts failing with the following ...
- 121
0
votes
0
answers
38
views
postgresql 16 filesystem snapshot in combination with pit recovery "invalid checkpoint record"
we are migrating many deployment to a kubernetes cluster.
I'm currently in the process of testing and documenting the restore process for our postgresql databases.
In our legacy environment we did/do ...
- 23
2
votes
1
answer
157
views
How to Backup and Restore a MariaDB database with Master and Slave replication configured?
I have a MariaDB Master and Slave server setup for replication. Both MariaDB servers are in the same datacenter and local network.
I want to do at least a daily full backup and incremental every 15 ...
0
votes
0
answers
31
views
MSSQL on AWS: remote user unable to establish connection via SSMS
Newly created MSSQL 2017 SE instance, using SQL authentication. I am able to connect to it with no issues via my corporate VPN. Overseas user on VPN is unable to connect, getting this error from SSMS:
...
- 143
0
votes
0
answers
29
views
How to take backup specific tables in specific schemas in Postgresql via PgAdmin?
I try to backup my test database's 3 schemas and some important tables inside it.
For example:
schema a: t1,t2,t3
schema b: t5,t10
schema c: t15
There are also sequences, functions etc. ofc.
Taking ...
- 127
0
votes
0
answers
61
views
server side trigger for after restoring database
there is a brilliant script to create a server side trigger on an event of a create database.
here is the script:
IF EXISTS (SELECT NULL FROM sys.server_triggers WHERE name = 'ddl_trig_database')
...
- 16.6k
0
votes
0
answers
41
views
How can I avoid downtime for AWS RDS SSL/TLS certificate rotation?
I have some production databases in RDS for which I have active connections and writes every minute. The current server certificates are expiring on 22nd August. I tried to update one, it takes 5 ...
- 101
0
votes
1
answer
525
views
Operating system error 1326(The user name or password is incorrect)
I have been working with mapping drives inside sql server.
I mapped something similar to this:
EXEC XP_CMDSHELL 'net use y: "\\my_server\Initialed Folders\MM" @@__password__@@ /User:...
- 16.6k
0
votes
1
answer
31
views
What is the function of the folders rdbms and tnslsnr on Oracle database
Question
What is the function of the folders rdbms and tnslsnr on Oracle database ( Windows ) ?
The issue with the folders rdbms and tnslsnr is that they are getting larger and larger 40gb+, and ...
1
vote
1
answer
203
views
How to copy “Standby / Read-Only” database from one VM to other VM?
I am trying to upgrade from SQL 2016 to SQL 2019 (as SQL 2016 will be out of service in July 2016) in a different VM (Virtual Machine - Windows Server 2022), so I want to copy one database to other ...
- 251
0
votes
0
answers
24
views
Record change broke the application
We have a database application that had a record changed in one table [RPI] that was referenced by another table [ERP] and now the entire application won't move forward or load anything from the RPI ...
0
votes
0
answers
23
views
Failed to prune sessions: no pg_hba.conf entry for host, although connection works fine
I am using an AWS RDS Postgres database and Typeorm to connect to the database. I have also configured the RDS database to require a SSL connection. I pass the CA certificate to the database like this:...
- 101