Comments (13)
whulshof
commented on July 19, 2024
Would the pull request also work on 10.0 or do I have to modify it? Probably dumb question, but I don't have the time right now to look into it and I do have trouble with huge amount of sessions. I could do some of the thorough testing as mentioned by @guewen though.
from queue.
guewen
commented on July 19, 2024
@whulshof I ported the pull request here: #53
I'd love your feedback :)
from queue.
sbidoul
commented on July 19, 2024
@guewen do you have good results with this in production? We'll probably deploy it too.
from queue.
whulshof
commented on July 19, 2024
@guewen thanks a lot. Will deploy right away and tell you!
Met vriendelijke groet/Kind regards,
Magnus Red
Willem Hulshof
+31 88 696 60 00 | +31 651 243 710 | www.magnus.nl<http://www.magnus.nl/red/>
[id:4FD331F6-E3AE-4679-826C-9D6015959C97]
Van: Guewen Baconnier <[email protected]>
Beantwoorden - Aan: OCA/queue <[email protected]>
Datum: donderdag 8 februari 2018 om 12:17
Aan: OCA/queue <[email protected]>
CC: Willem Hulshof <[email protected]>, Mention <[email protected]>
Onderwerp: Re: [OCA/queue] One anonymous session opened per job run (#44)
@whulshof<https://github.com/whulshof> I ported the pull request here: #53<#53>
I'd love your feedback :)
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub<#44 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AK1rqZHj1fSnnaLZxRaLcu2LxyPgJNZTks5tStezgaJpZM4RLBL8>.
from queue.
guewen
commented on July 19, 2024
do you have good results with this in production? We'll probably deploy it too.
@sbidoul Yes! So far so good. It helps a lot to keep a low number of sessions and we didn't had any side effects (at least observed) :)
@whulshof could you give it a try?
from queue.
whulshof
commented on July 19, 2024
It is a pity, that I just installed it in Test and we went live so test is not used that much. But I’m thinking about production, because I have 3000 sessions now, which is rather high for a maybe 100 named users system. On the other hand, it shouldn’t be noticeable in the system. I’ll try it tonight.
Met vriendelijke groet/Kind regards,
Magnus Red
Willem Hulshof
+31 88 696 60 00 | +31 651 243 710 | www.magnus.nl<http://www.magnus.nl/red/>
[id:4FD331F6-E3AE-4679-826C-9D6015959C97]
Van: Guewen Baconnier <[email protected]>
Beantwoorden - Aan: OCA/queue <[email protected]>
Datum: dinsdag 6 maart 2018 om 11:34
Aan: OCA/queue <[email protected]>
CC: Willem Hulshof <[email protected]>, Mention <[email protected]>
Onderwerp: Re: [OCA/queue] One anonymous session opened per job run (#44)
do you have good results with this in production? We'll probably deploy it too.
@sbidoul<https://github.com/sbidoul> Yes! So far so good. It helps a lot to keep a low number of sessions and we didn't had any side effects (at least observed) :)
@whulshof<https://github.com/whulshof> could you give it a try?
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub<#44 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AK1rqYJzc5F717Gi9d4ngOGB7ylt6aGLks5tbmYkgaJpZM4RLBL8>.
from queue.
sbidoul
commented on July 19, 2024
@Cedric-Pigeon if not done yet, can you deploy this in production and report your findings?
from queue.
whulshof
commented on July 19, 2024
@sbidoul and @guewen After running for a day with 240 queue.jobs sessions remain at 50-60, which is to be expected. No side-effects until now.
Question: would it be possible that large number of sessions lead to more used connections to postgres and therefor possible overshoot in max-connections?
Met vriendelijke groet/Kind regards,
Magnus Red
Willem Hulshof
+31 88 696 60 00 | +31 651 243 710 | www.magnus.nl<http://www.magnus.nl/red/>
[id:4FD331F6-E3AE-4679-826C-9D6015959C97]
Van: Guewen Baconnier <[email protected]>
Beantwoorden - Aan: OCA/queue <[email protected]>
Datum: dinsdag 6 maart 2018 om 11:34
Aan: OCA/queue <[email protected]>
CC: Willem Hulshof <[email protected]>, Mention <[email protected]>
Onderwerp: Re: [OCA/queue] One anonymous session opened per job run (#44)
do you have good results with this in production? We'll probably deploy it too.
@sbidoul<https://github.com/sbidoul> Yes! So far so good. It helps a lot to keep a low number of sessions and we didn't had any side effects (at least observed) :)
@whulshof<https://github.com/whulshof> could you give it a try?
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub<#44 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AK1rqYJzc5F717Gi9d4ngOGB7ylt6aGLks5tbmYkgaJpZM4RLBL8>.
from queue.
guewen
commented on July 19, 2024
Question: would it be possible that large number of sessions lead to more used connections to postgres and therefor possible overshoot in max-connections?
I don't think. I don't see any way web sessions and postgres connections would be related.
from queue.
guewen
commented on July 19, 2024
Thank you for your feedback @whulshof!
from queue.
whulshof
commented on July 19, 2024
I still have quite high numbers of sessions generated. After not monitoring for a month the number was some 8000 (!). After deletion and in a few days with a lot of Job Queue activity, the number again increased from 0 to 2000 sessions whereas there are some 50-100 human users. I get the feeling we didn't really solve this problem yet. @guewen @sbidoul any second thoughts about it?
from queue.
guewen
commented on July 19, 2024
@whulshof Are you sure they are not generated by something else, such as a healthcheck or uptime check?
On a production system with the patch applied since a couple of months, the session count stays slow.
2039 sessions at the moment, with 1'132'203 jobs the last 30 days
from queue.
whulshof
commented on July 19, 2024
@guewen I’m not sure, but in max one week and only a fraction of your number of jobs the number of anonymous sessions is 1400.
Met vriendelijke groet/Kind regards,
Magnus Red
Willem Hulshof
+31 88 696 60 00 | +31 651 243 710 | www.magnus.nl<http://www.magnus.nl/red/>
[id:4FD331F6-E3AE-4679-826C-9D6015959C97]
Van: Guewen Baconnier <[email protected]>
Beantwoorden - Aan: OCA/queue <[email protected]>
Datum: dinsdag 15 mei 2018 om 14:07
Aan: OCA/queue <[email protected]>
CC: Willem Hulshof <[email protected]>, Mention <[email protected]>
Onderwerp: Re: [OCA/queue] One anonymous session opened per job run (#44)
@whulshof<https://github.com/whulshof> Are you sure they are not generated by something else, such as a healthcheck or uptime check?
On a production system with the patch applied since a couple of months, the session count stays slow.
2039 sessions at the moment, with 1'132'203 jobs the last 30 days
[selection_287]<https://user-images.githubusercontent.com/417223/40055712-2addcf6a-5849-11e8-9e2d-826dded756d3.png>
[selection_288]<https://user-images.githubusercontent.com/417223/40055713-2af613d6-5849-11e8-832a-bda687556b06.png>
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub<#44 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AK1rqbW2L8TFrmh-Z18Dg6Bs6nwUyLtVks5tysTigaJpZM4RLBL8>.
from queue.
Related Issues (20)
- [16.0][queue_job] "base_sparse_field" is missing on Odoo 16 HOT 2
- Random message: Unable to use a closed cursor HOT 2
- chain() doesn't work as advertised (or am I misunderstanding something?) HOT 1
- Serialise job-graphs onto the database HOT 3
- [V16-queue_job] Problems with multiple databases
- Disable queue_job in staging env HOT 2
- Question: Is it possible to modify an existing queue.job chain? HOT 2
- The job runner does not understand cancelled jobs HOT 7
- Controller method fails HOT 8
- why run with with_delay can not get the new field。。。。？？？？ ValueError: Invalid field 'job_title' on model 'hdjn_oa.employee_ext' HOT 1
- [QUESTION] About channels HOT 1
- Error with PgBouncer HOT 6
- OperationalError, but progress is saved and job is repeated couple more times
- KeyError: 'socket' After install queue.job in odoo 16.0 HOT 9
- [14.0] identity_exact not working w/ chained jobs? HOT 6
- installation not possible in odoo 16 HOT 2
- Since Odoo 15.0 environment.manage is useless warning from migration script in queue_job HOT 2
- Assigning delayable variable to another variable breaks delayable HOT 1
- queue_job_cron_jobrunner for v13 HOT 3
- Cannot install queue_job on odoo 16/windows (OSError: [WinError 10038] An operation was attempted on something that is not a socket) HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from queue.