[GNC] update quotes hanging

[John Ralls]

Have you updated Finance::Quote to 1.49? It throttles the Alphavantage requests to comply with their 5 quotes/minute restriction.

You might also consider using yahoo_json for as many non-currency commodities as you can. Yahoo! still supports the json API and doesn't require throttling.

Regards,
John Ralls

> On Sep 23, 2019, at 6:59 PM, Jon Schewe <jpschewe at mtu.net> wrote:
> 
> I just tried 3.7.0 from ppa:sicklylife/gnucash and the behavior hasn't changed.
> 
> On 9/23/19 2:25 PM, Adrien Monteleone wrote:
>> There are no updates to the 2.6 series any longer. 2.6.21 is the last one and nearly 18 months old. There have been eight 3.x releases so far.
>> 
>> You can build from source, or there are debs floating around on the list for 3.7 that you should be able to install on 18.04.
>> 
>> 
>> Regards,
>> Adrien
>> 
>>> On Sep 23, 2019 w39d266, at 5:58 AM, Jon Schewe <jpschewe at mtu.net> wrote:
>>> 
>>> I'm using GnuCash 2.6.19 that ships with Ubuntu 18.04. I'm finding that the update price quotes process is hanging, both from within GnuCash and from the command line.
>>> 
>>> I've created a CSV file of all of my commodities and tested them individual using gnc-fq-dump and they all return fairly quickly. Not all of them have valid prices, but none hang. Below is the script that I have used with cron in the past to update my quotes at regular intervals.
>>> 
>>> When the process is running I can strace it and I find that the perl process is usually in a write call writing "use of uninitialized value".
>>> 
>>> Does anyone have suggestions to determine why updating the quotes is hanging?
>>> 
>>> Is this a problem with this version of gnucash? I would prefer to stick with the version of gnucash that comes with my distribution so that I get automatic updates, however I can build a custom version if that is what is needed.
>>> 
>>> 
>>> #!/bin/sh
>>> 
>>> ALPHAVANTAGE_API_KEY=XXXXXXX
>>> export ALPHAVANTAGE_API_KEY
>>> env $(dbus-launch) sh -c 'trap "kill $DBUS_SESSION_BUS_PID" EXIT; /usr/bin/gnucash --add-price-quotes ${HOME}/Documents/banking/gnucash/accounts.gnucash' 2>&1 | grep -v "Found Finance::Quote"
>>> 
>>> -- 
>>> http://mtu.net/~jpschewe
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> -- 
> http://mtu.net/~jpschewe
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.