You need to sign in or sign up before continuing.

Creation of new flag in RL8 fails

Running a command to create and publish to a new flag on an RL8 system (e.g., using the test suite to publish from segments-dev to segments-rl8) produces an error and fails.

Example: Running this: ligolw_segment_insert_dqsegdb --insert --segment-url=http://segments-rl8.ldas.cit --ifos=G1 --name=TEST_FLAG_GPS_TIME_1369765890 --version=1 -S /home/detchar/dqsegdb/known_segments_test_file.txt -G /home/detchar/dqsegdb/active_segments_test_file.txt --explain="This is a test flag published by test_segments_machine.sh on detchar-cit in a run started at GPS time 1369765890." --comment="This is a test flag published by test_segments_machine.sh on detchar-cit in a run started at GPS time 1369765890." Produces this message, which is normal: /usr/lib/python3.6/site-packages/dqsegdb/urifunctions.py:307: UserWarning: Info: Flag does not exist in database yet for URL: http://segments-rl8.ldas.cit/dq/G1/TEST_FLAG_GPS_TIME_1369765890/1, then several stack traces that end with the same error:

Traceback (most recent call last):
  File "/usr/lib/python3.6/site-packages/dqsegdb/apicalls.py", line 675, in patchWithFailCases
    patchDataUrllib2(url,data,logger=inlogger)
  File "/usr/lib/python3.6/site-packages/dqsegdb/urifunctions.py", line 270, in patchDataUrllib2
    urlreturned = urllib_request.urlopen(request, timeout=timeout, **urlopen_kw)
[...]
  File "/usr/lib64/python3.6/urllib/request.py", line 650, in http_error_default
    raise HTTPError(req.full_url, code, msg, hdrs, fp)
urllib.error.HTTPError: HTTP Error 404: Not Found

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3.6/site-packages/dqsegdb/apicalls.py", line 687, in patchWithFailCases
    putDataUrllib2(url,data,logger=inlogger)
  File "/usr/lib/python3.6/site-packages/dqsegdb/urifunctions.py", line 205, in putDataUrllib2
    urlreturned = urllib_request.urlopen(request, timeout=timeout, **urlopen_kw)
[...]
  File "/usr/lib64/python3.6/urllib/request.py", line 650, in http_error_default
    raise HTTPError(req.full_url, code, msg, hdrs, fp)
urllib.error.HTTPError: HTTP Error 404: Not Found

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/bin/ligolw_segment_insert_dqsegdb", line 438, in <module>
    publishAndExit(filepath,debug)
  File "/bin/ligolw_segment_insert_dqsegdb", line 175, in publishAndExit
    result=callInsertMultipleDQXMLThreaded(filepath,debug)
  File "/bin/ligolw_segment_insert_dqsegdb", line 197, in callInsertMultipleDQXMLThreaded
    result=apicalls.InsertMultipleDQXMLFileThreaded(infiles,logger,options.segment_url,hackDec11=False,debug=debug,threads=1)
  File "/usr/lib/python3.6/site-packages/dqsegdb/apicalls.py", line 1085, in InsertMultipleDQXMLFileThreaded
    patchWithFailCases(i,url,debug,logger,testing_options)
  File "/usr/lib/python3.6/site-packages/dqsegdb/apicalls.py", line 701, in patchWithFailCases
    putDataUrllib2(url,data,logger=inlogger)
  File "/usr/lib/python3.6/site-packages/dqsegdb/urifunctions.py", line 205, in putDataUrllib2
    urlreturned = urllib_request.urlopen(request, timeout=timeout, **urlopen_kw)
[...]
  File "/usr/lib64/python3.6/urllib/request.py", line 650, in http_error_default
    raise HTTPError(req.full_url, code, msg, hdrs, fp)
urllib.error.HTTPError: HTTP Error 404: Not Found

An example of this occurred at 11:35:55 PDT on 2023.06.02, attempting to publish the above flag, G1:TEST_FLAG_GPS_TIME_1369765890:1.

There are no particularly insightful messages in internal_access_log or internal_error_log on segments-rl8, but a Python server log (such as /opt/dqsegdb/python_server/logs/2023-06-02.log, for the example mentioned above) has this important line: 2023-06-02 11:35:55,746:CRITICAL:PUT /dq/G1/TEST_FLAG_GPS_TIME_1369765890 - Problem with ODBC statement execution (('HY000', "[HY000] [ma-3.1.12][10.3.35-MariaDB]Field 'dq_flag_assoc_versions' doesn't have a default value (1364) (SQLExecDirectW)"))