Redmine stops responding when trying to open a subversion repository
Replies (4)
RE: Redmine stops responding when trying to open a subversion repository
-
Added by Ronie Henrich almost 14 years ago
More details about this issue:
- postgresql-8.4.4
- PassengerSpawnMethod conservative
- Redmine stopped working with PassengerSpawnMethod set to smart or smart-lv2 after I upgraded postgresql from 8.2.15 to 8.4.4
After starting apache and accessing Redmine the first time, I get the folowing processes related to Redmine:
apache 27426 1 61 21:52 ? 00:00:06 Rails: /var/www/redmine postgres 27427 11862 0 21:52 ? 00:00:00 postgres: postgres redmine 127.0.0.1(33619) idle
Right after I click on the Repository tab, one more Redmine/rails proccess is created:
apache 27426 1 16 21:52 ? 00:00:07 Rails: /var/www/redmine postgres 27427 11862 0 21:52 ? 00:00:00 postgres: postgres redmine 127.0.0.1(33619) idle apache 27442 27426 0 21:53 ? 00:00:00 Rails: /var/www/redmineSo, to be able to access the repository tab, I have to do this workaround everytime I start/restart Apache:
- Kill both Redmine/rails processes (
kill -9 27442 27426); - Open Redmine but not click on the Repository tab;
- Restart Redmine (
touch /var/www/redmine/tmp/restart.txt); - Open again Redmine but not click on the Repository tab;
- Now I can open the Repository tab;
Any ideas on how to fix it to be able to run Redmine without the workaround above?
RE: Redmine stops responding when trying to open a subversion repository
-
Added by Andy Bolstridge almost 14 years ago
It shows that its gone wrong accessing the svn repo - you can add some debugging lines to show what is being fetched from there - it could be that it is trying to sync the changeset cache with what's in svn.
I added this to the environment and it started logging svn commands:
config.logger = Logger.new(config.log_path, 1, 1048576)
config.logger.level = Logger::DEBUG
RE: Redmine stops responding when trying to open a subversion repository
-
Added by Ronie Henrich almost 14 years ago
- I added this to Redmine's environment.rb to start logging svn commands:
config.logger = Logger.new(config.log_path, 1, 1048576) config.logger.level = Logger::DEBUG
- After starting Apache, Redmine hangs right after I click on a project's repository tab, and I got this in production.log:
Processing RepositoriesController#show (for 200.101.77.88 at 2011-02-09 02:28:36) [GET] Parameters: {"action"=>"show", "id"=>"myproject", "controller"=>"repositories"} ^[[4;36;1mSQL (0.6ms)^[[0m ^[[0;1mSELECT max("settings".updated_on) AS max_updated_on FROM "settings" ^[[0m ^[[4;35;1mUser Load (0.7ms)^[[0m ^[[0mSELECT * FROM "users" WHERE ("users"."id" = 6) AND (users.status = 1) AND ( ("users"."type" = 'User' OR "users"."type" = 'AnonymousUse$ ^[[4;36;1mProject Load (1.1ms)^[[0m ^[[0;1mSELECT * FROM "projects" WHERE ("projects"."identifier" = E'myproject') LIMIT 1^[[0m ^[[4;35;1mRepository Load (1.2ms)^[[0m ^[[0mSELECT * FROM "repositories" WHERE ("repositories".project_id = 4) LIMIT 1^[[0m ^[[4;36;1mEnabledModule Load (0.6ms)^[[0m ^[[0;1mSELECT name FROM "enabled_modules" WHERE ("enabled_modules".project_id = 4) ^[[0m ^[[4;35;1mSetting Load (0.7ms)^[[0m ^[[0mSELECT * FROM "settings" WHERE ("settings"."name" = E'autofetch_changesets') LIMIT 1^[[0m Shelling out: svn --config-dir /var/svn/.subversion info --xml 'https://redmine.foo.com.br/svn/myproject/' --no-auth-cache --non-interactive
- After doing the workaround (described in my previous comment/post), I was be able to access the project's repository tab, and I got this in production.log:
Processing RepositoriesController#show (for 200.101.77.88 at 2011-02-09 02:33:09) [GET] Parameters: {"action"=>"show", "id"=>"myproject", "controller"=>"repositories"} ^[[4;36;1mSQL (0.6ms)^[[0m ^[[0;1mSELECT max("settings".updated_on) AS max_updated_on FROM "settings" ^[[0m ^[[4;35;1mUser Load (0.7ms)^[[0m ^[[0mSELECT * FROM "users" WHERE ("users"."id" = 6) AND (users.status = 1) AND ( ("users"."type" = 'User' OR "users"."type" = 'AnonymousUse$ ^[[4;36;1mProject Load (0.8ms)^[[0m ^[[0;1mSELECT * FROM "projects" WHERE ("projects"."identifier" = E'myproject') LIMIT 1^[[0m ^[[4;35;1mRepository Load (1.2ms)^[[0m ^[[0mSELECT * FROM "repositories" WHERE ("repositories".project_id = 4) LIMIT 1^[[0m ^[[4;36;1mEnabledModule Load (0.7ms)^[[0m ^[[0;1mSELECT name FROM "enabled_modules" WHERE ("enabled_modules".project_id = 4) ^[[0m ^[[4;35;1mSetting Load (0.7ms)^[[0m ^[[0mSELECT * FROM "settings" WHERE ("settings"."name" = E'autofetch_changesets') LIMIT 1^[[0m Shelling out: svn --config-dir /var/svn/.subversion info --xml 'https://redmine.foo.com.br/svn/myproject/' --no-auth-cache --non-interactive ^[[4;36;1mChangeset Load (2.3ms)^[[0m ^[[0;1mSELECT * FROM "changesets" WHERE ("changesets".repository_id = 43) ORDER BY changesets.committed_on DESC, changesets.id DESC LI$ Shelling out: svn --config-dir /var/svn/.subversion list --xml 'https://redmine.foo.com.br/svn/myproject/'@HEAD --no-auth-cache --non-interactive Found 2 entries in the repository for 'https://redmine.foo.com.br/svn/myproject/' Shelling out: svn --config-dir /var/svn/.subversion log --xml -r HEAD:1 --no-auth-cache --non-interactive --limit 10 'https://redmine.foo.com.br/svn/myproject/' ^[[4;35;1mChangeset Load (2.2ms)^[[0m ^[[0mSELECT * FROM "changesets" WHERE ("changesets"."revision" IN (E'976',E'975',E'974',E'973',E'972',E'971',E'970',E'969',E'968',E'96$ ^[[4;36;1mUser Load (0.9ms)^[[0m ^[[0;1mSELECT * FROM "users" WHERE ("users"."id" = 6) AND ( ("users"."type" = 'User' OR "users"."type" = 'AnonymousUser' ) ) ^[[0m Shelling out: svn --config-dir /var/svn/.subversion --version Shelling out: svn --config-dir /var/svn/.subversion proplist --verbose --xml 'https://redmine.foo.com.br/svn/myproject/'@HEAD --no-auth-cache --non-interactive Rendering template within layouts/base Rendering repositories/show Rendered repositories/_navigation (19.6ms) Rendered repositories/_breadcrumbs (7.7ms) ^[[4;35;1mChangeset Load (1.1ms)^[[0m ^[[0mSELECT * FROM "changesets" WHERE ("changesets"."revision" = E'976') AND ("changesets".repository_id = 43) ORDER BY changesets.com$ ^[[4;36;1mRepository Load (0.6ms)^[[0m ^[[0;1mSELECT * FROM "repositories" WHERE ("repositories"."id" = 43) ^[[0m ^[[4;35;1mCACHE (0.0ms)^[[0m ^[[0mSELECT * FROM "users" WHERE ("users"."id" = 6) AND ( ("users"."type" = 'User' OR "users"."type" = 'AnonymousUser' ) ) ^[[0m ^[[4;36;1mSetting Load (0.7ms)^[[0m ^[[0;1mSELECT * FROM "settings" WHERE ("settings"."name" = E'user_format') LIMIT 1^[[0m ^[[4;35;1mChangeset Load (1.0ms)^[[0m ^[[0mSELECT * FROM "changesets" WHERE ("changesets"."revision" = E'930') AND ("changesets".repository_id = 43) ORDER BY changesets.com$ ^[[4;36;1mCACHE (0.0ms)^[[0m ^[[0;1mSELECT * FROM "repositories" WHERE ("repositories"."id" = 43) ^[[0m ^[[4;35;1mCACHE (0.0ms)^[[0m ^[[0mSELECT * FROM "users" WHERE ("users"."id" = 6) AND ( ("users"."type" = 'User' OR "users"."type" = 'AnonymousUser' ) ) ^[[0m Rendered repositories/_dir_list_content (48.8ms) Rendered repositories/_dir_list (52.4ms) ^[[4;36;1mCACHE (0.0ms)^[[0m ^[[0;1mSELECT * FROM "repositories" WHERE ("repositories"."id" = 43) ^[[0m ^[[4;35;1mUserPreference Load (0.7ms)^[[0m ^[[0mSELECT * FROM "user_preferences" WHERE ("user_preferences".user_id = 6) LIMIT 1^[[0m ^[[4;36;1mSetting Load (0.6ms)^[[0m ^[[0;1mSELECT * FROM "settings" WHERE ("settings"."name" = E'time_format') LIMIT 1^[[0m ^[[4;35;1mSetting Load (0.7ms)^[[0m ^[[0mSELECT * FROM "settings" WHERE ("settings"."name" = E'cache_formatted_text') LIMIT 1^[[0m ^[[4;36;1mIssue Load Including Associations (3.6ms)^[[0m ^[[0;1mSELECT "issues"."id" AS t0_r0, "issues"."tracker_id" AS t0_r1, "issues"."project_id" AS t0_r2, "issues"."sub$ ^[[4;35;1mIssuePriority Load (0.8ms)^[[0m ^[[0mSELECT * FROM "enumerations" WHERE ("enumerations"."id" = 7) AND ( ("enumerations"."type" = 'IssuePriority' ) ) ORDER BY enum$ ^[[4;36;1mCACHE (0.0ms)^[[0m ^[[0;1mSELECT * FROM "repositories" WHERE ("repositories"."id" = 43) ^[[0m ^[[4;35;1mCACHE (0.0ms)^[[0m ^[[0mSELECT * FROM "repositories" WHERE ("repositories"."id" = 43) ^[[0m ^[[4;36;1mCACHE (0.0ms)^[[0m ^[[0;1mSELECT * FROM "repositories" WHERE ("repositories"."id" = 43) ^[[0m ^[[4;35;1mCACHE (0.0ms)^[[0m ^[[0mSELECT * FROM "repositories" WHERE ("repositories"."id" = 43) ^[[0m ^[[4;36;1mIssue Load Including Associations (3.6ms)^[[0m ^[[0;1mSELECT "issues"."id" AS t0_r0, "issues"."tracker_id" AS t0_r1, "issues"."project_id" AS t0_r2, "issues"."sub$ ^[[4;35;1mCACHE (0.0ms)^[[0m ^[[0mSELECT * FROM "enumerations" WHERE ("enumerations"."id" = 7) AND ( ("enumerations"."type" = 'IssuePriority' ) ) ORDER BY enumerations.posi$ ^[[4;36;1mCACHE (0.0ms)^[[0m ^[[0;1mSELECT * FROM "repositories" WHERE ("repositories"."id" = 43) ^[[0m ^[[4;35;1mCACHE (0.0ms)^[[0m ^[[0mSELECT "issues"."id" AS t0_r0, "issues"."tracker_id" AS t0_r1, "issues"."project_id" AS t0_r2, "issues"."subject" AS t0_r3, "issues"."desc$ ^[[4;36;1mCACHE (0.0ms)^[[0m ^[[0;1mSELECT * FROM "enumerations" WHERE ("enumerations"."id" = 7) AND ( ("enumerations"."type" = 'IssuePriority' ) ) ORDER BY enumerations.po$ ^[[4;35;1mCACHE (0.0ms)^[[0m ^[[0mSELECT * FROM "repositories" WHERE ("repositories"."id" = 43) ^[[0m ^[[4;36;1mIssue Load Including Associations (3.6ms)^[[0m ^[[0;1mSELECT "issues"."id" AS t0_r0, "issues"."tracker_id" AS t0_r1, "issues"."project_id" AS t0_r2, "issues"."sub$ ^[[4;35;1mCACHE (0.0ms)^[[0m ^[[0mSELECT * FROM "enumerations" WHERE ("enumerations"."id" = 7) AND ( ("enumerations"."type" = 'IssuePriority' ) ) ORDER BY enumerations.posi$ ^[[4;36;1mCACHE (0.0ms)^[[0m ^[[0;1mSELECT * FROM "repositories" WHERE ("repositories"."id" = 43) ^[[0m ^[[4;35;1mCACHE (0.0ms)^[[0m ^[[0mSELECT * FROM "repositories" WHERE ("repositories"."id" = 43) ^[[0m ^[[4;36;1mIssue Load Including Associations (3.7ms)^[[0m ^[[0;1mSELECT "issues"."id" AS t0_r0, "issues"."tracker_id" AS t0_r1, "issues"."project_id" AS t0_r2, "issues"."sub$ ^[[4;35;1mCACHE (0.0ms)^[[0m ^[[0mSELECT * FROM "enumerations" WHERE ("enumerations"."id" = 7) AND ( ("enumerations"."type" = 'IssuePriority' ) ) ORDER BY enumerations.posi$ ^[[4;36;1mCACHE (0.0ms)^[[0m ^[[0;1mSELECT * FROM "repositories" WHERE ("repositories"."id" = 43) ^[[0m ^[[4;35;1mIssue Load Including Associations (3.6ms)^[[0m ^[[0mSELECT "issues"."id" AS t0_r0, "issues"."tracker_id" AS t0_r1, "issues"."project_id" AS t0_r2, "issues"."subje$ ^[[4;36;1mCACHE (0.0ms)^[[0m ^[[0;1mSELECT * FROM "enumerations" WHERE ("enumerations"."id" = 7) AND ( ("enumerations"."type" = 'IssuePriority' ) ) ORDER BY enumerations.po$ Rendered repositories/_revisions (596.2ms) ^[[4;35;1mToken Load (0.7ms)^[[0m ^[[0mSELECT * FROM "tokens" WHERE ("tokens".user_id = 6 AND (action='feeds')) LIMIT 1^[[0m ^[[4;36;1mProject Load (1.6ms)^[[0m ^[[0;1mSELECT "projects".* FROM "projects" INNER JOIN "members" ON "projects".id = "members".project_id WHERE (("members".user_id = 6) A$ ^[[4;35;1mSQL (1.1ms)^[[0m ^[[0mSELECT count(*) AS count_all FROM "projects" WHERE (((projects.status=1) AND (projects.id != 4)) AND (projects."lft" <= 28 AND projects."rgt$ ^[[4;36;1mProject Load (0.9ms)^[[0m ^[[0;1mSELECT * FROM "projects" WHERE (((projects.status=1) AND (projects.id != 4)) AND (projects."lft" <= 28 AND projects."rgt" >= 29))$ ^[[4;35;1mProject Load (0.9ms)^[[0m ^[[0mSELECT * FROM "projects" WHERE (projects."lft" <= 28 AND projects."rgt" >= 29) ORDER BY "lft" LIMIT 1^[[0m ^[[4;36;1mCACHE (0.0ms)^[[0m ^[[0;1mSELECT * FROM "projects" WHERE (projects."lft" <= 28 AND projects."rgt" >= 29) ORDER BY "lft" LIMIT 1^[[0m ^[[4;35;1mSQL (3.3ms)^[[0m ^[[0mSELECT count(DISTINCT "versions".id) AS count_all FROM "versions" LEFT OUTER JOIN "projects" ON "projects".id = "versions".project_id WHERE $ ^[[4;36;1mWiki Load (1.1ms)^[[0m ^[[0;1mSELECT * FROM "wikis" WHERE ("wikis".project_id = 4) LIMIT 1^[[0m ^[[4;35;1mSQL (1.1ms)^[[0m ^[[0mSELECT count(*) AS count_all FROM "boards" WHERE ("boards".project_id = 4) ^[[0m Completed in 3178ms (View: 847, DB: 45) | 200 OK [https://redmine.foo.com.br/projects/myproject/repository]
- Any ideas why Redmine's repository tab hangs right after starting Apache but works fine after killing Redmine's processes and restarting only Redmine?
- NOTE: This problem started after I upgraded Redmine from 1.0.2 to 1.1.0
Thanks!
RE: Redmine stops responding when trying to open a subversion repository
-
Added by Ronie Henrich almost 14 years ago
Any ideas on how to fix this issue?
Thanks!