[GNC] Get Quotes hung

[Kalpesh Patel]

Oh, that definitely is going to be a big factor in your response times for pricing queries. In that case OS is not going to matter… the debugging steps I suggested assumed issue from the US and further assumed that it is seen when fetching prices for US listed companies. Your connection from ISP (called last mile) might be fast in foreign country but not from your ISP to another upstream one (called core to core connection) as who knows what route it traverses or takes in both directions for data transit.

 

In that case software VPN likely will make a difference … I am not vouching any specific ones but I use surfshark when need to test development from different countries. Any VPN is likely to be very cheap especially if multi-year package is purchased.

 

At the end of the day, this is not a problem due to GNUCash or F::Q packages as these variables are out of their control…

 

From: Fred Tydeman <tydeman.fred at gmail.com> 
Sent: Friday, August 23, 2024 3:11 PM
To: Kalpesh Patel <kalpesh.patel at usa.net>
Cc: R Losey <rlosey at gmail.com>; Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Get Quotes hung

 

It appears to depend upon where one is in the world.

Last week in Medellin, Colombia, it took hours on a fast internet connection.

Today, in the Miami, FL, USA, airport, it takes about one minute.

I have tried

  Fedora Linux 40 with Gnucash 5.8

  Fedora Linux 37 with Gnucash 4.14

Both take the same time in either place in the world

 

On Wed, Aug 21, 2024 at 7:41 PM Kalpesh Patel <kalpesh.patel at usa.net <mailto:kalpesh.patel at usa.net> > wrote:

That length of time indicates that it is getting into some sort of weird loop for each security being fetched and then it waits to time out each one of those fetch call.

 

There are number of things you can try to narrow down the issue on your system:

 

-          See if you can time the fetch of single quote using the CLI that is provided with GNUCash.

-          Start with a blank file and then define just one or two securities. BK and BRK-A are good to start with and time that.

-          Run GNUCash in a debug mode and enable trace mode to capture the output to see if there is something not so right.

 

Some odd reason it feels like you are on a Linux Distro and it might be setup to auto configure for a proxy server but one does not exist. Although it wound ’t take that length of time to timeout.

 

Last thing that I can think is that your Perl distribution is busted badly enough and might need a fresh install. 

 

What version of GNUCash, and on which type and version of OS are running on?

 

From: Fred Tydeman <tydeman.fred at gmail.com <mailto:tydeman.fred at gmail.com> > 
Sent: Wednesday, August 21, 2024 7:08 PM
To: Kalpesh Patel <kalpesh.patel at usa.net <mailto:kalpesh.patel at usa.net> >
Cc: R Losey <rlosey at gmail.com <mailto:rlosey at gmail.com> >; Gnucash Users <gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> >
Subject: Re: [GNC] Get Quotes hung

 

 

 

On Wed, Aug 21, 2024 at 11:38 AM Kalpesh Patel <kalpesh.patel at usa.net <mailto:kalpesh.patel at usa.net> > wrote:

I am not seeing such delays and completes in about a minute. I do see failures now and then and that has all to do with Yahoo performing maintenance on their systems and is transient in nature.

Silly question I'll ask: did you verify that all those stocks are getting data from Yahoo and Yahoo only via yahoo_json as a single source? You aren't running any VPN session, knowingly or unknowingly, right?

 

No VPN.

All stocks are getting from yahoo.