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-09-15 07:14:43 GMT <DarkStar1> Good morning everyone

2017-09-15 07:21:28 GMT <yreg> Morning everyone !

2017-09-15 07:21:32 GMT <yreg> Morning Lanre

2017-09-15 08:54:24 GMT *** angelborroy_ is now known as angelborroy

2017-09-15 10:23:33 GMT <mp_> hello

2017-09-15 10:24:34 GMT <mp_> have question abot hard/soft links - scriptNode.addNode() create relations that is analogue of hard link?! how create something simmilar to softlink?

2017-09-15 10:43:32 GMT <AFaust> mp_: Alfresco really doesn't have something that can be considered a "soft link", e.g. that links only based on path and not a reference. Basically Alfresco has a "consistent, transparent hard link" and a "breakable, proxy hard link". With addNode() you are creating the first. The second type is possible by creating a node of type cm:link that has a property cm:destination that refers to the identity of the target.

2017-09-15 10:44:37 GMT <AFaust> The advantage of the second type is that you can restrict the visibility on the link separately from the permissions of the actual target, e.g. you can add additional restrictions that you might not want to set on the target itself.

2017-09-15 10:45:02 GMT <mp_> I

2017-09-15 10:46:16 GMT <mp_> I trying find the way to block removing original node form the not primary parent( not sure decription will help)

2017-09-15 10:46:55 GMT <mp_> But tnx. Your explanation have clarifyed fiew points for me

2017-09-15 12:40:52 GMT *** hobzalud is now known as nsoft

2017-09-15 12:42:38 GMT *** hobzalud is now known as tar

2017-09-15 12:44:06 GMT *** DragiBus_ is now known as DragiBus

2017-09-15 13:05:00 GMT <douglascrp> good morning

2017-09-15 13:08:05 GMT <DarkStar1> douglascrp: howdy

2017-09-15 13:08:17 GMT <MTielemans> hey there

2017-09-15 13:14:28 GMT <douglascrp> DarkStar1, fine

2017-09-15 13:14:30 GMT <douglascrp> you?

2017-09-15 14:07:47 GMT <DarkStar1> douglascrp: Hey dude. Sorry for the late response. I'm quite busy here.

2017-09-15 14:08:27 GMT <DarkStar1> but I do have to go now. :(

2017-09-15 14:08:36 GMT <DarkStar1> douglascrp: will ping uou later on WA

2017-09-15 14:33:11 GMT <MTielemans> ~since

2017-09-15 14:33:11 GMT <alfbot> MTielemans: Either MTielemans didn't leave, or no messages were sent while MTielemans was gone.

2017-09-15 15:55:57 GMT <eswbitto> I'm getting a server error that the DB connection pool is depleted.

2017-09-15 15:56:52 GMT <eswbitto> Would changing the settings in alfresco-global.properties create any issues with regard? to something much higher than 275

2017-09-15 16:03:05 GMT <yregaieg> eswbitto, as long as your DB server can handle that many connection (spec + config) it should be fine

2017-09-15 16:04:00 GMT <eswbitto> yregaieg what spec just number of cpu's?

2017-09-15 16:05:06 GMT <yregaieg> it is good practice to set the pool size to the maximum number of threads that theoretically can co-exist on your instance on a certain point in time (max number of HTTP worker threads + max number of async actions + max number of worker threads in scheduled jobs ... etc)

2017-09-15 16:05:57 GMT <yregaieg> eswbitto, you can not expect a server with 2 CPUs and 4 G of ram to be able to handle 10000 connections simultaneously, your hard need to be able to survive the load

2017-09-15 16:06:31 GMT <yregaieg> plus depending on DB server there should be some config to set the maximum number of connections

2017-09-15 16:06:51 GMT *** yregaieg is now known as yreg

2017-09-15 16:09:38 GMT <eswbitto> I have 8 cpu's and 18 GB of total Ram on the server...I have 12 GB set for java

2017-09-15 16:10:14 GMT <yreg> was referring to the hard for DB server not application server, or is it the same host ?

2017-09-15 16:10:33 GMT <eswbitto> its on the same host.....its the built in postgresql

2017-09-15 16:10:51 GMT <yreg> not a good idea if you want to scale up

2017-09-15 16:11:05 GMT <eswbitto> hmm

2017-09-15 16:11:21 GMT <eswbitto> so I should move my DB server to another host?

2017-09-15 16:12:32 GMT <eswbitto> yreg the problem I'm running into is that the growth is rapidly overtaking the available hardware.

2017-09-15 16:12:59 GMT <yreg> not sure what is the default setting for maximum number of connections on shipped postgres, but by default docs says it is 100

2017-09-15 16:13:25 GMT <yreg> https://www.postgresql.org/docs/9.6/static/runtime-config-connection.html

2017-09-15 16:13:26 GMT <alfbot> Title: PostgreSQL: Documentation: 9.6: Connections and Authentication (at www.postgresql.org)

2017-09-15 16:14:19 GMT <yreg> eswbitto, could it be that postgres max_connections is the real limitation

2017-09-15 16:14:55 GMT <eswbitto> yreg well I didn't change the max_connections setting in the alfresco-global.properties I left it when I did the install

2017-09-15 16:15:28 GMT <yreg> max_connections should be on the postgres side of things

2017-09-15 16:15:29 GMT <eswbitto> yreg I want to start there and raise the limit, but finding a good number will be tricky I think.

2017-09-15 16:15:33 GMT <fwu> hello all

2017-09-15 16:15:36 GMT <MarkTielemans> hi

2017-09-15 16:15:37 GMT <yreg> not alfresco-global.properties

2017-09-15 16:16:14 GMT <eswbitto> yreg you wouldn't configure postgres settings there?

2017-09-15 16:17:32 GMT <yreg> eswbitto, AFAIK postgres is not even aware that it is serving alfresco

2017-09-15 16:17:50 GMT <yreg> how would it pick up config enteries from an alfresco config file ?

2017-09-15 16:19:13 GMT <eswbitto> yreg well I thought that alfresco-global.properties was the one config file where you would make "most" of your config changes. Its a little confusing to have config setup there in the default.

2017-09-15 16:19:19 GMT <yreg> eswbitto, check for instance https://stackoverflow.com/a/32584211/2307988

2017-09-15 16:19:20 GMT <alfbot> Title: postgresql - How to increase the max connections in postgres? - Stack Overflow (at stackoverflow.com)

2017-09-15 16:20:00 GMT <yreg> eswbitto, it is, for the alfresco side of things, but definitely not for DB, not for Share, not for Solr !

2017-09-15 16:20:18 GMT <yreg> HEy MarkTielemans !

2017-09-15 16:20:29 GMT <eswbitto> yreg good to know...

2017-09-15 16:27:49 GMT <yreg> I was browsing around the alfresco SVN and couldn't find any customization to the OOTB postgres max_connections, so your alfresco must be trying to create new connections but is getting blocked by DB server limitation

2017-09-15 16:28:25 GMT <eswbitto> yreg I looked the postgres.conf and the max connections is set at 300 with the buffer set at 128mB

2017-09-15 16:28:49 GMT <eswbitto> that is default cause I haven't messed with this config file

2017-09-15 16:29:30 GMT <yreg> ok then if you increase the value on the alfresco side, you need to make sure the same increase reflect on postgres side

2017-09-15 16:32:01 GMT <eswbitto> yreg so alfresco side defaults to 275 postgres defaults to 300 I guess they didn't want to utilize the full amount maybe?.....Too early on a Friday to contemplate that....So I think the next step if finding that magic number that doesn't destroy alfredo

2017-09-15 16:32:46 GMT <yreg> eswbitto, I suppose there is a reserved number of connections on postgres side for super user in order to do maintainance tasks .. etc

2017-09-15 16:33:07 GMT <eswbitto> yreg that makes sense

2017-09-15 16:33:08 GMT <fwu> ppl, in a java web script, im trying to write to the log file using System.out.println but nothing is written. Why may be this happening?

2017-09-15 16:33:17 GMT <yreg> eswbitto, check the superuser_reserved_connections config entry in postgres.conf

2017-09-15 16:33:58 GMT <eswbitto> the default is 3, but its not enabled.

2017-09-15 16:35:19 GMT <yreg> fwu, AFAIK you need to properly use apache common logging https://github.com/Alfresco/community-edition-old/blob/2c1eff9953d3105e738f7b06ba9ba8a079ca4c24/projects/web-client/source/java/org/alfresco/web/app/servlet/AuthenticationHelper.java#L101 fo example

2017-09-15 16:35:20 GMT <alfbot> Title: community-edition-old/AuthenticationHelper.java at 2c1eff9953d3105e738f7b06ba9ba8a079ca4c24 · Alfresco/community-edition-old · GitHub (at github.com)

2017-09-15 16:35:57 GMT <yreg> what you are using now is considered a quick and dirty way of spitting messages to stdout

2017-09-15 16:36:25 GMT <fwu> yreg, yes I know, I just want to make a first debug. I then replace it.

2017-09-15 16:36:38 GMT <fwu> let me see the link. thank you

2017-09-15 16:37:27 GMT <eswbitto> yreg ok so I understand the correlation between postgres max connections and alfresco's as well....I don't believe I need to change the shared_buffers because that is just the amount of memory given to each connection right?

2017-09-15 16:38:12 GMT <yreg> eswbitto, I haven't checked, just guessing, might be as well a reserved number of connections for all kinds of other stuff (alfresco analytics, Desktop sync ... at least these two are known to require direct connection to DB) it might as well be something else

2017-09-15 16:38:33 GMT <yreg> I am not a DB expert, but I assume what you are saying is right

2017-09-15 16:40:16 GMT <eswbitto> yreg no worries...I will look into making these changes...if you want me to follow up with you I can just for poops and giggles......The one big gripe I have is that...I have a staging server that is identical to production, but I don't get the same usage from users to trouble shoot and fix on staging rather than a live server.

2017-09-15 17:00:08 GMT <fwu> ppl, is there any difference/problem making this in 5.2: "extends AbstractWorkflowWebscript"

2017-09-15 17:00:35 GMT <fwu> I used to do this in 4.2.f to implement a java backed webscript, but now it seems it is not working

2017-09-15 17:07:29 GMT <fwu> while extending the abstractworkflowwebscript I can reach the workflowService

2017-09-15 17:07:40 GMT <fwu> in a declarative webscript, can I also get it?

End of Daily Log

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