Hi Marco,

can you raise the logging to :debug by changing the line config.log_level = :debug in /opt/openproject/config/environments/production.rb and restart OpenProject with service openproject restart.

Then, please try again and report the debug output after the above message.

Best,
Oliver

I don’t have any idea what happens here.

An interessing point ist maybe that openproject always tries to look for a revision 200

Error output is svn: E195012: Unable to find repository location for ‘http://ukl-ib-dev/vc/esb/IBLogging’ in revision 200
Error output is svn: E195012: Unable to find repository location for ‘http://pdvt:8000/esb/PdvWorkfileReader’ in revision 200

Another point is that in the revision column of the projectarchibve view shown no number

Very confusing…

Every hint is welcome

Hi !

Is there a solution in the meantime ?

We have the exact problem with our OpenProject based on Docker. We even have the same mystical revision 200 which cause it.

Regards

Hi everyone,

the SVN adapter uses capturing STDOUT to process the output of the repository. There might be some limits imposed in your docker environment, but I couldn’t find anything about it.

using the rails console (RAILS_ENV bundle exec rails c), can you execute the following commands and post what their output is

# Get the SCM adapter for your project
scm = Project.find('your-project-identifier-here').repository.scm

# Get all revisions at the root path, might take some while
revisions = scm.revisions

# Output the length
puts revisions.count
revisions.inspect

Best,
Oliver

Hi Oliver,

after reading this, i remember that we already got the same error at #23816 and did some research on it.

But we are using a non docker installation. So this seems a general problem, with a commit count > 200.

Maybe we can now track this bug down.

Hi guys,

as far we analyzed the problem, we can say that there are circumstances where OpenProject begins to ask svn in revisions intervalls like

1 to 200
201 to 400

and so on. And when you do it on a path which was created after revision 200, the svn command fails.

Here is the requestes output. I anonymized some parts because of “Datenschutz” ;) One command seemed not to work:

irb(main):001:0> scm = Project.find('tc-cammunda-commons').repository.scm
=> #<OpenProject::Scm::Adapters::Subversion:0x0000000bc0d130 @url="svn+ssh://xxxxxxxx/yyyyyyyyy/trunk", @root_url="svn+ssh://xxxxxxx/yyyyyyyyy\trunk", @login="", @password="", @identifier="tc-cammunda-commons">
irb(main):002:0> revisions = scm.revisions
Password:

=> [#<OpenProject::Scm::Adapters::Revision:0x0000000bbe7160 @identifier="1761", @scmid=nil, @author="xxxxxx", @time=2017-09-18 11:07:34 +0000, @paths=[], @revision=nil, @branch=nil, @name="1761", @message="yyyyyyyyy">, #<OpenProject::Scm::Adapters::Revision:0x0000000bbe4b18 @identifier="1736", @scmid=nil, @author="xxxxxx", @time=2017-09-14 12:59:50 +0000, @paths=[], @revision=nil, @branch=nil, @name="1736", @message="yyyyyyyyy">, #<OpenProject::Scm::Adapters::Revision:0x0000000bbda460 @identifier="1705", @scmid=nil, @author="xxxxxx", @time=2017-09-13 14:24:06 +0000, @paths=[], @revision=nil, @branch=nil, @name="1705", @message="">, #<OpenProject::Scm::Adapters::Revision:0x0000000bbd3f70 @identifier="1668", @scmid=nil, @author="xxxxxx", @time=2017-09-08 11:56:45 +0000, @paths=[], @revision=nil, @branch=nil, @name="1668", @message="yyyyyyyyyy">, #<OpenProject::Scm::Adapters::Revision:0x0000000bbd16a8 @identifier="1667", @scmid=nil, @author="xxxxxx", @time=2017-09-08 11:26:25 +0000, @paths=[], @revision=nil, @branch=nil, @name="1667", @message="yyyyyyyyyyyyyyyyyyy">, #<OpenProject::Scm::Adapters::Revision:0x0000000bbceef8 @identifier="1666", @scmid=nil, @author="xxxxxx", @time=2017-09-08 11:21:22 +0000, @paths=[], @revision=nil, @branch=nil, @name="1666", @message="yyyyyyyyyyyyyyyyyyyyy">, #<OpenProject::Scm::Adapters::Revision:0x0000000bbcc6f8 @identifier="1597", @scmid=nil, @author="xxxxxx", @time=2017-09-01 13:27:20 +0000, @paths=[], @revision=nil, @branch=nil, @name="1597", @message="yyyyyyyyyyyyyyy">, #<OpenProject::Scm::Adapters::Revision:0x0000000bbc1e88 @identifier="1596", @scmid=nil, @author="xxxxxx", @time=2017-09-01 13:24:22 +0000, @paths=[], @revision=nil, @branch=nil, @name="1596", @message="Share project \"yyyyyyyyyyy\" into \"svn+ssh://xxxxxx@xxxxxxxxx\"">]

irb(main):003:0> put revisions.count
NoMethodError: undefined method `put' for main:Object
        from (irb):3
        from /usr/local/bundle/gems/railties-5.0.4/lib/rails/commands/console.rb:65:in `start'
        from /usr/local/bundle/gems/railties-5.0.4/lib/rails/commands/console_helper.rb:9:in `start'
        from /usr/local/bundle/gems/railties-5.0.4/lib/rails/commands/commands_tasks.rb:78:in `console'
        from /usr/local/bundle/gems/railties-5.0.4/lib/rails/commands/commands_tasks.rb:49:in `run_command!'
        from /usr/local/bundle/gems/railties-5.0.4/lib/rails/commands.rb:18:in `<top (required)>'
        from bin/rails:4:in `require'
        from bin/rails:4:in `<main>'
irb(main):004:0> revisions.inspect

=> "[#<OpenProject::Scm::Adapters::Revision:0x0000000bbe7160 @identifier=\"1761\", @scmid=nil, @author=\"xxxxxx\", @time=2017-09-18 11:07:34 +0000, @paths=[], @revision=nil, @branch=nil, @name=\"1761\", @message=\"yyyyyyyyyyyyyyyyyy\">, #<OpenProject::Scm::Adapters::Revision:0x0000000bbe4b18 @identifier=\"1736\", @scmid=nil, @author=\"xxxxxx\", @time=2017-09-14 12:59:50 +0000, @paths=[], @revision=nil, @branch=nil, @name=\"1736\", @message=\"yyyyyyyyyyyyyyyy\">, #<OpenProject::Scm::Adapters::Revision:0x0000000bbda460 @identifier=\"1705\", @scmid=nil, @author=\"xxxxxx\", @time=2017-09-13 14:24:06 +0000, @paths=[], @revision=nil, @branch=nil, @name=\"1705\", @message=\"\">, #<OpenProject::Scm::Adapters::Revision:0x0000000bbd3f70 @identifier=\"1668\", @scmid=nil, @author=\"xxxxxx\", @time=2017-09-08 11:56:45 +0000, @paths=[], @revision=nil, @branch=nil, @name=\"1668\", @message=\"yyyyyy\">, #<OpenProject::Scm::Adapters::Revision:0x0000000bbd16a8 @identifier=\"1667\", @scmid=nil, @author=\"xxxxxx\", @time=2017-09-08 11:26:25 +0000, @paths=[], @revision=nil, @branch=nil, @name=\"1667\", @message=\"yyyyyyyy\">, #<OpenProject::Scm::Adapters::Revision:0x0000000bbceef8 @identifier=\"1666\", @scmid=nil, @author=\"xxxxxx\", @time=2017-09-08 11:21:22 +0000, @paths=[], @revision=nil, @branch=nil, @name=\"1666\", @message=\"yyyyy\">, #<OpenProject::Scm::Adapters::Revision:0x0000000bbcc6f8 @identifier=\"1597\", @scmid=nil, @author=\"xxxxxx\", @time=2017-09-01 13:27:20 +0000, @paths=[], @revision=nil, @branch=nil, @name=\"1597\", @message=\"yyyyyyyyyyyyyyyyyyyyy\">, #<OpenProject::Scm::Adapters::Revision:0x0000000bbc1e88 @identifier=\"1596\", @scmid=nil, @author=\"xxxxxx\", @time=2017-09-01 13:24:22 +0000, @paths=[], @revision=nil, @branch=nil, @name=\"1596\", @message=\"Share project yyyyyyyy\\\" into \\\"svn+ssh://xxxxxx@yyyyyyyyyyyyyyyyyy\\\"\">]"

Regards

Hi Johann,

its puts, not put. Typo on my side, sorry.

Best,
Oliver

Hi !

No problem, here is the missing output

irb(main):003:0> puts revisions.count
8
=> nil

Regards

Johann

Okay, so even the adapter returns only a fraction of the actual changesets it should return.

as far we analyzed the problem, we can say that there are circumstances where OpenProject begins to ask svn in revisions intervalls like …

There are two different functions at play here. The SVN adapter simply shells out to SVN to read data from it through XML or plain stdout, and returns that.

OpenProject or rather redmine code caches revisions in the database, and only requests newer revisions it hasn’t yet seen. Since in subversion revision numbers are simply increasing integers, you’ll likely see an adapter call to anything > 200, where 200 is the last revision that was parsed the last time.

With our testing repository, I can’t reproduce the error with well over 200 revisions. There must be some part missing in my local setup that plays a role here.

Best,
Oliver

Hi !

Maybe its a specific constellation in SVN which caused this error.

We know you have problems to reproduce it. Yesterday Mr Wagner was here and we provided him additional information and log. Maybe this will help.

Regards

Hi Johann,

yes, we will get to the bottom of this. If nothing else helps, would there be an option to access your instance to debug this issue directly on your repositories?

I will be on vacation the next weeks, but could schedule a remote session afterwards to investigate this further.

Best,
Oliver

Hi !

I think a remote access wouldn’t be possible but I will foreward your request here internally.

Hava a nice vacation anyway :D

Regards

Hi !

Is there any progress in fixing the bug in the meantime ?

If not we will try to create a description to reproduce the bug.
But access to our data will not be possible.

Regards

Here’s a bugfix for a related issue that resulted in failing to access files and folders deleted in the past.

Turns out SVN has peg revisions to look up the path in the log output you’re looking for. By default this is HEAD. If the file/folder does not exist in this revision, an error is returned. I’m now adding the peg revision for the entries at all times and this seems to work fine.

Please check out the patch if it fixes your issue as well.
https://github.com/opf/openproject/pull/6034

Best,
Oliver

Hi !

Thanks for the patch.

I put the modified subversion.rb into our OP test system. But even after restart the behaviour didn’t changed.

I will check it more itensely on Monday. Otherwiese I will try to provide a scenario to create a SVN repo which causes the problems.

Regards and have a nice weekend.

Hi !

I created a shell script which fills an empty SVN repo in a way that the bug in OP can be reproduced. Do following steps:

1. Create an empty repo on a SVN server
2. Unpack the file op_test.sh.gz on a Linux system with installed SVN client with command gunzip op_test.sh.gz
3. Modify the shell script op_test.sh and set the SVN URL at top to the empty SVN repo
4. Go in a OP project and set its SVN path to good_trunk and check the archive in the project => All resivions are visible
5. Change the SVN path of the OP project to bad_trunk and check the project archive again => No revisions

I hope this helps you to fix the problem or maybe your patch already did it ?

Regards

@Johann Letzel @Oliver Günther

What SVN Server do you use? We use CollabNet Subversion Repository, maybe this could be a hint.