eraservice wont start

[lmbss 0]

I performed the recent updates presented and eraserver stopped starting with the following log

 

2023-04-08 15:36:36 Information: [Thread 7f6a931bf740]: Loading ESET modules from /var/opt/eset/RemoteAdministrator/Server/Modules/
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Local time is 2023-04-08 17:36:36
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: InstallConfiguration: ProductLine: era
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: InstallConfiguration: ProductVersion: 10.0.2133.0
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: InstallConfiguration: Locale: en_US
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: InstallConfiguration: ProductInstanceID: 29984224-2502-4f9e-b195-af26a1105659
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: InstallConfiguration: ProgramDataDirectory: /var/opt/eset/RemoteAdministrator/Server/
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: InstallConfiguration: ProductConfigurationDirectory: /etc/opt/eset/RemoteAdministrator/Server/
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: InstallConfiguration: ProgramLogsDirectory: /var/log/eset/RemoteAdministrator/Server/
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: InstallConfiguration: TempDirectory: /tmp/
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: InstallConfiguration: ProgramLibraryDirectory: /opt/eset/RemoteAdministrator/Server/
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: InstallConfiguration: ProgramEsetUpdatableModulesDirectory: /var/opt/eset/RemoteAdministrator/Server/Modules/
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: InstallConfiguration: CrashDumpsDirectory: /var/opt/eset/RemoteAdministrator/Server/Dumps/
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Hardware Fingerprint: 0100F868-EE89-1C3E-1984-EF1E42DA6B5E
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded ESET modules: 1=1079,18=1948,10=1281.1,46=1070,25=1130,40=2040.1
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Used memory before loaded module libraries is 54196 KB
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Translator
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Translator (used 1112 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Updates
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Updates (used 236 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Database
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Database (used 504 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library DataMiners
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library DataMiners (used 7668 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Scheduler
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Scheduler (used 276 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Security
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Security (used 308 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library NetworkGrpc
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library NetworkGrpc (used 504 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Network
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Network (used 604 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Cleanup
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Cleanup (used 124 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Symbols
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Symbols (used 164 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library DynamicGroups
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library DynamicGroups (used 160 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Tags
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Tags (used 172 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Indexer
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Indexer (used 160 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library RemoteDeployment
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library RemoteDeployment (used 492 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Replication
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Replication (used 980 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Reports
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Reports (used 512 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Automation
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Automation (used 764 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library StaticGroups
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library StaticGroups (used 1224 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library EmailSender
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library EmailSender (used 852 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library SNMPTrapSender
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library SNMPTrapSender (used 112 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library SyslogSender
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library SyslogSender (used 416 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library ReportPrinter
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library ReportPrinter (used 752 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library License
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library License (used 592 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Monitor
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Monitor (used 4 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Repository
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Repository (used 452 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Installers
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Installers (used 1304 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library LogExport
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library LogExport (used 292 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Policies
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Policies (used 272 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Users
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Users (used 344 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library ConsoleApi
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library ConsoleApi (used 3864 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library PushNotifications
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library PushNotifications (used 724 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Authentication
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Authentication (used 820 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library Encryption
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library Encryption (used 136 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading module library ExportImport
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loaded module library ExportImport (used 492 KB)
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Loading of modules took 51 milliseconds
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Used memory before modules load and initialization is 81588 KB
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Initializing module CTranslatorModule
2023-04-08 15:36:36 Information: CTranslatorModule [Thread 7f6a931bf740]: Registering translator resource
2023-04-08 15:36:36 Information: CTranslatorModule [Thread 7f6a931bf740]: Module successfully initialized
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Initialized module CTranslatorModule (used 256 KB) initialization took 0 milliseconds
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Initializing module CUpdatesModule
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Initialized module CUpdatesModule (used 540 KB) initialization took 0 milliseconds
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Initializing module CDatabaseModule
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Startup configuration builder builds successfully ...
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Startup connection pool created ...
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: ESMC microservice uuid = 29984224-2502-4f9e-b195-af26a1105659
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Static object event streaming enabled = 0
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Registering EventIniter Certificates with priority: 99996
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Registering EventIniter UserGroupsManagementMapper with priority: 99995
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Registering EventIniter StaticGroups with priority: 99999
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Registering EventIniter DynamicTemplates with priority: 100000
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Registering EventIniter PoliciesManagerMapper with priority: 99998
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Registering EventIniter AutomationStuff with priority: 99997
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Registering EventIniter AccessTokenMapper with priority: 99994
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Builder rebuilds successfully ...
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Connection pool recreated ...
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: ESMC microservice uuid = 29984224-2502-4f9e-b195-af26a1105659
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Static object event streaming enabled = 0
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Registering EventIniter Certificates with priority: 99996
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Registering EventIniter UserGroupsManagementMapper with priority: 99995
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Registering EventIniter StaticGroups with priority: 99999
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Registering EventIniter DynamicTemplates with priority: 100000
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Registering EventIniter PoliciesManagerMapper with priority: 99998
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Registering EventIniter AutomationStuff with priority: 99997
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: Registering EventIniter AccessTokenMapper with priority: 99994
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: CDBSetupperBase::PerformUpgradeIfNecessary: Checking if ETL DB is required
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: CDBSetupperBase::PerformUpgradeIfNecessary: ETL upgrade required.
2023-04-08 15:36:36 Information: CDatabaseModule [Thread 7f6a931bf740]: CDBSetupperBase::PerformUpgradeIfNecessary: Going to destroy tables because of previous fail: fact_fe_threat_event tbl_computers_aggr tbld_activethreats_status_engineversion tbld_application_identifier tbld_application_parameters tbld_apps_installed_status_name tbld_apps_installed_status_vendor tbld_cause tbld_computers_comment tbld_computers_name tbld_devicecontrol_device_event_device tbld_deviceinformation_device_status_manufacturer tbld_deviceinformation_device_status_model tbld_devicelocation_gps_status_provider tbld_diagnostics_diagnosticzip_event_data tbld_enterpriseinspectoralert_event_rulename tbld_exportedconfiguration_event_configuration tbld_firewallagregated_event_protocol tbld_hwinventory_chassis_status_description tbld_hwinventory_chassis_status_manufacturer tbld_hwinventory_display_status_description tbld_hwinventory_display_status_manufacturer tbld_hwinventory_displayadapter_status_description tbld_hwinventory_displayadapter_status_manufacturer tbld_hwinventory_inputdevice_status_description tbld_hwinventory_inputdevice_status_manufacturer tbld_hwinventory_massstorage_status_description tbld_hwinventory_massstorage_status_manufacturer tbld_hwinventory_networkadapter_status_description tbld_hwinventory_networkadapter_status_manufacturer tbld_hwinventory_printer_status_description tbld_hwinventory_processor_status_description tbld_hwinventory_processor_status_manufacturer tbld_hwinventory_ram_status_description tbld_hwinventory_ram_status_manufacturer tbld_hwinventory_sounddevice_status_description tbld_hwinventory_sounddevice_status_manufacturer tbld_identifiers_list_status_value tbld_ip_mask tbld_loggedusers_list_status_domain tbld_loggedusers_list_status_fullname tbld_loggedusers_list_status_name tbld_osinformation_edition_status_os_info_edition tbld_osinformation_locale_status_os_locale_language tbld_osinformation_timezone_status_time_zone_name_offset tbld_processname tbld_quarantine_uploadedfile_event_password tbld_quarantine_uploadedfile_event_path tbld_rdsensor_newcomputers_status_computer_identifier tbld_rdsensor_newcomputers_status_ipv4ipv6 tbld_rdsensor_newcomputers_status_mergedidentifier tbld_rdsensor_newcomputers_status_netcardvendor tbld_rdsensor_newcomputers_status_osname tbld_remote_host tbld_rulename tbld_scantargetsid tbld_security_product_status_nameversion tbld_srvsecproduct_scantargets_status_data tbld_static_groups_comment tbld_static_groups_name tbld_submittedfiles_event_username tbld_sysinspector_sysinspector_event_logdata tbld_threat_event_engineversion tbld_threatname tbld_used_license_status_licenseid_licenseproductname tbld_usergroup tbld_username tblf_activethreats_status tblf_applicationactivationmatrix_status tblf_appliedpoliciescount_status tblf_appliedpolicieslist_status tblf_appliedpolicyproducts_status tblf_apps_currentversion_status tblf_apps_installed_status tblf_apps_securitystatus_status tblf_apps_versioncheck_status tblf_audit_event tblf_blockedfiles_event tblf_certificates_peercertificate_status tblf_computer_connected_event tblf_computer_lost_event tblf_computercloningtickets_status tblf_computeridentityrecovered_event tblf_computerlocationmembership_status tblf_devicecontrol_device_event tblf_deviceinformation_device_status tblf_devicelocation_gps_status tblf_diagnostics_devicecontrol_device_event tblf_diagnostics_diagnosticzip_event tblf_diagnostics_firewall_event tblf_diagnostics_hips_event tblf_diagnostics_spam_event tblf_diagnostics_webcontrol_link_event tblf_dynamicgroups_content_status tblf_dynamicgroupsmembership_status tblf_dynamicthreatdetectionanalyses_status tblf_dynamicthreatdetectionglobalcustomersstatistics_status tblf_dynamicthreatdetectionglobaldetectionstatistics_status tblf_eesevent__event tblf_eesvirusdb_status tblf_encryption_storage_status tblf_enterpriseinspectoralert_event tblf_enterpriseinspectorincidentstatistics_status tblf_enterpriseinspectoroverview_status tblf_enterpriseinspectoroverviewtotals_status tblf_epns_status tblf_exclusionhitsagregated__event tblf_exclusionhitssummary_status tblf_exportedconfiguration_event tblf_featurestatus_status tblf_filteredwebsites_event tblf_firewallagregated_event tblf_functionality_computer_status tblf_functionality_problemsdetails_status tblf_functionality_products_status tblf_hipsagregated_event tblf_hwinventory_chassis_status tblf_hwinventory_display_status tblf_hwinventory_displayadapter_status tblf_hwinventory_inputdevice_status tblf_hwinventory_massstorage_status tblf_hwinventory_networkadapter_status tblf_hwinventory_printer_status tblf_hwinventory_processor_status tblf_hwinventory_ram_status tblf_hwinventory_sounddevice_status tblf_identifiers_list_status tblf_livegrid_status tblf_location_status tblf_loggedusers_list_status tblf_managed_products_status tblf_mdm_core_status tblf_mdm_enrollmenturls_status tblf_mdm_reenrollmenturls_status tblf_network_adapters_status tblf_network_ipaddresses_status tblf_network_mobile_status tblf_newcomputerenrolled_event tblf_osinformation_computerstarttime_status tblf_osinformation_edition_status tblf_osinformation_locale_status tblf_osinformation_timezone_status tblf_performance_server_event tblf_performance_server_state_status tblf_qos_database_event tblf_qos_network_event tblf_quarantine_content_status tblf_quarantine_uploadedfile_event tblf_rdsensor_newcomputers_status tblf_repository_agent_status tblf_repository_epi_status tblf_repository_server_status tblf_repository_software_status tblf_scan_event tblf_security_product_status tblf_serverseatchanged_event tblf_spam_topdomains_status tblf_spam_toprecipients_status tblf_spam_topsenders_status tblf_srvsecproduct_scantargets_status tblf_static_groups tblf_storage_capacity_status tblf_storage_list_status tblf_submittedfiles_event tblf_sysinspector_sysinspector_event tblf_task_client_event tblf_task_client_trigger_notification_event tblf_task_detail_agentdeployment_status tblf_task_server_status tblf_threat_event tblf_threatsmute_event tblf_threatsmuteeitoera_event tblf_threatsmuteeratoei_event tblf_tryandbuyfeatures_status tblf_used_license_status tblf_webcontrolagregated_event
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Unloading module: CUpdatesModule
2023-04-08 15:36:36 Information: Kernel [Thread 7f6a931bf740]: Unloading module: CTranslatorModule
2023-04-08 15:36:36 Error: Service [Thread 7f6a931bf740]: Service run-time failed with: [MySQL][ODBC 8.0(w) Driver][mysqld-5.6.50]Unknown table 'era_db.fact_fe_threat_event'

i need help to resolve this problem

[Marcos 4,915]

Our recommendation is to create a dump of the current db, migrate/deploy a new PROTECT Server with clean db. All necessary certificates and CA can be taken from the db dump.

In order to troubleshoot db related issues like that, please open a support ticket.

[lmbss 0]

How to open a support ticket?

[Marcos 4,915]

You can go through the wizard at https://go.eset.com/contact-support/ to create a ticket in the last step.