Creating a new field in email entity times out

[Emmker]

I try to create a field in email entity and it times out in around 40-50 seconds

The email records are around 200.000 or more

I do not have the same problem with any other entity.

I have tried boolean and enum type of fields with no luck.

Any ideas about why?


My server has 16gb ram dedicated to the espo, 8 cpus and the optimizations o mysql are
innodb_buffer_pool_size = 8G
innodb_buffer_pool_instances = 8
innodb_log_file_size = 2G
innodb_flush_log_at_trx_commit = 2
sort_buffer_size = 4M

[Vadym]

Hi Emmker,

Please provide the EspoCRM error log, web server error log, and a screenshot of Administration -> System Requirements to get more details about this issue.

[Emmker]

The error log:

[2024-09-15 21:00:36] ERROR: Workflow [66471ab5ee10769a1]: Action failed, [executeFormula] [0], SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email.c_test' in 'field list'.
[2024-09-15 21:00:36] ERROR: Workflow [66471ab5ee10769a1]: Action failed, [executeFormula] [0], SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email.c_test' in 'field list'.
[2024-09-15 21:00:36] ERROR: Workflow [66471ab5ee10769a1]: Action failed, [executeFormula] [0], SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email.c_test' in 'field list'.
[2024-09-15 21:00:36] ERROR: Workflow [66471ab5ee10769a1]: Action failed, [executeFormula] [0], SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email.c_test' in 'field list'.
[2024-09-15 21:00:36] ERROR: Workflow [66471ab5ee10769a1]: Action failed, [executeFormula] [0], SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email.c_test' in 'field list'.
[2024-09-15 21:00:36] ERROR: Workflow [66471ab5ee10769a1]: Action failed, [executeFormula] [0], SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email.c_test' in 'field list'.
[2024-09-15 21:00:36] ERROR: Workflow [66471ab5ee10769a1]: Action failed, [executeFormula] [0], SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email.c_test' in 'field list'.
[2024-09-15 21:00:36] CRITICAL: (HY000) Failed job 66e744065c6ef54c8. SQLSTATE[HY000]: General error: 2006 MySQL server has gone away :: /var/www/espocrm/application/Espo/ORM/Executor/DefaultSqlExecutor.php(77)
[2024-09-15 21:00:36] ERROR: (0) Uncaught Exception LogicException: "SQLSTATE[HY000]: General error: 2006 MySQL server has gone away" at /var/www/espocrm/application/Espo/Core/Job/JobRunner.php line 63 :: /var/www/espocrm/application/Espo/Core/Job/JobRunner.php(63)​ 

No errors on apache

[yuri]

Maybe the 'email' table is constantly read and written while you are creating the field. Maybe try to disable cron, set the maintenance mode (Administration > Settings), wait for a minute and then try to create your field.

Also check whether there's enough disk space on the server. MySQL may go away when it's not enough.

[yuri]

BTW. Does the email's list view load fast for you?

[Emmker]

Yes, as fast as always.

[Emmker]

Maybe the 'email' table is constantly read and written while you are creating the field. Maybe try to disable cron, set the maintenance mode (Administration > Settings), wait for a minute and then try to create your field.

Also check whether there's enough disk space on the server. MySQL may go away when it's not enough.

In maintenance mode same result.
The disk space is more than ok.

I will disable cron tonight to check, and get back.

Edit: same behaviour with disabled cron.
Should I try with disabled workflows too?