[jira] [Updated] (CLOUDSTACK-7266) Deleting account is not cleaning the snapshot entries in secondary storage

2014-08-11 Thread Min Chen (JIRA)

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-7266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Min Chen updated CLOUDSTACK-7266:
-

Assignee: manasaveloori  (was: Min Chen)

Assign back to reporter, please assign back to me once you attached the 
requested log.

 Deleting account is not cleaning the snapshot entries in secondary storage
 --

 Key: CLOUDSTACK-7266
 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-7266
 Project: CloudStack
  Issue Type: Bug
  Security Level: Public(Anyone can view this level - this is the 
 default.) 
  Components: Snapshot
Affects Versions: 4.5.0
Reporter: manasaveloori
Assignee: manasaveloori
Priority: Critical
 Fix For: 4.5.0

 Attachments: management-server.rar, mysqldump45.dmp


 Steps:
 1. Deployed CS with ESXi5.1
 2. Created VM with data disk.
 3. Created snapshots on both root and data disks.
 4. Now deleted the account.
  id: 4
account_name: test
uuid: c55b8251-7bb0-4531-bd7e-7811d55160e6
type: 0
   domain_id: 1
   state: enabled
 removed: 2014-08-06 06:04:50
  cleanup_needed: 0
  network_domain: NULL
 default_zone_id: NULL
 default: 0
 5. All the snapshots got deleted as apart of account clean up in DB
 mysql select * from snapshots where account_id=4\G;
 *** 1. row ***
   id: 38
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_2014080605
 uuid: 716f0dd5-056e-4cab-b814-125fc6fe84e6
snapshot_type: 0
 type_description: MANUAL
 size: 2147483648
  created: 2014-08-06 05:44:44
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 2. row ***
   id: 39
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_20140806054650
 uuid: ea949547-5ef7-40b0-99a6-152d346a0ad6
snapshot_type: 3
 type_description: HOURLY
 size: 2147483648
  created: 2014-08-06 05:46:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 3. row ***
   id: 40
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_20140806055150
 uuid: b8af0810-b08a-40bd-a114-13a4d75907ca
snapshot_type: 4
 type_description: DAILY
 size: 2147483648
  created: 2014-08-06 05:51:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 4. row ***
   id: 41
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_20140806055150
 uuid: dda5cfb7-f5ab-4bd0-bdd3-953932e77f5e
snapshot_type: 5
 type_description: WEEKLY
 size: 2147483648
  created: 2014-08-06 05:51:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 5. row ***
   id: 42
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 19
 disk_offering_id: 3
   status: Destroyed
 path: NULL
 name: testvmacct1_DATA-11_20140806055150
 uuid: 69c8b7d1-baab-42ac-9a7d-dbdb0688654f
snapshot_type: 3
 type_description: HOURLY
 size: 5368709120
  created: 2014-08-06 05:51:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 6. row ***
   id: 44
   data_center_id: 1
   

[jira] [Updated] (CLOUDSTACK-7266) Deleting account is not cleaning the snapshot entries in secondary storage

2014-08-11 Thread manasaveloori (JIRA)

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-7266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

manasaveloori updated CLOUDSTACK-7266:
--

Attachment: cloud.log-20140806.gz

 Deleting account is not cleaning the snapshot entries in secondary storage
 --

 Key: CLOUDSTACK-7266
 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-7266
 Project: CloudStack
  Issue Type: Bug
  Security Level: Public(Anyone can view this level - this is the 
 default.) 
  Components: Snapshot
Affects Versions: 4.5.0
Reporter: manasaveloori
Assignee: manasaveloori
Priority: Critical
 Fix For: 4.5.0

 Attachments: cloud.log-20140806.gz, management-server.rar, 
 mysqldump45.dmp


 Steps:
 1. Deployed CS with ESXi5.1
 2. Created VM with data disk.
 3. Created snapshots on both root and data disks.
 4. Now deleted the account.
  id: 4
account_name: test
uuid: c55b8251-7bb0-4531-bd7e-7811d55160e6
type: 0
   domain_id: 1
   state: enabled
 removed: 2014-08-06 06:04:50
  cleanup_needed: 0
  network_domain: NULL
 default_zone_id: NULL
 default: 0
 5. All the snapshots got deleted as apart of account clean up in DB
 mysql select * from snapshots where account_id=4\G;
 *** 1. row ***
   id: 38
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_2014080605
 uuid: 716f0dd5-056e-4cab-b814-125fc6fe84e6
snapshot_type: 0
 type_description: MANUAL
 size: 2147483648
  created: 2014-08-06 05:44:44
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 2. row ***
   id: 39
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_20140806054650
 uuid: ea949547-5ef7-40b0-99a6-152d346a0ad6
snapshot_type: 3
 type_description: HOURLY
 size: 2147483648
  created: 2014-08-06 05:46:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 3. row ***
   id: 40
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_20140806055150
 uuid: b8af0810-b08a-40bd-a114-13a4d75907ca
snapshot_type: 4
 type_description: DAILY
 size: 2147483648
  created: 2014-08-06 05:51:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 4. row ***
   id: 41
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_20140806055150
 uuid: dda5cfb7-f5ab-4bd0-bdd3-953932e77f5e
snapshot_type: 5
 type_description: WEEKLY
 size: 2147483648
  created: 2014-08-06 05:51:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 5. row ***
   id: 42
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 19
 disk_offering_id: 3
   status: Destroyed
 path: NULL
 name: testvmacct1_DATA-11_20140806055150
 uuid: 69c8b7d1-baab-42ac-9a7d-dbdb0688654f
snapshot_type: 3
 type_description: HOURLY
 size: 5368709120
  created: 2014-08-06 05:51:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 6. row ***
   id: 44
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 19
 

[jira] [Updated] (CLOUDSTACK-7266) Deleting account is not cleaning the snapshot entries in secondary storage

2014-08-11 Thread manasaveloori (JIRA)

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-7266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

manasaveloori updated CLOUDSTACK-7266:
--

Assignee: Min Chen  (was: manasaveloori)

 Deleting account is not cleaning the snapshot entries in secondary storage
 --

 Key: CLOUDSTACK-7266
 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-7266
 Project: CloudStack
  Issue Type: Bug
  Security Level: Public(Anyone can view this level - this is the 
 default.) 
  Components: Snapshot
Affects Versions: 4.5.0
Reporter: manasaveloori
Assignee: Min Chen
Priority: Critical
 Fix For: 4.5.0

 Attachments: cloud.log-20140806.gz, management-server.rar, 
 mysqldump45.dmp


 Steps:
 1. Deployed CS with ESXi5.1
 2. Created VM with data disk.
 3. Created snapshots on both root and data disks.
 4. Now deleted the account.
  id: 4
account_name: test
uuid: c55b8251-7bb0-4531-bd7e-7811d55160e6
type: 0
   domain_id: 1
   state: enabled
 removed: 2014-08-06 06:04:50
  cleanup_needed: 0
  network_domain: NULL
 default_zone_id: NULL
 default: 0
 5. All the snapshots got deleted as apart of account clean up in DB
 mysql select * from snapshots where account_id=4\G;
 *** 1. row ***
   id: 38
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_2014080605
 uuid: 716f0dd5-056e-4cab-b814-125fc6fe84e6
snapshot_type: 0
 type_description: MANUAL
 size: 2147483648
  created: 2014-08-06 05:44:44
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 2. row ***
   id: 39
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_20140806054650
 uuid: ea949547-5ef7-40b0-99a6-152d346a0ad6
snapshot_type: 3
 type_description: HOURLY
 size: 2147483648
  created: 2014-08-06 05:46:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 3. row ***
   id: 40
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_20140806055150
 uuid: b8af0810-b08a-40bd-a114-13a4d75907ca
snapshot_type: 4
 type_description: DAILY
 size: 2147483648
  created: 2014-08-06 05:51:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 4. row ***
   id: 41
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_20140806055150
 uuid: dda5cfb7-f5ab-4bd0-bdd3-953932e77f5e
snapshot_type: 5
 type_description: WEEKLY
 size: 2147483648
  created: 2014-08-06 05:51:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 5. row ***
   id: 42
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 19
 disk_offering_id: 3
   status: Destroyed
 path: NULL
 name: testvmacct1_DATA-11_20140806055150
 uuid: 69c8b7d1-baab-42ac-9a7d-dbdb0688654f
snapshot_type: 3
 type_description: HOURLY
 size: 5368709120
  created: 2014-08-06 05:51:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 6. row ***
   id: 44
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 19
 

[jira] [Updated] (CLOUDSTACK-7266) Deleting account is not cleaning the snapshot entries in secondary storage

2014-08-07 Thread Animesh Chaturvedi (JIRA)

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-7266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Animesh Chaturvedi updated CLOUDSTACK-7266:
---

Assignee: Min Chen

 Deleting account is not cleaning the snapshot entries in secondary storage
 --

 Key: CLOUDSTACK-7266
 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-7266
 Project: CloudStack
  Issue Type: Bug
  Security Level: Public(Anyone can view this level - this is the 
 default.) 
  Components: Snapshot
Affects Versions: 4.5.0
Reporter: manasaveloori
Assignee: Min Chen
Priority: Critical
 Fix For: 4.5.0

 Attachments: management-server.rar, mysqldump45.dmp


 Steps:
 1. Deployed CS with ESXi5.1
 2. Created VM with data disk.
 3. Created snapshots on both root and data disks.
 4. Now deleted the account.
  id: 4
account_name: test
uuid: c55b8251-7bb0-4531-bd7e-7811d55160e6
type: 0
   domain_id: 1
   state: enabled
 removed: 2014-08-06 06:04:50
  cleanup_needed: 0
  network_domain: NULL
 default_zone_id: NULL
 default: 0
 5. All the snapshots got deleted as apart of account clean up in DB
 mysql select * from snapshots where account_id=4\G;
 *** 1. row ***
   id: 38
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_2014080605
 uuid: 716f0dd5-056e-4cab-b814-125fc6fe84e6
snapshot_type: 0
 type_description: MANUAL
 size: 2147483648
  created: 2014-08-06 05:44:44
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 2. row ***
   id: 39
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_20140806054650
 uuid: ea949547-5ef7-40b0-99a6-152d346a0ad6
snapshot_type: 3
 type_description: HOURLY
 size: 2147483648
  created: 2014-08-06 05:46:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 3. row ***
   id: 40
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_20140806055150
 uuid: b8af0810-b08a-40bd-a114-13a4d75907ca
snapshot_type: 4
 type_description: DAILY
 size: 2147483648
  created: 2014-08-06 05:51:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 4. row ***
   id: 41
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_20140806055150
 uuid: dda5cfb7-f5ab-4bd0-bdd3-953932e77f5e
snapshot_type: 5
 type_description: WEEKLY
 size: 2147483648
  created: 2014-08-06 05:51:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 5. row ***
   id: 42
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 19
 disk_offering_id: 3
   status: Destroyed
 path: NULL
 name: testvmacct1_DATA-11_20140806055150
 uuid: 69c8b7d1-baab-42ac-9a7d-dbdb0688654f
snapshot_type: 3
 type_description: HOURLY
 size: 5368709120
  created: 2014-08-06 05:51:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 6. row ***
   id: 44
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 19
 disk_offering_id: 3
   status: 

[jira] [Updated] (CLOUDSTACK-7266) Deleting account is not cleaning the snapshot entries in secondary storage

2014-08-06 Thread manasaveloori (JIRA)

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-7266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

manasaveloori updated CLOUDSTACK-7266:
--

Summary: Deleting account is not cleaning the snapshot entries in secondary 
storage  (was: Deleting account is not cleaning the snaphot entries in 
secondary storage)

 Deleting account is not cleaning the snapshot entries in secondary storage
 --

 Key: CLOUDSTACK-7266
 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-7266
 Project: CloudStack
  Issue Type: Bug
  Security Level: Public(Anyone can view this level - this is the 
 default.) 
  Components: Snapshot
Affects Versions: 4.5.0
Reporter: manasaveloori
Priority: Critical
 Fix For: 4.5.0

 Attachments: management-server.rar, mysqldump45.dmp


 Steps:
 1. Deployed CS with ESXi5.1
 2. Created VM with data disk.
 3. Created snapshots on both root and data disks.
 4. Now deleted the account.
  id: 4
account_name: test
uuid: c55b8251-7bb0-4531-bd7e-7811d55160e6
type: 0
   domain_id: 1
   state: enabled
 removed: 2014-08-06 06:04:50
  cleanup_needed: 0
  network_domain: NULL
 default_zone_id: NULL
 default: 0
 5. All the snapshots got deleted as apart of account clean up in DB
 mysql select * from snapshots where account_id=4\G;
 *** 1. row ***
   id: 38
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_2014080605
 uuid: 716f0dd5-056e-4cab-b814-125fc6fe84e6
snapshot_type: 0
 type_description: MANUAL
 size: 2147483648
  created: 2014-08-06 05:44:44
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 2. row ***
   id: 39
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_20140806054650
 uuid: ea949547-5ef7-40b0-99a6-152d346a0ad6
snapshot_type: 3
 type_description: HOURLY
 size: 2147483648
  created: 2014-08-06 05:46:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 3. row ***
   id: 40
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_20140806055150
 uuid: b8af0810-b08a-40bd-a114-13a4d75907ca
snapshot_type: 4
 type_description: DAILY
 size: 2147483648
  created: 2014-08-06 05:51:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 4. row ***
   id: 41
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 18
 disk_offering_id: 1
   status: Destroyed
 path: NULL
 name: testvmacct1_ROOT-11_20140806055150
 uuid: dda5cfb7-f5ab-4bd0-bdd3-953932e77f5e
snapshot_type: 5
 type_description: WEEKLY
 size: 2147483648
  created: 2014-08-06 05:51:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 5. row ***
   id: 42
   data_center_id: 1
   account_id: 4
domain_id: 1
volume_id: 19
 disk_offering_id: 3
   status: Destroyed
 path: NULL
 name: testvmacct1_DATA-11_20140806055150
 uuid: 69c8b7d1-baab-42ac-9a7d-dbdb0688654f
snapshot_type: 3
 type_description: HOURLY
 size: 5368709120
  created: 2014-08-06 05:51:50
  removed: NULL
   backup_snap_id: NULL
 swift_id: NULL
   sechost_id: NULL
 prev_snap_id: NULL
  hypervisor_type: VMware
  version: 2.2
s3_id: NULL
 *** 6. row ***
   id: 44
   data_center_id: 1