Questions tagged [amazon-rds]
Amazon Relational Database Service is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.
979 questions
2 votes
1 answer
90 views
RDS - connect to HA Secondary without joining domain
I am attempting to connect to the secondary replica in an HA RDS cluster. Usually I do this by connecting to hostname.vpc.local with the master user SQL Auth credential. Today I restored an HA cluster ...
- 5,951
0 votes
1 answer
44 views
impdp failing in AWS RDS - seems RDS internal package (RDS_SYS_TRIGGER_UTIL) is missing or invalid?
In my job we have 3 Oracle database servers, hosted in AWS RDS - one for development, one for testing and one for production. We have a years-old bash script that uses expdp and impdp to export ...
- 101
0 votes
1 answer
66 views
Postgres tool to help with vacuum full when low on space
I'm often in the situation where I would like to "vacuum full" a table but there's not enough space left to duplicate data to remove bloat. That's because, to vacuum, a duplicate table is ...
- 103
0 votes
1 answer
77 views
In PostgresQL 16, how to detect where "Large Objects" are used?
I have a large database that I need to migrate from postgresql 16 to 17. But when programming a logical replication, I receive a message saying that a large object has been modified. But I don't know ...
- 111
1 vote
1 answer
48 views
RDS master user shouldn't be able to query msdb
I don't like working in RDS. I can't even query sysjobschedules with my Master user This data isn't completely gated off from me. For example I can see the schedule data in the job management UI. I ...
- 5,951
1 vote
1 answer
91 views
SQL Server Shrinkfile Stops at 76% Due to LOB and System Data—Is Partial Shrink Possible?
Problem: I am working on a SQL Server 2019 database where I deleted a large amount of user data (~500 GB). After deletion, I attempted to shrink the data file using: DBCC SHRINKFILE (N'web_Data', ...
1 vote
0 answers
75 views
AWS MYSQL RDS db instance freezes
Ok I'm facing a real crazy issue, I usually connect through AWS VPN Client Endpoint normally and I can access my database. Today I tried and TablePlus just froze, checked if I'm connected through ...
Mohammed Elbaz
3 votes
1 answer
154 views
500 million is becoming a horrible negative number on replicas
I need some assistance understanding what looks like a corrupted value in replicas. Here's the scenario: 1 primary database, 8 read replicas. Database is MySQL, deployed with Amazon RDS. There is a ...
- 89
0 votes
0 answers
33 views
hourly spikes in average active sessions on MySQL on RDS
I'm getting very odd behavior where there are much longer waits on a MySQL server running on RDS every hour on the hour. Average Active Sessions goes way up as well as waits, etc. It is running RDS ...
0 votes
0 answers
30 views
Is it possible to use RDS for Postgres read-replica only in direct-connection?
I couldn't find answer to this question in the official docs, so hoping it isn't a stupid question. I have RDS for Postgres which is being used by multiple micro-services. One such service is the BFF ...
- 101
0 votes
1 answer
292 views
Why does MySql in AWS RDS have periodic "Connect Timeout expired" errors?
This one is bizarre because the database itself is never under any significant load...logs show CPU usage averaging around 5-10%, Memory usage is low, 10-20%, there's only ever 20 or so connections ...
- 103
0 votes
1 answer
268 views
Best way to achieve HIPAA compliance in a PostgresSQL for Patient Data
So basically we are designing an application to store PII patient data, we are currently storing by encrypting the data in AWS RDS using an KMS key, what i mean by that is encyrpting the actual data ...
0 votes
0 answers
70 views
Amazon RDS - Database created by a different user is not accessible by the RDS ADMIN user
We are in the middle of a project where I created a RDS instance and after setting everything up, I created a Login. I addedcreate database permissions to this login, and today when the user created a ...
- 7,558
0 votes
1 answer
94 views
RDS postgres slow read IO
We are running postgres 14.12 in rds and expirence very slow IO reads.. around 30MB/s on index scans. we can't figure out what might be the cause of it. any ideas to what we should / could check? ...
- 1
0 votes
1 answer
393 views
Oracle alert.log "Thread 1 cannot allocate new log" on AWS RDS
I migrated from an on-premise Oracle XE to Amazon RDS. It's running on a T3.medium server with gp3 storage (200 GB/12000 IOPS). Almost every fifth minute the alert.log says like this: "Thread 1 ...
- 133