Uploaded image for project: 'Instrument control development'
  1. Instrument control development
  2. INSTRM-2364

Check agc_data insert, and catch/report psycopg2 errors

    XMLWordPrintable

    Details

      Description

      The following insert failed due to invalid data. Worse, the insert is being run in such a way that the failure is neither reported, nor rolled back. So the actor could then never insert again, And the callers had no idea why.

      2024-09-02 22:16:09.212 HST [321513] ERROR:  column "nan" does not exist at character 558
2024-09-02 22:16:09.212 HST [321513] STATEMENT:  INSERT INTO agc_data (agc_exposure_id, agc_camera_id, spot_id, image_moment_00_pix,
	        centroid_x_pix, centroid_y_pix, central_image_moment_20_pix,central_image_moment_11_pix,
	        central_image_moment_02_pix,peak_pixel_x_pix, peak_pixel_y_pix, peak_intensity, background,
	        estimated_magnitude, flags)  VALUES(606520, 5, 5,
	            -2.45703125, 647.43603515625, 936.2976684570312,
	            -24.042179107666016, -4.921999454498291,
	            4.560703754425049,
	            649, 943,
	            11.28125, 64380.71875,
	            nan, 13)

        Attachments

          Activity

            People

            • Assignee:
              chyan chyan
              Reporter:
              cloomis cloomis
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: