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
