If an error message is displayed when you are using ApsaraDB RDS, you can check the information about the error in the API Error Center. If no information about the error can be found, try to find a solution in this topic.
Note The following topics cover a variety of issues and solutions. You can use the search box or press Ctrl+F to search for topics by keyword.
Purchases and payments
- How do I handle zone- and region-related issues?
- How do I handle billing-related issues?
- How do I change the storage type of an ApsaraDB RDS instance from standard SSDs or ESSDs to local SSDs?
- Why is the MyISAM storage engine automatically disabled for ApsaraDB RDS for MySQL?
- Why am I unable to find an ApsaraDB RDS instance?
- Why does ApsaraDB RDS for MySQL not support the MyISAM storage engine?
Connections and networks
- How do I connect to an ApsaraDB RDS instance?
- How do I use Navicat to connect to an ApsaraDB RDS for MySQL instance?
- How do I access an ApsaraDB RDS instance from an ECS instance over an internal network?
- Why am I unable to connect to an ApsaraDB RDS for MySQL or ApsaraDB RDS for MariaDB instance from an on-premises device over the Internet?
- How do I determine the public IP address of an on-premises device or a client that is connected to an ApsaraDB RDS for SQL Server instance?
- Do I need to configure my application to automatically reconnect to an ApsaraDB RDS instance?
- How do I reduce the network latency between an ECS instance and an ApsaraDB RDS for PostgreSQL instance?
- What do I do if the "ERROR 1045 (28000): Access denied for user" error message is displayed when I connect to an ApsaraDB RDS for MySQL instance?
- What do I do if I cannot connect to an ApsaraDB RDS instance?
- What do I do if the "ip not in whitelist" error message is displayed when I connect an ECS instance to an ApsaraDB RDS instance over an internal network?
- What do I do if the "Can't connect to MySQL server on 'XXX'" error message is displayed when I connect to an ApsaraDB RDS for MySQL instance or an ApsaraDB RDS for MariaDB instance?
- How do I connect an ECS instance and an ApsaraDB RDS instance over an internal network if these instances reside in networks of different types?
- How do I connect an ECS instance to an ApsaraDB RDS instance over an internal network if these instances reside in different regions?
- How do I connect an ECS instance and an ApsaraDB RDS instance over an internal network if these instances reside in different VPCs?
- How do I handle issues about network types?
- What do I do if the "has more than 'max_user_connections'" or "has exceeded the 'max_user_connections'" error message is displayed when I connect to an ApsaraDB RDS for MySQL instance?
- What do I do if the "Unknown MySQL server host" error message is displayed when I connect to an ApsaraDB RDS for MySQL instance from an on-premises device that runs a Linux operating system?
- How do I connect an ECS instance to an ApsaraDB RDS instance if the instances are created within different Alibaba Cloud accounts?
- What do I do if excessive connections are established on an ApsaraDB RDS for PostgreSQL instance?
- How do I change the vSwitch of an ApsaraDB RDS instance?
- How do I connect a Java program to an ApsaraDB RDS for MySQL instance?
- How do I connect a Java application to an ApsaraDB RDS for SQL Server instance?
- How do I obtain the public IP address of an on-premises device that is connected to an ApsaraDB RDS for PostgreSQL instance?
- What do I do if the establishment of a connection to an ApsaraDB RDS for PostgreSQL instance is interrupted?
- How do I change the VPC of an ApsaraDB RDS instance?
- What do I do if the "Unknown MySQL server host" or "name or service not known" error message is displayed when I connect to an ApsaraDB RDS for MySQL instance or an ApsaraDB RDS for MariaDB instance?
- What do I do if a network-related or instance-specific error occurred when I attempt to connect to an ApsaraDB RDS for SQL Server instance?
- How do I connect to an ApsaraDB RDS instance from an external server?
Migration, synchronization, and change tracking
- What is DTS? What are the limits on DTS?
- How do I view the incremental data in an ApsaraDB RDS for MySQL instance?
- How do I import multiple data records to an ApsaraDB RDS for SQL Server instance at a time?
- What do I do if an error occurred when I use the COPY statement to import data to an ApsaraDB RDS for PostgreSQL instance?
- What do I do if the "Connection timed out" error message is displayed when I use the change tracking feature of DTS?
- What do I do if the "java.io.IOException: Parse message attribute failed" error message is reported by the change tracking feature of DTS?
- What do I do if the "client partition is empty" error message is displayed in DTS logs?
- How do I migrate self-managed databases to ApsaraDB RDS?
- What do I do if DTS prompts that the number of migrated data records exceeds the total number?
- Why are read-only ApsaraDB RDS instances not supported by the change tracking feature of DTS?
- What do I do if the schema existence check failed during the DTS precheck?
Backup and restoration
- What are the differences between data migration, synchronization, and restoration?
- How do I restore individual databases on an ApsaraDB RDS for MySQL instance?
- What do I do if the size of backup files on an ApsaraDB RDS instance exceeds the free quota for backup storage?
- How do I use DMS to export data as a CSV file?
- How do I configure the options of mysqldump for ApsaraDB RDS for MySQL?
- How do I restore the backup files that are downloaded from an ApsaraDB RDS instance to a new ApsaraDB RDS instance?
- How do I back up individual databases on an ApsaraDB RDS for SQL Server instance or an ApsaraDB RDS for MySQL instance?
- How do I use wget to download backup files in a Linux operating system?
- How do I restore individual databases on an ApsaraDB RDS for SQL Server instance?
- Which factors affect the amount of time that is required to change the specifications of an ApsaraDB RDS for MySQL instance?
- How do I use the log backup feature?
- How do I use get_rds_backup.py to download the backup files of an ApsaraDB RDS for MySQL instance?
- How do I back up or restore the databases of an ApsaraDB RDS for MySQL instance?
- How do I restore the data that is accidentally deleted from an ApsaraDB RDS instance?
- How do I restore the data of an ApsaraDB RDS for MySQL instance from a specific point in time to a self-managed database?
- What do I do if the "The operation is not permitted due to no backup" error message is displayed when I create a temporary ApsaraDB RDS instance?
- What do I do if a disaster recovery ApsaraDB RDS instance is paused?
- How do I use mysqldump to migrate data?
- How do I use RDSBackup to decompress the backup files of an ApsaraDB RDS for MySQL instance in a Windows operating system?
Read-only instances and read/write splitting
- How do I enable read/write splitting for an ApsaraDB RDS for MySQL instance?
- Does ApsaraDB RDS support read-only instances or read/write splitting?
- How do I make sure that data is read in a timely manner on an ApsaraDB RDS for MySQL instance when the read/write splitting feature is enabled?
- What do I do if a latency occurs when a read-only ApsaraDB RDS for MySQL instance synchronizes data from its primary instance?
Performance, storage capacity, and memory
- How do I handle issues related to storage capacity?
- How do I expand the storage capacity of an ApsaraDB RDS instance?
- What is availability detection?
- How do I create and view a stored procedure in ApsaraDB RDS for MySQL?
- I executed an SQL statement on both an ECS instance and an ApsaraDB RDS instance. Why is the query result returned faster on the ECS instance?
- What are the limits on ApsaraDB RDS for MySQL?
- How do I configure and use the query cache feature of ApsaraDB RDS for MySQL?
- What do I do if an ApsaraDB RDS instance is in the Locked state?
- What do I do if the "The transaction log for database xx is full due to 'LOG_BACKUP'" error message is displayed when I back up logs?
- What do I do if the number of connections to an ApsaraDB RDS for MySQL instance reaches the upper limit?
- What is the maximum storage capacity that is allowed for an ApsaraDB RDS instance?
- How do I manage long-time queries in an ApsaraDB RDS for MySQL instance?
- How does ApsaraDB RDS for MySQL collect table statistics?
- How do I view the current connection to an ApsaraDB RDS for SQL Server instance and the SQL statements that are executed over the current connection?
- How do I view the memory usage of an ApsaraDB RDS for SQL Server instance?
- How do I reclaim the tablespace of an ApsaraDB RDS for SQL Server instance?
- How do I view the storage usage of an ApsaraDB RDS for SQL Server instance at the instance, database, or table level?
- What do I do if I want to use the diagnostic report feature and obtain diagnostic reports in DAS and DMS?
- How do I use OSS to extend the tablespaces of an ApsaraDB RDS for PostgreSQL instance?
- How do I troubleshoot the issues that cause high CPU utilization on an ApsaraDB RDS for PostgreSQL instance?
- How do I troubleshoot the issues that cause abrupt increases in disk usage on an ApsaraDB RDS for PostgreSQL instance?
- What do I do if requests are blocked on an ApsaraDB RDS for SQL Server instance?
- What do I do if the CPU utilization of an ApsaraDB RDS for SQL Server instance is high?
- What do I do if an ApsaraDB RDS for SQL Server instance is automatically locked after its disk space is exhausted?
- Is disk space released when I use the DROP statement to delete indexes from InnoDB tables?
- What do I do if the CPU utilization is high and the usages of the memory, disk space, and IOPS are high?
- What do I do if an ApsaraDB RDS for MySQL instance is in the Locked state because its disk space is exhausted by data files?
- What do I do if the disk space of an ApsaraDB RDS for MySQL instance is exhausted by binary log files?
- What do I do if an ApsaraDB RDS for MySQL instance is in the Locked state because its disk space is exhausted by temporary files?
- What do I do if the disk space of an ApsaraDB RDS for MySQL instance is exhausted by system files?
- How do I view the events and threads that consume a large amount of memory in an ApsaraDB RDS for MySQL instance?
- What do I do if the CPU utilization of an ApsaraDB RDS for MySQL instance or an ApsaraDB RDS for MariaDB instance is high?
- What do I do if the IOPS usage of an ApsaraDB RDS for MySQL instance is high?
- How do I use the OPTIMIZE TABLE statement to release the tablespace of an ApsaraDB RDS for MySQL instance?
- How do I release a tablespace of an ApsaraDB RDS for MySQL instance?
- My ApsaraDB RDS for MySQL instance automatically locks after its disk space is exhausted. What do I do?
Accounts and permissions
- What do I do if the "ERROR 1044 (42000): Access denied for user 'xxxx'@'%' to database 'xxxx'" error message is displayed when I create a database on an ApsaraDB RDS instance?
- How do I authorize a RAM user to use DMS to log on to an ApsaraDB RDS instance?
- How do I grant permissions to the users of an ApsaraDB RDS for PostgreSQL instance?
- What do I do if the "must be owner of xxx" error message is displayed when I execute the CREATE CAST statement on an ApsaraDB RDS for PostgreSQL instance?
- What do I do if the "OPERATION need to be executed set by ADMIN" error message is displayed?
Upgrades
Databases and tables
- Does ApsaraDB RDS for MySQL support online DDL operations? How do I perform online DDL operations on an ApsaraDB RDS for MySQL instance?
- What are the limits on table partitions in ApsaraDB RDS for MySQL?
- How do I perform online DDL operations on an ApsaraDB RDS for MySQL instance?
- What are the limits on the size of a single table in ApsaraDB RDS for MySQL?
- Does ApsaraDB RDS for MySQL support table partitioning?
- How do I change the time zone of an ApsaraDB RDS for PostgreSQL instance?
- What are the descriptions of character sets in ApsaraDB RDS for MySQL?
- How do I make sure that database character encoding is valid in ApsaraDB RDS for MySQL?
- How do I change the encoding format of character sets of an ApsaraDB RDS for MySQL instance to utf8mb4?
- How do I use DTS to replicate and rename databases in an ApsaraDB RDS instance?
- How do I view the primary key fields of a table in an ApsaraDB RDS for MySQL instance?
- What do I do if the "The Changes you have made require the following table" error message is displayed when I modify a schema?
- What do I do if the "There are 2 other sessions using the database" error message is displayed when I delete a database from an ApsaraDB RDS for PostgreSQL instance?
Logs
- How do I handle issues related to binary logs?
- What rules does ApsaraDB RDS follow when it generates and deletes binary logs for an ApsaraDB RDS for MySQL instance?
- How do I remotely obtain and parse the binary logs of an ApsaraDB RDS for MySQL instance?
- What policies are used by ApsaraDB RDS to collect slow query logs?
- How do I shrink the transaction logs of an ApsaraDB RDS for SQL Server instance?
- Can I use the binary logs of a read-only ApsaraDB RDS for MySQL instance?
- What do I do if the "mysqld:Sort aborted:Server shutdown in progress" error message is displayed when I use an ApsaraDB RDS for MySQL instance?
SQL
- What do I do if the "Error 1709: Index column size too large. The maximum column size is 767 bytes." error message is displayed when I use an ApsaraDB RDS for MySQL instance?
- What do I do if the "relation "xxx" already exists" error message is displayed when I attempt to modify a capitalized table name in an ApsaraDB RDS for PostgreSQL instance?
- How do I use the postgres_fdw and dblink plug-ins to query data across databases in an ApsaraDB RDS for PostgreSQL instance?
- How do I handle the issues related to the group_concat function in an ApsaraDB RDS for MySQL instance?
- What do I do if the "OPERATION need to be executed set by ADMIN" error message is displayed when I install and use ThinkSNS to connect to an ApsaraDB RDS instance?
- How do I use the utf8mb4 character set to store emojis in an ApsaraDB RDS for MySQL instance?
- What do I do if the "SELECT command denied to user 'username'@'ip' for table 'user'" error message is displayed when I use an ApsaraDB RDS for MySQL instance?
- What do I do if the "the table '/home/mysql/xxxx/xxxx/#tab_name' is full" error message is displayed when I use an ApsaraDB RDS for MySQL instance?
- What do I do if the "Specified key was too long; max key length is 767 bytes" error message is displayed when I create indexes in an ApsaraDB RDS for MySQL instance?
- What do I do if the query results are inaccurate due to the large DECIMAL field of an ApsaraDB RDS for MySQL instance?
- What do I do if the "Out of resources when opening file './xxx.MYD' (Errcode: 24)" error message is displayed when I use an ApsaraDB RDS for MySQL instance?