[EP-tech] ep-issues error with items having huge amount of authors

stof999 at cmdt.ch stof999 at cmdt.ch
Wed Apr 23 14:52:58 BST 2014


-----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-----


More information about the Eprints-tech mailing list