Need Roller 2.0.1 release to address PostgreSQL upgrade problems

2005-12-05 Thread Dave Johnson
Serious problems with PostgreSQL upgrades and Roller 2.0: - The PostgreSQL upgrade script fails - The upgrade database on startup fails for PostgreSQL Here's the bug report: http://opensource2.atlassian.com/projects/roller/browse/ROL-910 I created a branch for Roller 2.0 maintenance and

Switch to Velocity based database script generation

2005-12-05 Thread Dave Johnson
Fixing that PostgreSQL upgrade problem was extremely painful with our text-replace based database script generation technique. Take a look at the stuff I committed yesterday if you don't believe me. So after I finished the work, I replaced the text-replace stuff with a much more powerful

Re: Roller 2.1-dev stability problems

2005-12-05 Thread Dave Johnson
I added the RequestFilter back into the chain saturday and the blank screen problems have completely disappeared, but I did get a crash on Sunday. The JVM again disappeared without leaving any log messages. This is significant; I haven't see crashes like this before. - Dave On Dec 3, 2005,

Re: Switch to Velocity based database script generation

2005-12-05 Thread Matt Raible
I haven't been involved with generating any of the database scripts - but I believe it can be simplified, and this looks like a good way to do it. +1 Matt On 12/5/05, Dave Johnson [EMAIL PROTECTED] wrote: Fixing that PostgreSQL upgrade problem was extremely painful with our text-replace based

Re: Switch to Velocity based database script generation

2005-12-05 Thread Anil Gangolli
+1 Big Yes! I had been suggesting Velocity-based generation of these too, and was just waiting for a good time to push this. I'm not as confident in the use of the Texen task to drive it, but that's an excellent start and it may suffice. I'd like to encourage the use of more

Re: Switch to Velocity based database script generation

2005-12-05 Thread Allen Gilliland
I am fine with pretty much anything that would improve our current db scripting process, but in truth, I'm not sure that I see much of a difference between this new method and the old one. -- Allen On Mon, 2005-12-05 at 07:36, Anil Gangolli wrote: +1 Big Yes! I had been suggesting

Admin Guide 2.x?

2005-12-05 Thread Anil Gangolli
Is someone still writing AdministrationGuide_2.x? I couldn't find it. There is http://rollerweblogger.org/wiki/Wiki.jsp?page=AdministrationGuide_1.x, and I'm looking for a home for the material there that still applies in 2.x. Should I just copy that for now? --a.

Re: Roller 2.1-dev stability problems

2005-12-05 Thread Dave Johnson
Well, don't I feel like an ID10T now. I just committed a fix for that. Thanks Anil! - Dave On Dec 5, 2005, at 11:09 AM, Anil Gangolli wrote: Dave, I still see the System.exit() calls I had mentioned finding in the run() (not main()) method of the TurnoverReferersTask and this is likely

Re: Roller 2.1-dev stability problems

2005-12-05 Thread Allen Gilliland
Dave, were you able to gather any more info about when the blank screen problem was happening on your site? like what the url was, what the cache key was, what the response code was, etc? It sounds like this is something wrong with how the request stack is being processed. If simply moving the

Re: Roller 2.1-dev stability problems

2005-12-05 Thread Allen Gilliland
On Mon, 2005-12-05 at 09:51, Dave Johnson wrote: On Dec 5, 2005, at 12:38 PM, Allen Gilliland wrote: were you able to gather any more info about when the blank screen problem was happening on your site? like what the url was, what the cache key was, what the response code was, etc? It

Re: Switch to Velocity based database script generation

2005-12-05 Thread Allen Gilliland
i just tried the upgrade script on hsql and it didn't work properly. hsql complained about the alter table foo alter lines. is there a reason why we are doing it in multiple lines rather than in a single line? i.e. i currently see ... alter table roller_comment add column approved bit; alter

Re: Switch to Velocity based database script generation

2005-12-05 Thread Dave Johnson
On Dec 5, 2005, at 2:25 PM, Allen Gilliland wrote: i just tried the upgrade script on hsql and it didn't work properly. hsql complained about the alter table foo alter lines. is there a reason why we are doing it in multiple lines rather than in a single line? i.e. Yes. PostgreSQL won't