search

Islandora-Devops / isle-dc

ISLE 8 - Dockerized Islandora 8 Deployment orchestrated with docker-compose
MIT License
22 stars 60 forks source link

Media migration error - SQLSTATE[40001]: Serialization failure #50

Closed g7morris closed 4 years ago

g7morris commented 4 years ago

From @marksandford on Slack:

"I've gotten the test ingest files ready to go and zipped up. Instructions are in the Readme, but it's basically installed as a module and a series of drush commands are run.

One caveat is that I consistently get SQLSTATE[40001]: Serialization failure when running the media migration. Running it again with --update seems to fix it (as described in Readme). Setting mysql to read-committed avoids the problem entirely, but I have no idea what the implications are for that in production, nor do I know if the ISLE config will differ in ways that will avoid the error"

@dannylamb Have you run into this issue yet?

g7morris commented 4 years ago

@marksandford Perhaps you could include a few more details on the ticket when you have a chance?

What steps are you taking?

Is this the islandora-vagrant VM or the ansible-playbook? etc. etc.

This way we can attempt to replicate on the upcoming merged ISLE docker stack. Thanks!

marksandford commented 4 years ago

I'm using the ansible playbook from here https://github.com/Islandora-Devops/islandora-playbook Steps are running the playbook as per the readme in the repo, followed by ingesting objects using the zip file here https://drive.google.com/file/d/1T_zD40r6LRHvLyRlqaUCfYe6YjutCfnc/view?usp=sharing The zip file is based on JHU's work, which in turn based on https://github.com/Islandora/migrate_islandora_csv

g7morris commented 4 years ago

This is no longer an issue due to work and improvements here https://github.com/Islandora-Devops/isle-buildkit. Please reopen ticket if this error arises again.