Hello there,
Recently some of our users imported a bunch of surveys from one server to another (version 3.22.
, and they're having problems with the survey answer/responses, like in the following message (my translation):
Code:
An error happened while trying to save a response in the survey Test Survey - 181285
DATA TO BE INSERTED:
token: 1FvmzymHpdBzJwe
181285X281X5066: 8
181285X281X5065: N/A
181285X281X5064: N/A
181285X281X5067: N/A
181285X281X5066: 8
181285X281X5065: N/A
181285X281X5064: N/A
181285X281X5067: N/A
SQL CODE THAT PRESENTED THE ERROR:
ERROR MESSAGE:
It isn't possible to include the row in the survey table.
Looking at the database log, we've seen that there is a primary key constraint violation:
Code:
2020-09-01 11:32:18 -03 [39001]: [5-1] db=limesurvey,host=172.23.0.25,user=app_limesurvey,app=[unknown] ERROR: 23505: duplicate key value violates unique constraint "lime_survey_146198_pkey"
2020-09-01 11:32:18 -03 [39001]: [6-1] db=limesurvey,host=172.23.0.25,user=app_limesurvey,app=[unknown] DETAIL: Key (id)=(14) already exists.
2020-09-01 11:32:18 -03 [39001]: [7-1] db=limesurvey,host=172.23.0.25,user=app_limesurvey,app=[unknown] LOCATION: _bt_check_unique, nbtinsert.c:534
2020-09-01 11:32:18 -03 [39001]: [8-1] db=limesurvey,host=172.23.0.25,user=app_limesurvey,app=[unknown] STATEMENT: INSERT INTO "lime_survey_146198" ("startlanguage", "token", "datestamp", "startdate", "seed"
This happened for several surveys and is halting our production environment. Would someone have a suggestion to how to proceed?
Thanks!
