https://community.cloudera.com/t5/Support-Questions/Possible-to-create-duplicate-Avro-Schemas-in-the-Schema/m-p/202708#M164714 <P>Thanks. I gave it a try. The SQL script now runs correctly. However when I try to create add a new schema I see this error in the registry.log file:</P><P>ERROR [13:21:06.461] [dw-27 - POST /api/v1/schemaregistry/schemas] c.h.r.s.w.SchemaRegistryResource - Error encountered while adding schema info [SchemaMetadata{type='avro', schemaGroup='sales-nxt-email', name='test', description='test', compatibility=BACKWARD, evolve=true}]<BR />com.hortonworks.registries.storage.exception.StorageException: org.postgresql.util.PSQLException: ERROR: null value in column "validationLevel" violates not-null constraint<BR /> Detail: Failing row contains (2, avro, sales-nxt-email, test, BACKWARD, null, test, t, 1502734866442).<BR /> at com.hortonworks.registries.storage.impl.jdbc.provider.sql.factory.AbstractQueryExecutor$QueryExecution.executeUpdate(AbstractQueryExecutor.java:225)<BR /> at com.hortonworks.registries.storage.impl.jdbc.provider.sql.factory.AbstractQueryExecutor.executeUpdate(AbstractQueryExecutor.java:182)<BR /> at com.hortonworks.registries.storage.impl.jdbc.provider.postgresql.factory.PostgresqlExecutor.insertOrUpdateWithUniqueId(PostgresqlExecutor.java:182)<BR /> at com.hortonworks.registries.storage.impl.jdbc.provider.postgresql.factory.PostgresqlExecutor.insert(PostgresqlExecutor.java:80)<BR /> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.add(JdbcStorageManager.java:66)<BR /> at com.hortonworks.registries.schemaregistry.DefaultSchemaRegistry.addSchemaMetadata(DefaultSchemaRegistry.java:168)<BR /> at com.hortonworks.registries.schemaregistry.webservice.SchemaRegistryResource.lambda$addSchemaInfo$1(SchemaRegistryResource.java:380)<BR /> at com.hortonworks.registries.schemaregistry.webservice.SchemaRegistryResource.handleLeaderAction(SchemaRegistryResource.java:158)<BR /> at com.hortonworks.registries.schemaregistry.webservice.SchemaRegistryResource.addSchemaInfo(SchemaRegistryResource.java:371)<BR /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<BR /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR /> at java.lang.reflect.Method.invoke(Method.java:498)</P><P>Looking at the create_tables.sql script for the schema_metadata_info table it appears there is a new column called "validationLevel" that is not in the original script that was used to install schema registry. Should this column allow nulls?</P><P>--New Script</P><P>CREATE TABLE IF NOT EXISTS schema_metadata_info (<BR /><BR /> "id" SERIAL UNIQUE NOT NULL,<BR /><BR /> "type" VARCHAR(255) NOT NULL,<BR /><BR /> "schemaGroup" VARCHAR(255) NOT NULL,<BR /><BR /> "name" VARCHAR(255) NOT NULL,<BR /><BR /> "compatibility" VARCHAR(255) NOT NULL,<BR /><BR /> <EM><STRONG>"validationLevel" VARCHAR(255) NOT NULL, -- added in 0.3.1, table should be altered to add this column from earlier versions.</STRONG></EM><BR /><BR /> "description" TEXT,<BR /><BR /> "evolve" BOOLEAN NOT NULL,<BR /><BR /> "timestamp" BIGINT NOT NULL,<BR /><BR /> PRIMARY KEY ( "name"),<BR /><BR /> UNIQUE ("id")<BR /><BR />);</P><P>--Script which was originally used to install Schema Registry</P><P>CREATE TABLE IF NOT EXISTS schema_metadata_info (<BR /> "id" SERIAL PRIMARY KEY,<BR /> "type" VARCHAR(256) NOT NULL,<BR /> "schemaGroup" VARCHAR(256) NOT NULL,<BR /> "name" VARCHAR(256) NOT NULL,<BR /> "compatibility" VARCHAR(256) NOT NULL,<BR /> "description" TEXT,<BR /> "evolve" BOOLEAN NOT NULL,<BR /> "timestamp" BIGINT NOT NULL,<BR /> UNIQUE("id","name")<BR />);</P> Tue, 15 Aug 2017 01:27:14 GMT kirk_demumbrane 2017-08-15T01:27:14Z