Team Chat Logs

February 1, 2010

2010 1
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
<< <   > >>

[00:01:35.960261]<Sp4rKy>coderanger_: it works, thanks :)
[00:14:25.793089]<otaku42>moin
[01:19:45.471658]<macmaN>mojito
[05:14:06.871812]<kirean>anyone using masterticketsplugin and postgres who've seen this: IntegrityError: duplicate key value violates unique constraint "mastertickets_pk"
[07:04:25.929067]<doki_pen>is there a way to do wikipedia style citations with trac's wiki?
[08:32:14.185271]<stockholm>i have a trac instance on top of postgresql 8.3, and people complain that its slow
[08:32:18.019957]<stockholm>how can i speed it up?
[08:33:05.479412]<stockholm>this is trac 0.11.1, it says
[08:34:06.152350]<cmc>slow for everything or slow for searching?
[08:35:26.535204]<stockholm>slow for example for report/1
[08:36:09.679067]<cmc>generate the sql for report/1 and then run explain analyze on it
[08:36:14.870495]<cmc>you can probably add indexes
[08:38:00.255534]<stockholm>yes, people on #postgresql remember the same, but dont recall which indexes they created
[08:38:06.287747]<stockholm>cmc: do you?
[08:38:34.141663]<stockholm>otaku42: do you recall?
[08:39:00.845253]<stockholm>otaku42: aparently you were the one talking to postgresql ppl regarding this, before
[08:39:08.312320]<cmc>explain analyze should tell you where it was taking a while
[08:39:46.718995]<stockholm>yes, i always wanted to learn about alalyze
[08:39:57.724297]<stockholm>but i hoped to fix this before dinner :-)
[08:40:08.095764]<cmc>hehe I understand
[08:40:58.419240]<cmc>definitely need an index on ticket id and custom_value.ticket and custom_value.name
[08:42:02.535897]<cmc>oh, but report/1 doesn't list custom fields
[08:42:47.734716]<cmc>I'd try removing the 'ORDER BY' clause to see if that speeds things up
[08:42:53.135113]<cmc>if not, perhaps an index on status
[08:59:07.337179]<stockholm>now lets see
[09:58:27.529140]<mperillo>hi
[09:58:41.477724]<cmc>hi
[09:58:59.104110]<mperillo>for a new Trac installation, is SQLite a good choice, or should I go with PostgreSQL?
[09:59:23.334034]<mperillo>I remember in the past there were same issues with sqlite
[09:59:39.024604]<mperillo>but some trac admin commands only works with sqlite
[09:59:41.971531]<cmc>depends on usage. if you will have just a few tickets, a few users, a few plugins, sqlite isn't too bad
[09:59:48.169026]<cmc>I like postgresql myself
[10:00:01.687295]<mperillo>I like postgresql, too
[10:00:02.901124]<cmc>which commands only work in sqlite that you need?
[10:00:42.053244]<mperillo>upgrade, if I remember correctly
[10:02:34.904926]<mperillo>or something related with doing a backup + restore of the database
[10:05:47.187889]<coderanger>upgrade works fine, we just force you to add --nobackup to the command line
[10:05:59.099993]<coderanger>and I think that is fixed for pgsql now, someone added a backup provider
[10:06:43.195484]<coderanger>the --nobackup thing is so you are 100% aware that Trac won't be backing up the DB for you, and upgrades are (in general) one wa
[10:06:45.171357]<coderanger>way
[10:07:37.160330]<mperillo>coderanger, ah, ok, thanks
[10:11:17.396674]<cmc>yeah, if you are using 11.6, just do a pg_dump of the db to make a backup
[10:28:12.563918]<flakrat>When adding an ESXi server to vCenter I chose to disable local administration by root, how do I re-enable that?
[10:28:20.903232]<flakrat>bah, wrong channel
[10:53:50.049311]<Computer>how can i get TracNotification to only send the email when a ticket is closed?
[10:53:54.866254]<Computer>and not when a ticket is opened/changed
[10:56:53.147510]<cmc>http://trac-hacks.org/wiki/FlexibleReporterNotificationPlugin gets pretty close
[11:42:11.572783]<IrCYop>Hey, my timeline in trac is not working properly. I will make a new ticket, and it will not show up on the timeline, but anything from 2 weeks ago you can see in the timeline. So it has this 2 week delay almost, but not only that, it seems to randomly place the tickets in that days timelime, example, in 01/04/10 or something, you will see ickets that are obviously created or edited before others, but will be in the wrong order on the timeline
[11:45:24.323242]<Sacho>what's your server's date?
[11:46:02.853273]<IrCYop>Wed Feb 3 02:11:38 CST 2010
[11:46:13.650271]<IrCYop>and my trac timeline goes up to 02/06/10
[11:46:22.437069]<IrCYop>for some reason
[11:46:37.206810]<IrCYop>and trac timeline thinks it is 02/03/10 right now
[11:46:52.674534]<IrCYop>or atleast thats the default date the timeline shows right now
[11:46:54.440423]<IrCYop>Sacho:
[11:47:11.929524]<IrCYop>which I can change
[11:47:16.816356]<IrCYop>by chaning the date
[11:47:19.973981]<Sacho>yeah
[11:47:38.141099]<Sacho>Not sure about the other symptoms, but the current date
[11:48:13.467321]<IrCYop>Sacho: i can sum this up easier, the timeline thinks tickets form 2 weeks ago were made yesterday
[12:57:35.608350]<Ghent>Hi, I am trying to install trac-trunk and getting this error: http://pastie.org/804788
[12:57:45.939320]<Ghent>I already have Genshi installed on the system
[13:10:00.900851]<IrCYop>Well timeline is working as expected now, just some tickets think they were changed or created more recently then they really were, but hopfully after a day when the next timeline day is shown, everything will be back to normal
[13:53:53.173703]<binbrain>I'm getting an error when I try to build a theme that it can't find the package TracThemeEngine
[13:54:07.484358]<binbrain>it looks like its looking for package in PyPi, but no such package exists
[14:00:59.813278]<binbrain>yeah, 2nd theme that fails to install because it can't fine TracThemeEngine
[19:41:22.317146]<ovnicraft>hi folks, i am trying to install tracmercurial plugin in trac 11.6, but when open my project tell me : Warning: Can't synchronize with the repository (/home/repos/geoempro does not appear to contain a Mercurial repository.). Look in the Trac log for more information.
[19:41:36.871284]<ovnicraft>i want to identify the error?
[19:41:56.680792]<ovnicraft>hg version 1.2.1
[19:42:05.027856]<ovnicraft>trac 0.11.6
[19:42:34.273059]<ovnicraft>and plugin was copied from http://svn.edgewall.org/repos/trac/plugins/0.11/mercurial-plugin
[19:43:50.732699]<ovnicraft>can help me here to identify the error?