00:00.18 | *** join/#storm wallflower (n=wallflow@ip-205-246-113-216.pool.grokthis.net) |
00:24.33 | *** join/#storm kov (n=kov@debian/developer/kov) |
04:04.40 | *** join/#storm oubiwann (n=oubiwann@67.111.52.130.ptr.us.xo.net) |
05:55.07 | *** join/#storm Sidnei (n=Sidnei@plone/dreamcatcher) |
08:34.11 | *** join/#storm jukart (i=lovely@lsfw01.lovelysystems.com) |
08:48.04 | *** join/#storm mcella (n=mcella@ip-143-10.sn3.eutelia.it) |
08:49.43 | *** join/#storm jona` (n=jon@fof.durge.org) |
08:50.09 | jona` | hi, i've got a small storm/pickle question |
08:50.49 | jona` | i wanted to pickle a storm object but got an error saying a Connection object could not be pickled. i'm wondering if anyone else has tried this and got a similar error. |
10:29.18 | *** join/#storm lightyear (n=ben@o.bcn.fluendo.net) |
11:51.11 | *** join/#storm Sidnei (n=Sidnei@plone/dreamcatcher) |
13:07.21 | *** join/#storm kripken (n=alon@85-250-12-82.bb.netvision.net.il) |
13:19.52 | *** join/#storm Sidnei_ (n=Sidnei@201-66-192-160.cslce701.dsl.brasiltelecom.net.br) |
13:36.36 | *** join/#storm kov (n=kov@debian/developer/kov) |
14:59.56 | *** join/#storm lightyear (n=ben@o.bcn.fluendo.net) |
15:27.35 | *** join/#storm Sidnei__ (n=Sidnei@189.30.217.33) |
15:30.26 | *** join/#storm lightyear (n=ben@195.10.10.180) |
15:59.06 | *** join/#storm Sidnei_ (n=Sidnei@189.30.217.33) |
16:14.44 | *** join/#storm HazzaUK (n=HazzaUK@dsl-217-155-201-84.zen.co.uk) |
16:20.50 | *** join/#storm andrea-bs (n=andrea-b@ubuntu/member/beeseek.developer.andrea-bs) |
16:38.12 | *** join/#storm jamesh (n=james@canonical/launchpad/jamesh) |
16:45.01 | *** join/#storm Sidnei__ (n=Sidnei@189.30.217.33) |
16:49.56 | *** join/#storm oubiwann (n=oubiwann@67.111.52.130.ptr.us.xo.net) |
17:05.01 | *** join/#storm oubiwann_ (n=oubiwann@67.111.52.130.ptr.us.xo.net) |
17:07.23 | *** join/#storm niemeyer (n=niemeyer@67.111.52.130.ptr.us.xo.net) |
17:09.53 | *** join/#storm jkakar (n=jkakar@67.111.52.130.ptr.us.xo.net) |
17:12.45 | *** join/#storm jukart (n=jukart@d91-130-142-16.cust.tele2.at) |
17:40.10 | *** join/#storm niemeyer (n=niemeyer@67.111.52.130.ptr.us.xo.net) |
17:40.34 | *** join/#storm jkakar (n=jkakar@67.111.52.130.ptr.us.xo.net) |
17:50.59 | *** join/#storm oubiwann_ (n=oubiwann@67.111.52.130.ptr.us.xo.net) |
18:16.40 | *** join/#storm jamesh (n=james@canonical/launchpad/jamesh) |
18:23.30 | HazzaUK | Anyone in here using the twisted integration code with sqlite backend? |
18:26.56 | lightyear | raises his arm |
18:31.30 | HazzaUK | I'm having quite a lot of trouble with the old 'database is locked' error |
18:33.19 | lightyear | HazzaUK: is it looked? |
18:33.24 | lightyear | -o+c? |
18:47.12 | HazzaUK | oh damn, he's gone |
18:52.48 | vvinet | so, was it locked |
18:58.18 | HazzaUK | Sorry, bit hectic here. All I have to go on is the error, which says it is. I'm looking for guidance really on how StorePool should be used. At the moment I'm doing as suggested in the twisted store.py in that I'm taking a store from the pool and commiting and putting it back in callback. |
19:02.53 | *** join/#storm thumper_laptop (n=tim@canonical/launchpad/thumper) |
19:05.09 | *** join/#storm HazzaUK (n=HazzaUK@dsl-217-155-201-84.zen.co.uk) [NETSPLIT VICTIM] |
19:05.09 | *** join/#storm kripken (n=alon@85-250-12-82.bb.netvision.net.il) [NETSPLIT VICTIM] |
19:05.09 | *** join/#storm artista_frustrad (n=artista_@201-25-168-91.ctame704.dsl.brasiltelecom.net.br) [NETSPLIT VICTIM] |
19:06.07 | vvinet | Did you read the documentation about concurrent access to sqlite databases? |
19:07.06 | vvinet | https://storm.canonical.com/Manual#SQLite%20and%20threads |
19:10.28 | *** join/#storm HazzaUK (n=HazzaUK@dsl-217-155-201-84.zen.co.uk) [NETSPLIT VICTIM] |
19:10.28 | *** join/#storm kripken (n=alon@85-250-12-82.bb.netvision.net.il) [NETSPLIT VICTIM] |
19:10.28 | *** join/#storm artista_frustrad (n=artista_@201-25-168-91.ctame704.dsl.brasiltelecom.net.br) [NETSPLIT VICTIM] |
19:15.46 | vvinet | HazzaUK: Does it answer your questions? |
19:26.27 | HazzaUK | vvinet: Sorry, I didn't see anything. Connection troubles |
19:26.27 | HazzaUK | What's the word? |
19:27.01 | HazzaUK | vvinet: Sorry, I didn't see anything. Connection troubles. |
19:27.03 | HazzaUK | What's the word? |
19:28.17 | HazzaUK | A truly dreadful connect, that can't cope with connecting to 2 or more irc channels at the same time. |
19:28.37 | vvinet | <vvinet> Did you read the documentation about concurrent access to sqlite databases? |
19:28.37 | vvinet | <PROTECTED> |
19:28.37 | vvinet | <PROTECTED> |
19:32.15 | HazzaUK | vvinet: thanks, reading in progress |
20:09.58 | HazzaUK | vvinet: Thanks, I'm going with the final suggestion. Kill SQLite. |
20:11.04 | vvinet | :) |
20:48.14 | *** join/#storm Sidnei_ (n=Sidnei@201-66-192-160.cslce701.dsl.brasiltelecom.net.br) |
21:06.08 | rockstar | jkakar, are you in the h-izz-ouse? |
21:06.44 | jkakar | rockstar: I'm at the hotel, yo. |
21:07.14 | rockstar | jkakar, but you're in the proverbial house. |
21:07.27 | jkakar | rockstar: Och, aye. |
21:07.42 | rockstar | thumper and I were wondering how to do a DISTINCT in Storm. |
21:07.54 | jkakar | result = store.find(Foo, ...) |
21:08.00 | jkakar | result.config(distinct=True) |
21:08.03 | jkakar | for x in result: ... |
21:08.19 | jkakar | You can also pass offset and limit keyword arguments to config, if you want. |
21:08.37 | jkakar | rockstar: ^^ |
21:08.59 | rockstar | jkakar, ah, okay. |
21:09.13 | rockstar | We were expecting something like store.find(...).distinct() |
21:09.28 | thumper | rockstar: well... not entirely |
21:09.35 | thumper | rockstar: I knew there was a way |
21:09.35 | jkakar | Heh |
21:09.46 | thumper | rockstar: I just whacked that in there as a place-holder |
21:09.56 | jkakar | store.find(...).distinct() is a bit odd, because distinct is not a verb... but whatever. |
21:10.02 | rockstar | thumper, no, I fully expected something like that. |
21:10.33 | rockstar | jkakar, yea, that's true, but with my understanding of storm, I would expect something like that. |
21:10.34 | jkakar | The main annoying thing with config(distinct=True) is that it doesn't return a new ResultSet, like other mutating methods. |
21:10.39 | jkakar | rockstar: I see. |
21:11.01 | rockstar | jkakar, but I would expect .distinct() to return a new ResultSet |
21:11.45 | jkakar | rockstar: Yeah, it would be good if it did, but it doesn't. It returns the same ResultSet. |
21:13.23 | jkakar | rockstar: The problem now is that changing that part of the API will break backwards compatibility, which we don't want to do. |
21:14.20 | therve | rockstar: you can easily use that: distinct_result = result.copy().config(distinct=True) |
21:14.34 | rockstar | jkakar, technically, you're < 1.0, so you can do whatever you want. ;) |
21:15.03 | jkakar | rockstar: Heh. |
21:17.03 | vvinet | result.config(distinct=True) returns the same ResultSet with changed attributes? |
21:17.08 | *** join/#storm HazzaUK (n=HazzaUK@dsl-217-155-201-84.zen.co.uk) [NETSPLIT VICTIM] |
21:17.08 | *** join/#storm kripken (n=alon@85-250-12-82.bb.netvision.net.il) [NETSPLIT VICTIM] |
21:17.09 | *** join/#storm artista_frustrad (n=artista_@201-25-168-91.ctame704.dsl.brasiltelecom.net.br) [NETSPLIT VICTIM] |
21:17.43 | therve | vvinet: it mutates the resultset |
21:18.13 | vvinet | that's what I would expect from that usage |
21:28.53 | *** join/#storm HazzaUK (n=HazzaUK@dsl-217-155-201-84.zen.co.uk) [NETSPLIT VICTIM] |
21:28.53 | *** join/#storm kripken (n=alon@85-250-12-82.bb.netvision.net.il) [NETSPLIT VICTIM] |
21:28.53 | *** join/#storm artista_frustrad (n=artista_@201-25-168-91.ctame704.dsl.brasiltelecom.net.br) [NETSPLIT VICTIM] |
21:54.30 | *** join/#storm kov (n=kov@debian/developer/kov) |
22:02.12 | *** join/#storm sidnei-mob (n=sidnei-m@189-95-89-69.3g.claro.net.br) |
22:04.56 | *** join/#storm jamesh (n=james@canonical/launchpad/jamesh) |
23:00.30 | *** join/#storm jamesh (n=james@canonical/launchpad/jamesh) |