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-08-17 00:00: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 12794 2026-08-13 21:20:44 2026-08-13 22:01:03
identifications 223187 2026-07-14 12:33:56 2026-07-14 12:33:56
isolated_tracklets 50789957 2026-08-16 21:28:21 2026-08-16 21:28:21
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 2011-10-27 02:54:58 2026-08-06 11:46:35
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 524422529 2026-08-16 17:02:28 2026-08-16 17:02:28
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1572688 2026-08-16 17:02:31 2026-08-16 18: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 95 2026-08-16 04:59:24.086326 2026-08-16 23:36:35.412068
neocp_events 332991 2026-08-16 23:36:35.370311 2026-08-16 23:36:35.370311
neocp_obs_archive 827832 2026-08-16 23:36:35.367336 2026-08-16 23:36:35.367336
neocp_obs 1188 2026-08-16 23:36:35.342145 2026-08-16 23:36:35.342145
neocp_prev_des 73504 2026-08-16 17:01:33.062389 2026-08-16 17:01:33.062389
neocp_var 208122 2026-08-16 23:36:35.502449 2026-08-16 23:36:35.502449
current_identifications 2087563 2026-08-16 17:00:41.403732 2026-08-16 17:01:54.081438
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1597267 2026-08-16 17:00:41.374102 2026-08-16 17:00:41.374102
obs_sbn 546055213 2026-08-08 10:08:37.874277-04 2026-08-16 20:03:45.932539-04
obs_alterations_deletions 1948151 2026-08-16 21:31:13.12724 2026-08-16 21:31:13.12724
obs_alterations_redesignations 5194 2026-08-12 19:41:29.142496 2026-08-12 19:41:29.142496
obs_alterations_unassociations 601055 2026-08-16 22:10:36.039894 2026-08-16 22:10:36.039894
mpc_orbits 1562873 2023-06-10 04:50:20.313233 2026-08-17 00:04:07.696378
minor_planet_names 26594 2013-07-23 23:31:57 2026-08-14 17:06:20.634304
obscodes 2717 2026-08-14 19:43:59.64199 2026-08-14 19:43:59.64199
comet_names 4389 2026-08-07 13:39:18.93276 2026-08-07 13:39:18.93276
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 546055160 2026-08-16 22:59:52.76904 2026-08-16 23:00:02.583411
MPC_mpcsbndb obs_sbn 546055160 2026-08-16 22:59:52.76904 2026-08-16 23:00:14.715821
SBN_to_AWS obs_sbn 546055160 2026-08-16 23:00:44.578385 2026-08-16 23:00:56.68517
MPC_primarydb current_identifications 2087563 2026-08-16 17:01:54.081438 2026-08-16 23:15:42.319503
MPC_mpcsbndb current_identifications 2087563 2026-08-16 17:01:54.081438 2026-08-16 23:15:43.141957
SBN_to_AWS current_identifications 2087563 2026-08-16 17:01:54.081438 2026-08-16 23:15:43.304612
MPC_primarydb comet_names 4389 2026-08-07 13:39:18.93276 2026-08-16 23:15:43.492294
MPC_mpcsbndb comet_names 4389 2026-08-07 13:39:18.93276 2026-08-16 23:15:43.587413
SBN_to_AWS comet_names 4389 2026-08-07 13:39:18.93276 2026-08-16 23:15:43.665004
MPC_primarydb minor_planet_names 26594 2026-08-14 17:06:20.634304 2026-08-16 23:15:43.744152
MPC_mpcsbndb minor_planet_names 26594 2026-08-14 17:06:20.634304 2026-08-16 23:15:43.893053
SBN_to_AWS minor_planet_names 26594 2026-08-14 17:06:20.634304 2026-08-16 23:15:43.987629
MPC_primarydb mpc_orbits 1562873 2026-08-16 23:15:25.908821 2026-08-16 23:15:44.071889
MPC_mpcsbndb mpc_orbits 1562873 2026-08-16 23:15:25.908821 2026-08-16 23:15:45.741003
SBN_to_AWS mpc_orbits 1562873 2026-08-16 23:15:25.908821 2026-08-16 23:15:46.065466
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-16 23:15:46.233168
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-16 23:15:46.53249
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-16 23:15:46.663963
MPC_primarydb neocp_els 95 2026-08-16 23:03:32.948809 2026-08-16 23:15:46.7917
MPC_mpcsbndb neocp_els 95 2026-08-16 23:03:32.948809 2026-08-16 23:15:46.885089
SBN_to_AWS neocp_els 95 2026-08-16 23:03:32.948809 2026-08-16 23:15:46.961192
MPC_primarydb neocp_events 332989 2026-08-16 23:03:32.943958 2026-08-16 23:15:47.039607
MPC_mpcsbndb neocp_events 332989 2026-08-16 23:03:32.943958 2026-08-16 23:15:47.219384
SBN_to_AWS neocp_events 332989 2026-08-16 23:03:32.943958 2026-08-16 23:15:47.334732
MPC_primarydb neocp_obs 1183 2026-08-16 23:03:32.895558 2026-08-16 23:15:47.434513
MPC_mpcsbndb neocp_obs 1183 2026-08-16 23:03:32.895558 2026-08-16 23:15:47.526717
SBN_to_AWS neocp_obs 1183 2026-08-16 23:03:32.895558 2026-08-16 23:15:47.603418
MPC_primarydb neocp_obs_archive 827827 2026-08-16 23:03:32.902469 2026-08-16 23:15:47.680609
MPC_mpcsbndb neocp_obs_archive 827827 2026-08-16 23:03:32.902469 2026-08-16 23:15:47.882269
SBN_to_AWS neocp_obs_archive 827827 2026-08-16 23:03:32.902469 2026-08-16 23:15:48.043163
MPC_primarydb neocp_prev_des 73504 2026-08-16 17:01:33.062389 2026-08-16 23:15:48.168187
MPC_mpcsbndb neocp_prev_des 73504 2026-08-16 17:01:33.062389 2026-08-16 23:15:48.297078
SBN_to_AWS neocp_prev_des 73504 2026-08-16 17:01:33.062389 2026-08-16 23:15:48.389657
MPC_primarydb neocp_var 208122 2026-08-16 23:03:33.018823 2026-08-16 23:15:48.476664
MPC_mpcsbndb neocp_var 208122 2026-08-16 23:03:33.018823 2026-08-16 23:15:48.655394
SBN_to_AWS neocp_var 208122 2026-08-16 23:03:33.018823 2026-08-16 23:15:48.777984
MPC_primarydb obscodes 2717 2026-08-14 19:43:59.64199 2026-08-16 23:15:48.870135
MPC_mpcsbndb obscodes 2717 2026-08-14 19:43:59.64199 2026-08-16 23:15:48.982666
SBN_to_AWS obscodes 2717 2026-08-14 19:43:59.64199 2026-08-16 23:15:49.06067
MPC_primarydb primary_objects 1597267 2026-08-16 17:00:41.374102 2026-08-16 23:15:49.139236
MPC_mpcsbndb primary_objects 1597267 2026-08-16 17:00:41.374102 2026-08-16 23:15:49.619631
SBN_to_AWS primary_objects 1597267 2026-08-16 17:00:41.374102 2026-08-16 23:15:49.82985
MPC_primarydb obs_alterations_corrections 0 2026-08-16 23:15:50.015463
MPC_mpcsbndb obs_alterations_corrections 0 2026-08-16 23:15:50.106667
SBN_to_AWS obs_alterations_corrections 0 2026-08-16 23:15:50.181287
MPC_primarydb obs_alterations_deletions 1948151 2026-08-16 21:31:13.12724 2026-08-16 23:15:50.259396
MPC_mpcsbndb obs_alterations_deletions 1948151 2026-08-16 21:31:13.12724 2026-08-16 23:15:50.77339
SBN_to_AWS obs_alterations_deletions 1948151 2026-08-16 21:31:13.12724 2026-08-16 23:15:50.911127
MPC_primarydb obs_alterations_redesignations 5194 2026-08-12 19:41:29.142496 2026-08-16 23:15:51.076221
MPC_mpcsbndb obs_alterations_redesignations 5194 2026-08-12 19:41:29.142496 2026-08-16 23:15:51.171203
SBN_to_AWS obs_alterations_redesignations 5194 2026-08-12 19:41:29.142496 2026-08-16 23:15:51.248792
MPC_primarydb obs_alterations_unassociations 601055 2026-08-16 22:10:36.039894 2026-08-16 23:15:51.326981
MPC_mpcsbndb obs_alterations_unassociations 601055 2026-08-16 22:10:36.039894 2026-08-16 23:15:51.564177
SBN_to_AWS obs_alterations_unassociations 601055 2026-08-16 22:10:36.039894 2026-08-16 23:15:51.684068