a

Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

22 Sep 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-23 21:10: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 12831 2025-01-03 03:38:23 2026-09-21 14:01:02
identifications 223187 2026-07-14 12:33:56 2026-07-14 12:33:56
isolated_tracklets 50790663 2026-09-22 11:18:18 2026-09-22 11:18:18
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:19 2026-09-08 14:26:32
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 524473623 2026-09-23 20:37:03 2026-09-23 20:37:03
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1582624 2026-09-23 20:10:22 2026-09-23 21: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 82 2026-09-22 08:44:31.593692 2026-09-23 20:10:52.050843
neocp_events 340022 2026-09-23 20:36:08.972782 2026-09-23 20:36:08.972782
neocp_obs_archive 840444 2026-09-23 20:10:52.002658 2026-09-23 20:10:52.002658
neocp_obs 1318 2026-09-23 20:10:51.96151 2026-09-23 20:10:51.96151
neocp_prev_des 74352 2026-09-23 20:36:08.848868 2026-09-23 20:36:08.848868
neocp_var 174119 2026-09-23 20:10:52.123864 2026-09-23 20:10:52.123864
current_identifications 2097694 2026-09-23 21:04:39.427895 2026-09-23 21:05:25.677497
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1607190 2026-09-23 21:04:39.366103 2026-09-23 21:04:39.366103
obs_sbn 554994790 2026-09-14 08:16:03.249795-04 2026-09-23 17:13:12.842209-04
obs_alterations_deletions 3453762 2026-09-23 11:50:50.537419 2026-09-23 11:50:50.537419
obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-08-25 19:50:31.030107
obs_alterations_unassociations 606147 2026-09-23 14:10:08.058293 2026-09-23 14:10:08.058293
mpc_orbits 1573007 2021-03-16 21:01:01.807268 2026-09-23 21:14:04.35386
minor_planet_names 26688 2011-10-28 10:08:52 2026-09-08 18:26:32.060609
obscodes 2727 2026-09-23 14:24:01.453193 2026-09-23 14:24:01.453193
comet_names 4394 2026-09-18 13:50:23.180345 2026-09-18 13:50:23.180345
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 554994724 2026-09-23 20:59:13.250265 2026-09-23 21:00:02.575303
MPC_mpcsbndb obs_sbn 554994724 2026-09-23 20:59:13.250265 2026-09-23 21:00:21.734282
SBN_to_AWS obs_sbn 554994724 2026-09-23 20:59:13.250265 2026-09-23 21:01:01.441668
MPC_primarydb current_identifications 2097694 2026-09-23 21:05:25.677497 2026-09-23 21:12:55.472377
MPC_mpcsbndb current_identifications 2097694 2026-09-23 21:05:25.677497 2026-09-23 21:12:56.297346
SBN_to_AWS current_identifications 2097694 2026-09-23 21:05:25.677497 2026-09-23 21:12:56.463986
MPC_primarydb comet_names 4394 2026-09-18 13:50:23.180345 2026-09-23 21:12:57.251176
MPC_mpcsbndb comet_names 4394 2026-09-18 13:50:23.180345 2026-09-23 21:12:57.370002
SBN_to_AWS comet_names 4394 2026-09-18 13:50:23.180345 2026-09-23 21:12:57.462424
MPC_primarydb minor_planet_names 26688 2026-09-08 18:26:32.060609 2026-09-23 21:12:57.564561
MPC_mpcsbndb minor_planet_names 26688 2026-09-08 18:26:32.060609 2026-09-23 21:12:57.748217
SBN_to_AWS minor_planet_names 26688 2026-09-08 18:26:32.060609 2026-09-23 21:12:57.856082
MPC_primarydb mpc_orbits 1573007 2026-09-23 21:12:49.844999 2026-09-23 21:12:58.060468
MPC_mpcsbndb mpc_orbits 1573007 2026-09-23 21:12:49.844999 2026-09-23 21:12:59.855934
SBN_to_AWS mpc_orbits 1573007 2026-09-23 21:12:49.844999 2026-09-23 21:13:00.233467
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-09-23 21:13:04.280028
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-09-23 21:13:04.657032
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-09-23 21:13:04.808909
MPC_primarydb neocp_els 81 2026-09-23 20:10:52.050843 2026-09-23 21:13:05.109769
MPC_mpcsbndb neocp_els 81 2026-09-23 20:10:52.050843 2026-09-23 21:13:05.225824
SBN_to_AWS neocp_els 81 2026-09-23 20:10:52.050843 2026-09-23 21:13:05.317264
MPC_primarydb neocp_events 340022 2026-09-23 20:36:08.972782 2026-09-23 21:13:05.41541
MPC_mpcsbndb neocp_events 340022 2026-09-23 20:36:08.972782 2026-09-23 21:13:05.619794
SBN_to_AWS neocp_events 340022 2026-09-23 20:36:08.972782 2026-09-23 21:13:05.751141
MPC_primarydb neocp_obs 1302 2026-09-23 20:10:51.96151 2026-09-23 21:13:05.916228
MPC_mpcsbndb neocp_obs 1302 2026-09-23 20:10:51.96151 2026-09-23 21:13:06.032582
SBN_to_AWS neocp_obs 1302 2026-09-23 20:10:51.96151 2026-09-23 21:13:06.125781
MPC_primarydb neocp_obs_archive 840444 2026-09-23 20:10:52.002658 2026-09-23 21:13:06.228197
MPC_mpcsbndb neocp_obs_archive 840444 2026-09-23 20:10:52.002658 2026-09-23 21:13:06.515245
SBN_to_AWS neocp_obs_archive 840444 2026-09-23 20:10:52.002658 2026-09-23 21:13:06.683876
MPC_primarydb neocp_prev_des 74352 2026-09-23 20:36:08.848868 2026-09-23 21:13:06.945622
MPC_mpcsbndb neocp_prev_des 74352 2026-09-23 20:36:08.848868 2026-09-23 21:13:07.100714
SBN_to_AWS neocp_prev_des 74352 2026-09-23 20:36:08.848868 2026-09-23 21:13:07.20809
MPC_primarydb neocp_var 172119 2026-09-23 20:10:52.123864 2026-09-23 21:13:07.334543
MPC_mpcsbndb neocp_var 172119 2026-09-23 20:10:52.123864 2026-09-23 21:13:07.526738
SBN_to_AWS neocp_var 172119 2026-09-23 20:10:52.123864 2026-09-23 21:13:07.650264
MPC_primarydb obscodes 2727 2026-09-23 14:24:01.453193 2026-09-23 21:13:07.840592
MPC_mpcsbndb obscodes 2727 2026-09-23 14:24:01.453193 2026-09-23 21:13:07.992291
SBN_to_AWS obscodes 2727 2026-09-23 14:24:01.453193 2026-09-23 21:13:08.08607
MPC_primarydb primary_objects 1607190 2026-09-23 21:04:39.366103 2026-09-23 21:13:08.186255
MPC_mpcsbndb primary_objects 1607190 2026-09-23 21:04:39.366103 2026-09-23 21:13:08.734441
SBN_to_AWS primary_objects 1607190 2026-09-23 21:04:39.366103 2026-09-23 21:13:08.957508
MPC_primarydb obs_alterations_corrections 0 2026-09-23 21:13:10.621775
MPC_mpcsbndb obs_alterations_corrections 0 2026-09-23 21:13:10.736435
SBN_to_AWS obs_alterations_corrections 0 2026-09-23 21:13:10.826499
MPC_primarydb obs_alterations_deletions 3453762 2026-09-23 11:50:50.537419 2026-09-23 21:13:10.935213
MPC_mpcsbndb obs_alterations_deletions 3453762 2026-09-23 11:50:50.537419 2026-09-23 21:13:12.023597
SBN_to_AWS obs_alterations_deletions 3453762 2026-09-23 11:50:50.537419 2026-09-23 21:13:12.219849
MPC_primarydb obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-09-23 21:13:12.593546
MPC_mpcsbndb obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-09-23 21:13:12.717064
SBN_to_AWS obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-09-23 21:13:12.810107
MPC_primarydb obs_alterations_unassociations 606147 2026-09-23 14:10:08.058293 2026-09-23 21:13:12.911054
MPC_mpcsbndb obs_alterations_unassociations 606147 2026-09-23 14:10:08.058293 2026-09-23 21:13:13.221528
SBN_to_AWS obs_alterations_unassociations 606147 2026-09-23 14:10:08.058293 2026-09-23 21:13:13.358501