You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by GitBox <gi...@apache.org> on 2021/01/21 12:09:51 UTC
[GitHub] [cloudstack] AlexanderKgr opened a new issue #4606: List of templates - 500 server error
AlexanderKgr opened a new issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606
<!--
Verify first that your issue/request is not already reported on GitHub.
Also test if the latest release and master branch are affected too.
Always add information AFTER of these HTML comments, but no need to delete the comments.
-->
##### ISSUE TYPE
<!-- Pick one below and delete the rest -->
* Bug Report
##### COMPONENT NAME
UI
~~~
~~~
##### CLOUDSTACK VERSION
4.15.
~~~
~~~
##### CONFIGURATION
Advanced networking
##### OS / ENVIRONMENT
<!--
Information about the environment if relevant, N/A otherwise
-->
##### SUMMARY
Until yesterday was working perfectly
##### STEPS TO REPRODUCE
Select images - Templates and i have the issue
~~~
~~~
<!-- You can also paste gist.github.com links for larger files -->
##### EXPECTED RESULTS
Until yesterday it was displaying templates
~~~
~~~
##### ACTUAL RESULTS
And the logs from cloudstack server
~~~
~~~
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] rhtyd commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
rhtyd commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-764617175
NPE possibly due to null value returned at https://github.com/apache/cloudstack/blob/4.15/server/src/main/java/com/cloud/api/query/dao/TemplateJoinDaoImpl.java#L164
cc @nvazquez @harikrishna-patnala - does this seems like vsphere/deploy-as-is changes?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr closed issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
AlexanderKgr closed issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] Pearl1594 commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
Pearl1594 commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-765201221
@AlexanderKgr going over the tables shared, it seems like there are some active templates on stores with id's 15 and 16 but these stores have been deleted. Ideally, if there are active templates on a store, removal of the image stores will be prevented. It's because of the presence of these templates that the API fails
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] rhtyd commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
rhtyd commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-764617175
NPE possibly due to null value returned at https://github.com/apache/cloudstack/blob/4.15/server/src/main/java/com/cloud/api/query/dao/TemplateJoinDaoImpl.java#L164
cc @nvazquez @harikrishna-patnala - does this seems like vsphere/deploy-as-is changes?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] shwstppr commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
shwstppr commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-764617097
@AlexanderKgr have you removed any secondary store?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] DaanHoogland commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
DaanHoogland commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-764686565
> > @AlexanderKgr these images are not very helpful. Can you add the text version?
> > You say it stopped working, was this after an upgrade or with the same version?
>
> it was working perfectly for 3-4 days without any issue
so no upgrade, same install, same templates?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] weizhouapache commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
weizhouapache commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-764812608
> > > > @AlexanderKgr these images are not very helpful. Can you add the text version?
> > > > You say it stopped working, was this after an upgrade or with the same version?
> > >
> > >
> > > it was working perfectly for 3-4 days without any issue
> >
> >
> > so no upgrade, same install, same templates?
>
> Updated to 4.15 before 3 - 4 days. Hadn't any issue those days. But today this 500 error.
> Of course there have been changes concerning templates. But no change concerning secondary storage and hosts. Anything that can help me fix this issue?
@AlexanderKgr
could you please share the tables below ?
(1) vm_template
(2) template_store_ref
(3) image_store
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] shwstppr commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
shwstppr commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-764617097
@AlexanderKgr have you removed any secondary store?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr edited a comment on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
AlexanderKgr edited a comment on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-764715094
> > > @AlexanderKgr these images are not very helpful. Can you add the text version?
> > > You say it stopped working, was this after an upgrade or with the same version?
> >
> >
> > it was working perfectly for 3-4 days without any issue
>
> so no upgrade, same install, same templates?
Updated to 4.15 before 3 - 4 days. Hadn't any issue those days. But today this 500 error.
Of course there have been changes concerning templates. But no change concerning secondary storage and hosts. Anything that can help me fix this issue?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
AlexanderKgr commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-764620605
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
AlexanderKgr commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-764625891
> @AlexanderKgr have you removed any secondary store?
no nothing
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
AlexanderKgr commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-764715094
> > > @AlexanderKgr these images are not very helpful. Can you add the text version?
> > > You say it stopped working, was this after an upgrade or with the same version?
> >
> >
> > it was working perfectly for 3-4 days without any issue
>
> so no upgrade, same install, same templates?
Updated to 4.15 before 3 - 4 days. Hadn't any issue those days. But today this 500 error
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
AlexanderKgr commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-764620605
> @AlexanderKgr these images are not very helpful. Can you add the text version?
>
> You say it stopped working, was this after an upgrade or with the same version?
it was working perfectly for 3-4 days without any issue
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] weizhouapache commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
weizhouapache commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-765226269
> yes I checked the same what @Pearl1594 mentioned.
> @AlexanderKgr please check if you have removed those secondary storages manually by some DB changes. If the secondary storage still available revert the DB changes or mark the active templates on those secondary storages as removed. Hope this will fix the your problem
@harikrishna-patnala agrees. it seems @AlexanderKgr removed db entries manually.
it is not a bug.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] harikrishna-patnala commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
harikrishna-patnala commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-765113922
> NPE possibly due to null value returned at https://github.com/apache/cloudstack/blob/4.15/server/src/main/java/com/cloud/api/query/dao/TemplateJoinDaoImpl.java#L164
> cc @nvazquez @harikrishna-patnala - does this seems like vsphere/deploy-as-is changes?
Not related to those changes @rhtyd . We can investigate based on the tables requested by @weizhouapache
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] DaanHoogland commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
DaanHoogland commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-764614459
@AlexanderKgr these images are not very helpful. Can you add the text version?
You say it stopped working, was this after an upgrade or with the same version?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr edited a comment on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
AlexanderKgr edited a comment on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-764715094
> > > @AlexanderKgr these images are not very helpful. Can you add the text version?
> > > You say it stopped working, was this after an upgrade or with the same version?
> >
> >
> > it was working perfectly for 3-4 days without any issue
>
> so no upgrade, same install, same templates?
Updated to 4.15 before 3 - 4 days. Hadn't any issue those days. But today this 500 error.
Of course there have been changes concerning templates. But no change concerning secondary storage and hosts. Anything that can help me fix this issue?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] DaanHoogland commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
DaanHoogland commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-764614459
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] weizhouapache commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
weizhouapache commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-764812608
> > > > @AlexanderKgr these images are not very helpful. Can you add the text version?
> > > > You say it stopped working, was this after an upgrade or with the same version?
> > >
> > >
> > > it was working perfectly for 3-4 days without any issue
> >
> >
> > so no upgrade, same install, same templates?
>
> Updated to 4.15 before 3 - 4 days. Hadn't any issue those days. But today this 500 error.
> Of course there have been changes concerning templates. But no change concerning secondary storage and hosts. Anything that can help me fix this issue?
@AlexanderKgr
could you please share the tables below ?
(1) vm_template
(2) template_store_ref
(3) image_store
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] harikrishna-patnala commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
harikrishna-patnala commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-765113922
> NPE possibly due to null value returned at https://github.com/apache/cloudstack/blob/4.15/server/src/main/java/com/cloud/api/query/dao/TemplateJoinDaoImpl.java#L164
> cc @nvazquez @harikrishna-patnala - does this seems like vsphere/deploy-as-is changes?
Not related to those changes @rhtyd . We can investigate based on the tables requested by @weizhouapache
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
AlexanderKgr commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-765250191
ok found the issue and fixed it. thank you very much.
tried migrating these secondary storages and something might happen with the migration
by the way...is there anywhere a description of the tables or a diagram of the db?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
AlexanderKgr commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-765158680
> > > > > @AlexanderKgr these images are not very helpful. Can you add the text version?
> > > > > You say it stopped working, was this after an upgrade or with the same version?
> > > >
> > > >
> > > > it was working perfectly for 3-4 days without any issue
> > >
> > >
> > > so no upgrade, same install, same templates?
> >
> >
> > Updated to 4.15 before 3 - 4 days. Hadn't any issue those days. But today this 500 error.
> > Of course there have been changes concerning templates. But no change concerning secondary storage and hosts. Anything that can help me fix this issue?
>
> @AlexanderKgr
> could you please share the tables below ?
> (1) vm_template
> (2) template_store_ref
> (3) image_store
sorry for the delay
the tables
[tables.zip](https://github.com/apache/cloudstack/files/5853916/tables.zip)
thanks for helping
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] harikrishna-patnala commented on issue #4606: List of templates - 500 server error
Posted by GitBox <gi...@apache.org>.
harikrishna-patnala commented on issue #4606:
URL: https://github.com/apache/cloudstack/issues/4606#issuecomment-765203911
yes I checked the same what @Pearl1594 mentioned.
@AlexanderKgr please check if you have removed those secondary storages manually by some DB changes. If the secondary storage still available revert the DB changes or mark the active templates on those secondary storages as removed. Hope this will fix the your problem
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org