Re: Snapshot on wheezy.

[Luca Filipozzi <lfilipoz@debian.org>]

On Thu, Mar 06, 2014 at 04:42:12PM +0000, Jakub Mikusek wrote:
> On 06/03/2014 16:28, "Luca Filipozzi" <lfilipoz@debian.org> wrote:
> 
> 
> > > ./snapshot:522: warning: useless use of a variable in void context
> > > Exception `NoMethodError' at /usr/lib/ruby/1.8/rational.rb:78 -
> > > undefined
> > > method `gcd' for Rational(1, 2):Rational
> > > (...)
> > > Did you get it running on Wheezy?
> >
> > We are currently running on Squeeze.
> 
> I think that's the way to go with snapshot at this stage. :-(

Or try ruby1.8 on Wheezy.  Try changing the #! line in the snapshot script to
/usr/bin/ruby1.8.  Then install all the 1.8 dependences needed by the script.

> > > Worst case scenario for me would be going back to Squeezy, but I would
> > > like to avoid that.
> >
> > I think the gcd error is spurious.
> 
> You're right - I think that command succeeded eventually.
> 
> >What's the rest of the output?  There'll be another error that is the root
> >cause.
> 
> Next step failed with :
> 
> snapshot@repo00:/srv/snapshot.debian.org$ TZ=UTC ./snapshot -s -c
> snapshot.conf -p $ARCHIVE_PATH -v -a $ARCHIVE_NAME import
> W, [2014-03-06 16:40:32#24330]  WARN -- : DB Error: ERROR:  invalid input
> syntax for type timestamp: "16:40:32.000000000"
> 
> W, [2014-03-06 16:40:32#24330]  WARN -- : Query: INSERT INTO mirrorrun
> (mirrorrun_uuid,run,archive_id,importing_host) VALUES (?,?,?,?) RETURNING
> mirrorrun_id
> W, [2014-03-06 16:40:32#24330]  WARN -- : Arguments:
> 6a753ddf-f84d-47a8-8a38-03a5fbcc1199, Thu Mar 06 16:40:32 +0000 2014, 1,
> repo00.localdomain
> /usr/lib/ruby/vendor_ruby/dbd/pg/statement.rb:62:in `execute': ERROR:
> invalid input syntax for type timestamp: "16:40:32.000000000"
> (DBI::ProgrammingError)
>         from /usr/lib/ruby/vendor_ruby/dbi/base_classes/database.rb:96:in
> `execute'
>         from /usr/lib/ruby/vendor_ruby/dbi/handles/database.rb:81:in
> `execute'
>         from ./snapshot:151:in `execute'
>         from ./snapshot:220:in `query_row'
>         from ./snapshot:173:in `insert'
>         from ./snapshot:182:in `insert_row'
>         from ./snapshot:659:in `_insert_mirrorrun'
>         from ./snapshot:714:in `import_from_filesystem'
>         from ./snapshot:1360:in `import'
>         from ./snapshot:1476
> snapshot@repo00:/srv/snapshot.debian.org$

That one will be harder to debug via email.  It's probably an incompatibility between the dbd:pg library for ruby1.9 and the postgres version.

Suggest you switch to ruby1.8 on Wheezy and see if that works.

Luca

-- 
Luca Filipozzi
http://www.crowdrise.com/SupportDebian