project activities no longer shown for issues
Added by Jeff Gunderson about 15 years ago
Up until a few days ago we were seeing activities for all changes made to issues. Now we are only seeing revisions when we check a project's activities. Are there any settings that control whether or not we see changes to issues? I tried reducing the number of days shown in the list but that didn't help. I also tried recycling the server and database but that didn't work. Can anyone tell me where the actvity log is kept in database so I check it?
We are using 8.4 with Postgres.
Thanks!
Jeff
Replies (4)
RE: project activities no longer shown for issues -help! - Added by Jeff Gunderson about 15 years ago
I tried many other tests and sometimes an updated issue will appear in the activity page. But I'll look a the page again and the issue will not be there. I haven't found a pattern to this - it seems like it randomly shows updated issues.
I found some similar requests in the past for this problem - but no one posted an explanation. (maybe we shouldn't be using Postgres?)
Thanks
Jeff
RE: project activities no longer shown for issues - Added by Jeff Gunderson about 15 years ago
No one is helping so I guess no one else has symptoms like this. I also found that the gantt and calendar also do not show all activities. I'm thinking the database is somehow damaged and maybe there are problems related to Postgres. Is anyone using Postgres? Should I convert to MySQL?
Jeff
RE: project activities no longer shown for issues - Added by Joachim Fritschi about 15 years ago
There seems to be a bug in Postgres 8.4 which causes these Errors. Postgres aparently optimizes a query and screws up. :( IssuID #4259)
RE: project activities no longer shown for issues - Added by Jeff Gunderson about 15 years ago
I almost gave up on Redmine but I guessed it had to do with Postgres so I converted to MySQL and so far everything is fine. I also converted to Mongrel and its much faster.