a

Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

26 Jun 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-08-12 16:20: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 12785 2014-02-10 15:54:13 2026-08-07 20:01:03
identifications 223187 2026-07-14 12:33:56 2026-07-14 12:33:56
isolated_tracklets 50789875 2026-08-12 14:28:22 2026-08-12 14:28:22
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 2011-10-27 02:54:58 2026-08-06 11:46:35
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 524417069 2026-08-12 12:38:45 2026-08-12 12:38:45
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1571478 2025-10-22 15:40:41 2026-08-12 13:01:47
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 116 2026-08-11 15:53:13.711813 2026-08-12 15:44:27.191746
neocp_events 332115 2026-08-12 15:44:27.389492 2026-08-12 15:44:27.389492
neocp_obs_archive 826413 2026-08-12 15:42:02.259806 2026-08-12 15:42:02.259806
neocp_obs 1249 2026-08-12 15:42:02.22229 2026-08-12 15:42:02.22229
neocp_prev_des 73396 2026-08-12 15:43:32.730731 2026-08-12 15:43:32.730731
neocp_var 241783 2026-08-12 15:44:27.254571 2026-08-12 15:44:27.254571
current_identifications 2086174 2026-08-12 16:05:10.303977 2026-08-12 16:05:49.228905
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1596001 2026-08-12 16:05:10.259554 2026-08-12 16:05:10.259554
obs_sbn 545581173 2026-08-12 12:16:14.582239-04 2026-08-12 12:23:46.409029-04
obs_alterations_deletions 1946319 2026-08-11 23:05:22.239547 2026-08-11 23:05:22.239547
obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-06-25 20:30:09.644732
obs_alterations_unassociations 600121 2026-08-12 14:14:01.780589 2026-08-12 14:14:01.780589
mpc_orbits 1561571 2021-03-16 19:55:23.350474 2026-08-12 16:24:10.085472
minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-06 15:47:16.33429
obscodes 2716 2026-08-11 20:33:23.272047 2026-08-11 20:33:23.272047
comet_names 4389 2026-08-07 13:39:18.93276 2026-08-07 13:39:18.93276
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 545522861 2026-08-12 14:59:57.980181 2026-08-12 15:00:02.532743
MPC_mpcsbndb obs_sbn 545523072 2026-08-12 15:00:17.963053 2026-08-12 15:00:22.018832
SBN_to_AWS obs_sbn 545523622 2026-08-12 15:00:58.05183 2026-08-12 15:01:02.607436
MPC_primarydb current_identifications 2086167 2026-08-12 13:55:33.195085 2026-08-12 15:37:24.742007
MPC_mpcsbndb current_identifications 2086167 2026-08-12 13:55:33.195085 2026-08-12 15:37:26.605033
SBN_to_AWS current_identifications 2086167 2026-08-12 13:55:33.195085 2026-08-12 15:37:26.760628
MPC_primarydb comet_names 4389 2026-08-07 13:39:18.93276 2026-08-12 15:37:27.518259
MPC_mpcsbndb comet_names 4389 2026-08-07 13:39:18.93276 2026-08-12 15:37:27.613133
SBN_to_AWS comet_names 4389 2026-08-07 13:39:18.93276 2026-08-12 15:37:27.691934
MPC_primarydb minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-12 15:37:27.781448
MPC_mpcsbndb minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-12 15:37:27.921346
SBN_to_AWS minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-12 15:37:28.017553
MPC_primarydb mpc_orbits 1561564 2026-08-12 15:27:40.990515 2026-08-12 15:37:28.159674
MPC_mpcsbndb mpc_orbits 1561564 2026-08-12 15:27:40.990515 2026-08-12 15:37:29.935025
SBN_to_AWS mpc_orbits 1561564 2026-08-12 15:27:40.990515 2026-08-12 15:37:30.252804
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-12 15:37:31.616027
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-12 15:37:31.965555
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-12 15:37:32.09976
MPC_primarydb neocp_els 117 2026-08-12 14:43:53.676265 2026-08-12 15:37:32.395025
MPC_mpcsbndb neocp_els 117 2026-08-12 14:43:53.676265 2026-08-12 15:37:32.487719
SBN_to_AWS neocp_els 117 2026-08-12 14:43:53.676265 2026-08-12 15:37:32.565026
MPC_primarydb neocp_events 332112 2026-08-12 14:43:53.788487 2026-08-12 15:37:32.653595
MPC_mpcsbndb neocp_events 332112 2026-08-12 14:43:53.788487 2026-08-12 15:37:32.848935
SBN_to_AWS neocp_events 332112 2026-08-12 14:43:53.788487 2026-08-12 15:37:32.963495
MPC_primarydb neocp_obs 1250 2026-08-12 14:43:53.496654 2026-08-12 15:37:33.108785
MPC_mpcsbndb neocp_obs 1250 2026-08-12 14:43:53.496654 2026-08-12 15:37:33.202995
SBN_to_AWS neocp_obs 1250 2026-08-12 14:43:53.496654 2026-08-12 15:37:33.280923
MPC_primarydb neocp_obs_archive 826410 2026-08-12 14:43:53.538082 2026-08-12 15:37:33.367369
MPC_mpcsbndb neocp_obs_archive 826410 2026-08-12 14:43:53.538082 2026-08-12 15:37:33.623192
SBN_to_AWS neocp_obs_archive 826410 2026-08-12 14:43:53.538082 2026-08-12 15:37:33.785167
MPC_primarydb neocp_prev_des 73395 2026-08-12 13:14:46.814787 2026-08-12 15:37:34.02536
MPC_mpcsbndb neocp_prev_des 73395 2026-08-12 13:14:46.814787 2026-08-12 15:37:34.156557
SBN_to_AWS neocp_prev_des 73395 2026-08-12 13:14:46.814787 2026-08-12 15:37:34.250713
MPC_primarydb neocp_var 243794 2026-08-12 14:43:53.628952 2026-08-12 15:37:34.358757
MPC_mpcsbndb neocp_var 243794 2026-08-12 14:43:53.628952 2026-08-12 15:37:34.540609
SBN_to_AWS neocp_var 243794 2026-08-12 14:43:53.628952 2026-08-12 15:37:34.655348
MPC_primarydb obscodes 2716 2026-08-11 20:33:23.272047 2026-08-12 15:37:34.859077
MPC_mpcsbndb obscodes 2716 2026-08-11 20:33:23.272047 2026-08-12 15:37:34.967248
SBN_to_AWS obscodes 2716 2026-08-11 20:33:23.272047 2026-08-12 15:37:35.046938
MPC_primarydb primary_objects 1595994 2026-08-12 13:54:56.131898 2026-08-12 15:37:35.133533
MPC_mpcsbndb primary_objects 1595994 2026-08-12 13:54:56.131898 2026-08-12 15:37:35.63542
SBN_to_AWS primary_objects 1595994 2026-08-12 13:54:56.131898 2026-08-12 15:37:35.848557
MPC_primarydb obs_alterations_corrections 0 2026-08-12 15:37:37.481792
MPC_mpcsbndb obs_alterations_corrections 0 2026-08-12 15:37:37.574635
SBN_to_AWS obs_alterations_corrections 0 2026-08-12 15:37:37.651251
MPC_primarydb obs_alterations_deletions 1946319 2026-08-11 23:05:22.239547 2026-08-12 15:37:37.731176
MPC_mpcsbndb obs_alterations_deletions 1946319 2026-08-11 23:05:22.239547 2026-08-12 15:37:38.356311
SBN_to_AWS obs_alterations_deletions 1946319 2026-08-11 23:05:22.239547 2026-08-12 15:37:38.489908
MPC_primarydb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-12 15:37:38.805105
MPC_mpcsbndb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-12 15:37:38.902733
SBN_to_AWS obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-12 15:37:38.982559
MPC_primarydb obs_alterations_unassociations 600121 2026-08-12 14:14:01.780589 2026-08-12 15:37:39.069096
MPC_mpcsbndb obs_alterations_unassociations 600121 2026-08-12 14:14:01.780589 2026-08-12 15:37:39.359546
SBN_to_AWS obs_alterations_unassociations 600121 2026-08-12 14:14:01.780589 2026-08-12 15:37:39.480096