{"id":120313,"recorded_at":"2026-10-26T14:40:17.647416Z","observed_at":"2026-10-26T14:40:17.647364Z","subject_kind":"source_record","subject":"x402_bazaar:https://saylorinnovations.com/api/kb/sqlalchemy-detached-instance-session-errors","kind":"listing","method":"baseline/1","body":{"endpoints":[["x402","https://saylorinnovations.com/api/kb/sqlalchemy-detached-instance-session-errors"]],"name":"Saylor Innovations Guide Library","owner_address":"0xa2a8df0f7caabea4e120a2568118f141569fc8aa","raw":{"accepts":[{"amount":"10000","asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","extra":{"assetTransferMethod":"eip3009","facilitatorOnly":true,"memo":"saylor:sqlalchemy-detached-insta","name":"USD Coin","note":"Base settles through an x402 facilitator. Send payload.signature and payload.authorization (EIP-3009); there is no self-submitted path on this network.","version":"2"},"maxTimeoutSeconds":120,"network":"eip155:8453","payTo":"0xA2A8dF0f7CaaBEa4e120a2568118f141569fc8aa","scheme":"exact"},{"amount":"10000","asset":"0x3c499c542cEF5E3811e1192ce70d8cC03d5c3359","extra":{"assetTransferMethod":"eip3009","facilitatorOnly":true,"memo":"saylor:sqlalchemy-detached-insta","name":"USD Coin","note":"Polygon settles through an x402 facilitator. Send payload.signature and payload.authorization (EIP-3009); there is no self-submitted path on this network.","version":"2"},"maxTimeoutSeconds":120,"network":"eip155:137","payTo":"0xA2A8dF0f7CaaBEa4e120a2568118f141569fc8aa","scheme":"exact"},{"amount":"10000","asset":"0xaf88d065e77c8cC2239327C5EDb3A432268e5831","extra":{"assetTransferMethod":"eip3009","facilitatorOnly":true,"memo":"saylor:sqlalchemy-detached-insta","name":"USD Coin","note":"Arbitrum settles through an x402 facilitator. Send payload.signature and payload.authorization (EIP-3009); there is no self-submitted path on this network.","version":"2"},"maxTimeoutSeconds":120,"network":"eip155:42161","payTo":"0xA2A8dF0f7CaaBEa4e120a2568118f141569fc8aa","scheme":"exact"},{"amount":"10000","asset":"EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v","extra":{"feePayer":"BFK9TLC3edb13K6v4YyH3DwPb5DSUpkWvb7XnqCL9b4F","memo":"saylor:sqlalchemy-detached-insta","reference":"5aSEaTa1sTZrQdgCBfSYk36mFFi43RcpsiE9aQBhgAUp","session":"eyJhcnRpY2xlSWQiOiJzcWxhbGNoZW15LWRldGFjaGVkLWluc3RhbmNlLXNlc3Npb24tZXJyb3JzIiwicmVmZXJlbmNlIjoiNWFTRWFUYTFzVFpyUWRnQ0JmU1lrMzZtRkZpNDNSY3BzaUU5YVFCaGdBVXAiLCJyZWNpcGllbnQiOiI3TFNqZnJKZjhmTnNCOFZBOXU3TjNXRW4yNXNtUUxwb2IzU3Z5VXZYYWN5NyIsIm1pbnQiOiJFUGpGV2RkNUF1ZnFTU3FlTTJxTjF4enliYXBDOEc0d0VHR2tad3lURHQxdiIsIm1pbkFtb3VudCI6MTAwMDAsImV4cCI6MTc5Mjk2Mjc1OTYyN30.NdJyVUCj-3pvhZIgWv_pybH-2zXYKtK154hc81ZMzr8"},"maxTimeoutSeconds":120,"network":"solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp","payTo":"7LSjfrJf8fNsB8VA9u7N3WEn25smQLpob3SvyUvXacy7","scheme":"exact"},{"amount":"10000","asset":"Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB","extra":{"feePayer":"BFK9TLC3edb13K6v4YyH3DwPb5DSUpkWvb7XnqCL9b4F","memo":"saylor:sqlalchemy-detached-insta","reference":"5vS4QJPLPsudvgCDcnqCubTKVCHUUBJpdYVn6JkMHeFU","session":"eyJhcnRpY2xlSWQiOiJzcWxhbGNoZW15LWRldGFjaGVkLWluc3RhbmNlLXNlc3Npb24tZXJyb3JzIiwicmVmZXJlbmNlIjoiNXZTNFFKUExQc3VkdmdDRGNucUN1YlRLVkNIVVVCSnBkWVZuNkprTUhlRlUiLCJyZWNpcGllbnQiOiI3TFNqZnJKZjhmTnNCOFZBOXU3TjNXRW4yNXNtUUxwb2IzU3Z5VXZYYWN5NyIsIm1pbnQiOiJFczl2TUZyemFDRVJtSmZyRjRIMkZZRDRLQ29Oa1kxMU1jQ2U4QmVud05ZQiIsIm1pbkFtb3VudCI6MTAwMDAsImV4cCI6MTc5Mjk2Mjc1OTYyN30.YK6vmftXSyaqqxXaI1qw8fYKfINh06S1rtoGD80AHCo"},"maxTimeoutSeconds":120,"network":"solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp","payTo":"7LSjfrJf8fNsB8VA9u7N3WEn25smQLpob3SvyUvXacy7","scheme":"exact"},{"amount":"95509","asset":"So11111111111111111111111111111111111111112","extra":{"memo":"saylor:sqlalchemy-detached-insta","native":true,"note":"Native SOL: send lamports with a system transfer, not an SPL transfer. Price is quoted live and this quote expires in 120s.","quotedLamports":"98463","reference":"6ZMxpANXvtgTR4ZDfsgt99L3irR6F78uUVCrBqZ6DnuS","session":"eyJhcnRpY2xlSWQiOiJzcWxhbGNoZW15LWRldGFjaGVkLWluc3RhbmNlLXNlc3Npb24tZXJyb3JzIiwicmVmZXJlbmNlIjoiNlpNeHBBTlh2dGdUUjRaRGZzZ3Q5OUwzaXJSNkY3OHVVVkNyQnFaNkRudVMiLCJyZWNpcGllbnQiOiI3TFNqZnJKZjhmTnNCOFZBOXU3TjNXRW4yNXNtUUxwb2IzU3Z5VXZYYWN5NyIsIm1pbnQiOm51bGwsIm1pbkFtb3VudCI6OTU1MDksImV4cCI6MTc5Mjk2Mjc1OTYyN30.MO6wXOTfasVINyKTxY6KyOtoJqTMRlWbJWIg5mHdnI8","solUsdPrice":101.56},"maxTimeoutSeconds":120,"network":"solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp","payTo":"7LSjfrJf8fNsB8VA9u7N3WEn25smQLpob3SvyUvXacy7","scheme":"exact"}],"description":"Fix SQLAlchemy DetachedInstanceError - session scope, selectinload eager loading, expire_on_commit, async MissingGreenlet, FastAPI session dependency","extensions":{"bazaar":{"info":{"input":{"method":"GET","type":"http"},"output":{"example":{"body":"Explains SQLAlchemy session lifecycle errors: DetachedInstanceError, object is not bound to a Session, MissingGreenlet in async, expire_on_commit, selectinload and joinedload, scoped sessions, FastAPI dependency pattern and pool overflow.","c":"Self-Hosting & Infra","id":"sqlalchemy-detached-instance-session-errors","t":"Fix SQLAlchemy DetachedInstanceError, \"Session is closed\" and Lazy Load Problems"},"type":"json"}},"schema":{"$schema":"https://json-schema.org/draft/2020-12/schema","properties":{"input":{"additionalProperties":false,"properties":{"method":{"enum":["GET"],"type":"string"},"type":{"const":"http","type":"string"}},"required":["type","method"],"type":"object"},"output":{"properties":{"example":{"properties":{"body":{"description":"Main body text","type":"string"},"c":{"description":"Category of the guide","type":"string"},"id":{"description":"Identifier of the record","type":"string"},"license":{"description":"License identifier","type":"string"},"price":{"description":"Price","type":["number","null"]},"t":{"description":"Title of the guide","type":"string"}},"required":["id","t","c","body"],"type":"object"},"type":{"const":"json","type":"string"}},"required":["type"],"type":"object"}},"required":["input"],"type":"object"}}},"iconUrl":"https://res.cloudinary.com/bdb-prod/image/upload/c_fill,ar_1:1,w_256,h_256,f_auto,q_auto/v1791811517/bazaar-icons/bc5e2b3d111ebbef.jpg","lastUpdated":"2026-10-25T21:10:39.672Z","quality":{"l30DaysTotalCalls":2,"l30DaysUniquePayers":2,"lastCalledAt":"2026-10-25T21:10:39.454Z"},"resource":"https://saylorinnovations.com/api/kb/sqlalchemy-detached-instance-session-errors","serviceName":"Saylor Innovations Guide Library","tags":["sqlalchemy","python","orm","sessions","fastapi"],"type":"http","x402Version":2},"source":"x402_bazaar","summary":"Fix SQLAlchemy DetachedInstanceError - session scope, selectinload eager loading, expire_on_commit, async MissingGreenlet, FastAPI session dependency"},"body_sha256":"b975ee47ab43f150a819a7ab85714cc7d1c2763ae4e0d27b2d01228eff3ef5f4","prev_id":null,"leaf":"0x0ea41a7910c46a171a6adf3cc462bdc2cc31ed92fad59d66857d68f222cdbc30","leaf_text":"{\"body\":\"b975ee47ab43f150a819a7ab85714cc7d1c2763ae4e0d27b2d01228eff3ef5f4\",\"id\":120313,\"kind\":\"listing\",\"method\":\"baseline/1\",\"observed_us\":1793025617647364,\"prev\":null,\"subject\":\"x402_bazaar:https://saylorinnovations.com/api/kb/sqlalchemy-detached-instance-session-errors\",\"subject_kind\":\"source_record\"}","day":{"day":"2026-10-26","leaves":296695,"root":"0xf43e8dcc3d451a4788b26be904c55e8c4c0fa75c9666796c51db38d37e2c0df8","chained":"0x702d5ac508f08b0d1accf36af25822d8e5660367494edd17a642fb61e158a57a","anchor_chain":"eip155:5042002","anchor_tx":"0x495162f8936e19f0039918feebe6c307f327cd6bf8c37219620b1970041fa9ae","anchor_block":69251483},"proof":["0x0ea3b6b4a1e204cb3ffdf7c48110077e19ce8ad8bdc20b2f5c0862cf67ce78cd","0xfa8b6680f9393dfc40d4478f74f73248e2bcff207eb25673eb51ebc27bea46ae","0x0989628ed23b13fe760c1d75fcdfe68097f1e9224f8927db9c79149b6002b4e9","0x8be9127c0545c6cdf346bb45ccff3f6a7a22b2b0cd1487372a91fef1cc8b99ff","0x9d4e9b9b036e5b187eee4a3b835a25ce43e71e803b8b3e9176860e58340f69e7","0x95bdaaeeabf20d450caff3a5000a960a7a57ce4ca50d81e18344d8af37d7fa2c","0xfdf416199a645068aad0c206b86690b9427cef60abddc76aaf30c87b910aaeb3","0xd0d64129cd3991df3ff242a9cf1c7cf3397d0dc486857c965b0f78ea40553d66","0x237ff8ead2e807c8c8253ebc3fbd3c0d1d8bc94d78c3e36dfc13945e41878a0f","0x36de94df31980769366d6459ea42b641bdc51120bfd8317d0101e69404feba8e","0x1e6a5f0042a4b7776e54cf79ce729b60eac17c4eb209cc9613fcd31c9fa0d26c","0x129649b2ec48fbc611fb055c3f5627bda42692beb65d09e853d75bcda4e06239","0x294f7935f78a896b5f246a7c9a7ee1b023720acdb03fff3cd549c63479848ec9","0xb49e8c2564256e5322e375cb619d9ac70fd17c1d1eba9c991bba4cb6428f45cc","0x60582ab4b41e72eb70eb0bce07fbf0fb4d2b62a8bad5be50f5d16d511adc746c","0xc6a4d7899a0f442958e26505011190b7cff2483611c1b94eba9043e0ba9ac36e","0x8c756542e482157df0c36464d75c937b845e4423dbbcfad08f0cf8d5a16b9a13","0x20704208aa6923d6b2450ef74ede87a6e0265d46447926038fe9506e9e154b2d","0x9b9ce5b74b9bab5121612ef6b64920a8d453cbf311096a423eef9702747e868a"]}