Error with OTRS after upgrading Ubuntu from 18 to 20

[msksharma]

Hi All,

Today i was testing Ubuntu upgrade from 18 to 20 on my development system. After the upgrade, i rebooted the system. When i try to access OTRS web interface, i got this error message.

Lost connection to MySQL server at 'reading initial communication packet', system error: 104

Please contact the administrator.

Backend ERROR: OTRS-CGI-10 Perl: 5.30.0 OS: linux Time: Mon Jan 30 04:54:14 2023

Message: Lost connection to MySQL server at 'reading initial communication packet', system error: 104

RemoteAddress: 10.18.0.102
RequestURI: /otrs/index.pl

Traceback (776):
Module: Kernel::System::Web::InterfaceAgent::Run Line: 184
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler Line: 38
Module: (eval) (v1.99) Line: 207
Module: ModPerl::RegistryCooker::run (v1.99) Line: 207
Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 173
Module: ModPerl::Registry::handler (v1.99) Line: 32

Could you please help me out?

[msksharma]

The Issue got resolved. Apparently, there were 2 variables which was no longer supported.

#query_cache_limit = 1M
#query_cache_size = 16M

After i commented these 2 variables and restarted Mysql, it worked.