search

devicehive / devicehive-docker

Run DeviceHive Docker containers with Docker Compose and on Kubernetes
92 stars 58 forks source link

Postgres syntax error with android-ble device #54

Closed DurandA closed 6 years ago

DurandA commented 6 years ago

I installed my own instance of devicehive using the provided docker-compose installation.

When using the android-ble client, the ble-android device is not created. This problem does not appear when using the playground. Apparently, the GET on /api/rest/device/devicehive-ble-android-a89e returns a 500 error:

postgres_1     | 2018-05-22 11:15:20.065 UTC [87] ERROR:  syntax error at or near ")" at character 1353
postgres_1     | 2018-05-22 11:15:20.065 UTC [87] STATEMENT:  select device0_.id as id1_1_0_, network1_.id as id1_4_1_, user3_.id as id1_3_2_, devicetype4_.id as id1_2_3_, device0_.blocked as blocked2_1_0_, device0_.data as data3_1_0_, device0_.device_id as device_i4_1_0_, device0_.device_type_id as device_t6_1_0_, device0_.name as name5_1_0_, device0_.network_id as network_7_1_0_, network1_.description as descript2_4_1_, network1_.entity_version as entity_v3_4_1_, network1_.name as name4_4_1_, user3_.all_device_types_available as all_devi2_3_2_, user3_.data as data3_3_2_, user3_.intro_reviewed as intro_re4_3_2_, user3_.last_login as last_log5_3_2_, user3_.login as login6_3_2_, user3_.login_attempts as login_at7_3_2_, user3_.password_hash as password8_3_2_, user3_.password_salt as password9_3_2_, user3_.role as role10_3_2_, user3_.status as status11_3_2_, users2_.network_id as network_1_7_0__, users2_.user_id as user_id2_7_0__, devicetype4_.description as descript2_2_3_, devicetype4_.entity_version as entity_v3_2_3_, devicetype4_.name as name4_2_3_ from device device0_ left outer join network network1_ on device0_.network_id=network1_.id left outer join user_network users2_ on network1_.id=users2_.network_id left outer join "dh_user" user3_ on users2_.user_id=user3_.id left outer join device_type devicetype4_ on device0_.device_type_id=devicetype4_.id where user3_.id=2 and (network1_.id in ()) and (device0_.device_id in ($1))
dh_proxy_1     | 213.55.176.254 - - [22/May/2018:11:15:20 +0000] "GET /api/rest/device/devicehive-ble-android-a89e HTTP/1.1" 500 50 "-" "okhttp/3.9.0" "-"

Here are the running containers (why do I have two mqtt brokers?):

CONTAINER ID        IMAGE                                   COMMAND                  CREATED             STATUS              PORTS                                                 NAMES
f09a39e75580        devicehive/devicehive-proxy:3.4.5.1     "/bin/sh ./proxy-sta…"   2 minutes ago       Up 2 minutes        80/tcp, 0.0.0.0:80->8080/tcp, 0.0.0.0:443->8443/tcp   rdbms-image_dh_proxy_1
98e7b0e4330e        devicehive/devicehive-frontend:3.4.5    "/bin/sh ./devicehiv…"   2 minutes ago       Up 2 minutes        0.0.0.0:8080->8080/tcp                                rdbms-image_dh_frontend_1
5fad3e889be9        devicehive/devicehive-auth:3.4.5        "/bin/sh ./devicehiv…"   2 minutes ago       Up 2 minutes        0.0.0.0:8090->8090/tcp                                rdbms-image_dh_auth_1
828945a15163        devicehive/devicehive-backend:3.4.5     "/bin/sh ./devicehiv…"   2 minutes ago       Up 2 minutes                                                              rdbms-image_dh_backend_1
0921c15bd37d        devicehive/devicehive-ws-proxy:1.1.0    "pm2-docker src/prox…"   2 hours ago         Up 2 hours          3000/tcp                                              rdbms-image_wsproxyext_1
bcaba87cf323        devicehive/devicehive-plugin:3.4.5      "/bin/sh ./devicehiv…"   2 hours ago         Up 2 hours          0.0.0.0:8110->8110/tcp                                rdbms-image_dh_plugin_1
c06e35cf120f        wurstmeister/kafka:1.0.0                "bash -c 'while true…"   2 hours ago         Up 2 hours                                                                rdbms-image_kafka-cleanup_1
a31417e6933c        devicehive/devicehive-mqtt:1.1.0        "pm2-docker src/brok…"   2 hours ago         Up 2 hours          1883/tcp                                              rdbms-image_mqtt_broker1_1
9c0ccce9a7a2        devicehive/devicehive-mqtt:1.1.0        "pm2-docker src/brok…"   2 hours ago         Up 2 hours          1883/tcp                                              rdbms-image_mqtt_broker2_1
6dbd581f38fb        redis:alpine                            "docker-entrypoint.s…"   2 hours ago         Up 2 hours          6379/tcp                                              rdbms-image_redis_1
2d73602140f1        devicehive/devicehive-ws-proxy:1.1.0    "pm2-docker src/prox…"   4 days ago          Up 2 hours          3000/tcp                                              rdbms-image_wsproxy_1
5f7536cfcf9d        wurstmeister/kafka:1.0.0                "start-kafka.sh"         4 days ago          Up 2 hours          0.0.0.0:9092->9092/tcp                                rdbms-image_kafka_1
f3126328ca7e        devicehive/devicehive-hazelcast:3.4.5   "./server.sh"            4 days ago          Up 2 hours          0.0.0.0:5701->5701/tcp                                rdbms-image_hazelcast_1
ead533a9d2b0        wurstmeister/zookeeper                  "/bin/sh -c '/usr/sb…"   4 days ago          Up 2 hours          22/tcp, 2888/tcp, 3888/tcp, 0.0.0.0:2181->2181/tcp    rdbms-image_zookeeper_1
912e10e5ecdd        postgres:10                             "docker-entrypoint.s…"   4 days ago          Up 2 hours          0.0.0.0:5432->5432/tcp                                rdbms-image_postgres_1
DurandA commented 6 years ago

Fixed in devicehive-docker 3.5.0.