Any one familiar with this error?

exit code 100 error

Dani AI

Generated

A numeric exit status like 100 on Unix usually has no universal meaning — it is whatever the process (or a helper it invoked) chose to return. That makes the problem one of locating who called exit(100) or returned 100 and why. was right to ask for environment details; clarified it’s Unix and suspects a DB stored procedure, and correctly noted the value may come from someone else’s code.

A practical checklist to find the source and fix it:

  • Reproduce and isolate. Run the program from a shell and immediately check the status with echo $?. Try calling the stored procedure directly from your DB client (sql client, psql, sqlplus, mysql) to see whether it produces the same numeric result or an explicit DB error.

  • Search the codebase and scripts for literal returns or exits:

    grep -R --line-number -E "exit\\(|return[[:space:]]+100" .

    Also search SQL files for RETURN 100 or SIGNAL/RAISE.

  • Catch who issues the exit at runtime. Use strace to watch for the exit syscall:

    strace -f -e trace=process ./your_program 2>&1 | grep -E "exit_group|exit\\("

    Or run under gdb and break on exit to get a backtrace:

    gdb --args ./your_program [args]
    (gdb) break exit
    (gdb) run
    (gdb) bt
  • If the stored procedure is the culprit, add explicit diagnostics: an OUT parameter, log rows to a debug table, or have the procedure raise a descriptive error. Check the DB server error/log files for stack traces or messages.

Useful references: POSIX exit semantics and the lack of a standard meaning for arbitrary exit values (see sysexits for common conventions), and strace for catching exit calls: and https://man7.org/linux/man-pages/man1/strace.1.html

If the grep/trace shows the 100 originates inside a third-party module, get that module’s source or documentation to interpret the meaning.

Recommended Answers

All 4 Replies

Oops, sorry
Unix platform

It seems like on the DB section of my code, it might be on storing procedure might fail and return 100.

Check the piece of code that's throwing this error.. it could be written by someone else, in which case only that guy can tell you what he meant by 100 !
Looking at the info available it's not possible to say anything..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.