stability between device #649

New Issue

YasserAntonio · 2020-08-30T16:30:58Z

YasserAntonio commented

2020-08-30 16:30:58 +00:00

Using the latest vikunja arm version when i'm connected on Vikunja using my IPhone navigator and trying to use Vikunja conected on my mac navigator at the same time i get at the first attempt (list clicking for exemple) an error 500. It does the same both ways. Here is an extact of the api logs showing the case:

vikunja_api.1.xvockzta93ry@Hestia    | 2020-08-30T16:21:38.204983956Z: WEB      ▶ 10.255.0.2  GET 200 /api/v1/namespaces?is_archived=true&page=1 102.776514ms - Mozilla/5.0 (iPhone; CPU iPhone OS 12_4_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1.2 Mobile/15E148 Safari/604.1
vikunja_api.1.xvockzta93ry@Hestia    | 2020-08-30T16:21:38.270768852Z: WEB      ▶ 10.255.0.2  GET 200 /api/v1/tasks/all?sort_by[]=due_date&sort_by[]=id&order_by[]=desc&order_by[]=desc&filter_by[]=done&filter_value[]=false&filter_comparator[]=equals&filter_concat=and&filter_include_nulls=true&page=1 167.492718ms - Mozilla/5.0 (iPhone; CPU iPhone OS 12_4_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1.2 Mobile/15E148 Safari/604.1
vikunja_api.1.xvockzta93ry@Hestia    | 2020-08-30T16:21:49.904469426Z: ERROR    ▶ handler/ReadAllWeb 594 Error 1045: Access denied for user 'vikunja'@'10.0.0.158' (using password: YES)
vikunja_api.1.xvockzta93ry@Hestia    | 2020-08-30T16:21:49.904904632Z: WEB      ▶ 10.255.0.2  GET 500 /api/v1/lists/2/tasks?sort_by[]=done&sort_by[]=id&order_by[]=asc&order_by[]=desc&filter_by[]=done&filter_value[]=false&filter_comparator[]=equals&filter_concat=and&page=1 10.652389ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36
vikunja_api.1.xvockzta93ry@Hestia    | 2020-08-30T16:21:49.921368759Z: WEB      ▶ 10.255.0.2  GET 200 /api/v1/lists/2 38.163278ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36vikunja_api.1.xvockzta93ry@Hestia    | 2020-08-30T16:22:10.557703028Z: ERROR   ▶ handler/ReadAllWeb 59a Error 1045: Access denied for user 'vikunja'@'10.0.0.158' (using password: YES)
vikunja_api.1.xvockzta93ry@Hestia    | 2020-08-30T16:22:10.558780522Z: WEB      ▶ 10.255.0.2  GET 500 /api/v1/namespaces?is_archived=true&page=1 21.952639ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36
vikunja_api.1.xvockzta93ry@Hestia    | 2020-08-30T16:22:10.560119786Z: ERROR    ▶ handler/ReadAllWeb 59c Error 1045: Access denied for user 'vikunja'@'10.0.0.158' (using password: YES)
vikunja_api.1.xvockzta93ry@Hestia    | 2020-08-30T16:22:10.561623579Z: WEB      ▶ 10.255.0.2  GET 500 /api/v1/tasks/all?sort_by[]=due_date&sort_by[]=id&order_by[]=desc&order_by[]=desc&filter_by[]=done&filter_value[]=false&filter_comparator[]=equals&filter_concat=and&filter_include_nulls=true&page=1 14.605232ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36
vikunja_api.1.xvockzta93ry@Hestia    | 2020-08-30T16:22:21.576852015Z: WEB      ▶ 10.255.0.2  GET 200 /api/v1/teams?page=1 48.5477ms - Mozilla/5.0 (iPhone; CPU iPhone OS 12_4_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1.2 Mobile/15E148 Safari/604.1

As showed the first error is made by the Macintosh navigator whes i was successfully using the Iphone just before and the second error is made when using the Iphone just after the Macintoch browser was stable.

Sometimes being conected else where could create the same error while tryng to conect but it return a wrong username/password message instead of the error code 500 whitch could be missleading and make people retype their credential vene when they are good

Using the latest vikunja arm version when i'm connected on Vikunja using my IPhone navigator and trying to use Vikunja conected on my mac navigator at the same time i get at the first attempt (list clicking for exemple) an error 500. It does the same both ways. Here is an extact of the api logs showing the case: ```base vikunja_api.1.xvockzta93ry@Hestia | 2020-08-30T16:21:38.204983956Z: WEB ▶ 10.255.0.2 GET 200 /api/v1/namespaces?is_archived=true&page=1 102.776514ms - Mozilla/5.0 (iPhone; CPU iPhone OS 12_4_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1.2 Mobile/15E148 Safari/604.1 vikunja_api.1.xvockzta93ry@Hestia | 2020-08-30T16:21:38.270768852Z: WEB ▶ 10.255.0.2 GET 200 /api/v1/tasks/all?sort_by[]=due_date&sort_by[]=id&order_by[]=desc&order_by[]=desc&filter_by[]=done&filter_value[]=false&filter_comparator[]=equals&filter_concat=and&filter_include_nulls=true&page=1 167.492718ms - Mozilla/5.0 (iPhone; CPU iPhone OS 12_4_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1.2 Mobile/15E148 Safari/604.1 vikunja_api.1.xvockzta93ry@Hestia | 2020-08-30T16:21:49.904469426Z: ERROR ▶ handler/ReadAllWeb 594 Error 1045: Access denied for user 'vikunja'@'10.0.0.158' (using password: YES) vikunja_api.1.xvockzta93ry@Hestia | 2020-08-30T16:21:49.904904632Z: WEB ▶ 10.255.0.2 GET 500 /api/v1/lists/2/tasks?sort_by[]=done&sort_by[]=id&order_by[]=asc&order_by[]=desc&filter_by[]=done&filter_value[]=false&filter_comparator[]=equals&filter_concat=and&page=1 10.652389ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36 vikunja_api.1.xvockzta93ry@Hestia | 2020-08-30T16:21:49.921368759Z: WEB ▶ 10.255.0.2 GET 200 /api/v1/lists/2 38.163278ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36vikunja_api.1.xvockzta93ry@Hestia | 2020-08-30T16:22:10.557703028Z: ERROR ▶ handler/ReadAllWeb 59a Error 1045: Access denied for user 'vikunja'@'10.0.0.158' (using password: YES) vikunja_api.1.xvockzta93ry@Hestia | 2020-08-30T16:22:10.558780522Z: WEB ▶ 10.255.0.2 GET 500 /api/v1/namespaces?is_archived=true&page=1 21.952639ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36 vikunja_api.1.xvockzta93ry@Hestia | 2020-08-30T16:22:10.560119786Z: ERROR ▶ handler/ReadAllWeb 59c Error 1045: Access denied for user 'vikunja'@'10.0.0.158' (using password: YES) vikunja_api.1.xvockzta93ry@Hestia | 2020-08-30T16:22:10.561623579Z: WEB ▶ 10.255.0.2 GET 500 /api/v1/tasks/all?sort_by[]=due_date&sort_by[]=id&order_by[]=desc&order_by[]=desc&filter_by[]=done&filter_value[]=false&filter_comparator[]=equals&filter_concat=and&filter_include_nulls=true&page=1 14.605232ms - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36 vikunja_api.1.xvockzta93ry@Hestia | 2020-08-30T16:22:21.576852015Z: WEB ▶ 10.255.0.2 GET 200 /api/v1/teams?page=1 48.5477ms - Mozilla/5.0 (iPhone; CPU iPhone OS 12_4_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1.2 Mobile/15E148 Safari/604.1 ``` As showed the first error is made by the Macintosh navigator whes i was successfully using the Iphone just before and the second error is made when using the Iphone just after the Macintoch browser was stable. Sometimes being conected else where could create the same error while tryng to conect but it return a wrong username/password message instead of the error code 500 whitch could be missleading and make people retype their credential vene when they are good

konrad commented

2020-08-31 07:36:05 +00:00

This line

handler/ReadAllWeb 594 Error 1045: Access denied for user 'vikunja'@'10.0.0.158' (using password: YES)

seems to indicate there's an issue with your database. What database are you using, can you verify it works correctly and is accessible from the server running vikunja?

This line ``` handler/ReadAllWeb 594 Error 1045: Access denied for user 'vikunja'@'10.0.0.158' (using password: YES) ``` seems to indicate there's an issue with your database. What database are you using, can you verify it works correctly and is accessible from the server running vikunja?

YasserAntonio commented

2020-08-31 07:48:39 +00:00

I use the arm image of biarms/mysql:5.7.30-beta-travis. Since my database is located on a mounted nfs server with a ssd cache, network latency might cause this if i'm the only one having this trouble. Did you reproduce this issue in your usual configuration ?

I entered into the vikunja api container and called it without any trouble when i tried it yesterday.

I use the arm image of biarms/mysql:5.7.30-beta-travis. Since my database is located on a mounted nfs server with a ssd cache, network latency might cause this if i'm the only one having this trouble. Did you reproduce this issue in your usual configuration ? I entered into the vikunja api container and called it without any trouble when i tried it yesterday.

konrad commented

2020-08-31 07:55:34 +00:00

I could not reproduce it, but my setup is a bit different. The only way I have seen this issue so far is when using this in a docker environment and the mysql container is starting and not yet ready to accept connections, but that is different from the case you're seeing.

YasserAntonio commented

2020-08-31 08:12:01 +00:00

Okey,seems like nfs + mysql is not the best combo... :

https://dev.mysql.com/doc/refman/5.6/en/disk-issues.html#disk-issues-nfs

You can close this issue, i will rethink my setup.

Okey,seems like nfs + mysql is not the best combo... : https://dev.mysql.com/doc/refman/5.6/en/disk-issues.html#disk-issues-nfs You can close this issue, i will rethink my setup.

konrad closed this issue

2020-08-31 08:24:38 +00:00

konrad referenced this issue from a commit

2024-02-07 14:00:26 +00:00

Update workbox monorepo to v6.2.4 (#649)

Sign in to join this conversation.