# DALQueryError: Query Error: Qserv request failed: error:

**URL:** <https://www.rubin.community/t/dalqueryerror-query-error-qserv-request-failed-error/10426>\
**Category:** Support\
**Tags:** dp1\
**Created:** [July 1, 2025, 12:06am UTC](https://www.rubin.community/t/dalqueryerror-query-error-qserv-request-failed-error/10426 "2025-07-01T00:06:26Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![steventgk](https://sea2.discourse-cdn.com/flex002/user_avatar/www.rubin.community/steventgk/32/2772_2.png) [@steventgk](https://www.rubin.community/u/steventgk)\
**Post date:** [July 1, 2025, 12:06am UTC](https://www.rubin.community/t/dalqueryerror-query-error-qserv-request-failed-error/10426/1 "2025-07-01T00:06:27Z")

</div>

Hi Folks,

Thank you for your excellent work on DP1, the related paper, and tutorials.

This is also related to [DALServiceError DALQueryError with user-uploaded table](http://www.rubin.community/t/dalserviceerror-dalqueryerror-with-user-uploaded-table/10257/12), running the same query with an uploaded user table for DP1, I get this new error, and I am not sure how to proceed:

```python
---------------------------------------------------------------------------
DALQueryError Traceback (most recent call last)
Cell In[54], line 1
----> 1 job.raise_if_error()

File /opt/lsst/software/stack/conda/envs/lsst-scipipe-10.0.0/lib/python3.12/site-packages/pyvo/dal/tap.py:1018, in AsyncTAPJob.raise_if_error(self)
   1016 msg = self._job.errorsummary.message.content
   1017 msg = msg or "<No useful error from server>"
-> 1018 raise DALQueryError("Query Error: " + msg, self.url)

DALQueryError: Query Error: Qserv request failed: error: invalid parameters of the request, ex: CONFIG addDatabaseFamily the family 'layout_340_3' already exists.

{'method': 'POST', 'timeout_sec': 300, 'url': 'http://172.24.49.51:25081/ingest/database'}

```

---

<div class="post-metadata">

**Author:** ![MelissaGraham](https://sea2.discourse-cdn.com/flex002/user_avatar/www.rubin.community/melissagraham/32/2549_2.png) [@MelissaGraham](https://www.rubin.community/u/MelissaGraham)\
**Post date:** [July 1, 2025, 2:12am UTC](https://www.rubin.community/t/dalqueryerror-query-error-qserv-request-failed-error/10426/2 "2025-07-01T02:12:27Z")

</div>

Hi @steventgk, thanks for posting this. Could you add what time today you encountered this error and if it was persistent? Sometimes timeouts are temporary.

---

<div class="post-metadata">

**Author:** ![frossie](https://sea2.discourse-cdn.com/flex002/user_avatar/www.rubin.community/frossie/32/9_2.png) [@frossie](https://www.rubin.community/u/frossie)\
**Post date:** [July 1, 2025, 5:01am UTC](https://www.rubin.community/t/dalqueryerror-query-error-qserv-request-failed-error/10426/3 "2025-07-01T05:01:37Z")

</div>

We see the issue. Trying to fix it without causing an outage first, if that doesn’t work we’ll fix it the hard way.

Thanks for the report, that was a hole in our monitoring. We try to find these things before you do.

---

<div class="post-metadata">

**Author:** ![frossie](https://sea2.discourse-cdn.com/flex002/user_avatar/www.rubin.community/frossie/32/9_2.png) [@frossie](https://www.rubin.community/u/frossie)\
**Post date:** [July 1, 2025, 6:09am UTC](https://www.rubin.community/t/dalqueryerror-query-error-qserv-request-failed-error/10426/4 "2025-07-01T06:09:07Z")

</div>

(deleting previous reply)

Sorry we thought we had it but we should complete more testing, and we’re keeling over at this point (long day!). Apologies for this, we’ll fix it with fresh brains tomorrow.

---

<div class="post-metadata">

**Author:** ![steventgk](https://sea2.discourse-cdn.com/flex002/user_avatar/www.rubin.community/steventgk/32/2772_2.png) [@steventgk](https://www.rubin.community/u/steventgk)\
**Post date:** [July 1, 2025, 12:28pm UTC](https://www.rubin.community/t/dalqueryerror-query-error-qserv-request-failed-error/10426/5 "2025-07-01T12:28:02Z")

</div>

Just wanted to say thank you for your efforts on this! Getting DP1 out with all the stretch goals, tutorials and infrastructure is amazing!

---

<div class="post-metadata">

**Author:** ![frossie](https://sea2.discourse-cdn.com/flex002/user_avatar/www.rubin.community/frossie/32/9_2.png) [@frossie](https://www.rubin.community/u/frossie)\
**Post date:** [July 1, 2025, 5:48pm UTC](https://www.rubin.community/t/dalqueryerror-query-error-qserv-request-failed-error/10426/6 "2025-07-01T17:48:46Z")

</div>

It is a truth universally acknowledged that developer velocity increases 1% with every compliment, keep it coming 🙂

On a more serious but happy note, we have deployed a no-downtime fix to data.lsst.cloud (pesky double-float conversion mismatch between systems, annoying how these pass their tests until they don’t). Try it and let us know how you got on.

---

<div class="post-metadata">

**Author:** ![MelissaGraham](https://sea2.discourse-cdn.com/flex002/user_avatar/www.rubin.community/melissagraham/32/2549_2.png) [@MelissaGraham](https://www.rubin.community/u/MelissaGraham)\
**Post date:** [July 2, 2025, 3:15pm UTC](https://www.rubin.community/t/dalqueryerror-query-error-qserv-request-failed-error/10426/7 "2025-07-02T15:15:19Z")

</div>

@steventgk if you could confirm that the issue is fixed, we can mark this topic as solved?

---

<div class="post-metadata">

**Author:** ![steventgk](https://sea2.discourse-cdn.com/flex002/user_avatar/www.rubin.community/steventgk/32/2772_2.png) [@steventgk](https://www.rubin.community/u/steventgk)\
**Post date:** [July 2, 2025, 8:35pm UTC](https://www.rubin.community/t/dalqueryerror-query-error-qserv-request-failed-error/10426/8 "2025-07-02T20:35:51Z")

</div>

Hi @MelissaGraham and @frossie, thanks again for getting back to me about this! Unfortunately, I have probably produced a query that returns no results, but it ran to ‘Job Complete’ for a significant time with no errors.

I would likely argue that my query was ambitious, and I should expect a null result; therefore, I am fairly confident that your fix does work, it’s just my bad science!

---

<div class="post-metadata">

**Author:** ![MelissaGraham](https://sea2.discourse-cdn.com/flex002/user_avatar/www.rubin.community/melissagraham/32/2549_2.png) [@MelissaGraham](https://www.rubin.community/u/MelissaGraham)\
**Post date:** [July 3, 2025, 2:35am UTC](https://www.rubin.community/t/dalqueryerror-query-error-qserv-request-failed-error/10426/9 "2025-07-03T02:35:43Z")

</div>

OK thank you @steventgk ! If you change your mind about the query and think it really should have produced a non-null result, we’d love to see it as an example in a new topic. We’re always learning from user queries (and we like to help!).
