gistfile1.txt

perl gmod_load_cvterms.pl -s CO -H localhost -D zea  -r postgres -p zeabase207 -d Pg -u maize_trait.obo
This script will UPDATE cvterms stored in your database from the input file! 
Default for -s: CO (specifies the database names for Dbxref objects)
Default for -F: File format set to obo
Connected to database zea on host localhost.
Parsing the ontology maize_trait.obo...
Default namespace is maize_trait 
....found namespace  'maize_trait' 
cv_id = 3
Updating an ontology in the database...
Ontology name: maize_trait
Getting all the terms of the new ontology...
***found 10 predicate terms!.
Retrieved 399 terms.
predicate term 'IS_A' already exists with cv_id 1
Predicate term PART_OF will be stored later if used as a relationship in an ontology term
Predicate term RELATED_TO will be stored later if used as a relationship in an ontology term
Predicate term REGULATES will be stored later if used as a relationship in an ontology term
Predicate term POSITIVELY_REGULATES will be stored later if used as a relationship in an ontology term
Predicate term NEGATIVELY_REGULATES will be stored later if used as a relationship in an ontology term
Predicate term METHOD_OF will be stored later if used as a relationship in an ontology term
Predicate term SCALE_OF will be stored later if used as a relationship in an ontology term
Predicate term PART_OF will be stored later if used as a relationship in an ontology term
Predicate term DERIVED_FROM will be stored later if used as a relationship in an ontology term
Getting all the terms of the current ontology...
Indexing terms and relationships...
Found term in file :  CO_322:0000125
Found term in file :  CO_322:0000028
Found term in file :  CO_322:0000276
Found term in file :  CO_322:0000088
Found term in file :  CO_322:0000206
Found term in file :  CO_322:0000116
Found term in file :  CO_322:0000069
Found term in file :  CO_322:0000100
Found term in file :  CO_322:0000358
Found term in file :  CO_322:0000331
Found term in file :  CO_322:0000012
Found term in file :  CO_322:0000053
Found term in file :  CO_322:0000082
Found term in file :  CO_322:0000233
Found term in file :  CO_322:0000259
Found term in file :  CO_322:0000194
Found term in file :  CO_322:0000055
Found term in file :  CO_322:0000368
Found term in file :  CO_322:0000220
Found term in file :  CO_322:0000316
Found term in file :  CO_322:0000161
Found term in file :  CO_322:0000395
Found term in file :  CO_322:0000087
Found term in file :  CO_322:0000173
Found term in file :  CO_322:0000027
Found term in file :  CO_322:0000033
Found term in file :  CO_322:0000007
Found term in file :  CO_322:0000347
Found term in file :  CO_322:0000208
Found term in file :  CO_322:0000091
Found term in file :  CO_322:0000292
Found term in file :  CO_322:0000378
Found term in file :  CO_322:0000325
Found term in file :  CO_322:0000025
Found term in file :  CO_322:0000350
Found term in file :  CO_322:0000291
Found term in file :  CO_322:0000374
Found term in file :  CO_322:0000199
Found term in file :  CO_322:0000112
Found term in file :  CO_322:0000226
Found term in file :  CO_322:0000056
Found term in file :  CO_322:0000211
Found term in file :  CO_322:0000151
Found term in file :  CO_322:0000011
Found term in file :  CO_322:0000382
Found term in file :  CO_322:0000337
Found term in file :  CO_322:0000099
Found term in file :  CO_322:0000071
Found term in file :  CO_322:0000340
Found term in file :  CO_322:0000074
Found term in file :  CO_322:0000311
Found term in file :  CO_322:0000060
Found term in file :  CO_322:0000065
Found term in file :  CO_322:0000241
Found term in file :  CO_322:0000198
Found term in file :  CO_322:0000137
Found term in file :  CO_322:0000389
Found term in file :  CO_322:0000127
Found term in file :  CO_322:0000327
Found term in file :  CO_322:0000320
Found term in file :  CO_322:0000280
Found term in file :  CO_322:0000273
Found term in file :  CO_322:0000236
Found term in file :  CO_322:0000361
Found term in file :  CO_322:0000249
Found term in file :  CO_322:0000218
Found term in file :  CO_322:0000202
Found term in file :  CO_322:0000166
Found term in file :  CO_322:0000184
Found term in file :  CO_322:0000133
Found term in file :  CO_322:0000010
Found term in file :  CO_322:0000348
Found term in file :  CO_322:0000143
Found term in file :  CO_322:0000047
Found term in file :  CO_322:0000178
Found term in file :  CO_322:0000019
Found term in file :  CO_322:0000285
Found term in file :  CO_322:0000138
Found term in file :  CO_322:0000122
Found term in file :  CO_322:0000102
Found term in file :  CO_322:0000129
Found term in file :  CO_322:0000181
Found term in file :  CO_322:0000385
Found term in file :  CO_322:0000234
Found term in file :  CO_322:0000314
Found term in file :  CO_322:0000307
Found term in file :  CO_322:0000152
Found term in file :  CO_322:0000000
Found term in file :  CO_322:0000018
Found term in file :  CO_322:0000388
Found term in file :  CO_322:0000364
Found term in file :  CO_322:0000094
Found term in file :  CO_322:0000355
Found term in file :  CO_322:0000157
Found term in file :  CO_322:0000326
Found term in file :  CO_322:0000158
Found term in file :  CO_322:0000045
Found term in file :  CO_322:0000367
Found term in file :  CO_322:0000023
Found term in file :  CO_322:0000096
Found term in file :  CO_322:0000335
Found term in file :  CO_322:0000035
Found term in file :  CO_322:0000041
Found term in file :  CO_322:0000270
Found term in file :  CO_322:0000195
Found term in file :  CO_322:0000003
Found term in file :  CO_322:0000391
Found term in file :  CO_322:0000016
Found term in file :  CO_322:0000288
Found term in file :  CO_322:0000193
Found term in file :  CO_322:0000117
Found term in file :  CO_322:0000324
Found term in file :  CO_322:0000180
Found term in file :  CO_322:0000244
Found term in file :  CO_322:0000160
Found term in file :  CO_322:0000351
Found term in file :  CO_322:0000246
Found term in file :  CO_322:0000240
Found term in file :  CO_322:0000072
Found term in file :  CO_322:0000334
Found term in file :  CO_322:0000059
Found term in file :  CO_322:0000230
Found term in file :  CO_322:0000299
Found term in file :  CO_322:0000113
Found term in file :  CO_322:0000377
Found term in file :  CO_322:0000101
Found term in file :  CO_322:0000201
Found term in file :  CO_322:0000379
Found term in file :  CO_322:0000111
Found term in file :  CO_322:0000150
Found term in file :  CO_322:0000189
Found term in file :  CO_322:0000342
Found term in file :  CO_322:0000295
Found term in file :  CO_322:0000266
Found term in file :  CO_322:0000089
Found term in file :  CO_322:0000341
Found term in file :  CO_322:0000105
Found term in file :  CO_322:0000085
Found term in file :  CO_322:0000172
Found term in file :  CO_322:0000075
Found term in file :  CO_322:0000214
Found term in file :  CO_322:0000221
Found term in file :  CO_322:0000037
Found term in file :  CO_322:0000062
Found term in file :  CO_322:0000095
Found term in file :  CO_322:0000008
Found term in file :  CO_322:0000039
Found term in file :  CO_322:0000050
Found term in file :  CO_322:0000312
Found term in file :  CO_322:0000302
Found term in file :  CO_322:0000229
Found term in file :  CO_322:0000043
Found term in file :  CO_322:0000260
Found term in file :  CO_322:0000237
Found term in file :  CO_322:0000370
Found term in file :  CO_322:0000309
Found term in file :  CO_322:0000188
Found term in file :  CO_322:0000066
Found term in file :  CO_322:0000315
Found term in file :  CO_322:0000001
Found term in file :  CO_322:0000134
Found term in file :  CO_322:0000114
Found term in file :  CO_322:0000338
Found term in file :  CO_322:0000142
Found term in file :  CO_322:0000380
Found term in file :  CO_322:0000098
Found term in file :  CO_322:0000300
Found term in file :  CO_322:0000222
Found term in file :  CO_322:0000020
Found term in file :  CO_322:0000286
Found term in file :  CO_322:0000118
Found term in file :  CO_322:0000081
Found term in file :  CO_322:0000381
Found term in file :  CO_322:0000305
Found term in file :  CO_322:0000308
Found term in file :  CO_322:0000392
Found term in file :  CO_322:0000254
Found term in file :  CO_322:0000177
Found term in file :  CO_322:0000373
Found term in file :  CO_322:0000217
Found term in file :  CO_322:0000328
Found term in file :  CO_322:0000239
Found term in file :  CO_322:0000120
Found term in file :  CO_322:0000141
Found term in file :  CO_322:0000281
Found term in file :  CO_322:0000269
Found term in file :  CO_322:0000205
Found term in file :  CO_322:0000156
Found term in file :  CO_322:0000040
Found term in file :  CO_322:0000017
Found term in file :  CO_322:0000363
Found term in file :  CO_322:0000044
Found term in file :  CO_322:0000235
Found term in file :  CO_322:0000301
Found term in file :  CO_322:0000006
Found term in file :  CO_322:0000034
Found term in file :  CO_322:0000213
Found term in file :  CO_322:0000183
Found term in file :  CO_322:0000092
Found term in file :  CO_322:0000049
Found term in file :  CO_322:0000362
Found term in file :  CO_322:0000317
Found term in file :  CO_322:0000296
Found term in file :  CO_322:0000265
Found term in file :  CO_322:0000167
Found term in file :  CO_322:0000130
Found term in file :  CO_322:0000169
Found term in file :  CO_322:0000398
Found term in file :  CO_322:0000384
Found term in file :  CO_322:0000386
Found term in file :  CO_322:0000200
Found term in file :  CO_322:0000174
Found term in file :  CO_322:0000376
Found term in file :  CO_322:0000366
Found term in file :  CO_322:0000123
Found term in file :  CO_322:0000329
Found term in file :  CO_322:0000042
Found term in file :  CO_322:0000022
Found term in file :  CO_322:0000272
Found term in file :  CO_322:0000159
Found term in file :  CO_322:0000190
Found term in file :  CO_322:0000298
Found term in file :  CO_322:0000093
Found term in file :  CO_322:0000313
Found term in file :  CO_322:0000015
Found term in file :  CO_322:0000107
Found term in file :  CO_322:0000231
Found term in file :  CO_322:0000243
Found term in file :  CO_322:0000149
Found term in file :  CO_322:0000146
Found term in file :  CO_322:0000343
Found term in file :  CO_322:0000287
Found term in file :  CO_322:0000076
Found term in file :  CO_322:0000397
Found term in file :  CO_322:0000294
Found term in file :  CO_322:0000349
Found term in file :  CO_322:0000104
Found term in file :  CO_322:0000275
Found term in file :  CO_322:0000155
Found term in file :  CO_322:0000063
Found term in file :  CO_322:0000197
Found term in file :  CO_322:0000203
Found term in file :  CO_322:0000261
Found term in file :  CO_322:0000136
Found term in file :  CO_322:0000079
Found term in file :  CO_322:0000135
Found term in file :  CO_322:0000058
Found term in file :  CO_322:0000321
Found term in file :  CO_322:0000284
Found term in file :  CO_322:0000084
Found term in file :  CO_322:0000247
Found term in file :  CO_322:0000371
Found term in file :  CO_322:0000204
Found term in file :  CO_322:0000289
Found term in file :  CO_322:0000163
Found term in file :  CO_322:0000346
Found term in file :  CO_322:0000013
Found term in file :  CO_322:0000002
Found term in file :  CO_322:0000186
Found term in file :  CO_322:0000080
Found term in file :  CO_322:0000108
Found term in file :  CO_322:0000145
Found term in file :  CO_322:0000333
Found term in file :  CO_322:0000339
Found term in file :  CO_322:0000228
Found term in file :  CO_322:0000323
Found term in file :  CO_322:0000268
Found term in file :  CO_322:0000345
Found term in file :  CO_322:0000067
Found term in file :  CO_322:0000110
Found term in file :  CO_322:0000319
Found term in file :  CO_322:0000170
Found term in file :  CO_322:0000191
Found term in file :  CO_322:0000224
Found term in file :  CO_322:0000187
Found term in file :  CO_322:0000223
Found term in file :  CO_322:0000282
Found term in file :  CO_322:0000262
Found term in file :  CO_322:0000077
Found term in file :  CO_322:0000119
Found term in file :  CO_322:0000212
Found term in file :  CO_322:0000352
Found term in file :  CO_322:0000344
Found term in file :  CO_322:0000124
Found term in file :  CO_322:0000238
Found term in file :  CO_322:0000251
Found term in file :  CO_322:0000369
Found term in file :  CO_322:0000253
Found term in file :  CO_322:0000279
Found term in file :  CO_322:0000175
Found term in file :  CO_322:0000209
Found term in file :  CO_322:0000357
Found term in file :  CO_322:0000256
Found term in file :  CO_322:0000216
Found term in file :  CO_322:0000372
Found term in file :  CO_322:0000115
Found term in file :  CO_322:0000168
Found term in file :  CO_322:0000029
Found term in file :  CO_322:0000061
Found term in file :  CO_322:0000004
Found term in file :  CO_322:0000078
Found term in file :  CO_322:0000021
Found term in file :  CO_322:0000227
Found term in file :  CO_322:0000336
Found term in file :  CO_322:0000097
Found term in file :  CO_322:0000070
Found term in file :  CO_322:0000179
Found term in file :  CO_322:0000383
Found term in file :  CO_322:0000264
Found term in file :  CO_322:0000255
Found term in file :  CO_322:0000297
Found term in file :  CO_322:0000359
Found term in file :  CO_322:0000182
Found term in file :  CO_322:0000106
Found term in file :  CO_322:0000277
Found term in file :  CO_322:0000090
Found term in file :  CO_322:0000232
Found term in file :  CO_322:0000176
Found term in file :  CO_322:0000225
Found term in file :  CO_322:0000330
Found term in file :  CO_322:0000140
Found term in file :  CO_322:0000207
Found term in file :  CO_322:0000263
Found term in file :  CO_322:0000394
Found term in file :  CO_322:0000165
Found term in file :  CO_322:0000046
Found term in file :  CO_322:0000360
Found term in file :  CO_322:0000131
Found term in file :  CO_322:0000290
Found term in file :  CO_322:0000121
Found term in file :  CO_322:0000147
Found term in file :  CO_322:0000304
Found term in file :  CO_322:0000048
Found term in file :  CO_322:0000210
Found term in file :  CO_322:0000396
Found term in file :  CO_322:0000258
Found term in file :  CO_322:0000171
Found term in file :  CO_322:0000393
Found term in file :  CO_322:0000054
Found term in file :  CO_322:0000064
Found term in file :  CO_322:0000014
Found term in file :  CO_322:0000293
Found term in file :  CO_322:0000052
Found term in file :  CO_322:0000365
Found term in file :  CO_322:0000274
Found term in file :  CO_322:0000306
Found term in file :  CO_322:0000068
Found term in file :  CO_322:0000322
Found term in file :  CO_322:0000353
Found term in file :  CO_322:0000164
Found term in file :  CO_322:0000375
Found term in file :  CO_322:0000086
Found term in file :  CO_322:0000026
Found term in file :  CO_322:0000139
Found term in file :  CO_322:0000126
Found term in file :  CO_322:0000252
Found term in file :  CO_322:0000024
Found term in file :  CO_322:0000310
Found term in file :  CO_322:0000283
Found term in file :  CO_322:0000073
Found term in file :  CO_322:0000038
Found term in file :  CO_322:0000132
Found term in file :  CO_322:0000154
Found term in file :  CO_322:0000303
Found term in file :  CO_322:0000192
Found term in file :  CO_322:0000250
Found term in file :  CO_322:0000057
Found term in file :  CO_322:0000215
Found term in file :  CO_322:0000278
Found term in file :  CO_322:0000148
Found term in file :  CO_322:0000271
Found term in file :  CO_322:0000128
Found term in file :  CO_322:0000153
Found term in file :  CO_322:0000387
Found term in file :  CO_322:0000051
Found term in file :  CO_322:0000245
Found term in file :  CO_322:0000267
Found term in file :  CO_322:0000354
Found term in file :  CO_322:0000219
Found term in file :  CO_322:0000318
Found term in file :  CO_322:0000009
Found term in file :  CO_322:0000257
Found term in file :  CO_322:0000103
Found term in file :  CO_322:0000083
Found term in file :  CO_322:0000030
Found term in file :  CO_322:0000185
Found term in file :  CO_322:0000390
Found term in file :  CO_322:0000332
Found term in file :  CO_322:0000248
Found term in file :  CO_322:0000109
Found term in file :  CO_322:0000005
Found term in file :  CO_322:0000144
Found term in file :  CO_322:0000356
Found term in file :  CO_322:0000036
Found term in file :  CO_322:0000031
Found term in file :  CO_322:0000032
Found term in file :  CO_322:0000162
Found term in file :  CO_322:0000196
Found term in file :  CO_322:0000242
Determining which terms are new...
...............................................................................................................................................................................................................................................................................................................................................................................................................Determine which terms are not in the file anymore...
 
                      These terms will be set to obsolete in the database
Inserting and updating terms...
DONE UPDATING existing terms! 
TERM 0000246 has name CIMMYT 1-5 scale, which also exists for term id 42 with accession 0000274

An error occured! Rolling back! DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR:  duplicate key value violates unique constraint "cvterm_c1"
DETAIL:  Key (name, cv_id, is_obsolete)=(CIMMYT 1-5 scale, 3, 0) already exists. [for Statement "INSERT INTO cvterm ( cv_id, dbxref_id, definition, is_obsolete, name) VALUES ( ?, ?, ?, ?, ? ) RETURNING cvterm_id" with ParamValues: 1='3', 2='84', 3=undef, 4='0', 5='CIMMYT 1-5 scale'] at gmod_load_cvterms.pl line 546