Scheduler Log show error message

[bzero]

Hello Team,

My scheduler Log shows a lot of alerts, most of them are as below:
Could you please advise how to fix it? Thanks a lot.

Method: all, Handler: frappe.model.utils.link_count.update_link_count
Traceback (innermost last):
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/tasks.py”, line 115, in scheduler_task
frappe.get_attr(handler)()
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/model/utils/link_count.py”, line 32, in update_link_count
key[1])
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/database.py”, line 136, in sql
self._cursor.execute(query, values)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (1146, “Table ‘b41fb7345e.tabWebsite Settings’ doesn’t exist”)

[yashodhan]

run as follows and see.

bench migrate
bench update --pull
bench update --patch
bench update

[bzero]

@yashodhan
Thanks for your advise.

But i am getting following error when executing this command: bench update --patch
Please show me how to fix it.

Thanks a lot.

mksimple@lab9:~/frappe-bench$ bench update --patch
Migrating trade.marketsimple.com
Executing erpnext.patches.v7_0.update_party_status in trade.marketsimple.com (b41fb7345e)
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 “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
main()
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/var/service/www/nginx/marketsimple.com/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 “/var/service/www/nginx/marketsimple.com/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 “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/commands.py”, line 29, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/commands.py”, line 218, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/migrate.py”, line 27, in migrate
frappe.modules.patch_handler.run_all()
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 25, in run_all
if not run_single(patchmodule = patch):
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 52, in run_single
return execute_patch(patchmodule, method, methodargs)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 68, in execute_patch
frappe.get_attr(patchmodule.split()[0] + “.execute”)()
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/erpnext/erpnext/patches/v7_0/update_party_status.py”, line 7, in execute
doc.update_status()
AttributeError: ‘Customer’ object has no attribute ‘update_status’
Traceback (most recent call last):
File “/usr/local/bin/bench”, line 9, in
load_entry_point(‘bench’, ‘console_scripts’, ‘bench’)()
File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/cli.py”, line 40, in cli
bench_command()
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/commands/update.py”, line 60, in update
_update(pull, patch, build, bench, auto, restart_supervisor, requirements, no_backup, upgrade, force=force)
File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/commands/update.py”, line 90, in _update
patch_sites(bench=bench_path)
File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/utils.py”, line 131, in patch_sites
run_frappe_cmd(‘–site’, ‘all’, ‘migrate’, bench=bench)
File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/utils.py”, line 454, in run_frappe_cmd
raise CommandFailedError(args)
bench.utils.CommandFailedError: (‘–site’, ‘all’, ‘migrate’)

[yashodhan]

From the frappe-bench folder try:

$ ./env/bin/pip install --upgrade -r apps/frappe/requirements.txt
$ bench switch-to-master
$ bench migrate
$ bench retry-upgrade

Something strange found in your log, it seems you are running develop branch which is pulling patch from upcoming version 7 of ERPNext. you should stick to ERPNExt version 6 available on master branch which is tested and stable.

Executing erpnext.patches.v7_0.update_party_status in trade.marketsimple.com (b41fb7345e)

[bzero]

Thanks @yashodhan

I am still getting error, please see below:

mksimple@lab9:~/frappe-bench$ ./env/bin/pip install -r apps/frappe/requirements.txt
Requirement already satisfied (use --upgrade to upgrade): chardet in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 1))
Requirement already satisfied (use --upgrade to upgrade): cssmin in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 2))
Requirement already satisfied (use --upgrade to upgrade): dropbox in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 3))
Requirement already satisfied (use --upgrade to upgrade): gunicorn in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 4))
Requirement already satisfied (use --upgrade to upgrade): httplib2 in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 5))
Requirement already satisfied (use --upgrade to upgrade): jinja2 in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 6))
Requirement already satisfied (use --upgrade to upgrade): markdown2 in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 7))
Requirement already satisfied (use --upgrade to upgrade): markupsafe in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 8))
Requirement already satisfied (use --upgrade to upgrade): mysql-python==1.2.5 in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 9))
Requirement already satisfied (use --upgrade to upgrade): python-geoip in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 10))
Requirement already satisfied (use --upgrade to upgrade): python-geoip-geolite2 in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 11))
Requirement already satisfied (use --upgrade to upgrade): python-dateutil in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 12))
Requirement already satisfied (use --upgrade to upgrade): pytz in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 13))
Requirement already satisfied (use --upgrade to upgrade): six in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 14))
Requirement already satisfied (use --upgrade to upgrade): termcolor in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 15))
Requirement already satisfied (use --upgrade to upgrade): werkzeug in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 16))
Requirement already satisfied (use --upgrade to upgrade): semantic-version in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 17))
Requirement already satisfied (use --upgrade to upgrade): rauth>=0.6.2 in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 18))
Requirement already satisfied (use --upgrade to upgrade): requests in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 19))
Requirement already satisfied (use --upgrade to upgrade): celery in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 20))
Requirement already satisfied (use --upgrade to upgrade): redis in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 21))
Requirement already satisfied (use --upgrade to upgrade): selenium in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 22))
Obtaining pdfkit from git+https://github.com/frappe/python-pdfkit.git#egg=pdfkit (from -r apps/frappe/requirements.txt (line 23))
Updating ./env/src/pdfkit clone
Requirement already satisfied (use --upgrade to upgrade): babel in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 24))
Requirement already satisfied (use --upgrade to upgrade): ipython in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 25))
Requirement already satisfied (use --upgrade to upgrade): html2text in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 26))
Requirement already satisfied (use --upgrade to upgrade): email-reply-parser in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 27))
Requirement already satisfied (use --upgrade to upgrade): click in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 28))
Requirement already satisfied (use --upgrade to upgrade): num2words in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 29))
Requirement already satisfied (use --upgrade to upgrade): watchdog==0.8.0 in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 30))
Requirement already satisfied (use --upgrade to upgrade): bleach in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 31))
Requirement already satisfied (use --upgrade to upgrade): bleach-whitelist in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 32))
Requirement already satisfied (use --upgrade to upgrade): Pillow in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 33))
Requirement already satisfied (use --upgrade to upgrade): beautifulsoup4 in ./env/lib/python2.7/site-packages (from -r apps/frappe/requirements.txt (line 34))
Requirement already satisfied (use --upgrade to upgrade): urllib3 in ./env/lib/python2.7/site-packages (from dropbox->-r apps/frappe/requirements.txt (line 3))
Requirement already satisfied (use --upgrade to upgrade): kombu<3.1,>=3.0.34 in ./env/lib/python2.7/site-packages (from celery->-r apps/frappe/requirements.txt (line 20))
Requirement already satisfied (use --upgrade to upgrade): billiard<3.4,>=3.3.0.23 in ./env/lib/python2.7/site-packages (from celery->-r apps/frappe/requirements.txt (line 20))
Requirement already satisfied (use --upgrade to upgrade): traitlets in ./env/lib/python2.7/site-packages (from ipython->-r apps/frappe/requirements.txt (line 25))
Requirement already satisfied (use --upgrade to upgrade): pickleshare in ./env/lib/python2.7/site-packages (from ipython->-r apps/frappe/requirements.txt (line 25))
Requirement already satisfied (use --upgrade to upgrade): simplegeneric>0.8 in ./env/lib/python2.7/site-packages (from ipython->-r apps/frappe/requirements.txt (line 25))
Requirement already satisfied (use --upgrade to upgrade): setuptools>=18.5 in ./env/lib/python2.7/site-packages (from ipython->-r apps/frappe/requirements.txt (line 25))
Requirement already satisfied (use --upgrade to upgrade): decorator in ./env/lib/python2.7/site-packages (from ipython->-r apps/frappe/requirements.txt (line 25))
Requirement already satisfied (use --upgrade to upgrade): pexpect in ./env/lib/python2.7/site-packages (from ipython->-r apps/frappe/requirements.txt (line 25))
Requirement already satisfied (use --upgrade to upgrade): argh>=0.24.1 in ./env/lib/python2.7/site-packages (from watchdog==0.8.0->-r apps/frappe/requirements.txt (line 30))
Requirement already satisfied (use --upgrade to upgrade): PyYAML>=3.10 in ./env/lib/python2.7/site-packages (from watchdog==0.8.0->-r apps/frappe/requirements.txt (line 30))
Requirement already satisfied (use --upgrade to upgrade): pathtools>=0.1.1 in ./env/lib/python2.7/site-packages (from watchdog==0.8.0->-r apps/frappe/requirements.txt (line 30))
Requirement already satisfied (use --upgrade to upgrade): html5lib>=0.999 in ./env/lib/python2.7/site-packages (from bleach->-r apps/frappe/requirements.txt (line 31))
Requirement already satisfied (use --upgrade to upgrade): anyjson>=0.3.3 in ./env/lib/python2.7/site-packages (from kombu<3.1,>=3.0.34->celery->-r apps/frappe/requirements.txt (line 20))
Requirement already satisfied (use --upgrade to upgrade): amqp<2.0,>=1.4.9 in ./env/lib/python2.7/site-packages (from kombu<3.1,>=3.0.34->celery->-r apps/frappe/requirements.txt (line 20))
Requirement already satisfied (use --upgrade to upgrade): ipython-genutils in ./env/lib/python2.7/site-packages (from traitlets->ipython->-r apps/frappe/requirements.txt (line 25))
Requirement already satisfied (use --upgrade to upgrade): path.py>=6.2 in ./env/lib/python2.7/site-packages (from pickleshare->ipython->-r apps/frappe/requirements.txt (line 25))
Requirement already satisfied (use --upgrade to upgrade): ptyprocess>=0.5 in ./env/lib/python2.7/site-packages (from pexpect->ipython->-r apps/frappe/requirements.txt (line 25))
Installing collected packages: pdfkit
Running setup.py develop for pdfkit
Successfully installed pdfkit-0.5.0
mksimple@lab9:~/frappe-bench$
mksimple@lab9:~/frappe-bench$
mksimple@lab9:~/frappe-bench$
mksimple@lab9:~/frappe-bench$ bench retry-upgrade
INFO:bench.app:pulling frappe
From GitHub - frappe/frappe: Low code web framework for real world applications, in Python and Javascript

• branch develop → FETCH_HEAD
  Already up-to-date.
  INFO:bench.app:pulling erpnext
  From GitHub - frappe/erpnext: Free and Open Source Enterprise Resource Planning (ERP)
• branch develop → FETCH_HEAD
  Already up-to-date.
  Migrating trade.marketsimple.com
  Executing erpnext.patches.v7_0.update_party_status in trade.marketsimple.com (b41fb7345e)
  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 “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
  main()
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
  click.Group(commands=commands)(prog_name=‘bench’)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 716, in call
  return self.main(*args, **kwargs)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 696, in main
  rv = self.invoke(ctx)
  File “/var/service/www/nginx/marketsimple.com/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 “/var/service/www/nginx/marketsimple.com/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 “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 889, in invoke
  return ctx.invoke(self.callback, **ctx.params)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
  return callback(*args, **kwargs)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
  return f(get_current_context(), *args, **kwargs)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/commands.py”, line 29, in _func
  ret = f(frappe._dict(ctx.obj), *args, **kwargs)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/commands.py”, line 218, in migrate
  migrate(context.verbose, rebuild_website=rebuild_website)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/migrate.py”, line 27, in migrate
  frappe.modules.patch_handler.run_all()
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 25, in run_all
  if not run_single(patchmodule = patch):
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 52, in run_single
  return execute_patch(patchmodule, method, methodargs)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 68, in execute_patch
  frappe.get_attr(patchmodule.split()[0] + “.execute”)()
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/erpnext/erpnext/patches/v7_0/update_party_status.py”, line 7, in execute
  doc.update_status()
  AttributeError: ‘Customer’ object has no attribute ‘update_status’
  Traceback (most recent call last):
  File “/usr/local/bin/bench”, line 9, in
  load_entry_point(‘bench’, ‘console_scripts’, ‘bench’)()
  File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/cli.py”, line 40, in cli
  bench_command()
  File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 716, in call
  return self.main(*args, **kwargs)
  File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 696, in main
  rv = self.invoke(ctx)
  File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 1060, in invoke
  return _process_result(sub_ctx.command.invoke(sub_ctx))
  File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 889, in invoke
  return ctx.invoke(self.callback, **ctx.params)
  File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 534, in invoke
  return callback(*args, **kwargs)
  File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/commands/update.py”, line 107, in retry_upgrade
  patch_sites()
  File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/utils.py”, line 131, in patch_sites
  run_frappe_cmd(‘–site’, ‘all’, ‘migrate’, bench=bench)
  File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/utils.py”, line 454, in run_frappe_cmd
  raise CommandFailedError(args)
  bench.utils.CommandFailedError: (‘–site’, ‘all’, ‘migrate’)
  mksimple@lab9:~/frappe-bench$

[bzero]

my apologies about quick reply, i followed your instruction, and getting following error,

• [new tag] v6.7.8 → v6.7.8
• [new tag] v6.8.0 → v6.8.0
• [new tag] v6.8.1 → v6.8.1
• [new tag] v6.8.2 → v6.8.2
• [new tag] v6.8.3 → v6.8.3
• [new tag] v6.8.4 → v6.8.4
• [new tag] v6.9.0 → v6.9.0
• [new tag] v6.9.1 → v6.9.1
• [new tag] v6.9.2 → v6.9.2
  remote: Counting objects: 1, done.
  remote: Total 1 (delta 0), reused 0 (delta 0), pack-reused 1
  Unpacking objects: 100% (1/1), done.
• [new tag] v6.27.6 → v6.27.6
  Branch master set up to track remote branch master from upstream.
  Switched to a new branch ‘master’
  Already up-to-date.

Switched to master
Please run bench update --patch to be safe from any differences in database schema
mksimple@lab9:~/frappe-bench$ bench update --patch
Migrating trade.marketsimple.com
Executing erpnext.patches.v6_20x.update_product_bundle_description in trade.marketsimple.com (b41fb7345e)
Success
Updating frappe : [= ]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 “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
main()
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/var/service/www/nginx/marketsimple.com/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 “/var/service/www/nginx/marketsimple.com/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 “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/commands.py”, line 29, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/commands.py”, line 205, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/migrate.py”, line 29, in migrate
frappe.model.sync.sync_all(verbose=verbose)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/model/sync.py”, line 19, in sync_all
sync_for(app, force, verbose=verbose)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/model/sync.py”, line 43, in sync_for
import_file_by_path(doc_path, force=force)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 54, in import_file_by_path
import_doc(doc, force=force, data_import=data_import, pre_process=pre_process)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 122, in import_doc
doc.insert()
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/model/document.py”, line 203, in insert
self.db_insert()
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/model/base_document.py”, line 282, in db_insert
), d.values())
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/database.py”, line 136, in sql
self._cursor.execute(query, values)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1048, “Column ‘track_seen’ cannot be null”)
Traceback (most recent call last):
File “/usr/local/bin/bench”, line 9, in
load_entry_point(‘bench’, ‘console_scripts’, ‘bench’)()
File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/cli.py”, line 40, in cli
bench_command()
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/commands/update.py”, line 60, in update
_update(pull, patch, build, bench, auto, restart_supervisor, requirements, no_backup, upgrade, force=force)
File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/commands/update.py”, line 90, in _update
patch_sites(bench=bench_path)
File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/utils.py”, line 131, in patch_sites
run_frappe_cmd(‘–site’, ‘all’, ‘migrate’, bench=bench)
File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/utils.py”, line 454, in run_frappe_cmd
raise CommandFailedError(args)
bench.utils.CommandFailedError: (‘–site’, ‘all’, ‘migrate’)
mksimple@lab9:~/frappe-bench$ bench update --patch
Migrating trade.marketsimple.com
Updating frappe : [= ]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 “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
main()
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/var/service/www/nginx/marketsimple.com/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 “/var/service/www/nginx/marketsimple.com/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 “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/commands.py”, line 29, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/commands.py”, line 205, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/migrate.py”, line 29, in migrate
frappe.model.sync.sync_all(verbose=verbose)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/model/sync.py”, line 19, in sync_all
sync_for(app, force, verbose=verbose)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/model/sync.py”, line 43, in sync_for
import_file_by_path(doc_path, force=force)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 54, in import_file_by_path
import_doc(doc, force=force, data_import=data_import, pre_process=pre_process)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 122, in import_doc
doc.insert()
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/model/document.py”, line 203, in insert
self.db_insert()
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/model/base_document.py”, line 282, in db_insert
), d.values())
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/database.py”, line 136, in sql
self._cursor.execute(query, values)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1048, “Column ‘track_seen’ cannot be null”)
Traceback (most recent call last):
File “/usr/local/bin/bench”, line 9, in
load_entry_point(‘bench’, ‘console_scripts’, ‘bench’)()
File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/cli.py”, line 40, in cli
bench_command()
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/commands/update.py”, line 60, in update
_update(pull, patch, build, bench, auto, restart_supervisor, requirements, no_backup, upgrade, force=force)
File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/commands/update.py”, line 90, in _update
patch_sites(bench=bench_path)
File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/utils.py”, line 131, in patch_sites
run_frappe_cmd(‘–site’, ‘all’, ‘migrate’, bench=bench)
File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/utils.py”, line 454, in run_frappe_cmd
raise CommandFailedError(args)
bench.utils.CommandFailedError: (‘–site’, ‘all’, ‘migrate’)
mksimple@lab9:~/frappe-bench$ bench retry-upgrade
INFO:bench.app:pulling frappe
From GitHub - frappe/frappe: Low code web framework for real world applications, in Python and Javascript

• branch master → FETCH_HEAD
  Already up-to-date.
  INFO:bench.app:pulling erpnext
  From GitHub - frappe/erpnext: Free and Open Source Enterprise Resource Planning (ERP)
• branch master → FETCH_HEAD
  Already up-to-date.
  Migrating trade.marketsimple.com
  Updating frappe : [= ]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 “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
  main()
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
  click.Group(commands=commands)(prog_name=‘bench’)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 716, in call
  return self.main(*args, **kwargs)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 696, in main
  rv = self.invoke(ctx)
  File “/var/service/www/nginx/marketsimple.com/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 “/var/service/www/nginx/marketsimple.com/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 “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 889, in invoke
  return ctx.invoke(self.callback, **ctx.params)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
  return callback(*args, **kwargs)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
  return f(get_current_context(), *args, **kwargs)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/commands.py”, line 29, in _func
  ret = f(frappe._dict(ctx.obj), *args, **kwargs)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/commands.py”, line 205, in migrate
  migrate(context.verbose, rebuild_website=rebuild_website)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/migrate.py”, line 29, in migrate
  frappe.model.sync.sync_all(verbose=verbose)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/model/sync.py”, line 19, in sync_all
  sync_for(app, force, verbose=verbose)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/model/sync.py”, line 43, in sync_for
  import_file_by_path(doc_path, force=force)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 54, in import_file_by_path
  import_doc(doc, force=force, data_import=data_import, pre_process=pre_process)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 122, in import_doc
  doc.insert()
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/model/document.py”, line 203, in insert
  self.db_insert()
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/model/base_document.py”, line 282, in db_insert
  ), d.values())
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/database.py”, line 136, in sql
  self._cursor.execute(query, values)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
  self.errorhandler(self, exc, value)
  File “/var/service/www/nginx/marketsimple.com/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
  raise errorclass, errorvalue
  _mysql_exceptions.OperationalError: (1048, “Column ‘track_seen’ cannot be null”)
  Traceback (most recent call last):
  File “/usr/local/bin/bench”, line 9, in
  load_entry_point(‘bench’, ‘console_scripts’, ‘bench’)()
  File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/cli.py”, line 40, in cli
  bench_command()
  File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 716, in call
  return self.main(*args, **kwargs)
  File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 696, in main
  rv = self.invoke(ctx)
  File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 1060, in invoke
  return _process_result(sub_ctx.command.invoke(sub_ctx))
  File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 889, in invoke
  return ctx.invoke(self.callback, **ctx.params)
  File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 534, in invoke
  return callback(*args, **kwargs)
  File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/commands/update.py”, line 107, in retry_upgrade
  patch_sites()
  File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/utils.py”, line 131, in patch_sites
  run_frappe_cmd(‘–site’, ‘all’, ‘migrate’, bench=bench)
  File “/var/service/www/nginx/marketsimple.com/bench-repo/bench/utils.py”, line 454, in run_frappe_cmd
  raise CommandFailedError(args)
  bench.utils.CommandFailedError: (‘–site’, ‘all’, ‘migrate’)
  mksimple@lab9:~/frappe-bench$

[bzero]

any advise to fix the issue, my site is now still with "Updating. We will be back in a few moments… "
couldn’t know how to pass the issue.

Thanks a lot.

[yashodhan]

Try following again:

@yashodhan

$ cd /var/service/www/nginx/marketsimple.com/frappe-bench
$ ./env/bin/pip install --upgrade -r apps/frappe/requirements.txt
$ bench migrate
$ bench retry-upgrade
$ bench update

[bzero]

Thanks @yashodhan
But i have reset the site by starting from beginning, following the instruction here, cause i’d like to use Production, stable version.

GitHub - frappe/bench: CLI to manage Multi-tenant deployments for Frappe apps

[bzero]

me again,

with new fresh installation, i still getting Scheduler Log alert, it’s attaching below,
Although i have setup the default Outgoing mail, as log request, but the Scheduler is still marked with “Not Seen” status.

Method: daily, Handler: erpnext.setup.doctype.email_digest.email_digest.send
Traceback (innermost last):
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/tasks.py”, line 115, in scheduler_task
frappe.get_attr(handler)()
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/erpnext/erpnext/setup/doctype/email_digest/email_digest.py”, line 346, in send
ed_obj.send()
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/erpnext/erpnext/setup/doctype/email_digest/email_digest.py”, line 66, in send
unsubscribe_message = _(“Unsubscribe from this Email Digest”))
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/init.py”, line 351, in sendmail
send_after=send_after, expose_recipients=expose_recipients, bulk_priority=bulk_priority)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/email/bulk.py”, line 50, in send
email_account = get_outgoing_email_account(True, append_to=reference_doctype)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/email/smtp.py”, line 56, in get_outgoing_email_account
frappe.OutgoingEmailError)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/init.py”, line 264, in throw
msgprint(msg, raise_exception=exc)
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/init.py”, line 257, in msgprint
_raise_exception()
File “/var/service/www/nginx/marketsimple.com/frappe-bench/apps/frappe/frappe/init.py”, line 242, in _raise_exception
raise raise_exception, encode(msg)
OutgoingEmailError: Please setup default Email Account from Setup > Email > Email Account

[Francois_Ifitwala]

Hi all,
I have similar issue here. Scheduler creating an error message every 2 minutes since 2-3 days.
here is the error message:

I’m on a ubuntu server using the develop branch of frappe and erpnext.

Any help would be appreciated.

Method: frappe.model.utils.link_count.update_link_count

Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 56, in execute_job
method(**kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/utils/link_count.py”, line 32, in update_link_count
key[1])
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 136, in sql
self._cursor.execute(query, values)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (1146, “Table ‘50750f34cc.tabWebsite Settings’ doesn’t exist”)