Bobrovozka

Untitled

Apr 2nd, 2021 (edited)
389
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. com.google.api.client.googleapis.json.GoogleJsonResponseException: 429 Too Many Requests
  2. GET https://sheets.googleapis.com/v4/spreadsheets/1LvxvhRwVtgwiu1I40L_xKji8d9PnnGTMonidv6rpigg/values/A1:A1
  3. {
  4.   "code" : 429,
  5.   "errors" : [ {
  6.     "domain" : "global",
  7.     "message" : "Resource has been exhausted (e.g. check quota).",
  8.     "reason" : "rateLimitExceeded"
  9.   } ],
  10.   "message" : "Resource has been exhausted (e.g. check quota).",
  11.   "status" : "RESOURCE_EXHAUSTED"
  12. }
  13.     at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:150)
  14.     at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:113)
  15.     at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:40)
  16.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest$1.interceptResponse(AbstractGoogleClientRequest.java:417)
  17.     at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1108)
  18.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:515)
  19.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:448)
  20.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:565)
  21.     at tech.ivoice.apps.adapter.service.GoogleSheetsServiceImpl.readRange(GoogleSheetsServiceImpl.java:24)
  22.     at tech.ivoice.apps.adapter.service.DatabaseListServiceImpl.isReady(DatabaseListServiceImpl.java:62)
  23.     at tech.ivoice.apps.adapter.task.GoogleSheetsLoadTask.process(GoogleSheetsLoadTask.java:30)
  24.     at tech.ivoice.apps.adapter.task.GoogleSheetsLoadTask.run(GoogleSheetsLoadTask.java:23)
  25.     at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
  26.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  27.     at java.lang.reflect.Method.invoke(Method.java:498)
  28.     at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  29.     at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  30.     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  31.     at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  32.     at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  33.     at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  34.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  35.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  36.     at java.lang.Thread.run(Thread.java:748)
  37. java.net.SocketTimeoutException: Read timed out
  38.     at java.net.SocketInputStream.socketRead0(Native Method)
  39.     at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
  40.     at java.net.SocketInputStream.read(SocketInputStream.java:171)
  41.     at java.net.SocketInputStream.read(SocketInputStream.java:141)
  42.     at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)
  43.     at sun.security.ssl.InputRecord.read(InputRecord.java:503)
  44.     at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:975)
  45.     at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:933)
  46.     at sun.security.ssl.AppInputStream.read(AppInputStream.java:105)
  47.     at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
  48.     at java.io.BufferedInputStream.read1(BufferedInputStream.java:286)
  49.     at java.io.BufferedInputStream.read(BufferedInputStream.java:345)
  50.     at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:735)
  51.     at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:678)
  52.     at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1587)
  53.     at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1492)
  54.     at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
  55.     at sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:347)
  56.     at com.google.api.client.http.javanet.NetHttpResponse.<init>(NetHttpResponse.java:36)
  57.     at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:149)
  58.     at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:84)
  59.     at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1012)
  60.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:515)
  61.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:448)
  62.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:565)
  63.     at tech.ivoice.apps.adapter.service.GoogleSheetsServiceImpl.readRange(GoogleSheetsServiceImpl.java:24)
  64.     at tech.ivoice.apps.adapter.service.DatabaseListServiceImpl.isReady(DatabaseListServiceImpl.java:62)
  65.     at tech.ivoice.apps.adapter.task.GoogleSheetsLoadTask.process(GoogleSheetsLoadTask.java:30)
  66.     at tech.ivoice.apps.adapter.task.GoogleSheetsLoadTask.run(GoogleSheetsLoadTask.java:23)
  67.     at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
  68.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  69.     at java.lang.reflect.Method.invoke(Method.java:498)
  70.     at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  71.     at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  72.     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  73.     at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  74.     at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  75.     at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  76.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  77.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  78.     at java.lang.Thread.run(Thread.java:748)
  79. java.net.SocketTimeoutException: Read timed out
  80.     at java.net.SocketInputStream.socketRead0(Native Method)
  81.     at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
  82.     at java.net.SocketInputStream.read(SocketInputStream.java:171)
  83.     at java.net.SocketInputStream.read(SocketInputStream.java:141)
  84.     at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)
  85.     at sun.security.ssl.InputRecord.read(InputRecord.java:503)
  86.     at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:975)
  87.     at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:933)
  88.     at sun.security.ssl.AppInputStream.read(AppInputStream.java:105)
  89.     at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
  90.     at java.io.BufferedInputStream.read1(BufferedInputStream.java:286)
  91.     at java.io.BufferedInputStream.read(BufferedInputStream.java:345)
  92.     at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:735)
  93.     at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:678)
  94.     at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1587)
  95.     at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1492)
  96.     at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
  97.     at sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:347)
  98.     at com.google.api.client.http.javanet.NetHttpResponse.<init>(NetHttpResponse.java:36)
  99.     at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:149)
  100.     at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:84)
  101.     at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1012)
  102.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:515)
  103.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:448)
  104.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:565)
  105.     at tech.ivoice.apps.adapter.service.GoogleSheetsServiceImpl.readRange(GoogleSheetsServiceImpl.java:24)
  106.     at tech.ivoice.apps.adapter.service.DatabaseListServiceImpl.isReady(DatabaseListServiceImpl.java:62)
  107.     at tech.ivoice.apps.adapter.task.GoogleSheetsLoadTask.process(GoogleSheetsLoadTask.java:30)
  108.     at tech.ivoice.apps.adapter.task.GoogleSheetsLoadTask.run(GoogleSheetsLoadTask.java:23)
  109.     at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
  110.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  111.     at java.lang.reflect.Method.invoke(Method.java:498)
  112.     at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  113.     at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  114.     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  115.     at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  116.     at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  117.     at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  118.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  119.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  120.     at java.lang.Thread.run(Thread.java:748)
  121. GET https://sheets.googleapis.com/v4/spreadsheets/1jlzTOyC7ZQ7uXzgz33hgEb8ni7kvQ9Bp13gmH0kSZ6Y/values/A1:A1
  122. {
  123.   "code" : 429,
  124.   "errors" : [ {
  125.     "domain" : "global",
  126.     "message" : "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute per user' of service 'sheets.googleapis.com' for consumer 'project_number:973891363924'.",
  127.     "reason" : "rateLimitExceeded"
  128.   } ],
  129.   "message" : "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute per user' of service 'sheets.googleapis.com' for consumer 'project_number:973891363924'.",
  130.   "status" : "RESOURCE_EXHAUSTED"
  131. }
  132.     at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:150)
  133.     at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:113)
  134.     at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:40)
  135.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest$1.interceptResponse(AbstractGoogleClientRequest.java:417)
  136.     at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1108)
  137.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:515)
  138.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:448)
  139.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:565)
  140.     at tech.ivoice.apps.adapter.service.GoogleSheetsServiceImpl.readRange(GoogleSheetsServiceImpl.java:24)
  141.     at tech.ivoice.apps.adapter.service.DatabaseListServiceImpl.isReady(DatabaseListServiceImpl.java:62)
  142.     at tech.ivoice.apps.adapter.task.GoogleSheetsLoadTask.process(GoogleSheetsLoadTask.java:30)
  143.     at tech.ivoice.apps.adapter.task.GoogleSheetsLoadTask.run(GoogleSheetsLoadTask.java:23)
  144.     at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
  145.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  146.     at java.lang.reflect.Method.invoke(Method.java:498)
  147.     at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  148.     at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  149.     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  150.     at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  151.     at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  152.     at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  153.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  154.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  155.     at java.lang.Thread.run(Thread.java:748)
  156. com.google.api.client.googleapis.json.GoogleJsonResponseException: 429 Too Many Requests
  157. GET https://sheets.googleapis.com/v4/spreadsheets/1jlzTOyC7ZQ7uXzgz33hgEb8ni7kvQ9Bp13gmH0kSZ6Y/values/A1:A1
  158. {
  159.   "code" : 429,
  160.   "errors" : [ {
  161.     "domain" : "global",
  162.     "message" : "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute per user' of service 'sheets.googleapis.com' for consumer 'project_number:973891363924'.",
  163.     "reason" : "rateLimitExceeded"
  164.   } ],
  165.   "message" : "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute per user' of service 'sheets.googleapis.com' for consumer 'project_number:973891363924'.",
  166.   "status" : "RESOURCE_EXHAUSTED"
  167. }
  168.     at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:150)
  169.     at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:113)
  170.     at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:40)
  171.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest$1.interceptResponse(AbstractGoogleClientRequest.java:417)
  172.     at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1108)
  173.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:515)
  174.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:448)
  175.     at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:565)
  176.     at tech.ivoice.apps.adapter.service.GoogleSheetsServiceImpl.readRange(GoogleSheetsServiceImpl.java:24)
  177.     at tech.ivoice.apps.adapter.service.DatabaseListServiceImpl.isReady(DatabaseListServiceImpl.java:62)
  178.     at tech.ivoice.apps.adapter.task.GoogleSheetsLoadTask.process(GoogleSheetsLoadTask.java:30)
  179.     at tech.ivoice.apps.adapter.task.GoogleSheetsLoadTask.run(GoogleSheetsLoadTask.java:23)
  180.     at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
  181.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  182.     at java.lang.reflect.Method.invoke(Method.java:498)
  183.     at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  184.     at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  185.     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  186.     at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  187.     at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  188.     at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  189.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  190.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  191.     at java.lang.Thread.run(Thread.java:748)
  192.  
  193.  
Add Comment
Please, Sign In to add comment