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 20:50:02 (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 49832542 2026-03-18 18:18:13 2026-03-18 18:18:13
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 512005130 2026-03-18 20:37:34 2026-03-18 20:37:34
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1534884 2026-03-18 20:37:38 2026-03-18 20:37:38
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 86 2026-03-17 05:43:25.027787 2026-03-18 20:51:30.902366
neocp_events 316448 2026-03-18 20:51:31.102377 2026-03-18 20:51:31.102377
neocp_obs_archive 792474 2026-03-18 20:51:30.861101 2026-03-18 20:51:30.861101
neocp_obs 1874 2026-03-18 20:51:30.819785 2026-03-18 20:51:30.819785
neocp_prev_des 71529 2026-03-18 20:36:52.951998 2026-03-18 20:36:52.951998
neocp_var 173897 2026-03-18 20:51:30.968877 2026-03-18 20:51:30.968877
current_identifications 2047643 2026-03-18 20:36:15.476645 2026-03-18 20:37:07.041236
numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-02-27 03:49:38.898045
primary_objects 1560254 2026-03-18 20:36:15.376589 2026-03-18 20:36:15.376589
obs_sbn 531874192 2026-03-18 16:52:35.131786-04 2026-03-18 16:53:22.73147-04
obs_alterations_deletions 1495192 2026-03-18 20:12:04.843603 2026-03-18 20:12:04.843603
obs_alterations_redesignations 4590 2026-03-18 20:47:44.531467 2026-03-18 20:47:44.531467
obs_alterations_unassociations 564295 2026-03-18 20:19:14.632088 2026-03-18 20:19:14.632088
mpc_orbits 1518395 2021-02-04 01:29:01.367542 2026-03-18 20:53:22.73147
minor_planet_names 26118 2011-10-28 06:29:37 2026-03-16 23:07:37.958069
obscodes 2687 2019-05-25 00:11:24.513966 2026-03-18 19:10:45.593554
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 531871691 2026-03-18 18:46:33.433256 2026-03-18 19:00:02.490087
MPC_mpcsbndb obs_sbn 531871691 2026-03-18 18:46:33.433256 2026-03-18 19:00:19.885395
SBN_to_AWS obs_sbn 531871691 2026-03-18 18:46:33.433256 2026-03-18 19:01:04.50093
MPC_primarydb current_identifications 2047642 2026-03-18 19:37:14.659586 2026-03-18 19:38:37.972445
MPC_mpcsbndb current_identifications 2047642 2026-03-18 19:37:14.659586 2026-03-18 19:38:38.658008
SBN_to_AWS current_identifications 2047642 2026-03-18 19:37:14.659586 2026-03-18 19:38:38.958443
MPC_primarydb comet_names 4366 2026-03-17 19:39:41.367684 2026-03-18 19:38:40.940457
MPC_mpcsbndb comet_names 4366 2026-03-17 19:39:41.367684 2026-03-18 19:38:41.052449
SBN_to_AWS comet_names 4366 2026-03-17 19:39:41.367684 2026-03-18 19:38:41.141023
MPC_primarydb minor_planet_names 26118 2026-03-16 23:07:37.958069 2026-03-18 19:38:41.23819
MPC_mpcsbndb minor_planet_names 26118 2026-03-16 23:07:37.958069 2026-03-18 19:38:41.399724
SBN_to_AWS minor_planet_names 26118 2026-03-16 23:07:37.958069 2026-03-18 19:38:41.500429
MPC_primarydb mpc_orbits 1518394 2026-03-18 19:36:44.804782 2026-03-18 19:38:41.643589
MPC_mpcsbndb mpc_orbits 1518394 2026-03-18 19:36:44.804782 2026-03-18 19:38:43.165047
SBN_to_AWS mpc_orbits 1518394 2026-03-18 19:36:44.804782 2026-03-18 19:38:43.635411
MPC_primarydb numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-18 19:38:51.328429
MPC_mpcsbndb numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-18 19:38:51.639545
SBN_to_AWS numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-18 19:38:51.778871
MPC_primarydb neocp_els 85 2026-03-18 19:28:20.366666 2026-03-18 19:38:52.051532
MPC_mpcsbndb neocp_els 85 2026-03-18 19:28:20.366666 2026-03-18 19:38:52.158845
SBN_to_AWS neocp_els 85 2026-03-18 19:28:20.366666 2026-03-18 19:38:52.246569
MPC_primarydb neocp_events 316436 2026-03-18 19:37:01.066693 2026-03-18 19:38:52.340547
MPC_mpcsbndb neocp_events 316436 2026-03-18 19:37:01.066693 2026-03-18 19:38:52.522455
SBN_to_AWS neocp_events 316436 2026-03-18 19:37:01.066693 2026-03-18 19:38:52.648286
MPC_primarydb neocp_obs 1865 2026-03-18 19:28:20.306684 2026-03-18 19:38:52.802603
MPC_mpcsbndb neocp_obs 1865 2026-03-18 19:28:20.306684 2026-03-18 19:38:52.912376
SBN_to_AWS neocp_obs 1865 2026-03-18 19:28:20.306684 2026-03-18 19:38:53.000204
MPC_primarydb neocp_obs_archive 792437 2026-03-18 19:31:08.343449 2026-03-18 19:38:53.095834
MPC_mpcsbndb neocp_obs_archive 792437 2026-03-18 19:31:08.343449 2026-03-18 19:38:53.317816
SBN_to_AWS neocp_obs_archive 792437 2026-03-18 19:31:08.343449 2026-03-18 19:38:53.476021
MPC_primarydb neocp_prev_des 71528 2026-03-18 19:37:00.942111 2026-03-18 19:38:53.72009
MPC_mpcsbndb neocp_prev_des 71528 2026-03-18 19:37:00.942111 2026-03-18 19:38:53.855604
SBN_to_AWS neocp_prev_des 71528 2026-03-18 19:37:00.942111 2026-03-18 19:38:53.960657
MPC_primarydb neocp_var 171897 2026-03-18 19:28:20.456724 2026-03-18 19:38:54.084929
MPC_mpcsbndb neocp_var 171897 2026-03-18 19:28:20.456724 2026-03-18 19:38:54.266897
SBN_to_AWS neocp_var 171897 2026-03-18 19:28:20.456724 2026-03-18 19:38:54.387978
MPC_primarydb obscodes 2687 2026-03-18 19:10:45.593554 2026-03-18 19:38:54.586105
MPC_mpcsbndb obscodes 2687 2026-03-18 19:10:45.593554 2026-03-18 19:38:54.711141
SBN_to_AWS obscodes 2687 2026-03-18 19:10:45.593554 2026-03-18 19:38:54.8027
MPC_primarydb primary_objects 1560254 2026-03-18 19:37:08.447893 2026-03-18 19:38:54.900993
MPC_mpcsbndb primary_objects 1560254 2026-03-18 19:37:08.447893 2026-03-18 19:38:55.307253
SBN_to_AWS primary_objects 1560254 2026-03-18 19:37:08.447893 2026-03-18 19:38:55.540728
MPC_primarydb obs_alterations_corrections 0 2026-03-18 19:38:57.185397
MPC_mpcsbndb obs_alterations_corrections 0 2026-03-18 19:38:57.294502
SBN_to_AWS obs_alterations_corrections 0 2026-03-18 19:38:57.381056
MPC_primarydb obs_alterations_deletions 1495189 2026-03-18 16:15:31.928311 2026-03-18 19:38:57.472438
MPC_mpcsbndb obs_alterations_deletions 1495189 2026-03-18 16:15:31.928311 2026-03-18 19:38:57.866393
SBN_to_AWS obs_alterations_deletions 1495189 2026-03-18 16:15:31.928311 2026-03-18 19:38:58.014889
MPC_primarydb obs_alterations_redesignations 4580 2026-03-18 19:38:25.67623 2026-03-18 19:38:58.279524
MPC_mpcsbndb obs_alterations_redesignations 4580 2026-03-18 19:38:25.67623 2026-03-18 19:38:58.393515
SBN_to_AWS obs_alterations_redesignations 4580 2026-03-18 19:38:25.67623 2026-03-18 19:38:58.483587
MPC_primarydb obs_alterations_unassociations 564292 2026-03-18 14:10:19.284248 2026-03-18 19:38:58.578833
MPC_mpcsbndb obs_alterations_unassociations 564292 2026-03-18 14:10:19.284248 2026-03-18 19:38:58.841354
SBN_to_AWS obs_alterations_unassociations 564292 2026-03-18 14:10:19.284248 2026-03-18 19:38:58.97056