Lxc copy error to another node

While applying the command
lxc copy {containername} {nodename}:
gets following

Error: Failed container creation: Create LXC container: UNIQUE constraint failed: storage_volumes.storage_pool_id, storage_volumes.node_id, storage_volumes.project_id, storage_volumes.name, storage_volumes.type

Sounds like there’s some cruft on the target node.

Can you show:

  • lxd sql global "SELECT * FROM containers;"
  • lxd sql global "SELECT * FROM storage_volumes;"

On the target node?

here is results

:~# lxd sql global "select * from containers;"
+-----+---------+--------------------------------+--------------+------+-----------+-------------------------------------+----------+-------------------------------------+-------------+------------+---------------------------+
| id  | node_id |              name              | architecture | type | ephemeral |            creation_date            | stateful |            last_use_date            | description | project_id |        expiry_date        |
+-----+---------+--------------------------------+--------------+------+-----------+-------------------------------------+----------+-------------------------------------+-------------+------------+---------------------------+
| 11  | 1       | gitlab                         | 2            | 0    | 0         | 2018-06-12T08:49:47+05:30           | 0        | 2019-07-26T08:57:19.015780483+05:30 |             | 1          | 0001-01-01T00:00:00Z      |
| 30  | 1       | gitlab/20180613-222735         | 2            | 1    | 0         | 2018-06-13T22:33:51+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 34  | 1       | ldap02                         | 2            | 0    | 0         | 2018-06-13T23:32:54+05:30           | 0        | 2019-07-26T08:56:44.552034332+05:30 |             | 1          | 0001-01-01T00:00:00Z      |
| 35  | 1       | biometric                      | 2            | 0    | 0         | 2018-06-13T23:33:13+05:30           | 0        | 2019-08-05T17:58:28.052122234+05:30 |             | 1          | 0001-01-01T00:00:00Z      |
| 36  | 1       | ldap02/20180613-222735         | 2            | 1    | 0         | 2018-06-13T22:27:36+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 37  | 1       | biometric/20180613-222735      | 2            | 1    | 0         | 2018-06-13T22:29:28+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 40  | 1       | ldap02/20180614-211035         | 2            | 1    | 0         | 2018-06-14T21:10:35+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 41  | 1       | biometric/20180614-211035      | 2            | 1    | 0         | 2018-06-14T21:10:36+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 42  | 1       | gitlab/20180614-211035         | 2            | 1    | 0         | 2018-06-14T21:10:36+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 48  | 1       | biometric/20180617-095745      | 2            | 1    | 0         | 2018-06-17T09:58:03+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 49  | 1       | ldap02/20180617-095745         | 2            | 1    | 0         | 2018-06-17T09:58:15+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 50  | 1       | gitlab/20180617-095745         | 2            | 1    | 0         | 2018-06-17T09:58:18+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 55  | 1       | ldap02/20180626-103744         | 2            | 1    | 0         | 2018-06-26T10:37:46+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 56  | 1       | gitlab/20180626-103744         | 2            | 1    | 0         | 2018-06-26T10:37:46+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 57  | 1       | biometric/20180626-103744      | 2            | 1    | 0         | 2018-06-26T10:37:47+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 63  | 1       | biometric/20180703-203906      | 2            | 1    | 0         | 2018-07-03T20:39:08+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 64  | 1       | ldap02/20180703-203906         | 2            | 1    | 0         | 2018-07-03T20:39:08+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 65  | 1       | gitlab/20180703-203906         | 2            | 1    | 0         | 2018-07-03T20:39:09+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 71  | 1       | gitlab/20180703-210300         | 2            | 1    | 0         | 2018-07-03T21:03:03+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 72  | 1       | ldap02/20180703-210300         | 2            | 1    | 0         | 2018-07-03T21:03:03+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 73  | 1       | biometric/20180703-210300      | 2            | 1    | 0         | 2018-07-03T21:03:03+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 145 | 1       | bugzilla                       | 2            | 0    | 0         | 2018-08-21T12:26:44+05:30           | 0        | 2019-08-08T13:53:09.830974472+05:30 |             | 1          | 0001-01-01T00:00:00Z      |
| 148 | 1       | maas-aibl                      | 2            | 0    | 0         | 2018-08-24T22:32:48+05:30           | 0        | 2019-07-26T08:54:51.565475902+05:30 |             | 1          | 0001-01-01T00:00:00Z      |
| 149 | 1       | maas-aibl/aibladmin            | 2            | 1    | 0         | 2018-08-24T22:50:50+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 150 | 1       | maas-aibl/maas-rack-controller | 2            | 1    | 0         | 2018-08-24T23:01:14+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 151 | 1       | gitlab/20180907                | 2            | 1    | 0         | 2018-09-07T18:39:30+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 154 | 1       | maas-aibl/20180911-123727      | 2            | 1    | 0         | 2018-09-11T12:37:28+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 155 | 1       | bugzilla/20180911-124452       | 2            | 1    | 0         | 2018-09-11T12:44:52+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 156 | 1       | gitlab/20180911-124452         | 2            | 1    | 0         | 2018-09-11T12:44:52+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 157 | 1       | biometric/20180911-124452      | 2            | 1    | 0         | 2018-09-11T12:44:53+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 158 | 1       | biometric/20180911-124547      | 2            | 1    | 0         | 2018-09-11T12:45:47+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 159 | 1       | gitlab/20180911-124547         | 2            | 1    | 0         | 2018-09-11T12:45:48+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 160 | 1       | bugzilla/20180911-124547       | 2            | 1    | 0         | 2018-09-11T12:45:48+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 161 | 1       | bugzilla/20180911-124628       | 2            | 1    | 0         | 2018-09-11T12:46:28+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 162 | 1       | biometric/20180911-124628      | 2            | 1    | 0         | 2018-09-11T12:46:28+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 163 | 1       | gitlab/20180911-124628         | 2            | 1    | 0         | 2018-09-11T12:46:29+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 164 | 1       | bugzilla/20180911-124733       | 2            | 1    | 0         | 2018-09-11T12:47:34+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 166 | 1       | biometric/20180911-124733      | 2            | 1    | 0         | 2018-09-11T12:47:34+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 167 | 1       | ldap02/20180911-124733         | 2            | 1    | 0         | 2018-09-11T12:48:41+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 168 | 1       | gitlab/20180911-124733         | 2            | 1    | 0         | 2018-09-11T12:53:24+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 169 | 1       | maas-aibl/20181003-122442      | 2            | 1    | 0         | 2018-10-03T12:24:45+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 170 | 1       | gitlab/20181003-122903         | 2            | 1    | 0         | 2018-10-03T12:29:06+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 171 | 1       | ldap02/20181003-122903         | 2            | 1    | 0         | 2018-10-03T12:29:08+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 172 | 1       | bugzilla/20181003-122903       | 2            | 1    | 0         | 2018-10-03T12:29:08+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 173 | 1       | biometric/20181003-122903      | 2            | 1    | 0         | 2018-10-03T12:29:10+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 174 | 1       | gitlab/20181018                | 2            | 1    | 0         | 2018-10-18T08:55:26.560256819+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 175 | 1       | ldap02/20190513                | 2            | 1    | 0         | 2019-05-13T09:22:38.137804529+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 176 | 1       | gitlab/20190515                | 2            | 1    | 0         | 2019-05-15T16:16:12.660889846+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 177 | 1       | partkeepr                      | 2            | 0    | 0         | 2019-05-17T19:29:26.521333073+05:30 | 0        | 2019-08-06T16:54:27.09283501+05:30  |             | 1          | 0001-01-01T00:00:00Z      |
| 178 | 1       | test-340                       | 2            | 0    | 0         | 2019-05-17T19:33:52.884989952+05:30 | 0        | 2019-07-26T08:55:29.170583537+05:30 |             | 1          | 0001-01-01T00:00:00Z      |
| 180 | 1       | aims-his                       | 2            | 0    | 0         | 2019-05-17T19:35:20.930406765+05:30 | 0        | 2019-08-06T13:49:18.618033317+05:30 |             | 1          | 0001-01-01T00:00:00Z      |
| 181 | 1       | adminweb                       | 2            | 0    | 0         | 2019-05-17T19:35:33.866402264+05:30 | 0        | 2019-08-06T14:06:57.619523853+05:30 |             | 1          | 0001-01-01T00:00:00Z      |
| 182 | 1       | ftp                            | 2            | 0    | 0         | 2019-05-17T19:36:07.345213905+05:30 | 0        | 2019-07-25T09:57:10.617293221+05:30 |             | 1          | 0001-01-01T00:00:00Z      |
| 183 | 1       | matlab                         | 2            | 0    | 0         | 2019-05-17T19:36:22.199776131+05:30 | 0        | 2019-08-08T13:19:20.807460554+05:30 |             | 1          | 0001-01-01T00:00:00Z      |
| 188 | 1       | test-360                       | 2            | 0    | 0         | 2019-05-17T21:35:25.360525119+05:30 | 0        | 2019-07-26T08:55:37.079900709+05:30 |             | 1          | 0001-01-01T00:00:00Z      |
| 189 | 1       | test-3600                      | 2            | 0    | 0         | 2019-05-17T21:36:20.47237177+05:30  | 0        | 2019-07-26T08:55:41.108097587+05:30 |             | 1          | 0001-01-01T00:00:00Z      |
| 190 | 1       | test-1286                      | 2            | 0    | 0         | 2019-05-17T21:37:15.224857107+05:30 | 0        | 2019-07-25T09:56:47.152834756+05:30 |             | 1          | 0001-01-01T00:00:00Z      |
| 191 | 1       | ftpt                           | 2            | 0    | 0         | 2019-05-17T21:46:15.920080144+05:30 | 0        | 2019-07-25T09:57:14.141681622+05:30 |             | 1          | 0001-01-01T00:00:00Z      |
| 195 | 1       | ldap02/20190517                | 2            | 1    | 0         | 2019-05-17T21:56:56.821152679+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 196 | 1       | gitlab/20190517                | 2            | 1    | 0         | 2019-05-17T21:57:05.166860422+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 197 | 1       | bugzilla/20190517              | 2            | 1    | 0         | 2019-05-17T21:57:14.921107614+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 198 | 1       | biometric/20190517             | 2            | 1    | 0         | 2019-05-17T21:57:24.710524216+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 199 | 1       | maas-aibl/20190517             | 2            | 1    | 0         | 2019-05-17T21:57:34.721659806+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 201 | 1       | aims-his/20190517              | 2            | 1    | 0         | 2019-05-17T21:58:09.902606343+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 202 | 1       | adminweb/20190517              | 2            | 1    | 0         | 2019-05-17T21:58:16.334412947+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 203 | 1       | ftp/20190517                   | 2            | 1    | 0         | 2019-05-17T21:58:23.612320789+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 204 | 1       | ftpt/20190517                  | 2            | 1    | 0         | 2019-05-17T21:58:27.686834202+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 205 | 1       | matlab/20190517                | 2            | 1    | 0         | 2019-05-17T21:58:34.676065519+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 210 | 1       | archiva                        | 2            | 0    | 0         | 2019-05-17T22:30:41.282757884+05:30 | 0        | 2019-07-25T09:57:18.656020024+05:30 |             | 1          | 0001-01-01T00:00:00Z      |
| 211 | 1       | archiva/20190508               | 2            | 1    | 0         | 2019-05-08T12:51:22+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 212 | 1       | archiva/20190508-1             | 2            | 1    | 0         | 2019-05-08T13:12:35+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 213 | 1       | archiva/20190517               | 2            | 1    | 0         | 2019-05-17T21:48:05+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 214 | 1       | archiva/20190517-1             | 2            | 1    | 0         | 2019-05-17T22:05:28+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 216 | 1       | adminweb/20190621              | 2            | 1    | 0         | 2019-06-21T12:34:56.058760243+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 217 | 1       | partkeepr/20190624-142740      | 2            | 1    | 0         | 2019-06-24T14:27:41.651222647+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 218 | 1       | ldap02/20190624-142740         | 2            | 1    | 0         | 2019-06-24T14:27:41.764798674+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 219 | 1       | gitlab/20190624-142740         | 2            | 1    | 0         | 2019-06-24T14:27:41.765383222+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 220 | 1       | biometric/20190624-142740      | 2            | 1    | 0         | 2019-06-24T14:27:42.107013854+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 221 | 1       | bugzilla/20190624-142740       | 2            | 1    | 0         | 2019-06-24T14:27:42.173322992+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 222 | 1       | adminweb/20190708-adminweb     | 2            | 1    | 0         | 2019-07-08T12:20:32.274480484+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 223 | 1       | maas-aibl/20190708-maas        | 2            | 1    | 0         | 2019-07-08T14:46:02.791525509+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 227 | 1       | biometric/12072019             | 2            | 1    | 0         | 2019-07-12T16:34:36.281691069+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 232 | 1       | CJava                          | 2            | 0    | 0         | 2019-07-26T12:10:38.18463069+05:30  | 0        | 2019-07-26T12:10:51.506910128+05:30 |             | 1          | 0001-01-01T00:00:00Z      |
| 235 | 1       | bugzilla/20190806              | 2            | 1    | 0         | 2019-08-06T14:12:59.634450819+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 236 | 1       | partkeepr/20190807-160404      | 2            | 1    | 0         | 2019-08-07T16:04:19.380582874+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
+-----+---------+--------------------------------+--------------+------+-----------+-------------------------------------+----------+-------------------------------------+-------------+------------+---------------------------+

lxd sql global “select * from storage_volumes;”

+-----+------------------------------------------------------------------+-----------------+---------+------+-------------+----------+------------+
| id  |                               name                               | storage_pool_id | node_id | type | description | snapshot | project_id |
+-----+------------------------------------------------------------------+-----------------+---------+------+-------------+----------+------------+
| 11  | gitlab                                                           | 1               | 1       | 0    |             | 0        | 1          |
| 30  | gitlab/20180613-222735                                           | 1               | 1       | 0    |             | 0        | 1          |
| 34  | ldap02                                                           | 1               | 1       | 0    |             | 0        | 1          |
| 35  | biometric                                                        | 1               | 1       | 0    |             | 0        | 1          |
| 36  | ldap02/20180613-222735                                           | 1               | 1       | 0    |             | 0        | 1          |
| 37  | biometric/20180613-222735                                        | 1               | 1       | 0    |             | 0        | 1          |
| 41  | ldap02/20180614-211035                                           | 1               | 1       | 0    |             | 0        | 1          |
| 42  | biometric/20180614-211035                                        | 1               | 1       | 0    |             | 0        | 1          |
| 43  | gitlab/20180614-211035                                           | 1               | 1       | 0    |             | 0        | 1          |
| 49  | biometric/20180617-095745                                        | 1               | 1       | 0    |             | 0        | 1          |
| 50  | ldap02/20180617-095745                                           | 1               | 1       | 0    |             | 0        | 1          |
| 51  | gitlab/20180617-095745                                           | 1               | 1       | 0    |             | 0        | 1          |
| 57  | gitlab/20180626-103744                                           | 1               | 1       | 0    |             | 0        | 1          |
| 58  | ldap02/20180626-103744                                           | 1               | 1       | 0    |             | 0        | 1          |
| 59  | biometric/20180626-103744                                        | 1               | 1       | 0    |             | 0        | 1          |
| 65  | biometric/20180703-203906                                        | 1               | 1       | 0    |             | 0        | 1          |root@node12:
| 66  | ldap02/20180703-203906                                           | 1               | 1       | 0    |             | 0        | 1          |
| 67  | gitlab/20180703-203906                                           | 1               | 1       | 0    |             | 0        | 1          |
| 73  | ldap02/20180703-210300                                           | 1               | 1       | 0    |             | 0        | 1          |
| 74  | biometric/20180703-210300                                        | 1               | 1       | 0    |             | 0        | 1          |
| 75  | gitlab/20180703-210300                                           | 1               | 1       | 0    |             | 0        | 1          |
| 109 | os-client/lxd-init                                               | 2               | 1       | 0    |             | 0        | 1          |
| 155 | bugzilla                                                         | 1               | 1       | 0    |             | 0        | 1          |
| 158 | maas-aibl                                                        | 1               | 1       | 0    |             | 0        | 1          |root@node12:
| 159 | maas-aibl/aibladmin                                              | 1               | 1       | 0    |             | 0        | 1          |
| 160 | maas-aibl/maas-rack-controller                                   | 1               | 1       | 0    |             | 0        | 1          |
| 167 | gitlab/20180907                                                  | 1               | 1       | 0    |             | 0        | 1          |
| 170 | maas-aibl/20180911-123727                                        | 1               | 1       | 0    |             | 0        | 1          |
| 171 | bugzilla/20180911-124452                                         | 1               | 1       | 0    |             | 0        | 1          |
| 172 | gitlab/20180911-124452                                           | 1               | 1       | 0    |             | 0        | 1          |
| 173 | biometric/20180911-124452                                        | 1               | 1       | 0    |             | 0        | 1          |
| 174 | biometric/20180911-124547                                        | 1               | 1       | 0    |             | 0        | 1          |
| 175 | gitlab/20180911-124547                                           | 1               | 1       | 0    |             | 0        | 1          |
| 176 | bugzilla/20180911-124547                                         | 1               | 1       | 0    |             | 0        | 1          |
| 177 | bugzilla/20180911-124628                                         | 1               | 1       | 0    |             | 0        | 1          |
| 178 | biometric/20180911-124628                                        | 1               | 1       | 0    |             | 0        | 1          |
| 179 | gitlab/20180911-124628                                           | 1               | 1       | 0    |             | 0        | 1          |
| 180 | bugzilla/20180911-124733                                         | 1               | 1       | 0    |             | 0        | 1          |
| 182 | biometric/20180911-124733                                        | 1               | 1       | 0    |             | 0        | 1          |
| 183 | ldap02/20180911-124733                                           | 1               | 1       | 0    |             | 0        | 1          |
| 184 | gitlab/20180911-124733                                           | 1               | 1       | 0    |             | 0        | 1          |
| 188 | maas-aibl/20181003-122442                                        | 1               | 1       | 0    |             | 0        | 1          |
| 189 | gitlab/20181003-122903                                           | 1               | 1       | 0    |             | 0        | 1          |
| 190 | ldap02/20181003-122903                                           | 1               | 1       | 0    |             | 0        | 1          |
| 191 | bugzilla/20181003-122903                                         | 1               | 1       | 0    |             | 0        | 1          |
| 192 | biometric/20181003-122903                                        | 1               | 1       | 0    |             | 0        | 1          |
| 196 | gitlab/20181018                                                  | 1               | 1       | 0    |             | 0        | 1          |
| 233 | ldap02/20190513                                                  | 1               | 1       | 0    |             | 0        | 1          |
| 234 | gitlab/20190515                                                  | 1               | 1       | 0    |             | 0        | 1          |
| 238 | partkeepr                                                        | 1               | 1       | 0    |             | 0        | 1          |
| 239 | test-340                                                         | 1               | 1       | 0    |             | 0        | 1          |
| 241 | aims-his                                                         | 1               | 1       | 0    |             | 0        | 1          |
| 242 | adminweb                                                         | 1               | 1       | 0    |             | 0        | 1          |
| 243 | ftp                                                              | 1               | 1       | 0    |             | 0        | 1          |
| 244 | matlab                                                           | 1               | 1       | 0    |             | 0        | 1          |
| 249 | test-360                                                         | 1               | 1       | 0    |             | 0        | 1          |
| 250 | test-3600                                                        | 1               | 1       | 0    |             | 0        | 1          |
| 251 | test-1286                                                        | 1               | 1       | 0    |             | 0        | 1          |
| 252 | ftpt                                                             | 1               | 1       | 0    |             | 0        | 1          |
| 256 | ldap02/20190517                                                  | 1               | 1       | 0    |             | 0        | 1          |
| 257 | gitlab/20190517                                                  | 1               | 1       | 0    |             | 0        | 1          |
| 258 | bugzilla/20190517                                                | 1               | 1       | 0    |             | 0        | 1          |
| 259 | biometric/20190517                                               | 1               | 1       | 0    |             | 0        | 1          |
| 260 | maas-aibl/20190517                                               | 1               | 1       | 0    |             | 0        | 1          |
| 262 | aims-his/20190517                                                | 1               | 1       | 0    |             | 0        | 1          |
| 263 | adminweb/20190517                                                | 1               | 1       | 0    |             | 0        | 1          |
| 264 | ftp/20190517                                                     | 1               | 1       | 0    |             | 0        | 1          |
| 265 | ftpt/20190517                                                    | 1               | 1       | 0    |             | 0        | 1          |
| 266 | matlab/20190517                                                  | 1               | 1       | 0    |             | 0        | 1          |
| 271 | archiva                                                          | 1               | 1       | 0    |             | 0        | 1          |
| 272 | archiva/20190508                                                 | 1               | 1       | 0    |             | 0        | 1          |
| 273 | archiva/20190508-1                                               | 1               | 1       | 0    |             | 0        | 1          |
| 274 | archiva/20190517                                                 | 1               | 1       | 0    |             | 0        | 1          |
| 275 | archiva/20190517-1                                               | 1               | 1       | 0    |             | 0        | 1          |
| 286 | adminweb/20190621                                                | 1               | 1       | 0    |             | 0        | 1          |
| 287 | partkeepr/20190624-142740                                        | 1               | 1       | 0    |             | 0        | 1          |
| 288 | ldap02/20190624-142740                                           | 1               | 1       | 0    |             | 0        | 1          |
| 289 | gitlab/20190624-142740                                           | 1               | 1       | 0    |             | 0        | 1          |
| 290 | biometric/20190624-142740                                        | 1               | 1       | 0    |             | 0        | 1          |
| 291 | bugzilla/20190624-142740                                         | 1               | 1       | 0    |             | 0        | 1          |
| 295 | adminweb/20190708-adminweb                                       | 1               | 1       | 0    |             | 0        | 1          |
| 296 | maas-aibl/20190708-maas                                          | 1               | 1       | 0    |             | 0        | 1          |
| 300 | biometric/12072019                                               | 1               | 1       | 0    |             | 0        | 1          |
| 302 | 368bb7174b679ece9bd0dfe2ab953c02c47ff4451736cb255655ba8348f17bc0 | 1               | 1       | 1    |             | 0        | 1          |
| 303 | 368bb7174b679ece9bd0dfe2ab953c02c47ff4451736cb255655ba8348f17bc0 | 2               | 1       | 1    |             | 0        | 1          |
| 304 | tmp                                                              | 2               | 1       | 2    |             | 0        | 1          |
| 305 | tmp                                                              | 4               | 1       | 2    |             | 0        | 1          |
| 308 | CJava                                                            | 1               | 1       | 0    |             | 0        | 1          |
| 309 | 60f53d7289be4147834523e3c7ffb2d1f5b8a7cbf86afe80e22585a5380534ba | 1               | 1       | 1    |             | 0        | 1          |
| 312 | bugzilla/20190806                                                | 1               | 1       | 0    |             | 0        | 1          |
| 313 | partkeepr/20190807-160404                                        | 1               | 1       | 0    |             | 0        | 1          |
+-----+------------------------------------------------------------------+-----------------+---------+------+-------------+----------+------------

What’s the name of the container you tried to transfer?

biometric and bugzilla are the containers facing the problem

And the DB dumps above were on the target server (not the source)?

Because it looks like you have those two containers on there.
I would have expected to see leftover volumes in the storage_volumes listing but not in the containers listing.

Can i know the command for the same

Same commands but run on the target system, not on the source.

Results from target node -

~# lxd sql global "select * from containers;"
+----+---------+-----------------------------------+--------------+------+-----------+-------------------------------------+----------+-------------------------------------+-------------+------------+---------------------------+
| id | node_id |               name                | architecture | type | ephemeral |            creation_date            | stateful |            last_use_date            | description | project_id |        expiry_date        |
+----+---------+-----------------------------------+--------------+------+-----------+-------------------------------------+----------+-------------------------------------+-------------+------------+---------------------------+
| 5  | 1       | partkeepr                         | 2            | 0    | 0         | 2019-08-05T16:55:54.822134504+05:30 | 0        | 2019-08-06T15:59:46.59624415+05:30  |             | 1          | 0001-01-01T00:00:00Z      |
| 6  | 1       | partkeepr/20190517                | 2            | 1    | 0         | 2019-05-17T21:57:57+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 7  | 1       | partkeepr/20190624-142740         | 2            | 1    | 0         | 2019-06-24T14:27:41+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 8  | 1       | partkeepr/11-07-2019partkeepr     | 2            | 1    | 0         | 2019-07-11T11:12:44+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 51 | 1       | aiotmdev-devi                     | 2            | 0    | 0         | 2019-08-06T13:33:24.138050217+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 52 | 1       | aiotmdev-devi/20180709-131022     | 2            | 1    | 0         | 2018-07-09T13:14:01+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 53 | 1       | aims-his                          | 2            | 0    | 0         | 2019-08-06T13:45:14.943750022+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 54 | 1       | aims-his/20190517                 | 2            | 1    | 0         | 2019-05-17T21:58:09+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 55 | 1       | adminweb                          | 2            | 0    | 0         | 2019-08-06T14:03:21.272376535+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 56 | 1       | adminweb/20190517                 | 2            | 1    | 0         | 2019-05-17T21:58:16+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 57 | 1       | adminweb/20190621                 | 2            | 1    | 0         | 2019-06-21T12:34:56+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 58 | 1       | adminweb/20190708-adminweb        | 2            | 1    | 0         | 2019-07-08T12:20:32+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 64 | 1       | aiotm-besafe                      | 2            | 0    | 0         | 2019-08-06T15:17:16.993367954+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 65 | 1       | aiotm-besafe/20180709-131022      | 2            | 1    | 0         | 2018-07-09T13:10:51+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 67 | 1       | partkeepr-nd12s1-20190807         | 2            | 0    | 0         | 2019-08-07T16:09:01.517293767+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 68 | 1       | matlab                            | 2            | 0    | 0         | 2019-08-08T11:43:07.152784995+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 69 | 1       | matlab/20190517                   | 2            | 1    | 0         | 2019-05-17T21:58:34+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 76 | 1       | CJava                             | 2            | 0    | 0         | 2019-08-13T16:28:12.66410276+05:30  | 0        | 2019-08-13T17:08:37.102381719+05:30 |             | 1          | 0001-01-01T05:53:20+05:53 |
| 77 | 1       | git-mqtt                          | 2            | 0    | 0         | 2019-08-13T16:33:52.220161296+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 78 | 1       | aiotmdev-backend                  | 2            | 0    | 0         | 2019-08-13T16:42:17.779732676+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 79 | 1       | aiotmdev-backend/20180709-131022  | 2            | 1    | 0         | 2018-07-09T13:13:34+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 80 | 1       | aiotmdev-frontend                 | 2            | 0    | 0         | 2019-08-13T16:54:31.238916852+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T00:00:00Z      |
| 81 | 1       | aiotmdev-frontend/20180709-131022 | 2            | 1    | 0         | 2018-07-09T13:14:30+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 82 | 1       | aiotmdev-gps                      | 2            | 0    | 0         | 2019-08-13T16:59:56.300608757+05:30 | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
| 83 | 1       | aiotmdev-gps/20180709-131022      | 2            | 1    | 0         | 2018-07-09T13:15:00+05:30           | 0        | 1970-01-01T05:30:00+05:30           |             | 1          | 0001-01-01T05:53:20+05:53 |
+----+---------+-----------------------------------+--------------+------+-----------+-------------------------------------+----------+-------------------------------------+-------------+------------+---------------------------+
:~# lxd sql global "SELECT * FROM storage_volumes;"
+----+-----------------------------------+-----------------+---------+------+-------------+----------+------------+
| id |               name                | storage_pool_id | node_id | type | description | snapshot | project_id |
+----+-----------------------------------+-----------------+---------+------+-------------+----------+------------+
| 3  | partkeepr                         | 1               | 1       | 0    |             | 0        | 1          |
| 4  | partkeepr/20190517                | 1               | 1       | 0    |             | 0        | 1          |
| 5  | partkeepr/20190624-142740         | 1               | 1       | 0    |             | 0        | 1          |
| 6  | partkeepr/11-07-2019partkeepr     | 1               | 1       | 0    |             | 0        | 1          |
| 8  | biometric                         | 1               | 1       | 0    |             | 0        | 1          |
| 10 | bugzilla                          | 1               | 1       | 0    |             | 0        | 1          |
| 11 | aiotmdev-devi                     | 1               | 1       | 0    |             | 0        | 1          |
| 12 | aiotmdev-devi/20180709-131022     | 1               | 1       | 0    |             | 0        | 1          |
| 13 | aims-his                          | 1               | 1       | 0    |             | 0        | 1          |
| 14 | aims-his/20190517                 | 1               | 1       | 0    |             | 0        | 1          |
| 15 | adminweb                          | 1               | 1       | 0    |             | 0        | 1          |
| 16 | adminweb/20190517                 | 1               | 1       | 0    |             | 0        | 1          |
| 17 | adminweb/20190621                 | 1               | 1       | 0    |             | 0        | 1          |
| 18 | adminweb/20190708-adminweb        | 1               | 1       | 0    |             | 0        | 1          |
| 19 | bugzilla-snap1                    | 1               | 1       | 0    |             | 0        | 1          |
| 20 | bugzilla-sp                       | 1               | 1       | 0    |             | 0        | 1          |
| 22 | aiotm-besafe                      | 1               | 1       | 0    |             | 0        | 1          |
| 23 | aiotm-besafe/20180709-131022      | 1               | 1       | 0    |             | 0        | 1          |
| 25 | partkeepr-nd12s1-20190807         | 1               | 1       | 0    |             | 0        | 1          |
| 26 | matlab                            | 1               | 1       | 0    |             | 0        | 1          |
| 27 | matlab/20190517                   | 1               | 1       | 0    |             | 0        | 1          |
| 28 | archiva                           | 1               | 1       | 0    |             | 0        | 1          |
| 29 | CJava                             | 1               | 1       | 0    |             | 0        | 1          |
| 30 | git-mqtt                          | 1               | 1       | 0    |             | 0        | 1          |
| 31 | aiotmdev-backend                  | 1               | 1       | 0    |             | 0        | 1          |
| 32 | aiotmdev-backend/20180709-131022  | 1               | 1       | 0    |             | 0        | 1          |
| 33 | aiotmdev-frontend                 | 1               | 1       | 0    |             | 0        | 1          |
| 34 | aiotmdev-frontend/20180709-131022 | 1               | 1       | 0    |             | 0        | 1          |
| 35 | aiotmdev-gps                      | 1               | 1       | 0    |             | 0        | 1          |
| 36 | aiotmdev-gps/20180709-131022      | 1               | 1       | 0    |             | 0        | 1          |
+----+-----------------------------------+-----------------+---------+------+-------------+----------+------------+

Ok, then on the target machine, run:

  • lxd sql global “DELETE FROM storage_volumes WHERE name=‘bugzilla’;”
  • lxd sql global “DELETE FROM storage_volumes WHERE name=‘biometric’;”

This will clear the leftover storage volumes and should fix the copy.

Try to below command

  • lxd sql global “DELETE FROM storage_volumes WHERE name=‘bugzilla’;”
    and after try to copy it again gets following message:
    #lxc copy bugzilla node35:
    Error: Failed container creation: Create LXC container: {“hostname”: [“Node with this Hostname already exists.”]}

Sounds like you’re connected to MAAS.

Are both source and target servers connected to the same MAAS?
If so, then this is indeed going to be a problem as MAAS will not allow two containers being defined, even temporarily, using the same name.

Dear Stephane ,

Yes , both source and target nodes are connected to MAAS

From both source and target nodes maas connection removed through

lxc profile edit default

Please let me know anything else to be done with maas configuration settings .

Also i tried to make a copy of container with in same node

lxc copy

But , with my case bugzilla container while copying gets following error:

~# lxc copy bugzilla bugzilla1
	Error: Create LXC container: IP address is already in use.

Tried with the same node where bugzilla lies ,we have partkeepr container make copy within container

And one more point is only biometric and bugzilla having the problem , rest all containers i can able to move to another node .

Waiting for your suggestion

Thank you