First off, if you are doing any kind of software development and you aren't using source control of some kind, you are missing out big time. I highly recommend source control. I use Visual SVN for the server and Smart SVN for the client, but there are lots of other great options out there. OK, on to the good stuff.
We have purchased licenses for RedGate's SQL Source Control, which allows you to use SQL Manager to check in SQL objects into a SVN repository. Very cool. I had been using this for a short while, and I soon saw this error when trying to scan for changes:
Could not read chunk Size: secure connection truncatedIt mentioned a 'secure connection', and so I figured that SSL could be an issue. I set up VisualSVN to listen on both ports 443 (with SSL) and 80 (without SSL) by adding the following to c:\program files\visualsvn server\conf\httpd-custom.conf and then restarting VisualSVN server:
Listen "80"But I still saw chunking errors like this:
Could not read chunk sizeWhat in the world is a chunking error? I tried Google, but all that turned up there was a not-so-useful discussion.
I figured I'd dig deeper, so I turned on errors in apache by adding the following to c:\program files\visualsvn server\conf\httpd-custom.conf and restarting VisualSVN: (I had to create the c:\errorlogs folder to get this to work)
ErrorLog c:/errorlogs/visualsvn_apache.logI then saw this in the apache log:
[Tue Sep 07 23:05:16 2010] [error] [client 192.168.3.33] Provider encountered an error while streaming a REPORT response. [500, #0]That finally gave me a little better error message to search for. After much more googling, I found 3 possible problems:
[Tue Sep 07 23:05:16 2010] [error] [client 192.168.3.33] A failure occurred while driving the update report editor [500, #620018]
[Tue Sep 07 23:05:16 2010] [error] [client 192.168.3.33] Error writing base64 data: APR does not understand this error code [500, #620018]
- Issue with VMWare Nat (the server and client were both running on virtual machines):
- Memory Leak
- HTTP Timeout
I first tried the VMWare NAT issue. I removed all possible NAT problems by running the SVN client on the same box as the SVN server, but the problem didn't go away. The Timeout issue was the next easiest one to try.
To address the timeout issue, I increased the timeout in the apache config to 30 minutes by adding this line to c:\program files\visualsvn server\conf\httpd-custom.conf and restarting VisualSVN:
Timeout 1800And that fixed the problem. The scan of our database / SVN server was taking about 15 minutes (tons of tables and stored procedures, with the scan running on a somewhat slow development server). However, the Apache timeout was set to around 10 minutes. So after 10 minutes, Apache gave up, which caused the chunking error, which then caused the client software to throw the error.
Please let me know in the comments if you have run into similar problems, or if I need to clarify this at all.