noborus / trdsql

CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats.
https://noborus.github.io/trdsql/
MIT License
1.94k stars 73 forks source link

Cannot use the tool, process gets instantly killed with 137 exit code #197

Closed rdsedmundo closed 8 months ago

rdsedmundo commented 1 year ago

Even if I run just trdsql -version it exists with a 137 exit code instantly. Any ideas? I'm using 0.10.0 and have installed (and tried to reinstall it already) via Homebrew.

I have used an older version in the past without issues. It's not a memory problem on my computer as I have plenty of RAM available.

~ ❯ trdsql -version                                                                                                                                                                                                        ✘ KILL 05:30:11 PM
[1]    16749 killed     trdsql -version
noborus commented 1 year ago

Hmmm. Could you tell me the environment such as os, os version, cpu, etc.?

rdsedmundo commented 1 year ago
$ pnpx envinfo

  System:
    OS: macOS 12.1
    CPU: (10) arm64 Apple M1 Max
    Memory: 1.75 GB / 32.00 GB
    Shell: 5.8 - /bin/zsh
  Binaries:
    Node: 16.15.0 - ~/.volta/tools/image/node/16.15.0/bin/node
    Yarn: 1.22.18 - ~/.volta/tools/image/yarn/1.22.18/bin/yarn
    npm: 8.5.5 - ~/.volta/tools/image/node/16.15.0/bin/npm
  Managers:
    Cargo: 1.59.0 - ~/homebrew/bin/cargo
    Homebrew: 3.5.10 - /Users/work/homebrew/bin/brew
    pip3: 21.3.1 - ~/homebrew/bin/pip3
    RubyGems: 3.0.3.1 - /usr/bin/gem
  Utilities:
    Make: 3.81 - /usr/bin/make
    GCC: 13.1.6 - /usr/bin/gcc
    Git: 2.32.0 - /usr/bin/git
    Clang: 13.1.6 - /usr/bin/clang
  Servers:
    Apache: 2.4.51 - /usr/sbin/apachectl
  Virtualization:
    Docker: 20.10.12 - /usr/local/bin/docker
  IDEs:
    Nano: 2.0.6 - /usr/bin/nano
    VSCode: 1.70.2 - /usr/local/bin/code
    Vim: 8.2 - /usr/bin/vim
    Xcode: /undefined - /usr/bin/xcodebuild
  Languages:
    Bash: 3.2.57 - /bin/bash
    Go: 1.17.3 - /Users/work/homebrew/bin/go
    Java: 17.0.1 - /usr/bin/javac
    Perl: 5.30.3 - /usr/bin/perl
    Python: 2.7.18 - /usr/bin/python
    Python3: 3.9.10 - /Users/work/homebrew/bin/python3
    Ruby: 2.6.8 - /usr/bin/ruby
    Rust: 1.59.0 - /Users/work/homebrew/bin/rustc
  Databases:
    SQLite: 3.36.0 - /usr/bin/sqlite3
  Browsers:
    Chrome: 104.0.5112.101
    Chrome Canary: 107.0.5261.1
    Firefox: 104.0
    Safari: 15.2
noborus commented 1 year ago

Thank you for the information. I ran homebrew macos-12 install test on github actions. it seems to be working.

https://github.com/noborus/homebrew-tap/runs/8047261109?check_suite_focus=true#step:3:33

So I don't know the cause yet.

srizzo commented 1 year ago

I believe github actions are running on an x86 and the issue happens on arm64

noborus commented 1 year ago

Hmm, could this be a code signing issue?

srizzo commented 1 year ago

Hmm, could this be a code signing issue?

So it seems.

My arm64 binary:

$ /opt/homebrew/Cellar/trdsql/0.10.1/bin/trdsql --version
Killed: 9
$ codesign --verify --deep --verbose /opt/homebrew/Cellar/trdsql/0.10.1/bin/trdsql
/opt/homebrew/Cellar/trdsql/0.10.1/bin/trdsql: invalid signature (code or signature have been modified)
In architecture: arm64

My x86 binary:

$ /usr/local/Cellar/trdsql/0.10.1/bin/trdsql --version
trdsql version v0.10.1
$ codesign --verify --deep --verbose /usr/local/Cellar/trdsql/0.10.1/bin/trdsql
/usr/local/Cellar/trdsql/0.10.1/bin/trdsql: code object is not signed at all
In architecture: x86_64
noborus commented 1 year ago

Hmm, could this be a code signing issue?

So it seems.

Thank you. What should I do...?

tyama711 commented 9 months ago

I also faced the same issue, but I was able to work around the problem by using go install to install it.

go install github.com/noborus/trdsql/cmd/trdsql@latest
noborus commented 9 months ago

Sorry for not being able to reply. For a while, I've been thinking of writing a note to remove the arm64 binary on the Mac in Homebrew, and the arm64 binary on the Mac, and use go install instead.

noborus commented 9 months ago

I tried changing the build method using github actions. Please let me know the results of your trial.

version: v.013.0-rc8

Homebrew(brew install noborus/tap/trdsql) https://github.com/noborus/homebrew-tap/blob/master/trdsql.rb

binary https://github.com/noborus/trdsql/releases/download/v0.13.0-rc8/trdsql_v0.13.0-rc8_darwin_arm64.zip

tyama711 commented 9 months ago

Thank you so much!! Now I can run this version on my M1 Mac!

❯ trdsql --version
trdsql version v0.13.0-rc8
noborus commented 9 months ago

Thank you so much!! Now I can run this version on my M1 Mac!

❯ trdsql --version
trdsql version v0.13.0-rc8

Thank you for your report. appreciate.

noborus commented 8 months ago

I think it's resolved, so I'll close it.