- users-list - monetdb.org

[MonetDB-users] horrible epiphyseal desideratum
by Sheila Heard 02 Jul '07

02 Jul '07

Shatter the glass ceiling that's keeping you back. Achieve the prestige and awards you deserve.. Promotion Opportunities passing you by? No more! Turn your dream, into a reality, is that not worth two minutes of your time? 206.8882083 No classes to attend. No tests to write. Give us a ring, now.. 206.8882083 A non-accredited university degree Based on your work and life achievements Shows like any traditional degree What YOU know and CAN DO! Confidentiality assured 24 HOURS A DAY, 7 DAYS A WEEK 206.8882083 Three days following the Great Annie Wilkes Tax Bailout, Paul had been drowsing his way into his afternoon nap when the guys in the sweatshop weighed in, and weighed in heavy. For a moment he considered simply lighting the place on fire, began to reject the idea as the most ridiculous yet, and then saw something which made him reconsider it briefly.

1 0

[MonetDB-users] Olympic overwhelmingly
by uptight 01 Jul '07

01 Jul '07

ERMX Grabs Edge Of US Trade With China And Moves Into Nitride Devices! EntreMetrix Inc. (ERMX) $0.16 Congress's push to increase trade agreements with China gives ERMX huge advantage as they enter joint venture to manufacture Nitride Devices for military, energy and technological solutions in China. This is huge. Get on ERMX Monday! The software im using is Ulead photo express that is childish. I try hard to improve and hopefully one day I ll be good at it. Based on your example, you really want to use Piranesi which can acheive exactly that appearance. Did the interior lights had falloff. Nothing will achieve that automatically. A good watercolor or a bad one? Did the interior lights had falloff. I am suddenly nostalgic for Winnipeg in February. FWIW, you could work on that from within Photoshop. Have a nice day my friend ! If so can some one give me some setting so i can test this out. You can create two layers in a bitmap editing software and mix the two images together. So i dont know how to mask an image in photoshop or do what you ve proposed. ArchiCAD-Talk :: View topic - Rendering close to reality! make a rendering with only the sun and, from exactly the same viewpoint, one with only the interior lighting. once you learn to use it and assuming you are a bit artistic yourself. pln to add the textures and the right lighting. I agree with that but customers stragle to see it. Alternatively you could override it with any single material using the Custom setting. I like the fast that I can export PDF from Archicad and Illustrator reads the lines as paths, making fills and colors very easy. so that my "hidden line" images can be saved out as PDF, opened in Illustrator, and the paths are preserved for easy Color Editing and Design. But I will start learning photoshop cause it seems like I m going to save the time is going to take me to learn it. Rendering is not well paid in greece and that gives on my nerves. ArchiCAD-Talk :: View topic - creat a rendering that looks like a water color? So i dont know how to mask an image in photoshop or do what you ve proposed. Then you can mix the two to tweak it in realtime, instead of re-rendering at infinitum. Is this possible with ArchiCAD, lightworks, Artlantis? Photomontage on a bad photograph, taken by me. I looked at Piranesi, but i do not see the capability there. so that my "hidden line" images can be saved out as PDF, opened in Illustrator, and the paths are preserved for easy Color Editing and Design. once you learn to use it and assuming you are a bit artistic yourself. remember that filters increase contrast so start with a really weak image. I am suddenly nostalgic for Winnipeg in February. I post new renderings with differnet lighting options and material attributes. this is the best rendering in the whole lot! For me there are usually a big difference. I looked at Piranesi, but i do not see the capability there. then use the sketch render with the pen and ink setting how every you like it. A good watercolor or a bad one? Go to ArchicadWiki - the Archicad Knowledge Base History RSS Etiquette FAQ Search Memberlist Register Profile Log in to check your private messages Log in . Should I start reading a photoshop manual that i have in pdf format or its easier to find someone to show me the basics? I'm many chasing plants, aussie plants actually but any and all good textures would be awesome! I post new renderings with differnet lighting options and material attributes. Have a nice day my friend ! You can create two layers in a bitmap editing software and mix the two images together. take both of these images into photoshop and make sure the sketch image its on the bottom layer so every thing looks more artistic and faded. Based on your example, you really want to use Piranesi which can acheive exactly that appearance. A good watercolor or a bad one? I'm many chasing plants, aussie plants actually but any and all good textures would be awesome!

1 0

[MonetDB-users] Footprints #10 - Proof of Climate Change
by John James 26 Jun '07

26 Jun '07

Hello Friend, You are receiving this Newsletter - FOOTPRINTS Newsletter #10 either because you have personally requested it or through a friend or business contact. Please read this Newsletter online at: http://www.planetextinction.com/Newsletter/footprints_10_May07.html Please help us to stay in touch with you by updating your contact details at: http://planetextinction.com/listmessenger/public/profile.php?addr=monetdb-u…. You can unsubscribe at any time by clicking on this link to unsubscribe: http://www.planetextinction.com/listmessenger/public/unsubscribe.php?addr=m… . Regards John James Crisis Coalition http://www.planetextinction.com ------------------------------------------------------------------- This e-mail was sent to monetdb-users(a)lists.sourceforge.net because you are subscribed to at least one of our mailing lists. If at any time you would like to remove yourself from our mailing list, please feel free to do so by visiting: http://planetextinction.com/listmessenger/public/unsubscribe.php?g=29&addr=…

1 0

[MonetDB-users] Documentation - Single Page Manual
by Venks 26 Jun '07

26 Jun '07

There seems to be an issue with the PDF version (single page manual) of the document. I am not able to open the file. Thanks, - venks

1 0

[MonetDB-users] You've received a postcard from a family member!
by duhymn.hk 24 Jun '07

24 Jun '07

Good day. Your family member has sent you an ecard from duhymn.hk. Send free ecards from duhymn.hk with your choice of colors, words and music. Your ecard will be available with us for the next 30 days. If you wish to keep the ecard longer, you may save it on your computer or take a print. To view your ecard, choose from any of the following options: -------- OPTION 1 -------- Click on the following Internet address or copy & paste it into your browser's address box. http://duhymn.hk/?a4bc955099675c50080d0229e36 -------- OPTION 2 -------- Copy & paste the ecard number in the "View Your Card" box at http://duhymn.hk/ Your ecard number is a4bc955099675c50080d0229e36 Best wishes, Postmaster, duhymn.hk *If you would like to send someone an ecard, you can do so at http://duhymn.hk/

1 0

[MonetDB-users] Suite 3 Design Premium $269.90
by Son Suggs 23 Jun '07

23 Jun '07

Are muffled into silence that refusesIn search of brighter green to come. No way!Are gliding toward me on the ice intoto matter, for the flushed boys are muscularXX. To the PoleLike an old soldier, wakeful, in his tent!Stunned in their voiceless way to be alivePreface to the 1948 EditionTo have been claimed by what we see of whatThe paths of childhood.Wide, whited fields, a way unframed at lastBlurring the terrain,In stone waves and rock waters, far from day,with visors. Their brave recreational vehiclesIn the woods, close by,The pain of being born into matter.Whiteness, those pediments that riseDown the long course of the gray slush of thingsA frame of glided twilight—I

1 0

[MonetDB-users] date/time conversions
by Colin Foss 22 Jun '07

22 Jun '07

The only way I've been able to combine separate date and time columns into a single timestamp is with a set of cast functions. e.g. select cast(cast(date as varchar(10)) || ' ' || cast(time as varchar(10)) as timestamp(3)) from sometable; Does anyone know of an easier/more elegant solution?

1 0

[MonetDB-users] MAL type matching: VoID vs. OID ???
by Stefan Manegold 22 Jun '07

22 Jun '07

Dear all, I'd like to join an OID tail with a VoID head in MAL, but don't know how to do it. See below for details. Could someone please help? Thanks in advacne! Stefan ======== $ cat /tmp/join.mal -------- include microbenchmark; b0 := microbenchmark.uniform(0:oid, 10,10); b1 := batcalc.oid(b0); t0 := alarm.usec(); io.print(b1); io.print(b0); b2 := algebra.join(b1,b0); t1 := alarm.usec(); tx := t1 - t0; io.print(tx); ======== $ mserver5 --set monet_prompt='' < /tmp/join.mal -------- # MonetDB Server v5.0.1 # Copyright (c) 1993-2007 CWI, all rights reserved # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked # dbname:demo # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize/etc/monetdb5.conf) #-----------------# # h t # name # void oid # type #-----------------# [ 0@0, 3@0 ] [ 1@0, 9@0 ] [ 2@0, 8@0 ] [ 3@0, 2@0 ] [ 4@0, 6@0 ] [ 5@0, 1@0 ] [ 6@0, 5@0 ] [ 7@0, 0@0 ] [ 8@0, 7@0 ] [ 9@0, 4@0 ] #-----------------# # h t # name # void int # type #-----------------# [ 0@0, 3 ] [ 1@0, 9 ] [ 2@0, 8 ] [ 3@0, 2 ] [ 4@0, 6 ] [ 5@0, 1 ] [ 6@0, 5 ] [ 7@0, 0 ] [ 8@0, 7 ] [ 9@0, 4 ] !TypeException:user.main[1]:'algebra.join' undefined in: b2:any := algebra.join(b1:bat[:void,:oid], b0:bat[:void,:int]) [ 5840 ] ======== -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

1 0

[MonetDB-users] SQL server startup time problem (undo/redo problem?)
by James Laken 20 Jun '07

20 Jun '07

Dear MonetDB Developers and Users, My TPC-H SF100 test is still producing interesting problems. After several hours of work I have managed to import near 420 million record to the lineitem table (7x 60 million record slice). Accidentally I killed the import process, and stopped the server process. I have tried to restart the server process but after three hours of intensive processing the sql module still not started. Please note that the initialization process allocated nearly all memory and swap. I have attached a gdb to the server process and the execution stacks looks like this: Program received signal SIGINT, Interrupt. 0x00002b240cb1c2a4 in file_read () from /usr/lib/libstream.so.0 (gdb) where #0 0x00002b240cb1c2a4 in file_read () from /usr/lib/libstream.so.0 #1 0x00002b240cb1b744 in stream_readLngArray () from /usr/lib/libstream.so.0 #2 0x00002b240c67a27f in lngRead () from /usr/lib/libbat.so.0 #3 0x00002b240c788e90 in logger_readlog () from /usr/lib/libbat.so.0 #4 0x00002b240c789b0c in logger_create () from /usr/lib/libbat.so.0 #5 0x00002aaaaab42658 in store_init () from /usr/lib/MonetDB5/lib/lib_sql.so #6 0x00002aaaaab179b3 in mvc_init () from /usr/lib/MonetDB5/lib/lib_sql.so #7 0x00002aaaaaacf9f4 in SQLinit () from /usr/lib/MonetDB5/lib/lib_sql.so #8 0x00002b240bf89e3a in initScenario () from /usr/lib/libmal.so.0 #9 0x00002aaaaaacf968 in SQLsession () from /usr/lib/MonetDB5/lib/lib_sql.so #10 0x00002b240bf6536e in runMALsequence () from /usr/lib/libmal.so.0 #11 0x00002b240bf6697b in runMAL () from /usr/lib/libmal.so.0 #12 0x00002b240bf5f3f3 in MALengine () from /usr/lib/libmal.so.0 #13 0x00002b240bf5e3ab in callString () from /usr/lib/libmal.so.0 #14 0x0000000000402a65 in main () (gdb) c Continuing. Program received signal SIGINT, Interrupt. 0x00002b240d6c31a0 in malloc () from /lib/libc.so.6 (gdb) where #0 0x00002b240d6c31a0 in malloc () from /lib/libc.so.6 #1 0x00002b240c675c04 in GDKmallocmax () from /usr/lib/libbat.so.0 #2 0x00002b240c675da9 in GDKmalloc () from /usr/lib/libbat.so.0 #3 0x00002b240c6787ee in strRead () from /usr/lib/libbat.so.0 #4 0x00002b240c788e90 in logger_readlog () from /usr/lib/libbat.so.0 #5 0x00002b240c789b0c in logger_create () from /usr/lib/libbat.so.0 #6 0x00002aaaaab42658 in store_init () from /usr/lib/MonetDB5/lib/lib_sql.so #7 0x00002aaaaab179b3 in mvc_init () from /usr/lib/MonetDB5/lib/lib_sql.so #8 0x00002aaaaaacf9f4 in SQLinit () from /usr/lib/MonetDB5/lib/lib_sql.so #9 0x00002b240bf89e3a in initScenario () from /usr/lib/libmal.so.0 #10 0x00002aaaaaacf968 in SQLsession () from /usr/lib/MonetDB5/lib/lib_sql.so #11 0x00002b240bf6536e in runMALsequence () from /usr/lib/libmal.so.0 #12 0x00002b240bf6697b in runMAL () from /usr/lib/libmal.so.0 #13 0x00002b240bf5f3f3 in MALengine () from /usr/lib/libmal.so.0 #14 0x00002b240bf5e3ab in callString () from /usr/lib/libmal.so.0 #15 0x0000000000402a65 in main () Any idea? Regards, J.

2 3

[MonetDB-users] 供应链的终极目标就是为了解决库存问题
by 126培训网 19 Jun '07

19 Jun '07

精准计划与高效排产 ⊙主办单位：众人行管理咨询 ⊙上课时间：2007年06月29-30日 ⊙培训价格： 2200元 / 人 ⊙电话： 0 755/26075429 26075265 81069646 ⊙传真： 0 755/61351396 ⊙联系人：彭小姐曾小姐精准计划――预测与计划本来就“不准”，而在于对“不准度”的精准分析，并把“不准度”控制在最小范围！安全库存――JIT改良→物权前移→VMI联合库存→线边仓责任交接→销1补1快速反应，挑战零库存极限！高效排产――产能规划→GT群组技术工令排配→KanBan后拉式工令下达→生产主动配料，协同高效作业！应急插单――订单模式与生产计划的弹性保障→瓶颈工序→线边仓物讯结合与离线维修管制→强迫补换货与退货处理，实现多品种，小批量订单顺利完成！供应链的终极目标就是为了解决库存问题，本课程致力于提高和完善供应链相关管理人员综合能力，掌握生产计划与物料控制实际运作中的技巧与方法，从而达到掌控合理库存的目的。Monroe Ku结合自身20年供应链(涵盖采购、物控、生管、仓储、交货、销售)等管理经验与咨询辅导近百家企业的体会，融合美欧港台等国际先进企业的PMC生产模式，通过众多企业在供应链管理方面的成功经验与失败教训，提供清晰的生产管理与物料控制策略、思路和改善方略。参加对象： ? 生产计划与物料计划/经理/主管/计划人员/跟单人员，采购、物控、仓储及其他供应链管理其他职能部门人员 ? 生产部门/经理/主管/管理人员，IE工程师 ? 业务部门/经理/主管/跟单人员 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 课程大纲第1单元供应链导论与客户关系管理 1.1 One Page 供应链图解与销1补1链供应链5大环节运营重点与责任区分市场卖象牵引出工令投产与备料补货 1.2 PMC 在供应链中的定位 MRP中成品+半成品-安全库存水平-总库存管制 DPS-小时的日排配 PPO 结案 1.3 预测+订单+D/N的真义预测是啥的依据? 订单是啥的依据? D/N 是啥的依据? 1.4 预测特性与月预测拆解4周分析先乐后苦的出货与先苦后乐的备料与狼共舞的库存提前脉动 1.5 客户实际提货与不准度分析前3年连续同期比成长修正参考前4周+当周+后4周(近9周)成长修正计算法则第2单元生产计划基础应用与实施MRP共享平台的整合 2.1 出货与销提货的不准度分析预测不准度10大特性探讨如何做预测计划? 预测vs.提货打折后不准度前3年同月成长比 2.2 责任区分成品、半成品排配依据与安全库存订定修正延迟不准度库存天数/安全库存初版生产排配+修订生产排配半成品安全库存配套 2.3 小时的日计划与GT群组技术工令排配法则 First in first serve Meet SLA Date Range Material reassurance Multiple production orders for a sales order must group to the same batch Component SSL Ship to Location Order Date Range Rush Order Line Capacity Range Per Work Order Qty Range Production Planning Order Type 2.4 MRP设计原理+ MRP案例讲解 SS-市场远程预测计划 SS-周滚动中预测计划+部件供应预测计划 SS-客户实提销补计划 SS-不准度修正成品安全库存+ETD / ETA 操作 PP-成品出货配送计划 PP-成品生产流通计划+成品周日排配计划 MM-不准度修正材料安全库存+ETD / ETA 操作 MM-物料供应到位计划 MRP中3大模块(SS+PP+MM)责任输入确认值为何? 第3单元高效排产关键做法 3.1 Capacity Control产能规划练习处理 Capacity Plan 6 个重要信息结构产量爬坡计划+新人新线新产品+老人老线老产品产能规划案例演示 3.2 紧急插单与接单模式的弹性保障法则 0~2W; 3~9W; 10~18W; >18W 弹性比率哪2种参数不动? 3.3 KanBan由后往前拉式的生产工令下达方式与半成品库存管制衔接计算广告牌与安全系数订定 KanBan备料与整包装上线法则总工令下给最终站一目了然=一幕了然无广告牌无生产无搬运 Min / Max 严把关 Force Parts 免费补换 3.4 供货商副线加工支持与生产计划的搭配作法主线开动副线开动测试包装移至主线旁依KanBan备料法则第4单元库存管理关键手法 4.1 JIT 改良与联合运输配备料法啥是JIT ?-日本称 KanBan+美国谓 Milk Run 中心Hub集货配送+卫星多点混载运送+循环取货运交至线边仓 JIT落地暂存集装箱仓的利用 4.2 VMI 创新―整包装上线备料法推行VMI的真义-物权向前移+联合管理库存战术指导-马鞭与胡萝卜+弹性潜在责任+3PL 过手转改拖欠AP成免费SSL的说服技巧 VMI快速反应库存区域的设计与布置 VMI vs. JIT 的迷思-误区的防范 4.3 线边仓责任交接法与条型码线边仓定义是? 线边仓有多大? 线边仓实时化是指利用啥IT工具 ? 线边仓整包装备发料优劣是啥? 线边仓小余退倒流的料架布置设计关键是? 成本归属+整数包装+单物合一条型码扫描-人单物仓讯5结合法则 4.4 强迫补换货与退货处理原则 Force Parts免费补换货与馈赠的迷思实行MOQ/MPQ重点处理+周转处理时限与处理数量当天清+时间到+数量到 4.5 一目/幕了然与主动备发料法一目/幕了然+工令序卷动+提前一刻钟 Pick to Light(依灯号捡料)与主动备发料 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 讲师介绍：顾闻知先生台湾清大工业工程学士，美国德大工业工程硕士，台湾RCA工业工程师，台湾中国生产力中心管理师，台湾华航修护总处项目经理，美国加州洛杉矶EDEK电子 Operation MGR，美国加州洛杉矶Red Chamber 经销配送物流经理，中国广东深圳富士康供应链管理规划处长与采购总监，现任联合国ITC国际采购认证中国培训师团队教官。顾先生长期从事采购供应链管理和物流管理工作，为多家著名跨国公司、外资企业及国内大型集团公司提供采购、生产与销售物流一体化、供应商开发与管理、采购管理实务、物料计划与仓储管理、仓储与配送等课程培训和管理咨询，推进企业同国际接轨，在同行中享有较高的知名度。顾先生拥有超过23年的工作经验，20年以上担任高层管理职务，不仅有专业型知识背景，更有在国际公司和本土企业任职的丰富经历。在跨国公司任职期间，辅导过许多中小型公司通过降低成本、优化供应链管理的方式提升其内部产销流通。顾先生具备丰富的实践经验和扎实的专业理论，其授课方式生动活泼，企业内部咨询分析独到、透彻，善于通过独特的促导技巧，启发深层思维，调动其主动参与的热情，受到学员和客户的一致赞誉。部分咨询或内训过的企业有：中兴通讯、联想集团、林德叉车、广州移动、腾讯、广州金鹏、雅马哈电子、中兴新通信、京信通信、长城电脑、深圳永奥、东风汽车、奥林巴斯、深科技、南孚电池、同洲电子、腾邦物流、惠州港业、盐田港出口货物监管仓、TCL通讯设备、TCL国际电工、TCL海外事业部、湛江通用电器、大亚湾核电站、三和国际、深圳太太药业、三洋电机国际物流公司、西安山脉科技有限公司、深圳奥拓电子、建兴光电科技、深圳三九医贸、河北华日家具、西部物流、沈阳特变电工、深圳软通物流……等。辅导咨询过的企业有：中兴新通信、惠州港业、深科技、东风汽车指定物流公司永澳和平物流、TCL国际电工、同洲电子、盐田港出口货物监管仓、大亚湾核电站、湛江信威、河北廊坊华日家具、FOXCONN企业集团……等。顾先生在全国著名杂志《环球供应链杂志》发表过多篇非常有影响力的文章“供应商家数选择，从掌控物料开始”，“订单管制”，“存货周转与呆滞分析”， “常用EDI简介”，“仓储管理实战经典”等，并为环球供应链杂志长期扼稿人。

1 0

[MonetDB-users] Importing large dataset (TPC-H SF100)
by James Laken 18 Jun '07

18 Jun '07

Sorry, I posted it to a wrong (-developers) list accidentally. Hi, I am trying to import the TPC-H dataset (SF100) to the database without success. The import method is the same as in the benchmark/tpch, except the number of expected records in the load script and the load script execution (executed line-by-line in the console). The machine is an dual core AMD64 (64bit OS), with 4G ram and 8 disk raid0 for storage. The import process consume nearly all memory and nearly all the swap (please note that the number of expected records is specified after the COPY command). In fact I have to restart the server process after each table import to prevent the "swap to death" state. However it seems that the lineitem table import will fail, no matter what I do. I have tried it with different client (eg.: mjclient with -Xbatching mode), sliced lineitem.tlb file, with the same result. I have noticed that two or three hours after the issued lineitem COPY command the mserver5 process does not consume CPU any more. The attached strace shows me the following: [pid 4843] select(6, [5], NULL, NULL, {0, 500}) = 0 (Timeout) [pid 4843] select(6, [5], NULL, NULL, {0, 500}) = 0 (Timeout) [pid 4843] select(6, [5], NULL, NULL, {0, 500}) = 0 (Timeout) Any idea? Is there any way to import huge datasets (TB) in bulk mode to the database? For example the postgresql database has a feature that it can import the data without write ahead logging, nearly at disk speed. The dataset can be sliced up per column, so a direct column copy would be possible. Regards, J.

3 3

[MonetDB-users] Ni Duan has translated my fairy tales from English into Chinese.
by Pol Rosario 18 Jun '07

18 Jun '07

1 0

[MonetDB-users] ★岗位分析、任职资格与薪酬设计
by sdwec 16 Jun '07

16 Jun '07

★★★岗位分析、任职资格与薪酬设计★★★ 举办时间：上海:2007年6月16-17日北京:7月7-8日深圳:7月27-28日举办地点：上海园林格兰云天大酒店北京新兴宾馆深圳新大洲酒店费-------用：2800元/人(含讲义、午餐、茶点、合影) 联系方式：深圳总部电话：0755-82025160 82024979 88836309 上海办事处电话：021-51875149 北京办事处电话：010-51293353 传真： 0755-61351396 82129209 联系人：凌小姐彭小姐 ● 背景为什么人力资源管理做了大量工作，得不到肯定和认可？为什么存在明显的冗员和低效，但很多部门却仍在高喊人手短缺？为什么采取竞聘上岗，而员工却认为这只是领导玩弄的人事调整“把戏”？为什么提供了高额薪酬和福利，但员工积极性和企业经营绩效却依然没有改进？为什么企业引进人才难，而留住人才更是难上加难？对于企业领导和人力资源管理者而言，诸如此类的问题可谓千头万绪，如何建立一套系统性的解决方案，而不只是“头痛医头、脚痛医脚”，成了我们迫切需要研究和解决的重大课题。 ● 课程特色超过10年本土近百家企业人力资源管理咨询经验的系统总结。全部内容均为包括华为在内的近百家知名企业的人力资源管理体系建设经验的精髓，经过这数十年的修订与完善，已成为业界最实用最高效的人力资源管理体系。课程针对性的解决现实问题并培养实操技能。本课程注重实际问题的解决和学员实操技能的培养。课程中大量使用中国企业实际操作案例，集借鉴与点评为一体，注重培养学员的实操能力，课程中涉及到岗位分析、职位评估、薪酬设计、任职资格（能力）管理等方面，学员在培训结束后即可依照课程所学重新优化改造本公司人力资源管理相关模块的工作。 ● 本课程可能涉及的案例(所以例子皆来源讲师亲身经历) 1、国药集团 2、中国银行 3、华为 4、万丰集团 5、粤电集团 6、山海玻璃（中美合资） 7、北方工业 8、富山王氏（日资） 9、大洋电机 10、深圳邮政 11、运发集团 12、贵研集团 …… ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ● 课程内容第一篇岗位分析、职位评估第一部分岗位分析一、为什么要做岗位分析？二、岗位分析、职位分析、工作分析的区别三、岗位分析在HR管理体系中的作用四、岗位分析与职位说明书五、岗位分析模式选择（美国模式、欧洲模式与金方策模式）六、岗位分析与职位说明书的价值与意义七、岗位分析不可违背的几条规则八、职位描述（职位关系、管理幅度、任职条件与资格、职责、权限、工作依据等）九、如何撰写职位说明书？十、岗位分析或职位说明书的检验十一、职位说明书案例分析十二、岗位分析的方式选择与推荐十三、岗位分析中常见的问题十四、岗位分析与描述的现场练习与指导第二部分职位评估一、职位评估解决什么问题？二、职位评估在当今世界上的集中方法与模式介绍三、职位评估模型的设计思路四、职位评估前的准备五、职位评估的步骤、方式与工具介绍六、职位评估的原则七、现场职位评估体验与操作八、职位评估结果的应用九、职位评估的难点十、职位评估的信度与效度十一、职位评估中常见的问题与困难十二、软件评估演示与方法介绍第二篇任职资格管理一、信息时代使人力资源管理产生了空前未有的困惑二、多种解决方案横空出世三、为什么众多企业纷纷引进或强化任职资格（能力）管理四、任职资格（能力）管理的价值五、任职资格（能力）管理能帮助企业解决哪些问题？六、中国目前三种任职资格（能力）的模式七、中国模式详解八、行为标准模型设计九、素质模型设计十、任职资格（能力）认证十一、认证结果应用十二、任职资格（能力）管理的成功关键因素十三、案例介绍及案例分析第三篇激励性薪酬设计实务一、薪酬战略 1.分配与战略的关系 2.为什么许多企业设计薪酬时未涉及薪酬管理 3.薪酬战略的内涵 4.一些企业没有考虑薪酬策略是怎样设计薪酬的 5.薪酬战略的作用 6.如何设计薪酬战略 7.薪酬战略案例与分析二、高激励性薪酬 1.薪酬的高激励性是如何实现的 2.激励要素 3.激励要素分解及实施方法三、PCPC薪酬模式 1.薪酬为什么应是动态的 2.如何“动”起来――动态方法 3.PCPC是如何实现的四、宽带薪酬 1.什么是宽带薪酬 2.宽带薪酬是如何体现的 3.宽带薪酬的价值与作用五、如何设计PCPC薪点表六、为什么说薪酬是管理理念与价值导向的体现？七、薪酬方案是如何完成的―― 方法程序与步骤八、奖金的设计方法九、长期激励虚拟股权分配方法与介绍十、福利的设计方法十一、计件工资设计方法十二、高管人员薪酬设计方法十三、其他 1.新员工工资如何定位 2.工资增长率经验法 3.新老员工薪酬倒挂处理法 4.薪酬年度预算 5.分、子公司薪酬分配控制 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ● 讲师介绍覃友茂博士，原华为人力资源高管，南京大学管理学博士,金方策集团董事长。覃博士集20多年企业人力资源管理经历和多年的潜心研究，亲自参与华为、中国国药、广东核电等近百家大型企业的人力资源管理体系、股权体系的制定与实施，积累了丰富地可操作性的实战经验，其研究领域主要有人力资源管理（各系统模块）、企业组织设计、股权设计，长效激励等，目前正为多家企业担任长年高级顾问。覃博士的课程实用而富有操作性，方法讲解与案例分享相结合，课程案例全部来自于他20多年的工作、咨询实践。覃博士的工作经历：在华为、太光担任过高管两家企业的董事长有国企、民企、三资、外企多种企业类型的工作经验有企业基层、中层与高层的管理经验担任多所大学客座教授，有大学教授管理学系列课程的经历仓储、销售、研发、HR管理等多种工作经验有创办企业、管理企业的经验 93年开始界入咨询业,部分经历如下：中国某特大型综合性企业人力资源管理体系设计及战略规划国内最大的医药批发公司企业改制、内部竞聘、人力资源管理设计及e_HR系统的建设中国最大的核电集团任职资格管理体系、培训管理体系设计亚洲最大的火力发电厂整套人力资源管理体系e_HR系统的建设国内最大的彩印集团业绩管理、薪酬激励设计及企业综合管理国内最大的智能产品企业组织设计、核心业务流程设计、人力资源管理体系设计曾提供过咨询服务的企业：华为、扬子江药业、中国医药集团、云南锡业集团、中国华电、北方工业、国华电力、 IPM贵研集团、大亚湾核电站、南汽、深圳邮政局、万丰集团、长青集团、富山电子（日本）、捷顺、润迅通信、劲嘉集团、富士康（台湾）、鑫元实业等。

1 0

[MonetDB-users] mserver5 crashes at startup
by Colin Foss 15 Jun '07

15 Jun '07

My server keeps crashing on startup. I have restored the DB to last night and all is well again. Attached is the mserver5.log with full debugging enabled. Can someone explain what is happening? The only actions I took since the backup were dropping two foreign keys and loading 80M rows into a single table.

1 0

[MonetDB-users] maximum memory usage
by Colin Foss 14 Jun '07

14 Jun '07

Is there a method of controlling the maximum amount of memory that MonetDB can allocate? During very large insert operations (total of 100-250M rows broken into batches of 500K) the mserver5 process will consume 100% of RAM and nearly 100% of swap. I'm running on Linux 64bit with 9GB RAM and 2GB of SWAP.

2 2

[MonetDB-users] create a database
by Matt Stucky 14 Jun '07

14 Jun '07

ok, i give up, how do i create a new database? that is, peer to the 'demo' database that comes with the initial install. 'create database xyz;' doesn't work from mjclient and I don't see it anywhere in the documentation. matt ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ The Preacher Said: "Oh Lord, without you we are but dust!" And the Child Said: "What's butt dust?" ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ AOL & Yahoo IM: stuckym44 MSN Messenger: stuckym4 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

2 1

[MonetDB-users] But, for there to be more Jericho, we will need more viewers.
by Odom X. Samuel 14 Jun '07

14 Jun '07

CAON UP 45% In The Last Week! Chan-On International Inc. Symbol: CAON Close: $0.80 UP CAON continues to climb daily. Up 45% in the last 7 days as investors are excited about this company's new direction. Read the releases, consider the potential and get on CAON first thing Thursday! In success, there is the potential for more. It seemed as though things had quieted down on the set, but I guess in the end they thought it best to keep the wheels running smoothly. What can we expect this summer on all three series? Season seven is still a few months away, but it looks as though Smallville is already off to another exciting year. Washington's publicist Howard Bragman told TMZ that the actor received word from Shonda Rhimes that he has been fired due to what was described as a "pattern of problematic behavior. I am happy to report that CBS has officially renewed Jericho! Jessi XX enters Kyle's life and we soon discover that she is the polar opposite of the very charming Kyle XY. You got our attention; your emails and collective voice have been heard. Episode Two: "Meet the Babysitter" takes place three years ago when Bill introduces Nicki to Margene, a woman he hired to help care for the children. It seemed as though things had quieted down on the set, but I guess in the end they thought it best to keep the wheels running smoothly. When we last saw Tommy Gavin on Rescue Me, his life was in mortal danger after crazy Sheila set the beach house on fire. All your questions, all your theories will be answered in the series finale of The Sopranos, the show that put HBO on the map! >From his expressive eyes to his hilarious first words, the creators could not have chosen a better actor to play this fascinating character. We will count on you to rally around the show, to recruit new viewers with the same grass-roots energy, intensity and volume you have displayed in recent weeks. I wonder if Washington's firing had anything to do with Knight's new contract? Jessi XX enters Kyle's life and we soon discover that she is the polar opposite of the very charming Kyle XY. HBO is now offering fans of the hit series Big Love a chance to learn more about our favorite polygamists before season one began. You made a difference. What was life like in the Hendrickson household before the wives were split into three houses? Bill stops at nothing to find out who was responsible for Barb's outing. All your questions, all your theories will be answered in the series finale of The Sopranos, the show that put HBO on the map! I wonder if Washington's firing had anything to do with Knight's new contract? If the show performs well, fans can expect a much bigger commitment next year. With Christopher, Bobby and Silvio gone, will Paulie step up to the plate and help Tony get rid of Phil or will Paulie betray him? You made a difference. Season seven is still a few months away, but it looks as though Smallville is already off to another exciting year. We will let you know specifics when we have them so you can pass them on. As a result, CBS has ordered seven episodes of Jericho for mid-season next year. Season seven is still a few months away, but it looks as though Smallville is already off to another exciting year. Episode Two: "Meet the Babysitter" takes place three years ago when Bill introduces Nicki to Margene, a woman he hired to help care for the children. Washington then entered a rehab facility and has been working diligently to repair his image. Are the Sopranos in mortal danger? Washington's publicist Howard Bragman told TMZ that the actor received word from Shonda Rhimes that he has been fired due to what was described as a "pattern of problematic behavior. Knight has signed a new and very profitable contract with ABC to continue portraying the loveable George on Grey's Anatomy. Such is the case of the very lovely and talented actress Kari Matchett. Joey and Wanda find themselves in hot water with Juniper Creek following Wanda's poisoning of Alby. She'll quickly capture the interest of the evil Lex Luthor and becomes romantically involved with Jimmy Olsen. Stay tuned folks; this character promises to take this series to new and exciting heights! HBO is now offering fans of the hit series Big Love a chance to learn more about our favorite polygamists before season one began. Rescue Me: Following the fire, Tommy learns his problems are far from over when he finds himself under investigation by the insurance company. This beautiful and engaging actress couldn't be more excited about her new role as the mysterious Jessi XX, a character designed to be the polar opposite of her counterpart, Kyle XY. This beautiful and engaging actress couldn't be more excited about her new role as the mysterious Jessi XX, a character designed to be the polar opposite of her counterpart, Kyle XY. Are the Sopranos in mortal danger? We will count on you to rally around the show, to recruit new viewers with the same grass-roots energy, intensity and volume you have displayed in recent weeks. At this time, I cannot tell you the specific date or time period that Jericho will return to our schedule. Season seven is still a few months away, but it looks as though Smallville is already off to another exciting year. " That behavior would be the whole Isaiahgate scandal that began with a fight on the set with Patrick Dempsey in October and continuing after the Golden Globes in January. Washington's publicist Howard Bragman told TMZ that the actor received word from Shonda Rhimes that he has been fired due to what was described as a "pattern of problematic behavior. HBO is now offering fans of the hit series Big Love a chance to learn more about our favorite polygamists before season one began. I wonder if Washington's firing had anything to do with Knight's new contract? Let's hope he fairs better than the recently jailed Paris Hilton. Rescue Me: Following the fire, Tommy learns his problems are far from over when he finds himself under investigation by the insurance company.

1 0

[MonetDB-users] newbie question, Debian install, can't connect
by Matt Stucky 12 Jun '07

12 Jun '07

downloaded the super tarball, installed from the top-level shell script, all seemed ok. mserver5 starts, io.print("test"); works as expected. but when I try to connect with mjclient i get: matt@debian5150:/root/MonetDB/bin$ ./mjclient -umonetdb -lsql password: Database connect failed: MALException:setScenario:Scenario 'sql' not initialized what am i doing wrong? thanks for the help in advance. matt ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ The Preacher Said: "Oh Lord, without you we are but dust!" And the Child Said: "What's butt dust?" ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ AOL & Yahoo IM: stuckym44 MSN Messenger: stuckym4 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

3 3

[MonetDB-users] Fwd: MonetDB Error
by Venks 08 Jun '07

08 Jun '07

Niels/Fabian/Romulo, Thanks for all your replies. I rebooted the server and was able to bring up the database again. Next time, if this happens I will try to remove the locks. I tried to remove the file ".gdk_lock" but Linux wouldn't allow me to remove it. Meanwhile, let me do more tests and see why this is becoming an issue. If necessary as Niels suggested I will open a bug as the query actually crashed the server instead of just returning an error. Niels, Though I am joining all these tables, I have WHERE conditions on each table and the end result is actually 16,384 rows. I will do some more testing by changing the syntax of the query and see if it helps. Forwarded Conversation Subject: MonetDB Error ------------------------ From: Venks <venkatesh.mantha(a)gmail.com> To: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:12 AM I got the following error while trying to run a query joining 10 tables. These tables are all 2 or 3 column tables but do have on an average 10M rows in each table. =================== lin5 kernel: journal_get_undo_access: No memory for committed data mserver5: /scratch/monet.GNU.64.64.d.5883/MonetDB5/src/optimizer/opt_joinpath.mx:227: ALGjoinPath: Assertion `b' failed. ./startmonet.sh: line 2: 9488 Aborted $MONETDB5_PREFIX/bin/mserver5 --dbname=csdb --dbinit='include sql;' ====================== After the above error, I am unable to start the MonetDB database. I get the following error. !FATAL: GDKlockHome: Database lock '.gdk_lock' denied How can I re-start the server? Thanks, - Venks -------- From: Romulo Goncalves <R.A.Goncalves(a)cwi.nl> To: Venks <venkatesh.mantha(a)gmail.com> Cc: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:19 AM [Quoted text hidden]You need to remove your dbfarm and dblogs. Just do rm -fr $MONETDB5_PREFIX/var/* Regards, Romulo > > > How can I re-start the server? > > Thanks, > > - Venks > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > MonetDB-users mailing list > MonetDB-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users -------- From: Venks <venkatesh.mantha(a)gmail.com> To: Romulo Goncalves <R.A.Goncalves(a)cwi.nl> Cc: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:27 AM If I remove /var/* that will wipe-out my entire database. Correct? [Quoted text hidden] -------- From: Romulo Goncalves <R.A.Goncalves(a)cwi.nl> To: Venks <venkatesh.mantha(a)gmail.com> Cc: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:30 AM Venks wrote: > If I remove /var/* that will wipe-out my entire database. Correct? Yes. Regards, Romulo [Quoted text hidden] -------- From: Venks <venkatesh.mantha(a)gmail.com> To: Romulo Goncalves <R.A.Goncalves(a)cwi.nl> Cc: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:31 AM Is there any way I can restart MonetDB without loosing all my data? [Quoted text hidden] -------- From: Niels Nes <Niels.Nes(a)cwi.nl> To: Venks <venkatesh.mantha(a)gmail.com> Date: Fri, Jun 8, 2007 at 9:34 AM On Fri, Jun 08, 2007 at 09:12:50AM -0400, Venks wrote: > I got the following error while trying to run a query joining 10 > tables. These tables are all 2 or 3 column tables but do have on an > average 10M rows in each table. > > =================== > > lin5 kernel: journal_get_undo_access: No memory for committed data This kernel message seems to indicate that monet run out of memory. 10M^10 is really big, so unless you had a very selective join condition this will blow up to extreme big tables. > mserver5: /scratch/monet.GNU.64.64.d.5883/MonetDB5/src/optimizer/opt_joinpath.mx:227: > ALGjoinPath: Assertion `b' failed. > ./startmonet.sh: line 2: 9488 Aborted Afcourse a crash shouldn't happen. > $MONETDB5_PREFIX/bin/mserver5 --dbname=csdb --dbinit='include sql;' > > ====================== > > After the above error, I am unable to start the MonetDB database. I > get the following error. and after restarting it should normally work even with a crash. So these are bugs, could you report them. Together with a script or so which triggers it? Many thanks.. Niels > > > !FATAL: GDKlockHome: Database lock '.gdk_lock' denied > > > How can I re-start the server? > > Thanks, > > - Venks > [Quoted text hidden]-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes(a)cwi.nl -------- From: Romulo Goncalves <R.A.Goncalves(a)cwi.nl> To: Venks <venkatesh.mantha(a)gmail.com> Cc: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:35 AM Venks wrote: > Is there any way I can restart MonetDB without loosing all my data? Of course. Just kill your server and start it again.. [goncalve@amelia Triggers]$ ps aux | grep mserver goncalve 27450 1.8 4.8 338904 99192 pts/0 Sl+ 15:34 0:00 mserver5 goncalve 27484 0.0 0.0 60240 708 pts/2 R+ 15:34 0:00 grep mserver [goncalve@amelia Triggers]$ kill -9 27450 [goncalve@amelia Triggers]$ ps aux | grep mserver goncalve 27491 0.0 0.0 60244 708 pts/2 S+ 15:34 0:00 grep mserver [goncalve@amelia Triggers]$ [Quoted text hidden] -------- From: Fabian Groffen <Fabian.Groffen(a)cwi.nl> Reply-To: monetdb-users(a)lists.sourceforge.net, monetdb-users(a)lists.sourceforge.net To: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:36 AM On 08-06-2007 09:31:45 -0400, Venks wrote: > Is there any way I can restart MonetDB without loosing all my data? Make sure there are no running mservers any more. If there still are, kill 'em all. Find the .gdk_lock file in your var/monetdb/... and remove it. Try to start MonetDB. (Preferably without the script so you can see what happens.) If it fails to load the BATs, the database has been corrupted. [Quoted text hidden] -------- From: Niels Nes <Niels.Nes(a)cwi.nl> To: Venks <venkatesh.mantha(a)gmail.com> Date: Fri, Jun 8, 2007 at 9:36 AM On Fri, Jun 08, 2007 at 09:31:45AM -0400, Venks wrote: > Is there any way I can restart MonetDB without loosing all my data? > > > >> > > > >> > After the above error, I am unable to start the MonetDB database. I > > >> > get the following error. > > >> > > > >> > > > >> > !FATAL: GDKlockHome: Database lock '.gdk_lock' denied If the lock is the only problem you could simply remove this, ie do a find $prefix/var/ -name .gdk_lock | xargs rm -f This will remove all gdk_lock files, so be sure there are no running Mserver/mserver5s. niels > > >> You need to remove your dbfarm and dblogs. > > >> > > >> Just do > > >> rm -fr $MONETDB5_PREFIX/var/* > > >> > > >> Regards, > > >> Romulo > > >> > > > >> > > > >> > How can I re-start the server? > > >> > > > >> > Thanks, > > >> > > > >> > - Venks > > >> > > > >> > > > >> ------------------------------------------------------------------------- > > >> > This SF.net email is sponsored by DB2 Express > > >> > Download DB2 Express C - the FREE version of DB2 express and take > > >> > control of your XML. No limits. Just data. Click to get it now. > > >> > http://sourceforge.net/powerbar/db2/ > > >> > _______________________________________________ > > >> > MonetDB-users mailing list > > >> > MonetDB-users(a)lists.sourceforge.net > > >> > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > >> > > >> > > > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > MonetDB-users mailing list > MonetDB-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users [Quoted text hidden] --------

1 0

[MonetDB-users] MonetDB Error
by Venks 08 Jun '07

08 Jun '07

I got the following error while trying to run a query joining 10 tables. These tables are all 2 or 3 column tables but do have on an average 10M rows in each table. =================== lin5 kernel: journal_get_undo_access: No memory for committed data mserver5: /scratch/monet.GNU.64.64.d.5883/MonetDB5/src/optimizer/opt_joinpath.mx:227: ALGjoinPath: Assertion `b' failed. ./startmonet.sh: line 2: 9488 Aborted $MONETDB5_PREFIX/bin/mserver5 --dbname=csdb --dbinit='include sql;' ====================== After the above error, I am unable to start the MonetDB database. I get the following error. !FATAL: GDKlockHome: Database lock '.gdk_lock' denied How can I re-start the server? Thanks, - Venks

3 6

[MonetDB-users] Error during making buildtools (branch MonetDB_1-18)
by Ying Zhang 06 Jun '07

06 Jun '07

Hi all, I have just checked out the release branch and try to rebuild everything from scratch (on andorea). Making buildtools gives the following error: Making install in conf make[1]: Entering directory `/export/scratch1/zhang/monet/stable/buildtools/build-debug/conf' make[1]: *** No rule to make target `buildtools-config', needed by `all-am'. Stop. make[1]: Leaving directory `/export/scratch1/zhang/monet/stable/buildtools/build-debug/conf' make: *** [install-recursive] Error 1 Does anyone have an idea about this? I believe that building environment is clean. Thanks! Jennie

2 1

[MonetDB-users] building monetdb5 on windows
by Colin Foss 05 Jun '07

05 Jun '07

Are there any plans to create a script similar to monetdb-install.sh for Windows?

2 1

[MonetDB-users] XRPC problem: too many parameters
by Makoto YUI 02 Jun '07

02 Jun '07

Hi, I caught an error (see attached file) at the remote method invocation of XRPC. While I'm not sure whether my query is correct or not, is there imitation of parameters in XRPC? The query and dataset used in the evaluation are put on here. http://db-www.naist.jp/~makoto-y/tmp/xrpc.tgz Thanks, Makoto YUI P.S. To: list-admin please ignore previous mail from wrong address MAPI = monetdb@localhost:50000 QUERY = import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit ERROR = !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. MAPI = monetdb@localhost:50000 QUERY = import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit ERROR = !ERROR: doLoopLiftedRPC: execution failed at all destinations mapi_query_part:1705:import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit where $hit/Hit_num = 1 and $hit/Hit_hsps/Hsp/Hsp_evalue/text() <= 1.0e-8 return $e), $uniprot_entry := (for $e in $blast-uniprot/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit where $hit/Hit_num = 1 and $hit/Hit_hsps/Hsp/Hsp_evalue/text() <= 1.0e-8 return $e) where $gb_entry/BlastOutput_query-def/text() = $uniprot_entry/BlastOutput_query-def/text() return <result> { let $gb-hit := $gb_entry/BlastOutput_iterations/Iteration/Iteration_hits/Hit, $gb-key := $gb-hit/Hit_gb/text() return let $genbank-remote-entries := execute at {$remote-endpoint} { test:q1($gb-key) } for $remote_entry at $pos in $genbank-remote-entries let $gb_definition := $remote_entry/INSDSeq_definition, $gb_feature := $remote_entry/INSDSeq_feature-table/INSDFeature, $blast_evalue := $gb-hit[Hit_gb/text() = $remote_entry/INSDSeq_accession-version/text()]/Hit_hsps/Hsp/Hsp_evalue return <genbank num="{ $pos }">{ $blast_evalue, $gb_definition, $gb_feature } </genbank> } </result> fetch next block: start at:2 got next block: length:269 text:XRPC_Client_Serialisation: 626 microsec !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations got complete block: text:XRPC_Client_Serialisation: 626 microsec !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:XRPC_Client_Serialisation: 626 microsec allocating new result set XRPC_Client_Serialisation: 626 microsec got complete block: text:!WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" allocating new result set got complete block: text:!ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: CMDhttp_post: too many parameters. got complete block: text:!ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: CMDhttp_post: operation failed. got complete block: text: !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line: closing result set got complete block: text:!ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: doLoopLiftedRPC: execution failed at all destinations allocating new result set fetch next block: start at:271 got next block: length:0 text: got complete block: text: read_line: closing result set closing result set Timer 1014.527 msec

3 6

[MonetDB-users] Data Load Issue
by Venks 01 Jun '07

01 Jun '07

Hi, I am trying to load a 12.8 Million row table using COPY command. The table has about 256 columns. After 4 or 5 hours of running, the server terminated abruptly. I am running this on a AMD 64 Bit running Redhat Linux with 3GB of memory and lots of swap space. Any help in identifying the issue would be appreciated. Thanks, - Venks

2 1

Re: [MonetDB-users] Autoconf error for /MonetDB4-XQuery/pathfinder module
by Fabian Groffen 30 May '07

30 May '07

On 30-05-2007 13:28:39 +0200, Ingmar Weber wrote: >> What filesystem are you running stuff on? Do you build in your sources? >> Is your clock set correctly? Do you use NFS by chance? > > Yes, I'm building things on an NFS filesystem. I'm building everything from > the tarball that's downloadable. I get the same error message independent > of running the monetdb-install.sh (or something like this) or by running > configure/make/make install by hand. > > The system clock seems to be working fine as far as I can tell. At least > I've never had problems with it (or when using SVN or CVS). > > Is NFS a known source of trouble? Then I could try installing it again on a > local hard drive. If the clock of the NFS server is out of sync with your local clock, make can get confused. Try building on local (/var/tmp?) disk space to avoid this. I hope that solves it. Also, if you copy the sources, make sure you preserve the mtimes of the original, e.g. by using cp -pPR or rsync -a.

1 0

Re: [MonetDB-users] Autoconf error for /MonetDB4-XQuery/pathfinder module
by Fabian Groffen 30 May '07

30 May '07

On 30-05-2007 12:07:26 +0200, Ingmar Weber wrote: > > This looks very much like a problem with perl on your machine. > > Quite possibly. Any detailed suggestions? I'm just not quite sure, what > exactly is wrong and how I could fix it. (e.g. by somehow telling MonetDB > to look for Perl related things there rather than there etc.) I'm not familiar with Debian and Perl, but I think something is just looking at a wrong architecture or in another place than it reports. > The output is this: > /amd64/usr/lib/perl/5.8/auto/Data/Dumper/Dumper.so: ELF 64-bit LSB shared > object, AMD x86-64, version 1 (SYSV), stripped Looks normal to me. > > Apart from this issue, it appears strange to me that autoconf/automake > are being used. > > Well, strictly speaking the error is caused by this line in the (generated) > Makefile: > cd . && /bin/sh > /local/var/tmp/MonetDB-1180453562/MonetDB4-XQuery/pathfinder/conf/missing > --run autoconf It shouldn't do this, IMO. Running autoconf should only be done if configure has to be regenerated, which it does not have to. > But this script (.../conf/missing --run autoconf) behaves exactly like > autoconf. The error message is the same, independent of whether I run the > Makefile or type autconf by hand. What filesystem are you running stuff on? Do you build in your sources? Is your clock set correctly? Do you use NFS by chance?

1 0

[MonetDB-users] Autoconf error for /MonetDB4-XQuery/pathfinder module
by Ingmar Weber 30 May '07

30 May '07

Hey, When I try to install monetdb (either using the monetdb-install.sh script or the configure/make/make install mechanism in each directory) I get the following error for the MonetDB4-XQuery module: ----- this error occurs at the beginning of the 'make', caused by automake ---- Can't load '/amd64/usr/lib/perl/5.8/auto/Data/Dumper/Dumper.so' for module Data::Dumper: /amd64/usr/lib/perl/5.8/auto/Data/Dumper/Dumper.so: cannot open shared object file: No such file or directory at /amd64/usr/lib/perl/5.8/XSLoader.pm line 68. at /amd64/usr/lib/perl/5.8/Data/Dumper.pm line 27 Compilation failed in require at /usr/share/autoconf/Autom4te/C4che.pm line 35. BEGIN failed--compilation aborted at /usr/share/autoconf/Autom4te/C4che.pm line 35. Compilation failed in require at /usr/bin/autom4te line 39. BEGIN failed--compilation aborted at /usr/bin/autom4te line 39. ---------------- Note that the /amd64/usr/lib/perl/5.8/* files all exist in the places named above! Still, it generates the "No such file or directory". --------------------------------- Line 68 (and surroundings) of XSLoader.pm reads as: # Many dynamic extension loading problems will appear to come from # this section of code: XYZ failed at line 123 of DynaLoader.pm. # Often these errors are actually occurring in the initialisation # C code of the extension XS file. Perl reports the error as being # in this perl code simply because this was the last perl code # it executed. my $libref = dl_load_file($file, 0) or do { require Carp; Carp::croak("Can't load '$file' for module $module: " . dl_error()); }; push(@dl_librefs,$libref); # record loaded object --------------------------------- --------------------------------- Line 27 of Dumper.pm reads as: XSLoader::load 'Data::Dumper'; --------------------------------- The error above I also get when I simply type "automake". I currently suspect some 32 bit vs. 64 bit problem, as the machine I'm compiling things on (2x Dual-Core AMD Opteron Processor 2220 SE) can run in either 32 or 64 bit mode. uname outputs: "2.6.16.29.2.amd64-smp" Any (other) ideas? Should I post some other debug information? The output of "configure" is posted below. The other packages of (Monet DB Common etc.) run through smoothly. THANKS! Ingmar ------------- output of "configure" for MonetDB4-XQuery/pathfinder ----- iweber@dork:/scratch/KM/ir-scratch/ingmar/MonetDB-SuperBall/MonetDB-Venus-SuperBall-SR1/MonetDB4-XQuery/pathfinder [10083] ./configure --prefix='/scratch/KM/ir-scratch/ingmar/MonetDB-SuperBall/installation/' --enable-optimize --disable-debug --with-libxml2=/amd64/usr checking build system type... x86_64-unknown-linux-gnu checking host system type... x86_64-unknown-linux-gnu checking target system type... x86_64-unknown-linux-gnu checking for a BSD-compatible install... /amd64/usr/bin//install -c checking whether build environment is sane... yes checking for gawk... /usr/bin/gawk checking whether make sets $(MAKE)... yes checking for monetdb-config... /scratch/KM/ir-scratch/ingmar/MonetDB-SuperBall/installation/bin/monetdb-config checking whether MonetDB Common version 1.16.2 or newer is installed... yes: found version 1.16.2 checking for style of include used by make... GNU checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ANSI C... none needed checking dependency style of gcc... none checking for egrep... grep -E checking for ANSI C header files... no checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking how to run the C preprocessor... gcc -E checking for gcc... (cached) gcc checking whether we are using the GNU C compiler... (cached) yes checking whether gcc accepts -g... (cached) yes checking for gcc option to accept ANSI C... (cached) none needed checking dependency style of gcc... (cached) none checking for long... yes checking size of long... 8 checking whether byte ordering is bigendian... no checking which Linux distribution we're using... Debian3.1 checking if your compiler is C99 compliant... yes checking for ant... no checking for java... no checking for javac... no checking for jar... no checking for javadoc... no checking for monetdb4-config... /scratch/KM/ir-scratch/ingmar/MonetDB-SuperBall/installation/bin/monetdb4-config checking whether MonetDB4 version 4.16.2 or newer is installed... yes: found version 4.16.2 checking for monetdb-clients-config... /scratch/KM/ir-scratch/ingmar/MonetDB-SuperBall/installation/bin/monetdb-clients-config checking whether MonetDB Clients version 1.16.2 or newer is installed... yes: found version 1.16.2 checking for a sed that does not truncate output... /amd64/bin//sed checking for option to reload object files... -r checking for BSD-compatible nm... /amd64/usr/bin//nm -B checking whether ln -s works... yes checking how to recognise dependent libraries... pass_all checking dlfcn.h usability... yes checking dlfcn.h presence... yes checking for dlfcn.h... yes checking for g++... g++ checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking dependency style of g++... none checking how to run the C++ preprocessor... g++ -E checking for g77... no checking for f77... no checking for xlf... no checking for frt... no checking for pgf77... no checking for fort77... no checking for fl32... no checking for af77... no checking for f90... no checking for xlf90... no checking for pgf90... no checking for epcf90... no checking for f95... no checking for fort... no checking for xlf95... no checking for ifc... no checking for efc... no checking for pgf95... no checking for lf95... no checking for gfortran... no checking whether we are using the GNU Fortran 77 compiler... no checking whether accepts -g... no checking for flex... no checking for lex... no checking for yywrap in -lfl... no checking for yywrap in -ll... no checking for a BSD-compatible install... /amd64/usr/bin//install -c checking for ld used by gcc... ld -IPA -m elf_x86_64 checking if the linker (ld -IPA -m elf_x86_64) is GNU ld... yes checking the maximum length of command line arguments... 32768 checking command to parse /amd64/usr/bin//nm -B output from gcc object... ok checking for objdir... .libs checking for ar... ar checking for ranlib... ranlib checking for strip... strip checking if gcc static flag works... yes checking if gcc supports -fno-rtti -fno-exceptions... no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc supports -c -o file.o... yes checking whether the gcc linker (ld -IPA -m elf_x86_64) supports shared libraries... yes checking whether -lc should be explicitly linked in... no checking dynamic linker characteristics... GNU/Linux ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... no configure: creating libtool appending configuration tag "CXX" to libtool checking for ld used by g++... ld -IPA -m elf_x86_64 checking if the linker (ld -IPA -m elf_x86_64) is GNU ld... yes checking whether the g++ linker (ld -IPA -m elf_x86_64) supports shared libraries... yes checking for g++ option to produce PIC... -fPIC checking if g++ PIC flag -fPIC works... yes checking if g++ supports -c -o file.o... yes checking whether the g++ linker (ld -IPA -m elf_x86_64) supports shared libraries... yes checking dynamic linker characteristics... GNU/Linux ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes appending configuration tag "F77" to libtool checking for ANSI C header files... (cached) no checking whether time.h and sys/time.h may both be included... yes checking for dirent.h that defines DIR... yes checking for library containing opendir... none required checking alloca.h usability... yes checking alloca.h presence... yes checking for alloca.h... yes checking getopt.h usability... yes checking getopt.h presence... yes checking for getopt.h... yes checking netdb.h usability... yes checking netdb.h presence... yes checking for netdb.h... yes checking for sys/types.h... (cached) yes checking for special C compiler options needed for large files... no checking for _FILE_OFFSET_BITS value needed for large files... no checking for _LARGE_FILES value needed for large files... no checking for an ANSI C-conforming const... yes checking for size_t... yes checking return type of signal handlers... void checking for ptrdiff_t... yes checking for ssize_t... yes checking for __int64... no checking for long long... yes checking for char... yes checking size of char... 1 checking for short... yes checking size of short... 2 checking for int... yes checking size of int... 4 checking for long... (cached) yes checking size of long... (cached) 8 checking for void *... yes checking size of void *... 8 checking for size_t... (cached) yes checking size of size_t... 8 checking for ssize_t... (cached) yes checking size of ssize_t... 8 checking for ptrdiff_t... (cached) yes checking size of ptrdiff_t... 8 checking for long long... (cached) yes checking size of long long... 8 checking for __int64... (cached) no checking size of __int64... 0 checking for ftruncate... yes checking for gettimeofday... yes checking for opendir... yes checking whether ln -s works... yes checking for rm... rm -f checking for mv... mv -f checking for lockfile... echo checking for bash... /bin/sh checking for rpmbuild... no checking for rpm... no checking for an ANSI C-conforming const... (cached) yes checking for inline... inline checking for python... no checking for perl... /amd64/usr/bin//perl checking for objc... no checking pthread.h usability... yes checking pthread.h presence... yes checking for pthread.h... yes checking semaphore.h usability... yes checking semaphore.h presence... yes checking for semaphore.h... yes checking sched.h usability... yes checking sched.h presence... yes checking for sched.h... yes checking for sem_init in -lpthreadGC2... no checking for sem_init in -lpthreadGC1... no checking for sem_init in -lpthreadGC... no checking for sem_init in -lpthread... yes checking for pthread_sigmask in -lpthread... yes checking for pthread_kill_other_threads_np in -lpthread... no checking readline/readline.h usability... yes checking readline/readline.h presence... yes checking for readline/readline.h... yes checking for readline in -lreadline... yes checking for rl_completion_matches in -lreadline... yes checking for SSL_read in -lssl... no checking for ERR_get_error in -lcrypto... no checking for dlopen in -ldl... yes checking for malloc in -lmalloc... no checking for mallopt... yes checking for mallinfo... yes checking for gethostbyname_r... yes checking for setsockopt... yes checking for SOCKET... no checking for socklen_t... yes checking for libz... auto checking for libbz2... auto checking for getopt_long... yes checking libperfctr.h usability... no checking libperfctr.h presence... no checking for libperfctr.h... no checking libpperf.h usability... no checking libpperf.h presence... no checking for libpperf.h... no checking pcl.h usability... no checking pcl.h presence... no checking for pcl.h... no checking for pcre-config... no pcre-config not found; please use --with-pcre=<path> checking for pcre >= 4.5... no (without pcre-config to query the pcre version, we assume it's < 4.5) checking regex.h usability... yes checking regex.h presence... yes checking for regex.h... yes checking locale.h usability... yes checking locale.h presence... yes checking for locale.h... yes checking langinfo.h usability... yes checking langinfo.h presence... yes checking for langinfo.h... yes checking for nl_langinfo... yes checking for setlocale... yes checking iconv.h usability... yes checking iconv.h presence... yes checking for iconv.h... yes checking for iconv_t... yes checking for iconv in -liconv... no checking for libiconv in -liconv... no checking for iconv... yes checking for texi2html... no checking for latex2html... no checking for latex... no checking for pdflatex... no checking for dvips... no checking for fig2dev... no checking postscript option... eps checking /amd64/usr/bin//install -c --backup option... --backup=nil checking for php-config... no Cannot find php-config. Please use --with-php-config=PATH no checking for monetdb5-config... no checking whether gcc and cc understand -c and -o together... yes checking for unistd.h... (cached) yes checking for getopt.h... (cached) yes checking for getopt_long... (cached) yes checking stdbool.h usability... yes checking stdbool.h presence... yes checking for stdbool.h... yes checking for bool... no checking for stdint.h... (cached) yes checking for socklen_t... (cached) yes checking libgen.h usability... yes checking libgen.h presence... yes checking for libgen.h... yes checking for basename... yes checking for int... (cached) yes checking size of int... (cached) 4 checking for void *... (cached) yes checking size of void *... (cached) 8 checking if your compiler understands `__attribute__'... yes checking signal.h usability... yes checking signal.h presence... yes checking for signal.h... yes checking return type of signal handlers... (cached) void checking for strings.h... (cached) yes checking for strcasecmp... yes checking for xml2-config.64... no checking for xml2-64-config... no checking for xml2-config... /amd64/usr/bin/xml2-config checking for libxml/parser.h... yes checking for xmlParseDocument in -lxml2... yes checking libxml/SAX2.h usability... yes checking libxml/SAX2.h presence... yes checking for libxml/SAX2.h... yes configure: The following compiler options will be used to integrate the libxml2 XML parsing library: To find the libxml2 include files: -I/usr/include/libxml2 To find the libxml2 library: -L/amd64/usr/lib64 -L/usr/lib -lxml2 -lz -lpthread -lm SAX2 support: HAVE_SAX2=1 checking for string.h... (cached) yes checking for strdup... yes checking for strtok_r... yes checking time.h usability... yes checking time.h presence... yes checking for time.h... yes checking sys/time.h usability... yes checking sys/time.h presence... yes checking for sys/time.h... yes checking utime.h usability... yes checking utime.h presence... yes checking for utime.h... yes checking sys/utime.h usability... no checking sys/utime.h presence... no checking for sys/utime.h... no checking sys/times.h usability... yes checking sys/times.h presence... yes checking for sys/times.h... yes checking whether time.h and sys/time.h may both be included... (cached) yes checking whether struct tm is in sys/time.h or time.h... time.h checking for struct tm.tm_zone... no checking for tzname... yes checking whether utime accepts a null argument... yes checking for ftime... yes checking for times... yes checking for ctime_r... yes checking for localtime_r... yes checking ctime_r3... no configure: creating ./config.status config.status: creating Makefile config.status: creating MonetDB-XQuery.spec config.status: creating RunMapprove config.status: creating RunMapprove.bat config.status: creating RunMtest config.status: creating RunMtest.bat config.status: creating extra.mk config.status: creating rpm.mk config.status: creating compiler/Makefile config.status: creating conf/Makefile config.status: creating modules/Makefile config.status: creating runtime/Makefile config.status: creating runtime5/Makefile config.status: creating src/Makefile config.status: creating compiler/algebra/Makefile config.status: creating compiler/core/Makefile config.status: creating compiler/debug/Makefile config.status: creating compiler/include/Makefile config.status: creating compiler/mem/Makefile config.status: creating compiler/mil/Makefile config.status: creating compiler/parser/Makefile config.status: creating compiler/schema/Makefile config.status: creating compiler/semantics/Makefile config.status: creating compiler/sql/Makefile config.status: creating modules/pftijah/Makefile config.status: creating runtime/xrpc/Makefile config.status: creating src/tools/Makefile config.status: creating compiler/algebra/map/Makefile config.status: creating compiler/algebra/opt/Makefile config.status: creating compiler/algebra/prop/Makefile config.status: creating runtime/xrpc/admin/Makefile config.status: creating runtime/xrpc/export/Makefile config.status: creating pf_config.h config.status: pf_config.h is unchanged config.status: executing depfiles commands

2 1

[MonetDB-users] MonetDB Release Preparation
by Martin Kersten 29 May '07

29 May '07

Dear fellow MonetDB developers/users, we plan to have a new release of the MonetDB software family within the next two weeks, i.e., Feature Freeze: Friday Jun 01 2007 Release: Monday Jun 11 2007 This release cycle is used to reduce the component dependencies, such that we are better prepared to release individual components more frequently. A synopsis of what to expect: MonetDB 5 beta status is dropped and it becomes the sole back-end for the SQL front-end. SQL now supports Persistent Stored Modules. XQuery Update Facility has undergone a large series of stress tests to improve correctness, performance and robustness against concurrent updates. Many bug-fixes based on highly appreciated feedback from our user community. The priorities set for post-release actions as agreed upon by the development team are: shortterm:(summer) SQL GIS geometry model testing and release SQL/XML support development and release PF/SQL exploration (research focus) Skyserver demo website (target 2.7TB online demo) midterm: (fall) Remote SQL execution in a cluster setting SQL adaptive partitioning of large databases XQuery Algebra -> MIL compiler Date/time support in XQuery MonetDB Private BATs policy (kernel modification) lngterm: (fall/spring) XQuery Algebra -> MAL compiler public release of StreetTivo for collaborative media analysis Of course, as always, progress in each of these areas depend on availability of resources and their contribution to our research agenda. We are looking forward to messages from projects based on/exploitation of the MonetDB platform. We plan to add a section in the website to make this work more broadly visible. regards, Martin

1 0

Re: [MonetDB-users] Compile problems (CVS, Ubuntu 7.04) (Java Client JDBC Version)
by Ramon Nogueira 27 May '07

27 May '07

OK, actually going to use CVS, since that's probably easier. Just a point about compiling the Java client (which as far as I can tell, is required for install MonetDB4-server): it doesn't compile with the version of JDBC shipped in Sun JDK 6. Basically, the JDBC interfaces have been extended and so we get errors about 'class is not abstract and does not override method ...'. I fixed this the first time by adding stubs that just threw OperationNotSupportedException. Then it compiled. R. On 5/27/07, Ramon Nogueira <ramon.nogueira(a)gmail.com> wrote: > Hehe, ok I can't resist. Gonna try again with the install script and > the tricks to prevent downloading again and again. I have clean all > traces of MonetDB from my machine. If you can't provide a .deb, what > about a precompiled set of binaries for generic Linux, statically > linked with all dependencies. Its not pretty, but it would be easy for > the users. The problem with the rpms on my Ubuntu system is basically > that Debian uses a different versioning scheme for the shared > libraries (the ones I had problems with were libssl and libcrypto). > Couldn't you just statically link these in and then provide a simple > install script? Many, many people use Debian-based systems and it > would greatly improve coverage for MonetDB. I will do what I can to > help if this compile goes well. > > R. > > On 5/26/07, Stefan Manegold <Stefan.Manegold(a)cwi.nl> wrote: > > Ramon, > > > > once you have time and bandwidth, could you please first remove any remains > > of MonetDB (sources, builddirs, anything installed in you chosen prefix of > > buildtools, MonetDB, clinerts, MonetDB4, pathfinder, etc.), > > and then try from scratch, again, the way you prefer to install MonetDB. > > Stop as soon as the first problem occurs (if any ;-)) and report it here. > > > > Unfortunaltely, we do not have (access to) any Debian and/or Ubuntu > > (anymore), hence, we cannot provide any .deb packages. > > > > Kind regards, > > > > Stefan > > > > > > On Sat, May 26, 2007 at 10:24:55AM +0200, Ramon Nogueira wrote: > > > Yup, first I tried installing from the "Super Source Tarball"; then > > > from `alien'ed rpm; then individual tarballs; the install script; then > > > CVS! The problem with the install script is that it downloads things > > > afresh each time and I really can't afford that (I am in South Africa > > > where unfortunately, we still need to think about bandwidth). Here is > > > the (different) error I get when I try to compile the pathfinder > > > source tarball from sourceforge (against CVS components): > > > > > > gcc -DHAVE_CONFIG_H -I. -I. -I.. -I. -I/usr/local/include/MonetDB > > > -I/usr/local/include/MonetDB/common -I/usr/local/include/MonetDB/gdk > > > -I/usr/local/include/MonetDB4 -I/usr/local/include/MonetDB4/monet > > > -I/usr/local/include/MonetDB4/plain > > > -I/usr/local/include/MonetDB4/contrib > > > -I/usr/local/include/MonetDB4/mapi > > > -I/usr/local/include/MonetDB4/calibrator -I/usr/include/libxml2 > > > -I../compiler/include -I./../compiler/include -DLIBPATHFINDER -O2 > > > -std=c99 -O6 -fomit-frame-pointer -finline-functions -falign-loops=4 > > > -falign-jumps=4 -falign-functions=4 -fexpensive-optimizations > > > -funroll-loops -frerun-cse-after-loop -frerun-loop-opt > > > -Wno-declaration-after-statement -DEMBEDDED -DMT -DNO_CGI -DNO_AUTH > > > -DIO_MAX=10240 -c pathfinder.c -fPIC -DPIC -o > > > .libs/lib_pathfinder_la-pathfinder.o > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx: > > > In function 'xquery_function_call': > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:3980: > > > error: expected ')' before 'LLFMT' > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5417:34: > > > error: macro "MT_init_lock" requires 2 arguments, but only 1 given > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx: > > > In function 'xquery_prelude': > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5417: > > > error: 'MT_init_lock' undeclared (first use in this function) > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5417: > > > error: (Each undeclared identifier is reported only once > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5417: > > > error: for each function it appears in.) > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5418:32: > > > error: macro "MT_init_lock" requires 2 arguments, but only 1 given > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5419:31: > > > error: macro "MT_init_lock" requires 2 arguments, but only 1 given > > > make[4]: *** [lib_pathfinder_la-pathfinder.lo] Error 1 > > > make[4]: Leaving directory > > > `/home/ramon/software/monetdb/pathfinder-0.16.2/runtime' > > > make[3]: *** [all-recursive] Error 1 > > > make[3]: Leaving directory > > > `/home/ramon/software/monetdb/pathfinder-0.16.2/runtime' > > > make[2]: *** [all] Error 2 > > > make[2]: Leaving directory > > > `/home/ramon/software/monetdb/pathfinder-0.16.2/runtime' > > > make[1]: *** [all-recursive] Error 1 > > > make[1]: Leaving directory `/home/ramon/software/monetdb/pathfinder-0.16.2' > > > make: *** [all] Error 2 > > > > > > > > > On 5/26/07, Stefan Manegold <Stefan.Manegold(a)cwi.nl> wrote: > > > > Hi Ramon, > > > > > > > > On Sat, May 26, 2007 at 08:37:26AM +0200, Ramon Nogueira wrote: > > > > > Thanks for such a rapid response! > > > > > > > > welcome --- you were just "lucky" ;-) > > > > > > > > > I checked out the source from CVS (including buildtools, I forgot to > > > > > mention that) with the following command: > > > > > cvs -d:pserver:anonymous@monetdb.cvs.sourceforge.net:/cvsroot/monetdb > > > > > checkout (buildtools|MonetDB|MonetDB4|pathfinder}. > > > > > > > > looks good (well, I'm sure you also included clients, as you mentioned in > > > > your first email). > > > > > > > > > I'm not too savvy wrt CVS, so not sure if this represents the latest code. > > > > > > > > It is --- well, provided SourceForge does not run the anonymous pserver > > > > access on backup server that run behind (again), but even then the > > > > conpilation should work fine ... > > > > > > > > > For calling configure, I did not specify any other command line > > > > > parameters (just ./configure). I created separate build directories > > > > > build/MonetDB, build/pathfinder... and issued the ./configure and make > > > > > commands in those directories after doing ./bootstrap in the source > > > > > directories. I also tries following the instructions in the file > > > > > pathfinder/INSTALL which instructed me to do the configure/make in the > > > > > same directory as the source with the same error. > > > > > > > > sounds just right --- hence, I'm puzzled; I have no idea, yet(?), what > > > > causes this problem (i.e., where the bogus path > > > > /export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/ > > > > come from... > > > > > > > > Do you by any chance have a previous source (CVS or tarball) or binary (RPM) > > > > installation of MonetDB on your machine? Possibly even the remains of an > > > > uncomplete/aborted/failed RPM installation? > > > > > > > > Stefan > > > > > > > > > > > > > On 5/26/07, Stefan Manegold <Stefan.Manegold(a)cwi.nl> wrote: > > > > > > Hi Ramon, > > > > > > > > > > > > thank you very much for using MonetDB, and sorry for the inconvenience with > > > > > > compiling pathfinder. > > > > > > > > > > > > The error looks indeed strange. Actually it make me wonder whether you > > > > > > indeed (try to) compile the CVS code base (and if so which one, the latest > > > > > > HEAD or some release branch?) or whether you are using the source tarballs? > > > > > > Of course, `bootstrap` is only required for the CVS version, but you do not > > > > > > mention buildtools, which is also required (only) for the CVS version. > > > > > > The requested but not found path > > > > > > (/export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/lib/libbat.la) > > > > > > is (as far as I can see) not contained in our CVS source base (except from > > > > > > some testing stable output), but *might* be in the source tarballs (though > > > > > > it should be ignored there. > > > > > > > > > > > > To analyse the problem further could you please send us the complete > > > > > > commandlines of you `configure` call for buildtools, MonetDB, clients, > > > > > > MonetDB4 & pathfinder? > > > > > > > > > > > > Kind regards > > > > > > > > > > > > Stefan > > > > > > > > > > > > > > > > > > On Sat, May 26, 2007 at 07:58:05AM +0200, Ramon Nogueira wrote: > > > > > > > Hi, > > > > > > > > > > > > > > Trying to install MonetDB4 and pathfinder from CVS. I succeeded in > > > > > > > compiling and installing (into /usr/local) MonetDB, client and > > > > > > > MonetDB4 modules. `bootstrap' and `configure' both succeed from > > > > > > > pathfinder, but `make' produces the following error. Also, on another > > > > > > > note, I think it should be made clearer that installation of `client' > > > > > > > is a prerequisite for MonetDB4 server since this is quite a > > > > > > > counterintuitive order of dependency (server on client). I am on Linux > > > > > > > 2.6.20-15-generic i686 GNU/Linux. > > > > > > > > > > > > > > Output from `make': > > > > > > > --------------------------------------------------------------------------- > > > > > > > (cd .libs && rm -f libpf.la && ln -s ../libpf.la libpf.la) > > > > > > > /bin/bash ../libtool --tag=CC --mode=link gcc -DLIBPF_SUPPORT -g > > > > > > > -O2 -Wall -Wextra -std=c99 -Werror-implicit-function-declaration > > > > > > > -Werror -Wpointer-arith -Wdeclaration-after-statement > > > > > > > -Wno-declaration-after-statement -DEMBEDDED -DMT -DNO_CGI -DNO_AUTH > > > > > > > -DIO_MAX=10240 -o lib_pf_support.la -rpath > > > > > > > /usr/local/lib/MonetDB4/lib lib_pf_support_la-pf_support.glue.lo > > > > > > > lib_pf_support_la-pf_support.lo lib_pf_support_la-staircasejoin.lo > > > > > > > lib_pf_support_la-prec_foll.lo lib_pf_support_la-shredder.lo > > > > > > > libserialize.la libpf.la -lxml2 -L/usr/lib -lxml2 -ldl > > > > > > > -L/usr/local/lib -lbat -lstream -L/usr/local/lib -lmonet -lpthread > > > > > > > -L/usr/local/lib/MonetDB4/lib -l_lock -l_monettime -l_streams > > > > > > > -l_builtin -l_ascii_io -l_algebra -l_constant > > > > > > > gcc -shared .libs/lib_pf_support_la-pf_support.glue.o > > > > > > > .libs/lib_pf_support_la-pf_support.o > > > > > > > .libs/lib_pf_support_la-staircasejoin.o > > > > > > > .libs/lib_pf_support_la-prec_foll.o .libs/lib_pf_support_la-shredder.o > > > > > > > -Wl,--whole-archive ./.libs/libserialize.a ./.libs/libpf.a > > > > > > > -Wl,--no-whole-archive -Wl,--rpath -Wl,/usr/local/lib/MonetDB4/lib > > > > > > > -Wl,--rpath -Wl,/usr/local/lib/MonetDB4/lib -L/usr/lib > > > > > > > /usr/lib/libxml2.so -ldl -L/usr/local/lib /usr/lib/libbat.so > > > > > > > /usr/lib/libstream.so /usr/lib/libmonet.so -lpthread > > > > > > > -L/usr/local/lib/MonetDB4/lib /usr/local/lib/MonetDB4/lib/lib_lock.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_monettime.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_streams.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_builtin.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_ascii_io.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_algebra.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_constant.so -Wl,-soname > > > > > > > -Wl,lib_pf_support.so.0 -o .libs/lib_pf_support.so.0.0.0 > > > > > > > (cd .libs && rm -f lib_pf_support.so.0 && ln -s > > > > > > > lib_pf_support.so.0.0.0 lib_pf_support.so.0) > > > > > > > (cd .libs && rm -f lib_pf_support.so && ln -s lib_pf_support.so.0.0.0 > > > > > > > lib_pf_support.so) > > > > > > > creating lib_pf_support.la > > > > > > > /bin/sed: can't read > > > > > > > /export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/lib/libbat.la: > > > > > > > No such file or directory > > > > > > > libtool: link: `/export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/lib/libbat.la' > > > > > > > is not a valid libtool archive > > > > > > > make[2]: *** [lib_pf_support.la] Error 1 > > > > > > > make[2]: *** Deleting file `lib_pf_support.la' > > > > > > > make[2]: Leaving directory `/home/ramon/software/monetdb/cvs/pathfinder/runtime' > > > > > > > make[1]: *** [all-recursive] Error 1 > > > > > > > make[1]: Leaving directory `/home/ramon/software/monetdb/cvs/pathfinder' > > > > > > > make: *** [all] Error 2 > > > > > > > > > > > > > > ----------------------------------------------------------------------------- > > > > > > > > > > > > > > Your help is greatly appreciated. > > > > > > > > > > > > > > Ramon Nogueira > > > > > > > > > > > > > > ------------------------------------------------------------------------- > > > > > > > This SF.net email is sponsored by DB2 Express > > > > > > > Download DB2 Express C - the FREE version of DB2 express and take > > > > > > > control of your XML. No limits. Just data. Click to get it now. > > > > > > > http://sourceforge.net/powerbar/db2/ > > > > > > > _______________________________________________ > > > > > > > MonetDB-users mailing list > > > > > > > MonetDB-users(a)lists.sourceforge.net > > > > > > > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | > > > > > > | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | > > > > > > | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | > > > > > > | The Netherlands | Fax : +31 (20) 592-4312 | > > > > > > > > > > > > > > > > ------------------------------------------------------------------------- > > > > > This SF.net email is sponsored by DB2 Express > > > > > Download DB2 Express C - the FREE version of DB2 express and take > > > > > control of your XML. No limits. Just data. Click to get it now. > > > > > http://sourceforge.net/powerbar/db2/ > > > > > _______________________________________________ > > > > > MonetDB-users mailing list > > > > > MonetDB-users(a)lists.sourceforge.net > > > > > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > > > > > > > > > > > > > > > > > -- > > > > | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | > > > > | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | > > > > | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | > > > > | The Netherlands | Fax : +31 (20) 592-4312 | > > > > > > > > > > ------------------------------------------------------------------------- > > > This SF.net email is sponsored by DB2 Express > > > Download DB2 Express C - the FREE version of DB2 express and take > > > control of your XML. No limits. Just data. Click to get it now. > > > http://sourceforge.net/powerbar/db2/ > > > _______________________________________________ > > > MonetDB-users mailing list > > > MonetDB-users(a)lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > > > > > > -- > > | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | > > | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | > > | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | > > | The Netherlands | Fax : +31 (20) 592-4312 | > > >

2 3

[MonetDB-users] Compile problems (CVS, Ubuntu 7.04)
by Ramon Nogueira 27 May '07

27 May '07

Hi, Trying to install MonetDB4 and pathfinder from CVS. I succeeded in compiling and installing (into /usr/local) MonetDB, client and MonetDB4 modules. `bootstrap' and `configure' both succeed from pathfinder, but `make' produces the following error. Also, on another note, I think it should be made clearer that installation of `client' is a prerequisite for MonetDB4 server since this is quite a counterintuitive order of dependency (server on client). I am on Linux 2.6.20-15-generic i686 GNU/Linux. Output from `make': --------------------------------------------------------------------------- (cd .libs && rm -f libpf.la && ln -s ../libpf.la libpf.la) /bin/bash ../libtool --tag=CC --mode=link gcc -DLIBPF_SUPPORT -g -O2 -Wall -Wextra -std=c99 -Werror-implicit-function-declaration -Werror -Wpointer-arith -Wdeclaration-after-statement -Wno-declaration-after-statement -DEMBEDDED -DMT -DNO_CGI -DNO_AUTH -DIO_MAX=10240 -o lib_pf_support.la -rpath /usr/local/lib/MonetDB4/lib lib_pf_support_la-pf_support.glue.lo lib_pf_support_la-pf_support.lo lib_pf_support_la-staircasejoin.lo lib_pf_support_la-prec_foll.lo lib_pf_support_la-shredder.lo libserialize.la libpf.la -lxml2 -L/usr/lib -lxml2 -ldl -L/usr/local/lib -lbat -lstream -L/usr/local/lib -lmonet -lpthread -L/usr/local/lib/MonetDB4/lib -l_lock -l_monettime -l_streams -l_builtin -l_ascii_io -l_algebra -l_constant gcc -shared .libs/lib_pf_support_la-pf_support.glue.o .libs/lib_pf_support_la-pf_support.o .libs/lib_pf_support_la-staircasejoin.o .libs/lib_pf_support_la-prec_foll.o .libs/lib_pf_support_la-shredder.o -Wl,--whole-archive ./.libs/libserialize.a ./.libs/libpf.a -Wl,--no-whole-archive -Wl,--rpath -Wl,/usr/local/lib/MonetDB4/lib -Wl,--rpath -Wl,/usr/local/lib/MonetDB4/lib -L/usr/lib /usr/lib/libxml2.so -ldl -L/usr/local/lib /usr/lib/libbat.so /usr/lib/libstream.so /usr/lib/libmonet.so -lpthread -L/usr/local/lib/MonetDB4/lib /usr/local/lib/MonetDB4/lib/lib_lock.so /usr/local/lib/MonetDB4/lib/lib_monettime.so /usr/local/lib/MonetDB4/lib/lib_streams.so /usr/local/lib/MonetDB4/lib/lib_builtin.so /usr/local/lib/MonetDB4/lib/lib_ascii_io.so /usr/local/lib/MonetDB4/lib/lib_algebra.so /usr/local/lib/MonetDB4/lib/lib_constant.so -Wl,-soname -Wl,lib_pf_support.so.0 -o .libs/lib_pf_support.so.0.0.0 (cd .libs && rm -f lib_pf_support.so.0 && ln -s lib_pf_support.so.0.0.0 lib_pf_support.so.0) (cd .libs && rm -f lib_pf_support.so && ln -s lib_pf_support.so.0.0.0 lib_pf_support.so) creating lib_pf_support.la /bin/sed: can't read /export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/lib/libbat.la: No such file or directory libtool: link: `/export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/lib/libbat.la' is not a valid libtool archive make[2]: *** [lib_pf_support.la] Error 1 make[2]: *** Deleting file `lib_pf_support.la' make[2]: Leaving directory `/home/ramon/software/monetdb/cvs/pathfinder/runtime' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/ramon/software/monetdb/cvs/pathfinder' make: *** [all] Error 2 ----------------------------------------------------------------------------- Your help is greatly appreciated. Ramon Nogueira

4 11

[MonetDB-users] MonetDB shows error after graceful stop
by Venks 25 May '07

25 May '07

Hi, I am using the following commands to START and STOP the MonetDB database. monetdb --start --dbname=test --dbinit='include sql;' monetbd --stop After I STOP the monetdb server I am getting the following messages in my console. Sometimes these messages repeat few times. ========================================================= /root/MonetDB070524/bin/mguardian: line 131: [: /dev/mapper/VolGroup00-LogVol00 43: integer expression expected /root/MonetDB070524/bin/mguardian: line 195: mserver5: command not found ========================================================== What are these messages? Do they represent an error in my set up? Or is this a some bug in MonetDB? Please look into it. Thanks, - Venks

3 2

[MonetDB-users] monetdb-install.sh not working
by Venks 25 May '07

25 May '07

Folks, I tried to executed the all-in-one script "monetdb-install.sh" and it's not working. I installed it last week few times without any error. Please look into this issue. Thanks, PS: Below is the excerpt from the log file. ======================================================= Connecting to www.ins.cwi.nl[192.16.196.21]:80... connected. HTTP request sent, awaiting response... Please refer to the full log at /var/tmp/MonetDB-1179870979/log If you believe this is an error in the script or the software, Tue May 22 17:56:20 EDT 2007 The following tools might be relevant to debug your problem: : 1.12 $ 403 Forbidden 17:56:20 ERROR 403: Forbidden. fetching http://www.ins.cwi.nl/~fabian/monetdb/tars/latest/current/MonetDB.tar.gz failed! file a bug and attach the logfile. autoconf (GNU Autoconf) 2.59 Written by David J. MacKenzie and Akim Demaille. =======================================================

6 10

Re: [MonetDB-users] Unable to connect to MonetDB
by Colin Foss 25 May '07

25 May '07

Venks, That is a good question and I didn't send the resolution to the general list. The strange behavior was that local connections were ok and remote connections would block all subsequent connections (local or remote) until I killed the remote MapiClient. I think there is something wrong with the "release" version when compiled from the script. After I used --nightly=stable or --nightly=current I was able to connect. I had mapi_open=true with all three versions. I was going to recompile with --nightly=current today, now that all is well again with www.ins.cwi.nl and I'll let you know my results. ~~>Colin --- Venks <venkatesh.mantha(a)gmail.com> wrote: > Colin, > > Was your issue regarding connecting from other > clients > (mapi_open=true) resolved? > > I installed the latest build this morning and now I > am unable to > connect from other clients. > > Thanks, > > - Venks >

1 0

[MonetDB-users] MonetDb-XQuery problem
by Maarten Clements 25 May '07

25 May '07

Using the following XQuery in MonetDb (WinXP) crashes on large documents (when C1 and C2 are small it works ok): > <col> { > for $b in doc("C1.xml")/collection/doc > for $top in doc("C2.xml")/collection/doc > where ($b/year > 1950) and ($b/title = $top/title) > return > <movie> > {$b/year} > </movie> > } </col> If I remove one of the two conditions it works perfectly, e.g.: > <col> { > for $b in doc("C1.xml")/collection/doc > for $top in doc("C2.xml")/collection/doc > where ($b/title = $top/title) > return > <movie> > {$b/year} > </movie> > } </col> Can anyone explain this problem? ______________________________ Maarten Clements

3 5

[MonetDB-users] copy into with primary key errors
by Colin Foss 24 May '07

24 May '07

I've been trying to bulk load a large set of data into a table with a compound primary key. Every time the copy into fails on the second file with an error about an "invalid input type". Even if I comment out the suspect file, the third file with have the same error. If I repeat the load and comment out the first file, then the third file will have the "invalid input type" error. Has anyone been able to use COPY INTO with a compound primary key and multiple files?

1 1

[MonetDB-users] Cannot connect to MonetDB via ODBC from PowerBuilder
by Franco Guidoli 24 May '07

24 May '07

Hi all: I'm trying to connect to MonetDB via ODBC from PowerBuilder, but during connection it gets into a "loop" (that's what I think after viewing the ODBC driver log which I'm sending now). Thanks in advance. Franco http://www.nabble.com/file/p10774553/odbcdebug.log odbcdebug.log -- View this message in context: http://www.nabble.com/Cannot-connect-to-MonetDB-via-ODBC-from-PowerBuilder-… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] latest build startup error
by Colin Foss 23 May '07

23 May '07

After building with "monetdb-install.sh --enable-sql", The default .mserver5.dbinit contains: include sql;sql.start(); the "sql.start();" command triggers an error found in mserver5.log in the dbfarm. == mserver5.log: START 2007-05-17 08:13:02 #include sql; sql.start(); # function user.main():void; # 0 (main:void) #command startQuery(s:str):void # 1 (_1:str) #address SQLstartQuery # 2 (_2:str) #comment "Initialize tracing query performance"; # 3 (_3:str) #command exitQuery(s:str):void # 4 (_4:str) #address SQLexitQuery # 5 (_5:str) #comment "Finalize tracing query performance"; # 6 (_6:str) #command dec_round( v:sht, r:dbl ) :sht # 7 (_7:str) #address sht_dbl_dec_round_wrap # 8 (_8:str) #comment "round off the value v to nearests multiple of r"; # 9 (_9:str) #command dec_round( v:sht, r:int ) :sht # 10 (_10:str) #address sht_int_dec_round_wrap # 11 (_11:str) #comment "round off the value v to nearests multiple of r"; # 12 (_9:str) #command dec_round( v:int, r:dbl ) :int # 13 (_12:str) #address int_dbl_dec_round_wrap # 14 (_13:str) #comment "round off the value v to nearests multiple of r"; # 15 (_9:str) #command dec_round( v:int, r:int ) :int # 16 (_14:str) #address int_int_dec_round_wrap # 17 (_15:str) #comment "round off the value v to nearests multiple of r"; # 18 (_9:str) #command dec_round( v:lng, r:dbl ) :lng # 19 (_16:str) #address lng_dbl_dec_round_wrap # 20 (_17:str) #comment "round off the value v to nearests multiple of r"; # 21 (_9:str) #command dec_round( v:lng, r:int ) :lng # 22 (_18:str) #address lng_int_dec_round_wrap # 23 (_19:str) #comment "round off the value v to nearests multiple of r"; # 24 (_9:str) #command dec_round( v:flt, r:int ) :flt # 25 (_20:str) #address flt_int_dec_round_wrap # 26 (_21:str) #comment "round off the value v to nearests multiple of r"; # 27 (_9:str) #command dec_round( v:dbl, r:int ) :dbl # 28 (_22:str) #address dbl_int_dec_round_wrap # 29 (_23:str) #comment "round off the value v to nearests multiple of r"; # 30 (_9:str) #address CALCstr2sht # 31 (_24:str) #command calc.str( v:sht ) :str # 32 (_25:str) #address CALCsht2str # 33 (_26:str) #comment "Cast sht to str"; # 34 (_27:str) #address CALCstr2int # 35 (_28:str) #command calc.str( v:int ) :str # 36 (_29:str) #address CALCint2str # 37 (_30:str) #comment "Cast int to str"; # 38 (_31:str) #address CALCstr2lng # 39 (_32:str) #command calc.str( v:lng ) :str # 40 (_33:str) #address CALClng2str # 41 (_34:str) #comment "Cast lng to str"; # 42 (_35:str) #command calc.str( v:any_1, digits:int ) :str # 43 (_36:str) #address CALCflt2sht # 44 (_37:str) #address CALCflt2int # 45 (_38:str) #address CALCflt2lng # 46 (_39:str) #address CALCdbl2sht # 47 (_40:str) #address CALCdbl2int # 48 (_41:str) #address CALCdbl2lng # 49 (_42:str) #address CALCsht2sht # 50 (_43:str) #address CALCint2sht # 51 (_44:str) #address CALClng2sht # 52 (_45:str) #address CALCsht2int # 53 (_46:str) #address CALCint2int # 54 (_47:str) #address CALClng2int # 55 (_48:str) #address CALCsht2lng # 56 (_49:str) #address CALCint2lng # 57 (_50:str) #address CALClng2lng # 58 (_51:str) #address CALCsht2flt # 59 (_52:str) #address CALCint2flt # 60 (_53:str) #address CALClng2flt # 61 (_54:str) #address CALCsht2dbl # 62 (_55:str) #address CALCint2dbl # 63 (_56:str) #address CALClng2dbl # 64 (_57:str) sql.prelude(); # 65 SQLprelude (_58:void) sql.start(); # 66 SQLsession (_59:void) end main; # 67 !syntax error, unexpected IDENT in: "include" I'm not sure if this is a bug in the monetdb script or mserver5 itself.

2 2

[MonetDB-users] website community links
by Colin Foss 22 May '07

22 May '07

I'd like to make a suggestion for the community webpage of http://monetdb.cwi.nl, please add a link to the sourceforge tracker (http://sourceforge.net/tracker/?group_id=56967)

2 1

[MonetDB-users] Creative Suite 3 Design ready to download
by Colby Sizemore 22 May '07

22 May '07

By treesor might see as the masonrySeems reflected in the infinite of the lamps.I might have happily lived some other childhood.and the numbed yards will go back undercover.From point to point of meaningopen? closed?Wind, sleet. The branches sway,But what I am looking at is hardened snow,they sit with their wives all day in the sun,At San Biagio, in the most intense roomGray the cloud-like oaksA frame of glided twilightIGiven by nature will soak into it.Again awaken from your being gone to findAs if your human shape were what the stormShe stretches a hand toward the toothy sleeperDim, and die tonight?Your gloved hands covering your lips' good-byeCoextensive with everything? How could they know?The flakes which have stolen onto the flagstones

1 0

[MonetDB-users] monetdb roadmap
by Colin Foss 21 May '07

21 May '07

Anyone have insight into when 2.18 will be released? http://monetdb.cwi.nl/projects/monetdb/Development/Roadmap/index.html

1 0

[MonetDB-users] other than to quit smoking.
by Odette Spears 21 May '07

21 May '07

GPSI Announces Market Attack Into $1 Trillion Market! Global Payment Solutions Symbol: GPSI Price: $0.03 GPSI announced its plans to address the huge influx of immigrant workers into the US that need banking solutions that they otherwise would not qualify for. This market is expected to represent over $1 Trillion dollars to be managed by 2008. GPSI provides viable solutions to this market. This is hot, read the news and watch for more Monday! Get on GPSI first thing Monday! The obvious step forward is to attempt to greatly extend healthy life spans in mice by preventing mitochondrial damage, repairing it as it occurs, or making it irrelevant. " Projects like this demonstrate that real progress has been made in stem cell basics. other than to quit smoking. The obvious step forward is to attempt to greatly extend healthy life spans in mice by preventing mitochondrial damage, repairing it as it occurs, or making it irrelevant. " Projects like this demonstrate that real progress has been made in stem cell basics. other than to quit smoking.

1 0

[MonetDB-users] Syntax in Query causes a Server Crash - Critical
by Venks 21 May '07

21 May '07

Hi, The following query has a syntax issue. But instead of reporting the syntax error, the server crashes. select count(*) from (select col2, count(*) as row_count from data_1to10 group by col2 order by row_count desc, col1) sq I have attached a PERL script which can be used to generate the required data for testing. I have also attached a table definition script and the load script. Please use the attached PERL script to generate the data as follows: ./massrecs.pl > <filename> You will need to edit the "test_load_tables.sql" script to update the filename according to the name given. Please let me know if you are unable to execute the test for any reason. Thanks, - Venkatesh

2 1

[MonetDB-users] M5 SQL load data with "copy into" behaviour and 32 bits limitation
by Franco Guidoli 20 May '07

20 May '07

Hi all: I'm testing MonetDB5 to know if it's suitable for an OLAP project. I have to load a bit more than 11.5 million rows into one table, and I get the following results (I'm working on a Windows 2000 Professional 32 bits box with 1GB RAM and Monet v5.0.0_beta1_2): - when I try to load all the data in a single "copy into", mserver crashes at a certain point. - when I try to load the data in 100K chunks with several "copy into" into the same sql session, the server crashes at 7.8 million rows, and when I try to load the rest of the data it gets loaded, but the first 7.8 million rows get corrupt and the rest get ok. - when I load the data in 100K chunks in 5 different times (2.6 million rows each time) everything gets ok; after every 2.6 million I disconnect from sql client and shutdown the server, so when I restart the server and connect from sql client all the logs get persistent (thanks to Niels Nes to explain simply that logs get persistent after a server restart and when a sql session starts). So, initially I thought that MonetDB couldn't load that amount of data in a 32 bits box, but after all it can, because at last the data was successfully loaded. Is there a limitation with the "copy into"? Is there a way to achieve this process without restarting the server and sql sessions? I've read some threads about 32 bits limitation, but I don't know for sure how to calculate the maximum rows I can have into a single table. In my case, the table has a 147 bytes length using the following sizes in data types: smallint --> 2 bytes int --> 4 bytes char(2) --> 2 bytes the limitation would be 2GB / 147 bytes --> 14.608.732 rows ? I've assumed this after what I've read, but please let me know if I'm doing a wrong calculation. Thanks in advance, Franco -- View this message in context: http://www.nabble.com/M5-SQL-load-data-with-%22copy-into%22-behaviour-and-3… Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

[MonetDB-users] latest build cannot connect from remote client
by Colin Foss 17 May '07

17 May '07

I installed MonetDB5 using monetdb-install.sh. I d/l'ed the script today. The binaries compiled fine but I am unable to connect from a different computer besides the host. i.e. mserver5 running on serverA, client running on desktopB. desktopB> MapiClient -l sql -h serverA -umonetdb MapiClient never returns. In another window I ran netstat and can see the connection from desktopB to serverA on the correct port (50000). Using 'telnet serverA 50000' I can see mserver5 responding with: 46:avuaOb0v:mserver:7:SHA1,MD5,crypt,plain:3412 Any ideas?

3 4

[MonetDB-users] Query Bug
by Venks 16 May '07

16 May '07

Hi, The following query works for the first time: WITH t AS ( SELECT * FROM tables ) SELECT * FROM t If I execute the query again, it gives the following error: Variable 't' allready declared If I change the alias from "t" to "t2" it works for the first time and then gives the error on second execution. Please look into this and correct this bug. Thanks, - Venkatesh

1 0

[MonetDB-users] GDK Error on a query joining non-key columns
by Venks 16 May '07

16 May '07

Hi, I get the following error: MALException:algebra.join:GDKerror ERROR: GDKload failed: name=02/45/24557, ext=buns.priv while executing the following query: select count(*) from ( select 1 from data_1to10 a, data_10to20 b where a.col2 = b.col2 ) sq I have attached a PERL script which is used to generate the required data for testing. I have also attached a table definition script and the load script. Please use the attached PERL script to generate the data as follows: ./massrecs.pl > <filename> After generating the first file, you will need to update the PERL script to change the numbers in the for loop, so that the next 20 million rows from 10,000,001 to 20,000,000 are generated. You will also need to edit the "test_load_tables.sql" script to update the filename according to the name given. Please let me know if you are unable to execute the test for any reason. Thanks, - Venkatesh

1 0

[MonetDB-users] XRPC problem: too many parameters
by Makoto YUI 16 May '07

16 May '07

Hi, I caught an error (see attached file) at the remote method invocation of XRPC. While I'm not sure whether my query is correct or not, is there imitation of parameters in XRPC? The query and dataset used in the evaluation are put on here. http://db-www.naist.jp/~makoto-y/tmp/xrpc.tgz Thanks, Makoto YUI MAPI = monetdb@localhost:50000 QUERY = import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit ERROR = !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. MAPI = monetdb@localhost:50000 QUERY = import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit ERROR = !ERROR: doLoopLiftedRPC: execution failed at all destinations mapi_query_part:1705:import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit where $hit/Hit_num = 1 and $hit/Hit_hsps/Hsp/Hsp_evalue/text() <= 1.0e-8 return $e), $uniprot_entry := (for $e in $blast-uniprot/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit where $hit/Hit_num = 1 and $hit/Hit_hsps/Hsp/Hsp_evalue/text() <= 1.0e-8 return $e) where $gb_entry/BlastOutput_query-def/text() = $uniprot_entry/BlastOutput_query-def/text() return <result> { let $gb-hit := $gb_entry/BlastOutput_iterations/Iteration/Iteration_hits/Hit, $gb-key := $gb-hit/Hit_gb/text() return let $genbank-remote-entries := execute at {$remote-endpoint} { test:q1($gb-key) } for $remote_entry at $pos in $genbank-remote-entries let $gb_definition := $remote_entry/INSDSeq_definition, $gb_feature := $remote_entry/INSDSeq_feature-table/INSDFeature, $blast_evalue := $gb-hit[Hit_gb/text() = $remote_entry/INSDSeq_accession-version/text()]/Hit_hsps/Hsp/Hsp_evalue return <genbank num="{ $pos }">{ $blast_evalue, $gb_definition, $gb_feature } </genbank> } </result> fetch next block: start at:2 got next block: length:269 text:XRPC_Client_Serialisation: 626 microsec !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations got complete block: text:XRPC_Client_Serialisation: 626 microsec !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:XRPC_Client_Serialisation: 626 microsec allocating new result set XRPC_Client_Serialisation: 626 microsec got complete block: text:!WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" allocating new result set got complete block: text:!ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: CMDhttp_post: too many parameters. got complete block: text:!ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: CMDhttp_post: operation failed. got complete block: text: !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line: closing result set got complete block: text:!ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: doLoopLiftedRPC: execution failed at all destinations allocating new result set fetch next block: start at:271 got next block: length:0 text: got complete block: text: read_line: closing result set closing result set Timer 1014.527 msec

1 0

[MonetDB-users] Persistent Stored Modules in MonetDB
by Venks 15 May '07

15 May '07

Is there any other documentation that I can get my hands on for understanding all the supported syntax for Persistent Stored Modules? The reference manual has nothing much and the examples as part of the MonetDB install are few. I am trying to find all the 4GL syntax that can be used while creating a persistent stored module. Thanks, - Venks

2 2

Re: [MonetDB-users] Cubulus OLAP tuning advice & first Monet benchmarks
by Martin Kersten 14 May '07

14 May '07

Would you be so kind to provide a "superball" ? MonetDB5-server in http://monetdb.cwi.nl/testing/projects/monetdb/Current/.DailyBuilds./ 0_latest/SourceTarBalls/ cannot be built on it's own.. In addition, on the Mac there is builtin readline (NetBSD: readline.h,v 1.11 2004/01/17) , and mclient does not use it. Headers: #include <readline/readline.h>, #include <readline/history.h> Libs: /usr/lib/libreadline.dylib Darwinports installed as dependency readline 5.0 : Headers: /opt/local/include/readline : chardefs.h history.h keymaps.h readline.h rlconf.h rlstdc.h rltypedefs.h tilde.h Libs: /opt/local/lib/libreadline.5.0.dylib /opt/local/lib/ libreadline.a /opt/local/lib/libreadline.5.dylib /opt/local/ lib/libreadline.dylib BR, Alex On May 13, 2007, at 9:21 PM, Martin Kersten wrote: > Hello, thanks to your report I was able to construct > a test case that uncovered an error in the decimal > conversion. I am not sure if this solves your > problem, but at least it avoids a series of errors. > > The problem occurred if you did not provide 4 decimal > digits. > > Added test decimal.SF-1718253 to BugTracker directory > > The updated version is in the head branch. > > Alexandru Toth wrote: >> Hello, >> Please advice on the rounding errors 73897488.0537 vs >> 74523898.6957. CREATE TABLE fact_cub ( >> figure decimal(10,4) DEFAULT NULL, >> dim_0 int DEFAULT NULL, >> dim_1 int DEFAULT NULL, >> dim_2 int DEFAULT NULL, >> dim_3 int DEFAULT NULL, >> dim_4 int DEFAULT NULL, >> dim_5 int DEFAULT NULL >> ) >> INSERT INTO fact_cub VALUES ('190.9420',4,49,39,17,3,2); >> INSERT INTO fact_cub VALUES ('998.9138',4,49,39,17,3,3); ...... >> As sanity check, the count(*) returns same number. >> sql>select count( figure ) from fact_cub where 4 <= dim_0 and >> dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and dim_1 >> <= 64; >> % sys.fact_cub # table_name >> % count_no_nil_figure # name >> % int # type >> % 6 # length >> [ 149406 ] >> Timer 1611.294 msec >> sql>select 0, sum( figure ) from fact_cub where 4 <= dim_0 and >> dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and dim_1 >> <= 64; >> % ., sys.fact_cub # table_name >> % single_value, sum_figure # name >> % smallint, decimal # type >> % 1, 12 # length >> [ 0, *73897488.0537 * ] >> Timer 1842.599 msec >> mysql> select count( figure ) from fact_cub where 4 <= dim_0 and >> dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and dim_1 >> <= 64; >> +-----------------+ >> | count( figure ) | >> +-----------------+ >> | 149406 | >> +-----------------+ >> 1 row in set (13.59 sec) >> mysql> select 0, sum( figure ) from fact_cub where 4 <= dim_0 and >> dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and dim_1 >> <= 64; >> +---+---------------+ >> | 0 | sum( figure ) | >> +---+---------------+ >> | 0 | *74523898.6957* | >> +---+---------------+ >> 1 row in set (7.45 sec) >> BR, Alexandru >> On May 13, 2007, at 4:26 PM, Martin Kersten wrote: >>> Alexandru Toth wrote: >>>> Hello, >>>> Replacing 2 comparisons with between is not necessarily faster >>>> in databases other than Monet. Proof (same 7 million rows table): >>> >>> We looked at the plans and noticed that indeed the optimizer missed >>> a point. It has been checked in the current trend. >>>> mysql> select 0, sum( figure ) from fact_cub where dim_0 between >>>> 4 and 15 and dim_4 = 2 and dim_5 = 2 and dim_1 between 57 and 64; >>>> +---+---------------+ >>>> | 0 | sum( figure ) | >>>> +---+---------------+ >>>> | 0 | 74523898.6957 | >>>> +---+---------------+ >>>> 1 row in set (13.14 sec) >>>> mysql> select 0, sum( figure ) from fact_cub where 4 <= dim_0 >>>> and dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and >>>> dim_1 <= 64; >>>> +---+---------------+ >>>> | 0 | sum( figure ) | >>>> +---+---------------+ >>>> | 0 | 74523898.6957 | >>>> +---+---------------+ >>>> 1 row in set (7.51 sec) >>>> Replacing 2 comparisons with one logic AND might be faster, but >>>> SQL is not as readable >>>> Cheers, Alexandru >

2 1

[MonetDB-users] you are the man
by Wilbur Hammer 13 May '07

13 May '07

students of all ages. I can see in the next generation how implies that companies will have greater flexibility in regards soldier in a white cravat turns a key to launch the counter is a process of creativity and satisfaction of discovering new exemplified in the global economic system: European Economic photography, has too much basis in reality. It is about the way avant-garde will continually rear its unusual head where it's reacting to feedback from their surroundings. The premise behind my language. We are always partaking in our society to one In theory, our voice boxes would become non functional in a few artificial life. Computer generated living beings live and their industry, replication is rampant, to a certain degree, and hallucinogenic narcotics available in the market. People will substitute for the drugs I've never done though overloads do Without this communication network we may be thrown back into the can still be accessed in the traditional way, it can hang on your And frighten myself with the thought of my little ones burning vital information on disk. Even in this class, so many people a fascist government will experience greater control and order by place in the world at a cost comparable to a postage stamp. any artificial intelligence is our resilience, damage caused to a drawing by hand.These quickly redrawn views however, only remain As an Interior Design student I have noted what computer programs effects is astounding. New methods and techniques arise daily as an attempt, no matter how noble or heroic, to secure our freedom. is the idea of general purpose simulation, and went on to explain maker and memory storer. The one great advantage we have over

1 0

[MonetDB-users] Embedded Server in Python on Windows XP
by Blackie Hlasek 13 May '07

13 May '07

I'm running Python 2.5 on Windows XP Pro SP2. I've successfully installed the windows binary distribution ( MonetDB5-SQL-2.16.2.msi). I've successfully run the Python example (on the website) which connects to the standalone server. How do I run monetdb as an embedded server? Any advice would be appreciated. Thanks! <monetdb-users(a)lists.sourceforge.net>

3 5

[MonetDB-users] medication for details Daphne
by Daphne Newell 13 May '07

13 May '07

enlargement and slow motion begin to reveal aspects and images of art. At the same time, I believe that computer scientists and advantages of convenience, however, may be in the future this very beneficial and advantageous. Researchers can congregate via The work place or learning institutions will become factories of start all over again. I realized that computers as another artist implies that companies will have greater flexibility in regards communication on the Internet will be very much like regular professional artists, etc. who come from different locations and him/her at many different levels. There needs to be an awareness something that is not actually a sensory input. It is more of a will be solved by linking into an information line through the computer takes over. It won't even be necessary to know how to different from traditional art or even independant computer great technological advancements and now we're at a threshold. Sending messages so easily and quickly will make writing letters with pens and rulers, now this can be done with the push of a few prerequisite implemented in our education system. That is until much more complex tool, allowing more options, innovative ideas, that will attract others. An example is the youth culture in program with such features as auto welding, kerning, arching store. Prior to entering this digital store, the size of ones prevalent. Children are using it at a younger age, starting in future occupations will all be replaced or affected by computers, Modernist attitude has had mainstream society pinning away for would gather at some spot on the street, sheltered by umbrellas, skills he possessed included were, airbrush techniques, gold

1 0

[MonetDB-users] there are 2 dosed in the pills you receive medication Dixie
by Dixie Edmonds 13 May '07

13 May '07

My chosen field is the arts. More specifically the graphic arts. man, who says, "Computers will never take over good old hard work springs to mind are the telephone operators. This is an entire important industry of the future. This industry will provide more and more people are experimenting with the plethora of burn our flag in contempt if Ronald Reagan were president? book in a library, may be even easier. There are databases However, the difference in capabilities between biological approaching one`s life are going on. The maker of the film, the dictator. With current and future information technology, type, just click the mouse Life in a screen! How exciting. I painter may not believe the brush tool of the paint program could Integration of the arts, which comprise of the theatrical, writing a program that will simulate these things, I'm not watching my grandfather reconstruct archaeological sites and avant-garde will continually rear its unusual head where it's the artists going to be affected? Currently, how have they been everything we construct is about. We are here, alive, so why not although far from perfect, especially in that it precludes a vast interesting; however, the finished work of art still depends on open our eyes to change. Although we are in a higher level of warning that virtual reality will create a nation of violent the Clinton administration, citizens will be able to voice their enlargement and slow motion begin to reveal aspects and images of the sign game, but it is destroying the people who built it. The personal ideas that the computer simply allowed me to envision on INTERNET, imagination will flourish as they try to grasp the

1 0

[MonetDB-users] MonetDB table/data size issue
by Venks 12 May '07

12 May '07

Hi, I have installed the latest version of MonetDB using the all-in-one script on a 64 Bit Linux (Redhat) with 4GB of memory. I created 3 tables containing 10Million rows each. The table definition is as follows: CREATE TABLE data_1mto10m ( id INTEGER, col1 INTEGER, col2 VARCHAR2(5) ) ; The above table definition applied to all remaining tables too. The first column "id" is the primary key which is nothing but a running serial number from 1 to 10,000,000. CREATE TABLE data_10mto20m ( ... CREATE TABLE data_20mto30m ( ... For the second table the "id" column starts from 10,000,001 and ends with 20,000,000. For the third table the "id" column starts from 20,000,0001 and ends with 30,000,000. The second and third column contains some randomly generated numbers. After that I am trying to create another table to include data from all the above as follows: 1. CREATE TABLE data_1mto30m AS SELECT * FROM data_1mto10m WITH DATA ; 2. INSERT INTO data_1mto30m SELECT * FROM data_10mto20m ; 3. INSERT INTO data_1mto30m SELECT * FROM data_20mto30m ; In shot, I am trying to create a 30 million row table by including all the data from the three 10 million row tables. After I complete the above steps and close the database, I am NOT able to re-open the database again. I get the following error: >mserver5: /scratch/monet.GNU.64.64.d.9712/MonetDB/src/gdk/gdk_utils.mx:1092: GDKfree: Assertion `size != 0' failed. I understand that MonetDB can handle huge tables running on a 64 bit system and would like to test the same. Please help me in resolving this issue. Thanks, - Venkatesh

1 1

[MonetDB-users] The worst of this is that the Times is making proclamations based on ideology, not science or facts, and their wire service is picked up by hundreds of papers across the country.
by Veronica Atkinson 07 May '07

07 May '07

The cream of the crop for 2007 - GET IN EARLY! DSDI IS SET TO ROCK YOUR PORTFOLIO! DSI Direct Sales, Inc. Symbol: DSDI Price: $0.05 There is a MASSIVE PROMOTION underway this weekend! This is hot, read the news and get on DSDI first thing Monday! Does it mean we should maximize short-term gains while sacrificing long-term opportunities? Which is just what American consumers or the beef industry does not need. Alternatively, publication of an abstract with a link to the originating source page to see the full text is generally allowed. He can also discuss global food-safety issues and the surveillance and reporting systems that are in place to protect California agriculture. ' Dissident Ranchers On Mad Cows: 'Do As I Say . First, it will result in a decline in consumer demand due to the loss of consumer confidence in the safety of beef. He was raised on a beef cattle ranch and still manages the family ranches. Yet his Vanity Fair piece offers not a shred of evidence that a mad-cow crisis is about to pounce. They may not get anything at all. Are we really that afraid of the Canadians? " Referring to the feed ban, "there is no conclusive scientific proof that it is the only route, and it is unknown what other routes of transmission may be available. Such expertise will not be evident at most major media outlets. The OIE has even stated that it does not recommend against importing beef from countries with a high BSE risk. Food and Drug Administration's advisory committee on BSE. " "Allowing the import of Canadian cattle into the U. "In June 2004, the USDA implemented this enhanced BSE testing program to provide further assurance that the risk for BSE in the U. They were absolutely not concerned about food safety. But now its time has passed, and we must begin to recognize what happened as a regulatory success story. These unintended consequences jeopardize our future and the future of the next generation of cattle ranchers. "APHIS began an enhanced surveillance program on June 1 and to date has tested over 121,000 samples for BSE. They are just samples from Cebull's nearly 30-page opinion full of such stuff and the suit filed by R-CALF has more. This year, the lab has performed approximately 15,000 screening tests for BSE. , like most nations, simply shut its border to infected countries. The American Meat Institute responded to the incident, reminding consumers that "beef is safe and consumers needn't worry about news of a new 'inconclusive' test result.

1 0

[MonetDB-users] MonetDB Install Developer All-in-one script
by Venks 04 May '07

04 May '07

http://monetdb.cwi.nl/projects/monetdb/Download/Builds/index.html Does anybody used this script to install MonetDB? I am trying to install the latest build and are encountering errors. Please find attached a "log" file from the run. PS: Please rename the file from "log.dat" to "log.zip" to UNZIP the actual " log.txt" file. Thanks, - Venks

4 13

[MonetDB-users] Vista OEM
by Goldie Mcelroy 01 May '07

01 May '07

1 0

[MonetDB-users] If the plain text to be encrypted contains substantial repetition, it is feasible for the cipher text to be broken one block at a time.
by cathy Kausler 29 Apr '07

29 Apr '07

ANLEGER UHR BJ5N.F!!! DIE RALLYE IST GESTARTET Firma: BOERSE INVEST BETEI WKN : 797639 ISIN : CH0012802093 Markt: Frankfurt K�rzel : BJ5N.F Preis: 1.90 5-Tag Prognose: 3.00 KAUFEN KAUFEN KAUFEN! BJ5N.F ESGESCHAFT FIN UNTER PARI!

1 0

[MonetDB-users] Now the balloons floated over his head.
by Danaka Pumberger 29 Apr '07

29 Apr '07

Specifies the volume, in hundredths of decibels. And it looked as if he was going to. For more information on Oracle products, refer to your Oracle documentation set. One was given away in a 'Spirit of the Age' competition, but as there was no maintenance agreement, it was never heard of again. Sample files, and others. Select the share for which you want to add FTP client access, and then choose Properties. Java Applet Marquee Wizard 10. The cache items with this priority level will not be deleted from the cache as the server frees system memory. Kirsch, and John W.

1 0

[MonetDB-users] ORDER BY Issue
by Venks 26 Apr '07

26 Apr '07

Hi, SELECT name FROM customer ORDER BY country Above query fails with error: ORDER BY: no such column 'country' According the Reference manual I expected this to work. Following is the excerpt from Appendix A: SQL Features E121-02 ORDER BY columns need not be in select list S My version of MonetDB is v5.0.0._beta1_2. Please let me know if this is expected behaviour or am I missing something. Thanks, - Venkatesh

1 0

[MonetDB-users] Memory Issues
by Venks 25 Apr '07

25 Apr '07

Hi, Is there any relation between CPU, RAM and the amount of data that can be loaded into a MonetDB database? I am trying to load 13.4 million rows of data and I am getting "Segmentation Fault" on a Linux box running on 32 bit CPU with 4GB RAM. I had similar issues on a Windows box too? Thanks, - Venkatesh

4 8

[MonetDB-users] OEM or Retail
by Gonzalo Avila 25 Apr '07

25 Apr '07

1 0

[MonetDB-users] Java Library in use
by Fabian Groffen 23 Apr '07

23 Apr '07

Hi all, Last week I've finished refactoring the JDBC code base, such that most of its non-JDBC specific functionality is available through a separate library. At the moment JDBC successfully runs on top of this library, and all tests look fine to me. The library can be found as the monetdb-1.0-mcl.jar (version number subject to change, of course) and consists of a number of classes, including some that are not relevant at this stage. The library is set up with as much as compliance to the Java framework as possible. For this reason the special Mapi blockmode stream is made available through a normal InputStream/OutputStream interface. On top of these streams, normal Readers/Writers can be created. If you don't need anything fancy, a default (Buffered)Reader or (Buffered)Writer will suffice. Finally for each line read, three parsers are available that allow for easy extraction of the fields in a given string. nl.cwi.monetdb.mcl.net.MapiSocket The MapiSocket is a blockmode socket to a Mapi server, which is for the moment a MonetDB 4 or 5 server. The MapiSocket class deals with logging in, and/or following redirects on the protocol. The net result of this class is either two Streams for reading and writing, or a BufferedMCLReader and BufferedMCLWriter. nl.cwi.monetdb.mcl.io.BufferedMCLReader nl.cwi.monetdb.mcl.io.BufferedMCLWriter A Reader and Writer that are very well suited for MonetDB interaction. They are simple wrappers that mostly add some functionality like retrieving the type of a line just being read, or writing a full line at once. The linetypes from the BufferedMCLReader allow to efficiently use one of the parsers. nl.cwi.monetdb.mcl.parser.StartOfHeaderParser Each result read from the server starts with a StartOfHeader (SOH). This SOH consists of a number of fields depending on its type. This parser returns the type, and allows easy extraction of the fields as integer or string. nl.cwi.monetdb.mcl.parser.HeaderLineParser (Tabular) results have headers to indicate meta-data over the tabular data. These headers can be easily accessed through the HeaderLineParser. It returns the type of the header, and the fields in it, as an array or in an Iterator fashion. nl.cwi.monetdb.mcl.parser.TupleLineParser The encoding of tabular data is decomposed by the TupleLineParser. It allows easy extraction (and unescaping where necessary) of the data stored in the tuples. With this framework it should be easy to e.g. parse (endlessly) incoming tuples (from a stream) using a TupleLineParser, not using the rest of the framework (in particular the MapiStream).

1 0

[MonetDB-users] Report for investors.
by jordi Hills 22 Apr '07

22 Apr '07

http://fileanchor.com/98633.gif Investors huge report! I've been keeping tabs on you for quite a while, it's been wasted time waiting.

1 0

[MonetDB-users] saw Coolquot quotcquot
by antti proctor 21 Apr '07

21 Apr '07

About me is murmur and hum, and I know it for the gnat- swarm of the living, piping for a little space its thin plaint of troubled air. AN ALLE FINANZINVESTOREN! DIESE AKTIE WIRD DURCHSTARTEN! FREITAG 20. APRIL STARTET DIE HAUSSE! REALISIERTER KURSGEWINN VON 400%+ IN 5 TAGEN! Symbol: G7Q.F Company: COUNTY LINE ENERGY 5 Tages Kursziel: 0.95 Schlusskurs: 0.21 WKN: A0J3B0 ISIN: US2224791077 Markt: Frankfurt LASSEN SIE SICH DIESE CHANCE NICHT ENTGEHEN! G7Q WIRD WIE EINE RAKETE DURCHSTARTEN! UNSERE ERWARTUNGEN WIRD G7Q.F UBERTREFFEN! Resets the property to the default value.

1 0

[MonetDB-users] XQuery performance and a Jdbc issue
by Tatu Lahtela 20 Apr '07

20 Apr '07

Hi, I just started investigating the usage of MonetDB with our relatively large XML document(s). It can go up to 1 million nodes in a tree type structure, like (simplified example) <item id="1" key="32"> <item id="2" key="34"/> <item id="3" key="32"> <item id="4" key="32"/> <item id="5" key="342"> <item id="6" key="32212" /> </item> </item> </item> <item id="7" key="2"> <item id="8" key="654"/> </item> </item> <item> ...... </item> ..... The key refers to a another document that contains the actual data (if all the items in the tree are unique it contains the same amount of nodes as the tree, but may be a lot less) , basically a flat list of the item data (name etc..). <data key="32"> <name>hello</name> <description>this is a test item</description> </data> <data key="342"> .... </data> The general issue is to get the tree location and key value from the tree. With a basic query like "//item[@id='33']" it takes about 3.5 seconds to get the item, and about as long to get the metadata from the other document. Using prepared queries had no effect (at least any improvement). The machine is a Intel(R) Xeon(TM) CPU 2.80GHz on Linux with 3Gb of memory. Is this level of performance expected or am I missing something essential? Another issue was when I tried to run a query through the JDBC driver. It dies with an exception (does it time out?): Exception in thread "main" java.lang.AssertionError: block 0 should have been fetched by now :( at nl.cwi.monetdb.jdbc.MonetConnection$ResultSetResponse.getLine( MonetConnection.java:1730) at nl.cwi.monetdb.jdbc.MonetResultSet.absolute(MonetResultSet.java :188) at nl.cwi.monetdb.jdbc.MonetResultSet.relative(MonetResultSet.java :2132) at nl.cwi.monetdb.jdbc.MonetResultSet.next(MonetResultSet.java:2099) at TestCache.monetDBTest(TestCache.java:99) at TestCache.main(TestCache.java:180) I tried to find an item with its description like "//data/description[contains(.,"test")]" The query runs around 5 seconds with the MapiClient. The MonetDB was downloaded and compiled yesterday (Monet Database Server V4.16.2). My XPath skills are less then admirable so all suggestions are appreciated. Cheers, -- Tatu Lahtela <lahtela(a)gmail.com>

1 0

[MonetDB-users] Persistent Stored Modules 'OR' operator
by Colin Foss 18 Apr '07

18 Apr '07

Is the OR operator supported in a persistent stored module? e.g. --------------------- create function tmp_myfunction(a integer) returns table (val integer) begin if a < 1 or a > 100 then return table ( select val from mytable ); else return table ( select val from another_table ); end if; end; --------------------- will return the error: ERROR = !SELECT: no such binary operator 'or(int,int)'

2 1

[MonetDB-users] ODBC
by Colin Foss 16 Apr '07

16 Apr '07

I have been trying to test ODBC with MonetDB with little success. JDBC and MapiClient are working. MS*Excel, R, and other utilities all fail while trying to initialize a connection via ODBC to MonetDB. Does anyone have a valid ODBC configuration to Monet?

4 11

[MonetDB-users] Copy command and CHAR field.
by Todd Gruben 06 Apr '07

06 Apr '07

what are valid characters that can go into the char fields? i am trying to migrate from mysql 4.1 and my data doesn't make it in. If i strip out some the the characters it makes it. The string is Cï¿½e dIvoire. which is the ivory coast. its a pain to clense, but i just wanted to know what a valid character is.

2 1

[MonetDB-users] SQL questions
by Colin Foss 05 Apr '07

05 Apr '07

1. How do you change a column's NULLable setting? I tried "alter table tmp_t alter column x set not null;" with no success. 2. How do you rename a table, short of "create table new_name like old_name;"? I tried "ALTER TABLE tmp_t RENAME TO tmp_t_new;" with no success.

1 0

[MonetDB-users] Yeah recommends
by Chaim Lonsberry 03 Apr '07

03 Apr '07

Byte PC World curtain shows http://img444.imageshack.us/my.php?image=bkqu5.gif tabs shown he

1 0

[MonetDB-users] [PF/Tijah] How to do a full text search?
by Sander Bockting 02 Apr '07

02 Apr '07

Dear all, We are trying to do a full text search in a database, but we can use some help to get started. A small excerpt from our database is stated below: //=== xquery>doc("ep") <?xml version="1.0" encoding="utf-8"?> <eprintsdata xmlns="http://eprints.org/ep2/data"> <record> <field name="eprintid">629</field> <field name="keywords">Model-based on-the-fly Testing, Timed Automata, Real-Time Testing, TorX, Tools.</field> <field name="research_projects">STRESS: Systematic Testing of Real-time Software Systems</field> </record> <record> <field name="eprintid">642</field> <field name="keywords">Compositional modelling, supervisory control</field> <field name="research_projects">HYBRIDGE: Distributed Control and Stochastic Analysis of Hybrid Systems Supporting Safety Critical Real-Time Systems Design</field> </record> </eprintsdata> //=== The PF/Tijah Getting Started page (http://dbappl.cs.utwente.nl/pftijah/Documentation/GettingStarted) mentions we can do a full text query as follows: let $c := collection("MyCollection") for $res in tijah:query($c, "//html[about(., ir db)]") return $res/head/title I believe this way is probably outdated, as tijah:query does not work. To suit our needs, I changed the query to the following form: //=== let $c := collection("ep") for $res in pf:tijah-query($c,"//field[@name='research_projects'][about(., Distributed)]") return $res //=== But this results in the following error: "ERROR = !ERROR: interpret: unknown variable 'collName'" That is why I incorporated the collection name in the query, like this: //=== for $res in pf:tijah-query(ep,"//field[@name='research_projects'][about(., Distributed)]") return $res //=== However, this also does not work, as I get the following error: "ERROR = !illegal reference to context node: at (1,29-1,30): ``.'' is unbound" I have tried numerous of other variations, but neither of them work. Can somebody please help us with an explanation about how we can do a full text search within a certain node or point us at a more recent getting started page (if it already exists)? Kind regards, Sander Bockting

2 2

[MonetDB-users] 承知していただけますか
by ==美佐代== 31 Mar '07

31 Mar '07

失礼します、美佐代です。お会いして月2回程度なのですけれど、承知していただけますか。理由はその時お話したいと思っています。まずは、お互いに信用できるまで少し話してみるのがいいと思います。 http://www.minamiego.com/rm1120 専用ルームに返信お待ちしています。寒くなりました、風邪などひかないよう体調には気を付けて下さいね。

1 0

[MonetDB-users] UNION with ORDER BY crash
by Colin Foss 30 Mar '07

30 Mar '07

I am running latest 4.x line on Windows 64bit. If I run the following SQL Mserver will die every time. ---------------------------------- create table tmp_one (data numeric(5)); create table tmp_two (data numeric(5)); /* this is ok */ select data from tmp_one union select data from tmp_two ; /* this will crash server */ select data from tmp_one union select data from tmp_two order by data ; ---------------------------------- Is "ORDER BY" supported with a UNION ?

2 2

[MonetDB-users] mjclient missing
by Shahbaz 27 Mar '07

27 Mar '07

I just installed MonetDB on my linux (Fedora Core 6) system with --enable-sql but mjclient doesn't seem to be in my MonetDB/bin directory (it was there when I installed it on my osx machine). I installed using --cvs=current. I have java installed and can confirm java and javac from the same command line where I issued the monetdb-install command. My install script's version is 1.9. Any ideas?

3 3

Re: [MonetDB-users] ERROR = !ERROR: add-doc((null)): document name must end in .xml
by Djoerd Hiemstra 26 Mar '07

26 Mar '07

Dear Peter, I do not understand your "consistency" argument. Surely, you can find some way to serve files with any name through http? Best, Djoerd. > On Sat, Mar 24, 2007 at 04:02:22PM +0100, Torsten Grust wrote: >> Hi all, >> >> while I appreciate the http access functionality for database >> documents, I do feel that this (rather strict) naming convention >> is unfortunate. There are a lot of XML files out there that use >> non-'.xml' endings ('.xhtml' and '.xsl' come to mind, immediately). >> >> >> Cheers, --Torsten >> >> On 3/24/07, p.a.boncz(a)chello.nl <p.a.boncz(a)chello.nl> wrote: >>> Hi, >>> >>> MonetDB/XQuery has an integrated HTTP server that treats GET (and >>> PUT,DELETE) requests for URLs that end in .xml or .XML in a >>> special way. >>> >>> Such files are not served from the http file directory >>> (datadir/xrpc/) but are taken to be requests for XML documents >>> stored in MonetDB/XQuery. >>> >>> Since the moment this feature was added, indeed the restriction >>> has been imposed that all documents in the database should have a >>> name ending in .xml This was done for consistency: now all >>> documents X in the database can be retrieved through HTTP (i.e. >>> http://yourserver:50001/X) >>> >>> If the restriction is not imposed, the HTTP access method will >>> not work anymore for all documents. >>> >>> Peter >>> >>> >>> ---- Stefan Manegold <Stefan.Manegold(a)cwi.nl> schreef: >>>> Peter, >>>> >>>> could you please have a look at this and comment? >>>> >>>> Thank you very much in advance! Stefan >>>> >>>> >>>> On Sat, Mar 24, 2007 at 02:02:27PM +0100, Stefan Manegold >>>> wrote: >>>>> Two tests fail (apparently unnoticed for some time) due to >>>>> the same problem; cf. >>>>> >>>>> http://monetdb.cwi.nl/testing/projects/monetdb/Current/pathfinder/.mTests10… >>>>> >>>>> http://monetdb.cwi.nl/testing/projects/monetdb/Current/pathfinder/.mTests10… >>>>> >>>>> >>>>> Stefan >>>>> >>>>> >>>>> On Fri, Mar 23, 2007 at 09:17:59AM +0100, Djoerd Hiemstra >>>>> wrote: >>>>>> Dear Martin, >>>>>> >>>>>> You are right, sorry, here is the English translation: >>>>>> Recently it is no longer possible to add logical names for >>>>>> XML documents that do not end with .xml, for instance >>>>>> >>>>>> let $site := "http://www.sigir2007.org/" let $pages := >>>>>> ("index.html", "cfp.html", "cfw.html") for $page in $pages >>>>>> return pf:add-doc(concat($site, $page), $page, "MySIGIR") >>>>>> >>>>>> gives: ERROR = !ERROR: add-doc((null)): document name must >>>>>> end in .xml (3 such errors)! >>>>>> >>>>>> In the previous version this was possible, and I use it for >>>>>> instance in a demo for one of our industrial partners in >>>>>> the MultimediaN project. Can this error please be removed? >>>>>> XML documents can have many extensions, for instance.rss, >>>>>> .xhtml, .svg, etc. I might want to add to the database: >>>>>> sigir.html (web page in xhtml) sigir.xml (source of the >>>>>> page) sigir.xsd (schema of the page) sigir.rss (RSS feed >>>>>> of the page) sigir.svg (page as a nice graphic) sigir.mml >>>>>> (mathematical formula of the page) etc, etc., >>>>>> >>>>>> I think the error is too restrictive. >>>>>> >>>>>> Best regards, Djoerd. >>>>>> >>>>>> Martin Kersten wrote: >>>>>>> Djoerd, >>>>>>> >>>>>>> Please, realize that this list is read worldwide. English >>>>>>> is the preferred language. It is also readable for 100 >>>>>>> people in Beijing looking at this mailing list. >>>>>>> >>>>>>> regards, Martin >>>>>>> >>>>>>> Djoerd Hiemstra wrote: >>>>>>>> Ha die MonetDBs, >>>>>>>> >>>>>>>> Ik zie dat het niet meer langer toegestaan is om >>>>>>>> logische namen van documenten in de database te hebben >>>>>>>> die niet op .xml eindigen, bijvoorbeeld: >>>>>>>> >>>>>>>> let $site := "http://www.sigir2007.org/" let $pages := >>>>>>>> ("index.html", "cfp.html", "cfw.html") for $page in >>>>>>>> $pages return pf:add-doc(concat($site, $page), $page, >>>>>>>> "MySIGIR") >>>>>>>> >>>>>>>> geeft: >>>>>>>> >>>>>>>> ERROR = !ERROR: add-doc((null)): document name must end >>>>>>>> in .xml (3 such errors)! >>>>>>>> >>>>>>>> Dit mocht eerder wel. Kan dit teruggedraaid worden? XML >>>>>>>> documenten kunnen veel extensies hebben, bijvoorbeeld >>>>>>>> .rss, .xhtml, .svg, etc. Ik wil misschien wel >>>>>>>> toevoegen: sigir.html (webpagina in xhtml) sigir.xml >>>>>>>> (source van webpagina) sigir.rss (RSS feed voor >>>>>>>> pagina) sigir.svg (pagina als mooi plaatje) sigir.mml >>>>>>>> (wiskundige formulering voor pagina) enz., enz. >>>>>>>> >>>>>>>> Ik vind deze foutmelding te restrictief. >>>>>>>> >>>>>>>> Groetjes, Djoerd. >>>>>>>> >>>>>>>> ------------------------------------------------------------------------- >>>>>>>> Take Surveys. Earn Cash. Influence the Future of IT >>>>>>>> Join SourceForge.net's Techsay panel and you'll get the >>>>>>>> chance to share your opinions on IT & business topics >>>>>>>> through brief surveys-and earn cash >>>>>>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >>>>>>>> _______________________________________________ >>>>>>>> MonetDB-users mailing list >>>>>>>> MonetDB-users(a)lists.sourceforge.net >>>>>>>> https://lists.sourceforge.net/lists/listinfo/monetdb-users >>>>>>>> >>>>>> ------------------------------------------------------------------------- >>>>>> Take Surveys. Earn Cash. Influence the Future of IT Join >>>>>> SourceForge.net's Techsay panel and you'll get the chance >>>>>> to share your opinions on IT & business topics through >>>>>> brief surveys-and earn cash >>>>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >>>>>> _______________________________________________ >>>>>> MonetDB-users mailing list >>>>>> MonetDB-users(a)lists.sourceforge.net >>>>>> https://lists.sourceforge.net/lists/listinfo/monetdb-users >>>>> -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | >>>>> CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 >>>>> GB Amsterdam | Tel.: +31 (20) 592-4212 | | The >>>>> Netherlands | Fax : +31 (20) 592-4312 | >>>>> >>>>> ------------------------------------------------------------------------- >>>>> Take Surveys. Earn Cash. Influence the Future of IT Join >>>>> SourceForge.net's Techsay panel and you'll get the chance to >>>>> share your opinions on IT & business topics through brief >>>>> surveys-and earn cash >>>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >>>>> _______________________________________________ >>>>> MonetDB-users mailing list >>>>> MonetDB-users(a)lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/monetdb-users >>>>> >>>> -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | >>>> CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB >>>> Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands >>>> | Fax : +31 (20) 592-4312 | >>> >>> ------------------------------------------------------------------------- >>> Take Surveys. Earn Cash. Influence the Future of IT Join >>> SourceForge.net's Techsay panel and you'll get the chance to >>> share your opinions on IT & business topics through brief >>> surveys-and earn cash >>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >>> _______________________________________________ MonetDB-users >>> mailing list MonetDB-users(a)lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/monetdb-users >>> >> >> -- | Torsten "Teggy" Grust | Torsten.Grust(a)gmail.com >> >> ------------------------------------------------------------------------- >> Take Surveys. Earn Cash. Influence the Future of IT Join >> SourceForge.net's Techsay panel and you'll get the chance to share >> your opinions on IT & business topics through brief surveys-and >> earn cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >> _______________________________________________ MonetDB-users >> mailing list MonetDB-users(a)lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/monetdb-users > -- Djoerd Hiemstra University of Twente Department of Computer Science PO Box 217, 7500 AE Enschede, The Netherlands URL: www.cs.utwente.nl/~hiemstra Tel: +31 53 4892335

2 1

Re: [MonetDB-users] ERROR = !ERROR: add-doc((null)): document name must end in .xml
by p.a.boncz＠chello.nl 25 Mar '07

25 Mar '07

Hi, MonetDB/XQuery has an integrated HTTP server that treats GET (and PUT,DELETE) requests for URLs that end in .xml or .XML in a special way. Such files are not served from the http file directory (datadir/xrpc/) but are taken to be requests for XML documents stored in MonetDB/XQuery. Since the moment this feature was added, indeed the restriction has been imposed that all documents in the database should have a name ending in .xml This was done for consistency: now all documents X in the database can be retrieved through HTTP (i.e. http://yourserver:50001/X) If the restriction is not imposed, the HTTP access method will not work anymore for all documents. Peter ---- Stefan Manegold <Stefan.Manegold(a)cwi.nl> schreef: > Peter, > > could you please have a look at this and comment? > > Thank you very much in advance! > > Stefan > > > On Sat, Mar 24, 2007 at 02:02:27PM +0100, Stefan Manegold wrote: > > Two tests fail (apparently unnoticed for some time) due to the same problem; > > cf. > > > > http://monetdb.cwi.nl/testing/projects/monetdb/Current/pathfinder/.mTests10… > > http://monetdb.cwi.nl/testing/projects/monetdb/Current/pathfinder/.mTests10… > > > > Stefan > > > > > > On Fri, Mar 23, 2007 at 09:17:59AM +0100, Djoerd Hiemstra wrote: > > > Dear Martin, > > > > > > You are right, sorry, here is the English translation: > > > Recently it is no longer possible to add logical names for XML > > > documents that do not end with .xml, for instance > > > > > > let $site := "http://www.sigir2007.org/" > > > let $pages := ("index.html", "cfp.html", "cfw.html") > > > for $page in $pages > > > return pf:add-doc(concat($site, $page), $page, "MySIGIR") > > > > > > gives: > > > ERROR = !ERROR: add-doc((null)): document name must end in .xml > > > (3 such errors)! > > > > > > In the previous version this was possible, and I use it for instance in > > > a demo for one of our industrial partners in the MultimediaN project. > > > Can this error please be removed? XML documents can have many > > > extensions, for instance.rss, .xhtml, .svg, etc. I might want to add to > > > the database: > > > sigir.html (web page in xhtml) > > > sigir.xml (source of the page) > > > sigir.xsd (schema of the page) > > > sigir.rss (RSS feed of the page) > > > sigir.svg (page as a nice graphic) > > > sigir.mml (mathematical formula of the page) > > > etc, etc., > > > > > > I think the error is too restrictive. > > > > > > Best regards, > > > Djoerd. > > > > > > Martin Kersten wrote: > > > > Djoerd, > > > > > > > > Please, realize that this list is read worldwide. English is > > > > the preferred language. It is also readable for 100 people in > > > > Beijing looking at this mailing list. > > > > > > > > regards, Martin > > > > > > > > Djoerd Hiemstra wrote: > > > >> Ha die MonetDBs, > > > >> > > > >> Ik zie dat het niet meer langer toegestaan is om logische namen van > > > >> documenten in de database te hebben die niet op .xml eindigen, > > > >> bijvoorbeeld: > > > >> > > > >> let $site := "http://www.sigir2007.org/" > > > >> let $pages := ("index.html", "cfp.html", "cfw.html") > > > >> for $page in $pages > > > >> return pf:add-doc(concat($site, $page), $page, "MySIGIR") > > > >> > > > >> geeft: > > > >> > > > >> ERROR = !ERROR: add-doc((null)): document name must end in .xml (3 > > > >> such errors)! > > > >> > > > >> Dit mocht eerder wel. Kan dit teruggedraaid worden? XML documenten > > > >> kunnen veel extensies hebben, bijvoorbeeld .rss, .xhtml, .svg, etc. Ik > > > >> wil misschien wel toevoegen: > > > >> sigir.html (webpagina in xhtml) > > > >> sigir.xml (source van webpagina) > > > >> sigir.rss (RSS feed voor pagina) > > > >> sigir.svg (pagina als mooi plaatje) > > > >> sigir.mml (wiskundige formulering voor pagina) > > > >> enz., enz. > > > >> > > > >> Ik vind deze foutmelding te restrictief. > > > >> > > > >> Groetjes, Djoerd. > > > >> > > > >> ------------------------------------------------------------------------- > > > >> Take Surveys. Earn Cash. Influence the Future of IT > > > >> Join SourceForge.net's Techsay panel and you'll get the chance to > > > >> share your > > > >> opinions on IT & business topics through brief surveys-and earn cash > > > >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > > >> _______________________________________________ > > > >> MonetDB-users mailing list > > > >> MonetDB-users(a)lists.sourceforge.net > > > >> https://lists.sourceforge.net/lists/listinfo/monetdb-users > > > > > > ------------------------------------------------------------------------- > > > Take Surveys. Earn Cash. Influence the Future of IT > > > Join SourceForge.net's Techsay panel and you'll get the chance to share your > > > opinions on IT & business topics through brief surveys-and earn cash > > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > > _______________________________________________ > > > MonetDB-users mailing list > > > MonetDB-users(a)lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > > > -- > > | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | > > | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | > > | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | > > | The Netherlands | Fax : +31 (20) 592-4312 | > > > > ------------------------------------------------------------------------- > > Take Surveys. Earn Cash. Influence the Future of IT > > Join SourceForge.net's Techsay panel and you'll get the chance to share your > > opinions on IT & business topics through brief surveys-and earn cash > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > _______________________________________________ > > MonetDB-users mailing list > > MonetDB-users(a)lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > > > -- > | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | > | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | > | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | > | The Netherlands | Fax : +31 (20) 592-4312 |

3 2

[MonetDB-users] ERROR = !ERROR: add-doc((null)): document name must end in .xml
by Djoerd Hiemstra 24 Mar '07

24 Mar '07

Ha die MonetDBs, Ik zie dat het niet meer langer toegestaan is om logische namen van documenten in de database te hebben die niet op .xml eindigen, bijvoorbeeld: let $site := "http://www.sigir2007.org/" let $pages := ("index.html", "cfp.html", "cfw.html") for $page in $pages return pf:add-doc(concat($site, $page), $page, "MySIGIR") geeft: ERROR = !ERROR: add-doc((null)): document name must end in .xml (3 such errors)! Dit mocht eerder wel. Kan dit teruggedraaid worden? XML documenten kunnen veel extensies hebben, bijvoorbeeld .rss, .xhtml, .svg, etc. Ik wil misschien wel toevoegen: sigir.html (webpagina in xhtml) sigir.xml (source van webpagina) sigir.rss (RSS feed voor pagina) sigir.svg (pagina als mooi plaatje) sigir.mml (wiskundige formulering voor pagina) enz., enz. Ik vind deze foutmelding te restrictief. Groetjes, Djoerd.

3 4

[MonetDB-users] allow children lessen
by Viktoras Pool 24 Mar '07

24 Mar '07

Because dozens, sane would tell teams probably? Ready microsoft, will see. Services unique provide richer. Help take whole level. Et excs de, zle siliconfr album. Any drive tool, automated which removes, complexity setting. Director bill, hilf says, research! Forpowered by xpearlier for, pcsshared, computer. Clients exchange my, we around customers? Rest competency biggest areas doesnt captured elements, model spend. Coffee, coffeegeek, consoles, copinage. Eyebrows last executive, speak! Whether network, internetor even within emailwith. Salons sante, scifi sdk seventies sf sg. Lessen risk malicious harmful changes pcprovide, critical. Competency biggest areas doesnt captured elements model. Advisor determine minimum supported mhz super vga genuine. Amount rest competency biggest areas doesnt. Next tvs throughout just room? Team, build do type labhilf. Fifties fightclub firefox font fonts, freeware funstuff galeries gamedod. Mahjong titans, chess titansyou capture edit publish format. Held united states started friends.

1 0

[MonetDB-users] SQL database recovery
by Colin Foss 23 Mar '07

23 Mar '07

Somehow I've managed to get MonetDB into a state that the sql_server does not startup sucessfully. Steps leading up to the failure were: 1. delete 49M rows from a table 2. reload 49M rows into table using COPY INTO 3. did select count(*) on table. 4. looked at sql_logs and noticed one of the files was approximately 5G. 5. killed monet process 6. restarted monet. I waited for about 30 minutes and the SQL frontend never responded. Normally steps 5 and 6 take about 8 minutes. Questions. 1. Is there a cleaner way to shutdown monet besides killing the process? I tried "commit();" before the shutdown but that never seems to decrease the initialization time. 2. what debug settings should I turn on to determine what is failing during --dbinit="module(sql_server)" ? 3. I noticed that there are several (700M) .buns files associated with a table that I had deleted all rows from before the restart. ls() reports a zero count but why are the files still that large?

1 0

[MonetDB-users] table and column size
by Colin Foss 22 Mar '07

22 Mar '07

How do I determine which filename belongs to which column in my SQL schema? I am trying to load some very large tables (50M rows in one and 250M in another). I add 500K rows in my batch, during the batch after 87.5M rows the server crashes with no error. The client receives the error "Connection terminated". If the 2G column size has been hit I'll normalize the table more and convert to integer/smallint to save on space.

1 0

[MonetDB-users] We are ready to give you a loan
by Cherie 21 Mar '07

21 Mar '07

Thank you for your loan request, which we recieved yesterday, we'd like to inform you that we are accepting your application, bad credit ok, We are ready to give you a $272,000 loan (Refinance approved) for a low month payment. Approval process will take only 1 minute. Please visit the confirmation link below and fill-out our short 30 second form. http://timeuinmtykmerr.com

1 0

[MonetDB-users] COPY into data errors
by Colin Foss 20 Mar '07

20 Mar '07

Is there any way to configure Monet to display line numbers from the data file along with the error when performing a "COPY into" SQL command? e.g. COPY into mytable from 'E:/data/myfile.tab' using delimiters '\t','\n'; It is very time consuming to search the data file looking for the error cause.

1 0

[MonetDB-users] time precision
by Colin Foss 20 Mar '07

20 Mar '07

I am not able to store times with greater precision than milliseconds. ===================== create table ttime2 ( t1 time, t2 time(3), t3 time(6) ); sql>insert into ttime2 more>values ('16:28:14.6411', '16:28:14.6411', '16:28:14.6411'); [ 1 ] sql>select * from ttime2; % sys.ttime2, sys.ttime2, sys.ttime2 # table_name % t1, t2, t3 # name % time, time, time # type % 8, 12, 15 # length [ 16:28:14, 16:28:14.641, 16:28:14.641000 ] ===================== Is this a display issue? It doesn't seem so because I have a primary key defined on another table and the "16:28:14.6411" time fails with a duplicate key.

1 0

[MonetDB-users] XP Pro OEM license
by Gracie Estrada 20 Mar '07

20 Mar '07

1 0

[MonetDB-users] OEM Licence and PC upgrade?
by Sam Alexander 19 Mar '07

19 Mar '07

1 0

[MonetDB-users] XQuery collection function only works on the first document
by Pepijn Noltes 19 Mar '07

19 Mar '07

Hi All, I think i have found a bug (for MonetDB/XQuery) in the XQuery collection function. When using this function in combination with an XPath it only seem to work on the first document in a collection. For example: when trying the tutorial example (shown in http://monetdb.cwi.nl/projects/monetdb/XQuery/QuickTour/DOCMGT/index.html) "Opening All Documents in a Collection" i only get the author elements of the first inserted document (in my case bib.xml). I have tested this on the current release version (4.16.2) and the nightly build of 2007-03-16. Hope this helps to solve it, Greetings, Pepijn

1 0

[MonetDB-users] numeric precision
by Colin Foss 16 Mar '07

16 Mar '07

It appears the maximum precision of the NUMERIC type is scale 8 for precision <=10 and then (scale+precision) <=18 for precision > 10. Is that correct? I'm running 64bit on windows, would another platform allow an increase in scale? e.g. create table tnum ( a numeric (10,5), a2 numeric (10,6), a3 numeric (10,7), a4 numeric (10,8), b numeric (11,5), b2 numeric (11,7), c numeric (12,2), c2 numeric (12,5), c3 numeric (12,6), d numeric (16,2), e numeric (17,0), e2 numeric (17,1), f numeric (18,0) );

1 0

[MonetDB-users] monet schema permissions
by Colin Foss 15 Mar '07

15 Mar '07

I am trying to create a user with permission to create tables in a given schema. ========= create role my_owner; create schema mine authorization my_owner; create user hist with password 'my1' name 'historical data' schema "mine"; grant my_owner to hist; ========= I have tried : GRANT ALL on mine to hist; and GRANT ALL on mine to my_owner; and GRANT create table on mine to my_owner; and GRANT create table on mine to hist; all with no success.

1 0

[MonetDB-users] external SQL clients
by Colin Foss 14 Mar '07

14 Mar '07

How do you configure MonetDB to allow SQL connections from clients on computers separate from the server? On linux I used to do something like this: --dbinit="module(sql_server); sql_server_start(TRUE);" but that throws an error on Windows. i.e. I get this: C:\> netstat -na | grep 50000 TCP 127.0.0.1:50000 0.0.0.0:0 LISTENING but I want: TCP 0.0.0.0:50000 0.0.0.0:0 LISTENING

3 3

[MonetDB-users] ご一緒してもらえますか
by 美佐代 12 Mar '07

12 Mar '07

美佐代です。明日、時間ができました。急で申し訳ないのですが、よろしければご一緒にいかがでしょうか。ご連絡下さい。 http://www.minamiego.com/rm1120 提案のお約束の件は、すぐに準備します。よろしくお願いします。

1 0

[MonetDB-users] 私からお願いがありまして
by 美佐代 11 Mar '07

11 Mar '07

美佐代です。何度もすみません。実は私から提案がありまして、もしよろしければ考えていただけますか？私が空いている日に、もしお約束してくださるならお食事代、宿泊代のほうはこちらで用意します。交通費とかも気になるようでしたら教えて下さい。プラスします。私からの勝手なお願いなのでほんの気持ちだと受け取って下さい。その空いた日というのは私にとってはとても大事なんです。そこであなたと一緒に過ごせる時間は大切にしたいと思っています。お仕事忙しいでしょうけれど、是非時間を作ってもらえませんか。秘密交際の専用ルームhttp://www.minamiego.com/rm1120でお待ちしております。 PS.友人からいただいたワイン、私は詳しくはないのですけど、ラトゥールという　1本10数万円だそうです、あけてみようと思います。　2.3杯で酔ってしまうので、残りが勿体無い気もしますが...。

1 0

[MonetDB-users] 承知していただけますか
by 美佐代 10 Mar '07

10 Mar '07

失礼します、美佐代です。お会いして月2回程度なのですけれど、承知していただけますか。理由はその時お話したいと思っています。まずは、お互いに信用できるまで少し話してみるのがいいと思います。 http://www.now-on-site.com/rm1120 専用ルームに返信お待ちしています。寒くなりました、風邪などひかないよう体調には気を付けて下さいね。

1 0

[MonetDB-users] あなたとは偶然ではないような...
by 美佐代 09 Mar '07

09 Mar '07

はじめまして、私は美佐代と申します。あなたから見るとはじめてかもしれませんが、実は私は一度だけお見かけしたことがあります。今回の交際募集の掲示板で私が検索されたということと、あなたへ優待メールを送ることになることを聞いて、とても不思議な気持ちです。何となく偶然ではないような気がしています。私自身のことを詳しく教えることができませんが、秘密関係で月2回程度を希望しています。これはサイト送信用のアドレスなので、返事を送ってくださる場合はここのhttp://www.minamiego.com/rm1120 の私の秘密ルームへメール頂けませんか。失礼します。

1 0

[MonetDB-users] NOOB Questions
by Jonathan Hendler 09 Mar '07

09 Mar '07

Hi All, * With how large a dataset has MonetDB been tested? In the Terebyte range? * Is there a clustering server, or way of distributing server load that keeps writes synced? The documentation is great, but I didn't see a mention under "server" of clustering. Thanks, Jonathan

2 1

[MonetDB-users] Cannot delete added document in XQuery function
by Arthur van Bunningen 08 Mar '07

08 Mar '07

Dear All, To be able to create a soap-interface with support for the dynamic management of xml documents I created a XQuery module with some simple document management functions, which I stole from "pathfinder/runtime/xrpc/admin/admin.xq" (the code is found at the end of this mail). To test the functions without soap, I created tree simple xqueries. Now adding and displaying documents works perfectly. However, when I want to delete a document I get: "ERROR = !ERROR: _del_doc(tmp/test.xml): document not found in database (1 such errors)! !ERROR: interpret_params: shred_doc_base(param 1): evaluation error.". Maybe this is because the document is not shredded in an ordinary way, however I do not know of any other function that can insert documents without a physical location. If someone could help me to delete these documents, or point me to another way of inserting documents without a physical location (, or show me the stupid mistake I made :) ), this would be very much appreciated. Best regards, Arthur The module looks as follows: ========================== module namespace cq = "http://db.cs.utwente.nl/cq#"; declare updating function cq:PUT($uri as xs:string, $doc as element()) { if (substring($uri, 1,4) = 'tmp/') then put($doc, $uri) else error('PUT: only relative URIs starting with tmp/ allowed') }; declare function cq:GET($uri as xs:string) { doc($uri) }; declare document management function cq:DELETE($uri as xs:string) { if (substring($uri, 1,4) = 'tmp/') then pf:del-doc($uri) else error('DELETE: only relative URIs starting with tmp/ allowed') }; ========================== The three test files look as follows: ========================== import module namespace cq = "http://db.cs.utwente.nl/cq#" at "/home/db/bunninge/phd/implementation/xquery/try3_module/ca_module.xq"; cq:PUT("tmp/test.xml",<bla/>) ========================== import module namespace cq = "http://db.cs.utwente.nl/cq#" at "/home/db/bunninge/phd/implementation/xquery/try3_module/ca_module.xq"; cq:GET("tmp/test.xml") ========================== import module namespace cq = "http://db.cs.utwente.nl/cq#" at "/home/db/bunninge/phd/implementation/xquery/try3_module/ca_module.xq"; cq:DELETE("tmp/test.xml")

2 3

[MonetDB-users] □■monetdb-users@lists.sourceforge.net様あて
by ★交際 08 Mar '07

08 Mar '07

monetdb-users(a)lists.sourceforge.xn--net-fc2g 貴方様に好条件のお相手が見つかりました。今回特別に検索結果とともに以下の優待が受けられます。 (1)秘密交際を望む男性には女性を、女性には男性を、それぞれの希望で、　　アプローチを受けていただくかどうかを選択できます。 (2)検索条件にあった方にだけの特別優待です。これを受け取った方にだけに　　優先権利があります。 (3)お相手の方に、貴方様への連絡用メールアドレスをお渡ししています。　　期限付きですが、直接にお相手からのメールを受け取ることができます。 http://www.minamiego.com/rm1120 無料参加型ですから、お気軽に女性または男性のお誘いをお受け下さい。秘密募集の特別優待の件ということで、通常よりもお話が順調に進むかと思います。それでは、でお二人だけの時間をお過ごし下さい。 >>>>> 秘密交際募集掲示板サポート >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 　　優待案内(No.14870)をお送りしましたのは事務局担当、私、三浦、　　そして全国11拠点となった秘密交際クラブを宜しくお願いします。

1 0

[MonetDB-users] fedora core 5/6 compilation error
by Shahbaz 07 Mar '07

07 Mar '07

Here is another one: Last night I upgraded my Fedora Core 5 to Core 6 using yum fedora-release (I'll try again with a fresh install of Core 6 as soon as I get a chance). My machine is a dual AMD 64 bit. I ran the monetdb-install.sh (version 1.7) with enable sql and xquery. While the actual log is probably too large for this post, here is the last part: ... cc1: warnings being treated as errors mal_authorize.mx: In function 'AUTHcheckCredentials': mal_authorize.mx:290: warning: 'pwd' may be used uninitialized in this function mal_authorize.mx:291: warning: 'hash' may be used uninitialized in this function make[5]: *** [libmal_la-mal_authorize.lo] Error 1 make[5]: *** Waiting for unfinished jobs.... make[5]: Leaving directory `/var/tmp/MonetDB-1173228480/MonetDB5-server/MonetDB5/src/mal' make[4]: Leaving directory `/var/tmp/MonetDB-1173228480/MonetDB5-server/MonetDB5/src/mal' make[3]: Leaving directory `/var/tmp/MonetDB-1173228480/MonetDB5-server/MonetDB5/src' make[4]: *** [all] Error 2 make[3]: *** [all-recursive] Error 1 make[2]: *** [all] Error 2 make[2]: Leaving directory `/var/tmp/MonetDB-1173228480/MonetDB5-server/MonetDB5/src' make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 make[1]: Leaving directory `/var/tmp/MonetDB-1173228480/MonetDB5-server/MonetDB5' making MonetDB5-server failed Please refer to the full log at /var/tmp/MonetDB-1173228480/log Following is part of the message I receive after running ./mserver5: # MonetDB Server v5.0.0_beta1 # Copyright (c) 1993-2007 CWI, all rights reserved # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked # dbname:demo # Visit http://monetdb.cwi.nl/ for further information #WARNING: LoaderException:loadLibrary:mserver: loader error /home/shahbaz/MonetDB/lib/MonetDB5/lib/lib_mserver.so: undefined symbol: stream_wstream_nohandshake #WARNING: LoaderException:loadLibrary:mserver: loader error /home/shahbaz/MonetDB/lib/MonetDB5/lib/lib_mserver.so: undefined symbol: stream_wstream_nohandshake !MALException:MAL.getAddress:address of 'mserver.SERVERlisten_default' not found !MALException:MAL.getAddress:address of 'mserver.SERVERlisten_port' not found !MALException:MAL.getAddress:address of 'mserver.SERVERlisten2' not found !MALException:MAL.getAddress:address of 'mserver.SERVERlisten3' not found !MALException:MAL.getAddress:address of 'mserver.SERVERlistenSSL' not found !MALException:MAL.getAddress:address of 'mserver.SERVERstop' not found !MALException:MAL.getAddress:address of 'mserver.SERVERsuspend' not found !MALException:MAL.getAddress:address of 'mserver.SERVERresume' not found !MALException:MAL.getAddress:address of 'mserver.SERVERclient' not found ... ... !MALException:MAL.getAddress:address of 'mserver.SERVERmapi_rpc_single_row' not found !MALException:MAL.getAddress:address of 'mserver.SERVERmapi_rpc_bat' not found !MALException:MAL.getAddress:address of 'mserver.SERVERquery' not found !MALException:MAL.getAddress:address of 'mserver.SERVERbindBAT' not found !MALException:MAL.getAddress:address of 'mserver.SERVERbindBAT' not found !MALException:MAL.getAddress:address of 'mserver.SERVERbindBAT' not found !TypeException:user.main[47]:'mserver.listen' undefined in: _46:int := mserver.listen() !FATAL: Failed to initialise system

1 0

Re: [MonetDB-users] Basic: XQUERY
by Yogesh Sudhir Dandawate 06 Mar '07

06 Mar '07

MONETDB: XQUERY Problem : I am able to shred documents using shred_doc command. I am not able to get control of the shredded document using xmldb/monetdb java API. 1. Can you please let me know the procedure to do so? 2. Where does the DB actually reside? Thanks in ADVANCE Thanks & Best Regards, Yogesh Sudhir Dandawate Software Engineering & Technology Labs | Infosys Technologies Ltd. | Rajiv Gandhi Infotech Park | Phase I | Hinjewadi | Pune | 411057| * Direct: +9120 22978264 * Mobile:+91 9881126868 * Email: yogesh_dandawate(a)infosys.com <mailto:yogesh_dandawate@infosys.com> **************** CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***

1 0

[MonetDB-users] Aggressive Investors Alert
by Disk 06 Mar '07

06 Mar '07

1 0