| 00:10.31 | jkakar | gabriel_: It's code that we modified and use in Landscape. |
| 00:10.49 | jkakar | gabriel_: It's open and free to use. |
| 00:14.32 | gabriel_ | jkakar, that's great, thanks again |
| 02:17.26 | *** join/#storm jml (n=jml@mumak.net) |
| 03:15.22 | *** join/#storm stub (n=stub@ppp-58-8-209-38.revip2.asianet.co.th) |
| 03:21.28 | *** join/#storm vvinet (n=vince@modemcable041.205-203-24.mc.videotron.ca) |
| 05:35.28 | *** join/#storm jukart (i=lovely@81.189.156.94) |
| 05:46.06 | *** join/#storm keppla (n=keppla@i577B1B2A.versanet.de) |
| 06:41.19 | *** join/#storm bsdemon (n=bsdemon@mail.moneyps.ru) |
| 07:27.53 | *** join/#storm jkakar (n=jkakar@S0106001ee57a879c.vc.shawcable.net) |
| 08:28.20 | *** join/#storm zmijunkie (n=chatzill@92.117.40.121) |
| 08:33.20 | *** join/#storm keppla (n=keppla@i577B1B2A.versanet.de) |
| 10:45.08 | *** join/#storm stub (n=stub@ppp-58-8-18-218.revip2.asianet.co.th) |
| 10:50.35 | *** join/#storm maxb (n=maxb@jabberwock.vm.bytemark.co.uk) [NETSPLIT VICTIM] |
| 11:02.30 | *** join/#storm kazade (n=luke@81-144-192-162.evanspinner.mezzonet.net) |
| 11:04.01 | kazade | Hi all, yesterday I had to upgrade to MySQL 5.1 after 5.0 decided to never boot again after a crash. Anyway, one of our apps uses storm to connect to the db and since the upgrade it keeps crashing with "Commands out of sync; you can't run this command now" when we call store.commit() any ideas? |
| 11:09.52 | stub | kazade: from storm.tracer import debug; debug(True) |
| 11:10.06 | stub | kazade: That should let you see what is going on |
| 11:11.38 | kazade | ok thanks :) |
| 11:12.01 | kazade | I'm wondering if it's the python mysql library rather than storm |
| 11:14.26 | stub | Maybe, although if it needs to muck with the connection to set it up that should all be over by the time Storm gets near it. My guess is somehow a commit is being called without the transaction ever actually starting (ie. you are running in autocommit mode or whatever MySQL calls it) |
| 11:19.21 | kazade | this is what makes me suspicious of the python-mysqldb version: "If, after an upgrade, you experience problems with recompiled client programs, such as Commands out of sync or unexpected core dumps, you probably have used old header or library files when compiling your programs. " |
| 12:02.31 | *** join/#storm andrea-bs (n=andrea@host72-103-dynamic.30-79-r.retail.telecomitalia.it) |
| 12:09.35 | kazade | stub: solved it... there was some raw SQL running that ended with a "COMMIT;" which was then followed by a store.commit() later on.. apparently MySQL 5.0 ignores that and 5.1 doesn't or something |
| 12:27.43 | *** join/#storm sidnei (n=sidnei@plone/dreamcatcher) |
| 12:36.12 | *** join/#storm fcorrea (n=fcorrea@187.3.196.43) |
| 12:42.17 | *** join/#storm vvinet (n=vince@smtpin.revolutionlinux.com) |
| 12:56.17 | *** join/#storm niemeyer (n=niemeyer@200.203.78.33) |
| 15:16.34 | *** join/#storm jukart (i=lovely@81.189.156.94) |
| 16:40.28 | *** join/#storm niemeyer_ (n=niemeyer@189-10-169-134.cslce701.dsl.brasiltelecom.net.br) |
| 16:40.38 | *** join/#storm sidnei_ (n=sidnei@189-10-169-134.cslce701.dsl.brasiltelecom.net.br) |
| 16:47.06 | *** join/#storm niemeyer__ (n=niemeyer@200-203-6-87.cslce701.dsl.brasiltelecom.net.br) |
| 16:47.22 | *** join/#storm sidnei__ (n=sidnei@200-203-6-87.cslce701.dsl.brasiltelecom.net.br) |
| 17:09.06 | *** join/#storm jukart (n=jukart@d86-32-163-51.cust.tele2.at) |
| 17:40.08 | *** join/#storm vvinet (n=vince@ip92-220.natdynamique.USherbrooke.ca) |
| 17:43.07 | gabriel_ | I'm getting "RuntimeError: Reference used in an unknown class". Google brings up https://lists.ubuntu.com/archives/storm/2009-July/001074.html and https://lists.ubuntu.com/archives/storm/2007-September/000347.htmlbut I'm not using a Proxy (at least not explicitly). I tried digging around with winpdb, but didn't get anywhere (there are lots of restrictions on what I can call/access because the db cursor can only be used in one thread. |
| 17:43.07 | gabriel_ | It seems, though, that winpdb actually made the error disappear). Anyone able to explain what should cause this error? |
| 17:46.16 | *** join/#storm artista_frustrad (n=artista_@201-15-254-162.ctame704.dsl.brasiltelecom.net.br) |
| 17:46.18 | therve | gabriel_: can you show your classes definition? |
| 18:01.31 | gabriel_ | therve, sorry for the delay. the relevant parts are here: http://pastebin.ubuntu.com/268088/ |
| 18:02.51 | therve | gabriel_: where are User or ActionContexts tables? |
| 18:05.22 | gabriel_ | action_context is created from the base_attr_link_table template near the top. I'll post the user table in a second |
| 18:09.32 | gabriel_ | ok, revised version at http://pastebin.ubuntu.com/268096/ |
| 18:09.45 | gabriel_ | thanks for having a look |
| 18:10.18 | gabriel_ | therve, let me know if there's anything else i can post to help you out |
| 18:10.32 | therve | gabriel_: where does it fail exactly? on a particular reference? |
| 18:10.45 | therve | ha actions |
| 18:11.04 | gabriel_ | at the very bottom i have a snippet from the failing test |
| 18:11.46 | therve | gabriel_: it may come from the BaseAttribute |
| 18:12.08 | therve | there are some nasty tricks in the Storm class, maybe you can't use inheritance like that |
| 18:12.16 | therve | you could try to remove that class |
| 18:13.00 | gabriel_ | i'll give that a go, but i'm pretty sure i have another similar inheritance that works properly. Shall I paste that? |
| 18:14.27 | therve | gabriel_: if you could give a runnable example it would be easier |
| 18:17.12 | gabriel_ | therve, can i give you the whole project with test suite? or do you need me to make a new, less complex example? |
| 18:18.55 | therve | gabriel_: if I can run a simple command without having to setup a db, sure :) |
| 18:19.45 | gabriel_ | fwiw, this seems to work as I'd expect: http://pastebin.ubuntu.com/268108/ |
| 18:20.49 | gabriel_ | nope, just one command: python test_model.py |
| 18:21.13 | gabriel_ | that's why sqlite is so fantastic :) |
| 18:21.37 | gabriel_ | therve, i'll put it online in a second |
| 18:21.51 | therve | fantastic is a big word :) handy, ok |
| 18:27.05 | gabriel_ | therve, ok, you should be able to get it from http://gabrielgrant.ca/tmp/libtask.tar.gz |
| 18:28.18 | gabriel_ | if you unpack it and run test_model.py, it should execute a test suite in which exactly one test fails |
| 18:28.35 | gabriel_ | \me crosses fingers |
| 18:29.26 | therve | got it |
| 18:30.46 | therve | oh god tabs :) |
| 18:32.00 | gabriel_ | uhoh...can you stand it? :) |
| 18:33.46 | therve | gabriel_: ok so it's indeed the BaseAttribute class |
| 18:33.53 | therve | if I remove it it works |
| 18:39.48 | gabriel_ | hmm...did you have a look at http://pastebin.ubuntu.com/268108/? it seems to be pretty much the same thing, no? |
| 18:40.43 | gabriel_ | (that code is also around line 380 of model.py) |
| 18:41.09 | therve | gabriel_: well maybe you didn't test those? |
| 18:41.55 | therve | gabriel_: ah you're not using the ReferenceSet here |
| 18:42.00 | therve | only a Reference |
| 18:42.06 | therve | the ReferenceSet may not work |
| 18:44.14 | gabriel_ | ok, i guess that's plausible. You don't happen to know _why_ that might be the case, do you? |
| 18:44.43 | gabriel_ | and i guess the simple solution is to just duplicate the definitions from the superclass? |
| 18:44.50 | therve | yeah |
| 18:45.04 | therve | using inheritance for this is not really supported |
| 18:46.18 | gabriel_ | ok, fair enough. |
| 18:46.23 | gabriel_ | Thanks a ton for your help! |
| 18:47.07 | therve | no problem! |
| 19:14.02 | gabriel_ | therve, ah-ha! i just figured out what the problem was! |
| 19:14.51 | gabriel_ | the ReferenceSet declaration was actions = ReferenceSet(id, 'ActionContexts.context_id', 'ActionContexts.action_id', 'Action.id') |
| 19:15.39 | gabriel_ | but the id object was defined on the superclass, so it wasn't being found |
| 19:16.37 | gabriel_ | changing it to 'Context.id' or 'Tag.id', however, causes it to properly sort out the references after instantiation |
| 19:17.38 | gabriel_ | so it was a bug of mine, not a shortcoming of storm itself |
| 20:05.01 | *** join/#storm jkakar (n=jkakar@S0106001ee57a879c.vc.shawcable.net) |
| 21:10.26 | *** join/#storm jkakar (n=jkakar@S0106001ee57a879c.vc.shawcable.net) |
| 21:59.24 | *** join/#storm artista_frustrad (n=artista_@201-24-236-183.ctame704.dsl.brasiltelecom.net.br) |
| 22:50.21 | *** join/#storm rockstar (n=rockstar@starscream.eventuallyanyway.com) |
| 23:01.42 | *** join/#storm fcorrea (n=fcorrea@189-54-35-134-nd.cpe.vivax.com.br) |
| 23:21.50 | *** join/#storm sidnei (n=sidnei@plone/dreamcatcher) |