You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
obert Bartlett Baron, reported about 1 year ago
When I try to select data to export (see image) or when I try to load the metric explorer I get (see image) similar errors.
In the data export page, the Realm dropdown does not have any Realms listed.
In the data explorer page, the popup states that "cloud" is an unknown realm. When I click 'OK' the page usually doesn't get past "loading"
Any suggestions?
PNG
Screen Shot ...
(170 KB)
PNG
Screen Shot ...
(171 KB)
JPG
xdmod_de1.jpg
(163 KB)
Ryan Rathsam , said about 1 year ago
Ticket: https://help.xdmod.org/support/tickets/30440
Hi Robert,
Are you able to connect from the command line on the xdmod host to the database w/ the credentials you have specified in portal_settings.ini ?
Robert Bartlett Baron , said about 1 year ago
Ryan,
Yes I am. Occasionally, the database connection is dropped, but it is not very frequent. Furthermore, the interface wouldn't load to this point if it was not able to connect.
Even as infrequently as it happens, we do have a problem with the database dropping the connection that we are working on resolving. However, I do not believe it is at the root of this problem.
Which table does the metric explorer use to find the realm?
Rob.
Robert Bartlett Baron , said about 1 year ago
For example:
find the pod that is running the xdmod container:
Rob@Roberts-Computer xdmod-pr-phpssid % oc get pods
NAME READY STATUS RESTARTS AGE
bc-xdmod-26-build 0/1 Completed 0 43h
mariadb-748974547d-mrcn6 1/1 Running 0 10d
moc-xdmod-6bcbb557d-gdx94 1/1 Running 0 22h
rsh into the container
Rob@Roberts-Computer xdmod-pr-phpssid % oc rsh moc-xdmod-6bcbb557d-gdx94
connect to the database using the 'xdmod' user
sh-4.2$ mysql -h mariadb --protocol=tcp -u xdmod -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 579
Server version: 10.3.34-MariaDB-1:10.3.34+maria~focal mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
run some sql:
MariaDB [(none)]> select * from moddb.realms;
+----------+-----------+---------+---------+
| realm_id | module_id | name | display |
+----------+-----------+---------+---------+
| 1 | 1 | cloud | Cloud |
| 4 | 1 | jobs | Jobs |
| 5 | 1 | storage | Storage |
+----------+-----------+---------+---------+
3 rows in set (0.00 sec)
MariaDB [(none)]>
I am using the same username/password in the portal_settings.ini file.
Robert Bartlett Baron , said 11 months ago
I am closing that as we finally found the configuration issue that has been plaguing us.
Robert Bartlett Baron , said 11 months ago
we can close this issue.
The text was updated successfully, but these errors were encountered:
obert Bartlett Baron, reported about 1 year ago
When I try to select data to export (see image) or when I try to load the metric explorer I get (see image) similar errors.
In the data export page, the Realm dropdown does not have any Realms listed.
In the data explorer page, the popup states that "cloud" is an unknown realm. When I click 'OK' the page usually doesn't get past "loading"
Here is the /var/log/xdmod/exceptions.log
sh-4.2$ cat exceptions.log
2022-06-13 21:59:35 [error] Exception Code: 2003
2022-06-13 21:59:35 [error] Message: SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'mariadb' (110)
2022-06-13 21:59:35 [error] Origin: /usr/share/xdmod/classes/CCR/DB/PDODB.php (line 88)
2022-06-13 21:59:35 [error] Trace:
#0 /usr/share/xdmod/classes/CCR/DB/PDODB.php(88): PDO->__construct('mysql:host=mari...', 'xdmod', 'pass')
#1 /usr/share/xdmod/classes/CCR/DB.php(111): CCR\DB\PDODB->connect()
#2 /usr/share/xdmod/classes/CCR/CCRDBHandler.php(55): CCR\DB::factory('logger')
#3 /usr/share/xdmod/classes/CCR/Log.php(286): CCR\CCRDBHandler->__construct(NULL, NULL, NULL, 200)
#4 [internal function]: CCR\Log::getDbHandler('data-warehouse-...', Array)
#5 /usr/share/xdmod/classes/CCR/Log.php(190): call_user_func(Array, 'data-warehouse-...', Array)
#6 /usr/share/xdmod/classes/CCR/Log.php(111): CCR\Log::getLogger('data-warehouse-...', Array)
#7 /usr/share/xdmod/classes/Rest/Controllers/WarehouseExportControllerProvider.php(51): CCR\Log::factory('data-warehouse-...', Array)
#8 /usr/share/xdmod/classes/Rest/XdmodApplicationFactory.php(184): Rest\Controllers\WarehouseExportControllerProvider->__construct(Array)
#9 /usr/share/xdmod/html/rest/index.php(22): Rest\XdmodApplicationFactory::getInstance()
#10 {main}
2022-06-15 18:08:03 [error] Exception Code: 2003
2022-06-15 18:08:03 [error] Message: SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'mariadb' (110)
2022-06-15 18:08:03 [error] Origin: /usr/share/xdmod/classes/CCR/DB/PDODB.php (line 88)
2022-06-15 18:08:03 [error] Trace:
#0 /usr/share/xdmod/classes/CCR/DB/PDODB.php(88): PDO->__construct('mysql:host=mari...', 'xdmod', 'pass')
#1 /usr/share/xdmod/classes/CCR/DB.php(111): CCR\DB\PDODB->connect()
#2 /usr/share/xdmod/classes/DataWarehouse.php(36): CCR\DB::factory('datawarehouse')
#3 /usr/share/xdmod/classes/DataWarehouse/Query/TimeAggregationUnit.php(84): DataWarehouse::connect()
#4 /usr/share/xdmod/classes/DataWarehouse/Query/Query.php(1378): DataWarehouse\Query\TimeAggregationUnit->getDateRangeIds('2022-05-01', '2022-05-31')
#5 /usr/share/xdmod/classes/DataWarehouse/Query/TimeseriesQuery.php(187): DataWarehouse\Query\Query->setDuration('2022-05-01', '2022-05-31')
#6 /usr/share/xdmod/classes/DataWarehouse/Query/Query.php(165): DataWarehouse\Query\TimeseriesQuery->setDuration('2022-05-01', '2022-05-31')
#7 /usr/share/xdmod/classes/DataWarehouse/Query/TimeseriesQuery.php(92): DataWarehouse\Query\Query->__construct('Cloud', 'day', '2022-05-01', '2022-05-31', NULL, NULL, Array, NULL)
#8 /usr/share/xdmod/classes/DataWarehouse/Visualization/HighChartTimeseries2.php(166): DataWarehouse\Query\TimeseriesQuery->__construct('Cloud', 'day', '2022-05-01', '2022-05-31')
#9 /usr/share/xdmod/classes/DataWarehouse/Access/MetricExplorer.php(195): DataWarehouse\Visualization\HighChartTimeseries2->configure(Array, Array, Array, Array, true, Object(stdClass), 2, 10, 0, false)
#10 /usr/share/xdmod/html/controllers/metric_explorer/get_data.php(19): DataWarehouse\Access\MetricExplorer->get_data(Object(XDUser))
#11 /usr/share/xdmod/classes/XDController.php(69): include('/usr/share/xdmo...')
#12 /usr/share/xdmod/html/controllers/metric_explorer.php(35): XDController->invoke('REQUEST')
#13 {main}
2022-06-20 11:53:10 [error] Exception Code: 0
2022-06-20 11:53:10 [error] Message: Request for unknown Realm: cloud
2022-06-20 11:53:10 [error] Origin: /usr/share/xdmod/classes/Realm/Realm.php (line 243)
2022-06-20 11:53:10 [error] Trace:
#0 /usr/share/xdmod/classes/DataWarehouse/Access/MetricExplorer.php(1049): Realm\Realm::factory('cloud')
#1 /usr/share/xdmod/classes/DataWarehouse/Access/MetricExplorer.php(1006): DataWarehouse\Access\MetricExplorer::getGroupBy(Object(XDUser), 'cloud', 'person')
#2 /usr/share/xdmod/classes/Rest/Controllers/WarehouseControllerProvider.php(997): DataWarehouse\Access\MetricExplorer::getDimensionValueName(Object(XDUser), 'person', '-1')
#3 [internal function]: Rest\Controllers\WarehouseControllerProvider->getQuickFilters(Object(Symfony\Component\HttpFoundation\Request), Object(Silex\Application))
#4 /usr/share/xdmod/vendor/symfony/http-kernel/HttpKernel.php(135): call_user_func_array(Array, Array)
#5 /usr/share/xdmod/vendor/symfony/http-kernel/HttpKernel.php(57): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#6 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(586): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#7 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(563): Silex\Application->handle(Object(Symfony\Component\HttpFoundation\Request))
#8 /usr/share/xdmod/html/rest/index.php(25): Silex\Application->run()
#9 {main}
2022-06-20 13:23:39 [error] Exception Code: 0
2022-06-20 13:23:39 [error] Message: Request for unknown Realm: cloud
2022-06-20 13:23:39 [error] Origin: /usr/share/xdmod/classes/Realm/Realm.php (line 243)
2022-06-20 13:23:39 [error] Trace:
#0 /usr/share/xdmod/classes/User/Elements/QueryDescripter.php(67): Realm\Realm::factory('cloud')
#1 /usr/share/xdmod/classes/Models/Services/Acls.php(1071): User\Elements\QueryDescripter->__construct('cloud', 'vm_size_memory')
#2 /usr/share/xdmod/html/controllers/metric_explorer/get_dw_descripter.php(46): Models\Services\Acls::getQueryDescripters(Object(XDUser))
#3 /usr/share/xdmod/classes/XDController.php(69): include('/usr/share/xdmo...')
#4 /usr/share/xdmod/html/controllers/metric_explorer.php(35): XDController->invoke('REQUEST')
#5 {main}
2022-06-20 13:24:10 [error] Exception Code: 0
2022-06-20 13:24:10 [error] Message: Request for unknown Realm: cloud
2022-06-20 13:24:10 [error] Origin: /usr/share/xdmod/classes/Realm/Realm.php (line 243)
2022-06-20 13:24:10 [error] Trace:
#0 /usr/share/xdmod/classes/DataWarehouse/Access/MetricExplorer.php(1049): Realm\Realm::factory('cloud')
#1 /usr/share/xdmod/classes/DataWarehouse/Access/MetricExplorer.php(1006): DataWarehouse\Access\MetricExplorer::getGroupBy(Object(XDUser), 'cloud', 'person')
#2 /usr/share/xdmod/classes/Rest/Controllers/WarehouseControllerProvider.php(997): DataWarehouse\Access\MetricExplorer::getDimensionValueName(Object(XDUser), 'person', '-1')
#3 [internal function]: Rest\Controllers\WarehouseControllerProvider->getQuickFilters(Object(Symfony\Component\HttpFoundation\Request), Object(Silex\Application))
#4 /usr/share/xdmod/vendor/symfony/http-kernel/HttpKernel.php(135): call_user_func_array(Array, Array)
#5 /usr/share/xdmod/vendor/symfony/http-kernel/HttpKernel.php(57): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#6 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(586): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#7 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(563): Silex\Application->handle(Object(Symfony\Component\HttpFoundation\Request))
#8 /usr/share/xdmod/html/rest/index.php(25): Silex\Application->run()
#9 {main}
2022-06-20 13:25:13 [error] Exception Code: 0
2022-06-20 13:25:13 [error] Message: Request for unknown Realm: cloud
2022-06-20 13:25:13 [error] Origin: /usr/share/xdmod/classes/Realm/Realm.php (line 243)
2022-06-20 13:25:13 [error] Trace:
#0 /usr/share/xdmod/classes/User/Elements/QueryDescripter.php(67): Realm\Realm::factory('cloud')
#1 /usr/share/xdmod/classes/Models/Services/Acls.php(1071): User\Elements\QueryDescripter->__construct('cloud', 'vm_size_memory')
#2 /usr/share/xdmod/html/controllers/metric_explorer/get_dw_descripter.php(46): Models\Services\Acls::getQueryDescripters(Object(XDUser))
#3 /usr/share/xdmod/classes/XDController.php(69): include('/usr/share/xdmo...')
#4 /usr/share/xdmod/html/controllers/metric_explorer.php(35): XDController->invoke('REQUEST')
#5 {main}
2022-06-20 13:25:16 [error] Exception Code: 0
2022-06-20 13:25:16 [error] Message: Request for unknown Realm: cloud
2022-06-20 13:25:16 [error] Origin: /usr/share/xdmod/classes/Realm/Realm.php (line 243)
2022-06-20 13:25:16 [error] Trace:
#0 /usr/share/xdmod/classes/DataWarehouse/Access/MetricExplorer.php(1049): Realm\Realm::factory('cloud')
#1 /usr/share/xdmod/classes/DataWarehouse/Access/MetricExplorer.php(1006): DataWarehouse\Access\MetricExplorer::getGroupBy(Object(XDUser), 'cloud', 'person')
#2 /usr/share/xdmod/classes/Rest/Controllers/WarehouseControllerProvider.php(997): DataWarehouse\Access\MetricExplorer::getDimensionValueName(Object(XDUser), 'person', '-1')
#3 [internal function]: Rest\Controllers\WarehouseControllerProvider->getQuickFilters(Object(Symfony\Component\HttpFoundation\Request), Object(Silex\Application))
#4 /usr/share/xdmod/vendor/symfony/http-kernel/HttpKernel.php(135): call_user_func_array(Array, Array)
#5 /usr/share/xdmod/vendor/symfony/http-kernel/HttpKernel.php(57): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#6 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(586): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#7 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(563): Silex\Application->handle(Object(Symfony\Component\HttpFoundation\Request))
#8 /usr/share/xdmod/html/rest/index.php(25): Silex\Application->run()
#9 {main}
2022-06-20 13:25:17 [error] Exception Code: 0
2022-06-20 13:25:17 [error] Message: Request for unknown Realm: cloud
2022-06-20 13:25:17 [error] Origin: /usr/share/xdmod/classes/Realm/Realm.php (line 243)
2022-06-20 13:25:17 [error] Trace:
#0 /usr/share/xdmod/classes/User/Elements/QueryDescripter.php(67): Realm\Realm::factory('cloud')
#1 /usr/share/xdmod/classes/Models/Services/Acls.php(1071): User\Elements\QueryDescripter->__construct('cloud', 'vm_size_memory')
#2 /usr/share/xdmod/html/controllers/metric_explorer/get_dw_descripter.php(46): Models\Services\Acls::getQueryDescripters(Object(XDUser))
#3 /usr/share/xdmod/classes/XDController.php(69): include('/usr/share/xdmo...')
#4 /usr/share/xdmod/html/controllers/metric_explorer.php(35): XDController->invoke('REQUEST')
#5 {main}
2022-06-20 13:25:37 [error] Exception Code: 0
2022-06-20 13:25:37 [error] Message: Request for unknown Realm: cloud
2022-06-20 13:25:37 [error] Origin: /usr/share/xdmod/classes/Realm/Realm.php (line 243)
2022-06-20 13:25:37 [error] Trace:
#0 /usr/share/xdmod/classes/DataWarehouse/Access/MetricExplorer.php(1049): Realm\Realm::factory('cloud')
#1 /usr/share/xdmod/classes/DataWarehouse/Access/MetricExplorer.php(1006): DataWarehouse\Access\MetricExplorer::getGroupBy(Object(XDUser), 'cloud', 'person')
#2 /usr/share/xdmod/classes/Rest/Controllers/WarehouseControllerProvider.php(997): DataWarehouse\Access\MetricExplorer::getDimensionValueName(Object(XDUser), 'person', '-1')
#3 [internal function]: Rest\Controllers\WarehouseControllerProvider->getQuickFilters(Object(Symfony\Component\HttpFoundation\Request), Object(Silex\Application))
#4 /usr/share/xdmod/vendor/symfony/http-kernel/HttpKernel.php(135): call_user_func_array(Array, Array)
#5 /usr/share/xdmod/vendor/symfony/http-kernel/HttpKernel.php(57): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#6 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(586): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#7 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(563): Silex\Application->handle(Object(Symfony\Component\HttpFoundation\Request))
#8 /usr/share/xdmod/html/rest/index.php(25): Silex\Application->run()
#9 {main}
2022-06-20 13:26:00 [error] Exception Code: 0
2022-06-20 13:26:00 [error] Message: Request for unknown Realm: cloud
2022-06-20 13:26:00 [error] Origin: /usr/share/xdmod/classes/Realm/Realm.php (line 243)
2022-06-20 13:26:00 [error] Trace:
#0 /usr/share/xdmod/classes/User/Elements/QueryDescripter.php(67): Realm\Realm::factory('cloud')
#1 /usr/share/xdmod/classes/Models/Services/Acls.php(1071): User\Elements\QueryDescripter->__construct('cloud', 'vm_size_memory')
#2 /usr/share/xdmod/html/controllers/metric_explorer/get_dw_descripter.php(46): Models\Services\Acls::getQueryDescripters(Object(XDUser))
#3 /usr/share/xdmod/classes/XDController.php(69): include('/usr/share/xdmo...')
#4 /usr/share/xdmod/html/controllers/metric_explorer.php(35): XDController->invoke('REQUEST')
#5 {main}
2022-06-20 13:26:16 [error] Exception Code: 0
2022-06-20 13:26:16 [error] Message: Request for unknown Realm: cloud
2022-06-20 13:26:16 [error] Origin: /usr/share/xdmod/classes/Realm/Realm.php (line 243)
2022-06-20 13:26:16 [error] Trace:
#0 /usr/share/xdmod/classes/DataWarehouse/Access/MetricExplorer.php(1049): Realm\Realm::factory('cloud')
#1 /usr/share/xdmod/classes/DataWarehouse/Access/MetricExplorer.php(1006): DataWarehouse\Access\MetricExplorer::getGroupBy(Object(XDUser), 'cloud', 'person')
#2 /usr/share/xdmod/classes/Rest/Controllers/WarehouseControllerProvider.php(997): DataWarehouse\Access\MetricExplorer::getDimensionValueName(Object(XDUser), 'person', '-1')
#3 [internal function]: Rest\Controllers\WarehouseControllerProvider->getQuickFilters(Object(Symfony\Component\HttpFoundation\Request), Object(Silex\Application))
#4 /usr/share/xdmod/vendor/symfony/http-kernel/HttpKernel.php(135): call_user_func_array(Array, Array)
#5 /usr/share/xdmod/vendor/symfony/http-kernel/HttpKernel.php(57): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#6 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(586): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#7 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(563): Silex\Application->handle(Object(Symfony\Component\HttpFoundation\Request))
#8 /usr/share/xdmod/html/rest/index.php(25): Silex\Application->run()
#9 {main}
2022-06-20 18:50:30 [error] Exception Code: 0
2022-06-20 18:50:30 [error] Message: Invalid token specified
2022-06-20 18:50:30 [error] Origin: /usr/share/xdmod/classes/Rest/Utilities/Authentication.php (line 261)
2022-06-20 18:50:30 [error] Trace:
#0 /usr/share/xdmod/classes/Rest/Utilities/Authentication.php(113): Rest\Utilities\Authentication::resolveUserFromToken('2e858d8d53495ff...', '10.131.0.1')
#1 /usr/share/xdmod/classes/Rest/Controllers/BaseControllerProvider.php(244): Rest\Utilities\Authentication::authenticateUser(Object(Symfony\Component\HttpFoundation\Request))
#2 [internal function]: Rest\Controllers\BaseControllerProvider::authenticate(Object(Symfony\Component\HttpFoundation\Request), Object(Silex\Application))
#3 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(338): call_user_func('\Rest\Controlle...', Object(Symfony\Component\HttpFoundation\Request), Object(Silex\Application))
#4 [internal function]: Silex\Application->Silex{closure}(Object(Symfony\Component\HttpKernel\Event\GetResponseEvent), 'kernel.request', Object(Symfony\Component\EventDispatcher\EventDispatcher))
#5 /usr/share/xdmod/vendor/symfony/event-dispatcher/EventDispatcher.php(184): call_user_func(Object(Closure), Object(Symfony\Component\HttpKernel\Event\GetResponseEvent), 'kernel.request', Object(Symfony\Component\EventDispatcher\EventDispatcher))
#6 /usr/share/xdmod/vendor/symfony/event-dispatcher/EventDispatcher.php(46): Symfony\Component\EventDispatcher\EventDispatcher->doDispatch(Array, 'kernel.request', Object(Symfony\Component\HttpKernel\Event\GetResponseEvent))
#7 /usr/share/xdmod/vendor/symfony/http-kernel/HttpKernel.php(116): Symfony\Component\EventDispatcher\EventDispatcher->dispatch('kernel.request', Object(Symfony\Component\HttpKernel\Event\GetResponseEvent))
#8 /usr/share/xdmod/vendor/symfony/http-kernel/HttpKernel.php(57): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#9 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(586): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#10 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(563): Silex\Application->handle(Object(Symfony\Component\HttpFoundation\Request))
#11 /usr/share/xdmod/html/rest/index.php(25): Silex\Application->run()
#12 {main}
2022-06-20 18:50:55 [error] Exception Code: 0
2022-06-20 18:50:55 [error] Message: Request for unknown Realm: cloud
2022-06-20 18:50:55 [error] Origin: /usr/share/xdmod/classes/Realm/Realm.php (line 243)
2022-06-20 18:50:55 [error] Trace:
#0 /usr/share/xdmod/classes/User/Elements/QueryDescripter.php(67): Realm\Realm::factory('cloud')
#1 /usr/share/xdmod/classes/Models/Services/Acls.php(1071): User\Elements\QueryDescripter->__construct('cloud', 'vm_size_memory')
#2 /usr/share/xdmod/html/controllers/metric_explorer/get_dw_descripter.php(46): Models\Services\Acls::getQueryDescripters(Object(XDUser))
#3 /usr/share/xdmod/classes/XDController.php(69): include('/usr/share/xdmo...')
#4 /usr/share/xdmod/html/controllers/metric_explorer.php(35): XDController->invoke('REQUEST')
#5 {main}
2022-06-20 18:51:56 [error] Exception Code: 0
2022-06-20 18:51:56 [error] Message: Request for unknown Realm: cloud
2022-06-20 18:51:56 [error] Origin: /usr/share/xdmod/classes/Realm/Realm.php (line 243)
2022-06-20 18:51:56 [error] Trace:
#0 /usr/share/xdmod/classes/DataWarehouse/Access/MetricExplorer.php(1049): Realm\Realm::factory('cloud')
#1 /usr/share/xdmod/classes/DataWarehouse/Access/MetricExplorer.php(1006): DataWarehouse\Access\MetricExplorer::getGroupBy(Object(XDUser), 'cloud', 'person')
#2 /usr/share/xdmod/classes/Rest/Controllers/WarehouseControllerProvider.php(997): DataWarehouse\Access\MetricExplorer::getDimensionValueName(Object(XDUser), 'person', '-1')
#3 [internal function]: Rest\Controllers\WarehouseControllerProvider->getQuickFilters(Object(Symfony\Component\HttpFoundation\Request), Object(Silex\Application))
#4 /usr/share/xdmod/vendor/symfony/http-kernel/HttpKernel.php(135): call_user_func_array(Array, Array)
#5 /usr/share/xdmod/vendor/symfony/http-kernel/HttpKernel.php(57): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#6 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(586): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#7 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(563): Silex\Application->handle(Object(Symfony\Component\HttpFoundation\Request))
#8 /usr/share/xdmod/html/rest/index.php(25): Silex\Application->run()
#9 {main}
2022-06-21 12:40:48 [error] Exception Code: 0
2022-06-21 12:40:48 [error] Message: Request for unknown Realm: cloud
2022-06-21 12:40:48 [error] Origin: /usr/share/xdmod/classes/Realm/Realm.php (line 243)
2022-06-21 12:40:48 [error] Trace:
#0 /usr/share/xdmod/classes/DataWarehouse/Access/MetricExplorer.php(1049): Realm\Realm::factory('cloud')
#1 /usr/share/xdmod/classes/DataWarehouse/Access/MetricExplorer.php(1006): DataWarehouse\Access\MetricExplorer::getGroupBy(Object(XDUser), 'cloud', 'person')
#2 /usr/share/xdmod/classes/Rest/Controllers/WarehouseControllerProvider.php(997): DataWarehouse\Access\MetricExplorer::getDimensionValueName(Object(XDUser), 'person', '-1')
#3 [internal function]: Rest\Controllers\WarehouseControllerProvider->getQuickFilters(Object(Symfony\Component\HttpFoundation\Request), Object(Silex\Application))
#4 /usr/share/xdmod/vendor/symfony/http-kernel/HttpKernel.php(135): call_user_func_array(Array, Array)
#5 /usr/share/xdmod/vendor/symfony/http-kernel/HttpKernel.php(57): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#6 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(586): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#7 /usr/share/xdmod/vendor/silex/silex/src/Silex/Application.php(563): Silex\Application->handle(Object(Symfony\Component\HttpFoundation\Request))
#8 /usr/share/xdmod/html/rest/index.php(25): Silex\Application->run()
#9 {main}
2022-06-21 12:41:54 [error] Exception Code: 2003
2022-06-21 12:41:54 [error] Message: SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'mariadb' (110)
2022-06-21 12:41:54 [error] Origin: /usr/share/xdmod/classes/CCR/DB/PDODB.php (line 88)
2022-06-21 12:41:54 [error] Trace:
#0 /usr/share/xdmod/classes/CCR/DB/PDODB.php(88): PDO->__construct('mysql:host=mari...', 'xdmod', 'pass')
#1 /usr/share/xdmod/classes/CCR/DB.php(111): CCR\DB\PDODB->connect()
#2 /usr/share/xdmod/classes/DataWarehouse/Export/QueryHandler.php(79): CCR\DB::factory('database')
#3 /usr/share/xdmod/classes/Rest/Controllers/WarehouseExportControllerProvider.php(53): DataWarehouse\Export\QueryHandler->__construct(Object(CCR\Logger))
#4 /usr/share/xdmod/classes/Rest/XdmodApplicationFactory.php(184): Rest\Controllers\WarehouseExportControllerProvider->__construct(Array)
#5 /usr/share/xdmod/html/rest/index.php(22): Rest\XdmodApplicationFactory::getInstance()
#6 {main}
2022-06-21 16:29:25 [error] Exception Code: 0
2022-06-21 16:29:25 [error] Message: Request for unknown Realm: cloud
2022-06-21 16:29:25 [error] Origin: /usr/share/xdmod/classes/Realm/Realm.php (line 243)
2022-06-21 16:29:25 [error] Trace:
#0 /usr/share/xdmod/classes/User/Elements/QueryDescripter.php(67): Realm\Realm::factory('cloud')
#1 /usr/share/xdmod/classes/Models/Services/Acls.php(1071): User\Elements\QueryDescripter->__construct('cloud', 'vm_size_memory')
#2 /usr/share/xdmod/html/controllers/metric_explorer/get_dw_descripter.php(46): Models\Services\Acls::getQueryDescripters(Object(XDUser))
#3 /usr/share/xdmod/classes/XDController.php(69): include('/usr/share/xdmo...')
#4 /usr/share/xdmod/html/controllers/metric_explorer.php(35): XDController->invoke('REQUEST')
#5 {main}
Any suggestions?
PNG
Screen Shot ...
(170 KB)
PNG
Screen Shot ...
(171 KB)
JPG
xdmod_de1.jpg
(163 KB)
Ryan Rathsam , said about 1 year ago
Ticket: https://help.xdmod.org/support/tickets/30440
Hi Robert,
Are you able to connect from the command line on the xdmod host to the database w/ the credentials you have specified in portal_settings.ini ?
Robert Bartlett Baron , said about 1 year ago
Ryan,
Yes I am. Occasionally, the database connection is dropped, but it is not very frequent. Furthermore, the interface wouldn't load to this point if it was not able to connect.
Even as infrequently as it happens, we do have a problem with the database dropping the connection that we are working on resolving. However, I do not believe it is at the root of this problem.
Which table does the metric explorer use to find the realm?
Rob.
Robert Bartlett Baron , said about 1 year ago
For example:
find the pod that is running the xdmod container:
Rob@Roberts-Computer xdmod-pr-phpssid % oc get pods
NAME READY STATUS RESTARTS AGE
bc-xdmod-26-build 0/1 Completed 0 43h
mariadb-748974547d-mrcn6 1/1 Running 0 10d
moc-xdmod-6bcbb557d-gdx94 1/1 Running 0 22h
rsh into the container
Rob@Roberts-Computer xdmod-pr-phpssid % oc rsh moc-xdmod-6bcbb557d-gdx94
connect to the database using the 'xdmod' user
sh-4.2$ mysql -h mariadb --protocol=tcp -u xdmod -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 579
Server version: 10.3.34-MariaDB-1:10.3.34+maria~focal mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> select * from moddb.realms;
+----------+-----------+---------+---------+
| realm_id | module_id | name | display |
+----------+-----------+---------+---------+
| 1 | 1 | cloud | Cloud |
| 4 | 1 | jobs | Jobs |
| 5 | 1 | storage | Storage |
+----------+-----------+---------+---------+
3 rows in set (0.00 sec)
MariaDB [(none)]>
I am using the same username/password in the portal_settings.ini file.
Robert Bartlett Baron , said 11 months ago
I am closing that as we finally found the configuration issue that has been plaguing us.
Robert Bartlett Baron , said 11 months ago
we can close this issue.
The text was updated successfully, but these errors were encountered: