JDBC error: 'protocol violation: unexpected line in data block: .'
Hello all, Is this a known bug? Is there any workaround? * Stack Trace java.sql.SQLException: 'protocol violation: unexpected line in data block: .' at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:2535) at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:2284) at nl.cwi.monetdb.jdbc.MonetStatement.internalExecute(MonetStatement.java:508) at nl.cwi.monetdb.jdbc.MonetStatement.execute(MonetStatement.java:349) at nl.cwi.monetdb.jdbc.MonetPreparedStatement.execute(MonetPreparedStatement.java:247) at nl.cwi.monetdb.jdbc.MonetPreparedStatement.executeQuery(MonetPreparedStatement.java:265) * Table definition sql>\d sys.wa_blogs_audience CREATE TABLE "sys"."wa_blogs_audience" ( "tid" CHAR(32) NOT NULL, "ts" BIGINT, "ts_hour" BIGINT, "ts_day" BIGINT, "ts_month" BIGINT, "s_site_name" VARCHAR(32), "s_hostname" VARCHAR(256), "n_pageviews" DOUBLE, "n_visits" DOUBLE, "n_visitors" DOUBLE, "h_visitors_register" VARCHAR(1881), CONSTRAINT "wa_blogs_audience_tid_pkey" PRIMARY KEY ("tid") ); * SQL SELECT ts, hllagg(h_visitors_register) FROM wa_blogs_audience WHERE ts>=1355172393000 AND ts<=1357764393000 GROUP BY ts; * Output from mclient $ mclient -p9701 kpi_v1 -f raw -s "SELECT ts, hllagg(h_visitors_register) FROM wa_blogs_audience WHERE ts>=1355172393000 AND ts<=1357764393000 GROUP BY ts;" at: https://dl.dropbox.com/u/279023/misc/mclient_output.txt * JDBC debug log at: https://dl.dropbox.com/u/279023/misc/monet_1357773164928.log Thanks in advance! -- Luis Neves _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
On 09-01-2013 23:30:38 +0000, Luis Neves wrote:
Hello all,
Is this a known bug? Is there any workaround?
Is this by chance on a Windows client? -- Fabian Groffen fabian@monetdb.org column-store pioneer http://www.monetdb.org/Home _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Hello, On 01/10/2013 07:48 AM, Fabian Groffen wrote:
On 09-01-2013 23:30:38 +0000, Luis Neves wrote:
Is this a known bug? Is there any workaround?
Is this by chance on a Windows client?
No... both the client and server are Linux $ lsb_release -a No LSB modules are available. Distributor ID: Debian Description: Debian GNU/Linux 6.0.4 (squeeze) Release: 6.0.4 Codename: squeeze $ uname -a Linux solr06 2.6.32-5-amd64 #1 SMP Mon Jan 16 16:22:28 UTC 2012 x86_64 GNU/Linux Also... I'm using the latest version of ther jdbc driver and the 11.13.7 version of the monetdb-server compiled from source (the debian packages for this version are borked). $ ldd /usr/bin/mserver5 linux-vdso.so.1 => (0x00007fff51f25000) libmonetdb5.so.13 => /usr/lib/libmonetdb5.so.13 (0x00007fe57a49a000) libbat.so.8 => /usr/lib/libbat.so.8 (0x00007fe579e89000) libmapi.so.6 => /usr/lib/libmapi.so.6 (0x00007fe579c74000) libcrypt.so.1 => /lib/libcrypt.so.1 (0x00007fe579a3d000) libreadline.so.6 => /lib/libreadline.so.6 (0x00007fe5797f9000) libxml2.so.2 => /usr/lib/libxml2.so.2 (0x00007fe5794a7000) libstream.so.3 => /usr/lib/libstream.so.3 (0x00007fe57929f000) libm.so.6 => /lib/libm.so.6 (0x00007fe57901d000) libz.so.1 => /usr/lib/libz.so.1 (0x00007fe578e05000) libpcre.so.3 => /lib/libpcre.so.3 (0x00007fe578bd5000) libssl.so.0.9.8 => /usr/lib/libssl.so.0.9.8 (0x00007fe578980000) libcrypto.so.0.9.8 => /usr/lib/libcrypto.so.0.9.8 (0x00007fe5785de000) libdl.so.2 => /lib/libdl.so.2 (0x00007fe5783da000) libpthread.so.0 => /lib/libpthread.so.0 (0x00007fe5781be000) libc.so.6 => /lib/libc.so.6 (0x00007fe577e5b000) libncurses.so.5 => /lib/libncurses.so.5 (0x00007fe577c15000) /lib64/ld-linux-x86-64.so.2 (0x00007fe57ad7d000) $ java -version java version "1.7.0_03" Java(TM) SE Runtime Environment (build 1.7.0_03-b04) Java HotSpot(TM) 64-Bit Server VM (build 22.1-b02, mixed mode) Thanks! -- /** * Luis Neves * @e-mail: luis.neves@co.sapo.pt * @xmpp: lfs_neves@sapo.pt * @web: http://technotes.blogs.sapo.pt/ * @tlm: +351 962 057 656 * -- * As opiniões expressas por mim não são * necessariamente opiniões em que eu acredito * -- */ _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
On 10-01-2013 08:11:16 +0000, Luis Neves wrote:
Hello,
On 01/10/2013 07:48 AM, Fabian Groffen wrote:
On 09-01-2013 23:30:38 +0000, Luis Neves wrote:
Is this a known bug? Is there any workaround?
Is this by chance on a Windows client?
No... both the client and server are Linux
I tried reproducing your error here MonetDB 5 server v11.13.8 "Oct2012-d1937899c419" (64-bit, 64-bit oids) Driver: v2.8 (Liberica 20130110 based on MCL v1.8) and it runs without problems (on my Mac). I use attached load file, and simply issue a select * from largestrings using mclient and JdbcClient. Does that work for you on a simple table (created by the script) too? -- Fabian Groffen fabian@monetdb.org column-store pioneer http://www.monetdb.org/Home _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
On 01/10/2013 09:26 AM, Fabian Groffen wrote:
I tried reproducing your error here
MonetDB 5 server v11.13.8 "Oct2012-d1937899c419" (64-bit, 64-bit oids) Driver: v2.8 (Liberica 20130110 based on MCL v1.8)
and it runs without problems (on my Mac).
I use attached load file, and simply issue a select * from largestrings using mclient and JdbcClient. Does that work for you on a simple table (created by the script) too?
It works here also... kind of... I created a table "tmp_foo": sql>\d tmp_foo CREATE TABLE "sys"."tmp_foo" ( "ts" BIGINT, "h_visitors_register" VARCHAR(1881) ); sql>INSERT INTO tmp_foo SELECT ts, hllagg(h_visitors_register) FROM wa_blogs_audience WHERE ts>=1355172393000 AND ts<=1357764393000 GROUP BY ts; 22 affected rows (157.172ms) In this sample program I only get this error when running the "sql_3" query... weird... they all have the same output. String sql_1 = "SELECT ts, h_visitors_register FROM tmp_foo;"; String sql_2 = "SELECT ts, hllagg(h_visitors_register) FROM tmp_foo GROUP BY ts;"; String sql_3 = "SELECT ts, hllagg(h_visitors_register) FROM wa_blogs_audience WHERE ts>=1355172393000 AND ts<=1357764393000 GROUP BY ts;"; Class.forName("nl.cwi.monetdb.jdbc.MonetDriver"); Connection conn = DriverManager.getConnection("jdbc:monetdb://host:9701/kpi_v1", "monetdb", "monetdb"); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql_3); while (rs.next()) { System.out.print(rs.getLong(1)); System.out.print("\t"); System.out.println(rs.getString(2)); } rs.close(); stmt.close(); conn.close(); Thanks! -- /** * Luis Neves * @e-mail: luis.neves@co.sapo.pt * @xmpp: lfs_neves@sapo.pt * @web: http://technotes.blogs.sapo.pt/ * @tlm: +351 962 057 656 * -- * As opiniões expressas por mim não são * necessariamente opiniões em que eu acredito * -- */ _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
On 10-01-2013 23:04:24 +0000, Luis Neves wrote:
On 01/10/2013 09:26 AM, Fabian Groffen wrote:
I use attached load file, and simply issue a select * from largestrings using mclient and JdbcClient. Does that work for you on a simple table (created by the script) too?
It works here also... kind of... I created a table "tmp_foo":
sql>\d tmp_foo CREATE TABLE "sys"."tmp_foo" ( "ts" BIGINT, "h_visitors_register" VARCHAR(1881) );
sql>INSERT INTO tmp_foo SELECT ts, hllagg(h_visitors_register) FROM wa_blogs_audience WHERE ts>=1355172393000 AND ts<=1357764393000 GROUP BY ts; 22 affected rows (157.172ms)
In this sample program I only get this error when running the "sql_3" query... weird... they all have the same output.
Where does the hllagg function come from? Does it perhaps write to the stream or flush? It looks like the server sends some sequence the JDBC driver doesn't like.
String sql_1 = "SELECT ts, h_visitors_register FROM tmp_foo;"; String sql_2 = "SELECT ts, hllagg(h_visitors_register) FROM tmp_foo GROUP BY ts;"; String sql_3 = "SELECT ts, hllagg(h_visitors_register) FROM wa_blogs_audience WHERE ts>=1355172393000 AND ts<=1357764393000 GROUP BY ts;";
-- Fabian Groffen fabian@monetdb.org column-store pioneer http://www.monetdb.org/Home _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Hello, On 01/11/2013 07:35 AM, Fabian Groffen wrote:
Where does the hllagg function come from? Does it perhaps write to the stream or flush? It looks like the server sends some sequence the JDBC driver doesn't like.
hllagg is a custom aggregate function that doesn't write to the stream... but I started getting this error even when not using it: https://dl.dropbox.com/u/279023/misc/monet_1357908288066.log (jdbc debug log) humm... this is puzzling. -- /** * Luis Neves * @e-mail: luis.neves@co.sapo.pt * @xmpp: lfs_neves@sapo.pt * @web: http://technotes.blogs.sapo.pt/ * @tlm: +351 962 057 656 * -- * As opiniões expressas por mim não são * necessariamente opiniões em que eu acredito * -- */ _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Fabian Groffen -
Luis Neves