I don't get a lot of traffic on my installation, mainly because it's more for logging.
I tried to invite someone to use the platform and when they create a password, I get DB Error #1205
[INSERT INTO `ost_session` SET `session_id` = '3098kvn2irou0nrl23p7h9j9sc', `session_data` = 'csrf|N;', `session_expire` = (NOW() + INTERVAL 86400 SECOND), `user_ip` = '192.168.1.1']
Lock wait timeout exceeded; try restarting transaction<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(201): osTicket->logDBError()<br />
#1 (root)/include/class.orm.php(3466): db_query()<br />
#2 (root)/include/class.orm.php(658): MySqlExecutor->execute()<br />
#3 (root)/include/class.ostsession.php(227): VerySimpleModel->save()<br />
#4 (root)/include/class.ostsession.php(158): DbSessionBackend->update()<br />
#5 [internal function]: SessionBackend->write()<br />
#6 [internal function]: session_write_close()<br />
The server sits behind HA-Proxy, which handles certs. So user_ip will always = 192.168.1.1 (the gateway and HAProxy server)
I tried setting innodb_wait_timeout = 600 in /etc/mysql/mariadb.cnf and my.cnf, didn't seem to do anything. In fact, before I restarted mariadb, I got and error about the setting. I restarted anyway and it started without an issue. I removed the setting and restarted before posting this message.
Also note, I tried creating a dummy user for testing, all successful until 'set password' page. I let the the page sit for a good long while before I hit refresh. All the while I was receiving this error over and over again (around 60 times).
MySQL (MariaDB) 10.3.27
cgi.fix_pathinfo -- this is set to '1' in /etc/php/7.4/apache2/php.ini, however OSTicket still shows that it is not set.