Hi Danial,
I guess I still need help with this. It looks like some of the SSL errors
are still getting through even with wrapping. Here's the latest backtrace:
OpenSSL::SSL::SSLError: SSL_connect SYSCALL returned=5 errno=0 state=SSLv3
read server hello A
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpclient-2.3.0.1/lib/httpclient/session.rb:302:in
`connect'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpclient-2.3.0.1/lib/httpclient/session.rb:302:in
`ssl_connect'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpclient-2.3.0.1/lib/httpclient/session.rb:759:in
`block in connect'
from
/path/to/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/timeout.rb:68:in
`timeout'
from
/path/to/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/timeout.rb:99:in
`timeout'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpclient-2.3.0.1/lib/httpclient/session.rb:750:in
`connect'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpclient-2.3.0.1/lib/httpclient/session.rb:608:in
`query'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpclient-2.3.0.1/lib/httpclient/session.rb:163:in
`query'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpclient-2.3.0.1/lib/httpclient.rb:1080:in
`do_get_block'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpclient-2.3.0.1/lib/httpclient.rb:884:in
`block in do_request'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpclient-2.3.0.1/lib/httpclient.rb:978:in
`protect_keep_alive_disconnected'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpclient-2.3.0.1/lib/httpclient.rb:883:in
`do_request'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpclient-2.3.0.1/lib/httpclient.rb:771:in
`request'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpclient-2.3.0.1/lib/httpclient.rb:681:in
`post'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpi-1.0.0/lib/httpi/adapter/httpclient.rb:32:in
`block in post'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpi-1.0.0/lib/httpi/adapter/httpclient.rb:64:in
`do_request'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpi-1.0.0/lib/httpi/adapter/httpclient.rb:31:in
`post'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpi-1.0.0/lib/httpi.rb:96:in
`block in post'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpi-1.0.0/lib/httpi.rb:193:in
`with_adapter'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/httpi-1.0.0/lib/httpi.rb:94:in
`post'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/google-ads-common-0.8.0/lib/ads_common/http.rb:52:in
`post_response'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/google-ads-common-0.8.0/lib/ads_common/auth/client_login_handler.rb:151:in
`generate_token'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/google-ads-common-0.8.0/lib/ads_common/auth/client_login_handler.rb:119:in
`create_token'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/google-ads-common-0.8.0/lib/ads_common/auth/base_handler.rb:50:in
`get_token'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/google-ads-common-0.8.0/lib/ads_common/auth/client_login_handler.rb:67:in
`auth_string'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/google-adwords-api-0.7.1/lib/adwords_api/report_header_handler.rb:53:in
`headers'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/google-adwords-api-0.7.1/lib/adwords_api/report_utils.rb:177:in
`get_report_request_headers'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/google-adwords-api-0.7.1/lib/adwords_api/report_utils.rb:153:in
`make_adhoc_request'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/google-adwords-api-0.7.1/lib/adwords_api/report_utils.rb:139:in
`get_report_response'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/google-adwords-api-0.7.1/lib/adwords_api/report_utils.rb:57:in
`download_report'
from
/path/to/app/shared/bundle/ruby/1.9.1/gems/google-adwords-api-0.7.1/lib/adwords_api/report_utils.rb:76:in
`download_report_as_file'
Let me know if there's anything else I can send you to try to resolve this.
As I mentioned, the adwords_xml.log is basically empty while the ssl errors
are occuring, so I don't have any log information I can send you for the
SOAP requests and responses.
Jeremy
On Tuesday, December 25, 2012 5:27:13 AM UTC-5, Jeremy Aube wrote:
>
> nevermind. Just got some new SSL errors in this morning.
>
> On Monday, December 24, 2012 8:17:36 AM UTC-5, Jeremy Aube wrote:
>>
>> Just to follow up on this, updating to the latest version of OpenSSL
>> seems to have fixed the issue. We haven't had any SSL errors for 2 days now.
>>
>> On Monday, December 17, 2012 8:54:21 AM UTC-5, Jeremy Aube wrote:
>>>
>>> Right now we're wrapping the calls with code to keep retrying the calls
>>> until they succeed, or fail too many times.
>>>
>>>
>>> On Tuesday, December 11, 2012 5:34:56 AM UTC-5, Nilesh Avhad wrote:
>>>>
>>>> Hi Jeremy,
>>>>
>>>> I am facing a similar issue. How did you resolve this?
>>>>
>>>> Regards,
>>>> Nilesh
>>>>
>>>> On Friday, 7 December 2012 18:47:20 UTC+5:30, Jeremy Aube wrote:
>>>>>
>>>>> Hi Danial,
>>>>>
>>>>> We checked the logs and it looks like no requests are being made
>>>>> during the time when the errors occur. We had a 2 hour gap this morning
>>>>> where no requests or responses were recorded, which happened at the time
>>>>> time as all the errors. The errors also seem to be coinciding with
>>>>> increased network activity on our side, so it seems very likely at this
>>>>> point that it's an issue on our side rather than with the AdWords API or
>>>>> the ruby client library.
>>>>>
>>>>> Thanks for your help!
>>>>>
>>>>> On Wednesday, December 5, 2012 4:16:23 AM UTC-5, AdWords API Advisor
>>>>> wrote:
>>>>>>
>>>>>> Hello Jeremy,
>>>>>>
>>>>>>
>>>>>> Can you please send me full debug output logs for such a request over
>>>>>> email (please make sure not to share it with the whole group as it
>>>>>> may
>>>>>> contain sensitive information).
>>>>>>
>>>>>>
>>>>>> -Danial, AdWords API Team.
>>>>>>
>>>>>>
>>>>>> Original Message Follows:
>>>>>> ------------------------
>>>>>> From: Jeremy Aube <[email protected]>
>>>>>> Subject: Re: OpenSSL::SSL::SSLError: SSL_connect SYSCALL returned=5
>>>>>> errno=0
>>>>>> state=SSLv3 read server session ticket A
>>>>>> Date: Mon, 3 Dec 2012 05:05:36 -0800 (PST)
>>>>>>
>>>>>> > Hi Danial,
>>>>>> >
>>>>>> > We installed the httpclient gem, but the SSL error still pops up
>>>>>> now and
>>>>>>
>>>>>> > then.
>>>>>> >
>>>>>> >
>>>>>> > On Monday, November 19, 2012 3:12:55 AM UTC-5, Danial Klimkin
>>>>>> wrote:
>>>>>> > >
>>>>>> > > Hello Jeremy,
>>>>>> > >
>>>>>> > >
>>>>>> > > It appears you are getting network timeouts. From the stack I can
>>>>>> see
>>>>>> you
>>>>>> > > are using the Ruby library with net_http adapter. I recommend
>>>>>> trying
>>>>>> > > httpclient instead.
>>>>>> > >
>>>>>> > > All you need to do it to install httpclient gem like:
>>>>>> > > gem install httpclient
>>>>>> > >
>>>>>> > >
>>>>>> > > -Danial, AdWords API Team.
>>>>>> > >
>>>>>> > >
>>>>>> > > On Friday, November 9, 2012 5:02:22 PM UTC+4, Jeremy Aube wrote:
>>>>>> > >>
>>>>>> > >> Last night at 4:27am ET, we had an ad-hoc campaign performance
>>>>>> report
>>>>>>
>>>>>> > >> fail with the following error:
>>>>>> > >>
>>>>>> > >> OpenSSL::SSL::SSLError: SSL_connect SYSCALL returned=5 errno=0
>>>>>> > >> state=SSLv3 read server session ticket A
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/net/http.rb:799:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `connect'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/net/http.rb:799:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `block in connect'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/timeout.rb:68:in
>>>>>>
>>>>>>
>>>>>> > >> `timeout'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/timeout.rb:99:in
>>>>>>
>>>>>>
>>>>>> > >> `timeout'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/net/http.rb:799:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `connect'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/net/http.rb:755:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `do_start'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/net/http.rb:744:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `start'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/<dist>/<app>/shared/bundle/ruby/1.9.1/gems/httpi-1.0.0/lib/httpi/adapter/net_http.rb:75:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `do_request'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/<dist>/<app>/shared/bundle/ruby/1.9.1/gems/httpi-1.0.0/lib/httpi/adapter/net_http.rb:30:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `post'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/<dist>/<app>/shared/bundle/ruby/1.9.1/gems/httpi-1.0.0/lib/httpi.rb:96:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `block in post'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/<dist>/<app>/shared/bundle/ruby/1.9.1/gems/httpi-1.0.0/lib/httpi.rb:193:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `with_adapter'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/<dist>/<app>/shared/bundle/ruby/1.9.1/gems/httpi-1.0.0/lib/httpi.rb:94:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `post'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/<dist>/<app>/shared/bundle/ruby/1.9.1/gems/google-ads-common-0.8.0/lib/ads_common/http.rb:52:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `post_response'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/<dist>/<app>/shared/bundle/ruby/1.9.1/gems/google-ads-common-0.8.0/lib/ads_common/auth/client_login_handler.rb:151:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `generate_token'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/<dist>/<app>/shared/bundle/ruby/1.9.1/gems/google-ads-common-0.8.0/lib/ads_common/auth/client_login_handler.rb:119:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `create_token'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/<dist>/<app>/shared/bundle/ruby/1.9.1/gems/google-ads-common-0.8.0/lib/ads_common/auth/base_handler.rb:50:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `get_token'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/<dist>/<app>/shared/bundle/ruby/1.9.1/gems/google-ads-common-0.8.0/lib/ads_common/auth/client_login_handler.rb:67:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `auth_string'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/<dist>/<app>/shared/bundle/ruby/1.9.1/gems/google-adwords-api-0.7.1/lib/adwords_api/report_header_handler.rb:53:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `headers'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/<dist>/<app>/shared/bundle/ruby/1.9.1/gems/google-adwords-api-0.7.1/lib/adwords_api/report_utils.rb:177:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `get_report_request_headers'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/<dist>/<app>/shared/bundle/ruby/1.9.1/gems/google-adwords-api-0.7.1/lib/adwords_api/report_utils.rb:153:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `make_adhoc_request'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/<dist>/<app>/shared/bundle/ruby/1.9.1/gems/google-adwords-api-0.7.1/lib/adwords_api/report_utils.rb:139:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `get_report_response'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/<dist>/<app>/shared/bundle/ruby/1.9.1/gems/google-adwords-api-0.7.1/lib/adwords_api/report_utils.rb:57:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `download_report'
>>>>>> > >> from
>>>>>> > >>
>>>>>> /Users/<user>/<dist>/<app>/shared/bundle/ruby/1.9.1/gems/google-adwords-api-0.7.1/lib/adwords_api/report_utils.rb:76:in
>>>>>>
>>>>>>
>>>>>>
>>>>>> > >> `download_report_as_file'
>>>>>> > >>
>>>>>> > >> We're using v201209. In the past we've had this error come up
>>>>>> > >> intermittently, sometimes occurring several times in a row
>>>>>> before
>>>>>> > >> disappearing for a few weeks. Currently we're not doing anything
>>>>>> to
>>>>>> handle
>>>>>> > >> it--I'm not sure if we can just wait 30 seconds and try
>>>>>> again--but
>>>>>> > >> everything did work fine when it ran the following hour. Also,
>>>>>> based
>>>>>> on the
>>>>>> > >> timing, it's possible that it spent a full 7 minutes trying to
>>>>>> download
>>>>>> > >> this report before coming up with the error; normally it would
>>>>>> complete
>>>>>> > >> nearly instantly.
>>>>>> > >>
>>>>>> > >
>>>>>> >
>>>>>> > --
>>>>>> > --
>>>>>> > =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
>>>>>> > Also find us on our blog and discussion group:
>>>>>> > http://adwordsapi.blogspot.com
>>>>>> > http://groups.google.com/group/adwords-api
>>>>>> > =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
>>>>>> >
>>>>>> > You received this message because you are subscribed to the Google
>>>>>> > Groups "AdWords API Forum" group.
>>>>>> > To post to this group, send email to [email protected]
>>>>>> > To unsubscribe from this group, send email to
>>>>>> > [email protected]
>>>>>> > For more options, visit this group at
>>>>>> > http://groups.google.com/group/adwords-api?hl=en
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>>
>>>>>>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en