Created attachment 634986 [details] ## Logs vdsm Description of problem: Insufficient error message, during creation Live-Snapshot with max chars length Version-Release number of selected component (if applicable): RHEVM 3.1 - SI22 RHEVM: rhevm-3.1.0-22.el6ev.noarch VDSM: vdsm-4.9.6-39.0.el6_3.x86_64 LIBVIRT: libvirt-0.9.10-21.el6_3.5.x86_64 QEMU & KVM: qemu-kvm-rhev-0.12.1.2-2.295.el6_3.2.x86_64 SANLOCK: sanlock-2.3-4.el6_3.x86_64 How reproducible: 100% Steps to Reproduce: 1. Create Live-Snapshot with max chars length Actual results: Get an error: Failed to create Snapshot qwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnmqwertyuiopasdfghjkzxcvbnm for VM vm-Win7 (User: admin@internal). Expected results: - Write more relevant description: Failed Create a Snapshot, as you reached max characters length (Max = xxxx) - Give only Warning message to user, and give a possibility fix description name. Not failed a operation. (UI validation for max characters length) Additional info: /var/log/ovirt-engine/engine.log 2012-10-29 10:32:44,855 INFO [org.ovirt.engine.core.bll.CreateAllSnapshotsFromVmCommand] (pool-4-thread-42) [783ae7f6] Running command: CreateAllSnapshotsFromVmCommand internal : false. Entities affected : ID: 67ca9c19-fd90-4b2f-8389-f1f86e969c98 Type: VM 2012-10-29 10:32:44,896 ERROR [org.ovirt.engine.core.bll.CreateAllSnapshotsFromVmCommand] (pool-4-thread-42) [783ae7f6] Command org.ovirt.engine.core.bll.CreateAllSnapshotsFromV mCommand throw exception: org.springframework.dao.DataIntegrityViolationException: CallableStatementCallback; SQL [{call insertsnapshot(?, ?, ?, ?, ?, ?, ?, ?)}]; ERROR: value t oo long for type character varying(4000) Where: SQL statement "INSERT INTO snapshots( snapshot_id, status, vm_id, snapshot_type, description, creation_date, app_list, vm_configuration) VALUES( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 )" PL/pgSQL function "insertsnapshot" line 2 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: value too long for type character varying(4000) Where: SQL statement "INSERT INTO snapshots( snapshot_id, status, vm_id, snapshot_type, description, creation_date, app_list, vm_configuration) VALUES( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 )" PL/pgSQL function "insertsnapshot" line 2 at SQL statement at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1 .RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1 .RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1 .RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1030) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1064) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:388) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:351) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:181) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:124) [engine-dal.jar:] at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeModification(SimpleJdbcCallsHandler.java:37) [engine-dal.jar:] at org.ovirt.engine.core.dao.DefaultGenericDaoDbFacade.save(DefaultGenericDaoDbFacade.java:93) [engine-dal.jar:] at org.ovirt.engine.core.bll.snapshots.SnapshotsManager.addSnapshot(SnapshotsManager.java:133) [engine-bll.jar:] at org.ovirt.engine.core.bll.snapshots.SnapshotsManager.addSnapshot(SnapshotsManager.java:96) [engine-bll.jar:] at org.ovirt.engine.core.bll.CreateAllSnapshotsFromVmCommand.ExecuteVmCommand(CreateAllSnapshotsFromVmCommand.java:92) [engine-bll.jar:] at org.ovirt.engine.core.bll.VmCommand.executeCommand(VmCommand.java:78) [engine-bll.jar:] at org.ovirt.engine.core.bll.CommandBase.executeWithoutTransaction(CommandBase.java:825) [engine-bll.jar:] at org.ovirt.engine.core.bll.CommandBase.executeActionInTransactionScope(CommandBase.java:916) [engine-bll.jar:] at org.ovirt.engine.core.bll.CommandBase.runInTransaction(CommandBase.java:1300) [engine-bll.jar:] at org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInNewTransaction(TransactionSupport.java:204) [engine-utils.jar:] at org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInRequired(TransactionSupport.java:142) [engine-utils.jar:] at org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInScope(TransactionSupport.java:109) [engine-utils.jar:] at org.ovirt.engine.core.bll.CommandBase.execute(CommandBase.java:931) [engine-bll.jar:] at org.ovirt.engine.core.bll.CommandBase.executeAction(CommandBase.java:285) [engine-bll.jar:] at org.ovirt.engine.core.bll.MultipleActionsRunner.executeValidatedCommands(MultipleActionsRunner.java:182) [engine-bll.jar:] at org.ovirt.engine.core.bll.MultipleActionsRunner.RunCommands(MultipleActionsRunner.java:162) [engine-bll.jar:] at org.ovirt.engine.core.bll.MultipleActionsRunner$1.run(MultipleActionsRunner.java:84) [engine-bll.jar:] at org.ovirt.engine.core.utils.threadpool.ThreadPoolUtil$InternalWrapperRunnable.run(ThreadPoolUtil.java:64) [engine-utils.jar:] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.7.0_09-icedtea] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_09-icedtea] at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_09-icedtea] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_09-icedtea] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_09-icedtea] at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_09-icedtea] Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(4000) Where: SQL statement "INSERT INTO snapshots( snapshot_id, status, vm_id, snapshot_type, description, creation_date, app_list, vm_configuration) VALUES( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 )" PL/pgSQL function "insertsnapshot" line 2 at SQL statement at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:360) at org.jboss.jca.adapters.jdbc.CachedPreparedStatement.execute(CachedPreparedStatement.java:297) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404) at org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1066) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1014) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE] ... 29 more 2012-10-29 10:32:44,917 ERROR [org.ovirt.engine.core.bll.CreateAllSnapshotsFromVmCommand] (pool-4-thread-42) [783ae7f6] Transaction rolled-back for command: org.ovirt.engine.core.bll.CreateAllSnapshotsFromVmCommand. 2012-10-29 10:32:44,919 INFO [org.ovirt.engine.core.bll.CreateAllSnapshotsFromVmCommand] (pool-4-thread-42) [783ae7f6] Lock freed to object EngineLock [exclusiveLocks= key: 67ca9c19-fd90-4b2f-8389-f1f86e969c98 value: VM , sharedLocks= ] 2012-10-29 10:34:35,193 INFO [org.ovirt.engine.core.bll.DbUserCacheManager] (QuartzScheduler_Worker-95) DbUserCacheManager::refreshAllUserData() - entered 2012-10-29 10:35:00,000 INFO [org.ovirt.engine.core.bll.AutoRecoveryManager] (QuartzScheduler_Worker-11) Autorecovering hosts is disabled, skipping
This is the same bug as 871029. Closing this one as duplicate, as 871029 has a bit more info in the comments. *** This bug has been marked as a duplicate of bug 871029 ***