DOWNTIME ANNOUNCEMENTSun 17 Mar 2024, between 4am to 8pm EDT, intermittent network outages due to disaster recovery testing.
|
Instructions (not for the faint of heart) for replicating the database are on the SBN Wiki. Questions/issues related to replication should be directed to Andrei Mamoutkine.
2024-03-19 00:30:02 (GMT)
Status of all major tables from MariaDB (mpc_development) and Postgres database (mpc_sbn). It includes list of all major tables, number of records in each tables, the latest updated record in each table. A color code corresponds to records updated less than 1 day, from 1 to 3 days and older than 3 days. Updated every 5 min. GMT timestamp of update is at the top left of the page.
Source file of data: statusDB.csv
Table | Count | Created_at | Updated_at |
close_approaches | 223366 | 2019-05-23 19:22:13 | 2019-05-23 19:22:13 |
comet_names | 4586 | 2017-03-15 16:46:33 | 2017-03-15 16:46:33 |
comet_orbit_uncertainties | 1015 | 2019-06-04 12:15:27 | 2019-06-04 12:15:27 |
comet_orbits | 9305 | 2024-03-13 02:51:14 | 2024-03-13 03:31:04 |
identifications | 192502 | 2024-03-18 12:11:54 | 2024-03-18 12:11:54 |
isolated_tracklets | 45242006 | 2024-03-19 00:08:17 | 2024-03-19 00:08:17 |
mpc_indices | 396 | 2024-02-28 22:30:01 | 2024-02-28 22:30:01 |
numbered_identifications | 1048827 | 2024-03-01 22:43:55 | 2024-03-01 22:43:55 |
numbered_mps | 660000 | 2013-03-28 19:38:33 | 2024-02-27 20:36:42 |
obs_request_observers | 52 | 2019-07-24 16:57:48 | 2019-07-24 16:57:48 |
obs_request_users | 7 | 2015-12-04 00:25:22 | 2015-12-04 00:25:22 |
observations | 422353284 | 2024-03-19 00:30:12 | 2024-03-19 00:30:12 |
orbit_uncertainties | 785684 | 2019-06-05 12:14:34 | 2023-12-03 00:49:38 |
orbits | 1368033 | 2024-03-18 20:57:18 | 2024-03-18 21:31:04 |
perturbed_orbits | 175724170 | 2018-09-27 17:20:33 | 2018-09-27 17:20:33 |
radar_observations | 1507 | 2023-06-23 18:31:24 | 2023-06-23 18:31:24 |
Table | Count | Created_at | Updated_at |
neocp_els | 76 | 2024-03-17 13:55:54.9742 | 2024-03-19 00:23:56.041419 |
neocp_events | 220108 | 2024-03-19 00:23:58.251145 | 2024-03-19 00:23:58.251145 |
neocp_obs_archive | 562727 | 2024-03-19 00:23:56.040005 | 2024-03-19 00:23:56.040005 |
neocp_obs | 586 | 2024-03-19 00:23:56.036774 | 2024-03-19 00:23:56.036774 |
neocp_prev_des | 58994 | 2024-03-18 23:55:51.876453 | 2024-03-18 23:55:51.876453 |
neocp_var | 145911 | 2024-03-19 00:23:58.233538 | 2024-03-19 00:23:58.233538 |
current_identifications | 1878823 | 2024-03-19 00:36:12.724177 | 2024-03-19 00:36:12.724177 |
numbered_identifications | 660777 | 2024-02-14 01:45:23.700187 | 2024-02-14 01:45:23.700187 |
primary_objects | 1404613 | 2024-03-19 00:36:12.706531 | 2024-03-19 00:36:12.706531 |
obs_sbn | 440118547 | 2023-10-16 04:23:10.166151-04 | 2024-03-18 20:36:13.7552-04 |
obs_alterations_deletions | 1271100 | 2024-03-18 21:29:57.222993 | 2024-03-18 21:29:57.222993 |
obs_alterations_redesignations | 3678 | 2024-03-11 12:56:56.364669 | 2024-03-11 12:56:56.364669 |
obs_alterations_unassociations | 127897 | 2024-03-19 00:12:57.823306 | 2024-03-19 00:12:57.823306 |
mpc_orbits | 1347607 | 2021-02-04 00:45:35.252068 | 2024-03-19 00:44:39.044533 |
YYYY-MM-DD - latest record is older than 3 days
YYYY-MM-DD - latest record is older than 1 day
YYYY-MM-DD - latest record is less than 1 day old
Server | Table | Count | Updated_at | Queried_at |
MPC_marsden | obs_sbn | 440118414 | 2024-03-18 23:58:10.353379 | 2024-03-19 00:00:02.541242 |
MPC_mpcweb5 | obs_sbn | 440118547 | 2024-03-19 00:12:50.917813 | 2024-03-19 00:12:56.91993 |
SBN_to_AWS | obs_sbn | 440118547 | 2024-03-19 00:18:18.44268 | 2024-03-19 00:21:01.386265 |
MPC_marsden | current_identifications | 1878821 | 2024-03-19 00:23:07.27454 | 2024-03-19 00:34:19.87922 |
MPC_mpcweb5 | current_identifications | 1878821 | 2024-03-19 00:23:07.27454 | 2024-03-19 00:34:20.91735 |
SBN_to_AWS | current_identifications | 1878821 | 2024-03-19 00:23:07.27454 | 2024-03-19 00:34:22.092587 |
MPC_marsden | mpc_orbits | 1347599 | 2024-03-19 00:34:22.412386 | 2024-03-19 00:34:22.478071 |
MPC_mpcweb5 | mpc_orbits | 1347599 | 2024-03-19 00:34:24.48007 | 2024-03-19 00:34:24.79334 |
SBN_to_AWS | mpc_orbits | 1347599 | 2024-03-19 00:34:24.573102 | 2024-03-19 00:34:26.01646 |
MPC_marsden | numbered_identifications | 660777 | 2024-02-14 01:45:23.700187 | 2024-03-19 00:34:26.639793 |
MPC_mpcweb5 | numbered_identifications | 660777 | 2024-02-14 01:45:23.700187 | 2024-03-19 00:34:26.900742 |
SBN_to_AWS | numbered_identifications | 660777 | 2024-02-14 01:45:23.700187 | 2024-03-19 00:34:27.162929 |
MPC_marsden | neocp_els | 76 | 2024-03-19 00:23:56.041419 | 2024-03-19 00:34:27.333656 |
MPC_mpcweb5 | neocp_els | 76 | 2024-03-19 00:23:56.041419 | 2024-03-19 00:34:27.412365 |
SBN_to_AWS | neocp_els | 76 | 2024-03-19 00:23:56.041419 | 2024-03-19 00:34:27.49467 |
MPC_marsden | neocp_events | 220108 | 2024-03-19 00:23:58.251145 | 2024-03-19 00:34:27.579606 |
MPC_mpcweb5 | neocp_events | 220108 | 2024-03-19 00:23:58.251145 | 2024-03-19 00:34:27.721095 |
SBN_to_AWS | neocp_events | 220108 | 2024-03-19 00:23:58.251145 | 2024-03-19 00:34:27.87782 |
MPC_marsden | neocp_obs | 586 | 2024-03-19 00:23:56.036774 | 2024-03-19 00:34:27.997136 |
MPC_mpcweb5 | neocp_obs | 586 | 2024-03-19 00:23:56.036774 | 2024-03-19 00:34:28.076347 |
SBN_to_AWS | neocp_obs | 586 | 2024-03-19 00:23:56.036774 | 2024-03-19 00:34:28.157643 |
MPC_marsden | neocp_obs_archive | 562727 | 2024-03-19 00:23:56.040005 | 2024-03-19 00:34:28.243984 |
MPC_mpcweb5 | neocp_obs_archive | 562727 | 2024-03-19 00:23:56.040005 | 2024-03-19 00:34:28.398597 |
SBN_to_AWS | neocp_obs_archive | 562727 | 2024-03-19 00:23:56.040005 | 2024-03-19 00:34:28.582056 |
MPC_marsden | neocp_prev_des | 58994 | 2024-03-18 23:55:51.876453 | 2024-03-19 00:34:28.730946 |
MPC_mpcweb5 | neocp_prev_des | 58994 | 2024-03-18 23:55:51.876453 | 2024-03-19 00:34:28.835063 |
SBN_to_AWS | neocp_prev_des | 58994 | 2024-03-18 23:55:51.876453 | 2024-03-19 00:34:28.96446 |
MPC_marsden | neocp_var | 145911 | 2024-03-19 00:23:58.233538 | 2024-03-19 00:34:29.069739 |
MPC_mpcweb5 | neocp_var | 145911 | 2024-03-19 00:23:58.233538 | 2024-03-19 00:34:29.191929 |
SBN_to_AWS | neocp_var | 147911 | 2024-03-19 00:23:58.233538 | 2024-03-19 00:34:29.298515 |
MPC_marsden | primary_objects | 1404611 | 2024-03-19 00:22:24.851642 | 2024-03-19 00:34:29.410158 |
MPC_mpcweb5 | primary_objects | 1404611 | 2024-03-19 00:22:24.851642 | 2024-03-19 00:34:30.040866 |
SBN_to_AWS | primary_objects | 1404611 | 2024-03-19 00:22:24.851642 | 2024-03-19 00:34:30.907664 |
MPC_marsden | obs_alterations_corrections | 2024-03-19 00:34:31.221488 | ||
MPC_mpcweb5 | obs_alterations_corrections | 2024-03-19 00:34:31.300612 | ||
SBN_to_AWS | obs_alterations_corrections | 2024-03-19 00:34:31.381491 | ||
MPC_marsden | obs_alterations_deletions | 1271100 | 2024-03-18 21:29:57.222993 | 2024-03-19 00:34:31.464456 |
MPC_mpcweb5 | obs_alterations_deletions | 1271100 | 2024-03-18 21:29:57.222993 | 2024-03-19 00:34:31.983765 |
SBN_to_AWS | obs_alterations_deletions | 1271100 | 2024-03-18 21:29:57.222993 | 2024-03-19 00:34:32.672701 |
MPC_marsden | obs_alterations_redesignations | 3678 | 2024-03-11 12:56:56.364669 | 2024-03-19 00:34:32.914835 |
MPC_mpcweb5 | obs_alterations_redesignations | 3678 | 2024-03-11 12:56:56.364669 | 2024-03-19 00:34:32.996153 |
SBN_to_AWS | obs_alterations_redesignations | 3678 | 2024-03-11 12:56:56.364669 | 2024-03-19 00:34:33.0804 |