ES-1567

During insertion processing by the MySQL adapter, if writing to a database fails due to any reason, the data may become inconsistent

Phenomenon

During insertion processing by the MySQL adapter, if writing to a database fails due to any reason, some data may unexpectedly be left behind and the data may become inconsistent.

Affected versions

Ver.2.3.2

Version when it was corrected

From Ver.2.1.0 to Ver.2.3.1

Affected module

HULFT IoT EdgeStreaming Runtime

Condition to reproduce

This phenomenon may occur when both of the following conditions are met:

• Use the MySQL adapter to perform either of the following insert operations for a database;

  • "Tool palette" > "Database" > "MySQL" > "Insert"

  • "Tool palette" > "Database" > "MySQL" > "Insert (result output)"

• An error occurs while writing to the database.

Alternative workaround

None

Status description

Even if the above conditions are met, writing to the database does not fail and the consistency of the data is maintained.