Have a query that consists of 10 unions.  For a period of time it will
constantly return with an error 12.  Moments later it might actually
work once or twice.  I can find nothing in any logs or whatever.   The
odd thing is that when it isn't working, simply reducing the unions to 8
or less returns with no problem.

A) Very little to be read about on the net for Error 12
B) What little there is talks mostly of BDB, which is of no relevance.

I've tried reproducing the problem with lots of unions, even tried
joining some simple table to try to get the same error, but to no avail.
I'm guess it is related to my specific schema.

I'm on 4.1.11, up from 4.1.10a but that didn't fix it.

Any debugging avenues suggested?

I know someone is going to want an explain, and it'll have to wait until
the morning.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to