RE: E200030 error on checkout

When I compiled from source, I tried using the latest sqlite and got several compile errors. Those errors were resolved when I went with the sql lite mentioned in the docs (3.6.18). The only LIB path the user has is /usr/local/ssl/lib, which has none of the sqllite libs in it.

From: Bert Huijben [mailto:bert_at_qqmail.nl]
Sent: Wednesday, August 22, 2012 8:47 AM
To: Ferreira, Matthew; users_at_subversion.apache.org
Subject: 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]<mailto:[mailto:mferreira_at_navisite.com]>
Sent: woensdag 22 augustus 2012 14:15
To: users_at_subversion.apache.org<mailto: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<mailto:mferreira_at_navisite.com>
Sent: Tuesday, August 21, 2012 1:45 PM
To: users_at_subversion.apache.org<mailto: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<mailto:mferreira_at_navisite.com>
Office: (978) 946-7747
Mobile: (978) 631-9810
[cid:image001.jpg_at_01CD8043.ED68E090]

________________________________
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.