/srv/irclogs.ubuntu.com/2006/12/13/#launchpad.txt

=== dand [n=dand@dyn-85.186.137.18.tm.upcnet.ro] has joined #launchpad
=== j-a-meinel [n=jameinel@adsl-75-51-62-134.dsl.chcgil.sbcglobal.net] has left #launchpad []
=== dand [n=dand@gw.datagroup.ro] has joined #launchpad
=== shawn___ [n=shawn@netblock-68-183-69-197.dslextreme.com] has joined #launchpad
=== joejaxx is now known as SysAdministrator
=== SysAdministrator is now known as joejaxx
ddaaI am once again confused by the launchpad security framework :(12:57
=== rrittenhouse [n=tad@cpe-76-188-35-66.neo.res.rr.com] has joined #launchpad
thumperddaa, whazzup?01:01
ddaatrying to implement the stuff with import timestamps01:01
ddaabut putting it in the launchpad content class, instead of in importd01:01
ddaaand it's like an uphill battle against launchpad stuff01:01
ddaavery frustrating :(01:01
ddaaall the more frustrating that importd completely bypasses the security framework, and all the launchpaddy stuff, and talks directly with the content class.01:03
ddaaBut proper launchpad tests are not entitled to the same privileges01:03
thumperhmm.. I understand your frustrations01:03
ddaaI get a ForbiddenAttribute for the new attribute01:03
=== mtaylor [n=mtaylor@206.173.9.2.ptr.us.xo.net] has joined #launchpad
ddaaand I've got no clue why01:03
ddaa... maybe I forgot to set the layer...01:05
=== jelmer [n=jelmer@a62-251-123-16.adsl.xs4all.nl] has joined #launchpad
jelmerhi01:06
jelmerAnybody in here with access to pqm.ubuntu.com?01:06
ddaathe control panel is crashing01:07
ddaait happens when there's a merge that makes it unhappy01:07
jelmerThat's probably what happened01:07
ddaait does not mean that pqm is broken01:07
jelmerI sent in my first merge request 5 minutes ago...01:07
ddaait's just the display that's broken01:08
jelmerah, ok01:08
jelmerddaa: btw, I've fixed the utf8 issue in bzr-svn01:08
ddaacool, tell me when you've fixed your branches01:08
jelmerOk, will do01:08
=== Keybuk [n=scott@quest.netsplit.com] has joined #launchpad
ddaaokay... this whole notion that a unit-test for a content class must go through the security framework is broken01:29
jameshddaa: check the zcml (productseries.zcml?)01:31
ddaaah!01:32
ddaaactually it does not have to! I was just being confused01:32
ddaajamesh: it's okay, I just assumed that because the test was in lib/canonical/launchpad/tests/ it was a victim to the importfascist01:33
ddaaThus, loads of problems.01:33
jameshideally the tests should use the same environment as the code uses when it runs01:33
ddaait does01:33
jameshnot doing so has been a source of bugs in the past01:33
ddaaimportd just calls directly into the content class01:34
ddaaand anyway, I'm just trying to unit test a method of the content class01:34
=== anandanbu [i=phoenix@59.92.112.143] has joined #launchpad
=== anandanbu [i=phoenix@59.92.112.143] has left #launchpad []
thumperjamesh: ping02:09
jameshthumper: pong02:32
=== thumper on phone
thumperjamesh: I was looking a bit more that the complete branch revision spec02:35
thumperand unfortunately the sql you specified doesn't exactly work, 02:36
thumperbut that's ok02:36
thumperI like the idea02:36
ddaajamesh: interesting factoid02:36
ddaa        assert UTC_NOW == None02:36
ddaa        assert UTC_NOW != None02:36
ddaaboth are true...02:36
jameshddaa: as expected ...02:36
jameshddaa: both result in an SQLExpression02:36
thumperddaa: try is None02:36
ddaabut self.assertEqual does ==, not "is"02:36
ddaaand NULL translates to None02:37
ddaaso self.assertEqual(series.datelastsynced, UTC_NOW) does not work02:37
jamesh>>> str(UTC_NOW == None)02:37
jamesh"(CURRENT_TIMESTAMP AT TIME ZONE 'UTC' IS NULL)"02:37
jamesh>>> str(UTC_NOW != None)02:37
jamesh"(CURRENT_TIMESTAMP AT TIME ZONE 'UTC' IS NOT NULL)"02:37
thumperjamesh: but if we can put off the feature until postgresql 8.3 then the "with recursive" sql join should be implemented02:37
ddaajamesh: any clue how I can express "check this attribute is UTC_NOW"?02:38
ddaamh... maybe str...02:38
jameshddaa: I'd suggest taking the value of datelastsynced beforehand, and then call obj.sync() afterwards and check that the value is different02:39
jameshsync() will reget the field values from the database, expanding the UTC_NOW constant to an actual date value02:39
thumperjamesh: I prefer the adjacency model of tree storage, especially since the revisions will be in many different "trees", and that way, you keep a clean model02:39
jameshthumper: how does this fit in with stub's work?02:39
thumperjamesh: I don't think it does, I grabbed his branch this morning but haven't looked at it02:40
thumperwhat he was doing was preorder tree storage02:40
jameshthumper: the model I proposed was from before I knew of stub's dag word02:40
jameshs/word/work/02:40
thumperhowever that works great for graphs that don't change much02:40
thumperand the model doesn't work too well for nodes that are in many trees02:40
ddaajamesh: it would be a bit weaker than what the test wants to express... specifically it's "If import_branch.last_mirrored is None, importUpdated just sets datelastsynced to UTC_NOW."...02:41
ddaait does not want to test that the method set the datelastsynced attribute to "something", but UTC_NOW02:41
ddaawrapping the things in str() works02:41
ddaait just needs a small comment02:42
jameshddaa: checking against the constant UTC_NOW is a bit fragile, since the field value will change on sync() or a commit02:42
ddaaself.assertEqual(str(series.datelastsynced), str(UTC_NOW))02:42
ddaajamesh: from what you say, this should be robust02:42
jameshthumper: well, in effect the Revision/RevisionParent tables form one big DAG ...02:43
ddaaAssertionError: 'None' != "CURRENT_TIMESTAMP AT TIME ZONE 'UTC'"02:43
jameshthat covers all the branches we know about02:43
thumperjamesh: yeah, but traversing that right now is a pita02:43
thumperI really think there should be a rev_id for the parent that is null if it's a ghost02:44
thumpersimpler joins02:44
jameshthumper: what I mean is: would it be possible to get the branch scanner to update a table using stub's layout02:44
jameshand is that representation useful for the web UI02:44
thumperthere is a function in the postgresql/contrib tablefunc.connectby02:45
thumperjamesh: the problem with the preorder traversal dag storage is that it works for *one* dag, not overlapping ones02:46
thumperothers use forrests and add a forest id02:46
jameshthumper: you mean that it doesn't really help if we want information about a subset of the dag?02:46
thumperwhich is effectively adding an extra row for each branch/revision02:46
ddaathumper: I am not sure I get what you mean by "the revisions can be in many different trees", but the idea of the Revision and RevisionParent tables is that they represent the fraction of the _global_ database that the supermirro sees.02:46
jameshwe've got one dag02:46
jameshand each branch is only concerned with a subset of that dag02:46
thumperjamesh: but our dag goes the wrong way :-)02:47
ddaaat least at the moment, if there is a ghost in only one branch, the dag stored in the database does not know about it02:47
jameshthumper: really?02:48
thumperddaa: we are discussing some work that is going on by stub to look at dag storage using preorder traversal trees02:48
thumperpreorder tree traversal doesn't work if you have multiple roots, but that could be munged with a fake one02:48
jameshthumper: you mean the fact that the subset is selected by the head of the tree, rather than the initial rev02:48
thumperjamesh: yes02:49
ddaaI understand that there's is some work in progress to allow easily finding all the branches associated to a revision and all the revisions associated to a branch without the need of an explicit branch-revision N-N table02:49
thumperddaa: yep that's it02:49
jameshthumper: can we get useful info if we start from the head rev and traverse backwards?02:49
ddaathumper: I was pointing out that although the N-N table would have faithfully represented ghosts as found in branches, I do not think it is a design goal.02:50
thumperalso inserting to the tree requires an update to all parents02:50
thumperto update left and right values02:50
thumperin order to get the simple insertion (which will be happening a lot with the branch scanner), you really want some form of adjacency model02:51
thumperwhich is what you jamesh originally suggested, and a "form" of it is in place now (but without explicit ids)02:51
thumperddaa: yes the N-N model is not ideal02:52
thumperand something we want to avoid02:52
ddaadid you get what I said about "faithfully representing that A branch does not have those revisions" not being a design goal?02:52
ddaaas in "those revisions are ghosts in A branch but not in this other"02:53
thumperddaa: too many negatives02:53
ddaanevermind02:53
ddaait's getting late here02:53
thumperddaa: I think I understand what you mean02:53
thumperddaa: no idea why you are still awake02:53
thumpersleep man!02:53
ddaawoke up late, went to the movies, have an urgent coding task02:54
ddaabut thanks to jamesh help, I'm now unstuck02:54
ddaaso, beddy time02:54
thumperI was looking at the lp bzr branch, and there are around 14000 revisions in the ancestry and 4300ish in the revision history02:55
thumperI'm also mildly concerned of any coded recursive searches to get the ancestry02:55
jameshyep02:56
thumpereven though the recursive depth to get the entire ancestry is likely to be < 2002:56
jameshthe latency'll kill you02:56
thumperall it takes though is one branch that had 50 or 100 revisions prior to being merged to kill it02:56
thumperthere is the contrib function that aparently has much successful use by the wider community02:57
thumperideally we'd have the "with recursive" sql statement (coming in 8.3)02:57
thumperI read an interesting article on "staircase join" being added to postgresql by some uni students02:58
thumperbut it was never merged to mainline development02:58
thumperthereby effectively adding tree awareness to the db02:58
thumpereffectively the same as "with recursive"02:58
=== thumper back to thinking on email for branches
=== thumper off to collect daughter from school, bbs
=== quail_linux [n=quail@unaffiliated/quaillinux/x-000001] has joined #launchpad
=== jimmythegeek [n=jimmythe@168.156.99.36] has joined #launchpad
jimmythegeekI'm having trouble editing the ubuntu documentation for Cacti.  I ran into a problem with the package and would like to share my findings.  Launchpad says I'm already logged in but ubuntu.com says to log in to edit03:11
jimmythegeekah, never mind.03:17
=== jimmythegeek [n=jimmythe@168.156.99.36] has left #launchpad []
=== stub [n=stub@ppp-58.8.12.128.revip2.asianet.co.th] has joined #launchpad
=== thumper [n=tim@166-179-30-77.jamamobile.co.nz] has joined #launchpad
=== doko_ [n=doko@dslb-088-073-065-036.pools.arcor-ip.net] has joined #launchpad
=== WebMaven [n=webmaven@ip72-193-220-34.lv.lv.cox.net] has joined #launchpad
=== _thumper_ [n=tim@166-179-25-75.jamamobile.co.nz] has joined #launchpad
=== _thumper_ is now known as eric-the-viking
=== eric-the-viking is now known as thumper
=== lifeless [n=robertc@ppp245-86.static.internode.on.net] has joined #launchpad
UbugtuNew bug: #62887 in linux-source-2.6.17 "Intel wireless 3945 not configured properly with Edgy Beta" [Undecided,Needs info]  http://launchpad.net/bugs/6288705:35
UbugtuNew bug: #73645 in linux-source-2.6.17 "Failure to detect Intel Pro/Wireless 3945 ABG" [Undecided,Unconfirmed]  http://launchpad.net/bugs/7364505:46
UbugtuNew bug: #68658 in Ubuntu "Intel PRO/Wireless 3945ABG wifi card supported but not loaded by default" [Undecided,Needs info]  http://launchpad.net/bugs/6865806:01
SteveAthumper: stub said yesterday that he'd had some ideas about representing branch data in the database06:19
thumperhi SteveA06:20
SteveAmorning06:20
thumperI had a look at the tree preorder storage stuff06:20
thumperand I'm not convinced06:20
thumperI have grabbed stub's branch, but haven't looked at it yet06:21
SteveAI don't know if these were new ideas not yet committed to code06:21
SteveAmaybe arrange a voice call with stub sometime06:22
thumpersounds like a plan06:22
thumperI'm cooking dinner right now, I'll be back around in a few hours#06:22
=== SteveA goes to try and get another hour or two of sleep before matt revell arrives
thumperback08:07
=== shawn___ [n=shawn@adsl-70-231-246-176.dsl.snfc21.sbcglobal.net] has joined #launchpad
=== stu1 [n=stub@ppp-58.8.12.133.revip2.asianet.co.th] has joined #launchpad
=== stu1 is now known as stub
=== mdke_ is now known as mdke
=== carlos [n=carlos@84.77.101.254] has joined #launchpad
carlosmorning09:05
mdkecan you guys delete release series?09:36
mdkeif so please delete https://launchpad.net/products/ubuntu-doc/main (no idea why it exists)09:36
=== raphink [n=raphink@ubuntu/member/raphink] has joined #launchpad
jameshmdke: there appear to be translation templates attached to that series09:41
jameshand packaging links09:41
=== owh [n=onno@59.154.24.148] has joined #launchpad
owhGreetings, just wondering what protocol is. I've been adding tags to a couple of bugs - that is, things that are related to ThinkPads - seeing that I have one of those and I figured I'd start helping out, but is there a set procedure that I should be aware of?09:43
jameshowh: it's worth asking the developers of the product/distro in question when using a new tag09:43
jameshowh: e.g. on #ubuntu-devel if you are tagging Ubuntu bugs09:44
SteveAmorning!09:45
SteveA(again)09:45
owhjamesh: Well, the only "new tag" was one that was already in the overall list, vaio, which appeared new for pcmcia-cs, but not for the overall list if you know what I mean.09:45
mdkejamesh: please delete it anyway, if that's possible09:45
mdkenot entirely sure how it is packaged in breezy amsn, but still09:45
owhjamesh: It was a bug to do with a thinkpad and a vaio machine, and I tagged it accordingly.09:45
jameshmdke: file a ticket: https://answers.launchpad.net/products/launchpad/+tickets09:45
mdkejamesh: sure09:45
owhI figured that the point of the tag was so that you could find bugs across different packages etc, using a tag.09:46
owhis that correct?09:46
jameshowh: if the tag name was already in use for Ubuntu, I'm sure they wouldn't mind you using it09:46
jameshprovided you use it consistently09:46
jameshyeah09:46
owhSo, will I be standing on anyone's toes if I keep "cleaning and pruning"?09:47
SteveAstub: about PG 8.2, do the client libraries stay the same?09:47
owhOr should I cease and desist?09:47
jameshowh: best to ask on #ubuntu-devel09:47
owhCool, will do. Tah.09:47
jameshowh: or on one of the Ubuntu mailing lists09:47
owhThanks for that jamesh.09:48
stubSteveA: I don't think they have broken the network protocol, so I think so. psycopg and old psql binaries should work fine. But this is why we test things first :)09:48
=== seb128 [n=seb128@ANancy-151-1-36-79.w83-196.abo.wanadoo.fr] has joined #launchpad
owhjamesh: Is there anything I need to know about #ubuntu-devel, there's 187 people in the room, six folks talking and no-one paying any attention to me. Did I break an unwritten rule I don't know about?10:00
=== elmo_ is now known as elmo
jameshowh: not sure.  Probably try asking again later10:11
owhTah jamesh.10:11
=== owh goes of to exercise patience :-)
=== doko_ is now known as doko
BjornTowh: if it's about ubuntu bugs, you might want to try #ubuntu-bugs instead.10:13
owhHmm, that's a fair suggestion BjornT.10:13
jameshI didn't know #ubuntu-bugs existed10:14
=== joachim-n [n=joachim@ACCFCB76.ipt.aol.com] has joined #launchpad
=== danilo-out is now known as danilos
=== carlos_ [n=carlos@84.77.99.212] has joined #launchpad
=== carlos_ is now known as carlos
BjornTstub: staging seems really slow at the moment. is it doing anything special?10:57
UbugtuNew bug: #75585 in rosetta "po import notification tests refactoring to share more code" [Low,Confirmed]  http://launchpad.net/bugs/7558511:00
=== matthewrevell [n=matthew@e190084.upc-e.chello.nl] has joined #launchpad
=== WebMaven [n=webmaven@ip72-193-220-34.lv.lv.cox.net] has joined #launchpad
UbugtuNew bug: #68646 in language-pack-ru "Russian l11n in tsclient is broken" [High,In progress]  http://launchpad.net/bugs/6864611:10
carlosstub: ping11:19
=== Keybuk [n=scott@quest.netsplit.com] has joined #launchpad
stubcarlos: pong11:20
carlosstub: dude... I hate you.... you caused 7 conflicts in pagetests that I changed completely :-(11:21
=== carlos cries ...
carlosstub: The pillar URL change, will fail if I revert your pagetest changes?11:21
stubI've been having to do the reverse since last week keeping the branch alive ;)11:21
stubcarlos: Probably - the old URLs are now redirects to the new URLs.11:22
carlosso browser.url will be different11:22
carlosok11:22
carlosthat's fine then11:22
stubBetter to use your pagetest, and just trim any /distros/ or /products/ or /projects/ from your URLs11:22
stubAnd change /rosetta to /translations11:22
carlosok11:22
carlosthanks for the hint11:23
stubIts all pretty mechanical11:23
BjornTstub: ping11:32
stubBjornT: pong11:32
BjornTstub: the Bugs page on staging causes a timeout. if you look at https://devpad.canonical.com/~jamesh/oops.cgi/2006-12-13/S8, could it be that an extra index is needed?11:33
stubBjornT: The slowest SQL statement takes less that 2.5 seconds. Time is spent rendering.11:40
stubBjornT: Probably because that query returns 30000 odd rows11:42
BjornTstub: hmm, right. i'll take a look at it, it should render only ten of the rows.11:43
stubNo LIMIT or OFFSET is in that query11:44
BjornTstub: the thing is that i need 10 unique bugs, not 10 unique bugtasks, and it's not trivial to get that with the existing search methods.11:53
=== salgado [n=salgado@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
BjornTi guess i could do a quick hack and put a limit in there, and deal with it properly later, though.11:53
stubSounds like you need to be selecting DISTINCT Bug.*, and then retrieving the bugtasks with a second query if you need that information.11:55
BjornTyeah. but given that this will block the planned rollout, i rather do as little as possible for now.11:59
=== matsubara [n=matsubar@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
=== niemeyer [n=niemeyer@201.14.38.176] has joined #launchpad
=== cprov-afk is now known as cprov
=== niemeyer [n=niemeyer@201.14.38.176] has joined #launchpad
=== jinty [n=jinty@172.Red-83-36-43.dynamicIP.rima-tde.net] has joined #launchpad
=== somerville32 [n=somervil@fctnnbsc15w-156034086016.nb.aliant.net] has joined #launchpad
=== LarstiQ waits for stub to return
=== pschulz01 [n=paul@202.174.42.5] has joined #launchpad
=== Seveas [n=seveas@ubuntu/member/seveas] has joined #launchpad
UbugtuNew bug: #75604 in launchpad "Marking products 'abandoned'" [Undecided,Unconfirmed]  http://launchpad.net/bugs/7560402:01
=== matthewrevell [n=matthew@e190084.upc-e.chello.nl] has joined #launchpad
=== ddaa [n=ddaa@nor75-18-82-241-238-155.fbx.proxad.net] has joined #launchpad
=== static [n=emurphy@194.18.118.70.cfl.res.rr.com] has joined #launchpad
=== carlos -> lunch
salgadocprov, you just reverted my changes to PendingReviews. :/03:04
cprovsalgado: oops, sorry.03:05
cprovsalgado: editmoin is faster ;)03:05
salgadoif it was faster I'd have reverted yours03:06
salgadodoesn't it warn you when somebody else is editing a page?03:08
cprovsalgado: no03:08
=== cprov is now known as cprov-lunch
=== static_ [n=emurphy@194.18.118.70.cfl.res.rr.com] has joined #launchpad
cprov-lunchkiko: can you have a look at #68675 ? who is responsible for PQM machine updates ?03:15
kikocprov-lunch, I think it's the admins, so file an RT request?03:17
=== flacoste [n=francis@modemcable207.210-200-24.mc.videotron.ca] has joined #launchpad
kikoalso, carlos or you could fix that by simply putting some ellipsis in the test03:17
kikobut.. no big deal.03:18
kikoelmo, ping?03:18
=== kiko is now known as kiko-fud
=== carlos [n=carlos@84.77.99.212] has joined #launchpad
UbugtuNew bug: #75615 in rosetta "f-spot doesn`t have po files" [Undecided,Unconfirmed]  http://launchpad.net/bugs/7561503:25
=== matsubara is now known as matsubara-lunch
=== cprov-lunch is now known as cprov
cprovkiko-fud: nop, but IMO best thing to do should be installing the backported apt.03:57
=== sabdf1 [n=sabdfl@217.205.109.249] has joined #launchpad
carloscprov: if you are talking about the test error I reported04:00
carloscprov: that will be required for every single server where we will run tests04:00
cprovcarlos: I can't see any problem if they are dapper04:00
carloscprov: sure, I'm just pointing it04:01
=== quail_linux_ [n=quail@unaffiliated/quaillinux/x-000001] has joined #launchpad
carlosor stub will get crazy with test failures04:01
cprovcarlos: yes, I agree that it could be tricky considering our complex infrastructure.04:04
=== frafu [n=frafu@vodsl-10046.vo.lu] has joined #launchpad
=== tonyyarusso [n=anthony@ubuntu/member/tonyyarusso] has joined #launchpad
tonyyarussoHeyo - not sure if this is possible to work around, but here's the deal:04:15
tonyyarussoThe e-mail address I have associated currently with my LP account has a spam filter set to allow only users / domains in an allow list.  Since being added to Ubuntu Members, I was subscribed to a "bug" (the developers thanks one ;) ), and when people add comments to it, the e-mails show up as from their personal e-mails, not identifying as launchpad in any way, and so get caught.04:16
tonyyarussoWould it be possible for bug comments subscription e-mails to show up as from @launchpad.net so I could just allow that domain, or do you have any other suggestions?04:17
=== aa_ [n=ali@pida/aa] has joined #launchpad
aa_hi, am I being blitheringly incompetent, but I can't add a new ssh key. Amazingly I already have added 2 keys and they are fine.04:21
aa_is it instant?04:22
aa_I mean is the key added isntantly?04:22
=== frafu [n=frafu@vodsl-10046.vo.lu] has left #launchpad []
salgadoaa_, yeah, it should be04:23
salgadodo you get any errors?04:23
aa_just Permission denied (publickey).04:23
aa_and doing ssh -v it is definitely offering the key04:24
carlostonyyarusso: I don't think that's possible, sorry04:24
aa_let me try again with my new knowledge that it is instant04:24
carlostonyyarusso: could you filter also based on email headers?04:24
tonyyarussocarlos: Actually, hold that thought - I may have just answered my own question04:24
carlos;-)04:24
aa_hm...how distressing04:25
tonyyarussocarlos: Adding bounces@canonical.com did it!  Sweet.04:25
aa_I guess I should check the key thaqt is imported into the bazaar04:25
tonyyarussonvm me :)04:26
UbugtuNew bug: #75620 in launchpad "Unable to unsubscribe to bug assigned to team" [Undecided,Unconfirmed]  http://launchpad.net/bugs/7562004:30
aa_any suggestions on what to do? I am just plain stuck unable to commit. I have checked the key is the same as the uploaded key, and that the key is being offered04:37
aa_should I be able to ssh bazaar.launchpad.net ?04:38
flacostekiko-fud: daily reminder that SupportTrackerRenaming is waiting for your review :-)04:40
=== j-a-meinel [n=jameinel@adsl-75-51-62-134.dsl.chcgil.sbcglobal.net] has joined #launchpad
=== matsubara-lunch is now known as matsubara
=== danilos is now known as danilo-out
=== quail_linux_ [n=quail@unaffiliated/quaillinux/x-000001] has joined #launchpad
=== carlos -> out
carloskiko-fud: you also owe me a review for translation form in read only mode ;-)05:08
carlossee you!05:08
=== aa_ [n=ali@pida/aa] has left #launchpad []
=== lbm [n=lbm@82.192.173.92] has joined #launchpad
=== asw [n=asw@karuna.med.harvard.edu] has joined #launchpad
=== kiko-fud is now known as kiko
=== frafu [n=frafu@vodsl-10046.vo.lu] has joined #launchpad
=== jkakar [n=jkakar@204.174.36.228] has joined #launchpad
=== sabdf1 is now known as sabdfl
=== BenC [n=bcollins@debian/developer/bcollins] has joined #launchpad
BenCyo lp'ers06:00
BenCI have a special request. I will, within a week, need all active linux-source-2.6.19 bugs transfered to linux-source-2.6.20 with a little blurb saying "Please reconfirm this bug against 2.6.20, in feisty now"06:01
BenCwould someone be willing to do this for me, roughly 60 bugs?06:01
matsubaraBenC: you could mail stub to do a sql magic for you or ask the bugsquad team, how does that sound?06:06
BenCmatsurba: Sounds great, thanks06:06
BenCrather prefer a sql change to avoid human error, and wasted energy06:07
matsubaranobody gets my name right :(06:09
matsubaraanyway, just mail stub, cc launchpad and he'll probably help you out with that.06:09
LarstiQmatsubara: I do!06:09
matsubaraLarstiQ: you probably cheated and used nick completion :P06:10
LarstiQeven without tabcompletion, it sounds too japanese to get wrong06:10
BenCmatsubara: Sorry :)06:10
matsubaraBenC: np. I'm getting used to it. I should change my name to foobara, that way developers won't ever type it wrong. :)06:13
BenChehe06:13
=== raphink [n=raphink@ubuntu/member/raphink] has joined #launchpad
kikocprov, can you give me the full diff in a pastebin?06:31
cprovkiko: let me check devpad first06:32
kikooki06:33
cprovkiko: https://devpad.canonical.com/~jamesh/pending-reviews/cprov/launchpad/trivialities/full-diff is up to date06:33
=== kiko looks
=== flacoste is now known as flacoste_lunch
=== ajmitch [n=ajmitch@port166-123.ubs.maxnet.net.nz] has joined #launchpad
=== flacoste_lunch is now known as flacoste
=== Ubug2 [n=bugbot@ubuntu/bot/ubugtu] has joined #launchpad
=== cprov is now known as cprov-out
=== WebMaven [n=webmaven@ip72-193-220-34.lv.lv.cox.net] has joined #launchpad
=== quail_linux_ [n=quail@unaffiliated/quaillinux/x-000001] has joined #launchpad
=== jamesh [n=james@203-59-208-48.dyn.iinet.net.au] has joined #launchpad
=== jamesh [n=james@203-59-208-48.dyn.iinet.net.au] has joined #launchpad
kikoBjornT, was the fix for bug queries you landed ar r4324 what fixes https://devpad.canonical.com/~jamesh/oops.cgi/2006-12-12/S18 -- ?08:43
kikos/ar /as /08:43
sabdflsalgado: cool timing to be working on those mails today :-)08:47
salgadosabdfl, indeed; I commented that with kiko a few minutes ago08:48
kikosabdfl, mindreading? we're getting there08:49
kikosabdfl, my random ubuntu bugs bounty is getting results!08:49
=== matsubara is now known as matsubara-afk
=== thumper [n=tim@222.152.39.218] has joined #launchpad
sabdflbounty?09:30
=== Keybuk [n=scott@syndicate.netsplit.com] has joined #launchpad
=== matsubara-afk is now known as matsubara
kikosabdfl, I've promised 10 DVDs to the group that nukes out all unconfirmed bugs with no packages assigned!09:54
kikosabdfl, that's about 1200 bugs09:54
kikowell, /was/. apparently today it's 900 something09:54
thumperkiko, which DVDs?09:55
kikothumper, 10 dvds of their choice09:55
=== LarstiQ would go for 5 dapper, 4 edgy and 1 feisty dvd.
kikovf09:55
kikothink "gone with the wind"09:56
thumperkiko: monty python box set is 1 or 4?09:56
kikothumper, 409:56
BjornTkiko: no, r4324 fixes another oops (https://devpad.canonical.com/~jamesh/oops.cgi/2006-12-13/S8). i'll land a similar fix for this oops, though.10:05
kikoBjornT, is it the same sort of problem?10:05
BjornTkiko: yeah. i practically copied the code from the filebug one.10:06
kikocopying the code... hmmm. red flag! should this be refactored or fixed more widely, BjornT?10:07
BjornTthe problem was that the code iterates through a large result set, thinking it should be cheap since it only iterates over about then items. but it seems that sqlobject listifies the result.10:08
kikowell, once you hit the resultset, that's it10:08
kikoit is materialized10:08
BjornTkiko: it should probably be refactored, yes. but i don't think it's a problem that can be fixed more widely.10:09
kikoBjornT, hmmm, right10:09
kikoBjornT, what you would need to do is always provide a limit for how many rows you'd want to query10:10
kikowe could forseeably limit all our queries 10:10
kikommmmm10:10
BjornTkiko: yeah, my quick fix was to only fetch 4 times as many results that i want to return. i'll fix it properly later by adding a method to IBugSet that queries the Bug table directly, instead of going through BugTask as it's done today.10:11
kikowill you need to do bookeeping manually -- i.e. omit dupes, for instance?10:12
BjornTwhat do you mean?10:12
kikoBjornT, well, BugTaskSet.search() helps you by setting things up so the query is "right"10:13
kikofor instance, dupes are omitted by default10:13
kikowill you have to do a manual query in this place?10:14
kikoI also am curious as to how you will be able to do this query directly on Bug if you want to filter by product/distro.10:14
BjornTkiko: well, yes. but for the most duplicated bugs case, by definition duplicate bugs will be omitted.10:16
kikoright10:16
BjornTkiko: right. i haven't thought through have to limit on BugTask attributes efficiently yet. that might be a problem, i'll ask stub or someone about it when i do it.10:17
kikohave to limit -- or how to limit?10:18
BjornTmight have to query the BugTask table first to get all the bug ids, then fetch the Bug instances.10:18
BjornTthen it should be possible to re-use code from BugTaskSet even10:19
kikoyes10:20
kikothere could definitely be an option to do that.10:20
kikoit might be weird to have bugtaskset return bugs/bug ids though10:20
BjornTkiko: i was mostly thinking of refactoring out the code that generates the sql queries.10:21
kikothat would be a possibility too10:22
kikobut public API for that? 10:22
=== kiko shudders
BjornTyeah, i know...10:22
=== cprov-out is now known as cprov
=== asw [n=asw@karuna.med.harvard.edu] has joined #launchpad
=== kiko is now known as kiko-afk
=== aa_ [n=ali@pida/aa] has joined #launchpad
=== matsubara [n=matsubar@200-171-140-32.dsl.telesp.net.br] has joined #launchpad
=== somerville32 [n=somervil@fctnnbsc15w-156034086016.nb.aliant.net] has joined #launchpad
=== sabdfl [n=sabdfl@ubuntu/member/pdpc.silver.sabdfl] has joined #launchpad
=== belito [n=user@201.240.250.48] has joined #launchpad
=== mtaylor [n=mtaylor@206.173.9.2.ptr.us.xo.net] has joined #launchpad
=== jml [n=jml@220-253-139-252.TAS.netspace.net.au] has joined #launchpad
=== rrittenhouse [n=tad@cpe-76-188-35-66.neo.res.rr.com] has joined #launchpad
radixhmm, it took me a while to figure out how to find a bug I filed that was marked as a duplicate (or the bug which it duplicated)12:04
radixbecause the "bugs I'm subscribed to" doesn't show *either*12:04
radixis that a bug I should file against launchpad?12:04
=== asw [n=asw@karuna.med.harvard.edu] has joined #launchpad
mtayloron the Register a new release page, it mentions adding a URL but there is no place to add a url. 12:15

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