Содержание
Saved searches
Use saved searches to filter your results more quickly
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Error: Illegal mix of collations #18
Error: Illegal mix of collations #18
Comments
2020/04/06 20:10:56 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp' -- 2020/04/06 20:10:56 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[50]:cycle_graphs(), /plugins/cycle/cycle.php[88]:get_next_graphid(), /plugins/cycle/functions.php[295]:db_fetch_assoc(), /lib/database.php[473]:db_fetch_assoc_prepared(), /lib/database.php[487]:db_execute_prepared()) 2020/04/06 20:10:56 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp' 2020/04/06 20:10:56 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[50]:cycle_graphs(), /plugins/cycle/cycle.php[88]:get_next_graphid(), /plugins/cycle/functions.php[295]:db_fetch_assoc(), /lib/database.php[473]:db_fetch_assoc_prepared(), /lib/database.php[487]:db_execute_prepared()) 2020/04/06 20:10:56 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[50]:cycle_graphs(), /plugins/cycle/cycle.php[88]:get_next_graphid(), /plugins/cycle/functions.php[295]:db_fetch_assoc(), /lib/database.php[473]:db_fetch_assoc_prepared(), /lib/database.php[487]:db_execute_prepared()) The text was updated successfully, but these errors were encountered:
utf8mb4_unicode became a requirement to properly handle foreign characters issued by both end users and devices. Without it, characters could become improperly handled, display and stored. It is a documented pre-requisite of Cacti since 1.2.0
However, because it can take time to convert a large number of tables, we do not force this change, but give the operator an option to do it during upgrade. After upgrade, the command line program should be used.
Much like the requirements to use barracuda, innodb and large prefixes have all become requirements under 1.2.x due to the number of tables, key sizes etc.
if you install cycle plugin it breaks cacti completely, had to rm -rf the dir to regain access to it.
the only thing that i do not have set is collation server.
version | 10.3.22-MariaDB-log | >= | 5.6 | MySQL 5.6+ and MariaDB 10.0+ are great releases, and are very good versions to choose. Make sure you run the very latest release though which fixes a long standing low level networking issue that was causing spine many issues with reliability. -- | -- | -- | -- | -- collation_server | utf8mb4_general_ci | = | utf8mb4_unicode_ci | When using Cacti with languages other than English, it is important to use the utf8mb4_unicode_ci collation type as some characters take more than a single byte. character_set_client | utf8mb4 | = | utf8mb4 | When using Cacti with languages other than English, it is important to use the utf8mb4 character set as some characters take more than a single byte. it breaks all spine polling, i cant troubleshoot when its installed. no poller running and no graphs created.
I had to remove the plugin all together to get the system back in control. I will look at ti again tomorrow, but when installed it breaks things badly.
There is a convert_table.php script in the cli directory that gets most of it, but I don’t think it sets the database collation and charset for new tables. It should do that maybe. I know the installer warns, but maybe not on and upgrade? I thought it always did.
I was of the opinion that the installer always warned about tables. As for server collation, that should be on the MySQL requirements section.
The warnings start by saying «When using Cacti with languages other than English» which indicates that people using English can ignore.
The errors exist even when collation is set as recommended. This plugin takes down the system when installed and enabled.
MariaDB [(none)]> SELECT * FROM INFORMATION_SCHEMA.SCHEMATA; +--------------+--------------------+----------------------------+------------------------+----------+ | CATALOG_NAME | SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH | +--------------+--------------------+----------------------------+------------------------+----------+ | def | information_schema | utf8 | utf8_general_ci | NULL | | def | test | utf8mb4 | utf8mb4_unicode_ci | NULL | | def | cacti | utf8mb4 | utf8mb4_unicode_ci | NULL | | def | mysql | utf8mb4 | utf8mb4_unicode_ci | NULL | | def | performance_schema | utf8 | utf8_general_ci | NULL | | def | syslog | utf8 | utf8_general_ci | NULL | +--------------+--------------------+----------------------------+------------------------+----------+ # tail -n 100 /var/log/cacti.log 2020/04/07 09:59:00 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[50]:cycle_graphs(), /plugins/cycle/cycle.php[88]:get_next_graphid(), /plugins/cycle/functions.php[295]:db_fetch_assoc(), /lib/database.php[473]:db_fetch_assoc_prepared(), /lib/database.php[487]:db_execute_prepared()) 2020/04/07 09:59:00 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp' 2020/04/07 09:59:00 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[50]:cycle_graphs(), /plugins/cycle/cycle.php[88]:get_next_graphid(), /plugins/cycle/functions.php[295]:db_fetch_assoc(), /lib/database.php[473]:db_fetch_assoc_prepared(), /lib/database.php[487]:db_execute_prepared()) 2020/04/07 09:59:00 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp' 2020/04/07 09:59:00 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[50]:cycle_graphs(), /plugins/cycle/cycle.php[88]:get_next_graphid(), /plugins/cycle/functions.php[295]:db_fetch_assoc(), /lib/database.php[473]:db_fetch_assoc_prepared(), /lib/database.php[487]:db_execute_prepared()) 2020/04/07 09:59:00 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp' 2020/04/07 09:59:00 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[50]:cycle_graphs(), /plugins/cycle/cycle.php[88]:get_next_graphid(), /plugins/cycle/functions.php[295]:db_fetch_assoc(), /lib/database.php[473]:db_fetch_assoc_prepared(), /lib/database.php[487]:db_execute_prepared()) 2020/04/07 09:59:00 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp' 2020/04/07 09:59:00 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[50]:cycle_graphs(), /plugins/cycle/cycle.php[88]:get_next_graphid(), /plugins/cycle/functions.php[295]:db_fetch_assoc(), /lib/database.php[473]:db_fetch_assoc_prepared(), /lib/database.php[487]:db_execute_prepared()) 2020/04/07 09:59:00 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp' 2020/04/07 09:59:00 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[50]:cycle_graphs(), /plugins/cycle/cycle.php[88]:get_next_graphid(), /plugins/cycle/functions.php[295]:db_fetch_assoc(), /lib/database.php[473]:db_fetch_assoc_prepared(), /lib/database.php[487]:db_execute_prepared()) 2020/04/07 09:59:00 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp' 2020/04/07 09:59:00 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[50]:cycle_graphs(), /plugins/cycle/cycle.php[88]:get_next_graphid(), /plugins/cycle/functions.php[295]:db_fetch_assoc(), /lib/database.php[473]:db_fetch_assoc_prepared(), /lib/database.php[487]:db_execute_prepared()) 2020/04/07 09:59:00 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp' 2020/04/07 09:59:00 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[50]:cycle_graphs(), /plugins/cycle/cycle.php[88]:get_next_graphid(), /plugins/cycle/functions.php[295]:db_fetch_assoc(), /lib/database.php[473]:db_fetch_assoc_prepared(), /lib/database.php[487]:db_execute_prepared()) 2020/04/07 09:59:00 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp' 2020/04/07 09:59:00 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[50]:cycle_graphs(), /plugins/cycle/cycle.php[88]:get_next_graphid(), /plugins/cycle/functions.php[295]:db_fetch_assoc(), /lib/database.php[473]:db_fetch_assoc_prepared(), /lib/database.php[487]:db_execute_prepared()) 2020/04/07 09:59:00 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp' 2020/04/07 09:59:00 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[50]:cycle_graphs(), /plugins/cycle/cycle.php[88]:get_next_graphid(), /plugins/cycle/functions.php[295]:db_fetch_assoc(), /lib/database.php[473]:db_fetch_assoc_prepared(), /lib/database.php[487]:db_execute_prepared()) 2020/04/07 09:59:00 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp' 2020/04/07 09:59:00 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[50]:cycle_graphs(), /plugins/cycle/cycle.php[88]:get_next_graphid(), /plugins/cycle/functions.php[295]:db_fetch_assoc(), /lib/database.php[473]:db_fetch_assoc_prepared(), /lib/database.php[487]:db_execute_prepared()) 2020/04/07 09:59:00 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp' 2020/04/07 09:59:00 - ERROR PHP ERROR: Maximum execution time of 300 seconds exceeded in file: /var/www/localhost/htdocs/cacti/lib/functions.php on line: 960 2020/04/07 09:59:00 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler()) 2020/04/07 09:59:00 - CMDPHP ERROR: A DB Cell Failed!, Error: PDOStatement::execute(): send of 37 bytes failed with errno=32 Broken pipe 2020/04/07 09:59:00 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[29]:include_once(), /include/auth.php[28]:require_once(), /include/global.php[502]:include_once(), /include/global_languages.php[64]:read_user_i18n_setting(), /include/global_languages.php[668]:db_table_exists(), /lib/database.php[768]:db_fetch_cell(), /lib/database.php[383]:db_fetch_cell_prepared(), /lib/database.php[399]:db_execute_prepared()) 2020/04/07 09:59:00 - CMDPHP ERROR: A DB Cell Failed!, Error: MySQL server has gone away 2020/04/07 09:59:00 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[29]:include_once(), /include/auth.php[28]:require_once(), /include/global.php[508]:include_once(), /include/global_arrays.php[971]:db_table_exists(), /lib/database.php[768]:db_fetch_cell(), /lib/database.php[383]:db_fetch_cell_prepared(), /lib/database.php[399]:db_execute_prepared()) 2020/04/07 09:59:00 - CMDPHP ERROR: A DB Cell Failed!, Error: MySQL server has gone away 2020/04/07 09:59:00 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[29]:include_once(), /include/auth.php[28]:require_once(), /include/global.php[508]:include_once(), /include/global_arrays.php[1482]:is_realm_allowed(), /lib/auth.php[711]:is_user_perms_valid(), /lib/auth.php[2669]:db_fetch_cell_prepared(), /lib/database.php[399]:db_execute_prepared()) 2020/04/07 09:59:00 - CMDPHP ERROR: A DB Cell Failed!, Error: MySQL server has gone away 2020/04/07 09:59:00 - CMDPHP SQL Backtrace: (/plugins/cycle/cycle.php[29]:include_once(), /include/auth.php[28]:require_once(), /include/global.php[508]:include_once(), /include/global_arrays.php[1482]:is_realm_allowed(), /lib/auth.php[712]:db_table_exists(), /lib/database.php[768]:db_fetch_cell(), /lib/database.php[383]:db_fetch_cell_prepared(), /lib/database.php[399]:db_execute_prepared())