Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

25 Feb 2026

  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

2026-03-13 05:50: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 5215 2026-03-06 22:06:00 2026-03-06 22:06:00
comet_orbits 12088 2014-02-10 15:54:12 2026-03-12 18:01:03
identifications 218005 2026-03-12 12:27:43 2026-03-12 12:27:43
isolated_tracklets 49827150 2026-03-13 05:48:19 2026-03-13 05:48:19
mp_discoverers 1969147 2025-06-18 21:18:06 2025-06-18 21:18:06
numbered_comet_identifications 1292 2025-10-23 16:03:49 2025-10-23 16:03:49
numbered_identifications 1333152 2026-03-05 21:16:52 2026-03-05 21:16:52
numbered_mps 887103 2013-01-31 09:35:48 2026-03-12 16:01:47
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 511996139 2026-03-13 01:09:39 2026-03-13 01:09:39
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1534744 2026-03-13 01:07:32 2026-03-13 02:01:03
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 57 2026-03-12 06:13:32.952304 2026-03-13 05:52:37.327981
neocp_events 315206 2026-03-13 05:52:37.523879 2026-03-13 05:52:37.523879
neocp_obs_archive 789341 2026-03-13 05:52:37.320185 2026-03-13 05:52:37.320185
neocp_obs 1506 2026-03-13 05:52:37.306996 2026-03-13 05:52:37.306996
neocp_prev_des 71431 2026-03-13 05:02:11.289546 2026-03-13 05:02:11.289546
neocp_var 104941 2026-03-13 05:52:37.372699 2026-03-13 05:52:37.372699
current_identifications 2047473 2026-03-13 01:08:28.122331 2026-03-13 01:09:14.752679
numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-02-27 03:49:38.898045
primary_objects 1560114 2026-03-13 01:08:28.102407 2026-03-13 01:08:28.102407
obs_sbn 531505665 2026-03-13 01:35:27.739978-04 2026-03-13 01:54:01.580452-04
obs_alterations_deletions 1494900 2026-03-13 05:21:15.877263 2026-03-13 05:21:15.877263
obs_alterations_redesignations 4534 2026-03-12 19:43:58.635937 2026-03-12 19:43:58.635937
obs_alterations_unassociations 563759 2026-03-12 18:10:06.373925 2026-03-12 18:10:06.373925
mpc_orbits 1517994 2021-02-04 00:48:50.384644 2026-03-13 05:54:11.906332
minor_planet_names 26098 2011-10-28 14:58:12 2026-03-12 20:01:46.061254
obscodes 2684 2026-03-11 15:22:01.984382 2026-03-11 15:22:01.984382
comet_names 4364 2024-12-02 19:54:27.590541 2026-03-12 18:32:33.284922
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 531493203 2026-03-13 04:58:12.004447 2026-03-13 05:00:02.753776
MPC_mpcsbndb obs_sbn 531493203 2026-03-13 04:58:12.004447 2026-03-13 05:00:25.390632
SBN_to_AWS obs_sbn 531493203 2026-03-13 04:58:12.004447 2026-03-13 05:00:50.825242
MPC_primarydb current_identifications 2047473 2026-03-13 01:09:14.752679 2026-03-13 05:10:59.901912
MPC_mpcsbndb current_identifications 2047473 2026-03-13 01:09:14.752679 2026-03-13 05:11:02.512358
SBN_to_AWS current_identifications 2047473 2026-03-13 01:09:14.752679 2026-03-13 05:11:02.753649
MPC_primarydb comet_names 4364 2026-03-12 18:32:33.284922 2026-03-13 05:11:04.212835
MPC_mpcsbndb comet_names 4364 2026-03-12 18:32:33.284922 2026-03-13 05:11:04.323791
SBN_to_AWS comet_names 4364 2026-03-12 18:32:33.284922 2026-03-13 05:11:04.406214
MPC_primarydb minor_planet_names 26098 2026-03-12 20:01:46.061254 2026-03-13 05:11:04.500031
MPC_mpcsbndb minor_planet_names 26098 2026-03-12 20:01:46.061254 2026-03-13 05:11:04.665156
SBN_to_AWS minor_planet_names 26098 2026-03-12 20:01:46.061254 2026-03-13 05:11:04.761857
MPC_primarydb mpc_orbits 1517994 2026-03-13 05:06:08.976707 2026-03-13 05:11:04.90084
MPC_mpcsbndb mpc_orbits 1517994 2026-03-13 05:06:08.976707 2026-03-13 05:11:06.819979
SBN_to_AWS mpc_orbits 1517994 2026-03-13 05:06:08.976707 2026-03-13 05:11:07.08017
MPC_primarydb numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-13 05:11:10.712308
MPC_mpcsbndb numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-13 05:11:11.659556
SBN_to_AWS numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-13 05:11:11.785181
MPC_primarydb neocp_els 57 2026-03-13 05:06:51.234646 2026-03-13 05:11:12.023973
MPC_mpcsbndb neocp_els 57 2026-03-13 05:06:51.234646 2026-03-13 05:11:12.133487
SBN_to_AWS neocp_els 57 2026-03-13 05:06:51.234646 2026-03-13 05:11:12.21528
MPC_primarydb neocp_events 315199 2026-03-13 05:06:51.399437 2026-03-13 05:11:12.31788
MPC_mpcsbndb neocp_events 315199 2026-03-13 05:06:51.399437 2026-03-13 05:11:12.669913
SBN_to_AWS neocp_events 315199 2026-03-13 05:06:51.399437 2026-03-13 05:11:12.77923
MPC_primarydb neocp_obs 1495 2026-03-13 05:06:51.223616 2026-03-13 05:11:12.918299
MPC_mpcsbndb neocp_obs 1495 2026-03-13 05:06:51.223616 2026-03-13 05:11:13.029303
SBN_to_AWS neocp_obs 1495 2026-03-13 05:06:51.223616 2026-03-13 05:11:13.11173
MPC_primarydb neocp_obs_archive 789330 2026-03-13 05:06:51.231594 2026-03-13 05:11:13.206008
MPC_mpcsbndb neocp_obs_archive 789330 2026-03-13 05:06:51.231594 2026-03-13 05:11:13.515611
SBN_to_AWS neocp_obs_archive 789330 2026-03-13 05:06:51.231594 2026-03-13 05:11:13.639718
MPC_primarydb neocp_prev_des 71431 2026-03-13 05:02:11.289546 2026-03-13 05:11:13.860382
MPC_mpcsbndb neocp_prev_des 71431 2026-03-13 05:02:11.289546 2026-03-13 05:11:14.017532
SBN_to_AWS neocp_prev_des 71431 2026-03-13 05:02:11.289546 2026-03-13 05:11:14.115379
MPC_primarydb neocp_var 106218 2026-03-13 05:06:51.269133 2026-03-13 05:11:14.23302
MPC_mpcsbndb neocp_var 106218 2026-03-13 05:06:51.269133 2026-03-13 05:11:14.417404
SBN_to_AWS neocp_var 106218 2026-03-13 05:06:51.269133 2026-03-13 05:11:14.526832
MPC_primarydb obscodes 2684 2026-03-11 15:22:01.984382 2026-03-13 05:11:14.763784
MPC_mpcsbndb obscodes 2684 2026-03-11 15:22:01.984382 2026-03-13 05:11:14.890849
SBN_to_AWS obscodes 2684 2026-03-11 15:22:01.984382 2026-03-13 05:11:14.974133
MPC_primarydb primary_objects 1560114 2026-03-13 01:08:28.102407 2026-03-13 05:11:15.067893
MPC_mpcsbndb primary_objects 1560114 2026-03-13 01:08:28.102407 2026-03-13 05:11:16.588315
SBN_to_AWS primary_objects 1560114 2026-03-13 01:08:28.102407 2026-03-13 05:11:16.740015
MPC_primarydb obs_alterations_corrections 0 2026-03-13 05:11:18.294761
MPC_mpcsbndb obs_alterations_corrections 0 2026-03-13 05:11:18.402807
SBN_to_AWS obs_alterations_corrections 0 2026-03-13 05:11:18.48425
MPC_primarydb obs_alterations_deletions 1494897 2026-03-12 22:21:36.124475 2026-03-13 05:11:18.570127
MPC_mpcsbndb obs_alterations_deletions 1494897 2026-03-12 22:21:36.124475 2026-03-13 05:11:20.513794
SBN_to_AWS obs_alterations_deletions 1494897 2026-03-12 22:21:36.124475 2026-03-13 05:11:20.64322
MPC_primarydb obs_alterations_redesignations 4534 2026-03-12 19:43:58.635937 2026-03-13 05:11:20.876417
MPC_mpcsbndb obs_alterations_redesignations 4534 2026-03-12 19:43:58.635937 2026-03-13 05:11:20.99476
SBN_to_AWS obs_alterations_redesignations 4534 2026-03-12 19:43:58.635937 2026-03-13 05:11:21.077785
MPC_primarydb obs_alterations_unassociations 563759 2026-03-12 18:10:06.373925 2026-03-13 05:11:21.168158
MPC_mpcsbndb obs_alterations_unassociations 563759 2026-03-12 18:10:06.373925 2026-03-13 05:11:21.676521
SBN_to_AWS obs_alterations_unassociations 563759 2026-03-12 18:10:06.373925 2026-03-13 05:11:21.79682