[Issues] GASTROM: ORA-28576: lost RPC connection to external procedure agent, ORA-02393: exceeded call limit on CPU usage

John P. McFarland mcfarland at astro.rug.nl
Thu Sep 27 14:16:54 CEST 2007 

Hi Philippe,

After consultation with our DB experts, it appears that the RPC connection 
was to the HTM library indicating that there was something unusual with the 
astrometry of your data.  This error likely caused the pickling error later 
on.  Please check that your astrometry is reasonable and that your 
grid_targets are consistent and try again.

Cheers,


-=John


On Mon, 24 Sep 2007, John P. McFarland wrote:

> Hi Philippe,
>
> I think the error messages are somewhat terse, but nonetheless say exactly
> what happened: a network error and an exceeded resource limit.  What exactly
> caused them and how to fix it, I can't be sure, but we will look into it get
> back to you as soon as possible.
>
> Cheers,
>
>
> -=John
>
>
> On Fri, 21 Sep 2007, Philippe Heraudeau wrote:
>
>> Hi ,
>>
>> I don't know what are these error messages. Could you please help?
>> Cheers,
>> Philippe
>>
>> This worked:
>> dpu.run('GAstrom',object='DEEP3a*',instrument='WFI',filter='#844',C=1,chip='ccd50')
>> # 32 chips
>>
>> This fails:
>> dpu.run('GAstrom',object='DEEP3a*',instrument='WFI',filter='#844',C=1)
>> # 32 * 8 chips
>> .....
>> [foucault] 14:15:17 - [node199] 13:48:48 - Using SourceList
>> GAS-Sci-PHERAUDEAU-WFI-------#844-ccd57-Red---Sci-54360.6615498-16e57bd5703860af7f4cb7e5285f069f9568e633.fits.slist,
>> SLID = 193791, number of sources =   313
>> [foucault] 14:15:17 - [node199] 13:48:48 - Using SourceList
>> GAS-Sci-PHERAUDEAU-WFI-------#844-ccd50-Red---Sci-54360.6639484-e47cf7e2ee094d029b0eef34268c3f6cbcb804a0.fits.slist,
>> SLID = 192251, number of sources =   313
>> [foucault] 14:15:17 - [node199] 13:48:48 - Using SourceList
>> GAS-Sci-PHERAUDEAU-WFI-------#844-ccd55-Red---Sci-54360.6707366-78399516189335c491317ba037e58e500dca5055.fits.slist,
>> SLID = 193341, number of sources =   166
>> [foucault] 14:15:17 - [node199] 13:48:48 - Using SourceList
>> GAS-Sci-PHERAUDEAU-WFI-------#844-ccd53-Red---Sci-54360.6638464-f9ac838d2ace470ba8637f42326b0001746d8c9b.fits.slist,
>> SLID = 192351, number of sources =   247
>> [foucault] 14:15:17 - [node199] 13:48:59 - Outer bounding box:
>> (171.54369,-21.98915,170.83598,-21.98923,170.83631,-21.39761,171.54347,-21.39781
>> )
>> [foucault] 14:15:17 - [node199] 13:49:26 - Copied 78254 sources to
>> scratch table
>> [foucault] 14:15:17 - Error executing 'execute'
>> [foucault] 14:15:17 - Exception:  ORA-28576: lost RPC connection to
>> external procedure agent
>> [foucault] 14:15:17 -
>> [foucault] 14:15:17 -   File
>> "/home/rugwn201/omegacen/awehome/opipe/current/astro/net/dpu_runner.py",
>> line 174, in main
>> [foucault] 14:15:17 -     job.execute()
>> [foucault] 14:15:17 -   File
>> "/net/hercules01/data/users/heraud/ASTROWISE/opipe/DBRecipes/GAstrom.py",
>> line 138, in execute
>> [foucault] 14:15:17 -   File
>> "/net/hercules01/data/users/heraud/ASTROWISE/opipe/DBRecipes/GAstrom.py",
>> line 177, in make_global_astrometric_solution
>> [foucault] 14:15:17 -   File
>> "/net/hercules01/data/users/heraud/ASTROWISE/opipe/astro/main/GAstrometric.py",
>> line 80, in make
>> [foucault] 14:15:17 -   File
>> "/net/hercules01/data/users/heraud/ASTROWISE/opipe/astro/main/GAstrometric.py",
>> line 179, in make_associate
>> [foucault] 14:15:17 -   File
>> "/net/hercules01/data/users/heraud/ASTROWISE/opipe/astro/main/AssociateList.py",
>> line 145, in make
>> [foucault] 14:15:17 -   File
>> "/net/hercules01/data/users/heraud/ASTROWISE/opipe/astro/main/AssociateList.py",
>> line 200, in associate_sourcelists
>> [foucault] 14:15:17 -   File
>> "/net/hercules01/data/users/heraud/ASTROWISE/opipe/astro/main/AssociateList.py",
>> line 1617, in make_matched_associatelist
>> [foucault] 14:15:17 - Error pickling job
>> [foucault] 14:15:17 - Exception:  can't pickle function objects
>> [foucault] 14:15:17 -   File
>> "/home/rugwn201/omegacen/awehome/opipe/current/astro/net/dpu_runner.py",
>> line 191, in main
>> [foucault] 14:15:17 -     pjob = pickle.dumps(job)
>> [foucault] 14:15:17 -   File
>> "/home/rugwn201/omegacen/local/x86_64/lib/python2.3/copy_reg.py", line
>> 69, in _reduce_ex
>> [foucault] 14:15:17 -     raise TypeError, "can't pickle %s objects" %
>> base.__name__
>>
>>
>> And with the same command I aslo got another error message:
>> [foucault] 16:23:20 - [node199] 16:09:48 - Using SourceList
>> GAS-Sci-PHERAUDEAU-WFI-------#844-ccd57-Red---Sci-54360.6608829-d98bcf15ac57f72b5ed27d823843a897b6e38c20.fits.slist,
>> SLID = 193271, number of sources =   381
>> [foucault] 16:23:20 - [node199] 16:09:58 - Outer bounding box:
>> (171.54369,-21.98915,170.83598,-21.98923,170.83631,-21.39761,171.54347,-21.39781
>> )
>> [foucault] 16:23:20 - [node199] 16:10:17 - Copied 78254 sources to
>> scratch table
>> [foucault] 16:23:20 - Error executing 'execute'
>> [foucault] 16:23:20 - Exception:  ORA-02393: exceeded call limit on CPU
>> usage
>> [foucault] 16:23:20 -
>> [foucault] 16:23:20 -   File
>> "/home/rugwn201/omegacen/awehome/opipe/current/astro/net/dpu_runner.py",
>> line 174, in main
>> [foucault] 16:23:20 -     job.execute()
>> [foucault] 16:23:20 -   File
>> "/net/hercules01/data/users/heraud/ASTROWISE/opipe/DBRecipes/GAstrom.py",
>> line 138, in execute
>> [foucault] 16:23:20 -   File
>> "/net/hercules01/data/users/heraud/ASTROWISE/opipe/DBRecipes/GAstrom.py",
>> line 177, in make_global_astrometric_solution
>> [foucault] 16:23:20 -   File
>> "/net/hercules01/data/users/heraud/ASTROWISE/opipe/astro/main/GAstrometric.py",
>> line 80, in make
>> [foucault] 16:23:20 -   File
>> "/net/hercules01/data/users/heraud/ASTROWISE/opipe/astro/main/GAstrometric.py",
>> line 179, in make_associate
>> [foucault] 16:23:20 -   File
>> "/net/hercules01/data/users/heraud/ASTROWISE/opipe/astro/main/AssociateList.py",
>> line 145, in make
>> [foucault] 16:23:20 -   File
>> "/net/hercules01/data/users/heraud/ASTROWISE/opipe/astro/main/AssociateList.py",
>> line 200, in associate_sourcelists
>> [foucault] 16:23:20 -   File
>> "/net/hercules01/data/users/heraud/ASTROWISE/opipe/astro/main/AssociateList.py",
>> line 1617, in make_matched_associatelist
>> [foucault] 16:23:20 - Error pickling job
>> [foucault] 16:23:20 - Exception:  can't pickle function objects
>> [foucault] 16:23:20 -   File
>> "/home/rugwn201/omegacen/awehome/opipe/current/astro/net/dpu_runner.py",
>> line 191, in main
>> [foucault] 16:23:20 -     pjob = pickle.dumps(job)
>> [foucault] 16:23:20 -   File
>> "/home/rugwn201/omegacen/local/x86_64/lib/python2.3/copy_reg.py", line
>> 69, in _reduce_ex
>> [foucault] 16:23:20 -     raise TypeError, "can't pickle %s objects" %
>> base.__name__
>> [foucault] 16:23:20 -
>>
>>
>>
> _______________________________________________
> Issues mailing list
> Issues at astro-wise.org
> http://listman.astro-wise.org/mailman/listinfo/issues
>
>
>
> ** CRM114 Whitelisted by: From: "John P. McFarland" <mcfarland at astro.rug.nl **
>
> ** ACCEPT: CRM114 Whitelisted by: From: "John P. McFarland" <mcfarland at astro.rug.nl **
>
>

More information about the Issues mailing list