Problem importing eprints 2 apache log data - IRStats Discuss

Message from discussion Problem importing eprints 2 apache log data
MIME-Version: 1.0
Date: Mon, 3 Nov 2008 19:29:10 -0800 (PST)
In-Reply-To: <64aefd6a-2300-4202-8ae9-1e44cd2108fe@q30g2000prq.googlegroups.com>
References: <64aefd6a-2300-4202-8ae9-1e44cd2108fe@q30g2000prq.googlegroups.com>
User-Agent: G2/1.0
Message-ID: <53639728-54f1-45f5-a8a6-3c3344644e78@b31g2000prf.googlegroups.com>
Subject: Re: Problem importing eprints 2 apache log data
From: Guy <guy.knig...@gmail.com>
To: IRStats Discuss <irstats-discuss@googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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` =3D ? LIMIT 1 ('159.226.47.109') -- failed:
> =A0at /usr/local/irstats/var/www/irstats/lib/IRStats/
> DatabaseInterface.pm line 625
>
> IRStats::DatabaseInterface::execute('IRStats::DatabaseInterface::mysql=3D=
HASH(0xa15189c)',
> 'DBI::st=3DHASH(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=3DH=
ASH(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::=
mysql=3DHASH(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::DatabaseInter=
face::mysql=3DHASH(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::MyHan=
dler=3DHASH(0xa4ad5c8)',
> 'Logfile::EPrints::Hit::Combined=3DHASH(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::=
MyHandler=3DHASH(0xa4ad5c8)',
> 'Logfile::EPrints::Hit::Combined=3DHASH(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:=
:SearchParser=3DHASH(0xa1f807c)',
> 'Logfile::EPrints::Hit::Combined=3DHASH(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::R=
epeated=3DHASH(0xa3e7d90)',
> 'Logfile::EPrints::Hit::Combined=3DHASH(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::Rob=
ots=3DHASH(0xa50d1a8)',
> 'Logfile::EPrints::Hit::Combined=3DHASH(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::Filt=
er::MaxPerSession=3DHASH(0xa3cdf18)',
> 'Logfile::EPrints::Hit::Combined=3DHASH(0xa6441a4)') called at /usr/
> local/irstats/var/www/irstats/lib/IRStats/Update/Filter/
> SelfReferrerFilter.pm line 23
>
> IRStats::Update::Filter::SelfReferrerFilter::fulltext('IRStats::Update::F=
ilter::SelfReferrerFilter=3DHASH(0xa4b72b8)',
> 'Logfile::EPrints::Hit::Combined=3DHASH(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=3DHASH(0xa51c9c0)',
> 'Logfile::EPrints::Hit::Combined=3DHASH(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=
=3DHASH(0xa64281c)',
> 'Logfile::EPrints::Hit::Combined=3DHASH(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:=
:FulltextOnly=3DHASH(0xa64281c)',
> 'Logfile::EPrints::Hit::Combined=3DHASH(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::Se=
ssion=3DHASH(0xa406940)',
> 'Logfile::EPrints::Hit::Combined=3DHASH(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=3DHASH(0xa5fc3ac)',
> 'Logfile::EPrints::Hit::Combined=3DHASH(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::EPrin=
ts=3DHASH(0xa4212c8)',
> 'Logfile::EPrints::Hit::Combined=3DHASH(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=3DHASH(0xa3f=
e4f4)',
> '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::A=
pacheEPrints=3DHASH(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=3DHASH(0x=
9fd87e4)')
> called at /usr/local/irstats/var/www/irstats/lib/IRStats/CLI.pm line
> 58
> =A0 =A0 =A0 =A0 IRStats::CLI::handler() called at /usr/local/irstats/var/=
www/
> irstats/lib/IRStats.pm line 70
> =A0 =A0 =A0 =A0 IRStats::handler() called at /usr/local/irstats/var/www/c=
gi-
> 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