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-11 06: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 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 50790271 2026-09-10 18:38:17 2026-09-10 18:38:17
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 524457504 2026-09-11 05:39:27 2026-09-11 05:39:27
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1578552 2026-09-11 05:39:32 2026-09-11 06: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 85 2026-09-11 06:22:08.096317 2026-09-11 06:22:08.096317
neocp_events 336347 2026-09-11 06:22:08.206304 2026-09-11 06:22:08.206304
neocp_obs_archive 833560 2026-09-11 06:22:07.960955 2026-09-11 06:22:07.960955
neocp_obs 705 2026-09-11 06:22:07.92003 2026-09-11 06:22:07.92003
neocp_prev_des 73921 2026-09-11 05:38:33.697701 2026-09-11 05:38:33.697701
neocp_var 188089 2026-09-11 06:22:08.050315 2026-09-11 06:22:08.050315
current_identifications 2093592 2026-09-11 05:37:41.397802 2026-09-11 05:38:53.122431
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1603088 2026-09-11 05:37:41.342579 2026-09-11 05:37:41.342579
obs_sbn 553291550 2017-07-09 20:00:00-04 2026-09-11 02:25:32.62363-04
obs_alterations_deletions 3453490 2026-09-11 04:06:08.375358 2026-09-11 04:06:08.375358
obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-08-25 19:50:31.030107
obs_alterations_unassociations 605365 2026-09-10 22:10:08.670607 2026-09-10 22:10:08.670607
mpc_orbits 1568888 2023-05-30 14:35:42.74657 2026-09-11 06:15:43.62968
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 553291509 2026-09-11 05:59:10.599554 2026-09-11 06:00:02.132203
MPC_mpcsbndb obs_sbn 553291511 2026-09-11 06:00:08.322428 2026-09-11 06:00:21.204388
SBN_to_AWS obs_sbn 553291511 2026-09-11 06:00:08.322428 2026-09-11 06:00:44.085111
MPC_primarydb current_identifications 2093592 2026-09-11 05:38:53.122431 2026-09-11 06:11:30.729319
MPC_mpcsbndb current_identifications 2093592 2026-09-11 05:38:53.122431 2026-09-11 06:11:31.649901
SBN_to_AWS current_identifications 2093592 2026-09-11 05:38:53.122431 2026-09-11 06:11:31.803245
MPC_primarydb comet_names 4393 2026-09-08 18:32:55.000779 2026-09-11 06:11:32.584655
MPC_mpcsbndb comet_names 4393 2026-09-08 18:32:55.000779 2026-09-11 06:11:32.698176
SBN_to_AWS comet_names 4393 2026-09-08 18:32:55.000779 2026-09-11 06:11:32.794207
MPC_primarydb minor_planet_names 26688 2026-09-08 18:26:32.060609 2026-09-11 06:11:32.899356
MPC_mpcsbndb minor_planet_names 26688 2026-09-08 18:26:32.060609 2026-09-11 06:11:33.065359
SBN_to_AWS minor_planet_names 26688 2026-09-08 18:26:32.060609 2026-09-11 06:11:33.171137
MPC_primarydb mpc_orbits 1568888 2026-09-11 06:09:18.483142 2026-09-11 06:11:33.377197
MPC_mpcsbndb mpc_orbits 1568888 2026-09-11 06:09:18.483142 2026-09-11 06:11:35.065315
SBN_to_AWS mpc_orbits 1568888 2026-09-11 06:09:18.483142 2026-09-11 06:11:35.32047
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-09-11 06:11:39.575007
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-09-11 06:11:39.937748
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-09-11 06:11:40.068821
MPC_primarydb neocp_els 83 2026-09-11 06:09:27.602241 2026-09-11 06:11:40.36852
MPC_mpcsbndb neocp_els 83 2026-09-11 06:09:27.602241 2026-09-11 06:11:40.479856
SBN_to_AWS neocp_els 83 2026-09-11 06:09:27.602241 2026-09-11 06:11:40.571121
MPC_primarydb neocp_events 336342 2026-09-11 06:09:27.560428 2026-09-11 06:11:40.670349
MPC_mpcsbndb neocp_events 336342 2026-09-11 06:09:27.560428 2026-09-11 06:11:40.858656
SBN_to_AWS neocp_events 336342 2026-09-11 06:09:27.560428 2026-09-11 06:11:40.975331
MPC_primarydb neocp_obs 694 2026-09-11 06:09:27.476958 2026-09-11 06:11:41.14427
MPC_mpcsbndb neocp_obs 694 2026-09-11 06:09:27.476958 2026-09-11 06:11:41.253962
SBN_to_AWS neocp_obs 694 2026-09-11 06:09:27.476958 2026-09-11 06:11:41.345747
MPC_primarydb neocp_obs_archive 833549 2026-09-11 06:09:27.519124 2026-09-11 06:11:41.446553
MPC_mpcsbndb neocp_obs_archive 833549 2026-09-11 06:09:27.519124 2026-09-11 06:11:41.715837
SBN_to_AWS neocp_obs_archive 833549 2026-09-11 06:09:27.519124 2026-09-11 06:11:41.841073
MPC_primarydb neocp_prev_des 73921 2026-09-11 05:38:33.697701 2026-09-11 06:11:42.093977
MPC_mpcsbndb neocp_prev_des 73921 2026-09-11 05:38:33.697701 2026-09-11 06:11:42.238864
SBN_to_AWS neocp_prev_des 73921 2026-09-11 05:38:33.697701 2026-09-11 06:11:42.344604
MPC_primarydb neocp_var 184089 2026-09-11 06:09:27.692473 2026-09-11 06:11:42.471034
MPC_mpcsbndb neocp_var 184089 2026-09-11 06:09:27.692473 2026-09-11 06:11:42.654614
SBN_to_AWS neocp_var 184089 2026-09-11 06:09:27.692473 2026-09-11 06:11:42.772456
MPC_primarydb obscodes 2722 2026-09-09 14:46:23.938076 2026-09-11 06:11:42.889446
MPC_mpcsbndb obscodes 2722 2026-09-09 14:46:23.938076 2026-09-11 06:11:43.011056
SBN_to_AWS obscodes 2722 2026-09-09 14:46:23.938076 2026-09-11 06:11:43.103207
MPC_primarydb primary_objects 1603088 2026-09-11 05:37:41.342579 2026-09-11 06:11:43.203282
MPC_mpcsbndb primary_objects 1603088 2026-09-11 05:37:41.342579 2026-09-11 06:11:43.670035
SBN_to_AWS primary_objects 1603088 2026-09-11 05:37:41.342579 2026-09-11 06:11:43.842723
MPC_primarydb obs_alterations_corrections 0 2026-09-11 06:11:45.463739
MPC_mpcsbndb obs_alterations_corrections 0 2026-09-11 06:11:45.573033
SBN_to_AWS obs_alterations_corrections 0 2026-09-11 06:11:45.66429
MPC_primarydb obs_alterations_deletions 3453490 2026-09-11 04:06:08.375358 2026-09-11 06:11:45.759723
MPC_mpcsbndb obs_alterations_deletions 3453490 2026-09-11 04:06:08.375358 2026-09-11 06:11:46.654742
SBN_to_AWS obs_alterations_deletions 3453490 2026-09-11 04:06:08.375358 2026-09-11 06:11:46.815378
MPC_primarydb obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-09-11 06:11:47.225432
MPC_mpcsbndb obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-09-11 06:11:47.340898
SBN_to_AWS obs_alterations_redesignations 5218 2026-08-25 19:50:31.030107 2026-09-11 06:11:47.43327
MPC_primarydb obs_alterations_unassociations 605365 2026-09-10 22:10:08.670607 2026-09-11 06:11:47.534409
MPC_mpcsbndb obs_alterations_unassociations 605365 2026-09-10 22:10:08.670607 2026-09-11 06:11:47.854054
SBN_to_AWS obs_alterations_unassociations 605365 2026-09-10 22:10:08.670607 2026-09-11 06:11:47.980924