[Deploying Sakai] DB exception errors after 2.5.4 to 2.6.2 upgrade

[Leon Kolchinsky]

Hmm,

Thanks Matthew.
So the solution is probably to go back to a 2 stage upgrade running to
scripts?

https://source.sakaiproject.org/svn/reference/branches/sakai_2-6
-x/docs/conversion/sakai_2_6_0_oracle_conversion.sql
https://source.sakaiproject.org/svn/reference/tags/sakai-2.6
.1/docs/conversion/sakai_2_6_0-2_6_1_oracle_conversion.sql

Thanks,
Leon

On Mon, Jun 21, 2010 at 14:49, Matthew Jones <jonespm at umich.edu> wrote:

> The column CONTEXT is in the first script you linked.
> https://source.sakaiproject.org/svn/reference/branches/sakai_2-6
> -x/docs/conversion/sakai_2_6_0_oracle_conversion.sql
>
> -- SAK-10801 Add CONTEXT field to SAKAI_EVENT
> alter table SAKAI_EVENT add CONTEXT varchar2(255) NULL;
>
> Not sure why that would no longer be there though.
>
> -Matthew
>
> On Sun, Jun 20, 2010 at 11:09 PM, Leon Kolchinsky <lkolchin at gmail.com>wrote:
>
>> Hello All,
>>
>> 1) Previously I've upgraded 2.5.4 version of Sakai to 2.6.1 with those 2
>> scripts:
>>  https://source.sakaiproject.org/svn/reference/branches/sakai_2-6
>> -x/docs/conversion/sakai_2_6_0_oracle_conversion.sql
>> https://source.sakaiproject.org/svn/reference/tags/sakai-2.6
>> .1/docs/conversion/sakai_2_6_0-2_6_1_oracle_conversion.sql
>>
>> I didn't have any warnings or exceptions in the logs after that.
>>
>> 2) Now, I've upgraded Sakai 2.5.4 to 2.6.2 DB version, using only one SQL
>> script:
>>
>> https://source.sakaiproject.org/svn/reference/branches/sakai_2-6-x/docs/conversion/sakai_2_6_0-2_6_x_oracle_conversion005_SAK-14482.sql
>> and entered new DB details to the sakai.properties.
>>
>> I'm getting those messages in the log file catalina.out :
>>
>> 2010-06-21 12:58:24,938  WARN
>> org.sakaiproject.event.impl.ClusterEventTracking$$EnhancerByCGLIB$$e6ff12b
>> 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 > ?) 6442154
>> 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 ideas on how to resolve these exceptions?
>>
>> Thanks,
>> Leon
>>
>> _______________________________________________
>> production mailing list
>> production at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/production
>>
>> TO UNSUBSCRIBE: send email to
>> production-unsubscribe at collab.sakaiproject.org with a subject of
>> "unsubscribe"
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20100621/3347f090/attachment.html