Hi, yes, destroy is also not working and throwing SQL exception
detailed logs from engine by doing destroy in attachment
thank you in advance
ladislav
On 21.02.2018 15:01, Eyal Shenitzky wrote:
Note that destroy and remove are two different operations.
Did you try both?
On Wed, Feb 21, 2018 at 3:17 PM, Ladislav Humenik
<ladislav.hume...@1und1.de <mailto:ladislav.hume...@1und1.de>> wrote:
Hi, of course i did. I put these domain's first in to maintenance,
then Detached it from the datacenter.
The last step is destroy or remove "just name it" and this last
step is mysteriously not working.
and throwing sql exception which I attached before.
Thank you in advance
ladislav
On 21.02.2018 14:03, Eyal Shenitzky wrote:
Did you manage to set the domain to maintenance?
If so you can try to 'Destroy' the domain.
On Wed, Feb 21, 2018 at 2:57 PM, Ladislav Humenik
<ladislav.hume...@1und1.de <mailto:ladislav.hume...@1und1.de>> wrote:
Hi, no
this table "STORAGE_DOMAIN_MAP_TABLE" is not present at any
of our ovirt's and
based on link
<http://?ui=2&ik=0712e9a1b3&view=fimg&th=161b8714ec199ae3&attid=0.1.1&disp=emb&attbid=ANGjdJ9PPOWU6bxvze9lPAM_2gBE-uu8fFppbzl2kuXMhSwyKx4QWo0sFYbLjNBgMhB0RdoOM_e16gleR75ZmUYnx3ndhB0CgYgXtvtBs7wNxOYf-o9rWv42duaUwsw&sz=s0-l75-ft&ats=1519218030205&rm=161b8714ec199ae3&zw&atsh=0>
this is just a temporary table. Can you point me to what
query should I test?
thank you in advance
Ladislav
On 21.02.2018 12:50, Eyal Shenitzky wrote:
According to the logs, it seems like you somehow missing a
table in the DB -
STORAGE_DOMAIN_MAP_TABLE.
4211-b98f-a37604642251] Command
'org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand'
failed: CallableStatementCallback; bad SQL grammar [{call
force_delete_storage_domain(?)}]; nested exception is
org.postgresql.util.PSQLException: ERROR: relation
"storage_domain_map_table" does not exist
Did you tryied to run some SQL query which cause that issue?
On Wed, Feb 21, 2018 at 11:48 AM, Ladislav Humenik
<ladislav.hume...@1und1.de
<mailto:ladislav.hume...@1und1.de>> wrote:
Hello,
we can not remove old NFS-data storage domains, this 4
are already deactivated and unattached:
engine=> select id,storage_name from storage_domains
where storage_name like 'bs09%';
id | storage_name
--------------------------------------+---------------
819b419e-638b-43c7-9189-b93c0314d38a | bs09aF2C10kvm
9a403356-f58a-4e80-9435-026e6f853a9b | bs09bF2C10kvm
f5efd264-045b-48d5-b35c-661a30461de5 | bs09aF2C9kvm
a0989c64-fc41-4a8b-8544-914137d7eae8 | bs09bF2C9kvm
(4 rows)
The only images which still resides in DB are OVF_STORE
templates:
engine=> select image_guid,storage_name,disk_description
from images_storage_domain_view where storage_name like
'bs09%';
image_guid | storage_name | disk_description
--------------------------------------+---------------+------------------
6b72139d-a4b3-4e22-98e2-e8b1d64e8e50 | bs09bF2C9kvm |
OVF_STORE
997fe5a6-9647-4d42-b074-27767984b7d2 | bs09bF2C9kvm |
OVF_STORE
2b1884cb-eb37-475f-9c24-9638400f15af | bs09aF2C10kvm |
OVF_STORE
85383ffe-68ba-4a82-a692-d93e38bf7f4c | bs09aF2C9kvm |
OVF_STORE
bca14796-aed1-4747-87c9-1b25861fad86 | bs09aF2C9kvm |
OVF_STORE
797c27bf-7c2d-4363-96f9-565fa58d0a5e | bs09bF2C10kvm |
OVF_STORE
5d092a1b-597c-48a3-8058-cbe40d39c2c9 | bs09bF2C10kvm |
OVF_STORE
dc61f42f-1330-4bfb-986a-d868c736da59 | bs09aF2C10kvm |
OVF_STORE
(8 rows)
Current oVirt Engine version: 4.1.8.2-1.el7.centos
Exception logs from engine are in attachment
Do you have any magic sql statement to figure out what
is causing this exception and how we can remove those
storage domains without disruption ?
Thank you in advance
--
Ladislav Humenik
_______________________________________________
Users mailing list
Users@ovirt.org <mailto:Users@ovirt.org>
http://lists.ovirt.org/mailman/listinfo/users
<http://lists.ovirt.org/mailman/listinfo/users>
--
Regards,
Eyal Shenitzky
--
Ladislav Humenik
System administrator / VI
IT Operations Hosting Infrastructure
1&1 Internet SE |Ernst-Frey-Str. 5 | 76135 Karlsruhe | Germany
<https://maps.google.com/?q=Ernst-Frey-Str.+5+%7C+76135+Karlsruhe+%7C+Germany&entry=gmail&source=g>
Phone:+49 721 91374-8361 <tel:+49%20721%20913748361>
E-Mail:ladislav.hume...@1und1.de <mailto:ladislav.hume...@1und1.de> |
Web:www.1und1.de <http://www.1und1.de>
Hauptsitz Montabaur, Amtsgericht Montabaur, HRB 24498
Vorstand: Robert Hoffmann, Hans-Henning Kettler, Uwe Lamnek, Matthias
Steinberg
Aufsichtsratsvorsitzender: René Obermann
Member of United Internet
Diese E-Mail kann vertrauliche und/oder gesetzlich geschützte
Informationen enthalten. Wenn Sie nicht der bestimmungsgemäße Adressat sind
oder diese E-Mail irrtümlich erhalten haben, unterrichten Sie bitte den
Absender und vernichten Sie diese E-Mail. Anderen als dem bestimmungsgemäßen
Adressaten ist untersagt, diese E-Mail zu speichern, weiterzuleiten oder ihren
Inhalt auf welche Weise auch immer zu verwenden.
This e-mail may contain confidential and/or privileged information. If
you are not the intended recipient of this e-mail, you are hereby notified that
saving, distribution or use of the content of this e-mail in any way is
prohibited. If you have received this e-mail in error, please notify the sender
and delete the e-mail.
--
Regards,
Eyal Shenitzky
--
Ladislav Humenik
System administrator / VI
IT Operations Hosting Infrastructure
1&1 Internet SE |Ernst-Frey-Str. 5 | 76135 Karlsruhe | Germany
<https://maps.google.com/?q=Ernst-Frey-Str.+5+%7C+76135+Karlsruhe+%7C+Germany&entry=gmail&source=g>
Phone:+49 721 91374-8361 <tel:+49%20721%20913748361>
E-Mail:ladislav.hume...@1und1.de <mailto:ladislav.hume...@1und1.de> |
Web:www.1und1.de <http://www.1und1.de>
Hauptsitz Montabaur, Amtsgericht Montabaur, HRB 24498
Vorstand: Robert Hoffmann, Hans-Henning Kettler, Uwe Lamnek, Matthias
Steinberg
Aufsichtsratsvorsitzender: René Obermann
Member of United Internet
Diese E-Mail kann vertrauliche und/oder gesetzlich geschützte Informationen
enthalten. Wenn Sie nicht der bestimmungsgemäße Adressat sind oder diese E-Mail
irrtümlich erhalten haben, unterrichten Sie bitte den Absender und vernichten
Sie diese E-Mail. Anderen als dem bestimmungsgemäßen Adressaten ist untersagt,
diese E-Mail zu speichern, weiterzuleiten oder ihren Inhalt auf welche Weise
auch immer zu verwenden.
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient of this e-mail, you are hereby notified that
saving, distribution or use of the content of this e-mail in any way is
prohibited. If you have received this e-mail in error, please notify the sender
and delete the e-mail.
--
Regards,
Eyal Shenitzky
--
Ladislav Humenik
System administrator / VI
IT Operations Hosting Infrastructure
1&1 Internet SE | Ernst-Frey-Str. 5 | 76135 Karlsruhe | Germany
Phone: +49 721 91374-8361
E-Mail: ladislav.hume...@1und1.de | Web: www.1und1.de
Hauptsitz Montabaur, Amtsgericht Montabaur, HRB 24498
Vorstand: Robert Hoffmann, Hans-Henning Kettler, Uwe Lamnek, Matthias Steinberg
Aufsichtsratsvorsitzender: René Obermann
Member of United Internet
Diese E-Mail kann vertrauliche und/oder gesetzlich geschützte Informationen
enthalten. Wenn Sie nicht der bestimmungsgemäße Adressat sind oder diese E-Mail
irrtümlich erhalten haben, unterrichten Sie bitte den Absender und vernichten
Sie diese E-Mail. Anderen als dem bestimmungsgemäßen Adressaten ist untersagt,
diese E-Mail zu speichern, weiterzuleiten oder ihren Inhalt auf welche Weise
auch immer zu verwenden.
This e-mail may contain confidential and/or privileged information. If you are
not the intended recipient of this e-mail, you are hereby notified that saving,
distribution or use of the content of this e-mail in any way is prohibited. If
you have received this e-mail in error, please notify the sender and delete the
e-mail.
2018-02-21 15:03:23,259+01 INFO [org.ovirt.engine.core.bll.storage.domain.ForceRemoveStorageDomainCommand] (default task-46) [201c8b91-22aa-46ad-be85-5146188bbbd8] Lock Acquired to object 'EngineLock:{ex
clusiveLocks='[f5efd264-045b-48d5-b35c-661a30461de5=STORAGE]', sharedLocks=''}'
2018-02-21 15:03:23,292+01 INFO [org.ovirt.engine.core.bll.storage.domain.ForceRemoveStorageDomainCommand] (org.ovirt.thread.pool-6-thread-28) [201c8b91-22aa-46ad-be85-5146188bbbd8] Running command: Forc
eRemoveStorageDomainCommand internal: false. Entities affected : ID: f5efd264-045b-48d5-b35c-661a30461de5 Type: StorageAction group DELETE_STORAGE_DOMAIN with role type ADMIN
2018-02-21 15:03:23,299+01 ERROR [org.ovirt.engine.core.bll.storage.domain.ForceRemoveStorageDomainCommand] (org.ovirt.thread.pool-6-thread-28) [201c8b91-22aa-46ad-be85-5146188bbbd8] Command 'org.ovirt.en
gine.core.bll.storage.domain.ForceRemoveStorageDomainCommand' failed: CallableStatementCallback; bad SQL grammar [{call force_delete_storage_domain(?)}]; nested exception is org.postgresql.util.PSQLExcept
ion: ERROR: relation "storage_domain_map_table" does not exist
Where: SQL statement "TRUNCATE TABLE STORAGE_DOMAIN_MAP_TABLE"
PL/pgSQL function remove_entities_from_storage_domain(uuid) line 21 at SQL statement
SQL statement "SELECT Remove_Entities_From_storage_domain(v_storage_domain_id)"
PL/pgSQL function force_delete_storage_domain(uuid) line 3 at PERFORM
2018-02-21 15:03:23,299+01 ERROR [org.ovirt.engine.core.bll.storage.domain.ForceRemoveStorageDomainCommand] (org.ovirt.thread.pool-6-thread-28) [201c8b91-22aa-46ad-be85-5146188bbbd8] Exception: org.spring
framework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call force_delete_storage_domain(?)}]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "storage_d
omain_map_table" does not exist
Where: SQL statement "TRUNCATE TABLE STORAGE_DOMAIN_MAP_TABLE"
PL/pgSQL function remove_entities_from_storage_domain(uuid) line 21 at SQL statement
SQL statement "SELECT Remove_Entities_From_storage_domain(v_storage_domain_id)"
PL/pgSQL function force_delete_storage_domain(uuid) line 3 at PERFORM
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) [spring-jdbc.jar:4.2.4.RELEASE]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) [spring-jdbc.jar:4.2.4.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1094) [spring-jdbc.jar:4.2.4.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1130) [spring-jdbc.jar:4.2.4.RELEASE]
at org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:405) [spring-jdbc.jar:4.2.4.RELEASE]
at org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:365) [spring-jdbc.jar:4.2.4.RELEASE]
at org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:198) [spring-jdbc.jar:4.2.4.RELEASE]
at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:135) [dal.jar:]
at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:130) [dal.jar:]
at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeModification(SimpleJdbcCallsHandler.java:76) [dal.jar:]
at org.ovirt.engine.core.dao.StorageDomainDaoImpl.remove(StorageDomainDaoImpl.java:132) [dal.jar:]
at org.ovirt.engine.core.bll.storage.domain.ForceRemoveStorageDomainCommand.executeCommand(ForceRemoveStorageDomainCommand.java:68) [bll.jar:]
at org.ovirt.engine.core.bll.CommandBase.executeWithoutTransaction(CommandBase.java:1251) [bll.jar:]
at org.ovirt.engine.core.bll.CommandBase.executeActionInTransactionScope(CommandBase.java:1391) [bll.jar:]
at org.ovirt.engine.core.bll.CommandBase.runInTransaction(CommandBase.java:2055) [bll.jar:]
at org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInNewTransaction(TransactionSupport.java:202) [utils.jar:]
at org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInRequired(TransactionSupport.java:137) [utils.jar:]
at org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInScope(TransactionSupport.java:105) [utils.jar:]
at org.ovirt.engine.core.bll.CommandBase.execute(CommandBase.java:1451) [bll.jar:]
at org.ovirt.engine.core.bll.CommandBase.executeAction(CommandBase.java:397) [bll.jar:]
at org.ovirt.engine.core.bll.PrevalidatingMultipleActionsRunner.executeValidatedCommand(PrevalidatingMultipleActionsRunner.java:204) [bll.jar:]
at org.ovirt.engine.core.bll.PrevalidatingMultipleActionsRunner.runCommands(PrevalidatingMultipleActionsRunner.java:176) [bll.jar:]
at org.ovirt.engine.core.bll.PrevalidatingMultipleActionsRunner.lambda$invokeCommands$3(PrevalidatingMultipleActionsRunner.java:182) [bll.jar:]
at org.ovirt.engine.core.utils.threadpool.ThreadPoolUtil$InternalWrapperRunnable.run(ThreadPoolUtil.java:84) [utils.jar:]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [rt.jar:1.8.0_161]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_161]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_161]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_161]
at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_161]
Caused by: org.postgresql.util.PSQLException: ERROR: relation "storage_domain_map_table" does not exist
Where: SQL statement "TRUNCATE TABLE STORAGE_DOMAIN_MAP_TABLE"
PL/pgSQL function remove_entities_from_storage_domain(uuid) line 21 at SQL statement
SQL statement "SELECT Remove_Entities_From_storage_domain(v_storage_domain_id)"
PL/pgSQL function force_delete_storage_domain(uuid) line 3 at PERFORM
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:410)
at org.jboss.jca.adapters.jdbc.CachedPreparedStatement.execute(CachedPreparedStatement.java:303)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:442)
at org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1133) [spring-jdbc.jar:4.2.4.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1130) [spring-jdbc.jar:4.2.4.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1078) [spring-jdbc.jar:4.2.4.RELEASE]
... 26 more
2018-02-21 15:03:23,303+01 ERROR [org.ovirt.engine.core.bll.storage.domain.ForceRemoveStorageDomainCommand] (org.ovirt.thread.pool-6-thread-28) [201c8b91-22aa-46ad-be85-5146188bbbd8] Transaction rolled-back for command 'org.ovirt.engine.core.bll.storage.domain.ForceRemoveStorageDomainCommand'.
2018-02-21 15:03:23,307+01 ERROR [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector] (org.ovirt.thread.pool-6-thread-28) [201c8b91-22aa-46ad-be85-5146188bbbd8] EVENT_ID: USER_FORCE_REMOVE_STORAGE_DOMAIN_FAILED(982), Correlation ID: 201c8b91-22aa-46ad-be85-5146188bbbd8, Job ID: 3e4061bb-1ee0-40e5-98f5-272c4859f79a, Call Stack: null, Custom ID: null, Custom Event ID: -1, Message: Failed to forcibly remove Storage Domain bs09aF2C9kvm. (User: #####)
2018-02-21 15:03:23,310+01 INFO [org.ovirt.engine.core.bll.storage.domain.ForceRemoveStorageDomainCommand] (org.ovirt.thread.pool-6-thread-28) [201c8b91-22aa-46ad-be85-5146188bbbd8] Lock freed to object 'EngineLock:{exclusiveLocks='[f5efd264-045b-48d5-b35c-661a30461de5=STORAGE]', sharedLocks=''}'
_______________________________________________
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users