a

Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

26 Jun 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-09-06 19: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 5227 2026-06-03 09:27:00 2026-06-03 09:27:00
comet_orbits 12821 2025-01-03 03:38:23 2026-09-04 16:01:02
identifications 223187 2026-07-14 12:33:56 2026-07-14 12:33:56
isolated_tracklets 50790151 2026-09-06 11:08:15 2026-09-06 11:08:15
mp_discoverers 1969147 2025-06-18 21:18:06 2025-06-18 21:18:06
numbered_comet_identifications 1295 2026-06-03 09:12:00 2026-06-03 09:12:00
numbered_identifications 1342746 2026-06-03 02:55:41 2026-06-03 02:55:41
numbered_mps 895910 2026-06-03 02:57:32 2026-08-17 14:54:31
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 524448842 2026-09-06 19:38:51 2026-09-06 19:38:51
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1577755 2026-09-06 19:39:01 2026-09-06 19:39:01
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 97 2026-09-06 07:34:29.240744 2026-09-06 19:45:34.633965
neocp_events 335440 2026-09-06 19:45:34.593125 2026-09-06 19:45:34.593125
neocp_obs_archive 831996 2026-09-06 19:45:34.551436 2026-09-06 19:45:34.551436
neocp_obs 1075 2026-09-06 19:45:34.510833 2026-09-06 19:45:34.510833
neocp_prev_des 73806 2026-09-06 19:37:59.351497 2026-09-06 19:37:59.351497
neocp_var 207299 2026-09-06 19:45:34.704572 2026-09-06 19:45:34.704572
current_identifications 2092980 2026-09-06 19:52:53.667998 2026-09-06 19:53:35.106961
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1602476 2026-09-06 19:52:53.638596 2026-09-06 19:52:53.638596
obs_sbn 552226510 2022-02-09 14:44:31.941781-05 2026-09-06 15:52:56.299388-04
obs_alterations_deletions 2971126 2026-09-06 17:48:57.268462 2026-09-06 17:48:57.268462
obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-08-25 19:50:31.030107
obs_alterations_unassociations 605192 2026-09-06 18:13:06.631099 2026-09-06 18:13:06.631099
mpc_orbits 1568265 2026-09-06 19:51:44.706358 2026-09-06 19:51:54.456134
minor_planet_names 26623 2024-08-15 18:31:11.706972 2026-08-17 18:54:31.231141
obscodes 2722 2019-05-25 00:11:29.955971 2026-09-05 17:21:54.242782
comet_names 4392 2026-08-25 17:00:02.297019 2026-08-25 17:00:02.297019
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 552226356 2026-09-06 18:59:15.87397 2026-09-06 19:00:02.12033
MPC_mpcsbndb obs_sbn 552226356 2026-09-06 18:59:15.87397 2026-09-06 19:00:14.667782
SBN_to_AWS obs_sbn 552226356 2026-09-06 19:00:21.143462 2026-09-06 19:00:38.564348
MPC_primarydb current_identifications 2092958 2026-09-06 19:06:39.354406 2026-09-06 19:08:16.934076
MPC_mpcsbndb current_identifications 2092958 2026-09-06 19:06:39.354406 2026-09-06 19:08:20.23821
SBN_to_AWS current_identifications 2092958 2026-09-06 19:06:39.354406 2026-09-06 19:08:20.402968
MPC_primarydb comet_names 4392 2026-08-25 17:00:02.297019 2026-09-06 19:08:21.18201
MPC_mpcsbndb comet_names 4392 2026-08-25 17:00:02.297019 2026-09-06 19:08:21.30409
SBN_to_AWS comet_names 4392 2026-08-25 17:00:02.297019 2026-09-06 19:08:21.398766
MPC_primarydb minor_planet_names 26623 2026-08-17 18:54:31.231141 2026-09-06 19:08:21.504275
MPC_mpcsbndb minor_planet_names 26623 2026-08-17 18:54:31.231141 2026-09-06 19:08:21.681402
SBN_to_AWS minor_planet_names 26623 2026-08-17 18:54:31.231141 2026-09-06 19:08:21.789758
MPC_primarydb mpc_orbits 1568244 2026-09-06 19:07:01.558924 2026-09-06 19:08:21.997312
MPC_mpcsbndb mpc_orbits 1568244 2026-09-06 19:07:01.558924 2026-09-06 19:08:23.719591
SBN_to_AWS mpc_orbits 1568244 2026-09-06 19:07:01.558924 2026-09-06 19:08:23.983898
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-09-06 19:08:26.380193
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-09-06 19:08:26.698
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-09-06 19:08:26.834247
MPC_primarydb neocp_els 98 2026-09-06 18:13:26.968236 2026-09-06 19:08:27.146673
MPC_mpcsbndb neocp_els 98 2026-09-06 18:13:26.968236 2026-09-06 19:08:27.266445
SBN_to_AWS neocp_els 98 2026-09-06 18:13:26.968236 2026-09-06 19:08:27.360208
MPC_primarydb neocp_events 335436 2026-09-06 18:27:44.412952 2026-09-06 19:08:27.461808
MPC_mpcsbndb neocp_events 335436 2026-09-06 18:27:44.412952 2026-09-06 19:08:27.668745
SBN_to_AWS neocp_events 335436 2026-09-06 18:27:44.412952 2026-09-06 19:08:27.78847
MPC_primarydb neocp_obs 1080 2026-09-06 18:13:26.841097 2026-09-06 19:08:27.954756
MPC_mpcsbndb neocp_obs 1080 2026-09-06 18:13:26.841097 2026-09-06 19:08:28.073258
SBN_to_AWS neocp_obs 1080 2026-09-06 18:13:26.841097 2026-09-06 19:08:28.16771
MPC_primarydb neocp_obs_archive 831989 2026-09-06 18:13:26.883176 2026-09-06 19:08:28.272586
MPC_mpcsbndb neocp_obs_archive 831989 2026-09-06 18:13:26.883176 2026-09-06 19:08:28.482732
SBN_to_AWS neocp_obs_archive 831989 2026-09-06 18:13:26.883176 2026-09-06 19:08:28.614358
MPC_primarydb neocp_prev_des 73805 2026-09-06 18:27:44.289764 2026-09-06 19:08:28.873669
MPC_mpcsbndb neocp_prev_des 73805 2026-09-06 18:27:44.289764 2026-09-06 19:08:29.024389
SBN_to_AWS neocp_prev_des 73805 2026-09-06 18:27:44.289764 2026-09-06 19:08:29.133737
MPC_primarydb neocp_var 209299 2026-09-06 18:13:27.0607 2026-09-06 19:08:29.263786
MPC_mpcsbndb neocp_var 209299 2026-09-06 18:13:27.0607 2026-09-06 19:08:29.455333
SBN_to_AWS neocp_var 209299 2026-09-06 18:13:27.0607 2026-09-06 19:08:29.577831
MPC_primarydb obscodes 2722 2026-09-05 17:21:54.242782 2026-09-06 19:08:29.760329
MPC_mpcsbndb obscodes 2722 2026-09-05 17:21:54.242782 2026-09-06 19:08:29.897357
SBN_to_AWS obscodes 2722 2026-09-05 17:21:54.242782 2026-09-06 19:08:29.9922
MPC_primarydb primary_objects 1602454 2026-09-06 19:05:57.187352 2026-09-06 19:08:30.094855
MPC_mpcsbndb primary_objects 1602454 2026-09-06 19:05:57.187352 2026-09-06 19:08:30.535724
SBN_to_AWS primary_objects 1602454 2026-09-06 19:05:57.187352 2026-09-06 19:08:30.708735
MPC_primarydb obs_alterations_corrections 0 2026-09-06 19:08:32.362082
MPC_mpcsbndb obs_alterations_corrections 0 2026-09-06 19:08:32.482693
SBN_to_AWS obs_alterations_corrections 0 2026-09-06 19:08:32.576363
MPC_primarydb obs_alterations_deletions 2971126 2026-09-06 17:48:57.268462 2026-09-06 19:08:32.673255
MPC_mpcsbndb obs_alterations_deletions 2971126 2026-09-06 17:48:57.268462 2026-09-06 19:08:33.316443
SBN_to_AWS obs_alterations_deletions 2971126 2026-09-06 17:48:57.268462 2026-09-06 19:08:33.470739
MPC_primarydb obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-09-06 19:08:33.869238
MPC_mpcsbndb obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-09-06 19:08:33.992124
SBN_to_AWS obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-09-06 19:08:34.086929
MPC_primarydb obs_alterations_unassociations 605192 2026-09-06 18:13:06.631099 2026-09-06 19:08:34.190862
MPC_mpcsbndb obs_alterations_unassociations 605192 2026-09-06 18:13:06.631099 2026-09-06 19:08:34.477148
SBN_to_AWS obs_alterations_unassociations 605192 2026-09-06 18:13:06.631099 2026-09-06 19:08:34.606921