Projet

Général

Profil

Redmine » Historique » Version 5

Laurent GUERBY, 12/05/2014 16:37

1 1 Laurent GUERBY
{{>toc}}
2 1 Laurent GUERBY
3 1 Laurent GUERBY
h1. Redmine
4 1 Laurent GUERBY
5 1 Laurent GUERBY
h2. Liens
6 1 Laurent GUERBY
7 1 Laurent GUERBY
* https://wiki.ldn-fai.net/wiki/Redmine#Par_mail ouvrir un ticket redmine par mail
8 2 Mehdi Abaakouk
9 2 Mehdi Abaakouk
10 2 Mehdi Abaakouk
h2. Investigation Erreur 500
11 2 Mehdi Abaakouk
12 5 Laurent GUERBY
http://lists.tetaneutral.net/pipermail/technique/2014-May/001335.html
13 5 Laurent GUERBY
14 2 Mehdi Abaakouk
Erreur dans /srv/http/redmine/log/production.log:
15 2 Mehdi Abaakouk
16 2 Mehdi Abaakouk
<pre>
17 2 Mehdi Abaakouk
Completed 500 Internal Server Error in 23.2ms
18 2 Mehdi Abaakouk
19 2 Mehdi Abaakouk
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint "wiki_content_versions_pkey"
20 2 Mehdi Abaakouk
DETAIL:  Key (id)=(164) already exists.
21 2 Mehdi Abaakouk
: 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"):
22 2 Mehdi Abaakouk
</pre>
23 2 Mehdi Abaakouk
24 2 Mehdi Abaakouk
<pre>
25 2 Mehdi Abaakouk
# su - postgres
26 2 Mehdi Abaakouk
# psql redmine
27 3 Mehdi Abaakouk
# select max(id) from wiki_content_versions;
28 4 Mehdi Abaakouk
max  
29 4 Mehdi Abaakouk
------
30 4 Mehdi Abaakouk
 6193
31 4 Mehdi Abaakouk
(1 row)
32 3 Mehdi Abaakouk
# alter sequence wiki_content_versions_id_seq start 6194;
33 3 Mehdi Abaakouk
# alter sequence wiki_content_versions_id_seq restart;
34 2 Mehdi Abaakouk
</pre>