ESMC server service crashing

[ewong 8]

Hi,

Kinda feel like I'm digging an even bigger hole.  The certificate issue hasn't even been fixed, and now I'm getting a DB error:

2019-12-14 04:38:44 Information: CDatabaseModule [Thread 1a40]: Loading of tags starting.
2019-12-14 04:38:44 Information: CDatabaseModule [Thread 1a40]: #rows in blobs: 0
2019-12-14 04:38:44 Information: CDatabaseModule [Thread 1a40]: #column-attrs: 2
2019-12-14 04:38:44 Information: CDatabaseModule [Thread 1a40]: #rows: 0
2019-12-14 04:38:44 Information: CDatabaseModule [Thread 1a40]: Compaction from Load()
2019-12-14 04:38:44 Information: CDatabaseModule [Thread 1a40]: CExecutor.CCompactionState: Changing error from NoError to GeneralError.
2019-12-14 04:38:44 Information: CDatabaseModule [Thread 1a40]: CExecutor.CCompactionState: Request to change error from GeneralError to GeneralError ignored. Another error allready set.
2019-12-14 04:38:44 Information: Kernel [Thread 1a40]: Unloading module: CDynamicGroupsModule
2019-12-14 04:38:44 Information: Kernel [Thread 1a40]: Unloading module: CSymbolsModule
2019-12-14 04:38:44 Information: Kernel [Thread 1a40]: Unloading module: CCleanupModule
2019-12-14 04:38:44 Information: Kernel [Thread 1a40]: Unloading module: NetworkModule
2019-12-14 04:38:44 Information: Kernel [Thread 1a40]: Unloading module: CNetworkGrpcModule
2019-12-14 04:38:44 Information: Kernel [Thread 1a40]: Unloading module: CServerSecurityModule
2019-12-14 04:38:44 Information: Kernel [Thread 1a40]: Unloading module: SchedulerModule
2019-12-14 04:38:44 Information: Kernel [Thread 1a40]: Unloading module: CDataMinersModule
2019-12-14 04:38:44 Information: Kernel [Thread 1a40]: Unloading module: CDatabaseModule
2019-12-14 04:38:44 Information: Kernel [Thread 1a40]: Unloading module: CUpdatesModule
2019-12-14 04:38:44 Information: Kernel [Thread 1a40]: Unloading module: CTranslatorModule
2019-12-14 04:38:44 Error: Service [Thread 1a40]: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.27]Got a packet bigger than 'max_allowed_packet' bytes (1153)

I'm not entirely sure which setting made the service crash every time I start it.  

(I'm beginning to feel it's better if I just killed the whole setup and re-install everything...  worst case scenario, of course.)

Thanks

Edmund

Edited December 14, 2019 by ewong
added a bit more context to the log

[MartinK 378]

Could you verify MySQL configuration, especially in terms of values required by ESMC to work properly? Maybe parameter

max_allowed_packet

  is not configured properly and is lower than required 33M? Default is 4M which is not sufficient for ESMC to work properly.