Activity

1. weizhouapache

   added this to the 4.19.1.0 milestone on Apr 17, 2024
2. weizhouapache commented on Apr 17, 2024

   

   weizhouapache

   on Apr 17, 2024

   MemberAuthor

   More actions

   The issue is caused by multiple duplicated records for the templates in template_store_ref table

   mysql> select id,store_id,template_id,created,download_pct,size,download_state,error_str,url,state from template_store_ref where template_id=243;
   +----+----------+-------------+---------------------+--------------+------------+----------------------+----------------------------------------------------+------+----------+
   | id | store_id | template_id | created             | download_pct | size       | download_state       | error_str                                          | url  | state    |
   +----+----------+-------------+---------------------+--------------+------------+----------------------+----------------------------------------------------+------+----------+
   | 96 |        2 |         243 | 2024-04-17 08:17:49 |          100 | 5242880000 | DOWNLOADED           | Install completed successfully at 4/17/24, 8:21 AM | NULL | Creating |
   | 97 |        1 |         243 | 2024-04-17 08:17:49 |          100 |          0 | DOWNLOAD_IN_PROGRESS | Download success, starting install                 | NULL | Creating |
   | 98 |        2 |         243 | 2024-04-17 08:17:49 |          100 | 5242880000 | DOWNLOADED           | Install completed successfully at 4/17/24, 8:21 AM | NULL | Ready    |
   | 99 |        1 |         243 | 2024-04-17 08:17:49 |          100 | 5242880000 | DOWNLOADED           | Install completed successfully at 4/17/24, 8:19 AM | NULL | Ready    |
   +----+----------+-------------+---------------------+--------------+------------+----------------------+----------------------------------------------------+------+----------+
   4 rows in set (0.00 sec)
   

   once the duplicated records are removed, the template is Ready

   mysql> delete from template_store_ref where id=96;
   Query OK, 1 row affected (0.00 sec)
   
   mysql> delete from template_store_ref where id=97;
   Query OK, 1 row affected (0.00 sec)
   
   

   

   I will create a draft PR

   Reacted by Vishesh
3. DaanHoogland

   added

   affects:4.19.0

   on Apr 17, 2024
4. weizhouapache

   linked a pull request that will close this issueserver: fix duplicated records for templates if there are multiple zones #8933on Apr 17, 2024
5. sureshanaparti

   added this to Apache CloudStack 4.19.1on Apr 23, 2024
6. shwstppr commented on May 22, 2024

   

   shwstppr

   on May 22, 2024

   Contributor

   More actions

   @weizhouapache should we close this as #8933 is merged?
7. weizhouapache commented on May 22, 2024

   

   weizhouapache

   on May 22, 2024

   MemberAuthor

   More actions

   @weizhouapache should we close this as #8933 is merged?

   yes @shwstppr
8. sureshanaparti

   moved this to In Progress in Apache CloudStack 4.19.1on May 23, 2024
9. sureshanaparti commented on May 23, 2024

   

   sureshanaparti

   on May 23, 2024

   Contributor

   More actions

   @weizhouapache Closing this, as advised.
10. sureshanaparti

    closed this as completedon May 23, 2024
11. github-project-automation

    moved this from In Progress to Done in Apache CloudStack 4.19.1on May 23, 2024