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
