Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

11 Jul 2025

  1. Nominal.

Please report concerns!

KEY

Database Replication

Instructions (not for the faint of heart) for replicating the database are posted. Questions/issues related to replication should be directed to Andrei Mamoutkine.

Latest update of every table in MPC MariaDB and Postgres

2025-07-15 22:00:01 (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
comet_names 5206 2025-04-09 15:30:27 2025-04-09 15:30:27
comet_orbits 10019 2025-07-14 19:21:27 2025-07-14 20:01:02
identifications 206919 2025-07-14 12:28:23 2025-07-14 12:28:23
isolated_tracklets 48743206 2025-07-15 21:58:11 2025-07-15 21:58:11
mp_discoverers 1969147 2025-06-18 21:18:06 2025-06-18 21:18:06
numbered_comet_identifications 1091 2025-06-24 16:23:23 2025-06-24 16:23:23
numbered_identifications 1241797 2025-06-22 19:43:06 2025-06-22 19:43:06
numbered_mps 811552 2018-05-31 01:04:45 2025-07-08 10:13:12
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 483002878 2025-07-15 21:30:32 2025-07-15 21:30:32
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1471499 2025-07-15 21:30:38 2025-07-15 22:01:02
radar_observations 1507 2024-12-04 04:59:18 2024-12-04 04:59:18
No change in Maria mpc_development database structure.

Postgres mpc_sbn:

Table Count Created_at Updated_at
neocp_els 24 2025-07-15 10:39:06.630607 2025-07-15 21:58:22.169328
neocp_events 278188 2025-07-15 21:58:22.337435 2025-07-15 21:58:22.337435
neocp_obs_archive 706657 2025-07-15 21:58:22.166618 2025-07-15 21:58:22.166618
neocp_obs 217 2025-07-15 21:58:22.159765 2025-07-15 21:58:22.159765
neocp_prev_des 66606 2025-07-15 21:30:10.86612 2025-07-15 21:30:10.86612
neocp_var 47209 2025-07-15 21:58:22.205536 2025-07-15 21:58:22.205536
current_identifications 1981071 2025-07-15 21:15:54.733631 2025-07-15 21:30:15.905598
numbered_identifications 812353 2025-07-02 20:42:14.240799 2025-07-02 21:10:12.477554
primary_objects 1499078 2025-07-15 21:15:54.695525 2025-07-15 21:15:54.695525
obs_sbn 494413065 2025-07-15 17:55:04.814028-04 2025-07-15 17:58:09.809027-04
obs_alterations_deletions 1359763 2025-07-15 11:25:20.240967 2025-07-15 11:25:20.240967
obs_alterations_redesignations 4254 2025-05-21 17:18:42.682759 2025-06-13 07:10:58.084417
obs_alterations_unassociations 420572 2025-07-15 00:10:06.237855 2025-07-15 00:10:06.237855
mpc_orbits 1451904 2025-05-04 13:18:21.396556 2025-07-15 21:35:12.836811
minor_planet_names 25565 2018-03-04 02:26:16 2025-07-08 14:12:32.989
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_primarydb obs_sbn 494412997 2025-07-15 20:58:10.265924 2025-07-15 21:00:02.160746
MPC_mpcsbndb obs_sbn 494412997 2025-07-15 20:58:10.265924 2025-07-15 21:00:26.438212
SBN_to_AWS obs_sbn 494412997 2025-07-15 20:58:10.265924 2025-07-15 21:00:39.212399
MPC_primarydb current_identifications 1981070 2025-07-15 20:42:23.411468 2025-07-15 21:13:03.298607
MPC_mpcsbndb current_identifications 1981070 2025-07-15 20:42:23.411468 2025-07-15 21:13:03.956779
SBN_to_AWS current_identifications 1981070 2025-07-15 20:42:23.411468 2025-07-15 21:13:04.154556
MPC_primarydb minor_planet_names 25565 2025-07-08 14:12:32.989 2025-07-15 21:13:04.363904
MPC_mpcsbndb minor_planet_names 25565 2025-07-08 14:12:32.989 2025-07-15 21:13:04.51762
SBN_to_AWS minor_planet_names 25565 2025-07-08 14:12:32.989 2025-07-15 21:13:04.624024
MPC_primarydb mpc_orbits 1451903 2025-07-15 20:42:18.711075 2025-07-15 21:13:04.720609
MPC_mpcsbndb mpc_orbits 1451903 2025-07-15 20:42:18.711075 2025-07-15 21:13:05.709228
SBN_to_AWS mpc_orbits 1451903 2025-07-15 20:42:18.711075 2025-07-15 21:13:05.90836
MPC_primarydb numbered_identifications 812353 2025-07-02 21:10:12.477554 2025-07-15 21:13:06.209791
MPC_mpcsbndb numbered_identifications 812353 2025-07-02 21:10:12.477554 2025-07-15 21:13:06.538738
SBN_to_AWS numbered_identifications 812353 2025-07-02 21:10:12.477554 2025-07-15 21:13:06.67296
MPC_primarydb neocp_els 25 2025-07-15 16:32:15.036393 2025-07-15 21:13:06.807995
MPC_mpcsbndb neocp_els 25 2025-07-15 16:32:15.036393 2025-07-15 21:13:06.915134
SBN_to_AWS neocp_els 25 2025-07-15 16:32:15.036393 2025-07-15 21:13:07.002829
MPC_primarydb neocp_events 278185 2025-07-15 19:41:28.560634 2025-07-15 21:13:07.093269
MPC_mpcsbndb neocp_events 278185 2025-07-15 19:41:28.560634 2025-07-15 21:13:07.289424
SBN_to_AWS neocp_events 278185 2025-07-15 19:41:28.560634 2025-07-15 21:13:07.408775
MPC_primarydb neocp_obs 252 2025-07-15 14:34:09.616095 2025-07-15 21:13:07.517724
MPC_mpcsbndb neocp_obs 252 2025-07-15 14:34:09.616095 2025-07-15 21:13:07.622356
SBN_to_AWS neocp_obs 252 2025-07-15 14:34:09.616095 2025-07-15 21:13:07.710713
MPC_primarydb neocp_obs_archive 706652 2025-07-15 19:20:30.19714 2025-07-15 21:13:07.801939
MPC_mpcsbndb neocp_obs_archive 706652 2025-07-15 19:20:30.19714 2025-07-15 21:13:08.066357
SBN_to_AWS neocp_obs_archive 706652 2025-07-15 19:20:30.19714 2025-07-15 21:13:08.195458
MPC_primarydb neocp_prev_des 66605 2025-07-15 19:41:28.536141 2025-07-15 21:13:08.326055
MPC_mpcsbndb neocp_prev_des 66605 2025-07-15 19:41:28.536141 2025-07-15 21:13:08.466286
SBN_to_AWS neocp_prev_des 66605 2025-07-15 19:41:28.536141 2025-07-15 21:13:08.569734
MPC_primarydb neocp_var 49209 2025-07-15 16:32:15.078442 2025-07-15 21:13:08.66689
MPC_mpcsbndb neocp_var 49209 2025-07-15 16:32:15.078442 2025-07-15 21:13:08.80282
SBN_to_AWS neocp_var 49209 2025-07-15 16:32:15.078442 2025-07-15 21:13:08.911056
MPC_primarydb obscodes 2627 2025-07-15 13:53:07.724401 2025-07-15 21:13:09.005617
MPC_mpcsbndb obscodes 2627 2025-07-15 13:53:07.724401 2025-07-15 21:13:09.134763
SBN_to_AWS obscodes 2627 2025-07-15 13:53:07.724401 2025-07-15 21:13:09.22346
MPC_primarydb primary_objects 1499077 2025-07-15 20:41:37.385201 2025-07-15 21:13:09.314566
MPC_mpcsbndb primary_objects 1499077 2025-07-15 20:41:37.385201 2025-07-15 21:13:09.813218
SBN_to_AWS primary_objects 1499077 2025-07-15 20:41:37.385201 2025-07-15 21:13:09.975911
MPC_primarydb obs_alterations_corrections 0 2025-07-15 21:13:10.209137
MPC_mpcsbndb obs_alterations_corrections 0 2025-07-15 21:13:10.311443
SBN_to_AWS obs_alterations_corrections 0 2025-07-15 21:13:10.399243
MPC_primarydb obs_alterations_deletions 1359763 2025-07-15 11:25:20.240967 2025-07-15 21:13:10.490116
MPC_mpcsbndb obs_alterations_deletions 1359763 2025-07-15 11:25:20.240967 2025-07-15 21:13:10.987836
SBN_to_AWS obs_alterations_deletions 1359763 2025-07-15 11:25:20.240967 2025-07-15 21:13:11.12009
MPC_primarydb obs_alterations_redesignations 4254 2025-06-13 07:10:58.084417 2025-07-15 21:13:11.2634
MPC_mpcsbndb obs_alterations_redesignations 4254 2025-06-13 07:10:58.084417 2025-07-15 21:13:11.374054
SBN_to_AWS obs_alterations_redesignations 4254 2025-06-13 07:10:58.084417 2025-07-15 21:13:11.463208