Hi Fabian
the DbVisualizer log file is :
RD 1298855541531: read final block: 57 bytes
RX 1298855541531: onxRWd3Yv:mserver:9:RIPEMD160,SHA256,SHA1,MD5:LIT:SHA512:
RD 1298855541531: inserting prompt
TD 1298855541531: write final block: 92 bytes
TX 1298855541531: BIG:risk:{SHA256}01fa94fefcadb5918473e49aaa8e425538f8d40960b2d649348cb17c599031ae:sql:krisk:
RD 1298855541546: read final block: 0 bytes
RX 1298855541546:
RD 1298855541546: inserting prompt
TD 1298855541546: write final block: 48 bytes
TX 1298855541546: sSET TIME ZONE INTERVAL '+08:00' HOUR TO MINUTE;
RD 1298855541546: read final block: 0 bytes
RX 1298855541546:
RD 1298855541546: inserting prompt
TD 1298855541546: write final block: 15 bytes
TX 1298855541546: Xreply_size 250
RD 1298855541546: read final block: 0 bytes
RX 1298855541546:
RD 1298855541546: inserting prompt
TD 1298855541546: write final block: 46 bytes
TX 1298855541546: sSELECT "name", "value" FROM sys.env() as env;
RD 1298855541546: read final block: 4246 bytes
RX 1298855541546: &1 0 46 2 46
% .env, .env # table_name
% name, value # name
% varchar, varchar # type
% 18, 203 # length
[ "gdk_arch", "32biti686-pc-win32" ]
[ "gdk_version", "1.40.3" ]
[ "prefix", "D:\\Program Files\\MonetDB\\MonetDB5" ]
[ "exec_prefix", "D:\\Program Files\\MonetDB\\MonetDB5" ]
[ "gdk_dbname", "krisk" ]
[ "gdk_dbfarm", "C:\\Documents and Settings\\swordtan\\Application Data\\MonetDB5\\dbfarm" ]
[ "gdk_debug", "0" ]
[ "gdk_alloc_map", "no" ]
[ "gdk_vmtrim", "yes" ]
[ "monet_admin", "adm" ]
[ "monet_prompt", ">" ]
[ "monet_welcome", "yes" ]
[ "monet_mod_path", "D:\\Program Files\\MonetDB\\MonetDB5\\lib\\MonetDB5;D:\\Program Files\\MonetDB\\MonetDB5\\lib\\MonetDB5\\lib;D:\\Program Files\\MonetDB\\MonetDB5\\lib\\MonetDB5\\bin" ]
[ "monet_daemon", "no" ]
[ "host", "localhost" ]
[ "mapi_port", "50000" ]
[ "mapi_clients", "2" ]
[ "mapi_open", "true" ]
[ "mapi_autosense", "false" ]
[ "default_pipe", "inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector" ]
[ "minimal_pipe", "inline,remap,deadcode,multiplex,garbageCollector" ]
[ "sql_optimizer", "default_pipe" ]
[ "sql_debug", "0" ]
[ "standoff_ns", "" ]
[ "standoff_start", "start" ]
[ "standoff_end", "end" ]
[ "config", "D:\\Program Files\\MonetDB\\MonetDB5\\etc\\monetdb5.conf" ]
[ "mero_pidfile", "D:\\Program Files\\MonetDB\\MonetDB5\\var\\run\\MonetDB\\merovingian.pid" ]
[ "mero_controlport", "50001" ]
[ "nov2009_pipe", "inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector" ]
[ "replication_pipe", "inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,replication,multiplex,garbageCollector" ]
[ "accumulator_pipe", "inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,accumulators,dataflow,history,multiplex,garbageCollector" ]
[ "recycler_pipe", "inline,remap,evaluate,costModel,coercions,emptySet,aliases,deadcode,constants,commonTerms,joinPath,deadcode,recycle,reduce,dataflow,history,multiplex,garbageCollector" ]
[ "cracker_pipe", "inline,remap,evaluate,costModel,coercions,emptySet,aliases,selcrack,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector" ]
[ "sidcrack_pipe", "inline,remap,evaluate,costModel,coercions,emptySet,aliases,sidcrack,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector" ]
[ "datacell_pipe", "inline,remap,evaluate,costModel,coercions,emptySet,aliases,deadcode,constants,commonTerms,joinPath,datacell,deadcode,reduce,dataflow,history,multiplex,garbageCollector" ]
[ "octopus_pipe", "inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,constants,commonTerms,joinPath,octopus,deadcode,reduce,dataflow,history,multiplex,garbageCollector" ]
[ "mapreduce_pipe", "inline,remap,evaluate,costModel,coercions,emptySet,aliases,mapreduce,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector" ]
[ "datacyclotron_pipe", "inline,remap,evaluate,costModel,coercions,emptySet,aliases,datacyclotron,mergetable,deadcode,constants,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,replication,multiplex,garbageCollector" ]
[ "derive_pipe", "inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,derivePath,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector" ]
[ "dictionary_pipe", "inline,remap,dictionary,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,history,multiplex,garbageCollector" ]
[ "compression_pipe", "inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,dataflow,compression,dataflow,history,multiplex,garbageCollector" ]
[ "gdk_mem_pagebits", "16" ]
[ "gdk_mem_bigsize", "1048576" ]
[ "monet_pid", "984" ]
[ "monet_version", "5.22.3" ]
RD 1298855541546: inserting prompt
TD 1298855541562: write final block: 60 bytes
TX 1298855541562: sselect * from risk.td_ind_security_held where id = 1560000;
RD 1298855541578: read final block: 1600 bytes
RX 1298855541578: &1 1 1 30 1
% risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held # table_name
% id, bizdate, painnercode, currency, exchange, seccode, basickind, unrealizedgainchange, unrealizedgain, margingain, interestgain, othergain, yieldrate, accrualinterest, allgain, fullmv, marketvalue, lastfullmv, lastmarketvalue, lastcost, cost, buysum, sellsum, realizedgain, holdingqty, lastholdingqty, mvweight, lastmvweight, fullmvweight, lastfullmvweight # name
% int, varchar, varchar, varchar, varchar, varchar, varchar, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal # type
% 7, 8, 8, 3, 5, 6, 3, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 14, 14, 14, 14 # length
RD 1298855541578: inserting prompt
TD 1298855762109: write final block: 60 bytes
TX 1298855762109: sselect * from risk.td_ind_security_held where id = 1560000;
RD 1298855762125: read final block: 1600 bytes
RX 1298855762125: &1 2 1 30 1
% risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held, risk.td_ind_security_held # table_name
% id, bizdate, painnercode, currency, exchange, seccode, basickind, unrealizedgainchange, unrealizedgain, margingain, interestgain, othergain, yieldrate, accrualinterest, allgain, fullmv, marketvalue, lastfullmv, lastmarketvalue, lastcost, cost, buysum, sellsum, realizedgain, holdingqty, lastholdingqty, mvweight, lastmvweight, fullmvweight, lastfullmvweight # name
% int, varchar, varchar, varchar, varchar, varchar, varchar, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal # type
% 7, 8, 8, 3, 5, 6, 3, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 14, 14, 14, 14 # length
RD 1298855762125: inserting prompt
when I change the sql to : select id,bizdate from risk.td_ind_security_held where id = 1560000 , it gets the right result.so I try to specify other
field , when i specify the column "allgain" , the error appears again.
At 2011-02-28 02:43:44，""
On 27-02-2011 15:05:08 +0800, tangray wrote:
Hi
when execute sql : select * from td_ind_security_held where id = 1560000
in DbVisualizer 7.1.1,it appears "protocol violation: unexpected line in data block"
A protocol violation usually indicates the server is sending some information not at the right occasion. I assume you use JDBC. In order to get more insight in this problem, I need a JDBC debug-log. You can send me this log off-list.
You can create such log by creating a JDBC connection with the debug=true property in the connection url, e.g. jdbc:monetdb://yourhost/yourdb?debug=true
------------------------------------------------------------------------------ Free Software Download: Index, Search & Analyze Logs and other IT data in Real-Time with Splunk. Collect, index and harness all the fast moving IT data generated by your applications, servers and devices whether physical, virtual or in the cloud. Deliver compliance at lower cost and gain new business insights. http://p.sf.net/sfu/splunk-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users