Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Mysql verb starts failing: "query address for prices not found" #4839

Open
matt2e opened this issue Mar 12, 2025 · 0 comments
Open

Mysql verb starts failing: "query address for prices not found" #4839

matt2e opened this issue Mar 12, 2025 · 0 comments
Labels
triage Issue needs triaging

Comments

@matt2e
Copy link
Collaborator

matt2e commented Mar 12, 2025

I have a module called stockdb with a storePrice verb which uses a mysql db and a query verb called insertStockPrice
This module is dependant on stocks, which periodically publishes to a topic that stockdb.storePrice consumes from.
I updated the code in stocks which caused a redeploy of stockdb.
After the redeploy I start getting these errors each time the sql verb is called:

error:stockdb:runner13: Call to deployments dpl-stockdb-26pnv7m4tewzljnk failed: call to verb stockdb.insertStockPrice failed: query address for prices not found
error:stockdb:runner13: Call to deployments dpl-stockdb-26pnv7m4tewzljnk failed: call to verb stockdb.storePrice failed: stockdb.insertStockPrice: call to verb stockdb.insertStockPrice failed: query address for prices not found

I've seen this twice in the last 2 days.

log.json

Here's the queries file:

-- name: InsertStockPrice :exec
INSERT INTO stock_prices (
    symbol,
    price,
    timestamp
) VALUES (?, ?, ?);

-- name: GetLatestPrices :many
SELECT symbol, price, timestamp
FROM stock_prices
WHERE symbol = ?
ORDER BY timestamp DESC
LIMIT 10;
@github-actions github-actions bot added the triage Issue needs triaging label Mar 12, 2025
@matt2e matt2e changed the title Mysql verb starts failing "query address for prices not found" Mysql verb starts failing: "query address for prices not found" Mar 12, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
triage Issue needs triaging
Projects
None yet
Development

No branches or pull requests

1 participant