prisma: MySQL: PANIC: Expected parent IDs to be set when ordering by parent ID. in query-engine/core/src/interpreter/query_interpreters/inmemory_record_processor.rs:71:18
Hi Prisma Team! My Prisma Client just crashed. This is the report:
Versions
Name | Version |
---|---|
Node | v12.22.10 |
OS | debian-openssl-1.1.x |
Prisma Client | 3.11.0 |
Query Engine | 0.1.0 |
Database | mysql |
Logs
B%2C%5D%22%2C+%22%22%29+AS+accumulatedTradingVolume%2C++REGEXP_REPLACE%28marketValue%2C+%22%5B%2C%5D%22%2C+%22%22%29+AS+marketValue%2C+localTradedAt+from+UsaStockData+where+localTradedAt+%3D+%28select+max%28localTradedAt%29+from+UsaStockData%29%29+A+LEFT+JOIN+StockDictionary+B+ON+A.symbolCode+%3D+B.symbolCode++ORDER+BY+A.closePrice%2B0+desc+limit+%3F+offset+%3F+%2C+%5B10%2C0%5D%29%0Aprisma%3Aclient+Prisma+Client+call%3A%0Aprisma%3Aclient%3AlibraryEngine+sending+request%2C+this.libraryStarted%3A+false%0Aprisma%3Aclient%3AlibraryEngine+library+starting%0Aprisma%3Aclient%3AlibraryEngine+library+started%0Aprisma%3Aclient%3AlibraryEngine+sending+request%2C+this.libraryStarted%3A+true%0Aprisma%3Aclient%3AlibraryEngine+sending+request%2C+this.libraryStarted%3A+true%0Aprisma%3Aclient+prisma.queryRaw%28SELECT+A.*%2C+B.stockName+as+stockNameKor%2C+B.stockNameEng+as+stockNameOrigin+FROM+%28SELECT+gubun%2C+reutersCode%2C+symbolCode%2C+stockName%2C+stockNameEng%2C+REGEXP_REPLACE%28closePrice%2C+%22%5B%2C%5D%22%2C+%22%22%29+AS+closePrice%2C+REGEXP_REPLACE%28compareToPreviousClosePrice%2C+%22%5B%2C%5D%22%2C+%22%22%29+AS+compareToPreviousClosePrice%2C++REGEXP_REPLACE%28fluctuationsRatio%2C+%22%5B%2C%5D%22%2C+%22%22%29+AS+fluctuationsRatio%2C++REGEXP_REPLACE%28accumulatedTradingVolume%2C+%22%5B%2C%5D%22%2C+%22%22%29+AS+accumulatedTradingVolume%2C++REGEXP_REPLACE%28marketValue%2C+%22%5B%2C%5D%22%2C+%22%22%29+AS+marketValue%2C+localTradedAt+from+UsaStockData+where+localTradedAt+%3D+%28select+max%28localTradedAt%29+from+UsaStockData%29%29+A+LEFT+JOIN+StockDictionary+B+ON+A.symbolCode+%3D+B.symbolCode++ORDER+BY+A.accumulatedTradingVolume%2B0+desc+limit+%3F+offset+%3F+%2C+%5B10%2C0%5D%29%0Aprisma%3Aclient+Prisma+Client+call%3A%0Aprisma%3Aclient%3AlibraryEngine+sending+request%2C+this.libraryStarted%3A+true%0Aprisma%3Aclient+prisma.queryRaw%28SELECT+A.*%2C+B.stockName+as+stockNameKor%2C+B.stockNameEng+as+stockNameOrigin+FROM+%28SELECT+gubun%2C+reutersCode%2C+symbolCode%2C+stockName%2C+stockNameEng%2C+REGEXP_REPLACE%28closePrice%2C+%22%5B%2C%5D%22%2C+%22%22%29+AS+closePrice%2C+REGEXP_REPLACE%28compareToPreviousClosePrice%2C+%22%5B%2C%5D%22%2C+%22%22%29+AS+compareToPreviousClosePrice%2C++REGEXP_REPLACE%28fluctuationsRatio%2C+%22%5B%2C%5D%22%2C+%22%22%29+AS+fluctuationsRatio%2C++REGEXP_REPLACE%28accumulatedTradingVolume%2C+%22%5B%2C%5D%22%2C+%22%22%29+AS+accumulatedTradingVolume%2C++REGEXP_REPLACE%28marketValue%2C+%22%5B%2C%5D%22%2C+%22%22%29+AS+marketValue%2C+localTradedAt+from+UsaStockData+where+localTradedAt+%3D+%28select+max%28localTradedAt%29+from+UsaStockData%29%29+A+LEFT+JOIN+StockDictionary+B+ON+A.symbolCode+%3D+B.symbolCode++ORDER+BY+A.fluctuationsRatio%2B0+ASC+limit+%3F+offset+%3F+%2C+%5B10%2C0%5D%29%0Aprisma%3Aclient+Prisma+Client+call%3A%0Aprisma%3Aclient%3AlibraryEngine+sending+request%2C+this.libraryStarted%3A+true%0Aprisma%3Aclient%3Arequest_handler+Error%3A+Expected+parent+IDs+to+be+set+when+ordering+by+parent+ID.%0A++++at+prismaGraphQLToJSError+%28%2Fhome%2Fubuntu%2Fcunning-stock%2Finsider-backend%2Fnode_modules%2F%40prisma%2Fclient%2Fruntime%2Findex.js%3A33924%3A10%29%0A++++at+Object.request+%28%2Fhome%2Fubuntu%2Fcunning-stock%2Finsider-backend%2Fnode_modules%2F%40prisma%2Fclient%2Fruntime%2Findex.js%3A35748%3A17%29%0A++++at+async+Object.request+%28%2Fhome%2Fubuntu%2Fcunning-stock%2Finsider-backend%2Fnode_modules%2F%40prisma%2Fclient%2Fruntime%2Findex.js%3A39788%3A24%29%0A++++at+async+PrismaClient._request+%28%2Fhome%2Fubuntu%2Fcunning-stock%2Finsider-backend%2Fnode_modules%2F%40prisma%2Fclient%2Fruntime%2Findex.js%3A40646%3A18%29%0A%60%60%60%0A%0A%23%23+Client+Snippet%0A%60%60%60ts%0A%2F%2F+PLEASE+FILL+YOUR+CODE+SNIPPET+HERE%0A%60%60%60%0A%0A%23%23+Schema%0A%60%60%60prisma%0A%2F%2F+PLEASE+ADD+YOUR+SCHEMA+HERE+IF+POSSIBLE%0A%60%60%60%0A%0A%23%23+Prisma+Engine+Query%0A%60%60%60%0A%7B%22X%22%3A%7B%7D%7D%0A%60%60%60%0A&title=PANIC%3A+Expected+parent+IDs+to+be+set+when+ordering+by+parent+ID.+in+query-engine%2Fcore%2Fsrc%2Finterpreter%2Fquery_interpreters%2Finmemory_record_processor.rs%3A71%3A18&template=bug_report.md
If you want the Prisma team to look into it, please open the link above 🙏
To increase the chance of success, please post your schema and a snippet of
how you used Prisma Client in the issue.
at Object.logger (/home/ubuntu/cunning-stock/insider-backend/node_modules/@prisma/client/runtime/index.js:35615:30)
at /home/ubuntu/cunning-stock/insider-backend/node_modules/@prisma/client/runtime/index.js:35584:34
prisma:client:request_handler Error: Expected parent IDs to be set when ordering by parent ID.
at prismaGraphQLToJSError (/home/ubuntu/cunning-stock/insider-backend/node_modules/@prisma/client/runtime/index.js:33924:10)
at Object.request (/home/ubuntu/cunning-stock/insider-backend/node_modules/@prisma/client/runtime/index.js:35748:17)
at async Object.request (/home/ubuntu/cunning-stock/insider-backend/node_modules/@prisma/client/runtime/index.js:39788:24)
at async PrismaClient._request (/home/ubuntu/cunning-stock/insider-backend/node_modules/@prisma/client/runtime/index.js:40646:18)
Client Snippet
// PLEASE FILL YOUR CODE SNIPPET HERE
Schema
// PLEASE ADD YOUR SCHEMA HERE IF POSSIBLE
Prisma Engine Query
{"X":{}}
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Comments: 15 (9 by maintainers)
Hi @janpio thanks for the info. We did invite @pantharshit00 already. Thank guys.
Hey @grandff,
Would you mind sharing a minimal Prisma Schema + client snippet so that we could reproduce your bug?
Thank you 🙏