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-14 10: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 5227 2026-06-03 09:27:00 2026-06-03 09:27:00
comet_orbits 12823 2026-09-08 18:36:22 2026-09-08 19:01:02
identifications 223187 2026-07-14 12:33:56 2026-07-14 12:33:56
isolated_tracklets 50790411 2026-09-14 10:38:14 2026-09-14 10:38:14
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 524460722 2026-09-14 10:08:49 2026-09-14 10:08:49
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1579035 2026-09-14 10:08:53 2026-09-14 10:08:53
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 140 2026-09-14 10:36:06.768359 2026-09-14 10:36:06.768359
neocp_events 337368 2026-09-14 10:36:06.846647 2026-09-14 10:36:06.846647
neocp_obs_archive 835500 2026-09-14 10:36:06.632874 2026-09-14 10:36:06.632874
neocp_obs 1214 2026-09-14 10:36:06.624509 2026-09-14 10:36:06.624509
neocp_prev_des 74012 2026-09-14 10:07:44.335588 2026-09-14 10:07:44.335588
neocp_var 293822 2026-09-14 10:36:06.723234 2026-09-14 10:36:06.723234
current_identifications 2094550 2026-09-14 10:06:55.660657 2026-09-14 10:08:13.777693
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1604046 2026-09-14 10:06:55.636147 2026-09-14 10:06:55.636147
obs_sbn 553773104 2026-09-14 06:42:49.3319-04 2026-09-14 06:43:09.13163-04
obs_alterations_deletions 3453540 2026-09-13 19:24:53.050858 2026-09-13 19:24:53.050858
obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-08-25 19:50:31.030107
obs_alterations_unassociations 605508 2026-09-14 10:10:08.888725 2026-09-14 10:10:08.888725
mpc_orbits 1569849 2021-02-04 01:11:06.856285 2026-09-14 10:44:08.000148
minor_planet_names 26688 2011-10-28 10:08:52 2026-09-08 18:26:32.060609
obscodes 2722 2024-04-14 12:55:11.714538 2026-09-09 14:46:23.938076
comet_names 4393 2026-09-08 18:32:55.000779 2026-09-08 18:32:55.000779
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 553771550 2026-09-14 09:59:14.714155 2026-09-14 10:00:02.16078
MPC_mpcsbndb obs_sbn 553771550 2026-09-14 10:00:11.108501 2026-09-14 10:00:22.218813
SBN_to_AWS obs_sbn 553771550 2026-09-14 10:00:11.108501 2026-09-14 10:00:46.210338
MPC_primarydb current_identifications 2094550 2026-09-14 10:08:13.777693 2026-09-14 10:11:59.112858
MPC_mpcsbndb current_identifications 2094550 2026-09-14 10:08:13.777693 2026-09-14 10:12:00.076052
SBN_to_AWS current_identifications 2094550 2026-09-14 10:08:13.777693 2026-09-14 10:12:00.232103
MPC_primarydb comet_names 4393 2026-09-08 18:32:55.000779 2026-09-14 10:12:01.015274
MPC_mpcsbndb comet_names 4393 2026-09-08 18:32:55.000779 2026-09-14 10:12:01.131981
SBN_to_AWS comet_names 4393 2026-09-08 18:32:55.000779 2026-09-14 10:12:01.226117
MPC_primarydb minor_planet_names 26688 2026-09-08 18:26:32.060609 2026-09-14 10:12:01.330444
MPC_mpcsbndb minor_planet_names 26688 2026-09-08 18:26:32.060609 2026-09-14 10:12:01.512722
SBN_to_AWS minor_planet_names 26688 2026-09-08 18:26:32.060609 2026-09-14 10:12:01.619559
MPC_primarydb mpc_orbits 1569849 2026-09-14 10:11:46.878668 2026-09-14 10:12:01.827903
MPC_mpcsbndb mpc_orbits 1569849 2026-09-14 10:11:46.878668 2026-09-14 10:12:03.626212
SBN_to_AWS mpc_orbits 1569849 2026-09-14 10:11:46.878668 2026-09-14 10:12:03.843234
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-09-14 10:12:06.683435
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-09-14 10:12:07.051828
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-09-14 10:12:07.183654
MPC_primarydb neocp_els 137 2026-09-14 09:55:44.49618 2026-09-14 10:12:07.476427
MPC_mpcsbndb neocp_els 137 2026-09-14 09:55:44.49618 2026-09-14 10:12:07.590176
SBN_to_AWS neocp_els 137 2026-09-14 09:55:44.49618 2026-09-14 10:12:07.681619
MPC_primarydb neocp_events 337360 2026-09-14 10:07:44.451028 2026-09-14 10:12:07.779542
MPC_mpcsbndb neocp_events 337360 2026-09-14 10:07:44.451028 2026-09-14 10:12:07.978699
SBN_to_AWS neocp_events 337360 2026-09-14 10:07:44.451028 2026-09-14 10:12:08.097422
MPC_primarydb neocp_obs 1190 2026-09-14 09:55:44.483427 2026-09-14 10:12:08.268058
MPC_mpcsbndb neocp_obs 1190 2026-09-14 09:55:44.483427 2026-09-14 10:12:08.381039
SBN_to_AWS neocp_obs 1190 2026-09-14 09:55:44.483427 2026-09-14 10:12:08.472614
MPC_primarydb neocp_obs_archive 835476 2026-09-14 09:55:44.489325 2026-09-14 10:12:08.573755
MPC_mpcsbndb neocp_obs_archive 835476 2026-09-14 09:55:44.489325 2026-09-14 10:12:08.842796
SBN_to_AWS neocp_obs_archive 835476 2026-09-14 09:55:44.489325 2026-09-14 10:12:08.971583
MPC_primarydb neocp_prev_des 74012 2026-09-14 10:07:44.335588 2026-09-14 10:12:09.225578
MPC_mpcsbndb neocp_prev_des 74012 2026-09-14 10:07:44.335588 2026-09-14 10:12:09.377513
SBN_to_AWS neocp_prev_des 74012 2026-09-14 10:07:44.335588 2026-09-14 10:12:09.482613
MPC_primarydb neocp_var 287822 2026-09-14 09:55:44.585859 2026-09-14 10:12:09.608979
MPC_mpcsbndb neocp_var 287822 2026-09-14 09:55:44.585859 2026-09-14 10:12:09.818211
SBN_to_AWS neocp_var 287822 2026-09-14 09:55:44.585859 2026-09-14 10:12:09.942265
MPC_primarydb obscodes 2722 2026-09-09 14:46:23.938076 2026-09-14 10:12:10.224173
MPC_mpcsbndb obscodes 2722 2026-09-09 14:46:23.938076 2026-09-14 10:12:10.362026
SBN_to_AWS obscodes 2722 2026-09-09 14:46:23.938076 2026-09-14 10:12:10.453884
MPC_primarydb primary_objects 1604046 2026-09-14 10:06:55.636147 2026-09-14 10:12:10.553352
MPC_mpcsbndb primary_objects 1604046 2026-09-14 10:06:55.636147 2026-09-14 10:12:11.040804
SBN_to_AWS primary_objects 1604046 2026-09-14 10:06:55.636147 2026-09-14 10:12:11.223041
MPC_primarydb obs_alterations_corrections 0 2026-09-14 10:12:12.867284
MPC_mpcsbndb obs_alterations_corrections 0 2026-09-14 10:12:12.981928
SBN_to_AWS obs_alterations_corrections 0 2026-09-14 10:12:13.07426
MPC_primarydb obs_alterations_deletions 3453540 2026-09-13 19:24:53.050858 2026-09-14 10:12:13.169859
MPC_mpcsbndb obs_alterations_deletions 3453540 2026-09-13 19:24:53.050858 2026-09-14 10:12:13.991667
SBN_to_AWS obs_alterations_deletions 3453540 2026-09-13 19:24:53.050858 2026-09-14 10:12:14.159708
MPC_primarydb obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-09-14 10:12:14.53893
MPC_mpcsbndb obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-09-14 10:12:14.660625
SBN_to_AWS obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-09-14 10:12:14.753375
MPC_primarydb obs_alterations_unassociations 605508 2026-09-14 10:10:08.888725 2026-09-14 10:12:14.85431
MPC_mpcsbndb obs_alterations_unassociations 605508 2026-09-14 10:10:08.888725 2026-09-14 10:12:15.154332
SBN_to_AWS obs_alterations_unassociations 605508 2026-09-14 10:10:08.888725 2026-09-14 10:12:15.281521