Problem
=======
Recovery Framework in RAPID plugin issues 'ALTER TABLE <table-name>
SECONDARY_LOAD' commands to automatically load tables. Framework uses MySQL
service to issue these queries in local sessions. Specifically
command_service_run_command() is called, and it's return value is checked to
know if load successfully happened or not. Along with the return value, the
error value set in thd variable of the session is also checked. Understanding
is that return value does not account all runtime errors.

Analysis
========
WL#13357 introduced a modification in the session service query execution method
that clears THD's Diagnostic Area at the end. Query execution failures could not
be detected anymore.

Fix
===
Modificaion in the command_service_run_command function was rolled back.
The X plugin was modified not to rely on the Diagnostic Area when generating
connection message audit event on authentication error.

RB: 24103

Reviewed-by: Georgi 'Joro' Kodinov <georgi.kodinov@oracle.com>
Reviewed-by: Łukasz Kotula <lukasz.kotula@oracle.com>