Errors after rebuild WebIssues server

Submitted by shaupt on 2021-12-20

Hello all,

we had to rebuild our old WebIssues server because the operating system version is no longer supported. The new server uses AlmaLinux 8.5 and WebIssues version 1.1.5. The Database is the same as before.

Datenbankserver:MySQL 5.5.5-10.3.28-MariaDB

PHP-Version:7.2.24 (fpm-fcgi)

Web-Server:Apache/2.4.37 (AlmaLinux) OpenSSL/1.1.1k

Currently we always get errors when running the cronjob.

And we get errors when a user logs in who is not an admin user.

Unhandled System_Db_Exception: in /localhome/htdocs/webissues-server/system/db/mysqli/engine.inc.php on line 287
Stack trace:
#0 /localhome/htdocs/webissues-server/system/db/mysqli/engine.inc.php(110): System_Db_Mysqli_Engine->handleError(Object(mysqli))
#1 /localhome/htdocs/webissues-server/system/db/mysqli/engine.inc.php(90): System_Db_Mysqli_Engine->executeStatement('SELECT COUNT(*)...', Array)
#2 /localhome/htdocs/webissues-server/system/db/connection.inc.php(256): System_Db_Mysqli_Engine->query('SELECT COUNT(*)...', Array)
#3 /localhome/htdocs/webissues-server/system/db/connection.inc.php(356): System_Db_Connection->queryArgs('SELECT COUNT(*)...', Array)
#4 /localhome/htdocs/webissues-server/system/db/connection.inc.php(343): System_Db_Connection->queryScalarArgs('SELECT COUNT(*)...', Array)
#5 /localhome/htdocs/webissues-server/system/api/projectmanager.inc.php(683): System_Db_Connection->queryScalar('SELECT COUNT(*)...', 2, 2)
#6 /localhome/htdocs/webissues-server/client/projectstree.inc.php(66): System_Api_ProjectManager->getProjectsCount()
#7 /localhome/htdocs/webissues-server/system/web/component.inc.php(100): Client_ProjectsTree->execute()
#8 /localhome/htdocs/webissues-server/system/web/view.inc.php(247): System_Web_Component->run()
#9 /localhome/htdocs/webissues-server/client/index.html.php(22): System_Web_View->insertComponent('Client_Projects...')
#10 /localhome/htdocs/webissues-server/system/web/view.inc.php(284): include('/localhome/htdo...')
#11 /localhome/htdocs/webissues-server/system/web/view.inc.php(217): System_Web_View->executeTemplate()
#12 /localhome/htdocs/webissues-server/system/web/component.inc.php(102): System_Web_View->render()
#13 /localhome/htdocs/webissues-server/system/web/application.inc.php(77): System_Web_Component->run()
#14 /localhome/htdocs/webissues-server/system/core/application.inc.php(210): System_Web_Application->execute()
#15 /localhome/htdocs/webissues-server/system/bootstrap.inc.php(130): System_Core_Application->run()
#16 /localhome/htdocs/webissues-server/client/index.php(61): System_Bootstrap::run('Common_Applicat...', 'Client_Index')
#17 {main}

Where could be the problem?

Thank you for support...

Sigrid

I suspect that it's the well known "Prepared statement needs to be re-prepared" problem. It can be fixed by changing the configuration of MySQL or by upgrading to the latest version of WebIssues, where this problem no longer occurs.

Regards,
Michał

configuration of MySQL is as follows

[mysqld]
max_connect_errors = 100
max_connections=2000
open_files_limit = 16484
max_allowed_packet = 512M
read_buffer_size = 256K
read_rnd_buffer_size = 512K
innodb_log_file_size = 2GB
log-bin=/datastore/binlogs/bin.log
log-bin-index=/datastore/binlogs/bin-log.index
binlog-format=row
server-id=0
expire_logs_days=3
table_open_cache=16384
table_definition_cache=16384
tmp_table_size=64M
join_buffer_size=512k
innodb_file_per_table=1

Shoud we increase table_open_cache and table_definition_cache?

How can we get a more detailed error message (log level, trace level) ?

Best regards

Sigrid

You can try, but it already seems quite large. I just found another potential source of the problem - when you moved the database to a new server, the owner of the effective_right view could be restored incorrectly - see this thread in the forum.

Regards,
Michał

Thanks for the helpful tip. That was exactly the problem. We changed the DEFINER in the view effective_right and SQL SECURITY to INVOKER. After that, no more error messages came and the cron job now works without errors.

Best regards

Sigrid

But we have now found one problem after all. The event log contains the following message

PHP Warning: count(): Parameter must be an array or an object that implements Countable in /localhome/htdocs/webissues-server/system/api/querygenerator.inc.php on line 693

What can we do to fix the problem?

Best Regards

Sigrid

It’s a known bug in version 1.1.5. You can upgrade to version 2.0 or just fix one line of code as described here.

Regards,

Michał

Thanks for the info. We have fixed the one line and will plan the upgrade soon.

Our system administrator now has enabled selinux for the server.

We get an error message when uploading files as task attachments.

Is there any guidance for webissues on what to set for selinux?

What else could be the problem?

The error message does not say what the problem is but only that there is a problem. How can we create a more meaningful error message.

Best Regards,

Sigrid