Re: Apache SVN commit fail

[ Hi, please don't top-post on this list, i.e. put your reply at the
bottom or inline. And preferably use plain-text emails. I've
re-arranged your reply into a bottom-post. More below. ]

On Fri, Jan 19, 2018 at 3:04 AM, 黃靖翔Bill Huang <bill.huang_at_unizyx.com.tw> wrote:
> 2018-01-18 18:47 GMT+08:00 Johan Corveleyn <jcorvel_at_gmail.com>:
>>
>> On Thu, Jan 18, 2018 at 9:52 AM, 黃靖翔Bill Huang <bill.huang_at_unizyx.com.tw> wrote:
>> > I have a serious problem when I commit data to SVN server ,
>> > It always in Committing transaction have a unknow problem .
>> > When commit run to Committing transaction , it always need to wait 10 min and reply below error message：
>> >
>> > Committing transaction...
>> > svn: E175012: Commit failed (details follow):
>> > svn: E175012: Connection timed out
>> > svn: E200042: Additional errors:
>> > svn: E175002: Unexpected server error 500 'Internal Server Error' on '/svn/0_IT_test/Bill/!svn/txn/0-0'
>> >
>> > May I know under what circumstances will this error result ?
>> >
>> > I have tried many ways to exclude this error , but still has not been solved this problem
>> >
>> > can please help us trubleshooting this problem ?
>> >
>> > SVN server is ubuntu 16.04
>> > SVN version is 1.9.3
>>
>> You'll have to take a look at the error log on the server (or ask a
>> sysadmin to do that for you). There should be more information about
>> the reason for the 500 Internal Server Error.
>>
>> --
>> Johan
>
> Dear Sir：
>
> Attachment is my SVN server log , as described earlier ,
> when my user commit data and finally will wait for 10 minutes after the failure
> I check SVN Log not show any detail message about this error.
> and during that time keep monitor SVN server performance is normal
>
> The only relevant is committing transaction will wait for 10 min and reply error.
> In access log have show execute MERGE at 18:48:53 and after 10 minutes (18:58:54) show delete
> error log shows Could not MERGE resource at 18:59:47
>
> I don't have any idea for this error message can do something
>
> I try to adjust ./subversion http-timeout and apache2.conf ,
> but did not solve it successfully.
>
> May I know have any advice can provide?
>
> Thank you for your help
>
>

You should focus on the first series of errors in the error log. Which is this:

[Thu Jan 18 18:59:47.799933 2018] Could not MERGE resource
"/svn/0_IT_test/Bill/!svn/txn/4-e" into "/svn/0_IT_test/Bill". [500,
#0]
[Thu Jan 18 18:59:47.799948 2018] An error occurred while committing
the transaction. [500, #160014]
[Thu Jan 18 18:59:47.799950 2018] Reference to non-existent node
'_2j3j.0.t4-e' in filesystem '/var/lib/svn/0_IT_test/Bill/db' [500,
#160014]

I think the essential part of the error message is this:

Reference to non-existent node '_2j3j.0.t4-e' in filesystem
'/var/lib/svn/0_IT_test/Bill/db'

I'm not sure what that means, but I'd check for any corruption of the
repository. I googled that "Reference to non-existent node" message,
and found one potentially relevant post (and some very old ones, all
about repository corruption):

https://svn.haxx.se/users/archive-2006-08/0013.shtml

So I'd try:
* svnadmin verify
* svnadmin dump (sometimes dump find problems that verify misses)
* svnadmin recover (this apparently helped the user in the post I
referred to above)

And check for anything unusual on a storage level, verify the filesystem etc ...

-- 
Johan