Announcement

Collapse
No announcement yet.

database upgrade problem when going from OX 6.8 to 6.10

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Martin Heiland
    replied
    Not a problem, but we're interested in the initial cause of this problem. Do you still have log files from your first upgrade try?

    Leave a comment:


  • friess
    replied
    ... and that works just great

    Thank you for your very efficient and appreciated support!

    Kind regards,

    MichaŽl

    Leave a comment:


  • Martin Heiland
    replied
    Seems like the database has been locked and is still version 34 which is 6.8. Have you restarted the groupware after the error message occured? To try again, please enter

    Code:
    UPDATE version SET locked=0;
    After that, try to login again and please keep an eye on the logfile if they contain any severe error message.

    Greetings

    Leave a comment:


  • friess
    replied
    Sure, here you are:

    mysql> SELECT * FROM version;
    +---------+--------+---------------+------------------+----------+
    | version | locked | gw_compatible | admin_compatible | server |
    +---------+--------+---------------+------------------+----------+
    | 34 | 1 | 1 | 1 | oxserver |
    +---------+--------+---------------+------------------+----------+

    MichaŽl

    Leave a comment:


  • Martin Heiland
    replied
    Hi,

    could you please post the result of the following mysql query at your ox database?

    Code:
    SELECT * FROM version;
    Thanks

    Leave a comment:


  • friess
    replied
    This is correct. I get the error for every login, which means that I cannot login on the server.

    I get the OX landing page though, with the right login banner and the proper OX version displayed.

    Is there any log that would help determine where the problem is coming from?

    MichaŽl

    Leave a comment:


  • Carsten Hoeger
    replied
    That update should take some milliseconds on such a small installation.

    Does that mean, that this error comes with every try to login?
    It's quite likely _not_ related to the server startup.

    What exactly does not work - if at all -?

    Leave a comment:


  • friess
    replied
    Dear Carsten,

    I appreciate your quick reply. I am a bit surprised though that the update would take more than 20 minutes. Is such a long time really expected, knowing that under the /varl/lib/mysql directory there are only 48MB of data?

    Kind regards,

    MichaŽl

    Leave a comment:


  • Carsten Hoeger
    replied
    Just read the error within the stacktrace:

    Code:
    [...] Updating database ... Try again later. [...]
    The new version requires some database updates which will be done with the first access to the database.

    Leave a comment:


  • database upgrade problem when going from OX 6.8 to 6.10

    Hello,

    I'm upgrading OX on a Debian Etch system and once I have upgraded all OX packages, the system fails to start with the following error:

    WARNING: DBP-0012 Category=5 Message=Connection used for 2001 milliseconds. exceptionID=187223021-1
    DBP-0012 Category=5 Message=Connection used for 2001 milliseconds. exceptionID=187223021-1
    at com.openexchange.database.internal.DBPoolingExcept ionFactory.createException(DBPoolingExceptionFacto ry.java:76)
    at com.openexchange.database.internal.DBPoolingExcept ionFactory.createException(DBPoolingExceptionFacto ry.java:62)
    at com.openexchange.exceptions.Exceptions.create(Exce ptions.java:139)
    at com.openexchange.exceptions.Exceptions.create(Exce ptions.java:143)
    at com.openexchange.exceptions.Exceptions.create(Exce ptions.java:155)
    at com.openexchange.database.DBPoolingExceptionCodes. create(DBPoolingExceptionCodes.java:186)
    at com.openexchange.database.internal.ConnectionPool$ ConnectionLifecycle.validate(ConnectionPool.java:3 21)
    at com.openexchange.pooling.ReentrantLockPool.back(Re entrantLockPool.java:256)
    at com.openexchange.pooling.ReentrantLockPool.back(Re entrantLockPool.java:222)
    at com.openexchange.database.internal.DatabaseService Impl.back(DatabaseServiceImpl.java:222)
    at com.openexchange.database.internal.DatabaseService Impl.back(DatabaseServiceImpl.java:356)
    at com.openexchange.databaseold.Database.back(Databas e.java:225)
    at com.openexchange.groupware.update.SchemaStoreImpl. loadSchema(SchemaStoreImpl.java:423)
    at com.openexchange.groupware.update.SchemaStoreImpl. getSchema(SchemaStoreImpl.java:125)
    at com.openexchange.groupware.update.SchemaStore.getS chema(SchemaStore.java:142)
    at com.openexchange.groupware.update.UpdaterImpl.getS chema(UpdaterImpl.java:135)
    at com.openexchange.groupware.update.UpdaterImpl.isLo cked(UpdaterImpl.java:90)
    at com.openexchange.groupware.contexts.impl.CachingCo ntextStorage$1.load(CachingContextStorage.java:159 )
    at com.openexchange.groupware.contexts.impl.CachingCo ntextStorage$1.load(CachingContextStorage.java:167 )
    at com.openexchange.cache.dynamic.impl.Refresher.refr esh(Refresher.java:162)
    at com.openexchange.groupware.contexts.impl.ContextRe loader.<init>(ContextReloader.java:79)
    at com.openexchange.groupware.contexts.impl.CachingCo ntextStorage.loadContext(CachingContextStorage.jav a:172)
    at com.openexchange.groupware.contexts.impl.ContextSt orage.getContext(ContextStorage.java:115)
    at com.openexchange.tools.webdav.OXServlet.addSession (OXServlet.java:342)
    at com.openexchange.tools.webdav.OXServlet.doAuth(OXS ervlet.java:189)
    at com.openexchange.webdav.PermissionServlet.service( PermissionServlet.java:86)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
    at com.openexchange.ajp13.najp.AJPv13RequestHandlerIm pl.doServletService(AJPv13RequestHandlerImpl.java: 429)
    at com.openexchange.ajp13.AJPv13Request.response(AJPv 13Request.java:128)
    at com.openexchange.ajp13.najp.AJPv13RequestHandlerIm pl.createResponse(AJPv13RequestHandlerImpl.java:28 2)
    at com.openexchange.ajp13.najp.AJPv13ConnectionImpl.c reateResponse(AJPv13ConnectionImpl.java:189)
    at com.openexchange.ajp13.najp.AJPv13Task.run(AJPv13T ask.java:258)
    at java.util.concurrent.Executors$RunnableAdapter.cal l(Executors.java:417)
    at java.util.concurrent.FutureTask$Sync.innerRun(Futu reTask.java:269)
    at java.util.concurrent.FutureTask.run(FutureTask.jav a:123)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:650)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:675)
    at java.lang.Thread.run(Thread.java:595)
    Sep 9, 2009 10:04:30 AM com.openexchange.tools.webdav.OXServlet doAuth
    SEVERE: CTX-0007 Category=4 Message=Updating database ... Try again later. exceptionID=187223021-2
    CTX-0007 Category=4 Message=Updating database ... Try again later. exceptionID=187223021-2
    at com.openexchange.groupware.contexts.impl.ContextSt orage.getContext(ContextStorage.java:117)
    at com.openexchange.tools.webdav.OXServlet.addSession (OXServlet.java:342)
    at com.openexchange.tools.webdav.OXServlet.doAuth(OXS ervlet.java:189)
    at com.openexchange.webdav.PermissionServlet.service( PermissionServlet.java:86)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
    at com.openexchange.ajp13.najp.AJPv13RequestHandlerIm pl.doServletService(AJPv13RequestHandlerImpl.java: 429)
    at com.openexchange.ajp13.AJPv13Request.response(AJPv 13Request.java:128)
    at com.openexchange.ajp13.najp.AJPv13RequestHandlerIm pl.createResponse(AJPv13RequestHandlerImpl.java:28 2)
    at com.openexchange.ajp13.najp.AJPv13ConnectionImpl.c reateResponse(AJPv13ConnectionImpl.java:189)
    at com.openexchange.ajp13.najp.AJPv13Task.run(AJPv13T ask.java:258)
    at java.util.concurrent.Executors$RunnableAdapter.cal l(Executors.java:417)
    at java.util.concurrent.FutureTask$Sync.innerRun(Futu reTask.java:269)
    at java.util.concurrent.FutureTask.run(FutureTask.jav a:123)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:650)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:675)
    at java.lang.Thread.run(Thread.java:595)



    Any idea on the cause of this problem?

    Thank you in advance for your help.

    MichaŽl

    PS: whole log is attached
    Attached Files
Working...
X