EPrints Technical Mailing List Archive

Message: #02964

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hihi

sorry, there are exactly 3091 (sic!) authors.
maybe this impress you a bit more for an answer.
EP is handling this amount of authors quit well (depence on CPU, RAM,
...) (springer isn't doing it better!).
but how you handling this in the institution?
and how you handling this for the descripted error?

thanks
stof

On 23.04.2014 15:52, stof999@cmdt.ch wrote:
> 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
> 
> *** Options:
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech ***
> Archive: http://www.eprints.org/tech.php/ *** EPrints community
> wiki: http://wiki.eprints.org/ *** EPrints developers Forum:
> http://forum.eprints.org/
> 

- -- 
*************************
http://stof999.ch/contact
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iEYEARECAAYFAlNgF3UACgkQnHWJdWtV8XyidACePOup2QzqHX7phFGyncIn8p8K
OjkAnRuCmSAhrJj2ty463jSr4bsSl3Jy
=5Nwf
-----END PGP SIGNATURE-----