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 2022/03/08 19:30:28 UTC
[GitHub] [cloudstack] AlexanderKgr opened a new issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
AlexanderKgr opened a new issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074
<!--
Verify first that your issue/request is not already reported on GitHub.
Also test if the latest release and main 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
<!--
Categorize the issue, e.g. API, VR, VPN, UI, etc.
-->
~~~
Update issue
~~~
##### CLOUDSTACK VERSION
<!--
New line separated list of affected versions, commit ID for issues on main branch.
-->
~~~
4.16.0.0 - 4.16.1.0
~~~
##### CONFIGURATION
<!--
Information about the configuration if relevant, e.g. basic network, advanced networking, etc. N/A otherwise
-->
Ubuntu Server 18.04
Advanced networking
##### OS / ENVIRONMENT
<!--
Information about the environment if relevant, N/A otherwise
-->
##### SUMMARY
<!-- Explain the problem/feature briefly -->
Followed instructions for update me test lab and have the following issue.
##### STEPS TO REPRODUCE
<!--
For bugs, show exactly how to reproduce the problem, using a minimal test-case. Use Screenshots if accurate.
For new features, show how the feature would be used.
-->
<!-- Paste example playbooks or commands between quotes below -->
~~~
Installed new system vm template
Stopped management server
Made the database backup
Fixed repository.
And updated cloudstack management package
The following error came.
~~~
<!-- You can also paste gist.github.com links for larger files -->
##### EXPECTED RESULTS
<!-- What did you expect to happen when running the steps above? -->
~~~
Cloudstack to start, but it didn;t
~~~
##### ACTUAL RESULTS
<!-- What actually happened? -->
<!-- Paste verbatim command output between quotes below -->
~~~
~~~
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr commented on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
AlexanderKgr commented on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1067170741
was trying to update my lab cloudstack instance and got another issue.
please @nvazquez i need your help.
I have never user cloudstack_usage package
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] nvazquez commented on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
nvazquez commented on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1064048600
Many thanks @AlexanderKgr - great it has worked!
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr edited a comment on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
AlexanderKgr edited a comment on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1062572157
error removing column.
reinstalling package didn't work.
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr commented on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
AlexanderKgr commented on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1062572157
error removing column.
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr closed issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
AlexanderKgr closed issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr commented on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
AlexanderKgr commented on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1062796522
> @AlexanderKgr Have you upgraded with the packages at "https://download.cloudstack.org/ubuntu/dists/bionic/4.16/pool/" ? The packages there are rebuild and uploaded again, can you check with latest packages.
i will check it again. thanks for the answer
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] nvazquez commented on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
nvazquez commented on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1067816337
Hi @AlexanderKgr sorry I have just read your comment. I can see the upgrade script for 4.16.0 to 4.16.1 alters that table, but it seems like you were not using the cloud_usage schema before? After creating the cloud_usage database, did you experience the same failure or succeeded? Good you have fixed, the cloud_usage database was needed in this case. Is it good if I close 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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] nvazquez commented on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
nvazquez commented on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1063245051
Yes @AlexanderKgr I have seen that - have also been investigating why your database contains that column if version 4.16.0 does not contain it and was introduced only on 4.16.1.
Found this PR which introduced the constraint that is blocking you from removing the column: https://github.com/apache/cloudstack/pull/5541/files#diff-c3fcc536a9c25282503a8d8f0c07b5320ab9c6ffea9e199bafdba6e306f0aa8bR796. But this PR was reverted(https://github.com/apache/cloudstack/pull/5665) and not included on 4.16.0. It seems like you were not using the 4.16.0 release packages but a development version. This is not included on 4.16.0:
````
ALTER TABLE cloud.vm_work_job ADD CONSTRAINT vm_work_job_step_and_objects UNIQUE KEY (step,vm_instance_id,secondary_object);
````
Anyways, to revert this constraint I would suggest the following SQL and then retry dropping the column:
````
ALTER TABLE cloud.vm_work_job DROP CONSTRAINT vm_work_job_step_and_objects;
````
Let us know if that fixes the problem, after dropping the column you should be able to upgrade
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] sureshanaparti commented on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
sureshanaparti commented on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1063824957
Hi @AlexanderKgr, I've checked the upgrade path, and as @nvazquez pointed the column `secondary_object` doesn't exists in 4.16.0
**DB before upgrade:**
```
[cloud]> desc vm_work_job;
+----------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+---------------------+------+-----+---------+-------+
| id | bigint(20) unsigned | NO | PRI | NULL | |
| step | char(32) | NO | MUL | NULL | |
| vm_type | char(32) | NO | MUL | NULL | |
| vm_instance_id | bigint(20) unsigned | NO | MUL | NULL | |
+----------------+---------------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
```
**Upgrade log =>**
_2022-03-10 08:51:25,906 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Schema upgrade from 4.16.0.0 to 4.16.1.0
2022-03-10 08:51:25,906 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --;
2022-03-10 08:51:25,907 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`vm_work_job` ADD COLUMN `secondary_object` char(100) COMMENT 'any additional item that must be checked during queueing' AFTER `vm_instance_id`
2022-03-10 08:51:25,930 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Stored procedures to handle cloud and cloud_schema changes
2022-03-10 08:51:25,931 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Idempotent ADD COLUMN_
**DB after upgrade:**
```
[cloud]> desc cloud.vm_work_job;
+------------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+---------------------+------+-----+---------+-------+
| id | bigint(20) unsigned | NO | PRI | NULL | |
| step | char(32) | NO | MUL | NULL | |
| vm_type | char(32) | NO | MUL | NULL | |
| vm_instance_id | bigint(20) unsigned | NO | MUL | NULL | |
| secondary_object | char(100) | YES | | NULL | |
+------------------+---------------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
```
Can you try with the steps @nvazquez suggested, and update us. Thanks.
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr edited a comment on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
AlexanderKgr edited a comment on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1062572157
error removing column.
reinstalling package didn't fix it
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr edited a comment on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
AlexanderKgr edited a comment on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1062796522
> @AlexanderKgr Have you upgraded with the packages at "https://download.cloudstack.org/ubuntu/dists/bionic/4.16/pool/" ? The packages there are rebuild and uploaded again, can you check with latest packages.
i will check it again. thanks for the answer
i have upgraded with this package
cloudstack-management_4.16.1.0~bionic_all.deb | 2022-03-08 15:55
and still facing the 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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] nvazquez commented on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
nvazquez commented on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1062241280
Hi @AlexanderKgr have you tried upgrading twice? Or testing a 4.16.1 RC version on this environment? It is failing due to duplicated columns from the schema file for the upgrade: https://github.com/apache/cloudstack/blob/4.16.1.0/engine%2Fschema%2Fsrc%2Fmain%2Fresources%2FMETA-INF%2Fdb%2Fschema-41600to41610.sql#L22
As a workaround you can consider removing the column `secondary_object` from the table `vm_work_job` and retry the upgrade. Please consider also taking a backup of the database prior to the column removal
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] nvazquez commented on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
nvazquez commented on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1063198973
Hi @AlexanderKgr it seems like the duplicate record did not allow the column removal, once you can remove it and remove the column please retry - otherwise it will complain since the column still exists
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr commented on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
AlexanderKgr commented on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1067183045
fixed but with strange way.
I reconfigured db and have restored only cloud db . Cloud_usage db was intact as it was created by script
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr commented on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
AlexanderKgr commented on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1062570609
> Hi @AlexanderKgr have you tried upgrading twice? Or testing a 4.16.1 RC version on this environment? It is failing due to duplicated columns from the schema file for the upgrade: https://github.com/apache/cloudstack/blob/4.16.1.0/engine%2Fschema%2Fsrc%2Fmain%2Fresources%2FMETA-INF%2Fdb%2Fschema-41600to41610.sql#L22
>
> As a workaround you can consider removing the column `secondary_object` from the table `vm_work_job` and retry the upgrade. Please consider also taking a backup of the database prior to the column removal
Hi @nvazquez . I haven't tried to upgrade twice, neither i have tried 4.16.1 RC because of lack of time. I have backed up everything and also it is a vm with snapshot.
I will try to remove the column.
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr commented on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
AlexanderKgr commented on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1068250554
i having issues with windows vms. don't boot at all. searching for it
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr closed issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
AlexanderKgr closed issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] sureshanaparti commented on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
sureshanaparti commented on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1062778460
@AlexanderKgr Have you upgraded with the packages at "https://download.cloudstack.org/ubuntu/dists/bionic/4.16/pool/" ? The packages there are rebuild and uploaded again, can you check with latest packages.
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr commented on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
AlexanderKgr commented on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1063223720
> Hi @AlexanderKgr it seems like the duplicate record did not allow the column removal, once you can remove it and remove the column please retry - otherwise it will complain since the column still exists
Look my comment above. It is not possible to remove the column
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] AlexanderKgr commented on issue #6074: Error Updating from 4.16.0.0 to 4.16.1.0
Posted by GitBox <gi...@apache.org>.
AlexanderKgr commented on issue #6074:
URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1064042542
@nvazquez you were right.
i was trying to update a snapshot version of 4.16.
Reverted all my lab to 4.15 and upgraded to 4.16.1 without any issue.
Thanks again for the help
--
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.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org