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
