I'm testing out apdqc module in the integration environment for a Drupal Commerce-heavy site I'm working on as I expect it can resolve or at least mitigate some Rules locking issues we're having.

I've gotten configuration information into settings.php and resolved most of the red items in the status report except for the innodb_buffer_pool_size (which I intend to bother our sysadmins about later along with some of the yellow items). I converted semaphore table to memory, which worked fine. I then attempt the other two operations, converting cache table collations and indices. They both give a success message.... but don't go away. They're still there to be run, status report is still complaining about them.

Digging in and doing some brute force debugging on the collation one, I confirm that despite the success message, the cache table collations are not getting updated. Digging further, I discover that the async_query calls are failing (returning "NO DB" - digging even further, they're getting access denied when they try to make a database connection - I need to debug that further myself, will put in a bug report if I find an issue on apdqc's side.) But the convert cache table operations don't check for this condition, and assume all went well.

It would be nice if these operations reported when this sort of thing goes wrong with the async_query (to surface whatever configuration issue and/or bug is at play here) and/or fell back to db_query for this case. Failing silently while returning a success message is somewhat less than desirable. (Some sort of status report test for async_query might be nice too, but I'll perhaps address that in a separate ticket after I figure out what's going wrong in our particular case.)

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Olarin created an issue. See original summary.

mikeytown2’s picture

Following patch has been committed. Now it has a better warning message.

  • mikeytown2 committed 0b7f81d on 7.x-1.x
    Issue #2584275 by mikeytown2: Provide better feedback when db operations...

  • mikeytown2 committed ab4f094 on 7.x-1.x
    Issue #2584275 by mikeytown2: Provide better feedback when db operations...

  • mikeytown2 committed 2de19f1 on 7.x-1.x
    Issue #2584275 by mikeytown2: Make sure apdqc_query is working.
    
mikeytown2’s picture

Status: Active » Fixed
FileSize
1.06 KB

Marking this issue as fixed. status report now checks that apdqc_query is working.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.