When we attempt to edit some projects, the progress indicator either does not move or goes half way across and stalls. After a wait a blank screen is displayed. Using the back arrow on the browser restores the original screen display. other projects open fine and we are able to edit them. The projects we can and can not edit remain consistent form one to to another. One strange thing was that restoring a backup to before one of the affected projects was edited did not fix the problem.
So we suspected some sort of data corruption. But in looking at the MySQL tables related to the project manager, we can not see any differences between projects we can edit and those we can not. And we have not discerned any pattern of users or links, except that the projects affected are linked to each other. I made a link to a editable project to one project (a training event) that seems central in this network, but that did not affect if that project could be edited in subsequent tries.
One data corruption we did see was in the egw_pm_members table. There is a entry for a pm_id of 0 with 13 users as members. The users are involved in projects we can edit and those we can not, so not sure that this is related. I assume we can delete those records in the table that point to pm_id = 0. None of the other tables have a reference to pm_id 0 that I have observed.
We are using a VPS with Debian 5 and php 5.26-- lenny, Egroupware 1.8.001
We found the problem was with too much history being generated. As we increased the timeout periods we were able to get more and more projects to display. Some projects took more than 3 minutes to display. When we emptied the history table in MySQL, that project displayed in 7 seconds.
The numerous history entries were changes in start and end times that are automatically being generated. When we discovered the issue it appeared that the changes were 1 or 2 hours change. We do not use the time of day when ending projects so the default of 00:00 is always used.
We setup a cron job to remove old histroy. The editing problem has not resurfaced since we did that 3 weeks ago.
But I am seeing that the start and end dates of projects are still being automatically changed, sometimes by years, so I know that is not being done by staff updating their projects. We have most projects set to synchronize with to-do items in the infolog that are linked to them. When the changes were one or 2 hours we wondered if it was a timezone issue, but clearly that is not case as the changes are sometimes in years and occur with a single user being credited with the change, not just between users in different time zones.
Perhaps a related issue is that when a user edits the end date of a to-do item in the infolog, on his/her third or so edit an error message will appear on clicking the save button. The message states that another user is editing the project and you should copy your changes and merge them with the other user. No other user is editing the project. If the user makes enough attempts at editing and saving, they are usually successful.
Blank screen mostly reffers to some error mentioned in the error_log of
your webserver. Please have a look there. Also having all projects
linked to each other may lead to problems of recurrence, so maybe you
running into a loop and timeout …
Birgit Becker
When we attempt to edit some projects, the progress indicator either does not
move or goes half way across and stalls. After a wait a blank screen is
displayed. Using the back arrow on the browser restores the original screen
display. other projects open fine and we are able to edit them. The projects
we can and can not edit remain consistent form one to to another. One
strange thing was that restoring a backup to before one of the affected
projects was edited did not fix the problem.
So we suspected some sort of data corruption. But in looking at the MySQL
tables related to the project manager, we can not see any differences
between projects we can edit and those we can not. And we have not
discerned any pattern of users or links, except that the projects affected
are linked to each other. I made a link to a editable project to one project
(a training event) that seems central in this network, but that did not
affect if that project could be edited in subsequent tries.
One data corruption we did see was in the egw_pm_members table. There is a
entry for a pm_id of 0 with 13 users as members. The users are involved in
projects we can edit and those we can not, so not sure that this is related.
I assume we can delete those records in the table that point to pm_id = 0.
None of the other tables have a reference to pm_id 0 that I have observed.
We are using a VPS with Debian 5 and php 5.26-- lenny, Egroupware 1.8.001
Simplify data backup and recovery for your virtual environment with vRanger.
Installation’s a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Data protection magic?
Nope - It’s vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev
Stylite GmbH
Handelsregister Kaiserslautern HRB 30575
Geschäftsführer:
Andre Keller und Ralf Becker
USt-ID: DE214280951
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2