René's URL Explorer Experiment


Title: Bug: Pagination breaks if the row used as cursor is deleted · Issue #1357 · coder/coder · GitHub

Open Graph Title: Bug: Pagination breaks if the row used as cursor is deleted · Issue #1357 · coder/coder

X Title: Bug: Pagination breaks if the row used as cursor is deleted · Issue #1357 · coder/coder

Description: This issue was pointed out by @spikecurtis in #1308 (comment). Steps to Reproduce Set up coder server Request a user or template version with the after_id: GET 'http://localhost:3000/api/v2/templates/b60ecd72-9b8a-492b-b30d-077cbee5e550/...

Open Graph Description: This issue was pointed out by @spikecurtis in #1308 (comment). Steps to Reproduce Set up coder server Request a user or template version with the after_id: GET 'http://localhost:3000/api/v2/templat...

X Description: This issue was pointed out by @spikecurtis in #1308 (comment). Steps to Reproduce Set up coder server Request a user or template version with the after_id: GET 'http://localhost:3000/api/v2/tem...

Opengraph URL: https://github.com/coder/coder/issues/1357

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Bug: Pagination breaks if the row used as cursor is deleted","articleBody":"This issue was pointed out by @spikecurtis in https://github.com/coder/coder/pull/1308#discussion_r866142137.\r\n\r\n## Steps to Reproduce\r\n\r\n1. Set up coder server\r\n2. Request a user or template version with the `after_id`: `GET 'http://localhost:3000/api/v2/templates/b60ecd72-9b8a-492b-b30d-077cbee5e550/versions?limit=1&after_id=49993e4e-a42f-40f3-96a8-636ac765833c'`\r\n3. Delete the template version row in the database where `id = '49993e4e-a42f-40f3-96a8-636ac765833c'`\r\n4. Redo step 2\r\n\r\n## Expected\r\n\r\nThe API would return an error, all results or metadata related to pagination.\r\n\r\n## Actual\r\n\r\nThe API returns no results.\r\n\r\n## Notes\r\n\r\nWe're not actively using pagination yet, so this is not an immediate problem and it may not ever be a problem for the aforementioned endpoints, but it's one that we should account for. The solution could be to either never delete rows from the database (only mark as deleted) or to query the database to verify that the cursor exists, either as part of the pagination query or separately.\r\n\r\nKeep solution as simple as possible. Throw an error if you get into a situation like this. ","author":{"url":"https://github.com/mafredri","@type":"Person","name":"mafredri"},"datePublished":"2022-05-10T08:01:59Z","url":"https://github.com/coder/coder/issues/1357"}

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format)
route-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:4f4147bb-2f9b-f939-ee44-8c1f8f79c036
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idDF04:172B92:1F0A11B:2955C84:6B0176BE
html-safe-noncebb4a177fc1c75d7d4742a26cba9e0523cd9ff58c795c810a0871801bce11e015
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJERjA0OjE3MkI5MjoxRjBBMTFCOjI5NTVDODQ6NkIwMTc2QkUiLCJ2aXNpdG9yX2lkIjoiNDE4MTY4NzcxNTc1MTg4NDQ3OCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac5d1b7c7d2b9eacd9d5145235b1af1c565292d600568098642038880e61a333ca
hovercard-subject-tagissue:1230772109
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/coder/coder/1357/issue_layout
twitter:imagehttps://opengraph.githubassets.com/9ebf75e360963618d778f1ea689bd0dc512c407714f68cd8557ac9a28ff15337/coder/coder/issues/1357
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/9ebf75e360963618d778f1ea689bd0dc512c407714f68cd8557ac9a28ff15337/coder/coder/issues/1357
og:image:altThis issue was pointed out by @spikecurtis in #1308 (comment). Steps to Reproduce Set up coder server Request a user or template version with the after_id: GET 'http://localhost:3000/api/v2/templat...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamemafredri
hostnamegithub.com
expected-hostnamegithub.com
Nonecc5dfdd32f62ebd3223cab3af3aa2b268d3605218237326a48a99d1efd89495c
turbo-cache-controlno-preview
go-importgithub.com/coder/coder git https://github.com/coder/coder.git
octolytics-dimension-user_id95932066
octolytics-dimension-user_logincoder
octolytics-dimension-repository_id440752086
octolytics-dimension-repository_nwocoder/coder
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id440752086
octolytics-dimension-repository_network_root_nwocoder/coder
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release8c77c9e8439031ad54c75a250694842892f693e1
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/coder/coder/issues/1357#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fcoder%2Fcoder%2Fissues%2F1357
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fcoder%2Fcoder%2Fissues%2F1357
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=coder%2Fcoder
Reloadhttps://github.com/coder/coder/issues/1357
Reloadhttps://github.com/coder/coder/issues/1357
Reloadhttps://github.com/coder/coder/issues/1357
coderhttps://github.com/coder
coderhttps://github.com/coder/coder
Codehttps://github.com/coder/coder
Issues320 (320)https://github.com/coder/coder/issues
Pull requests470 (470)https://github.com/coder/coder/pulls
Discussionshttps://github.com/coder/coder/discussions
Actionshttps://github.com/coder/coder/actions
Projectshttps://github.com/coder/coder/projects
Security and quality49 (49)https://github.com/coder/coder/security
Insightshttps://github.com/coder/coder/insights
https://github.com/coder/coder
New issuehttps://github.com/login?return_to=https://github.com/coder/coder/issues/1357
New issuehttps://github.com/login?return_to=https://github.com/coder/coder/issues/1357
Bug: Pagination breaks if the row used as cursor is deletedhttps://github.com/coder/coder/issues/1357#top
https://github.com/Emyrk
apiArea: HTTP APIhttps://github.com/coder/coder/issues?q=state%3Aopen%20label%3A%22api%22
Community MVPhttps://github.com/coder/coder/milestone/2
https://github.com/mafredri
mafredrihttps://github.com/mafredri
on May 10, 2022https://github.com/coder/coder/issues/1357#issue-1230772109
@spikecurtishttps://github.com/spikecurtis
#1308 (comment)https://github.com/coder/coder/pull/1308#discussion_r866142137
mafredrihttps://github.com/mafredri
bug 🐛https://github.com/coder/coder/issues?q=state%3Aopen%20label%3A%22bug%20%3Abug%3A%22
apiArea: HTTP APIhttps://github.com/coder/coder/issues?q=state%3Aopen%20label%3A%22api%22
on May 10, 2022https://github.com/coder/coder/issues/1357#event-6579679604
missknisshttps://github.com/misskniss
needs grooming 🪒https://github.com/coder/coder/issues?q=state%3Aopen%20label%3A%22needs%20grooming%20%3Arazor%3A%22
on May 12, 2022https://github.com/coder/coder/issues/1357#event-6595272722
https://github.com/tjcran
tjcranhttps://github.com/tjcran
on May 16, 2022https://github.com/coder/coder/issues/1357#issuecomment-1127210836
tjcranhttps://github.com/tjcran
Community MVP 🏁https://github.com/coder/coder/issues?q=state%3Aopen%20label%3A%22Community%20MVP%20%3Acheckered_flag%3A%22
needs grooming 🪒https://github.com/coder/coder/issues?q=state%3Aopen%20label%3A%22needs%20grooming%20%3Arazor%3A%22
on May 16, 2022https://github.com/coder/coder/issues/1357#event-6612882848
tjcranhttps://github.com/tjcran
Community MVPhttps://github.com/coder/coder/milestone/2
on May 16, 2022https://github.com/coder/coder/issues/1357#event-6612883164
missknisshttps://github.com/misskniss
needs grooming 🪒https://github.com/coder/coder/issues?q=state%3Aopen%20label%3A%22needs%20grooming%20%3Arazor%3A%22
on May 17, 2022https://github.com/coder/coder/issues/1357#event-6625308491
https://github.com/Emyrk
Emyrkhttps://github.com/Emyrk
on May 17, 2022https://github.com/coder/coder/issues/1357#issuecomment-1129011329
missknisshttps://github.com/misskniss
Emyrkhttps://github.com/Emyrk
on May 17, 2022https://github.com/coder/coder/issues/1357#event-6625547611
missknisshttps://github.com/misskniss
needs grooming 🪒https://github.com/coder/coder/issues?q=state%3Aopen%20label%3A%22needs%20grooming%20%3Arazor%3A%22
on May 17, 2022https://github.com/coder/coder/issues/1357#event-6625552384
https://github.com/Emyrk
Emyrkhttps://github.com/Emyrk
on Jun 2, 2022https://github.com/coder/coder/issues/1357#issuecomment-1144952260
#1947https://github.com/coder/coder/pull/1947
Emyrkhttps://github.com/Emyrk
completedhttps://github.com/coder/coder/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Jun 2, 2022https://github.com/coder/coder/issues/1357#event-6729025337
Sign up for freehttps://github.com/signup?return_to=https://github.com/coder/coder/issues/1357
Sign in to commenthttps://github.com/login?return_to=https://github.com/coder/coder/issues/1357
Emyrkhttps://github.com/Emyrk
apiArea: HTTP APIhttps://github.com/coder/coder/issues?q=state%3Aopen%20label%3A%22api%22
Community MVPhttps://github.com/coder/coder/milestone/2
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.