[Monetdb-developers] write error

Sjoerd Mullender sjoerd at acm.org
Thu Oct 7 15:10:41 CEST 2010


On 2010-10-07 14:48, Mark Bucciarelli wrote:
> Hi,
> 
> I'm getting a "write error" when running a fairly large
> and complex query (five tables and subselect in where).
> 
> I run
> 
>    $ mclient -l sql -d <db> -u <usr> < t.sql
>    password:
>    ...
>    % 6, 26, 1, 103, 229, 5 # length
>    write error
>    $ echo $?
>    1

The write error happens when mclient wants to write a character that it
got from the server (i.e. part of the data you're printing) that cannot
be converted to the output character set.  For instance, if you have
some Japanese of Greek (or whatever) character in your data, and you're
attempting to write to a latin-1 (a.k.a. iso-8859-1) terminal.
Try running mclient with the -Eutf-8 option to tell it to "convert" to
UTF-8 (i.e. don't convert anything).  The output may not look good on
your terminal, but you shouldn't get a write error either.  (You might
want to redirect the output to a file.)

> I've run the exact query on SQLite, so I'm pretty
> sure the SQL is good.
> 
> This is Feb2010.  I'm thinking about upgrading, but
> I'm close to a release so I'd prefer not to.
> 
> Does this description remind anyone of a commit to
> Jun2010 that may have fixed such an issue?
> 
> Trying to boil the (complex) SQL down to a small
> reproduceable test case will take a lot of time.
> 
> Is there another approach I can use to debug that
> would be faster?
> 
> There is nothing in the merovingian log.
> 
> Thanks,
> 
> m
> 
> ------------------------------------------------------------------------------
> Beautiful is writing same markup. Internet Explorer 9 supports
> standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2 & L3.
> Spend less time writing and  rewriting code and more time creating great
> experiences on the web. Be a part of the beta today.
> http://p.sf.net/sfu/beautyoftheweb
> _______________________________________________
> Monetdb-developers mailing list
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers


-- 
Sjoerd Mullender

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 371 bytes
Desc: OpenPGP digital signature
URL: <http://www.monetdb.org/pipermail/developers-list/attachments/20101007/a19cf7c9/attachment.sig>


More information about the developers-list mailing list