Re: Pixory and Tomcat Uprade

Klemens Dickbauer <[email protected]> Fri, 17 Dec 2004 12:41:42 +0100

Newsgroups	gmane.comp.web.pixory
Organization	MSK Informatik
Message-ID	<[email protected]>

Hi Joe and Jakob!

Thanks both of you for your quick replies. I started with Joe's tip to create 
the log file. I attach it to this mail, but can't find nothing unusual in 
this log. Given that there are no cached messages, I assume the problem is 
indeed during database processing.
So I go on with Jakob's suggestion to use the HSQL tools to look into the 
database file. 
By the way, Joe, I'm not very used to sourceforge's CVS access, I could only 
find the 0.5 tag in the rep, is there also a 0.5.1 tag I've overlooked or do 
you only tag major releases?

thanks again and bye for now,
~klemens


Am Freitag, 17. Dezember 2004 02:32 schrieb joe panico:
>  Klemens,
>
>  It's true, as Jakob pointed out, that the DB structure
>  has probably changed since 3.11. But Pixory should be
>  able to upgrade the DB structure in place. Hopefully,
>  the log will tell all.
>
>  To get a log, copy the log.configuration.xml, included
>  with your distro, to ~/log/log.configuration.xml.
>  That's a directory named "log" under the home
>  directory of the user that the app server runs as.
>  After you restart the app server, Pixory should create
>  a log file in that same directory. Please post that
>  log file, or at least the relevant sections.
>
>  regards,
>
>  joe
>
>  --- Klemens Dickbauer
>
>  <[email protected]> wrote:
>  > Hi!
>  >
>  > Today I wanted to upgrade Pixory to 0.5.1. Since my
>  > server runs a Debian Woody
>  > installtaion, I also had to upgrade to tomcat4.
>  > After the common update
>  > hassles Tomcat is running, and also Pixory is in
>  > principal doing a fine job.
>  > But only when I start a fresh installation. When I
>  > copy the .pixory folder
>  > (tomcat4 incorporates a new user by default) to
>  > reuse contact and sharing
>  > information, Tomcat hangs after a restart at the
>  > first invocation call,
>  > consuming all CPU till it is stopped again.
>  > Unfortunately there is no log
>  > entry at all. :-(
>  >
>  > I was upgrading from Pixory 3.11
>  > Access flags to the pictures' folders are ok.
>  >
>  > If anybody experiences similar behaviour I'd be glad
>  > to get a hint what's
>  > wrong with my config.
>  >
>  > bye,
>  > ~klemens
>
>  __________________________________________________
>  Do You Yahoo!?
>  Tired of spam?  Yahoo! Mail has the best spam protection around
>  http://mail.yahoo.com
>
>
>
> Yahoo! Groups Sponsor
>
>
>
> ADVERTISEMENT
>
>
>
>
>
>
>
>  Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/pixory-beta/
>  
> To unsubscribe from this group, send an email to:
> [email protected]
>  
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

-- 
Klemens Dickbauer, MSK Informatik GesmbH
A-1160 Wien, Zeillergasse 5/309
phone: +43 699 18181919
mail: [email protected]



------------------------ Yahoo! Groups Sponsor --------------------~--> 
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/EGnolB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/pixory-beta/

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

pixory.log (text/x-log, 10.2 KB)

12:11:53,861 INFO (main) [pxapplication.PXApplication init] - java.lang.Class@1fd5e2[JETTY=false,JETTY_4=false,JETTY_5=false,TOMCAT=true,TOMCAT_4=true,TOMCAT_5=false,UNKNOWN=false]
12:11:53,884 INFO (main) [pxtapestry.PXApplicationServlet init] - config: org.apache.catalina.core.StandardWrapperFacade@1c6572b
12:11:54,964 INFO (main) [dialect.Dialect <init>] - Using dialect: net.sf.hibernate.dialect.HSQLDialect
12:11:54,984 INFO (main) [dialect.Dialect <init>] - Using dialect: net.sf.hibernate.dialect.HSQLDialect
12:11:55,903 INFO (main) [cfg.Environment <clinit>] - Hibernate 2.1.2
12:11:55,913 INFO (main) [cfg.Environment <clinit>] - hibernate.properties not found
12:11:55,937 INFO (main) [cfg.Environment <clinit>] - using CGLIB reflection optimizer
12:11:55,956 INFO (main) [cfg.Configuration secondPassCompile] - processing one-to-many association mappings
12:11:55,959 INFO (main) [cfg.Configuration secondPassCompile] - processing one-to-one association property references
12:11:55,962 INFO (main) [cfg.Configuration secondPassCompile] - processing foreign key constraints
12:11:56,036 INFO (main) [dialect.Dialect <init>] - Using dialect: net.sf.hibernate.dialect.HSQLDialect
12:11:56,041 INFO (main) [cfg.SettingsFactory buildSettings] - Use outer join fetching: false
12:11:56,064 INFO (main) [connection.DriverManagerConnectionProvider configure] - Using Hibernate built-in connection pool (not for production use!)
12:11:56,067 INFO (main) [connection.DriverManagerConnectionProvider configure] - Hibernate connection pool size: 5
12:11:56,104 INFO (main) [connection.DriverManagerConnectionProvider configure] - using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:/usr/share/tomcat4/.pixory/data/pixory
12:11:56,108 INFO (main) [connection.DriverManagerConnectionProvider configure] - connection properties: {user=sa, password=}
12:11:56,122 INFO (main) [transaction.TransactionFactoryFactory buildTransactionFactory] - Transaction strategy: net.sf.hibernate.transaction.JDBCTransactionFactory
12:11:56,138 INFO (main) [transaction.TransactionManagerLookupFactory getTransactionManagerLookup] - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
12:11:59,928 INFO (main) [cfg.SettingsFactory buildSettings] - Use scrollable result sets: true
12:11:59,932 INFO (main) [cfg.SettingsFactory buildSettings] - Use JDBC3 getGeneratedKeys(): false
12:11:59,935 INFO (main) [cfg.SettingsFactory buildSettings] - Optimize cache for minimal puts: false
12:11:59,938 INFO (main) [cfg.SettingsFactory buildSettings] - Query language substitutions: {}
12:11:59,942 INFO (main) [cfg.SettingsFactory buildSettings] - cache provider: net.sf.hibernate.cache.HashtableCacheProvider
12:11:59,967 INFO (main) [cfg.Configuration configureCaches] - instantiating and configuring caches
12:12:00,458 INFO (main) [impl.SessionFactoryImpl <init>] - building session factory
12:12:01,104 INFO (main) [impl.SessionFactoryObjectFactory addInstance] - no JNDI name configured
12:12:02,151 INFO (main) [pxmodel.PXObjectStoreVersion ensureCurrent] - store version: 2
12:12:02,169 INFO (main) [cfg.Configuration addClass] - Mapping resource: org/pixory/pxmodel/PXAlbumFace.hbm.xml
12:12:02,814 INFO (main) [cfg.Binder bindRootClass] - Mapping class: org.pixory.pxmodel.PXAlbumFace -> ALBUM_FACE
12:12:03,303 INFO (main) [cfg.Configuration addClass] - Mapping resource: org/pixory/pxmodel/PXSystem.hbm.xml
12:12:03,393 INFO (main) [cfg.Binder bindRootClass] - Mapping class: org.pixory.pxmodel.PXSystem -> PX_SYSTEM
12:12:03,400 INFO (main) [cfg.Configuration addClass] - Mapping resource: org/pixory/pxmodel/PXIdentity.hbm.xml
12:12:03,623 INFO (main) [cfg.Binder bindRootClass] - Mapping class: org.pixory.pxmodel.PXIdentity -> PX_IDENTITY
12:12:03,627 INFO (main) [cfg.Binder bindCollection] - Mapping collection: org.pixory.pxmodel.PXIdentity.contactsOf -> PX_CONTACT
12:12:03,630 INFO (main) [cfg.Binder bindCollection] - Mapping collection: org.pixory.pxmodel.PXIdentity.groups -> PX_MEMBERSHIP
12:12:03,791 INFO (main) [cfg.Binder bindSubclass] - Mapping subclass: org.pixory.pxmodel.PXPerson -> PX_IDENTITY
12:12:03,794 INFO (main) [cfg.Binder bindCollection] - Mapping collection: org.pixory.pxmodel.PXPerson.contacts -> PX_CONTACT
12:12:03,803 INFO (main) [cfg.Binder bindSubclass] - Mapping subclass: org.pixory.pxmodel.PXGroup -> PX_IDENTITY
12:12:03,816 INFO (main) [cfg.Binder bindCollection] - Mapping collection: org.pixory.pxmodel.PXGroup.members -> PX_MEMBERSHIP
12:12:03,819 INFO (main) [cfg.Configuration addClass] - Mapping resource: org/pixory/pxmodel/PXEmailAddress.hbm.xml
12:12:03,951 INFO (main) [cfg.Binder bindRootClass] - Mapping class: org.pixory.pxmodel.PXEmailAddress -> PX_EMAILADDRESS
12:12:03,969 INFO (main) [cfg.Configuration addClass] - Mapping resource: org/pixory/pxmodel/PXUserAccount.hbm.xml
12:12:04,051 INFO (main) [cfg.Binder bindRootClass] - Mapping class: org.pixory.pxmodel.PXUserAccount -> PX_USER_ACCOUNT
12:12:04,062 INFO (main) [cfg.Configuration addClass] - Mapping resource: org/pixory/pxmodel/PXConfigurationValue.hbm.xml
12:12:04,158 INFO (main) [cfg.Binder bindRootClass] - Mapping class: org.pixory.pxmodel.PXConfigurationValue -> PX_CONFIGURATION_VALUE
12:12:04,171 INFO (main) [cfg.Configuration addClass] - Mapping resource: org/pixory/pxmodel/PXConfigurationAttribute.hbm.xml
12:12:04,233 INFO (main) [cfg.Binder bindRootClass] - Mapping class: org.pixory.pxmodel.PXConfigurationAttribute -> PX_CONFIGURATION_ATTRIBUTE
12:12:04,258 INFO (main) [cfg.Configuration addClass] - Mapping resource: org/pixory/pxmodel/PXInvitation.hbm.xml
12:12:04,332 INFO (main) [cfg.Binder bindRootClass] - Mapping class: org.pixory.pxmodel.PXInvitation -> PX_INVITATION
12:12:04,337 INFO (main) [cfg.Configuration addClass] - Mapping resource: org/pixory/pxmodel/PXInvitationRecipient.hbm.xml
12:12:04,412 INFO (main) [cfg.Binder bindRootClass] - Mapping class: org.pixory.pxmodel.PXInvitationRecipient -> PX_INVITATION_RECIPIENT
12:12:04,423 INFO (main) [cfg.Configuration addClass] - Mapping resource: org/pixory/pxmodel/PXShare.hbm.xml
12:12:04,479 INFO (main) [cfg.Binder bindRootClass] - Mapping class: org.pixory.pxmodel.PXShare -> PX_SHARE
12:12:04,488 INFO (main) [cfg.Configuration addClass] - Mapping resource: org/pixory/pxmodel/PXShareMethod.hbm.xml
12:12:04,543 INFO (main) [cfg.Binder bindRootClass] - Mapping class: org.pixory.pxmodel.PXShareMethod -> PX_SHARE_METHOD
12:12:04,551 INFO (main) [cfg.Configuration secondPassCompile] - processing one-to-many association mappings
12:12:04,554 INFO (main) [cfg.Binder bindCollectionSecondPass] - Mapping collection: org.pixory.pxmodel.PXAlbumFace.invitations -> PX_INVITATION
12:12:04,558 INFO (main) [cfg.Binder bindCollectionSecondPass] - Mapping collection: org.pixory.pxmodel.PXAlbumFace.shares -> PX_SHARE
12:12:04,566 INFO (main) [cfg.Binder bindCollectionSecondPass] - Mapping collection: org.pixory.pxmodel.PXIdentity.invitationReceipts -> PX_INVITATION_RECIPIENT
12:12:04,569 INFO (main) [cfg.Binder bindCollectionSecondPass] - Mapping collection: org.pixory.pxmodel.PXIdentity.toShares -> PX_SHARE
12:12:04,572 INFO (main) [cfg.Binder bindCollectionSecondPass] - Mapping collection: org.pixory.pxmodel.PXPerson.emailAddresses -> PX_EMAILADDRESS
12:12:04,575 INFO (main) [cfg.Binder bindCollectionSecondPass] - Mapping collection: org.pixory.pxmodel.PXPerson.userAccounts -> PX_USER_ACCOUNT
12:12:04,578 INFO (main) [cfg.Binder bindCollectionSecondPass] - Mapping collection: org.pixory.pxmodel.PXUserAccount.configurationValues -> PX_CONFIGURATION_VALUE
12:12:04,589 INFO (main) [cfg.Binder bindCollectionSecondPass] - Mapping collection: org.pixory.pxmodel.PXInvitation.invitationRecipients -> PX_INVITATION_RECIPIENT
12:12:04,595 INFO (main) [cfg.Configuration secondPassCompile] - processing one-to-one association property references
12:12:04,598 INFO (main) [cfg.Configuration secondPassCompile] - processing foreign key constraints
12:12:04,605 INFO (main) [dialect.Dialect <init>] - Using dialect: net.sf.hibernate.dialect.HSQLDialect
12:12:04,608 INFO (main) [cfg.SettingsFactory buildSettings] - Use outer join fetching: false
12:12:04,611 INFO (main) [connection.DriverManagerConnectionProvider configure] - Using Hibernate built-in connection pool (not for production use!)
12:12:04,613 INFO (main) [connection.DriverManagerConnectionProvider configure] - Hibernate connection pool size: 5
12:12:04,620 INFO (main) [connection.DriverManagerConnectionProvider configure] - using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:/usr/share/tomcat4/.pixory/data/pixory
12:12:04,629 INFO (main) [connection.DriverManagerConnectionProvider configure] - connection properties: {user=sa, password=}
12:12:04,631 INFO (main) [transaction.TransactionFactoryFactory buildTransactionFactory] - Transaction strategy: net.sf.hibernate.transaction.JDBCTransactionFactory
12:12:04,634 INFO (main) [transaction.TransactionManagerLookupFactory getTransactionManagerLookup] - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
12:12:04,644 INFO (main) [cfg.SettingsFactory buildSettings] - Use scrollable result sets: true
12:12:04,647 INFO (main) [cfg.SettingsFactory buildSettings] - Use JDBC3 getGeneratedKeys(): false
12:12:04,649 INFO (main) [cfg.SettingsFactory buildSettings] - Optimize cache for minimal puts: false
12:12:04,652 INFO (main) [cfg.SettingsFactory buildSettings] - Query language substitutions: {}
12:12:04,661 INFO (main) [cfg.SettingsFactory buildSettings] - cache provider: net.sf.hibernate.cache.HashtableCacheProvider
12:12:04,664 INFO (main) [cfg.Configuration configureCaches] - instantiating and configuring caches
12:12:04,666 INFO (main) [impl.SessionFactoryImpl <init>] - building session factory
12:12:05,346 INFO (main) [util.ReflectHelper getBulkBean] - reflection optimizer disabled for: org.pixory.pxmodel.PXIdentity, InstantiationError: org.pixory.pxmodel.PXIdentity
12:12:06,143 INFO (main) [impl.SessionFactoryObjectFactory addInstance] - no JNDI name configured
12:12:06,152 INFO (main) [cfg.Configuration secondPassCompile] - processing one-to-many association mappings
12:12:06,154 INFO (main) [cfg.Configuration secondPassCompile] - processing one-to-one association property references
12:12:06,157 INFO (main) [cfg.Configuration secondPassCompile] - processing foreign key constraints