roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anil Gangolli <a...@busybuddha.org>
Subject Re: Upgrade from 4.0 to 4.0.1 fails with glassfish and Derby
Date Fri, 16 Jan 2009 22:04:48 GMT

Hmm. 

There's something a bit weird about your build.   The 4.0.1 source tree 
does not have any version of 400-to-410-migration.sql.  It has 
400-to-401-migration.sql.  Your build somehow has this, which is at 
least an indication that something isn't quite right with it.

Did you pull your sources from roller/tags/roller_4.0.1/ ?   Did you 
pull to a clean directory?  Did you install the webapp to a clean directory?

--a.

Stephan M├╝hlstrasser wrote:
> 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
>   


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message