7,832 questions
0
votes
0
answers
13
views
How to increase undo tablespaces on aws rds mysql innodb_undo_tablespaces [migrated]
I have the issue that my undo history keeps growing and purging does not catch up.
This number constantly increases:
SELECT count FROM information_schema.innodb_metrics WHERE name = '...
- 14.4k
0
votes
0
answers
68
views
AWS RDS MariaDB query surprisingly slow on single value result
I have the following tables:
create table account_transactions
(
id int auto_increment primary key,
account_id int not null,
amount ...
- 1,442
0
votes
1
answer
63
views
Connection to AWS RDS with Secret manager creds from python SQL Alchemy failed with no pg_hba.conf entry for host ... no encryption
I created an AWS RDS in CDK using secret manager credentials:
rds.DatabaseInstance(
self,
id=resource_name,
instance_identifier=resource_name,
...
- 3,707
Best practices
0
votes
1
replies
60
views
Doing password rotation with spring-boot
I'm a DevOps engineer trying to implement password rotation for multiple services, some are Python, some Node but most are Kotlin and are using spring-boot, Our passwords are encrypted outside AWS and ...
- 1,708
1
vote
1
answer
127
views
Exporting Incremental RDS Snapshot into an S3 Bucket
I would like to ask two questions;
1- if RDS snapshots are incremental when we exported the incremental snapshot in to s3 via ExportTask will it be the only partial data or full data.
2- When data is ...
- 13
Advice
1
vote
3
replies
51
views
Safe to run "VACUUM FREEZE" on template1 or template0 databases in postgres?
I run periodic VACUUM FREEZE on my main database to avoid aggressive vacuuming during busy times, wondering if it's safe to run freeze on template databases too before they reach the threshold (200M ...
- 7,577
1
vote
0
answers
24
views
How to capture IAM user identity in Aurora MySQL audit logs when connecting through AWS TEAM elevated access?
I’m using TEAM elevated access for AWS in my organization to temporarily access an Aurora MySQL cluster.
TEAM provides database access through a tunneled MySQL session using a generic database ...
Advice
1
vote
2
replies
78
views
AWS How to identify/recommend the instance type for an RDS?
I am currently working on recommendation for aws rds instance type recommendation. We have identified the instances which are underutilised.
I want to know how to recommend a better version of rds ...
- 29
0
votes
0
answers
55
views
Application running in Docker containers the application restarted using Amazon RDS Aurora MySQL for the database and experiencing out-of-memory issue
UncaughtException: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap ...
0
votes
2
answers
87
views
AWS Lambda inside VPC cannot connect to RDS MySQL (timeout)
Background
I'm building a Lambda function (Node.js 20 runtime) that connects to an Amazon RDS MySQL database within the same VPC.
Both the Lambda and the RDS instance are deployed in private subnets.
...
0
votes
0
answers
132
views
Sudden CPU spike on AWS RDS (PostgreSQL) after running fine for the entire last month
I encountered an issue where our AWS RDS (PostgreSQL) instance suddenly experienced a high CPU spike, even though it had been running normally for the entire previous month.
Currently, the system is ...
- 13
1
vote
1
answer
77
views
PSQLException: ERROR: buffer is pinned in InvalidateBuffer on CREATE DATABASE command
Working with Amazon RDS - PostgreSQL 16, my Java application started receiving the following error when trying to run the CREATE DATABASE command
Caused by: org.postgresql.util.PSQLException: ERROR: ...
- 2,218
0
votes
1
answer
47
views
npm drizzle-kit and AWS RDS: Error: getaddrinfo EAI_AGAIN
I don't seem to be able to push my configuration to RDS
// package.json
"drizzle-kit": "^0.31.5",
// drizzle.config.ts
import { defineConfig, Config } from 'drizzle-kit';
const ...
- 310
1
vote
0
answers
75
views
Mysql ConnectionAttempts increased on AWS RDS after dotnet 6 update to 8
After updating our Dotnet API from dotnet 6 to 8 the connection-attemps on AWS RDS increased significantly (see attached picture).
The API is running in a docker-container.
We use a MYSQL RDS instance ...
- 34
1
vote
0
answers
102
views
Postgres stored procedure doesn't return if running longer than 5 minutes
I have the following simple Postgres stored procedure created that just sleeps a number of minutes as passed in to call:
create procedure sleep_test(delay_minutes numeric)
language plpgsql
as
$$
...
- 23