/srv/irclogs.ubuntu.com/2012/10/16/#launchpad-dev.txt

=== matsubara is now known as matsubara-afk
wallyworld_wgrant: there's a couple of criticals for timeouts doing the most simple updates to the bug table eg update bug set description = "blah" where id = 234. that took 8s. we should be able to close these as a one off you think?02:22
wgrantwallyworld_: Not for writes, no02:25
wgrantwallyworld_: Long trivial reads are The Glitchâ„¢, but writes tend to be locks02:25
wgrantWhich are a real issue that warrants investigation02:25
wallyworld_difficult given how infrequently it seems to happen02:26
wgrantWell02:26
wgrantWe can put in place monitoring02:26
wgrantTo track down long invasive locks02:26
wgrantBut indeed.02:26
wallyworld_and it seems sporadic - 3 bugs, 3 different single inserts, 3 different tables02:27
wgrantWhich bugs?02:27
wallyworld_bug 105985302:27
_mup_Bug #1059853: BugTask:+editstatus timeout blocked on bug update setting heat <timeout> <Launchpad itself:Triaged> < https://launchpad.net/bugs/1059853 >02:27
wgrantOften we'll have multiple OOPSes02:27
wallyworld_bug 104898402:27
wgrantWhich suggest it's not just The Glitch02:27
_mup_Bug #1048984: BugTask:+edit timeout <timeout> <Launchpad itself:Triaged> < https://launchpad.net/bugs/1048984 >02:27
wgrantBut obviously writes *can* be affected by The Glitch too02:27
wallyworld_bug 102810502:28
_mup_Bug #1028105: BugTask:+editstatus slow inserting BugMessage <bugs> <timeout> <Launchpad itself:Triaged> < https://launchpad.net/bugs/1028105 >02:28
wgrantSo, all of those could conceivably be long Person locks02:28
wallyworld_how is updating a bug description affected by a person lock?02:29
wgrantAh, true, the description change couldn't be affected02:31
wgrantBut the BugMessage one probably is02:31
wgrantDue to the FK to person02:31
wgrantIf you're inserting a new row, or changing the value of the owner column, it will conflict with a write lock on the referenced person row02:31
wallyworld_do we know what holds long write locks on Person?02:32
wgrantBut the UPDATE Bug SET date_last_updated=%s, description=%s WHERE Bug.id = %s; can indeed not be affected by that02:32
wgrantIt must be either a glitch or a lock on the bug row itself02:32
wgrantAll three could be explained by a lock on the bug row.02:32
wallyworld_sure. finding out what is the root cause will be difficult02:32
=== almaisan-away is now known as al-maisan
=== al-maisan is now known as almaisan-away
=== almaisan-away is now known as al-maisan
adeuringgood morning07:28
=== frankban changed the topic of #launchpad-dev to: http://dev.launchpad.net/ | On call reviewer: frankban | Firefighting: - | Critical bugs: ~260
=== rick_h_ changed the topic of #launchpad-dev to: http://dev.launchpad.net/ | On call reviewer: frankban, rick_h | Firefighting: - | Critical bugs: ~260
=== al-maisan is now known as almaisan-away
=== matsubara-afk is now known as matsubara
sinzuijcsackett, do you have time to hangout14:12
jcsackettsinzui: sure, give me a moment to locate my phone.14:12
abentleysinzui: Do you know whether the ProductReleaseFinder should consider non-public products?14:23
rick_h_abentley: r=me but didn't mark approve since you mentioned some stray test failures in the stand up14:25
abentleyrick_h_: Thanks.  I've nailed down most of the test failures now, just got ProductReleaseFinder to worry about.14:25
rick_h_abentley: k14:26
sinzuiabentley, I am confident that the answer is no14:29
abentleysinzui: Thanks.14:29
sinzuiabentley, I don't think they should be permitted to have releases...but that can be debated. they should not be permitted to have a release_file_glob.14:30
adeuringfrankban, rick_h_: could one of you please review this MP: https://code.launchpad.net/~adeuring/launchpad/milestone-sec-adapter/+merge/129907 ?14:31
rick_h_adeuring: sure thing, will take a look14:32
rick_h_adeuring: is the QA on the other branch all ok?14:32
abentleyrick_h_: I've pushed r16113, which has no known test failures.14:32
adeuringrick_h_: just marked it as OK14:32
rick_h_adeuring: awesome thanks14:32
adeuringrick_h_: ...and I noticed a bunch of merge conflicts in the new branch...14:32
rick_h_adeuring: in the milestone one?14:33
adeuringrick_h_: yes14:33
rick_h_adeuring: ok cool, will work on getting the deploy done while you peek at that then14:33
adeuringrick_h_: sounds good14:33
adeuringrick_h_: I created a new branch & MP: https://code.launchpad.net/~adeuring/launchpad/milestone-sec-adapter/+merge/129917 (was easier create a new branch than to update a somewhat outdated one...)14:51
rick_h_adeuring: rgr14:52
rick_h_adeuring: is +            self.assertRaises(Unauthorized, getattr, obj, name)15:06
rick_h_oops15:06
rick_h_adeuring: is Authorzized a german thing? At first I thought it was a typo but it's consistantly repeated15:06
adeuringrick_h_: nah, that's an oridnary typo ;)15:06
rick_h_ah ok, well you're darn consistant with it and got me wondering :)15:07
mgzis you're going to tyop, it's best to do it consistently!15:07
adeuringI'll fix it15:07
rick_h_adeuring: np, noting them in the comments15:07
rick_h_mgz: exactly! Get them thinking15:08
rick_h_adeuring: r=me with some typo and a question15:17
adeuringrick_h_: thanks!15:17
rick_h_thanks for the comments to help me along!15:17
rick_h_adeuring: on the check vs the db constraint, I just bring it up as a general case of check what you want to check directly in case things come along later and you get more than you meant to at a later date15:32
adeuringrick_h_: could you explain this a bit more?15:33
rick_h_adeuring: so right now there's two cases, product nad distribution.15:34
adeuringright15:34
rick_h_later, let's say someone adds distroseries (not that it would in this case)15:34
rick_h_your check is against product, so now two things would match, distribution and the newly added distroseries15:34
rick_h_because you were only checking that product is None15:34
rick_h_in this case, I guess it's unlikely to be expanded to other items, but as a general rule of thumb, if you want to make sure it's not a distribution I'd word it as self.distribution is not None15:35
rick_h_vs the indirect product is None15:35
adeuringrick_h_: ok, in that case we would anyway need to distinguish the cases for distribtuion and distroseries. The current check for "prodct is not None" has in this case the advantage that it prvents a failure for the case that distribution _and_ product are none because distroseries is not none15:37
rick_h_adeuring: right, but you'd hit a failure and then make sure you take the new condition into account vs silently passing successfully15:38
rick_h_adeuring: sorry, it's just a general comment and nothing in particular in this case.15:38
adeuringrick_h_: ok ;) and ISTM that we have different kinds of failure in mind ;)15:38
=== frankban changed the topic of #launchpad-dev to: http://dev.launchpad.net/ | On call reviewer: rick_h | Firefighting: - | Critical bugs: ~260
=== deryck is now known as deryck[lunch]
abentleyrick_h_: I'm going on lunch, but could you please review https://code.launchpad.net/~abentley/launchpad/user-blueprints-tests/+merge/129944 and https://code.launchpad.net/~abentley/launchpad/user-blueprints/+merge/129945 ?  They are two steps in the same work.16:58
=== matsubara is now known as matsubara-lunch
rick_h_abentley: loading up16:59
=== deryck[lunch] is now known as deryck
=== matsubara-lunch is now known as matsubara
timrcQuestion: we have a user using syncSources() to copy over binary packages from a source PPA to a target PPA.  The issue we are encountering is that if syncSources() runs and all arches are not already built in the source PPA, they apparently get built in the target PPA.  When the arch finishes building in the source PPA syncSources apparently will not overwrite what was built in the target PPA18:19
timrcIn our case it's imperative that the package is identical between the two PPAs18:19
timrcHe's currently having to add additional logic to his script to ensure syncSources is only called once all arches are built18:20
timrcIs this a bug in LP or expected behavior?18:20
maxbtimrc: Somewhat expected. You may be interested in lp-promote-ppa in lp:hydrazine18:29
maxb(Pre written cli script for this use case)18:30
timrcmaxb, I'll check it out.  Thanks for the tip18:32
abentleyrick_h_: private-product-listings is on devel now, so you should be able to merge and use it.18:46
rick_h_abentley: awesome thanks18:52
=== rick_h_ changed the topic of #launchpad-dev to: http://dev.launchpad.net/ | On call reviewer: - | Firefighting: - | Critical bugs: ~260
abentleywgrant: ~abentley/launchpad/user-blueprints is in EC2.18:54
=== Ursinha_ is now known as Ursinha
cjwatsontimrc: By the way, is there a reason you're still using syncSources (which will almost certainly time out lots) and not copyPackages?  Not that it will IIRC make a difference to this bug, but still.19:26
cjwatsons/bug/behaviour/19:26
abentleyderyck: There's no OCR.  Could you please review https://code.launchpad.net/~abentley/launchpad/user-blueprints-privacy/+merge/129967 ?19:28
maxbcjwatson: syncSources generally works just fine for a single source. In that scenario, it is highly desirable to receive synchronous feedback19:31
timrccjwatson, Not sure why this particular user chose syncSources over copyPackages19:33
maxbFor a script writer's usage, syncSources is better19:33
maxbUnless you're trying to sync something like the linux kernel, for which LP really is going to time out19:34
cjwatsonWhy are you using syncSources rather than syncSource for a single source? :-)19:34
timrcwe use syncSource for a single, small, package in PES to copy a keyring package into PPAs that are created through one of our interfaces.  Works well enough.  I could see the concern if we were copying a lot of packages, though.19:34
cjwatsonsyncSource I can more or less understand.  copyPackage and copyPackages I can certainly understand.  syncSources not so much.19:34
timrcsyncSource(s) / copyPackage(s) seem like poor choices for name when taken together19:35
timrcs/name/naming/19:36
deryckabentley, sure, I can review.19:36
abentleyderyck: Thanks.19:36
derycknp19:36
abentleyderyck: rick_h_ already did the hard bits.19:37
cjwatsontimrc: Yes, they grew organically rather than being designed.  Once in place, of course, good APIs don't change.19:38
cjwatson(Not designed as a whole, I mean.  Of course they were designed individually.)19:38
timrcI really wish copyPackage/syncPackage had a flag that could be specified that would fail the operation if not all arches were yet built for the package in question19:39
deryckabentley, yeah, that wasn't bad at all.  easy peasy.  r=me.19:40
timrcit does seem like a bug to me if what you're trying to express is "copy but don't rebuild this package" only to do just that19:40
timrccjwatson, they change, hence versioning...19:41
timrcseems like we decided to stop at 1.0 oh and default to devel, though19:41
abentleyderyck: thanks.  We're over our WIP limit on QA, so I'll hold off landing for now.19:41
cjwatsontimrc: Yeah, but in reality it would be very inconvenient for little real benefit19:41
cjwatsontimrc: Ubuntu uses copyPackage(s) *extensively*19:42
deryckabentley, abel's should have moved across, sorry.  I updated the board.19:42
abentleyderyck: Cool.19:43
timrccjwatson, Yeah and our use of PPAs is not exactly what they were intended for, so I'm willing to cut some slack :D19:45
=== Ursinha is now known as Ursinha-afk
=== matsubara is now known as matsubara-dinner
abentleysinzui: around?22:47
sinzuiI am22:47
abentleysinzui: Could you do me a favour and create a proprietary project on qastaging so I can test my fix for https://qastaging.launchpad.net/projects/+review-licenses ?22:47
sinzuiokay22:48
sinzuiabentley, reload. I created https://qastaging.launchpad.net/aaron-curtis-test22:49
abentleysinzui: I see nothing new, but it's not broken.  Win.  Thanks.22:50
sinzuiyep22:50
wgrantsinzui, abentley: That project doesn't look private22:51
wgrantAll its sharing polices are public22:51
wgrant"Information Type: Public"22:51
abentleysinzui: Yes, I can see the project under /projects, for example.22:52
sinzuioh, I made a commercial project, not a public one.22:53
sinzuiI suck22:53
* sinzui tries again22:53
wgrantIt's Proprietary now22:53
abentleysinzui: I want a proprietary one.22:53
sinzuiI will do both22:53
abentleyStrangely, I seem to be able to navigate to https://qastaging.launchpad.net/aaron-curtis-test but I don't see it listed at https://qastaging.launchpad.net/projects22:55
wgrantAs I mentioned in the review, it's because Product.userCanView lets ~registry see private projects22:56
wgrantWhich doesn't really make sense22:56
sinzuiI did it right the first time https://qastaging.launchpad.net/aaron-curtis-test-222:57
abentleysinzui: Okay, I don't see either one listed, but I can navigate to both.  I'll call qa-ok on this code, but I'll make sure we have a bug for this registry issue.22:59
sinzuiI see it as a CA22:59
* sinzui is happy23:00
abentleysinzui: But you would also see it as product owner.  You should be able to see BzrTools as CA.23:00
sinzuiabentley, I see your private tests :)23:01

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