Hi,
Occasionally I am getting this exception:
Exception in thread "pool-2-thread-2"
org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL
[INSERT INTO COM_AUDIT_TRAIL (AUD_USER, AUD_CLIENT_IP, AUD_SERVER_IP,
AUD_RESOURCE, AUD_ACTION, APPLIC_CD, AUD_DATE) VALUES (?, ?, ?, ?, ?, ?, ?)];
Duplicate entry
'test-all-172.21.20.68-172.21.28.208-cellevault-mng.cellebrite.co' for key
'PRIMARY'; nested exception is
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Duplicate entry
'test-all-172.21.20.68-172.21.28.208-cellevault-mng.cellebrite.co' for key
'PRIMARY'
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:241)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:812)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:868)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:876)
at
org.springframework.jdbc.core.simple.SimpleJdbcTemplate.update(SimpleJdbcTemplate.java:253)
at
com.github.inspektr.audit.support.JdbcAuditTrailManager$LoggingTask$1.doInTransactionWithoutResult(JdbcAuditTrailManager.java:154)
at
org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
at
com.github.inspektr.audit.support.JdbcAuditTrailManager$LoggingTask.run(JdbcAuditTrailManager.java:147)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Duplicate entry
'test-all-172.21.20.68-172.21.28.208-cellevault-mng.cellebrite.co' for key
'PRIMARY'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2377)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2361)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at
org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:818)
at
org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:1)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
... 11 more
This is how I declare that table:
CREATE TABLE `COM_AUDIT_TRAIL` (
`AUD_USER` varchar(100) NOT NULL ,
`AUD_CLIENT_IP` VARCHAR(15) NOT NULL ,
`AUD_SERVER_IP` VARCHAR(15) NOT NULL ,
`AUD_RESOURCE` varchar(100) NOT NULL ,
`AUD_ACTION` varchar(100) NOT NULL ,
`APPLIC_CD` varchar(5) NOT NULL ,
`AUD_DATE` TIMESTAMP NOT NULL
);
ALTER TABLE `COM_AUDIT_TRAIL`
ADD CONSTRAINT `COM_AUDIT_TRAIL_PK`
PRIMARY KEY (
`AUD_USER`,
`AUD_CLIENT_IP`,
`AUD_SERVER_IP`,
`AUD_RESOURCE`,
`AUD_ACTION`,
`APPLIC_CD`,
`AUD_DATE`
) ;
Any idea what's wrong?
thanks.
--
You are currently subscribed to [email protected] as:
[email protected]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/cas-user
