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-20 19: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 12086 2014-02-10 15:54:08 2026-03-17 22:01:06
identifications 218077 2026-03-20 12:27:48 2026-03-20 12:27:48
isolated_tracklets 49836687 2026-03-20 18:18:38 2026-03-20 18:18:38
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 512008794 2026-03-20 19:07:47 2026-03-20 19:07:47
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1534951 2026-03-20 19:07:51 2026-03-20 19:07:51
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 70 2026-02-03 15:31:03.146684 2026-03-20 19:21:26.634875
neocp_events 317128 2026-03-20 19:07:05.977024 2026-03-20 19:07:05.977024
neocp_obs_archive 794238 2026-03-20 18:59:43.171168 2026-03-20 18:59:43.171168
neocp_obs 1884 2026-03-20 18:59:43.154686 2026-03-20 18:59:43.154686
neocp_prev_des 71602 2026-03-20 19:07:05.865325 2026-03-20 19:07:05.865325
neocp_var 145480 2026-03-20 18:59:43.263769 2026-03-20 18:59:43.263769
current_identifications 2047713 2026-03-20 19:06:26.419476 2026-03-20 19:07:19.472375
numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-02-27 03:49:38.898045
primary_objects 1560318 2026-03-20 19:06:26.350762 2026-03-20 19:06:26.350762
obs_sbn 532086351 2026-03-20 14:55:42.755789-04 2026-03-20 15:07:21.895767-04
obs_alterations_deletions 1495310 2026-03-20 16:31:27.231946 2026-03-20 16:31:27.231946
obs_alterations_redesignations 4827 2026-03-19 21:32:24.382836 2026-03-19 21:32:24.382836
obs_alterations_unassociations 564462 2026-03-20 18:10:14.092031 2026-03-20 18:10:14.092031
mpc_orbits 1518462 2021-02-04 02:30:01.591653 2026-03-20 19:22:23.425875
minor_planet_names 26118 2013-03-28 19:50:22 2026-03-20 19:08:47.331146
obscodes 2687 2019-05-25 00:11:24.513966 2026-03-18 19:10:45.593554
comet_names 4366 2026-03-17 19:39:41.367684 2026-03-17 19:39:41.367684
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 532086300 2026-03-20 18:39:26.990946 2026-03-20 19:00:02.8185
MPC_mpcsbndb obs_sbn 532086300 2026-03-20 18:39:26.990946 2026-03-20 19:00:34.726599
SBN_to_AWS obs_sbn 532086300 2026-03-20 18:39:26.990946 2026-03-20 19:01:20.841977
MPC_primarydb current_identifications 2047713 2026-03-20 19:07:19.472375 2026-03-20 19:13:57.205905
MPC_mpcsbndb current_identifications 2047713 2026-03-20 19:07:19.472375 2026-03-20 19:13:58.243636
SBN_to_AWS current_identifications 2047713 2026-03-20 19:07:19.472375 2026-03-20 19:13:58.386915
MPC_primarydb comet_names 4366 2026-03-17 19:39:41.367684 2026-03-20 19:13:58.989348
MPC_mpcsbndb comet_names 4366 2026-03-17 19:39:41.367684 2026-03-20 19:13:59.093952
SBN_to_AWS comet_names 4366 2026-03-17 19:39:41.367684 2026-03-20 19:13:59.177181
MPC_primarydb minor_planet_names 26118 2026-03-20 19:08:47.331146 2026-03-20 19:13:59.269718
MPC_mpcsbndb minor_planet_names 26118 2026-03-20 19:08:47.331146 2026-03-20 19:13:59.42219
SBN_to_AWS minor_planet_names 26118 2026-03-20 19:08:47.331146 2026-03-20 19:13:59.51834
MPC_primarydb mpc_orbits 1518462 2026-03-20 19:12:22.771846 2026-03-20 19:13:59.654525
MPC_mpcsbndb mpc_orbits 1518462 2026-03-20 19:12:22.771846 2026-03-20 19:14:01.164042
SBN_to_AWS mpc_orbits 1518462 2026-03-20 19:12:22.771846 2026-03-20 19:14:01.66415
MPC_primarydb numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-20 19:14:03.941842
MPC_mpcsbndb numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-20 19:14:04.308728
SBN_to_AWS numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-20 19:14:04.44499
MPC_primarydb neocp_els 70 2026-03-20 18:59:43.173858 2026-03-20 19:14:04.749398
MPC_mpcsbndb neocp_els 70 2026-03-20 18:59:43.173858 2026-03-20 19:14:04.85578
SBN_to_AWS neocp_els 70 2026-03-20 18:59:43.173858 2026-03-20 19:14:04.938468
MPC_primarydb neocp_events 317128 2026-03-20 19:07:05.977024 2026-03-20 19:14:05.031563
MPC_mpcsbndb neocp_events 317128 2026-03-20 19:07:05.977024 2026-03-20 19:14:05.216654
SBN_to_AWS neocp_events 317128 2026-03-20 19:07:05.977024 2026-03-20 19:14:05.335513
MPC_primarydb neocp_obs 1833 2026-03-20 18:59:43.154686 2026-03-20 19:14:05.540162
MPC_mpcsbndb neocp_obs 1833 2026-03-20 18:59:43.154686 2026-03-20 19:14:05.645464
SBN_to_AWS neocp_obs 1833 2026-03-20 18:59:43.154686 2026-03-20 19:14:05.729917
MPC_primarydb neocp_obs_archive 794238 2026-03-20 18:59:43.171168 2026-03-20 19:14:05.833393
MPC_mpcsbndb neocp_obs_archive 794238 2026-03-20 18:59:43.171168 2026-03-20 19:14:06.100451
SBN_to_AWS neocp_obs_archive 794238 2026-03-20 18:59:43.171168 2026-03-20 19:14:06.244672
MPC_primarydb neocp_prev_des 71602 2026-03-20 19:07:05.865325 2026-03-20 19:14:06.575545
MPC_mpcsbndb neocp_prev_des 71602 2026-03-20 19:07:05.865325 2026-03-20 19:14:06.70944
SBN_to_AWS neocp_prev_des 71602 2026-03-20 19:07:05.865325 2026-03-20 19:14:06.810035
MPC_primarydb neocp_var 143480 2026-03-20 18:59:43.263769 2026-03-20 19:14:06.91955
MPC_mpcsbndb neocp_var 143480 2026-03-20 18:59:43.263769 2026-03-20 19:14:07.0857
SBN_to_AWS neocp_var 143480 2026-03-20 18:59:43.263769 2026-03-20 19:14:07.19911
MPC_primarydb obscodes 2687 2026-03-18 19:10:45.593554 2026-03-20 19:14:07.359887
MPC_mpcsbndb obscodes 2687 2026-03-18 19:10:45.593554 2026-03-20 19:14:07.479285
SBN_to_AWS obscodes 2687 2026-03-18 19:10:45.593554 2026-03-20 19:14:07.567644
MPC_primarydb primary_objects 1560318 2026-03-20 19:06:26.350762 2026-03-20 19:14:07.658528
MPC_mpcsbndb primary_objects 1560318 2026-03-20 19:06:26.350762 2026-03-20 19:14:08.194595
SBN_to_AWS primary_objects 1560318 2026-03-20 19:06:26.350762 2026-03-20 19:14:08.419167
MPC_primarydb obs_alterations_corrections 0 2026-03-20 19:14:08.848515
MPC_mpcsbndb obs_alterations_corrections 0 2026-03-20 19:14:08.960794
SBN_to_AWS obs_alterations_corrections 0 2026-03-20 19:14:09.042301
MPC_primarydb obs_alterations_deletions 1495310 2026-03-20 16:31:27.231946 2026-03-20 19:14:09.127278
MPC_mpcsbndb obs_alterations_deletions 1495310 2026-03-20 16:31:27.231946 2026-03-20 19:14:09.634999
SBN_to_AWS obs_alterations_deletions 1495310 2026-03-20 16:31:27.231946 2026-03-20 19:14:09.778438
MPC_primarydb obs_alterations_redesignations 4827 2026-03-19 21:32:24.382836 2026-03-20 19:14:09.946714
MPC_mpcsbndb obs_alterations_redesignations 4827 2026-03-19 21:32:24.382836 2026-03-20 19:14:10.055587
SBN_to_AWS obs_alterations_redesignations 4827 2026-03-19 21:32:24.382836 2026-03-20 19:14:10.139661
MPC_primarydb obs_alterations_unassociations 564462 2026-03-20 18:10:14.092031 2026-03-20 19:14:10.230309
MPC_mpcsbndb obs_alterations_unassociations 564462 2026-03-20 18:10:14.092031 2026-03-20 19:14:10.573216
SBN_to_AWS obs_alterations_unassociations 564462 2026-03-20 18:10:14.092031 2026-03-20 19:14:10.695747