Satheesh2050
(Satheesh Krishnavilas Anirudhan)
August 6, 2019, 6:56am
1
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
stgraber
(Stéphane Graber)
August 6, 2019, 4:31pm
2
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?
Satheesh2050
(Satheesh Krishnavilas Anirudhan)
August 12, 2019, 5:04am
3
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 |
+-----+---------+--------------------------------+--------------+------+-----------+-------------------------------------+----------+-------------------------------------+-------------+------------+---------------------------+
Satheesh2050
(Satheesh Krishnavilas Anirudhan)
August 12, 2019, 5:07am
4
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 |
+-----+------------------------------------------------------------------+-----------------+---------+------+-------------+----------+------------
stgraber
(Stéphane Graber)
August 12, 2019, 3:00pm
5
What’s the name of the container you tried to transfer?
Satheesh2050
(Satheesh Krishnavilas Anirudhan)
August 12, 2019, 3:28pm
6
biometric and bugzilla are the containers facing the problem
stgraber
(Stéphane Graber)
August 12, 2019, 7:17pm
7
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.
Satheesh2050
(Satheesh Krishnavilas Anirudhan)
August 13, 2019, 4:39am
8
Can i know the command for the same
stgraber
(Stéphane Graber)
August 13, 2019, 2:07pm
9
Same commands but run on the target system, not on the source.
Satheesh2050
(Satheesh Krishnavilas Anirudhan)
August 14, 2019, 4:37am
10
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 |
+----+---------+-----------------------------------+--------------+------+-----------+-------------------------------------+----------+-------------------------------------+-------------+------------+---------------------------+
Satheesh2050
(Satheesh Krishnavilas Anirudhan)
August 14, 2019, 4:37am
11
:~# 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 |
+----+-----------------------------------+-----------------+---------+------+-------------+----------+------------+
stgraber
(Stéphane Graber)
August 14, 2019, 2:00pm
12
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.
stgraber
(Stéphane Graber)
August 16, 2019, 8:42pm
14
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.
Satheesh2050
(Satheesh Krishnavilas Anirudhan)
August 17, 2019, 9:17am
15
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 .
Satheesh2050
(Satheesh Krishnavilas Anirudhan)
August 20, 2019, 3:05am
16
Waiting for your suggestion
Thank you
stgraber
(Stéphane Graber)
August 20, 2019, 2:32pm
17
Can you show lxc config show --expanded bugzilla
on the source server and lxc profile show default
on the target server?
Satheesh2050
(Satheesh Krishnavilas Anirudhan)
August 21, 2019, 4:30am
18
:~# lxc config show --expanded bugzilla
architecture: x86_64
config:
boot.autostart: “true”
image.architecture: amd64
image.description: ubuntu 16.04 LTS amd64 (release) (20170619.1)
image.label: release
image.os: ubuntu
image.release: xenial
image.serial: “20170619.1”
image.version: “16.04”
security.privileged: “true”
volatile.base_image: 7a7ff654cbd8f5f09bec03aa19d8d7d92649127d18659036a963b1ea63f90d25
volatile.eth0.host_name: veth39f75b43
volatile.eth0.hwaddr: 00:16:3e:f1:09:d1
volatile.idmap.base: “0”
volatile.idmap.current: ‘[]’
volatile.idmap.next: ‘[]’
volatile.last_state.idmap: ‘[]’
volatile.last_state.power: RUNNING
devices:
eth0:
ipv4.address: 10.3.6.237
maas.subnet.ipv4: AIBLSRV
name: eth0
nictype: bridged
parent: br1286
type: nic
root:
path: /
pool: default
type: disk
ephemeral: false
profiles:
default
stateful: false
description: “”
Satheesh2050
(Satheesh Krishnavilas Anirudhan)
August 21, 2019, 4:31am
19
~# lxc profile show default
config: {}
description: Default LXD profile
devices:
eth0:
name: eth0
nictype: bridged
parent: br1
type: nic
root:
path: /
pool: default
type: disk
name: default
used_by:
/1.0/containers/partkeepr
/1.0/containers/partkeepr/20190517
/1.0/containers/partkeepr/20190624-142740
/1.0/containers/partkeepr/11-07-2019partkeepr
/1.0/containers/aims-his
/1.0/containers/aims-his/20190517
/1.0/containers/adminweb
/1.0/containers/adminweb/20190517
/1.0/containers/adminweb/20190621
/1.0/containers/adminweb/20190708-adminweb
/1.0/containers/aiotm-besafe
/1.0/containers/aiotm-besafe/20180709-131022
/1.0/containers/partkeepr-nd12s1-20190807
/1.0/containers/matlab
/1.0/containers/matlab/20190517
/1.0/containers/CJava
/1.0/containers/git-mqtt
/1.0/containers/aiotmdev-backend
/1.0/containers/aiotmdev-backend/20180709-131022
/1.0/containers/aiotmdev-frontend
/1.0/containers/aiotmdev-frontend/20180709-131022
/1.0/containers/aiotmdev-gps
/1.0/containers/aiotmdev-gps/20180709-131022
/1.0/containers/aiotmdev-devi
/1.0/containers/aiotmdev-devi/20180709-131022
/1.0/containers/backup-aiotm-mqttauth
/1.0/containers/backup-aiotm-mqttauth/20181003-111356
/1.0/containers/backup-aiotm-mqttauth/20181101-120114
/1.0/containers/backup-aiotm-mqttauth/20181101-121736
/1.0/containers/backup-public-mqtt
/1.0/containers/backup-public-mqtt/20180808-232052
/1.0/containers/backup-public-mqtt/20181003-111356
/1.0/containers/backup-public-mqtt/20181101-120114
/1.0/containers/backup-public-mqtt/20181101-121736
/1.0/containers/gitlab-evidya
/1.0/containers/ftp
/1.0/containers/ftp/20190517
/1.0/containers/ftpt
/1.0/containers/ftpt/20190517
/1.0/containers/gitlab-ganglia
/1.0/containers/gitlab-runner15
stgraber
(Stéphane Graber)
August 21, 2019, 4:34pm
20
Can you try removing the eth0
device, moving your container and then adding it back on the target?
That should avoid any conflict in MAAS with subnet and/or IP.