Bug #116491 SIGSEGV while synhronizing database to the model
Submitted: 28 Oct 2024 11:45 Modified: 29 Nov 2024 10:23
Reporter: Eugene Lyulka Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S1 (Critical)
Version:8.0.38 build 4270039 CE OS:MacOS (14.7 (23H124))
Assigned to: CPU Architecture:ARM (M1 Max)

[28 Oct 2024 11:45] Eugene Lyulka
Description:
Trying to synchronize model with remote database result in application crash after "Select changes to apply" step.

wb.log:
13:42:09 [DB3][SSHTunnelManager]: About to create ssh tunnel.
13:42:09 [DB2][SSHTunnelManager]: Tunnel port created on socket: 64766
13:42:09 [DB3][SSHTunnelHandler]: Start tunnel handler thread.
13:42:09 [DB2][SSHTunnelManager]: Wakeup socket got connection, reloading socketList.
13:42:09 [INF][     SSH tunnel]: SSH tunnel opened on port: 64766
13:42:09 [DB2][     SSH tunnel]: Increment port usage count: 64766
13:42:09 [DB3][SSHTunnelHandler]: About to handle new connection.
13:42:09 [DB3][SSHTunnelHandler]: Accepted new connection.
13:42:09 [DB3][SSHTunnelHandler]: Unable to open channel, wait a moment and retry.
13:42:09 [DB1][SSHTunnelHandler]: Channel successfully opened
13:42:09 [DB1][SSHTunnelHandler]: Tunnel created.
13:42:10 [INF][            grt]: Nothing to fetch	
13:42:10 [DB2][     SSH tunnel]: Decrement port usage count: 64766
13:42:10 [DB3][SSHTunnelHandler]: Tunnel handler thread stopped.
13:42:10 [DB2][SSHTunnelManager]: Shutdown port: 64766
13:42:10 [INF][            grt]: Updating model...	
13:42:10 [INF][       grt_diff]: Saving oldNames and other sync state info for Mysql@127.0.0.1:3306@****::mydb (catalog 1385696D-017B-4303-8408-0941EEAE9900)
13:42:10 [INF][       grt_diff]: Saving oldNames and other sync state info for Mysql@127.0.0.1:3306@****::**** (catalog 1385696D-017B-4303-8408-0941EEAE9900)
13:42:10 [DB3][   Undo manager]: begin undo group: 
13:42:10 [DB3][       grt_diff]: 3758486B-2BF7-4539-81DA-F47F6E13CE18 is not in primary mapping
13:42:10 [DB3][       grt_diff]: 92E8C223-10FE-4942-B8ED-10EFB95E3E3E is not in primary mapping
13:42:10 [DB3][       grt_diff]: com.mysql.rdbms.mysql.datatype.datetime_f is not in primary mapping
13:42:10 [DB3][       grt_diff]: com.mysql.rdbms.mysql.datatype.int is not in primary mapping
13:42:10 [DB3][       grt_diff]: com.mysql.rdbms.mysql.datatype.text is not in primary mapping
13:42:10 [DB3][       grt_diff]: com.mysql.rdbms.mysql.datatype.time_f is not in primary mapping
13:42:10 [DB3][       grt_diff]: com.mysql.rdbms.mysql.datatype.timestamp_f is not in primary mapping
13:42:10 [DB3][       grt_diff]: com.mysql.rdbms.mysql.datatype.varchar is not in primary mapping
13:42:10 [DB3][   Undo manager]: begin undo group: 
13:42:10 [DB3][   Undo manager]: end undo group: Rename 'profile_contracts' to 'predefined_contracts'

How to repeat:
Try to synchronize model with many tables and many differences.
[28 Oct 2024 11:46] Eugene Lyulka
crash dialog content

Attachment: crashlog.txt (text/plain), 105.61 KiB.

[29 Oct 2024 10:23] MySQL Verification Team
Hi Mr. Lyulka,

Thank you for your bug report.

Have you tried the fixes that Workbench recommended, like moving the columns to the primary mapping and also the last comment:

Rename 'profile_contracts' to 'predefined_contracts'

Let us know whether that helped.
[30 Nov 2024 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".