Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

23 Jan 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-02-09 02:30: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 5214 2025-10-23 17:12:59 2025-10-23 17:12:59
comet_orbits 11219 2026-01-29 19:18:18 2026-01-29 20:01:02
identifications 211641 2026-01-14 12:15:20 2026-01-14 12:15:20
isolated_tracklets 49753166 2026-02-08 17:08:40 2026-02-08 17:08:40
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 2011-10-28 09:36:11 2026-01-12 14:34: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 502489963 2026-02-08 12:25:14 2026-02-08 12:25:14
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1528592 2024-10-01 12:53:10 2026-02-08 13:01:41
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 57 2026-02-03 15:31:03.146684 2026-02-09 02:21:18.391763
neocp_events 310314 2026-02-09 02:19:20.340259 2026-02-09 02:19:20.340259
neocp_obs_archive 777208 2026-02-09 02:19:20.071666 2026-02-09 02:19:20.071666
neocp_obs 1084 2026-02-09 02:19:20.030717 2026-02-09 02:19:20.030717
neocp_prev_des 70896 2026-02-08 17:36:59.255015 2026-02-08 17:36:59.255015
neocp_var 101952 2026-02-09 02:19:20.2042 2026-02-09 02:19:20.2042
current_identifications 2038781 2025-02-26 06:46:08.661596 2026-02-08 11:15:55.244074
numbered_identifications 875979 2025-10-20 21:02:31.305341 2025-10-20 21:02:31.305341
primary_objects 1554515 2026-02-08 07:29:05.121243 2026-02-08 07:29:05.121243
obs_sbn 527456980 2024-03-14 09:01:34.378056-04 2026-02-08 21:33:21.164915-05
obs_alterations_deletions 1472567 2026-02-08 10:23:04.504238 2026-02-08 10:23:04.504238
obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-01-03 19:19:15.911342
obs_alterations_unassociations 535751 2026-02-08 22:10:07.487422 2026-02-08 22:10:07.487422
mpc_orbits 1510848 2026-02-06 11:22:10.73543 2026-02-09 02:33:32.265509
minor_planet_names 25992 2011-10-27 06:38:13 2026-01-16 00:37:34.652007
obscodes 2676 2026-02-04 14:56:08.830913 2026-02-04 14:56:08.830913
comet_names 4295 2023-08-15 14:55:17.305679 2026-02-05 00:12:51.9462
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 527456970 2026-02-09 01:59:51.151641 2026-02-09 02:00:02.659081
MPC_mpcsbndb obs_sbn 527456970 2026-02-09 01:59:51.151641 2026-02-09 02:00:15.282148
SBN_to_AWS obs_sbn 527456970 2026-02-09 01:59:51.151641 2026-02-09 02:00:38.822803
MPC_primarydb current_identifications 2038781 2026-02-08 11:15:55.244074 2026-02-09 02:01:26.1841
MPC_mpcsbndb current_identifications 2038781 2026-02-08 11:15:55.244074 2026-02-09 02:01:26.657874
SBN_to_AWS current_identifications 2038781 2026-02-08 11:15:55.244074 2026-02-09 02:01:26.883232
MPC_primarydb comet_names 4288 2026-02-05 00:12:51.9462 2026-02-09 02:01:27.124197
MPC_mpcsbndb comet_names 4288 2026-02-05 00:12:51.9462 2026-02-09 02:01:27.227711
SBN_to_AWS comet_names 4288 2026-02-05 00:12:51.9462 2026-02-09 02:01:27.317401
MPC_primarydb minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-02-09 02:01:27.4111
MPC_mpcsbndb minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-02-09 02:01:27.552473
SBN_to_AWS minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-02-09 02:01:27.65264
MPC_primarydb mpc_orbits 1510848 2026-02-09 02:01:14.610299 2026-02-09 02:01:27.750382
MPC_mpcsbndb mpc_orbits 1510848 2026-02-09 02:01:14.610299 2026-02-09 02:01:29.25345
SBN_to_AWS mpc_orbits 1510848 2026-02-09 02:01:14.610299 2026-02-09 02:01:29.532963
MPC_primarydb numbered_identifications 875979 2025-10-20 21:02:31.305341 2026-02-09 02:01:29.828481
MPC_mpcsbndb numbered_identifications 875979 2025-10-20 21:02:31.305341 2026-02-09 02:01:30.108808
SBN_to_AWS numbered_identifications 875979 2025-10-20 21:02:31.305341 2026-02-09 02:01:30.243662
MPC_primarydb neocp_els 57 2026-02-09 01:57:26.835404 2026-02-09 02:01:30.386403
MPC_mpcsbndb neocp_els 57 2026-02-09 01:57:26.835404 2026-02-09 02:01:30.487029
SBN_to_AWS neocp_els 57 2026-02-09 01:57:26.835404 2026-02-09 02:01:30.57524
MPC_primarydb neocp_events 310312 2026-02-09 01:57:27.061487 2026-02-09 02:01:30.666511
MPC_mpcsbndb neocp_events 310312 2026-02-09 01:57:27.061487 2026-02-09 02:01:30.838948
SBN_to_AWS neocp_events 310312 2026-02-09 01:57:27.061487 2026-02-09 02:01:30.958997
MPC_primarydb neocp_obs 1078 2026-02-09 01:57:26.753135 2026-02-09 02:01:31.073273
MPC_mpcsbndb neocp_obs 1078 2026-02-09 01:57:26.753135 2026-02-09 02:01:31.172611
SBN_to_AWS neocp_obs 1078 2026-02-09 01:57:26.753135 2026-02-09 02:01:31.261055
MPC_primarydb neocp_obs_archive 777202 2026-02-09 01:57:26.794027 2026-02-09 02:01:31.354471
MPC_mpcsbndb neocp_obs_archive 777202 2026-02-09 01:57:26.794027 2026-02-09 02:01:31.554101
SBN_to_AWS neocp_obs_archive 777202 2026-02-09 01:57:26.794027 2026-02-09 02:01:31.690539
MPC_primarydb neocp_prev_des 70896 2026-02-08 17:36:59.255015 2026-02-09 02:01:31.830089
MPC_mpcsbndb neocp_prev_des 70896 2026-02-08 17:36:59.255015 2026-02-09 02:01:31.961028
SBN_to_AWS neocp_prev_des 70896 2026-02-08 17:36:59.255015 2026-02-09 02:01:32.063007
MPC_primarydb neocp_var 101895 2026-02-09 01:57:26.925932 2026-02-09 02:01:32.161485
MPC_mpcsbndb neocp_var 101895 2026-02-09 01:57:26.925932 2026-02-09 02:01:32.320467
SBN_to_AWS neocp_var 101895 2026-02-09 01:57:26.925932 2026-02-09 02:01:32.439331
MPC_primarydb obscodes 2676 2026-02-04 14:56:08.830913 2026-02-09 02:01:32.541262
MPC_mpcsbndb obscodes 2676 2026-02-04 14:56:08.830913 2026-02-09 02:01:32.654711
SBN_to_AWS obscodes 2676 2026-02-04 14:56:08.830913 2026-02-09 02:01:32.743078
MPC_primarydb primary_objects 1554515 2026-02-08 07:29:05.121243 2026-02-09 02:01:32.834863
MPC_mpcsbndb primary_objects 1554515 2026-02-08 07:29:05.121243 2026-02-09 02:01:33.233083
SBN_to_AWS primary_objects 1554515 2026-02-08 07:29:05.121243 2026-02-09 02:01:33.391597
MPC_primarydb obs_alterations_corrections 0 2026-02-09 02:01:33.578872
MPC_mpcsbndb obs_alterations_corrections 0 2026-02-09 02:01:33.681347
SBN_to_AWS obs_alterations_corrections 0 2026-02-09 02:01:33.769258
MPC_primarydb obs_alterations_deletions 1472567 2026-02-08 10:23:04.504238 2026-02-09 02:01:33.860467
MPC_mpcsbndb obs_alterations_deletions 1472567 2026-02-08 10:23:04.504238 2026-02-09 02:01:34.256501
SBN_to_AWS obs_alterations_deletions 1472567 2026-02-08 10:23:04.504238 2026-02-09 02:01:34.394178
MPC_primarydb obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-02-09 02:01:34.545257
MPC_mpcsbndb obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-02-09 02:01:34.65108
SBN_to_AWS obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-02-09 02:01:34.740172
MPC_primarydb obs_alterations_unassociations 535751 2026-02-08 22:10:07.487422 2026-02-09 02:01:34.831738
MPC_mpcsbndb obs_alterations_unassociations 535751 2026-02-08 22:10:07.487422 2026-02-09 02:01:35.070118
SBN_to_AWS obs_alterations_unassociations 535751 2026-02-08 22:10:07.487422 2026-02-09 02:01:35.197034