Hi,
I just tested an upgrade from roller 4.0 to roller 4.0.1 which fails.
My environment:
Ubuntu 8.10
glassfish-v2-b58g
Derby 10.2.2
JDK 1.6.0_03-b05
roller 4.0.1 built from SVN source (I have to add a fix for defect
ROL-1694 which is not yet fixed 4.0.1)
This is my roller-custom.properties:
installation.type=auto
database.configurationType=jndi
database.jndi.name=jdbc/rollerdb
mail.configurationType=properties
mail.hostname=<removed>
mail.username=<removed>
mail.password=<removed>
After uploading the new roller.war and going to the roller URL, I saw
the message that the database tables need to be upgraded, which I
confirmed. After a while the following was displayed:
Error upgrading tables
Error upgrading tables, possibly due to an error in the database
creation script or because you are using an unsupported database. You
will have to fix this problem and then restart or redeploy Roller
before you can proceed. Below are the success/error messages issued
during the upgrade process:
Running database upgrade script: derby/400-to-410-migration.sql
create table roller_permission ( id varchar(48) not null primary
key, username varchar(255) not null, actions varchar(255),
objectid varchar(48), objecttype varchar(255), pending
smallint default 1, datecreated timestamp not null )
insert into roller_permission
(id,username,actions,objectid,objecttype,pending,datecreated) select w.id ||
u.username , u.username, 'edit_draft', w.handle, 'Weblog', 0,
current_timestamp from rolleruser as u, website as w, roller_user_permissions
as p where p.user_id = u.id and p.website_id = w.id and permission_mask = 1
insert into roller_permission
(id,username,actions,objectid,objecttype,pending,datecreated) select w.id ||
u.username , u.username, 'author', w.handle, 'Weblog', 0, current_timestamp
from rolleruser as u, website as w, roller_user_permissions as p where
p.user_id = u.id and p.website_id = w.id and permission_mask = 2
insert into roller_permission
(id,username,actions,objectid,objecttype,pending,datecreated) select w.id ||
u.username , u.username, 'admin', w.handle, 'Weblog', 0, current_timestamp
from rolleruser as u, website as w, roller_user_permissions as p where
p.user_id = u.id and p.website_id = w.id and permission_mask = 3
alter table userrole alter column userid null
alter table website alter column userid null
alter table website add column creator varchar(255) default null
update website as w set lastmodified = lastmodified, datecreated = datecreated,
creator = (select u.username from rolleruser as u where u.id = w.userid)
alter table weblogentry alter column userid null
alter table weblogentry add column creator varchar(255) default null
update weblogentry as w set pubtime = pubtime, updatetime = updatetime, creator
= (select u.username from rolleruser as u where u.id = w.userid)
alter table roller_weblogentrytag alter column userid null
alter table roller_weblogentrytag add column creator varchar(255) default null
update roller_weblogentrytag as w set time = time, creator = (select u.username
from rolleruser as u where u.id = w.userid)
create table roller_userattribute( id varchar(48) not null primary
key, username varchar(255) not null, attrname varchar(255) not null,
attrvalue varchar(255) not null )
create index ua_username_idx on roller_userattribute( username )
create index ua_attrname_idx on roller_userattribute( attrname )
create index ua_attrvalue_idx on roller_userattribute( attrvalue )
I can see no error message here.
These are the roller.log messages:
INFO 2009-01-15 20:58:58,356 ContinuousWorkerThread:run -
HitCountQueueProcessor Started.
INFO 2009-01-15 20:58:58,358 HitCountQueue:shutdown - stopping worker
HitCountQueueProcessor
INFO 2009-01-15 20:58:58,464 ContinuousWorkerThread:run -
HitCountQueueProcessor INTERRUPT: sleep interrupted
INFO 2009-01-15 20:59:09,701 DatabaseProvider:successMessage - SUCCESS: Got
parameters. Using configuration type JNDI_NAME
INFO 2009-01-15 20:59:09,704 DatabaseProvider:successMessage - -- Using JNDI
datasource name: java:comp/env/jdbc/rollerdb
INFO 2009-01-15 20:59:09,708 DatabaseProvider:successMessage - SUCCESS:
located JNDI DataSource [java:comp/env/jdbc/rollerdb]
INFO 2009-01-15 20:59:10,013 RollerContext:contextInitialized -
--------------------------------------------------------------
Roller Weblogger startup INCOMPLETE, user interaction required
--------------------------------------------------------------
INFO 2009-01-15 20:59:10,014 RollerContext:initializeSecurityFeatures -
Remember Me enabled: true
INFO 2009-01-15 20:59:10,019 RollerContext:initializeSecurityFeatures -
Password Encryption Algorithm set to 'SHA'
INFO 2009-01-15 20:59:10,019 RollerContext:setupVelocity - Initializing
Velocity
INFO 2009-01-15 20:59:10,694 IPBanFilter:init - INIT IPBanFilter
INFO 2009-01-15 20:59:11,995 RequestMappingFilter:init - Request mapping
filter initialized, 1 mappers configured.
WARN 2009-01-15 20:59:13,102 Settings:getLocale - Settings: Could not parse
struts.locale setting, substituting default VM locale
INFO 2009-01-15 20:59:13,641 PageServlet:init - Initializing PageServlet
INFO 2009-01-15 20:59:13,644 WeblogPageCache:<init> - {id=cache.weblogpage,
enabled=true, timeout=3600, size=400}
INFO 2009-01-15 20:59:13,648 CacheManager:<clinit> - Cache Manager Initialized.
INFO 2009-01-15 20:59:13,649 CacheManager:<clinit> - Cache Factory =
org.apache.roller.weblogger.util.cache.ExpiringLRUCacheFactoryImpl
INFO 2009-01-15 20:59:13,654 SiteWideCache:<init> - {id=cache.sitewide,
enabled=true, timeout=1800, size=50}
INFO 2009-01-15 20:59:13,655 PageServlet:init - Referrer processing enabled =
true
INFO 2009-01-15 20:59:13,658 FeedServlet:init - Initializing FeedServlet
INFO 2009-01-15 20:59:13,660 WeblogFeedCache:<init> - {id=cache.weblogfeed,
enabled=true, timeout=3600, size=200}
INFO 2009-01-15 20:59:13,663 SearchServlet:init - Initializing SearchServlet
INFO 2009-01-15 20:59:13,665 ResourceServlet:init - Initializing
ResourceServlet
INFO 2009-01-15 20:59:13,668 CommentServlet:init - Initializing CommentServlet
INFO 2009-01-15 20:59:13,697 CommentValidationManager:<init> - Configured
CommentValidator: Blacklist Comment Validator /
org.apache.roller.weblogger.ui.rendering.plugins.comments.BlacklistCommentValidator
INFO 2009-01-15 20:59:13,699 CommentValidationManager:<init> - Configured
CommentValidator: Excess Links Comment Validator /
org.apache.roller.weblogger.ui.rendering.plugins.comments.ExcessLinksCommentValidator
INFO 2009-01-15 20:59:13,700 CommentValidationManager:<init> - Configured
CommentValidator: Excess Size Comment Validator /
org.apache.roller.weblogger.ui.rendering.plugins.comments.ExcessSizeCommentValidator
INFO 2009-01-15 20:59:13,704 CommentValidationManager:<init> - Configured 3
CommentValidators
INFO 2009-01-15 20:59:13,708 CommentServlet:init - Comment Throttling DISABLED
INFO 2009-01-15 20:59:13,712 CommentValidationManager:<init> - Configured
CommentValidator: Blacklist Comment Validator /
org.apache.roller.weblogger.ui.rendering.plugins.comments.BlacklistCommentValidator
INFO 2009-01-15 20:59:13,712 CommentValidationManager:<init> - Configured
CommentValidator: Excess Links Comment Validator /
org.apache.roller.weblogger.ui.rendering.plugins.comments.ExcessLinksCommentValidator
INFO 2009-01-15 20:59:13,713 CommentValidationManager:<init> - Configured
CommentValidator: Excess Size Comment Validator /
org.apache.roller.weblogger.ui.rendering.plugins.comments.ExcessSizeCommentValidator
INFO 2009-01-15 20:59:13,713 CommentValidationManager:<init> - Configured 3
CommentValidators
INFO 2009-01-15 20:59:13,717 RSDServlet:init - Initializing RSDServlet
INFO 2009-01-15 20:59:13,720 PlanetFeedServlet:init - Initializing
PlanetRssServlet
INFO 2009-01-15 20:59:13,722 PlanetCache:<init> - Planet cache =
{id=cache.planet, enabled=true, timeout=1800, size=10}
INFO 2009-01-15 20:59:13,726 PreviewResourceServlet:init - Initializing
PreviewResourceServlet
INFO 2009-01-15 20:59:13,729 PreviewThemeImageServlet:init - Initializing
PreviewThemeImageServlet
INFO 2009-01-15 20:59:13,735 PreviewServlet:init - Initializing PreviewServlet
INFO 2009-01-15 20:59:55,270 DatabaseInstaller:upgradeDatabase - Database is
old, beginning upgrade to version 410
I can see no error messages here. The glassfish log file also does not
contain any error messages.
How can I find out what went wrong?
Thanks
Stephan
