Questions tagged with Database
Content language: English
Sort by most recent
Is there a way we can refresh a limited set of data from Prod AWS account to Dev AWS account PostgreSQL database?
For e.g., I have to refresh few rows from couple of tables of Prod to Dev DB. I don't want to do a full refresh of the data using snapshots.
Database: AWS Aurora PostgreSQL
Hi,
I need to migrate PostgreSQL DB in AWS.
Is it possible to have an estimate migration's time?
Thanks in advance for your help.
I've configured the Athena connection to a RDS SQL Server database using a JDBC driver. After choosing the Data Source the Database does not load and there is a "Network Failure" shown without any information. What might be the cause of such error or where I can find more information on how to solve such case?
Im trying to follow this guide https://workmarket.tech/zero-downtime-maintenances-on-mysql-rds-ba13b51103c2 , for \*active\*-\*active\* replication.
But on command
`CHANGE *active* TO *active*_HOST=....`
i get error:
`ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER or REPLICATION_*secondary*_ADMIN privilege(s) for this operation`
As i understood AWS forbids this kind of access via command line access.
So, how do i then do this change? i assume via `parameters group`... but how?
\*active\* = some non inclusive word
\*secondary\* = some other non inclusive word
We using RDS Read replica For Production DB. RDS Read Replica taken more Storage than main DB .
Prod Storage : 81 GB
Read Replica: 1000GB
Even now we are getting the recommendation to increase the storage even more . Why does it take more storage? How to reduce the storage size without affecting read replica. It also afflicted our prod DR process and cost wise.
confirm we promote the Read Replica DB to Main DB it take same amount of storage.
Hi, I'm trying to create a copy of an Aurora PostgreSQL cluster snapshot in a different region using the aws cli, I was able to do it five times, but now I'm getting the error message **Cannot copy more than 5 snapshots concurrently to the same region**.
I suspect that the problem was that I deleted those snapshots while they were being copied and for some reason the status was never updated.
##### Question:
do I have to contact the technical support so that they can update the status of the snapshots in the region or is there a way to clean up the snapshots that were deleted before copy them?
current scenario
1 MysqlRDS with 8TB of an instance.
After migrating some application log tables, it was found that:
- We are allocating an unnecessary 6TB, as the total size of the database is approx. 2TB
AWS does not yet provide means to downsize allocated storage.
what is the need
- migrates the database to another instance in the same region with the storage already adjusted and thus freeing us from paying for an unnecessary 6TB of storage,
What is the best strategy for a bank with this volume, operating with 2 read replicas, 24 hours a day, 365 days a year.
Hello there,
I'm trying to drop a DB on the Aurora, but the requests just hangs. I've tried several times and the last attempt has been runnning for 600 seconds.
it's a tiny DB of 20MB gzipped.
* running `show databases;` returns the borken_db in the list.
* running `use broken_db;`now hangs too.
* running `show processlist`returns the following:
| Id | User | Host | db | Command | Time | State | Info |
|----|-----------------|-----------------|-------------|---------|------|----------------------------------|-----------------------------|
| 5 | event_scheduler | localhost | | Daemon | 8310 | Waiting on empty queue | |
| 19 | rdsadmin | localhost | | Sleep | 0 | | |
| 21 | rdsadmin | localhost | | Sleep | 1 | | |
| 22 | rdsadmin | localhost | | Sleep | 1 | | |
| 25 | rdsadmin | localhost | | Sleep | 252 | | |
| 36 | root_user | 10.0.0.48:36768 | broken_db | Sleep | 2404 | | |
| 38 | root_user | 10.0.0.48:36788 | mysql | Query | 2736 | Waiting for schema metadata lock | DROP DATABASE `broken_db` |
| 47 | root_user | 10.0.0.48:36826 | mysql | Query | 2346 | Waiting for schema metadata lock | drop DATABASE broken_db |
| 50 | root_user | 10.0.0.48:36854 | | Query | 1990 | Waiting for schema metadata lock | USE `broken_db` |
| 51 | root_user | 10.0.0.48:36874 | mysql | Query | 0 | init | show processlist |
| 52 | root_user | 10.0.0.48:36894 | mysql | Query | 1042 | Waiting for schema metadata lock | use broken_db |
| 58 | root_user | 10.0.0.48:36922 | | Query | 178 | Waiting for schema metadata lock | use broken_db |
| 59 | rdsadmin | localhost | | Sleep | 7 | | |
where do I go from there?
For the last few days, I am trying to upgrade an RDS SQL Server web-edition instance from db.t2.small to db.t3.small. but every time i receive the following error.
*We're sorry, your request to modify DB instance xxx has failed.
Cannot modify the instance class because there are no instances of the requested class available in the current instance's availability zone. Please try your request again at a later time.*
I have also used AWS CLI to check the orderable db-instances
describe-orderable-db-instance-options
This returns command also shows that orderable instances are available in us-east-1 with instance type as db.t3.small , but still i am unable to change the instance type. Is anyone facing the same issue or has a solution to this ?
Hi,
I am hoping to start using RDS Oracle with Multi-Tenant support(CBD), but I am struggling to create another PDB (a clone of the first PDB ORCL) using the master user "admin".
CREATE PLUGGABLE DATABASE ORCL1 FROM ORCL
Error report -
ORA-65040: operation not allowed from within a pluggable database
65040. 00000 - "operation not allowed from within a pluggable database"
*Cause: An operation was attempted that can only be performed in the root
or application root container.
If I try to switch to root
alter session set container=CDB$ROOT
Error report -
ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to perform a database operation without
the necessary privileges.
*Action: Ask your database administrator or designated security
administrator to grant you the necessary privileges
I have also tried another user and tried to assign the privileges for both of the above but I get a permission denied. Has anyone done similar?
Thanks
Currently, the Create RDS read replica screen doesn't allow choosing a custom parameter group (and option group) on creation so
a new read replica with a smaller instance class ends up getting stuck in "incompatible-parameters" mode because of high values of buffer related parameters in the original primary instance's parameter group, so I have to create the new replica first with the original instance class of the primary instance, change the parameter group and then resize the replica to a smaller instance class.
Also, replication errors can occur while the primary parameter group is applied on the read replica because of MEMORY engine tables which have out of sync rows between the instances, which were meant to be excluded from replication using the read replica custom parameter group.
Error while fetching the data from dynamo db from athena
Error:
GENERIC_USER_ERROR: Encountered an exception[java.lang.ClassCastException] from your LambdaFunction[arn:aws:lambda:ap-south-1:458993339053:function:dynamodbdata] executed in context[S3SpillLocation{bucket='swaasa-athena-db-spill-ap-south-1', key='athena-spill/d38cdaf7-7fb2-48b9-acc8-9139de2fe525/821dc5fc-f893-40f9-b25e-96b832e55c4a', directory=true}] with message[class java.lang.String cannot be cast to class java.math.BigDecimal (java.lang.String and java.math.BigDecimal are in module java.base of loader 'bootstrap')]
Tried using the try_cast but still seeing the issue
query id: 0a47ace5-b8fc-46cb-8ff5-23194925882e