504(Gateway Time-out) on GET request











up vote
0
down vote

favorite












I'm using Java, to execute GET request with HttpURLConnection to our server. (Timeout is infinity)



       HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setConnectTimeout(0);
con.setReadTimeout(0);


The server configured as spring Controller and access the MySQL DB and run some queries.



In some of the cases, if the call takes 50 seconds, I get 504(Gateway Time-out) response from the server,
and in the server, there is an exception:
"org.apache.catalina.connector.ClientAbortException: null .... Caused by: java.net.SocketException: Connection reset"



What is the reason for the timeout?
It's in the Server side? or on the client side?



Thanks.










share|improve this question







New contributor




lefispam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
























    up vote
    0
    down vote

    favorite












    I'm using Java, to execute GET request with HttpURLConnection to our server. (Timeout is infinity)



           HttpURLConnection con = (HttpURLConnection) obj.openConnection();
    con.setConnectTimeout(0);
    con.setReadTimeout(0);


    The server configured as spring Controller and access the MySQL DB and run some queries.



    In some of the cases, if the call takes 50 seconds, I get 504(Gateway Time-out) response from the server,
    and in the server, there is an exception:
    "org.apache.catalina.connector.ClientAbortException: null .... Caused by: java.net.SocketException: Connection reset"



    What is the reason for the timeout?
    It's in the Server side? or on the client side?



    Thanks.










    share|improve this question







    New contributor




    lefispam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.






















      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I'm using Java, to execute GET request with HttpURLConnection to our server. (Timeout is infinity)



             HttpURLConnection con = (HttpURLConnection) obj.openConnection();
      con.setConnectTimeout(0);
      con.setReadTimeout(0);


      The server configured as spring Controller and access the MySQL DB and run some queries.



      In some of the cases, if the call takes 50 seconds, I get 504(Gateway Time-out) response from the server,
      and in the server, there is an exception:
      "org.apache.catalina.connector.ClientAbortException: null .... Caused by: java.net.SocketException: Connection reset"



      What is the reason for the timeout?
      It's in the Server side? or on the client side?



      Thanks.










      share|improve this question







      New contributor




      lefispam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      I'm using Java, to execute GET request with HttpURLConnection to our server. (Timeout is infinity)



             HttpURLConnection con = (HttpURLConnection) obj.openConnection();
      con.setConnectTimeout(0);
      con.setReadTimeout(0);


      The server configured as spring Controller and access the MySQL DB and run some queries.



      In some of the cases, if the call takes 50 seconds, I get 504(Gateway Time-out) response from the server,
      and in the server, there is an exception:
      "org.apache.catalina.connector.ClientAbortException: null .... Caused by: java.net.SocketException: Connection reset"



      What is the reason for the timeout?
      It's in the Server side? or on the client side?



      Thanks.







      spring rest spring-mvc model-view-controller controller






      share|improve this question







      New contributor




      lefispam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question







      New contributor




      lefispam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question






      New contributor




      lefispam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 19 hours ago









      lefispam

      1




      1




      New contributor




      lefispam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      lefispam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      lefispam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.
























          1 Answer
          1






          active

          oldest

          votes

















          up vote
          0
          down vote













          MySQL has it's own internal timeout settings. Try running the following sql queries against this database before running your other queries:



          SET SESSION connect_timeout=300;
          SET SESSION max_execution_time=300;


          I believe these variables can also be set to 0 (infinity), although this may affect the stability of the service, and could influence other concurrent users (if there are any).






          share|improve this answer





















            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });






            lefispam is a new contributor. Be nice, and check out our Code of Conduct.










             

            draft saved


            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53371076%2f504gateway-time-out-on-get-request%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            0
            down vote













            MySQL has it's own internal timeout settings. Try running the following sql queries against this database before running your other queries:



            SET SESSION connect_timeout=300;
            SET SESSION max_execution_time=300;


            I believe these variables can also be set to 0 (infinity), although this may affect the stability of the service, and could influence other concurrent users (if there are any).






            share|improve this answer

























              up vote
              0
              down vote













              MySQL has it's own internal timeout settings. Try running the following sql queries against this database before running your other queries:



              SET SESSION connect_timeout=300;
              SET SESSION max_execution_time=300;


              I believe these variables can also be set to 0 (infinity), although this may affect the stability of the service, and could influence other concurrent users (if there are any).






              share|improve this answer























                up vote
                0
                down vote










                up vote
                0
                down vote









                MySQL has it's own internal timeout settings. Try running the following sql queries against this database before running your other queries:



                SET SESSION connect_timeout=300;
                SET SESSION max_execution_time=300;


                I believe these variables can also be set to 0 (infinity), although this may affect the stability of the service, and could influence other concurrent users (if there are any).






                share|improve this answer












                MySQL has it's own internal timeout settings. Try running the following sql queries against this database before running your other queries:



                SET SESSION connect_timeout=300;
                SET SESSION max_execution_time=300;


                I believe these variables can also be set to 0 (infinity), although this may affect the stability of the service, and could influence other concurrent users (if there are any).







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 19 hours ago









                Regan Koopmans

                1416




                1416






















                    lefispam is a new contributor. Be nice, and check out our Code of Conduct.










                     

                    draft saved


                    draft discarded


















                    lefispam is a new contributor. Be nice, and check out our Code of Conduct.













                    lefispam is a new contributor. Be nice, and check out our Code of Conduct.












                    lefispam is a new contributor. Be nice, and check out our Code of Conduct.















                     


                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53371076%2f504gateway-time-out-on-get-request%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Wiesbaden

                    Marschland

                    Dieringhausen