Team Chat Logs

2006 11
Mo Tu We Th Fr Sa Su
        1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31

December 31, 2006

[00:00:20] <coderanger_> well actually probably not much
[00:00:33] <pacopablo> hehe, I'm actually trying to find a fairly unobtrusive patch for this :)
[00:00:57] <coderanger_> optimization can always come later anyway
[00:06:54] <tag-> pacopablo: know what would be causing this? http://www.blisted.org/blog?year=2006&month=2
[00:07:32] <tag-> says day is out of range for month, but the day is not specified
[00:07:52] * tag- wonders if maybe this isn't a bug that's already been fixed
[00:07:56] <pacopablo> yeah, but it's probably some leap-year bug that I have
[00:08:07] <pacopablo> I'm probably calculating the number of days in february wrong
[00:08:14] <tag-> well it seems to be every other month
[00:08:18] <pacopablo> really?
[00:08:18] <coderanger_> assuming he didn't change that code, it uses today's date if you don't give one
[00:08:20] <tag-> http://www.blisted.org/blog?year=2006&month=4
[00:08:29] <coderanger_> today is the 31st
[00:08:33] <tag-> http://www.blisted.org/blog?year=2006&month=6
[00:08:41] <coderanger_> so any month without 31 days still error
[00:08:45] <coderanger_> er, will
[00:08:47] <pacopablo> ahh, yes
[00:08:53] <pacopablo> very nice catch coderanger
[00:09:05] <tag-> I see
[00:09:12] <pacopablo> tag-: can you file a bug on t-h.o please?
[00:09:16] <tag-> sure
[00:09:16] <pacopablo> I'll try to fix it soon
[00:09:40] <pacopablo> I need to give some loving to the blog plugin again
[00:13:08] <tag-> yes
[00:13:10] <tag-> loving
[00:13:17] <tag-> I've been trying to give loving to personal projects this weekend
[00:13:20] <coderanger_> heh, I still need to port a bunch of your calendar enhancements back to the code I took it from
[00:13:29] <tag-> I fixed some test suite today that's been broken for the better part of 2 years :-P
[00:13:32] <coderanger_> though I probably never will
[00:18:57] <coderanger_> happy new year to y'all
[00:19:36] <pacopablo> happy new year (allbeit close to 24 hours too early)
[00:49:10] * real-dev has left #trac
[00:52:13] <pacopablo> well, definitely happier now that I have found that UNIX sockets will work already in 0.10.3
[00:52:35] <pacopablo> postgres://user:pass@/dbname?host=/path/to/socket/dir
[00:52:43] <pacopablo> thanks matt_good
[00:59:02] * xjjk has quit IRC
[00:59:58] <pacopablo> night all
[01:16:28] <matt_good> pacopablo: Trac doesn't use SQLAlchemy, I'm not sure what the Trac URI is for using PG sockets
[02:19:46] * m_g has joined #trac
[04:06:02] * lowkey has joined #trac
[04:55:00] * dimi3 has joined #trac
[05:05:58] * idnar_ has quit IRC
[05:47:19] * dimi3 has quit IRC
[06:05:18] * mario_ has joined #trac
[06:20:59] * pygi has quit IRC
[06:37:53] * matt_good has quit IRC
[06:40:06] * matt_good has joined #trac
[07:44:09] * lnayrb has joined #trac
[07:50:09] * iXce has joined #trac
[07:50:15] <iXce> hi ^_^
[07:50:23] <mario_> hi iXce
[07:50:51] <iXce> i'm getting a "RuntimeError: maximum recursion limit exceeded" when viewing the report page :/
[07:51:12] <mario_> you're having how many tickets? :)
[07:51:16] <iXce> only the pages with all the active tickets though, other pages are working well
[07:51:17] <iXce> err
[07:51:30] <iXce> ~ 300 tickets on the bugged pages
[07:51:45] <mario_> that's not too much :-/
[07:51:50] <iXce> no :/
[07:51:58] <iXce> and that worked before
[07:52:27] <mario_> before - you did any changes?
[07:52:44] <iXce> in fact i had awful load problems on the server it was on before
[07:52:56] <iXce> so i just moved it to another server
[07:53:36] <mario_> iXce, load problems = fcgi?
[07:53:40] <iXce> yep
[07:53:51] <mario_> eh, can you move to mod_python ?
[07:53:59] <mario_> that solves problems, at least it did for me
[07:54:00] <iXce> it's a lighttpd server
[07:54:03] <mario_> iXce, oh
[07:54:13] <mario_> I had load 9.xx on one of the servers with fcgi :-/
[07:54:18] <iXce> the new one is using apache though
[07:54:19] <iXce> yeah
[07:54:26] <iXce> i know what you felt :p
[07:54:40] <mario_> :p
[07:55:18] <iXce> the fact is that i already had such an error
[07:55:31] <mario_> and solved it how?
[07:55:32] <iXce> but i solved it by reinstalling *i can't remember which* a package
[07:55:37] <mario_> :P
[07:55:40] <iXce> :p
[07:56:01] <mario_> sudo apt-get remove * --purge && sudo apt-get install * :)
[07:56:16] <iXce> :p
[07:56:30] <mario_> would that work or is not debianish server?
[07:56:38] <mario_> :P
[07:56:40] <iXce> it's debian :p
[07:56:50] <mario_> oh, good, so there's your solution :)
[07:57:01] <mario_> now, lemme try to think of a more effective and less devastating one :P
[07:57:04] <iXce> :p
[07:57:47] <mario_> you tried restarting web server?
[07:58:14] <iXce> yep
[07:58:17] <iXce> at least.. 100 times :p
[07:58:25] <mario_> ok, so that won't work :P
[07:59:36] * bryanl has quit IRC
[08:00:58] <mario_> iXce, what's the url where you see error?
[08:01:06] <mario_> unless it's ultra-secret
[08:02:02] <iXce> http://bugs.beryl-project.org/report/1
[08:02:06] <iXce> it's not :p
[08:02:39] <mario_> o right, the beryl one
[08:02:42] <mario_> I remember you now :)
[08:02:50] <iXce> hehe
[08:02:57] <iXce> i've had an awful lot of problems :p
[08:03:25] <iXce> but I love trac <3 (everyone tells me to use bugzilla, but it's not as much polished & featureful as trac :/)
[08:03:36] <mario_> yea, well ... trac rocks ^_^
[08:03:40] <mario_> and btw. /me is pygi :P
[08:03:44] <mario_> if you remember in any case :)
[08:03:50] <iXce> ah yeah :p
[08:03:57] <iXce> mmh
[08:04:11] <iXce> didn't you say once to delete all the tickets to fix this error? :p
[08:04:24] <mario_> lol, no? :P
[08:04:41] <iXce> you did :p
[08:04:42] <iXce> http://pacopablo.com/irclogs/2006/12/03
[08:04:42] <mario_> what a funny solution would that be ? :p
[08:04:51] <iXce> [13:20:53] <hatezilla> RuntimeError: maximum recursion limit exceeded
[08:04:52] <iXce> [13:23:37] <pygi> hatezilla, DELETE * from tickets;
[08:05:02] <iXce> :)
[08:05:12] <mario_> ah, right, I know that :P
[08:05:29] <iXce> :)
[08:05:44] <mario_> but I think that was another problem :P
[08:05:46] <mario_> or perhaps not :)
[08:05:56] <iXce> well he got spammed
[08:06:00] <iXce> so.. :)
[08:06:56] <mario_> oh, right :P
[08:07:08] <mario_> well, he could have just used delete ticket if it wasn't all tickets :P
[08:09:46] <mario_> iXce, perhaps there is some ticket which contains some form of error?
[08:09:52] * mario_ is running out of ideas quickly
[08:10:16] <iXce> hm perhaps
[08:10:23] <iXce> should i go through the tickets one by one?
[08:10:34] <mario_> not really, too much tickets to do that
[08:10:41] <mario_> and I don't know which kind of error should that be
[08:10:45] <iXce> hehe
[08:12:44] <mario_> iXce, hm, according to trac tickets, such problems may have been caused by "bad" or "faulty" comments
[08:13:00] <iXce> yeah
[08:13:10] <iXce> maybe can i dump all the latest comments?
[08:13:17] <mario_> but the problem seem to have been fixed in 9.x
[08:13:25] <iXce> yeah that's what i saw
[08:14:09] <mario_> when did the problem appear?
[08:14:43] <iXce> when i changed machine :p
[08:15:00] <iXce> btw i was using python2.4 on the one and python2.3 on the new one
[08:15:12] <mario_> ah, could try py2.4?
[08:15:23] <iXce> mh maybe
[08:15:41] <mario_> and uhm, the site is very very slow
[08:15:41] <iXce> but i'd have to recompile the plugins & mod_python
[08:15:47] <iXce> yeah
[08:15:54] <iXce> there's nothing else than trac there
[08:16:02] <mario_> !!!
[08:16:13] <iXce> and load ~ 0.3
[08:16:29] <mario_> load is not too big, but it's just 1 user there, or 2 :-/
[08:17:14] <iXce> heh
[08:17:35] <mario_> 5 years to open something :/
[08:17:41] * mario_ looks into it more
[08:17:43] <iXce> :/
[08:18:03] <iXce> load average: 0.25, 0.27, 0.36
[08:20:28] <mario_> iXce, what about backing up database, and removing all comments?
[08:20:41] <iXce> hehe why not
[08:20:43] <mario_> if that's the error, we'll restore and find out together which comment/s are false
[08:20:57] <iXce> just cp the trac.db?
[08:21:04] <mario_> I guess so, yes :)
[08:23:48] <iXce> err
[08:23:48] <iXce> wow
[08:23:55] <mario_> what? :)
[08:23:59] <iXce> Internal Server Error Oo
[08:26:17] <mario_> o.O
[08:26:47] <iXce> [error] [client 88.191.30.32] PythonHandler trac.web.modpython_frontend: DatabaseError: file is encrypted or is not a database
[08:26:50] <iXce> interesting joke
[08:26:56] <mario_> ahm, you have a new database? :P
[08:28:28] <iXce> that's.. strange oO
[08:28:57] <mario_> iXce, what's strange? :P
[08:29:15] <iXce> this bad error :(
[08:29:16] <iXce> :p
[08:30:27] <mario_> well, do you have new trac.db? :P
[08:30:33] <iXce> i have backups
[08:30:39] <iXce> but it's not better
[08:30:46] <iXce> i installed another python sqlite package
[08:30:48] <iXce> might be the problem :p
[08:31:25] <iXce> ahh way better
[08:32:00] <iXce> note: never EVER install python-pysqlite2
[08:32:00] <mario_> do an resync
[08:32:07] <mario_> trac-admin resync :)
[08:32:26] <iXce> yep
[08:32:45] <iXce> just the 2nd one todya
[08:32:54] <mario_> lol, db locked :P
[08:34:03] <iXce> okay
[08:34:10] <iXce> time to backup again :p
[08:34:21] <mario_> yep
[08:34:35] <iXce> and then?
[08:34:40] <iXce> sqlite trac.db?
[08:34:45] <mario_> well, erase all comments:P
[08:34:54] <mario_> perhaps: DELETE * from COMMENTS :)
[08:34:57] <mario_> perhaps: DELETE * from COMMENTS; :)
[08:35:40] <iXce> SQL error: near "*": syntax error ^^
[08:36:24] <iXce> SQL error: no such table: comments
[08:37:40] <iXce> maybe the table ticket_change ?
[08:38:38] <dcj> hey i've just been lurking here ...
[08:38:44] <dcj> but i might be reinventing the wheel
[08:39:07] <dcj> does anybody know an existing effort to put all of Trac's dependencies into a single self-referential bundle, for standalone operation?
[08:40:16] <iXce> no idea, sorry :/
[08:40:54] <mario_> iXce, ah, I dunno how the table is called :-/
[08:41:02] <mario_> you could list all tables, and do a guessing :P
[08:41:25] <iXce> i think it's ticket_change :p
[08:42:15] <mario_> ok, well, delete it then:P
[08:42:22] * ktne has joined #trac
[08:42:40] <dcj> iXce: well at least if you have no idea, there's a chance I'm not reinventing the wheel :)
[08:42:48] <iXce> i did it, no success :p
[08:43:01] <mario_> iXce, so no such table ? :)
[08:43:05] <mario_> just list the tables :P
[08:43:09] <iXce> no
[08:43:17] <iXce> i mean, it dropped the comments
[08:43:24] <iXce> (i listed the table to find the good one :p)
[08:43:26] <mario_> oh :P
[08:43:33] <mario_> and still same problem?
[08:43:33] <iXce> but still the same error
[08:43:35] <iXce> yep
[08:43:39] <mario_> what about deleting tickets this time? :)
[08:44:23] <iXce> works alot better
[08:44:29] <iXce> :p
[08:45:37] <mario_> yay :)
[08:45:45] <mario_> now we know some ticket 'causes problem :P
[08:46:06] <iXce> yep
[08:46:12] <mario_> ok, restore backup
[08:46:28] <iXce> done
[08:46:35] <iXce> i dumped the tickets too
[08:46:40] <iXce> putting it online for you :p
[08:46:52] <mario_> lol :)
[08:47:09] <iXce> is it sensible data?
[08:47:17] <iXce> or can i just paste the url here? :p
[08:47:26] <mario_> do whatever you want
[08:47:29] <iXce> http://guillaume.segu.in/tickets
[08:48:56] <mario_> iXce, could you wait 10 mins?
[08:49:07] <mario_> I have to drive someone somewhere :P
[08:49:10] <iXce> sure
[08:49:13] <mario_> thanks :)
[08:49:16] <iXce> have fun ^^
[08:49:31] <mario_> look for weird characters, or very very very long ticket descriptions
[08:49:41] <mario_> or anything that might look broken, then we'll discuss once I'm back :P
[08:49:56] <iXce> kk :)
[08:51:19] * maxb has joined #trac
[08:58:28] <coderanger_> dcj: There is a script for it for Windows
[08:59:04] <coderanger_> Other platforms already have package management tools
[09:11:43] <dcj> coderanger_: just to install everything though, right?
[09:11:53] <coderanger_> yes
[09:11:58] <dcj> coderanger_: i'm thinking along the lines of everything in a container that can be drag-dropped between machines
[09:12:07] <coderanger_> If you want a drop in tool, there are several vmware images for trac
[09:12:13] <coderanger_> vmtrac and buildix for example
[09:12:19] <dcj> coderanger_: specifically for an unorthodox use - single SQLite local "project" documents
[09:12:47] <dcj> basically i'm thinking of a desktop single-user version of Trac
[09:13:20] <coderanger_> beyond the VMWare images, I don't know of anything to handle that simply I suppose
[09:13:27] <dcj> cool, thanks :)
[09:13:33] <coderanger_> I have some funky bash scripts, but they are pretty specific to me
[09:13:41] <dcj> so far I'm just slowly pulling all the dependencies in and massaging PYTHONPATH etc to make it work
[09:13:49] <coderanger_> and geared to development anyway
[09:14:04] <dcj> i was able to install trac with an alternate prefix to get it to point to itself correctly
[09:14:27] <dcj> now i'm just going down the list of deps like pysvn, etc
[09:14:46] <coderanger_> pysvn isnt a dep ;-)
[09:14:59] <dcj> just a "very nice" ? :)
[09:15:04] <coderanger_> http://coderanger.net/~coderanger/trac_bashrc
[09:15:14] <coderanger_> nope, not related to Trac at all
[09:15:21] <coderanger_> Trac uses the SWIG bindings, not PySVN
[09:15:37] <dcj> ooooh
[09:15:42] <dcj> glad I asked :)
[09:16:05] <dcj> i am getting an "unknown repository type "svn""
[09:16:08] <dcj> and I jumped to conclusison
[09:16:17] <dcj> thanks for the bashrc there is some great stuff in there
[09:16:21] <coderanger_> within that bashrc look at tset, tversion, and tserver
[09:16:33] <coderanger_> they manage which trac version/env is active
[09:16:42] <coderanger_> as well as running a distro server
[09:17:31] <coderanger_> that error means the SWIG bindings arent installed
[09:17:42] <dcj> ah -- sort of obvious now that I think of it
[09:17:51] <dcj> i'mm testing on a virgin os x machine
[09:17:55] <dcj> where all these bugs show up
[09:18:05] <dcj> (since I have all the libs installed globally on my main machine)
[09:18:25] <dcj> so that means reinstall svn with the swig flags, right?
[09:18:26] <dcj> it's been a while
[09:18:33] <coderanger_> @wiki TracSubversion
[09:18:33] <evil_twin> coderanger_: http://trac.edgewall.org/wiki/TracSubversion
[09:18:44] * coderanger_ is now known as coderanger
[09:19:02] <dcj> ah yes - many many thanks
[09:20:20] <mario_> iXce, I'm back
[09:20:48] <iXce> wb mario_ ^^
[09:20:51] <iXce> i found nothing interesting :/
[09:21:17] <mario_> iXce, thanks ...
[09:21:18] <iXce> there are lots of tickets with quite long desc
[09:21:20] <mario_> and ah :-/
[09:21:38] <mario_> iXce, drop one by one? :/
[09:23:55] <iXce> :/
[09:24:01] <mario_> iXce, I agree :/
[09:24:12] <mario_> iXce, hm, could we write a test script?
[09:24:25] <mario_> which drops ticket one by one, and reports if there's still error?
[09:24:29] <mario_> if no error, stop dropping
[09:24:37] <mario_> but ofcourse, if we drop one, and still error, we restore that one
[09:24:43] <mario_> and go to next
[09:25:05] <coderanger> whats the error?
[09:26:03] <mario_> coderanger, http://bugs.beryl-project.org/report/1
[09:26:04] <mario_> this
[09:26:46] <coderanger> whats plugins are installed
[09:27:15] <mario_> you'll have to ask iXce :)
[09:27:16] <iXce> mario_ : hm yeah why not!
[09:27:22] <iXce> coderanger : mmh
[09:27:24] <iXce> webadmin
[09:27:27] <iXce> accountmanager
[09:27:29] <iXce> xmlrpc
[09:27:34] <iXce> spamfilter
[09:27:36] * User580 has joined #trac
[09:27:37] <Miron_> And what is the raw text of the ticket? The wiki_to_html is having the issues.
[09:27:38] <iXce> iniadmin
[09:28:02] <iXce> (and that's all ^^)
[09:28:38] <iXce> Miron_ : well, one of the 300 tickets that are processed on that page :x
[09:29:16] * User580 has quit IRC
[09:29:42] * mario_ is now known as pygi
[09:30:19] <Miron_> What if you setup a script to check each ticket?
[09:30:39] <iXce> mmh
[09:30:43] <iXce> i've no clue on how to do that :x
[09:30:54] <iXce> i'm a PHP/C coder, not python >.<
[09:32:24] <coderanger> one sec
[09:32:26] <coderanger> checking
[09:32:27] <Miron_> How many tickets total?
[09:32:32] <coderanger> 617
[09:32:39] <coderanger> the check script is running
[09:33:17] <coderanger> takes about 1 second per ticket, so itl take a minute
[09:33:21] <coderanger> or 10
[09:33:30] <iXce> oh ^^
[09:34:41] <coderanger> probably some awful wiki markup
[09:46:57] <Miron_> Ticket 520.
[09:47:22] <iXce> h
[09:47:23] <iXce> ah
[09:47:47] <iXce> right
[09:48:35] <iXce> wow thanks :)
[09:48:54] <iXce> hm right
[09:49:00] <iXce> the description was damn long
[09:49:07] <iXce> (dump here : http://guillaume.segu.in/tickets)
[09:49:40] <iXce> thanks you very very much Miron_ ^^
[09:49:57] <iXce> would you mind sharing the script you used? :)
[09:50:05] <pygi> coderanger, where do you find that script btw.? :P
[09:50:12] <coderanger> I wrote it in about 10 seconds
[09:50:18] <pygi> iXce, how long was description ?:)
[09:50:19] <coderanger> heh, yep
[09:50:22] <coderanger> 520 just got flagged
[09:50:23] <pygi> coderanger, well, share :P
[09:50:35] <coderanger> gotta wait for it to finish
[09:50:56] <pygi> oh, oki
[09:51:09] <iXce> around 300 lines
[09:51:26] <coderanger> its not the size that really matters
[09:51:31] <coderanger> its that it was unescped
[09:51:38] <Miron_> paste?
[09:51:45] <iXce> http://guillaume.segu.in/520
[09:51:45] <coderanger> so the core dump was being processed as wiki texts
[09:52:07] <iXce> ahh ok
[09:52:17] <coderanger> http://coderanger.net/~coderanger/check.py
[09:52:21] <iXce> ty
[09:52:58] <iXce> damn easy ^^
[09:53:06] <coderanger> not sure who in their right mind pastes a core dump as text though
[09:53:18] <coderanger> ain't python great like that ;-)
[09:53:27] <iXce> bbl (dinner :))
[09:54:17] <Miron_> My script looks very similar, but not so well done.
[09:59:08] <pygi> :P
[10:31:38] <pygi> well, why does trac still shows up that weird popup when I click login when it shouldn't? :)
[12:35:12] * jpatota has quit IRC
[14:06:18] * xjjk has joined #trac
[14:26:37] * anotherjesse has joined #trac
[14:28:28] <anotherjesse> Anyone else had a problem when using trac via fcgi through lighttpd with it failing with IOError: [Errno 13] Permission denied: '/trac/jesse/VERSION'
[14:28:34] <anotherjesse> args = (13, 'Permission denied')
[14:28:35] <anotherjesse> errno = 13
[14:28:35] <anotherjesse> filename = '/trac/jesse/VERSION'
[14:28:35] <anotherjesse> strerror = 'Permission denied'
[14:29:33] <anotherjesse> (http://code.overstimulate.com/ shows the full traceback)
[14:35:43] <coderanger> make sure that the web server user has read access to the env
[14:35:50] <coderanger> and r/w on the db folder
[14:37:35] * anotherjesse has quit IRC
[14:40:55] * lnayrb is now known as bryanl
[15:25:32] * lightcap has joined #trac
[15:27:55] * lightcap has quit IRC
[15:28:00] * lightcap has joined #trac
[15:38:55] * boorad_ has joined #trac
[15:45:07] * boorad__ has joined #trac
[15:52:19] * boorad_ has quit IRC
[15:52:51] * boorad_ has joined #trac
[15:53:16] * boorad has quit IRC
[15:55:02] * boorad__ has quit IRC
[16:06:31] <alect> happy new year!
[16:11:39] <prologic> you too!
[16:18:46] <iXce> happy new year! thanks :)
[16:43:54] * m_g has quit IRC
[17:03:22] * anotherjesse has joined #trac
[17:04:24] * tenshiKur0 has joined #trac
[17:06:57] * bryanl has quit IRC
[17:13:52] * tenshiKur0 has quit IRC
[17:15:30] * matt_good has quit IRC
[17:24:07] * matt_good has joined #trac
[17:37:09] * boorad__ has joined #trac
[17:52:13] * boorad_ has quit IRC
[17:58:45] * ktne has quit IRC
[18:14:33] * boorad__ is now known as boorad
[18:19:08] * Epcylon has quit IRC
[18:19:08] * agile has quit IRC
[18:19:08] * homeasvs__ has quit IRC
[18:19:08] * termie has quit IRC
[18:19:08] * mnemoc has quit IRC
[18:19:08] * morfoh has quit IRC
[18:19:08] * Synapse has quit IRC
[18:19:08] * matt_good has quit IRC
[18:19:08] * pygi has quit IRC
[18:19:08] * s0undt3ch has quit IRC
[18:19:08] * omry has quit IRC
[18:19:08]