Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

22 May 2023

  1. SBN server is up and running. Both databases (mpcbeta and mpc_sbn) are available for re-subscription.

Please report concerns!

KEY

Database Replication

Instructions (not for the faint of heart) for replicating the database are on the SBN Wiki. Questions/issues related to replication should be directed to Andrei Mamoutkine.

Latest update of every table in MPC MariaDB and Postgres

2023-05-30 17:20:01 (GMT)

Status of all major tables from MariaDB (mpc_development) and two parallel Postgres databases (mpcbeta and 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
close_approaches 223366 2019-05-23 19:22:13 2019-05-23 19:22:13
comet_names 4586 2017-03-15 16:46:33 2017-03-15 16:46:33
comet_orbit_uncertainties 1015 2019-06-04 12:15:27 2019-06-04 12:15:27
comet_orbits 12245 2023-05-30 05:09:32 2023-05-30 05:31:04
identifications 611660 2023-05-29 12:06:10 2023-05-29 12:06:10
isolated_tracklets 40161554 2023-05-30 10:58:32 2023-05-30 10:58:32
mpc_indices 396 2023-05-30 17:00:05 2023-05-30 17:00:05
numbered_identifications 1000438 2023-04-21 05:37:41 2023-04-21 05:37:41
numbered_mps 620108 2011-10-27 00:36:35 2023-05-26 17:36:43
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 386669307 2023-05-30 15:22:19 2023-05-30 15:22:19
orbit_uncertainties 787153 2019-06-03 12:14:53 2023-04-21 05:47:13
orbits 1284454 2023-05-30 15:22:24 2023-05-30 15:31:03
perturbed_orbits 175724170 2018-09-27 17:20:33 2018-09-27 17:20:33
radar_observations 1507 2019-05-30 03:12:41 2019-05-30 03:12:41
No change in Maria mpc_development database structure.

Postgres mpcbeta:

Table Count Created_at Updated_at
neocp_els 54 2023-05-27 07:21:25.998092 2023-05-30 17:18:22.439352
neocp_events 182149 2023-05-30 17:18:25.262286 2023-05-30 17:18:25.262286
neocp_obs_archive 475956 2023-05-30 17:18:22.434535 2023-05-30 17:18:22.434535
neocp_obs 734 2023-05-30 17:18:22.431153 2023-05-30 17:18:22.431153
neocp_prev_des 54028 2023-05-30 16:19:56.442957 2023-05-30 16:19:56.442957
neocp_var 101864 2023-05-30 17:18:25.230089 2023-05-30 17:18:25.230089
current_identifications 1812543 2023-05-30 13:41:52.426829 2023-05-30 17:11:17.89389
numbered_identifications 620865 2023-04-20 04:45:11.100617 2023-04-20 04:45:11.100617
primary_objects 1211321 2021-09-28 18:55:58.729643 2021-09-28 18:55:58.729643
No change to Postgres mpcbeta database structure

Postgres mpc_sbn:

Table Count Created_at Updated_at
neocp_els 54 2023-05-27 07:21:25.998092 2023-05-30 17:18:22.439352
neocp_events 182149 2023-05-30 17:18:25.262286 2023-05-30 17:18:25.262286
neocp_obs_archive 475956 2023-05-30 17:18:22.434535 2023-05-30 17:18:22.434535
neocp_obs 734 2023-05-30 17:18:22.431153 2023-05-30 17:18:22.431153
neocp_prev_des 54028 2023-05-30 16:19:56.442957 2023-05-30 16:19:56.442957
neocp_var 101864 2023-05-30 17:18:25.230089 2023-05-30 17:18:25.230089
current_identifications 1812543 2023-05-30 13:41:52.426829 2023-05-30 17:11:17.89389
numbered_identifications 620865 2023-04-20 04:45:11.100617 2023-04-20 04:45:11.100617
primary_objects 1341575 2023-05-30 16:19:31.613295 2023-05-30 16:19:31.613295
obs_sbn 395863683 2023-05-22 18:56:03.155628-04 2023-05-30 13:21:21.786499-04
obs_alterations_deletions 906180 2023-05-30 16:40:39.815808 2023-05-30 16:40:39.815808
obs_alterations_redesignations 2396 2023-05-26 15:10:51.15547 2023-05-26 15:10:51.15547
obs_alterations_unassociations 19176 2023-05-29 22:01:21.026704 2023-05-29 22:01:21.026704
mpc_orbits 1275587 2023-05-30 17:28:31.539972 2023-05-30 17:28:35.47953
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_marsden obs_sbn 395857530 2023-05-30 12:05:43.38574 2023-05-30 12:25:15.783031
MPC_mpcweb5 obs_sbn 395857655 2023-05-30 12:34:33.637 2023-05-30 12:35:15.343147
SBN_to_AWS obs_sbn 395857679 2023-05-30 12:42:00.561331 2023-05-30 12:42:10.212944
MPC_marsden current_identifications 1812374 2023-05-30 12:52:20.031081 2023-05-30 12:52:24.065929
MPC_mpcweb5 current_identifications 1812374 2023-05-30 12:52:20.031081 2023-05-30 12:52:24.598884
SBN_to_AWS current_identifications 1812374 2023-05-30 12:52:20.031081 2023-05-30 12:52:24.743037
MPC_marsden mpc_orbits 1275407 2023-05-30 12:51:54.137254 2023-05-30 12:52:24.982314
MPC_mpcweb5 mpc_orbits 1275407 2023-05-30 12:51:54.137254 2023-05-30 12:52:26.599534
SBN_to_AWS mpc_orbits 1275407 2023-05-30 12:51:54.137254 2023-05-30 12:52:26.759288
MPC_marsden numbered_identifications 620865 2023-04-20 04:45:11.100617 2023-05-30 12:52:26.957209
MPC_mpcweb5 numbered_identifications 620865 2023-04-20 04:45:11.100617 2023-05-30 12:52:27.168529
SBN_to_AWS numbered_identifications 620865 2023-04-20 04:45:11.100617 2023-05-30 12:52:27.274958
MPC_marsden neocp_els 53 2023-05-30 11:45:47.782862 2023-05-30 12:52:27.403267
MPC_mpcweb5 neocp_els 53 2023-05-30 11:45:47.782862 2023-05-30 12:52:27.482528
SBN_to_AWS neocp_els 53 2023-05-30 11:45:47.782862 2023-05-30 12:52:27.560263
MPC_marsden neocp_events 182103 2023-05-30 11:45:51.447388 2023-05-30 12:52:27.639888
MPC_mpcweb5 neocp_events 182103 2023-05-30 11:45:51.447388 2023-05-30 12:52:27.764658
SBN_to_AWS neocp_events 182103 2023-05-30 11:45:51.447388 2023-05-30 12:52:27.857126
MPC_marsden neocp_obs 726 2023-05-30 11:45:47.772374 2023-05-30 12:52:27.95331
MPC_mpcweb5 neocp_obs 726 2023-05-30 11:45:47.772374 2023-05-30 12:52:28.033366
SBN_to_AWS neocp_obs 726 2023-05-30 11:45:47.772374 2023-05-30 12:52:28.111361
MPC_marsden neocp_obs_archive 475935 2023-05-30 11:45:47.777844 2023-05-30 12:52:28.190629
MPC_mpcweb5 neocp_obs_archive 475935 2023-05-30 11:45:47.777844 2023-05-30 12:52:28.369417
SBN_to_AWS neocp_obs_archive 475935 2023-05-30 11:45:47.777844 2023-05-30 12:52:28.462562
MPC_marsden neocp_prev_des 54027 2023-05-30 11:08:43.39271 2023-05-30 12:52:28.574802
MPC_mpcweb5 neocp_prev_des 54027 2023-05-30 11:08:43.39271 2023-05-30 12:52:28.677046
SBN_to_AWS neocp_prev_des 54027 2023-05-30 11:08:43.39271 2023-05-30 12:52:28.762222
MPC_marsden neocp_var 97720 2023-05-30 11:45:51.420906 2023-05-30 12:52:28.848203
MPC_mpcweb5 neocp_var 97720 2023-05-30 11:45:51.420906 2023-05-30 12:52:28.974194
SBN_to_AWS neocp_var 97720 2023-05-30 11:45:51.420906 2023-05-30 12:52:29.074741
MPC_marsden primary_objects 1341406 2023-05-30 12:52:20.01741 2023-05-30 12:52:29.171582
MPC_mpcweb5 primary_objects 1341406 2023-05-30 12:52:20.01741 2023-05-30 12:52:29.530853
SBN_to_AWS primary_objects 1341406 2023-05-30 12:52:20.01741 2023-05-30 12:52:29.666005
MPC_marsden obs_alterations_corrections 2023-05-30 12:52:29.876196
MPC_mpcweb5 obs_alterations_corrections 2023-05-30 12:52:29.956036
SBN_to_AWS obs_alterations_corrections 2023-05-30 12:52:30.033727
MPC_marsden obs_alterations_deletions 906176 2023-05-29 22:01:14.000798 2023-05-30 12:52:30.112582
MPC_mpcweb5 obs_alterations_deletions 906176 2023-05-29 22:01:14.000798 2023-05-30 12:52:30.614257
SBN_to_AWS obs_alterations_deletions 906176 2023-05-29 22:01:14.000798 2023-05-30 12:52:30.725211
MPC_marsden obs_alterations_redesignations 2396 2023-05-26 15:10:51.15547 2023-05-30 12:52:30.869086
MPC_mpcweb5 obs_alterations_redesignations 2396 2023-05-26 15:10:51.15547 2023-05-30 12:52:30.950618
SBN_to_AWS obs_alterations_redesignations 2396 2023-05-26 15:10:51.15547 2023-05-30 12:52:31.028796