Guest User

from template_store_ref;

a guest
Aug 16th, 2014
270
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.04 KB | None | 0 0
  1. mysql> select * from template_store_ref;
  2. +----+----------+-------------+---------------------+---------------------+--------------------------------------+--------------+------------+------------+---------------+----------------------+----------------------------------------------------+---------------------------------------------------------------------------------------+--------------------------------------------------------------+--------------------------------------------------------------------------------------------+-----------+-----------+---------+--------------+---------+---------------------+----------------------+--------------+
  3. | id | store_id | template_id | created | last_updated | job_id | download_pct | size | store_role | physical_size | download_state | error_str | local_path | install_path | url | state | destroyed | is_copy | update_count | ref_cnt | updated | download_url_created | download_url |
  4. +----+----------+-------------+---------------------+---------------------+--------------------------------------+--------------+------------+------------+---------------+----------------------+----------------------------------------------------+---------------------------------------------------------------------------------------+--------------------------------------------------------------+--------------------------------------------------------------------------------------------+-----------+-----------+---------+--------------+---------+---------------------+----------------------+--------------+
  5. | 4 | 1 | 3 | 2014-08-14 09:35:16 | 2014-08-16 18:50:41 | NULL | 100 | 307120640 | Image | 307120640 | DOWNLOADED | NULL | NULL | template/tmpl/1/3/41d1652e-d129-4e4d-8acd-df7a4d303c0d.qcow2 | http://download.cloud.com/templates/4.3/systemvm64template-2014-01-14-master-kvm.qcow2.bz2 | Ready | 0 | 0 | 0 | 0 | NULL | NULL | NULL |
  6. | 16 | 1 | 4 | 2014-08-16 09:05:12 | 2014-08-16 11:55:42 | f1515777-95a3-4ecc-96cc-cd874321a351 | 99 | 0 | Image | 0 | DOWNLOAD_IN_PROGRESS | | /mnt/SecStorage/c22b0fcc-cc29-399e-9b71-f474fc0c2d1e/null/dnld4107663942445325938tmp_ | NULL | NULL | Creating | 0 | 0 | 5 | 0 | 2014-08-16 10:30:56 | NULL | NULL |
  7. | 20 | 1 | 4 | 2014-08-16 09:41:57 | 2014-08-16 11:59:03 | f1515777-95a3-4ecc-96cc-cd874321a351 | 100 | 0 | Image | 0 | DOWNLOAD_IN_PROGRESS | Download success, starting install | /mnt/SecStorage/c22b0fcc-cc29-399e-9b71-f474fc0c2d1e/null/dnld4107663942445325938tmp_ | null/c1990e4a-6573-3781-8f87-47b42b6e64d6.qcow2 | NULL | Allocated | 0 | 0 | 0 | 0 | NULL | NULL | NULL |
  8. | 21 | 1 | 4 | 2014-08-16 09:41:58 | 2014-08-16 12:00:14 | f1515777-95a3-4ecc-96cc-cd874321a351 | 100 | 8589934592 | Image | 1769537536 | DOWNLOADED | Install completed successfully at 8/16/14 12:00 PM | /mnt/SecStorage/c22b0fcc-cc29-399e-9b71-f474fc0c2d1e/null/dnld4107663942445325938tmp_ | null/c1990e4a-6573-3781-8f87-47b42b6e64d6.qcow2 | NULL | Allocated | 0 | 0 | 0 | 0 | NULL | NULL | NULL |
  9. | 22 | 1 | 4 | 2014-08-16 09:42:08 | 2014-08-16 11:58:43 | f1515777-95a3-4ecc-96cc-cd874321a351 | 100 | 0 | Image | 0 | DOWNLOAD_IN_PROGRESS | Download success, starting install | /mnt/SecStorage/c22b0fcc-cc29-399e-9b71-f474fc0c2d1e/null/dnld4107663942445325938tmp_ | null/c1990e4a-6573-3781-8f87-47b42b6e64d6.qcow2 | NULL | Allocated | 0 | 0 | 0 | 0 | NULL | NULL | NULL |
  10. | 25 | 1 | 4 | 2014-08-16 09:42:36 | 2014-08-16 11:59:23 | f1515777-95a3-4ecc-96cc-cd874321a351 | 100 | 0 | Image | 0 | DOWNLOAD_IN_PROGRESS | Download success, starting install | /mnt/SecStorage/c22b0fcc-cc29-399e-9b71-f474fc0c2d1e/null/dnld4107663942445325938tmp_ | null/c1990e4a-6573-3781-8f87-47b42b6e64d6.qcow2 | NULL | Creating | 0 | 0 | 1 | 0 | 2014-08-16 10:03:02 | NULL | NULL |
  11. | 27 | 1 | 4 | 2014-08-16 10:03:02 | 2014-08-16 12:00:03 | f1515777-95a3-4ecc-96cc-cd874321a351 | 100 | 8589934592 | Image | 1769537536 | DOWNLOADED | Install completed successfully at 8/16/14 12:00 PM | /mnt/SecStorage/c22b0fcc-cc29-399e-9b71-f474fc0c2d1e/null/dnld4107663942445325938tmp_ | null/c1990e4a-6573-3781-8f87-47b42b6e64d6.qcow2 | NULL | Allocated | 0 | 0 | 0 | 0 | NULL | NULL | NULL |
  12. | 28 | 1 | 4 | 2014-08-16 10:03:14 | 2014-08-16 11:53:42 | f1515777-95a3-4ecc-96cc-cd874321a351 | 98 | 0 | Image | 0 | DOWNLOAD_IN_PROGRESS | | /mnt/SecStorage/c22b0fcc-cc29-399e-9b71-f474fc0c2d1e/null/dnld4107663942445325938tmp_ | NULL | NULL | Creating | 0 | 0 | 1 | 0 | 2014-08-16 10:30:43 | NULL | NULL |
  13. | 29 | 1 | 4 | 2014-08-16 10:30:43 | 2014-08-16 11:56:02 | f1515777-95a3-4ecc-96cc-cd874321a351 | 100 | 0 | Image | 0 | DOWNLOAD_IN_PROGRESS | Download success, starting install | /mnt/SecStorage/c22b0fcc-cc29-399e-9b71-f474fc0c2d1e/null/dnld4107663942445325938tmp_ | NULL | NULL | Allocated | 0 | 0 | 0 | 0 | NULL | NULL | NULL |
  14. | 30 | 1 | 4 | 2014-08-16 10:30:56 | 2014-08-16 11:59:43 | f1515777-95a3-4ecc-96cc-cd874321a351 | 100 | 0 | Image | 0 | DOWNLOAD_IN_PROGRESS | Download success, starting install | /mnt/SecStorage/c22b0fcc-cc29-399e-9b71-f474fc0c2d1e/null/dnld4107663942445325938tmp_ | null/c1990e4a-6573-3781-8f87-47b42b6e64d6.qcow2 | NULL | Allocated | 0 | 0 | 0 | 0 | NULL | NULL | NULL |
  15. | 31 | 1 | 4 | 2014-08-16 18:50:42 | NULL | NULL | 0 | NULL | Image | 0 | NULL | NULL | NULL | template/tmpl/1/4 | NULL | Allocated | 0 | 0 | 0 | 0 | NULL | NULL | NULL |
  16. +----+----------+-------------+---------------------+---------------------+--------------------------------------+--------------+------------+------------+---------------+----------------------+----------------------------------------------------+---------------------------------------------------------------------------------------+--------------------------------------------------------------+--------------------------------------------------------------------------------------------+-----------+-----------+---------+--------------+---------+---------------------+----------------------+--------------+
  17. 11 rows in set (0.00 sec)
  18.  
  19. mysql>
Advertisement
Add Comment
Please, Sign In to add comment