Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

25 Feb 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-03-11 18:40: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 5215 2026-03-06 22:06:00 2026-03-06 22:06:00
comet_orbits 12030 2021-10-19 05:20:25 2026-03-07 23:01:17
identifications 218003 2026-03-11 12:26:56 2026-03-11 12:26:56
isolated_tracklets 49825627 2026-03-11 18:38:49 2026-03-11 18:38:49
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 1333152 2026-03-05 21:16:52 2026-03-05 21:16:52
numbered_mps 887103 2026-03-05 21:21:22 2026-03-05 21:21:22
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 511993624 2026-03-11 18:00:19 2026-03-11 18:00:19
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1534687 2015-01-08 22:04:41 2026-03-11 18: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 67 2026-03-11 18:38:28.254448 2026-03-11 18:38:28.254448
neocp_events 314905 2026-03-11 18:38:28.369423 2026-03-11 18:38:28.369423
neocp_obs_archive 788594 2026-03-11 18:38:28.152802 2026-03-11 18:38:28.152802
neocp_obs 1269 2026-03-11 18:38:28.111962 2026-03-11 18:38:28.111962
neocp_prev_des 71405 2026-03-11 16:56:57.369341 2026-03-11 16:56:57.369341
neocp_var 125545 2026-03-11 18:38:28.200785 2026-03-11 18:38:28.200785
current_identifications 2047438 2026-03-11 18:04:10.417673 2026-03-11 18:04:42.375405
numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-02-27 03:49:38.898045
primary_objects 1560082 2026-03-11 18:04:10.387629 2026-03-11 18:04:10.387629
obs_sbn 531348396 2026-03-11 14:35:16.489294-04 2026-03-11 14:38:47.57682-04
obs_alterations_deletions 1494467 2026-03-11 17:15:24.505516 2026-03-11 17:15:24.505516
obs_alterations_redesignations 4515 2025-12-01 14:51:10.350811 2026-02-26 23:34:40.379845
obs_alterations_unassociations 563599 2026-03-11 18:38:45.602732 2026-03-11 18:38:45.602732
mpc_orbits 1517111 2021-02-04 01:17:49.015166 2026-03-11 18:19:53.802805
minor_planet_names 25992 2011-10-27 06:38:13 2026-01-16 00:37:34.652007
obscodes 2684 2026-03-11 15:22:01.984382 2026-03-11 15:22:01.984382
comet_names 4364 2026-02-25 01:23:59.404633 2026-02-25 01:23:59.404633
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 531347681 2026-03-11 17:59:53.732847 2026-03-11 18:00:02.321385
MPC_mpcsbndb obs_sbn 531347681 2026-03-11 18:00:13.279881 2026-03-11 18:00:19.073244
SBN_to_AWS obs_sbn 531347681 2026-03-11 18:00:13.279881 2026-03-11 18:00:44.595763
MPC_primarydb current_identifications 2047438 2026-03-11 18:04:42.375405 2026-03-11 18:10:24.439155
MPC_mpcsbndb current_identifications 2047438 2026-03-11 18:04:42.375405 2026-03-11 18:10:25.002346
SBN_to_AWS current_identifications 2047438 2026-03-11 18:04:42.375405 2026-03-11 18:10:25.224401
MPC_primarydb comet_names 4364 2026-02-25 01:23:59.404633 2026-03-11 18:10:26.702429
MPC_mpcsbndb comet_names 4364 2026-02-25 01:23:59.404633 2026-03-11 18:10:26.80436
SBN_to_AWS comet_names 4364 2026-02-25 01:23:59.404633 2026-03-11 18:10:26.886729
MPC_primarydb minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-03-11 18:10:26.983478
MPC_mpcsbndb minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-03-11 18:10:27.147348
SBN_to_AWS minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-03-11 18:10:27.244865
MPC_primarydb mpc_orbits 1517111 2026-03-11 18:04:58.009755 2026-03-11 18:10:27.379661
MPC_mpcsbndb mpc_orbits 1517111 2026-03-11 18:04:58.009755 2026-03-11 18:10:28.896954
SBN_to_AWS mpc_orbits 1517111 2026-03-11 18:04:58.009755 2026-03-11 18:10:29.194049
MPC_primarydb numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-11 18:10:33.422175
MPC_mpcsbndb numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-11 18:10:33.804125
SBN_to_AWS numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-11 18:10:33.93648
MPC_primarydb neocp_els 66 2026-03-11 18:02:29.591958 2026-03-11 18:10:34.16863
MPC_mpcsbndb neocp_els 66 2026-03-11 18:02:29.591958 2026-03-11 18:10:34.272844
SBN_to_AWS neocp_els 66 2026-03-11 18:02:29.591958 2026-03-11 18:10:34.35385
MPC_primarydb neocp_events 314904 2026-03-11 18:02:29.749775 2026-03-11 18:10:34.441798
MPC_mpcsbndb neocp_events 314904 2026-03-11 18:02:29.749775 2026-03-11 18:10:34.631851
SBN_to_AWS neocp_events 314904 2026-03-11 18:02:29.749775 2026-03-11 18:10:34.742727
MPC_primarydb neocp_obs 1267 2026-03-11 18:02:29.580701 2026-03-11 18:10:34.883842
MPC_mpcsbndb neocp_obs 1267 2026-03-11 18:02:29.580701 2026-03-11 18:10:34.987807
SBN_to_AWS neocp_obs 1267 2026-03-11 18:02:29.580701 2026-03-11 18:10:35.070095
MPC_primarydb neocp_obs_archive 788592 2026-03-11 18:02:29.589033 2026-03-11 18:10:35.163674
MPC_mpcsbndb neocp_obs_archive 788592 2026-03-11 18:02:29.589033 2026-03-11 18:10:35.423588
SBN_to_AWS neocp_obs_archive 788592 2026-03-11 18:02:29.589033 2026-03-11 18:10:35.552268
MPC_primarydb neocp_prev_des 71405 2026-03-11 16:56:57.369341 2026-03-11 18:10:35.763644
MPC_mpcsbndb neocp_prev_des 71405 2026-03-11 16:56:57.369341 2026-03-11 18:10:35.911409
SBN_to_AWS neocp_prev_des 71405 2026-03-11 16:56:57.369341 2026-03-11 18:10:36.009341
MPC_primarydb neocp_var 123545 2026-03-11 18:02:29.625578 2026-03-11 18:10:36.125546
MPC_mpcsbndb neocp_var 123545 2026-03-11 18:02:29.625578 2026-03-11 18:10:36.295225
SBN_to_AWS neocp_var 123545 2026-03-11 18:02:29.625578 2026-03-11 18:10:36.40616
MPC_primarydb obscodes 2684 2026-03-11 15:22:01.984382 2026-03-11 18:10:36.574508
MPC_mpcsbndb obscodes 2684 2026-03-11 15:22:01.984382 2026-03-11 18:10:36.690524
SBN_to_AWS obscodes 2684 2026-03-11 15:22:01.984382 2026-03-11 18:10:36.77372
MPC_primarydb primary_objects 1560082 2026-03-11 18:04:10.387629 2026-03-11 18:10:36.867263
MPC_mpcsbndb primary_objects 1560082 2026-03-11 18:04:10.387629 2026-03-11 18:10:37.317452
SBN_to_AWS primary_objects 1560082 2026-03-11 18:04:10.387629 2026-03-11 18:10:37.4738
MPC_primarydb obs_alterations_corrections 0 2026-03-11 18:10:39.065576
MPC_mpcsbndb obs_alterations_corrections 0 2026-03-11 18:10:39.169105
SBN_to_AWS obs_alterations_corrections 0 2026-03-11 18:10:39.250557
MPC_primarydb obs_alterations_deletions 1494467 2026-03-11 17:15:24.505516 2026-03-11 18:10:39.336809
MPC_mpcsbndb obs_alterations_deletions 1494467 2026-03-11 17:15:24.505516 2026-03-11 18:10:39.880614
SBN_to_AWS obs_alterations_deletions 1494467 2026-03-11 17:15:24.505516 2026-03-11 18:10:40.013573
MPC_primarydb obs_alterations_redesignations 4515 2026-02-26 23:34:40.379845 2026-03-11 18:10:40.250073
MPC_mpcsbndb obs_alterations_redesignations 4515 2026-02-26 23:34:40.379845 2026-03-11 18:10:40.361424
SBN_to_AWS obs_alterations_redesignations 4515 2026-02-26 23:34:40.379845 2026-03-11 18:10:40.444064
MPC_primarydb obs_alterations_unassociations 563589 2026-03-11 18:10:06.414999 2026-03-11 18:10:40.534172
MPC_mpcsbndb obs_alterations_unassociations 563589 2026-03-11 18:10:06.414999 2026-03-11 18:10:40.844706
SBN_to_AWS obs_alterations_unassociations 563589 2026-03-11 18:10:06.414999 2026-03-11 18:10:40.969453