1242 - target liveweb-primary vttablet rpc error code = FailedPrecondition desc = Subquery returns more than 1 row errno 1242 sqlstate 21000 CallerID wqy60oqpsw9pb05voy0u Sql select from products whe
This error message is indicating that there is a problem with a subquery in the SQL statement being executed by vttablet on a target server with the name "liveweb.-.primary". Specifically, the subquery is returning more than one row, which is causing a "FailedPrecondition" error.
The SQL statement in question is selecting all columns from the "products" table where the "category_id" matches the result of a subquery. The subquery itself is selecting the "id" column from the "Categories" table where the "parent_id" matches a parameter value.
Based on this information, it appears that there may be multiple categories with the same parent ID, which is causing the subquery to return more than one row. To fix this issue, you may need to modify the SQL statement to ensure that it only selects a single row from the subquery, or change the data in the database so that there are no duplicate parent IDs
原文地址: https://www.cveoy.top/t/topic/dBVp 著作权归作者所有。请勿转载和采集!