1,647 questions
3
votes
2
answers
76
views
Autovacuum causing deadlocks with ALTER TABLE RENAME on Aurora PostgreSQL 14
I'm working with COTS software, so changing the software is difficult.
The software has a process:
Creates a temporary table
Adds a bunch of data
When finished, renames the table
ALTER TABLE ...
- 1,269
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 ...
1
vote
1
answer
89
views
Different versions of pg_stat_statements on different databases on the same instance?
I'm writing some code to capture some query info in aurora postgres. When I take data from pg_stat_statements view from 3 different databases, I can see different columns returned.
Turns out the ...
- 86
0
votes
1
answer
62
views
MySQL Aurora slow COUNT query
I have a COUNT(*) query that is really fast in several DB's, but is really slow on MySQL AURORA:
I can't seem to figure out why. First I thought it was because it went the MEMORY went over the 4MB, ...
- 486
0
votes
1
answer
98
views
Query performance degradation under multiple concurrent requests
Environment:
Database: AWS Aurora MySQL (8.0)
connector: software.aws.rds,aws-mysql-jdbc || software.amazon.jdbc,aws-advanced-jdbc-wrapper
Application: Spring Boot (3.5.0)
Java Version: 21
I'm ...
4
votes
2
answers
172
views
Catastrophic query planning, non-use of index in MySQL 8+
I have a legacy Drupal 7 site that is used strictly internally. It's replacement is under active development, but in the meantime it is using Aurora2, MySQL 5.7 compatible and is in very expensive ...
- 549
0
votes
1
answer
448
views
Why do the pg_temp_### and pg_toast_temp_### schemas keep growing, and why are they not being dropped or released automatically?
We've observed a significant number of temporary schemas with names like pg_temp_* and pg_toast_temp_* accumulating in both the Sandbox and Dev environments.
Why do the pg_temp_### and pg_toast_temp_##...
0
votes
0
answers
192
views
Spring Boot with mariadb-java-client, AWS JDBC Wrapper, and HikariCP: PreparedStatement executeBatch Only Works with Single Statement in Batch
I have a Spring Boot application that connects to an Amazon Aurora MySQL-compatible database. The setup uses the MariaDB JDBC driver, the AWS JDBC wrapper, and HikariCP for connection pooling.
My code ...
- 168
-1
votes
1
answer
130
views
INSERT INTO @Tbl issue on Babelfish for Aurora PostgreSQL with SQL Server Compatibility (Babelfish 4.4.0)
DECLARE @Tbl TABLE
(
ID bigint,
Seq bigint identity(1,1)
)
DECLARE @sqltest nvarchar(max);
SET @sqltest = 'SELECT 1';
INSERT INTO @Tbl (...
1
vote
0
answers
105
views
Replication: new Aurora MySQL read replicas aren’t picked up by TypeORM after autoscaling
Environment
TypeORM: 0.3.20
@nestjs/typeorm: 10.0.2
Node.js: v22.13
Database: AWS Aurora MySQL 8.0 (provisioned cluster with autoscaling read replicas)
Description
We have a single “read” endpoint ...
- 169
3
votes
1
answer
98
views
Downscaling AWS RDS Aurora-MySQL instances
We use Terraform to manage AWS resources. I recently downscaled RDS Aurora-MySql8 cluster (one reader, one writer in different AZ) from r5 to t3 instances. I try to figure out from AWS event logs ...
- 1,843
0
votes
1
answer
78
views
MySQL Aurora (8.0.mysql_aurora.3.07.1) Cannot Alter or DROP Table "ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction"
MySQL Aurora (8.0.mysql_aurora.3.07.1)
Cannot run Alter table or DROP Table commands
Getting
"ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction"
What I already did ...
- 506
0
votes
1
answer
281
views
AWS RDS Aurora (postgres engine) upgrade from 13.12 to 14.17
I'm trying to upgrade my engine version from 13.12 to 14.17.
Below is my Terraform code:
resource "aws_rds_cluster" "aurora" {
cluster_identifier = local.env_config....
- 133
0
votes
0
answers
76
views
Unexpected restart of Aurora Mysql
We are experiencing repeated instability with our Aurora MySQL instance db.r7g.xlarge engine version 8.0.mysql_aurora.3.06.0, and despite the recent restart being marked as “zero downtime,” we ...
0
votes
0
answers
146
views
Entire data is not ingested by AWS Bedrock
I am trying to create a vector data using AWS Bedrock. I am passing a CSV file(stored in S3). While ingesting data, some of the data is randomly dropped by AWS. The csv file has 1000 rows while the ...
