[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

plague-client list failing



Doing "plague-client list" fails with the following error:

Error: an error ocurred communicating with the server. '<Fault 1:
'pg.DatabaseError:error \'ERROR:  expression
too complex\nDETAIL:  Nesting depth exceeds maximum expression depth
10000.\nHINT:  Increase the configuration
parameter "max_expr_depth".\n\' in \'SELECT jobid, parent_uid,
starttime, endtime, arch, builder_addr, status,
builder_status FROM archjobs WHERE parent_uid=5 OR parent_uid=1 OR
parent_uid=3 OR parent_uid=6 OR parent_uid=9

The "OR parent_uid = " clauses go on for a few pages (something 226K).
PostgreSQL has a limit of 10,000 clauses in an expression.  Limiting
the number of jobs selected would fix the problem.

- Ian


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]