Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

10 Sep 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-10-01 21: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 5213 2025-08-13 22:56:38 2025-08-13 22:56:38
comet_orbits 10675 2014-02-10 15:54:12 2025-09-30 19:01:02
identifications 208447 2025-10-01 13:00:23 2025-10-01 13:00:23
isolated_tracklets 49209819 2025-10-01 21:38:07 2025-10-01 21:38:07
mp_discoverers 1969147 2025-06-18 21:18:06 2025-06-18 21:18:06
numbered_comet_identifications 1098 2025-09-08 16:50:25 2025-09-08 16:50:25
numbered_identifications 1287478 2025-09-08 13:59:53 2025-09-08 13:59:53
numbered_mps 847427 2011-10-27 01:46:47 2025-09-29 16:57:11
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 492644331 2025-10-01 21:32:05 2025-10-01 21:32:05
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1481699 2025-10-01 21:32:08 2025-10-01 21:32:08
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 102 2025-10-01 06:00:51.529011 2025-10-01 21:48:20.111073
neocp_events 290502 2025-10-01 21:48:20.355056 2025-10-01 21:48:20.355056
neocp_obs_archive 732870 2025-10-01 21:48:20.06975 2025-10-01 21:48:20.06975
neocp_obs 1299 2025-10-01 21:48:20.028963 2025-10-01 21:48:20.028963
neocp_prev_des 68303 2025-10-01 21:41:48.813539 2025-10-01 21:41:48.813539
neocp_var 194195 2025-10-01 21:48:20.201893 2025-10-01 21:48:20.201893
current_identifications 1991896 2025-10-01 21:30:48.685894 2025-10-01 21:31:45.486651
numbered_identifications 848253 2025-09-18 20:26:39.638099 2025-09-18 20:26:39.638099
primary_objects 1509167 2025-10-01 21:30:48.6265 2025-10-01 21:30:48.6265
obs_sbn 503330110 2025-09-30 14:31:18.070659-04 2025-10-01 17:47:29.307539-04
obs_alterations_deletions 1376865 2025-10-01 15:39:10.08145 2025-10-01 15:39:10.08145
obs_alterations_redesignations 4360 2025-09-26 14:20:47.258045 2025-09-26 14:20:47.258045
obs_alterations_unassociations 467630 2025-10-01 17:55:57.955312 2025-10-01 17:55:57.955312
mpc_orbits 1463454 2021-02-03 23:34:19.930262 2025-10-01 21:47:29.307539
minor_planet_names 25808 2025-09-08 15:38:40.078114 2025-09-29 20:57:11.055096
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 503329857 2025-10-01 20:58:08.974689 2025-10-01 21:00:02.8135
MPC_mpcsbndb obs_sbn 503329888 2025-10-01 21:01:23.352122 2025-10-01 21:01:47.019763
SBN_to_AWS obs_sbn 503329891 2025-10-01 21:02:00.25 2025-10-01 21:02:05.756569
MPC_primarydb current_identifications 1991892 2025-10-01 20:38:57.663634 2025-10-01 21:14:47.147394
MPC_mpcsbndb current_identifications 1991892 2025-10-01 20:38:57.663634 2025-10-01 21:14:47.920411
SBN_to_AWS current_identifications 1991892 2025-10-01 20:38:57.663634 2025-10-01 21:14:48.156014
MPC_primarydb minor_planet_names 25808 2025-09-29 20:57:11.055096 2025-10-01 21:14:48.510606
MPC_mpcsbndb minor_planet_names 25808 2025-09-29 20:57:11.055096 2025-10-01 21:14:48.643778
SBN_to_AWS minor_planet_names 25808 2025-09-29 20:57:11.055096 2025-10-01 21:14:48.746041
MPC_primarydb mpc_orbits 1463450 2025-10-01 21:13:44.724086 2025-10-01 21:14:48.846876
MPC_mpcsbndb mpc_orbits 1463450 2025-10-01 21:13:44.724086 2025-10-01 21:14:49.622547
SBN_to_AWS mpc_orbits 1463450 2025-10-01 21:13:44.724086 2025-10-01 21:14:49.94206
MPC_primarydb numbered_identifications 848253 2025-09-18 20:26:39.638099 2025-10-01 21:14:52.382297
MPC_mpcsbndb numbered_identifications 848253 2025-09-18 20:26:39.638099 2025-10-01 21:14:52.700315
SBN_to_AWS numbered_identifications 848253 2025-09-18 20:26:39.638099 2025-10-01 21:14:52.828792
MPC_primarydb neocp_els 106 2025-10-01 21:12:47.08745 2025-10-01 21:14:52.973736
MPC_mpcsbndb neocp_els 106 2025-10-01 21:12:47.08745 2025-10-01 21:14:53.077796
SBN_to_AWS neocp_els 106 2025-10-01 21:12:47.08745 2025-10-01 21:14:53.161658
MPC_primarydb neocp_events 290483 2025-10-01 21:12:47.178913 2025-10-01 21:14:53.252568
MPC_mpcsbndb neocp_events 290483 2025-10-01 21:12:47.178913 2025-10-01 21:14:53.606654
SBN_to_AWS neocp_events 290483 2025-10-01 21:12:47.178913 2025-10-01 21:14:53.72013
MPC_primarydb neocp_obs 1406 2025-10-01 21:12:47.006152 2025-10-01 21:14:53.836285
MPC_mpcsbndb neocp_obs 1406 2025-10-01 21:12:47.006152 2025-10-01 21:14:53.93932
SBN_to_AWS neocp_obs 1406 2025-10-01 21:12:47.006152 2025-10-01 21:14:54.023736
MPC_primarydb neocp_obs_archive 732825 2025-10-01 21:12:47.034487 2025-10-01 21:14:54.11851
MPC_mpcsbndb neocp_obs_archive 732825 2025-10-01 21:12:47.034487 2025-10-01 21:14:54.379825
SBN_to_AWS neocp_obs_archive 732825 2025-10-01 21:12:47.034487 2025-10-01 21:14:54.50571
MPC_primarydb neocp_prev_des 68297 2025-10-01 19:17:02.31861 2025-10-01 21:14:54.645771
MPC_mpcsbndb neocp_prev_des 68297 2025-10-01 19:17:02.31861 2025-10-01 21:14:54.7884
SBN_to_AWS neocp_prev_des 68297 2025-10-01 19:17:02.31861 2025-10-01 21:14:54.887293
MPC_primarydb neocp_var 203655 2025-10-01 21:12:47.045571 2025-10-01 21:14:54.990222
MPC_mpcsbndb neocp_var 203655 2025-10-01 21:12:47.045571 2025-10-01 21:14:55.152212
SBN_to_AWS neocp_var 203655 2025-10-01 21:12:47.045571 2025-10-01 21:14:55.277615
MPC_primarydb obscodes 2649 2025-09-30 19:50:21.069372 2025-10-01 21:14:55.455046
MPC_mpcsbndb obscodes 2649 2025-09-30 19:50:21.069372 2025-10-01 21:14:55.605235
SBN_to_AWS obscodes 2649 2025-09-30 19:50:21.069372 2025-10-01 21:14:55.689964
MPC_primarydb primary_objects 1509163 2025-10-01 20:38:57.615469 2025-10-01 21:14:55.781465
MPC_mpcsbndb primary_objects 1509163 2025-10-01 20:38:57.615469 2025-10-01 21:14:56.704833
SBN_to_AWS primary_objects 1509163 2025-10-01 20:38:57.615469 2025-10-01 21:14:56.86065
MPC_primarydb obs_alterations_corrections 0 2025-10-01 21:14:57.495052
MPC_mpcsbndb obs_alterations_corrections 0 2025-10-01 21:14:57.600746
SBN_to_AWS obs_alterations_corrections 0 2025-10-01 21:14:57.684177
MPC_primarydb obs_alterations_deletions 1376865 2025-10-01 15:39:10.08145 2025-10-01 21:14:57.770982
MPC_mpcsbndb obs_alterations_deletions 1376865 2025-10-01 15:39:10.08145 2025-10-01 21:14:59.134167
SBN_to_AWS obs_alterations_deletions 1376865 2025-10-01 15:39:10.08145 2025-10-01 21:14:59.262019
MPC_primarydb obs_alterations_redesignations 4360 2025-09-26 14:20:47.258045 2025-10-01 21:14:59.411536
MPC_mpcsbndb obs_alterations_redesignations 4360 2025-09-26 14:20:47.258045 2025-10-01 21:14:59.52684
SBN_to_AWS obs_alterations_redesignations 4360 2025-09-26 14:20:47.258045 2025-10-01 21:14:59.611865