Deadlock found in create feedback API

[alisebt]

Gorse version v0.4.4-5-gf4a6606

Describe the bug I use the Logstash to read from the SQL Server database and insert feedback into the gorse system via API (HTTP output plugin). I get the following error on the API call

Error 1213: Deadlock found when trying to get lock; try restarting transaction

To Reproduce http { url => "http://192.168.20.208:8087/api/feedback" http_method => "post" format => "json_batch" }

Expected behavior status: 200 response: affected rows number

[zhenghaoz]

Hi @alisebt . What database backend do you use?

[alisebt]

Hi @zhenghaoz. The database is mysql.

[zhenghaoz]

Other users met this issue as well. However, I can't reproduce it. I guess it is caused by #489, could you help me verify it once #489 merged? Thanks.