Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

18 Nov 2025

  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

2025-11-29 18: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 5214 2025-10-23 17:12:59 2025-10-23 17:12:59
comet_orbits 11198 2025-02-07 23:25:28 2025-11-26 00:01:10
identifications 210979 2025-11-29 12:20:01 2025-11-29 12:20:01
isolated_tracklets 49553701 2025-11-29 17:57:22 2025-11-29 17:57:22
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 1319125 2025-10-22 17:46:28 2025-10-22 17:46:28
numbered_mps 875150 2025-10-23 01:12:58 2025-11-19 17:03:38
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 502390988 2025-11-29 16:33:46 2025-11-29 16:33:46
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1495993 2025-11-29 16:27:58 2025-11-29 17: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 154 2025-11-29 06:58:12.36255 2025-11-29 18:03:31.310428
neocp_events 299328 2025-11-29 18:03:31.540633 2025-11-29 18:03:31.540633
neocp_obs_archive 753382 2025-11-29 18:03:31.267096 2025-11-29 18:03:31.267096
neocp_obs 1499 2025-11-29 18:03:31.225513 2025-11-29 18:03:31.225513
neocp_prev_des 69454 2025-11-29 17:07:23.939728 2025-11-29 17:07:23.939728
neocp_var 297410 2025-11-29 18:03:31.402052 2025-11-29 18:03:31.402052
current_identifications 2006089 2025-11-29 17:55:33.979975 2025-11-29 17:56:07.306086
numbered_identifications 875979 2025-10-20 21:02:31.305341 2025-10-20 21:02:31.305341
primary_objects 1522130 2025-11-29 17:55:33.921504 2025-11-29 17:55:33.921504
obs_sbn 514069930 2023-05-15 08:03:04.524047-04 2025-11-29 13:00:50.167698-05
obs_alterations_deletions 1387344 2025-11-29 13:28:10.333627 2025-11-29 13:28:10.333627
obs_alterations_redesignations 4426 2025-11-23 14:47:23.199793 2025-11-23 14:47:23.199793
obs_alterations_unassociations 526275 2025-11-29 16:34:38.913726 2025-11-29 16:34:38.913726
mpc_orbits 1478021 2025-11-29 09:36:56.421219 2025-11-29 18:01:07.26642
minor_planet_names 25881 2015-06-03 22:57:34 2025-11-19 22:03:16.504632
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 514065229 2025-11-29 16:58:19.554382 2025-11-29 17:00:02.90175
MPC_mpcsbndb obs_sbn 514065229 2025-11-29 16:58:19.554382 2025-11-29 17:00:19.362236
SBN_to_AWS obs_sbn 514065229 2025-11-29 16:58:19.554382 2025-11-29 17:01:03.67376
MPC_primarydb current_identifications 2006084 2025-11-29 16:54:08.169776 2025-11-29 17:10:30.201385
MPC_mpcsbndb current_identifications 2006084 2025-11-29 16:54:08.169776 2025-11-29 17:10:31.221428
SBN_to_AWS current_identifications 2006084 2025-11-29 16:54:08.169776 2025-11-29 17:10:31.507834
MPC_primarydb minor_planet_names 25881 2025-11-19 22:03:16.504632 2025-11-29 17:10:31.956839
MPC_mpcsbndb minor_planet_names 25881 2025-11-19 22:03:16.504632 2025-11-29 17:10:32.118044
SBN_to_AWS minor_planet_names 25881 2025-11-19 22:03:16.504632 2025-11-29 17:10:32.217632
MPC_primarydb mpc_orbits 1478016 2025-11-29 17:10:31.42871 2025-11-29 17:10:32.324329
MPC_mpcsbndb mpc_orbits 1478016 2025-11-29 17:10:34.869838 2025-11-29 17:10:35.892536
SBN_to_AWS mpc_orbits 1478016 2025-11-29 17:10:34.445928 2025-11-29 17:10:36.293251
MPC_primarydb numbered_identifications 875979 2025-10-20 21:02:31.305341 2025-11-29 17:10:39.295213
MPC_mpcsbndb numbered_identifications 875979 2025-10-20 21:02:31.305341 2025-11-29 17:10:39.702654
SBN_to_AWS numbered_identifications 875979 2025-10-20 21:02:31.305341 2025-11-29 17:10:39.847142
MPC_primarydb neocp_els 151 2025-11-29 17:02:27.298295 2025-11-29 17:10:40.010658
MPC_mpcsbndb neocp_els 151 2025-11-29 17:02:27.298295 2025-11-29 17:10:40.117061
SBN_to_AWS neocp_els 151 2025-11-29 17:02:27.298295 2025-11-29 17:10:40.203817
MPC_primarydb neocp_events 299317 2025-11-29 17:07:24.030125 2025-11-29 17:10:40.297026
MPC_mpcsbndb neocp_events 299317 2025-11-29 17:07:24.030125 2025-11-29 17:10:40.660335
SBN_to_AWS neocp_events 299317 2025-11-29 17:07:24.030125 2025-11-29 17:10:40.782107
MPC_primarydb neocp_obs 1468 2025-11-29 17:02:27.216119 2025-11-29 17:10:40.903032
MPC_mpcsbndb neocp_obs 1468 2025-11-29 17:02:27.216119 2025-11-29 17:10:41.010246
SBN_to_AWS neocp_obs 1468 2025-11-29 17:02:27.216119 2025-11-29 17:10:41.099446
MPC_primarydb neocp_obs_archive 753351 2025-11-29 17:02:27.257226 2025-11-29 17:10:41.205976
MPC_mpcsbndb neocp_obs_archive 753351 2025-11-29 17:02:27.257226 2025-11-29 17:10:41.480822
SBN_to_AWS neocp_obs_archive 753351 2025-11-29 17:02:27.257226 2025-11-29 17:10:41.629752
MPC_primarydb neocp_prev_des 69454 2025-11-29 17:07:23.939728 2025-11-29 17:10:41.78693
MPC_mpcsbndb neocp_prev_des 69454 2025-11-29 17:07:23.939728 2025-11-29 17:10:41.993716
SBN_to_AWS neocp_prev_des 69454 2025-11-29 17:07:23.939728 2025-11-29 17:10:42.094215
MPC_primarydb neocp_var 291410 2025-11-29 17:02:27.431055 2025-11-29 17:10:42.197887
MPC_mpcsbndb neocp_var 291410 2025-11-29 17:02:27.431055 2025-11-29 17:10:42.396082
SBN_to_AWS neocp_var 291410 2025-11-29 17:02:27.431055 2025-11-29 17:10:42.536596
MPC_primarydb obscodes 2662 2025-11-26 17:50:15.357439 2025-11-29 17:10:42.766501
MPC_mpcsbndb obscodes 2662 2025-11-26 17:50:15.357439 2025-11-29 17:10:42.890352
SBN_to_AWS obscodes 2662 2025-11-26 17:50:15.357439 2025-11-29 17:10:42.978708
MPC_primarydb primary_objects 1522125 2025-11-29 16:54:08.147022 2025-11-29 17:10:43.071641
MPC_mpcsbndb primary_objects 1522125 2025-11-29 16:54:08.147022 2025-11-29 17:10:43.782463
SBN_to_AWS primary_objects 1522125 2025-11-29 16:54:08.147022 2025-11-29 17:10:44.007221
MPC_primarydb obs_alterations_corrections 0 2025-11-29 17:10:44.645285
MPC_mpcsbndb obs_alterations_corrections 0 2025-11-29 17:10:44.760542
SBN_to_AWS obs_alterations_corrections 0 2025-11-29 17:10:44.846707
MPC_primarydb obs_alterations_deletions 1387344 2025-11-29 13:28:10.333627 2025-11-29 17:10:44.93615
MPC_mpcsbndb obs_alterations_deletions 1387344 2025-11-29 13:28:10.333627 2025-11-29 17:10:45.923547
SBN_to_AWS obs_alterations_deletions 1387344 2025-11-29 13:28:10.333627 2025-11-29 17:10:46.057966
MPC_primarydb obs_alterations_redesignations 4426 2025-11-23 14:47:23.199793 2025-11-29 17:10:46.226179
MPC_mpcsbndb obs_alterations_redesignations 4426 2025-11-23 14:47:23.199793 2025-11-29 17:10:46.34181
SBN_to_AWS obs_alterations_redesignations 4426 2025-11-23 14:47:23.199793 2025-11-29 17:10:46.428833