On Tue, Feb 21, 2017 at 11:47 AM, Fred Rolland <froll...@redhat.com> wrote:
> Add before the command (with your db password): PGPASSWORD=engine > > for example: > PGPASSWORD=engine /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -T > > PGPASSWORD=engine /usr/share/ovirt-engine/setup/dbutils/unlock_entity.sh > -t disk -u engine -q > > >From taskcleaner, if I use the "-T" option I get error [root@ovmgr1 ovirt-engine]# PGPASSWORD=my_pwd /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -d engine -u engine -T t ERROR: column "job_id" does not exist LINE 1: ...created_at,status,return_value,return_value_class,job_id,ste... ^ FATAL: Cannot execute sql command: --command=SELECT command_id,command_type,root_command_id,command_parameters,command_params_class,created_at,status,return_value,return_value_class,job_id,step_id,executed FROM GetAllCommandsWithRunningTasks(); I see the function GetAllCommandsWithRunningTasks as defined only in /usr/share/ovirt-engine/setup/dbutils/taskcleaner_sp_3_5.sql and it seems it makes query on commands_entities, but if I directly go inside db, the table doesn't contain indeed a job_id column.... I'm on 4.1 upgraded from 4.0.6 engine=# \d command_entities Table "public.command_entities" Column | Type | Modifiers -----------------------+--------------------------+--------------------------------- command_id | uuid | not null command_type | integer | not null root_command_id | uuid | command_parameters | text | command_params_class | character varying(256) | created_at | timestamp with time zone | status | character varying(20) | default NULL::character varying callback_enabled | boolean | default false callback_notified | boolean | default false return_value | text | return_value_class | character varying(256) | executed | boolean | default false user_id | uuid | parent_command_id | uuid | data | text | engine_session_seq_id | bigint | command_context | text | Indexes: "pk_command_entities" PRIMARY KEY, btree (command_id) "idx_root_command_id" btree (root_command_id) WHERE root_command_id IS NOT NULL Referenced by: TABLE "command_assoc_entities" CONSTRAINT "fk_coco_command_assoc_entity" FOREIGN KEY (command_id) REFERENCES comm and_entities(command_id) ON DELETE CASCADE engine=# Anyway after unlocking the disk and retrying the move, I get the same error while creating auto snapshot... the first problem on host (that is a different host from the chosen yesterday) seems MetaDataKeyNotFoundError: Meta Data key not found error: ("Missing metadata key: 'DOMAIN': found: {'NONE': 2017-02-21 11:38:58,985 INFO (jsonrpc/0) [dispatcher] Run and protect: createVolume(sdUUID=u'900b1853-e192-4661-a0f9-7c7c396f6f49', spUUID=u'588237b8-0031-02f6-035d-000000000136', imgUUID=u'f0b5a0e4-ee5d-44a7-ba07-08285791368a', size=u'461708984320', volFormat=4, preallocate=2, diskType=2, volUUID=u'c39c3d9f-dde8-45ab-b4a9-7c3b45c6391d', desc=u'', srcImgUUID=u'f0b5a0e4-ee5d-44a7-ba07-08285791368a', srcVolUUID=u'7ed43974-1039-4a68-a8b3-321e7594fe4c', initialSize=None) (logUtils:49) 2017-02-21 11:38:58,987 INFO (jsonrpc/0) [IOProcessClient] Starting client ioprocess-6269 (__init__:330) 2017-02-21 11:38:59,006 INFO (ioprocess/32170) [IOProcess] Starting ioprocess (__init__:452) 2017-02-21 11:38:59,040 INFO (jsonrpc/0) [dispatcher] Run and protect: createVolume, Return response: None (logUtils:52) 2017-02-21 11:38:59,053 INFO (jsonrpc/0) [jsonrpc.JsonRpcServer] RPC call Volume.create succeeded in 0.07 seconds (__init__:515) 2017-02-21 11:38:59,054 INFO (tasks/9) [storage.ThreadPool.WorkerThread] START task 08d7797a-af46-489f-ada0-c70bf4359366 (cmd=<bound method Task.commit of <storage.task.Task instance at 0x7f8eb84aacf8>>, args=None) (threadPool:208) 2017-02-21 11:38:59,150 WARN (tasks/9) [storage.ResourceManager] Resource factory failed to create resource '01_img_900b1853-e192-4661-a0f9-7c7c396f6f49.f0b5a0e4-ee5d-44a7-ba07-08285791368a'. Canceling request. (resourceManager:542) Traceback (most recent call last): File "/usr/share/vdsm/storage/resourceManager.py", line 538, in registerResource obj = namespaceObj.factory.createResource(name, lockType) File "/usr/share/vdsm/storage/resourceFactories.py", line 190, in createResource lockType) File "/usr/share/vdsm/storage/resourceFactories.py", line 119, in __getResourceCandidatesList imgUUID=resourceName) File "/usr/share/vdsm/storage/image.py", line 220, in getChain if srcVol.isLeaf(): File "/usr/share/vdsm/storage/volume.py", line 1261, in isLeaf return self._manifest.isLeaf() File "/usr/share/vdsm/storage/volume.py", line 133, in isLeaf return self.getVolType() == sc.type2name(sc.LEAF_VOL) File "/usr/share/vdsm/storage/volume.py", line 129, in getVolType self.voltype = self.getMetaParam(sc.VOLTYPE) File "/usr/share/vdsm/storage/volume.py", line 113, in getMetaParam meta = self.getMetadata() File "/usr/share/vdsm/storage/blockVolume.py", line 115, in getMetadata md = VolumeMetadata.from_lines(lines) File "/usr/lib/python2.7/site-packages/vdsm/storage/volumemetadata.py", line 103, in from_lines "Missing metadata key: %s: found: %s" % (e, md)) MetaDataKeyNotFoundError: Meta Data key not found error: ("Missing metadata key: 'DOMAIN': found: {'NONE': '######################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################'}",) 2017-02-21 11:38:59,183 WARN (tasks/9) [storage.ResourceManager.Request] (ResName='01_img_900b1853-e192-4661-a0f9-7c7c396f6f49.f0b5a0e4-ee5d-44a7-ba07-08285791368a', ReqID='571de7e4-6da2-4d40-911e-defb0eb735d8') Tried to cancel a processed request (resourceManager:183) 2017-02-21 11:38:59,184 ERROR (tasks/9) [storage.TaskManager.Task] (Task='08d7797a-af46-489f-ada0-c70bf4359366') Unexpected error (task:870) Traceback (most recent call last): File "/usr/share/vdsm/storage/task.py", line 877, in _run return fn(*args, **kargs) File "/usr/share/vdsm/storage/task.py", line 333, in run return self.cmd(*self.argslist, **self.argsdict) File "/usr/lib/python2.7/site-packages/vdsm/storage/securable.py", line 79, in wrapper return method(self, *args, **kwargs) File "/usr/share/vdsm/storage/sp.py", line 1924, in createVolume with rm.acquireResource(img_ns, imgUUID, rm.EXCLUSIVE): File "/usr/share/vdsm/storage/resourceManager.py", line 1025, in acquireResource return _manager.acquireResource(namespace, name, lockType, timeout=timeout) File "/usr/share/vdsm/storage/resourceManager.py", line 473, in acquireResource raise se.ResourceAcqusitionFailed() ResourceAcqusitionFailed: Could not acquire resource. Probably resource factory threw an exception.: ()
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users