Changes between Initial Version and Version 1 of drmsHandyChecks

Timestamp:

02/10/14 12:57:09 (10 years ago)

Author:

niles

Comment:

--

drmsHandyChecks

@@ +1 @@
+
+= NetDRMS Useful Debugging Checks =
+
+This is a collection of short checks that can be done on the SUMS or DRMS databases to debug problems. It should be fairly
+clear from the context if the query should be run on the DRMD database or on the SUMS one. If in doubt, try one, and fail
+over to the other.
+
+=== Check sunum_queue size ===
+
+This checks the size of the sunum_queue - the sunums waiting to be processed. This should ideally be 0 unless a lot
+of sunums have come in at once.
+
+{{{
+select count(*) from sunum_queue;
+}}}
+
+=== Check sunum_queue entries older than 1 day ===
+
+This checks the number of entries in sunum_queue that are older than a day. This should be 0.
+
+{{{
+select count(*) from sunum_queue where timestamp < now() - interval '1 days';
+}}}
+
+=== See what partitions SUMS has available ===
+
+This shows what partitions SUMS has available. The last entry in the table - pds_set_num - should be 0. If it
+is not, then perhaps the disk is unmounted, or SUMS sees it as having filled up (note that SUMS sees a disk as full
+slightly before the disk is at 100% use). You will have to work with sum_rm to clear up some space and then set
+pds_set_num to 0 again.
+
+{{{
+select * from sum_partn_avail;
+}}}
+
+
+=== Temporal coverage ===
+
+When data are written to disk, they have an "effective date" - a date after which they can be deleted by sum_rm.
+This returns the latest effective date that is still available.
+
+{{{
+select min(effective_date) from sum_partn_alloc;
+}}}
+
+=== slony updates ===
+
+This shows the time of the last slony update and the time it was last applied. It should be very recent, at least on the current day.
+
+{{{
+select * from _jsoc.sl_archive_tracking;
+}}}
+
+
+=== Show data on disk ===
+
+This shows data that are on disk. Note that you can be subscribed to a dataset and yet not have data for it on disk (no trigger to get the data).
+
+{{{
+select owning_series, sum(bytes), count(*) from sum_main  group by owning_series order by sum(bytes);
+}}}
+