I just did the upgrade on Debian using the .db packages and ran into these
errors during the process of doing it. I am presuming they do not matter, but
I want to be sure.
creating djigzo PostgreSQL database and database user
ERROR: role "djigzo" already exists
createdb: database creation failed: ERROR: database "djigzo" already exists
ERROR: relation "admin" already exists
ERROR: relation "admin_authority" already exists
ERROR: relation "authority" already exists
ERROR: relation "blob" already exists
ERROR: relation "certificaterequest" already exists
ERROR: relation "certificates" already exists
ERROR: relation "certificates_email" already exists
ERROR: relation "crls" already exists
ERROR: relation "ctl" already exists
ERROR: relation "ctl_namevalues" already exists
ERROR: relation "keystore" already exists
ERROR: relation "mail_repository" already exists
ERROR: relation "mail_repository_recipients" already exists
ERROR: relation "named_blob" already exists
ERROR: relation "named_blob_named_blob" already exists
ERROR: relation "properties" already exists
ERROR: relation "properties_namevalues" already exists
ERROR: relation "sms" already exists
ERROR: relation "userpreferences" already exists
ERROR: relation "userpreferences_certificates" already exists
ERROR: relation "userpreferences_inheritedpreferences" already exists
ERROR: relation "userpreferences_named_blob" already exists
ERROR: relation "userpreferences_named_certificates" already exists
ERROR: relation "users" already exists
ERROR: constraint "fk31eb4613a92db044" for relation "admin_authority" already
exists
ERROR: constraint "fk31eb46135dd88a6" for relation "admin_authority" already
exists
ERROR: relation "certificaterequest_email_index" already exists
ERROR: relation "certificaterequest_next_update_index" already exists
ERROR: relation "certificaterequest_created_index" already exists
ERROR: relation "certificates_issuer_index" already exists
ERROR: relation "certificates_key_alias_index" already exists
ERROR: relation "certificates_thumbprint_index" already exists
ERROR: relation "certificates_creationdate_index" already exists
ERROR: relation "certificates_subject_index" already exists
ERROR: relation "certificates_store_name_index" already exists
ERROR: relation "certificates_subject_key_id_index" already exists
ERROR: relation "certificates_serial_index" already exists
ERROR: constraint "fk904263596f91dc04" for relation "certificates_email"
already exists
ERROR: relation "crls_thumbprint_index" already exists
ERROR: relation "crls_issuer_index" already exists
ERROR: relation "crls_crlnumber_index" already exists
ERROR: relation "crls_store_name_index" already exists
ERROR: constraint "fkc370b4312c4f7350" for relation "ctl_namevalues" already
exists
ERROR: relation "keystore_alias_index" already exists
ERROR: relation "keystore_storename_index" already exists
ERROR: constraint "fk9f4a42d2a7662f3" for relation "mail_repository" already
exists
ERROR: constraint "fk16fd4d076bba8de5" for relation
"mail_repository_recipients" already exists
ERROR: constraint "fkef3face33f4fe1e7" for relation "named_blob" already
exists
ERROR: constraint "fkc12079bf50dff003" for relation "named_blob_named_blob"
already exists
ERROR: constraint "fkc12079bf9df0d9c9" for relation "named_blob_named_blob"
already exists
ERROR: constraint "fk1de74a19d9423b4c" for relation "properties_namevalues"
already exists
ERROR: relation "sms_datelasttry_index" already exists
ERROR: relation "userpreferences_name_index" already exists
ERROR: relation "userpreferences_category_index" already exists
ERROR: constraint "fk8551364dfe700867" for relation "userpreferences" already
exists
ERROR: constraint "fk8551364d3f326a0d" for relation "userpreferences" already
exists
ERROR: constraint "fkb8b48a6e4e408931" for relation
"userpreferences_certificates" already exists
ERROR: constraint "fkb8b48a6e6f91dc04" for relation
"userpreferences_certificates" already exists
ERROR: constraint "fk46abee904e408931" for relation
"userpreferences_inheritedpreferences" already exists
ERROR: constraint "fk46abee90f11d70ab" for relation
"userpreferences_inheritedpreferences" already exists
ERROR: constraint "fka77dca154e408931" for relation
"userpreferences_named_blob" already exists
ERROR: constraint "fka77dca159df0d9c9" for relation
"userpreferences_named_blob" already exists
ERROR: constraint "fkaab29434a3567c25" for relation
"userpreferences_named_certificates" already exists
ERROR: constraint "fkaab294344e408931" for relation
"userpreferences_named_certificates" already exists
ERROR: constraint "fk6a68e08ba1f7c2e" for relation "users" already exists
ERROR: relation "hibernate_sequence" already exists
ERROR: relation "certificates_email_email_index" already exists
···
--
Nancy Anthracite
OOPS! That was supposed to be the .deb packages, not .db.
···
On Friday, March 18, 2011, Nancy Anthracite wrote:
I just did the upgrade on Debian using the .db packages and ran into these
errors during the process of doing it. I am presuming they do not matter,
but I want to be sure.
creating djigzo PostgreSQL database and database user
ERROR: role "djigzo" already exists
createdb: database creation failed: ERROR: database "djigzo" already
exists ERROR: relation "admin" already exists
ERROR: relation "admin_authority" already exists
ERROR: relation "authority" already exists
ERROR: relation "blob" already exists
ERROR: relation "certificaterequest" already exists
ERROR: relation "certificates" already exists
ERROR: relation "certificates_email" already exists
ERROR: relation "crls" already exists
ERROR: relation "ctl" already exists
ERROR: relation "ctl_namevalues" already exists
ERROR: relation "keystore" already exists
ERROR: relation "mail_repository" already exists
ERROR: relation "mail_repository_recipients" already exists
ERROR: relation "named_blob" already exists
ERROR: relation "named_blob_named_blob" already exists
ERROR: relation "properties" already exists
ERROR: relation "properties_namevalues" already exists
ERROR: relation "sms" already exists
ERROR: relation "userpreferences" already exists
ERROR: relation "userpreferences_certificates" already exists
ERROR: relation "userpreferences_inheritedpreferences" already exists
ERROR: relation "userpreferences_named_blob" already exists
ERROR: relation "userpreferences_named_certificates" already exists
ERROR: relation "users" already exists
ERROR: constraint "fk31eb4613a92db044" for relation "admin_authority"
already exists
ERROR: constraint "fk31eb46135dd88a6" for relation "admin_authority"
already exists
ERROR: relation "certificaterequest_email_index" already exists
ERROR: relation "certificaterequest_next_update_index" already exists
ERROR: relation "certificaterequest_created_index" already exists
ERROR: relation "certificates_issuer_index" already exists
ERROR: relation "certificates_key_alias_index" already exists
ERROR: relation "certificates_thumbprint_index" already exists
ERROR: relation "certificates_creationdate_index" already exists
ERROR: relation "certificates_subject_index" already exists
ERROR: relation "certificates_store_name_index" already exists
ERROR: relation "certificates_subject_key_id_index" already exists
ERROR: relation "certificates_serial_index" already exists
ERROR: constraint "fk904263596f91dc04" for relation "certificates_email"
already exists
ERROR: relation "crls_thumbprint_index" already exists
ERROR: relation "crls_issuer_index" already exists
ERROR: relation "crls_crlnumber_index" already exists
ERROR: relation "crls_store_name_index" already exists
ERROR: constraint "fkc370b4312c4f7350" for relation "ctl_namevalues"
already exists
ERROR: relation "keystore_alias_index" already exists
ERROR: relation "keystore_storename_index" already exists
ERROR: constraint "fk9f4a42d2a7662f3" for relation "mail_repository"
already exists
ERROR: constraint "fk16fd4d076bba8de5" for relation
"mail_repository_recipients" already exists
ERROR: constraint "fkef3face33f4fe1e7" for relation "named_blob" already
exists
ERROR: constraint "fkc12079bf50dff003" for relation
"named_blob_named_blob" already exists
ERROR: constraint "fkc12079bf9df0d9c9" for relation
"named_blob_named_blob" already exists
ERROR: constraint "fk1de74a19d9423b4c" for relation
"properties_namevalues" already exists
ERROR: relation "sms_datelasttry_index" already exists
ERROR: relation "userpreferences_name_index" already exists
ERROR: relation "userpreferences_category_index" already exists
ERROR: constraint "fk8551364dfe700867" for relation "userpreferences"
already exists
ERROR: constraint "fk8551364d3f326a0d" for relation "userpreferences"
already exists
ERROR: constraint "fkb8b48a6e4e408931" for relation
"userpreferences_certificates" already exists
ERROR: constraint "fkb8b48a6e6f91dc04" for relation
"userpreferences_certificates" already exists
ERROR: constraint "fk46abee904e408931" for relation
"userpreferences_inheritedpreferences" already exists
ERROR: constraint "fk46abee90f11d70ab" for relation
"userpreferences_inheritedpreferences" already exists
ERROR: constraint "fka77dca154e408931" for relation
"userpreferences_named_blob" already exists
ERROR: constraint "fka77dca159df0d9c9" for relation
"userpreferences_named_blob" already exists
ERROR: constraint "fkaab29434a3567c25" for relation
"userpreferences_named_certificates" already exists
ERROR: constraint "fkaab294344e408931" for relation
"userpreferences_named_certificates" already exists
ERROR: constraint "fk6a68e08ba1f7c2e" for relation "users" already exists
ERROR: relation "hibernate_sequence" already exists
ERROR: relation "certificates_email_email_index" already exists
--
Nancy Anthracite
I just did the upgrade on Debian using the .db packages and ran into these
errors during the process of doing it. I am presuming they do not matter, but
I want to be sure.
These warnings can be ignored. They are just warnings that certain
tables and indexes already exist.
I will add a note about this in the upgrade guide.
Kind regards,
Martijn Brinkers
···
On 03/18/2011 05:14 PM, Nancy Anthracite wrote:
creating djigzo PostgreSQL database and database user
ERROR: role "djigzo" already exists
createdb: database creation failed: ERROR: database "djigzo" already exists
ERROR: relation "admin" already exists
ERROR: relation "admin_authority" already exists
ERROR: relation "authority" already exists
ERROR: relation "blob" already exists
ERROR: relation "certificaterequest" already exists
ERROR: relation "certificates" already exists
ERROR: relation "certificates_email" already exists
ERROR: relation "crls" already exists
ERROR: relation "ctl" already exists
ERROR: relation "ctl_namevalues" already exists
ERROR: relation "keystore" already exists
ERROR: relation "mail_repository" already exists
ERROR: relation "mail_repository_recipients" already exists
ERROR: relation "named_blob" already exists
ERROR: relation "named_blob_named_blob" already exists
ERROR: relation "properties" already exists
ERROR: relation "properties_namevalues" already exists
ERROR: relation "sms" already exists
ERROR: relation "userpreferences" already exists
ERROR: relation "userpreferences_certificates" already exists
ERROR: relation "userpreferences_inheritedpreferences" already exists
ERROR: relation "userpreferences_named_blob" already exists
ERROR: relation "userpreferences_named_certificates" already exists
ERROR: relation "users" already exists
ERROR: constraint "fk31eb4613a92db044" for relation "admin_authority" already
exists
ERROR: constraint "fk31eb46135dd88a6" for relation "admin_authority" already
exists
ERROR: relation "certificaterequest_email_index" already exists
ERROR: relation "certificaterequest_next_update_index" already exists
ERROR: relation "certificaterequest_created_index" already exists
ERROR: relation "certificates_issuer_index" already exists
ERROR: relation "certificates_key_alias_index" already exists
ERROR: relation "certificates_thumbprint_index" already exists
ERROR: relation "certificates_creationdate_index" already exists
ERROR: relation "certificates_subject_index" already exists
ERROR: relation "certificates_store_name_index" already exists
ERROR: relation "certificates_subject_key_id_index" already exists
ERROR: relation "certificates_serial_index" already exists
ERROR: constraint "fk904263596f91dc04" for relation "certificates_email"
already exists
ERROR: relation "crls_thumbprint_index" already exists
ERROR: relation "crls_issuer_index" already exists
ERROR: relation "crls_crlnumber_index" already exists
ERROR: relation "crls_store_name_index" already exists
ERROR: constraint "fkc370b4312c4f7350" for relation "ctl_namevalues" already
exists
ERROR: relation "keystore_alias_index" already exists
ERROR: relation "keystore_storename_index" already exists
ERROR: constraint "fk9f4a42d2a7662f3" for relation "mail_repository" already
exists
ERROR: constraint "fk16fd4d076bba8de5" for relation
"mail_repository_recipients" already exists
ERROR: constraint "fkef3face33f4fe1e7" for relation "named_blob" already
exists
ERROR: constraint "fkc12079bf50dff003" for relation "named_blob_named_blob"
already exists
ERROR: constraint "fkc12079bf9df0d9c9" for relation "named_blob_named_blob"
already exists
ERROR: constraint "fk1de74a19d9423b4c" for relation "properties_namevalues"
already exists
ERROR: relation "sms_datelasttry_index" already exists
ERROR: relation "userpreferences_name_index" already exists
ERROR: relation "userpreferences_category_index" already exists
ERROR: constraint "fk8551364dfe700867" for relation "userpreferences" already
exists
ERROR: constraint "fk8551364d3f326a0d" for relation "userpreferences" already
exists
ERROR: constraint "fkb8b48a6e4e408931" for relation
"userpreferences_certificates" already exists
ERROR: constraint "fkb8b48a6e6f91dc04" for relation
"userpreferences_certificates" already exists
ERROR: constraint "fk46abee904e408931" for relation
"userpreferences_inheritedpreferences" already exists
ERROR: constraint "fk46abee90f11d70ab" for relation
"userpreferences_inheritedpreferences" already exists
ERROR: constraint "fka77dca154e408931" for relation
"userpreferences_named_blob" already exists
ERROR: constraint "fka77dca159df0d9c9" for relation
"userpreferences_named_blob" already exists
ERROR: constraint "fkaab29434a3567c25" for relation
"userpreferences_named_certificates" already exists
ERROR: constraint "fkaab294344e408931" for relation
"userpreferences_named_certificates" already exists
ERROR: constraint "fk6a68e08ba1f7c2e" for relation "users" already exists
ERROR: relation "hibernate_sequence" already exists
ERROR: relation "certificates_email_email_index" already exists
--
Djigzo open source email encryption