You can reset Ambari and delete the contents of the database with ./ambari-server reset
But it will flatten your installation and effectively be like starting from the beginning, nothing is remembered. It's very destructive. On Wed., Jun. 17, 2020, 03:10 Leoš Literák, <[email protected]> wrote: > Hi, > > my colleague has installed the Ambari + Hadoop stack on our servers. He > used Postgresql 11 to store the information. Then I had to downgrade the > Postgresql to 9.3.9. I have exported the ambari schema from 11 to 9.3.9. > Since then Ambari stopped working even when we started Postgresql 11 again. > > The current situation is that I can log in to Ambari and it shows an > empty installation with Launch wizard. Hadoop is stopped and there are no > manual scripts. The colleague is not available and I need to continue. > > It is Ambari 2.6.2.2. > > ambari-server.out > Database consistency check result: DB_CHECK_WARNING > > ambari-server.log > 17 Jun 2020 07:10:43,169 INFO [main] ControllerModule:224 - Detected > POSTGRES as the database type from the JDBC URL > 17 Jun 2020 07:10:43,181 INFO [main] ControllerModule:267 - Using c3p0 > ComboPooledDataSource as the EclipsLink DataSource > 17 Jun 2020 07:10:52,612 INFO [main] StackModule:191 - Resolve: HDP:2.6 > 17 Jun 2020 07:10:52,612 INFO [main] StackModule:374 - > mergeServiceWithExplicitParentcommon-services/DRUID/0.10.1 > 17 Jun 2020 07:10:52,612 INFO [main] ServiceModule:185 - Resolve service > 17 Jun 2020 07:10:52,612 INFO [main] ServiceModule:198 - Display name > service/parent: null/Druid > 17 Jun 2020 07:11:06,165 INFO [main] WebApplicationImpl:815 - Initiating > Jersey application, version 'Jersey: 1.19 02/11/2015 03:25 AM' > 17 Jun 2020 07:11:06,310 WARN [main] Errors:173 - The following warnings > have been detected with resource and/or provider classes: > WARNING: A HTTP GET method, public javax.ws.rs.core.Response > org.apache.ambari.server.api.services.ActionService.getActionDefinitions(java.lang.String,javax.ws.rs.core.HttpHeaders,javax.ws.rs.core.UriInfo), > should not consume any entity. > 17 Jun 2020 07:11:06,427 INFO [main] AmbariServer:565 - ********* Started > Server ********** > 17 Jun 2020 07:12:15,345 ERROR [alert-event-bus-1] > AlertReceivedListener:480 - Unable to process alert > yarn_resourcemanager_webui for an invalid cluster named centaur_sandbox > 17 Jun 2020 07:12:15,345 ERROR [alert-event-bus-2] > AlertReceivedListener:480 - Unable to process alert > ams_metrics_collector_process for an invalid cluster named centaur_sandbox > 17 Jun 2020 08:46:06,661 INFO [pool-18-thread-1] MetricsServiceImpl:65 - > Attempting to initialize metrics sink > 17 Jun 2020 08:46:06,661 INFO [pool-18-thread-1] MetricsServiceImpl:81 - > ********* Configuring Metric Sink ********** > 17 Jun 2020 08:46:06,661 INFO [pool-18-thread-1] AmbariMetricSinkImpl:95 > - No clusters configured. > 17 Jun 2020 08:46:13,343 ERROR [alert-event-bus-2] > AlertReceivedListener:480 - Unable to process alert > ams_metrics_collector_process for an invalid cluster named centaur_sandbox > 17 Jun 2020 08:46:13,343 ERROR [alert-event-bus-2] > AlertReceivedListener:480 - Unable to process alert ambari_agent_disk_usage > for an invalid cluster named centaur_sandbox > 17 Jun 2020 08:46:13,343 ERROR [alert-event-bus-2] > AlertReceivedListener:480 - Unable to process alert datanode_webui for an > invalid cluster named centaur_sandbox > 17 Jun 2020 08:46:13,344 ERROR [alert-event-bus-2] > AlertReceivedListener:480 - Unable to process alert > ams_metrics_collector_autostart for an invalid cluster named centaur_sandbox > > *select * from host* returns 3 rows > > ambari=> select * from stack; > stack_id | stack_name | stack_version > ----------+-------------+----------------- > 1 | HDP | 2.0.6 > 2 | HDP | 2.3.ECS > 16 | BigInsights | 4.2 > (16 rows) > > Tables groups, clusters are empty. Well, most of the tables are empty. > > If the ambari schema is broken, is there any reasonable way to populate it > again from the existing cluster? Or does it mean we have to remove all > components and start the wizard from scratch? > > Thank you > > Leos >
