can't find relation
Musketeer7 opened this issue · 4 comments
Musketeer7 commented
hi
I have set up the kit based on bitholla/hollaex-core:1.20.3 on a ubuntu 18.04 machine, but I can't sign up and it says that 'can't find relation "users"` and this is the case for all relations .so setup commands doesn't make any migrations on database. is there any way to form the data model of application?
hollaex logs:
Container : local_hollaex-nginx_1
There are no logs for container : local_hollaex-nginx_1.
Container : local_hollaex-server-api_1
(node:1) [DEP0097] DeprecationWarning: Using a domain property in MakeCallback is deprecated. Use the async_context variant of MakeCallback or the AsyncResource class instead.
{"level":"info","message":"1170e54b-34d5-470d-8ab7-9414cb5e8cc2 middleware/hostname localhost 172.19.0.1 http://localhost:8080 OPTIONS /v1/login","timestamp":"2020-02-02T13:43:18.610Z"}
{"level":"verbose","message":"1170e54b-34d5-470d-8ab7-9414cb5e8cc2 origin http://localhost:8080","timestamp":"2020-02-02T13:43:18.610Z"}
{"message":"::ffff:172.19.0.8 - - [02/Feb/2020:13:43:18 +0000] \"OPTIONS /v1/login HTTP/1.0\" 204 0 \"http://localhost:8080/login\" \"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36\"\n ","level":"info","timestamp":"2020-02-02T13:43:18.612Z"}
{"level":"info","message":"b8414a8b-1fae-4342-a29a-5252551bc446 middleware/hostname localhost 172.19.0.1 http://localhost:8080 POST /v1/login","timestamp":"2020-02-02T13:43:18.615Z"}
{"level":"verbose","message":"b8414a8b-1fae-4342-a29a-5252551bc446 origin http://localhost:8080","timestamp":"2020-02-02T13:43:18.615Z"}
{"level":"debug","message":"b8414a8b-1fae-4342-a29a-5252551bc446 controllers/user/loginPost koosha_pooyeshgar@outlook.com 03AOLTBLSRSO0ARAJMZbi13juNBNung_HUYWBmp22UDQipTJqHqzUwzYFlgFS6kK_0XD3iy5qnE95vQYl3slaAp7jCSaUAtcjy-b1xe73bpA2PhrxUk5xyQKubicdFc2YDIexmKtkqbjQfIW6ETiKwkVHrApWjwLUiYknwG68mFFqHqbf2ZpVudw1OGw9xlUp-vzy_98xmkhSt_0fxsdYidt4LPd-ryIzEOHhNCXsHlr8_yWSo8KkVPBE8vxtRLfd1K4HikSZxPomo_-OHj_12sdFxBF6DigDKkiI_3QNxlC3qFETMSfZNMh7_93A0PIgtxWF-jPeWyRauG3_VFZaaVXh3O8U1_J9gyo6PKM864Ug3btG4y0PQn9o4IQkZWtxWeFchwxqowOpAH6heMNzOjcox_F_tcL1MfA 172.19.0.1","timestamp":"2020-02-02T13:43:18.627Z"}
{"message":"Executing (default): SELECT \"id\", \"email\", \"password\", \"verification_level\", \"otp_enabled\", \"activated\", \"is_admin\", \"is_support\", \"is_supervisor\", \"is_kyc\", \"settings\" FROM \"Users\" AS \"User\" WHERE \"User\".\"email\" = 'koosha_pooyeshgar@outlook.com'; ","level":"debug","timestamp":"2020-02-02T13:43:18.637Z"}
(node:1) [DEP0097] DeprecationWarning: Using a domain property in MakeCallback is deprecated. Use the async_context variant of MakeCallback or the AsyncResource class instead.
{"level":"error","message":"b8414a8b-1fae-4342-a29a-5252551bc446 controllers/user/loginPost {\"name\":\"SequelizeDatabaseError\",\"parent\":{\"name\":\"error\",\"length\":105,\"severity\":\"ERROR\",\"code\":\"42P01\",\"position\":\"154\",\"file\":\"parse_relation.c\",\"line\":\"1180\",\"routine\":\"parserOpenTable\",\"sql\":\"SELECT \\\"id\\\", \\\"email\\\", \\\"password\\\", \\\"verification_level\\\", \\\"otp_enabled\\\", \\\"activated\\\", \\\"is_admin\\\", \\\"is_support\\\", \\\"is_supervisor\\\", \\\"is_kyc\\\", \\\"settings\\\" FROM \\\"Users\\\" AS \\\"User\\\" WHERE \\\"User\\\".\\\"email\\\" = 'koosha_pooyeshgar@outlook.com';\"},\"original\":{\"name\":\"error\",\"length\":105,\"severity\":\"ERROR\",\"code\":\"42P01\",\"position\":\"154\",\"file\":\"parse_relation.c\",\"line\":\"1180\",\"routine\":\"parserOpenTable\",\"sql\":\"SELECT \\\"id\\\", \\\"email\\\", \\\"password\\\", \\\"verification_level\\\", \\\"otp_enabled\\\", \\\"activated\\\", \\\"is_admin\\\", \\\"is_support\\\", \\\"is_supervisor\\\", \\\"is_kyc\\\", \\\"settings\\\" FROM \\\"Users\\\" AS \\\"User\\\" WHERE \\\"User\\\".\\\"email\\\" = 'koosha_pooyeshgar@outlook.com';\"},\"sql\":\"SELECT \\\"id\\\", \\\"email\\\", \\\"password\\\", \\\"verification_level\\\", \\\"otp_enabled\\\", \\\"activated\\\", \\\"is_admin\\\", \\\"is_support\\\", \\\"is_supervisor\\\", \\\"is_kyc\\\", \\\"settings\\\" FROM \\\"Users\\\" AS \\\"User\\\" WHERE \\\"User\\\".\\\"email\\\" = 'koosha_pooyeshgar@outlook.com';\"}","timestamp":"2020-02-02T13:43:18.639Z"}
{"message":"::ffff:172.19.0.8 - - [02/Feb/2020:13:43:18 +0000] \"POST /v1/login HTTP/1.0\" 403 35 \"http://localhost:8080/login\" \"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36\"\n ","level":"info","timestamp":"2020-02-02T13:43:18.640Z"}
Container : local_hollaex-server-stream_1
{"message":"Ẃebsocket server listening on port: 10080 ","level":"debug","timestamp":"2020-02-02T13:40:45.437Z"}
{"message":"Connect to PubSub ","level":"verbose","timestamp":"2020-02-02T13:40:45.447Z"}
{"message":"Connect to redis ","level":"verbose","timestamp":"2020-02-02T13:40:45.448Z"}
{"message":"Authenticated to PubSub ","level":"verbose","timestamp":"2020-02-02T13:40:45.451Z"}
{"message":"PubSub is ready ","level":"info","timestamp":"2020-02-02T13:40:45.451Z"}
{"message":"Authenticated to redis ","level":"verbose","timestamp":"2020-02-02T13:40:45.452Z"}
{"message":"Redis is ready ","level":"info","timestamp":"2020-02-02T13:40:45.452Z"}
{"level":"debug","message":"retore_bannedUsers {}","timestamp":"2020-02-02T13:40:45.455Z"}
{"message":"Executing (default): SELECT \"id\", \"name\", \"activated\", \"initialized\", \"blocked\", \"activation_code\", \"url\", \"created_at\", \"updated_at\" FROM \"Statuses\" AS \"Status\" LIMIT 1; ","level":"debug","timestamp":"2020-02-02T13:40:46.288Z"}
{"level":"error","message":"init/checkStatus relation \"Statuses\" does not exist","timestamp":"2020-02-02T13:40:46.290Z"}
Container : local_hollaex-server-engine-xht-usdt_1
{"message":"Authenticated to redis ","level":"verbose","timestamp":"2020-02-02T13:40:45.674Z"}
{"message":"Redis is ready ","level":"info","timestamp":"2020-02-02T13:40:45.674Z"}
{"level":"verbose","message":"queue/queue-orderbook/onSubscribe channel:init 1","timestamp":"2020-02-02T13:40:45.677Z"}
{"level":"verbose","message":"queue/queue-orderbook/onSubscribe channel:orderbook:xht-usdt 2","timestamp":"2020-02-02T13:40:45.677Z"}
{"level":"verbose","message":"Left actives 0","timestamp":"2020-02-02T13:40:45.677Z"}
{"level":"verbose","message":"Left inactives 0","timestamp":"2020-02-02T13:40:45.678Z"}
{"level":"verbose","message":"Completed 0","timestamp":"2020-02-02T13:40:45.678Z"}
{"level":"verbose","message":"Failed 0","timestamp":"2020-02-02T13:40:45.678Z"}
{"message":"Executing (default): SELECT \"id\", \"name\", \"activated\", \"initialized\", \"blocked\", \"activation_code\", \"url\", \"created_at\", \"updated_at\" FROM \"Statuses\" AS \"Status\" LIMIT 1; ","level":"debug","timestamp":"2020-02-02T13:40:46.288Z"}
{"level":"error","message":"init/checkStatus relation \"Statuses\" does not exist","timestamp":"2020-02-02T13:40:46.290Z"}
Container : client_hollaex-web_1
172.20.0.1 - - [02/Feb/2020:13:43:08 +0000] "GET /assets/acounts/account-icons-09.svg HTTP/1.1" 304 0 "http://localhost:8080/login" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36" "-"
172.20.0.1 - - [02/Feb/2020:13:43:08 +0000] "GET /assets/fonts/raleway/Raleway-Regular.ttf HTTP/1.1" 304 0 "http://localhost:8080/static/css/main.fa856bea.chunk.css" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36" "-"
172.20.0.1 - - [02/Feb/2020:13:43:08 +0000] "GET /assets/fonts/raleway/Raleway-Medium.ttf HTTP/1.1" 304 0 "http://localhost:8080/static/css/main.fa856bea.chunk.css" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36" "-"
172.20.0.1 - - [02/Feb/2020:13:43:08 +0000] "GET /assets/acounts/account-icons-19.svg HTTP/1.1" 304 0 "http://localhost:8080/login" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36" "-"
172.20.0.1 - - [02/Feb/2020:13:43:16 +0000] "GET /static/js/2.b0dbc78b.chunk.js.map HTTP/1.1" 304 0 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36" "-"
172.20.0.1 - - [02/Feb/2020:13:43:16 +0000] "GET /static/js/main.837e89f3.chunk.js.map HTTP/1.1" 304 0 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36" "-"
172.20.0.1 - - [02/Feb/2020:13:43:16 +0000] "GET /css/bootstrap.min.css.map HTTP/1.1" 304 0 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36" "-"
172.20.0.1 - - [02/Feb/2020:13:43:16 +0000] "GET /static/css/2.2a428127.chunk.css.map HTTP/1.1" 304 0 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36" "-"
172.20.0.1 - - [02/Feb/2020:13:43:16 +0000] "GET /css/bootstrap-grid.min.css.map HTTP/1.1" 304 0 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36" "-"
172.20.0.1 - - [02/Feb/2020:13:43:16 +0000] "GET /static/css/main.fa856bea.chunk.css.map HTTP/1.1" 304 0 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36" "-"
Container : local_hollaex-influxdb_1
There are no logs for container : local_hollaex-influxdb_1.
Container : local_hollaex-redis_1
1:M 02 Feb 2020 13:40:15.486 # Redis is now ready to exit, bye bye...
1:C 02 Feb 2020 13:40:23.651 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
1:C 02 Feb 2020 13:40:23.651 # Redis version=5.0.5, bits=64, commit=00000000, modified=0, pid=1, just started
1:C 02 Feb 2020 13:40:23.651 # Configuration loaded
1:M 02 Feb 2020 13:40:23.652 * Running mode=standalone, port=6379.
1:M 02 Feb 2020 13:40:23.652 # WARNING: The TCP backlog setting of 511 cannot be enforced because /proc/sys/net/core/somaxconn is set to the lower value of 128.
1:M 02 Feb 2020 13:40:23.652 # Server initialized
1:M 02 Feb 2020 13:40:23.652 # 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.
1:M 02 Feb 2020 13:40:23.652 # 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.
1:M 02 Feb 2020 13:40:23.652 * Ready to accept connections
Container : local_hollaex-db_1
2020-02-02 13:40:46.929 UTC [37] ERROR: relation "Coins" does not exist at character 204
2020-02-02 13:40:46.929 UTC [37] STATEMENT: SELECT "id", "fullname", "symbol", "active", "allow_deposit", "allow_withdrawal", "withdrawal_fee", "min", "max", "increment_unit", "deposit_limits", "withdrawal_limits", "created_at", "updated_at" FROM "Coins" AS "Coin";
2020-02-02 13:40:46.929 UTC [39] ERROR: relation "Pairs" does not exist at character 202
2020-02-02 13:40:46.929 UTC [39] STATEMENT: SELECT "id", "name", "pair_base", "pair_2", "taker_fees", "maker_fees", "min_size", "max_size", "min_price", "max_price", "increment_size", "increment_price", "active", "created_at", "updated_at" FROM "Pairs" AS "Pair";
2020-02-02 13:43:18.637 UTC [45] ERROR: relation "Users" does not exist at character 154
2020-02-02 13:43:18.637 UTC [45] STATEMENT: SELECT "id", "email", "password", "verification_level", "otp_enabled", "activated", "is_admin", "is_support", "is_supervisor", "is_kyc", "settings" FROM "Users" AS "User" WHERE "User"."email" = 'koosha_pooyeshgar@outlook.com';
2020-02-02 13:54:25.757 UTC [70] ERROR: relation "Coins" does not exist at character 13
2020-02-02 13:54:25.757 UTC [70] STATEMENT: INSERT INTO "Coins" ("id","fullname","symbol","active","allow_deposit","allow_withdrawal","withdrawal_fee","min","max","increment_unit","deposit_limits","withdrawal_limits","created_at","updated_at") VALUES (DEFAULT,'Mammad','mmm',true,true,true,0.001,0.001,10000,0.001,'{"1":0,"2":0,"3":0,"4":0}','{"1":0,"2":0,"3":0,"4":0}',NOW(),NOW()) RETURNING *;
2020-02-02 13:56:10.479 UTC [73] ERROR: syntax error at or near "selec" at character 1
2020-02-02 13:56:10.479 UTC [73] STATEMENT: selec * from Users;
There are no logs for container : local_hollaex-db_1.
Displayed last 10 lines of logs from container(s).
To see logs from specific container(s), Please run 'hollaex logs --target <NAME_OF_COMPONENT> --lines <LINES_OF_LOGS>'.
For example, 'hollaex logs --target api --lines 20'.
abeikverdi commented
Musketeer7 commented
You havent setup and initialized your exchange. Use the following docs and make sure your exchange is setup. If you already have setup the exchange, this link might be useful.
Thanks for your reply.
As a matter of fact, I was following the docs (or at least that's what I think I've been doing). I did use hollaex setup command, skipped a few of fields to default, donno if that would have caused the problem?
abeikverdi commented
Some of those are optional and you can skip some configurations. I don't think thats the issue.
Try running hollaex restart and if it doesn't work terminate it and start over. You also better pass the files generated through dash.bitholla.com instead of manual CLI form.
Musketeer7 commented
Some of those are optional and you can skip some configurations. I don't think thats the issue.
Try running
hollaex restartand if it doesn't work terminate it and start over. You also better pass the files generated through dash.bitholla.com instead of manual CLI form.
I stopped the exchanged, made a fresh setup, then started the new exchange and it's working now. It must have been some sort of a mistake on my part - don't know what exactly though.
Thanks again. Cheers.