Red Hat Bugzilla – Bug 833653
Transaction time out when processing large glossary file
Last modified: 2012-09-12 19:48:11 EDT
Created attachment 593119 [details]
part of log to show the traceback of error
Description of problem:
Transaction on server is time out due to processing this large file.
Steps to Reproduce:
1. Using zanata python client to push compendium glossary file to server
2. Download compendium-zh_CN-LATEST.po and clean up
3. run zanata glossary push --lang zh-Hans compendium-zh_CN-LATEST.po
The Client receive 500 error from server: The server encountered an internal error () that prevented it from fulfilling this request.
200 Success response from server
Actually, the Transaction on server is time out due to processing this large file, the attatchment is part of the log of server, it shows that server indeed receive the glossary items from client and store them to database, but since there are a huge amount of glossary items, the server failed at the end since timeout is set to 300s for Transaction.
I think maybe no need to change the Transaction timeout setting on server, but on the other hand, try to break the large file to small part on client and then push to server.
Implemented batch transaction on server side.
This fix works for 1.7 Servers but not 1.6.1 servers.
After talked to Alex, The server side fix will only go to 1.7.
As for 1.6 servers, workaround can be applied to client.