Creation of an instance fails on V.8.0.4 fails

[rajesh_p_e]

I’m trying to create a simple instance (Ubuntu) on my AWS cloud. However, it’s failing with the following error:

2025-03-26_16:27:22.68555 ''[2025-03-26 16:27:56,692] [RxCachedThreadScheduler-6] INFO  c.m.InstanceService - validating instance: ee0cac45-05b6-4cbd-a6ce-ba4fd3839fba
2025-03-26_16:27:56.69258 ''[2025-03-26 16:27:56,801] [RxCachedThreadScheduler-6] INFO  c.m.InstanceService - updating validation results: true
2025-03-26_16:27:56.80211 ''[2025-03-26 16:27:56,803] [RxCachedThreadScheduler-6] INFO  c.m.InstanceService - marking exection request complete: ee0cac45-05b6-4cbd-a6ce-ba4fd3839fba
2025-03-26_16:27:56.80314 ''[2025-03-26 16:28:06,697] [http-nio-127.0.0.1-8080-exec-1] INFO  c.m.AuditLogService - CEF:0|MorpheusData|Morpheus|8.0.4|infrastructure:storageVolumes#display|storageVolume Created|src=10.7.25.218 suid=10 suser=rajesh request=http://10.6.83.219/infrastructure/storage/volumes/display requestMethod=POST cn2=1 cn2Label=Account ID
2025-03-26_16:28:06.69806 ''[2025-03-26 16:28:06,748] [http-nio-127.0.0.1-8080-exec-17] INFO  c.m.AuditLogService - CEF:0|MorpheusData|Morpheus|8.0.4|instances#computedHostnameName|instance Created|src=10.7.25.218 suid=10 suser=rajesh request=http://10.6.83.219/provisioning/instances/computeHostname requestMethod=POST cn2=1 cn2Label=Account ID
2025-03-26_16:28:06.74847 ''[2025-03-26 16:28:10,196] [http-nio-127.0.0.1-8080-exec-7] ERROR o.h.e.j.s.SqlExceptionHelper - Field 'used_gpus' doesn't have a default value
2025-03-26_16:28:10.19675 ''[2025-03-26 16:28:10,197] [http-nio-127.0.0.1-8080-exec-7] ERROR c.m.InstanceService - createInstanceContainers error: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not execute statement; SQL [n/a]; Field 'used_gpus' doesn't have a default value; nested exception is java.sql.SQLException: Field 'used_gpus' doesn't have a default value
2025-03-26_16:28:10.19863 'org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not execute statement; SQL [n/a]; Field 'used_gpus' doesn't have a default value; nested exception is java.sql.SQLException: Field 'used_gpus' doesn't have a default value
2025-03-26_16:28:10.19864  at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:248)
2025-03-26_16:28:10.19865  at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
2025-03-26_16:28:10.19882  at org.grails.orm.hibernate.GrailsHibernateTemplate.convertJdbcAccessException(GrailsHibernateTemplate.java:725)
2025-03-26_16:28:10.19886  at org.grails.orm.hibernate.GrailsHibernateTemplate.convertHibernateAccessException(GrailsHibernateTemplate.java:712)
2025-03-26_16:28:10.19886  at org.grails.orm.hibernate.GrailsHibernateTemplate.doExecute(GrailsHibernateTemplate.java:301)
2025-03-26_16:28:10.19887  at org.grails.orm.hibernate.GrailsHibernateTemplate.execute(GrailsHibernateTemplate.java:241)
2025-03-26_16:28:10.19887  at org.grails.orm.hibernate.GrailsHibernateTemplate.execute(GrailsHibernateTemplate.java:120)

[Ollie-Phillips]

What OS are you using, and specifically which package did you install. Can you link the name. The error is self explanatory, but that field does not exist in my Morpheus 8.0.4, though I have similar for storage, memory and cpu.

Can you run this SQL against your database:

SELECT column_name, table_schema, table_name from information_schema.columns where column_name like 'used_%';

[rajesh_p_e]

OS: Ubuntu 24.04.2 LTS
Morpheus: 8.0.4 (debian)
How do I connect to the mysql instance of Morpheus? What are the credentials?

[Ollie-Phillips]

Hi, this is probably best handled via our support team. Please can you open a Morpheus support case.