Re: pkgtools/pkgin-0.9.2 - sql errors (on Linux)

[Matthias Ferdinand <mf+ml.pkgsrc-users%netzwerkagentursaarland.de@localhost>]

On Tue, Aug 18, 2015 at 08:34:28PM +0100, Jonathan Perkin wrote:
> * On 2015-08-17 at 18:23 BST, Matthias Ferdinand wrote:
> 
> > since upgrading from pkgin-0.8.0 to 0.9.1 / 0.9.2, "pkgin av" only shows
> >     Requested list is empty.
> > and re-reading local and remote summary at each invocation.
> > 
> > In /opt/pkgsrc/var/db/pkgin/sql.log I see lots of entries like
> >     SQL error: near ")": syntax error
> >     SQL query: );
> > 
> > This not only happens on old Linux installs, but also on Ubuntu
> > 12.04/14.04
> 
> This should now be fixed in 0.9.3 which I've just committed to pkgsrc,
> as well as a few other build fixes (e.g. it is now WARNS=4 clean on
> Ubuntu 12.04).
> 
> Please test (especially on other systems) and let me know of any
> issues.

Hi, thanks for fixing. Wworks fine on my Linux hosts (Ubuntu
6.06/8.04/10.04/12.04/14.04, SuSE 9.0/9.2, NetBSD 5.1/6.1).

On Ubuntu 6.06 the system compiler (4.0.4) produced segfaults with -O2
but not with -O0. Switching to gcc47 from pkgsrc worked.

On a heavily modified SuSE10.0 I still keep getting segfaults, but
that is probably some other compiler issue I need to investigate.

Regards