pi@raspberrypi:~/Mycodo/databases $ sudo bash ../mycodo/scripts/upgrade_post.sh #### Running initialization #### Creating mycodo user useradd: user 'mycodo' already exists The user `mycodo' is already a member of `adm'. The user `mycodo' is already a member of `dialout'. The user `mycodo' is already a member of `gpio'. The user `mycodo' is already a member of `i2c'. The user `mycodo' is already a member of `kmem'. The user `mycodo' is already a member of `video'. The user `pi' is already a member of `mycodo'. The user `mycodo' is already a member of `pi'. #### Compiling mycodo_wrapper #### Creating symlinks to Mycodo executables #### Creating files and directories #### Setting permissions #### Checking if swap size is 100 MB and needs to be changed to 512 MB #### Swap not currently set to 100 MB. Not changing. #### Checking python 3 virtualenv #### Virtualenv already exists, skipping creation #### Updating apt repositories Hit:1 http://archive.raspberrypi.org/debian buster InRelease Hit:2 http://raspbian.raspberrypi.org/raspbian buster InRelease Reading package lists... Done #### Installing prerequisite apt packages and update pip Reading package lists... Done Building dependency tree Reading state information... Done Package 'apache2' is not installed, so not removed Package 'python-cffi-backend' is not installed, so not removed Package 'python3-cffi-backend' is not installed, so not removed The following packages were automatically installed and are no longer required: libjs-sphinxdoc libjs-underscore libpython-all-dev python-all python-all-dev python-asn1crypto python-configparser python-cookies python-crypto python-dbus python-entrypoints python-enum34 python-funcsigs python-jwt python-keyrings.alt python-mock python-pbr python-responses python-wheel python-xdg python3-asn1crypto python3-cookies python3-entrypoints python3-jwt python3-responses Use 'sudo apt autoremove' to remove them. 0 upgraded, 0 newly installed, 0 to remove and 104 not upgraded. Reading package lists... Done Building dependency tree Reading state information... Done g++ is already the newest version (4:8.3.0-1+rpi2). gawk is already the newest version (1:4.2.1+dfsg-1). gcc is already the newest version (4:8.3.0-1+rpi2). git is already the newest version (1:2.20.1-2+deb10u3). libffi-dev is already the newest version (3.2.1-9). libi2c-dev is already the newest version (4.1-1). logrotate is already the newest version (3.14.0-4). moreutils is already the newest version (0.62-1+b1). nginx is already the newest version (1.14.2-2+deb10u3). python3 is already the newest version (3.7.3-1). python3-dev is already the newest version (3.7.3-1). python3-pylint-common is already the newest version (0.2.5-2). python3-setuptools is already the newest version (40.8.0-1). python3-smbus is already the newest version (4.1-1). rng-tools is already the newest version (2-unofficial-mt.14-1). sqlite3 is already the newest version (3.27.2-3+deb10u1). wget is already the newest version (1.20.1-1.1). The following packages were automatically installed and are no longer required: libjs-sphinxdoc libjs-underscore libpython-all-dev python-all python-all-dev python-asn1crypto python-configparser python-cookies python-crypto python-dbus python-entrypoints python-enum34 python-funcsigs python-jwt python-keyrings.alt python-mock python-pbr python-responses python-wheel python-xdg python3-asn1crypto python3-cookies python3-entrypoints python3-jwt python3-responses Use 'sudo apt autoremove' to remove them. 0 upgraded, 0 newly installed, 0 to remove and 104 not upgraded. Searching for pip Best match: pip 21.1.2 Adding pip 21.1.2 to easy-install.pth file Installing pip script to /usr/local/bin Installing pip3 script to /usr/local/bin Installing pip3.8 script to /usr/local/bin Using /usr/local/lib/python3.7/dist-packages Processing dependencies for pip Finished processing dependencies for pip Looking in indexes: https://pypi.org/simple, https://www.piwheels.org/simple Requirement already satisfied: pip in /usr/local/lib/python3.7/dist-packages (21.1.2) WARNING: Running pip as root will break packages and permissions. You should install packages reliably by using venv: https://pip.pypa.io/warnings/venv #### Installing and configuring nginx web server Removed /etc/systemd/system/multi-user.target.wants/mycodoflask.service. Removed /etc/systemd/system/mycodoflask.service. Synchronizing state of nginx.service with SysV service script with /lib/systemd/systemd-sysv-install. Executing: /lib/systemd/systemd-sysv-install enable nginx Created symlink /etc/systemd/system/multi-user.target.wants/mycodoflask.service → /home/pi/Mycodo/install/mycodoflask.service. Created symlink /etc/systemd/system/mycodoflask.service → /home/pi/Mycodo/install/mycodoflask.service. #### Installing logrotate scripts Mycodo logrotate script installed #### Updating pip Looking in indexes: https://pypi.org/simple, https://www.piwheels.org/simple Requirement already satisfied: pip in ./env/lib/python3.7/site-packages (21.1.2) #### Installing pip requirements Looking in indexes: https://pypi.org/simple, https://www.piwheels.org/simple Requirement already satisfied: pip in ./env/lib/python3.7/site-packages (21.1.2) Requirement already satisfied: setuptools in ./env/lib/python3.7/site-packages (56.0.0) WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ProtocolError('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))': /simple/setuptools/ Collecting setuptools Using cached setuptools-57.0.0-py3-none-any.whl (821 kB) Installing collected packages: setuptools Attempting uninstall: setuptools Found existing installation: setuptools 56.0.0 Uninstalling setuptools-56.0.0: Successfully uninstalled setuptools-56.0.0 Successfully installed setuptools-57.0.0 Looking in indexes: https://pypi.org/simple, https://www.piwheels.org/simple Requirement already satisfied: alembic==1.5.8 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 2)) (1.5.8) Collecting argparse==1.4.0 Using cached https://www.piwheels.org/simple/argparse/argparse-1.4.0-py2.py3-none-any.whl (23 kB) Requirement already satisfied: bcrypt==3.2.0 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 4)) (3.2.0) Requirement already satisfied: daemonize==2.5.0 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 5)) (2.5.0) Requirement already satisfied: distro==1.5.0 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 6)) (1.5.0) Requirement already satisfied: email_validator==1.1.2 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 7)) (1.1.2) Requirement already satisfied: filelock==3.0.12 in /usr/local/lib/python3.7/dist-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 8)) (3.0.12) Requirement already satisfied: Flask==1.1.2 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 9)) (1.1.2) Requirement already satisfied: Flask_Accept==0.0.6 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 10)) (0.0.6) Requirement already satisfied: Flask_Babel==2.0.0 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 11)) (2.0.0) Requirement already satisfied: Flask_Compress==1.9.0 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 12)) (1.9.0) Requirement already satisfied: Flask_Limiter==1.4 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 13)) (1.4) Requirement already satisfied: Flask_Login==0.5.0 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 14)) (0.5.0) Requirement already satisfied: Flask_Marshmallow==0.14.0 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 15)) (0.14.0) Requirement already satisfied: Flask_RESTX==0.3.0 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 17)) (0.3.0) Requirement already satisfied: Flask_SQLAlchemy==2.5.1 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 18)) (2.5.1) Requirement already satisfied: Flask_Talisman==0.7.0 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 19)) (0.7.0) Requirement already satisfied: Flask_WTF==0.14.3 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 20)) (0.14.3) Requirement already satisfied: geocoder==1.38.1 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 21)) (1.38.1) Requirement already satisfied: gunicorn==20.1.0 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 22)) (20.1.0) Requirement already satisfied: influxdb==5.3.1 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 23)) (5.3.1) Requirement already satisfied: marshmallow_sqlalchemy==0.24.2 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 24)) (0.24.2) Requirement already satisfied: pyro5==5.12 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 25)) (5.12) Requirement already satisfied: pyserial==3.5 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 26)) (3.5) Requirement already satisfied: python-dateutil==2.8.1 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 27)) (2.8.1) Requirement already satisfied: requests==2.25.1 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 28)) (2.25.1) Collecting setuptools==56.0.0 Using cached https://www.piwheels.org/simple/setuptools/setuptools-56.0.0-py3-none-any.whl (784 kB) Requirement already satisfied: SQLAlchemy==1.4.7 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 30)) (1.4.7) Requirement already satisfied: Werkzeug==1.0.1 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 31)) (1.0.1) Requirement already satisfied: WTForms==2.3.3 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements.txt (line 32)) (2.3.3) Requirement already satisfied: Mako in ./env/lib/python3.7/site-packages (from alembic==1.5.8->-r /home/pi/Mycodo/install/requirements.txt (line 2)) (1.1.4) Requirement already satisfied: python-editor>=0.3 in ./env/lib/python3.7/site-packages (from alembic==1.5.8->-r /home/pi/Mycodo/install/requirements.txt (line 2)) (1.0.4) Requirement already satisfied: cffi>=1.1 in ./env/lib/python3.7/site-packages (from bcrypt==3.2.0->-r /home/pi/Mycodo/install/requirements.txt (line 4)) (1.14.5) Requirement already satisfied: six>=1.4.1 in /usr/lib/python3/dist-packages (from bcrypt==3.2.0->-r /home/pi/Mycodo/install/requirements.txt (line 4)) (1.12.0) Requirement already satisfied: dnspython>=1.15.0 in ./env/lib/python3.7/site-packages (from email_validator==1.1.2->-r /home/pi/Mycodo/install/requirements.txt (line 7)) (2.1.0) Requirement already satisfied: idna>=2.0.0 in /usr/lib/python3/dist-packages (from email_validator==1.1.2->-r /home/pi/Mycodo/install/requirements.txt (line 7)) (2.6) Requirement already satisfied: Jinja2>=2.10.1 in ./env/lib/python3.7/site-packages (from Flask==1.1.2->-r /home/pi/Mycodo/install/requirements.txt (line 9)) (3.0.1) Requirement already satisfied: itsdangerous>=0.24 in /usr/lib/python3/dist-packages (from Flask==1.1.2->-r /home/pi/Mycodo/install/requirements.txt (line 9)) (0.24) Requirement already satisfied: click>=5.1 in /usr/lib/python3/dist-packages (from Flask==1.1.2->-r /home/pi/Mycodo/install/requirements.txt (line 9)) (7.0) Requirement already satisfied: Babel>=2.3 in ./env/lib/python3.7/site-packages (from Flask_Babel==2.0.0->-r /home/pi/Mycodo/install/requirements.txt (line 11)) (2.9.1) Requirement already satisfied: pytz in ./env/lib/python3.7/site-packages (from Flask_Babel==2.0.0->-r /home/pi/Mycodo/install/requirements.txt (line 11)) (2021.1) Requirement already satisfied: brotli in ./env/lib/python3.7/site-packages (from Flask_Compress==1.9.0->-r /home/pi/Mycodo/install/requirements.txt (line 12)) (1.0.9) Requirement already satisfied: limits in ./env/lib/python3.7/site-packages (from Flask_Limiter==1.4->-r /home/pi/Mycodo/install/requirements.txt (line 13)) (1.5.1) Requirement already satisfied: marshmallow>=2.0.0 in ./env/lib/python3.7/site-packages (from Flask_Marshmallow==0.14.0->-r /home/pi/Mycodo/install/requirements.txt (line 15)) (3.12.1) Requirement already satisfied: aniso8601>=0.82 in ./env/lib/python3.7/site-packages (from Flask_RESTX==0.3.0->-r /home/pi/Mycodo/install/requirements.txt (line 17)) (9.0.1) Requirement already satisfied: jsonschema in ./env/lib/python3.7/site-packages (from Flask_RESTX==0.3.0->-r /home/pi/Mycodo/install/requirements.txt (line 17)) (3.2.0) Requirement already satisfied: future in ./env/lib/python3.7/site-packages (from geocoder==1.38.1->-r /home/pi/Mycodo/install/requirements.txt (line 21)) (0.18.2) Requirement already satisfied: ratelim in ./env/lib/python3.7/site-packages (from geocoder==1.38.1->-r /home/pi/Mycodo/install/requirements.txt (line 21)) (0.1.6) Requirement already satisfied: msgpack in ./env/lib/python3.7/site-packages (from influxdb==5.3.1->-r /home/pi/Mycodo/install/requirements.txt (line 23)) (1.0.2) Requirement already satisfied: serpent>=1.27 in ./env/lib/python3.7/site-packages (from pyro5==5.12->-r /home/pi/Mycodo/install/requirements.txt (line 25)) (1.40) Requirement already satisfied: certifi>=2017.4.17 in /usr/lib/python3/dist-packages (from requests==2.25.1->-r /home/pi/Mycodo/install/requirements.txt (line 28)) (2018.8.24) Requirement already satisfied: urllib3<1.27,>=1.21.1 in /usr/lib/python3/dist-packages (from requests==2.25.1->-r /home/pi/Mycodo/install/requirements.txt (line 28)) (1.24.1) Requirement already satisfied: chardet<5,>=3.0.2 in /usr/lib/python3/dist-packages (from requests==2.25.1->-r /home/pi/Mycodo/install/requirements.txt (line 28)) (3.0.4) Requirement already satisfied: greenlet!=0.4.17 in ./env/lib/python3.7/site-packages (from SQLAlchemy==1.4.7->-r /home/pi/Mycodo/install/requirements.txt (line 30)) (1.1.0) Requirement already satisfied: importlib-metadata in /usr/local/lib/python3.7/dist-packages (from SQLAlchemy==1.4.7->-r /home/pi/Mycodo/install/requirements.txt (line 30)) (4.0.1) Requirement already satisfied: MarkupSafe in ./env/lib/python3.7/site-packages (from WTForms==2.3.3->-r /home/pi/Mycodo/install/requirements.txt (line 32)) (2.0.1) Requirement already satisfied: pycparser in ./env/lib/python3.7/site-packages (from cffi>=1.1->bcrypt==3.2.0->-r /home/pi/Mycodo/install/requirements.txt (line 4)) (2.20) Requirement already satisfied: zipp>=0.5 in /usr/local/lib/python3.7/dist-packages (from importlib-metadata->SQLAlchemy==1.4.7->-r /home/pi/Mycodo/install/requirements.txt (line 30)) (3.4.1) Requirement already satisfied: typing-extensions>=3.6.4 in /usr/local/lib/python3.7/dist-packages (from importlib-metadata->SQLAlchemy==1.4.7->-r /home/pi/Mycodo/install/requirements.txt (line 30)) (3.10.0.0) Requirement already satisfied: pyrsistent>=0.14.0 in ./env/lib/python3.7/site-packages (from jsonschema->Flask_RESTX==0.3.0->-r /home/pi/Mycodo/install/requirements.txt (line 17)) (0.17.3) Requirement already satisfied: attrs>=17.4.0 in ./env/lib/python3.7/site-packages (from jsonschema->Flask_RESTX==0.3.0->-r /home/pi/Mycodo/install/requirements.txt (line 17)) (21.2.0) Requirement already satisfied: decorator in ./env/lib/python3.7/site-packages (from ratelim->geocoder==1.38.1->-r /home/pi/Mycodo/install/requirements.txt (line 21)) (5.0.9) Installing collected packages: setuptools, argparse Attempting uninstall: setuptools Found existing installation: setuptools 57.0.0 Uninstalling setuptools-57.0.0: Successfully uninstalled setuptools-57.0.0 Successfully installed argparse-1.4.0 setuptools-56.0.0 Looking in indexes: https://pypi.org/simple, https://www.piwheels.org/simple Requirement already satisfied: pylibftdi==0.19.0 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements-rpi.txt (line 2)) (0.19.0) Requirement already satisfied: RPi.GPIO in /usr/lib/python3/dist-packages (from -r /home/pi/Mycodo/install/requirements-rpi.txt (line 3)) (0.7.0) Requirement already satisfied: smbus2==0.4.1 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements-rpi.txt (line 4)) (0.4.1) Looking in indexes: https://pypi.org/simple, https://www.piwheels.org/simple Requirement already satisfied: testfixtures==6.17.1 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements-testing.txt (line 2)) (6.17.1) Requirement already satisfied: mock==4.0.3 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements-testing.txt (line 3)) (4.0.3) Requirement already satisfied: pytest==6.2.3 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements-testing.txt (line 4)) (6.2.3) Requirement already satisfied: factory_boy==3.2.0 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements-testing.txt (line 5)) (3.2.0) Requirement already satisfied: webtest==2.0.35 in ./env/lib/python3.7/site-packages (from -r /home/pi/Mycodo/install/requirements-testing.txt (line 6)) (2.0.35) Requirement already satisfied: iniconfig in ./env/lib/python3.7/site-packages (from pytest==6.2.3->-r /home/pi/Mycodo/install/requirements-testing.txt (line 4)) (1.1.1) Requirement already satisfied: py>=1.8.2 in ./env/lib/python3.7/site-packages (from pytest==6.2.3->-r /home/pi/Mycodo/install/requirements-testing.txt (line 4)) (1.10.0) Requirement already satisfied: attrs>=19.2.0 in ./env/lib/python3.7/site-packages (from pytest==6.2.3->-r /home/pi/Mycodo/install/requirements-testing.txt (line 4)) (21.2.0) Requirement already satisfied: packaging in ./env/lib/python3.7/site-packages (from pytest==6.2.3->-r /home/pi/Mycodo/install/requirements-testing.txt (line 4)) (20.9) Requirement already satisfied: toml in ./env/lib/python3.7/site-packages (from pytest==6.2.3->-r /home/pi/Mycodo/install/requirements-testing.txt (line 4)) (0.10.2) Requirement already satisfied: pluggy<1.0.0a1,>=0.12 in ./env/lib/python3.7/site-packages (from pytest==6.2.3->-r /home/pi/Mycodo/install/requirements-testing.txt (line 4)) (0.13.1) Requirement already satisfied: importlib-metadata>=0.12 in /usr/local/lib/python3.7/dist-packages (from pytest==6.2.3->-r /home/pi/Mycodo/install/requirements-testing.txt (line 4)) (4.0.1) Requirement already satisfied: Faker>=0.7.0 in ./env/lib/python3.7/site-packages (from factory_boy==3.2.0->-r /home/pi/Mycodo/install/requirements-testing.txt (line 5)) (8.2.1) Requirement already satisfied: six in /usr/lib/python3/dist-packages (from webtest==2.0.35->-r /home/pi/Mycodo/install/requirements-testing.txt (line 6)) (1.12.0) Requirement already satisfied: waitress>=0.8.5 in ./env/lib/python3.7/site-packages (from webtest==2.0.35->-r /home/pi/Mycodo/install/requirements-testing.txt (line 6)) (2.0.0) Requirement already satisfied: WebOb>=1.2 in ./env/lib/python3.7/site-packages (from webtest==2.0.35->-r /home/pi/Mycodo/install/requirements-testing.txt (line 6)) (1.8.7) Requirement already satisfied: beautifulsoup4 in /usr/lib/python3/dist-packages (from webtest==2.0.35->-r /home/pi/Mycodo/install/requirements-testing.txt (line 6)) (4.7.1) Requirement already satisfied: text-unidecode==1.3 in ./env/lib/python3.7/site-packages (from Faker>=0.7.0->factory_boy==3.2.0->-r /home/pi/Mycodo/install/requirements-testing.txt (line 5)) (1.3) Requirement already satisfied: python-dateutil>=2.4 in ./env/lib/python3.7/site-packages (from Faker>=0.7.0->factory_boy==3.2.0->-r /home/pi/Mycodo/install/requirements-testing.txt (line 5)) (2.8.1) Requirement already satisfied: typing-extensions>=3.6.4 in /usr/local/lib/python3.7/dist-packages (from importlib-metadata>=0.12->pytest==6.2.3->-r /home/pi/Mycodo/install/requirements-testing.txt (line 4)) (3.10.0.0) Requirement already satisfied: zipp>=0.5 in /usr/local/lib/python3.7/dist-packages (from importlib-metadata>=0.12->pytest==6.2.3->-r /home/pi/Mycodo/install/requirements-testing.txt (line 4)) (3.4.1) Requirement already satisfied: pyparsing>=2.0.2 in ./env/lib/python3.7/site-packages (from packaging->pytest==6.2.3->-r /home/pi/Mycodo/install/requirements-testing.txt (line 4)) (2.4.7) #### Ensuring compatible version of influxdb is installed #### Correct version of InfluxDB currently installed #### Upgrading Mycodo database with alembic (if needed) INFO [alembic.runtime.migration] Context impl SQLiteImpl. INFO [alembic.runtime.migration] Will assume non-transactional DDL. INFO [alembic.runtime.migration] Running upgrade f5b77ef5f17c -> 61a0d0568d24, Add password reset capabilities Traceback (most recent call last): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: duplicate column name: password_reset_code The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/pi/Mycodo/env/bin/alembic", line 8, in sys.exit(main()) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/config.py", line 559, in main CommandLine(prog=prog).main(argv=argv) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/config.py", line 553, in main self.run_cmd(cfg, options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/config.py", line 533, in run_cmd **dict((k, getattr(options, k, None)) for k in kwarg) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/command.py", line 294, in upgrade script.run_env() File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/script/base.py", line 490, in run_env util.load_python_file(self.dir, "env.py") File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/util/pyfiles.py", line 97, in load_python_file module = load_module_py(module_id, path) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/util/compat.py", line 182, in load_module_py spec.loader.exec_module(module) File "", line 728, in exec_module File "", line 219, in _call_with_frames_removed File "alembic/env.py", line 69, in run_migrations_online() File "alembic/env.py", line 64, in run_migrations_online context.run_migrations() File "", line 8, in run_migrations File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/runtime/environment.py", line 813, in run_migrations self.get_context().run_migrations(**kw) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/runtime/migration.py", line 560, in run_migrations step.migration_fn(**kw) File "/home/pi/Mycodo/databases/alembic/versions/61a0d0568d24_add_password_reset_capabilities.py", line 29, in upgrade batch_op.add_column(sa.Column('password_reset_last_request', sa.DateTime)) File "/usr/lib/python3.7/contextlib.py", line 119, in __exit__ next(self.gen) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/operations/base.py", line 336, in batch_alter_table impl.flush() File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/operations/batch.py", line 86, in flush fn(*arg, **kw) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/ddl/impl.py", line 256, in add_column self._exec(base.AddColumn(table_name, column, schema=schema)) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/alembic/ddl/impl.py", line 146, in _exec return conn.execute(construct, multiparams) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1200, in execute return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 78, in _execute_on_connection self, multiparams, params, execution_options File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1296, in _execute_ddl compiled, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1749, in _execute_context e, statement, parameters, cursor, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1930, in _handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2], from_=e File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column name: password_reset_code [SQL: ALTER TABLE users ADD COLUMN password_reset_code TEXT] (Background on this error at: http://sqlalche.me/e/14/e3q8) #### Executing post-alembic script Found revision IDs to execute code: ['f5b77ef5f17c', '61a0d0568d24', '61a0d0568d24'] Revision ID f5b77ef5f17c Executing post-alembic code for revision f5b77ef5f17c Revision ID 61a0d0568d24 Executing post-alembic code for revision 61a0d0568d24 Error raised in session_scope. Session will be rolled back: db_uri='sqlite:////home/pi/Mycodo/databases/mycodo.db', error='(sqlite3.OperationalError) no such column: roles.reset_password [SQL: SELECT roles.id AS roles_id, roles.unique_id AS roles_unique_id, roles.name AS roles_name, roles.edit_settings AS roles_edit_settings, roles.edit_controllers AS roles_edit_controllers, roles.edit_users AS roles_edit_users, roles.view_settings AS roles_view_settings, roles.view_camera AS roles_view_camera, roles.view_stats AS roles_view_stats, roles.view_logs AS roles_view_logs, roles.reset_password AS roles_reset_password FROM roles] (Background on this error at: http://sqlalche.me/e/14/e3q8)' Traceback (most recent call last): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such column: roles.reset_password The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/pi/Mycodo/mycodo/databases/utils.py", line 26, in session_scope yield session File "/home/pi/Mycodo/databases/alembic_post.py", line 750, in for role in session.query(Role).all(): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2685, in all return self._iter().all() File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2823, in _iter execution_options={"_sa_orm_load_options": self.load_options}, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1670, in execute result = conn._execute_20(statement, params or {}, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1520, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 314, in _execute_on_connection self, multiparams, params, execution_options File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1399, in _execute_clauseelement cache_hit=cache_hit, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1749, in _execute_context e, statement, parameters, cursor, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1930, in _handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2], from_=e File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: roles.reset_password [SQL: SELECT roles.id AS roles_id, roles.unique_id AS roles_unique_id, roles.name AS roles_name, roles.edit_settings AS roles_edit_settings, roles.edit_controllers AS roles_edit_controllers, roles.edit_users AS roles_edit_users, roles.view_settings AS roles_view_settings, roles.view_camera AS roles_view_camera, roles.view_stats AS roles_view_stats, roles.view_logs AS roles_view_logs, roles.reset_password AS roles_reset_password FROM roles] (Background on this error at: http://sqlalche.me/e/14/e3q8) ERROR: post-alembic revision 61a0d0568d24: Traceback (most recent call last): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such column: roles.reset_password The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/pi/Mycodo/databases/alembic_post.py", line 750, in for role in session.query(Role).all(): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2685, in all return self._iter().all() File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2823, in _iter execution_options={"_sa_orm_load_options": self.load_options}, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1670, in execute result = conn._execute_20(statement, params or {}, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1520, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 314, in _execute_on_connection self, multiparams, params, execution_options File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1399, in _execute_clauseelement cache_hit=cache_hit, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1749, in _execute_context e, statement, parameters, cursor, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1930, in _handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2], from_=e File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: roles.reset_password [SQL: SELECT roles.id AS roles_id, roles.unique_id AS roles_unique_id, roles.name AS roles_name, roles.edit_settings AS roles_edit_settings, roles.edit_controllers AS roles_edit_controllers, roles.edit_users AS roles_edit_users, roles.view_settings AS roles_view_settings, roles.view_camera AS roles_view_camera, roles.view_stats AS roles_view_stats, roles.view_logs AS roles_view_logs, roles.reset_password AS roles_reset_password FROM roles] (Background on this error at: http://sqlalche.me/e/14/e3q8) Revision ID 61a0d0568d24 Executing post-alembic code for revision 61a0d0568d24 Error raised in session_scope. Session will be rolled back: db_uri='sqlite:////home/pi/Mycodo/databases/mycodo.db', error='(sqlite3.OperationalError) no such column: roles.reset_password [SQL: SELECT roles.id AS roles_id, roles.unique_id AS roles_unique_id, roles.name AS roles_name, roles.edit_settings AS roles_edit_settings, roles.edit_controllers AS roles_edit_controllers, roles.edit_users AS roles_edit_users, roles.view_settings AS roles_view_settings, roles.view_camera AS roles_view_camera, roles.view_stats AS roles_view_stats, roles.view_logs AS roles_view_logs, roles.reset_password AS roles_reset_password FROM roles] (Background on this error at: http://sqlalche.me/e/14/e3q8)' Traceback (most recent call last): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such column: roles.reset_password The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/pi/Mycodo/mycodo/databases/utils.py", line 26, in session_scope yield session File "/home/pi/Mycodo/databases/alembic_post.py", line 750, in for role in session.query(Role).all(): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2685, in all return self._iter().all() File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2823, in _iter execution_options={"_sa_orm_load_options": self.load_options}, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1670, in execute result = conn._execute_20(statement, params or {}, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1520, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 314, in _execute_on_connection self, multiparams, params, execution_options File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1399, in _execute_clauseelement cache_hit=cache_hit, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1749, in _execute_context e, statement, parameters, cursor, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1930, in _handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2], from_=e File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: roles.reset_password [SQL: SELECT roles.id AS roles_id, roles.unique_id AS roles_unique_id, roles.name AS roles_name, roles.edit_settings AS roles_edit_settings, roles.edit_controllers AS roles_edit_controllers, roles.edit_users AS roles_edit_users, roles.view_settings AS roles_view_settings, roles.view_camera AS roles_view_camera, roles.view_stats AS roles_view_stats, roles.view_logs AS roles_view_logs, roles.reset_password AS roles_reset_password FROM roles] (Background on this error at: http://sqlalche.me/e/14/e3q8) ERROR: post-alembic revision 61a0d0568d24: Traceback (most recent call last): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such column: roles.reset_password The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/pi/Mycodo/databases/alembic_post.py", line 750, in for role in session.query(Role).all(): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2685, in all return self._iter().all() File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2823, in _iter execution_options={"_sa_orm_load_options": self.load_options}, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1670, in execute result = conn._execute_20(statement, params or {}, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1520, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 314, in _execute_on_connection self, multiparams, params, execution_options File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1399, in _execute_clauseelement cache_hit=cache_hit, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1749, in _execute_context e, statement, parameters, cursor, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1930, in _handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2], from_=e File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: roles.reset_password [SQL: SELECT roles.id AS roles_id, roles.unique_id AS roles_unique_id, roles.name AS roles_name, roles.edit_settings AS roles_edit_settings, roles.edit_controllers AS roles_edit_controllers, roles.edit_users AS roles_edit_users, roles.view_settings AS roles_view_settings, roles.view_camera AS roles_view_camera, roles.view_stats AS roles_view_stats, roles.view_logs AS roles_view_logs, roles.reset_password AS roles_reset_password FROM roles] (Background on this error at: http://sqlalche.me/e/14/e3q8) Completed with errors. Review the entire log for details. Errors recorded: ERROR: ERROR: post-alembic revision 61a0d0568d24: Traceback (most recent call last): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such column: roles.reset_password The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/pi/Mycodo/databases/alembic_post.py", line 750, in for role in session.query(Role).all(): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2685, in all return self._iter().all() File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2823, in _iter execution_options={"_sa_orm_load_options": self.load_options}, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1670, in execute result = conn._execute_20(statement, params or {}, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1520, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 314, in _execute_on_connection self, multiparams, params, execution_options File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1399, in _execute_clauseelement cache_hit=cache_hit, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1749, in _execute_context e, statement, parameters, cursor, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1930, in _handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2], from_=e File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: roles.reset_password [SQL: SELECT roles.id AS roles_id, roles.unique_id AS roles_unique_id, roles.name AS roles_name, roles.edit_settings AS roles_edit_settings, roles.edit_controllers AS roles_edit_controllers, roles.edit_users AS roles_edit_users, roles.view_settings AS roles_view_settings, roles.view_camera AS roles_view_camera, roles.view_stats AS roles_view_stats, roles.view_logs AS roles_view_logs, roles.reset_password AS roles_reset_password FROM roles] (Background on this error at: http://sqlalche.me/e/14/e3q8) ERROR: ERROR: post-alembic revision 61a0d0568d24: Traceback (most recent call last): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such column: roles.reset_password The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/pi/Mycodo/databases/alembic_post.py", line 750, in for role in session.query(Role).all(): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2685, in all return self._iter().all() File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2823, in _iter execution_options={"_sa_orm_load_options": self.load_options}, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1670, in execute result = conn._execute_20(statement, params or {}, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1520, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 314, in _execute_on_connection self, multiparams, params, execution_options File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1399, in _execute_clauseelement cache_hit=cache_hit, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1749, in _execute_context e, statement, parameters, cursor, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1930, in _handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2], from_=e File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: roles.reset_password [SQL: SELECT roles.id AS roles_id, roles.unique_id AS roles_unique_id, roles.name AS roles_name, roles.edit_settings AS roles_edit_settings, roles.edit_controllers AS roles_edit_controllers, roles.edit_users AS roles_edit_users, roles.view_settings AS roles_view_settings, roles.view_camera AS roles_view_camera, roles.view_stats AS roles_view_stats, roles.view_logs AS roles_view_logs, roles.reset_password AS roles_reset_password FROM roles] (Background on this error at: http://sqlalche.me/e/14/e3q8) #### Checking for updates to dependencies Traceback (most recent call last): File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such column: output.log_level_debug The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/pi/Mycodo/mycodo/utils/update_dependencies.py", line 89, in for each_dev in output: File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2813, in __iter__ return self._iter().__iter__() File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2823, in _iter execution_options={"_sa_orm_load_options": self.load_options}, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1670, in execute result = conn._execute_20(statement, params or {}, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1520, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 314, in _execute_on_connection self, multiparams, params, execution_options File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1399, in _execute_clauseelement cache_hit=cache_hit, File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1749, in _execute_context e, statement, parameters, cursor, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1930, in _handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2], from_=e File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context cursor, statement, parameters, context File "/home/pi/Mycodo/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: output.log_level_debug [SQL: SELECT output.id AS output_id, output.unique_id AS output_unique_id, output.output_type AS output_output_type, output.name AS output_name, output.log_level_debug AS output_log_level_debug, output.interface AS output_interface, output.location AS output_location, output.i2c_location AS output_i2c_location, output.i2c_bus AS output_i2c_bus, output.ftdi_location AS output_ftdi_location, output.uart_location AS output_uart_location, output.baud_rate AS output_baud_rate, output.custom_options AS output_custom_options, output.pin AS output_pin, output.on_state AS output_on_state, output.amps AS output_amps, output.on_until AS output_on_until, output.off_until AS output_off_until, output.last_duration AS output_last_duration, output.on_duration AS output_on_duration, output.protocol AS output_protocol, output.pulse_length AS output_pulse_length, output.linux_command_user AS output_linux_command_user, output.on_command AS output_on_command, output.off_command AS output_off_command, output.pwm_command AS output_pwm_command, output.force_command AS output_force_command, output.trigger_functions_at_start AS output_trigger_functions_at_start, output.state_startup AS output_state_startup, output.startup_value AS output_startup_value, output.state_shutdown AS output_state_shutdown, output.shutdown_value AS output_shutdown_value, output.pwm_hertz AS output_pwm_hertz, output.pwm_library AS output_pwm_library, output.pwm_invert_signal AS output_pwm_invert_signal, output.flow_rate AS output_flow_rate, output.output_mode AS output_output_mode FROM output] (Background on this error at: http://sqlalche.me/e/14/e3q8) #### Disabling installed mycodo startup script Removed /etc/systemd/system/mycodo.service. Removed /etc/systemd/system/multi-user.target.wants/mycodo.service. #### Enabling current mycodo startup script Created symlink /etc/systemd/system/mycodo.service → /home/pi/Mycodo/install/mycodo.service. Created symlink /etc/systemd/system/multi-user.target.wants/mycodo.service → /home/pi/Mycodo/install/mycodo.service. #### Compiling Translations compiling catalog mycodo_flask/translations/pt/LC_MESSAGES/messages.po to mycodo_flask/translations/pt/LC_MESSAGES/messages.mo compiling catalog mycodo_flask/translations/nl/LC_MESSAGES/messages.po to mycodo_flask/translations/nl/LC_MESSAGES/messages.mo compiling catalog mycodo_flask/translations/de/LC_MESSAGES/messages.po to mycodo_flask/translations/de/LC_MESSAGES/messages.mo compiling catalog mycodo_flask/translations/sr/LC_MESSAGES/messages.po to mycodo_flask/translations/sr/LC_MESSAGES/messages.mo compiling catalog mycodo_flask/translations/zh/LC_MESSAGES/messages.po to mycodo_flask/translations/zh/LC_MESSAGES/messages.mo compiling catalog mycodo_flask/translations/sv/LC_MESSAGES/messages.po to mycodo_flask/translations/sv/LC_MESSAGES/messages.mo compiling catalog mycodo_flask/translations/it/LC_MESSAGES/messages.po to mycodo_flask/translations/it/LC_MESSAGES/messages.mo compiling catalog mycodo_flask/translations/pl/LC_MESSAGES/messages.po to mycodo_flask/translations/pl/LC_MESSAGES/messages.mo compiling catalog mycodo_flask/translations/es/LC_MESSAGES/messages.po to mycodo_flask/translations/es/LC_MESSAGES/messages.mo compiling catalog mycodo_flask/translations/nb/LC_MESSAGES/messages.po to mycodo_flask/translations/nb/LC_MESSAGES/messages.mo compiling catalog mycodo_flask/translations/fr/LC_MESSAGES/messages.po to mycodo_flask/translations/fr/LC_MESSAGES/messages.mo compiling catalog mycodo_flask/translations/ru/LC_MESSAGES/messages.po to mycodo_flask/translations/ru/LC_MESSAGES/messages.mo #### Generating widget HTML files #### Updating Mycodo restart monitor crontab entry Removing crontab entry ... Appending to crontab: ----------------------------------------------- @reboot /var/mycodo-root/env/bin/python /var/mycodo-root/mycodo/scripts/restart_daemon.py --continuouscheck & ----------------------------------------------- To remove previously added crontab entry, run: /home/pi/Mycodo/install/crontab.sh restart_daemon --remove #### Setting permissions #### Restarting the Mycodo daemon Mycodo previously shut down properly #### Restarting nginx #### Reloading mycodoflask mycodoflask.service is not active, cannot reload. #### Connecting to http://localhost (creates Mycodo database if it doesn't exist) #### Could not connect to http://localhost. Waiting 60 seconds then trying again (up to 5 times)... #### Trying again... #### Could not connect to http://localhost. Waiting 60 seconds then trying again (up to 5 times)... #### Trying again... #### Could not connect to http://localhost. Waiting 60 seconds then trying again (up to 5 times)... #### Trying again... #### Could not connect to http://localhost. Waiting 60 seconds then trying again (up to 5 times)... #### Trying again... #### Could not connect to http://localhost. Waiting 60 seconds then trying again (up to 5 times)... #### Trying again... #### Could not connect to http://localhost. Waiting 60 seconds then trying again (up to 5 times)... #### Trying again... #### Could not connect to http://localhost. Waiting 60 seconds then trying again (up to 5 times)... #### Trying again... #### Could not connect to http://localhost. Waiting 60 seconds then trying again (up to 5 times)... #### Trying again... #### Could not connect to http://localhost. Waiting 60 seconds then trying again (up to 5 times)... #### Trying again... #### Could not connect to http://localhost. Waiting 60 seconds then trying again (up to 5 times)... #### Trying again... Stage 3 execution time summary: initialize: 10 s update-swap-size: 0 s setup-virtualenv: 0 s update-apt: 7 s update-packages: 16 s web-server-update: 5 s update-logrotate: 0 s update-pip3: 59 s update-pip3-packages: 186 s update-dependencies: 4 s update-influxdb: 0 s update-alembic: 3 s update-alembic-post: 5 s update-mycodo-startup-script: 2 s compile-translations: 11 s generate-widget-html: 4 s update-cron: 4 s update-permissions: 1 s restart-daemon: 34 s web-server_reload: 6 s web-server-connect: 602 s pi@raspberrypi:~/Mycodo/databases $