IRC logs of #tryton for Friday, 2014-02-28

chat.freenode.net #tryton log beginning Fri Feb 28 00:00:01 CET 2014
-!- pekka1(~pekka@cm-84.210.54.188.getinternet.no) has joined #tryton00:41
-!- digitalsatori(~Thunderbi@116.234.234.90) has joined #tryton01:04
-!- cedk(~ced@2001:6f8:3aa:1:10ec:9f63:ed26:39f8) has joined #tryton01:06
-!- cedk(~ced@85.26.36.239) has joined #tryton01:11
-!- flox(~florent@unaffiliated/flox) has joined #tryton01:48
-!- woakas1(~woakas@static.13.240.46.78.clients.your-server.de) has joined #tryton01:50
-!- gremly(~gremly@190.85.36.58) has joined #tryton01:57
-!- digitalsatori(~Thunderbi@116.234.234.90) has joined #tryton01:59
-!- udono1(~udono@ip-176-199-172-145.unitymediagroup.de) has joined #tryton02:04
-!- rafiu(~Adium@host81-139-178-190.in-addr.btopenworld.com) has joined #tryton02:06
-!- myrdd`(~myrdd@55d422c9.access.ecotel.net) has joined #tryton02:15
-!- rafiu1(~Adium@host81-139-178-190.in-addr.btopenworld.com) has joined #tryton02:25
-!- gremly(~gremly@190.85.36.58) has joined #tryton02:30
-!- digitalsatori(~Thunderbi@116.234.234.90) has joined #tryton03:28
-!- udono(~udono@ip-88-152-168-173.unitymediagroup.de) has joined #tryton03:40
-!- plantian1(~ian@174.135.6.172) has joined #tryton05:35
-!- yangoon1(~mathiasb@p549F0C0A.dip0.t-ipconnect.de) has joined #tryton06:06
-!- frispete_(~frispete@p54A9370C.dip0.t-ipconnect.de) has joined #tryton06:41
-!- LordVan(~LordVan@gentoo/developer/LordVan) has joined #tryton07:07
-!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton07:38
-!- jvblasco(~seba@62.43.196.37.static.user.ono.com) has joined #tryton08:33
-!- jeancavallo(~giovanni@LVelizy-156-46-68-52.w80-12.abo.wanadoo.fr) has joined #tryton08:39
-!- pjstevns(~Thunderbi@2001:981:7170:1:a8b1:db7e:7673:8995) has joined #tryton08:59
-!- cons1L1(d9569fa4@gateway/web/freenode/ip.217.86.159.164) has joined #tryton09:00
-!- nicoe(~nicoe@22.78-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton09:02
-!- pokoli(~pokoli@unaffiliated/pokoli) has joined #tryton09:17
jvblascoguys i'm having load and iowait peaks in a tryton server instance09:24
jvblascocentos with postgres from their repo09:25
jvblascoand tryton running in a virtualen with supervisor09:25
jvblascoi think postgres may be de culprit here09:25
jvblascoany tip for a postgres server tunning?09:26
jvblascoi form of documentation09:26
jvblascoin form*09:26
-!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has joined #tryton09:27
pokolijvblasco: maybe this article on postgresql wiki is usefull for you https://wiki.postgresql.org/wiki/Performance_Optimization09:28
pokolijvblasco: have you incresed the memory of PostgreSQL? default settings are quite conservative09:29
-!- littlebit(~Thunderbi@ulmg-5d846fcf.pool.mediaWays.net) has joined #tryton09:44
jvblascopokoli: i didn't, i found a python script called pgtune but i don't know how reliable it is10:10
jvblascopokoli: btw i think it may be the shared memory as u are saying, cause ppl complains about psql performance in openVZ and it seems the shared memory is the culprit10:11
jvblascopokoli: https://github.com/gregs1104/pgtune#readme10:12
-!- cedk(~ced@85.26.36.239) has joined #tryton10:12
pokolijvblasco: I will prefer doing it manualy instead of using such script :P10:28
jvblascopokoli: i will try with the script first as i need to suffocate the fire, i will need to read that wiki page though this weekend for fine tunning and gaining control over it10:35
cedkI find running postgresql on a virtual host, not very performant10:36
cedkI think it requires a lot of tunning to be good as on bare metal10:36
cedkalso I always advise to run trytond and pg on the same host10:37
jvblascothey are on the same "host"10:40
jvblascoi think i have some problems with memory tunning10:41
jvblascoalso the machine is 1GB RAM in an openVZ instance10:41
jvblascobut the postgres is killing the hypervisor with iowait and load peaks10:41
jvblascoif we find that opportunity cost for tunning that postgres to be there without killing the hypervisor is very high, we will do some basic tunning and move to another technology like VMWare or OpenStack10:43
cedkjvblasco: hahahah bare metal!10:44
jvblascothe thing is that an out of load tryton (just a cron action every 5 mins attacking pingdom API) was killing the hypervisor, and my guess is postgres, not tryton10:44
pokolijvblasco: can I ask you about database size?10:47
jvblascopokoli: almost empty10:47
pokolijvblasco: I have run a 6GB on my laptop with postgresql default settings10:51
pokolijvblasco: and no run iowait and load peaks10:52
pokolijvblasco: so mabe the problem is how openVZ handles files10:53
jvblascopokoli: i also had tenloahora oversized and didn't run into any issues. But that machine is really limited10:58
jvblascopokoli: btw i think openVZ is doing some magic in the problem too10:58
-!- Telesight(~anthony@77-175-168-222.FTTH.ispfabriek.nl) has joined #tryton11:00
-!- mariomop(~quassel@181.110.66.240) has joined #tryton11:52
-!- cons1L1(d9569fa4@gateway/web/freenode/ip.217.86.159.164) has joined #tryton12:20
-!- hiaselhans(~hiaselhan@212.186.35.254) has joined #tryton12:26
-!- smarro(~sebastian@190.105.85.74) has joined #tryton12:28
-!- sharoonthomas(~sharoonth@115.243.127.100) has joined #tryton12:33
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton12:35
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton12:38
hiaselhanshi there, heres the guy filing some of those silly bug reports some time ago...13:10
hiaselhanssorry for that, but after playing around a bit with reports, i found it convenient to have the translation context inheritent aswell13:11
hiaselhansso i added those few lines.. should i provide a patch for that (only a few lines) or is it not of interest maybe?13:11
udonohiaselhans: hi, I don't understand13:12
hiaselhansi inherited some report from companyreport for example13:13
hiaselhansand set my name to something.something13:13
hiaselhansand in order not to provide all translation context but use the one from sale.sale instead i have to call TranslationFactory with a different class property13:14
hiaselhansother than __name__ which is something.something :)13:15
udonohiaselhans: if you think your patch could be interesting for someone else, just send it to the tryton-contrib  group. If you think it should be included in main tryton, file an issue and fight your codereview ;-)13:18
udonohiaselhans: https://groups.google.com/forum/#!forum/tryton-contrib13:19
hiaselhansthanks, ill just use the mailinglist :)13:22
-!- pjstevns(~Thunderbi@2001:981:7170:1:a8b1:db7e:7673:8995) has left #tryton13:25
-!- hyances(~humberto@181.141.36.235) has joined #tryton13:38
-!- pablovannini(~pablo@181.47.176.42) has joined #tryton14:06
-!- sharoonthomas(~sharoonth@115.244.8.152) has joined #tryton15:53
-!- zodman(~zodman@50.115.163.209) has joined #tryton16:16
-!- smarro(~sebastian@181.47.135.16) has joined #tryton16:19
-!- littlebit(~Thunderbi@ulmg-5d846fcf.pool.mediaWays.net) has joined #tryton16:38
-!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton16:43
-!- digitalsatori(~Thunderbi@114.92.199.176) has joined #tryton17:29
-!- smarro_(~sebastian@host100.190-136-175.telecom.net.ar) has joined #tryton17:48
-!- smarro(~sebastian@host100.190-136-175.telecom.net.ar) has joined #tryton17:52
-!- hyances(~humberto@181.141.36.235) has joined #tryton17:58
-!- lukio(~lukio@181.47.176.42) has joined #tryton18:00
-!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has left #tryton18:14
-!- digitalsatori(~Thunderbi@114.92.199.176) has joined #tryton18:28
-!- lukio(~lukio@181.47.176.42) has left #tryton18:31
-!- littlebit(~Thunderbi@ulmg-5d846fcf.pool.mediaWays.net) has joined #tryton18:43
-!- cedk(~ced@85.26.36.239) has joined #tryton18:50
-!- zodman(~zodman@50.115.163.209) has joined #tryton18:50
-!- mariomop(~quassel@181.110.66.240) has joined #tryton18:52
-!- sisalp(~sisalpuse@gratoox.sisalp.net) has joined #tryton18:54
-!- zodman(~zodman@50.115.163.209) has joined #tryton19:02
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton19:15
-!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton19:38
-!- pablovannini(~pablo@181.47.176.42) has joined #tryton21:22
-!- hyances(~humberto@181.141.36.235) has joined #tryton21:52
-!- zodman(~zodman@50.115.163.209) has joined #tryton23:30
-!- zodman(~zodman@50.115.163.209) has joined #tryton23:39
-!- ArtGravity(~artgravit@2602:47:d89d:b600:7003:f174:5b10:713b) has joined #tryton23:43

Generated by irclog2html.py 2.11.0 by Marius Gedminas - find it at mg.pov.lt!