On my site, www.urbanministry.org, the workflow_node_history table contains over 250,000 records of the same event - the deletion of node 20239. The only thing unique about each one is that the hid is incremented. In total, there are over 7,000,000 records in the table, nearly all of them duplicates of one thing or another.

I have looked at the _workflow_write_history function and where it is called and I am not sure why this bug is occurring. This is critically impacting our ability to use the workflow module on our site. Thanks for any assistance you can offer.

Comments

jvandyk’s picture

jvandyk commented

Do you have a scheduled transition for that node stuck in your workflow_scheduled_transition table? There were some bug fixes in the 6.x branch of workflow that affected that recently.

EvanDonovan’s picture

EvanDonovan commented

I checked that table, and it is blank.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Title: {workflow_node_history} table contains 1000s of duplicate records - 7,000,000 in all » {workflow_node_history} table contains 1000s of duplicate records
Bastlynn’s picture

Bastlynn commented
Status: Active » Closed (won't fix)

Hi,

With the release of Drupal 7, Drupal 5 is no longer receiving security updates, reviews, or development from many contributed modules. Since 5 is now considered a depreciated version, you really should seriously look into upgrading to Drupal 6 or 7. The newer versions of Drupal work better, have more support, and will be safer (literally! security patches!) for your website. We are currently working on a new release for Workflow to Drupal 7. In light of that, further support for Drupal 5 issues is infeasible at the moment. Please consider upgrading to Drupal 6 or 7 in the near future - you'll be glad you did.

- Bastlynn