• Contenu
• Redmine
  • Liens
  • Upgrade
  • Investigation Erreur 500

Redmine¶

La machine chiliproject contient:

- une base données postgres
 - une application installé dans /srv/http/redmine
 - le git de git.tetaneutral.net dans /srv/http/repositories

Liens¶

• https://wiki.ldn-fai.net/wiki/Redmine#Par_mail ouvrir un ticket redmine par mail

Upgrade¶

1. /etc/init.d/apache2 stop
2. su - postgres
3. pgdump redmine > redmine-3.X.X-20130108.sql
4. exit #
5. ssh -Tf -D9999 h2 -p 2222 sleep 15m
7. cd /srv/http/redmine
8. tsocks git fetch pull --rebase
9. cd plugins/redmine_git_hosting
10. git checkout v0.7.8

1. cd /srv/http/redmine

1. tsocks bundle update
2. gem cleanup
3. tsocks bundle update
4. bundle exec rake generate_secret_token
5. bundle exec rake db:migrate RAILS_ENV=production
6. bundle exec rake redmine:plugins:migrate RAILS_ENV=production
7. bundle exec rake tmp:cache:clear tmp:sessions:clear

Investigation Erreur 500¶

http://lists.tetaneutral.net/pipermail/technique/2014-May/001335.html

Erreur dans /srv/http/redmine/log/production.log:

Completed 500 Internal Server Error in 23.2ms

ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint "wiki_content_versions_pkey" 
DETAIL:  Key (id)=(164) already exists.
: INSERT INTO "wiki_content_versions" ("author_id", "comments", "compression", "data", "page_id", "updated_on", "version", "wiki_content_id") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "id"):

# su - postgres
# psql redmine
# select max(id) from wiki_content_versions;
max  
------
 6193
(1 row)
# alter sequence wiki_content_versions_id_seq start 6194;
# alter sequence wiki_content_versions_id_seq restart;