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

database insert failure because of dependencies? #12

Open
MxmUrw opened this issue Dec 8, 2022 · 1 comment
Open

database insert failure because of dependencies? #12

MxmUrw opened this issue Dec 8, 2022 · 1 comment
Labels
bug Something isn't working

Comments

@MxmUrw
Copy link
Contributor

MxmUrw commented Dec 8, 2022

We get:

dpsa4fl-janus-tasks2_1  | Running taskprovision server
dpsa4fl-janus-tasks1_1  | Running taskprovision server
dpsa4fl-janus-tasks1_1  | creating training session with id 18328
dpsa4fl-janus-tasks2_1  | creating training session with id 18328
dpsa4fl-janus-tasks1_1  | provisioning task now with id 7nWLxhZ9Er7VCZLm1BPdJa6GRSoYZlX0ZpGe6jc7s6o
dpsa4fl-janus-tasks2_1  | provisioning task now with id 7nWLxhZ9Er7VCZLm1BPdJa6GRSoYZlX0ZpGe6jc7s6o
db1_1                   | 2022-12-08 05:39:37.253 UTC [36] ERROR:  could not serialize access due to read/write dependencies among transactions
db1_1                   | 2022-12-08 05:39:37.253 UTC [36] DETAIL:  Reason code: Canceled on identification as a pivot, during write.
db1_1                   | 2022-12-08 05:39:37.253 UTC [36] HINT:  The transaction might succeed if retried.
db1_1                   | 2022-12-08 05:39:37.253 UTC [36] STATEMENT:  INSERT INTO client_reports
db1_1                   | 	                (task_id, report_id, client_timestamp, extensions, public_share, input_shares)
db1_1                   | 	            VALUES ((SELECT id FROM tasks WHERE task_id = $1), $2, $3, $4, $5, $6)
aggregator1_1           | {"timestamp":"2022-12-08T05:39:37.254804Z","level":"ERROR","fields":{"error":"DB error: db error: ERROR: could not serialize access due to read/write dependencies among transactions\nDETAIL: Reason code: Canceled on identification as a pivot, during write.\nHINT: The transaction might succeed if retried."},"target":"janus_aggregator::datastore","filename":"aggregator/src/datastore.rs","line_number":885,"threadId":"ThreadId(8)"}
aggregator1_1           | {"timestamp":"2022-12-08T05:39:37.254850Z","level":"ERROR","fields":{"error":"DB error: db error: ERROR: could not serialize access due to read/write dependencies among transactions\nDETAIL: Reason code: Canceled on identification as a pivot, during write.\nHINT: The transaction might succeed if retried."},"target":"janus_aggregator::datastore","filename":"aggregator/src/datastore.rs","line_number":122,"threadId":"ThreadId(8)"}
@MxmUrw MxmUrw converted this from a draft issue Dec 8, 2022
@MxmUrw MxmUrw added the bug Something isn't working label Dec 8, 2022
@MxmUrw
Copy link
Contributor Author

MxmUrw commented Dec 19, 2022

Interestingly enough, aggregation always succeeds. It might be that this error is irrelevant?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
Status: Todo
Development

No branches or pull requests

1 participant