Title: Transaction timeout during checksum computation for large filepath fields · Issue #1386 · datajoint/datajoint-python · GitHub
Open Graph Title: Transaction timeout during checksum computation for large filepath fields · Issue #1386 · datajoint/datajoint-python
X Title: Transaction timeout during checksum computation for large filepath fields · Issue #1386 · datajoint/datajoint-python
Description: Problem In three-part make() methods, the transaction can expire while checksums are computed for large files with filepath fields. This causes the entire make() to fail, not just a performance degradation. The checksum computation for l...
Open Graph Description: Problem In three-part make() methods, the transaction can expire while checksums are computed for large files with filepath fields. This causes the entire make() to fail, not just a performance deg...
X Description: Problem In three-part make() methods, the transaction can expire while checksums are computed for large files with filepath fields. This causes the entire make() to fail, not just a performance deg...
Opengraph URL: https://github.com/datajoint/datajoint-python/issues/1386
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Transaction timeout during checksum computation for large filepath fields","articleBody":"## Problem\n\nIn three-part `make()` methods, the transaction can expire while checksums are computed for large files with `filepath` fields. This causes the entire `make()` to fail, not just a performance degradation.\n\nThe checksum computation for large files takes long enough that the database transaction times out before the insert can complete.\n\n## Context\n\nThis affects the 0.14.x branch. The issue occurs when:\n- Working with large files (videos, imaging data, etc.)\n- Using filepath attributes that reference these large files\n- The checksum computation happens within the transaction\n- Computation time exceeds the transaction timeout\n\n## Impact\n\n- `make()` fails entirely for large files\n- Data that was already computed is lost\n- Users cannot reliably use filepath fields with large files\n\n## Branch\n\n`maint/0.14`\n\n## Note\n\nThis will be addressed differently in DataJoint 2.0+.","author":{"url":"https://github.com/dimitri-yatsenko","@type":"Person","name":"dimitri-yatsenko"},"datePublished":"2026-02-05T19:00:32.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/1386/datajoint-python/issues/1386"}
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:c73a9ac2-d1c7-0cf5-97ba-5c4dddeba8fe |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | A8B6:3974FE:5E531A:7E1577:6A4DA558 |
| html-safe-nonce | b71e00fa516ee3ce1947aa60b8dfbcc529ec103ac43ca743eae314d7db2b676a |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBOEI2OjM5NzRGRTo1RTUzMUE6N0UxNTc3OjZBNERBNTU4IiwidmlzaXRvcl9pZCI6IjUwMTk3ODQ5NDc4NjQyODI0NTYiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 335579aa0887329a3ce8576d45b974136ddae5329fc4262f94daa781cc87e997 |
| hovercard-subject-tag | issue:3903075532 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/datajoint/datajoint-python/1386/issue_layout |
| twitter:image | https://opengraph.githubassets.com/0f13374ddb191825efd1da39d824f257c492b311a50f15ad4788c1059ceabefc/datajoint/datajoint-python/issues/1386 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/0f13374ddb191825efd1da39d824f257c492b311a50f15ad4788c1059ceabefc/datajoint/datajoint-python/issues/1386 |
| og:image:alt | Problem In three-part make() methods, the transaction can expire while checksums are computed for large files with filepath fields. This causes the entire make() to fail, not just a performance deg... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | dimitri-yatsenko |
| hostname | github.com |
| expected-hostname | github.com |
| None | 06b8a6144231bf3a234f1c2e9993861e07ce98a905912b114aa386c2d7e84b33 |
| turbo-cache-control | no-preview |
| go-import | github.com/datajoint/datajoint-python git https://github.com/datajoint/datajoint-python.git |
| octolytics-dimension-user_id | 2375501 |
| octolytics-dimension-user_login | datajoint |
| octolytics-dimension-repository_id | 5866704 |
| octolytics-dimension-repository_nwo | datajoint/datajoint-python |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 5866704 |
| octolytics-dimension-repository_network_root_nwo | datajoint/datajoint-python |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 7f13faa65cccc9b729d674da83335d5dcfdfd193 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width