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-09-20 22:50: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 5227 2026-06-03 09:27:00 2026-06-03 09:27:00
comet_orbits 12826 2026-09-18 14:21:15 2026-09-18 15:01:03
identifications 223187 2026-07-14 12:33:56 2026-07-14 12:33:56
isolated_tracklets 50790571 2026-09-20 18:28:25 2026-09-20 18:28:25
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 2026-06-03 02:57:19 2026-09-08 14:26:32
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 524469237 2026-09-20 22:38:19 2026-09-20 22:38:19
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1581101 2026-09-20 22:38:24 2026-09-20 22:38:24
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 151 2026-09-20 07:24:39.758952 2026-09-20 22:39:29.282444
neocp_events 339410 2026-09-20 22:43:37.938211 2026-09-20 22:43:37.938211
neocp_obs_archive 839491 2026-09-20 22:39:29.197315 2026-09-20 22:39:29.197315
neocp_obs 2224 2026-09-20 22:39:29.156233 2026-09-20 22:39:29.156233
neocp_prev_des 74234 2026-09-20 22:37:32.164859 2026-09-20 22:37:32.164859
neocp_var 310235 2026-09-20 22:39:29.370008 2026-09-20 22:39:29.370008
current_identifications 2096277 2026-09-20 22:36:42.67954 2026-09-20 22:37:48.032073
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1605773 2026-09-20 22:36:42.647571 2026-09-20 22:36:42.647571
obs_sbn 554757510 2025-06-22 04:41:07.466512-04 2026-09-20 18:52:49.89025-04
obs_alterations_deletions 3453691 2026-09-20 21:57:39.051077 2026-09-20 21:57:39.051077
obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-08-25 19:50:31.030107
obs_alterations_unassociations 605945 2026-09-20 22:10:08.189794 2026-09-20 22:10:08.189794
mpc_orbits 1571588 2026-09-13 20:35:56.670928 2026-09-20 22:54:32.020954
minor_planet_names 26688 2011-10-28 10:08:52 2026-09-08 18:26:32.060609
obscodes 2726 2026-09-18 23:14:07.818373 2026-09-18 23:14:07.818373
comet_names 4394 2026-09-18 13:50:23.180345 2026-09-18 13:50:23.180345
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 554754549 2026-09-20 20:59:35.649245 2026-09-20 21:00:02.047235
MPC_mpcsbndb obs_sbn 554754549 2026-09-20 20:59:35.649245 2026-09-20 21:00:20.326832
SBN_to_AWS obs_sbn 554754549 2026-09-20 21:00:40.671168 2026-09-20 21:01:00.432156
MPC_primarydb current_identifications 2096276 2026-09-20 17:24:15.859071 2026-09-20 21:12:41.337262
MPC_mpcsbndb current_identifications 2096276 2026-09-20 17:24:15.859071 2026-09-20 21:12:42.249013
SBN_to_AWS current_identifications 2096276 2026-09-20 17:24:15.859071 2026-09-20 21:12:42.416369
MPC_primarydb comet_names 4394 2026-09-18 13:50:23.180345 2026-09-20 21:12:43.206859
MPC_mpcsbndb comet_names 4394 2026-09-18 13:50:23.180345 2026-09-20 21:12:43.317747
SBN_to_AWS comet_names 4394 2026-09-18 13:50:23.180345 2026-09-20 21:12:43.409635
MPC_primarydb minor_planet_names 26688 2026-09-08 18:26:32.060609 2026-09-20 21:12:43.512101
MPC_mpcsbndb minor_planet_names 26688 2026-09-08 18:26:32.060609 2026-09-20 21:12:43.698621
SBN_to_AWS minor_planet_names 26688 2026-09-08 18:26:32.060609 2026-09-20 21:12:43.807738
MPC_primarydb mpc_orbits 1571587 2026-09-20 21:12:40.170456 2026-09-20 21:12:44.011865
MPC_mpcsbndb mpc_orbits 1571587 2026-09-20 21:12:40.170456 2026-09-20 21:12:45.97571
SBN_to_AWS mpc_orbits 1571587 2026-09-20 21:12:40.170456 2026-09-20 21:12:46.356884
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-09-20 21:12:50.479204
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-09-20 21:12:50.843705
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-09-20 21:12:50.984171
MPC_primarydb neocp_els 153 2026-09-20 21:08:16.142774 2026-09-20 21:12:51.282453
MPC_mpcsbndb neocp_els 153 2026-09-20 21:08:16.142774 2026-09-20 21:12:51.393032
SBN_to_AWS neocp_els 153 2026-09-20 21:08:16.142774 2026-09-20 21:12:51.483632
MPC_primarydb neocp_events 339379 2026-09-20 21:08:16.101824 2026-09-20 21:12:51.580992
MPC_mpcsbndb neocp_events 339379 2026-09-20 21:08:16.101824 2026-09-20 21:12:51.786589
SBN_to_AWS neocp_events 339379 2026-09-20 21:08:16.101824 2026-09-20 21:12:51.918058
MPC_primarydb neocp_obs 2218 2026-09-20 21:08:16.019492 2026-09-20 21:12:52.091288
MPC_mpcsbndb neocp_obs 2218 2026-09-20 21:08:16.019492 2026-09-20 21:12:52.201853
SBN_to_AWS neocp_obs 2218 2026-09-20 21:08:16.019492 2026-09-20 21:12:52.295141
MPC_primarydb neocp_obs_archive 839428 2026-09-20 21:08:16.060569 2026-09-20 21:12:52.406183
MPC_mpcsbndb neocp_obs_archive 839428 2026-09-20 21:08:16.060569 2026-09-20 21:12:52.711047
SBN_to_AWS neocp_obs_archive 839428 2026-09-20 21:08:16.060569 2026-09-20 21:12:52.861179
MPC_primarydb neocp_prev_des 74231 2026-09-20 17:25:03.434991 2026-09-20 21:12:53.116112
MPC_mpcsbndb neocp_prev_des 74231 2026-09-20 17:25:03.434991 2026-09-20 21:12:53.2619
SBN_to_AWS neocp_prev_des 74231 2026-09-20 17:25:03.434991 2026-09-20 21:12:53.368795
MPC_primarydb neocp_var 314038 2026-09-20 21:08:16.232468 2026-09-20 21:12:53.49454
MPC_mpcsbndb neocp_var 314038 2026-09-20 21:08:16.232468 2026-09-20 21:12:53.726527
SBN_to_AWS neocp_var 314038 2026-09-20 21:08:16.232468 2026-09-20 21:12:53.850919
MPC_primarydb obscodes 2726 2026-09-18 23:14:07.818373 2026-09-20 21:12:54.161819
MPC_mpcsbndb obscodes 2726 2026-09-18 23:14:07.818373 2026-09-20 21:12:54.289487
SBN_to_AWS obscodes 2726 2026-09-18 23:14:07.818373 2026-09-20 21:12:54.382714
MPC_primarydb primary_objects 1605772 2026-09-20 17:24:15.825117 2026-09-20 21:12:54.482026
MPC_mpcsbndb primary_objects 1605772 2026-09-20 17:24:15.825117 2026-09-20 21:12:55.057188
SBN_to_AWS primary_objects 1605772 2026-09-20 17:24:15.825117 2026-09-20 21:12:55.272518
MPC_primarydb obs_alterations_corrections 0 2026-09-20 21:12:56.925646
MPC_mpcsbndb obs_alterations_corrections 0 2026-09-20 21:12:57.0363
SBN_to_AWS obs_alterations_corrections 0 2026-09-20 21:12:57.126002
MPC_primarydb obs_alterations_deletions 3453688 2026-09-20 20:32:55.978453 2026-09-20 21:12:57.219145
MPC_mpcsbndb obs_alterations_deletions 3453688 2026-09-20 20:32:55.978453 2026-09-20 21:12:58.278142
SBN_to_AWS obs_alterations_deletions 3453688 2026-09-20 20:32:55.978453 2026-09-20 21:12:58.464983
MPC_primarydb obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-09-20 21:12:58.831743
MPC_mpcsbndb obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-09-20 21:12:58.952891
SBN_to_AWS obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-09-20 21:12:59.046276
MPC_primarydb obs_alterations_unassociations 605935 2026-09-20 21:01:06.549007 2026-09-20 21:12:59.14679
MPC_mpcsbndb obs_alterations_unassociations 605935 2026-09-20 21:01:06.549007 2026-09-20 21:12:59.460494
SBN_to_AWS obs_alterations_unassociations 605935 2026-09-20 21:01:06.549007 2026-09-20 21:12:59.5941