roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephan Mühlstrasser <stephan.muehlstras...@web.de>
Subject Re: Upgrade from 4.0 to 4.0.1 fails with glassfish and Derby
Date Fri, 16 Jan 2009 23:36:47 GMT
Ah, thank you, I see my mistake. I followed the instructions from the Wiki to get the sources
from SVN, and I didn't think about the fact that I would get something later than 4.0.1.

I did this:

svn checkout https://svn.apache.org/repos/asf/roller/trunk roller_trunk

I will now try to check out with the roller_4.0.1 tag, and see whether that fixes my problem.

Thanks
Stephan

> -----Ursprüngliche Nachricht-----
> Von: "Anil Gangolli" <anil@busybuddha.org>
> Gesendet: 16.01.09 23:05:30
> An: user@roller.apache.org
> Betreff: Re: Upgrade from 4.0 to 4.0.1 fails with glassfish and Derby


> 
> 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
> >   
> 
> 
> 


__________________________________________________________________
Deutschlands größte Online-Videothek schenkt Ihnen 12.000 Videos!*
http://entertainment.web.de/de/entertainment/maxdome/index.html


Mime
View raw message