I'm occasionally seeing this MySQL error in watchdog. The site is quite busy and has lots of modules and css/js files. I was surprised not to find any other issues about this. Is this something unique to my configuration, or could advagg have a bug with it's bundling system?

User warning: Too many tables; MySQL can only use 61 tables in a join query: SELECT root.bundle_md5 FROM advagg_bundles AS root INNER JOIN advagg_bundles AS a USING(bundle_md5) INNER JOIN advagg_bundles AS b USING(bundle_md5) INNER JOIN advagg_bundles AS c USING(bundle_md5) INNER JOIN advagg_bundles AS d USING(bundle_md5) INNER JOIN advagg_bundles AS e USING(bundle_md5) INNER JOIN advagg_bundles AS f USING(bundle_md5) INNER JOIN advagg_bundles AS g USING(bundle_md5) INNER JOIN advagg_bundles AS h USING(bundle_md5) INNER JOIN advagg_bundles AS i USING(bundle_md5) INNER JOIN advagg_bundles AS j USING(bundle_md5) INNER JOIN advagg_bundles AS ba USING(bundle_md5) INNER JOIN advagg_bundles AS bb USING(bundle_md5) INNER JOIN advagg_bundles AS bc USING(bundle_md5) INNER JOIN advagg_bundles AS bd USING(bundle_md5) INNER JOIN advagg_bundles AS be USING(bundle_md5) INNER JOIN advagg_bundles AS bf USING(bundle_md5) INNER JOIN advagg_bundles AS bg USING(bundle_md5) INNER JOIN advagg_bundles AS bh USING(bundle_md5) INNER JOIN advagg_bundles AS bi USING(bundle_md5) INNER JOIN advagg_bundles AS bj USING(bundle_md5) INNER JOIN advagg_bundles AS ca USING(bundle_md5) INNER JOIN advagg_bundles AS cb USING(bundle_md5) INNER JOIN advagg_bundles AS cc USING(bundle_md5) INNER JOIN advagg_bundles AS cd USING(bundle_md5) INNER JOIN advagg_bundles AS ce USING(bundle_md5) INNER JOIN advagg_bundles AS cf USING(bundle_md5) INNER JOIN advagg_bundles AS cg USING(bundle_md5) INNER JOIN advagg_bundles AS ch USING(bundle_md5) INNER JOIN advagg_bundles AS ci USING(bundle_md5) INNER JOIN advagg_bundles AS cj USING(bundle_md5) INNER JOIN advagg_bundles AS da USING(bundle_md5) INNER JOIN advagg_bundles AS db USING(bundle_md5) INNER JOIN advagg_bundles AS dc USING(bundle_md5) INNER JOIN advagg_bundles AS dd USING(bundle_md5) INNER JOIN advagg_bundles AS de USING(bundle_md5) INNER JOIN advagg_bundles AS df USING(bundle_md5) INNER JOIN advagg_bundles AS dg USING(bundle_md5) INNER JOIN advagg_bundles AS dh USING(bundle_md5) INNER JOIN advagg_bundles AS di USING(bundle_md5) INNER JOIN advagg_bundles AS dj USING(bundle_md5) INNER JOIN advagg_bundles AS ea USING(bundle_md5) INNER JOIN advagg_bundles AS eb USING(bundle_md5) INNER JOIN advagg_bundles AS ec USING(bundle_md5) INNER JOIN advagg_bundles AS ed USING(bundle_md5) INNER JOIN advagg_bundles AS ee USING(bundle_md5) INNER JOIN advagg_bundles AS ef USING(bundle_md5) INNER JOIN advagg_bundles AS eg USING(bundle_md5) INNER JOIN advagg_bundles AS eh USING(bundle_md5) INNER JOIN advagg_bundles AS ei USING(bundle_md5) INNER JOIN advagg_bundles AS ej USING(bundle_md5) INNER JOIN advagg_bundles AS fa USING(bundle_md5) INNER JOIN advagg_bundles AS fb USING(bundle_md5) INNER JOIN advagg_bundles AS fc USING(bundle_md5) INNER JOIN advagg_bundles AS fd USING(bundle_md5) INNER JOIN advagg_bundles AS fe USING(bundle_md5) INNER JOIN advagg_bundles AS ff USING(bundle_md5) INNER JOIN advagg_bundles AS fg USING(bundle_md5) INNER JOIN advagg_bundles AS fh USING(bundle_md5) INNER JOIN advagg_bundles AS fi USING(bundle_md5) INNER JOIN advagg_bundles AS fj USING(bundle_md5) INNER JOIN advagg_bundles AS ga USING(bundle_md5) WHERE a.filename_md5 = '4268f91bd0de04dd8d9d2ff4282259d9' AND b.filename_md5 = '52ae9b20d07a214cf2b5eb3bbd675899' AND c.filename_md5 = '1ac1d22e9a084703fc1dac0cb9e186fe' AND d.filename_md5 = 'ec5c656b7a90cc61367b5b8b519725f9' AND e.filename_md5 = 'c38afabbbf41bb6dd0dc0d334cf6b8fc' AND f.filename_md5 = 'ac5a3f4f431b52771272f754a63c9ec0' AND g.filename_md5 = 'ac5f09ee40718d1aabdfbe52962df12b' AND h.filename_md5 = '817daedd521a2669b0a1733984d3ab8d' AND i.filename_md5 = 'c9f71b6c745c219a20de18eba608451e' AND j.filename_md5 = '508c9894297367123d7d5a79cd3a97c6' AND ba.filename_md5 = '4dbcb1a7396d39baf0d4e076899d6679' AND bb.filename_md5 = 'f63549055f2b98030719d2d465bede95' AND bc.filename_md5 = 'aa038ab71f8d02ae5fb0d380a02728b8' AND bd.filename_md5 = '9f580c525a51542a3d2c4bd8c50c13cf' AND be.filename_md5 = '793e6a6051d1d7b46d021e24cfc23535' AND bf.filename_md5 = 'cd0edd3427384c4596bf66222e2a3fcd' AND bg.filename_md5 = '625127f09813ceeb67433b9f28d6e0a0' AND bh.filename_md5 = '2af39980e2683d1713c5a24cca4ae792' AND bi.filename_md5 = '7a9ac398e893b0412528bc2fee5d2832' AND bj.filename_md5 = '1a5ab7a50c32345a18dfede5d6c0e82f' AND ca.filename_md5 = 'd4cf2288107eb4654aad629126577ce6' AND cb.filename_md5 = '566032e03490a0a0538d666095a524fe' AND cc.filename_md5 = 'abf224eaae77613eec9992e72e598de4' AND cd.filename_md5 = 'b10fed42674e308b49caedf90610a435' AND ce.filename_md5 = 'c2432d4d708a615422496d883b5fac6b' AND cf.filename_md5 = '1c19a98b559fa884c75a05f025e15127' AND cg.filename_md5 = 'feef6f119e27694bd93250d438369a36' AND ch.filename_md5 = 'ac3d999899d9e5375a326c769bb144be' AND ci.filename_md5 = '844a6a259c032a5d3ba58d7147bf644a' AND cj.filename_md5 = '0e44544c31ddfab2935a44b7b0d4cf66' AND da.filename_md5 = '15d690fa9eb2f948e86c5cea9f5d5de2' AND db.filename_md5 = 'b2afc8ae0d05f72af1ad134bcc9eb189' AND dc.filename_md5 = 'f1ece9aca82de5d9f8c11befda78ca59' AND dd.filename_md5 = '61a684203b64e8342683afc4852d5411' AND de.filename_md5 = 'a7dcc182ef8f4fd9d1f9f19cc11af3cf' AND df.filename_md5 = '87987aa274bf2c7c75be5dd8f54f91ab' AND dg.filename_md5 = '540da21e27afc568598a32d08e02b216' AND dh.filename_md5 = '239d9a0759184090c117b9d1faac5fd2' AND di.filename_md5 = '430c122a5ac0cb5a39f4a43c36bb7cd9' AND dj.filename_md5 = '14ed8838f4c8ac54325c8774c6bb80ec' AND ea.filename_md5 = '44e9146e0b202ba6ef3e2e049879473c' AND eb.filename_md5 = 'cf0e5df1ce64119cffc3f94519600245' AND ec.filename_md5 = '0ea4864bd5e40421686ccc112a1e977c' AND ed.filename_md5 = 'a3163f2de4d68bc2f2ab493dd2d6e07e' AND ee.filename_md5 = '84631cbe6ec36d3cb407fae242f5bed9' AND ef.filename_md5 = '44bc1aaf5cab393c76226c61e731ffe1' AND eg.filename_md5 = '1c3511b933524d47f0ec52dda5da5448' AND eh.filename_md5 = 'e7af70c6bc592161830f5361e17852ec' AND ei.filename_md5 = '5197ccd7910d6bd79142874a18ae3ca7' AND ej.filename_md5 = '529fb0176151434d84b1223decdc7af2' AND fa.filename_md5 = '8db6dcad21f8c83dcf6ccaf0f9583def' AND fb.filename_md5 = '8060f833924ec2b33be1f3ead1d81715' AND fc.filename_md5 = 'a7ad88724ad359dfe8ae510602f57c5f' AND fd.filename_md5 = 'a8e052561dd333e3e17c067aea2cb6dd' AND fe.filename_md5 = '3c54c5f6eb6edc3bb1e7481a4c6d12b7' AND ff.filename_md5 = '19b52b24e89c8212f4f14302eb066356' AND fg.filename_md5 = '8348bd06eb56b2ecfab0b1a57bcbfdf3' AND fh.filename_md5 = '6c7f6b1db1f68653ee8d01c5055ffe8f' AND fi.filename_md5 = '199e55ed200c842c941b61242109ca41' AND fj.filename_md5 = 'f88cec77e54915077d9ace48adaf184e' AND ga.filename_md5 = '7755a6b00f0d3ad3471c05d818d15568' GROUP BY bundle_md5 in _db_query() (line 148 of /var/www/live.mysite.com/web/includes/database.mysql.inc).

Comments

mikeytown2’s picture

Component: Miscellaneous » Code

Bummer, looks like I need to account for the limits of mysql. It has to do with your configuration, you have a lot of CSS or JS files loading on that page. I can get around this by using PHP to do the join logic if we have more than 60 files.

The real question is what version of the code are you using? I think you are using an older version of advagg as the function that runs this query no longer gets called from anywhere; advagg_find_existing_bundle() is the function that contains the monster join and I've commented the call to it out a little while ago due to some unrelated issues.

mikeytown2’s picture

Status: Active » Postponed (maintainer needs more info)

Going to postpone until you can verify that your using 1.5 or the latest dev.

bibo’s picture

Thanks for your fast response mikeytown2 :-)

Going to postpone until you can verify that your using 1.5 or the latest dev.

I'm using the dev-version, but apparently not the latest one. advagg.info says:

; Information added by drupal.org packaging script on 2011-04-06
version = "6.x-1.x-dev"
core = "6.x"
project = "advagg"
datestamp = "1302091345"

I guess I'll just upgrade and see if this error re-occurs?

mikeytown2’s picture

Status: Postponed (maintainer needs more info) » Closed (works as designed)

Your dev version is 4 months old. Going to close this issue as I believe it won't happen in the latest version.