Does not work with ob-sql-mode? about ob-async HOT 10 CLOSED

Thank you so much!
After adding sql to that list it works now.
You might want to add that information to your documentation as it was not required without the :async parameter.

from ob-async.

Looks like you're using :session, which isn't supported, unfortunately (see #1). Can you check whether it works without :session?

from ob-async.

Closing due to inactivity.

from ob-async.

I can confirm this bug without :session as well. Same error message
Symbol’s function definition is void: org-babel-execute:sql-mode

from ob-async.

@baron42bba I've just pushed (what I hope is) a fix in #27. Can you confirm whether you still see this issue on the latest revision of master? If so, can you upload your troubleshooting.org output?

from ob-async.

#+TITLE: Issue Reporting Checklist
#+PROPERTIES: :header-args :results value

This checklist will help you diagnose problems with your =ob-async=
setup.

• Instructions

Execute the src blocks one at a time with =ctrl-c ctrl-c= to
ensure that =ob-async-org-babel-execute-src-block= is used for files
with the :async header-arg. If by the end of this file your issue
isn't solved, open an issue on Github with the contents of this file.

First, make sure you can execute emacs-lisp src blocks without the
async header argument. Otherwise you've got bigger problems, and none
of this is going to work.

#+BEGIN_SRC emacs-lisp
(message "Yes, I can synchronously execute emacs-lisp from an org-babel src block.")
#+END_SRC

#+RESULTS:
: Yes, I can synchronously execute emacs-lisp from an org-babel src block.

• Checklist

Have you installed the =ctrl-c ctrl-c= hook as described in the
README? If so, you should see =ob-async-org-babel-execute-src-block=
in this list.

#+BEGIN_SRC emacs-lisp :results value
(message "%s" org-ctrl-c-ctrl-c-hook)
#+END_SRC

#+RESULTS:
: nil

From where are you loading =ob-async=?

#+BEGIN_SRC emacs-lisp
(symbol-file 'ob-async-org-babel-execute-src-block)
#+END_SRC

#+RESULTS:
: /Users/andreas/.emacs.d/elpa/ob-async-20180410.2058/ob-async.el

#+BEGIN_SRC emacs-lisp
(message "PID: %s\nEmacs version: %s\norg version: %s\nPath to org: %s" (emacs-pid) (emacs-version) (org-version) (symbol-file 'org-version))
#+END_SRC

#+RESULTS:
: PID: 888
: Emacs version: GNU Emacs 25.3.1 (x86_64-apple-darwin13.4.0, NS appkit-1265.21 Version 10.9.5 (Build 13F1911))
: of 2017-09-12
: org version: 9.1.2
: Path to org: /Users/andreas/.emacs.d/elpa/org-20171030/org.el

Execution of the :async block occurs in an Emacs subprocess. Are you
using a consistent version of emacs and org-mode across both
processes? Compare the output of this block the output of the previous block.

#+BEGIN_SRC emacs-lisp :async
(message "PID: %s\nEmacs version: %s\norg version: %s\nPath to org: %s" (emacs-pid) (emacs-version) (org-version) (symbol-file 'org-version))
#+END_SRC

#+RESULTS:
: PID: 21271
: Emacs version: GNU Emacs 25.3.1 (x86_64-apple-darwin13.4.0, NS appkit-1265.21 Version 10.9.5 (Build 13F1911))
: of 2017-09-12
: org version: 9.1.2
: Path to org: /Users/andreas/.emacs.d/elpa/org-20171030/org.el

If you're using a consistent version and still facing problems, turn
on async debugging.

#+BEGIN_SRC emacs-lisp
(setq async-debug t)
#+END_SRC

#+RESULTS:
: t

If possible, replace the following block with a block that reproduces
your problem, then execute it.

#+BEGIN_SRC emacs-lisp :async
(message "I'm executed in a subprocess.")
#+END_SRC

#+RESULTS:
: I’m executed in a subprocess.

This is the elisp that was sent to the Emacs subprocess. If there's
still nothing obviously wrong, file an issue on GitHub and include the
contents of this file as a Gist.

#+BEGIN_SRC emacs-lisp
(switch-to-buffer "Messages")
(goto-char (point-max))
(re-search-backward "Transmitting sexp {{{\([^}]+\)}}}")
(match-string 1)
#+END_SRC

#+RESULTS:
#+begin_example
'(lambda nil
(setq exec-path
'("/Users/andreas/perl5/bin" "/Users/andreas/Library/Python/2.7/bin" "/usr/local/MacGPG2/bin" "/Library/TeX/texbin" "/Users/andreas/.gopath/bin" "/Users/andreas/bin" "/opt/local/bin" "/usr/local/bin" "/usr/bin" "/bin" "/usr/sbin" "/sbin" "/Applications/Emacs.app/Contents/MacOS/bin-x86_64-10_9" "/Applications/Emacs.app/Contents/MacOS/libexec-x86_64-10_9" "/usr/bin" "/bin" "/usr/sbin" "/sbin" "/Applications/Emacs.app/Contents/MacOS/bin-x86_64-10_9" "/Applications/Emacs.app/Contents/MacOS/libexec-x86_64-10_9" "/Applications/Emacs.app/Contents/MacOS/libexec" "/Applications/Emacs.app/Contents/MacOS/bin"))
(setq load-path
'("/.emacs.d/elpa/keyfreq-20160516.716" "/.emacs.d/elpa/key-chord-20151209.104" "/.emacs.d/elpa/helm-descbinds-20160108.1947" "/.emacs.d/elpa/helm-20160530.424" "/.emacs.d/elpa/sqlup-mode-20160911.1911" "/.emacs.d/elpa/auto-complete-20160107.8" "/.emacs.d/elpa/elfeed-org-20150412.145" "/.emacs.d/elpa/elfeed-20150608.13027" "/.emacs.d/elpa/twittering-mode-20160207.156" "/.emacs.d/elpa/avy-20171230.220" "/.emacs.d/elpa/guide-key-20150107.2235" "/.emacs.d/elpa/popwin-20150315.600" "/.emacs.d/elpa/flycheck-20160218.41" "/.emacs.d/elpa/yasnippet-20180204.1613" "/.emacs.d/elpa/expand-region-20150525.205" "/.emacs.d/elpa/rainbow-delimiters-20150320.17" "/.emacs.d/elpa/dash-20170810.137" "/.emacs.d/elpa/smartparens-20160217.1102" "/.emacs.d/elpa/focus-20160111.522" "/.emacs.d/elpa/popup-20151222.1339" "/.emacs.d/elpa" "/.emacs.d/elpa/async-20170916.2256" "/Users/andreas/.emacs.d/lisp" "/Users/andreas/.emacs.d/elpa/org-20171030" "/Users/andreas/.emacs.d/elpa/ac-helm-20140919.917" "/Users/andreas/.emacs.d/elpa/ace-jump-mode-20140616.115" "/Users/andreas/.emacs.d/elpa/alert-20160824.821" "/Users/andreas/.emacs.d/elpa/apples-mode-20110120.2018" "/Users/andreas/.emacs.d/elpa/artbollocks-mode-20141212.1332" "/Users/andreas/.emacs.d/elpa/ascii-3.1" "/Users/andreas/.emacs.d/elpa/avy-20171230.220" "/Users/andreas/.emacs.d/elpa/aws-snippets-20180410.845" "/Users/andreas/.emacs.d/elpa/bug-hunter-1.3.1" "/Users/andreas/.emacs.d/elpa/centered-cursor-mode-20151001.634/" "/Users/andreas/.emacs.d/elpa/circe-20161102.1405" "/Users/andreas/.emacs.d/elpa/color-identifiers-mode-20150602.1804/" "/Users/andreas/.emacs.d/elpa/command-log-mode-20160412.2147" "/Users/andreas/.emacs.d/elpa/csv-mode-1.6/" "/Users/andreas/.emacs.d/elpa/csv-nav-20130407.1120/" "/Users/andreas/.emacs.d/elpa/demo-it-20170628.1503" "/Users/andreas/.emacs.d/elpa/dired+-20160124.1907/" "/Users/andreas/.emacs.d/elpa/dired-narrow-20160130.845/" "/Users/andreas/.emacs.d/elpa/dired-hacks-utils-20150819.948/" "/Users/andreas/.emacs.d/elpa/editorconfig-20171208.2036" "/Users/andreas/.emacs.d/elpa/ejc-sql-20170215.321" "/Users/andreas/.emacs.d/elpa/auto-complete-20160107.8/" "/Users/andreas/.emacs.d/elpa/clomacs-20170128.850" "/Users/andreas/.emacs.d/elpa/cider-20170129.1941" "/Users/andreas/.emacs.d/elpa/clojure-mode-20170120.2239" "/Users/andreas/.emacs.d/elpa/elfeed-org-20150412.145/" "/Users/andreas/.emacs.d/elpa/elfeed-20150608.1302/" "/Users/andreas/.emacs.d/elpa/emojify-20160928.550" "/Users/andreas/.emacs.d/elpa/engine-mode-20150902.1035/" "/Users/andreas/.emacs.d/elpa/epoch-view-0.0.1/" "/Users/andreas/.emacs.d/elpa/expand-region-20150525.205/" "/Users/andreas/.emacs.d/elpa/flycheck-20160218.41/" "/Users/andreas/.emacs.d/elpa/flymake-puppet-20141006.1855/" "/Users/andreas/.emacs.d/elpa/flymake-easy-20140818.55/" "/Users/andreas/.emacs.d/elpa/focus-20160111.522/" "/Users/andreas/.emacs.d/elpa/fullframe-20160209.2318/" "/Users/andreas/.emacs.d/elpa/fullscreen-mode-20130524.956" "/Users/andreas/.emacs.d/elpa/ggtags-20151214.1344/" "/Users/andreas/.emacs.d/elpa/git-timemachine-20160120.416/" "/Users/andreas/.emacs.d/elpa/gntp-20141024.1950" "/Users/andreas/.emacs.d/elpa/gnuplot-20141231.1337" "/Users/andreas/.emacs.d/elpa/go-mode-20170726.555" "/Users/andreas/.emacs.d/elpa/go-snippets-20170831.2302" "/Users/andreas/.emacs.d/elpa/guide-key-20150107.2235/" "/Users/andreas/.emacs.d/elpa/helm-aws-20151124.133/" "/Users/andreas/.emacs.d/elpa/helm-c-yasnippet-20151231.10/" "/Users/andreas/.emacs.d/elpa/helm-descbinds-20160108.1947/" "/Users/andreas/.emacs.d/elpa/helm-git-20120630.1403" "/Users/andreas/.emacs.d/elpa/helm-gtags-20160202.503/" "/Users/andreas/.emacs.d/elpa/helm-projectile-20151220.221/" "/Users/andreas/.emacs.d/elpa/helm-safari-20160115.2334/" "/Users/andreas/.emacs.d/elpa/helm-swoop-20170923.2127" "/Users/andreas/.emacs.d/elpa/highlight-symbol-20160102.1209" "/Users/andreas/.emacs.d/elpa/impatient-mode-20150501.247/" "/Users/andreas/.emacs.d/elpa/json-mode-20170418.1900" "/Users/andreas/.emacs.d/elpa/json-reformat-20160212.53" "/Users/andreas/.emacs.d/elpa/json-snatcher-20150511.2047" "/Users/andreas/.emacs.d/elpa/key-chord-20151209.104/" "/Users/andreas/.emacs.d/elpa/keyfreq-20160516.716" "/Users/andreas/.emacs.d/elpa/langtool-20160116.1654/" "/Users/andreas/.emacs.d/elpa/log4e-20150105.505" "/Users/andreas/.emacs.d/elpa/magit-gitflow-20170929.124" "/Users/andreas/.emacs.d/elpa/magit-20180404.1428" "/Users/andreas/.emacs.d/elpa/git-commit-20180401.314" "/Users/andreas/.emacs.d/elpa/ghub-20180404.520" "/Users/andreas/.emacs.d/elpa/magit-popup-20180329.1302" "/Users/andreas/.emacs.d/elpa/mew-20161030.1807" "/Users/andreas/.emacs.d/elpa/multiple-cursors-20160513.316/" "/Users/andreas/.emacs.d/elpa/mustache-20131117.1407" "/Users/andreas/.emacs.d/elpa/ht-20140122.1555" "/Users/andreas/.emacs.d/elpa/mustache-mode-20141024.732/" "/Users/andreas/.emacs.d/elpa/mwe-log-commands-20100703.541" "/Users/andreas/.emacs.d/elpa/neotree-20160306.730/" "/Users/andreas/.emacs.d/elpa/ob-async-20180410.2058" "/Users/andreas/.emacs.d/elpa/ob-cfengine3-20170915.634" "/Users/andreas/.emacs.d/elpa/ob-restclient-20160323.2305" "/Users/andreas/.emacs.d/elpa/org-chef-20180304.1104" "/Users/andreas/.emacs.d/elpa/org-jira-20170527.2154" "/Users/andreas/.emacs.d/elpa/org-mime-20171105.1440" "/Users/andreas/.emacs.d/elpa/org-plus-contrib-20170407" "/Users/andreas/.emacs.d/elpa/org-sticky-header-20170422.2135" "/Users/andreas/.emacs.d/elpa/org-tree-slide-20151222.2347/" "/Users/andreas/.emacs.d/elpa/ox-clip-20161106.823" "/Users/andreas/.emacs.d/elpa/htmlize-20130207.1202" "/Users/andreas/.emacs.d/elpa/ox-jira-20161026.429" "/Users/andreas/.emacs.d/elpa/ox-reveal-20161027.226" "/Users/andreas/.emacs.d/elpa/org-20171030" "/Users/andreas/.emacs.d/elpa/package-lint-20171201.1903" "/Users/andreas/.emacs.d/elpa/paradox-20150611.645/" "/Users/andreas/.emacs.d/elpa/popwin-20150315.600/" "/Users/andreas/.emacs.d/elpa/projectile-20160210.905/" "/Users/andreas/.emacs.d/elpa/puppet-mode-20150730.1208/" "/Users/andreas/.emacs.d/elpa/pkg-info-20150517.443/" "/Users/andreas/.emacs.d/elpa/epl-20150517.433/" "/Users/andreas/.emacs.d/elpa/queue-0.1.1" "/Users/andreas/.emacs.d/elpa/rainbow-delimiters-20150320.17/" "/Users/andreas/.emacs.d/elpa/rainbow-mode-0.12/" "/Users/andreas/.emacs.d/elpa/request-20160822.1659" "/Users/andreas/.emacs.d/elpa/restclient-helm-20160407.249/" "/Users/andreas/.emacs.d/elpa/helm-20160530.424/" "/Users/andreas/.emacs.d/elpa/popup-20151222.1339/" "/Users/andreas/.emacs.d/elpa/restclient-20160414.1524/" "/Users/andreas/.emacs.d/elpa/rhtml-mode-20130422.611/" "/Users/andreas/.emacs.d/elpa/s-20140910.334/" "/Users/andreas/.emacs.d/elpa/seq-2.19" "/Users/andreas/.emacs.d/elpa/sicp-20151130.757/" "/Users/andreas/.emacs.d/elpa/simple-httpd-20150430.1755/" "/Users/andreas/.emacs.d/elpa/smartparens-20160217.1102/" "/Users/andreas/.emacs.d/elpa/spinner-1.7.3" "/Users/andreas/.emacs.d/elpa/sqlup-mode-20160911.1911" "/Users/andreas/.emacs.d/elpa/string-edit-20151213.930/" "/Users/andreas/.emacs.d/elpa/dash-20170810.137" "/Users/andreas/.emacs.d/elpa/sx-20150702.818/" "/Users/andreas/.emacs.d/elpa/let-alist-1.0.5" "/Users/andreas/.emacs.d/elpa/markdown-mode-20160219.913/" "/Users/andreas/.emacs.d/elpa/terraform-mode-20160823.31/" "/Users/andreas/.emacs.d/elpa/hcl-mode-20160502.1700/" "/Users/andreas/.emacs.d/elpa/tldr-20160106.2055/" "/Users/andreas/.emacs.d/elpa/tt-mode-20130804.410" "/Users/andreas/.emacs.d/elpa/twittering-mode-20160207.156/" "/Users/andreas/.emacs.d/elpa/undo-tree-20140509.522/" "/Users/andreas/.emacs.d/elpa/vertica-snippets-20180207.453" "/Users/andreas/.emacs.d/elpa/visual-ascii-mode-20150129.246" "/Users/andreas/.emacs.d/elpa/visual-regexp-20150329.954" "/Users/andreas/.emacs.d/elpa/websocket-20161022.2054" "/Users/andreas/.emacs.d/elpa/with-editor-20180318.1253" "/Users/andreas/.emacs.d/elpa/x-path-walker-20160822.1015/" "/Users/andreas/.emacs.d/elpa/helm-core-20160530.52/" "/Users/andreas/.emacs.d/elpa/async-20170916.2256" "/Users/andreas/.emacs.d/elpa/yaml-mode-20160220.340/" "/Users/andreas/.emacs.d/elpa/yasnippet-20180204.1613" "/Library/Application Support/Emacs/25.3/site-lisp" "/Library/Application Support/Emacs/site-lisp" "/Applications/Emacs.app/Contents/Resources/site-lisp" "/Applications/Emacs.app/Contents/Resources/lisp" "/Applications/Emacs.app/Contents/Resources/lisp/vc" "/Applications/Emacs.app/Contents/Resources/lisp/url" "/Applications/Emacs.app/Contents/Resources/lisp/textmodes" "/Applications/Emacs.app/Contents/Resources/lisp/progmodes" "/Applications/Emacs.app/Contents/Resources/lisp/play" "/Applications/Emacs.app/Contents/Resources/lisp/nxml" "/Applications/Emacs.app/Contents/Resources/lisp/net" "/Applications/Emacs.app/Contents/Resources/lisp/mh-e" "/Applications/Emacs.app/Contents/Resources/lisp/mail" "/Applications/Emacs.app/Contents/Resources/lisp/leim" "/Applications/Emacs.app/Contents/Resources/lisp/language" "/Applications/Emacs.app/Contents/Resources/lisp/international" "/Applications/Emacs.app/Contents/Resources/lisp/gnus" "/Applications/Emacs.app/Contents/Resources/lisp/eshell" "/Applications/Emacs.app/Contents/Resources/lisp/erc" "/Applications/Emacs.app/Contents/Resources/lisp/emulation" "/Applications/Emacs.app/Contents/Resources/lisp/emacs-lisp" "/Applications/Emacs.app/Contents/Resources/lisp/cedet" "/Applications/Emacs.app/Contents/Resources/lisp/calendar" "/Applications/Emacs.app/Contents/Resources/lisp/calc" "/Applications/Emacs.app/Contents/Resources/lisp/obsolete" "/.emacs.d/elpa/org-plus-contrib-20170407" "/.emacs.d/elpa/org-sticky-header-20170422.2135" "/.emacs.d/elpa/ggtags-20151214.1344" "/.emacs.d/elpa/helm-gtags-20160202.503"))
(package-initialize)
(org-babel-do-load-languages 'org-babel-load-languages
'((shell . t)
(python . t)
(R . t)
(ruby . t)
(ditaa . t)
(dot . t)
(octave . t)
(sqlite . t)
(perl . t)))
(let
((default-directory "/Users/andreas/git/github/ob-async/"))
(org-babel-execute:emacs-lisp "(message "I'm executed in a subprocess.")"
'((:colname-names)
(:rowname-names)
(:result-params "replace")
(:result-type . value)
(:results . "replace")
(:exports . "code")
(:session . "none")
(:cache . "no")
(:noweb . "no")
(:hlines . "no")
(:tangle . "no")
(:lexical . "no")
(:async)))))
#+end_example

#+BEGIN_SRC emacs-lisp
(switch-to-buffer "Messages")
(goto-char (point-max))
(re-search-backward "Transmitting sexp {{{\([^}]+\)}}}")
(match-string 1)
#+END_SRC

#+RESULTS:
#+begin_example
'(lambda nil
(setq exec-path
'("/Users/andreas/perl5/bin" "/Users/andreas/Library/Python/2.7/bin" "/usr/local/MacGPG2/bin" "/Library/TeX/texbin" "/Users/andreas/.gopath/bin" "/Users/andreas/bin" "/opt/local/bin" "/usr/local/bin" "/usr/bin" "/bin" "/usr/sbin" "/sbin" "/Applications/Emacs.app/Contents/MacOS/bin-x86_64-10_9" "/Applications/Emacs.app/Contents/MacOS/libexec-x86_64-10_9" "/usr/bin" "/bin" "/usr/sbin" "/sbin" "/Applications/Emacs.app/Contents/MacOS/bin-x86_64-10_9" "/Applications/Emacs.app/Contents/MacOS/libexec-x86_64-10_9" "/Applications/Emacs.app/Contents/MacOS/libexec" "/Applications/Emacs.app/Contents/MacOS/bin"))
(setq load-path
'("/.emacs.d/elpa/keyfreq-20160516.716" "/.emacs.d/elpa/key-chord-20151209.104" "/.emacs.d/elpa/helm-descbinds-20160108.1947" "/.emacs.d/elpa/helm-20160530.424" "/.emacs.d/elpa/sqlup-mode-20160911.1911" "/.emacs.d/elpa/auto-complete-20160107.8" "/.emacs.d/elpa/elfeed-org-20150412.145" "/.emacs.d/elpa/elfeed-20150608.13027" "/.emacs.d/elpa/twittering-mode-20160207.156" "/.emacs.d/elpa/avy-20171230.220" "/.emacs.d/elpa/guide-key-20150107.2235" "/.emacs.d/elpa/popwin-20150315.600" "/.emacs.d/elpa/flycheck-20160218.41" "/.emacs.d/elpa/yasnippet-20180204.1613" "/.emacs.d/elpa/expand-region-20150525.205" "/.emacs.d/elpa/rainbow-delimiters-20150320.17" "/.emacs.d/elpa/dash-20170810.137" "/.emacs.d/elpa/smartparens-20160217.1102" "/.emacs.d/elpa/focus-20160111.522" "/.emacs.d/elpa/popup-20151222.1339" "/.emacs.d/elpa" "/.emacs.d/elpa/async-20170916.2256" "/Users/andreas/.emacs.d/lisp" "/Users/andreas/.emacs.d/elpa/org-20171030" "/Users/andreas/.emacs.d/elpa/ac-helm-20140919.917" "/Users/andreas/.emacs.d/elpa/ace-jump-mode-20140616.115" "/Users/andreas/.emacs.d/elpa/alert-20160824.821" "/Users/andreas/.emacs.d/elpa/apples-mode-20110120.2018" "/Users/andreas/.emacs.d/elpa/artbollocks-mode-20141212.1332" "/Users/andreas/.emacs.d/elpa/ascii-3.1" "/Users/andreas/.emacs.d/elpa/avy-20171230.220" "/Users/andreas/.emacs.d/elpa/aws-snippets-20180410.845" "/Users/andreas/.emacs.d/elpa/bug-hunter-1.3.1" "/Users/andreas/.emacs.d/elpa/centered-cursor-mode-20151001.634/" "/Users/andreas/.emacs.d/elpa/circe-20161102.1405" "/Users/andreas/.emacs.d/elpa/color-identifiers-mode-20150602.1804/" "/Users/andreas/.emacs.d/elpa/command-log-mode-20160412.2147" "/Users/andreas/.emacs.d/elpa/csv-mode-1.6/" "/Users/andreas/.emacs.d/elpa/csv-nav-20130407.1120/" "/Users/andreas/.emacs.d/elpa/demo-it-20170628.1503" "/Users/andreas/.emacs.d/elpa/dired+-20160124.1907/" "/Users/andreas/.emacs.d/elpa/dired-narrow-20160130.845/" "/Users/andreas/.emacs.d/elpa/dired-hacks-utils-20150819.948/" "/Users/andreas/.emacs.d/elpa/editorconfig-20171208.2036" "/Users/andreas/.emacs.d/elpa/ejc-sql-20170215.321" "/Users/andreas/.emacs.d/elpa/auto-complete-20160107.8/" "/Users/andreas/.emacs.d/elpa/clomacs-20170128.850" "/Users/andreas/.emacs.d/elpa/cider-20170129.1941" "/Users/andreas/.emacs.d/elpa/clojure-mode-20170120.2239" "/Users/andreas/.emacs.d/elpa/elfeed-org-20150412.145/" "/Users/andreas/.emacs.d/elpa/elfeed-20150608.1302/" "/Users/andreas/.emacs.d/elpa/emojify-20160928.550" "/Users/andreas/.emacs.d/elpa/engine-mode-20150902.1035/" "/Users/andreas/.emacs.d/elpa/epoch-view-0.0.1/" "/Users/andreas/.emacs.d/elpa/expand-region-20150525.205/" "/Users/andreas/.emacs.d/elpa/flycheck-20160218.41/" "/Users/andreas/.emacs.d/elpa/flymake-puppet-20141006.1855/" "/Users/andreas/.emacs.d/elpa/flymake-easy-20140818.55/" "/Users/andreas/.emacs.d/elpa/focus-20160111.522/" "/Users/andreas/.emacs.d/elpa/fullframe-20160209.2318/" "/Users/andreas/.emacs.d/elpa/fullscreen-mode-20130524.956" "/Users/andreas/.emacs.d/elpa/ggtags-20151214.1344/" "/Users/andreas/.emacs.d/elpa/git-timemachine-20160120.416/" "/Users/andreas/.emacs.d/elpa/gntp-20141024.1950" "/Users/andreas/.emacs.d/elpa/gnuplot-20141231.1337" "/Users/andreas/.emacs.d/elpa/go-mode-20170726.555" "/Users/andreas/.emacs.d/elpa/go-snippets-20170831.2302" "/Users/andreas/.emacs.d/elpa/guide-key-20150107.2235/" "/Users/andreas/.emacs.d/elpa/helm-aws-20151124.133/" "/Users/andreas/.emacs.d/elpa/helm-c-yasnippet-20151231.10/" "/Users/andreas/.emacs.d/elpa/helm-descbinds-20160108.1947/" "/Users/andreas/.emacs.d/elpa/helm-git-20120630.1403" "/Users/andreas/.emacs.d/elpa/helm-gtags-20160202.503/" "/Users/andreas/.emacs.d/elpa/helm-projectile-20151220.221/" "/Users/andreas/.emacs.d/elpa/helm-safari-20160115.2334/" "/Users/andreas/.emacs.d/elpa/helm-swoop-20170923.2127" "/Users/andreas/.emacs.d/elpa/highlight-symbol-20160102.1209" "/Users/andreas/.emacs.d/elpa/impatient-mode-20150501.247/" "/Users/andreas/.emacs.d/elpa/json-mode-20170418.1900" "/Users/andreas/.emacs.d/elpa/json-reformat-20160212.53" "/Users/andreas/.emacs.d/elpa/json-snatcher-20150511.2047" "/Users/andreas/.emacs.d/elpa/key-chord-20151209.104/" "/Users/andreas/.emacs.d/elpa/keyfreq-20160516.716" "/Users/andreas/.emacs.d/elpa/langtool-20160116.1654/" "/Users/andreas/.emacs.d/elpa/log4e-20150105.505" "/Users/andreas/.emacs.d/elpa/magit-gitflow-20170929.124" "/Users/andreas/.emacs.d/elpa/magit-20180404.1428" "/Users/andreas/.emacs.d/elpa/git-commit-20180401.314" "/Users/andreas/.emacs.d/elpa/ghub-20180404.520" "/Users/andreas/.emacs.d/elpa/magit-popup-20180329.1302" "/Users/andreas/.emacs.d/elpa/mew-20161030.1807" "/Users/andreas/.emacs.d/elpa/multiple-cursors-20160513.316/" "/Users/andreas/.emacs.d/elpa/mustache-20131117.1407" "/Users/andreas/.emacs.d/elpa/ht-20140122.1555" "/Users/andreas/.emacs.d/elpa/mustache-mode-20141024.732/" "/Users/andreas/.emacs.d/elpa/mwe-log-commands-20100703.541" "/Users/andreas/.emacs.d/elpa/neotree-20160306.730/" "/Users/andreas/.emacs.d/elpa/ob-async-20180410.2058" "/Users/andreas/.emacs.d/elpa/ob-cfengine3-20170915.634" "/Users/andreas/.emacs.d/elpa/ob-restclient-20160323.2305" "/Users/andreas/.emacs.d/elpa/org-chef-20180304.1104" "/Users/andreas/.emacs.d/elpa/org-jira-20170527.2154" "/Users/andreas/.emacs.d/elpa/org-mime-20171105.1440" "/Users/andreas/.emacs.d/elpa/org-plus-contrib-20170407" "/Users/andreas/.emacs.d/elpa/org-sticky-header-20170422.2135" "/Users/andreas/.emacs.d/elpa/org-tree-slide-20151222.2347/" "/Users/andreas/.emacs.d/elpa/ox-clip-20161106.823" "/Users/andreas/.emacs.d/elpa/htmlize-20130207.1202" "/Users/andreas/.emacs.d/elpa/ox-jira-20161026.429" "/Users/andreas/.emacs.d/elpa/ox-reveal-20161027.226" "/Users/andreas/.emacs.d/elpa/org-20171030" "/Users/andreas/.emacs.d/elpa/package-lint-20171201.1903" "/Users/andreas/.emacs.d/elpa/paradox-20150611.645/" "/Users/andreas/.emacs.d/elpa/popwin-20150315.600/" "/Users/andreas/.emacs.d/elpa/projectile-20160210.905/" "/Users/andreas/.emacs.d/elpa/puppet-mode-20150730.1208/" "/Users/andreas/.emacs.d/elpa/pkg-info-20150517.443/" "/Users/andreas/.emacs.d/elpa/epl-20150517.433/" "/Users/andreas/.emacs.d/elpa/queue-0.1.1" "/Users/andreas/.emacs.d/elpa/rainbow-delimiters-20150320.17/" "/Users/andreas/.emacs.d/elpa/rainbow-mode-0.12/" "/Users/andreas/.emacs.d/elpa/request-20160822.1659" "/Users/andreas/.emacs.d/elpa/restclient-helm-20160407.249/" "/Users/andreas/.emacs.d/elpa/helm-20160530.424/" "/Users/andreas/.emacs.d/elpa/popup-20151222.1339/" "/Users/andreas/.emacs.d/elpa/restclient-20160414.1524/" "/Users/andreas/.emacs.d/elpa/rhtml-mode-20130422.611/" "/Users/andreas/.emacs.d/elpa/s-20140910.334/" "/Users/andreas/.emacs.d/elpa/seq-2.19" "/Users/andreas/.emacs.d/elpa/sicp-20151130.757/" "/Users/andreas/.emacs.d/elpa/simple-httpd-20150430.1755/" "/Users/andreas/.emacs.d/elpa/smartparens-20160217.1102/" "/Users/andreas/.emacs.d/elpa/spinner-1.7.3" "/Users/andreas/.emacs.d/elpa/sqlup-mode-20160911.1911" "/Users/andreas/.emacs.d/elpa/string-edit-20151213.930/" "/Users/andreas/.emacs.d/elpa/dash-20170810.137" "/Users/andreas/.emacs.d/elpa/sx-20150702.818/" "/Users/andreas/.emacs.d/elpa/let-alist-1.0.5" "/Users/andreas/.emacs.d/elpa/markdown-mode-20160219.913/" "/Users/andreas/.emacs.d/elpa/terraform-mode-20160823.31/" "/Users/andreas/.emacs.d/elpa/hcl-mode-20160502.1700/" "/Users/andreas/.emacs.d/elpa/tldr-20160106.2055/" "/Users/andreas/.emacs.d/elpa/tt-mode-20130804.410" "/Users/andreas/.emacs.d/elpa/twittering-mode-20160207.156/" "/Users/andreas/.emacs.d/elpa/undo-tree-20140509.522/" "/Users/andreas/.emacs.d/elpa/vertica-snippets-20180207.453" "/Users/andreas/.emacs.d/elpa/visual-ascii-mode-20150129.246" "/Users/andreas/.emacs.d/elpa/visual-regexp-20150329.954" "/Users/andreas/.emacs.d/elpa/websocket-20161022.2054" "/Users/andreas/.emacs.d/elpa/with-editor-20180318.1253" "/Users/andreas/.emacs.d/elpa/x-path-walker-20160822.1015/" "/Users/andreas/.emacs.d/elpa/helm-core-20160530.52/" "/Users/andreas/.emacs.d/elpa/async-20170916.2256" "/Users/andreas/.emacs.d/elpa/yaml-mode-20160220.340/" "/Users/andreas/.emacs.d/elpa/yasnippet-20180204.1613" "/Library/Application Support/Emacs/25.3/site-lisp" "/Library/Application Support/Emacs/site-lisp" "/Applications/Emacs.app/Contents/Resources/site-lisp" "/Applications/Emacs.app/Contents/Resources/lisp" "/Applications/Emacs.app/Contents/Resources/lisp/vc" "/Applications/Emacs.app/Contents/Resources/lisp/url" "/Applications/Emacs.app/Contents/Resources/lisp/textmodes" "/Applications/Emacs.app/Contents/Resources/lisp/progmodes" "/Applications/Emacs.app/Contents/Resources/lisp/play" "/Applications/Emacs.app/Contents/Resources/lisp/nxml" "/Applications/Emacs.app/Contents/Resources/lisp/net" "/Applications/Emacs.app/Contents/Resources/lisp/mh-e" "/Applications/Emacs.app/Contents/Resources/lisp/mail" "/Applications/Emacs.app/Contents/Resources/lisp/leim" "/Applications/Emacs.app/Contents/Resources/lisp/language" "/Applications/Emacs.app/Contents/Resources/lisp/international" "/Applications/Emacs.app/Contents/Resources/lisp/gnus" "/Applications/Emacs.app/Contents/Resources/lisp/eshell" "/Applications/Emacs.app/Contents/Resources/lisp/erc" "/Applications/Emacs.app/Contents/Resources/lisp/emulation" "/Applications/Emacs.app/Contents/Resources/lisp/emacs-lisp" "/Applications/Emacs.app/Contents/Resources/lisp/cedet" "/Applications/Emacs.app/Contents/Resources/lisp/calendar" "/Applications/Emacs.app/Contents/Resources/lisp/calc" "/Applications/Emacs.app/Contents/Resources/lisp/obsolete" "/.emacs.d/elpa/org-plus-contrib-20170407" "/.emacs.d/elpa/org-sticky-header-20170422.2135" "/.emacs.d/elpa/ggtags-20151214.1344" "/.emacs.d/elpa/helm-gtags-20160202.503"))
(package-initialize)
(org-babel-do-load-languages 'org-babel-load-languages
'((shell . t)
(python . t)
(R . t)
(ruby . t)
(ditaa . t)
(dot . t)
(octave . t)
(sqlite . t)
(perl . t)))
(let
((default-directory "/Users/andreas/workorg/"))
(org-babel-execute:sql "select * from nodes;"
'((:colname-names)
(:rowname-names)
(:result-params "replace")
(:result-type . value)
(:results . "replace")
(:exports . "code")
(:session . "none")
(:cache . "no")
(:noweb . "no")
(:hlines . "no")
(:tangle . "no")
(:engine . "vertica")
(:dbhost . "testhost.foo.com")
(:dbuser . "dbadmin")
(:dbpassword . "foo")
(:database . "testdb")
(:async)))))
#+end_example

• Bug Description

If your issue still hasn't been resolved, describe it here.

#+BEGIN_QUOTE
error in process sentinel: if: Symbol’s function definition is void: org-babel-execute:sql
error in process sentinel: Symbol’s function definition is void: org-babel-execute:sql
#+END_QUOTE

I had a short look into the code.
Can it be that the sql related parameters are not handed over?
They are getting set in the PROPERTIES section.
Not long ago they got moved into :header-args:sql:
Before that they were directly set.

from ob-async.

@baron42bba It looks like you haven't picked up the fix, based on the path in your troubleshooting output (/Users/andreas/.emacs.d/elpa/ob-async-20180410.2058/ob-async.el). The latest release on MELPA is 20180429.1039, which includes the potential fix.

from ob-async.

from ob-async.

So the child process can't find a function named org-babel-execute:sql - where does it get loaded from normally? (i.e., in the parent process)

Can you include the SRC block corresponding to the last transmitted sexp? I'm guessing the lang is sql? I see sqlite included in your org-babel-load-languages...

(org-babel-do-load-languages 'org-babel-load-languages
'((shell . t)
(python . t)
(R . t)
(ruby . t)
(ditaa . t)
(dot . t)
(octave . t)
(sqlite . t)
(perl . t)))

...but not sql, which I think would explain it.

from ob-async.

@baron42bba Good idea. I've updated the troubleshooting guide in #28

from ob-async.