-
Bug
-
Resolution: Done
-
High
-
Casablanca Release
-
None
-
Casablanca-RC1 (10/12-10/25)
Rolling exceptions related to invalid database schema.
==> common-modules/integrity-monitor/error.log <====> common-modules/integrity-monitor/error.log <==2018-10-17T01:09:48.561Z|||Thread-7||||ERROR|||||org.mariadb.jdbc.MariaDbStatement||error executing queryjava.sql.SQLIntegrityConstraintViolationException: (conn=1053) Column 'remote' cannot be null at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:171) at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:110) at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:228) at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:216) at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:150) at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeUpdate(MariaDbPreparedStatementClient.java:183) at org.onap.xacml.parser.ParseLog.dbAccesss(ParseLog.java:697) at org.onap.xacml.parser.ParseLog.writeDb(ParseLog.java:653) at org.onap.xacml.parser.ParseLog.process(ParseLog.java:643) at org.onap.xacml.parser.ParseLog.lambda$processLine$1(ParseLog.java:139) at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184) at java.util.stream.SliceOps$1$1.accept(SliceOps.java:204) at java.util.Iterator.forEachRemaining(Iterator.java:116) at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801) at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471) at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151) at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174) at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) at java.util.stream.ReferencePipeline.forEachOrdered(ReferencePipeline.java:423) at org.onap.xacml.parser.ParseLog.processLine(ParseLog.java:139) at org.onap.xacml.parser.ParseLog.access$100(ParseLog.java:61) at org.onap.xacml.parser.ParseLog$3.run(ParseLog.java:286) at java.lang.Thread.run(Thread.java:748)Caused by: java.sql.SQLException: Column 'remote' cannot be nullQuery is: insert into SYSTEMLOGDB values (NULL, ?, ?, ?, ?, ?, ?);, parameters ['https://pap:9091/pap/','Request URI: /pap/onap/pushPolicy',<null>,'PAP','2018-10-17 01:09:22','INFO'] at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:153) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:255) at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:209) ... 20 common frames omitted2018-10-17T01:09:48.561Z|||Thread-7||||ERROR|||||com.att.eelf.error||POLICY-515E ERROR: Error trying to excute SQL Statment: java.sql.SQLIntegrityConstraintViolationException: (conn=1053) Column 'remote' cannot be null2018-10-17T01:09:48.563Z|||Thread-7||||ERROR|||||org.mariadb.jdbc.MariaDbStatement||error executing queryjava.sql.SQLIntegrityConstraintViolationException: (conn=1054) Column 'remote' cannot be null at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:171) at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:110) at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:228) at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:216) at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:150) at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeUpdate(MariaDbPreparedStatementClient.java:183) at org.onap.xacml.parser.ParseLog.dbAccesss(ParseLog.java:697) at org.onap.xacml.parser.ParseLog.writeDb(ParseLog.java:653) at org.onap.xacml.parser.ParseLog.process(ParseLog.java:643) at org.onap.xacml.parser.ParseLog.lambda$processLine$1(ParseLog.java:139) at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184) at java.util.stream.SliceOps$1$1.accept(SliceOps.java:204) at java.util.Iterator.forEachRemaining(Iterator.java:116) at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801) at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471) at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151) at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174) at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) at java.util.stream.ReferencePipeline.forEachOrdered(ReferencePipeline.java:423) at org.onap.xacml.parser.ParseLog.processLine(ParseLog.java:139) at org.onap.xacml.parser.ParseLog.access$100(ParseLog.java:61) at org.onap.xacml.parser.ParseLog$3.run(ParseLog.java:286) at java.lang.Thread.run(Thread.java:748)Caused by: java.sql.SQLException: Column 'remote' cannot be nullQuery is: insert into SYSTEMLOGDB values (NULL, ?, ?, ?, ?, ?, ?);, parameters ['https://pap:9091/pap/','Adding Cors Response Headers!!!',<null>,'PAP','2018-10-17 01:09:22','INFO'] at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:153) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:255) at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:209) ... 20 common frames omitted2018-10-17T01:09:48.563Z|||Thread-7||||ERROR|||||com.att.eelf.error||POLICY-515E ERROR: Error trying to excute SQL Statment: java.sql.SQLIntegrityConstraintViolationException: (conn=1054) Column 'remote' cannot be null
==> common-modules/integrity-monitor/debug.log <==2018-10-17T01:09:48.563Z|||Thread-7||||ERROR|||||org.mariadb.jdbc.MariaDbStatement||error executing queryjava.sql.SQLIntegrityConstraintViolationException: (conn=1054) Column 'remote' cannot be null at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:171) at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:110) at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:228) at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:216) at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:150) at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeUpdate(MariaDbPreparedStatementClient.java:183) at org.onap.xacml.parser.ParseLog.dbAccesss(ParseLog.java:697) at org.onap.xacml.parser.ParseLog.writeDb(ParseLog.java:653) at org.onap.xacml.parser.ParseLog.process(ParseLog.java:643) at org.onap.xacml.parser.ParseLog.lambda$processLine$1(ParseLog.java:139) at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184) at java.util.stream.SliceOps$1$1.accept(SliceOps.java:204) at java.util.Iterator.forEachRemaining(Iterator.java:116) at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801) at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471) at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151) at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174) at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) at java.util.stream.ReferencePipeline.forEachOrdered(ReferencePipeline.java:423) at org.onap.xacml.parser.ParseLog.processLine(ParseLog.java:139) at org.onap.xacml.parser.ParseLog.access$100(ParseLog.java:61) at org.onap.xacml.parser.ParseLog$3.run(ParseLog.java:286) at java.lang.Thread.run(Thread.java:748)Caused by: java.sql.SQLException: Column 'remote' cannot be null