Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

21 May 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-30 04:50:02 (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 12628 2023-09-20 23:40:02 2026-05-28 20:01:03
identifications 218331 2026-04-14 12:33:30 2026-04-14 12:33:30
isolated_tracklets 49972036 2026-05-30 04:48:17 2026-05-30 04:48:17
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 512094699 2026-05-30 04:37:10 2026-05-30 04:37:10
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1559090 2026-05-30 04:37:15 2026-05-30 04:37:15
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 20 2026-05-29 06:34:06.386669 2026-05-30 04:33:13.450697
neocp_events 325210 2026-05-30 04:36:40.411329 2026-05-30 04:36:40.411329
neocp_obs_archive 813684 2026-05-30 04:33:13.368736 2026-05-30 04:33:13.368736
neocp_obs 188 2026-05-30 04:33:13.327245 2026-05-30 04:33:13.327245
neocp_prev_des 72593 2026-05-30 04:36:39.954243 2026-05-30 04:36:39.954243
neocp_var 52665 2026-05-30 04:33:13.540459 2026-05-30 04:33:13.540459
current_identifications 2071709 2026-05-30 04:35:56.444459 2026-05-30 04:36:49.367007
numbered_identifications 887936 2026-03-24 19:55:09.966554 2026-03-24 19:55:09.966554
primary_objects 1584166 2026-05-30 04:35:56.167241 2026-05-30 04:35:56.167241
obs_sbn 539910872 2026-05-30 00:50:36.604768-04 2026-05-30 00:51:14.136984-04
obs_alterations_deletions 1690905 2026-05-30 03:53:06.868197 2026-05-30 03:53:06.868197
obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-04-07 06:22:54.863572
obs_alterations_unassociations 581056 2026-05-29 15:25:20.527246 2026-05-29 15:25:20.527246
mpc_orbits 1549072 2022-02-02 07:30:56.68266 2026-05-30 04:51:14.136984
minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-05-07 14:26:32.139498
obscodes 2703 2019-05-25 00:11:26.475272 2026-05-27 23:09:26.958103
comet_names 4376 2026-05-26 21:03:40.256139 2026-05-26 21:03:40.256139
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 539910199 2026-05-30 03:58:14.845226 2026-05-30 04:00:02.255412
MPC_mpcsbndb obs_sbn 539910199 2026-05-30 04:01:16.786519 2026-05-30 04:01:27.316697
SBN_to_AWS obs_sbn 539910199 2026-05-30 04:01:16.786519 2026-05-30 04:01:52.557133
MPC_primarydb current_identifications 2071708 2026-05-30 04:01:42.884284 2026-05-30 04:18:39.207369
MPC_mpcsbndb current_identifications 2071708 2026-05-30 04:01:42.884284 2026-05-30 04:18:52.680631
SBN_to_AWS current_identifications 2071708 2026-05-30 04:01:42.884284 2026-05-30 04:18:52.841969
MPC_primarydb comet_names 4376 2026-05-26 21:03:40.256139 2026-05-30 04:18:53.256962
MPC_mpcsbndb comet_names 4376 2026-05-26 21:03:40.256139 2026-05-30 04:18:53.364625
SBN_to_AWS comet_names 4376 2026-05-26 21:03:40.256139 2026-05-30 04:18:53.451742
MPC_primarydb minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-05-30 04:18:53.54995
MPC_mpcsbndb minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-05-30 04:18:53.726674
SBN_to_AWS minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-05-30 04:18:53.826012
MPC_primarydb mpc_orbits 1549071 2026-05-30 04:17:54.709877 2026-05-30 04:18:53.972182
MPC_mpcsbndb mpc_orbits 1549071 2026-05-30 04:17:54.709877 2026-05-30 04:18:55.986906
SBN_to_AWS mpc_orbits 1549071 2026-05-30 04:17:54.709877 2026-05-30 04:18:56.20259
MPC_primarydb numbered_identifications 887800 2026-03-24 19:55:09.966554 2026-05-30 04:18:57.524467
MPC_mpcsbndb numbered_identifications 887800 2026-03-24 19:55:09.966554 2026-05-30 04:18:57.89666
SBN_to_AWS numbered_identifications 887800 2026-03-24 19:55:09.966554 2026-05-30 04:18:58.02764
MPC_primarydb neocp_els 20 2026-05-29 23:54:37.446304 2026-05-30 04:18:58.311182
MPC_mpcsbndb neocp_els 20 2026-05-29 23:54:37.446304 2026-05-30 04:18:58.416654
SBN_to_AWS neocp_els 20 2026-05-29 23:54:37.446304 2026-05-30 04:18:58.503069
MPC_primarydb neocp_events 325207 2026-05-30 01:05:28.330576 2026-05-30 04:18:58.597565
MPC_mpcsbndb neocp_events 325207 2026-05-30 01:05:28.330576 2026-05-30 04:18:58.806598
SBN_to_AWS neocp_events 325207 2026-05-30 01:05:28.330576 2026-05-30 04:18:58.920313
MPC_primarydb neocp_obs 180 2026-05-29 23:54:37.39145 2026-05-30 04:18:59.069713
MPC_mpcsbndb neocp_obs 180 2026-05-29 23:54:37.39145 2026-05-30 04:18:59.175962
SBN_to_AWS neocp_obs 180 2026-05-29 23:54:37.39145 2026-05-30 04:18:59.261707
MPC_primarydb neocp_obs_archive 813676 2026-05-29 23:54:37.410227 2026-05-30 04:18:59.357303
MPC_mpcsbndb neocp_obs_archive 813676 2026-05-29 23:54:37.410227 2026-05-30 04:18:59.690265
SBN_to_AWS neocp_obs_archive 813676 2026-05-29 23:54:37.410227 2026-05-30 04:18:59.818406
MPC_primarydb neocp_prev_des 72592 2026-05-30 01:05:28.182425 2026-05-30 04:19:00.045157
MPC_mpcsbndb neocp_prev_des 72592 2026-05-30 01:05:28.182425 2026-05-30 04:19:00.198711
SBN_to_AWS neocp_prev_des 72592 2026-05-30 01:05:28.182425 2026-05-30 04:19:00.298317
MPC_primarydb neocp_var 52665 2026-05-29 23:54:37.548985 2026-05-30 04:19:00.417934
MPC_mpcsbndb neocp_var 52665 2026-05-29 23:54:37.548985 2026-05-30 04:19:00.563045
SBN_to_AWS neocp_var 52665 2026-05-29 23:54:37.548985 2026-05-30 04:19:00.666063
MPC_primarydb obscodes 2703 2026-05-27 23:09:26.958103 2026-05-30 04:19:00.786297
MPC_mpcsbndb obscodes 2703 2026-05-27 23:09:26.958103 2026-05-30 04:19:00.929553
SBN_to_AWS obscodes 2703 2026-05-27 23:09:26.958103 2026-05-30 04:19:01.016797
MPC_primarydb primary_objects 1584165 2026-05-30 04:01:09.022476 2026-05-30 04:19:01.111056
MPC_mpcsbndb primary_objects 1584165 2026-05-30 04:01:09.022476 2026-05-30 04:19:02.006225
SBN_to_AWS primary_objects 1584165 2026-05-30 04:01:09.022476 2026-05-30 04:19:02.189296
MPC_primarydb obs_alterations_corrections 0 2026-05-30 04:19:03.778629
MPC_mpcsbndb obs_alterations_corrections 0 2026-05-30 04:19:03.882188
SBN_to_AWS obs_alterations_corrections 0 2026-05-30 04:19:03.968404
MPC_primarydb obs_alterations_deletions 1690905 2026-05-30 03:53:06.868197 2026-05-30 04:19:04.058024
MPC_mpcsbndb obs_alterations_deletions 1690905 2026-05-30 03:53:06.868197 2026-05-30 04:19:04.719048
SBN_to_AWS obs_alterations_deletions 1690905 2026-05-30 03:53:06.868197 2026-05-30 04:19:04.862898
MPC_primarydb obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-05-30 04:19:05.220616
MPC_mpcsbndb obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-05-30 04:19:05.33894
SBN_to_AWS obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-05-30 04:19:05.426723
MPC_primarydb obs_alterations_unassociations 581056 2026-05-29 15:25:20.527246 2026-05-30 04:19:05.522757
MPC_mpcsbndb obs_alterations_unassociations 581056 2026-05-29 15:25:20.527246 2026-05-30 04:19:06.00401
SBN_to_AWS obs_alterations_unassociations 581056 2026-05-29 15:25:20.527246 2026-05-30 04:19:06.130948