我也遇到了这个问题，能解决了吗？
错误提示：
InternalServerError:errCode: InternalServerError | errMsg: Error in $cursor stage :: caused by :: operation exceeded time limit
//云函数代码
'use strict';
exports.main = async (event, context) => {
const db = uniCloud.database();
const dbCmd = db.command;
const collection = db.collection('dataList');
const $ = dbCmd.aggregate
if (!event.id) {
return false
}
let dats = {};
let status = dbCmd.eq(2);
if (event.isMe) {
status = dbCmd.gte(-2);
} else {
status = dbCmd.gte(1);
}
let skip = event.skip*1;
if(!skip){
skip = 0
}
if (event.lookup) { //连表查询,添加like数据
if (event.type == 'dynamic' || event.type == 'dynamic2') {
dats = {
uid: event.id,
status: status
}
if (event.sortId) {
if (event.sortId > 0) {
dats = {
uid: event.id,
status: status,
sortId: event.sortId
}
}
}
} else {
dats = {
uid: event.id,
status: dbCmd.eq(2)
}
}
let res = await collection.aggregate()
.sort({
"_id": -1
})
.match(dats)
.skip(skip)
.limit(15)
.lookup({
from: 'user-like',
let: {
m_id: '$_id'
},
pipeline: $.pipeline()
.match(dbCmd.expr($.and([
$.eq(['$mid', '$$m_id']),
$.eq(['$uid', event.id])
])))
.project({
_id: 1,
uid: 1,
mid: 1
})
.done(),
as: 'like'
})
.end()
return res.data;
} else {
if (event.type == 'dynamic' || event.type == 'dynamic2') {
dats = {
uid: event.id,
status: status
}
if (event.sortId) {
if (event.sortId > 0) {
dats = {
uid: event.id,
status: status,
sortId: event.sortId
}
}
}
} else {
dats = {
uid: event.id,
status: dbCmd.eq(2)
}
}
let res = await collection.where(dats)
.skip(event.skip)
.limit(15)
.orderBy("time", "desc")
.get();
return res.data
}
};
硕菊叶 (作者)
用的云函数，有配置索引
2021-01-12 14:29
硕菊叶 (作者)
只要加了uid这一行，就会报错。。
2021-01-12 14:30
DCloud_uniCloud_WYQ
回复 硕菊叶: 有用skip或者count了吗，索引怎么配置的？
2021-01-12 20:03