Resolved!
Thanks for the tip from https://github.com/lxc/lxd/issues/7024 : Post from James Fraser (fwaggle).
I did the following.
lxd sql global “SELECT MAX(id) FROM storage_volumes_all LIMIT 1;”
±--------+
| MAX(id) |
±--------+
| 125 |
±--------+
lxd sql global “UPDATE sqlite_sequence SET seq = 125 WHERE name = ‘storage_volumes’”
Rows affected: 1
Now lxc snapshot c2 works
lxc info c2
Name: c2
Location: none
Remote: unix://
Architecture: x86_64
Created: 2020/03/16 09:40 UTC
Status: Running
Type: container
Profiles: default
Pid: 21647
…
Snapshots:
snap0 (taken at 2020/03/17 04:17 UTC) (stateless)
Thanks once again.
Best regards
Stay safe.
–mohananpg, india