Deploy Problem: failure to reset DB/run app

[Natalie Lee]

Hi Chris, 

I've successfully built my codes on Otree hub, but cannot reset DB nor open my app. I've tried uninstall-reinstalling numpy. Any insights would be appreciated. Thank you!

This is the error message I get after clicking "Reset DB"

This is the error message I get when I run the app on Heroku:

Here is the log:

2022-02-03T12:14:19.898629+00:00 app[worker.1]: File "<frozen importlib._bootstrap>", line 1007, in _find_and_load

2022-02-03T12:14:19.898629+00:00 app[worker.1]: File "<frozen importlib._bootstrap>", line 986, in _find_and_load_unlocked

2022-02-03T12:14:19.898633+00:00 app[worker.1]: File "<frozen importlib._bootstrap>", line 680, in _load_unlocked

2022-02-03T12:14:19.898633+00:00 app[worker.1]: File "<frozen importlib._bootstrap_external>", line 850, in exec_module

2022-02-03T12:14:19.898633+00:00 app[worker.1]: File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed

2022-02-03T12:14:19.898634+00:00 app[worker.1]: File "/app/barg_three/models.py", line 6, in <module>

2022-02-03T12:14:19.898635+00:00 app[worker.1]: import numpy as np

2022-02-03T12:14:19.898635+00:00 app[worker.1]: ModuleNotFoundError: No module named 'numpy'

2022-02-03T12:14:19.929538+00:00 app[web.1]: Traceback (most recent call last):

2022-02-03T12:14:19.929641+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.9/site-packages/otree/database.py", line 268, in init_orm

2022-02-03T12:14:19.929644+00:00 app[web.1]: models = get_models_module(app)

2022-02-03T12:14:19.929644+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.9/site-packages/otree/common.py", line 75, in get_models_module

2022-02-03T12:14:19.929644+00:00 app[web.1]: return import_module(module_name)

2022-02-03T12:14:19.929647+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.9/importlib/__init__.py", line 127, in import_module

2022-02-03T12:14:19.929650+00:00 app[web.1]: return _bootstrap._gcd_import(name[level:], package, level)

2022-02-03T12:14:19.929653+00:00 app[web.1]: File "<frozen importlib._bootstrap>", line 1030, in _gcd_import

2022-02-03T12:14:19.929653+00:00 app[web.1]: File "<frozen importlib._bootstrap>", line 1007, in _find_and_load

2022-02-03T12:14:19.929654+00:00 app[web.1]: File "<frozen importlib._bootstrap>", line 986, in _find_and_load_unlocked

2022-02-03T12:14:19.929654+00:00 app[web.1]: File "<frozen importlib._bootstrap>", line 680, in _load_unlocked

2022-02-03T12:14:19.929654+00:00 app[web.1]: File "<frozen importlib._bootstrap_external>", line 850, in exec_module

2022-02-03T12:14:19.929654+00:00 app[web.1]: File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed

2022-02-03T12:14:19.929654+00:00 app[web.1]: File "/app/barg_three/models.py", line 6, in <module>

2022-02-03T12:14:19.929657+00:00 app[web.1]: import numpy as np

2022-02-03T12:14:19.929657+00:00 app[web.1]: ModuleNotFoundError: No module named 'numpy'

2022-02-03T12:14:20.097475+00:00 heroku[web.1]: Process exited with status 1

2022-02-03T12:14:20.120557+00:00 heroku[worker.1]: Process exited with status 1

2022-02-03T12:14:20.165019+00:00 heroku[web.1]: State changed from starting to crashed

2022-02-03T12:14:20.188792+00:00 heroku[web.1]: State changed from crashed to starting

2022-02-03T12:14:20.926580+00:00 heroku[worker.1]: State changed from up to crashed

2022-02-03T12:14:20.937085+00:00 heroku[worker.1]: State changed from crashed to starting

2022-02-03T12:14:22.000000+00:00 app[api]: Build succeeded

2022-02-03T12:14:23.876145+00:00 heroku[web.1]: Starting process with command `otree runprodserver1of2`

2022-02-03T12:14:24.718330+00:00 heroku[worker.1]: Starting process with command `otree runprodserver2of2`

2022-02-03T12:14:24.993957+00:00 app[web.1]: Traceback (most recent call last):

2022-02-03T12:14:24.993983+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.9/site-packages/otree/database.py", line 268, in init_orm

2022-02-03T12:14:24.993984+00:00 app[web.1]: models = get_models_module(app)

2022-02-03T12:14:24.993992+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.9/site-packages/otree/common.py", line 75, in get_models_module

2022-02-03T12:14:24.993993+00:00 app[web.1]: return import_module(module_name)

2022-02-03T12:14:24.994001+00:00 app[web.1]: File "/app/.heroku/python/lib/python3.9/importlib/__init__.py", line 127, in import_module

2022-02-03T12:14:24.994002+00:00 app[web.1]: return _bootstrap._gcd_import(name[level:], package, level)

2022-02-03T12:14:24.994009+00:00 app[web.1]: File "<frozen importlib._bootstrap>", line 1030, in _gcd_import

2022-02-03T12:14:24.994018+00:00 app[web.1]: File "<frozen importlib._bootstrap>", line 1007, in _find_and_load

2022-02-03T12:14:24.994026+00:00 app[web.1]: File "<frozen importlib._bootstrap>", line 986, in _find_and_load_unlocked

2022-02-03T12:14:24.994034+00:00 app[web.1]: File "<frozen importlib._bootstrap>", line 680, in _load_unlocked

2022-02-03T12:14:24.994043+00:00 app[web.1]: File "<frozen importlib._bootstrap_external>", line 850, in exec_module

2022-02-03T12:14:24.994051+00:00 app[web.1]: File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed

2022-02-03T12:14:24.994059+00:00 app[web.1]: File "/app/barg_three/models.py", line 6, in <module>

2022-02-03T12:14:24.994060+00:00 app[web.1]: import numpy as np

2022-02-03T12:14:24.994075+00:00 app[web.1]: ModuleNotFoundError: No module named 'numpy'

2022-02-03T12:14:25.171034+00:00 heroku[web.1]: Process exited with status 1

2022-02-03T12:14:25.400580+00:00 heroku[web.1]: State changed from starting to crashed

2022-02-03T12:14:25.609868+00:00 heroku[worker.1]: State changed from starting to up

2022-02-03T12:14:26.085600+00:00 app[worker.1]: Traceback (most recent call last):

2022-02-03T12:14:26.085633+00:00 app[worker.1]: File "/app/.heroku/python/lib/python3.9/site-packages/otree/database.py", line 268, in init_orm

2022-02-03T12:14:26.085636+00:00 app[worker.1]: models = get_models_module(app)

2022-02-03T12:14:26.085638+00:00 app[worker.1]: File "/app/.heroku/python/lib/python3.9/site-packages/otree/common.py", line 75, in get_models_module

2022-02-03T12:14:26.085638+00:00 app[worker.1]: return import_module(module_name)

2022-02-03T12:14:26.085643+00:00 app[worker.1]: File "/app/.heroku/python/lib/python3.9/importlib/__init__.py", line 127, in import_module

2022-02-03T12:14:26.090988+00:00 app[worker.1]: return _bootstrap._gcd_import(name[level:], package, level)

2022-02-03T12:14:26.090995+00:00 app[worker.1]: File "<frozen importlib._bootstrap>", line 1030, in _gcd_import

2022-02-03T12:14:26.091000+00:00 app[worker.1]: File "<frozen importlib._bootstrap>", line 1007, in _find_and_load

2022-02-03T12:14:26.091000+00:00 app[worker.1]: File "<frozen importlib._bootstrap>", line 986, in _find_and_load_unlocked

2022-02-03T12:14:26.091001+00:00 app[worker.1]: File "<frozen importlib._bootstrap>", line 680, in _load_unlocked

2022-02-03T12:14:26.091001+00:00 app[worker.1]: File "<frozen importlib._bootstrap_external>", line 850, in exec_module

2022-02-03T12:14:26.091001+00:00 app[worker.1]: File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed

2022-02-03T12:14:26.091001+00:00 app[worker.1]: File "/app/barg_three/models.py", line 6, in <module>

2022-02-03T12:14:26.091004+00:00 app[worker.1]: import numpy as np

2022-02-03T12:14:26.091004+00:00 app[worker.1]: ModuleNotFoundError: No module named 'numpy'

2022-02-03T12:14:26.262580+00:00 heroku[worker.1]: Process exited with status 1

2022-02-03T12:14:26.530669+00:00 heroku[worker.1]: State changed from up to crashed

2022-02-03T12:16:02.000000+00:00 app[heroku-postgres]: source=DATABASE addon=postgresql-acute-84093 sample#current_transaction=945 sample#db_size=11547183bytes sample#tables=31 sample#active-connections=11 sample#waiting-connections=0 sample#index-cache-hit-rate=0.95507 sample#table-cache-hit-rate=0.97283 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.10084 sample#tmp-disk-used=542765056 sample#tmp-disk-available=72436027392 sample#memory-total=4018284kB sample#memory-free=137036kB sample#memory-cached=3377020kB sample#memory-postgres=25144kB sample#wal-percentage-used=0.06477715638082764

2022-02-03T12:16:06.000000+00:00 app[heroku-redis]: source=REDIS addon=redis-parallel-63615 sample#active-connections=1 sample#load-avg-1m=0.005 sample#load-avg-5m=0.025 sample#load-avg-15m=0.005 sample#read-iops=0 sample#write-iops=16.874 sample#memory-total=15619148kB sample#memory-free=8667376kB sample#memory-cached=4716428kB sample#memory-redis=1716776bytes sample#hit-rate=1 sample#evicted-keys=0

2022-02-03T12:17:58.704384+00:00 app[api]: Starting process with command `otree resetdb --noinput` by user h....@uva.nl

2022-02-03T12:18:02.461177+00:00 heroku[run.2325]: Starting process with command `otree resetdb --noinput`

2022-02-03T12:18:03.720529+00:00 heroku[run.2325]: State changed from starting to up

2022-02-03T12:18:04.272833+00:00 app[run.2325]: Traceback (most recent call last):

2022-02-03T12:18:04.272850+00:00 app[run.2325]: File "/app/.heroku/python/lib/python3.9/site-packages/otree/database.py", line 268, in init_orm

2022-02-03T12:18:04.272850+00:00 app[run.2325]: models = get_models_module(app)

2022-02-03T12:18:04.272850+00:00 app[run.2325]: File "/app/.heroku/python/lib/python3.9/site-packages/otree/common.py", line 75, in get_models_module

2022-02-03T12:18:04.272850+00:00 app[run.2325]: return import_module(module_name)

2022-02-03T12:18:04.272851+00:00 app[run.2325]: File "/app/.heroku/python/lib/python3.9/importlib/__init__.py", line 127, in import_module

2022-02-03T12:18:04.272851+00:00 app[run.2325]: return _bootstrap._gcd_import(name[level:], package, level)

2022-02-03T12:18:04.272852+00:00 app[run.2325]: File "<frozen importlib._bootstrap>", line 1030, in _gcd_import

2022-02-03T12:18:04.272854+00:00 app[run.2325]: File "<frozen importlib._bootstrap>", line 1007, in _find_and_load

2022-02-03T12:18:04.272890+00:00 app[run.2325]: File "<frozen importlib._bootstrap>", line 986, in _find_and_load_unlocked

2022-02-03T12:18:04.272891+00:00 app[run.2325]: File "<frozen importlib._bootstrap>", line 680, in _load_unlocked

2022-02-03T12:18:04.272891+00:00 app[run.2325]: File "<frozen importlib._bootstrap_external>", line 850, in exec_module

2022-02-03T12:18:04.272891+00:00 app[run.2325]: File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed

2022-02-03T12:18:04.272892+00:00 app[run.2325]: File "/app/barg_three/models.py", line 6, in <module>

2022-02-03T12:18:04.272892+00:00 app[run.2325]: import numpy as np

2022-02-03T12:18:04.272908+00:00 app[run.2325]: ModuleNotFoundError: No module named 'numpy'

2022-02-03T12:18:04.477454+00:00 heroku[run.2325]: Process exited with status 1

2022-02-03T12:18:04.587382+00:00 heroku[run.2325]: State changed from up to complete

2022-02-03T12:19:50.000000+00:00 app[heroku-redis]: source=REDIS addon=redis-parallel-63615 sample#active-connections=1 sample#load-avg-1m=0.025 sample#load-avg-5m=0.035 sample#load-avg-15m=0.01 sample#read-iops=0 sample#write-iops=16.39 sample#memory-total=15619148kB sample#memory-free=8661288kB sample#memory-cached=4722152kB sample#memory-redis=1716776bytes sample#hit-rate=1 sample#evicted-keys=0

2022-02-03T12:20:22.000000+00:00 app[heroku-postgres]: source=DATABASE addon=postgresql-acute-84093 sample#current_transaction=945 sample#db_size=11547183bytes sample#tables=31 sample#active-connections=11 sample#waiting-connections=0 sample#index-cache-hit-rate=0.95507 sample#table-cache-hit-rate=0.97283 sample#load-avg-1m=0.015 sample#load-avg-5m=0.01 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.090498 sample#tmp-disk-used=542765056 sample#tmp-disk-available=72436027392 sample#memory-total=4018284kB sample#memory-free=136212kB sample#memory-cached=3377240kB sample#memory-postgres=25268kB sample#wal-percentage-used=0.06477715638082764

2022-02-03T12:21:31.839712+00:00 heroku[router]: at=error code=H10 desc="App crashed" method=GET path="/" host=bargaining-experiment.herokuapp.com request_id=ffb33035-33d7-4af5-8273-f4ced7e18e77 fwd="31.151.137.126" dyno= connect= service= status=503 bytes= protocol=https

2022-02-03T12:22:31.000000+00:00 app[heroku-postgres]: source=DATABASE addon=postgresql-acute-84093 sample#current_transaction=945 sample#db_size=11547183bytes sample#tables=31 sample#active-connections=11 sample#waiting-connections=0 sample#index-cache-hit-rate=0.95507 sample#table-cache-hit-rate=0.97283 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.079439 sample#tmp-disk-used=542765056 sample#tmp-disk-available=72436027392 sample#memory-total=4018284kB sample#memory-free=137864kB sample#memory-cached=3377424kB sample#memory-postgres=22304kB sample#wal-percentage-used=0.06477715638082764

2022-02-03T12:24:14.000000+00:00 app[heroku-redis]: source=REDIS addon=redis-parallel-63615 sample#active-connections=1 sample#load-avg-1m=0.04 sample#load-avg-5m=0.045 sample#load-avg-15m=0.015 sample#read-iops=0 sample#write-iops=16.255 sample#memory-total=15619148kB sample#memory-free=8656760kB sample#memory-cached=4727532kB sample#memory-redis=1716776bytes sample#hit-rate=1 sample#evicted-keys=0

2022-02-03T12:26:50.000000+00:00 app[heroku-postgres]: source=DATABASE addon=postgresql-acute-84093 sample#current_transaction=945 sample#db_size=11547183bytes sample#tables=31 sample#active-connections=11 sample#waiting-connections=0 sample#index-cache-hit-rate=0.95507 sample#table-cache-hit-rate=0.97283 sample#load-avg-1m=0.035 sample#load-avg-5m=0.01 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.078189 sample#tmp-disk-used=542765056 sample#tmp-disk-available=72436027392 sample#memory-total=4018284kB sample#memory-free=137664kB sample#memory-cached=3377728kB sample#memory-postgres=22304kB sample#wal-percentage-used=0.06477715638082764

2022-02-03T12:27:44.000000+00:00 app[heroku-redis]: source=REDIS addon=redis-parallel-63615 sample#active-connections=1 sample#load-avg-1m=0.045 sample#load-avg-5m=0.04 sample#load-avg-15m=0.015 sample#read-iops=0 sample#write-iops=16.565 sample#memory-total=15619148kB sample#memory-free=8653004kB sample#memory-cached=4731624kB sample#memory-redis=1716776bytes sample#hit-rate=1 sample#evicted-keys=0

[Chris @ oTree]

Put numpy in your requirements.txt

Sent from my phone

On Feb 3, 2022, at 8:34 PM, Natalie Lee <natalie...@gmail.com> wrote:

Hi Chris, 

--
You received this message because you are subscribed to the Google Groups "oTree help & discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to otree+un...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/otree/1cb7b605-6ca3-45af-81d5-fd9f63a93bfdn%40googlegroups.com.

[Natalie Lee]

It worked. Thank you!

Best,

Natalie