Skip to Content.
Sympa Menu

perfsonar-user - Re: [perfsonar-user] Update to 3.4 interrupted during DB migration

Subject: perfSONAR User Q&A and Other Discussion

List archive

Re: [perfsonar-user] Update to 3.4 interrupted during DB migration


Chronological Thread 
  • From: Aaron Brown <>
  • To: Lixin Liu <>
  • Cc: "" <>
  • Subject: Re: [perfsonar-user] Update to 3.4 interrupted during DB migration
  • Date: Wed, 17 Dec 2014 14:43:32 +0000
  • Accept-language: en-US
  • Authentication-results: sfu.ca; dkim=none (message not signed) header.d=none;

Hey Lixin,

Could you edit /opt/perfsonar_ps/toolkit/scripts/psb_to_esmond.pl, and try
commenting out the lines like:

die "Error posting …”

And then re-run the tool. I don’t think the migration tool wasn’t made to be
restarted.

Cheers,
Aaron

> On Dec 16, 2014, at 10:40 AM, Lixin Liu
> <>
> wrote:
>
> Hi Aaron,
>
> Yes, the OWAMP migration stopped and the script started processing
> traceroute
> records and stopped again with the same error.
>
> Thanks,
>
> Lixin.
>
> On 2014-12-16, 7:06 AM, "Aaron Brown"
> <>
> wrote:
>
>> Hi Lixin,
>>
>> The Oconflict¹ error should just mean that it¹s attempting to re-insert
>> the data. Is that causing the process to stop or ?
>>
>> Cheers,
>> Aaron
>>
>>> On Dec 16, 2014, at 12:01 AM, Lixin Liu
>>> <>
>>> wrote:
>>>
>>> Hi Jason,
>>>
>>> Rerunning psb_to_esmond script again, it went a bit further, but failed
>>> again:
>>>
>>> 2014/12/15 20:46:09 (14952) INFO> psb_to_esmond.pl:286
>>> main::convert_owamp
>>> - Sending metadata....[START]
>>> 2014/12/15 20:46:09 (14952) INFO> psb_to_esmond.pl:345
>>> main::convert_owamp
>>> - Sending metadata....[END]
>>> 2014/12/15 20:46:16 (14952) INFO> psb_to_esmond.pl:272
>>> main::convert_owamp
>>> - Sending delay data for 1080253740.1241952063.1686456867....[START]
>>> 2014/12/15 20:48:48 (14952) ERROR> psb_to_esmond.pl:185 main:: - Error
>>> posting 1080253740.1241952063.1686456867409 CONFLICT
>>>
>>> Any idea?
>>>
>>> Thanks,
>>>
>>> Lixin.
>>>
>>>
>>> On 2014-12-15, 1:28 PM, "Jason Zurawski"
>>> <>
>>> wrote:
>>>
>>>> Hey Lixin;
>>>>
>>>> Our usual esmond expert is away for the holidays. I don?t think there
>>>> is
>>>> any harm in re-running the script, but do note we haven?t tried this
>>>> failure scenario ourselves.
>>>>
>>>> Sorry to not be very helpful;
>>>>
>>>> -jason
>>>>
>>>> On Dec 15, 2014, at 4:12 PM, Lixin Liu
>>>> <>
>>>> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> For some unknown reason, the migration to new DB was interrupted
>>>>> after a few hours. The log in /var/log/perfsonar/psb_to_esmond.log
>>>>> shows:
>>>>>
>>>>> 2014/12/14 03:29:29 (8021) INFO> psb_to_esmond.pl:286
>>>>> main::convert_owamp -
>>>>> Sending metadata....[START]
>>>>> 2014/12/14 03:29:29 (8021) INFO> psb_to_esmond.pl:345
>>>>> main::convert_owamp -
>>>>> Sending metadata....[END]
>>>>> 2014/12/14 03:30:01 (8021) INFO> psb_to_esmond.pl:272
>>>>> main::convert_owamp -
>>>>> Sending delay data for 1405144515.1241952063.1686456867....[START]
>>>>> 2014/12/14 03:39:31 (8021) ERROR> psb_to_esmond.pl:185 main:: - Error
>>>>> posting 1405144515.1241952063.1686456867500 Server closed connection
>>>>> without
>>>>> sending any data back
>>>>>
>>>>> 2014/12/14 03:39:31 (8021) INFO> psb_to_esmond.pl:565
>>>>> main::convert_traceroute - Adding data from 2014-11-14
>>>>> 2014/12/14 03:39:31 (8021) INFO> psb_to_esmond.pl:569
>>>>> main::convert_traceroute - Finding test specs....[START]
>>>>> 2014/12/14 03:39:31 (8021) INFO> psb_to_esmond.pl:583
>>>>> main::convert_traceroute - Finding test specs....[END]
>>>>> ...........
>>>>>
>>>>> 2014/12/14 03:41:35 (8021) INFO> psb_to_esmond.pl:608
>>>>> main::convert_traceroute - Sending traceroute data for
>>>>> 3a00d5fea634d01080838bd3a7b148ff....[START]
>>>>> 2014/12/14 03:41:36 (8021) ERROR> psb_to_esmond.pl:185 main:: - Error
>>>>> posting 3a00d5fea634d01080838bd3a7b148ff409 CONFLICT
>>>>> 2014/12/14 03:41:36 (8021) INFO> psb_to_esmond.pl:742
>>>>> main::save_state_file - Saving state file....[START]
>>>>> 2014/12/14 03:41:36 (8021) INFO> psb_to_esmond.pl:750
>>>>> main::save_state_file - Saving state file....[END]
>>>>>
>>>>>
>>>>> Should I just rerun psb_to_esmond.pl script?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Lixin
>>>
>>>
>>
>
>




Archive powered by MHonArc 2.6.16.

Top of Page