Jump to content

ESMC VA eraserver crashing after upgrading external mysql to 5.7


maniel
 Share

Recommended Posts

We recently upgraded to ESMC from ERA 6.5, we stumbled upon some performance problems (timeouts in web console), wanting to debug if it's a problem with our docker-deployed mysql 5.6.41 i installed mysql 5.7 on host machine, imported db and tried to connect VA to it. The eraserver service seems to fails, there is no crash related info in /var/log/eset/RemoteAdministrator/Server/trace.log, it seems to exit after following info:

Quote

2018-08-28 10:37:11 Information: Kernel [Thread 7fe6aa5bb740]: Initialized module CDatabaseModule (used 18664 KB)

 

Link to comment
Share on other sites

  • ESET Staff

Could you please check content of folder /var/opt/eset/RemoteAdministrator/Server/Dumps for possible crash dumps? If you execute ERAServer process manually from root terminal, does it provide more details in console output (before starting, service eraserver stop to disable service startup will be required)?

Link to comment
Share on other sites

It says this:

[root@era ~]# /opt/eset/RemoteAdministrator/Server/ERAServer
Loading kernel
Logging to directory /var/log/eset/RemoteAdministrator/Server/
ERAServer: /export/home2/pb2/build/sb_1-28191188-1523532795.64/rpm/BUILD/mysql-connector-odbc-8.0.11-src/driver/my_prepared_stmt.cc:135: int ssps_get_out_params(STMT*): Assertion `values' failed.
Created mini-dump: /var/opt/eset/RemoteAdministrator/Server/Dumps/Local/455c2741-a7ca-4486-1fb0ba8a-11e04845.dmp
Aborted
[root@era ~]#

Ill send you a dump by PM

MySQL version is  5.7.23-0ubuntu0.16.04.1, i remember the same happening when after upgrading docker deployed database to mysql:5.7.23

Edited by maniel
Link to comment
Share on other sites

  • ESET Staff
7 hours ago, maniel said:

It says this:


[root@era ~]# /opt/eset/RemoteAdministrator/Server/ERAServer
Loading kernel
Logging to directory /var/log/eset/RemoteAdministrator/Server/
ERAServer: /export/home2/pb2/build/sb_1-28191188-1523532795.64/rpm/BUILD/mysql-connector-odbc-8.0.11-src/driver/my_prepared_stmt.cc:135: int ssps_get_out_params(STMT*): Assertion `values' failed.
Created mini-dump: /var/opt/eset/RemoteAdministrator/Server/Dumps/Local/455c2741-a7ca-4486-1fb0ba8a-11e04845.dmp
Aborted
[root@era ~]#

Ill send you a dump by PM

MySQL version is  5.7.23-0ubuntu0.16.04.1, i remember the same happening when after upgrading docker deployed database to mysql:5.7.23

As I wrote in PM, problem will be most probably with MySQL ODBC driver v8. We have been aware of this issues, but left v8 driver in appliance, because t worked in combination with MySQL 5.6 available in appliance. My recommendations is to downgrade MySQL ODBC driver to version 5.3, which should work both with MySQL 5.6 and also MySQL 5.7.

Link to comment
Share on other sites

thanks for reply, it works with `mysql-connector-odbc.x86_64-5.3.10-1.el7` from `mysql-connectors-community` repo, other versions i tried generated following error:

2018-08-29 19:46:29 Error: Service [Thread 7f0163e66740]: [MySQL][ODBC 5.3(w) Driver][mysqld-5.6.41]Duplicate entry 'db_starschema' for key 'PRIMARY'

on the side note I've learned howto use yum:)

Link to comment
Share on other sites

  • 2 weeks later...
Guest
This topic is now closed to further replies.
 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...