net.maizegenetics.analysis.gbs.v2.SNPQualityProfilerPlugin: time: Nov 6, 2015 14:29:35 [pool-1-thread-1] INFO net.maizegenetics.plugindef.AbstractPlugin - SNPQualityProfilerPlugin Parameters taxa: null db: /home/rollins/gouldian_gbs/Ref_genome/T5/datab/t5pl.db tname: null statFile: SNPqualstats_151104.txt deleteOldData: false size of all tags in tag table=1385147 size of all tags in mappingApproach table=2 size of all taxa in taxa table=288 sublist [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287] size of all positions in snpPosition table=346972 Processing Positions between 0 and 10,000.java.sql.SQLException: UNIQUE constraint failed: snpQuality.snpid, snpQuality.taxasubset


Solutions on the web

Solution icon of googlegroups
via Google Groups by Peri Bolton, 4 months ago
, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89

Stack trace

net.maizegenetics.analysis.gbs.v2.SNPQualityProfilerPlugin: time: 
Nov 6, 2015 14:29:35
[pool-1-thread-1] INFO net.maizegenetics.plugindef.AbstractPlugin - 
SNPQualityProfilerPlugin Parameters
taxa: null
db: /home/rollins/gouldian_gbs/Ref_genome/T5/datab/t5pl.db
tname: null
statFile: SNPqualstats_151104.txt
deleteOldData: false

size of all tags in tag table=1385147
size of all tags in mappingApproach table=2
size of all taxa in taxa table=288
sublist
[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 
21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 
40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 
59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 
78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 
97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 
112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 
127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 
142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 
157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 
172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 
187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 
202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 
217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 
232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 
247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 
262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 
277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287]
size of all positions in snpPosition table=346972
Processing Positions between 0 and 10,000.java.sql.SQLException: UNIQUE 
constraint failed: snpQuality.snpid, snpQuality.taxasubset
	at org.sqlite.core.DB.throwex(DB.java:859)
	at org.sqlite.core.DB.executeBatch(DB.java:760)
	at org.sqlite.core.CorePreparedStatement.executeBatch(CorePreparedStatement.java:77)
	at net.maizegenetics.dna.tag.TagDataSQLite.putSNPQualityProfile(TagDataSQLite.java:535)
	at net.maizegenetics.analysis.gbs.v2.SNPQualityProfilerPlugin.processData(SNPQualityProfilerPlugin.java:204)
	at net.maizegenetics.plugindef.AbstractPlugin.performFunction(AbstractPlugin.java:108)
	at net.maizegenetics.plugindef.AbstractPlugin.dataSetReturned(AbstractPlugin.java:1585)
	at net.maizegenetics.plugindef.ThreadedPluginListener.run(ThreadedPluginListener.java:29)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.