Ticket #275 (closed problem: fixed)

Opened 3 months ago

Last modified 3 months ago

Stereo data not showing past ~11/22/17

Reported by: jacob Owned by: jacob
Priority: high Milestone:
Component: DP:SSC Version: 1.4
Severity: normal Keywords:
Cc: ed

Description

Data for SECCHI, PLASTIC, IMPACT, and SWAVES is not presenting on the VSO. All update scripts are called by the same cron job. All operate through the stereo5 data mount, though the mount doesn't seem to be the issue, the volumes behind them are nearly full.

Change History

comment:1 Changed 3 months ago by jacob

Issue found with usr/local/scripts/ssc_catalog/_stereo_update.sql. At some point the script ran only partially successfully, leaving tables which should have been dropped or renamed in the database. Commenting out certain drop and rename statements will allow the script to run.

Last edited 3 months ago by jacob (previous) (diff)

comment:2 Changed 3 months ago by jacob

Problem solved: _stereo_update.sql takes a very long time to run, it is believable that the script was interrupted, maybe even by a person who'd thought it was hanging. _stereo_update.sql was reverted to its previous working version and lines were added to update.sh to harden against future occurrence of this issue.

comment:3 Changed 3 months ago by jacob

  • Status changed from new to closed
  • Resolution set to fixed
Note: See TracTickets for help on using tickets.