Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.Greetings ...
First cron, after install and basic setup of ERP site, seems to hang if you run cron. Also had a odd problem, where I can add items, but can not just click on their description to view. I get an
Fatal error: Maximum execution time of 240 seconds exceeded in /var/drupal/drupal-erp.leet/includes/database.mysqli.inc on line 115
But after a few hours or so, the cron and item access works fine. Think this might be a MySQL indexing issue or something, but would rather get an expert opinion.
Thanks
Mailed
LeeT
| Comment | File | Size | Author |
|---|---|---|---|
| #7 | erp-nohang.patch | 2.14 KB | leenx |
| #6 | faulty.diff | 2.07 KB | leenx |
Comments
Comment #1
leenx CreditAttribution: leenx commentedJust a little more info ...
http://erp.leenx.tld/node/10
Reports: Fatal error: Maximum execution time of 120 seconds exceeded in /var/drupal/drupal-erp.leet/includes/database.mysql-common.inc on line 41
But, http://erp.leenx.tld/node/10/edit
Showes the item fine. Had a similar problem a few days ago, showing somebody the joys of DrupalERP. Had to show them the add edit to the URL and it works, but today, it's working fine.
Thanks
Mailed
LeeT
Comment #2
singularoHMmm. can really tell why without some insight into what was in the log files. I suspect its just a first search index update sort of issue.
Comment #3
leenx CreditAttribution: leenx commentedGreetings ...
Thanks for the quick reply. Which logs is best to look at? A little extra info, I have created another item, and it works fine, but the first (LABOUR), I am still getting time outs.
Is there a quick and easy way to rebuild the indexs or something like that? I tried the cron again this morning, and that too is giving timeouts. Doing to do a backup and restore and see if that works.
Thanks
Mailed
LeeT
Comment #4
leenx CreditAttribution: leenx commentedJust another note, did a backup and restore, using the Drupal Backup & Migrate module, and it did not solve the problem. I then check all other basic nodes, like Store/Supplier/Customer and then all seemed fine. So I deleted node 10, which is first Item, LABOUR. Recreated it and was able to run cron without a problem.
This same problem could be the reason why I can't hostin Aegir. We need to look at why the first Item, is causing a funny. Will look though the profile and see if I can see anything, but I'm still very new to this.
Comment #5
leenx CreditAttribution: leenx commentedok, so today I spent alot of time, trying to figure out what was causing this problem. It seem, it has to be a problem with version projects[erp] = 1.1, which has the problem and version projects[erp] = 1.1-beta7, which seems to work. Or I mean, not hang on the Labour item or cron. Hoping I can figure out what is the problem and post a patch or something.
Comment #6
leenx CreditAttribution: leenx commentedUsing erp 1.1, I think I found the code that causes the cron and Labour to hang. I don't yet know enough to be able to fix the code, so I have just made a diff that removes the code and functionality.
Will work on the code at a later stage, but have a few other things that I wish to fix and/or improve with ERP.
Comment #7
leenx CreditAttribution: leenx commentedDone some more tests, thinking that maybe I had broken something else, but, it seems not.
I have updated the patch, hoping it will be accepted into the current code base, at which point, I believe that this case can be closed.
Comment #8
singularo