You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@roller.apache.org by David M Johnson <Da...@Sun.COM> on 2006/03/24 04:48:16 UTC
Roller 2.2-rc1-incubating is available
Roller 2.2 RC1 is available for testing.
You can het it here:
http://people.apache.org/~snoopdave/roller-2.2-rc/
User and install docs are in the same directory.
The upgrade guide is now in Appendix A of the install guide.
- Dave
On Mar 23, 2006, at 3:40 PM, Dave Johnson wrote:
> Today is the 2nd to last Thursday in the month: Release Candidate day
> http://rollerweblogger.org/wiki/Wiki.jsp?page=RollerReleasePlan
>
> I think we have made more than enough progress for a release, so
> I'm planning on putting together Roller 2.2-incubating RC1 today.
>
> Enhancements made and bugs fixed
>
> If you take a look at the issue list for Roller 2.2 (http://
> tinyurl.com/d3cwa), you'll see that we have 25 of 42 issues marked
> as RESOLVED. Those are the issues that Allen and I have verified
> and most (if not all) of them have actually been deployed to
> production sites. The remaining issues are marked as IN PROGRESS.
> They have all been addressed too and for the next week, we'll be
> working to verify them -- and we'd love any help we can get.
>
> Documentation updates
>
> The Roller 2.2 What's New guide is up to date
> http://rollerweblogger.org/wiki/Wiki.jsp?page=Roller_2.2_WhatsNew
>
> The User Guide and Install Guide have been updated for 2.2.
> http://people.apache.org/~snoopdave/roller-2.2-rc/
>
> The Javadocs have been updated:
> http://rollerweblogger.org/javadoc/
> (old docs are here: http://rollerweblogger.org/javadoc_2.0)
>
> The Velocidocs have been updated:
> http://rollerweblogger.org/velocidoc/
> (old docs are here: http://rollerweblogger.org/velocidoc_2.0)
>
> - Dave
Re: Roller 2.2-rc1-incubating is available
Posted by Allen Gilliland <Al...@Sun.COM>.
Yes, this is definitely a bug.
The monthly display page should do exactly what you expect, which is to
show all entries from the given month.
-- Allen
Oscar del Rio wrote:
> There seems to be a bug with the new YYYYMM month entries;
> it *starts* on the first day of the month and *back* to the
> previous month. If there are no posts on the first of the
> month, all entries are from the previous month (MM-1)
>
> Example:
> http://blogs.mie.utoronto.ca/roller/page/oscar/200510
> shows only September (200509) entries instead of October.
>
> Perhaps YYYYMM should start with the *last* day of the month
> and back N entries.
Re: Roller 2.2-rc1-incubating is available
Posted by David M Johnson <Da...@Sun.COM>.
This issue is now known as ROL-1096
http://opensource.atlassian.com/projects/roller/browse/ROL-1096
Thanks,
Dave
On Mar 25, 2006, at 6:40 PM, Oscar del Rio wrote:
> There seems to be a bug with the new YYYYMM month entries;
> it *starts* on the first day of the month and *back* to the
> previous month. If there are no posts on the first of the
> month, all entries are from the previous month (MM-1)
>
> Example:
> http://blogs.mie.utoronto.ca/roller/page/oscar/200510
> shows only September (200509) entries instead of October.
>
> Perhaps YYYYMM should start with the *last* day of the month
> and back N entries.
Re: Roller 2.2-rc1-incubating is available
Posted by Oscar del Rio <de...@mie.utoronto.ca>.
There seems to be a bug with the new YYYYMM month entries;
it *starts* on the first day of the month and *back* to the
previous month. If there are no posts on the first of the
month, all entries are from the previous month (MM-1)
Example:
http://blogs.mie.utoronto.ca/roller/page/oscar/200510
shows only September (200509) entries instead of October.
Perhaps YYYYMM should start with the *last* day of the month
and back N entries.
Re: Roller 2.2-rc1-incubating is available
Posted by Allen Gilliland <Al...@Sun.COM>.
Oscar,
I believe the new functionality is intentional so a single day archive
only shows entries from that day, and I think that makes the most sense.
I don't think that when someone tries to show entries from Oct 10,
2005 that it should show entries not from that day.
So I don't consider this a bug.
-- Allen
Oscar del Rio wrote:
> David M Johnson wrote:
>> Roller 2.2 RC1 is available for testing.
>>
>> You can het it here:
>> http://people.apache.org/~snoopdave/roller-2.2-rc/
>
> Thanks, Dave. I'm testing 2.2rc1 and so far so good :-)
>
> except for the Prev/Next entries navigation that now allows
> navigation to older posts by linking to the appropriate
> YYYYMMDD entries: when you go to Prev entries it shows only the
> entries for one day (usually just one entry for most bloggers).
>
> In 2.1, YYYYMMDD shows N entries starting at the given date
> which I think is what the reader would expect when they navigate
> back and forth (from one page with N entries to another page with
> also N entries).
>
> Is that a bug, or was the YYYYMMDD code changed to show only
> blogs for the given date.
>
> Thanks again
>
> Oscar
>
Re: Roller 2.2-rc1-incubating is available
Posted by Oscar del Rio <de...@mie.utoronto.ca>.
David M Johnson wrote:
> Roller 2.2 RC1 is available for testing.
>
> You can het it here:
> http://people.apache.org/~snoopdave/roller-2.2-rc/
Thanks, Dave. I'm testing 2.2rc1 and so far so good :-)
except for the Prev/Next entries navigation that now allows
navigation to older posts by linking to the appropriate
YYYYMMDD entries: when you go to Prev entries it shows only the
entries for one day (usually just one entry for most bloggers).
In 2.1, YYYYMMDD shows N entries starting at the given date
which I think is what the reader would expect when they navigate
back and forth (from one page with N entries to another page with
also N entries).
Is that a bug, or was the YYYYMMDD code changed to show only
blogs for the given date.
Thanks again
Oscar
Fwd: Roller 2.2-rc2-incubating is available
Posted by David M Johnson <Da...@Sun.COM>.
I forgot to include roller-users.
Begin forwarded message:
> From: David M Johnson <Da...@Sun.COM>
> Date: March 27, 2006 5:45:49 PM EST
> To: roller-dev@incubator.apache.org
> Subject: Roller 2.2-rc2-incubating is available
> Reply-To: roller-dev@incubator.apache.org
>
> A new release candidate (RC) is ready for testing: Roller 2.2-rc2-
> incubating.
>
> You can get the new RC here:
> http://people.apache.org/~snoopdave/roller-2.2-rc/
>
> Updated User and install docs are in the same directory (thanks Anil)
>
> And these bugs found in RC1 were addressed (thanks Oscar and Axel):
>
> ROL-1094 Error adding new subscription in planet
> http://opensource.atlassian.com/projects/roller/browse/ROL-1094
>
> ROL-1096 Month view shows wrong month
> http://opensource.atlassian.com/projects/roller/browse/ROL-1096
>
> ROL-1097 Problem with encoded HTML in titles in RSS feeds
> http://opensource.atlassian.com/projects/roller/browse/ROL-1097
>
> - Dave
>
>
> PS. And here's what's new in 2.2:
> http://rollerweblogger.org/wiki/Wiki.jsp?page=Roller_2.2_WhatsNew
>
Roller 2.2-rc2-incubating is available
Posted by David M Johnson <Da...@Sun.COM>.
A new release candidate (RC) is ready for testing: Roller 2.2-rc2-
incubating.
You can get the new RC here:
http://people.apache.org/~snoopdave/roller-2.2-rc/
Updated User and install docs are in the same directory (thanks Anil)
And these bugs found in RC1 were addressed (thanks Oscar and Axel):
ROL-1094 Error adding new subscription in planet
http://opensource.atlassian.com/projects/roller/browse/ROL-1094
ROL-1096 Month view shows wrong month
http://opensource.atlassian.com/projects/roller/browse/ROL-1096
ROL-1097 Problem with encoded HTML in titles in RSS feeds
http://opensource.atlassian.com/projects/roller/browse/ROL-1097
- Dave
PS. And here's what's new in 2.2:
http://rollerweblogger.org/wiki/Wiki.jsp?page=Roller_2.2_WhatsNew
Re: New website table
Posted by Elias Torres <el...@torrez.us>.
David M Johnson wrote:
> We have XML driven name/value properties at the site-wide level.
>
> I wonder if we should have the same thing at the website/weblog level?
>
> - Dave
>
Very interesting observation Dave.
This is what RDF is about "triples". A triple would be:
{ website property value }
{ weblog property value }
{ site property value }
We could do all of them in a single table.
-Elias
>
>
>
> On Mar 28, 2006, at 8:01 PM, Allen Gilliland wrote:
>> Elias Torres wrote:
>>> David M Johnson wrote:
>>>>
>>>> On Mar 28, 2006, at 1:25 PM, Elias Torres wrote:
>>>>> Did you guys had a chance to look at this message?
>>>>
>>>> Do you have some specific proposal for fixing this?
>>> Breakout some of the big properties into a separate table?
>>
>> huh? that sounds wacky to me. you are saying we need to move data
>> outside of the website table into different tables? i don't see how
>> that could be the case.
>>
>>>>
>>>> What if we dropped the old ignoreWords column, since it is no longer
>>>> used?
>>> I tried without this column, but the problem still persisted. I think
>>> I'm ok with the extra commands needed to make this work, I'm just
>>> concerned with the size of the tuples in this table. I worry how big
>>> we'll keep making this table with time. :(
>>
>> i don't understand how this is an issue with the website table but not
>> the weblogentry table, which is pretty similar?
>>
>> in the long term the website table will absolutely need to grow and i
>> don't really want to try wacky workarounds where we put things in
>> different tables just to work around limits in DB2. i think we should
>> definitely be removing any tables/columns that are no longer used and
>> i am fine with shortening columns that are overly long, like handle,
>> editorpage, and editortheme.
>>
>> -- Allen
>>
>>
>>> -Elias
>>>>
>>>> - Dave
>>>>
>>>>
>>>>>
>>>>> -Elias
>>>>>
>>>>> Elias Torres wrote:
>>>>>> I was working on getting Roller working with an IBM DB2 Express-C
>>>>>> VMWare image. However, I found myself dealing with temporary table
>>>>>> spaces, complicated stuff that looked like this:
>>>>>> WARN 2006-03-23 17:06:23,328 JDBCExceptionReporter:logExceptions
>>>>>> - SQL
>>>>>> Error: -1585, SQLState: 54048
>>>>>> ERROR 2006-03-23 17:06:23,328 JDBCExceptionReporter:logExceptions -
>>>>>> [IBM][CLI Driver][DB2/NT] SQL1585N A system temporary table space
>>>>>> with
>>>>>> sufficient page size does not exist. SQLSTATE=54048
>>>>>> The answer (partly thanks to Matt for AppFuse wiki):
>>>>>> connect to roller;
>>>>>> create bufferpool ROLLER_BP size 1000 pagesize 32 k;
>>>>>> create temporary tablespace ROLLER_TEMP pagesize 32 k
>>>>>> managed by system
>>>>>> using ('roller_temp')
>>>>>> bufferpool ROLLER_BP;
>>>>>> I then went on to find out what's wrong with the source code in
>>>>>> the trunk? After a short discussion with a colleague at IBM (Jay
>>>>>> Allen), we came to the conclusion that it was around this line in
>>>>>> 200-to-210-migration.vm:
>>>>>> alter table website add column blacklist $TEXT_SQL_TYPE;
>>>>>> The default temporary table space page size in DB2 is 4K and I
>>>>>> found this out because Roller is blowing that limit in queries to
>>>>>> the website table. In short, we have 8 varchar(255), 2 clobs (in
>>>>>> db2.properties each is 102400) and not counting the rest of small
>>>>>> fields. I think that given the discussion we had the other day on
>>>>>> trying to make the columns "smaller", we should also think of
>>>>>> making the rows smaller too. I'd rather make Roller work by
>>>>>> default with DB2, but this is not a big deal of a fix, however,
>>>>>> I'm concerned with the performance against these large tuples in
>>>>>> major tables like website.
>>>>>> Regards,
>>>>>> Elias
>>>>>> David M Johnson wrote:
>>>>>>> Roller 2.2 RC1 is available for testing.
>>>>>>>
>>>>>>> You can het it here:
>>>>>>> http://people.apache.org/~snoopdave/roller-2.2-rc/
>>>>>>>
>>>>>>> User and install docs are in the same directory.
>>>>>>> The upgrade guide is now in Appendix A of the install guide.
>>>>>>>
>>>>>>> - Dave
>>>>>>>
>>>>>>>
>>>>>>> On Mar 23, 2006, at 3:40 PM, Dave Johnson wrote:
>>>>>>>> Today is the 2nd to last Thursday in the month: Release
>>>>>>>> Candidate day
>>>>>>>> http://rollerweblogger.org/wiki/Wiki.jsp?page=RollerReleasePlan
>>>>>>>>
>>>>>>>> I think we have made more than enough progress for a release, so
>>>>>>>> I'm planning on putting together Roller 2.2-incubating RC1 today.
>>>>>>>>
>>>>>>>> Enhancements made and bugs fixed
>>>>>>>>
>>>>>>>> If you take a look at the issue list for Roller 2.2
>>>>>>>> (http://tinyurl.com/d3cwa), you'll see that we have 25 of 42
>>>>>>>> issues marked as RESOLVED. Those are the issues that Allen and I
>>>>>>>> have verified and most (if not all) of them have actually been
>>>>>>>> deployed to production sites. The remaining issues are marked as
>>>>>>>> IN PROGRESS. They have all been addressed too and for the next
>>>>>>>> week, we'll be working to verify them -- and we'd love any help
>>>>>>>> we can get.
>>>>>>>>
>>>>>>>> Documentation updates
>>>>>>>>
>>>>>>>> The Roller 2.2 What's New guide is up to date
>>>>>>>> http://rollerweblogger.org/wiki/Wiki.jsp?page=Roller_2.2_WhatsNew
>>>>>>>>
>>>>>>>> The User Guide and Install Guide have been updated for 2.2.
>>>>>>>> http://people.apache.org/~snoopdave/roller-2.2-rc/
>>>>>>>>
>>>>>>>> The Javadocs have been updated:
>>>>>>>> http://rollerweblogger.org/javadoc/
>>>>>>>> (old docs are here: http://rollerweblogger.org/javadoc_2.0)
>>>>>>>>
>>>>>>>> The Velocidocs have been updated:
>>>>>>>> http://rollerweblogger.org/velocidoc/
>>>>>>>> (old docs are here: http://rollerweblogger.org/velocidoc_2.0)
>>>>>>>>
>>>>>>>> - Dave
>>>>>>>
>>>>
>>>>
>
>
Re: New website table
Posted by David M Johnson <Da...@Sun.COM>.
We have XML driven name/value properties at the site-wide level.
I wonder if we should have the same thing at the website/weblog level?
- Dave
On Mar 28, 2006, at 8:01 PM, Allen Gilliland wrote:
> Elias Torres wrote:
>> David M Johnson wrote:
>>>
>>> On Mar 28, 2006, at 1:25 PM, Elias Torres wrote:
>>>> Did you guys had a chance to look at this message?
>>>
>>> Do you have some specific proposal for fixing this?
>> Breakout some of the big properties into a separate table?
>
> huh? that sounds wacky to me. you are saying we need to move data
> outside of the website table into different tables? i don't see
> how that could be the case.
>
>>>
>>> What if we dropped the old ignoreWords column, since it is no
>>> longer used?
>> I tried without this column, but the problem still persisted. I
>> think I'm ok with the extra commands needed to make this work, I'm
>> just concerned with the size of the tuples in this table. I worry
>> how big we'll keep making this table with time. :(
>
> i don't understand how this is an issue with the website table but
> not the weblogentry table, which is pretty similar?
>
> in the long term the website table will absolutely need to grow and
> i don't really want to try wacky workarounds where we put things in
> different tables just to work around limits in DB2. i think we
> should definitely be removing any tables/columns that are no longer
> used and i am fine with shortening columns that are overly long,
> like handle, editorpage, and editortheme.
>
> -- Allen
>
>
>> -Elias
>>>
>>> - Dave
>>>
>>>
>>>>
>>>> -Elias
>>>>
>>>> Elias Torres wrote:
>>>>> I was working on getting Roller working with an IBM DB2 Express-
>>>>> C VMWare image. However, I found myself dealing with temporary
>>>>> table spaces, complicated stuff that looked like this:
>>>>> WARN 2006-03-23 17:06:23,328
>>>>> JDBCExceptionReporter:logExceptions - SQL
>>>>> Error: -1585, SQLState: 54048
>>>>> ERROR 2006-03-23 17:06:23,328
>>>>> JDBCExceptionReporter:logExceptions -
>>>>> [IBM][CLI Driver][DB2/NT] SQL1585N A system temporary table
>>>>> space with
>>>>> sufficient page size does not exist. SQLSTATE=54048
>>>>> The answer (partly thanks to Matt for AppFuse wiki):
>>>>> connect to roller;
>>>>> create bufferpool ROLLER_BP size 1000 pagesize 32 k;
>>>>> create temporary tablespace ROLLER_TEMP pagesize 32 k
>>>>> managed by system
>>>>> using ('roller_temp')
>>>>> bufferpool ROLLER_BP;
>>>>> I then went on to find out what's wrong with the source code in
>>>>> the trunk? After a short discussion with a colleague at IBM
>>>>> (Jay Allen), we came to the conclusion that it was around this
>>>>> line in 200-to-210-migration.vm:
>>>>> alter table website add column blacklist $TEXT_SQL_TYPE;
>>>>> The default temporary table space page size in DB2 is 4K and I
>>>>> found this out because Roller is blowing that limit in queries
>>>>> to the website table. In short, we have 8 varchar(255), 2 clobs
>>>>> (in db2.properties each is 102400) and not counting the rest of
>>>>> small fields. I think that given the discussion we had the
>>>>> other day on trying to make the columns "smaller", we should
>>>>> also think of making the rows smaller too. I'd rather make
>>>>> Roller work by default with DB2, but this is not a big deal of
>>>>> a fix, however, I'm concerned with the performance against
>>>>> these large tuples in major tables like website.
>>>>> Regards,
>>>>> Elias
>>>>> David M Johnson wrote:
>>>>>> Roller 2.2 RC1 is available for testing.
>>>>>>
>>>>>> You can het it here:
>>>>>> http://people.apache.org/~snoopdave/roller-2.2-rc/
>>>>>>
>>>>>> User and install docs are in the same directory.
>>>>>> The upgrade guide is now in Appendix A of the install guide.
>>>>>>
>>>>>> - Dave
>>>>>>
>>>>>>
>>>>>> On Mar 23, 2006, at 3:40 PM, Dave Johnson wrote:
>>>>>>> Today is the 2nd to last Thursday in the month: Release
>>>>>>> Candidate day
>>>>>>> http://rollerweblogger.org/wiki/Wiki.jsp?page=RollerReleasePlan
>>>>>>>
>>>>>>> I think we have made more than enough progress for a release,
>>>>>>> so I'm planning on putting together Roller 2.2-incubating RC1
>>>>>>> today.
>>>>>>>
>>>>>>> Enhancements made and bugs fixed
>>>>>>>
>>>>>>> If you take a look at the issue list for Roller 2.2 (http://
>>>>>>> tinyurl.com/d3cwa), you'll see that we have 25 of 42 issues
>>>>>>> marked as RESOLVED. Those are the issues that Allen and I
>>>>>>> have verified and most (if not all) of them have actually
>>>>>>> been deployed to production sites. The remaining issues are
>>>>>>> marked as IN PROGRESS. They have all been addressed too and
>>>>>>> for the next week, we'll be working to verify them -- and
>>>>>>> we'd love any help we can get.
>>>>>>>
>>>>>>> Documentation updates
>>>>>>>
>>>>>>> The Roller 2.2 What's New guide is up to date
>>>>>>> http://rollerweblogger.org/wiki/Wiki.jsp?
>>>>>>> page=Roller_2.2_WhatsNew
>>>>>>>
>>>>>>> The User Guide and Install Guide have been updated for 2.2.
>>>>>>> http://people.apache.org/~snoopdave/roller-2.2-rc/
>>>>>>>
>>>>>>> The Javadocs have been updated:
>>>>>>> http://rollerweblogger.org/javadoc/
>>>>>>> (old docs are here: http://rollerweblogger.org/javadoc_2.0)
>>>>>>>
>>>>>>> The Velocidocs have been updated:
>>>>>>> http://rollerweblogger.org/velocidoc/
>>>>>>> (old docs are here: http://rollerweblogger.org/velocidoc_2.0)
>>>>>>>
>>>>>>> - Dave
>>>>>>
>>>
>>>
Re: New website table
Posted by Elias Torres <el...@torrez.us>.
Allen Gilliland wrote:
>
>
> Elias Torres wrote:
>> David M Johnson wrote:
>>>
>>> On Mar 28, 2006, at 1:25 PM, Elias Torres wrote:
>>>> Did you guys had a chance to look at this message?
>>>
>>> Do you have some specific proposal for fixing this?
>>
>> Breakout some of the big properties into a separate table?
>
> huh? that sounds wacky to me. you are saying we need to move data
> outside of the website table into different tables? i don't see how
> that could be the case.
>
>>
>>>
>>> What if we dropped the old ignoreWords column, since it is no longer
>>> used?
>>
>> I tried without this column, but the problem still persisted. I think
>> I'm ok with the extra commands needed to make this work, I'm just
>> concerned with the size of the tuples in this table. I worry how big
>> we'll keep making this table with time. :(
>
> i don't understand how this is an issue with the website table but not
> the weblogentry table, which is pretty similar?
>
> in the long term the website table will absolutely need to grow and i
> don't really want to try wacky workarounds where we put things in
> different tables just to work around limits in DB2. i think we should
> definitely be removing any tables/columns that are no longer used and i
> am fine with shortening columns that are overly long, like handle,
> editorpage, and editortheme.
It's not a DB2 limit. It's just over the default temporary tablespace
size which can be fixed. However, I'm bringing up the issue we were
discussing sometime ago about length of rows in databases and how we
wanted this to be small. If we keep making this rows thousands of bytes
long, we will definitely be using a lot of disk and making our queries
slower due to disk access and so forth. If this is not the case, let's
keep on doing what we are doing.
Re: New website table
Posted by Allen Gilliland <Al...@Sun.COM>.
Elias Torres wrote:
> David M Johnson wrote:
>>
>> On Mar 28, 2006, at 1:25 PM, Elias Torres wrote:
>>> Did you guys had a chance to look at this message?
>>
>> Do you have some specific proposal for fixing this?
>
> Breakout some of the big properties into a separate table?
huh? that sounds wacky to me. you are saying we need to move data
outside of the website table into different tables? i don't see how
that could be the case.
>
>>
>> What if we dropped the old ignoreWords column, since it is no longer
>> used?
>
> I tried without this column, but the problem still persisted. I think
> I'm ok with the extra commands needed to make this work, I'm just
> concerned with the size of the tuples in this table. I worry how big
> we'll keep making this table with time. :(
i don't understand how this is an issue with the website table but not
the weblogentry table, which is pretty similar?
in the long term the website table will absolutely need to grow and i
don't really want to try wacky workarounds where we put things in
different tables just to work around limits in DB2. i think we should
definitely be removing any tables/columns that are no longer used and i
am fine with shortening columns that are overly long, like handle,
editorpage, and editortheme.
-- Allen
>
> -Elias
>
>>
>> - Dave
>>
>>
>>>
>>> -Elias
>>>
>>> Elias Torres wrote:
>>>> I was working on getting Roller working with an IBM DB2 Express-C
>>>> VMWare image. However, I found myself dealing with temporary table
>>>> spaces, complicated stuff that looked like this:
>>>> WARN 2006-03-23 17:06:23,328 JDBCExceptionReporter:logExceptions - SQL
>>>> Error: -1585, SQLState: 54048
>>>> ERROR 2006-03-23 17:06:23,328 JDBCExceptionReporter:logExceptions -
>>>> [IBM][CLI Driver][DB2/NT] SQL1585N A system temporary table space with
>>>> sufficient page size does not exist. SQLSTATE=54048
>>>> The answer (partly thanks to Matt for AppFuse wiki):
>>>> connect to roller;
>>>> create bufferpool ROLLER_BP size 1000 pagesize 32 k;
>>>> create temporary tablespace ROLLER_TEMP pagesize 32 k
>>>> managed by system
>>>> using ('roller_temp')
>>>> bufferpool ROLLER_BP;
>>>> I then went on to find out what's wrong with the source code in the
>>>> trunk? After a short discussion with a colleague at IBM (Jay Allen),
>>>> we came to the conclusion that it was around this line in
>>>> 200-to-210-migration.vm:
>>>> alter table website add column blacklist $TEXT_SQL_TYPE;
>>>> The default temporary table space page size in DB2 is 4K and I found
>>>> this out because Roller is blowing that limit in queries to the
>>>> website table. In short, we have 8 varchar(255), 2 clobs (in
>>>> db2.properties each is 102400) and not counting the rest of small
>>>> fields. I think that given the discussion we had the other day on
>>>> trying to make the columns "smaller", we should also think of making
>>>> the rows smaller too. I'd rather make Roller work by default with
>>>> DB2, but this is not a big deal of a fix, however, I'm concerned
>>>> with the performance against these large tuples in major tables like
>>>> website.
>>>> Regards,
>>>> Elias
>>>> David M Johnson wrote:
>>>>> Roller 2.2 RC1 is available for testing.
>>>>>
>>>>> You can het it here:
>>>>> http://people.apache.org/~snoopdave/roller-2.2-rc/
>>>>>
>>>>> User and install docs are in the same directory.
>>>>> The upgrade guide is now in Appendix A of the install guide.
>>>>>
>>>>> - Dave
>>>>>
>>>>>
>>>>> On Mar 23, 2006, at 3:40 PM, Dave Johnson wrote:
>>>>>> Today is the 2nd to last Thursday in the month: Release Candidate day
>>>>>> http://rollerweblogger.org/wiki/Wiki.jsp?page=RollerReleasePlan
>>>>>>
>>>>>> I think we have made more than enough progress for a release, so
>>>>>> I'm planning on putting together Roller 2.2-incubating RC1 today.
>>>>>>
>>>>>> Enhancements made and bugs fixed
>>>>>>
>>>>>> If you take a look at the issue list for Roller 2.2
>>>>>> (http://tinyurl.com/d3cwa), you'll see that we have 25 of 42
>>>>>> issues marked as RESOLVED. Those are the issues that Allen and I
>>>>>> have verified and most (if not all) of them have actually been
>>>>>> deployed to production sites. The remaining issues are marked as
>>>>>> IN PROGRESS. They have all been addressed too and for the next
>>>>>> week, we'll be working to verify them -- and we'd love any help
>>>>>> we can get.
>>>>>>
>>>>>> Documentation updates
>>>>>>
>>>>>> The Roller 2.2 What's New guide is up to date
>>>>>> http://rollerweblogger.org/wiki/Wiki.jsp?page=Roller_2.2_WhatsNew
>>>>>>
>>>>>> The User Guide and Install Guide have been updated for 2.2.
>>>>>> http://people.apache.org/~snoopdave/roller-2.2-rc/
>>>>>>
>>>>>> The Javadocs have been updated:
>>>>>> http://rollerweblogger.org/javadoc/
>>>>>> (old docs are here: http://rollerweblogger.org/javadoc_2.0)
>>>>>>
>>>>>> The Velocidocs have been updated:
>>>>>> http://rollerweblogger.org/velocidoc/
>>>>>> (old docs are here: http://rollerweblogger.org/velocidoc_2.0)
>>>>>>
>>>>>> - Dave
>>>>>
>>
>>
Re: New website table
Posted by Elias Torres <el...@torrez.us>.
David M Johnson wrote:
>
> On Mar 28, 2006, at 1:25 PM, Elias Torres wrote:
>> Did you guys had a chance to look at this message?
>
> Do you have some specific proposal for fixing this?
Breakout some of the big properties into a separate table?
>
> What if we dropped the old ignoreWords column, since it is no longer used?
I tried without this column, but the problem still persisted. I think
I'm ok with the extra commands needed to make this work, I'm just
concerned with the size of the tuples in this table. I worry how big
we'll keep making this table with time. :(
-Elias
>
> - Dave
>
>
>>
>> -Elias
>>
>> Elias Torres wrote:
>>> I was working on getting Roller working with an IBM DB2 Express-C
>>> VMWare image. However, I found myself dealing with temporary table
>>> spaces, complicated stuff that looked like this:
>>> WARN 2006-03-23 17:06:23,328 JDBCExceptionReporter:logExceptions - SQL
>>> Error: -1585, SQLState: 54048
>>> ERROR 2006-03-23 17:06:23,328 JDBCExceptionReporter:logExceptions -
>>> [IBM][CLI Driver][DB2/NT] SQL1585N A system temporary table space with
>>> sufficient page size does not exist. SQLSTATE=54048
>>> The answer (partly thanks to Matt for AppFuse wiki):
>>> connect to roller;
>>> create bufferpool ROLLER_BP size 1000 pagesize 32 k;
>>> create temporary tablespace ROLLER_TEMP pagesize 32 k
>>> managed by system
>>> using ('roller_temp')
>>> bufferpool ROLLER_BP;
>>> I then went on to find out what's wrong with the source code in the
>>> trunk? After a short discussion with a colleague at IBM (Jay Allen),
>>> we came to the conclusion that it was around this line in
>>> 200-to-210-migration.vm:
>>> alter table website add column blacklist $TEXT_SQL_TYPE;
>>> The default temporary table space page size in DB2 is 4K and I found
>>> this out because Roller is blowing that limit in queries to the
>>> website table. In short, we have 8 varchar(255), 2 clobs (in
>>> db2.properties each is 102400) and not counting the rest of small
>>> fields. I think that given the discussion we had the other day on
>>> trying to make the columns "smaller", we should also think of making
>>> the rows smaller too. I'd rather make Roller work by default with
>>> DB2, but this is not a big deal of a fix, however, I'm concerned with
>>> the performance against these large tuples in major tables like website.
>>> Regards,
>>> Elias
>>> David M Johnson wrote:
>>>> Roller 2.2 RC1 is available for testing.
>>>>
>>>> You can het it here:
>>>> http://people.apache.org/~snoopdave/roller-2.2-rc/
>>>>
>>>> User and install docs are in the same directory.
>>>> The upgrade guide is now in Appendix A of the install guide.
>>>>
>>>> - Dave
>>>>
>>>>
>>>> On Mar 23, 2006, at 3:40 PM, Dave Johnson wrote:
>>>>> Today is the 2nd to last Thursday in the month: Release Candidate day
>>>>> http://rollerweblogger.org/wiki/Wiki.jsp?page=RollerReleasePlan
>>>>>
>>>>> I think we have made more than enough progress for a release, so
>>>>> I'm planning on putting together Roller 2.2-incubating RC1 today.
>>>>>
>>>>> Enhancements made and bugs fixed
>>>>>
>>>>> If you take a look at the issue list for Roller 2.2
>>>>> (http://tinyurl.com/d3cwa), you'll see that we have 25 of 42 issues
>>>>> marked as RESOLVED. Those are the issues that Allen and I have
>>>>> verified and most (if not all) of them have actually been deployed
>>>>> to production sites. The remaining issues are marked as IN
>>>>> PROGRESS. They have all been addressed too and for the next week,
>>>>> we'll be working to verify them -- and we'd love any help we can get.
>>>>>
>>>>> Documentation updates
>>>>>
>>>>> The Roller 2.2 What's New guide is up to date
>>>>> http://rollerweblogger.org/wiki/Wiki.jsp?page=Roller_2.2_WhatsNew
>>>>>
>>>>> The User Guide and Install Guide have been updated for 2.2.
>>>>> http://people.apache.org/~snoopdave/roller-2.2-rc/
>>>>>
>>>>> The Javadocs have been updated:
>>>>> http://rollerweblogger.org/javadoc/
>>>>> (old docs are here: http://rollerweblogger.org/javadoc_2.0)
>>>>>
>>>>> The Velocidocs have been updated:
>>>>> http://rollerweblogger.org/velocidoc/
>>>>> (old docs are here: http://rollerweblogger.org/velocidoc_2.0)
>>>>>
>>>>> - Dave
>>>>
>
>
Re: New website table
Posted by David M Johnson <Da...@Sun.COM>.
On Mar 28, 2006, at 1:25 PM, Elias Torres wrote:
> Did you guys had a chance to look at this message?
Do you have some specific proposal for fixing this?
What if we dropped the old ignoreWords column, since it is no longer
used?
- Dave
>
> -Elias
>
> Elias Torres wrote:
>> I was working on getting Roller working with an IBM DB2 Express-C
>> VMWare image. However, I found myself dealing with temporary table
>> spaces, complicated stuff that looked like this:
>> WARN 2006-03-23 17:06:23,328 JDBCExceptionReporter:logExceptions
>> - SQL
>> Error: -1585, SQLState: 54048
>> ERROR 2006-03-23 17:06:23,328 JDBCExceptionReporter:logExceptions -
>> [IBM][CLI Driver][DB2/NT] SQL1585N A system temporary table space
>> with
>> sufficient page size does not exist. SQLSTATE=54048
>> The answer (partly thanks to Matt for AppFuse wiki):
>> connect to roller;
>> create bufferpool ROLLER_BP size 1000 pagesize 32 k;
>> create temporary tablespace ROLLER_TEMP pagesize 32 k
>> managed by system
>> using ('roller_temp')
>> bufferpool ROLLER_BP;
>> I then went on to find out what's wrong with the source code in
>> the trunk? After a short discussion with a colleague at IBM (Jay
>> Allen), we came to the conclusion that it was around this line in
>> 200-to-210-migration.vm:
>> alter table website add column blacklist $TEXT_SQL_TYPE;
>> The default temporary table space page size in DB2 is 4K and I
>> found this out because Roller is blowing that limit in queries to
>> the website table. In short, we have 8 varchar(255), 2 clobs (in
>> db2.properties each is 102400) and not counting the rest of small
>> fields. I think that given the discussion we had the other day on
>> trying to make the columns "smaller", we should also think of
>> making the rows smaller too. I'd rather make Roller work by
>> default with DB2, but this is not a big deal of a fix, however,
>> I'm concerned with the performance against these large tuples in
>> major tables like website.
>> Regards,
>> Elias
>> David M Johnson wrote:
>>> Roller 2.2 RC1 is available for testing.
>>>
>>> You can het it here:
>>> http://people.apache.org/~snoopdave/roller-2.2-rc/
>>>
>>> User and install docs are in the same directory.
>>> The upgrade guide is now in Appendix A of the install guide.
>>>
>>> - Dave
>>>
>>>
>>> On Mar 23, 2006, at 3:40 PM, Dave Johnson wrote:
>>>> Today is the 2nd to last Thursday in the month: Release
>>>> Candidate day
>>>> http://rollerweblogger.org/wiki/Wiki.jsp?page=RollerReleasePlan
>>>>
>>>> I think we have made more than enough progress for a release, so
>>>> I'm planning on putting together Roller 2.2-incubating RC1 today.
>>>>
>>>> Enhancements made and bugs fixed
>>>>
>>>> If you take a look at the issue list for Roller 2.2 (http://
>>>> tinyurl.com/d3cwa), you'll see that we have 25 of 42 issues
>>>> marked as RESOLVED. Those are the issues that Allen and I have
>>>> verified and most (if not all) of them have actually been
>>>> deployed to production sites. The remaining issues are marked as
>>>> IN PROGRESS. They have all been addressed too and for the next
>>>> week, we'll be working to verify them -- and we'd love any help
>>>> we can get.
>>>>
>>>> Documentation updates
>>>>
>>>> The Roller 2.2 What's New guide is up to date
>>>> http://rollerweblogger.org/wiki/Wiki.jsp?page=Roller_2.2_WhatsNew
>>>>
>>>> The User Guide and Install Guide have been updated for 2.2.
>>>> http://people.apache.org/~snoopdave/roller-2.2-rc/
>>>>
>>>> The Javadocs have been updated:
>>>> http://rollerweblogger.org/javadoc/
>>>> (old docs are here: http://rollerweblogger.org/javadoc_2.0)
>>>>
>>>> The Velocidocs have been updated:
>>>> http://rollerweblogger.org/velocidoc/
>>>> (old docs are here: http://rollerweblogger.org/velocidoc_2.0)
>>>>
>>>> - Dave
>>>
New website table
Posted by Elias Torres <el...@torrez.us>.
Did you guys had a chance to look at this message?
-Elias
Elias Torres wrote:
> I was working on getting Roller working with an IBM DB2 Express-C VMWare
> image. However, I found myself dealing with temporary table spaces,
> complicated stuff that looked like this:
>
> WARN 2006-03-23 17:06:23,328 JDBCExceptionReporter:logExceptions - SQL
> Error: -1585, SQLState: 54048
> ERROR 2006-03-23 17:06:23,328 JDBCExceptionReporter:logExceptions -
> [IBM][CLI Driver][DB2/NT] SQL1585N A system temporary table space with
> sufficient page size does not exist. SQLSTATE=54048
>
> The answer (partly thanks to Matt for AppFuse wiki):
>
> connect to roller;
> create bufferpool ROLLER_BP size 1000 pagesize 32 k;
> create temporary tablespace ROLLER_TEMP pagesize 32 k
> managed by system
> using ('roller_temp')
> bufferpool ROLLER_BP;
>
> I then went on to find out what's wrong with the source code in the
> trunk? After a short discussion with a colleague at IBM (Jay Allen), we
> came to the conclusion that it was around this line in
> 200-to-210-migration.vm:
>
> alter table website add column blacklist $TEXT_SQL_TYPE;
>
> The default temporary table space page size in DB2 is 4K and I found
> this out because Roller is blowing that limit in queries to the website
> table. In short, we have 8 varchar(255), 2 clobs (in db2.properties each
> is 102400) and not counting the rest of small fields. I think that given
> the discussion we had the other day on trying to make the columns
> "smaller", we should also think of making the rows smaller too. I'd
> rather make Roller work by default with DB2, but this is not a big deal
> of a fix, however, I'm concerned with the performance against these
> large tuples in major tables like website.
>
> Regards,
>
> Elias
>
> David M Johnson wrote:
>> Roller 2.2 RC1 is available for testing.
>>
>> You can het it here:
>> http://people.apache.org/~snoopdave/roller-2.2-rc/
>>
>> User and install docs are in the same directory.
>> The upgrade guide is now in Appendix A of the install guide.
>>
>> - Dave
>>
>>
>> On Mar 23, 2006, at 3:40 PM, Dave Johnson wrote:
>>> Today is the 2nd to last Thursday in the month: Release Candidate day
>>> http://rollerweblogger.org/wiki/Wiki.jsp?page=RollerReleasePlan
>>>
>>> I think we have made more than enough progress for a release, so I'm
>>> planning on putting together Roller 2.2-incubating RC1 today.
>>>
>>> Enhancements made and bugs fixed
>>>
>>> If you take a look at the issue list for Roller 2.2
>>> (http://tinyurl.com/d3cwa), you'll see that we have 25 of 42 issues
>>> marked as RESOLVED. Those are the issues that Allen and I have
>>> verified and most (if not all) of them have actually been deployed to
>>> production sites. The remaining issues are marked as IN PROGRESS.
>>> They have all been addressed too and for the next week, we'll be
>>> working to verify them -- and we'd love any help we can get.
>>>
>>> Documentation updates
>>>
>>> The Roller 2.2 What's New guide is up to date
>>> http://rollerweblogger.org/wiki/Wiki.jsp?page=Roller_2.2_WhatsNew
>>>
>>> The User Guide and Install Guide have been updated for 2.2.
>>> http://people.apache.org/~snoopdave/roller-2.2-rc/
>>>
>>> The Javadocs have been updated:
>>> http://rollerweblogger.org/javadoc/
>>> (old docs are here: http://rollerweblogger.org/javadoc_2.0)
>>>
>>> The Velocidocs have been updated:
>>> http://rollerweblogger.org/velocidoc/
>>> (old docs are here: http://rollerweblogger.org/velocidoc_2.0)
>>>
>>> - Dave
>>
>
Re: Roller 2.2-rc1-incubating is available
Posted by Elias Torres <el...@torrez.us>.
I was working on getting Roller working with an IBM DB2 Express-C VMWare
image. However, I found myself dealing with temporary table spaces,
complicated stuff that looked like this:
WARN 2006-03-23 17:06:23,328 JDBCExceptionReporter:logExceptions - SQL
Error: -1585, SQLState: 54048
ERROR 2006-03-23 17:06:23,328 JDBCExceptionReporter:logExceptions -
[IBM][CLI Driver][DB2/NT] SQL1585N A system temporary table space with
sufficient page size does not exist. SQLSTATE=54048
The answer (partly thanks to Matt for AppFuse wiki):
connect to roller;
create bufferpool ROLLER_BP size 1000 pagesize 32 k;
create temporary tablespace ROLLER_TEMP pagesize 32 k
managed by system
using ('roller_temp')
bufferpool ROLLER_BP;
I then went on to find out what's wrong with the source code in the
trunk? After a short discussion with a colleague at IBM (Jay Allen), we
came to the conclusion that it was around this line in
200-to-210-migration.vm:
alter table website add column blacklist $TEXT_SQL_TYPE;
The default temporary table space page size in DB2 is 4K and I found
this out because Roller is blowing that limit in queries to the website
table. In short, we have 8 varchar(255), 2 clobs (in db2.properties each
is 102400) and not counting the rest of small fields. I think that given
the discussion we had the other day on trying to make the columns
"smaller", we should also think of making the rows smaller too. I'd
rather make Roller work by default with DB2, but this is not a big deal
of a fix, however, I'm concerned with the performance against these
large tuples in major tables like website.
Regards,
Elias
David M Johnson wrote:
> Roller 2.2 RC1 is available for testing.
>
> You can het it here:
> http://people.apache.org/~snoopdave/roller-2.2-rc/
>
> User and install docs are in the same directory.
> The upgrade guide is now in Appendix A of the install guide.
>
> - Dave
>
>
> On Mar 23, 2006, at 3:40 PM, Dave Johnson wrote:
>> Today is the 2nd to last Thursday in the month: Release Candidate day
>> http://rollerweblogger.org/wiki/Wiki.jsp?page=RollerReleasePlan
>>
>> I think we have made more than enough progress for a release, so I'm
>> planning on putting together Roller 2.2-incubating RC1 today.
>>
>> Enhancements made and bugs fixed
>>
>> If you take a look at the issue list for Roller 2.2
>> (http://tinyurl.com/d3cwa), you'll see that we have 25 of 42 issues
>> marked as RESOLVED. Those are the issues that Allen and I have
>> verified and most (if not all) of them have actually been deployed to
>> production sites. The remaining issues are marked as IN PROGRESS. They
>> have all been addressed too and for the next week, we'll be working to
>> verify them -- and we'd love any help we can get.
>>
>> Documentation updates
>>
>> The Roller 2.2 What's New guide is up to date
>> http://rollerweblogger.org/wiki/Wiki.jsp?page=Roller_2.2_WhatsNew
>>
>> The User Guide and Install Guide have been updated for 2.2.
>> http://people.apache.org/~snoopdave/roller-2.2-rc/
>>
>> The Javadocs have been updated:
>> http://rollerweblogger.org/javadoc/
>> (old docs are here: http://rollerweblogger.org/javadoc_2.0)
>>
>> The Velocidocs have been updated:
>> http://rollerweblogger.org/velocidoc/
>> (old docs are here: http://rollerweblogger.org/velocidoc_2.0)
>>
>> - Dave
>