I have a .NET application that executes queries in a MySQL database in Amazon Aurora RDS. The database is the MySQL 5.6 database — the version that ships with Aurora.
I execute queries according to the scheme (name: flight) in the database (name: SSIMLoader). I am using MySQL 6.9.8.0 libraries.
edit: The connection string points to the main server in the cluster, and not to the specific server.
Error while inserting, selecting and updating, so there is no real template. Even simple select statements come out randomly.
However, we do not get such an error when executing queries through MySQL Workbench.
After restarting the server, the error disappears for several days, and then returns.
We have very intensive requests that increase the processor load to 90% for long periods of time, but the error persists even after the processor drops to 10%.
Has anyone else experienced this, and if so, how did you get past it?
Thanks in advance.
- edit
And got an error again:
MySql.Data.MySqlClient.MySqlException(0x80004005): 'flight' MySql.Data.MySqlClient.MySqlStream.ReadPacket() MySql.Data.MySqlClient.NativeDriver.ReadOk(Boolean read) MySql.Data.MySqlClient.MySqlConnection.ChangeDatabase(String databaseName) MySql.Data.MySqlClient.MySqlConnection.Open() MySql.Data.MySqlClient.MySqlConnection.Open() Universal.Access.Database.BaseDatabaseConnection.EstablishFactoryConnection() Universal.Access.Database.BaseDatabaseConnection.ExecuteReader(CommandType commandType, CommandText commandText) Universal.Core.DataModel.ExecutableDatabaseConnection.ExecuteQuery(String sqlQuery) C:\tc-projects\universal-platform\Universal.Core\DataModel\ExecutableDatabaseConnection.cs: 65
:
UP-DEV | Universal.Core.Data.Importer Error finding current record, SQL: SELECT aircraft_config,updated_by,asa_flight_id,atd_utc,bay,terminal,is_cancelled,flight_number,created_at,from_iata,flight_date_utc,std_local,takeoff_time_local,is_international,is_aerocare,cobt_local,customer_atd_local,takeoff_time_utc,std_utc,atd_local,asa_state,aircraft_type,customer_atd_utc,carrier_code,updated_at,gate,service_type,etd_local,cobt_utc,flight_status,etd_utc,aircraft_rego,created_by,id,flight_date,to_iata FROM flight.departure_flight WHERE carrier_code='JQ' AND flight_date_utc='2017-01-20T00:00:00' AND flight_number='57' AND from_iata='MEL'. Database returned: Unknown database 'flight'