RE: E200030 error on checkout

Withut knowledge of your setup:

My guess would be that your setup accidentally picks up an older Sqlite as
this syntax is supported by all our supported Sqlite versions. (Maybe by
using a different library at runtime that at compile time).

If you are upgrading Sqlite specifically I would recommend going to a very
recent 3.7 version as there are relevant optimizer fixes that may speed up
several operations.

                Bert

From: Ferreira, Matthew [mailto:mferreira_at_navisite.com]
Sent: woensdag 22 augustus 2012 14:15
To: users_at_subversion.apache.org
Subject: RE: E200030 error on checkout

Correcting the subject line to reflect the actual error code

From: mferreira_at_navisite.com
Sent: Tuesday, August 21, 2012 1:45 PM
To: users_at_subversion.apache.org
Subject: e20300 error on checkout

When using the svn client, seeing the following:

svn: E200030: near "OLD": syntax error, executing statement 'CREATE TRIGGER
nodes_insert_trigger AFTER INSERT ON nodes WHEN NEW.checksum IS NOT NULL
BEGIN UPDATE pristine SET refcount = refcount + 1 WHERE checksum =
NEW.checksum; END; CREATE TRIGGER nodes_delete_trigger AFTER DELETE ON nodes
WHEN OLD.checksum IS NOT NULL BEGIN UPDATE pristine SET refcount =
refcount - 1 WHERE checksum = OLD.checksum; END; CREATE TRIGGER
nodes_update_checksum_trigger AFTER UPDATE OF checksum ON nodes WHEN
NEW.checksum IS NOT OLD.checksum BEGIN UPDATE pristine SET refcount =
refcount + 1 WHERE checksum = NEW.checksum; UPDATE pristine SET refcount
= refcount - 1 WHERE checksum = OLD.checksum; END; '

When I searched around I found a lot of users seeing issues with CygWin, but
I'm using Solaris 9 Sparc w/ sqlite 3.6.18

It creates the directory with the wc.db file and a couple others but doesn't
check anything out

Thanks in Advance

Matt Ferreira
Web Services Engineer, Sr. - Managed Web Serivces

NaviSite - A Time Warner Cable Company

mferreira_at_navisite.com

Office: (978) 946-7747
Mobile: (978) 631-9810
Description: cid:image001.jpg_at_01CC038E.F3B18AC0

  _____

This e-mail is the property of NaviSite, Inc. It is intended only for the
person or entity to which it is addressed and may contain information that
is privileged, confidential, or otherwise protected from disclosure.
Distribution or copying of this e-mail, or the information contained herein,
to anyone other than the intended recipient is prohibited.