The error is reported by SQL clients (Squirrel SQL, OpenOffice, etc) when issuing SELECT * FROM "dpa"."collection_info"; The previous log file was the output when the above query was passed by the client. On Monday 11 February 2008 16:45:14 Niels Nes wrote:
On Mon, Feb 11, 2008 at 10:14:53PM +0100, Fabian Groffen wrote:
On 11-02-2008 15:14:02 -0500, McKennirey.Matthew wrote:
This is the log file we receive when attempting to display the contents of tables using Squirrel SQL, or any number of other clients using the JDBC driver.
The error message is Error: protocol violation: unexpected line in data block:
In one of the columns, for some INSERTs we store bytes and for other INSERTs, into the same column, we store characters. The column is of type VARCHAR. Is this the issue?
No idea, I think I found your issue though: (removed lots of data to make it readable)
RX 1202760166421: &1 8 37 14 37 % # table_name % # name % # type % # length [ 1 [ 2 [ 3 [ 4 [ 5 [ 6 [ 7 [ 8 [ 9 [ 10 [ 11 [ 12 [ 13 [ 14 [ 15 [ 16
RD 1202760166421: inserting prompt
16 != (14 or 37) so JDBC gets confused by getting more rows than it expects. It could be clearer here in the error message, but I'm not sure where it ends up here, it might complain about seeing the prompt after reading line 15 and 16, in which case the error message is correct.
Niels, any idea on how this can happen (sending more rows than the header says)?
I have no idea. What is the query which gives this problematic output.
Niels
PS. This is a BUG.
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users