SuiteCRM slow - [ERROR] Unable to find relationship

anils · 27 June 2023 17:14

SuiteCRM 8.1, freshly installed, runs slow. Queries take a long time to execute. When I look at the log:

Search:
Reg Exp:
Ignore Self:
Displaying Log
Your process ID [10406]
Your IP Address is 182.69.182.54
Tue Jun 27 16:58:39 2023 [1482][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:39 2023 [1482][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:40 2023 [1482][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:40 2023 [1482][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship projects_users_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship am_projecttemplates_users_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship projects_users_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship am_projecttemplates_users_resources
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:58:48 2023 [1577][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:17 2023 [1873][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:17 2023 [1873][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:17 2023 [1873][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:17 2023 [1873][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship projects_users_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship am_projecttemplates_users_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship projects_users_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship am_projecttemplates_users_resources
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 16:59:28 2023 [1976][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:01 2023 [9671][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:01 2023 [9671][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:01 2023 [9671][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:01 2023 [9671][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship projects_users_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship am_projecttemplates_users_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship projects_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship am_projecttemplates_contacts_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship projects_users_resources
Tue Jun 27 17:10:10 2023 [10101][1][ERROR] Unable to find relationship am_projecttemplates_users_resources
Tue Jun 27 17:10:11 2023 [10101][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:11 2023 [10101][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:11 2023 [10101][1][ERROR] Unable to find relationship emails_email_templates
Tue Jun 27 17:10:11 2023 [10101][1][ERROR] Unable to find relationship emails_email_templates

I get all these errors. Any ideas ?

chirag_biz309 · 28 June 2023 04:06

Hello @anils

step - 1 : Clear your browser’s cache
step - 2 : Set file permission and ownership. Have a look the part of permission and ownership click here
step - 3 : Go to Admin and Repair and Rebuild

I hope this is helpful.

Thanks.

anils · 28 June 2023 05:03

Tried all 3 steps. The permissions are set to 755 for most files.
Issue persists, [ERROR] Unable to find relationship emails_email_templates is all over the log files.

chirag_biz309 · 28 June 2023 05:05

Okay @anils

Tell me one thing, are you running this SuiteCRM v8.1 locally or on server?

anils · 28 June 2023 05:19

It’s on a server. The same server has Wordpress, VTiger and other tools that work well. The load on the server and database are negligible.

After installation of SuiteCRM, I have created only a few accounts and disabled the modules that I don’t need from ’ Display Modules And Subpanels’

SuiteCRM runs really slow, the loading animation stays for 6 to 10 seconds each time. In the logs, I only see these Unable to find relationship errors.

chirag_biz309 · 28 June 2023 05:25

ok @anils

I think it is an issue of file permission and ownership of cache directory.
Have a look the part of permission and ownership once again https://docs.suitecrm.com/admin/installation-guide/downloading-installing/

anils · 28 June 2023 06:28

You were right. Because I was using file manager in cpanel to change permissions, only the outer folder’s permission was changing to 775. With ftp, I have recursively changed permissions of folders public/legacy/ custom modules themes data upload to 775 and now the [ERROR] Unable to find relationship is gone.

Thanks you!

anils · 28 June 2023 17:12

This has not solved the problem for SuiteCRM being slow. As the [[ERROR] Unable to find relationship] issue is resolved, I will open another topic for the slow speed issue.

mwojtaszek · 11 May 2024 09:30

That was very helpful-- almost all errors that were popping up on an each link click were gone for a while. Except for one-- when opening an email:

Sat May 11 11:10:51 2024 [17360][1][ERROR] Unable to find relationship emails_email_templates
Sat May 11 11:10:51 2024 [17360][1][ERROR] Unable to find relationship emails_email_templates
Sat May 11 11:11:05 2024 [17363][1][ERROR] Unable to find relationship emails_email_templates
Sat May 11 11:11:05 2024 [17363][1][ERROR] Unable to find relationship emails_email_templates

But after a short while they came back

pgr · 11 May 2024 10:09

The problem when ownerships and permissions get changed recurrently is typically caused by either

cron jobs running as the wrong user (root, for example): see this
you’re logging in through ftp or ssh with a different user, and changing files