Actions
Task #101235
openMake additional DB connections optional sometimes, e.g. in case of SchemaMigration
Status:
New
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2023-07-05
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
11
PHP Version:
Tags:
Complexity:
Sprint Focus:
Description
While one can expect that the default DB connection for a TYPO3 is always available, there are scenarios where additional databases might not be available temporarily. Especially in case of schema migration this can result in problems, e.g. because a "not so important" additional DB should be ignored, while still wanting the schema migration to take place for the default connection.
A common scenario where this could occur is during deployment when and if the EXT:typo3_console
command database:updateschema
is run.
Currently, running this command with an unavailable additional DB is not possible as an unhandled exception would be thrown before the actual migration, due to the connection timeout.
- SchemaMigration
- no schema migration should be done (table is completely managed by a 3rd party)
- schema migration only for mapped tables (in general tables are managed by a 3rd party, but a few tables were created by TYPO3)
- full schema control (like TYPO3 default, 3rd party tables not mapped should be removed)
- the schema migration should have an option to skip unavailable connections (handle the exceptions) and still run for the others
- If a table mapping exists, then the whole connection is treated by the SchemaMigration
additional.php
: Check if additional condition is up (and perhaps if on CLI), perhaps remove connection.- read-only user for db access
Updated by Helmut Hummel over 1 year ago
- Related to Bug #94638: DB Schema diff fails, when a database table is mapped to a different connection added
Updated by Garvin Hicking 4 months ago
- Category set to Database API (Doctrine DBAL)
Actions