When running a long process the DB connection can be dropped. Pinging the DB would keep the connection alive.

CommentFileSizeAuthor
#3 httprl-1909120-2-ping-db.patch2.12 KBmikeytown2
#2 httprl-1909120-1-ping-db.patch2.02 KBmikeytown2
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

mikeytown2’s picture

mikeytown2 CreditAttribution: mikeytown2 commented

I think system_get_files_database() would be a good "db ping" function. $files would be an empty array and $type could be 'db_ping'.

mikeytown2’s picture

mikeytown2 CreditAttribution: mikeytown2 commented
Status: Active » Needs work
FileSize
httprl-1909120-1-ping-db.patch2.02 KB

Patch still needs to take into account not running under drupal. Other than that it should be ready to go.

mikeytown2’s picture

mikeytown2 CreditAttribution: mikeytown2 commented
Status: Needs work » Fixed
FileSize
httprl-1909120-2-ping-db.patch2.12 KB

The following patch has been committed to 6.x & 7.x

Status: Fixed » Closed (fixed)

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