Does not work with ob-sql-mode?

[indigoviolet]

Checklist

• [ x] I followed the troubleshooting guide and it did not address my issue
• [ x] I've included a link to a Github Gist with the full contents of my troubleshooting.org buffer
• [ ] Each section below is filled in and includes sufficient detail to reproduce the issue

Expected Behavior

sql-mode org-babel block executes with :async

Actual Behavior

Fails with ERROR: error in process sentinel: Symbol’s function definition is void: org-babel-execute:sql-mode

Steps to Reproduce

• I'm using https://github.com/nikclayton/ob-sql-mode/

• Use sql-postgres or sql-connect to start a psql inferior buffer (probably works with other connections too)

• Name the buffer *SQL: postgres:test* to match <product>:<session> in the header

• Execute with C-c C-c. The Result block gets generated, but isn't resolved, and I get an error.

Troubleshooting Artifacts

https://gist.github.com/indigoviolet/dc433a83fa851f3413f291bf850f50ab

[astahlman]

Looks like you're using :session, which isn't supported, unfortunately (see https://github.com/astahlman/ob-async/issues/1). Can you check whether it works without :session?

[astahlman]

Closing due to inactivity.

[baron42bba]

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

[astahlman]

@baron42bba I've just pushed (what I hope is) a fix in https://github.com/astahlman/ob-async/pull/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?

[baron42bba]

+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.

[astahlman]

@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.

[baron42bba]

I just replaced the content of the file with your patch.

On 30. Apr 2018, at 5:49 PM, Andrew Stahlman notifications@github.com wrote:

@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.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.

[astahlman]

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.

[baron42bba]

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.

[astahlman]

@baron42bba Good idea. I've updated the troubleshooting guide in https://github.com/astahlman/ob-async/pull/28