[Building Sakai] Database connection corrupted

[tannaz alinaghi]

Hi All,

In Tomcat startup, it sounds that Sakai faces some problem in connecting database. The  server log is as follows,

........................................................................

INFO: .init(): table: SAKAI_NOTIFICATION locks-in-db: false (2009-08-23 11:48:43
,750 main_org.sakaiproject.event.impl.DbNotificationService)
INFO: init() (2009-08-23 11:48:43,812 main_org.sakaiproject.content.impl.DbResou
rceTypeRegistry)
INFO: init() (2009-08-23 11:48:43,828 main_org.sakaiproject.content.impl.Resourc
eTypeRegistryImpl)
INFO: init() (2009-08-23 11:48:43,875 main_org.sakaiproject.time.api.TimeService
)
FATAL: Check on Database Failed  (2009-08-23 11:48:44,093 main_org.sakaiproject.
content.impl.DbContentService)
java.sql.SQLException: Incorrect string value: '\xC2\x80\xC2\x81\xC2\x82...' for
 column 'bval' at row 1
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
        at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedSt
atement.java:1169)
        at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPrepared
Statement.java:693)

..
..
..


FATAL: =========================================================== (2009-08-23 1
1:48:44,656 main_org.sakaiproject.content.impl.DbContentService)
FATAL: WARNING
  The connection from this instance of Sakai to the database
  has been tested and found to corrupt UTF-8 Data.
  In order for Sakai to operate correctly you must ensure that your
  database setup is correct for UTF-8 data. This includes both the
  JDBC connection to the database and the underlying storage in the
  database.
  The test that was performed on your database create a table
  wrote some data to that table and read it back again. On reading
  that data back it found some form of corruption, reported above.

 More information on database setup for sakai can be found at
 http://bugs.sakaiproject.org/confluence/display/DOC/Install+Guide+-+DB+(2.4)

 Sakai Startup will continue but you might want to address this issue ASAP.
 (2009-08-23 11:48:44,656 main_org.sakaiproject.content.impl.DbContentService)
INFO: Migration of data to the Binary format will be performed by this node  (20
09-08-23 11:48:44,718 main_org.sakaiproject.content.impl.DbContentService)

........................................................................

Although loading process skips the problem, but similar exceptions occurs in further steps and finally(after completion of startup) Sakai does not work properly.

Thanks,
T.A



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090823/3797b431/attachment.html