Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

24 Mar 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-04-12 18:20: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 12623 2025-02-07 23:25:28 2026-04-08 21:01:05
identifications 218325 2026-04-12 12:31:40 2026-04-12 12:31:40
isolated_tracklets 49894393 2026-04-12 16:56:28 2026-04-12 16:56:28
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 2026-03-05 21:21:21 2026-03-20 15:09:13
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 512040556 2026-04-12 13:18:47 2026-04-12 13:18:47
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1535942 2023-04-16 14:49:01 2026-04-12 14: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 26 2026-04-12 01:02:23.468957 2026-04-12 14:32:37.541039
neocp_events 320251 2026-04-12 14:32:37.737889 2026-04-12 14:32:37.737889
neocp_obs_archive 801535 2026-04-12 14:32:09.916758 2026-04-12 14:32:09.916758
neocp_obs 314 2026-04-12 14:32:09.909266 2026-04-12 14:32:09.909266
neocp_prev_des 71960 2026-04-12 13:55:38.497556 2026-04-12 13:55:38.497556
neocp_var 59561 2026-04-12 14:32:37.603904 2026-04-12 14:32:37.603904
current_identifications 2048712 2023-04-16 14:48:08.108033 2026-04-12 13:18:15.940669
numbered_identifications 887936 2026-03-24 19:55:09.966554 2026-03-24 19:55:09.966554
primary_objects 1561183 2026-04-12 10:56:37.500384 2026-04-12 10:56:37.500384
obs_sbn 535260888 2026-04-10 01:35:17.561874-04 2026-04-12 14:10:14.774432-04
obs_alterations_deletions 1504553 2026-04-12 17:52:32.91095 2026-04-12 17:52:32.91095
obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-04-07 06:22:54.863572
obs_alterations_unassociations 569249 2026-04-12 18:10:14.689039 2026-04-12 18:10:14.689039
mpc_orbits 1519795 2021-02-04 00:13:21.848747 2026-04-12 12:34:39.346713
minor_planet_names 26118 2020-01-27 05:07:57 2026-03-26 20:42:30.892984
obscodes 2688 2026-03-24 21:22:36.174456 2026-03-24 21:22:36.174456
comet_names 4372 2026-03-31 18:21:22.998027 2026-03-31 18:21:22.998027
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 535260888 2026-04-12 17:52:32.91095 2026-04-12 18:00:02.584845
MPC_mpcsbndb obs_sbn 535260888 2026-04-12 17:52:32.91095 2026-04-12 18:00:19.179281
SBN_to_AWS obs_sbn 535260888 2026-04-12 17:52:32.91095 2026-04-12 18:00:43.795836
MPC_primarydb current_identifications 2048712 2026-04-12 13:18:15.940669 2026-04-12 18:04:41.844293
MPC_mpcsbndb current_identifications 2048712 2026-04-12 13:18:15.940669 2026-04-12 18:04:42.569999
SBN_to_AWS current_identifications 2048712 2026-04-12 13:18:15.940669 2026-04-12 18:04:42.707627
MPC_primarydb comet_names 4372 2026-03-31 18:21:22.998027 2026-04-12 18:04:42.887985
MPC_mpcsbndb comet_names 4372 2026-03-31 18:21:22.998027 2026-04-12 18:04:42.998375
SBN_to_AWS comet_names 4372 2026-03-31 18:21:22.998027 2026-04-12 18:04:43.080817
MPC_primarydb minor_planet_names 26118 2026-03-26 20:42:30.892984 2026-04-12 18:04:43.166923
MPC_mpcsbndb minor_planet_names 26118 2026-03-26 20:42:30.892984 2026-04-12 18:04:43.326954
SBN_to_AWS minor_planet_names 26118 2026-03-26 20:42:30.892984 2026-04-12 18:04:43.421782
MPC_primarydb mpc_orbits 1519795 2026-04-12 12:34:39.346713 2026-04-12 18:04:43.513387
MPC_mpcsbndb mpc_orbits 1519795 2026-04-12 12:34:39.346713 2026-04-12 18:04:45.042364
SBN_to_AWS mpc_orbits 1519795 2026-04-12 12:34:39.346713 2026-04-12 18:04:45.276553
MPC_primarydb numbered_identifications 887936 2026-03-24 19:55:09.966554 2026-04-12 18:04:46.532113
MPC_mpcsbndb numbered_identifications 887936 2026-03-24 19:55:09.966554 2026-04-12 18:04:46.83823
SBN_to_AWS numbered_identifications 887936 2026-03-24 19:55:09.966554 2026-04-12 18:04:46.963978
MPC_primarydb neocp_els 26 2026-04-12 14:32:37.541039 2026-04-12 18:04:47.115262
MPC_mpcsbndb neocp_els 26 2026-04-12 14:32:37.541039 2026-04-12 18:04:47.224012
SBN_to_AWS neocp_els 26 2026-04-12 14:32:37.541039 2026-04-12 18:04:47.305647
MPC_primarydb neocp_events 320251 2026-04-12 14:32:37.737889 2026-04-12 18:04:47.391957
MPC_mpcsbndb neocp_events 320251 2026-04-12 14:32:37.737889 2026-04-12 18:04:47.568556
SBN_to_AWS neocp_events 320251 2026-04-12 14:32:37.737889 2026-04-12 18:04:47.67995
MPC_primarydb neocp_obs 314 2026-04-12 14:32:09.909266 2026-04-12 18:04:47.787893
MPC_mpcsbndb neocp_obs 314 2026-04-12 14:32:09.909266 2026-04-12 18:04:47.898484
SBN_to_AWS neocp_obs 314 2026-04-12 14:32:09.909266 2026-04-12 18:04:47.980902
MPC_primarydb neocp_obs_archive 801535 2026-04-12 14:32:09.916758 2026-04-12 18:04:48.067242
MPC_mpcsbndb neocp_obs_archive 801535 2026-04-12 14:32:09.916758 2026-04-12 18:04:48.297125
SBN_to_AWS neocp_obs_archive 801535 2026-04-12 14:32:09.916758 2026-04-12 18:04:48.422631
MPC_primarydb neocp_prev_des 71960 2026-04-12 13:55:38.497556 2026-04-12 18:04:48.562141
MPC_mpcsbndb neocp_prev_des 71960 2026-04-12 13:55:38.497556 2026-04-12 18:04:48.703324
SBN_to_AWS neocp_prev_des 71960 2026-04-12 13:55:38.497556 2026-04-12 18:04:48.799705
MPC_primarydb neocp_var 59561 2026-04-12 14:32:37.603904 2026-04-12 18:04:48.893885
MPC_mpcsbndb neocp_var 59561 2026-04-12 14:32:37.603904 2026-04-12 18:04:49.078039
SBN_to_AWS neocp_var 59561 2026-04-12 14:32:37.603904 2026-04-12 18:04:49.178859
MPC_primarydb obscodes 2688 2026-03-24 21:22:36.174456 2026-04-12 18:04:49.294445
MPC_mpcsbndb obscodes 2688 2026-03-24 21:22:36.174456 2026-04-12 18:04:49.419589
SBN_to_AWS obscodes 2688 2026-03-24 21:22:36.174456 2026-04-12 18:04:49.502674
MPC_primarydb primary_objects 1561183 2026-04-12 10:56:37.500384 2026-04-12 18:04:49.588899
MPC_mpcsbndb primary_objects 1561183 2026-04-12 10:56:37.500384 2026-04-12 18:04:50.012696
SBN_to_AWS primary_objects 1561183 2026-04-12 10:56:37.500384 2026-04-12 18:04:50.17709
MPC_primarydb obs_alterations_corrections 0 2026-04-12 18:04:50.38914
MPC_mpcsbndb obs_alterations_corrections 0 2026-04-12 18:04:50.496631
SBN_to_AWS obs_alterations_corrections 0 2026-04-12 18:04:50.577891
MPC_primarydb obs_alterations_deletions 1504553 2026-04-12 17:52:32.91095 2026-04-12 18:04:50.662963
MPC_mpcsbndb obs_alterations_deletions 1504553 2026-04-12 17:52:32.91095 2026-04-12 18:04:51.097541
SBN_to_AWS obs_alterations_deletions 1504553 2026-04-12 17:52:32.91095 2026-04-12 18:04:51.224296
MPC_primarydb obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-04-12 18:04:51.371835
MPC_mpcsbndb obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-04-12 18:04:51.482864
SBN_to_AWS obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-04-12 18:04:51.565988
MPC_primarydb obs_alterations_unassociations 569239 2026-04-12 14:10:08.445259 2026-04-12 18:04:51.651786
MPC_mpcsbndb obs_alterations_unassociations 569239 2026-04-12 14:10:08.445259 2026-04-12 18:04:51.922126
SBN_to_AWS obs_alterations_unassociations 569239 2026-04-12 14:10:08.445259 2026-04-12 18:04:52.041995