Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

24 Apr 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-05-17 21:10: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 12626 2025-02-07 23:25:28 2026-05-08 21:01:03
identifications 218331 2026-04-14 12:33:30 2026-04-14 12:33:30
isolated_tracklets 49955645 2026-05-17 21:08:17 2026-05-17 21:08:17
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 2024-02-21 19:12:24 2026-05-07 10:18:37
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 512081062 2026-05-17 21:07:16 2026-05-17 21:07:16
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1558538 2026-05-14 05:28:23 2026-05-17 21:11:55
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 24 2026-05-17 07:28:35.343003 2026-05-17 21:00:44.294878
neocp_events 324135 2026-05-17 21:06:33.63238 2026-05-17 21:06:33.63238
neocp_obs_archive 811471 2026-05-17 21:00:44.252502 2026-05-17 21:00:44.252502
neocp_obs 255 2026-05-17 21:00:44.210906 2026-05-17 21:00:44.210906
neocp_prev_des 72444 2026-05-17 21:06:33.353614 2026-05-17 21:06:33.353614
neocp_var 60918 2026-05-17 21:00:44.385264 2026-05-17 21:00:44.385264
current_identifications 2071201 2026-05-14 05:26:37.314768 2026-05-17 21:11:25.935686
numbered_identifications 887936 2026-03-24 19:55:09.966554 2026-03-24 19:55:09.966554
primary_objects 1583669 2026-05-17 21:05:50.273735 2026-05-17 21:05:50.273735
obs_sbn 539164801 2026-05-17 17:15:09.015415-04 2026-05-17 17:16:20.611249-04
obs_alterations_deletions 1489915 2026-05-17 01:46:05.282749 2026-05-17 01:46:05.282749
obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-04-07 06:22:54.863572
obs_alterations_unassociations 579807 2026-05-17 17:34:09.859687 2026-05-17 17:34:09.859687
mpc_orbits 1548554 2021-02-04 02:03:58.42263 2026-05-17 21:16:20.611249
minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-05-07 14:26:32.139498
obscodes 2702 2026-05-15 19:49:43.167881 2026-05-15 19:49:43.167881
comet_names 4374 2026-05-06 19:14:21.901296 2026-05-06 19:14:21.901296
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 539164733 2026-05-17 20:58:24.685333 2026-05-17 21:00:02.433002
MPC_mpcsbndb obs_sbn 539164733 2026-05-17 20:58:24.685333 2026-05-17 21:00:19.710761
SBN_to_AWS obs_sbn 539164733 2026-05-17 20:58:24.685333 2026-05-17 21:00:43.386602
MPC_primarydb current_identifications 2071201 2026-05-17 21:11:25.935686 2026-05-17 21:16:02.878104
MPC_mpcsbndb current_identifications 2071201 2026-05-17 21:11:25.935686 2026-05-17 21:16:03.849063
SBN_to_AWS current_identifications 2071201 2026-05-17 21:11:25.935686 2026-05-17 21:16:03.998764
MPC_primarydb comet_names 4374 2026-05-06 19:14:21.901296 2026-05-17 21:16:04.386199
MPC_mpcsbndb comet_names 4374 2026-05-06 19:14:21.901296 2026-05-17 21:16:04.494273
SBN_to_AWS comet_names 4374 2026-05-06 19:14:21.901296 2026-05-17 21:16:04.581103
MPC_primarydb minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-05-17 21:16:04.679314
MPC_mpcsbndb minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-05-17 21:16:04.835659
SBN_to_AWS minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-05-17 21:16:04.937822
MPC_primarydb mpc_orbits 1548554 2026-05-17 21:11:45.550136 2026-05-17 21:16:05.084032
MPC_mpcsbndb mpc_orbits 1548554 2026-05-17 21:11:45.550136 2026-05-17 21:16:06.729614
SBN_to_AWS mpc_orbits 1548554 2026-05-17 21:11:45.550136 2026-05-17 21:16:06.951254
MPC_primarydb numbered_identifications 887800 2026-03-24 19:55:09.966554 2026-05-17 21:16:08.68238
MPC_mpcsbndb numbered_identifications 887800 2026-03-24 19:55:09.966554 2026-05-17 21:16:09.088669
SBN_to_AWS numbered_identifications 887800 2026-03-24 19:55:09.966554 2026-05-17 21:16:09.217906
MPC_primarydb neocp_els 23 2026-05-17 20:53:03.407752 2026-05-17 21:16:09.507784
MPC_mpcsbndb neocp_els 23 2026-05-17 20:53:03.407752 2026-05-17 21:16:09.615931
SBN_to_AWS neocp_els 23 2026-05-17 20:53:03.407752 2026-05-17 21:16:09.703393
MPC_primarydb neocp_events 324135 2026-05-17 21:06:33.63238 2026-05-17 21:16:09.797375
MPC_mpcsbndb neocp_events 324135 2026-05-17 21:06:33.63238 2026-05-17 21:16:09.995361
SBN_to_AWS neocp_events 324135 2026-05-17 21:06:33.63238 2026-05-17 21:16:10.110323
MPC_primarydb neocp_obs 235 2026-05-17 20:53:03.324122 2026-05-17 21:16:10.262186
MPC_mpcsbndb neocp_obs 235 2026-05-17 20:53:03.324122 2026-05-17 21:16:10.370259
SBN_to_AWS neocp_obs 235 2026-05-17 20:53:03.324122 2026-05-17 21:16:10.457546
MPC_primarydb neocp_obs_archive 811471 2026-05-17 21:00:44.252502 2026-05-17 21:16:10.554573
MPC_mpcsbndb neocp_obs_archive 811471 2026-05-17 21:00:44.252502 2026-05-17 21:16:10.813173
SBN_to_AWS neocp_obs_archive 811471 2026-05-17 21:00:44.252502 2026-05-17 21:16:10.945834
MPC_primarydb neocp_prev_des 72444 2026-05-17 21:06:33.353614 2026-05-17 21:16:11.175944
MPC_mpcsbndb neocp_prev_des 72444 2026-05-17 21:06:33.353614 2026-05-17 21:16:11.319701
SBN_to_AWS neocp_prev_des 72444 2026-05-17 21:06:33.353614 2026-05-17 21:16:11.423419
MPC_primarydb neocp_var 58918 2026-05-17 20:53:03.499546 2026-05-17 21:16:11.545043
MPC_mpcsbndb neocp_var 58918 2026-05-17 20:53:03.499546 2026-05-17 21:16:11.703598
SBN_to_AWS neocp_var 58918 2026-05-17 20:53:03.499546 2026-05-17 21:16:11.808983
MPC_primarydb obscodes 2702 2026-05-15 19:49:43.167881 2026-05-17 21:16:11.983718
MPC_mpcsbndb obscodes 2702 2026-05-15 19:49:43.167881 2026-05-17 21:16:12.104639
SBN_to_AWS obscodes 2702 2026-05-15 19:49:43.167881 2026-05-17 21:16:12.192052
MPC_primarydb primary_objects 1583669 2026-05-17 21:05:50.273735 2026-05-17 21:16:12.288322
MPC_mpcsbndb primary_objects 1583669 2026-05-17 21:05:50.273735 2026-05-17 21:16:12.793494
SBN_to_AWS primary_objects 1583669 2026-05-17 21:05:50.273735 2026-05-17 21:16:12.977801
MPC_primarydb obs_alterations_corrections 0 2026-05-17 21:16:14.607584
MPC_mpcsbndb obs_alterations_corrections 0 2026-05-17 21:16:14.712725
SBN_to_AWS obs_alterations_corrections 0 2026-05-17 21:16:14.79924
MPC_primarydb obs_alterations_deletions 1489915 2026-05-17 01:46:05.282749 2026-05-17 21:16:14.89159
MPC_mpcsbndb obs_alterations_deletions 1489915 2026-05-17 01:46:05.282749 2026-05-17 21:16:15.50954
SBN_to_AWS obs_alterations_deletions 1489915 2026-05-17 01:46:05.282749 2026-05-17 21:16:15.64595
MPC_primarydb obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-05-17 21:16:15.910288
MPC_mpcsbndb obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-05-17 21:16:16.023935
SBN_to_AWS obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-05-17 21:16:16.111133
MPC_primarydb obs_alterations_unassociations 579807 2026-05-17 17:34:09.859687 2026-05-17 21:16:16.207928
MPC_mpcsbndb obs_alterations_unassociations 579807 2026-05-17 17:34:09.859687 2026-05-17 21:16:16.517394
SBN_to_AWS obs_alterations_unassociations 579807 2026-05-17 17:34:09.859687 2026-05-17 21:16:16.641845