Error
Error Code:
1122
MariaDB Error 1122: Cannot Load User-Defined Function
Description
MariaDB Error 1122, 'Can't load function', indicates that the server attempted to load a User-Defined Function (UDF) but failed. This typically occurs when executing a `CREATE FUNCTION` statement or calling a UDF, and the server cannot locate, access, or properly initialize the associated shared library file.
Error Message
Can't load function '%s'
Known Causes
4 known causesMissing UDF Library File
The shared library file (.so for Linux/macOS, .dll for Windows) for the UDF does not exist in the expected directory, or the path specified during `CREATE FUNCTION` is incorrect.
Insufficient File Permissions
The MariaDB server process lacks the necessary read and execute permissions for the UDF library file or its containing directory, preventing it from accessing the file.
Corrupt or Incompatible Library
The UDF shared library file might be corrupt, compiled for an incompatible architecture or operating system, or contains unresolved symbols, making it unreadable by MariaDB.
Incorrect `plugin_dir` Setting
The `plugin_dir` system variable in MariaDB is configured incorrectly, causing the server to look for UDF libraries in the wrong default location.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service