KSQL server failed to start after upgrade

I just upgraded a small Confluent Kafka cluster at a customer. Almost everything went fine, just following these instructions: https://docs.confluent.io/current/installation/upgrade.html (our servers are running on CentOS). But at the end KSQL server wouldn’t start and failed with this error message: [2019-07-11 16:23:31,233] ERROR Failed to start KSQL (io.confluent.ksql.rest.server.KsqlServerMain:53) java.lang.IllegalStateException: Invalid replcation factor on topic _confluent-ksql-default__command_topic: 1 at io.confluent.ksql.rest.util.KsqlInternalTopicUtils.ensureTopic(KsqlInternalTopicUtils.java:91) at io.confluent.ksql.rest.server.KsqlRestApplication.initialize(KsqlRestApplication.java:237) at io.confluent.ksql.rest.server.KsqlRestApplication.startKsql(KsqlRestApplication.java:200) at io.confluent.ksql.rest.server.KsqlRestApplication.start(KsqlRestApplication.java:187) at io.confluent.ksql.rest.server.KsqlServerMain.tryStartApp(KsqlServerMain.java:65) at io.confluent.ksql.rest.server.KsqlServerMain.main(KsqlServerMain.java:51) I checked the replication factor with: ...

July 11, 2019 · 1 min · Øyvind Isene

Removing obsolete parameters from spfile

This is a common error message after upgrade of the database: ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance In 11g (last tested with 11.2.0.3) even if your start up the database from an old type pfile without any obsolete parameters and then create an spfile from memory like this: create spfile from memory; Oracle will insert two obsolete parameters into the spfile. This query will list obsolete parameters in your spfile: ...

April 14, 2013 · 1 min · Øyvind Isene