Project

General

Profile

show_info

postgres@sdo3:/DATABASES/DUMPS$ psql -p5434 ias_sdo_sums 
psql (9.4.4)
Type "help" for help.

ias_sdo_sums=# select * from sum_main WHERE ds_index=884413026 ;
    online_loc     | online_status | archive_status | offsite_ack | history_comment |   owning_series    | storage_group | storage_set |  bytes  | ds_index  | create_sumid |     creat_date      |     access_da
te     | username | arch_tape | arch_tape_pos | arch_tape_fn | arch_tape_date | warnings | status | safe_tape | safe_tape_pos | safe_tape_fn | safe_tape_date 
-------------------+---------------+----------------+-------------+-----------------+--------------------+---------------+-------------+---------+-----------+--------------+---------------------+--------------
-------+----------+-----------+---------------+--------------+----------------+----------+--------+-----------+---------------+--------------+----------------
 /SUM13/D884413026 | Y             | N              | N           |                 | hmi.sharp_720s_nrt |             0 |           0 | 1906167 | 884413026 |    133775491 | 2016-12-21 02:01:24 | 2016-12-21 02
:01:24 | nouser   |           |               |              |                |          |        |           |               |              | 
(1 row)

ias_sdo_sums=# exit
ias_sdo_sums-# \q
postgres@sdo3:/DATABASES/DUMPS$ exit
déconnexion
root@sdo3:/home/production# exit
exit
production@sdo3:~$ sum
sum                      sum_arch_recset.pl       sumck_k1M                sumget                   sum_rm_0                 sum_rm_stop.pl           sum_start_k1.MULTI       sum_stop_k1_tape
sum_adv                  sum_arch_su.pl           sumck_M                  sumlookgroupcron.pl      sum_rm_1                 sumsd.py                 sum_start.NetDRMS        sum_stop.NetDRMS
sumaintain.pl            sum_chmown               sum_export               sumlookgroupX.pl         sum_rm_2                 sums_procck.py           sum_stop_j1_k1.MULTI     sum_svc
sum_alrm1                sum_ck                   sum_export_svc           sum_rm                   sum_rm_start.pl          sum_start_j1_k1.MULTI    sum_stop_k1.MULTI        sum_time_server_scan.pl
production@sdo3:~$ sum_start.NetDRMS 
Number of SUM process sets to spawn = 1
Max number of SUM process can spawn = 8
SUMSERVER is sdo3
SUMS_MANAGER is production
SUMS db is ias_sdo_sums
SUMS log dir is /usr/local/netdrms_current/logs/SUM
sum_start.NetDRMS at 2017.03.14_09:48:38

** NOTE: SUMS is already running
Do you want me to do a sum_stop.NetDRMS followed by a sum_start.NetDRMS (y or n):
y
SUMS log dir is /usr/local/netdrms_current/logs/SUM

sum_stop.NetDRMS at 2017.03.14_09:48:53

NOTE: This will stop sum_svc and related processes. Make sure you want to do this
Enter reason for stop (terminate with single '.' or ^D):
>> ljzfelzeb
>> .
Please identify yourself:
>> pab
Timed-out waiting for sums_procck.py (pid 14861) to exit.
** Now starting SUMS on ias_sdo_sums
SUM NetDRMS Start Complete
production@sdo3:~$ Running on SUMS-server host sdo3.
Connection to SUMS DB ias_sdo_sums.
Using SUMS-log file sum_svc_2017.02.01.105605.logR.
Using SUMS-rm-log file 2017.02.01.105605.log.
Process sum_svc is not running.
Starting process sum_svc.

Please wait for sum_svc and tape inventory (optional) to initialize...
Can't open config file /usr/local/netdrms_current/logs/SUM/sum_rm.cfg. Using defaults...
sum_svc now available

production@sdo3:~$ show_info -r -S -P 'hmi.sharp_720s_nrt[5398][! DATE__OBS>$(2016-12-20T23:00:00Z) AND DATE__OBS<$(2016-12-21T01:00:00Z) !]' key='DATE__OBS' 
recnum    sunum    DATE__OBS    SUDIR
2190405    884413026    2016-12-20T23:10:30.80Z    /SUM13/D884413026/S00000
2190409    884414163    2016-12-20T23:22:30.80Z    /SUM13/D884414163/S00000
2190413    884416279    2016-12-20T23:34:30.80Z    /SUM13/D884416279/S00000
2190417    884417281    2016-12-20T23:46:30.80Z    /SUM13/D884417281/S00000
2190421    884419003    2016-12-20T23:58:30.80Z    /SUM13/D884419003/S00000
2190425    884421131    2016-12-21T00:10:30.90Z    /SUM13/D884421131/S00000
2190429    884422598    2016-12-21T00:22:30.90Z    /SUM13/D884422598/S00000
2190433    884424336    2016-12-21T00:34:30.90Z    /SUM13/D884424336/S00000
2190437    884425290    2016-12-21T00:46:30.90Z    /SUM13/D884425290/S00000
2190441    884427329    2016-12-21T00:58:30.90Z    /SUM13/D884427329/S00000
production@sdo3:~$ show_series
  aia.lev1
  drms.sites
  hmi.bharp_720s
  hmi.bharp_720s_nrt
  hmi.ic_720s
  hmi.ic_nolimbdark_720s_nrt
  hmi.m_720s
  hmi.m_720s_nrt
  hmi.mharp_720s
  hmi.mharp_720s_nrt
  hmi.sharp_720s
  hmi.sharp_720s_nrt
  hmi.sharp_cea_720s_nrt

Test subscription

root@sdo3:/usr/local/netdrms_8.12# python3 base/drms/replication/subscribe_series/subscribe.py cfg=base/drms/replication/etc/ias.repclient.cfg reqtype=subscribe series=hmi.sharp_cea_720s --loglevel=debug
Checking for existing request at server.
Series hmi.sharp_cea_720s is not published and not available for subscription.