prims テーブルの TextカラムのUTF-8問題 
Error Message
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
書き込み場所
- 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; } }
データ設定場所
- /Data/MySQL/MySQLSimulationData.cs: L142辺り
cmd.CommandText = "replace into prims (" +
データ読み込み場所
- /Data/MySQL/MySQLSimulationData.cs: L350辺り
SceneObjectPart prim = BuildPrim(reader);
Counter: 181,
today: 1,
yesterday: 1
最終更新: 2023-08-15 (火) 19:15:16 (JST) (255d) by iseki
