dennissiemensma
commented
5 years ago Welke output krijg je hiermee:
sudo su - dsmr
./manage.py showmigrations | grep -v '[X]'Closed megapearl closed 5 years ago
dennissiemensma
commented
5 years ago Welke output krijg je hiermee:
sudo su - dsmr
./manage.py showmigrations | grep -v '[X]'Je kunt sowieso dit nog proberen:
sudo su - postgres
psql dsmrreader
BEGIN;
SELECT setval(pg_get_serial_sequence('"django_content_type"','id'), coalesce(max("id"), 1), max("id") IS NOT null) FROM "django_content_type";
COMMIT;En daarna:
sudo su - dsmr
./post-deploy.shWellicht krijg je nu de melding niet meer.
megapearl
commented
5 years ago Welke output krijg je hiermee:
sudo su - dsmr ./manage.py showmigrations | grep -v '[X]'
(dsmrreader) dsmr@ubuntu-server:~/dsmr-reader$ ./manage.py showmigrations | grep -v '[X]'
admin
auth
contenttypes
dsmr_api
dsmr_backend
dsmr_backup
dsmr_consumption
dsmr_datalogger
dsmr_frontend
dsmr_mindergas
dsmr_mqtt
dsmr_notification
dsmr_pvoutput
dsmr_stats
dsmr_weather
sessions
(dsmrreader) dsmr@ubuntu-server:~/dsmr-reader$
Je kunt sowieso dit nog proberen:
sudo su - postgres psql dsmrreader BEGIN; SELECT setval(pg_get_serial_sequence('"django_content_type"','id'), coalesce(max("id"), 1), max("id") IS NOT null) FROM "django_content_type"; COMMIT;En daarna:
sudo su - dsmr ./post-deploy.shWellicht krijg je nu de melding niet meer.
Inderdaad geen error meer:
postgres@ubuntu-server:~$ psql dsmrreader
psql (10.9 (Ubuntu 10.9-0ubuntu0.18.10.1))
Type "help" for help.
dsmrreader=# BEGIN;
BEGIN
dsmrreader=# SELECT setval(pg_get_serial_sequence('"django_content_type"','id'), coalesce(max("id"), 1), max("id") IS NOT null) FROM "django_content_type";
setval
--------
42
(1 row)
dsmrreader=# COMMIT;
COMMIT
dsmrreader=# \q
deploy lijkt nu goed te gaan:
(dsmrreader) dsmr@ubuntu-server:~/dsmr-reader$ ./post-deploy.sh
--- Checking whether VirtualEnv is activated.
--- Checking Python version.
Running Python 3.6.8 (default, Apr 9 2019, 04:59:38)
[GCC 8.3.0]
--- Checking & synchronizing base requirements for changes.
Requirement already satisfied: crcmod==1.7 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from -r dsmrreader/provisioning/requirements/base.txt (line 1)) (1.7)
Requirement already satisfied: coreapi==2.3.3 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from -r dsmrreader/provisioning/requirements/base.txt (line 2)) (2.3.3)
Requirement already satisfied: django==2.2.6 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from -r dsmrreader/provisioning/requirements/base.txt (line 3)) (2.2.6)
Requirement already satisfied: django-colorfield==0.1.15 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from -r dsmrreader/provisioning/requirements/base.txt (line 4)) (0.1.15)
Requirement already satisfied: django-debug-toolbar==2.0 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from -r dsmrreader/provisioning/requirements/base.txt (line 5)) (2.0)
Requirement already satisfied: django-filter==2.2.0 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from -r dsmrreader/provisioning/requirements/base.txt (line 6)) (2.2.0)
Requirement already satisfied: djangorestframework==3.10.3 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from -r dsmrreader/provisioning/requirements/base.txt (line 7)) (3.10.3)
Requirement already satisfied: django-solo==1.1.3 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from -r dsmrreader/provisioning/requirements/base.txt (line 8)) (1.1.3)
Requirement already satisfied: dropbox==9.4.0 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from -r dsmrreader/provisioning/requirements/base.txt (line 9)) (9.4.0)
Requirement already satisfied: gunicorn==19.9.0 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from -r dsmrreader/provisioning/requirements/base.txt (line 10)) (19.9.0)
Requirement already satisfied: paho-mqtt==1.4.0 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from -r dsmrreader/provisioning/requirements/base.txt (line 11)) (1.4.0)
Requirement already satisfied: pyserial==3.4 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from -r dsmrreader/provisioning/requirements/base.txt (line 12)) (3.4)
Requirement already satisfied: python-dateutil==2.8.0 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from -r dsmrreader/provisioning/requirements/base.txt (line 13)) (2.8.0)
Requirement already satisfied: pytz==2019.3 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from -r dsmrreader/provisioning/requirements/base.txt (line 14)) (2019.3)
Requirement already satisfied: requests==2.22.0 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from -r dsmrreader/provisioning/requirements/base.txt (line 15)) (2.22.0)
Requirement already satisfied: urllib3==1.25.6 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from -r dsmrreader/provisioning/requirements/base.txt (line 16)) (1.25.6)
Requirement already satisfied: coreschema in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from coreapi==2.3.3->-r dsmrreader/provisioning/requirements/base.txt (line 2)) (0.0.4)
Requirement already satisfied: uritemplate in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from coreapi==2.3.3->-r dsmrreader/provisioning/requirements/base.txt (line 2)) (3.0.0)
Requirement already satisfied: itypes in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from coreapi==2.3.3->-r dsmrreader/provisioning/requirements/base.txt (line 2)) (1.1.0)
Requirement already satisfied: sqlparse in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from django==2.2.6->-r dsmrreader/provisioning/requirements/base.txt (line 3)) (0.3.0)
Requirement already satisfied: six>=1.3.0 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from dropbox==9.4.0->-r dsmrreader/provisioning/requirements/base.txt (line 9)) (1.12.0)
Requirement already satisfied: idna<2.9,>=2.5 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from requests==2.22.0->-r dsmrreader/provisioning/requirements/base.txt (line 15)) (2.8)
Requirement already satisfied: chardet<3.1.0,>=3.0.2 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from requests==2.22.0->-r dsmrreader/provisioning/requirements/base.txt (line 15)) (3.0.4)
Requirement already satisfied: certifi>=2017.4.17 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from requests==2.22.0->-r dsmrreader/provisioning/requirements/base.txt (line 15)) (2019.6.16)
Requirement already satisfied: jinja2 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from coreschema->coreapi==2.3.3->-r dsmrreader/provisioning/requirements/base.txt (line 2)) (2.10.1)
Requirement already satisfied: MarkupSafe>=0.23 in /home/dsmr/.virtualenvs/dsmrreader/lib/python3.6/site-packages (from jinja2->coreschema->coreapi==2.3.3->-r dsmrreader/provisioning/requirements/base.txt (line 2)) (1.1.1)
--- Checking & synchronizing database changes/migrations.
Operations to perform:
Apply all migrations: admin, auth, contenttypes, dsmr_api, dsmr_backend, dsmr_backup, dsmr_consumption, dsmr_datalogger, dsmr_frontend, dsmr_mindergas, dsmr_mqtt, dsmr_notification, dsmr_pvoutput, dsmr_stats, dsmr_weather, sessions
Running migrations:
No migrations to apply.
--- Checking & synchronizing static file changes.
0 static files copied to '/var/www/dsmrreader/static', 537 unmodified.
--- Reloading running apps...
* Reloading process: dsmr_webinterface (Gunicorn) [OK]
* Reloading process: dsmr_backend [OK]
* Reloading process: dsmr_mqtt [OK]
--- Clearing cache...
[2019-10-11 08:16:13,924] INFO Clearing cache: default
[2019-10-11 08:16:13,925] INFO Clearing cache: mqtt
[2019-10-11 08:16:13,925] INFO Done
(dsmrreader) dsmr@ubuntu-server:~/dsmr-reader$
v2.6Ubuntu Linuxv5Overige
Hoi Dennis,
Er lijkt mij iets fout te staan in mijn database, bij sommige updates krijg ik duplicate key errors, De laatste 2 updates gingen goed (van 2.4 -> 2.5 en van 2.5 -> 2.6) Maar van 2.6 naar 2.7 gaat het mis.
Hoe kan ik de hele database checken/repareren?
(dsmrreader) dsmr@ubuntu-server:~/dsmr-reader$ ./deploy.sh
--- You are currently running version: 2.6
Please make sure you've read EACH release note BEFORE deploying, since some changes might not always be backwards compatible or depend on your database!