Installation problems moving from labs3b to labs3stable

[efestione]

Hi everyone,
I'm triyng to migrate from a server (A) to another (B), but I obtain this error:

20:03:59,969 INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
20:04:08,016 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
20:04:08,906 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
20:04:09,906 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started: 949 transactions.
20:04:10,172 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        10 % complete.
20:04:10,172 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        20 % complete.
20:04:10,172 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        30 % complete.
20:04:10,188 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        40 % complete.
20:04:10,188 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        50 % complete.
20:04:10,188 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        60 % complete.
20:04:10,203 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        70 % complete.
20:04:10,203 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        80 % complete.
20:04:10,203 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        90 % complete.
20:04:10,219 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        100 % complete.
20:04:18,469 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery completed.
20:04:18,500 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Rebuilding indexes for 1 AVM Stores
20:04:18,500 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent]     Rebuilding index for sitestore
20:04:18,563 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent]   Reindex   100% complete
20:04:18,563 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Finished rebuilding indexes for AVM Stores
20:04:18,750 INFO  [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: E:\Alfresco\alf_data
20:04:18,766 ERROR [org.alfresco.repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: System content not found in content store.
20:04:18,766 ERROR [org.alfresco.repo.admin.ConfigurationChecker] Ensure that the 'dir.root' property is pointing to the correct data location.
20:04:18,766 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Ensure that the 'dir.root' property is pointing to the correct data location.
                at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:312)
…

Servers are:

(A)
Windows XP
dir.root: C:/Alfresco/alf_data

(B)
Windows Server 2003
dir.root: E:/Alfresco/alf_data

I followed the steps described in the wiki section "General_Process_Upgrade".
Can the different drive ('E' instead of 'C') be the source of this problem? Or what else?

Thanks for your help.
Alessandro

[derek]

Hi,

                        for (Locale locale : mlText.getLocales())
                        {
                            String localeString = mlText.getValue(locale);
                            …
                                duplicator = new MLTokenDuplicator(vba.tokenStream(attributeName, new StringReader(localeString)), locale, null, analysisMode);
                            …
‍‍‍‍‍‍‍

It appears that the locale-specific string returned from the mltext object is null.  This is unexpected i.e. I would not expect null string values to be applied to any locale.  The good news is that the FTS indexer is a background job (which is why only text searching would be broken) so we should be able to find the data that is causing the problem.  Run the following SQL and post the results (or a subset if there are many):

select * from alf_node_properties np join alf_locale l on (l.id = np.locale_id) where l.locale_str != '.default' and np.string_value is null;‍

Also, please give details of what your language settings are for the user that uploads the documents.

[efestione]

Run the following SQL and post the results (or a subset if there are many):

select * from alf_node_properties np join alf_locale l on (l.id = np.locale_id) where l.locale_str != '.default' and np.string_value is null;‍

Also, please give details of what your language settings are for the user that uploads the documents.

Hi,

The result is a single record:

node_id    2662
actual_type_n    0
persisted_type_n    0
boolean_value    
long_value    0
float_value    0
double_value    0
string_value    NULL
serializable_value    [BLOB - 0B]
qname_id    111
list_index    -1
locale_id    5
id    5
version    0
locale_str    it_IT_‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I installed the italian language pack but the exception is thrown even if I select english. The problem doesn't seem linked to a particular user.
A doubt: the node id = 2662 is an image I uploaded this morning, but the problem is more days old.

Thank you very much

[derek]

Hi,
Delete that record; it contains no useful information and is incorrect (null string_value with non-default locale).  Then repeat some document uploads and let me know if new, incorrect data appears.

delete from alf_node_properties where node_id = 2662 and qname_id = 111 and list_index = -1 and locale_id = 5‍

Regards

[efestione]

Hi,
I deleted the record.

After, logged as admin,  I uploaded a .ppt file but I obtained the same exception.

Then I relaunched this query

select * from alf_node_properties np join alf_locale l on (l.id = np.locale_id) where l.locale_str != '.default' and np.string_value is null;
‍‍‍

Now the result is 0 records.

[derek]

Hi,
Let's widen the search to get cm:title and cm:description properties without any value:

select * from alf_node_properties np join alf_qname qn on (np.qname_id = qn.id) where qn.local_name in ('title', 'description') and np.string_value is null;
‍‍‍

Regards

[efestione]

I obtained 83 records. I report below the first four:

node_id     2021    2399    1858    1879
actual_type_n    0    0    0    0
persisted_type_n    0    0    0    0
boolean_value             
long_value    0    0    0    0
float_value    0    0    0    0
double_value    0    0    0    0
string_value    NULL    NULL    NULL    NULL
serializable_value    [BLOB - 0B]    [BLOB - 0B]    [BLOB - 0B]    [BLOB - 0B]
qname_id    110    110    111    111
list_index    -1    -1    -1    -1
locale_id    1    1    1    1
id    110    110    111    111
version    0    0    0    0
ns_id    3    3    3    3
local_name    title    title    description    description
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[derek]

Hi,
Does this list grow as you add documents?  You can delete those as well, but you'll need the mysql delete-join syntax.

[efestione]

Hi,
no, the list doesn't grow when I add document.
Then to solve the problem Do I need to delete all those records?

Does the query sound like this?

DELETE alf_node_properties.*, alf_qname.*
FROM  alf_node_properties np, alf_qname qn
WHERE np.qname_id = qn.id
AND
qn.local_name
IN (
'title', 'description'
)
AND np.string_value IS NULL

[derek]

Not quite!

DELETE alf_node_properties
   FROM alf_node_properties
   JOIN alf_qname ON (alf_node_properties.qname_id = alf_qname.id)
   WHERE
      alf_qname.local_name IN ('title', 'description') AND
      alf_node_properties.string_value is null
;
‍‍‍‍‍‍‍‍‍

[efestione]

Great Derek! thank you very much! The exception disappears.
Have you any idea about the presence of these dirty records?