Remote server refuses longer HTTP POST requests

[mik1234mc]

Hi all,

my application connects usign Python Request library to ArcadeDB over HTTP API (and SQL). So far, I run the application together with ArcadeDB server on the same machine (debian). Now, I moved the server on a different machine (also debian, same ArcadeDB version). I have an issue with longer HTTP POST commands (>3500B, this is just indicative threshold) exceeding one TCP packet. The server accepts these longer packets usually 2times (after ArcadeDB server reset) and then returns code 400 and { "error" : "Command text is null"}. If I dump a communication between the server(10.21.0.7.2480) and the application (10.21.99.22), I see 2 first correct HTTP requests (starting at 13:04:45.334757 and 13:04:53.625676) and the subsequent HTTP POST requests (starting at 13:04:58.484945) are refused (at 13:04:58.486308) before all the request packets are received. I played with ArcadeDB settings on buffer size and timeout values, but no improvement. Do you have any hints why local deploment works, but remote access only very limited?

tcpdump 'tcp port 2480'
tcpdump: verbose output suppressed, use -v[v]... for full protocol decode
listening on tun0, link-type RAW (Raw IP), snapshot length 262144 bytes
13:04:45.306006 IP 10.21.99.22.56974 > 10.21.0.7.2480: Flags [S], seq 2287200538, win 64240, options [mss 1288,sackOK,TS val 231553502 ecr 0,nop,wscale 7], length 0
13:04:45.306026 IP 10.21.0.7.2480 > 10.21.99.22.56974: Flags [S.], seq 3780681345, ack 2287200539, win 65160, options [mss 1460,sackOK,TS val 797755808 ecr 231553502,nop,wscale 7], length 0
13:04:45.334484 IP 10.21.99.22.56974 > 10.21.0.7.2480: Flags [.], ack 1, win 502, options [nop,nop,TS val 231553525 ecr 797755808], length 0
13:04:45.334757 IP 10.21.99.22.56974 > 10.21.0.7.2480: Flags [.], seq 1:1277, ack 1, win 502, options [nop,nop,TS val 231553526 ecr 797755808], length 1276
13:04:45.334781 IP 10.21.0.7.2480 > 10.21.99.22.56974: Flags [.], ack 1277, win 501, options [nop,nop,TS val 797755837 ecr 231553526], length 0
13:04:45.338556 IP 10.21.99.22.56974 > 10.21.0.7.2480: Flags [P.], seq 1277:2553, ack 1, win 502, options [nop,nop,TS val 231553526 ecr 797755808], length 1276
13:04:45.338582 IP 10.21.0.7.2480 > 10.21.99.22.56974: Flags [.], ack 2553, win 494, options [nop,nop,TS val 797755841 ecr 231553526], length 0
13:04:45.342089 IP 10.21.99.22.56974 > 10.21.0.7.2480: Flags [.], seq 2553:3829, ack 1, win 502, options [nop,nop,TS val 231553526 ecr 797755808], length 1276
13:04:45.342110 IP 10.21.0.7.2480 > 10.21.99.22.56974: Flags [.], ack 3829, win 485, options [nop,nop,TS val 797755844 ecr 231553526], length 0
13:04:45.342477 IP 10.21.99.22.56974 > 10.21.0.7.2480: Flags [P.], seq 3829:4743, ack 1, win 502, options [nop,nop,TS val 231553526 ecr 797755808], length 914
13:04:45.342502 IP 10.21.0.7.2480 > 10.21.99.22.56974: Flags [.], ack 4743, win 478, options [nop,nop,TS val 797755845 ecr 231553526], length 0
13:04:45.561882 IP 10.21.0.7.2480 > 10.21.99.22.56974: Flags [P.], seq 1:300, ack 4743, win 501, options [nop,nop,TS val 797756064 ecr 231553526], length 299
13:04:45.591702 IP 10.21.99.22.56974 > 10.21.0.7.2480: Flags [.], ack 300, win 501, options [nop,nop,TS val 231553785 ecr 797756064], length 0
13:04:53.625676 IP 10.21.99.22.56974 > 10.21.0.7.2480: Flags [.], seq 4743:6019, ack 300, win 501, options [nop,nop,TS val 231561807 ecr 797756064], length 1276
13:04:53.625722 IP 10.21.0.7.2480 > 10.21.99.22.56974: Flags [.], ack 6019, win 501, options [nop,nop,TS val 797764128 ecr 231561807], length 0
13:04:53.625778 IP 10.21.99.22.56974 > 10.21.0.7.2480: Flags [P.], seq 6019:7295, ack 300, win 501, options [nop,nop,TS val 231561807 ecr 797756064], length 1276
13:04:53.625790 IP 10.21.0.7.2480 > 10.21.99.22.56974: Flags [.], ack 7295, win 494, options [nop,nop,TS val 797764128 ecr 231561807], length 0
13:04:53.625845 IP 10.21.99.22.56974 > 10.21.0.7.2480: Flags [.], seq 7295:8571, ack 300, win 501, options [nop,nop,TS val 231561807 ecr 797756064], length 1276
13:04:53.625853 IP 10.21.0.7.2480 > 10.21.99.22.56974: Flags [.], ack 8571, win 485, options [nop,nop,TS val 797764128 ecr 231561807], length 0
13:04:53.625908 IP 10.21.99.22.56974 > 10.21.0.7.2480: Flags [P.], seq 8571:9485, ack 300, win 501, options [nop,nop,TS val 231561807 ecr 797756064], length 914
13:04:53.625917 IP 10.21.0.7.2480 > 10.21.99.22.56974: Flags [.], ack 9485, win 478, options [nop,nop,TS val 797764128 ecr 231561807], length 0
13:04:53.631623 IP 10.21.0.7.2480 > 10.21.99.22.56974: Flags [P.], seq 300:599, ack 9485, win 501, options [nop,nop,TS val 797764134 ecr 231561807], length 299
13:04:53.656532 IP 10.21.99.22.56974 > 10.21.0.7.2480: Flags [.], ack 599, win 501, options [nop,nop,TS val 231561851 ecr 797764134], length 0
13:04:58.484945 IP 10.21.99.22.56974 > 10.21.0.7.2480: Flags [.], seq 9485:10761, ack 599, win 501, options [nop,nop,TS val 231566690 ecr 797764134], length 1276
13:04:58.485474 IP 10.21.99.22.56974 > 10.21.0.7.2480: Flags [P.], seq 10761:12037, ack 599, win 501, options [nop,nop,TS val 231566690 ecr 797764134], length 1276
13:04:58.485480 IP 10.21.0.7.2480 > 10.21.99.22.56974: Flags [.], ack 12037, win 501, options [nop,nop,TS val 797768988 ecr 231566690], length 0
13:04:58.486308 IP 10.21.0.7.2480 > 10.21.99.22.56974: Flags [P.], seq 599:775, ack 12037, win 501, options [nop,nop,TS val 797768988 ecr 231566690], length 176
13:04:58.487250 IP 10.21.99.22.56974 > 10.21.0.7.2480: Flags [.], seq 12037:13313, ack 599, win 501, options [nop,nop,TS val 231566690 ecr 797764134], length 1276
13:04:58.487478 IP 10.21.99.22.56974 > 10.21.0.7.2480: Flags [P.], seq 13313:14227, ack 599, win 501, options [nop,nop,TS val 231566690 ecr 797764134], length 914

[lvca]

It could be related to the timeout we use to read the HTTP request, let me check if we can make it configurable, or at least longer by default.

[lvca]

Just created an issue with a fix #760 (comment). Please let me know if this resolves your issue.