-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 5.0.N
-
Fix Version/s: 5.0.3
-
Component/s: Database and Persistence, Upgrades
-
Labels:None
-
Environment:CentOS 7 running in a VM on a Debian 8 KVM host
-
Bug Priority:
Category 1
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.
- is cloned by
-
MNT-15522
PropTablesCleanupJob is not protected by JobLockService causing race condition.
- Closed
