EPrints Technical Mailing List Archive
See the EPrints wiki for instructions on how to join this mailing list and related information.
Message: #02925
< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First
[EP-tech] ep-issues error with items having huge amount of authors
- To: eprints-tech@ecs.soton.ac.uk
- Subject: [EP-tech] ep-issues error with items having huge amount of authors
- From: "stof999@cmdt.ch" <stof999@cmdt.ch>
- Date: Wed, 23 Apr 2014 15:52:58 +0200
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 hi with items having a lot of authors (200!) i.e. http://dx.doi.org/10.1007/JHEP10(2013)189 (takes a while!) the daily issues_audit rises an mysql error: DBD::mysql::st execute failed: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline. at /usr/share/eprints3/bin/../perl_lib/EPrints/Database.pm line 1185, <DATA> line 959. UPDATE `eprint__ordervalues_de` SET `item_issues_id`=?, `item_issues_description`=?, `item_issues_count`=?, `item_issues_timestamp`=?, `item_issues_status`=?, `item_issues_type`=? WHERE `eprintid`='41454': 1118 at /usr/share/eprints3/bin/../perl_lib/EPrints/Index.pm line 271 EPrints::Index::_do_ordervalues('EPrints::Repository=HASH(0x4735b70)', 'EPrints::DataSet=HASH(0x4eb8678)', 'HASH(0xc139ce8)', 'HASH(0xdbc0518)', 0) called at /usr/share/eprints3/bin/../perl_lib/EPrints/Index.pm line 210 EPrints::Index::update_ordervalues('EPrints::Repository=HASH(0x4735b70)', 'EPrints::DataSet=HASH(0x4eb8678)', 'HASH(0xc139ce8)', 'HASH(0xdbc0518)') called at /usr/share/eprints3/bin/../perl_lib/EPrints/Database.pm line 1636 EPrints::Database::update('EPrints::Database::mysql=HASH(0x4f18f18)', 'EPrints::DataSet=HASH(0x4eb8678)', 'HASH(0xc139ce8)', 'HASH(0xdbc0518)') called at /usr/share/eprints3/bin/../perl_lib/EPrints/DataObj.pm line 652 EPrints::DataObj::commit('EPrints::DataObj::EPrint=HASH(0xdbc0530)', undef) called at /usr/share/eprints3/bin/../perl_lib/EPrints/DataObj/EPrint.pm line 1011 EPrints::DataObj::EPrint::commit('EPrints::DataObj::EPrint=HASH(0xdbc0530)') called at /usr/share/eprints3/bin/issues_audit line 216 main::_ANON_('EPrints::Repository=HASH(0x4735b70)', 'EPrints::DataSet=HASH(0x4eb8678)', 'EPrints::DataObj::EPrint=HASH(0xdbc0530)', undef) called at /usr/share/eprints3/bin/../perl_lib/EPrints/List.pm line 664 EPrints::List::map('EPrints::List=HASH(0x38aed20)', 'CODE(0x88ec078)') called at /usr/share/eprints3/bin/issues_audit line 217 does anyone know this problem? can there something be done? thanks a lot stof -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iEYEARECAAYFAlNXxboACgkQnHWJdWtV8XyBzwCgn9fK1MiipUFfjePJk6UEw95j QmgAnRFijb3s8/7GEvvvmE3CSGmSIFrw =bE/t -----END PGP SIGNATURE-----
- Prev by Date: [EP-tech] Indexing issues
- Next by Date: [EP-tech] ep-issues: how to search for issue type EPrints::Plugin::Issues::ExactTitleDups
- Previous by thread: [EP-tech] Indexing issues
- Next by thread: [EP-tech] Re: ep-issues error with items having huge amount of authors
- Index(es):