Unable to start ERPNext fter update from 8.xx to 9.xx

I am still finding out how do I do that? If you can be so nice please elaborate to the uninitiated plz…

I saw the below commands from your link. I am going to try it just now then I will give you feedback thanks @clarkej

shreyaspNov '16
@noetico

bench --site your_site console
In console: frappe.reload_doc(‘core’, ‘doctype’, ‘language’)
frappe.db.commit()
then proceed with bench --site your_site migrate

Like this:

frappe@erpnext:~/frappe-bench$ bench console
Python 2.7.6 (default, Jun 22 2015, 18:00:18)
Type “copyright”, “credits” or “license” for more information.
IPython 5.1.0 – An enhanced Interactive Python.
? -> Introduction and overview of IPython’s features.
%quickref -> Quick reference.
help -> Python’s own help system.
object? -> Details about ‘object’, use ‘object??’ for extra details.

In [1]: frappe.reload_doc(“integrations”, “doctype”, “webhook”)

1

That’s good progress, now check the logs for signs of an error…

For me, it’s:

Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 54, in application
    init_request(request)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 116, in init_request
    frappe.local.http_request = frappe.auth.HTTPRequest()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 53, in __init__
    frappe.local.login_manager = LoginManager()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 111, in __init__
    self.run_trigger('on_session_creation')
  File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 232, in run_trigger
    frappe.call(frappe.get_attr(method), login_manager=self)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 935, in call
    return fn(*args, **newargs)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/communication/feed.py", line 59, in login_feed
    add_authentication_log(subject, login_manager.user)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/authentication_log/authentication_log.py", line 22, in add_authentication_log
    }).insert(ignore_permissions=True)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 211, in insert
    self.run_method("before_insert")
  File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 705, in run_method
    run_webhooks(self, method)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/integrations/doctype/webhook/__init__.py", line 21, in run_webhooks
    fields=["name", "webhook_docevent", "webhook_doctype"])
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 1173, in get_all
    return get_list(doctype, *args, **kwargs)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 1146, in get_list
    return frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 88, in execute
    result = self.build_and_run()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 100, in build_and_run
    args = self.prepare_args()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 117, in prepare_args
    self.set_optional_columns()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 218, in set_optional_columns
    columns = frappe.db.get_table_columns(self.doctype)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 823, in get_table_columns
    return self.get_db_table_columns('tab' + doctype)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 819, in get_db_table_columns
    return [r[0] for r in self.sql("DESC `%s`" % table)]
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 163, in sql
    self._cursor.execute(query)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 250, in execute
    self.errorhandler(self, exc, value)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
    raise errorvalue
ProgrammingError: (1146, "Table 'd56cb677eaab3383.tabWebhook' doesn't exist")

That’s not end. Here is screenshot when I applied below command in bench console as suggested above i.e.
In [1]: frappe.reload_doc(“integrations”, “doctype”, “webhook”)

‎Ok… to know your site name; enter th terminal if you don’t have gui… do

Cd /home and hit enter from wherever you are

Then…
Cd frappe/frappe-bench/sites

Your site should be something like site1.local or maybe some other name like erpnext.vm if you got a vm image.

So the site name you can then use in the command.

Like this

Bench --site site1.local console

Hit enter.

Then continue.

One of the logs file; frappe.txt shows following traceback:

[DEBUG] 2017-11-01 03:39:18,290 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 03:43:19,397 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 03:47:19,475 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 03:51:20,517 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 03:55:21,570 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 03:59:22,629 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:03:23,695 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:07:24,711 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:11:25,720 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:15:26,750 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:19:27,772 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:23:28,777 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:27:29,807 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:31:31,095 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:35:31,179 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:39:32,203 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:43:33,283 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:47:34,352 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:51:35,393 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:55:36,490 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 04:59:37,583 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:03:38,636 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:07:39,641 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:11:40,678 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:15:41,751 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:19:42,784 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:23:43,909 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:27:45,025 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:31:46,470 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:35:47,551 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:39:48,660 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:43:49,781 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:47:50,830 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:51:51,280 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:55:52,393 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 05:59:53,471 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:03:53,554 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:07:54,610 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:11:55,688 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:15:56,872 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:19:57,923 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:24:22,740 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:28:22,856 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:32:24,354 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:36:25,456 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:40:26,513 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:44:27,525 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:48:28,556 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:52:29,603 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 06:56:30,654 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:00:31,665 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:04:32,771 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:08:33,810 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:12:34,900 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:16:35,946 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:20:36,960 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:24:37,974 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:28:39,000 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:32:40,269 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:36:40,319 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:40:41,341 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:44:42,403 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:48:43,464 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:52:44,494 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 07:56:45,560 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 08:00:46,622 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 08:04:48,107 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 08:08:49,129 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 08:12:50,151 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 08:19:32,144 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-01 08:23:33,210 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-03 05:59:20,115 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-03 06:03:20,317 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-03 06:07:20,471 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-03 06:11:21,520 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-03 06:22:15,049 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-03 06:26:16,006 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-03 06:30:17,023 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm
[DEBUG] 2017-11-03 06:34:18,024 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: erpnext.vm
Queued events for site erpnext.vm

No those are not tracebacks, they are identified like this:

Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 174, in runmodule_as_main
“main”, fname, loader, pkg_name)

The bottom of the traceback typically has an Exception or Error message with clue to highlight hopefully the problem…

Also please rather than post pages of logs, to try to digest and focus on their content to get to the root of the problem, thanks…

Hello @clarkej, might you missed my comment: Unable to start ERPNext fter update from 8.xx to 9.xx .

This contains Traceback as well as a screenshot. This comment is just to bump, might you missed my comment.

Oh…thanks sir…I am now learning the basics of tracebacks…thanks for invaluable advise…

I am copying part of the traceback in worker.error log

Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 162, in _run_module_as_main
main”, fname, loader, pkg_name)
File “/usr/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
main()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 716, in call
Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 162, in _run_module_as_main
main”, fname, loader, pkg_name)
File “/usr/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
main()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/scheduler.py”, line 166, in start_worker
start_worker(queue)
Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 162, in _run_module_as_main
main”, fname, loader, pkg_name)
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/scheduler.py”, line 166, in start_worker
start_worker(queue)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 102, in start_worker
Worker(queues, name=get_worker_name(queue)).work()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 457, in work
self.register_death()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 265, in register_death
p.execute()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 2641, in execute
File “/usr/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
main()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
return execute(conn, stack, raise_on_error)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 2495, in _execute_transaction
connection.send_packed_command(all_cmds)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 538, in send_packed_command
self.connect()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 442, in connect
raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error 111 connecting to localhost:11000. Connection refused.
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 102, in start_worker
Worker(queues, name=get_worker_name(queue)).work()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 457, in work
self.register_death()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 265, in register_death
p.execute()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 2641, in execute
return execute(conn, stack, raise_on_error)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 2495, in _execute_transaction
return callback(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/scheduler.py”, line 166, in start_worker
start_worker(queue)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 102, in start_worker
Worker(queues, name=get_worker_name(queue)).work()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 457, in work
self.register_death()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 265, in register_death
p.execute()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 2641, in execute
return execute(conn, stack, raise_on_error)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 2495, in _execute_transaction
connection.send_packed_command(all_cmds)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 538, in send_packed_command
self.connect()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 442, in connect
raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error 111 connecting to localhost:11000. Connection refused.
connection.send_packed_command(all_cmds)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 538, in send_packed_command
self.connect()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 442, in connect
raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error 111 connecting to localhost:11000. Connection refused.
06:27:36 RQ worker u’rq:worker:erpnext.1502.short’ started, version 0.6.0
06:27:36 RQ worker u’rq:worker:erpnext.1488.default’ started, version 0.6.0
06:27:36 Cleaning registries for queue: default
06:27:36 RQ worker u’rq:worker:erpnext.1495.long’ started, version 0.6.0
06:27:36 Cleaning registries for queue: long
06:27:36 Cleaning registries for queue: short
06:27:36
06:27:36 *** Listening on short…
06:27:36
06:27:36 *** Listening on default…
06:27:36
06:27:36 *** Listening on long…
06:53:40 short: frappe.utils.background_jobs.execute_job(async=True, event=u’all’, job_name=u’frappe.email.queue.flush’, kwargs={}, method=u’frappe.email.queue.flush’, site=u’erpnext.vm’, user=u’Administrator’) (92bc1349-8c3f-44ba-ae46-4e356b199ab5)
06:53:41 short: Job OK (92bc1349-8c3f-44ba-ae46-4e356b199ab5)
06:53:41 Result is kept for 500 seconds
06:53:42
06:53:42 *** Listening on short…
06:53:42 short: frappe.utils.background_jobs.execute_job(async=True, event=u’all’, job_name=u’frappe.email.doctype.email_account.email_account.pull’, kwargs={}, method=u’frappe.email.doctype.email_account.email_account.pull’, site=u’erpnext.vm’, user=u’Administrator’) (991b266f-82e5-4451-a6e7-e0bacfc684d3)
06:53:43 short: Job OK (991b266f-82e5-4451-a6e7-e0bacfc684d3)
06:53:43 Result is kept for 500 seconds
06:53:43
06:53:43 *** Listening on short…
06:53:43 short: frappe.utils.background_jobs.execute_job(async=True, event=u’all’, job_name=u’frappe.email.doctype.email_account.email_account.notify_unreplied’, kwargs={}, method=u’frappe.email.doctype.email_account.email_account.notify_unreplied’, site=u’erpnext.vm’, user=u’Administrator’) (eb030e89-cc80-4c34-b9db-cab4041c0f3b)
06:53:44 short: Job OK (eb030e89-cc80-4c34-b9db-cab4041c0f3b)
06:53:44 Result is kept for 500 seconds
06:53:44
06:53:44 *** Listening on short…
06:55:41 short: frappe.utils.background_jobs.execute_job(async=True, event=u’all’, job_name=u’frappe.email.queue.flush’, kwargs={}, method=u’frappe.email.queue.flush’, site=u’erpnext.vm’, user=u’Administrator’) (37adfec7-3d6e-44af-9c3b-b262048ce2b6)
06:55:42 short: Job OK (37adfec7-3d6e-44af-9c3b-b262048ce2b6)

Wonderful, your update completed successfully.

This seems to be a server startup issue:

raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error 111 connecting to localhost:11000. Connection refused.

You may just need to restart you supervisor?

A forum search will point to how to do this.

best wishes

I urge you to search the forum for answers @aaimaa , thanks!

Right now I am searching the forum…thanks dear sir

I got this command from forum. I hope it’s the one you mean

sudo supervisorctl start all

and after “enter” nothing happened just went back to frappe-bench$

AND AFTER I UPDATED SITE AGAIN AND THEN WHEN I TRY TO MIGRATE FOLLOWING ERROR IS SHOWN ON THE TERMINAL DURING MIGRATE:

Well, you should see this

frappe@erpnext:~/frappe-bench$ sudo supervisorctl stop all
frappe-bench-frappe-schedule: stopped
frappe-bench-frappe-default-worker-0: stopped
frappe-bench-frappe-long-worker-0: stopped
frappe-bench-frappe-short-worker-0: stopped
frappe-bench-frappe-web: stopped
frappe-bench-node-socketio: stopped
frappe-bench-redis-queue: stopped
frappe-bench-redis-cache: stopped
frappe-bench-redis-socketio: stopped
frappe@erpnext:~/frappe-bench$ sudo supervisorctl start all
frappe-bench-frappe-schedule: started
frappe-bench-frappe-default-worker-0: started
frappe-bench-frappe-long-worker-0: started
frappe-bench-frappe-short-worker-0: started
frappe-bench-frappe-web: started
frappe-bench-node-socketio: started
frappe-bench-redis-queue: started
frappe-bench-redis-cache: started
frappe-bench-redis-socketio: started
frappe@erpnext:~/frappe-bench$

Please I suggest you start another thread

This may help
[solution] 'supervisorctl start all' has no response or affect

OK. I did stop all first that start all and then it shows the all started just like your post above but when I type localhost:8080 in my browser it still shows “updating, please refresh after sometime”

I also did
In [1]: frappe.reload_doc(“core”, “doctype”, “has_domain”)
The result is: False

1 Like

Hi
I have same error ( tabFees table is missing grand_total field) and run bench migrate can’t solved.
So I try to update tabFees table by manual script. I don’t know this way is good or not,
But After run script is ok. Before run script update your database first.

ALTER TABLE `tabFees` ADD COLUMN `fee_schedule`  varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `total_amount`;

ALTER TABLE `tabFees` ADD COLUMN `receivable_account`  varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `fee_schedule`;

ALTER TABLE `tabFees` ADD COLUMN `letter_head`  varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `receivable_account`;

ALTER TABLE `tabFees` ADD COLUMN `cost_center`  varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `letter_head`;

ALTER TABLE `tabFees` ADD COLUMN `income_account`  varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `cost_center`;

ALTER TABLE `tabFees` ADD COLUMN `posting_time`  time(6) NULL DEFAULT NULL AFTER `income_account`;

ALTER TABLE `tabFees` ADD COLUMN `send_payment_request`  int(1) NOT NULL DEFAULT 0 AFTER `posting_time`;

ALTER TABLE `tabFees` ADD COLUMN `set_posting_time`  int(1) NOT NULL DEFAULT 0 AFTER `send_payment_request`;

ALTER TABLE `tabFees` ADD COLUMN `company`  varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `set_posting_time`;

ALTER TABLE `tabFees` ADD COLUMN `grand_total_in_words`  varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `company`;

ALTER TABLE `tabFees` ADD COLUMN `grand_total`  decimal(18,6) NOT NULL DEFAULT 0.000000 AFTER `grand_total_in_words`;

ALTER TABLE `tabFees` ADD COLUMN `posting_date`  date NULL DEFAULT NULL AFTER `grand_total`;

ALTER TABLE `tabFees` ADD COLUMN `include_payment`  int(1) NOT NULL DEFAULT 0 AFTER `posting_date`;

ALTER TABLE `tabFees` ADD COLUMN `currency`  varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `include_payment`;

ALTER TABLE `tabFees` ADD COLUMN `student_batch`  varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `currency`;

ALTER TABLE `tabFees` ADD COLUMN `select_print_heading`  varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `student_batch`;

ALTER TABLE `tabFees` ADD COLUMN `student_email`  varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `select_print_heading`;