You have been subscribed to a public bug:
In CRM Module, in Opportunities, i have created a search filter with all
opportunities of a salesman. The query is too large, and if i use the
filter, openerp-server down. They are not nothing in the openerp log. I
have to restart openerp-server. It is the query:
DEBUG actengo openerp.sql_db: query: SELECT
res_partner."comment",res_partner."ean13",res_partner."color",res_partner."image",res_partner."city",res_partner."user_id",res_partner."opt_out",res_partner."title",res_partner."company_id",res_partner."last_reconciliation_date",res_partner.$
FROM "res_partner" WHERE res_partner.id IN (1585, 1108, 9301, 9302, 1111, 1112,
9305, 1114, 9770, 1116, 9309, 1587, 1118, 9311, 9312, 1700, 9313, 9314, 9315,
1124, 9317, 9318, 1127, 1589, 9320, 9321, 9773, 1131, 1132, 1133, 9326,
9327, 1136, 1591, 1682, 1140, 9333, 1142, 1592, 1143, 1865, 9337, 9338, 1593,
9340, 1149, 9342, 9343, 1152, 1594, 9866, 9346, 9778, 1157, 1595, 9350, 1159,
9352, 1596, 9355, 1164, 9780, 9358, 9359, 1597, 1168, 9361, 9362, 9363, 1598,
1173, 1174, 9782, 9368, 1177, 1599, 1178, 9867, 1179, 1180, 1181, 1182, 1600,
1183, 1184, 1185, 1186, 1187, 1601, 1188, 1684, 1189, 1190, 1191, 1155, 9384,
1602, 1193, 1194, 9387, 9388, 1197, 1198, 1199, 9392, 9393, 9394, 1604, 1203,
9396, 1205, 9775, 1206, 9399, 1605, 1208, 1209, 9402, 1211, 1606, 1685, 1214,
1215, 9408, 1217, 1607, 1218, 1219, 1220, 1221, 1222, 1608, 1224, 1225, 1226,
1227, 1609, 1228, 9421, 9422, 1610, 1233, 9426, 9427, 9428, 9429, 9430, 1686,
9431, 9795, 1241, 1242, 1612, 9435, 1244, 1245, 9438, 9439, 1613, 9440, 9442,
1251, 9444, 9445, 9870, 9446, 9447, 1256, 1257, 1615, 1258, 9451, 9452, 9453,
1262, 9455, 9456, 1265, 1266, 1267, 1268, 9461, 1270, 9463, 1618, 1273, 1274,
1275, 9468, 10075, 9469, 9257, 1279, 9472, 9803, 1282, 1620, 1283, 9476, 1286,
1287, 1621, 1288, 1289, 1290, 1292, 1293, 1294, 1295, 9806, 9488, 1623, 9490,
9491, 9492, 1301, 9494, 9495, 9496, 9497, 9808, 9498, 9499, 1625, 9500, 9501,
9502, 9809, 1311, 1312, 1626, 1313, 1689, 9506, 9507, 1316, 9510, 1319, 1320,
9811, 1321, 1322, 1628, 1323, 9516, 1325, 9518, 1327, 1629, 9520, 1329, 1330,
9776, 1331, 9524, 1630, 1333, 1335, 9814, 1336, 10087, 1337, 1631, 9530, 1690,
1339, 9534, 1632, 1343, 1344, 1345, 9816, 1346, 1347, 1633, 1348, 1349, 1350,
9543, 1352, 1353, 1907, 1354, 1355, 1356, 1357, 1635, 1358, 1359, 1360, 9819,
1636, 1363, 1691, 1364, 1365) ORDER BY name
Approximately 70% of the time that I make this action the server goes
down.
In the PostgreSQL Log indicate EOF connection.
** Affects: ubuntu
Importance: Undecided
Status: New
--
[7.0] Server down on execute large personalised search filter
https://bugs.launchpad.net/bugs/1177291
You received this bug notification because you are a member of Ubuntu Bugs,
which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
