| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 2081 | RackTables | default | public | 2023-05-01 00:24 | 2024-03-12 21:53 |
| Reporter | Jose Luis Le Vraux | Assigned To | |||
| Priority | high | Severity | feature | Reproducibility | always |
| Status | new | Resolution | open | ||
| Platform | debian 11 | OS | debian 11 | OS Version | debian 11 |
| Product Version | 0.22.0 | ||||
| Summary | 2081: RackTables installation: step 5 of 7 | ||||
| Description | http://localhost/racktables/wwwroot/?module=installer RackTables installation: step 5 of 7 Your database is already holding 74 tables, so I will stop here and let you check it yourself. There is some important data there probably. borre la base y la cree de nuevo, borre las tablas probe varias formas, pero siempre quedo en el paso 5 de 7, las tablas se crean automaticamente | ||||
| Additional Information | MariaDB [racktables_db]> show tables -> ; +---------------------------+ | Tables_in_racktables_db | +---------------------------+ | Atom | | Attribute | | AttributeMap | | AttributeValue | | CachedPAV | | CachedPNV | | CachedPVM | | Chapter | | Config | | Dictionary | | EntityLink | | File | | FileLink | | IPv4Address | | IPv4Allocation | | IPv4LB | | IPv4Log | | IPv4NAT | | IPv4Network | | IPv4RS | | IPv4RSPool | | IPv4VS | | IPv6Address | | IPv6Allocation | | IPv6Log | | IPv6Network | | LDAPCache | | Link | | Location | | Molecule | | MountOperation | | Object | | ObjectHistory | | ObjectLog | | ObjectParentCompat | | PatchCableConnector | | PatchCableConnectorCompat | | PatchCableHeap | | PatchCableHeapLog | | PatchCableOIFCompat | | PatchCableType | | Plugin | | Port | | PortAllowedVLAN | | PortCompat | | PortInnerInterface | | PortInterfaceCompat | | PortLog | | PortNativeVLAN | | PortOuterInterface | | PortVLANMode | | Rack | | RackObject | | RackSpace | | RackThumbnail | | Row | | Script | | TagStorage | | TagTree | | UserAccount | | UserConfig | | VLANDescription | | VLANDomain | | VLANIPv4 | | VLANIPv6 | | VLANSTRule | | VLANSwitch | | VLANSwitchTemplate | | VLANValidID | | VS | | VSEnabledIPs | | VSEnabledPorts | | VSIPs | | VSPorts | +---------------------------+ 74 rows in set (0,001 sec) | ||||
| Tags | No tags attached. | ||||
 |
despues de presionar muchas veces RETRY aparece el siguiente mensaje en http://localhost/racktables/wwwroot/?module=installer PDOException SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'innodb_test' already exists (42S01) at file /var/www/html/racktables/wwwroot/inc/dictionary.php, line 46 /var/www/html/racktables/wwwroot/inc/dictionary.php:46 query() /var/www/html/racktables/wwwroot/inc/install.php:357 isInnoDBSupported() /var/www/html/racktables/wwwroot/inc/install.php:59 init_database_static() /var/www/html/racktables/wwwroot/index.php:299 renderInstallerHTML() Error info: Array ( [0] => 42S01 [1] => 1050 [2] => Table 'innodb_test' already exists ) Parameters: GET (array) module installer POST (array) step 5 COOKIE (array) Pycharm-3f5a1ac 0029b808-6642-4403-9d44-6c0439c81323 |
 |
I do not remember seeing such an error before. Could you post detailed steps to reproduce please? |
 |
I encountered this very same issue installing on Ubuntu 22. It looks like the current installation script is trying to configure the database twice- once in step 2 (or maybe it was 3?- when I was asked to enter the database credentials) and again here in step 5. My workaround was to comment out the 7 lines in install.php: # if (count ($tables)) #ji { # echo 'Your database is already holding ' . count ($tables); # echo ' tables, so I will stop here and let you check it yourself. '; # echo 'There is some important data there probably. '; # return FALSE; # } I was then able to proceed- I received pages and pages of errors trying to re-create the tables that already were created, but the installer allowed me to proceed, and everything seems to be working OK. An alternate workaround would be to delete all 74 tables. |
|
|
As mentioned before, this bug needs the exact steps to reproduce. To the best of my understanding, the logic that guards pre-existing tables in the database has been in place for many years and always worked as intended. |
