Daily Log for #alfresco IRC Channel

Alfresco discussion and collaboration. Stick around a few hours after asking a question.

Official support for Enterprise subscribers: support.alfresco.com.

Joining the Channel:

Join in the conversation by getting an IRC client and connecting to #alfresco at Freenode. Our you can use the IRC web chat.

More information about the channel is in the wiki.

Getting Help

More help is available in this list of resources.

Daily Log for #alfresco

2017-04-28 06:16:42 GMT <twen> hello

2017-04-28 07:01:17 GMT <FSilvani> good morning

2017-04-28 09:39:12 GMT <fwu> hi all!

2017-04-28 10:10:15 GMT *** iwkse_ is now known as iwkse

2017-04-28 12:32:46 GMT <Modestas> douglascrp: do you have few minutes?

2017-04-28 12:52:58 GMT <digcat> ~later tell yreg when your back on the ground, vote on this issue when you get a chance https://mattermost.atlassian.net/browse/PLT-541

2017-04-28 12:52:58 GMT <alfbot> digcat: The operation succeeded.

2017-04-28 13:52:37 GMT <douglascrp> Modestas, hey

2017-04-28 13:53:30 GMT <Modestas> douglascrp: is is possible to create NodeRef that I would be able to query it using CMIS but index for that NodeRef in SOLR was not created?

2017-04-28 13:53:40 GMT <Modestas> douglascrp: sorry, hello :)

2017-04-28 13:54:03 GMT <douglascrp> I didn't get that

2017-04-28 13:54:45 GMT <Modestas> hmm..

2017-04-28 13:55:10 GMT <Modestas> can you explain to me how related is CMIS with SOLR ?

2017-04-28 13:55:39 GMT <douglascrp> well, solr is the "search" engine

2017-04-28 13:55:53 GMT <douglascrp> depending on the query you create, it can be used

2017-04-28 13:56:07 GMT <Modestas> but CMIS can look directly to db or I am mistaken?

2017-04-28 13:56:08 GMT <douglascrp> but the database can also be used

2017-04-28 13:56:31 GMT <douglascrp> yes, it can be, but you have to make sure your query is compatible

2017-04-28 13:56:35 GMT <douglascrp> let me get a link to you

2017-04-28 13:57:13 GMT <douglascrp> http://www.tsgrp.com/2017/04/06/alfresco-solr-issues-when-does-just-leveraging-the-database-make-sense/

2017-04-28 13:57:16 GMT <alfbot> Title: Alfresco Solr Issues – when does just leveraging the database make sense? (at www.tsgrp.com)

2017-04-28 13:57:31 GMT <douglascrp> http://www.tsgrp.com/2016/11/08/alfrescos-transactional-metadata-query-system-mystery-results/

2017-04-28 13:57:33 GMT <alfbot> Title: Alfresco’s Transactional Metadata Query System – Mystery Results (at www.tsgrp.com)

2017-04-28 13:59:26 GMT <douglascrp> and this one too, but I haven't read it yet http://beecon.buzz/2017/assets/files/E10/Making%20proper%20use%20of%20transactional%20metadata%20queries.pdf

2017-04-28 13:59:32 GMT <douglascrp> the last one is from beecon

2017-04-28 14:00:19 GMT <Modestas> douglascrp: thank you i will take a look

2017-04-28 14:00:51 GMT <Modestas> one more question if I may :)

2017-04-28 14:01:08 GMT <Modestas> when we create NodeRef its meta data is indexed by solr

2017-04-28 14:01:23 GMT <Modestas> is it possible to say that all expect 1 property should be indexed by solr?

2017-04-28 14:01:50 GMT <douglascrp> again, I didn't get that

2017-04-28 14:01:54 GMT <Modestas> by say I mean configure in model by creating custom type

2017-04-28 14:01:55 GMT <douglascrp> all expect 1 property

2017-04-28 14:02:05 GMT <douglascrp> by default, all properties are indexed

2017-04-28 14:02:11 GMT <douglascrp> if that is what you want to know

2017-04-28 14:02:22 GMT <Modestas> if you create a custom type

2017-04-28 14:02:37 GMT <Modestas> and parent is sys:base

2017-04-28 14:02:54 GMT <douglascrp> ok

2017-04-28 14:03:14 GMT <Modestas> and create a NodeRef using that custom type

2017-04-28 14:03:42 GMT <douglascrp> you do not create NodeRef

2017-04-28 14:03:45 GMT <douglascrp> you create a node

2017-04-28 14:04:00 GMT <douglascrp> and you get a NodeRef back

2017-04-28 14:04:06 GMT <Modestas> yes you are correct

2017-04-28 14:04:17 GMT <douglascrp> but I still didn't get your question

2017-04-28 14:04:33 GMT <Modestas> by default that node is indexed by solr

2017-04-28 14:04:33 GMT <douglascrp> do you want to know if your node's properties will be indexed

2017-04-28 14:04:42 GMT <douglascrp> yes, all the properties

2017-04-28 14:04:58 GMT <Modestas> so I want to disable index for all properties expect one

2017-04-28 14:05:13 GMT <douglascrp> ah, right

2017-04-28 14:05:29 GMT <douglascrp> ok, then you will have to set the indexed option to false inside the property definition

2017-04-28 14:05:35 GMT <douglascrp> that configuration is for each property

2017-04-28 14:05:51 GMT <Modestas> understood

2017-04-28 14:06:15 GMT <douglascrp> <type name='cm:content'>

2017-04-28 14:06:16 GMT <douglascrp> <title>Content</title>

2017-04-28 14:06:16 GMT <douglascrp> <parent>cm:cmobject</parent>

2017-04-28 14:06:16 GMT <douglascrp> <properties>

2017-04-28 14:06:16 GMT <douglascrp> <property name='cm:content'>

2017-04-28 14:06:16 GMT <douglascrp> <type>d:content</type>

2017-04-28 14:06:18 GMT <douglascrp> <mandatory>false</mandatory>

2017-04-28 14:06:20 GMT <douglascrp> <index enabled='true'>

2017-04-28 14:06:22 GMT <douglascrp> <atomic>false</atomic>

2017-04-28 14:06:24 GMT <douglascrp> <stored>false</stored>

2017-04-28 14:06:26 GMT <douglascrp> <tokenised>true</tokenised>

2017-04-28 14:06:28 GMT <douglascrp> </index>

2017-04-28 14:06:30 GMT <douglascrp> </property>

2017-04-28 14:06:34 GMT <douglascrp> </properties>

2017-04-28 14:06:36 GMT <douglascrp> </type>

2017-04-28 14:06:38 GMT <douglascrp> this is the default

2017-04-28 14:06:40 GMT <douglascrp> if you want to disable it, you have to set <index enabled='false'>

2017-04-28 14:06:46 GMT <douglascrp> for each property

2017-04-28 14:07:03 GMT <Modestas> so how can i override parent properties to make them not indexed?

2017-04-28 14:07:04 GMT <douglascrp> and for the one you DO want to have indexed, you have to do nothing

2017-04-28 14:07:12 GMT <douglascrp> parent

2017-04-28 14:07:34 GMT <douglascrp> well, if it is your custom content type, simply change it, and perform a full solr reindex

2017-04-28 14:07:56 GMT <douglascrp> but it the property is an OOTB one, don't change that

2017-04-28 14:08:23 GMT <douglascrp> https://community.alfresco.com/docs/DOC-4798-full-text-search-configuration

2017-04-28 14:08:25 GMT <alfbot> Title: Full-Text Search Configuration | Alfresco Community (at community.alfresco.com)

2017-04-28 14:08:50 GMT <Modestas> What I am trying to achieve is to minimise solr indexing

2017-04-28 14:09:14 GMT <douglascrp> well, the main part of solr index is the content

2017-04-28 14:09:20 GMT <Modestas> all custom properties has been marked as index enabled=false

2017-04-28 14:09:24 GMT <douglascrp> what you can do is disable the content index if that is ok for you

2017-04-28 14:09:42 GMT <Modestas> but still for 5mln nodes I create about 11GB solr index

2017-04-28 14:09:43 GMT <douglascrp> I doubt that will give you a big difference in size

2017-04-28 14:10:06 GMT <douglascrp> do you rely on full text search in content?

2017-04-28 14:10:18 GMT <Modestas> and basically I have only 1 property which is indexed

2017-04-28 14:10:26 GMT <Modestas> no full text index is disabled in my case

2017-04-28 14:10:45 GMT <douglascrp> again, I bet the property itself is not the main reason for that amount of data

2017-04-28 14:10:48 GMT <douglascrp> one more thing

2017-04-28 14:10:56 GMT <douglascrp> you can disable the archive indexing at all

2017-04-28 14:11:00 GMT <douglascrp> I mean, the trashcan

2017-04-28 14:11:14 GMT <Modestas> I did that too

2017-04-28 14:11:27 GMT <douglascrp> and what is the size of your contentstore?

2017-04-28 14:11:28 GMT <Modestas> is it possible to read what data is indexed in solr?

2017-04-28 14:11:34 GMT <douglascrp> do you have multi-version documents?

2017-04-28 14:12:11 GMT <Modestas> I delete previous version of document

2017-04-28 14:12:17 GMT <Modestas> 11G /opt/alfresco-community/alf_data/contentstore 0 /opt/alfresco-community/alf_data/contentstore.deleted 60K /opt/alfresco-community/alf_data/keystore 16G /opt/alfresco-community/alf_data/postgresql 11G /opt/alfresco-community/alf_data/solr4

2017-04-28 14:12:39 GMT <Modestas> 11G /opt/alfresco-community/alf_data/contentstore

2017-04-28 14:12:44 GMT <Modestas> 16G /opt/alfresco-community/alf_data/postgresql

2017-04-28 14:12:48 GMT <Modestas> 11G /opt/alfresco-community/alf_data/solr4

2017-04-28 14:15:25 GMT <douglascrp> I am afraid I didn't get your answer for "is the content index enabled"

2017-04-28 14:15:49 GMT <Modestas> content index is disabled

2017-04-28 14:16:03 GMT <douglascrp> it makes no sense to have the contentsotre and the solr index with the same size

2017-04-28 14:16:08 GMT <douglascrp> something must be wrong there

2017-04-28 14:16:22 GMT <douglascrp> usually, you can consider it wont be bigger than 40%

2017-04-28 14:16:39 GMT <douglascrp> if the contentstore is 11 G, you should have no more then 5 GB in solr

2017-04-28 14:16:56 GMT <douglascrp> even more in the case with content index disable

2017-04-28 14:17:00 GMT <douglascrp> disabled

2017-04-28 14:17:15 GMT <douglascrp> the only way to understand what is going on is to check your environment

2017-04-28 14:18:19 GMT <Modestas> please note that I create a lot of small nodes

2017-04-28 14:18:32 GMT <Modestas> in this server node number is 5mln

2017-04-28 14:24:12 GMT <douglascrp> and why that

2017-04-28 14:25:12 GMT <fwu> back

2017-04-28 14:25:36 GMT <Modestas> douglascrp: specific of cameo collaborator :)

2017-04-28 14:25:45 GMT <Modestas> and sysml views and viewpoints

2017-04-28 14:26:09 GMT <Modestas> douglascrp: hope you can open http://ccexamples.nomagic.com:8080/share/s/s5vQQmUkQQ-qq_CeTLnJOQ#TREE_VIEW_ID__18_0_4_f720368_1430908394077_24932_25963NodeView___17_0_1_601020a_1306996838695_329979_14358_cc_TREE_VIEW_ID__18_0_4_f720368_1430908394077_24932_25963

2017-04-28 14:26:10 GMT <alfbot> Title: Alfresco » Information System for Training Organization (at ccexamples.nomagic.com:8080)

2017-04-28 14:26:26 GMT <Modestas> this is alfresco with cameo collaborator

2017-04-28 14:27:00 GMT <Modestas> and one of the views & viewPoints template is Software

2017-04-28 14:33:53 GMT <douglascrp> Modestas, yes, I am in

2017-04-28 14:35:32 GMT <douglascrp> Modestas, are all the relations, links, saved as nodes?

End of Daily Log

The other logs are at http://esplins.org/hash_alfresco