<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.3.2">
</HEAD>
<BODY>
On Sun, 2007-03-04 at 19:34 -0500, Ian Eslick wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">Interesting, BDB with ACL was clean for me (except for indexing-class- </FONT>
<FONT COLOR="#000000">opt which fails everywhere right now). Can you tell me what the </FONT>
<FONT COLOR="#000000">error outputs were?</FONT>
<FONT COLOR="#000000">Darn, I was hoping you'd have an idea how to debug the lispworks </FONT>
<FONT COLOR="#000000">failure. It's probably some pointer/type thing in Lispwork's UFFI. </FONT>
<FONT COLOR="#000000">I'm not sure when, or if, I'll get to this.</FONT>
<FONT COLOR="#000000">Try running the postgresql version again. Sometimes you have to open </FONT>
<FONT COLOR="#000000">the SQL databases twice to get them to work properly.</FONT>
</PRE>
</BLOCKQUOTE>
Additionally, if it is an option, try the postgres connection that does not go through the socket.<BR>
I would like to have both working, but have mainly tested with the direct connection. Tomorrow<BR>
night I'll think about why the socket might be failing and test with it here on my machine.<BR>
<BR>
<BR>
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">Thanks,</FONT>
<FONT COLOR="#000000">Ian</FONT>
<FONT COLOR="#000000">On Mar 4, 2007, at 6:22 PM, Frank Schorr wrote:</FONT>
<FONT COLOR="#000000">> Ok, I tried the latest cvs on Windows.</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> This is BDB with ACL trial:</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> 3 out of 125 total tests failed: ELE-TESTS::INDEXING-CLASS-OPT, ELE- </FONT>
<FONT COLOR="#000000">> TESTS::INDEXING-SLOT-MAKUNBOUND, ELE-TESTS::INDEXING-WIPE-INDEX.</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> This is BDB on LispWorks 5.0.1:</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> Exception C0000005 [flags 0] at 1541483 {inside foreign code}</FONT>
<FONT COLOR="#000000">> eax 0 ebx 153FED0 ecx 7F edx 16</FONT>
<FONT COLOR="#000000">> esp 153FEA8 ebp 153FEC0 esi 21C1E8E3 edi E8</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> when calling %db-env-create</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> Repairing this is far from what I can help with.</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> I tried the postgresql-socket version then.</FONT>
<FONT COLOR="#000000">> This used to work with ACL and the last elephant version a while ago,</FONT>
<FONT COLOR="#000000">> before I learned to make the dlls.</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> (asdf:operate 'asdf:load-op :elephant)</FONT>
<FONT COLOR="#000000">> (asdf:operate 'asdf:load-op :ele-clsql)</FONT>
<FONT COLOR="#000000">> (asdf:operate 'asdf:load-op :clsql-postgresql-socket)</FONT>
<FONT COLOR="#000000">> (asdf:operate 'asdf:load-op :elephant-tests)</FONT>
<FONT COLOR="#000000">> (do-backend-tests '(:clsql (:postgresql-socket "localhost" "clsql- </FONT>
<FONT COLOR="#000000">> tests" "postgres" "$postgres%")))</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> Warning: While accessing database #<POSTGRESQL-SOCKET-DATABASE </FONT>
<FONT COLOR="#000000">> localhost/clsql-tests/postgres OPEN @ #x2115e65a></FONT>
<FONT COLOR="#000000">> Warning: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit </FONT>
<FONT COLOR="#000000">> index "keyvalue_pkey" for table "keyvalue"</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> has occurred.</FONT>
<FONT COLOR="#000000">> Warning: POSTGRESQL-WARNING occurred on connection</FONT>
<FONT COLOR="#000000">> #S(POSTGRESQL-CONNECTION :HOST localhost</FONT>
<FONT COLOR="#000000">> :PORT 5432</FONT>
<FONT COLOR="#000000">> :DATABASE clsql-tests</FONT>
<FONT COLOR="#000000">> :USER postgres</FONT>
<FONT COLOR="#000000">> :PASSWORD $postgres%</FONT>
<FONT COLOR="#000000">> :OPTIONS</FONT>
<FONT COLOR="#000000">> :TTY</FONT>
<FONT COLOR="#000000">> :SOCKET #<MULTIVALENT stream </FONT>
<FONT COLOR="#000000">> socket connected from localhost/2413 to localhost/5432 @ #x2114e222></FONT>
<FONT COLOR="#000000">> :PID 3920</FONT>
<FONT COLOR="#000000">> :KEY 1974900746).</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> Reason: NOTICE: CREATE TABLE / PRIMARY KEY will create </FONT>
<FONT COLOR="#000000">> implicit index "keyvalue_pkey" for table "keyvalue"</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> Error: While accessing database #<POSTGRESQL-SOCKET-DATABASE </FONT>
<FONT COLOR="#000000">> localhost/clsql-tests/postgres OPEN @ #x2115e65a></FONT>
<FONT COLOR="#000000">> with expression "create table keyvalue (</FONT>
<FONT COLOR="#000000">> pk integer PRIMARY KEY DEFAULT nextval('serial'),</FONT>
<FONT COLOR="#000000">> clctn_id integer NOT NULL,</FONT>
<FONT COLOR="#000000">> key varchar NOT NULL,</FONT>
<FONT COLOR="#000000">> value varchar</FONT>
<FONT COLOR="#000000">> )":</FONT>
<FONT COLOR="#000000">> Error missing-result / Didn't receive result cursor for query.</FONT>
<FONT COLOR="#000000">> has occurred.</FONT>
<FONT COLOR="#000000">> [condition type: SQL-DATABASE-DATA-ERROR]</FONT>
<FONT COLOR="#000000">> Warning: While accessing database #<POSTGRESQL-SOCKET-DATABASE </FONT>
<FONT COLOR="#000000">> localhost/clsql-tests/postgres OPEN @ #x2115e65a></FONT>
<FONT COLOR="#000000">> Warning: WARNING: there is no transaction in progress</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> has occurred.</FONT>
<FONT COLOR="#000000">> Warning: POSTGRESQL-WARNING occurred on connection</FONT>
<FONT COLOR="#000000">> #S(POSTGRESQL-CONNECTION :HOST localhost</FONT>
<FONT COLOR="#000000">> :PORT 5432</FONT>
<FONT COLOR="#000000">> :DATABASE clsql-tests</FONT>
<FONT COLOR="#000000">> :USER postgres</FONT>
<FONT COLOR="#000000">> :PASSWORD $postgres%</FONT>
<FONT COLOR="#000000">> :OPTIONS</FONT>
<FONT COLOR="#000000">> :TTY</FONT>
<FONT COLOR="#000000">> :SOCKET #<MULTIVALENT stream </FONT>
<FONT COLOR="#000000">> socket connected from localhost/2416 to localhost/5432 @ #x2117923a></FONT>
<FONT COLOR="#000000">> :PID 3772</FONT>
<FONT COLOR="#000000">> :KEY 1674368639).</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> Reason: WARNING: there is no transaction in progress</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> Do you think postgresql-socket should run and the error is with my </FONT>
<FONT COLOR="#000000">> new installation of postgres/cl-sql ?</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> It would be great if you made elephant available for Lispworks on </FONT>
<FONT COLOR="#000000">> windows.</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> Frank</FONT>
<FONT COLOR="#000000">> ______________________________________________________________________ </FONT>
<FONT COLOR="#000000">> ___</FONT>
<FONT COLOR="#000000">> In 5 Schritten zur eigenen Homepage. Jetzt Domain sichern und </FONT>
<FONT COLOR="#000000">> gestalten!</FONT>
<FONT COLOR="#000000">> Nur 3,99 EUR/Monat! <A HREF="http://www.maildomain.web.de/?mc=021114">http://www.maildomain.web.de/?mc=021114</A></FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> _______________________________________________</FONT>
<FONT COLOR="#000000">> elephant-devel site list</FONT>
<FONT COLOR="#000000">> <A HREF="mailto:elephant-devel@common-lisp.net">elephant-devel@common-lisp.net</A></FONT>
<FONT COLOR="#000000">> <A HREF="http://common-lisp.net/mailman/listinfo/elephant-devel">http://common-lisp.net/mailman/listinfo/elephant-devel</A></FONT>
<FONT COLOR="#000000">_______________________________________________</FONT>
<FONT COLOR="#000000">elephant-devel site list</FONT>
<FONT COLOR="#000000"><A HREF="mailto:elephant-devel@common-lisp.net">elephant-devel@common-lisp.net</A></FONT>
<FONT COLOR="#000000"><A HREF="http://common-lisp.net/mailman/listinfo/elephant-devel">http://common-lisp.net/mailman/listinfo/elephant-devel</A></FONT>
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>