"invalid number of terminals" Is Displayed When Data Is Imported to MySQL

Symptom

When data is imported to the MySQL database, the problem of invalid numbers occurs and the message "invalid number of terminals" is displayed.

Key Process and Cause Analysis

The number of connection requests sent by JDBC Connector exceeds the maximum number of connections configured on the MySQL server.

Conclusion and Solution

1. Run the following SQL statement on the MySQL client to check the value of max_connections:

   show variables like 'max_connections';

2. Change the value of terminals in the my_mysql.properties file to a value smaller than that of max_connections.
   1. Open the my_mysql.properties file.

      vi my_mysql.properties

   2. Press i to enter the insert mode and change the value of terminals to a value smaller than that of max_connections.

      Modification example:

      

   3. Press Esc, type :wq!, and press Enter to save the file and exit.
3. Run the data loading command again.

   ./runDatabaseBuild.sh my_mysql.properties