search

drakkar-lig / walt-python-packages

Home of walt-node, walt-server, walt-client and walt-common python packages.
https://walt-project.liglab.fr
BSD 3-Clause "New" or "Revised" License
5 stars 3 forks source link

Unable to forget device #20

Closed audeoudh closed 5 years ago

audeoudh commented 5 years ago

walt device forget raises an error:

# walt device forget switch-S9
Unexpected server-side issue! update or delete on table "devices" violates foreign key constraint "switches_mac_fkey" on table "switches"
DETAIL:  Key (mac)=(6c:b0:ce:18:d5:6c) is still referenced from table "switches".

done.

At the server side, we have this error log:

  File "/usr/local/lib/python2.7/dist-packages/walt/server/threads/main/db.py", line 127, in forget_device
    """,  (dev_name,)*6)
  File "/usr/local/lib/python2.7/dist-packages/walt/server/postgres.py", line 45, in execute
    self.c.execute(query, query_args)
  File "/usr/lib/python2.7/dist-packages/psycopg2/extras.py", line 288, in execute
    return super(NamedTupleCursor, self).execute(query, vars)
psycopg2.IntegrityError: update or delete on table "devices" violates foreign key constraint "switches_mac_fkey" on table "switches"
DETAIL:  Key (mac)=(6c:b0:ce:18:d5:6c) is still referenced from table "switches".