- (SQL) Fixed that the SMP did not start up if a database migration alters the audit table
smp_audititself - as the new migrationV36of v8.4.0 does. The audit itemsql-migration-successis written from the FlywayAFTER_EACH_MIGRATEcallback, which runs inside the still open transaction of the migration, whereas theINSERTof the audit item uses its own connection - so the insert waited for the table lock held by exactly that transaction, and the transaction waited for the callback to return.
The audit item is therefore now written asynchronously, so that the migration can commit and release the lock.
This was reported for PostgreSQL.
Based on #544 - thx @vrbyjimmy. See #543. - (SQL) Fixed that the global search of the Business Card list did not find Business Cards with multilingual names.
An entity with a single unlabelled name is stored in the columnname, whereas an entity with multiple names or with a language labelled name is stored in the JSON columnnamesand leavesnameempty - andESMPBusinessCardColumn.NAMEonly searched the former. It now searches both columns, so that the SQL backend finds the same Business Cards as the XML and the MongoDB backend, which already searched all entity names.
Based on #542 - thx @vinit-thummar - (MongoDB) Fixed that the case insensitive lookup of a user by email address also matched substrings, so that e.g.
sermgr@smp.localhostreturned the user with the email addressusermgr@smp.localhost.
The regular expression used for the comparison is now anchored at both ends, so thatUserManagerMongoDB.getUserOfEmailAddressIgnoreCase (String)requires an exact match, as the XML and the SQL user manager do.
Based on #541 - thx @vinit-thummar
What's Changed
- Fix MongoDB case-insensitive email lookup matching substrings by @vinit-thummar in #541
- Fix SQL search for multilingual business card names by @vinit-thummar in #542
- Fix migration by @vrbyjimmy in #544
Full Changelog: phoss-smp-parent-pom-8.4.0...phoss-smp-parent-pom-8.4.1