[Bug]: New Installation Script - `Failed: Update database`

[SerKnight]

Describe the bug

Hello - excited to get this running, but having a database/alembic issue on a fresh installation.

During alembic upgrade head stage in both the scripted and manual install I get:

/bin/bash: line 29: 20315 Killed: 9               $1
+ echo 'Failed: Update database'
Failed: Update database

Note that this is a brand new computer so might not have some sqlite dependency I need? However, I'm able to create db's fine outside of script 🤷

$ python --version          
Python 3.10.11

$ sqlite3 --version
3.39.5 2022-10-14 20:58:05 554764a6e721fab307c63a4f98cd958c8428a5d9d8edfde951858d6fd02daapl

To Reproduce

Pre-reqs

• macOS Sonoma [14.1] - M3 36gb
• Had git installed
• Also installed tesseract (but I don't think its related)

Full stack trace

• https://gist.github.com/SerKnight/f8f12d69b8dfbbded9b7966ea3d03c31

/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/OpenAdaptAI/OpenAdapt/HEAD/install/install_openadapt.sh)"
...
Success: Clone git repo
Success: Install Poetry
Success: Install Python dependencies
...
+ RunAndCheck 'poetry run alembic upgrade head' 'Update database'
+ poetry run alembic upgrade head

2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - STOP_STRS=['oa.stop']
2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - SPECIAL_CHAR_STOP_SEQUENCES=[['ctrl', 'ctrl', 'ctrl']]
2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - STOP_SEQUENCES=[['o', 'a', '.', 's', 't', 'o', 'p'], ['ctrl', 'ctrl', 'ctrl']]
2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - ENV_FILE_PATH=.env
2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - CACHE_DIR_PATH=.cache
2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - CACHE_ENABLED=True
2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - CACHE_VERBOSITY=0
2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - DB_ECHO=False
2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - DB_FNAME=openadapt.db
2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - ERROR_REPORTING_ENABLED=True
2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - ERROR_REPORTING_DSN=https://[email protected]/3798
2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - ERROR_REPORTING_BRANCH=main
2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - OPENAI_API_KEY=<set your api key in .env>
2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - OPENAI_MODEL_NAME=gpt-3.5-turbo
2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - RECORD_READ_ACTIVE_ELEMENT_STATE=False
2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - REPLAY_STRIP_ELEMENT_STATE=True
2023-12-09 04:01:15.913 | INFO     | openadapt.config:<module>:233 - IGNORE_WARNINGS=False
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - MAX_NUM_WARNINGS_PER_SECOND=5
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - WARNING_SUPPRESSION_PERIOD=1
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - MESSAGES_TO_FILTER=['Cannot pickle Objective-C objects']
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - ACTION_TEXT_SEP=-
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - ACTION_TEXT_NAME_PREFIX=<
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - ACTION_TEXT_NAME_SUFFIX=>
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - PLOT_PERFORMANCE=True
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - CAPTURE_DIR_PATH=captures
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - APP_DARK_MODE=False
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - SCRUB_ENABLED=False
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - SCRUB_CHAR=*
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - SCRUB_LANGUAGE=en
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - SCRUB_FILL_COLOR=255
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - SCRUB_CONFIG_TRF={'nlp_engine_name': 'spacy', 'models': [{'lang_code': 'en', 'model_name': 'en_core_web_trf'}]}
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - SCRUB_PRESIDIO_IGNORE_ENTITIES=[]
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - SCRUB_KEYS_HTML=['text', 'canonical_text', 'title', 'state', 'task_description', 'key_char', 'canonical_key_char', 'key_vk', 'children']
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - VISUALIZE_DARK_MODE=False
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - VISUALIZE_RUN_NATIVELY=True
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - VISUALIZE_DENSE_TREES=True
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - VISUALIZE_ANIMATIONS=True
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - VISUALIZE_EXPAND_ALL=False
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - VISUALIZE_MAX_TABLE_CHILDREN=10
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - SAVE_SCREENSHOT_DIFF=False
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - SPACY_MODEL_NAME=en_core_web_trf
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - PRIVATE_AI_API_KEY=<set your api key in .env>
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - ROOT_DIRPATH=/Users/christopherknight/code/personal/OpenAdapt
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - DB_FPATH=/Users/christopherknight/code/personal/OpenAdapt/openadapt.db
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - DB_URL=sqlite:////Users/christopherknight/code/personal/OpenAdapt/openadapt.db
2023-12-09 04:01:15.914 | INFO     | openadapt.config:<module>:233 - DIRNAME_PERFORMANCE_PLOTS=performance
2023-12-09 04:01:15.916 | INFO     | openadapt.config:<module>:237 - active_branch_name='main'
2023-12-09 04:01:15.916 | INFO     | openadapt.config:<module>:239 - is_reporting_branch=True
DB_URL=sqlite:////Users/christopherknight/code/personal/OpenAdapt/openadapt.db
INFO  [alembic.runtime.migration] Context impl SQLiteImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
/bin/bash: line 29: 21305 Killed: 9               $1
+ echo 'Failed: Update database'
Failed: Update database
+ Cleanup
+ '[' -d ../OpenAdapt ']'
+ cd ..
+ rm -rf OpenAdapt
+ echo 'Deleted OpenAdapt directory'
Deleted OpenAdapt directory
+ exit 1