doug at fledge.watson.org
Sat Jul 26 16:03:16 UTC 2014
On Sat, 26 Jul 2014, Matthew Seaman wrote:
>> Still cool. Then I tried 'pkg upgrade -n' and got 'Nothing to do' after
>> several hundred of the following:
>> "pkg: sqlite: near "ORDER": syntax error (pkgdb.c:3186)"
>> probably 418 lines but written to SYSERROR so difficult to count.
>> Several questions come to mind:
>> 1) The system was build around Dec 2013, so I think 'nothing to do is
>> not the right answer.
>> 2) Are the sql errors correct? Probably because you can not order the
>> set but should be suppressed??
>> I am late to the game but I did scan PRs and questions before asking.
>> An unrelated question. Everything I used seems to be there except for
>> pkg_tree. Perhaps the need goes away but I would not expect an
>> autoupdate of 418 packages to work after 7 months of no changes.
>> pkg_tree was helpful in attacking upgrading in cases I did not want to
>> delete all and start again.
>> Thanks for any thoughts and/or guidence
> Which version of pkg(8) did you first install, and have you upgraded it
> since? Where did you get pkg(8) from? Can you show us the output of
> 'pkg -vv' please?
I added pkg via pkg_add after updating to 9.2. Since that gave the EOL warning
I did a 'pkg delete' to clear everything and then boot strapped pkg in the
normal was. I figured gotta go forward. Aside from the possibility of being able
to upgrade pkg is much faster and easier to install Xorg + you wm of choice.
search also nicely solves the problem: "what the #$%^ is the name of the
package". Also the help system makes it easy/convenient to learn the options as
the need arises. A really nice job on this.
> The sqlite syntax error is a bug in pkg(8), but there have been many
> similar addressed over time. There's two possibilities here: either the
> sqlite schema on your system is corrupt, or your version of pkg(8) is
> producing incorrect SQL.
> You can get pkg(8) to print out the SQL it is running by calling with
> debugging turned up to 4:
> env DEBUG_LEVEL=4 pkg upgrade -n
> If it turns out the pkg is producing mangled SQL then you can probably
> cure the problem by forcibly upgrading to the latest. Careful though:
> if it's your local.sqlite that's wrong here, then forcibly upgrading
> pkg(8) could just be making things worse.
I will keep the debugging tips, thanks. As before I figured all of this was at
the front end of the development cycle. When converting the pkg_add files to the
pkgdb I got a lot of messages to the effect of 'option conclict' or some such.
If my issues are of any interest I can fairly easily duplicate the process on
another system. Otherwise thanks, and this is much, much better for me and I
would think the Xorg folks as well.
More information about the freebsd-questions