[#CMP-390] JdbcDirectory: rows marked deleted are not being deleted

Compass

JdbcDirectory: rows marked deleted are not being deleted

Created: 26/Apr/07 10:22 AM Updated: 27/Apr/07 04:02 PM

Component/s:

Compass::Core

Affects Version/s:

1.1 GA

Fix Version/s:

1.1.1, 1.2 M1

Environment:

Mac OS X 10.4.9 (Intel), Java 1.5.0_07

Description

« Hide

Index rows in the database are not being deleted when the deleted_ flag is set to 1. The reason appears to be that the code in JdbcDirectory.deleteMarkDeleted() runs successully, but the transaction is immediately rolled back because autoCommit is set to false (the default).

I am using MySQL 5.0.24a and MySQL Connector/J 3.1.13.

All

Comments

Change History

Sort Order:

[ Permlink | « Hide ]

Shay Banon added a comment - 27/Apr/07 04:02 PM

The call to deleteMarkDeleted was not executed under a transactions (as noted).

Fixed for version 1.2 M, and created a new patch version 1.1.1