Hide Forgot
Created attachment 827570 [details] Test run log file Description of problem: If someone starts uploading a large source doc file to a project, and someone else adds _any_ project to a group, a transaction failure will occur Version-Release number of selected component (if applicable): dev How reproducible: Moderate, consistent Steps to Reproduce: 1. Sign in as admin 2. Open a tab on Groups, select a group 3. Open another tab on Project, select a project 4. On the project page, press Source documents, upload and select a large file to upload - e.g. Moby Dick from project Gutenberg 5. Press Upload 6. Go to the group tab and press Settings -> Projects 7. Enter a project name and press Add Actual results: Transaction failed An unexpected error has occurred. Please report this problem with details of what you were attempting. Expected results: No lock problems should be evident on a db read Additional info: Attached server log The file upload target project and group add target project do not need to be one and the same, it seems.
Pull request: https://github.com/zanata/zanata-server/pull/292
Ignore pull request information above. Wrong update.
Does not occur using a mysql database, only on h2. Downgrading severity.
After discussion, due to the new group statistics page have only word based statistics, we have decided to remove the overall messages count from the page which is the cause of this issue from Zanata 3.2 release. However, we should decide as a separate feature if we are going to include message statistics in the page.
pull request: https://github.com/zanata/zanata-server/pull/295
This appears to still be a problem. I noticed that I had to clear the caches for it to occur (i.e. will only happen the first time)
The problem is caused by databases that force pessimistic lock - e.g. h2 database does not support optimistic locking. Despite not officially supporting anything other than mysql, it would be appropriate to handle these situations gracefully - and should be mentioned in the documentation for those who may wish to attempt databases other than mysql.
h2 not supported