Fails to create a pool, has weird sqlite3.OperationalError

[dasunusername]

Hello
I am new to NASes and Truenas i am running TrueNAS-12.0-U8 and am trying to add 2 new (and formatted) WD reds that i am going to mirror but when i use the GUI to create it i get this error

---

Code:

(sqlite3.OperationalError) no such column: system_advanced.adv_syslog_tls_certificate_authority_id [SQL: SELECT system_advanced.id, system_advanced.adv_consolemenu, system_advanced.adv_serialconsole, system_advanced.adv_serialport, system_advanced.adv_serialspeed, system_advanced.adv_powerdaemon, system_advanced.adv_swapondrive, system_advanced.adv_overprovision, system_advanced.adv_consolemsg, system_advanced.adv_traceback, system_advanced.adv_advancedmode, system_advanced.adv_autotune, system_advanced.adv_debugkernel, system_advanced.adv_uploadcrash, system_advanced.adv_anonstats, system_advanced.adv_anonstats_token, system_advanced.adv_motd, system_advanced.adv_boot_scrub, system_advanced.adv_fqdn_syslog, system_advanced.adv_sed_user, system_advanced.adv_sed_passwd, system_advanced.adv_sysloglevel, system_advanced.adv_syslogserver, system_advanced.adv_syslog_transport, system_advanced.adv_syslog_tls_certificate_id, system_advanced.adv_syslog_tls_certificate_authority_id, system_advanced.adv_kmip_uid, system_certificate_1.id, system_certificate_1.cert_type, system_certificate_1.cert_name, system_certificate_1.cert_certificate, system_certificate_1.cert_privatekey, system_certificate_1."cert_CSR", system_certificate_1.cert_signedby_id, system_certificate_1.cert_acme_uri, system_certificate_1.cert_domains_authenticators, system_certificate_1.cert_renew_days, system_certificate_1.cert_acme_id, system_certificate_1.cert_revoked_date, system_certificateauthority_1.id, system_certificateauthority_1.cert_type, system_certificateauthority_1.cert_name, system_certificateauthority_1.cert_certificate, system_certificateauthority_1.cert_privatekey, system_certificateauthority_1."cert_CSR", system_certificateauthority_1.cert_revoked_date, system_certificateauthority_1.cert_signedby_id, system_certificateauthority_2.id, system_certificateauthority_2.cert_type, system_certificateauthority_2.cert_name, system_certificateauthority_2.cert_certificate, system_certificateauthority_2.cert_privatekey, system_certificateauthority_2."cert_CSR", system_certificateauthority_2.cert_revoked_date, system_certificateauthority_2.cert_signedby_id, system_acmeregistration_1.id, system_acmeregistration_1.uri, system_acmeregistration_1.directory, system_acmeregistration_1.tos, system_acmeregistration_1.new_account_uri, system_acmeregistration_1.new_nonce_uri, system_acmeregistration_1.new_order_uri, system_acmeregistration_1.revoke_cert_uri, system_certificateauthority_3.id, system_certificateauthority_3.cert_type, system_certificateauthority_3.cert_name, system_certificateauthority_3.cert_certificate, system_certificateauthority_3.cert_privatekey, system_certificateauthority_3."cert_CSR", system_certificateauthority_3.cert_revoked_date, system_certificateauthority_3.cert_signedby_id, system_certificateauthority_4.id, system_certificateauthority_4.cert_type, system_certificateauthority_4.cert_name, system_certificateauthority_4.cert_certificate, system_certificateauthority_4.cert_privatekey, system_certificateauthority_4."cert_CSR", system_certificateauthority_4.cert_revoked_date, system_certificateauthority_4.cert_signedby_id FROM system_advanced LEFT OUTER JOIN system_certificate AS system_certificate_1 ON system_certificate_1.id = system_advanced.adv_syslog_tls_certificate_id LEFT OUTER JOIN system_certificateauthority AS system_certificateauthority_1 ON system_certificateauthority_1.id = system_certificate_1.cert_signedby_id LEFT OUTER JOIN system_certificateauthority AS system_certificateauthority_2 ON system_certificateauthority_2.id = system_certificateauthority_1.cert_signedby_id LEFT OUTER JOIN system_acmeregistration AS system_acmeregistration_1 ON system_acmeregistration_1.id = system_certificate_1.cert_acme_id LEFT OUTER JOIN system_certificateauthority AS system_certificateauthority_3 ON system_certificateauthority_3.id = system_advanced.adv_syslog_tls_certificate_authority_id LEFT OUTER JOIN system_certificateauthority AS system_certificateauthority_4 ON system_certificateauthority_4.id = system_certificateauthority_3.cert_signedby_id] (Background on this error at: http://sqlalche.me/e/e3q8)

any help would be appreciated

 

[Samuel Tai]

This looks like a corrupt install that didn't have a self-signed cert created. Try installing to a different boot drive.

 

[dasunusername]

This looks like a corrupt install that didn't have a self-signed cert created. Try installing to a different boot drive.

If I do create a new boot drive will I be able to import the old pools and their respective data?

 

[Samuel Tai]

If I do create a new boot drive will I be able to import the old pools and their respective data?

Yes, that's one of the best features of TrueNAS. The data pool is separate from the boot pool.

 

[dasunusername]

Yes, that's one of the best features of TrueNAS. The data pool is separate from the boot pool.

Awesome thank you!