Env: Znuny 6.5.15, OS Rocky 9.6 x86_64, perl-5.32.1, mariadb 10.5.27, httpd (apache2) 2.4.62
Greetings,
I just completed a fork transition and stepped upgrade from Centuran 6.0.47 to Znuny 6.5.15. There are a few lingering issues (OAuth2 refresh) but one odd issue is long delays, up to a minute, when selecting reply in a ticket or after hitting send in a reply. I'm hoping someone can suggest where to look.
The upgrade path was: Centuran-6.0.47->Znuny-6.0.47 -> Znuny 6.1.2 -> Znuny-6.2.2 -> Znuny-6.3.4 -> Znuny-6.4.5 -> Znuny-6.5.15 and the full upgrade process was completed at each step version.
The delays go like this:
1. Zoomed into a ticket. Click reply box and select reply template.
2. New browser window opens for the reply but the browser window stays blank for 30-45 seconds, then populates with OTRS html and reply window content.
3. Complete reply and hit send button.
4. Send button grays out after being selected and the reply window hangs in that state for 30-45 seconds and then disappears.
5. The reply email does get sent and looks intact, uncorrupted or otherwise not truncated.
No Perl related errors in OTRS logs, no errors in httpd ssl_error log, nothing in dmesg or /var/log/messages, nothing serious in MariaDB error logs. No errors in the hypervisor running the vm instance where OTRS is located and running. All resources are local, local file system, etc. No remote DB, etc.
I verified httpd and mariadb settings per the fresh install instructions in the Znuny 6.5.15 tarball.
The two errors I did see I'm not yet sure what to do about or if it would effect this issue:
httpd: complains about running mpm_prefork_module with mod http2.
note: Znuny 6.5.15 instruction directed to disable mpm_event_module and enable mpm_prefork_module.
mariadb:
[ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
[ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU
[ERROR] mariadbd: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
[ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
Long delay when replying or sending reply (Znuny LTS 6.5.15)
Moderator: crythias