Postgresql missing tables

[Steven]

hey,

still got the problem from yesterday, me and my colleague did the same things with your standard installation files.

after a bit of research i found out that im missing like 20 tables in my postgresql database and my colleague got everything.

any ideas on that?

my version:
List of relations
Schema | Name | Type | Owner
--------±-----------------------------------------------±------±------
public | acls_accesscontrollist | table | mayan
public | acls_accesscontrollist_permissions | table | mayan
public | actstream_action | table | mayan
public | actstream_follow | table | mayan
public | announcements_announcement | table | mayan
public | appearance_theme | table | mayan
public | appearance_userthemesetting | table | mayan
public | auth_group | table | mayan
public | auth_group_permissions | table | mayan
public | auth_permission | table | mayan
public | auth_user | table | mayan
public | auth_user_groups | table | mayan
public | auth_user_user_permissions | table | mayan
public | authentication_otp_userotpdata | table | mayan
public | authtoken_token | table | mayan
public | autoadmin_autoadminsingleton | table | mayan
public | cabinets_cabinet | table | mayan
public | cabinets_cabinet_documents | table | mayan
public | checkouts_documentcheckout | table | mayan
public | converter_asset | table | mayan
public | converter_layertransformation | table | mayan
public | converter_objectlayer | table | mayan
public | converter_storedlayer | table | mayan
public | credentials_storedcredential | table | mayan
public | django_admin_log | table | mayan
public | django_celery_beat_clockedschedule | table | mayan
public | django_celery_beat_crontabschedule | table | mayan
public | django_celery_beat_intervalschedule | table | mayan
public | django_celery_beat_periodictask | table | mayan
public | django_celery_beat_periodictasks | table | mayan
public | django_celery_beat_solarschedule | table | mayan
public | django_content_type | table | mayan
public | django_gpg_key | table | mayan
public | django_migrations | table | mayan
public | django_site | table | mayan
public | document_comments_comment | table | mayan
public | document_indexing_indexinstancenode | table | mayan
public | document_indexing_indexinstancenode_documents | table | mayan
public | document_indexing_indextemplate | table | mayan
public | document_indexing_indextemplate_document_types | table | mayan
public | document_indexing_indextemplateeventtrigger | table | mayan
public | document_indexing_indextemplatenode | table | mayan
public | document_parsing_documentfilepagecontent | table | mayan
public | document_parsing_documenttypesettings | table | mayan
public | document_signatures_detachedsignature | table | mayan
public | document_signatures_embeddedsignature | table | mayan
public | document_signatures_signaturebasemodel | table | mayan
public | document_states_workflow | table | mayan
public | document_states_workflow_document_types | table | mayan
public | document_states_workflowinstance | table | mayan
public | document_states_workflowinstancelogentry | table | mayan
public | document_states_workflowstate | table | mayan
public | document_states_workflowstateaction | table | mayan
public | document_states_workflowstateescalation | table | mayan
public | document_states_workflowtransition | table | mayan
public | document_states_workflowtransitionfield | table | mayan
public | document_states_workflowtransitiontriggerevent | table | mayan
public | documents_document | table | mayan
public | documents_documentfile | table | mayan
public | documents_documentfilepage | table | mayan
public | documents_documenttype | table | mayan
public | documents_documenttypefilename | table | mayan
public | documents_documentversion | table | mayan
public | documents_documentversionpage | table | mayan
public | documents_favoritedocument | table | mayan
public | documents_recentlyaccesseddocument | table | mayan
public | duplicates_duplicatebackendentry | table | mayan
public | duplicates_duplicatebackendentry_documents | table | mayan
public | duplicates_storedduplicatebackend | table | mayan
public | dynamic_search_savedresultset | table | mayan
public | dynamic_search_savedresultsetentry | table | mayan
public | events_eventsubscription | table | mayan
public | events_notification | table | mayan
public | events_objecteventsubscription | table | mayan
public | events_storedeventtype | table | mayan
public | file_caching_cache | table | mayan
public | file_caching_cachepartition | table | mayan
public | file_caching_cachepartitionfile | table | mayan
public | file_metadata_documentfiledriverentry | table | mayan
public | file_metadata_documenttypesettings | table | mayan
public | file_metadata_filemetadataentry | table | mayan
public | file_metadata_storeddriver | table | mayan
public | linking_smartlink | table | mayan
public | linking_smartlink_document_types | table | mayan
public | linking_smartlinkcondition | table | mayan
public | locales_userlocaleprofile | table | mayan
public | motd_message | table | mayan
public | ocr_documentpageocrcontent | table | mayan
public | ocr_documenttypesettings | table | mayan
public | ocr_documentversionocrerror | table | mayan
public | permissions_role | table | mayan
public | permissions_role_groups | table | mayan
public | permissions_role_permissions | table | mayan
public | permissions_storedpermission | table | mayan
public | storage_storageshareduploadedfile | table | mayan
(95 rows)

my colleagues version:

                        List of relations

Schema | Name | Type | Owner
--------±-----------------------------------------------±------±------
public | acls_accesscontrollist | table | mayan
public | acls_accesscontrollist_permissions | table | mayan
public | actstream_action | table | mayan
public | actstream_follow | table | mayan
public | announcements_announcement | table | mayan
public | appearance_theme | table | mayan
public | appearance_userthemesetting | table | mayan
public | auth_group | table | mayan
public | auth_group_permissions | table | mayan
public | auth_permission | table | mayan
public | auth_user | table | mayan
public | auth_user_groups | table | mayan
public | auth_user_user_permissions | table | mayan
public | authentication_otp_userotpdata | table | mayan
public | authtoken_token | table | mayan
public | autoadmin_autoadminsingleton | table | mayan
public | cabinets_cabinet | table | mayan
public | cabinets_cabinet_documents | table | mayan
public | checkouts_documentcheckout | table | mayan
public | converter_asset | table | mayan
public | converter_layertransformation | table | mayan
public | converter_objectlayer | table | mayan
public | converter_storedlayer | table | mayan
public | credentials_storedcredential | table | mayan
public | django_admin_log | table | mayan
public | django_celery_beat_clockedschedule | table | mayan
public | django_celery_beat_crontabschedule | table | mayan
public | django_celery_beat_intervalschedule | table | mayan
public | django_celery_beat_periodictask | table | mayan
public | django_celery_beat_periodictasks | table | mayan
public | django_celery_beat_solarschedule | table | mayan
public | django_content_type | table | mayan
public | django_gpg_key | table | mayan
public | django_migrations | table | mayan
public | django_session | table | mayan
public | django_site | table | mayan
public | document_comments_comment | table | mayan
public | document_indexing_indexinstancenode | table | mayan
public | document_indexing_indexinstancenode_documents | table | mayan
public | document_indexing_indextemplate | table | mayan
public | document_indexing_indextemplate_document_types | table | mayan
public | document_indexing_indextemplateeventtrigger | table | mayan
public | document_indexing_indextemplatenode | table | mayan
public | document_parsing_documentfilepagecontent | table | mayan
public | document_parsing_documenttypesettings | table | mayan
public | document_signatures_detachedsignature | table | mayan
public | document_signatures_embeddedsignature | table | mayan
public | document_signatures_signaturebasemodel | table | mayan
public | document_states_workflow | table | mayan
public | document_states_workflow_document_types | table | mayan
public | document_states_workflowinstance | table | mayan
public | document_states_workflowinstancelogentry | table | mayan
public | document_states_workflowstate | table | mayan
public | document_states_workflowstateaction | table | mayan
public | document_states_workflowstateescalation | table | mayan
public | document_states_workflowtransition | table | mayan
public | document_states_workflowtransitionfield | table | mayan
public | document_states_workflowtransitiontriggerevent | table | mayan
public | documents_document | table | mayan
public | documents_documentfile | table | mayan
public | documents_documentfilepage | table | mayan
public | documents_documenttype | table | mayan
public | documents_documenttypefilename | table | mayan
public | documents_documentversion | table | mayan
public | documents_documentversionpage | table | mayan
public | documents_favoritedocument | table | mayan
public | documents_recentlyaccesseddocument | table | mayan
public | duplicates_duplicatebackendentry | table | mayan
public | duplicates_duplicatebackendentry_documents | table | mayan
public | duplicates_storedduplicatebackend | table | mayan
public | dynamic_search_savedresultset | table | mayan
public | dynamic_search_savedresultsetentry | table | mayan
public | events_eventsubscription | table | mayan
public | events_notification | table | mayan
public | events_objecteventsubscription | table | mayan
public | events_storedeventtype | table | mayan
public | file_caching_cache | table | mayan
public | file_caching_cachepartition | table | mayan
public | file_caching_cachepartitionfile | table | mayan
public | file_metadata_documentfiledriverentry | table | mayan
public | file_metadata_documenttypesettings | table | mayan
public | file_metadata_filemetadataentry | table | mayan
public | file_metadata_storeddriver | table | mayan
public | linking_smartlink | table | mayan
public | linking_smartlink_document_types | table | mayan
public | linking_smartlinkcondition | table | mayan
public | locales_userlocaleprofile | table | mayan
public | lock_manager_lock | table | mayan
public | logging_errorlogpartition | table | mayan
public | logging_errorlogpartitionentry | table | mayan
public | logging_storederrorlog | table | mayan
public | mailer_usermailer | table | mayan
public | mayan_statistics_statisticresult | table | mayan
public | messaging_message | table | mayan
public | metadata_documentmetadata | table | mayan
public | metadata_documenttypemetadatatype | table | mayan
public | metadata_metadatatype | table | mayan
public | ocr_documenttypeocrsettings | table | mayan
public | ocr_documentversionpageocrcontent | table | mayan
public | permissions_role | table | mayan
public | permissions_role_groups | table | mayan
public | permissions_role_permissions | table | mayan
public | permissions_storedpermission | table | mayan
public | quotas_quota | table | mayan
public | signature_captures_signaturecapture | table | mayan
public | smart_settings_updatedsetting | table | mayan
public | sources_documentfilesourcemetadata | table | mayan
public | sources_source | table | mayan
public | storage_downloadfile | table | mayan
public | storage_shareduploadedfile | table | mayan
public | tags_tag | table | mayan
public | tags_tag_documents | table | mayan
public | user_management_useroptions | table | mayan
public | web_links_weblink | table | mayan
public | web_links_weblink_document_types | table | mayan

best regards

steven

[dbayer]

Did you reuse the same Docker container when you used the official docker-compose.yml?

If you did then the volumes from the previous failed attempt will still be there. Try deleting all the old volumes, and then run docker compose.

[Steven]

hey i deleted every single volume and image etc. with docker system prune --volumes so i guess there was nothing left

[dbayer]

You could do a “docker volume ls” and see if any with your container name are still left.

[Steven]

nop nothing was left after docker system prune --volumes but what can cause my postgresdb to miss like 20 tables - because thats the reason my mayan wont boot…

[Steven]

@roberto.rosario u got any idea how i can miss 20 postgresql tables with the standard docker compose file?

[roberto.rosario]

New installation throws this error

Hi, It seems that the Docker Compose file has been greatly modified and it is also either running or include settings for a translation service, a custom Mayan API client, another DMS software, a custom payment processing app, and another database client software connecting to the same Mayan EDMS PostgreSQL database. It is very like that these modifications are causing the issue. Please reproduce the suspected bug using unmodified Mayan files. For support with customization or integration wi…