Mysql issues – license statistics – x-formation documentation
During the License Statistics evaluation, you may have License Statistics temporarily running on a machine that does not meet the minimum system requirements. Data recovery google store In such cases where there is not enough memory on the machine hosting the License Statistics installation , the MySQL server may not start properly the first time you start License Statistics, which will produce warnings similar to the following in the xflicstat.log file:
You can check whether insufficient memory is the problem by looking at the MySQL server log file, which can be found in one of the following directories:
– mysql_error.log and/or hostname.err under data folder in mysql_x86 directory (or mysql_x64 or mysql for License Statistics v4.19.1 and newer ).
To resolve this issue, you can try lowering the memory requirement in the config.ini file by changing the innodb_buffer_pool_size setting to the desired value; for example, to 1024M or as low as 512M, depending on available resources.
This setting may be changed only for testing purposes (for example, during evaluation). Database works The proper solution is to install License Statistics on a machine that meets system requirements . Data recovery cheap Note that lowering the innodb_buffer_pool_size setting may decrease the performance of License Statistics, causing it to run slower. Database of state incentives for renewables and efficiency Lost connection to MySQL server during query
The above message indicates that your MySQL server settings should be adjusted.
Data recovery usb stick To resolve this issue, follow the configuration instructions described in Using an external MySQL database. Database companies You can also find more information about this problem in the MySQL reference manual. Database application “Specified key was too long; max key length is 767 bytes” error
To resolve this issue, you can also upgrade License Statistics that uses an embedded MySQL database to License Statistics using an external MySQL database. Database online If this does not resolve the problem, you can try upgrading License Statistics from an external to embedded database. Database high availability Different versions of MySQL database
When the version of your database is different than the version of the database provided by X-Formation, you may get error messages similar to the following in the License Statistics log file:
[ERROR] mysql: missing sql_mode variables: STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_UNSIGNED_SUBTRACTION
• Find the following variables in the my.ini file: sql_mode = STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_UNSIGNED_SUBTRACTION
• Enclose these variables in quotation marks, as shown below. Database utility sql_mode = “STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_UNSIGNED_SUBTRACTION”
[ERROR] update: cannot obtain ‘xformation’ database version: “Error 1146: Table ‘xformation.Version’ doesn’t exist” [ERROR] License Statistics C++ Core stopped with error: “update: cannot obtain ‘xformation’ database version: \”Error 1146: Table ‘xformation.Version’ doesn’t exist\””.
To resolve this problem, you need to open your currently used mysql configuration file (my.ini) and find lower_case_table_names variable. Data recovery zagreb The default value of this variable is
To resolve this issue, you can temporarily disable the license server using the Realtime License Servers tab in the Administration page and start deleting data. Database administrator jobs If you have many license servers for which you want to delete data, contact X-Formation Support for assistance.