mainflux-users exited with code 1
Closed this issue · 8 comments
piratkin commented
I get errors at startup, help me please start the ui
$ git clone https://github.com/mainflux/ui.git && cd ui
...
$ git checkout tags/0.12.1 -b 0.12.1
...
mainflux-auth | {"level":"error","message":"Failed to connect to postgres: pq: the database system is starting up","ts":"2021-12-06T07:11:49.813154999Z"}
mainflux-jaeger | {"level":"info","ts":1638774709.0063202,"caller":"grpc/clientconn.go:1139","msg":"grpc: addrConn.createTransport failed to connect to {127.0.0.1:14250 0 <nil>}. Err :connection error: desc = \"transport: Error while dialing dial tcp 127.0.0.1:14250: connect: connection refused\". Reconnecting...","system":"grpc","grpc_log":true}
mainflux-users | {"level":"error","message":"failed to create admin user: rpc error: code = Unavailable desc = connection error: desc = \"transport: Error while dialing dial tcp 192.168.128.18:8181: connect: connection refused\"","ts":"2021-12-06T07:11:51.223912023Z"}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.618+00:00"},"s":"I", "c":"CONTROL", "id":20712, "ctx":"LogicalSessionCacheReap","msg":"Sessions collection is not set up; waiting until next sessions reap interval","attr":{"error":"NamespaceNotFound: config.system.sessions does not exist"}}
mainflux-users | {"level":"error","message":"failed to create admin user: rpc error: code = Internal desc = internal server error","ts":"2021-12-06T07:11:53.493338283Z"}
mainflux-auth-db | 2021-12-06 07:11:49.594 UTC [35] LOG: background worker "logical replication launcher" (PID 42) exited with exit code 1
mainflux-bootstrap-db | 2021-12-06 07:11:51.506 UTC [35] LOG: background worker "logical replication launcher" (PID 42) exited with exit code 1
mainflux-things-db | 2021-12-06 07:11:51.425 UTC [35] LOG: background worker "logical replication launcher" (PID 42) exited with exit code 1
mainflux-users-db | 2021-12-06 07:11:50.681 UTC [35] LOG: background worker "logical replication launcher" (PID 42) exited with exit code 1
mainflux-users exited with code 1
...System information:
$ docker -v
Docker version 20.10.7, build 20.10.7-0ubuntu5~20.04.2
$ docker-compose version
docker-compose version 1.29.2, build 5becea4c
docker-py version: 5.0.0
CPython version: 3.7.10
OpenSSL version: OpenSSL 1.1.0l 10 Sep 2019
$ go version
go version go1.17.4 linux/amd64
$ protoc --version
libprotoc 3.6.1My git diff:
$ git diff
diff --git a/docker/.env b/docker/.env
index 61b84f1..877bf0d 100644
--- a/docker/.env
+++ b/docker/.env
@@ -1,4 +1,5 @@
# Docker: Environment variables in Compose
+MF_RELEASE_TAG=0.12.1
## UI
MF_UI_PORT=3000
@@ -49,7 +50,7 @@ MF_USERS_DB_PASS=mainflux
MF_USERS_DB=users
MF_USERS_ADMIN_EMAIL=admin@example.com
MF_USERS_ADMIN_PASSWORD=12345678
-MF_USERS_RESET_PWD_TEMPLATE=users.tmpl
+MF_USERS_RESET_PWD_TEMPLATE=mail.tmpl
MF_USERS_PASS_REGEX=^.{8,}$
### Email utility
@@ -60,7 +61,7 @@ MF_EMAIL_USERNAME=18bf7f70705139
MF_EMAIL_PASSWORD=2b0d302e775b1e
MF_EMAIL_FROM_ADDRESS=from@example.com
MF_EMAIL_FROM_NAME=Example
-MF_EMAIL_TEMPLATE=email.tmpl
+MF_EMAIL_TEMPLATE=mail.tmpl
### Token utility
MF_TOKEN_RESET_ENDPOINT=/reset-request
@@ -132,7 +133,7 @@ MF_PROVISION_CERTS_HOURS_VALID=2400h
### LoRa
MF_LORA_ADAPTER_LOG_LEVEL=debug
-MF_LORA_ADAPTER_MESSAGES_URL=tcp://lora.mqtt.mainflux.io:1883
+MF_LORA_ADAPTER_MESSAGES_URL=tcp://localhost:1883
MF_LORA_ADAPTER_HTTP_PORT=8187
MF_LORA_ADAPTER_ROUTE_MAP_URL=localhost:6379
MF_LORA_ADAPTER_ROUTE_MAP_PASS=
diff --git a/docker/docker-compose.yml b/docker/docker-compose.yml
index f07393c..a7fcd06 100644
--- a/docker/docker-compose.yml
+++ b/docker/docker-compose.yml
@@ -414,30 +414,30 @@ services:
- ../../ssl/certs:/etc/ssl/certs
## LORA ADAPTER
- lora-redis:
- image: redis:5.0-alpine
- container_name: mainflux-lora-redis
- restart: on-failure
- networks:
- - mainflux-base-net
+ # lora-redis:
+ # image: redis:5.0-alpine
+ # container_name: mainflux-lora-redis
+ # restart: on-failure
+ # networks:
+ # - mainflux-base-net
- lora-adapter:
- image: mainflux/lora:latest
- container_name: mainflux-lora
- depends_on:
- - nats
- restart: on-failure
- environment:
- MF_LORA_ADAPTER_LOG_LEVEL: ${MF_LORA_ADAPTER_LOG_LEVEL}
- MF_THINGS_ES_URL: es-redis:${MF_REDIS_TCP_PORT}
- MF_LORA_ADAPTER_ROUTE_MAP_URL: lora-redis:${MF_REDIS_TCP_PORT}
- MF_LORA_ADAPTER_MESSAGES_URL: ${MF_LORA_ADAPTER_MESSAGES_URL}
- MF_LORA_ADAPTER_HTTP_PORT: ${MF_LORA_ADAPTER_HTTP_PORT}
- MF_NATS_URL: ${MF_NATS_URL}
- ports:
- - ${MF_LORA_ADAPTER_HTTP_PORT}:${MF_LORA_ADAPTER_HTTP_PORT}
- networks:
- - mainflux-base-net
+ # lora-adapter:
+ # image: mainflux/lora:latest
+ # container_name: mainflux-lora
+ # depends_on:
+ # - nats
+ # restart: on-failure
+ # environment:
+ # MF_LORA_ADAPTER_LOG_LEVEL: ${MF_LORA_ADAPTER_LOG_LEVEL}
+ # MF_THINGS_ES_URL: es-redis:${MF_REDIS_TCP_PORT}
+ # MF_LORA_ADAPTER_ROUTE_MAP_URL: lora-redis:${MF_REDIS_TCP_PORT}
+ # MF_LORA_ADAPTER_MESSAGES_URL: ${MF_LORA_ADAPTER_MESSAGES_URL}
+ # MF_LORA_ADAPTER_HTTP_PORT: ${MF_LORA_ADAPTER_HTTP_PORT}
+ # MF_NATS_URL: ${MF_NATS_URL}
+ # ports:
+ # - ${MF_LORA_ADAPTER_HTTP_PORT}:${MF_LORA_ADAPTER_HTTP_PORT}
+ # networks:
+ # - mainflux-base-net
## BOOTSTRAP
bootstrap-db:Full logs
$ docker-compose -f docker/docker-compose.yml pull
Pulling ui ... done
Pulling nats ... done
Pulling auth-db ... done
Pulling auth ... done
Pulling users-db ... done
Pulling users ... done
Pulling things-db ... done
Pulling auth-redis ... done
Pulling things ... done
Pulling jaeger ... done
Pulling vernemq ... done
Pulling mqtt-adapter ... done
Pulling http-adapter ... done
Pulling nginx ... done
Pulling es-redis ... done
Pulling opcua-redis ... done
Pulling opcua-adapter ... done
Pulling influxdb ... done
Pulling influxdb-writer ... done
Pulling grafana ... done
Pulling influxdb-reader ... done
Pulling bootstrap-db ... done
Pulling bootstrap ... done
Pulling provision ... done
Pulling twins-db ... done
Pulling twins ... done
$ docker-compose -f docker/docker-compose.yml up
Creating network "docker_mainflux-base-net" with driver "bridge"
Creating volume "docker_mainflux-auth-db-volume" with default driver
Creating volume "docker_mainflux-users-db-volume" with default driver
Creating volume "docker_mainflux-things-db-volume" with default driver
Creating volume "docker_mainflux-auth-redis-volume" with default driver
Creating volume "docker_mainflux-es-redis-volume" with default driver
Creating volume "docker_mainflux-influxdb-volume" with default driver
Creating volume "docker_mainflux-bootstrap-db-volume" with default driver
Creating volume "docker_mainflux-grafana-volume" with default driver
Creating volume "docker_mainflux-opcua-adapter-volume" with default driver
Creating volume "docker_mainflux-opcua-redis-volume" with default driver
Creating volume "docker_mainflux-twins-db-volume" with default driver
Creating volume "docker_mainflux-twins-db-configdb-volume" with default driver
Creating volume "docker_mainflux-mqtt-broker-volume" with default driver
Creating mainflux-opcua-redis ... done
Creating mainflux-influxdb ... done
Creating mainflux-jaeger ... done
Creating mainflux-bootstrap-db ... done
Creating mainflux-users-db ... done
Creating mainflux-twins-db ... done
Creating mainflux-es-redis ... done
Creating mainflux-things-db ... done
Creating mainflux-auth-db ... done
Creating mainflux-nats ... done
Creating mainflux-auth-redis ... done
Creating mainflux-provision ... done
Creating mainflux-vernemq ... done
Creating mainflux-influxdb-reader ... done
Creating mainflux-ui ... done
Creating mainflux-grafana ... done
Creating mainflux-auth ... done
Creating mainflux-opcua ... done
Creating mainflux-influxdb-writer ... done
Creating mainflux-bootstrap ... done
Creating mainflux-twins ... done
Creating mainflux-users ... done
Creating mainflux-things ... done
Creating mainflux-mqtt ... done
Creating mainflux-http ... done
Creating mainflux-nginx ... done
Attaching to mainflux-influxdb, mainflux-auth-db, mainflux-users-db, mainflux-es-redis, mainflux-jaeger, mainflux-ui, mainflux-auth-redis, mainflux-provision, mainflux-nats, mainflux-things-db, mainflux-bootstrap-db, mainflux-opcua-redis, mainflux-vernemq, mainflux-grafana, mainflux-twins-db, mainflux-influxdb-reader, mainflux-auth, mainflux-opcua, mainflux-bootstrap, mainflux-twins, mainflux-influxdb-writer, mainflux-users, mainflux-things, mainflux-http, mainflux-mqtt, mainflux-nginx
mainflux-auth | {"level":"error","message":"Failed to connect to postgres: pq: the database system is starting up","ts":"2021-12-06T07:11:49.813154999Z"}
mainflux-auth-db | The files belonging to this database system will be owned by user "postgres".
mainflux-auth-db | This user must also own the server process.
mainflux-auth-db |
mainflux-auth-db | The database cluster will be initialized with locale "en_US.utf8".
mainflux-auth-db | The default database encoding has accordingly been set to "UTF8".
mainflux-auth-db | The default text search configuration will be set to "english".
mainflux-auth-db |
mainflux-auth-db | Data page checksums are disabled.
mainflux-auth-db |
mainflux-auth-db | fixing permissions on existing directory /var/lib/postgresql/data ... ok
mainflux-auth-db | creating subdirectories ... ok
mainflux-auth-db | selecting dynamic shared memory implementation ... posix
mainflux-auth-db | selecting default max_connections ... 100
mainflux-auth-db | selecting default shared_buffers ... 128MB
mainflux-auth-db | selecting default time zone ... UTC
mainflux-auth-db | creating configuration files ... ok
mainflux-auth-db | running bootstrap script ... ok
mainflux-auth-db | performing post-bootstrap initialization ... sh: locale: not found
mainflux-auth-db | 2021-12-06 07:11:48.702 UTC [30] WARNING: no usable system locales were found
mainflux-auth-db | ok
mainflux-auth-db | syncing data to disk ... ok
mainflux-auth-db |
mainflux-auth-db |
mainflux-auth-db | Success. You can now start the database server using:
mainflux-auth-db |
mainflux-auth-db | pg_ctl -D /var/lib/postgresql/data -l logfile start
mainflux-auth-db |
mainflux-auth-db | initdb: warning: enabling "trust" authentication for local connections
mainflux-auth-db | You can change this by editing pg_hba.conf or using the option -A, or
mainflux-auth-db | --auth-local and --auth-host, the next time you run initdb.
mainflux-auth-redis | 1:C 06 Dec 2021 07:11:49.077 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
mainflux-auth-redis | 1:C 06 Dec 2021 07:11:49.077 # Redis version=5.0.14, bits=64, commit=00000000, modified=0, pid=1, just started
mainflux-auth-redis | 1:C 06 Dec 2021 07:11:49.077 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
mainflux-bootstrap-db | The files belonging to this database system will be owned by user "postgres".
mainflux-bootstrap-db | This user must also own the server process.
mainflux-bootstrap-db |
mainflux-bootstrap-db | The database cluster will be initialized with locale "en_US.utf8".
mainflux-bootstrap-db | The default database encoding has accordingly been set to "UTF8".
mainflux-bootstrap-db | The default text search configuration will be set to "english".
mainflux-bootstrap-db |
mainflux-bootstrap-db | Data page checksums are disabled.
mainflux-bootstrap-db |
mainflux-bootstrap-db | fixing permissions on existing directory /var/lib/postgresql/data ... ok
mainflux-bootstrap-db | creating subdirectories ... ok
mainflux-auth-db | waiting for server to start....2021-12-06 07:11:49.380 UTC [35] LOG: starting PostgreSQL 13.1 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.2.1_pre1) 10.2.1 20201203, 64-bit
mainflux-bootstrap | {"level":"error","message":"Failed to connect to postgres: dial tcp 192.168.128.14:5432: connect: connection refused","ts":"2021-12-06T07:11:50.780652687Z"}
mainflux-es-redis | 1:C 06 Dec 2021 07:11:48.815 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
mainflux-es-redis | 1:C 06 Dec 2021 07:11:48.815 # Redis version=5.0.14, bits=64, commit=00000000, modified=0, pid=1, just started
mainflux-es-redis | 1:C 06 Dec 2021 07:11:48.815 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
mainflux-auth-redis | 1:M 06 Dec 2021 07:11:49.078 * Running mode=standalone, port=6379.
mainflux-auth-redis | 1:M 06 Dec 2021 07:11:49.078 # Server initialized
mainflux-auth-redis | 1:M 06 Dec 2021 07:11:49.078 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
mainflux-auth-redis | 1:M 06 Dec 2021 07:11:49.078 # 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.
mainflux-auth-redis | 1:M 06 Dec 2021 07:11:49.078 * Ready to accept connections
mainflux-auth-db | 2021-12-06 07:11:49.382 UTC [35] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
mainflux-es-redis | 1:M 06 Dec 2021 07:11:48.816 * Running mode=standalone, port=6379.
mainflux-auth-db | 2021-12-06 07:11:49.391 UTC [36] LOG: database system was shut down at 2021-12-06 07:11:49 UTC
mainflux-auth-db | 2021-12-06 07:11:49.394 UTC [35] LOG: database system is ready to accept connections
mainflux-es-redis | 1:M 06 Dec 2021 07:11:48.816 # Server initialized
mainflux-es-redis | 1:M 06 Dec 2021 07:11:48.816 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
mainflux-es-redis | 1:M 06 Dec 2021 07:11:48.816 # 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.
mainflux-bootstrap-db | selecting dynamic shared memory implementation ... posix
mainflux-es-redis | 1:M 06 Dec 2021 07:11:48.816 * Ready to accept connections
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Starting Grafana" logger=server version=7.3.7 commit=1e261642f4 branch=HEAD compiled=2021-01-14T08:41:57+0000
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Config loaded from" logger=settings file=/usr/share/grafana/conf/defaults.ini
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Config loaded from" logger=settings file=/etc/grafana/grafana.ini
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.data=/var/lib/grafana"
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.logs=/var/log/grafana"
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.plugins=/var/lib/grafana/plugins"
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.provisioning=/etc/grafana/provisioning"
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.log.mode=console"
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_PATHS_DATA=/var/lib/grafana"
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_PATHS_LOGS=/var/log/grafana"
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_PATHS_PLUGINS=/var/lib/grafana/plugins"
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_PATHS_PROVISIONING=/etc/grafana/provisioning"
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Path Home" logger=settings path=/usr/share/grafana
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Path Data" logger=settings path=/var/lib/grafana
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Path Logs" logger=settings path=/var/log/grafana
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Path Plugins" logger=settings path=/var/lib/grafana/plugins
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Path Provisioning" logger=settings path=/etc/grafana/provisioning
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="App mode production" logger=settings
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Creating SQLite database file" logger=sqlstore path=/var/lib/grafana/grafana.db
mainflux-auth-db | done
mainflux-auth-db | server started
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Starting DB migrations" logger=migrator
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="create migration_log table"
mainflux-auth-db | CREATE DATABASE
mainflux-auth-db |
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="create user table"
mainflux-bootstrap-db | selecting default max_connections ... 100
mainflux-auth-db |
mainflux-auth-db | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
mainflux-auth-db |
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="add unique index user.login"
mainflux-http | {"level":"info","message":"gRPC communication is not encrypted","ts":"2021-12-06T07:11:51.951361098Z"}
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="add unique index user.email"
mainflux-bootstrap-db | selecting default shared_buffers ... 128MB
mainflux-auth-db | 2021-12-06 07:11:49.589 UTC [35] LOG: received fast shutdown request
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_user_login - v1"
mainflux-bootstrap-db | selecting default time zone ... UTC
mainflux-auth-db | waiting for server to shut down....2021-12-06 07:11:49.590 UTC [35] LOG: aborting any active transactions
mainflux-http | {"level":"info","message":"HTTP adapter service started on port 8185","ts":"2021-12-06T07:11:51.971081982Z"}
mainflux-bootstrap-db | creating configuration files ... ok
mainflux-influxdb | influxdb init process in progress...
mainflux-auth-db | 2021-12-06 07:11:49.594 UTC [35] LOG: background worker "logical replication launcher" (PID 42) exited with exit code 1
mainflux-auth-db | 2021-12-06 07:11:49.594 UTC [37] LOG: shutting down
mainflux-auth-db | 2021-12-06 07:11:49.626 UTC [35] LOG: database system is shut down
mainflux-influxdb-reader | {"level":"info","message":"gRPC communication is not encrypted","ts":"2021-12-06T07:11:49.709073475Z"}
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_user_email - v1"
mainflux-bootstrap-db | running bootstrap script ... ok
mainflux-influxdb | ts=2021-12-06T07:11:48.008544Z lvl=info msg="InfluxDB starting" log_id=0YFeBwA0000 version=1.8.3 branch=1.8 commit=563e6c3d1a7a2790763c6289501095dbec19244e
mainflux-influxdb | ts=2021-12-06T07:11:48.008579Z lvl=info msg="Go runtime" log_id=0YFeBwA0000 version=go1.13.8 maxprocs=6
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="Rename table user to user_v1 - v1"
mainflux-influxdb-writer | {"level":"info","message":"Using SenML transformer","ts":"2021-12-06T07:11:50.928060461Z"}
mainflux-influxdb-writer | {"level":"warn","message":"Failed to load subjects: unable to open configuration file : open /config.toml: no such file or directory","ts":"2021-12-06T07:11:50.928125992Z"}
mainflux-influxdb-writer | {"level":"info","message":"InfluxDB writer service started, exposed port :8900","ts":"2021-12-06T07:11:50.928153778Z"}
mainflux-bootstrap-db | performing post-bootstrap initialization ... sh: locale: not found
mainflux-bootstrap-db | 2021-12-06 07:11:50.501 UTC [30] WARNING: no usable system locales were found
mainflux-influxdb | ts=2021-12-06T07:11:48.111259Z lvl=info msg="Using data dir" log_id=0YFeBwA0000 service=store path=/var/lib/influxdb/data
mainflux-influxdb | ts=2021-12-06T07:11:48.111333Z lvl=info msg="Compaction settings" log_id=0YFeBwA0000 service=store max_concurrent_compactions=3 throughput_bytes_per_second=50331648 throughput_bytes_per_second_burst=50331648
mainflux-influxdb | ts=2021-12-06T07:11:48.111349Z lvl=info msg="Open store (start)" log_id=0YFeBwA0000 service=store trace_id=0YFeBwZl000 op_name=tsdb_open op_event=start
mainflux-influxdb | ts=2021-12-06T07:11:48.111380Z lvl=info msg="Open store (end)" log_id=0YFeBwA0000 service=store trace_id=0YFeBwZl000 op_name=tsdb_open op_event=end op_elapsed=0.033ms
mainflux-influxdb | ts=2021-12-06T07:11:48.111405Z lvl=info msg="Opened service" log_id=0YFeBwA0000 service=subscriber
mainflux-influxdb | ts=2021-12-06T07:11:48.111410Z lvl=info msg="Starting monitor service" log_id=0YFeBwA0000 service=monitor
mainflux-influxdb | ts=2021-12-06T07:11:48.111414Z lvl=info msg="Registered diagnostics client" log_id=0YFeBwA0000 service=monitor name=build
mainflux-influxdb | ts=2021-12-06T07:11:48.111418Z lvl=info msg="Registered diagnostics client" log_id=0YFeBwA0000 service=monitor name=runtime
mainflux-influxdb | ts=2021-12-06T07:11:48.111422Z lvl=info msg="Registered diagnostics client" log_id=0YFeBwA0000 service=monitor name=network
mainflux-influxdb | ts=2021-12-06T07:11:48.111429Z lvl=info msg="Registered diagnostics client" log_id=0YFeBwA0000 service=monitor name=system
mainflux-influxdb | ts=2021-12-06T07:11:48.111444Z lvl=info msg="Starting precreation service" log_id=0YFeBwA0000 service=shard-precreation check_interval=10m advance_period=30m
mainflux-influxdb | ts=2021-12-06T07:11:48.111454Z lvl=info msg="Starting snapshot service" log_id=0YFeBwA0000 service=snapshot
mainflux-influxdb | ts=2021-12-06T07:11:48.111458Z lvl=info msg="Starting continuous query service" log_id=0YFeBwA0000 service=continuous_querier
mainflux-influxdb | ts=2021-12-06T07:11:48.111470Z lvl=info msg="Starting HTTP service" log_id=0YFeBwA0000 service=httpd authentication=false
mainflux-influxdb | ts=2021-12-06T07:11:48.111474Z lvl=info msg="opened HTTP access log" log_id=0YFeBwA0000 service=httpd path=stderr
mainflux-influxdb | ts=2021-12-06T07:11:48.111500Z lvl=info msg="Listening on HTTP" log_id=0YFeBwA0000 service=httpd addr=127.0.0.1:8086 https=false
mainflux-influxdb | ts=2021-12-06T07:11:48.111525Z lvl=info msg="Starting retention policy enforcement service" log_id=0YFeBwA0000 service=retention check_interval=30m
mainflux-influxdb-reader | {"level":"info","message":"InfluxDB reader service started, exposed port 8905","ts":"2021-12-06T07:11:49.71061756Z"}
mainflux-auth-db | done
mainflux-auth-db | server stopped
mainflux-auth-db |
mainflux-auth-db | PostgreSQL init process complete; ready for start up.
mainflux-auth-db |
mainflux-mqtt | {"level":"info","message":"Broker not ready: Get \"http://vernemq:8888/health\": dial tcp 192.168.128.12:8888: connect: connection refused, next try in 288.619002ms","ts":"2021-12-06T07:11:52.005691031Z"}
mainflux-nats | [1] 2021/12/06 07:11:49.174081 [INF] Starting nats-server version 1.3.0
mainflux-nats | [1] 2021/12/06 07:11:49.174117 [INF] Git commit [eed4fbc]
mainflux-nats | [1] 2021/12/06 07:11:49.174311 [INF] Listening for client connections on 0.0.0.0:4222
mainflux-nats | [1] 2021/12/06 07:11:49.174322 [INF] Server is ready
mainflux-jaeger | 2021/12/06 07:11:48 maxprocs: Leaving GOMAXPROCS=6: CPU quota undefined
mainflux-mqtt | {"level":"info","message":"Broker not ready: Get \"http://vernemq:8888/health\": dial tcp 192.168.128.12:8888: connect: connection refused, next try in 1.03652013s","ts":"2021-12-06T07:11:52.295969017Z"}
mainflux-auth-db | 2021-12-06 07:11:49.726 UTC [1] LOG: starting PostgreSQL 13.1 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.2.1_pre1) 10.2.1 20201203, 64-bit
mainflux-auth-db | 2021-12-06 07:11:49.731 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
mainflux-auth-db | 2021-12-06 07:11:49.731 UTC [1] LOG: listening on IPv6 address "::", port 5432
mainflux-bootstrap-db | ok
mainflux-jaeger | {"level":"info","ts":1638774708.9010139,"caller":"flags/service.go:115","msg":"Mounting metrics handler on admin server","route":"/metrics"}
mainflux-jaeger | {"level":"info","ts":1638774708.9013424,"caller":"flags/admin.go:108","msg":"Mounting health check on admin server","route":"/"}
mainflux-jaeger | {"level":"info","ts":1638774708.9014015,"caller":"flags/admin.go:114","msg":"Starting admin HTTP server","http-port":14269}
mainflux-jaeger | {"level":"info","ts":1638774708.901411,"caller":"flags/admin.go:100","msg":"Admin server started","http-port":14269,"health-status":"unavailable"}
mainflux-influxdb | ts=2021-12-06T07:11:48.111816Z lvl=info msg="Storing statistics" log_id=0YFeBwA0000 service=monitor db_instance=_internal db_rp=monitor interval=10s
mainflux-jaeger | {"level":"info","ts":1638774708.9926376,"caller":"memory/factory.go:55","msg":"Memory storage initialized","configuration":{"MaxTraces":0}}
mainflux-jaeger | {"level":"info","ts":1638774708.998058,"caller":"grpc/builder.go:75","msg":"Agent requested insecure grpc connection to collector(s)"}
mainflux-jaeger | {"level":"info","ts":1638774708.9981065,"caller":"grpc/clientconn.go:242","msg":"parsed scheme: \"\"","system":"grpc","grpc_log":true}
mainflux-jaeger | {"level":"info","ts":1638774708.9981472,"caller":"grpc/clientconn.go:248","msg":"scheme \"\" not registered, fallback to default scheme","system":"grpc","grpc_log":true}
mainflux-jaeger | {"level":"info","ts":1638774708.99817,"caller":"grpc/resolver_conn_wrapper.go:113","msg":"ccResolverWrapper: sending update to cc: {[{127.0.0.1:14250 0 <nil>}] }","system":"grpc","grpc_log":true}
mainflux-jaeger | {"level":"info","ts":1638774708.9984262,"caller":"base/balancer.go:76","msg":"base.baseBalancer: got new resolver state: {[{127.0.0.1:14250 0 <nil>}] }","system":"grpc","grpc_log":true}
mainflux-jaeger | {"level":"info","ts":1638774708.9984972,"caller":"base/balancer.go:130","msg":"base.baseBalancer: handle SubConn state change: 0xc000470040, CONNECTING","system":"grpc","grpc_log":true}
mainflux-jaeger | {"level":"info","ts":1638774708.99951,"caller":"all-in-one/main.go:198","msg":"Starting agent"}
mainflux-influxdb | ts=2021-12-06T07:11:48.112256Z lvl=info msg="Sending usage statistics to usage.influxdata.com" log_id=0YFeBwA0000
mainflux-auth-db | 2021-12-06 07:11:49.799 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
mainflux-bootstrap-db | syncing data to disk ... ok
mainflux-bootstrap-db |
mainflux-bootstrap-db |
mainflux-bootstrap-db | Success. You can now start the database server using:
mainflux-bootstrap-db |
mainflux-bootstrap-db | pg_ctl -D /var/lib/postgresql/data -l logfile start
mainflux-bootstrap-db |
mainflux-jaeger | {"level":"info","ts":1638774709.0063202,"caller":"grpc/clientconn.go:1139","msg":"grpc: addrConn.createTransport failed to connect to {127.0.0.1:14250 0 <nil>}. Err :connection error: desc = \"transport: Error while dialing dial tcp 127.0.0.1:14250: connect: connection refused\". Reconnecting...","system":"grpc","grpc_log":true}
mainflux-jaeger | {"level":"info","ts":1638774709.006394,"caller":"base/balancer.go:130","msg":"base.baseBalancer: handle SubConn state change: 0xc000470040, TRANSIENT_FAILURE","system":"grpc","grpc_log":true}
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="create user table v2"
mainflux-bootstrap-db | initdb: warning: enabling "trust" authentication for local connections
mainflux-bootstrap-db | You can change this by editing pg_hba.conf or using the option -A, or
mainflux-bootstrap-db | --auth-local and --auth-host, the next time you run initdb.
mainflux-auth-db | 2021-12-06 07:11:49.810 UTC [49] LOG: database system was shut down at 2021-12-06 07:11:49 UTC
mainflux-influxdb | ts=2021-12-06T07:11:48.112854Z lvl=info msg="Listening for signals" log_id=0YFeBwA0000
mainflux-jaeger | {"level":"info","ts":1638774709.014534,"caller":"app/agent.go:68","msg":"Starting jaeger-agent HTTP server","http-port":5778}
mainflux-auth-db | 2021-12-06 07:11:49.811 UTC [50] FATAL: the database system is starting up
mainflux-influxdb | [httpd] 127.0.0.1 - - [06/Dec/2021:07:11:49 +0000] "GET /ping HTTP/1.1" 204 0 "-" "InfluxDBShell/1.8.3" c77bdf31-5663-11ec-8001-0242c0a88002 182
mainflux-influxdb | ts=2021-12-06T07:11:49.018425Z lvl=info msg="Executing query" log_id=0YFeBwA0000 service=query query="CREATE DATABASE mainflux"
mainflux-influxdb | [httpd] 127.0.0.1 - - [06/Dec/2021:07:11:49 +0000] "POST /query?chunked=true&db=&epoch=ns&q=CREATE+DATABASE+mainflux HTTP/1.1" 200 57 "-" "InfluxDBShell/1.8.3" c77bf1f6-5663-11ec-8002-0242c0a88002 7130
mainflux-auth-db | 2021-12-06 07:11:49.819 UTC [1] LOG: database system is ready to accept connections
mainflux-opcua | {"level":"info","message":"Connected to thing Redis Route-map","ts":"2021-12-06T07:11:50.521138397Z"}
mainflux-opcua | {"level":"info","message":"Connected to channel Redis Route-map","ts":"2021-12-06T07:11:50.521179422Z"}
mainflux-opcua | {"level":"info","message":"Connected to connection Redis Route-map","ts":"2021-12-06T07:11:50.521186947Z"}
mainflux-bootstrap-db | waiting for server to start....2021-12-06 07:11:51.342 UTC [35] LOG: starting PostgreSQL 13.1 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.2.1_pre1) 10.2.1 20201203, 64-bit
mainflux-jaeger | {"level":"info","ts":1638774709.0270221,"caller":"all-in-one/main.go:241","msg":"Starting jaeger-collector TChannel server","port":14267}
mainflux-jaeger | {"level":"info","ts":1638774709.0271254,"caller":"grpcserver/grpc_server.go:64","msg":"Starting jaeger-collector gRPC server","grpc-port":"14250"}
mainflux-jaeger | {"level":"info","ts":1638774709.0271719,"caller":"all-in-one/main.go:259","msg":"Starting jaeger-collector HTTP server","http-port":14268}
mainflux-jaeger | {"level":"info","ts":1638774709.027191,"caller":"querysvc/query_service.go:130","msg":"Archive storage not created","reason":"archive storage not supported"}
mainflux-jaeger | {"level":"info","ts":1638774709.0272,"caller":"all-in-one/main.go:341","msg":"Archive storage not initialized"}
mainflux-influxdb | ts=2021-12-06T07:11:49.033421Z lvl=info msg="Signal received, initializing clean shutdown..." log_id=0YFeBwA0000
mainflux-influxdb | ts=2021-12-06T07:11:49.033463Z lvl=info msg="Waiting for clean shutdown..." log_id=0YFeBwA0000
mainflux-influxdb | ts=2021-12-06T07:11:49.033523Z lvl=info msg="Listener closed" log_id=0YFeBwA0000 service=snapshot
mainflux-influxdb | ts=2021-12-06T07:11:49.033557Z lvl=info msg="Shutting down monitor service" log_id=0YFeBwA0000 service=monitor
mainflux-jaeger | {"level":"info","ts":1638774709.0277455,"caller":"healthcheck/handler.go:129","msg":"Health Check state change","status":"ready"}
mainflux-jaeger | {"level":"info","ts":1638774709.027768,"caller":"app/server.go:134","msg":"Starting CMUX server","port":16686}
mainflux-jaeger | {"level":"info","ts":1638774709.0278578,"caller":"app/server.go:111","msg":"Starting HTTP server","port":16686}
mainflux-jaeger | {"level":"info","ts":1638774709.0278733,"caller":"app/server.go:124","msg":"Starting GRPC server","port":16686}
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="create index UQE_user_login - v2"
mainflux-opcua | {"level":"warn","message":"Read stored subscriptions failed: file not found : stat /store/nodes.csv: no such file or directory","ts":"2021-12-06T07:11:50.531737858Z"}
mainflux-opcua | {"level":"info","message":"opcua-adapter service started, exposed port 8188","ts":"2021-12-06T07:11:50.53178755Z"}
mainflux-bootstrap-db | 2021-12-06 07:11:51.343 UTC [35] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
mainflux-influxdb | /init-influxdb.sh: ignoring /docker-entrypoint-initdb.d/*
mainflux-influxdb |
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="create index UQE_user_email - v2"
mainflux-bootstrap-db | 2021-12-06 07:11:51.348 UTC [36] LOG: database system was shut down at 2021-12-06 07:11:51 UTC
mainflux-provision | {"level":"info","message":"Continue with settings from file: /configs/config.toml","ts":"2021-12-06T07:11:49.144287119Z"}
mainflux-provision | {"level":"info","message":"Provision service started using http on port 8190","ts":"2021-12-06T07:11:49.144460933Z"}
mainflux-opcua-redis | 1:C 06 Dec 2021 07:11:49.589 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
mainflux-opcua-redis | 1:C 06 Dec 2021 07:11:49.589 # Redis version=5.0.14, bits=64, commit=00000000, modified=0, pid=1, just started
mainflux-opcua-redis | 1:C 06 Dec 2021 07:11:49.589 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="copy data_source v1 to v2"
mainflux-opcua-redis | 1:M 06 Dec 2021 07:11:49.598 * Running mode=standalone, port=6379.
mainflux-opcua-redis | 1:M 06 Dec 2021 07:11:49.598 # Server initialized
mainflux-opcua-redis | 1:M 06 Dec 2021 07:11:49.598 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
mainflux-opcua-redis | 1:M 06 Dec 2021 07:11:49.598 # 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.
mainflux-opcua-redis | 1:M 06 Dec 2021 07:11:49.598 * Ready to accept connections
mainflux-bootstrap-db | 2021-12-06 07:11:51.351 UTC [35] LOG: database system is ready to accept connections
mainflux-bootstrap-db | done
mainflux-bootstrap-db | server started
mainflux-things-db | The files belonging to this database system will be owned by user "postgres".
mainflux-things-db | This user must also own the server process.
mainflux-things-db |
mainflux-things-db | The database cluster will be initialized with locale "en_US.utf8".
mainflux-things-db | The default database encoding has accordingly been set to "UTF8".
mainflux-things-db | The default text search configuration will be set to "english".
mainflux-things-db |
mainflux-things-db | Data page checksums are disabled.
mainflux-things | {"level":"error","message":"Failed to connect to postgres: dial tcp 192.168.128.11:5432: connect: connection refused","ts":"2021-12-06T07:11:51.15299458Z"}
mainflux-bootstrap-db | CREATE DATABASE
mainflux-things-db |
mainflux-things-db | fixing permissions on existing directory /var/lib/postgresql/data ... ok
mainflux-twins | {"level":"info","message":"gRPC communication is not encrypted","ts":"2021-12-06T07:11:50.929611344Z"}
mainflux-bootstrap-db |
mainflux-things-db | creating subdirectories ... ok
mainflux-influxdb | ts=2021-12-06T07:11:49.033588Z lvl=info msg="Terminating precreation service" log_id=0YFeBwA0000 service=shard-precreation
mainflux-influxdb | ts=2021-12-06T07:11:49.033605Z lvl=info msg="Terminating continuous query service" log_id=0YFeBwA0000 service=continuous_querier
mainflux-influxdb | ts=2021-12-06T07:11:49.033631Z lvl=info msg="Closing retention policy enforcement service" log_id=0YFeBwA0000 service=retention
mainflux-influxdb | ts=2021-12-06T07:11:49.033675Z lvl=info msg="Closed service" log_id=0YFeBwA0000 service=subscriber
mainflux-influxdb | ts=2021-12-06T07:11:49.033706Z lvl=info msg="Server shutdown completed" log_id=0YFeBwA0000
mainflux-twins | {"level":"info","message":"Twins service started using http on port 9021","ts":"2021-12-06T07:11:50.936017819Z"}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:49.715+00:00"},"s":"I", "c":"CONTROL", "id":23285, "ctx":"main","msg":"Automatically disabling TLS 1.0, to force-enable TLS 1.0 specify --sslDisabledProtocols 'none'"}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:49.717+00:00"},"s":"W", "c":"ASIO", "id":22601, "ctx":"main","msg":"No TransportLayer configured during NetworkInterface startup"}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:49.717+00:00"},"s":"I", "c":"NETWORK", "id":4648601, "ctx":"main","msg":"Implicit TCP FastOpen unavailable. If TCP FastOpen is required, set tcpFastOpenServer, tcpFastOpenClient, and tcpFastOpenQueueSize."}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:49.718+00:00"},"s":"I", "c":"STORAGE", "id":4615611, "ctx":"initandlisten","msg":"MongoDB starting","attr":{"pid":1,"port":27018,"dbPath":"/data/db","architecture":"64-bit","host":"4123679fc350"}}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:49.718+00:00"},"s":"I", "c":"CONTROL", "id":23403, "ctx":"initandlisten","msg":"Build Info","attr":{"buildInfo":{"version":"4.4.6","gitVersion":"72e66213c2c3eab37d9358d5e78ad7f5c1d0d0d7","openSSLVersion":"OpenSSL 1.1.1 11 Sep 2018","modules":[],"allocator":"tcmalloc","environment":{"distmod":"ubuntu1804","distarch":"x86_64","target_arch":"x86_64"}}}}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:49.718+00:00"},"s":"I", "c":"CONTROL", "id":51765, "ctx":"initandlisten","msg":"Operating System","attr":{"os":{"name":"Ubuntu","version":"18.04"}}}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:49.718+00:00"},"s":"I", "c":"CONTROL", "id":21951, "ctx":"initandlisten","msg":"Options set by command line","attr":{"options":{"net":{"bindIp":"*","port":27018}}}}
mainflux-influxdb | ts=2021-12-06T07:11:49.112025Z lvl=info msg="InfluxDB starting" log_id=0YFeB~Tl000 version=1.8.3 branch=1.8 commit=563e6c3d1a7a2790763c6289501095dbec19244e
mainflux-influxdb | ts=2021-12-06T07:11:49.112055Z lvl=info msg="Go runtime" log_id=0YFeB~Tl000 version=go1.13.8 maxprocs=6
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:49.722+00:00"},"s":"I", "c":"STORAGE", "id":22297, "ctx":"initandlisten","msg":"Using the XFS filesystem is strongly recommended with the WiredTiger storage engine. See http://dochub.mongodb.org/core/prodnotes-filesystem","tags":["startupWarnings"]}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:49.722+00:00"},"s":"I", "c":"STORAGE", "id":22315, "ctx":"initandlisten","msg":"Opening WiredTiger","attr":{"config":"create,cache_size=11514M,session_max=33000,eviction=(threads_min=4,threads_max=4),config_base=false,statistics=(fast),log=(enabled=true,archive=true,path=journal,compressor=snappy),file_manager=(close_idle_time=100000,close_scan_interval=10,close_handle_minimum=250),statistics_log=(wait=0),verbose=[recovery_progress,checkpoint_progress,compact_progress],"}}
mainflux-users | {"level":"info","message":"gRPC communication is not encrypted","ts":"2021-12-06T07:11:51.218058443Z"}
mainflux-influxdb | ts=2021-12-06T07:11:49.220512Z lvl=info msg="Using data dir" log_id=0YFeB~Tl000 service=store path=/var/lib/influxdb/data
mainflux-influxdb | ts=2021-12-06T07:11:49.220548Z lvl=info msg="Compaction settings" log_id=0YFeB~Tl000 service=store max_concurrent_compactions=3 throughput_bytes_per_second=50331648 throughput_bytes_per_second_burst=50331648
mainflux-influxdb | ts=2021-12-06T07:11:49.220562Z lvl=info msg="Open store (start)" log_id=0YFeB~Tl000 service=store trace_id=0YFeB~u0000 op_name=tsdb_open op_event=start
mainflux-influxdb | ts=2021-12-06T07:11:49.220602Z lvl=info msg="Open store (end)" log_id=0YFeB~Tl000 service=store trace_id=0YFeB~u0000 op_name=tsdb_open op_event=end op_elapsed=0.039ms
mainflux-influxdb | ts=2021-12-06T07:11:49.220627Z lvl=info msg="Opened service" log_id=0YFeB~Tl000 service=subscriber
mainflux-influxdb | ts=2021-12-06T07:11:49.220631Z lvl=info msg="Starting monitor service" log_id=0YFeB~Tl000 service=monitor
mainflux-influxdb | ts=2021-12-06T07:11:49.220641Z lvl=info msg="Registered diagnostics client" log_id=0YFeB~Tl000 service=monitor name=build
mainflux-influxdb | ts=2021-12-06T07:11:49.220644Z lvl=info msg="Registered diagnostics client" log_id=0YFeB~Tl000 service=monitor name=runtime
mainflux-influxdb | ts=2021-12-06T07:11:49.220647Z lvl=info msg="Registered diagnostics client" log_id=0YFeB~Tl000 service=monitor name=network
mainflux-influxdb | ts=2021-12-06T07:11:49.220655Z lvl=info msg="Registered diagnostics client" log_id=0YFeB~Tl000 service=monitor name=system
mainflux-influxdb | ts=2021-12-06T07:11:49.220675Z lvl=info msg="Starting precreation service" log_id=0YFeB~Tl000 service=shard-precreation check_interval=10m advance_period=30m
mainflux-influxdb | ts=2021-12-06T07:11:49.220681Z lvl=info msg="Starting snapshot service" log_id=0YFeB~Tl000 service=snapshot
mainflux-influxdb | ts=2021-12-06T07:11:49.220685Z lvl=info msg="Starting continuous query service" log_id=0YFeB~Tl000 service=continuous_querier
mainflux-influxdb | ts=2021-12-06T07:11:49.220694Z lvl=info msg="Starting HTTP service" log_id=0YFeB~Tl000 service=httpd authentication=false
mainflux-influxdb | ts=2021-12-06T07:11:49.220698Z lvl=info msg="opened HTTP access log" log_id=0YFeB~Tl000 service=httpd path=stderr
mainflux-bootstrap-db |
mainflux-bootstrap-db | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
mainflux-bootstrap-db |
mainflux-influxdb | ts=2021-12-06T07:11:49.220966Z lvl=info msg="Listening on HTTP" log_id=0YFeB~Tl000 service=httpd addr=[::]:8086 https=false
mainflux-influxdb | ts=2021-12-06T07:11:49.220991Z lvl=info msg="Starting retention policy enforcement service" log_id=0YFeB~Tl000 service=retention check_interval=30m
mainflux-influxdb | ts=2021-12-06T07:11:49.221042Z lvl=info msg="Listening for signals" log_id=0YFeB~Tl000
mainflux-influxdb | ts=2021-12-06T07:11:49.221127Z lvl=info msg="Storing statistics" log_id=0YFeB~Tl000 service=monitor db_instance=_internal db_rp=monitor interval=10s
mainflux-influxdb | ts=2021-12-06T07:11:49.221242Z lvl=info msg="Sending usage statistics to usage.influxdata.com" log_id=0YFeB~Tl000
mainflux-things-db | selecting dynamic shared memory implementation ... posix
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.419+00:00"},"s":"I", "c":"STORAGE", "id":22430, "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1638774710:419625][1:0x7f3580554ac0], txn-recover: [WT_VERB_RECOVERY | WT_VERB_RECOVERY_PROGRESS] Set global recovery timestamp: (0, 0)"}}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.419+00:00"},"s":"I", "c":"STORAGE", "id":22430, "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1638774710:419691][1:0x7f3580554ac0], txn-recover: [WT_VERB_RECOVERY | WT_VERB_RECOVERY_PROGRESS] Set global oldest timestamp: (0, 0)"}}
mainflux-users | {"level":"error","message":"failed to create admin user: rpc error: code = Unavailable desc = connection error: desc = \"transport: Error while dialing dial tcp 192.168.128.18:8181: connect: connection refused\"","ts":"2021-12-06T07:11:51.223912023Z"}
mainflux-users-db | The files belonging to this database system will be owned by user "postgres".
mainflux-users-db | This user must also own the server process.
mainflux-users-db |
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.431+00:00"},"s":"I", "c":"STORAGE", "id":4795906, "ctx":"initandlisten","msg":"WiredTiger opened","attr":{"durationMillis":709}}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.431+00:00"},"s":"I", "c":"RECOVERY", "id":23987, "ctx":"initandlisten","msg":"WiredTiger recoveryTimestamp","attr":{"recoveryTimestamp":{"$timestamp":{"t":0,"i":0}}}}
mainflux-bootstrap-db | waiting for server to shut down....2021-12-06 07:11:51.504 UTC [35] LOG: received fast shutdown request
mainflux-users-db | The database cluster will be initialized with locale "en_US.utf8".
mainflux-users-db | The default database encoding has accordingly been set to "UTF8".
mainflux-users-db | The default text search configuration will be set to "english".
mainflux-users-db |
mainflux-users-db | Data page checksums are disabled.
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="Drop old table user_v1"
mainflux-things-db | selecting default max_connections ... 100
mainflux-users-db |
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="Add column help_flags1 to user table"
mainflux-things-db | selecting default shared_buffers ... 128MB
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.486+00:00"},"s":"I", "c":"STORAGE", "id":4366408, "ctx":"initandlisten","msg":"No table logging settings modifications are required for existing WiredTiger tables","attr":{"loggingEnabled":true}}
mainflux-things-db | selecting default time zone ... UTC
mainflux-bootstrap-db | 2021-12-06 07:11:51.506 UTC [35] LOG: aborting any active transactions
mainflux-things-db | creating configuration files ... ok
mainflux-users-db | fixing permissions on existing directory /var/lib/postgresql/data ... ok
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.488+00:00"},"s":"I", "c":"STORAGE", "id":22262, "ctx":"initandlisten","msg":"Timestamp monitor starting"}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.524+00:00"},"s":"W", "c":"CONTROL", "id":22120, "ctx":"initandlisten","msg":"Access control is not enabled for the database. Read and write access to data and configuration is unrestricted","tags":["startupWarnings"]}
mainflux-bootstrap-db | 2021-12-06 07:11:51.506 UTC [35] LOG: background worker "logical replication launcher" (PID 42) exited with exit code 1
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="Update user table charset"
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="Add last_seen_at column to user"
mainflux-things-db | running bootstrap script ... ok
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.527+00:00"},"s":"I", "c":"STORAGE", "id":20320, "ctx":"initandlisten","msg":"createCollection","attr":{"namespace":"admin.system.version","uuidDisposition":"provided","uuid":{"uuid":{"$uuid":"6f622afa-5154-4e20-8c79-526bbbd6df97"}},"options":{"uuid":{"$uuid":"6f622afa-5154-4e20-8c79-526bbbd6df97"}}}}
mainflux-bootstrap-db | 2021-12-06 07:11:51.507 UTC [37] LOG: shutting down
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.561+00:00"},"s":"I", "c":"INDEX", "id":20345, "ctx":"initandlisten","msg":"Index build: done building","attr":{"buildUUID":null,"namespace":"admin.system.version","index":"_id_","commitTimestamp":{"$timestamp":{"t":0,"i":0}}}}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.561+00:00"},"s":"I", "c":"COMMAND", "id":20459, "ctx":"initandlisten","msg":"Setting featureCompatibilityVersion","attr":{"newVersion":"4.4"}}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.562+00:00"},"s":"I", "c":"STORAGE", "id":20536, "ctx":"initandlisten","msg":"Flow Control is enabled on this deployment"}
mainflux-bootstrap-db | 2021-12-06 07:11:51.551 UTC [35] LOG: database system is shut down
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="Add missing user data"
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.571+00:00"},"s":"I", "c":"STORAGE", "id":20320, "ctx":"initandlisten","msg":"createCollection","attr":{"namespace":"local.startup_log","uuidDisposition":"generated","uuid":{"uuid":{"$uuid":"c397de53-80b0-4b76-aa25-488bb0d2e5e8"}},"options":{"capped":true,"size":10485760}}}
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="Add is_disabled column to user"
mainflux-things-db | performing post-bootstrap initialization ... sh: locale: not found
mainflux-bootstrap-db | done
mainflux-bootstrap-db | server stopped
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.604+00:00"},"s":"I", "c":"INDEX", "id":20345, "ctx":"initandlisten","msg":"Index build: done building","attr":{"buildUUID":null,"namespace":"local.startup_log","index":"_id_","commitTimestamp":{"$timestamp":{"t":0,"i":0}}}}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.604+00:00"},"s":"I", "c":"FTDC", "id":20625, "ctx":"initandlisten","msg":"Initializing full-time diagnostic data capture","attr":{"dataDirectory":"/data/db/diagnostic.data"}}
mainflux-users-db | creating subdirectories ... ok
mainflux-things-db | 2021-12-06 07:11:50.267 UTC [30] WARNING: no usable system locales were found
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.615+00:00"},"s":"I", "c":"STORAGE", "id":20320, "ctx":"LogicalSessionCacheRefresh","msg":"createCollection","attr":{"namespace":"config.system.sessions","uuidDisposition":"generated","uuid":{"uuid":{"$uuid":"a75760a0-55f4-45f5-8bd2-1f0bbf88f83e"}},"options":{}}}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.618+00:00"},"s":"I", "c":"CONTROL", "id":20712, "ctx":"LogicalSessionCacheReap","msg":"Sessions collection is not set up; waiting until next sessions reap interval","attr":{"error":"NamespaceNotFound: config.system.sessions does not exist"}}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.619+00:00"},"s":"I", "c":"NETWORK", "id":23015, "ctx":"listener","msg":"Listening on","attr":{"address":"/tmp/mongodb-27018.sock"}}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.619+00:00"},"s":"I", "c":"NETWORK", "id":23015, "ctx":"listener","msg":"Listening on","attr":{"address":"0.0.0.0"}}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.619+00:00"},"s":"I", "c":"NETWORK", "id":23016, "ctx":"listener","msg":"Waiting for connections","attr":{"port":27018,"ssl":"off"}}
mainflux-things-db | ok
mainflux-bootstrap-db |
mainflux-bootstrap-db | PostgreSQL init process complete; ready for start up.
mainflux-bootstrap-db |
mainflux-things-db | syncing data to disk ... ok
mainflux-things-db |
mainflux-things-db |
mainflux-things-db | Success. You can now start the database server using:
mainflux-things-db |
mainflux-things-db | pg_ctl -D /var/lib/postgresql/data -l logfile start
mainflux-things-db |
mainflux-bootstrap-db | 2021-12-06 07:11:51.631 UTC [1] LOG: starting PostgreSQL 13.1 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.2.1_pre1) 10.2.1 20201203, 64-bit
mainflux-bootstrap-db | 2021-12-06 07:11:51.631 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
mainflux-bootstrap-db | 2021-12-06 07:11:51.631 UTC [1] LOG: listening on IPv6 address "::", port 5432
mainflux-things-db | initdb: warning: enabling "trust" authentication for local connections
mainflux-things-db | You can change this by editing pg_hba.conf or using the option -A, or
mainflux-things-db | --auth-local and --auth-host, the next time you run initdb.
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.663+00:00"},"s":"I", "c":"INDEX", "id":20345, "ctx":"LogicalSessionCacheRefresh","msg":"Index build: done building","attr":{"buildUUID":null,"namespace":"config.system.sessions","index":"_id_","commitTimestamp":{"$timestamp":{"t":0,"i":0}}}}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.663+00:00"},"s":"I", "c":"INDEX", "id":20345, "ctx":"LogicalSessionCacheRefresh","msg":"Index build: done building","attr":{"buildUUID":null,"namespace":"config.system.sessions","index":"lsidTTLIndex","commitTimestamp":{"$timestamp":{"t":0,"i":0}}}}
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.931+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"192.168.128.22:40106","connectionId":1,"connectionCount":1}}
mainflux-users-db | selecting dynamic shared memory implementation ... posix
mainflux-bootstrap-db | 2021-12-06 07:11:51.636 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
mainflux-things-db | waiting for server to start....2021-12-06 07:11:51.223 UTC [35] LOG: starting PostgreSQL 13.1 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.2.1_pre1) 10.2.1 20201203, 64-bit
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.931+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"192.168.128.22:40108","connectionId":2,"connectionCount":2}}
mainflux-users-db | selecting default max_connections ... 100
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="Add index user.login/user.email"
mainflux-things-db | 2021-12-06 07:11:51.245 UTC [35] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.932+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn2","msg":"client metadata","attr":{"remote":"192.168.128.22:40108","client":"conn2","doc":{"driver":{"name":"mongo-go-driver","version":"v1.7.1"},"os":{"type":"linux","architecture":"amd64"},"platform":"go1.17.3"}}}
mainflux-bootstrap-db | 2021-12-06 07:11:51.639 UTC [49] LOG: database system was shut down at 2021-12-06 07:11:51 UTC
mainflux-grafana | t=2021-12-06T07:11:49+0000 lvl=info msg="Executing migration" logger=migrator id="create temp user table v1-7"
mainflux-users-db | selecting default shared_buffers ... 128MB
mainflux-bootstrap-db | 2021-12-06 07:11:51.642 UTC [1] LOG: database system is ready to accept connections
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:11:50.932+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn1","msg":"client metadata","attr":{"remote":"192.168.128.22:40106","client":"conn1","doc":{"driver":{"name":"mongo-go-driver","version":"v1.7.1"},"os":{"type":"linux","architecture":"amd64"},"platform":"go1.17.3"}}}
mainflux-things-db | 2021-12-06 07:11:51.263 UTC [36] LOG: database system was shut down at 2021-12-06 07:11:50 UTC
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_email - v1-7"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_org_id - v1-7"
mainflux-things-db | 2021-12-06 07:11:51.268 UTC [35] LOG: database system is ready to accept connections
mainflux-users-db | selecting default time zone ... UTC
mainflux-things-db | done
mainflux-things-db | server started
mainflux-users-db | creating configuration files ... ok
mainflux-users-db | running bootstrap script ... ok
mainflux-users-db | performing post-bootstrap initialization ... sh: locale: not found
mainflux-users-db | 2021-12-06 07:11:49.378 UTC [30] WARNING: no usable system locales were found
mainflux-things-db | CREATE DATABASE
mainflux-users-db | ok
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_code - v1-7"
mainflux-things-db |
mainflux-things-db |
mainflux-things-db | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
mainflux-things-db |
mainflux-users-db | syncing data to disk ... initdb: warning: enabling "trust" authentication for local connections
mainflux-users-db | You can change this by editing pg_hba.conf or using the option -A, or
mainflux-users-db | --auth-local and --auth-host, the next time you run initdb.
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_status - v1-7"
mainflux-things-db | waiting for server to shut down....2021-12-06 07:11:51.423 UTC [35] LOG: received fast shutdown request
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Update temp_user table charset"
mainflux-users-db | ok
mainflux-users-db |
mainflux-users-db |
mainflux-users-db | Success. You can now start the database server using:
mainflux-users-db |
mainflux-users-db | pg_ctl -D /var/lib/postgresql/data -l logfile start
mainflux-users-db |
mainflux-things-db | 2021-12-06 07:11:51.424 UTC [35] LOG: aborting any active transactions
mainflux-users-db | waiting for server to start....2021-12-06 07:11:50.412 UTC [35] LOG: starting PostgreSQL 13.1 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.2.1_pre1) 10.2.1 20201203, 64-bit
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_email - v1"
mainflux-things-db | 2021-12-06 07:11:51.425 UTC [35] LOG: background worker "logical replication launcher" (PID 42) exited with exit code 1
mainflux-users-db | 2021-12-06 07:11:50.422 UTC [35] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_org_id - v1"
mainflux-things-db | 2021-12-06 07:11:51.425 UTC [37] LOG: shutting down
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_code - v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_status - v1"
mainflux-users-db | 2021-12-06 07:11:50.436 UTC [36] LOG: database system was shut down at 2021-12-06 07:11:50 UTC
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Rename table temp_user to temp_user_tmp_qwerty - v1"
mainflux-things-db | 2021-12-06 07:11:51.445 UTC [35] LOG: database system is shut down
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create temp_user v2"
mainflux-users-db | 2021-12-06 07:11:50.439 UTC [35] LOG: database system is ready to accept connections
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_email - v2"
mainflux-things-db | done
mainflux-things-db | server stopped
mainflux-things-db |
mainflux-things-db | PostgreSQL init process complete; ready for start up.
mainflux-things-db |
mainflux-users-db | done
mainflux-users-db | server started
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_org_id - v2"
mainflux-things-db | 2021-12-06 07:11:51.543 UTC [1] LOG: starting PostgreSQL 13.1 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.2.1_pre1) 10.2.1 20201203, 64-bit
mainflux-things-db | 2021-12-06 07:11:51.544 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
mainflux-things-db | 2021-12-06 07:11:51.544 UTC [1] LOG: listening on IPv6 address "::", port 5432
mainflux-things-db | 2021-12-06 07:11:51.549 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_code - v2"
mainflux-users-db | CREATE DATABASE
mainflux-users-db |
mainflux-users-db |
mainflux-users-db | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
mainflux-users-db |
mainflux-users-db | 2021-12-06 07:11:50.678 UTC [35] LOG: received fast shutdown request
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_status - v2"
mainflux-things-db | 2021-12-06 07:11:51.567 UTC [49] LOG: database system was shut down at 2021-12-06 07:11:51 UTC
mainflux-things-db | 2021-12-06 07:11:51.571 UTC [1] LOG: database system is ready to accept connections
mainflux-users-db | waiting for server to shut down....2021-12-06 07:11:50.681 UTC [35] LOG: aborting any active transactions
mainflux-users-db | 2021-12-06 07:11:50.681 UTC [35] LOG: background worker "logical replication launcher" (PID 42) exited with exit code 1
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="copy temp_user v1 to v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="drop temp_user_tmp_qwerty"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Set created for temp users that will otherwise prematurely expire"
mainflux-users-db | 2021-12-06 07:11:50.684 UTC [37] LOG: shutting down
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create star table"
mainflux-users-db | 2021-12-06 07:11:50.705 UTC [35] LOG: database system is shut down
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="add unique index star.user_id_dashboard_id"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create org table v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index UQE_org_name - v1"
mainflux-users-db | done
mainflux-users-db | server stopped
mainflux-users-db |
mainflux-users-db | PostgreSQL init process complete; ready for start up.
mainflux-users-db |
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create org_user table v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_org_user_org_id - v1"
mainflux-users-db | 2021-12-06 07:11:50.796 UTC [1] LOG: starting PostgreSQL 13.1 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.2.1_pre1) 10.2.1 20201203, 64-bit
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index UQE_org_user_org_id_user_id - v1"
mainflux-users-db | 2021-12-06 07:11:50.796 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Update org table charset"
mainflux-users-db | 2021-12-06 07:11:50.796 UTC [1] LOG: listening on IPv6 address "::", port 5432
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Update org_user table charset"
mainflux-users-db | 2021-12-06 07:11:50.804 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Migrate all Read Only Viewers to Viewers"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create dashboard table"
mainflux-users-db | 2021-12-06 07:11:50.810 UTC [49] LOG: database system was shut down at 2021-12-06 07:11:50 UTC
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="add index dashboard.account_id"
mainflux-users-db | 2021-12-06 07:11:50.815 UTC [1] LOG: database system is ready to accept connections
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="add unique index dashboard_account_id_slug"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create dashboard_tag table"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="add unique index dashboard_tag.dasboard_id_term"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_dashboard_tag_dashboard_id_term - v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Rename table dashboard to dashboard_v1 - v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create dashboard v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_dashboard_org_id - v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index UQE_dashboard_org_id_slug - v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="copy dashboard v1 to v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="drop table dashboard_v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="alter dashboard.data to mediumtext v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add column updated_by in dashboard - v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add column created_by in dashboard - v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add column gnetId in dashboard"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add index for gnetId in dashboard"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add column plugin_id in dashboard"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add index for plugin_id in dashboard"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add index for dashboard_id in dashboard_tag"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Update dashboard table charset"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Update dashboard_tag table charset"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add column folder_id in dashboard"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add column isFolder in dashboard"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add column has_acl in dashboard"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add column uid in dashboard"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Update uid column values in dashboard"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add unique index dashboard_org_id_uid"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Remove unique index org_id_slug"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Update dashboard title length"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add unique index for dashboard_org_id_title_folder_id"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create dashboard_provisioning"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Rename table dashboard_provisioning to dashboard_provisioning_tmp_qwerty - v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create dashboard_provisioning v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_dashboard_provisioning_dashboard_id - v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_dashboard_provisioning_dashboard_id_name - v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="copy dashboard_provisioning v1 to v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="drop dashboard_provisioning_tmp_qwerty"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add check_sum column"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add index for dashboard_title"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="delete tags for deleted dashboards"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="delete stars for deleted dashboards"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create data_source table"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="add index data_source.account_id"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="add unique index data_source.account_id_name"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_data_source_account_id - v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_data_source_account_id_name - v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Rename table data_source to data_source_v1 - v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create data_source table v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_data_source_org_id - v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index UQE_data_source_org_id_name - v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="copy data_source v1 to v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Drop old table data_source_v1 #2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add column with_credentials"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add secure json data column"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Update data_source table charset"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Update initial version to 1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add read_only data column"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Migrate logging ds to loki ds"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Update json_data with nulls"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add uid column"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Update uid value"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add unique index datasource_org_id_uid"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create api_key table"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="add index api_key.account_id"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="add index api_key.key"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="add index api_key.account_id_name"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_api_key_account_id - v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_api_key_key - v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_api_key_account_id_name - v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Rename table api_key to api_key_v1 - v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create api_key table v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_api_key_org_id - v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index UQE_api_key_key - v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index UQE_api_key_org_id_name - v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="copy api_key v1 to v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Drop old table api_key_v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Update api_key table charset"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add expires to api_key table"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create dashboard_snapshot table v4"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="drop table dashboard_snapshot_v4 #1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create dashboard_snapshot table v5 #2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index UQE_dashboard_snapshot_key - v5"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index UQE_dashboard_snapshot_delete_key - v5"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_dashboard_snapshot_user_id - v5"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="alter dashboard_snapshot to mediumtext v2"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Update dashboard_snapshot table charset"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add column external_delete_url to dashboard_snapshots table"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add encrypted dashboard json column"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Change dashboard_encrypted column to MEDIUMBLOB"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create quota table v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index UQE_quota_org_id_user_id_target - v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Update quota table charset"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create plugin_setting table"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="create index UQE_plugin_setting_org_id_plugin_id - v1"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Add column plugin_version to plugin_settings"
mainflux-grafana | t=2021-12-06T07:11:50+0000 lvl=info msg="Executing migration" logger=migrator id="Update plugin_setting table charset"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create session table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Drop old table playlist table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Drop old table playlist_item table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create playlist table v2"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create playlist item table v2"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Update playlist table charset"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Update playlist_item table charset"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="drop preferences table v2"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="drop preferences table v3"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create preferences table v3"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Update preferences table charset"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add column team_id in preferences"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Update team_id column values in preferences"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create alert table v1"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index alert org_id & id "
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index alert state"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index alert dashboard_id"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Create alert_rule_tag table v1"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add unique index alert_rule_tag.alert_id_tag_id"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create alert_notification table v1"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add column is_default"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add column frequency"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add column send_reminder"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add column disable_resolve_message"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index alert_notification org_id & name"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Update alert table charset"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Update alert_notification table charset"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create notification_journal table v1"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index notification_journal org_id & alert_id & notifier_id"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="drop alert_notification_journal"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create alert_notification_state table v1"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index alert_notification_state org_id & alert_id & notifier_id"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add for to alert table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add column uid in alert_notification"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Update uid column values in alert_notification"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add unique index alert_notification_org_id_uid"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Remove unique index org_id_name"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add column secure_settings in alert_notification"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="alter alert.settings to mediumtext"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add non-unique index alert_notification_state_alert_id"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add non-unique index alert_rule_tag_alert_id"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Drop old annotation table v4"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create annotation table v5"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index annotation 0 v3"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index annotation 1 v3"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index annotation 2 v3"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index annotation 3 v3"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index annotation 4 v3"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Update annotation table charset"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add column region_id to annotation table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Drop category_id index"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add column tags to annotation table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Create annotation_tag table v2"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add unique index annotation_tag.annotation_id_tag_id"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Update alert annotations and set TEXT to empty"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add created time to annotation table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add updated time to annotation table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add index for created in annotation table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add index for updated in annotation table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Convert existing annotations from seconds to milliseconds"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add epoch_end column"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add index for epoch_end"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Make epoch_end the same as epoch"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Move region to single row"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Remove index org_id_epoch from annotation table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Remove index org_id_dashboard_id_panel_id_epoch from annotation table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add index for org_id_dashboard_id_epoch_end_epoch on annotation table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add index for org_id_epoch_end_epoch on annotation table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Remove index org_id_epoch_epoch_end from annotation table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add index for alert_id on annotation table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create test_data table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create dashboard_version table v1"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index dashboard_version.dashboard_id"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add unique index dashboard_version.dashboard_id and dashboard_version.version"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Set dashboard version to 1 where 0"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="save existing dashboard data in dashboard_version table v1"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="alter dashboard_version.data to mediumtext v1"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create team table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index team.org_id"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add unique index team_org_id_name"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create team member table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index team_member.org_id"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add unique index team_member_org_id_team_id_user_id"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index team_member.team_id"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add column email to team table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add column external to team_member table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add column permission to team_member table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create dashboard acl table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index dashboard_acl_dashboard_id"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add unique index dashboard_acl_dashboard_id_user_id"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add unique index dashboard_acl_dashboard_id_team_id"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="save default acl rules in dashboard_acl table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="delete acl rules for deleted dashboards and folders"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create tag table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index tag.key_value"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create login attempt table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index login_attempt.username"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_login_attempt_username - v1"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Rename table login_attempt to login_attempt_tmp_qwerty - v1"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create login_attempt v2"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_login_attempt_username - v2"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="copy login_attempt v1 to v2"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="drop login_attempt_tmp_qwerty"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create user auth table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create index IDX_user_auth_auth_module_auth_id - v1"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="alter user_auth.auth_id to length 190"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add OAuth access token to user_auth"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add OAuth refresh token to user_auth"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add OAuth token type to user_auth"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add OAuth expiry to user_auth"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="Add index to user_id column in user_auth"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create server_lock table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index server_lock.operation_uid"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create user auth token table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add unique index user_auth_token.auth_token"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add unique index user_auth_token.prev_auth_token"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index user_auth_token.user_id"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create cache_data table"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add unique index cache_data.cache_key"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="create short_url table v1"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Executing migration" logger=migrator id="add index short_url.org_id-uid"
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Created default admin" logger=sqlstore user=admin
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Starting plugin search" logger=plugins
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="Registering plugin" logger=plugins id=input
mainflux-grafana | t=2021-12-06T07:11:51+0000 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl= socket=
mainflux-users exited with code 1
mainflux-mqtt | {"level":"info","message":"Broker not ready: Get \"http://vernemq:8888/health\": dial tcp 192.168.128.12:8888: connect: connection refused, next try in 707.045635ms","ts":"2021-12-06T07:11:53.333742112Z"}
mainflux-users | {"level":"info","message":"gRPC communication is not encrypted","ts":"2021-12-06T07:11:53.487874119Z"}
mainflux-users | {"level":"error","message":"failed to create admin user: rpc error: code = Internal desc = internal server error","ts":"2021-12-06T07:11:53.493338283Z"}
mainflux-vernemq | config is OK
mainflux-vernemq | -config /vernemq/data/generated.configs/app.2021.12.06.07.11.52.config -args_file /vernemq/bin/../etc/vm.args -vm_args /vernemq/bin/../etc/vm.args
mainflux-vernemq | Exec: /vernemq/bin/../erts-10.7.2.7/bin/erlexec -boot /vernemq/bin/../releases/1.11.0/vernemq -config /vernemq/data/generated.configs/app.2021.12.06.07.11.52.config -args_file /vernemq/bin/../etc/vm.args -vm_args /vernemq/bin/../etc/vm.args -pa /vernemq/bin/../lib/erlio-patches -- console -noshell -noinput
mainflux-vernemq | Root: /vernemq/bin/..
mainflux-mqtt | {"level":"info","message":"Broker not ready: Get \"http://vernemq:8888/health\": dial tcp 192.168.128.12:8888: connect: connection refused, next try in 1.318040285s","ts":"2021-12-06T07:11:54.041660662Z"}
mainflux-users exited with code 1
mainflux-mqtt | {"level":"info","message":"gRPC communication is not encrypted","ts":"2021-12-06T07:11:55.385234886Z"}
mainflux-mqtt | {"level":"info","message":"Starting MQTT proxy on port 1883","ts":"2021-12-06T07:11:55.404198657Z"}
mainflux-mqtt | {"level":"info","message":"Starting MQTT over WS proxy on port 8080","ts":"2021-12-06T07:11:55.404247435Z"}
mainflux-users | {"level":"info","message":"gRPC communication is not encrypted","ts":"2021-12-06T07:11:56.639190348Z"}
mainflux-users | {"level":"error","message":"failed to create admin user: rpc error: code = Internal desc = internal server error","ts":"2021-12-06T07:11:56.643706272Z"}
mainflux-users exited with code 1
mainflux-users | {"level":"error","message":"failed to create admin user: rpc error: code = Internal desc = internal server error","ts":"2021-12-06T07:12:00.209069781Z"}
mainflux-users exited with code 1
mainflux-users | {"level":"error","message":"failed to create admin user: rpc error: code = Internal desc = internal server error","ts":"2021-12-06T07:12:06.963524065Z"}
mainflux-users exited with code 1
mainflux-users | {"level":"info","message":"gRPC communication is not encrypted","ts":"2021-12-06T07:12:20.120880132Z"}
mainflux-users | {"level":"error","message":"failed to create admin user: rpc error: code = Internal desc = internal server error","ts":"2021-12-06T07:12:20.127002404Z"}
mainflux-users exited with code 1
mainflux-users | {"level":"info","message":"gRPC communication is not encrypted","ts":"2021-12-06T07:12:46.071403731Z"}
mainflux-users | {"level":"error","message":"failed to create admin user: rpc error: code = Internal desc = internal server error","ts":"2021-12-06T07:12:46.076051947Z"}
mainflux-users exited with code 1
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:12:50.489+00:00"},"s":"I", "c":"STORAGE", "id":22430, "ctx":"WTCheckpointThread","msg":"WiredTiger message","attr":{"message":"[1638774770:489364][1:0x7f3573040700], WT_SESSION.checkpoint: [WT_VERB_CHECKPOINT_PROGRESS] saving checkpoint snapshot min: 34, snapshot max: 34 snapshot count: 0, oldest timestamp: (0, 0) , meta checkpoint timestamp: (0, 0)"}}
mainflux-users | {"level":"error","message":"failed to create admin user: rpc error: code = Internal desc = internal server error","ts":"2021-12-06T07:13:37.625897935Z"}
mainflux-users exited with code 1
mainflux-twins-db | {"t":{"$date":"2021-12-06T07:13:50.519+00:00"},"s":"I", "c":"STORAGE", "id":22430, "ctx":"WTCheckpointThread","msg":"WiredTiger message","attr":{"message":"[1638774830:519534][1:0x7f3573040700], WT_SESSION.checkpoint: [WT_VERB_CHECKPOINT_PROGRESS] saving checkpoint snapshot min: 36, snapshot max: 36 snapshot count: 0, oldest timestamp: (0, 0) , meta checkpoint timestamp: (0, 0)"}}
^CGracefully stopping... (press Ctrl+C again to force)
Stopping mainflux-nginx ... done
Stopping mainflux-mqtt ... done
Stopping mainflux-http ... done
Stopping mainflux-things ... done
Stopping mainflux-users ... done
Stopping mainflux-twins ... done
Stopping mainflux-bootstrap ... done
Stopping mainflux-influxdb-writer ... done
Stopping mainflux-opcua ... done
Stopping mainflux-auth ... done
Stopping mainflux-grafana ... done
Stopping mainflux-vernemq ... done
Stopping mainflux-ui ... done
Stopping mainflux-influxdb-reader ... done
Stopping mainflux-auth-redis ... done
Stopping mainflux-nats ... done
Stopping mainflux-provision ... done
Stopping mainflux-things-db ... done
Stopping mainflux-auth-db ... done
Stopping mainflux-twins-db ... done
Stopping mainflux-es-redis ... done
Stopping mainflux-users-db ... done
Stopping mainflux-influxdb ... done
Stopping mainflux-bootstrap-db ... done
Stopping mainflux-jaeger ... done
Stopping mainflux-opcua-redis ... donepiratkin commented
Added keto, rebuilt, ui started. Now how to login?
$ git clone https://github.com/mainflux/mainflux.git
...
$ make cli
CGO_ENABLED=0 GOOS= GOARCH=amd64 GOARM= go build -mod=vendor -ldflags "-s -w" -o build/mainflux-cli cmd/cli/main.go
$ build/mainflux-cli provision test
error: failed to create entity : 403 Forbiddenalso tried
$ npm install
...
** Angular Live Development Server is listening on localhost:4200, open your browser on http://localhost:4200/ **
✔ Compiled successfully.connect to
http://localhost:4200
But I can't create users.
When I access the http://localhost:3000 port, I cannot login. I get a 405 error in the logs:
mainflux-ui | 192.168.192.1 - - [07/Dec/2021:06:57:08 +0000] "POST /tokens HTTP/1.1" 405 576 "http://localhost:3000/ui/auth/login" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36" "-"
manuio commented
@piratkin UI is exposed on port 80, port 3000 is for internal usage. Try with localhost/ui.
Regarding the bug with Users creation you should probably wait a little bit since this page is on development. The API recently changed because of Groups and policies. When it will be ready Users page will be present in the production image.
piratkin commented
It worked, thanks).
Can you please tell me if I understood correctly, ui can be run separately via npm? Is it correct to use separate ui and separate mainflux? Or is it only suitable for development mode?
manuio commented
@piratkin Great! I'll close this issue then.
npm is used to run angular-cli and it's only for development. For production we recommend to use a docker image.
You can build your own with make ui and then make run. This commands will build an image and then run the docker composition with the latest UI image.
piratkin commented
I'm completely confused what is angular-cli and how is it different from ui(ngx-admin)?
As a result, the ui from the main branch (as well as from the v0.12.1 tag also did not work) did not work for me, it was not possible to log in with credentials (admin@example.com 12345678).
For this reason, I decided not to use the ui, but to launch mainflux from the main branch and in addition to it, run npm start from the ui/main branch, which launches ngx-admin. And it somehow worked, but it gives errors very unreliably, some functions through the web interface do not work.
Is it possible to somehow log into the ui on port 3000 because 80 and 443 are not responding at all? When deploying from mainflux/ui.
manuio commented
@piratkin You can find information about angular-cli here: https://angular.io/cli Basically it's used to run the UI in localhost:4200 and have a dynamic compilation that allows you to develop easily. When you are done with your development you can build a new docker image with make ui and use it by running again the docker composition with make run (latest tag will be used here: https://github.com/mainflux/ui/blob/master/docker/docker-compose.yml#L29).
I'm not sure about you login bug. You are maybe doing something wrong...
Port 3000 is for internal usage. The one that should work is 80.
piratkin commented
Specified version 0.12.1 for all images in the config, disabled the lora adapter because I don't plan on using a separate lora server, and finally I was able to log into the web ui.
- image: mainflux/ui:latest
+ image: mainflux/ui:${MF_RELEASE_TAG}
- image: mainflux/auth:latest
+ image: mainflux/auth:${MF_RELEASE_TAG}
- image: mainflux/users:latest
+ image: mainflux/users:${MF_RELEASE_TAG}
etc
...The problem was that I already have a web server on my server and occupies ports 80/443, changing the configuration in .env does not solve the problem. ports are not changed in the nginx config. decided not to change the nginx server configs, and instead corrected docker-compose.json:
...
nginx:
image: nginx:1.16.0-alpine
container_name: mainflux-nginx
restart: on-failure
volumes:
- ./nginx/nginx-${AUTH-key}.conf:/etc/nginx/nginx.conf.template
- ./nginx/entrypoint.sh:/entrypoint.sh
- ./nginx/snippets:/etc/nginx/snippets
- ./ssl/authorization.js:/etc/nginx/authorization.js
- ./ssl/certs/mainflux-server.crt:/etc/ssl/certs/mainflux-server.crt
- ./ssl/certs/ca.crt:/etc/ssl/certs/ca.crt
- ./ssl/certs/mainflux-server.key:/etc/ssl/private/mainflux-server.key
- ./ssl/dhparam.pem:/etc/ssl/certs/dhparam.pem
ports:
#- ${MF_NGINX_HTTP_PORT}:${MF_NGINX_HTTP_PORT}
#- ${MF_NGINX_SSL_PORT}:${MF_NGINX_SSL_PORT}
- ${MF_NGINX_HTTP_PORT}:80
- ${MF_NGINX_SSL_PORT}:443
- ${MF_NGINX_MQTT_PORT}:${MF_NGINX_MQTT_PORT}
- ${MF_NGINX_MQTTS_PORT}:${MF_NGINX_MQTTS_PORT}
networks:
- mainflux-base-net
env_file:
- .env
command: /entrypoint.sh
depends_on:
- things
- users
...I didn't mention it right away because I was running
mainflux/uion ports80/443, but for some unknown reason I couldn't login because it was something else.
piratkin commented
I have found another problem. Because I changed ports 80/443, it turned out that mainflux-cli is doesn't work:
./mainflux-cli users token admin@example.com 12345678
error: failed to create entity : 403 Forbiddenmainflux-cli tries to use port 80, but since it is busy, it receives a 403 error from the server, which is even more confusing.
It would be nice to make the process of changing standard ports easier and more informative. Hope my post on this will be helpful.