Skip to content
This repository has been archived by the owner on Dec 8, 2022. It is now read-only.

Add Case test fails #36

Closed
paddatrapper opened this issue Jul 29, 2015 · 1 comment
Closed

Add Case test fails #36

paddatrapper opened this issue Jul 29, 2015 · 1 comment

Comments

@paddatrapper
Copy link
Owner

Not sure the direct cause, but the add case test fails after a few runs. Flushing the db fixes the issue

@paddatrapper
Copy link
Owner Author

Turns out it is caused by a MySQL Database Truncation error as case number is too long:

21:07:10 [Thread-7 ERROR c.k.c.s.datalayer.CaseRepository - Error inserting case 2015-07-00010 - Something happened
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'caseNumber' at row 1
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3885) ~[server-0.1a-SNAPSHOT-jar-with-dependencies.jar:na]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[server-0.1a-SNAPSHOT-jar-with-dependencies.jar:na]
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[server-0.1a-SNAPSHOT-jar-with-dependencies.jar:na]
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[server-0.1a-SNAPSHOT-jar-with-dependencies.jar:na]
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[server-0.1a-SNAPSHOT-jar-with-dependencies.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[server-0.1a-SNAPSHOT-jar-with-dependencies.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141) ~[server-0.1a-SNAPSHOT-jar-with-dependencies.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2077) ~[server-0.1a-SNAPSHOT-jar-with-dependencies.jar:na]
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2062) ~[server-0.1a-SNAPSHOT-jar-with-dependencies.jar:na]
    at com.kritsit.casetracker.server.datalayer.DatabasePersistence.set(DatabasePersistence.java:134) ~[server-0.1a-SNAPSHOT-jar-with-dependencies.jar:na]
    at com.kritsit.casetracker.server.datalayer.DatabasePersistence.executeUpdate(DatabasePersistence.java:119) ~[server-0.1a-SNAPSHOT-jar-with-dependencies.jar:na]
    at com.kritsit.casetracker.server.datalayer.CaseRepository.insertCase(CaseRepository.java:167) ~[server-0.1a-SNAPSHOT-jar-with-dependencies.jar:na]
    at com.kritsit.casetracker.server.domain.services.ClientConnectionThread.run(ClientConnectionThread.java:100) [server-0.1a-SNAPSHOT-jar-with-dependencies.jar:na]
    at java.lang.Thread.run(Thread.java:745) [na:1.8.0_60]

paddatrapper pushed a commit that referenced this issue Sep 10, 2015
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant