MySQL Error number: MY-013189; Symbol: ER_SYS_VAR_NOT_FOUND; SQLSTATE: HY000 报错 故障修复 远程处理

文档解释

Error number: MY-013189; Symbol: ER_SYS_VAR_NOT_FOUND; sqlSTATE: HY000

Message: Variable name ‘%s’ not found.

Error MY-013189 ( ER_SYS_VAR_NOT_FOUND) is thrown by Mysql when a query is perfORMed which references a system variable that does not exist.

Error Message:

SQLSTATE[HY000]: General error: 13183 Variable ‘%s’ not found.

Explanations:

Error MY-013189 occurs when a variable is referenced that does not exist. This might happen when the variable is misspelled, or not declared.

Common cases:

When a system variable is defined, or someone is trying to change the value of an existing system variable, they might mistype the variable name.

When a system variable is referenced but is not defined, it leads to this error message.

Solution:

To resolve this issue, make sure to use the correct spelling and case of the system variable name in the query. When defining a system variable, make sure that the variable is known in the scope of the session.

Check for typos in the variable name and make sure the variable is actually defined.