Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

25 Feb 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-03-18 13:30: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 12086 2014-02-10 15:54:08 2026-03-17 22:01:06
identifications 218067 2026-03-18 12:25:43 2026-03-18 12:25:43
isolated_tracklets 49832408 2026-03-18 12:57:30 2026-03-18 12:57:30
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 2022-04-06 05:12:26 2026-03-16 19:07:41
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 512004741 2026-03-18 13:19:21 2026-03-18 13:19:21
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1534877 2019-03-31 22:11:17 2026-03-18 13:19: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 94 2026-03-18 13:31:38.485742 2026-03-18 13:31:38.485742
neocp_events 316400 2026-03-18 13:31:38.579658 2026-03-18 13:31:38.579658
neocp_obs_archive 792385 2026-03-18 13:31:38.419004 2026-03-18 13:31:38.419004
neocp_obs 2256 2026-03-18 13:31:38.406654 2026-03-18 13:31:38.406654
neocp_prev_des 71516 2026-03-18 12:55:57.620948 2026-03-18 12:55:57.620948
neocp_var 188894 2026-03-18 13:31:38.433625 2026-03-18 13:31:38.433625
current_identifications 2047630 2020-07-30 16:13:01.366536 2026-03-18 13:18:47.815143
numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-02-27 03:49:38.898045
primary_objects 1560241 2026-03-18 10:06:16.98371 2026-03-18 10:06:16.98371
obs_sbn 531843919 2026-03-18 08:46:16.111364-04 2026-03-18 09:33:38.825482-04
obs_alterations_deletions 1495177 2026-03-18 13:01:11.350754 2026-03-18 13:01:11.350754
obs_alterations_redesignations 4565 2026-03-17 19:53:37.435364 2026-03-17 19:53:37.435364
obs_alterations_unassociations 564246 2026-03-18 11:28:12.090151 2026-03-18 11:28:12.090151
mpc_orbits 1518382 2021-02-04 01:32:34.286193 2026-03-18 13:33:59.919407
minor_planet_names 26118 2011-10-28 06:29:37 2026-03-16 23:07:37.958069
obscodes 2686 2026-03-17 20:41:07.124026 2026-03-17 20:41:07.124026
comet_names 4366 2026-03-17 19:39:41.367684 2026-03-17 19:39:41.367684
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 531804995 2026-03-18 12:59:59.394302 2026-03-18 13:00:02.72669
MPC_mpcsbndb obs_sbn 531805061 2026-03-18 13:00:18.846996 2026-03-18 13:00:20.475944
SBN_to_AWS obs_sbn 531805183 2026-03-18 13:00:52.561745 2026-03-18 13:00:58.991286
MPC_primarydb current_identifications 2047630 2026-03-18 12:25:40.890893 2026-03-18 13:12:43.594127
MPC_mpcsbndb current_identifications 2047630 2026-03-18 12:25:40.890893 2026-03-18 13:12:44.365415
SBN_to_AWS current_identifications 2047630 2026-03-18 12:25:40.890893 2026-03-18 13:12:44.646538
MPC_primarydb comet_names 4366 2026-03-17 19:39:41.367684 2026-03-18 13:12:46.108378
MPC_mpcsbndb comet_names 4366 2026-03-17 19:39:41.367684 2026-03-18 13:12:46.216175
SBN_to_AWS comet_names 4366 2026-03-17 19:39:41.367684 2026-03-18 13:12:46.30098
MPC_primarydb minor_planet_names 26118 2026-03-16 23:07:37.958069 2026-03-18 13:12:46.396506
MPC_mpcsbndb minor_planet_names 26118 2026-03-16 23:07:37.958069 2026-03-18 13:12:46.558828
SBN_to_AWS minor_planet_names 26118 2026-03-16 23:07:37.958069 2026-03-18 13:12:46.656342
MPC_primarydb mpc_orbits 1518382 2026-03-18 13:12:46.024708 2026-03-18 13:12:46.791912
MPC_mpcsbndb mpc_orbits 1518382 2026-03-18 13:12:47.473574 2026-03-18 13:12:48.507545
SBN_to_AWS mpc_orbits 1518382 2026-03-18 13:12:47.022169 2026-03-18 13:12:48.960333
MPC_primarydb numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-18 13:12:53.335672
MPC_mpcsbndb numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-18 13:12:53.689084
SBN_to_AWS numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-18 13:12:53.827893
MPC_primarydb neocp_els 93 2026-03-18 12:45:00.575611 2026-03-18 13:12:54.0607
MPC_mpcsbndb neocp_els 93 2026-03-18 12:45:00.575611 2026-03-18 13:12:54.169756
SBN_to_AWS neocp_els 93 2026-03-18 12:45:00.575611 2026-03-18 13:12:54.25221
MPC_primarydb neocp_events 316398 2026-03-18 12:55:57.805322 2026-03-18 13:12:54.34121
MPC_mpcsbndb neocp_events 316398 2026-03-18 12:55:57.805322 2026-03-18 13:12:54.549695
SBN_to_AWS neocp_events 316398 2026-03-18 12:55:57.805322 2026-03-18 13:12:54.665915
MPC_primarydb neocp_obs 2249 2026-03-18 12:45:00.490328 2026-03-18 13:12:54.811069
MPC_mpcsbndb neocp_obs 2249 2026-03-18 12:45:00.490328 2026-03-18 13:12:54.915341
SBN_to_AWS neocp_obs 2249 2026-03-18 12:45:00.490328 2026-03-18 13:12:54.999852
MPC_primarydb neocp_obs_archive 792378 2026-03-18 12:45:00.569354 2026-03-18 13:12:55.09402
MPC_mpcsbndb neocp_obs_archive 792378 2026-03-18 12:45:00.569354 2026-03-18 13:12:55.362176
SBN_to_AWS neocp_obs_archive 792378 2026-03-18 12:45:00.569354 2026-03-18 13:12:55.510562
MPC_primarydb neocp_prev_des 71516 2026-03-18 12:55:57.620948 2026-03-18 13:12:55.734768
MPC_mpcsbndb neocp_prev_des 71516 2026-03-18 12:55:57.620948 2026-03-18 13:12:55.87619
SBN_to_AWS neocp_prev_des 71516 2026-03-18 12:55:57.620948 2026-03-18 13:12:55.976167
MPC_primarydb neocp_var 186894 2026-03-18 12:45:00.716288 2026-03-18 13:12:56.092646
MPC_mpcsbndb neocp_var 186894 2026-03-18 12:45:00.716288 2026-03-18 13:12:56.276656
SBN_to_AWS neocp_var 186894 2026-03-18 12:45:00.716288 2026-03-18 13:12:56.398791
MPC_primarydb obscodes 2686 2026-03-17 20:41:07.124026 2026-03-18 13:12:56.60728
MPC_mpcsbndb obscodes 2686 2026-03-17 20:41:07.124026 2026-03-18 13:12:56.73157
SBN_to_AWS obscodes 2686 2026-03-17 20:41:07.124026 2026-03-18 13:12:56.817642
MPC_primarydb primary_objects 1560241 2026-03-18 10:06:16.98371 2026-03-18 13:12:56.913217
MPC_mpcsbndb primary_objects 1560241 2026-03-18 10:06:16.98371 2026-03-18 13:12:57.452448
SBN_to_AWS primary_objects 1560241 2026-03-18 10:06:16.98371 2026-03-18 13:12:57.701119
MPC_primarydb obs_alterations_corrections 0 2026-03-18 13:12:59.284996
MPC_mpcsbndb obs_alterations_corrections 0 2026-03-18 13:12:59.392885
SBN_to_AWS obs_alterations_corrections 0 2026-03-18 13:12:59.476206
MPC_primarydb obs_alterations_deletions 1495177 2026-03-18 13:01:11.350754 2026-03-18 13:12:59.562816
MPC_mpcsbndb obs_alterations_deletions 1495177 2026-03-18 13:01:11.350754 2026-03-18 13:13:00.087754
SBN_to_AWS obs_alterations_deletions 1495177 2026-03-18 13:01:11.350754 2026-03-18 13:13:00.240416
MPC_primarydb obs_alterations_redesignations 4565 2026-03-17 19:53:37.435364 2026-03-18 13:13:00.482723
MPC_mpcsbndb obs_alterations_redesignations 4565 2026-03-17 19:53:37.435364 2026-03-18 13:13:00.594855
SBN_to_AWS obs_alterations_redesignations 4565 2026-03-17 19:53:37.435364 2026-03-18 13:13:00.680304
MPC_primarydb obs_alterations_unassociations 564246 2026-03-18 11:28:12.090151 2026-03-18 13:13:00.770393
MPC_mpcsbndb obs_alterations_unassociations 564246 2026-03-18 11:28:12.090151 2026-03-18 13:13:01.128452
SBN_to_AWS obs_alterations_unassociations 564246 2026-03-18 11:28:12.090151 2026-03-18 13:13:01.266727