Details

    • Type: Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 5.0.N
    • Fix Version/s: 5.0.3
    • Labels:
      None
    • Environment:
      CentOS 7 running in a VM on a Debian 8 KVM host

      Description

      A forums user has reported an issue with a very large database size.

      • Started with Alfresco Community 5.0.d
      • Upgraded to 5.1.a, 5.1.b, and 5.1.c
      • No problems encountered
      • During upgrade to 5.1.c, noticed that pg_dump was producing a 16GB DB (running DB is 9GB)
      • Two tables are big: alf_prop_serializable_value (8GB) and alf_prop_value (almost 1GB)
      • alf_data contains 12.6 GB and has 65,000 files
      • Most files are uploaded using SMB/CIFS, but also using Share and IMAP (via Thunderbird)
      • Auditing is not enabled
      • running attributes.propcleaner didn't help, and produced a bunch of error messages
      2015-11-17 01:59:59,426 INFO  [org.alfresco.repo.domain.schema.script.ScriptExecutorImpl] [DefaultScheduler_Worker-1] Processing from 0 to 1 rows of 0 rows from table temp_del_double1.
      2015-11-17 01:59:59,431 ERROR [org.alfresco.repo.domain.schema.script.ScriptExecutorImpl] [DefaultScheduler_Worker-4] Statement execution failed:
         SQL: create table temp_prop_root_ref
      (
          id INT8 NOT NULL
      )
         Error: ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
        Detail: Key (typname, typnamespace)=(temp_prop_root_ref, 2200) already exists.
         File: /home/wadams/alfresco-5.1ea-201510/tomcat/temp/Alfresco/AlfrescoSchema-PostgreSQLDialect-Update-8302102904952264845.sql
         Line: 20
      2015-11-17 01:59:59,431 INFO  [org.alfresco.repo.domain.schema.script.ScriptExecutorImpl] [DefaultScheduler_Worker-1] Executing database script /home/wadams/alfresco-5.1ea-201510/tomcat/temp/Alfresco/AlfrescoSchema-PostgreSQLDialect-Update-4220164947366785582.sql (Copied from alfresco/dbscripts/utility/org.hibernate.dialect.PostgreSQLDialect/CleanAlfPropTablesPostExec.sql).
      2015-11-17 01:59:59,431 INFO  [org.alfresco.repo.domain.schema.script.ScriptExecutorImpl] [DefaultScheduler_Worker-4] Executing database script /home/wadams/alfresco-5.1ea-201510/tomcat/temp/Alfresco/AlfrescoSchema-PostgreSQLDialect-Update-5537965044981921163.sql (Copied from alfresco/dbscripts/utility/org.hibernate.dialect.PostgreSQLDialect/CleanAlfPropTablesPostExec.sql).2015-11-17 01:59:59,426 INFO  [org.alfresco.repo.domain.schema.script.ScriptExecutorImpl] [DefaultScheduler_Worker-1] Processing from 0 to 1 rows of 0 rows from table temp_del_double1.
      2015-11-17 01:59:59,431 ERROR [org.alfresco.repo.domain.schema.script.ScriptExecutorImpl] [DefaultScheduler_Worker-4] Statement execution failed:
         SQL: create table temp_prop_root_ref
      (
          id INT8 NOT NULL
      )
         Error: ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index"
        Detail: Key (typname, typnamespace)=(temp_prop_root_ref, 2200) already exists.
         File: /home/wadams/alfresco-5.1ea-201510/tomcat/temp/Alfresco/AlfrescoSchema-PostgreSQLDialect-Update-8302102904952264845.sql
         Line: 20
      2015-11-17 01:59:59,431 INFO  [org.alfresco.repo.domain.schema.script.ScriptExecutorImpl] [DefaultScheduler_Worker-1] Executing database script /home/wadams/alfresco-5.1ea-201510/tomcat/temp/Alfresco/AlfrescoSchema-PostgreSQLDialect-Update-4220164947366785582.sql (Copied from alfresco/dbscripts/utility/org.hibernate.dialect.PostgreSQLDialect/CleanAlfPropTablesPostExec.sql).
      2015-11-17 01:59:59,431 INFO  [org.alfresco.repo.domain.schema.script.ScriptExecutorImpl] [DefaultScheduler_Worker-4] Executing database script /home/wadams/alfresco-5.1ea-201510/tomcat/temp/Alfresco/AlfrescoSchema-PostgreSQLDialect-Update-5537965044981921163.sql (Copied from alfresco/dbscripts/utility/org.hibernate.dialect.PostgreSQLDialect/CleanAlfPropTablesPostExec.sql).
      

      This report comes from the forums, and Axel Faust has a theory that this is a regression in 5.1 because 4.2.x and 5.0 cut off text values at 1000 characters to prevent serialization.

      https://forums.alfresco.com/forum/installation-upgrades-configuration-integration/configuration/huge-database-size-11142015-1023

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedbugs Closed Bugs (Inactive)
                  Reporter:
                  resplin Richard Esplin [X] (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  8 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 4 hours, 30 minutes
                    4h 30m

                      Structure Helper Panel