Skip to content

Instantly share code, notes, and snippets.

@aturner
Last active October 8, 2015 17:34
Show Gist options
  • Save aturner/ae2bacb5a1a4ad5a23b8 to your computer and use it in GitHub Desktop.
Save aturner/ae2bacb5a1a4ad5a23b8 to your computer and use it in GitHub Desktop.
ASpace 1.2.0->1.3.0 upgrade errors
=========================================================================================
ERROR 1 (UC San Francisco's ASpace instance)
=========================================================================================
failed: [ucsf] => {"changed": true, "cmd": "./scripts/setup-database.sh",
"delta": "0:00:10.902939", "end": "2015-10-01 20:43:10.181809", "rc": 1,
"start": "2015-10-01 20:42:59.278870", "warnings": []}
stderr: Sequel::UniqueConstraintViolation:
Java::ComMysqlJdbcExceptionsJdbc4::MySQLIntegrityConstraintViolationExcepti
on: Duplicate entry 'job_type' for key 'name'
raise_error at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/misc.r
b:423
statement at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.r
b:648
execute at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.r
b:245
hold at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool
/threaded.rb:98
synchronize at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connec
ting.rb:255
execute at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.r
b:244
execute_insert at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.r
b:276
execute_insert at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions
.rb:927
insert at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions
.rb:336
create_enum at
/home/ucsf/archivesspace/lib/common.jar!/db/migrations/utils.rb:45
(root) at
/home/ucsf/archivesspace/lib/common.jar!/db/migrations/037_generalized_job_
table.rb:6
instance_eval at org/jruby/RubyBasicObject.java:1533
apply at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migr
ation.rb:100
run at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migr
ation.rb:528
checked_transaction at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migr
ation.rb:466
run at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migr
ation.rb:527
each at org/jruby/RubyArray.java:1613
run at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migr
ation.rb:524
run at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migr
ation.rb:391
setup_database at
file:/home/ucsf/archivesspace/lib/common.jar!/db/db_migrator.rb:184
(root) at ../scripts/rb/migrate_db.rb:43
connect at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connec
ting.rb:69
connect at
/home/ucsf/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/core.rb:95
(root) at ../scripts/rb/migrate_db.rb:28
stdout: Loading ArchivesSpace configuration file from path:
/home/ucsf/archivesspace/./config/config.rb
Loading ArchivesSpace configuration file from path:
/home/ucsf/archivesspace/./config/config.rb
Running migrations against
jdbc:mysql://aspace.crqkpkb4l2po.us-east-1.rds.amazonaws.com:3306/ucsf?user
=ucsf&password=nv6N._DCqegvkGq3,bQG&useUnicode=true&characterEncoding=UTF-8
=========================================================================================
ERROR 2 (UC Merced Physical Planning, Construction, & Design's ASpace instance)
=========================================================================================
failed: [ucmppdc] => {"changed": true, "cmd":
"./scripts/setup-database.sh", "delta": "0:00:10.486754", "end":
"2015-10-01 20:50:03.795922", "rc": 1, "start": "2015-10-01 20:49:53.309168", "warnings": []}
stderr: Adding separate permissions for updating major record types Updating groups to include the new permssions
Sequel::UniqueConstraintViolation:
Java::ComMysqlJdbcExceptionsJdbc4::MySQLIntegrityConstraintViolationExcepti
on: Duplicate entry '27-1' for key
'group_permission_permission_id_group_id_index'
raise_error at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/mis
c.rb:423
statement at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdb
c.rb:648
execute at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdb
c.rb:245
hold at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_p
ool/threaded.rb:98
synchronize at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/con
necting.rb:255
execute at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdb
c.rb:244
execute_insert at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdb
c.rb:276
execute_insert at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/acti
ons.rb:927
insert at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/acti
ons.rb:336
(root) at
/home/ucmppdc/archivesspace/lib/common.jar!/db/migrations/032_split_update_
archival_record_permission_by_record_type_and_related_permissions_changes.r
b:91
each at org/jruby/RubyArray.java:1613
(root) at
/home/ucmppdc/archivesspace/lib/common.jar!/db/migrations/032_split_update_
archival_record_permission_by_record_type_and_related_permissions_changes.r
b:90
instance_eval at org/jruby/RubyBasicObject.java:1533
apply at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/m
igration.rb:100
run at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/m
igration.rb:528
checked_transaction at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/m
igration.rb:466
run at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/m
igration.rb:527
each at org/jruby/RubyArray.java:1613
run at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/m
igration.rb:524
run at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/m
igration.rb:391
setup_database at
file:/home/ucmppdc/archivesspace/lib/common.jar!/db/db_migrator.rb:184
(root) at ../scripts/rb/migrate_db.rb:43
connect at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/con
necting.rb:69
connect at
/home/ucmppdc/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/core.rb:95
(root) at ../scripts/rb/migrate_db.rb:28
stdout: Loading ArchivesSpace configuration file from path:
/home/ucmppdc/archivesspace/./config/config.rb
Loading ArchivesSpace configuration file from path:
/home/ucmppdc/archivesspace/./config/config.rb
Running migrations against
jdbc:mysql://aspace.crqkpkb4l2po.us-east-1.rds.amazonaws.com:3306/ucmppdc?u
ser=ucmppdc&password=ZltGyu5B-ubmx__F7Idn&useUnicode=true&characterEncoding
=UTF-8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment