Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

26 Feb 2024

  1. Nominal.

Please report concerns!

KEY

Database Replication

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.

Latest update of every table in MPC MariaDB and Postgres

2024-03-04 08:40: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.

MariaDB mpc_development:

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 9284 2024-03-02 04:42:21 2024-03-02 05:31:03
identifications 192032 2024-03-03 12:08:50 2024-03-03 12:08:50
isolated_tracklets 44937494 2024-03-04 08:38:46 2024-03-04 08:38:46
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 421660537 2024-03-04 04:01:33 2024-03-04 07:54:48
orbit_uncertainties 785684 2019-06-05 12:14:34 2023-12-03 00:49:38
orbits 1366397 2018-04-17 13:29:58 2024-03-04 04:31:03
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
No change in Maria mpc_development database structure.

Postgres mpc_sbn:

Table Count Created_at Updated_at
neocp_els 44 2024-03-03 09:28:55.696664 2024-03-04 08:38:25.190251
neocp_events 218784 2024-03-04 08:38:25.7031 2024-03-04 08:38:25.7031
neocp_obs_archive 559067 2024-03-04 08:38:25.188632 2024-03-04 08:38:25.188632
neocp_obs 600 2024-03-04 08:38:25.184836 2024-03-04 08:38:25.184836
neocp_prev_des 58817 2024-03-04 04:02:15.251912 2024-03-04 04:02:15.251912
neocp_var 84337 2024-03-04 08:38:25.675856 2024-03-04 08:38:25.675856
current_identifications 1877325 2020-07-30 16:14:52.891925 2024-03-03 20:26:01.481894
numbered_identifications 660777 2024-02-14 01:45:23.700187 2024-02-14 01:45:23.700187
primary_objects 1403345 2024-03-03 20:08:59.356938 2024-03-03 20:08:59.356938
obs_sbn 438600496 2024-03-04 03:36:05.118404-05 2024-03-04 03:39:48.241863-05
obs_alterations_deletions 1270421 2024-03-02 15:40:16.499608 2024-03-02 15:40:16.499608
obs_alterations_redesignations 3004 2024-03-01 16:21:51.971048 2024-03-01 16:21:51.971048
obs_alterations_unassociations 123638 2024-03-04 00:10:10.681923 2024-03-04 00:10:10.681923
mpc_orbits 1345849 2021-02-04 03:18:24.032589 2024-03-04 08:39:47.770005
No change to Postgres mpc_sbn database structure

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

Replication status view MPC-master → [SBN] → MPC-replica:

Server Table Count Updated_at Queried_at
MPC_marsden obs_sbn 438600262 2024-03-04 07:58:09.176691 2024-03-04 08:00:02.219751
MPC_mpcweb5 obs_sbn 438600290 2024-03-04 08:09:12.365183 2024-03-04 08:12:42.290838
SBN_to_AWS obs_sbn 438600377 2024-03-04 08:18:18.883535 2024-03-04 08:19:56.52366
MPC_marsden current_identifications 1877325 2024-03-03 20:26:01.481894 2024-03-04 08:32:11.004468
MPC_mpcweb5 current_identifications 1877325 2024-03-03 20:26:01.481894 2024-03-04 08:32:11.48066
SBN_to_AWS current_identifications 1877325 2024-03-03 20:26:01.481894 2024-03-04 08:32:11.616478
MPC_marsden mpc_orbits 1345849 2024-03-04 08:25:21.261989 2024-03-04 08:32:11.880389
MPC_mpcweb5 mpc_orbits 1345849 2024-03-04 08:25:21.261989 2024-03-04 08:32:12.755728
SBN_to_AWS mpc_orbits 1345849 2024-03-04 08:25:21.261989 2024-03-04 08:32:12.893675
MPC_marsden numbered_identifications 660777 2024-02-14 01:45:23.700187 2024-03-04 08:32:13.123389
MPC_mpcweb5 numbered_identifications 660777 2024-02-14 01:45:23.700187 2024-03-04 08:32:13.319386
SBN_to_AWS numbered_identifications 660777 2024-02-14 01:45:23.700187 2024-03-04 08:32:13.413128
MPC_marsden neocp_els 44 2024-03-04 08:16:15.299382 2024-03-04 08:32:13.533971
MPC_mpcweb5 neocp_els 44 2024-03-04 08:16:15.299382 2024-03-04 08:32:13.598284
SBN_to_AWS neocp_els 44 2024-03-04 08:16:15.299382 2024-03-04 08:32:13.659192
MPC_marsden neocp_events 218783 2024-03-04 08:16:17.882716 2024-03-04 08:32:13.721666
MPC_mpcweb5 neocp_events 218783 2024-03-04 08:16:17.882716 2024-03-04 08:32:13.851733
SBN_to_AWS neocp_events 218783 2024-03-04 08:16:17.882716 2024-03-04 08:32:13.931311
MPC_marsden neocp_obs 598 2024-03-04 08:16:15.288986 2024-03-04 08:32:14.017689
MPC_mpcweb5 neocp_obs 598 2024-03-04 08:16:15.288986 2024-03-04 08:32:14.082117
SBN_to_AWS neocp_obs 598 2024-03-04 08:16:15.288986 2024-03-04 08:32:14.143235
MPC_marsden neocp_obs_archive 559065 2024-03-04 08:16:15.297513 2024-03-04 08:32:14.205988
MPC_mpcweb5 neocp_obs_archive 559065 2024-03-04 08:16:15.297513 2024-03-04 08:32:14.373696
SBN_to_AWS neocp_obs_archive 559065 2024-03-04 08:16:15.297513 2024-03-04 08:32:14.452533
MPC_marsden neocp_prev_des 58817 2024-03-04 04:02:15.251912 2024-03-04 08:32:14.558412
MPC_mpcweb5 neocp_prev_des 58817 2024-03-04 04:02:15.251912 2024-03-04 08:32:14.63879
SBN_to_AWS neocp_prev_des 58817 2024-03-04 04:02:15.251912 2024-03-04 08:32:14.708694
MPC_marsden neocp_var 84337 2024-03-04 08:16:17.856834 2024-03-04 08:32:14.780424
MPC_mpcweb5 neocp_var 84337 2024-03-04 08:16:17.856834 2024-03-04 08:32:14.878011
SBN_to_AWS neocp_var 86337 2024-03-04 08:16:17.856834 2024-03-04 08:32:14.957044
MPC_marsden primary_objects 1403343 2024-03-03 20:08:59.356938 2024-03-04 08:32:15.037067
MPC_mpcweb5 primary_objects 1403343 2024-03-03 20:08:59.356938 2024-03-04 08:32:15.479515
SBN_to_AWS primary_objects 1403343 2024-03-03 20:08:59.356938 2024-03-04 08:32:15.613234
MPC_marsden obs_alterations_corrections 2024-03-04 08:32:15.844039
MPC_mpcweb5 obs_alterations_corrections 2024-03-04 08:32:15.907743
SBN_to_AWS obs_alterations_corrections 2024-03-04 08:32:15.968549
MPC_marsden obs_alterations_deletions 1270421 2024-03-02 15:40:16.499608 2024-03-04 08:32:16.030877
MPC_mpcweb5 obs_alterations_deletions 1270421 2024-03-02 15:40:16.499608 2024-03-04 08:32:16.347418
SBN_to_AWS obs_alterations_deletions 1270421 2024-03-02 15:40:16.499608 2024-03-04 08:32:16.459743
MPC_marsden obs_alterations_redesignations 3004 2024-03-01 16:21:51.971048 2024-03-04 08:32:16.62983
MPC_mpcweb5 obs_alterations_redesignations 3004 2024-03-01 16:21:51.971048 2024-03-04 08:32:16.694749
SBN_to_AWS obs_alterations_redesignations 3004 2024-03-01 16:21:51.971048 2024-03-04 08:32:16.756148