Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
The executable comments that mariadb-dump uses are not parsed by qc_sqlite:
2024-09-11 12:39:29 info : (1) [pp_sqlite] (RW-Split-Router); Parsing the query failed, cannot report query type: /*!40103 SET TIME_ZONE='+00:00' */
|
2024-09-11 12:39:29 info : (1) (RW-Split-Router); > Autocommit: [enabled], trx is [not open], cmd: (0x3) COM_QUERY, plen: 39, type: N/A, stmt: /*!40103 SET TIME_ZONE='+00:00' */
|
2024-09-11 12:39:29 info : (1) [readwritesplit] (RW-Split-Router); Route query to primary: server1 <
|
2024-09-11 12:39:29 info : (1) [pp_sqlite] (server1); Parsing the query failed, cannot report query type: /*!40103 SET TIME_ZONE='+00:00' */
|
2024-09-11 12:39:29 info : (1) [readwritesplit] (RW-Split-Router); Reply complete from 'server1' (OK: 0 warnings)
|
2024-09-11 12:39:29 info : (1) [pp_sqlite] (RW-Split-Router); Parsing the query failed, cannot report query type: /*M!100100 SET @@MAX_STATEMENT_TIME=0.000000 */
|
2024-09-11 12:39:29 info : (1) (RW-Split-Router); > Autocommit: [enabled], trx is [not open], cmd: (0x3) COM_QUERY, plen: 52, type: N/A, stmt: /*M!100100 SET @@MAX_STATEMENT_TIME=0.000000 */
|
2024-09-11 12:39:29 info : (1) [readwritesplit] (RW-Split-Router); Route query to primary: server1 <
|
2024-09-11 12:39:29 info : (1) [pp_sqlite] (server1); Parsing the query failed, cannot report query type: /*M!100100 SET @@MAX_STATEMENT_TIME=0.000000 */
|
2024-09-11 12:39:29 info : (1) [readwritesplit] (RW-Split-Router); Reply complete from 'server1' (OK: 0 warnings)
|
2024-09-11 12:39:29 info : (1) [pp_sqlite] (RW-Split-Router); Parsing the query failed, cannot report query type: /*M!100100 SET WAIT_TIMEOUT=DEFAULT */
|
2024-09-11 12:39:29 info : (1) (RW-Split-Router); > Autocommit: [enabled], trx is [not open], cmd: (0x3) COM_QUERY, plen: 43, type: N/A, stmt: /*M!100100 SET WAIT_TIMEOUT=DEFAULT */
|
2024-09-11 12:39:29 info : (1) [readwritesplit] (RW-Split-Router); Route query to primary: server1 <
|
2024-09-11 12:39:29 info : (1) [pp_sqlite] (server1); Parsing the query failed, cannot report query type: /*M!100100 SET WAIT_TIMEOUT=DEFAULT */
|
2024-09-11 12:39:29 info : (1) [readwritesplit] (RW-Split-Router); Reply complete from 'server1' (OK: 0 warnings)
|
The result of this is that the dump may fail in confusing ways as the character sets and other variables aren't what they're supposed to be.