ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Error Log: 'job_name': u'frappe.utils.global_search.sync_global_search'

erpnext
v10

#1

Hello everyone,
After I ran bench update I am encounter with this log in Error Log. Do you have any suggestion on this?

{‘retry’: 0, ‘log’: <function log at 0x7fe6d8ac5e60>, ‘site’: u’site1.local’, ‘event’: u’all’, ‘method_name’: u’frappe.utils.global_search.sync_global_search’, ‘method’: <function sync_global_search at 0x7fe6d96dd6e0>, ‘user’: u’Administrator’, ‘kwargs’: {}, ‘async’: True, ‘job_name’: u’frappe.utils.global_search.sync_global_search’}
Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 97, in execute_job
method(**kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/global_search.py”, line 318, in sync_global_search
frappe.db.sql(’’’
TypeError: ‘NoneType’ object is not iterable


#2

What you might try is to rerun ‘bench update’, ‘bench migrate’ and also try ‘bench rebuild-global-search’


#3

The output as follows

frappe@erp:~/frappe-bench$ bench update
INFO:bench.utils:updating bench
INFO:bench.utils:git pull
Already up to date.
INFO:bench.utils:./env/bin/pip install Pillow
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won’t be maintained after that date. A future version of pip will drop support for Python 2.7.
Requirement already satisfied: Pillow in ./env/lib/python2.7/site-packages (5.3.0)
INFO:bench.app:pulling frappe
INFO:bench.utils:git pull upstream v10.x.x
From https://github.com/frappe/frappe

  • branch v10.x.x -> FETCH_HEAD
    Already up to date.
    INFO:bench.utils:find . -name “*.pyc” -delete
    INFO:bench.app:pulling erpnext
    INFO:bench.utils:git pull upstream v10.x.x
    From https://github.com/frappe/erpnext
  • branch v10.x.x -> FETCH_HEAD
    Already up to date.
    INFO:bench.utils:find . -name “*.pyc” -delete
    Updating Python libraries…
    INFO:bench.utils:./env/bin/pip install --upgrade pip
    DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won’t be maintained after that date. A future version of pip will drop support for Python 2.7.
    Requirement already up-to-date: pip in ./env/lib/python2.7/site-packages (19.0.3)
    INFO:bench.utils:./env/bin/pip install -q -r /home/frappe/.bench/requirements.txt
    DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won’t be maintained after that date. A future version of pip will drop support for Python 2.7.
    INFO:bench.app:installing frappe
    INFO:bench.utils:./env/bin/pip install -q -e ./apps/frappe
    DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won’t be maintained after that date. A future version of pip will drop support for Python 2.7.
    INFO:bench.app:installing erpnext
    INFO:bench.utils:./env/bin/pip install -q -e ./apps/erpnext
    DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won’t be maintained after that date. A future version of pip will drop support for Python 2.7.
    Updating node packages…
    INFO:bench.utils:npm install
    npm WARN optional Skipping failed optional dependency /chokidar/fsevents:
    npm WARN notsup Not compatible with your operating system or architecture: fsevents@1.2.7
    npm WARN frappe@ No description
    Backing up sites…
    Patching sites…
    Migrating site1.local
    Updating DocTypes for frappe : [========================================]
    Updating DocTypes for erpnext : [========================================]
    Migrating site2.local
    Updating DocTypes for frappe : [========================================]
    Updating DocTypes for erpnext : [========================================]
    Wrote css/frappe-web.css - 65.11 KB
    Wrote js/frappe-web.min.js - 132.77 KB
    Wrote js/control.min.js - 77.1 KB
    Wrote js/dialog.min.js - 117.07 KB
    Wrote css/desk.min.css - 309.05 KB
    Wrote css/frappe-rtl.css - 32.49 KB
    Wrote js/libs.min.js - 1.13 MB
    Wrote js/desk.min.js - 460.07 KB
    Wrote css/module.min.css - 2.08 KB
    Wrote css/form.min.css - 4.47 KB
    Wrote js/form.min.js - 196.97 KB
    Wrote css/list.min.css - 13.36 KB
    Wrote js/list.min.js - 154.9 KB
    Wrote css/report.min.css - 7.89 KB
    Wrote js/report.min.js - 260.58 KB
    Wrote js/web_form.min.js - 247.55 KB
    Wrote css/web_form.css - 24.42 KB
    Wrote js/print_format_v3.min.js - 23.39 KB
    Wrote css/erpnext.css - 8.1 KB
    Wrote js/erpnext-web.min.js - 3.8 KB
    Wrote js/erpnext.min.js - 162.18 KB
    Wrote js/item-dashboard.min.js - 8.13 KB

Bench: Deployment tool for Frappe and ERPNext (https://erpnext.org).
Open source depends on your contributions, so please contribute bug reports, patches, fixes or cash and be a part of the community
()
frappe@erp:~/frappe-bench$ bench --site site1.local migrate
Migrating site1.local
Updating DocTypes for frappe : [========================================]
Updating DocTypes for erpnext : [========================================]
frappe@erp:~/frappe-bench$ bench --site site2.local migrate
Migrating site2.local
Updating DocTypes for frappe : [========================================]
Updating DocTypes for erpnext : [========================================]
frappe@erp:~/frappe-bench$ bench --site site1.local rebuild-global-search
Rebuilding Global Search : [========================================]
frappe@erp:~/frappe-bench$ bench --site site2.local rebuild-global-search
Rebuilding Global Search : [========================================]
frappe@erp:~/frappe-bench$

All seems fine by the output above, but after a few minutes, the same error appears again.

Installed Apps
ERPNext: v10.1.81 (898977b) (v10.x.x)
Frappe Framework: v10.1.71-8 (92dc1e0) (v10.x.x)


#4

The History shows lots of changes in the last few months https://github.com/frappe/frappe/blob/develop/frappe/utils/global_search.py

Whether say fixes there have also been applied to v10 is one question?

Best report this on https://github.com/frappe/frappe/issues

You might load your data into a v11 instance to check for this problem.

Another option is to set a breakpoint to debug what Python code has a null value that causes the sql expresssion to error.