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

2019-07-11 09:44:47 GMT <alfresco-discord> <mbui> How is the XML payload for associations formatted using CMIS? For example properties is: <cmis:propertyString propertyDefinitionId=":employeeAge" displayName="Age" localName="employeeAge" queryName="mu:employeeAge"> <cmis:value>35</cmis:value> </cmis:propertyString>

2019-07-11 10:36:11 GMT <alfresco-discord> <mbui> Reasoning for my question is that when creating a node of a custom type, it has a mandatory association. So is it possible (and how?) to create a node with an association (relationship) ?

2019-07-11 10:49:33 GMT <angelborroy> (Alfresco) CMIS does not support creating custom associations

2019-07-11 10:59:20 GMT <AFaust> Damn.... just had to deal with a very extreme corner case bug in Alfresco startup...

2019-07-11 11:02:35 GMT <AFaust> This specifically was an issue in a Docker-ized environment because the IP of the Docker container had changed (due to docker-compose down + up re-creating the network, which got a different IP range)

2019-07-11 11:04:53 GMT <AFaust> When the startup is not an Alfresco upgrade, but includes a module upgrade with an associated module component that needs to be run...

2019-07-11 11:05:38 GMT <AFaust> And that module component needs to run a batch processor to patch some data or otherwise need to create its own transaction...

2019-07-11 11:06:10 GMT <AFaust> Then you can run into a database deadlock on startup, IF the IP of the server is not already stored in the alf_server table

2019-07-11 11:07:50 GMT <AFaust> This is caused by Alfresco having an outer transaction open where they have already inserted a new alf_server entry but have not yet committed it, and your inner transaction(s) also attempt to insert such an entry, in order to link it to the alf_transaction table for tracking their changes.

2019-07-11 11:09:00 GMT <AFaust> This has never been an issue with the "legacy" deployment methods, but with Docker / Kubernetes, this could happen to some people over time...

2019-07-11 11:09:36 GMT <AFaust> (unless you start pinning your internal container IPs, which is a bad practice as far as I understand)

2019-07-11 11:09:56 GMT <angelborroy> Probably you can raise an issue for that

2019-07-11 11:10:08 GMT <angelborroy> I’ll try to promote it in order to be fixed

2019-07-11 11:19:20 GMT <AFaust> I'll look into reproducing that in a local 6.1 environment with a trivial example first...

2019-07-11 11:20:05 GMT <AFaust> This just now happened during a deployment in a production environment, which was really annoying since time was of the issue and there was nothing set up to quickly debug the issue.

2019-07-11 11:20:34 GMT <alfresco-discord> <mbui> angelborroy: You can't create a relationship (association) between two nodes via CMIS?

2019-07-11 11:20:45 GMT <angelborroy> afaik, no

2019-07-11 11:21:48 GMT <AFaust> Ehm... you should be able to. Relationships are a key part of the CMIS type model.

2019-07-11 11:23:01 GMT <AFaust> And there is a createRelationships implementation in AlfrescoCmisServiceImpl (the server side backend to CMIS)

2019-07-11 11:23:46 GMT <AFaust> There are even references to JIRA issues / bugfixes in the comments, suggesting that this feature is used by some...

2019-07-11 11:24:36 GMT <AFaust> The only thing you can't do is create the relationship in the same transaction as the node.

2019-07-11 11:24:46 GMT <AFaust> That is the problem mbui is facing which he cannot overcome.

2019-07-11 11:24:50 GMT <angelborroy> Also I think that custom associations are not supported

2019-07-11 11:25:24 GMT <angelborroy> I was talking about these ones

2019-07-11 11:25:36 GMT <AFaust> Of course custom associations are supported. There are no "default CMIS associations", so without custom associations, there would be nothing to do with that feature.

2019-07-11 11:26:01 GMT <angelborroy> good to know

2019-07-11 11:28:08 GMT <angelborroy> So the limitation is that you cannot query for associations, right?

2019-07-11 11:29:49 GMT <AFaust> You cannot query for them, and you cannot create them in the same transaction as the node, so you cannot use mandatory associations

2019-07-11 11:30:06 GMT <AFaust> And "query" as in CMIS QL - of course you can retrieve them

2019-07-11 11:58:57 GMT <alfresco-discord> <mbui> Thanks for clearing that up AFaust

2019-07-11 14:06:06 GMT <AFaust> angelborroy: https://issues.alfresco.com/jira/browse/ALF-22091

2019-07-11 14:18:59 GMT <angelborroy> I guess this is also happening in k8s

2019-07-11 14:19:17 GMT <AFaust> I would expect so

2019-07-11 14:20:41 GMT <angelborroy> Just not to get a “Docker Compose” is not supported

2019-07-11 14:20:48 GMT <AFaust> I mean, I am sort of expecting k8s deployment for Alfresco Enterprise to suffer from various issues resulting from dynamic container host names / IPs.

2019-07-11 14:22:08 GMT <AFaust> Since those addresses are registered in the database as part of the cluster functionality and used for communication attempts by other servers, never cleared and thus just accumulate. I expect cluster startup to slow down over time as more and more obsolete addresses are stored in the database

2019-07-11 14:22:45 GMT <AFaust> angelborroy: I mean, I phrased the issue to be mostly generic, and only used Docker Compose as a demonstrator.

2019-07-11 14:23:15 GMT <AFaust> The same problem would occur in a legacy deployment as well, if you moved your ACS instance to another server instead of stopping/restarting your Compose deployment.

2019-07-11 14:23:33 GMT <angelborroy> Right

2019-07-11 14:23:38 GMT <angelborroy> But better to be explicit :D

2019-07-11 14:26:31 GMT <AFaust> There, also adapted my description

2019-07-11 15:05:03 GMT <angelborroy> AFaust can you explain further that “query as CMIS QL can retrieve relationships”

2019-07-11 15:05:23 GMT <angelborroy> I’m working on a sample to deal with relationships in CMIS

2019-07-11 15:05:43 GMT <AFaust> Well, you cannot query for associations using CMIS QL obviously, because it is not part of the query language.

2019-07-11 15:05:51 GMT <angelborroy> ah, ok

2019-07-11 15:05:56 GMT <AFaust> But you can retrieve associations via the regular CMIS services.

2019-07-11 15:06:02 GMT <angelborroy> right

2019-07-11 15:06:04 GMT <angelborroy> Thanks

2019-07-11 15:06:08 GMT <AFaust> Just like you can't query for associations via FTS but can still use NodeService

2019-07-11 15:35:17 GMT <alfresco-discord> <LuisColorado> Has anybody used the bulk import tool (the one included with Alfresco), just to notice that no permissions have been set? The nodes in Share say "No permissions set"

2019-07-11 15:36:24 GMT <alfresco-discord> <LuisColorado> Not sure if this nodes were created using the Bulk Import Tool or CMIS. I don't think that CMIS would create nodes with no permissions, right?

2019-07-11 22:17:17 GMT <alfresco-discord> <edw24> Is there a way to upload a file using the alfresco ootb api with it's binary content without persisting the file to disk?

2019-07-11 22:32:26 GMT <AFaust> Why would you want to upload a file to Alfresco without persisting it to disk?

End of Daily Log

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