Allow multiple databases share the same port
Details
| Detail name | Value |
|---|---|
| Changelog Number | 24938 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 8.0.0 |
| Fix Versions | Exasol 2025.1.0, Exasol 8.29.11 |
| Resolution Date | 2025-07-08 |
Description
Previously, we were not allowing two databases to share the same database port number, even if these two databases ran on different nodes. Jobs such as “db_create” and “db_configure” would detect that the port is being used by the existing databases and would not allow you to set that port for the selected database.
Workaround
Perform these steps in order:
- Login into COS using “c4 connect -s COS -i PLAY_ID”
- Create the new database with some random port number that is not used by the existing databases
- Open EXAConf at “/exa/etc/EXAConf”
- Modify the port number of the created database to the desired port number (that may already be used by another database)
- Change the “Checksum” field to “COMMIT”
- Run “exaconf commit”
Fix
Confd now allows two (or more) databases to use the same port, as long as they do not share nodes. For example, database A and database B may both run on port 8563 as long as database A nodes are [11, 12] and database B nodes are [13, 14]. However, if the two databases share at least one node, they will not be allowed to use the same port.
Changed behavior
The database port check will now be done when starting a database (db_start) and not when creating (db_create) or configuring (db_configure) a database.
