You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@subversion.apache.org by "Ferreira, Matthew" <mf...@navisite.com> on 2012/08/22 14:14:53 UTC

RE: E200030 error on checkout

Correcting the subject line to reflect the actual error code

From: mferreira@navisite.com
Sent: Tuesday, August 21, 2012 1:45 PM
To: users@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@navisite.com<ma...@navisite.com>
Office:  (978) 946-7747
Mobile: (978) 631-9810
[cid:image001.jpg@01CD803E.34A13440]


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

RE: E200030 error on checkout

Posted by "Ferreira, Matthew" <mf...@navisite.com>.
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@qqmail.nl]
Sent: Wednesday, August 22, 2012 8:47 AM
To: Ferreira, Matthew; users@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@navisite.com]<mailto:[mailto:mferreira@navisite.com]>
Sent: woensdag 22 augustus 2012 14:15
To: users@subversion.apache.org<ma...@subversion.apache.org>
Subject: RE: E200030 error on checkout

Correcting the subject line to reflect the actual error code

From: mferreira@navisite.com<ma...@navisite.com>
Sent: Tuesday, August 21, 2012 1:45 PM
To: users@subversion.apache.org<ma...@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@navisite.com<ma...@navisite.com>
Office:  (978) 946-7747
Mobile: (978) 631-9810
[cid:image001.jpg@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.

RE: E200030 error on checkout

Posted by Bert Huijben <be...@qqmail.nl>.
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@navisite.com] 
Sent: woensdag 22 augustus 2012 14:15
To: users@subversion.apache.org
Subject: RE: E200030 error on checkout

 

Correcting the subject line to reflect the actual error code

 

From: mferreira@navisite.com 
Sent: Tuesday, August 21, 2012 1:45 PM
To: users@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@navisite.com

Office:  (978) 946-7747
Mobile: (978) 631-9810
Description: cid:image001.jpg@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.