Community
User Guides
Support
Community
Help Forums
English Forum
General
About our Community
General Discussion
News and Feedback
Products
F-Secure SAFE
F-Secure FREEDOME
F-Secure KEY
F-Secure SENSE Router
F-Secure ID PROTECTION
Other products
Beta programs
Feature Requests
Finnish Forum (Tukifoorumi)
Tuotteet Kotiin
F-Secure SAFE
F-Secure FREEDOME
F-Secure KEY
F-Secure SENSE Router
F-Secure ID PROTECTION
Muut tietoturvatuotteet
Support Articles
Language
English
Suomi
Deutsch
Français
日本語
Svenska
Dansk
Italiano
Nederlands
Norsk
Polski
中文 (繁體)
Products & Services
F-Secure TOTAL
F-Secure SAFE / Internet Security / Anti-Virus
F-Secure FREEDOME
F-Secure KEY
F-Secure SENSE Router
F-Secure ID PROTECTION
Other products
Common topics
User Guides
Support
Login
|
Register
Console login error with Policy Manager using external MySQL database - F-Secure Community
<main> <article class="userContent"> <h3 data-version="2" data-article="000016309">Issue:</h3> <p>Logging in to the Policy Manager Console returns an error message: "F-Secure Policy Manager Console cannot start: internal error. See Administrator.error.log for more information."<br><br>The Administrator.error.log contains several SQL-related entries with "error code [1206]:The total number of locks exceeds the lock table size"</p> <h3>Resolution:</h3> <p>These SQL-errors are in most cases related to the value <b>innodb_buffer_pool_size</b>, and increasing this value usually fixes the issues. The value is verified by looking it up in the <b>my.ini </b>file on the MySQL-server, where it can also be increased as needed. <br><br>Due to the large possible variations in user environments we are not able to give a direct number that this value should be set to. You can look for additional guidance from the <a rel="nofollow" href="http://mysql.localhost.net.ar/doc/refman/5.4/en/innodb-parameters.html#sysvar_innodb_buffer_pool_size">MySQL Reference Manual</a> and try an incremental approach, making several smaller changes and monitoring the results.<br><br>After modifying the value in the <b>my.ini </b>file, restart the MySQL-server and the Policy Manager Server to make sure everything is running with the latest configuration.<br><br><b>Note:</b> Observe that getting or setting the value through Command line does not show or modify the correct value for every version of MySQL. To guarantee that the value is set correctly all changes need to happen via interaction with the <b>my.ini </b>file.</p> <p>Article no: 000016309</p> </article> </main>