Redmine » Historique » Version 5
Version 4 (Mehdi Abaakouk, 12/05/2014 16:34) → Version 5/16 (Laurent GUERBY, 12/05/2014 16:37)
{{>toc}}
h1. Redmine
h2. Liens
* https://wiki.ldn-fai.net/wiki/Redmine#Par_mail ouvrir un ticket redmine par mail
h2. Investigation Erreur 500
http://lists.tetaneutral.net/pipermail/technique/2014-May/001335.html
Erreur dans /srv/http/redmine/log/production.log:
<pre>
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"):
</pre>
<pre>
# 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;
</pre>
h1. Redmine
h2. Liens
* https://wiki.ldn-fai.net/wiki/Redmine#Par_mail ouvrir un ticket redmine par mail
h2. Investigation Erreur 500
http://lists.tetaneutral.net/pipermail/technique/2014-May/001335.html
Erreur dans /srv/http/redmine/log/production.log:
<pre>
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"):
</pre>
<pre>
# 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;
</pre>