ERPNext Installation Issues

[SuryaNittala]

Hi,
I am trying to install ERPNext on ubuntu 16.04 version and its failing with the following error.

oslabs@oslabs:~/test-frappe-bench$ bench new-site foo.bar
MySQL root password: 
================================================================================
Creation of your site - foo.bar failed because MariaDB is not properly 
configured to use the Barracuda storage engine. 
Please add the settings below to MariaDB's my.cnf, restart MariaDB then 
run `bench new-site foo.bar` again.


[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

[mysql]
default-character-set = utf8mb4

================================================================================

I followed the below link
Home · frappe/frappe Wiki · GitHub step by step. Also, i rechecked all the settings in /etc/mysql/my.cnf and these settings are present as part of this. I restarted mysql,mariadb services. As a last resort, i restarted the system and bench as well but was of no use. Any help on this would be highly appreciated.

Thanks,
-Surya

[SuryaNittala]

Just to be sure, i checked the the path of the configuration file as well.
:~$ find /etc -name my.cnf
/etc/mysql/my.cnf .

BTW i have gone through similar posts which has a mention of this problem and tried out the suggestions.Any insights on the root cause of the issue ?

[SuryaNittala]

Update - I could solve the issue maria db issue with changes in the config file and could proceed further. But after making all the changes and configuring the erp next, when i start the bench it exits with the following error.

bench-start
bench-start: command not found
~/test-frappe-bench$ bench start 
17:19:39 system           | redis_socketio.1 started (pid=5735)
17:19:39 redis_socketio.1 |                 _._                                                  
17:19:39 redis_socketio.1 |            _.-``__ ''-._                                             
17:19:39 redis_socketio.1 |       _.-``    `.  `_.  ''-._           Redis 3.0.6 (00000000/0) 64 bit
17:19:39 redis_socketio.1 |   .-`` .-```.  ```\/    _.,_ ''-._                                   
17:19:39 redis_socketio.1 |  (    '      ,       .-`  | `,    )     Running in standalone mode
17:19:39 redis_socketio.1 |  |`-._`-...-` __...-.``-._|'` _.-'|     Port: 12000
17:19:39 redis_socketio.1 |  |    `-._   `._    /     _.-'    |     PID: 5748
17:19:39 redis_socketio.1 |   `-._    `-._  `-./  _.-'    _.-'                                   
17:19:39 redis_socketio.1 |  |`-._`-._    `-.__.-'    _.-'_.-'|                                  
17:19:39 redis_socketio.1 |  |    `-._`-._        _.-'_.-'    |           http://redis.io        
17:19:39 redis_socketio.1 |   `-._    `-._`-.__.-'_.-'    _.-'                                   
17:19:39 redis_socketio.1 |  |`-._`-._    `-.__.-'    _.-'_.-'|                                  
17:19:39 redis_socketio.1 |  |    `-._`-._        _.-'_.-'    |                                  
17:19:39 redis_socketio.1 |   `-._    `-._`-.__.-'_.-'    _.-'                                   
17:19:39 redis_socketio.1 |       `-._    `-.__.-'    _.-'                                       
17:19:39 redis_socketio.1 |           `-._        _.-'                                           
17:19:39 redis_socketio.1 |               `-.__.-'                                               
17:19:39 redis_socketio.1 | 
17:19:39 redis_socketio.1 | 5748:M 28 Jul 17:19:39.965 # Server started, Redis version 3.0.6
17:19:39 redis_socketio.1 | 5748:M 28 Jul 17:19:39.965 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled.
17:19:39 redis_socketio.1 | 5748:M 28 Jul 17:19:39.965 * The server is now ready to accept connections on port 12000
17:19:39 system           | worker_long.1 started (pid=5741)
17:19:39 system           | worker_short.1 started (pid=5756)
17:19:39 system           | worker_default.1 started (pid=5745)
17:19:39 system           | watch.1 started (pid=5743)
17:19:39 system           | redis_queue.1 started (pid=5744)
17:19:39 redis_queue.1    |                 _._                                                  
17:19:39 redis_queue.1    |            _.-``__ ''-._                                             
17:19:39 redis_queue.1    |       _.-``    `.  `_.  ''-._           Redis 3.0.6 (00000000/0) 64 bit
17:19:39 redis_queue.1    |   .-`` .-```.  ```\/    _.,_ ''-._                                   
17:19:39 redis_queue.1    |  (    '      ,       .-`  | `,    )     Running in standalone mode
17:19:39 redis_queue.1    |  |`-._`-...-` __...-.``-._|'` _.-'|     Port: 11000
17:19:39 redis_queue.1    |  |    `-._   `._    /     _.-'    |     PID: 5757
17:19:39 redis_queue.1    |   `-._    `-._  `-./  _.-'    _.-'                                   
17:19:39 redis_queue.1    |  |`-._`-._    `-.__.-'    _.-'_.-'|                                  
17:19:39 redis_queue.1    |  |    `-._`-._        _.-'_.-'    |           http://redis.io        
17:19:39 redis_queue.1    |   `-._    `-._`-.__.-'_.-'    _.-'                                   
17:19:39 redis_queue.1    |  |`-._`-._    `-.__.-'    _.-'_.-'|                                  
17:19:39 redis_queue.1    |  |    `-._`-._        _.-'_.-'    |                                  
17:19:39 redis_queue.1    |   `-._    `-._`-.__.-'_.-'    _.-'                                   
17:19:39 redis_queue.1    |       `-._    `-.__.-'    _.-'                                       
17:19:39 redis_queue.1    |           `-._        _.-'                                           
17:19:39 redis_queue.1    |               `-.__.-'                                               
17:19:39 redis_queue.1    | 
17:19:39 redis_queue.1    | 5757:M 28 Jul 17:19:39.983 # Server started, Redis version 3.0.6
17:19:39 redis_queue.1    | 5757:M 28 Jul 17:19:39.983 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled.
17:19:39 redis_queue.1    | 5757:M 28 Jul 17:19:39.983 * The server is now ready to accept connections on port 11000
17:19:40 system           | redis_cache.1 started (pid=5747)
17:19:40 redis_cache.1    |                 _._                                                  
17:19:40 redis_cache.1    |            _.-``__ ''-._                                             
17:19:40 redis_cache.1    |       _.-``    `.  `_.  ''-._           Redis 3.0.6 (00000000/0) 64 bit
17:19:40 redis_cache.1    |   .-`` .-```.  ```\/    _.,_ ''-._                                   
17:19:40 redis_cache.1    |  (    '      ,       .-`  | `,    )     Running in standalone mode
17:19:40 redis_cache.1    |  |`-._`-...-` __...-.``-._|'` _.-'|     Port: 13000
17:19:40 redis_cache.1    |  |    `-._   `._    /     _.-'    |     PID: 5765
17:19:40 redis_cache.1    |   `-._    `-._  `-./  _.-'    _.-'                                   
17:19:40 redis_cache.1    |  |`-._`-._    `-.__.-'    _.-'_.-'|                                  
17:19:40 redis_cache.1    |  |    `-._`-._        _.-'_.-'    |           http://redis.io        
17:19:40 redis_cache.1    |   `-._    `-._`-.__.-'_.-'    _.-'                                   
17:19:40 redis_cache.1    |  |`-._`-._    `-.__.-'    _.-'_.-'|                                  
17:19:40 redis_cache.1    |  |    `-._`-._        _.-'_.-'    |                                  
17:19:40 redis_cache.1    |   `-._    `-._`-.__.-'_.-'    _.-'                                   
17:19:40 redis_cache.1    |       `-._    `-.__.-'    _.-'                                       
17:19:40 redis_cache.1    |           `-._        _.-'                                           
17:19:40 redis_cache.1    |               `-.__.-'                                               
17:19:40 redis_cache.1    | 
17:19:40 redis_cache.1    | 5765:M 28 Jul 17:19:39.999 # Server started, Redis version 3.0.6
17:19:40 redis_cache.1    | 5765:M 28 Jul 17:19:39.999 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled.
17:19:40 redis_cache.1    | 5765:M 28 Jul 17:19:39.999 * The server is now ready to accept connections on port 13000
17:19:40 system           | schedule.1 started (pid=5740)
17:19:40 system           | socketio.1 started (pid=5746)
17:19:40 system           | web.1 started (pid=5742)
17:19:40 socketio.1       | listening on *: 9000
17:19:41 worker_default.1 | Traceback (most recent call last):
17:19:41 worker_default.1 |   File "/usr/lib/python2.7/runpy.py", line 174, in _run_module_as_main
17:19:41 worker_default.1 |     "__main__", fname, loader, pkg_name)
17:19:41 worker_default.1 |   File "/usr/lib/python2.7/runpy.py", line 72, in _run_code
17:19:41 worker_default.1 |     exec code in run_globals
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 97, in <module>
17:19:41 worker_default.1 |     main()
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
17:19:41 worker_default.1 |     click.Group(commands=commands)(prog_name='bench')
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 722, in __call__
17:19:41 worker_default.1 |     return self.main(*args, **kwargs)
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 697, in main
17:19:41 worker_default.1 |     rv = self.invoke(ctx)
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke
17:19:41 worker_default.1 |     return _process_result(sub_ctx.command.invoke(sub_ctx))
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke
17:19:41 worker_default.1 |     return _process_result(sub_ctx.command.invoke(sub_ctx))
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 895, in invoke
17:19:41 worker_default.1 |     return ctx.invoke(self.callback, **ctx.params)
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 535, in invoke
17:19:41 worker_default.1 |     return callback(*args, **kwargs)
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/apps/frappe/frappe/commands/scheduler.py", line 158, in start_worker
17:19:41 worker_default.1 |     start_worker(queue, quiet = quiet)
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/apps/frappe/frappe/utils/background_jobs.py", line 145, in start_worker
17:19:41 worker_default.1 |     Worker(queues, name=get_worker_name(queue)).work(logging_level = logging_level)
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py", line 466, in work
17:19:41 worker_default.1 |     self.register_birth()
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py", line 273, in register_birth
17:19:41 worker_default.1 |     if self.connection.exists(self.key) and \
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py", line 951, in exists
17:19:41 worker_default.1 |     return self.execute_command('EXISTS', name)
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py", line 673, in execute_command
17:19:41 worker_default.1 |     connection.send_command(*args)
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py", line 610, in send_command
17:19:41 worker_default.1 |     self.send_packed_command(self.pack_command(*args))
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py", line 585, in send_packed_command
17:19:41 worker_default.1 |     self.connect()
17:19:41 worker_default.1 |   File "/home/oslabs/test-frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py", line 489, in connect
17:19:41 worker_default.1 |     raise ConnectionError(self._error_message(e))
17:19:41 worker_default.1 | redis.exceptions.ConnectionError: Error 111 connecting to localhost:11000. Connection refused.
17:19:41 system           | worker_default.1 stopped (rc=1)
17:19:41 system           | sending SIGTERM to redis_socketio.1 (pid 5735)
17:19:41 system           | sending SIGTERM to worker_long.1 (pid 5741)
17:19:41 system           | sending SIGTERM to watch.1 (pid 5743)
17:19:41 system           | sending SIGTERM to redis_queue.1 (pid 5744)
17:19:41 system           | sending SIGTERM to web.1 (pid 5742)
17:19:41 system           | sending SIGTERM to schedule.1 (pid 5740)
17:19:41 system           | sending SIGTERM to socketio.1 (pid 5746)
17:19:41 system           | sending SIGTERM to redis_cache.1 (pid 5747)
17:19:41 system           | sending SIGTERM to worker_short.1 (pid 5756)
17:19:41 redis_queue.1    | 5757:signal-handler (1532778581) Received SIGTERM scheduling shutdown...
17:19:41 system           | socketio.1 stopped (rc=-15)
17:19:41 redis_cache.1    | 5765:signal-handler (1532778581) Received SIGTERM scheduling shutdown...
17:19:41 redis_socketio.1 | 5748:signal-handler (1532778581) Received SIGTERM scheduling shutdown...
17:19:41 system           | schedule.1 stopped (rc=-15)
17:19:41 system           | worker_short.1 stopped (rc=-15)
17:19:41 system           | watch.1 stopped (rc=-15)
17:19:41 system           | web.1 stopped (rc=-15)
17:19:41 system           | worker_long.1 stopped (rc=-15)
17:19:41 redis_socketio.1 | 5748:M 28 Jul 17:19:41.767 # User requested shutdown...
17:19:41 redis_socketio.1 | 5748:M 28 Jul 17:19:41.767 # Redis is now ready to exit, bye bye...
17:19:41 system           | redis_socketio.1 stopped (rc=-15)
17:19:41 redis_queue.1    | 5757:M 28 Jul 17:19:41.798 # User requested shutdown...
17:19:41 redis_queue.1    | 5757:M 28 Jul 17:19:41.798 # Redis is now ready to exit, bye bye...
17:19:41 system           | redis_queue.1 stopped (rc=-15)
17:19:41 redis_cache.1    | 5765:M 28 Jul 17:19:41.812 # User requested shutdown...
17:19:41 redis_cache.1    | 5765:M 28 Jul 17:19:41.812 # Redis is now ready to exit, bye bye...
17:19:41 system           | redis_cache.1 stopped (rc=-15)
~/test-frappe-bench$

I changed the limits.conf and sysctl.conf to accommodate maximum open files. Though I could get rid of the warnings its landing a connection refused issue. I checked the port bindings to ensure that no duplicate process are running.

>> 17:19:41 worker_default.1 | redis.exceptions.ConnectionError: Error 111 connecting to localhost:11000. Connection refused.

Any help on this issue will be highly appreciated…

Thanks,
-Surya

[hifyaan]

@SuryaNittala

WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command ‘echo never > /sys/kernel/mm/transparent_hugepage/enabled’ as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled

i would start here
i had a similar issue on on opensuse leap 15
the rule of thumb is to first get rid off all errors before continuing

[yashodhan]

Check if your Redis server instance is running as following, if not then you need to install/reinstall it first (sudo apt-get install --reinstall redis-server)

service redis-server start
service redis-server status

do remove following file then do as above, then check if bench starts

cp /var/lib/redis/redis.rdb /var/lib/redis/redis.rdb.backup
rm /var/lib/redis/redis.rdb

[yashodhan]

@SuryaNittala

BTW i have gone through similar posts which has a mention of this problem and tried out the suggestions.Any insights on the root cause of the issue ?

it may be due to malformed my.cnf
Recreating all parameters a fresh, might help to fix this issue.

Ubuntu 16.04 bench newsite error

The last folder checked for configurations files is /etc/mysql/mariadb.conf.d which contains a conf file overwritting what has already been loaded from /etc/mysql/conf.d/barracuda.cnf. E.g the output of mysqld --print-defaults shows you have multiple definitions of --collation_server=* the last of which is not correct. (only the last definition is used if there are multiple definitions). The solution would be to move /etc/mysql/conf.d/barracuda.cnf to /etc/mysql/mariadb.conf.d/barracuda.cnf so…

[trentmu]

@clarkej recommends…

Error after os upgrade Ubuntu 17.04

Maybe try this - pip uninstall mysql-python apt-get install libmysqlclient-dev pip install mysql-python You will find the above here Error while installing erpnext bench init frappe-bench && cd frappe-bench - #3 by ninjas

[clarkej]

These may offer clues too?

sudo service mysql status
sudo less /var/lib/mysql/mysql-error.log

[SuryaNittala]

:~/

TestSiteBench/frappe-bench$ bench start
16:28:00 system           | redis_socketio.1 started (pid=3009)
16:28:00 redis_socketio.1 |                 _._                                                  
16:28:00 redis_socketio.1 |            _.-``__ ''-._                                             
16:28:00 redis_socketio.1 |       _.-``    `.  `_.  ''-._           Redis 3.0.6 (00000000/0) 64 bit
16:28:00 redis_socketio.1 |   .-`` .-```.  ```\/    _.,_ ''-._                                   
16:28:00 redis_socketio.1 |  (    '      ,       .-`  | `,    )     Running in standalone mode
16:28:00 redis_socketio.1 |  |`-._`-...-` __...-.``-._|'` _.-'|     Port: 12000
16:28:00 redis_socketio.1 |  |    `-._   `._    /     _.-'    |     PID: 3020
16:28:00 redis_socketio.1 |   `-._    `-._  `-./  _.-'    _.-'                                   
16:28:00 redis_socketio.1 |  |`-._`-._    `-.__.-'    _.-'_.-'|                                  
16:28:00 redis_socketio.1 |  |    `-._`-._        _.-'_.-'    |           http://redis.io        
16:28:00 redis_socketio.1 |   `-._    `-._`-.__.-'_.-'    _.-'                                   
16:28:00 redis_socketio.1 |  |`-._`-._    `-.__.-'    _.-'_.-'|                                  
16:28:00 redis_socketio.1 |  |    `-._`-._        _.-'_.-'    |                                  
16:28:00 redis_socketio.1 |   `-._    `-._`-.__.-'_.-'    _.-'                                   
16:28:00 redis_socketio.1 |       `-._    `-.__.-'    _.-'                                       
16:28:00 redis_socketio.1 |           `-._        _.-'                                           
16:28:00 redis_socketio.1 |               `-.__.-'                                               
16:28:00 redis_socketio.1 | 
16:28:00 redis_socketio.1 | 3020:M 30 Jul 16:28:00.822 # Server started, Redis version 3.0.6
16:28:00 redis_socketio.1 | 3020:M 30 Jul 16:28:00.822 * The server is now ready to accept connections on port 12000
16:28:00 system           | redis_queue.1 started (pid=3017)
16:28:00 redis_queue.1    |                 _._                                                  
16:28:00 redis_queue.1    |            _.-``__ ''-._                                             
16:28:00 redis_queue.1    |       _.-``    `.  `_.  ''-._           Redis 3.0.6 (00000000/0) 64 bit
16:28:00 redis_queue.1    |   .-`` .-```.  ```\/    _.,_ ''-._                                   
16:28:00 redis_queue.1    |  (    '      ,       .-`  | `,    )     Running in standalone mode
16:28:00 redis_queue.1    |  |`-._`-...-` __...-.``-._|'` _.-'|     Port: 11000
16:28:00 redis_queue.1    |  |    `-._   `._    /     _.-'    |     PID: 3021
16:28:00 redis_queue.1    |   `-._    `-._  `-./  _.-'    _.-'                                   
16:28:00 redis_queue.1    |  |`-._`-._    `-.__.-'    _.-'_.-'|                                  
16:28:00 redis_queue.1    |  |    `-._`-._        _.-'_.-'    |           http://redis.io        
16:28:00 redis_queue.1    |   `-._    `-._`-.__.-'_.-'    _.-'                                   
16:28:00 redis_queue.1    |  |`-._`-._    `-.__.-'    _.-'_.-'|                                  
16:28:00 redis_queue.1    |  |    `-._`-._        _.-'_.-'    |                                  
16:28:00 redis_queue.1    |   `-._    `-._`-.__.-'_.-'    _.-'                                   
16:28:00 redis_queue.1    |       `-._    `-.__.-'    _.-'                                       
16:28:00 redis_queue.1    |           `-._        _.-'                                           
16:28:00 redis_queue.1    |               `-.__.-'                                               
16:28:00 redis_queue.1    | 
16:28:00 redis_queue.1    | 3021:M 30 Jul 16:28:00.822 # Server started, Redis version 3.0.6
16:28:00 redis_queue.1    | 3021:M 30 Jul 16:28:00.822 * The server is now ready to accept connections on port 11000
16:28:00 system           | redis_cache.1 started (pid=3019)
16:28:00 redis_cache.1    |                 _._                                                  
16:28:00 redis_cache.1    |            _.-``__ ''-._                                             
16:28:00 redis_cache.1    |       _.-``    `.  `_.  ''-._           Redis 3.0.6 (00000000/0) 64 bit
16:28:00 redis_cache.1    |   .-`` .-```.  ```\/    _.,_ ''-._                                   
16:28:00 redis_cache.1    |  (    '      ,       .-`  | `,    )     Running in standalone mode
16:28:00 redis_cache.1    |  |`-._`-...-` __...-.``-._|'` _.-'|     Port: 13000
16:28:00 redis_cache.1    |  |    `-._   `._    /     _.-'    |     PID: 3023
16:28:00 redis_cache.1    |   `-._    `-._  `-./  _.-'    _.-'                                   
16:28:00 redis_cache.1    |  |`-._`-._    `-.__.-'    _.-'_.-'|                                  
16:28:00 redis_cache.1    |  |    `-._`-._        _.-'_.-'    |           http://redis.io        
16:28:00 redis_cache.1    |   `-._    `-._`-.__.-'_.-'    _.-'                                   
16:28:00 redis_cache.1    |  |`-._`-._    `-.__.-'    _.-'_.-'|                                  
16:28:00 redis_cache.1    |  |    `-._`-._        _.-'_.-'    |                                  
16:28:00 redis_cache.1    |   `-._    `-._`-.__.-'_.-'    _.-'                                   
16:28:00 redis_cache.1    |       `-._    `-.__.-'    _.-'                                       
16:28:00 redis_cache.1    |           `-._        _.-'                                           
16:28:00 redis_cache.1    |               `-.__.-'                                               
16:28:00 redis_cache.1    | 
16:28:00 redis_cache.1    | 3023:M 30 Jul 16:28:00.823 # Server started, Redis version 3.0.6
16:28:00 redis_cache.1    | 3023:M 30 Jul 16:28:00.823 * The server is now ready to accept connections on port 13000
16:28:00 system           | socketio.1 started (pid=3018)
16:28:00 system           | watch.1 started (pid=3011)
16:28:00 system           | schedule.1 started (pid=3015)
16:28:00 system           | web.1 started (pid=3035)
16:28:00 system           | worker_default.1 started (pid=3034)
16:28:00 system           | worker_short.1 started (pid=3036)
16:28:00 system           | worker_long.1 started (pid=3016)
16:28:01 socketio.1       | listening on *: 9000
16:28:02 worker_long.1    | Traceback (most recent call last):
16:28:02 worker_long.1    |   File "/usr/lib/python2.7/runpy.py", line 174, in _run_module_as_main
16:28:02 worker_long.1    |     "__main__", fname, loader, pkg_name)
16:28:02 worker_long.1    |   File "/usr/lib/python2.7/runpy.py", line 72, in _run_code
16:28:02 worker_long.1    |     exec code in run_globals
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 97, in <module>
16:28:02 worker_long.1    |     main()
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
16:28:02 worker_long.1    |     click.Group(commands=commands)(prog_name='bench')
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 722, in __call__
16:28:02 worker_long.1    |     return self.main(*args, **kwargs)
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 697, in main
16:28:02 worker_long.1    |     rv = self.invoke(ctx)
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke
16:28:02 worker_long.1    |     return _process_result(sub_ctx.command.invoke(sub_ctx))
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke
16:28:02 worker_long.1    |     return _process_result(sub_ctx.command.invoke(sub_ctx))
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 895, in invoke
16:28:02 worker_long.1    |     return ctx.invoke(self.callback, **ctx.params)
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 535, in invoke
16:28:02 worker_long.1    |     return callback(*args, **kwargs)
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/apps/frappe/frappe/commands/scheduler.py", line 158, in start_worker
16:28:02 worker_long.1    |     start_worker(queue, quiet = quiet)
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/apps/frappe/frappe/utils/background_jobs.py", line 145, in start_worker
16:28:02 worker_long.1    |     Worker(queues, name=get_worker_name(queue)).work(logging_level = logging_level)
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py", line 466, in work
16:28:02 worker_long.1    |     self.register_birth()
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/env/local/lib/python2.7/site-packages/rq/worker.py", line 273, in register_birth
16:28:02 worker_long.1    |     if self.connection.exists(self.key) and \
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py", line 951, in exists
16:28:02 worker_long.1    |     return self.execute_command('EXISTS', name)
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/env/local/lib/python2.7/site-packages/redis/client.py", line 673, in execute_command
16:28:02 worker_long.1    |     connection.send_command(*args)
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py", line 610, in send_command
16:28:02 worker_long.1    |     self.send_packed_command(self.pack_command(*args))
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py", line 585, in send_packed_command
16:28:02 worker_long.1    |     self.connect()
16:28:02 worker_long.1    |   File "/home/oslabs/TestSiteBench/frappe-bench/env/local/lib/python2.7/site-packages/redis/connection.py", line 489, in connect
16:28:02 worker_long.1    |     raise ConnectionError(self._error_message(e))
16:28:02 worker_long.1    | redis.exceptions.ConnectionError: Error 111 connecting to localhost:11000. Connection refused.
16:28:02 system           | worker_long.1 stopped (rc=1)
16:28:02 system           | sending SIGTERM to redis_socketio.1 (pid 3009)
16:28:02 system           | sending SIGTERM to watch.1 (pid 3011)
16:28:02 system           | sending SIGTERM to redis_queue.1 (pid 3017)
16:28:02 system           | sending SIGTERM to web.1 (pid 3035)
16:28:02 system           | sending SIGTERM to schedule.1 (pid 3015)
16:28:02 system           | sending SIGTERM to worker_default.1 (pid 3034)
16:28:02 system           | sending SIGTERM to socketio.1 (pid 3018)
16:28:02 system           | sending SIGTERM to redis_cache.1 (pid 3019)
16:28:02 system           | sending SIGTERM to worker_short.1 (pid 3036)
16:28:02 system           | worker_default.1 stopped (rc=-15)
16:28:02 redis_cache.1    | 3023:signal-handler (1532948282) Received SIGTERM scheduling shutdown...
16:28:02 system           | web.1 stopped (rc=-15)
16:28:02 redis_socketio.1 | 3020:signal-handler (1532948282) Received SIGTERM scheduling shutdown...
16:28:02 redis_queue.1    | 3021:signal-handler (1532948282) Received SIGTERM scheduling shutdown...
16:28:02 system           | worker_short.1 stopped (rc=-15)
16:28:02 system           | schedule.1 stopped (rc=-15)
16:28:02 system           | socketio.1 stopped (rc=-15)
16:28:02 system           | watch.1 stopped (rc=-15)
16:28:02 redis_socketio.1 | 3020:M 30 Jul 16:28:02.225 # User requested shutdown...
16:28:02 redis_socketio.1 | 3020:M 30 Jul 16:28:02.225 # Redis is now ready to exit, bye bye...
16:28:02 system           | redis_socketio.1 stopped (rc=-15)
16:28:02 redis_cache.1    | 3023:M 30 Jul 16:28:02.225 # User requested shutdown...
16:28:02 redis_cache.1    | 3023:M 30 Jul 16:28:02.225 # Redis is now ready to exit, bye bye...
16:28:02 redis_queue.1    | 3021:M 30 Jul 16:28:02.225 # User requested shutdown...
16:28:02 system           | redis_cache.1 stopped (rc=-15)
16:28:02 redis_queue.1    | 3021:M 30 Jul 16:28:02.225 # Redis is now ready to exit, bye bye...
16:28:02 system           | redis_queue.1 stopped (rc=-15)

I made all the required changes to see off all the warning messages but couldn’t start the bench.

[SuryaNittala]

:~/

TestSiteBench/frappe-bench$ service redis-server status
● redis-server.service - Advanced key-value store
   Loaded: loaded (/lib/systemd/system/redis-server.service; enabled; vendor preset: enabled)
   Active: active (running) since Mon 2018-07-30 16:27:52 IST; 4min 41s ago
     Docs: http://redis.io/documentation,
           man:redis-server(1)
  Process: 2971 ExecStopPost=/bin/run-parts --verbose /etc/redis/redis-server.post-down.d (code=exited, status=0/SUCCESS)
  Process: 2967 ExecStop=/bin/kill -s TERM $MAINPID (code=exited, status=0/SUCCESS)
  Process: 2963 ExecStop=/bin/run-parts --verbose /etc/redis/redis-server.pre-down.d (code=exited, status=0/SUCCESS)
  Process: 2987 ExecStartPost=/bin/run-parts --verbose /etc/redis/redis-server.post-up.d (code=exited, status=0/SUCCESS)
  Process: 2984 ExecStart=/usr/bin/redis-server /etc/redis/redis.conf (code=exited, status=0/SUCCESS)
  Process: 2978 ExecStartPre=/bin/run-parts --verbose /etc/redis/redis-server.pre-up.d (code=exited, status=0/SUCCESS)
 Main PID: 2986 (redis-server)
   CGroup: /system.slice/redis-server.service
           └─2986 /usr/bin/redis-server 127.0.0.1:6379       

Jul 30 16:27:52 systemd[1]: Starting Advanced key-value store...
Jul 30 16:27:52 run-parts[2978]: run-parts: executing /etc/redis/redis-server.pre-up.d/00_example
Jul 30 16:27:52 run-parts[2987]: run-parts: executing /etc/redis/redis-server.post-up.d/00_example
Jul 30 16:27:52  systemd[1]: Started Advanced key-value store.

:/var/lib/redis$ ls -l
total 8
-rw-r--r-- 1 redis redis 18 Jul 30 16:27 dump.rdb
-rwxr-xr-x 1 root  root  18 Jul 30 16:00 dump.rdb.backup

Redis server is running fine on the system and i ensured to delete the older dump.rdb in the redis folder. After all these changes, i restarted the system and started the bench but it failed…

[yashodhan]

Best way out, is take backup of MySQL DB and sites directory.
Format the server and reinstall bench from scratch but, This time use auto installer with flag to provision developer environment.

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

Example:

python install.py --develop --user frappe

[root13F]

On the very first time, was that my.cnf empty or having some text ?