OpenSim/DB/prims/UTF-8 のバックアップ(No.1)

• バックアップ一覧
• 差分 を表示
• 現在との差分 を表示
• ソース を表示
• OpenSim/DB/prims/UTF-8 へ行く。
  • 1 (2024-09-02 (月) 13:22:37)

prims テーブルの TextカラムのUTF-8問題 †[edit]

Error Message †[edit]

2023-08-12 20:52:48,996 ERROR [REGION DB]: MySQL error in ExecuteNonQuery: Incorrect string value: '\xE7\xA9\xBA\xE3\x81\x8D...' for column `jogrid_db`.`prims`.`Text` at row 1
2023-08-12 20:52:48,997 ERROR [SCENE]: Storing of grid user name pole, 1e854de9-143c-4e10-aa14-f42ba4c68e0b in Tempest failed with exception Incorrect string value: '\xE7\xA9\xBA\xE3\x81\x8D...' for column `jogrid_db`.`prims`.`Text` at row 1  at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00096] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
  at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int64& insertedId) [0x00026] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
  at MySql.Data.MySqlClient.Driver.GetResult (System.Int32 statementId, System.Int32& affectedRows, System.Int64& insertedId) [0x00000] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
  at MySql.Data.MySqlClient.Driver.NextResult (System.Int32 statementId, System.Boolean force) [0x00023] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
  at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00205] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00315] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () [0x00000] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery () [0x00033] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
  at OpenSim.Data.MySQL.MySQLSimulationData.ExecuteNonQuery (MySql.Data.MySqlClient.MySqlCommand c) [0x00024] in <8b4206b9ccaf407f9cb5690f46a27ae5>:0
  at OpenSim.Data.MySQL.MySQLSimulationData.StoreObject (OpenSim.Region.Framework.Scenes.SceneObjectGroup obj, OpenMetaverse.UUID regionUUID) [0x000d5] in <8b4206b9ccaf407f9cb5690f46a27ae5>:0
  at OpenSim.Services.SimulationService.SimulationDataService.StoreObject (OpenSim.Region.Framework.Scenes.SceneObjectGroup obj, OpenMetaverse.UUID regionUUID) [0x00000] in <e4c21485e2f94459bf60ab3b6739a1cb>:0
  at OpenSim.Region.Framework.Scenes.SceneObjectGroup.ProcessBackup (OpenSim.Region.Framework.Interfaces.ISimulationDataService datastore, System.Boolean forcedBackup) [0x00341] in <8777cf221e4544bf893c42f6ef87e7f4>:0

書き込み場所 †[edit]

• Data/MySQL/MySQLSimulationData.cs

         private void ExecuteNonQuery(MySqlCommand c)
         {
             try
             {
                 c.ExecuteNonQuery();
             }
             catch (Exception e)
             {
                 m_log.Error("[REGION DB]: MySQL error in ExecuteNonQuery: " + e.Message);
                 throw;
             }
         }

データ設定場所 †[edit]

• /Data/MySQL/MySQLSimulationData.cs: L142辺り

        cmd.CommandText = "replace into prims (" +

データ読み込み場所 †[edit]

• /Data/MySQL/MySQLSimulationData.cs: L350辺り

         SceneObjectPart prim = BuildPrim(reader);