Location Database Update

Location Database Update

[Charles Brown]

[-- Attachment #1: Type: text/plain, Size: 79 bytes --]

The location database has not updated since Feb 24.
Is that to be expected?

Re: Location Database Update

[Rob Brewer]

[-- Attachment #1: Type: text/plain, Size: 424 bytes --]

On Thu, 9 Mar 2023 06:10:37 -0600, Charles Brown wrote:

> The location database has not updated since Feb 24.
> Is that to be expected?

This has happened previously and seems to be resolved after the next 
weekly update. 

There seems to be a problem though when the update fails and /usr/local/
bin/update-location-database hangs causing a 20 to 30% increase in cpu 
usage until it times out after about 3 minutes.


Rob

Re: Location Database Update

[Charles Brown]

[-- Attachment #1: Type: text/plain, Size: 662 bytes --]

I thought perhaps there could be an issue since the location-database 
git repository stopped getting a daily update after Feb 24
See:  https://git.ipfire.org/?p=location/location-database.git

-cab

> On Thu, 9 Mar 2023 06:10:37 -0600, Charles Brown wrote:
>
> >/The location database has not updated since Feb 24. />/Is that to be expected? /
> This has happened previously and seems to be resolved after the next
> weekly update.
>
> There seems to be a problem though when the update fails and /usr/local/
> bin/update-location-database hangs causing a 20 to 30% increase in cpu
> usage until it times out after about 3 minutes.
>
>
> Rob

Re: Location Database Update

[Rob Brewer]

[-- Attachment #1: Type: text/plain, Size: 561 bytes --]

On Fri, 10 Mar 2023 05:47:49 -0600, Charles Brown wrote:

> I thought perhaps there could be an issue since the location-database
> git repository stopped getting a daily update after Feb 24 See: 
> https://git.ipfire.org/?p=location/location-database.git
> 
> -cab
> 

The lack of updates to the database is coincides with my last update

[root(a)ipfire-dev2 ~]# location version
Sat, 25 Feb 2023 05:27:21 GMT

Hopefully someone is looking at reason why the database isn't updating.

The other problem of the high cpu usage also needs to be resolved.


Rob

Re: Location Database Update

[Peter Müller]

[-- Attachment #1: Type: text/plain, Size: 829 bytes --]

Hello *,

thanks for flagging this.

This is not an issue induced by Core Update 173, but on the server side, where
the location database is generated. I'm at it and will keep you updated.

Thanks, and best regards,
Peter Müller


> On Fri, 10 Mar 2023 05:47:49 -0600, Charles Brown wrote:
> 
>> I thought perhaps there could be an issue since the location-database
>> git repository stopped getting a daily update after Feb 24 See: 
>> https://git.ipfire.org/?p=location/location-database.git
>>
>> -cab
>>
> 
> The lack of updates to the database is coincides with my last update
> 
> [root(a)ipfire-dev2 ~]# location version
> Sat, 25 Feb 2023 05:27:21 GMT
> 
> Hopefully someone is looking at reason why the database isn't updating.
> 
> The other problem of the high cpu usage also needs to be resolved.
> 
> 
> Rob
> 
> 

Re: Location Database Update

[Rob Brewer]

[-- Attachment #1: Type: text/plain, Size: 1012 bytes --]

On Sat, 11 Mar 2023 13:29:12 +0000, Peter Müller wrote:

> Hello *,
> 
> thanks for flagging this.
> 
> This is not an issue induced by Core Update 173, but on the server side,
> where the location database is generated. I'm at it and will keep you
> updated.
> 
> Thanks, and best regards,
> Peter Müller
>
 
Thanks Peter looks OK now.

location version
Sat, 11 Mar 2023 15:06:35 GMT

Rob



> 
>> On Fri, 10 Mar 2023 05:47:49 -0600, Charles Brown wrote:
>> 
>>> I thought perhaps there could be an issue since the location-database
>>> git repository stopped getting a daily update after Feb 24 See:
>>> https://git.ipfire.org/?p=location/location-database.git
>>>
>>> -cab
>>>
>>>
>> The lack of updates to the database is coincides with my last update
>> 
>> [root(a)ipfire-dev2 ~]# location version Sat, 25 Feb 2023 05:27:21 GMT
>> 
>> Hopefully someone is looking at reason why the database isn't updating.
>> 
>> The other problem of the high cpu usage also needs to be resolved.
>> 
>> 
>> Rob
>> 
>>

Re: Location Database Update

[Peter Müller]

[-- Attachment #1: Type: text/plain, Size: 1259 bytes --]

Hello Rob,

always. Thanks again for poking. :-)

I'll keep an eye on the situation, but the daily generation of location
databases now seems to work fine.

Thanks, and best regards,
Peter Müller


> On Sat, 11 Mar 2023 13:29:12 +0000, Peter Müller wrote:
> 
>> Hello *,
>>
>> thanks for flagging this.
>>
>> This is not an issue induced by Core Update 173, but on the server side,
>> where the location database is generated. I'm at it and will keep you
>> updated.
>>
>> Thanks, and best regards,
>> Peter Müller
>>
>  
> Thanks Peter looks OK now.
> 
> location version
> Sat, 11 Mar 2023 15:06:35 GMT
> 
> Rob
> 
> 
> 
>>
>>> On Fri, 10 Mar 2023 05:47:49 -0600, Charles Brown wrote:
>>>
>>>> I thought perhaps there could be an issue since the location-database
>>>> git repository stopped getting a daily update after Feb 24 See:
>>>> https://git.ipfire.org/?p=location/location-database.git
>>>>
>>>> -cab
>>>>
>>>>
>>> The lack of updates to the database is coincides with my last update
>>>
>>> [root(a)ipfire-dev2 ~]# location version Sat, 25 Feb 2023 05:27:21 GMT
>>>
>>> Hopefully someone is looking at reason why the database isn't updating.
>>>
>>> The other problem of the high cpu usage also needs to be resolved.
>>>
>>>
>>> Rob
>>>
>>>
> 

Re: Location Database Update

[Rob Brewer]

[-- Attachment #1: Type: text/plain, Size: 1536 bytes --]

Hi Peter

On Sun, 12 Mar 2023 11:43:34 +0000, Peter Müller wrote:

> Hello Rob,
> 
> always. Thanks again for poking. :-)
> 
> I'll keep an eye on the situation, but the daily generation of location
> databases now seems to work fine.
> 
> Thanks, and best regards,
> Peter Müller
> 

Any thoughts on the hourly high CPU usage when the database fails to 
update when the server is down ?

Thanks again

Rob





> 
>> On Sat, 11 Mar 2023 13:29:12 +0000, Peter Müller wrote:
>> 
>>> Hello *,
>>>
>>> thanks for flagging this.
>>>
>>> This is not an issue induced by Core Update 173, but on the server
>>> side,
>>> where the location database is generated. I'm at it and will keep you
>>> updated.
>>>
>>> Thanks, and best regards,
>>> Peter Müller
>>>
>>>
>> Thanks Peter looks OK now.
>> 
>> location version Sat, 11 Mar 2023 15:06:35 GMT
>> 
>> Rob
>> 
>> 
>> 
>> 
>>>> On Fri, 10 Mar 2023 05:47:49 -0600, Charles Brown wrote:
>>>>
>>>>> I thought perhaps there could be an issue since the
>>>>> location-database git repository stopped getting a daily update
>>>>> after Feb 24 See:
>>>>> https://git.ipfire.org/?p=location/location-database.git
>>>>>
>>>>> -cab
>>>>>
>>>>>
>>>> The lack of updates to the database is coincides with my last update
>>>>
>>>> [root(a)ipfire-dev2 ~]# location version Sat, 25 Feb 2023 05:27:21 GMT
>>>>
>>>> Hopefully someone is looking at reason why the database isn't
>>>> updating.
>>>>
>>>> The other problem of the high cpu usage also needs to be resolved.
>>>>
>>>>
>>>> Rob
>>>>
>>>>
>>>>