Description:
When i change a charset/collation for a table column and synchronize this, the changes are correct executed in target table, but the statement will be not excluded from next synchronization-process.
Here the content of wb-log-file:
14:13:13 [INF][ WBContext UI]: Initializing workbench context UI with these values:
base dir: /usr/share/mysql-workbench
plugin path: /usr/lib/mysql-workbench/plugins
struct path: /usr/share/mysql-workbench/grt
module path: /usr/lib/mysql-workbench/modules
library path: /usr/share/mysql-workbench/libraries
user data dir: /home/timbuktu/.mysql/workbench
open at start:
open type:
run at startup:
run type:
Force SW rendering: No
Force OpenGL: No
quit when done: No
14:13:13 [INF][ WBContext]: WbContext::init
14:13:13 [INF][ WBA]: Looking for extension modules for WBA...
14:13:13 [INF][ WBA]: 0 extension modules found
14:13:13 [WRN][ grt]: Duplicate plugin name wb.tools.cmdlineClient There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
14:13:13 [WRN][ grt]: /home/timbuktu/.mysql/workbench/connections.xml:27: link 'db70e78a-149a-11ed-9e0e-87c31faea0d4' <object GrtObject> key=owner could not be resolved
14:13:13 [WRN][ grt]: Duplicate plugin name wb.tools.cmdlineClient There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
14:13:13 [INF][ WBContext]: System info:
MySQL Workbench Community (GPL) for Linux/Unix version 8.0.29 CE build 1751076 (64 bit)
Configuration Directory: /home/timbuktu/.mysql/workbench
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.16.0
OS: Ubuntu 22.04 x86_64
CPU: 16x 11th Gen Intel(R) Core(TM) i7-11800H @ 2.30GHz (800.000MHz) - 62,51GiB RAM
No video adapter info available
Distribution: Ubuntu 22.04.1 LTS
Fips mode enabled: no
14:13:13 [INF][ ModelContext]: Found model auto-save /home/timbuktu/.mysql/workbench/flex-container-v2.mwbd, but it is empty. Deleting it...
14:13:13 [INF][ WQE backend]: Found auto-save workspace /home/timbuktu/.mysql/workbench/sql_workspaces/Local_instance_3306-1.autosave
14:13:14 [WRN][ WBModule]: OS not found on supported OS list. OS string: 'Ubuntu 22.04 x86_64'
14:13:15 [INF][SQL Editor Form]: Opened connection 'Local instance 3306' to MySQL Community Server (GPL) version 5.7.38
14:13:18 [ERR][SQL Editor Form]: Unable to create db_mgmt_SSHConnectionRef object
14:13:19 [ERR][SQL Editor Form]: Unable to create db_mgmt_SSHConnectionRef object
14:15:23 [INF][ grt]: Fetching schema list.
14:15:23 [INF][ grt]: OK
14:15:24 [INF][ grt]: Fetching table list.
14:15:24 [INF][ grt]: 219 items from flex-container-base
14:15:24 [INF][ grt]: OK
14:15:24 [INF][ grt]: Fetching view list.
14:15:24 [INF][ grt]: 0 items from flex-container-base
14:15:24 [INF][ grt]: OK
14:15:24 [INF][ grt]: Fetching routine list.
14:15:24 [INF][ grt]: 0 items from flex-container-base
14:15:24 [INF][ grt]: OK
14:15:24 [INF][ grt]: Fetching trigger list.
14:15:24 [INF][ grt]: 24 items from flex-container-base
14:15:24 [INF][ grt]: OK
14:15:26 [INF][ grt_diff]: Restoring oldNames and other sync state info for Mysql@localhost:3306::flex-container-base (catalog 2969076f-126e-11ed-9afc-1f236f58f7d5)
14:15:31 [INF][ grt]: Applying synchronization scripts to server...
14:15:31 [INF][ grt]: Executing SQL script in server
14:15:31 [INF][ grt]: SQL script execution finished: statements: 8 succeeded, 0 failed
14:15:32 [INF][ grt]: Fetching back view definitions in final form.
14:15:32 [INF][ grt]: Nothing to fetch
14:15:32 [INF][ grt]: Updating model...
14:15:32 [INF][ grt_diff]: Saving oldNames and other sync state info for Mysql@localhost:3306::flex-container-base (catalog 2969076f-126e-11ed-9afc-1f236f58f7d5)
14:15:52 [INF][ grt]: Fetching schema list.
14:15:52 [INF][ grt]: OK
14:15:53 [INF][ grt]: Fetching table list.
14:15:53 [INF][ grt]: 219 items from flex-container-base
14:15:53 [INF][ grt]: OK
14:15:53 [INF][ grt]: Fetching view list.
14:15:53 [INF][ grt]: 0 items from flex-container-base
14:15:53 [INF][ grt]: OK
14:15:53 [INF][ grt]: Fetching routine list.
14:15:53 [INF][ grt]: 0 items from flex-container-base
14:15:53 [INF][ grt]: OK
14:15:53 [INF][ grt]: Fetching trigger list.
14:15:53 [INF][ grt]: 24 items from flex-container-base
14:15:53 [INF][ grt]: OK
14:15:55 [INF][ grt_diff]: Restoring oldNames and other sync state info for Mysql@localhost:3306::flex-container-base (catalog 2969076f-126e-11ed-9afc-1f236f58f7d5)
14:16:42 [INF][ grt]: Applying synchronization scripts to server...
14:16:42 [INF][ grt]: Executing SQL script in server
14:16:42 [INF][ grt]: SQL script execution finished: statements: 7 succeeded, 0 failed
14:16:43 [INF][ grt]: Fetching back view definitions in final form.
14:16:43 [INF][ grt]: Nothing to fetch
14:16:43 [INF][ grt]: Updating model...
14:16:43 [INF][ grt_diff]: Saving oldNames and other sync state info for Mysql@localhost:3306::flex-container-base (catalog 2969076f-126e-11ed-9afc-1f236f58f7d5)
14:16:51 [INF][ grt]: Fetching schema list.
14:16:51 [INF][ grt]: OK
14:16:52 [INF][ grt]: Fetching table list.
14:16:52 [INF][ grt]: 219 items from flex-container-base
14:16:52 [INF][ grt]: OK
14:16:52 [INF][ grt]: Fetching view list.
14:16:52 [INF][ grt]: 0 items from flex-container-base
14:16:52 [INF][ grt]: OK
14:16:52 [INF][ grt]: Fetching routine list.
14:16:52 [INF][ grt]: 0 items from flex-container-base
14:16:52 [INF][ grt]: OK
14:16:52 [INF][ grt]: Fetching trigger list.
14:16:52 [INF][ grt]: 24 items from flex-container-base
14:16:52 [INF][ grt]: OK
14:16:53 [INF][ grt_diff]: Restoring oldNames and other sync state info for Mysql@localhost:3306::flex-container-base (catalog 2969076f-126e-11ed-9afc-1f236f58f7d5)
14:18:18 [INF][ grt]: Fetching schema list.
14:18:18 [INF][ grt]: OK
14:18:19 [INF][ grt]: Fetching table list.
14:18:20 [INF][ grt]: 219 items from flex-container-base
14:18:20 [INF][ grt]: OK
14:18:20 [INF][ grt]: Fetching view list.
14:18:20 [INF][ grt]: 0 items from flex-container-base
14:18:20 [INF][ grt]: OK
14:18:20 [INF][ grt]: Fetching routine list.
14:18:20 [INF][ grt]: 0 items from flex-container-base
14:18:20 [INF][ grt]: OK
14:18:20 [INF][ grt]: Fetching trigger list.
14:18:20 [INF][ grt]: 24 items from flex-container-base
14:18:20 [INF][ grt]: OK
14:18:21 [INF][ grt_diff]: Restoring oldNames and other sync state info for Mysql@localhost:3306::flex-container-base (catalog 2969076f-126e-11ed-9afc-1f236f58f7d5)
14:18:37 [ERR][ pymforms]: Unhandled exception in Python code:
How to repeat:
Change a charset/collation from a table column and synchronize to target table. After this check the target table and start the synchronization-process again. You will still find the statement, although it was exectuted successfully in the synchronization-process before.
