DBSolo 5 connection lost during SQL generation step

[Jyoti Ranjan Singh]

Hello Dbsolo Admin,

We have installed DBSolo in a linux machine and we are trying to sync the data from one database to another database.  

However, We are observing while SQL generation step the dbsolo is throwing connection lost error. We are not sure how to check if the error is due to DBSolo tool . Below are the version and driver details 

Source MySQL Version - MySQL 8.4

Destination MySQL Version - MySQL 8.4

MySQL Java Connector Driver used - 5.1.49

Would request to please kindly provide some step to debug this.

Regards,

Jyoti Ranjan Singh 

[DB Solo Admin]

Check your error.log file please. It should be in the same directory where the executable is. If you do not see the file, please start the tool as Administrator.

marko

[Jyoti Ranjan Singh]

Hello Marko,

Thanks for your quick response . Below is the error message i am getting in the logis which i am not sure what causes this and where exactly the connection lost.  It would be helpful if you can share your thoughts. Any pointers will really be appreciated. 

[2024-10-07 00:03:17.148] INFO: A: Starting sync file generation: /mnt/bkp/sync/scripts/dbsolo_sql/ProdPreview.sql
[2024-10-07 00:06:24.069] SEVERE: MainApp: Error performing comparison: {0}
Connection Lost
        at com.dbsolo.b.u.¤(Unknown Source)
        at com.dbsolo.b.u.Ħ(Unknown Source)
        at com.dbsolo.b.u.W(Unknown Source)
        at com.dbsolo.b.u.ª(Unknown Source)
        at com.dbsolo.b.u.A(Unknown Source)
        at com.dbsolo.Z.B.B.F.A(Unknown Source)
        at com.dbsolo.Z.B.B.F.B(Unknown Source)
        at com.dbsolo.Z.B.B.F.A(Unknown Source)
        at com.dbsolo.P.E.A.G(Unknown Source)
        at com.dbsolo.ui.MainApp.main(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:84)
        at com.install4j.runtime.launcher.UnixLauncher.start(UnixLauncher.java:66)
        at install4j.com.dbsolo.ui.MainApp_commandLine.main(Unknown Source)

Regards,

Jyoti Ranjan Singh

[DB Solo Admin]

Please send your entire error.log file to the support email address.

Marko