2022 Developer Survey is open! Take survey.

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.

Filter by
Sorted by
Tagged with
1 vote
0 answers
14 views

Why is this DELETE causing my Aurora MySQL 5.7 instance to crash?

I have a large table (2.3TB of data, 1.9TB index, 33 billion rows). A user recently executed a DELETE statement (32k rows) against the table, which caused the server to eat up all memory and then fail ...
user avatar
0 votes
0 answers
16 views

How to reduce disk usage on a RDS Postgres instance after a significant increase following a VACUUM(FULL, ANALYZE, VERBOSE)?

We have a Postgres 13 database that has been slowly but steadily increasing its disk usage on Amazon RDS. Right before a VACUUM(FULL, ANALYZE, VERBOSE) command it was ~300 GB, but afterwards it jumped ...
user avatar
1 vote
0 answers
11 views

Dbeaver restore database Error 1277 you need the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege for this operation

I'm attempting to import a .sql file to restore a database(hosted on AWS RDS) however this error keeps coming up. ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER, ...
user avatar
0 votes
0 answers
11 views

How to clear AWS RDS Aurora MySQL local storage?

I got a warning message about running out of AWS RDS local storage. The free storage capacity for DB Instance: {MY INSTANCE NAME} is low at 2% of the provisioned storage [Provisioned Storage: 157.36 ...
user avatar
1 vote
2 answers
30 views

MySQL RDS: Drop formerly huge table without freezing DB?

I am using MySQL 5.6 in AWS RDS. I want to drop a table that used to have 8 billion rows. Hearing that dropping a large table can freeze the database, I instead chose to delete the rows using a loop. ...
user avatar
0 votes
0 answers
10 views

why MySQL is trying to resolve '**ip**.client.mchsi.com'?

I have a mysql instance on Amazon RDS and recently I'm receiving this error message in: error/mysql-error-running.log. [Warning] [MY-010058] [Server] Hostname '<ip>.client.mchsi.com' does not ...
user avatar
  • 1
0 votes
1 answer
29 views

php mysql aggregating/ combining queries to reduce db connections

I have a use case where a large number of clients are reporting their operational states every minute using an HTTP connection to a php script. For each client, I have a row in a mysql table with ...
user avatar
  • 101
-1 votes
0 answers
6 views

AWS Postgresql RDS to OCI Postgresql Database Real Time Replication

Good day, our organization is planning to have a DRP cloud provider which is OCI. Is it possible to implement the REAL TIME syncing of data from AWS PostgreSQL RDS to OCI PostgreSQL Database?? If yes, ...
user avatar
0 votes
0 answers
63 views

AWS RDS database replication replicates everything regardless my parameters group

I have a database in RDS that I want to replicate. I made a parameter group where I described which tables I want to be replicated. I applied it to my replica, and still it replicated the whole ...
user avatar
0 votes
1 answer
25 views

fivetran replication from PostgreSQL (connector Broken with WAL log error)

PostgreSQL RDS instance having physical replication to multi-AZ, same instance also enabled for Fivetran replication copying data to BigQuery using WAL logical test-decoding. Multiple issues here: ...
user avatar
0 votes
0 answers
39 views

How to understand and decrease Innodb_rows_read.avg (RDS INNODB)?

I am looking to understand what's behind Innodb_rows_read value and how to decrease it. For some unknown reasons my RDS server has been over 90% of CPU for more than 5 days and after investigation, ...
user avatar
  • 109
0 votes
1 answer
33 views

How to restore a RDS Postgres instance from a snapshot exported to S3?

Amazon RDS Postgres database are backed up as snapshots automatically. Because of the high storage costs ($0.095 per GB-Month), I want to move them to S3 (Storage Class: Glacier Deep Archive: 0.00099 ...
user avatar
0 votes
0 answers
25 views

LOAD DATA LOCAL INFILE - server's temporary file storage

While reading docs, I came across following: When LOCAL is used, the client program reads the file and sends its contents to the server. The server creates a copy of the file in the directory where ...
user avatar
0 votes
0 answers
42 views

Refresh materialized view on Postgresql 11 on RDS

We are currently on Postgres 11.13 on AWS RDS. I am trying to create a materialized view that takes about 6-7 minutes to run. What is the best way to keep this MV mostly up to date? I was thinking of ...
user avatar
  • 101
0 votes
1 answer
26 views

Is rdstopmgr an AWS RDS user?

I am running postgres on AWS RDS. RDS creates some users on its own, such as rdsadmin and rdsrepladmin. I am familiar with these However, I also see rdstopmgr, when I query postgres for roles. Google ...
user avatar
0 votes
0 answers
43 views

How to prevent sequences from getting out of sequence?

I have several sequences for tables (dynamic information and crosswalks) that get out of sync from the table primary keys during testing. While I can fix them, what can I do to prevent the sequences ...
user avatar
1 vote
0 answers
6 views

Delete Temporary Tables from Abandoned ALTER Query

I had some big tables, where the running ALTER query timed out. Is there a way to remove the temporary tables created by this ALTER query, as they are taking up a huge amount of storage. I am on RDS. ...
user avatar
0 votes
1 answer
70 views

Row size too large (> 8126) - 5.7.mysql_aurora.2.10.0

CreateTableConstraintStep ddlList = (CreateTableConstraintStep) dslContext .createTableIfNotExists(getDSLTableName(List)) .columns(fields) ...
user avatar
1 vote
2 answers
61 views

MySQL Database locks up - trying to explain spike in writes

Trying to explain this symptom Our RDS MySQL database (no fancy custom parameter settings) has been going down periodically, which our team believe is due to a high number of concurrent connections ...
user avatar
  • 111
0 votes
0 answers
39 views

Cross-database backup/restore when prefixing existing databases by envrionment name

Our team is migrating an existing MSSQL server to AWS RDS (for Microsoft Sql server). To reduce costs, our team has decided to use only 1 RDS instance that contains all of our databases but prefixed ...
user avatar
1 vote
0 answers
124 views

AWS Lambda to RDS PostgreSQL connection

Hello fellow AWS contributors, I’m currently working on a project to set up an example of connecting a Lambda function to our PostgreSQL database hosted on RDS. I tested my Python + SQL code locally (...
user avatar
2 votes
1 answer
24 views

Using innodb_flush_log_at_trx_commit = 2 with RDS MultiAZ - Safe?

I understand the downsides of using the parameter setting innodb_flush_log_at_trx_commit = 2 If you want to know more, look at another answer, for example Is it safe to use ...
user avatar
0 votes
0 answers
13 views

Does AWS RDS MariabDb supports automatic failover?

We want to use AWS RDS to store our app's data. We are leaning towards MariaDb because of its temporal tables feature. And hence not chosing AWS Aurora with MySQL. Another reason being even though ...
user avatar
  • 121
4 votes
1 answer
139 views

How to await the execution of the rds_backup_database stored procedure?

Our team is migrating one of our databases to Amazon RDS MS SQL Server. As part of that, we have to rewrite some of our stored procedures. We have a stored procedure that performs a database backup to ...
user avatar
3 votes
2 answers
59 views

How to resolve The instance could not be upgraded because the 'reg*' data type is used in user tables?

I tried to upgrade a Postgres DB Engine from 11.12 to 13.3 on AWS via the admin console in the browser. But the upgrade could not be performed, the error/pg_upgrade_precheck.log shows this message. ...
user avatar
1 vote
1 answer
195 views

BACKUP DATABASE permission denied when using AWS RDS

Our team is migrating to the cloud and we have chosen RDS For MSSQL to host our current db server. As part of that, we have a lot of stored procedures that need to be modified. Some of those are ...
user avatar
0 votes
0 answers
5 views

Can RDS reader and write have different parameter group?

I have an RDS (MySQL) instance, with a reader and a writer. The writer is used by a number of transactional jetty apps, and the long_query_time is set low. The reader is used by a single application, ...
user avatar
  • 221
0 votes
0 answers
29 views

Unable to create Read replica - AWS RDS SQL Server 2016

I am trying to create a read replica for a Sql Server enterprise Edition (2016 SP2 CU16) but no such option is presented in the drop down. I have gone through all the documentation provided and the ...
user avatar
0 votes
1 answer
306 views

AWS RDS "Maintenance Required"

I saw from the web interface that maintenance on my RDS postgresql instances is required, so I ran aws rds describe-pending-maintenance-actions, and it says that there's a "system-update" ...
user avatar
  • 455
0 votes
0 answers
17 views

Errors messages when pusing data with psql on existing database

So I have a remote postgres database hosted on aws's rds, for a django application. This is still in dev (though obviously would like to start trying to do things right already). I need to upload ...
user avatar
1 vote
2 answers
110 views

Reading SQL Server .sqlaudit Files Stored in S3

I set up an audit in SQL Server that saves audit logs (.sqlaudit files) to RDS, which we then copy over to S3 using a standard process. All of the documentation I can find on reading these audit files ...
user avatar
0 votes
0 answers
50 views

Oracle RDS Logminer ORA-01291 Missing Log File?

I have an Oracle RDS database I manage, and I need to be able to pull changes from the database for replication to another system. Once connect to the database, below is the commands I run. EXEC ...
user avatar
  • 101
1 vote
1 answer
93 views

RDS slow queries after few weeks

Since I updated from MySQL 5.6 to 5.7 I started to have very slow queries in my Aurora RDS instance. In my local XAMPP the same queries took a few seconds but in RDS some of them were about 6 minutes. ...
user avatar
  • 113
0 votes
1 answer
30 views

How to query for Amazon RDS instance configuration?

From within a plpgsql script run on an Amazon RDS Postgres instance, is it possible to get information about instance configuration? How do I retrieve the DB instance ID, ARN (Amazon Resouce Name) or ...
user avatar
0 votes
0 answers
26 views

What is MySQL doing? There are no active queries and full utilization of disk

I see an abnormal behavior of disk IOPS being fully utilized constantly for hours without no actual queries within this time range. I have MariaDB 10.4.21 running in AWS RDS at db.t4g.medium machine. ...
user avatar
  • 101
1 vote
1 answer
45 views

Does the Read IOPS metric on RDS count OS cache hits?

I'm doing some tuning on a read-only replica, and I want to make sure I understand the "Read IOPS" metric. Certainly, any pages that are found in the postgres shared_buffers cache don't ...
user avatar
  • 111
0 votes
0 answers
55 views

InnoDB - Fulltext (match against) extremely slow, wrong indexes?

I've recently migrated my myisam-tables to InnoDB and some things are a bit weird for me. For starters, the indexes looks a bit different (and maybe is the reason why the new InnoDB-implementation is ...
user avatar
  • 121
0 votes
0 answers
13 views

SQL code Compatibility: Migrating an Oracle RDS database to an Athena Trino Datalake

We are thinking of migrating an Oracle RDS database to Athena Trino Datalake. We would keep all database names, schemas, tables, and columns the same. Would SQL that runs correctly against the Oracle ...
user avatar
0 votes
0 answers
25 views

How to compare two MySQL databases?

I will be migrating MySQL databases from Aurora MySQL cluster in one account to another account using snapshot approach of AWS RDS. I need to perform a validation or comparison test to prove that ...
user avatar
1 vote
1 answer
106 views

AWS RDS postgres error when running sql function: RI_constraintrigger_a_19346 is a system trigger

So I need to import django fixtures (e.g. a django's database dump essentially) in postgres on a aws rds instance. I have tested locally that the constraints of the DB are all valid (by importing ...
user avatar
1 vote
0 answers
41 views

Why Isn't the MySQL Index Immediately Available?

We are in the process of moving from AWS RDS MySQL 5 to AWS RDS MySQL 8. We have a script that runs a few dozen queries. The last few look like this: ALTER TABLE my_right_table ADD INDEX (col_a, col_b)...
user avatar
  • 11
1 vote
1 answer
69 views

Slow simple select query on Postgresql 13 RDS hosted indexed table

I am working with a simple table, hosted on RDS instance running Postgresql 13. It is using t3.small instance with general purpose SSD storage. The table and its index look like this measurements=> ...
user avatar
  • 13
0 votes
1 answer
121 views

Unable to perform the 'rds_restore_database' procedure on AWS RDS SQL Server Express

I'm facing the error Maximum supported database size on SQL Server Express edition is: 10 GB. when executing the restore procedure msdb.dbo.rds_restore_database. The weird thing is the actual database ...
user avatar
  • 101
0 votes
1 answer
263 views

AWS RDS MSSQL cannot alter the availability group 'RDSAG0'. because it does not exist or you do not have permission

In AWS RDS MSSQL we have mirroring running between primary and replica via Always On. We want to remove/drop a couple of databases, but when we try: ALTER AVAILABILITY GROUP RDSAG0 REMOVE DATABASE [db-...
user avatar
0 votes
0 answers
45 views

How to restore the backup of schema taken using pgdump from a different RDS to a different RDS in postgresql?

I have 2 RDS in AWS actually . I need to take the schema from one of the RDS and restore it into the second RDS without taking the table data. So i have taken the backup using this command in bastion ...
user avatar
  • 1
1 vote
0 answers
35 views

Calculating IOPS in a SQL Server EC2 - RDS migration

I'm evaluating costs for a possible migration of a SQL Server that is currently running on Amazon EC2 to Amazon RDS. On the EC2 instance I have six volumes, described as follows: type size IOPS gp2 ...
user avatar
1 vote
0 answers
54 views

Does AWS Aurora MySQL not support encrypted binary log replication with RDS MySQL master?

Trying to setup replication between an RDS MySQL (5.6) master with an Aurora MySQL (also 5.6) replica cluster in the same region via binary log replication for a work project. However, this doesn't ...
user avatar
0 votes
1 answer
192 views

AWS RDS SQL Server Instance, Question in Maintenance Plan

New to cloud and have questions on AWS RDS SQL Server Instance, Question in Maintenance Plan. As a DBA team we are expecting RDS access and admin access on SQL box. But was limited with setupadmin ...
user avatar
0 votes
1 answer
173 views

PostgreSQL RDS: Slower than expected performance when large table / index is not in cache

I have a fairly large table, 43GB and a 14GB index, that consists of time series cost data. I am querying by date and summing the amount. When this data is not in the cache (either OS or Postgres) the ...
user avatar
  • 103
1 vote
0 answers
546 views

Replication from AWS RDS to MySQL fails because of unknown character set?

I have an RDS instance running MySQL 5.7, which I have configured as replication master, and a MySQL 5.7 running on an EC2 instance (Ubuntu 20.04) as slave. The replication breaks instantly with: ...
user avatar
  • 221

1
2 3 4 5
17