reformatting cause the command I gave you is missing quotes
```bash
su - postgres
psql engine -c "update vm_static set cluster_id = (select cluster_id from
cluster where name = 'NEWCLUSTERNAME') where vm_name = 'HostedEngine';
"
```
On Mon, Jul 4, 2016 at 12:02 PM, Roy Golan <rgolan(a)redhat.com> wrote:
On Thu, Jun 30, 2016 at 12:33 PM, Roy Golan <rgolan(a)redhat.com> wrote:
>
>
> On Wed, Jun 29, 2016 at 10:25 AM, <mike.lupe(a)gmx.ch> wrote:
>
>> Hello all,
>>
>> yesterday I upgraded my 3.6.x to 4.0 and got stuck with obviously not
>> being able to shutdown HE VM itself ("shutdown all VMs" required for
>> increasing the compatibility level to 4.0). As I luckily already had a 4th
>> pure computing node, rgolan friendly walked me through the process of
>> creating a new V4 cluster and moving that 4th node to it. The purpose was
>> to free up the default cluster, to be prepared to increase to V4.
>>
>> The next step was to migrate the HE VM to the new cluster
>> ("automatically chose host", as there is only one host for that new
>> cluster). Everything went well, but (as rgolan asked to check) the cluster
>> assignment for the HE VM in the edit VM dialogue still shows "Default"
and
>> an attempt to increase the compatibility of "Default" cluster of
course
>> didn't work ("first shut down all VMs!"). The migration of another
VM to
>> that new cluster on the other hand worked without a glitch.
>>
>> Attached is the engine.log. Relevant entries should start at around "
>> 2016-06-29 00:53:20 ", it should be the time I created the new cluster and
>> moved pure computing node " slp-ovirtnode-04 " to it. Please ignore
the
>> glusterfs brick entries, I have additional disks ready to be added, but
>> this is another story ;)
>>
>> Hopefully there is a way to entirely move the HE VM to the new cluster.
>>
>> Thanks and regards
>> mikelupe
>> _______________________________________________
>> Users mailing list
>> Users(a)ovirt.org
>>
http://lists.ovirt.org/mailman/listinfo/users
>>
>>
> At the end of the migration we prevent that action on the hosted engine
> vm specifically
>
> 2016-06-28 21:55:20,734 WARN
> [org.ovirt.engine.core.bll.ChangeVMClusterCommand]
> (ForkJoinPool-1-worker-0) [3ce2a3ad] Validation of action 'ChangeVMCluster'
> failed for user SYSTEM. Reasons:
>
VAR__ACTION__UPDATE,VAR__TYPE__VM__CLUSTER,ACTION_TYPE_FAILED_CANNOT_RUN_ACTION_ON_NON_MANAGED_VM
>
> I opened
https://bugzilla.redhat.com/show_bug.cgi?id=1351533
>
> Mike if you want meanwhile I can supply a script to help you with that.
>
>
>
```bash
su - postgres
psql engine -c "update vm_static set cluster_id = (select cluster_id from
cluster where name = 'NEWCLUSTERNAME') where vm_name = 'HostedEngine';