MySQL not showing the UPDATE and INSERT query outputs
The UPDATE and INSERT query provides the outputs when executed in MySQL shell. The same query can be executed from
Read more
Day: September 4, 2021
Maven Error: Could not transfer from/to maven-default-http-blocker (http://0.0.0.0/): Blocked mirror for repositories
Could not transfer from/to maven-default-http-blocker (http://0.0.0.0/): Blocked mirror for repositories This error happens because of the insecure repositories. i.e. http
Read more
How to schedule EC2 instances to change type
We can modify the EC2 instance type at any time according to the requirements. This article explains the steps to
Read more
How to skip replication errors in RDS MySQL
Errors will break the replication process in slave. RDS provides an option to skip the error and re-sync the replica.
Read more
PostgreSQL Error: could not execute query: ERROR: role does not exist
could not execute query: ERROR: role does not exist This is a common error that usually happens on restoring PostgreSQL
Read more
MySQL Error: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
The MySQL server is running with the --secure-file-priv option so it cannot execute this statement This is not an issue
Read more
How to schedule EBS snapshots in AWS
AWS provides Data Lifecycle Manager to automate the process of backing up of EBS volumes. We can configure lifecycle policeis
Read more
How to create additional super user in RDS MySQL
RDS have only one super user by default when the instance is created. But we can create users the same
Read more
PostgreSQL ERROR: could not access file "pglogical": No such file or directory
ERROR: could not access file "pglogical": No such file or directory This error happens due to the missing of PostgreSQL
Read more