Stuck " internal server eror"

1

previously i forced server to shut down , then after boot i got this error

Redis cache server not running. Please contact Administrator / Techsupport error

i try update the server bench update migrate from 8.0 to 10
then i got this error

frappe-bench$ sudo bench update

INFO:bench.utils:updating bench
INFO:bench.utils:git pull
Already up-to-date.
INFO:bench.utils:./env/bin/pip install Pillow
Requirement already satisfied: Pillow in ./env/lib/python2.7/site-packages
Requirement already satisfied: olefile in ./env/lib/python2.7/site-packages (from Pillow)
INFO:bench.app:pulling frappe
INFO:bench.utils:git pull  upstream master
From https://github.com/frappe/frappe
 * branch            master     -> FETCH_HEAD
Already up-to-date.
INFO:bench.utils:find . -name "*.pyc" -delete
INFO:bench.app:pulling erpnext
INFO:bench.utils:git pull  upstream master
From https://github.com/frappe/erpnext
 * branch            master     -> 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
Requirement already up-to-date: pip in ./env/lib/python2.7/site-packages
INFO:bench.utils:./env/bin/pip install -q -r /home/frappe/.bench/requirements.txt
INFO:bench.utils:./env/bin/pip install -q -r ./apps/frappe/requirements.txt
INFO:bench.utils:./env/bin/pip install -q -r ./apps/erpnext/requirements.txt
Updating node libraries...
INFO:bench.utils:npm install
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: fsevents@^1.0.0 (node_modules/chokidar/node_modules/fsevents):
npm WARN notsup SKIPPING OPTIONAL DEPENDENCY: Unsupported platform for fsevents@1.1.3: wanted {"os":"darwin","arch":"any"} (current: {"os":"linux","arch":"x64"})
npm WARN frappe@ No description
Backing up sites...
Traceback (most recent call last):
  File "/usr/lib/python2.7/runpy.py", line 174, 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 94, in <module>
    main()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, 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 722, in __call__
    return self.main(*args, **kwargs)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 697, in main
    rv = self.invoke(ctx)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1066, 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 1066, 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 895, 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 535, in invoke
    return callback(*args, **kwargs)
  File "/home/frappe/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 "/home/frappe/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 24, in _func
    ret = f(frappe._dict(ctx.obj), *args, **kwargs)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py", line 294, in backup
    odb = scheduled_backup(ignore_files=not with_files, backup_path_db=backup_path_db, backup_path_files=backup_path_files, backup_path_private_files=backup_path_private_files, force=True)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/backups.py", line 166, in scheduled_backup
    odb = new_backup(older_than, ignore_files, backup_path_db=backup_path_db, backup_path_files=backup_path_files, force=force)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/backups.py", line 176, in new_backup
    odb.get_backup(older_than, ignore_files, force=force)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/backups.py", line 48, in get_backup
    self.set_backup_file_name()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/backups.py", line 63, in set_backup_file_name
    todays_date = now_datetime().strftime('%Y%m%d_%H%M%S')
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/data.py", line 122, in now_datetime
    dt = convert_utc_to_user_timezone(datetime.datetime.utcnow())
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/data.py", line 145, in convert_utc_to_user_timezone
    return utcnow.astimezone(timezone(get_time_zone()))
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/data.py", line 139, in get_time_zone
    return frappe.cache().get_value("time_zone", _get_time_zone)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/redis_wrapper.py", line 72, in get_value
    val = generator()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/data.py", line 133, in _get_time_zone
    return frappe.db.get_system_setting('time_zone') or 'Asia/Kolkata'
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 871, in get_system_setting
    return frappe.cache().get_value("system_settings", _load_system_settings).get(key)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/redis_wrapper.py", line 72, in get_value
    val = generator()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 870, in _load_system_settings
    return self.get_singles_dict("System Settings")
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 555, in get_singles_dict
    tabSingles where doctype=%s""", doctype))
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 136, in sql
    self.connect()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 86, in connect
    charset='utf8mb4', use_unicode = True, conv = conversions)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/__init__.py", line 90, in Connect
    return Connection(*args, **kwargs)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 699, in __init__
    self.connect()
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 967, in connect
    raise exc
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on u'localhost' ([Errno -2] Name or service not known)")

mean while at web i get this error

Internal Server Error

>supervisorctl status

frappe-bench-redis:frappe-bench-redis-cache RUNNING pid 2219, uptime 7:32:50
frappe-bench-redis:frappe-bench-redis-queue RUNNING pid 2218, uptime 7:32:50
frappe-bench-redis:frappe-bench-redis-socketio RUNNING pid 2220, uptime 7:32:50
frappe-bench-web:frappe-bench-frappe-web RUNNING pid 2214, uptime 7:32:50
frappe-bench-web:frappe-bench-node-socketio FATAL Exited too quickly (process log may have details)
frappe-bench-workers:frappe-bench-frappe-default-worker-0 RUNNING pid 28061, uptime 0:00:04
frappe-bench-workers:frappe-bench-frappe-long-worker-0 STARTING
frappe-bench-workers:frappe-bench-frappe-schedule RUNNING pid 27826, uptime 0:00:21
frappe-bench-workers:frappe-bench-frappe-short-worker-0 RUNNING pid 28082, uptime 0:00:03

>npm list socket.io

frappe@ /home/frappe/frappe-bench
└── socket.io@2.0.3

please help

2 
sudo killall redis-server
sudo killall mysqld

Then bench start

3

Try to start mysql service then test the connection by typing:
/etc/init.d/MySQL start
mysql -u root -p[your mariadb password]

also be careful that the passwords correct in the installation file, then update again

4

i have try this @OmarJaber no luck

1 Like
5

the Mysql service is started well but no luck too , is it course by install WEBMIN .?, but before that its ok.
any idea?

6

Try bench build to rebuild your Minify + concatenate JS and CSS files

7

i have try it no luck

servererorr
servererorr1683×1811 65.6 KB

8

Check your server logs under frappe-bench/logs to find out the error.

9

frappe.log1

Preformatted textRequest Error
    Traceback (most recent call last):
      File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 59, in application
        init_request(request)
      File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 121, in init_request
        frappe.local.http_request = frappe.auth.HTTPRequest()
      File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 44, in __init__
        self.set_lang()
      File "/home/frappe/frappe-bench/apps/frappe/frappe/auth.py", line 88, in set_lang
        frappe.local.lang = guess_language()
      File "/home/frappe/frappe-bench/apps/frappe/frappe/translate.py", line 29, in guess_language
        lang_list = get_all_languages() or []
      File "/home/frappe/frappe-bench/apps/frappe/frappe/translate.py", line 84, in get_all_languages
        return frappe.cache().get_value('languages', _get)
      File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/redis_wrapper.py", line 72, in get_value
        val = generator()
      File "/home/frappe/frappe-bench/apps/frappe/frappe/translate.py", line 83, in _get
        return frappe.db.sql_list('select name from tabLanguage')
      File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 232, in sql_list
        return [r[0] for r in self.sql(query, values, debug=debug)]
      File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 136, in sql
        self.connect()
      File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 86, in connect
        charset='utf8mb4', use_unicode = True, conv = conversions)
      File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/__init__.py", line 90, in Connect
        return Connection(*args, **kwargs)
      File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 699, in __init__
        self.connect()
      File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 967, in connect
        raise exc
    OperationalError: (2003, "Can't connect to MySQL server on u'localhost' ([Errno -2] Name or service not known)")
    [ERROR] 2018-01-08 15:14:24,971 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/error.py:
    New Exception collected with id: 2018-01-08 15:14:24.563107-118.101.74.20-5e7
    [ERROR] 2018-01-08 15:38:26,849 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/error.py:
    New Exception collected with id: 2018-01-08 15:38:26.836263-66.249.66.26-e1b

worker.error.log

Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 174, 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 94, in
main()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, 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 722, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, 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 1066, 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 895, 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 535, in invoke
return callback(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/scheduler.py”, line 157, in start_worker
start_worker(queue)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 139, 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 449, in work
self.register_birth()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py”, line 259, in register_birth
if self.connection.exists(self.key) and
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 951, in exists
return self.execute_command(‘EXISTS’, name)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 673, in execute_command
connection.send_command(*args)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 610, in send_command
self.send_packed_command(self.pack_command(*args))
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 585, in send_packed_command
self.connect()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 489, in connect
raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error -2 connecting to localhost:11000. Name or service not known

web.log.

Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/website/render.py”, line 39, in render
data = render_page_by_language(path)
File “/home/frappe/frappe-bench/apps/frappe/frappe/website/render.py”, line 134, in render_page_by_language
File “/home/frappe/frappe-bench/apps/frappe/frappe/website/render.py”, line 150, in render_page
File “/home/frappe/frappe-bench/apps/frappe/frappe/website/render.py”, line 157, in build
except frappe.DoesNotExistError:
File “/home/frappe/frappe-bench/apps/frappe/frappe/website/render.py”, line 170, in build_page
if context.title and “{{” in context.title:
File “/home/frappe/frappe-bench/apps/frappe/frappe/website/context.py”, line 15, in get_context
context = get_page_context(path)
File “/home/frappe/frappe-bench/apps/frappe/frappe/website/router.py”, line 35, in get_page_context
page_context = make_page_context(path)
File “/home/frappe/frappe-bench/apps/frappe/frappe/website/router.py”, line 43, in make_page_context
context = resolve_route(path)
File “/home/frappe/frappe-bench/apps/frappe/frappe/website/router.py”, line 21, in resolve_route
return get_page_context_from_doctype(path)
File “/home/frappe/frappe-bench/apps/frappe/frappe/website/router.py”, line 75, in get_page_context_from_doctype
page_info = get_page_info_from_doctypes(path)
File “/home/frappe/frappe-bench/apps/frappe/frappe/website/router.py”, line 97, in get_page_info_from_doctypes
controller = get_controller(doctype)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/base_document.py”, line 35, in get_controller
else:
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/utils.py”, line 185, in load_doctype_module
doctype_python_modules[key] = frappe.get_module(module_name)
ImportError: Module import failed for Item (erpnext.stock.doctype.item.item Error: cannot import name clean_html)

118.101.74.20 does not exist
118.101.74.20 does not exist
118.101.74.20 does not exist
118.101.74.20 does not exist
60.48.74.240 does not exist
60.48.74.240 does not exist

Schedule.error.log

Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 174, 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 94, in
main()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, 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 722, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, 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 1066, 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 895, 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 535, in invoke
return callback(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/scheduler.py”, line 151, in start_scheduler
start_scheduler()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py”, line 57, in start_scheduler
schedule.run_pending()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/schedule/init.py”, line 452, in run_pending
default_scheduler.run_pending()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/schedule/init.py”, line 75, in run_pending
self._run_job(job)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/schedule/init.py”, line 129, in _run_job
ret = job.run()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/schedule/init.py”, line 377, in run
ret = self.job_func()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py”, line 68, in enqueue_events_for_all_sites
jobs_per_site = get_jobs()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py”, line 160, in get_jobs
for job in q.jobs:
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/queue.py”, line 150, in jobs
return self.get_jobs()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/queue.py”, line 139, in get_jobs
job_ids = self.get_job_ids(offset, length)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/rq/queue.py”, line 135, in get_job_ids
self.connection.lrange(self.key, start, end)]
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 1347, in lrange
return self.execute_command(‘LRANGE’, name, start, end)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py”, line 673, in execute_command
connection.send_command(*args)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 610, in send_command
self.send_packed_command(self.pack_command(*args))
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 585, in send_packed_command
self.connect()
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py”, line 489, in connect
raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error -2 connecting to localhost:11000. Name or service not known.

node-socketio.erro.log

Error: Redis connection to localhost:12000 failed - getaddrinfo ENOTFOUND localhost localhost:12000
at errnoException (dns.js:28:10)
at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:76:26)
events.js:160
throw er; // Unhandled ‘error’ event
^

Error: Redis connection to localhost:12000 failed - getaddrinfo ENOTFOUND localhost localhost:12000
at errnoException (dns.js:28:10)
at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:76:26)
events.js:160
throw er; // Unhandled ‘error’ event
^

10

hi will i lose all my setting ,my modify form and doctype, if i do backup from all 8 then restore to new version 10 ?

is this command #rm -rf node_modules modify will lost my all setiing?

thankyou for help

11

:/home/frappe/frappe-bench$ sudo node -v
v6.12.3
:/home/frappe/frappe-bench$ sudo netstat -tulpn | grep mysql
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 2146/mysqld
:/home/frappe/frappe-bench$ sudo npm -v
3.10.10
:/home/frappe/frappe-bench$ sudo netstat -tulpn | grep nginx
tcp 0 0 0.0.0.0:443 0.0.0.0:* LISTEN 2153/nginx -g daemo
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 2153/nginx -g daemo
:/home/frappe/frappe-bench$ sudo netstat -tulpn | grep master
tcp 0 0 0.0.0.0:25 0.0.0.0:* LISTEN 2344/master
tcp6 0 0 :::25 :::* LISTEN 2344/master
:/home/frappe/frappe-bench$ udo netstat -tulpn | grep 8000
The program ‘udo’ is currently not installed. You can install it by typing:
sudo apt install udo
:/home/frappe/frappe-bench$ udo netstat -tulpn | grep 8000
The program ‘udo’ is currently not installed. You can install it by typing:
sudo apt install udo
:/home/frappe/frappe-bench$ sudo netstat -tulpn | grep 8000
tcp 0 0 127.0.0.1:8000 0.0.0.0:* LISTEN 2176/python
:/home/frappe/frappe-bench$ sudo netstat -tulpn | grep node
:/home/frappe/frappe-bench$ sudo netstat -tulpn | grep node
:/home/frappe/frappe-bench$ sudo netstat -tulpn | grep node
:/home/frappe/frappe-bench$

im troubleshooting https://jwrober.github.io/erpnext_admin_guide/i-u-b/install ERPnext i found out node NodeJS is not running on port 9000

12

i mess up with webmin hostname & dns client config by chosing mulicast dns

now ok

thanks all for reply

2 Likes