Project

General

Profile

Tests netdrms812 » History » Version 7

Pablo Alingery, 14/03/2017 10:34

1 7 Pablo Alingery
h1. show_info
2 1 Pablo Alingery
3 1 Pablo Alingery
<pre>
4 6 Pablo Alingery
postgres@sdo3:/DATABASES/DUMPS$ psql -p5434 ias_sdo_sums 
5 6 Pablo Alingery
psql (9.4.4)
6 6 Pablo Alingery
Type "help" for help.
7 1 Pablo Alingery
8 6 Pablo Alingery
ias_sdo_sums=# select * from sum_main WHERE ds_index=884413026 ;
9 6 Pablo Alingery
    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
10 6 Pablo Alingery
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 
11 6 Pablo Alingery
-------------------+---------------+----------------+-------------+-----------------+--------------------+---------------+-------------+---------+-----------+--------------+---------------------+--------------
12 6 Pablo Alingery
-------+----------+-----------+---------------+--------------+----------------+----------+--------+-----------+---------------+--------------+----------------
13 6 Pablo Alingery
 /SUM13/D884413026 | Y             | N              | N           |                 | hmi.sharp_720s_nrt |             0 |           0 | 1906167 | 884413026 |    133775491 | 2016-12-21 02:01:24 | 2016-12-21 02
14 6 Pablo Alingery
:01:24 | nouser   |           |               |              |                |          |        |           |               |              | 
15 6 Pablo Alingery
(1 row)
16 5 Pablo Alingery
17 6 Pablo Alingery
ias_sdo_sums=# exit
18 6 Pablo Alingery
ias_sdo_sums-# \q
19 6 Pablo Alingery
postgres@sdo3:/DATABASES/DUMPS$ exit
20 6 Pablo Alingery
déconnexion
21 6 Pablo Alingery
root@sdo3:/home/production# exit
22 6 Pablo Alingery
exit
23 6 Pablo Alingery
production@sdo3:~$ sum
24 6 Pablo Alingery
sum                      sum_arch_recset.pl       sumck_k1M                sumget                   sum_rm_0                 sum_rm_stop.pl           sum_start_k1.MULTI       sum_stop_k1_tape
25 6 Pablo Alingery
sum_adv                  sum_arch_su.pl           sumck_M                  sumlookgroupcron.pl      sum_rm_1                 sumsd.py                 sum_start.NetDRMS        sum_stop.NetDRMS
26 6 Pablo Alingery
sumaintain.pl            sum_chmown               sum_export               sumlookgroupX.pl         sum_rm_2                 sums_procck.py           sum_stop_j1_k1.MULTI     sum_svc
27 6 Pablo Alingery
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
28 6 Pablo Alingery
production@sdo3:~$ sum_start.NetDRMS 
29 6 Pablo Alingery
Number of SUM process sets to spawn = 1
30 6 Pablo Alingery
Max number of SUM process can spawn = 8
31 6 Pablo Alingery
SUMSERVER is sdo3
32 6 Pablo Alingery
SUMS_MANAGER is production
33 6 Pablo Alingery
SUMS db is ias_sdo_sums
34 6 Pablo Alingery
SUMS log dir is /usr/local/netdrms_current/logs/SUM
35 6 Pablo Alingery
sum_start.NetDRMS at 2017.03.14_09:48:38
36 5 Pablo Alingery
37 6 Pablo Alingery
** NOTE: SUMS is already running
38 6 Pablo Alingery
Do you want me to do a sum_stop.NetDRMS followed by a sum_start.NetDRMS (y or n):
39 6 Pablo Alingery
y
40 6 Pablo Alingery
SUMS log dir is /usr/local/netdrms_current/logs/SUM
41 5 Pablo Alingery
42 6 Pablo Alingery
sum_stop.NetDRMS at 2017.03.14_09:48:53
43 5 Pablo Alingery
44 6 Pablo Alingery
NOTE: This will stop sum_svc and related processes. Make sure you want to do this
45 6 Pablo Alingery
Enter reason for stop (terminate with single '.' or ^D):
46 6 Pablo Alingery
>> ljzfelzeb
47 6 Pablo Alingery
>> .
48 6 Pablo Alingery
Please identify yourself:
49 6 Pablo Alingery
>> pab
50 6 Pablo Alingery
Timed-out waiting for sums_procck.py (pid 14861) to exit.
51 6 Pablo Alingery
** Now starting SUMS on ias_sdo_sums
52 6 Pablo Alingery
SUM NetDRMS Start Complete
53 6 Pablo Alingery
production@sdo3:~$ Running on SUMS-server host sdo3.
54 6 Pablo Alingery
Connection to SUMS DB ias_sdo_sums.
55 6 Pablo Alingery
Using SUMS-log file sum_svc_2017.02.01.105605.logR.
56 6 Pablo Alingery
Using SUMS-rm-log file 2017.02.01.105605.log.
57 6 Pablo Alingery
Process sum_svc is not running.
58 6 Pablo Alingery
Starting process sum_svc.
59 5 Pablo Alingery
60 6 Pablo Alingery
Please wait for sum_svc and tape inventory (optional) to initialize...
61 6 Pablo Alingery
Can't open config file /usr/local/netdrms_current/logs/SUM/sum_rm.cfg. Using defaults...
62 6 Pablo Alingery
sum_svc now available
63 5 Pablo Alingery
64 6 Pablo Alingery
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' 
65 6 Pablo Alingery
recnum	sunum	DATE__OBS	SUDIR
66 6 Pablo Alingery
2190405	884413026	2016-12-20T23:10:30.80Z	/SUM13/D884413026/S00000
67 6 Pablo Alingery
2190409	884414163	2016-12-20T23:22:30.80Z	/SUM13/D884414163/S00000
68 6 Pablo Alingery
2190413	884416279	2016-12-20T23:34:30.80Z	/SUM13/D884416279/S00000
69 6 Pablo Alingery
2190417	884417281	2016-12-20T23:46:30.80Z	/SUM13/D884417281/S00000
70 6 Pablo Alingery
2190421	884419003	2016-12-20T23:58:30.80Z	/SUM13/D884419003/S00000
71 6 Pablo Alingery
2190425	884421131	2016-12-21T00:10:30.90Z	/SUM13/D884421131/S00000
72 6 Pablo Alingery
2190429	884422598	2016-12-21T00:22:30.90Z	/SUM13/D884422598/S00000
73 6 Pablo Alingery
2190433	884424336	2016-12-21T00:34:30.90Z	/SUM13/D884424336/S00000
74 6 Pablo Alingery
2190437	884425290	2016-12-21T00:46:30.90Z	/SUM13/D884425290/S00000
75 6 Pablo Alingery
2190441	884427329	2016-12-21T00:58:30.90Z	/SUM13/D884427329/S00000
76 6 Pablo Alingery
production@sdo3:~$ show_series
77 6 Pablo Alingery
  aia.lev1
78 6 Pablo Alingery
  drms.sites
79 6 Pablo Alingery
  hmi.bharp_720s
80 6 Pablo Alingery
  hmi.bharp_720s_nrt
81 6 Pablo Alingery
  hmi.ic_720s
82 6 Pablo Alingery
  hmi.ic_nolimbdark_720s_nrt
83 6 Pablo Alingery
  hmi.m_720s
84 6 Pablo Alingery
  hmi.m_720s_nrt
85 6 Pablo Alingery
  hmi.mharp_720s
86 6 Pablo Alingery
  hmi.mharp_720s_nrt
87 6 Pablo Alingery
  hmi.sharp_720s
88 6 Pablo Alingery
  hmi.sharp_720s_nrt
89 6 Pablo Alingery
  hmi.sharp_cea_720s_nrt
90 1 Pablo Alingery
91 7 Pablo Alingery
</pre>
92 7 Pablo Alingery
93 7 Pablo Alingery
94 7 Pablo Alingery
h1. Test subscription
95 7 Pablo Alingery
96 7 Pablo Alingery
<pre>
97 7 Pablo Alingery
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
98 7 Pablo Alingery
Checking for existing request at server.
99 7 Pablo Alingery
Series hmi.sharp_cea_720s is not published and not available for subscription.
100 5 Pablo Alingery
</pre>