Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

24 Apr 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-05-13 21: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 5215 2026-03-06 22:06:00 2026-03-06 22:06:00
comet_orbits 12626 2025-02-07 23:25:28 2026-05-08 21:01:03
identifications 218331 2026-04-14 12:33:30 2026-04-14 12:33:30
isolated_tracklets 49949370 2026-05-13 20:38:35 2026-05-13 20:38:35
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 2024-02-21 19:12:24 2026-05-07 10:18:37
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 512076593 2026-05-13 19:07:00 2026-05-13 19:07:00
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1558214 2026-05-13 19:07:04 2026-05-13 20: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 31 2026-05-12 07:15:03.450886 2026-05-13 20:57:52.560649
neocp_events 323594 2026-05-13 20:57:52.788022 2026-05-13 20:57:52.788022
neocp_obs_archive 810226 2026-05-13 20:57:52.519212 2026-05-13 20:57:52.519212
neocp_obs 424 2026-05-13 20:57:52.478004 2026-05-13 20:57:52.478004
neocp_prev_des 72364 2026-05-13 20:36:25.876143 2026-05-13 20:36:25.876143
neocp_var 71021 2026-05-13 20:57:52.646844 2026-05-13 20:57:52.646844
current_identifications 2070898 2026-05-13 20:35:46.667727 2026-05-13 20:35:46.667727
numbered_identifications 887936 2026-03-24 19:55:09.966554 2026-03-24 19:55:09.966554
primary_objects 1583366 2026-05-13 20:35:46.520209 2026-05-13 20:35:46.520209
obs_sbn 538752304 2022-11-25 08:19:17.071461-05 2026-05-13 16:46:10.015295-04
obs_alterations_deletions 1509816 2026-05-13 17:58:44.012014 2026-05-13 17:58:44.012014
obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-04-07 06:22:54.863572
obs_alterations_unassociations 579364 2026-05-13 18:10:07.460076 2026-05-13 18:10:07.460076
mpc_orbits 1548244 2026-05-13 20:36:11.282927 2026-05-13 20:46:31.087731
minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-05-07 14:26:32.139498
obscodes 2701 2026-05-11 21:27:27.616557 2026-05-11 21:27:27.616557
comet_names 4374 2026-05-06 19:14:21.901296 2026-05-06 19:14:21.901296
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 538750774 2026-05-13 19:59:58.935711 2026-05-13 20:00:02.180838
MPC_mpcsbndb obs_sbn 538750888 2026-05-13 20:00:19.069852 2026-05-13 20:00:26.710621
SBN_to_AWS obs_sbn 538751026 2026-05-13 20:00:40.822177 2026-05-13 20:00:50.036958
MPC_primarydb current_identifications 2070897 2026-05-13 19:06:29.839038 2026-05-13 20:16:08.048063
MPC_mpcsbndb current_identifications 2070897 2026-05-13 19:06:29.839038 2026-05-13 20:16:09.096874
SBN_to_AWS current_identifications 2070897 2026-05-13 19:06:29.839038 2026-05-13 20:16:09.23951
MPC_primarydb comet_names 4374 2026-05-06 19:14:21.901296 2026-05-13 20:16:09.618605
MPC_mpcsbndb comet_names 4374 2026-05-06 19:14:21.901296 2026-05-13 20:16:09.726109
SBN_to_AWS comet_names 4374 2026-05-06 19:14:21.901296 2026-05-13 20:16:09.809998
MPC_primarydb minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-05-13 20:16:09.904094
MPC_mpcsbndb minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-05-13 20:16:10.069337
SBN_to_AWS minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-05-13 20:16:10.165556
MPC_primarydb mpc_orbits 1548243 2026-05-13 20:04:35.832975 2026-05-13 20:16:10.308985
MPC_mpcsbndb mpc_orbits 1548243 2026-05-13 20:04:35.832975 2026-05-13 20:16:12.059285
SBN_to_AWS mpc_orbits 1548243 2026-05-13 20:04:35.832975 2026-05-13 20:16:12.419117
MPC_primarydb numbered_identifications 887800 2026-03-24 19:55:09.966554 2026-05-13 20:16:16.923207
MPC_mpcsbndb numbered_identifications 887800 2026-03-24 19:55:09.966554 2026-05-13 20:16:17.373619
SBN_to_AWS numbered_identifications 887800 2026-03-24 19:55:09.966554 2026-05-13 20:16:17.505113
MPC_primarydb neocp_els 32 2026-05-13 18:21:11.146076 2026-05-13 20:16:17.79072
MPC_mpcsbndb neocp_els 32 2026-05-13 18:21:11.146076 2026-05-13 20:16:17.899932
SBN_to_AWS neocp_els 32 2026-05-13 18:21:11.146076 2026-05-13 20:16:17.983268
MPC_primarydb neocp_events 323584 2026-05-13 19:11:25.209974 2026-05-13 20:16:18.073238
MPC_mpcsbndb neocp_events 323584 2026-05-13 19:11:25.209974 2026-05-13 20:16:18.311015
SBN_to_AWS neocp_events 323584 2026-05-13 19:11:25.209974 2026-05-13 20:16:18.428585
MPC_primarydb neocp_obs 405 2026-05-13 18:04:18.774404 2026-05-13 20:16:18.579592
MPC_mpcsbndb neocp_obs 405 2026-05-13 18:04:18.774404 2026-05-13 20:16:18.690607
SBN_to_AWS neocp_obs 405 2026-05-13 18:04:18.774404 2026-05-13 20:16:18.773886
MPC_primarydb neocp_obs_archive 810193 2026-05-13 18:04:18.891191 2026-05-13 20:16:18.86697
MPC_mpcsbndb neocp_obs_archive 810193 2026-05-13 18:04:18.891191 2026-05-13 20:16:19.167344
SBN_to_AWS neocp_obs_archive 810193 2026-05-13 18:04:18.891191 2026-05-13 20:16:19.292666
MPC_primarydb neocp_prev_des 72363 2026-05-13 19:06:13.252682 2026-05-13 20:16:19.514043
MPC_mpcsbndb neocp_prev_des 72363 2026-05-13 19:06:13.252682 2026-05-13 20:16:19.66028
SBN_to_AWS neocp_prev_des 72363 2026-05-13 19:06:13.252682 2026-05-13 20:16:19.758338
MPC_primarydb neocp_var 74620 2026-05-13 18:04:18.933712 2026-05-13 20:16:19.87583
MPC_mpcsbndb neocp_var 74620 2026-05-13 18:04:18.933712 2026-05-13 20:16:20.039181
SBN_to_AWS neocp_var 74620 2026-05-13 18:04:18.933712 2026-05-13 20:16:20.149156
MPC_primarydb obscodes 2701 2026-05-11 21:27:27.616557 2026-05-13 20:16:20.309061
MPC_mpcsbndb obscodes 2701 2026-05-11 21:27:27.616557 2026-05-13 20:16:20.445341
SBN_to_AWS obscodes 2701 2026-05-11 21:27:27.616557 2026-05-13 20:16:20.529386
MPC_primarydb primary_objects 1583365 2026-05-13 19:05:26.801491 2026-05-13 20:16:20.622221
MPC_mpcsbndb primary_objects 1583365 2026-05-13 19:05:26.801491 2026-05-13 20:16:21.346724
SBN_to_AWS primary_objects 1583365 2026-05-13 19:05:26.801491 2026-05-13 20:16:21.518766
MPC_primarydb obs_alterations_corrections 0 2026-05-13 20:16:23.132633
MPC_mpcsbndb obs_alterations_corrections 0 2026-05-13 20:16:23.239145
SBN_to_AWS obs_alterations_corrections 0 2026-05-13 20:16:23.32262
MPC_primarydb obs_alterations_deletions 1509816 2026-05-13 17:58:44.012014 2026-05-13 20:16:23.408825
MPC_mpcsbndb obs_alterations_deletions 1509816 2026-05-13 17:58:44.012014 2026-05-13 20:16:24.140905
SBN_to_AWS obs_alterations_deletions 1509816 2026-05-13 17:58:44.012014 2026-05-13 20:16:24.269661
MPC_primarydb obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-05-13 20:16:24.447273
MPC_mpcsbndb obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-05-13 20:16:24.561834
SBN_to_AWS obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-05-13 20:16:24.64628
MPC_primarydb obs_alterations_unassociations 579364 2026-05-13 18:10:07.460076 2026-05-13 20:16:24.739034
MPC_mpcsbndb obs_alterations_unassociations 579364 2026-05-13 18:10:07.460076 2026-05-13 20:16:25.057311
SBN_to_AWS obs_alterations_unassociations 579364 2026-05-13 18:10:07.460076 2026-05-13 20:16:25.181127