[Deploying Sakai] SQL errors after upgrade

[Leon Kolchinsky]

Hello,

Sorry for bothering you guys.
Apparently DB admin forgot to run those 2 sql conversion scripts ;(

I've only got this message during startup:

2011-03-15 16:46:51,015  INFO main
org.sakaiproject.authz.impl.DbAuthzGroupService - init(): table: SAKAI_REALM
external locks: true
INFO: [GenericDao] Could not execute first DDL line, skipping the rest:
java.sql.SQLException: ORA-00955: name is already used by an existing object
INFO: [GenericDao] Could not execute first DDL line, skipping the rest:
java.sql.SQLException: ORA-00955: name is already used by an existing object

Any suggestions?
Should I fix anything in my configs?

Cheers,
Leon Kolchinsky



On Tue, Mar 15, 2011 at 16:25, Leon Kolchinsky <lkolchin at gmail.com> wrote:

> Hello All,
>
> After 2.5.4 to 2.6.2 upgrade of Sakai, I'm getting lots of those errors:
>
> 2011-03-15 16:23:14,246  WARN
> org.sakaiproject.event.impl.ClusterEventTracking$$EnhancerByCGLIB$$a356947c
> org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select /*+
> FIRST_ROWS */
> EVENT_ID,EVENT_DATE,EVENT,REF,SAKAI_EVENT.SESSION_ID,EVENT_CODE,CONTEXT,SESSION_SERVER
> from   SAKAI_EVENT,SAKAI_SESSION where  (SAKAI_EVENT.SESSION_ID =
> SAKAI_SESSION.SESSION_ID(+)) and (EVENT_ID > ?) 8136651
> java.sql.SQLException: ORA-00904: "CONTEXT": invalid identifier
>
>         at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
>         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
>         at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
>         at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
>         at
> oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)
>         at
> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
>         at
> oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)
>         at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
>         at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
>         at
> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
>         at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
>         at
> org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:545)
>         at
> org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:464)
>         at
> org.sakaiproject.event.impl.ClusterEventTracking.run(ClusterEventTracking.java:510)
>         at java.lang.Thread.run(Thread.java:595)
>
> Any suggestions on how to fix it?
>
> Cheers,
> Leon Kolchinsky
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20110315/fad29e9d/attachment.html