Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

23 Feb 2025

  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

2025-03-10 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 5202 2017-03-15 16:46:33 2025-02-02 03:55:25
comet_orbits 9917 2025-02-07 23:25:28 2025-03-06 20:01:03
identifications 204979 2025-03-10 12:26:48 2025-03-10 12:26:48
isolated_tracklets 48361107 2025-03-10 17:16:49 2025-03-10 17:16:49
mp_discoverers 1937686 2014-10-19 04:36:17 2025-01-30 01:06:24
numbered_comet_identifications 1084 2025-02-24 11:40:13 2025-02-24 11:40:13
numbered_identifications 1199480 2025-02-07 17:43:41 2025-02-07 17:43:41
numbered_mps 773916 2025-02-07 19:44:28 2025-02-25 19:54:56
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 470523881 2025-03-10 18:06:09 2025-03-10 18:06:09
orbit_uncertainties 785438 2019-06-05 12:14:34 2024-12-03 08:16:15
orbits 1456948 2025-03-10 18:06:12 2025-03-10 19: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 42 2025-03-10 19:27:03.638365 2025-03-10 19:27:03.638365
neocp_events 266228 2025-03-10 19:27:03.692204 2025-03-10 19:27:03.692204
neocp_obs_archive 676669 2025-03-10 19:27:03.585237 2025-03-10 19:27:03.585237
neocp_obs 369 2025-03-10 19:27:03.578912 2025-03-10 19:27:03.578912
neocp_prev_des 65081 2025-03-10 18:06:21.685613 2025-03-10 18:06:21.685613
neocp_var 75729 2025-03-10 19:27:03.594514 2025-03-10 19:27:03.594514
current_identifications 1966766 2025-03-10 21:12:00.12605 2025-03-10 21:13:05.764367
numbered_identifications 774710 2025-02-06 01:18:26.171581 2025-02-06 01:18:26.171581
primary_objects 1485718 2025-03-10 21:12:00.100349 2025-03-10 21:12:00.100349
obs_sbn 482626980 2025-01-10 09:13:04.665034-05 2025-03-10 17:12:02.394588-04
obs_alterations_deletions 1316331 2025-03-10 20:36:51.747699 2025-03-10 20:36:51.747699
obs_alterations_redesignations 4208 2025-03-06 19:22:03.650961 2025-03-06 19:22:03.650961
obs_alterations_unassociations 376641 2025-03-10 20:36:59.831632 2025-03-10 20:36:59.831632
mpc_orbits 1435611 2025-03-10 21:12:47.030769 2025-03-10 21:12:53.302818
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 482626980 2025-03-10 20:59:39.464612 2025-03-10 21:00:01.770983
MPC_mpcsbndb obs_sbn 482626980 2025-03-10 20:59:39.464612 2025-03-10 21:00:08.386162
SBN_to_AWS obs_sbn 482626980 2025-03-10 20:59:39.464612 2025-03-10 21:00:26.803406
MPC_primarydb current_identifications 1966762 2025-03-10 19:46:11.510853 2025-03-10 21:00:54.82045
MPC_mpcsbndb current_identifications 1966762 2025-03-10 19:46:11.510853 2025-03-10 21:00:55.386234
SBN_to_AWS current_identifications 1966762 2025-03-10 19:46:11.510853 2025-03-10 21:00:55.592003
MPC_primarydb mpc_orbits 1435605 2025-03-10 21:00:41.362227 2025-03-10 21:00:55.859099
MPC_mpcsbndb mpc_orbits 1435605 2025-03-10 21:00:57.374428 2025-03-10 21:00:58.322555
SBN_to_AWS mpc_orbits 1435605 2025-03-10 21:00:57.374428 2025-03-10 21:00:58.637957
MPC_primarydb numbered_identifications 774710 2025-02-06 01:18:26.171581 2025-03-10 21:00:59.031668
MPC_mpcsbndb numbered_identifications 774710 2025-02-06 01:18:26.171581 2025-03-10 21:00:59.422083
SBN_to_AWS numbered_identifications 774710 2025-02-06 01:18:26.171581 2025-03-10 21:00:59.581356
MPC_primarydb neocp_els 42 2025-03-10 19:27:03.638365 2025-03-10 21:00:59.806198
MPC_mpcsbndb neocp_els 42 2025-03-10 19:27:03.638365 2025-03-10 21:00:59.90875
SBN_to_AWS neocp_els 42 2025-03-10 19:27:03.638365 2025-03-10 21:00:59.996528
MPC_primarydb neocp_events 266228 2025-03-10 19:27:03.692204 2025-03-10 21:01:00.172491
MPC_mpcsbndb neocp_events 266228 2025-03-10 19:27:03.692204 2025-03-10 21:01:00.343839
SBN_to_AWS neocp_events 266228 2025-03-10 19:27:03.692204 2025-03-10 21:01:00.466136
MPC_primarydb neocp_obs 369 2025-03-10 19:27:03.578912 2025-03-10 21:01:00.669924
MPC_mpcsbndb neocp_obs 369 2025-03-10 19:27:03.578912 2025-03-10 21:01:00.774083
SBN_to_AWS neocp_obs 369 2025-03-10 19:27:03.578912 2025-03-10 21:01:00.862245
MPC_primarydb neocp_obs_archive 676669 2025-03-10 19:27:03.585237 2025-03-10 21:01:01.039415
MPC_mpcsbndb neocp_obs_archive 676669 2025-03-10 19:27:03.585237 2025-03-10 21:01:01.276514
SBN_to_AWS neocp_obs_archive 676669 2025-03-10 19:27:03.585237 2025-03-10 21:01:01.410127
MPC_primarydb neocp_prev_des 65081 2025-03-10 18:06:21.685613 2025-03-10 21:01:01.618512
MPC_mpcsbndb neocp_prev_des 65081 2025-03-10 18:06:21.685613 2025-03-10 21:01:01.755532
SBN_to_AWS neocp_prev_des 65081 2025-03-10 18:06:21.685613 2025-03-10 21:01:01.860305
MPC_primarydb neocp_var 75729 2025-03-10 19:27:03.594514 2025-03-10 21:01:02.051131
MPC_mpcsbndb neocp_var 75729 2025-03-10 19:27:03.594514 2025-03-10 21:01:02.190995
SBN_to_AWS neocp_var 75729 2025-03-10 19:27:03.594514 2025-03-10 21:01:02.309664
MPC_primarydb primary_objects 1485714 2025-03-10 18:05:44.075865 2025-03-10 21:01:02.51021
MPC_mpcsbndb primary_objects 1485714 2025-03-10 18:05:44.075865 2025-03-10 21:01:03.011769
SBN_to_AWS primary_objects 1485714 2025-03-10 18:05:44.075865 2025-03-10 21:01:03.202873
MPC_primarydb obs_alterations_corrections 0 2025-03-10 21:01:03.43792
MPC_mpcsbndb obs_alterations_corrections 0 2025-03-10 21:01:03.538349
SBN_to_AWS obs_alterations_corrections 0 2025-03-10 21:01:03.625506
MPC_primarydb obs_alterations_deletions 1316331 2025-03-10 20:36:51.747699 2025-03-10 21:01:03.802868
MPC_mpcsbndb obs_alterations_deletions 1316331 2025-03-10 20:36:51.747699 2025-03-10 21:01:04.293049
SBN_to_AWS obs_alterations_deletions 1316331 2025-03-10 20:36:51.747699 2025-03-10 21:01:04.423024
MPC_primarydb obs_alterations_redesignations 4208 2025-03-06 19:22:03.650961 2025-03-10 21:01:04.638438
MPC_mpcsbndb obs_alterations_redesignations 4208 2025-03-06 19:22:03.650961 2025-03-10 21:01:04.745075
SBN_to_AWS obs_alterations_redesignations 4208 2025-03-06 19:22:03.650961 2025-03-10 21:01:04.834105