Frequent crashes during the use of Oracle DB

[VadimMuhtarov]

1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): Oracle 19

2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 6.0.3 (555), Sonoma 14.5 (23F79)

3. The steps to reproduce this issue: No exact steps, just use Oracle DB and it will crash after some time

TablePlus-2024-05-16-091347.log TablePlus-2024-05-10-125536.log TablePlus-2024-05-13-123500.log TablePlus-2024-05-14-094354.log

[huyphams]

Hi @VadimMuhtarov thank you. We're using the Oracle Instant Client as the native driver, which is quite bad. It is only support intel base x86_64 which means TablePlus beta you're using running on Rosetta 2.

We will move away from Oracle Instant Client in the future updates with a better, lighter driver and support Apple Silicon Chip natively.

[huyphams]

And also lot of crashes and bugs that Oracle does not want to fix or care.

[VadimMuhtarov]

Do you mean TablePlus updates or new Bolt SQL client?

[huyphams]

TablePlus and Bolt SQL are two apps with different feature set. This update has nothing todo with Bolt SQL.

[huyphams]

Hi, please try this patch and see how it goes, TablePlus now support Oracle thin with ARM native driver, no need Rosetta 2. https://www.dropbox.com/scl/fi/rnzl329j9llknuoj0c0h1/TablePlus.dmg?rlkey=fykl1eshbl1ylnn48s5ic7rau&dl=0

[VadimMuhtarov]

Can't connect now, same database, same credentials. Should I create new bug ticket?

[huyphams]

Which Oracle version are you using @VadimMuhtarov ?

[VadimMuhtarov]

Oracle 19

[huyphams]

Let me add the error message and see what was wrong.

[huyphams]

You can download again using the same link above @VadimMuhtarov

[VadimMuhtarov]

Looks like something wrong with credentials in this version, because I reinstalled Rosetta 2 version and it works

[huyphams]

ah my bad, building a new build.

[huyphams]

You can try again, the same link above

[VadimMuhtarov]

Connected, will be testing

[huyphams]

Crashes are expected but it is easy to fix them now, please report if you have found any. Thanks

[VadimMuhtarov]

Crashed in background again TablePlus-2024-06-21-101334.logs.log And another one TablePlus-2024-06-21-104008.log And again TablePlus-2024-06-21-104100.log

[huyphams]

Hi @VadimMuhtarov just updated the build you can download again using the same link. It also would be great if you can attach the report from Apple report instead of the json. it's hard to see the crash log.

[VadimMuhtarov]

Just got another 2 crashes on the latest build. Don't know what you mean under "Apple report", but these are from Crash Reports in Console utility TablePlus-2024-06-22-082048.ips.zip TablePlus-2024-06-22-082418.ips.zip

[huyphams]

@VadimMuhtarov thanks, after the app crash, Apple usually shows a report popup, you can click detail to see the crash call stack.

[huyphams]

btw, I think your two recent crash logs are good enough, thank you very much!

[VadimMuhtarov]

Just copied a fresh log from that popup if needed crash.log

[huyphams]

Do you have the step to reproduce the issue?

[VadimMuhtarov]

Most of the crashes are random. The last one was after I ran

SELECT * FROM table_1 A JOIN table_2 B ON A.ID = B.ID JOIN table_3 C ON B.ID = C.ID;

This crash is reproducible

[huyphams]

Just updated the new build with more debugging symbol and support Oracle XML TYPE decoding. If you have a chance, please try it. (same link above).

[VadimMuhtarov]

TablePlus-2024-06-22-220936.ips.zip

[huyphams]

Just updated the build which prevents TablePlus from the crash in your report.

[VadimMuhtarov]

This crash has been fixed, thanks, I'll keep looking.

[huyphams]

thanks for confirming, going to publish new official beta build now.