Problem importing eprints 2 apache log data - IRStats Discuss

Message from discussion Problem importing eprints 2 apache log data

Guy

More options 4 Nov 2008, 03:29

From: Guy <guy.knig...@gmail.com>

Date: Mon, 3 Nov 2008 19:29:10 -0800 (PST)

Local: Tues 4 Nov 2008 03:29

Subject: Re: Problem importing eprints 2 apache log data

  Reply to author
  |
  Forward | Print | View thread
  | Show original
  | Report this message | Find messages by this author
  

Well it looks like I fixed the problem by doing a repair on the table
in question - however, I still get a whole heap of "Use of
uninitialized value in pattern match (M//) at /usr/local/irstats/var/
www/irstats/lib/IRStats/Update/Handler/MyHandler.pm line x, <STDIN>
line xxx. Are these errors something to be concerned about? I think
they probably aren't, but if anyone knows how to clear them up I'm all
ears.

Thanks,
Guy

On 4 Nov, 13:21, Guy <guy.knig...@gmail.com> wrote:

> I'm experiencing errors when trying to import data from an eprints 2
> log. I tried another logfile (same server, different year) and am
> getting the same error. There error output is below:

> Use of uninitialized value in pattern match (m//) at /usr/local/
> irstats/var/www/irstats/lib/IRStats/Update/Handler/MyHandler.pm line
> 48, <STDIN> line 9.
> Use of uninitialized value in pattern match (m//) at /usr/local/
> irstats/var/www/irstats/lib/IRStats/Update/Handler/MyHandler.pm line
> 48, <STDIN> line 9.
> Use of uninitialized value in pattern match (m//) at /usr/local/
> irstats/var/www/irstats/lib/IRStats/Update/Handler/MyHandler.pm line
> 48, <STDIN> line 9.
> DBD::mysql::st execute failed: Table './quteprints/
> irstats_column_requester_host' is marked as crashed and should be
> repaired at /usr/local/irstats/var/www/irstats/lib/IRStats/
> DatabaseInterface.pm line 625.
> Use of uninitialized value in concatenation (.) or string at /usr/
> local/irstats/var/www/irstats/lib/IRStats/DatabaseInterface.pm line
> 625.
> Execution of -- SELECT `id` FROM `irstats_column_requester_host` WHERE
> `value` = ? LIMIT 1 ('159.226.47.109') -- failed:
> at /usr/local/irstats/var/www/irstats/lib/IRStats/
> DatabaseInterface.pm line 625

> IRStats::DatabaseInterface::execute('IRStats::DatabaseInterface::mysql=HASH (0xa15189c)',
> 'DBI::st=HASH(0xa642a98)', 159.226.47.109) called at /usr/local/
> irstats/var/www/irstats/lib/IRStats/DatabaseInterface.pm line 581

> IRStats::DatabaseInterface::do_sql('IRStats::DatabaseInterface::mysql=HASH( 0xa15189c)',
> 'SELECT `id` FROM `irstats_column_requester_host` WHERE `value...',
> 159.226.47.109) called at /usr/local/irstats/var/www/irstats/lib/
> IRStats/DatabaseInterface.pm line 520

> IRStats::DatabaseInterface::column_table_id('IRStats::DatabaseInterface::my sql=HASH(0xa15189c)',
> 'irstats_column_requester_host', 159.226.47.109) called at /usr/local/
> irstats/var/www/irstats/lib/IRStats/DatabaseInterface.pm line 479

> IRStats::DatabaseInterface::insert_main_table_row('IRStats::DatabaseInterfa ce::mysql=HASH(0xa15189c)',
> 'HASH(0xa64457c)') called at /usr/local/irstats/var/www/irstats/lib/
> IRStats/Update/Handler/MyHandler.pm line 81

> IRStats::Update::Handler::MyHandler::hit('IRStats::Update::Handler::MyHandl er=HASH(0xa4ad5c8)',
> 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/
> local/irstats/var/www/irstats/lib/IRStats/Update/Handler/MyHandler.pm
> line 38

> IRStats::Update::Handler::MyHandler::fulltext('IRStats::Update::Handler::My Handler=HASH(0xa4ad5c8)',
> 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/
> local/irstats/var/www/irstats/lib/IRStats/Update/Filter/
> SearchParser.pm line 159

> IRStats::Update::Filter::SearchParser::AUTOLOAD('IRStats::Update::Filter::S earchParser=HASH(0xa1f807c)',
> 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/lib/
> perl5/site_perl/5.8.8/Logfile/EPrints/Filter/Repeated.pm line 49

> Logfile::EPrints::Filter::Repeated::fulltext('Logfile::EPrints::Filter::Rep eated=HASH(0xa3e7d90)',
> 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/lib/
> perl5/site_perl/5.8.8/Logfile/EPrints/Filter/Robots.pm line 45

> Logfile::EPrints::Filter::Robots::AUTOLOAD('Logfile::EPrints::Filter::Robot s=HASH(0xa50d1a8)',
> 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/lib/
> perl5/site_perl/5.8.8/Logfile/EPrints/Filter/Session.pm line 183

> Logfile::EPrints::Filter::MaxPerSession::AUTOLOAD('Logfile::EPrints::Filter ::MaxPerSession=HASH(0xa3cdf18)',
> 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/
> local/irstats/var/www/irstats/lib/IRStats/Update/Filter/
> SelfReferrerFilter.pm line 23

> IRStats::Update::Filter::SelfReferrerFilter::fulltext('IRStats::Update::Fil ter::SelfReferrerFilter=HASH(0xa4b72b8)',
> 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/
> local/irstats/var/www/irstats/lib/IRStats/Update/Filter/
> NegateHandler.pm line 28

> IRStats::Update::Filter::NegateHandler::AUTOLOAD('IRStats::Update::Filter:: NegateHandler=HASH(0xa51c9c0)',
> 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/lib/
> perl5/site_perl/5.8.8/Logfile/EPrints/Filter.pm line 35

> Logfile::EPrints::Filter::AUTOLOAD('IRStats::Update::Filter::FulltextOnly=H ASH(0xa64281c)',
> 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/
> local/irstats/var/www/irstats/lib/IRStats/Update/Filter/
> FulltextOnly.pm line 11

> IRStats::Update::Filter::FulltextOnly::fulltext('IRStats::Update::Filter::F ulltextOnly=HASH(0xa64281c)',
> 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/lib/
> perl5/site_perl/5.8.8/Logfile/EPrints/Filter/Session.pm line 39

> Logfile::EPrints::Filter::Session::AUTOLOAD('Logfile::EPrints::Filter::Sess ion=HASH(0xa406940)',
> 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/
> local/irstats/var/www/irstats/lib/IRStats/Update/Parser/
> ApacheEPrints.pm line 47
> IRStats::Update::Parser::ApacheEPrints::AUTOLOAD('IRStats::Update::Parser:: ApacheEPrints=HASH(0xa5fc3ac)',
> 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/lib/
> perl5/site_perl/5.8.8/Logfile/EPrints/Mapping/EPrints.pm line 21

> Logfile::EPrints::Mapping::EPrints::hit('Logfile::EPrints::Mapping::EPrints =HASH(0xa4212c8)',
> 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/lib/
> perl5/site_perl/5.8.8/Logfile/EPrints/Parser.pm line 26

> Logfile::EPrints::Parser::parse_fh('Logfile::EPrints::Parser=HASH(0xa3fe4f4 )',
> 'GLOB(0x9dae348)') called at /usr/local/irstats/var/www/irstats/lib/
> IRStats/Update/Parser/ApacheEPrints.pm line 33

> IRStats::Update::Parser::ApacheEPrints::parse('IRStats::Update::Parser::Apa cheEPrints=HASH(0xa5fc3ac)')
> called at /usr/local/irstats/var/www/irstats/lib/IRStats/CLI/
> update_table.pm line 91

> IRStats::CLI::update_table::execute('IRStats::CLI::update_table=HASH(0x9fd8 7e4)')
> called at /usr/local/irstats/var/www/irstats/lib/IRStats/CLI.pm line
> 58
> IRStats::CLI::handler() called at /usr/local/irstats/var/www/
> irstats/lib/IRStats.pm line 70
> IRStats::handler() called at /usr/local/irstats/var/www/cgi-
> bin/irstats.cgi line 30

> Is anyone able to advise what might be causing this problem? Any help
> would be greatly appreciated.

> Thanks,
> Guy

> Guy Knights
> Computer Systems Officer
> Library Systems, QUT
> Phone: (07) 3138 3910
> Email: g.knig...@qut.edu.au

Reply to author Forward