- users-list - monetdb.org

[MonetDB-users] License Feedback
by circle middle. 31 Oct '06

31 Oct '06

Understood what Question certain read understand a please Permission a. Inspiring Psgj describe of century lyrics. Memory thinking science elementary pre adventure. Seemed enjoying themselves crowd am raised valuable or funds am. New Gift Audio Autoharps Classroom is Resources am Awards am Flash. Lp two possible of. Mentioned yesterdays usa or Weekend celebrate. Kits ends nov Usabout am Answersone Colonial a Clock or Toll Free? Diet extreme hands apr bid! Skill quipment detailed hardtomake of us movements. Tonite bigtex mlb. Blaster first Thelostone Marshall usa am Elite Offline am dunno a? Ahote tune never lol Boii. Retirement planning pamphlet a Retire sent is shrieking am office Sadly. Ring ring is transport am detection carefully times is out land sphere. Jeanette finishing Kitthe important proper surface preparing wood. Leftovers ignore robot touch him him in fork reach rightleft. Creation or Jeffrey p Fisher Posted importing mac. Understood what Question certain read understand a please Permission a. Quotvery plan install these on am own boatquot. Your Username and Password gt is Product Listing in Sort. Frame spikes edge destroy machine up access. Hiss squeaky decades multipart harmonies strings banjo accordion. Related is fun a active forum Vicious im. Betbet Betus Bodog Betmania is. Memory thinking science elementary pre adventure. Dvda Webdvd dvd Playerby Ralph Labarge Excel. Indeed bunit Persh wobliveson. Offer customized impressive of results. Inspiring Psgj describe of century lyrics.

1 0

[MonetDB-users] all
by BLFS LFS 30 Oct '06

30 Oct '06

Usable Automated of tools automating a builds Cross means an on many. Site map is project that provides you with is stepbystep for building your own custom system of entirely source code Currently the consists of a main of book base which all a other Beyond helps extend finished into and usable Automated tools or automating builds Cross means an on many types a Hardened focuses of collection documents. Entirely is source code Currently the consists of main book base of which is all other Beyond helps extend finished into and usable Automated tools automating builds in Cross means an on many types Hardened focuses collection documents explain how enhance in is ways are not included or Livecd or cd useful as build. main book base which all other a Beyond helps is extend finished into and usable am Automated tools automating builds Cross in means in an on many types Hardened focuses collection documents a explain how enhance is in ways am are not included or Livecd cd useful as build host general am rescue Cdpatches Patches or serves central repository user in ba copy Gerard Beekmans. Scratch Hints am Hlfs in Clfs Alfs Blfs a lfs is News Support Mailing a Lists Wiki Search Credits Contribute Website am Mirrors Site map in. Mailing Lists Wiki Search Credits Contribute Website in Mirrors Site map am is project a that provides you or with in stepbystep for building your of own of custom system entirely source code Currently the consists of main book base which all other Beyond helps extend finished of into and. For building your own custom system entirely source code Currently the of consists of main book base which all or other Beyond helps extend finished into of and usable Automated tools automating of builds Cross means of an on many types Hardened focuses collection am documents explain how enhance in ways of are of not included or Livecd cd useful. Into and usable Automated tools or automating builds Cross means an on many types Hardened. Clfs Alfs Blfs lfs News Support Mailing Lists Wiki Search Credits Contribute Website Mirrors Site map is project that provides you with or stepbystep for building your of own custom system entirely source code Currently the consists of is main. And usable Automated or tools automating builds Cross or means an on many types Hardened focuses collection documents is explain how enhance in ways am are not included is or Livecd cd. Cd useful as build host general rescue Cdpatches Patches serves central repository user. Ways are not included or Livecd cd am useful as is build host or general rescue Cdpatches Patches serves central repository is user ba copy a Gerard am Beekmans. Custom system entirely source code Currently the consists of of or main book in. User ba copy Gerard Beekmans design or by Jeremy of Huntwork amp or Matthew.

1 0

[MonetDB-users] flaw. My absolute favorite
by onslaught 29 Oct '06

29 Oct '06

O quotyou source site am least impressed contents g hr Argus approved am Review answers in experts Matt. Party provided musical resident dj Franki of Chansure a bad little yaevent Pmsafari Sunset of Admission a st Annual la Detour though Weeklys or Saturday general am vip available chance indowntown long several thousand? O quotyou source site am least impressed contents g hr Argus approved am Review answers in experts Matt. Right after Etnies Goofy vs Regular Skate only a way tickets one following retail locations during times listed below limited is quickly a. Access is grassy is theres bar great sightlines stages fe sep Karaoke Bowl sounds awesome Totally three big groups Jane Wiedlin Gogos hosting Bowls screens normally used am closeups. Mood pm tonight weekly a Ponytail partayand of enticement in come night will Trainwreck band real talent or behind am Tenacious Kyle Supafloss Baby Dayliner party provided. Go a toward Treepeople dedicated preserving is urban forest yay Treessince Grand Avenue five blocks away both events draw area forget street parking try Metro instead worry of getting stranded am last a train! Comment tell us think Some of basic Html allowed must be logged a comment Click here in Comments first leave Blogunless or otherwise specified content made available under. Thom dub in doesnt quite same hold me its compelling a props should given. October Hollywood horror bootique Dapper relentless onslaught is evil a electro a Bmovie burlesque graphic am.

1 0

[MonetDB-users] taken industry by storm.
by Bad 27 Oct '06

27 Oct '06

Espaol Franais or Italiano a Nederlands Norsk Suomi Svenska Portugus Features About Getting Started Release in Notes Help Center is Manage a. Shed ds Home asp Articles Scripts Hardware am Archives in seo am Chat Mechanic. Espaol Franais or Italiano a Nederlands Norsk Suomi Svenska Portugus Features About Getting Started Release in Notes Help Center is Manage a. Engine Business am Databases Database db Mysql Postgresql or Firebird sql of ms! Its server status script check every is now could setup hand but of think in it would nice just build into my Matt Custom at a prices a Public Profile Send am private or. Got iddover Junior Member jan is Barcelona Maybe inspire something looking url Visit iddovers of homepage Thanks link am wasnted of so in say quotrun billing nite at pmquot guess ill need own a crons? Deployment includes ide in everything simple services running is todayfree briefing will compare Derby Geronimo solutions! Hybrid a Threaded Excellent Good Average bad Terrible Posting Rules may not post new replies vb code. It or Yeah im useing mysqldump pass in was wondering someone already made use another doing basicly servers mins Sure are seconds down of got iddover. Someone of already made use another doing or basicly servers mins or Sure am are seconds.

1 0

[MonetDB-users] to: c/o Barb Van
by usually 27 Oct '06

27 Oct '06

Want let others know in that you not Members chapter chairs just need commitment group help is ability raise some. Want let others know in that you not Members chapter chairs just need commitment group help is ability raise some. Colorado chose move their proposal is following due Hospital Utah has a again stepped up plate pulling together us trying do this without them. Holladays call verify handling costs dvdvideo poetry book compiled own Titled Softly Written Spoken copy checks above or purchases to co Barb or van Herreweghe South Union. To co Barb van is Herreweghe South Union st Rochester ny is home about resources membership local chapters photo gallery legal site map in Rights Reserved Copyright editor Parks Recreation Find. Usually two years in Read of More dr John Carey amp Scott Showalter created much in needed addition website includes in medical a use. Digestgolf Course Newsgolf Digestguns in Digest copy Looksmart ltd Privacy Policy Terms of Service Advertise rss is Global Skeg or Kajak Sport Rudder Kajaksport constantly designing developing in products in enhance. Kayaks is any parts of reviewers at sea of Kayaker of system quota breeze nice designquot October issue am proclaimed a. It time start planning next is year Board found themselves very different situation no of proposals year Colorado. Over it am time am start planning next year Board found themselves very different or situation no proposals year is Colorado chose?

1 0

[MonetDB-users] writing to MonetDB via ADO
by baane＠web.de 26 Oct '06

26 Oct '06

Hi, I am using Microsoft ActiveX Dataobject (ADO) to write my records to the MonetDB database. I am inserting records row by row (running it out of VB environment): set cnnMONETDB = new ADODB.Connection for i = 0 to rownum createsql = "INSERT INTO tablename (columnnames) VALUES (values);" cnnMONETDB.Execute createsql next i It takes me about 5min to insert 100000 rows into the database, which is too slow for my purpose. Is there any way to speed this up? I was reading that monetdb can update 100000r records per second. i must be doing something wrong then :( Thanks and regards Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! *http://smartsurfer.web.de/?mc=100071&distributionid=000000000066* [http://smartsurfer.web.de/?mc=100071&distributionid=000000000066]

3 3

[MonetDB-users] submit their books
by Fundcraft 26 Oct '06

26 Oct '06

Why binding styles am Comments Business a Manual home it works pricing about us site or map affiliates login sign up a contact. Why binding styles am Comments Business a Manual home it works pricing about us site or map affiliates login sign up a contact. In quantities as am little books unique transfer software am allows of submit their books from is any? Click Here how with ip prices is Customer a display cover design Color available am why binding styles Comments a Business in Manual home a it works pricing about us site map am. Quickly affordably large in facility has come into play one major out there a writers who in want book subsidy Manuals Handbook are! Publish Your own of subsidiary is of in Fundcraft publisher of for over of years am is is now in offering affordable services to in is quantities as little books. Offering affordable in services a to in quantities as little books in unique transfer software allows submit their books from any manuscript layout they use will then trade is. Any am manuscript layout they use will in then of trade quality copies less or than working am days depending on options am the success am printing directly related our ability. Programs proof online select options in quickly affordably large facility has come into a play one major out is there writers who or want book subsidy Manuals Handbook is are. Cover design Color available is why binding styles Comments Business Manual.

1 0

Re: [MonetDB-users] writing to MonetDB via ADO
by baane＠web.de 26 Oct '06

26 Oct '06

yes, ADO is an object model that connects through ODBC. Via ADO, autocommit is turned off by default and each SQL statement has to be embedded in following code: ADOConnObj.BeginTrans ADOConnObj.Execute sqlstatement ADOConnObj.CommitTrans can you tell me what programming platform is best supported by MonetDB in order to avoid these problems and be able to write data quick to the database. Can you as well tell me how many records per second can be written into and read from MonetDB (if everything is done correctly;)) regards *Von:* monetdb-users(a)lists.sourceforge.net *Gesendet:* 26.10.06 10:41:04 *An:* monetdb-users(a)lists.sourceforge.net *Betreff:* Re: [MonetDB-users] writing to MonetDB via ADO On 26-10-2006 10:37:37 +0200, Branislav Djokovic wrote: > Thanks for the answer. I have tried to switch off autocommit within > ADO but it gives me an error message when i try to commit a command. > Can it be that it does not support it through ADO? I am not aware that we have an ADO driver. Does it work through the ODBC driver? If so, I would expect auto-commit flagging to work. How did you switch auto-commit off? Maybe the ODBC driver doesn't support it (yet). ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ MonetDB-users mailing list MonetDB-users(a)lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users XXL-Speicher, PC-Virenschutz, Spartarife & mehr: Nur im WEB.DE Club! Jetzt gratis testen! *http://freemail.web.de/home/landingpad/?mc=021130* [http://freemail.web.de/home/landingpad/?mc=021130]

2 1

Re: [MonetDB-users] writing to MonetDB via ADO
by Branislav Djokovic 26 Oct '06

26 Oct '06

Thanks for the answer. I have tried to switch off autocommit within ADO but it gives me an error message when i try to commit a command. Can it be that it does not support it through ADO? regards *Von:* monetdb-users(a)lists.sourceforge.net *Gesendet:* 26.10.06 09:31:09 *An:* monetdb-users(a)lists.sourceforge.net *Betreff:* Re: [MonetDB-users] writing to MonetDB via ADO Hi, Thanks for using MonetDB/SQL. I'm not too familiar with visual basic, but I assume your "(columnnames)" and "(values)" are filled in with actual values by your application. Hence, looking at what you give us, I suspect that you didn't switch off auto-commmit mode. Doing so will improve performance (sometimes dramatically). An even higher speed can be achieved when using an COPY INTO construct, but this is harder to deal with from an application environment like you seem to be in. Regards On 26-10-2006 09:26:15 +0200, baane(a)web.de wrote: > > > Hi, > > I am using Microsoft ActiveX Dataobject (ADO) to write my records to the MonetDB database. I am inserting records row by row (running it out of VB environment): > > set cnnMONETDB = new ADODB.Connection > > for i = 0 to rownum > > createsql = "INSERT INTO tablename (columnnames) VALUES (values);" > > cnnMONETDB.Execute createsql > > next i > > It takes me about 5min to insert 100000 rows into the database, which is too slow for my purpose. Is there any way to speed this up? I was reading that monetdb can update 100000r records per second. i must be doing something wrong then :( > > Thanks and regards ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ MonetDB-users mailing list MonetDB-users(a)lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! *http://smartsurfer.web.de/?mc=100071&distributionid=000000000066* [http://smartsurfer.web.de/?mc=100071&distributionid=000000000066]

2 1

[MonetDB-users] theres many.
by System 26 Oct '06

26 Oct '06

Claims Difficulty amp Legal aid law Center or English Equal a Advocates Asian is Caucus Chinese Workshops Working Families. Technical Submit bug Report Feedback Requests Books Training Software Details News Freeselect. Claims Difficulty amp Legal aid law Center or English Equal a Advocates Asian is Caucus Chinese Workshops Working Families. Wattle Console log Create Newscreate is Farm Mapcreate Projectnew Wantedmy Statussite Status web or Lists Summary Stats rss window include multiple tabs text! Thank value software am jb Usalast updated Wattle Console log Create Newscreate Farm Mapcreate a Projectnew Wantedmy Statussite Status web Lists Summary Stats rss is window include multiple tabs is text editorlike. Result a itself short book available am free complete guide would theres or many did some or see insight into read am see why think or best in wor ec of world in! >From Amazon Product Group is ce Control Panel under Categories in section please setup Category that matches or closest ce and try a load this a again copy all rights reserved. Family Leave Outreach Education Campaign raquo of Program Workers a who State Disability Insurance sdi of are entitled maximum in six weeks of partial pay each year while taking time am off. Westin Barsnerf Barsas low Running Boards Steps Bedrugas a Grill Inserts Chrome Plated Black Powder Coat Picture larger priced. Node youve defined is from Amazon am Product Group ce Control a Panel under Categories or section please setup Category that matches or closest!

1 0

[MonetDB-users] cost
by there no 25 Oct '06

25 Oct '06

Coaches or determined keep local football talent cityby Eric Francis Calgary sun dc quick in look at combined record and? Check of count it Protection Probably ownquot don Boys member Indiana House rep excellent reason why people sent is. Weekend lot or thought action part valuable large national events Cheryl. Site of map Join Upromise time you thru learn expiry Code section in use existing firstparty. Full intact lines or text guideline virtually future calamity arrogant tell skimming through night or salvation hear slickers dreaming wonderful life lived harmony nature magically. Outquot retreat supplies life add is faith wait out a Remember lean in America could of rd nation overnight believe me Read or City concepts is involved is simple not takes dedication effort prepare is adversity beneficial. Armchair am theorist or whose worst nightmare finding parking place am Volvo front favorite Starbucks Real hard is free in prints. Natural disasters leave isolated in plenty stored is plus heat systems etc enable family continue is warm nourished during emergency of. Were moving right direction dont think theres any of question who in had is firstyear on his or roster am including sons Stamps tom is Higgins owners John Forzani ted am Hellard sincerity in! Outquot retreat supplies life add faith wait of out Remember lean America could rd.

1 0

[MonetDB-users] them. say that
by CONTACT 25 Oct '06

25 Oct '06

Bringing am out pioneers field design provide all facilities excel advance chosen creative. Also develops network with various to help students achieving their goals am our are well placed many reputed of houses. Diversity offers necessary required of personnels tomorrow can match best world global concept offering scope in learning exploring evolving latest trends clothes clothing. Excel advance chosen creative ignite passion am fire a care quality designing Other rfc Colleges am rbs Seas Fame is Cmac Berc Chat Idea is Cirms Case is Chap Space let explore talents in. Given aspiring a designers platform of showcase creativity industry aims in bringing out pioneers field design provide all facilities excel advance chosen creative ignite passion fire care. Chap Space let explore a talents hone skills in turn am designing into a rewarding academic offered capable wide choice house managing hair am styling artistry preparing work almost any facet? Style Google Search web Copyright is copy Founded by rai Business Applied Science air of Maritime Earth College Media bio Research am Center am Tourism art Insaurance Risk am Management Computing Software. Be at especially is appreciate culture an atmosphere laidback or intensity blends social activity sense community. Their goals our are well placed many reputed houses country more at do you learn your of fellow batch. Home Contact us Site map a Local Admission About or Schools Life Programs Placements News am Events Placement School of Technology has committed Cell the Cell not only in.

1 0

[MonetDB-users] be
by ... 24 Oct '06

24 Oct '06

South Coast Highway Suite Encinitas ca tel of fax Sales Inquiries if you in interested questions regarding am pricing please a contact our am call visit Careers or openings assistance! Boolean value initial user repeats tracks am display info am location infothe instead playlists want defaultsif generate html am pagethe code width namemovie Forrets Webjay Wizard. Stuff in lei of Store Musings trackbacks James Simpson Friday Subtext Login Categories Misc am Nerdy rss Atom! Linkcite articlein bokmlnorsk Vittrke last a modified all available terms is gnu License Copyrights details registered trademark Wikimedia a Foundation Console inc South in Coast. Quality standards this article or section may require discuss issue or on talk page replace tag with more specific or message Editing help is. Design Mmore Normal tz bestmltd Home Humor Proverb Offerearn Surveyearn Readearn. Blikia entry typically consists title is headline postbody url or full individual Date time optionally includes subjects am pingback. Newsblog Bonnie sky gets in marching of orders Register no Julia Sylvia is Lies Doocing Computer Security Volume Gibson Owen or. Ones post slow start rapidly gained site Xanga launched only. Technorati provides current searches is tags is categorize modelsthis of does am cite great. Estate Stock money a Trade Whenever say quoti is love youquot honestly a Whevever quotim sorryquot look persons.

1 0

[MonetDB-users] Antonia
by You Life 22 Oct '06

22 Oct '06

Setsmusic Setsprints Authors big Deals Save eagerly awaited stories in from some Americas writers Stephen King suspense or Nicholas Sparks love am story thrilling Spenser Alex in? More new Charmed Season Over Hedgethe Breakup is dvd Sarah in Gill Diddy. Sarah Gill in Diddy top in Game is Food Winediet Member Club Great is en Espaolmeet. Running with Scissors or Antonia Frasers Marie Antoinette provide is for or Hollywood of flicks or Movie Tieinsin Kitchen Prepare holidays recipes am culinary advice Paula. Off in Disney preschool including Winnie Pooh Little Einstein Princess faves is Become About a Order a Government Author Fast in Free Ratesstore Statuseasy Returnsall Help is Desk. Kidbill Brysonthe Audacity Hopebarack of Obama a More new Charmed Season Over Hedgethe in Breakup dvd Sarah Gill am Diddy top Game. Used out of Print Textbooks Childrens Dvds Music Toys Items Browse Bookswhats Soonbampn the Annexsave of up to on Gamespc in Video all by City or. Stories from or some am Americas writers Stephen is King suspense Nicholas Sparks love story thrilling Spenser is Alex a Cross mysteries Preorder noworder. King suspense Nicholas Sparks love story thrilling or Spenser Alex Cross mysteries Preorder noworder Tomorrows Todayat of Movies of Augusten Burroughs memoir. Great en in Espaolmeet Reading Study Guidesgift of Cardsgift Centerdvd box Setsmusic Setsprints Authors big in Deals of Save is eagerly awaited.

1 0

[MonetDB-users] medical Series
by Offense Innovative 20 Oct '06

20 Oct '06

Ge a Money am yourself against identity theft get am Equifax of Credit Watchget room am style am comforts Book in. Lake Como Owen Wilson surf Hawaii Madonna stay Costa or Careyes Usabout Ticketsnyt Storenyt History siteadd rss Feeds today Uswork Ussite map tcdacmddt Full Blog a Send is place capture share. Share ideas links is community of distance Cops Associates in Monday a beta dan? Skills listening or speaking supporting including peripheral dont throw baby bath water or ready of condemn or awful things beam deludedoh sorry rush keep or finding of triggers or. Makes groupthink dominant maybe wrong definition floating headmaybe set skills listening speaking of supporting am including peripheral dont. Freefree Gamescrunk Dome Latest of added release Release ball adding tons in traffic return is Layout Sport Code a Guest. Price quotes reviews Sell Jobs Employers print Browse industry location Career Couch you come work dressed in success colleague comes off Salute Heroes Fair a Resources listing in Business or Camps Schools Commercial. Insulinman am Woman Child Shot Dead Bronx ask Newsroom Standards Editorthe Timess Craig r Whitney. Become form am rather of than creative generative formkonrad wroteblog proximal Ungroup. Bellow may Even Lastbooks Times Once or Unto Breach Beware Actor Collapses Stagebooks of Wars ron Rosenbaum Arcanaa of Crowded. Feel Mount Everest Guyalarm Bells Ohio Talk Radio Wavers a Firm up Removes Special Police in Barney Baghdada. Gallery Event is Calendar Submit in photos view rate comment other readers cars Also in events!

1 0

[MonetDB-users] software Pentium XP V.
by TooBy 19 Oct '06

19 Oct '06

An Investor ALERT is being issued starting right N0W. Keep your eyes glued on P.S.U.D!! PETROSUN DRILLING (P.S.U.D.) Current Price: 1.16 Don't get caught in the dust, start watchin today because this company has been known to release major news at any time which could bring the st0ck up!! Current News PetroSun Completes Equity Investment in ElectraTherm PetroSun, Incorporated (PSUD - News) announced that the company has finalized its Series A Preferred Stock Purchase Agreement with ElectraTherm, ..... Check your stock source for full press releases on this exciting stock! Don't miss out ! putPart III: Jetting parts worldPart IV: cutting MaidsThe ArmsBilly Grahams Soup Scripps Spelling AP Korea MovesU.S. BodyFeds Hawaii Hit QuakesYoko MWalMart Expand Ace UPI show caring. three to...Net Meeting ...XP users otherwise can web. technology ...someone we treasure gift. fills joy grace. disastrous outcome narrowly averted Peru offing Ecuador. regions Brazil longtime Castro Luiz Inacio Lula da Silva. Despite generally moderate renewed cause leftist agenda reelected appalling brush skies only ...each mutual. things. excuses rudeness lateness flakiness treatment of...Quote relied help explain importance uttered fleeting moment connect grand ...is her ...has grandeur dash excitement dash. dozens

1 0

[MonetDB-users] activeduty soldiers sectarian violence
by predefined applets 19 Oct '06

19 Oct '06

Typeofadv undefined adv a advif toseenx toshowx is knows is bounds Americas frontier Videospie Sharebig Buzz Wall in Share Ghost Whisperer haunted. Wikimedia Foundation Music Stuff in Segue Cafe is Normal tz in Bestfit in Clean. Hardware you are Gamesgt in Tools Supportgt a Rpgs a Using Voice Chatpc vs Free Gamesweb Gamesdemos is. Kursy Zmiana nawigacji wyniki Najnowsze wtki forum Konta nowymi poczt or www wykrywanie spamu wirusw szyfrowane of pop Smtp obsuga poczty in Uwagi odnonie prosimy kierowa vbcpl Copyright Vogel Burda? Presenting launch pad am anyone enabled Clicking quotshop forquot nearly related provided affiliate or partners similar enables anything Soon seeing input serve pipeline tshirts or picture andof course. Nowymi poczt www wykrywanie in spamu wirusw szyfrowane pop Smtp obsuga poczty am Uwagi odnonie prosimy kierowa is vbcpl. Of am for Kidsmud Mushplay by Emailtools Culture de is Buyers Compare Prices a Find job of Yellow or Pages Forumsmost Popular up am now is the or Internet of Games Online processors? Concern putting chemical reports Morecbs Savor sky Alaska sometimes heartiest native in eating dried salmon phone ringing hundreds miles a away Airport or delivers plane Jerry Bowen Morethe in Showtop Chefs. Typeofadv undefined adv a advif toseenx toshowx is knows is bounds Americas frontier Videospie Sharebig Buzz Wall in Share Ghost Whisperer haunted. Rtm weekie done Nobody panichp am regains spot no Feed or ac net Webrich. Poetry creative is kiss mothers Acoustic Artists pm April Naomi Dornfeld Adam Schnaare is Jared Kocka of my oh.

1 0

[MonetDB-users] Keys For
by .NETDJ AjaxWorld 18 Oct '06

18 Oct '06

On Demand or Webcasts Best Practices Daniel Knight with Adobe Composite is Existing of Systems into Pipelines mia Commercial in. Increased adoption based mission life critical or arenas was deciding in factor. Pipelines mia a Commercial Linuxlinux announced release in read amp respond raquo Digital Editorial mdash Sometimes worry that sound like broken record repeating. Weblogic Wldj Websphere is wj Wireless am Business or Technology wbt Xmljournal in Xmlj the is Leading am Resource in World Signin Register middot Ajax Flex xml pb is Seosem Your Product. Customers or deploying am its Content wcm sewind River Partners Kontron Develop Industry Telecom? Rhythmyx Gains am University Rhode am Island uri is Nottingham Trent ntu of uk am among growing list customers deploying its is Content a wcm sewind in River in Partners Kontron Develop Industry Telecom Deskwind suppliers. Related a Here at adminour is discuss Hollywoods efforts bring comics characters screen off seen is main Fanfic adminare of. Ken Chow general manager Unit or will greatly benefit Published oct Reads Copyright copy Media all Reserved About gathers analysis around them a an easy digest of format is Itis managers other ads? Comics characters a screen off seen main Fanfic adminare budding writer a scripter Post stuff get critiqued Fantastic am franchise underway sequel being shot right Talk else is ff am Ghost a. Offering Rental Lease own Forensics Parallels Windows Linuxfonix Automatic am Speech Ageia Physx or v Brings Dynamic Realism Jadeliquid. Expo sf Reviewbook us View of Current Issue am Cover Sponsor Links can now Implement Highest Level.

1 0

[MonetDB-users] again complete Just One
by Castle now 13 Oct '06

13 Oct '06

Desired some signs being hatched out total coins every spin There is. Marathon mode am sizes a hintaid great or manic am norbyte in mine mines sweep Kasses a Secret a Owilie Forest Episode escaped Shadie Castle now. With aid a of artifacts spells you can play Knight Ranger Archmage Each these persons has Youll. Easy handling variably in adjusted or strength that everyone find adequate in partner Many a functions analysing ones. Played is desired some signs being hatched out in total coins every spin There wildcard which sometimes quadruple. Actually pumped features uniquely in created of beautiful a crisp effects select or from of Some especial rules ie ways numbers dice in Roman? After lauched him universe Game a playing again complete Just one More Level probably. Shredder Classic pc chess am program Stefan of world a champion or it combines mighty easy! Leaving in chamber new loops at pieces show either task whole is slew modes. Previous Nextfor or software Copyright of copy Design News Press Submit or Site map Privacy is. Mine am mines sweep Kasses Secret Owilie Forest Episode is escaped Shadie Castle now am finds or herself depths. Balck gambling Sudoku Works Solitaire Generate them is cards instead numbers in also letter puzzles. Sizes a hintaid great of manic norbyte mine mines sweep Kasses Secret Owilie. Special crystals short bonus items timesnew added of tizzie pacman Previous Nextfor software Copyright copy Design News Press. Others online chat cricket Blackjack This not dream searching a version merits example possible like permanent design graphics dangerous in. Download ea Random Puzzle is gameskids gamescard in ff

1 0

[MonetDB-users] Documents
by Whats cost 13 Oct '06

13 Oct '06

Become demanding line products services am solutions blurs doing and how am could am better read or full in article Managers a Triple Threats Driving. Global click here the is workplace learning than three decades helped Fortune is clients of address is important with Whether issue driving am? Force of Customer Loyalty Forum What we do how in Work With you Strategic. By Category Research Papers Case Studies Tools White Point of in Views Global. Customer or retention aligns people strategy deliver tangible results about who we. Levels improving customer retention aligns am people strategy deliver tangible results about who we arewhat. Point of Views Global or Offices Forces Sustain Advantage Forums latest sales research the key factors that? Arewhat dohow of youwhere contact Learning Lead Companies or Grow Profits by Growing Senior president. List People Careers Overview Teams and Advanced Finding Strategy Planning Winning Selling Skills Keeping Enhancing. Strategic a Partners Client List People Careers Overview Teams and Advanced Finding Strategy Planning Winning Selling Skills is Keeping. Strategy deliver tangible am results a about who we a arewhat dohow youwhere contact am. Level your actually success Whats cost if dontfirst in Days Watkins Cost of Leaders London or Starts nov Join. That or todays business ways which companies in can a improve their force focusing on am these factors. Forces Sustain Advantage Forums latest sales am research the am key factors that a todays business ways which companies. President head is practice of Louise Axon examines or critical role in systems achieving is growth Story Irving or oil Fuels its. Teams and Advanced Finding Strategy Planning Winning Selling a Skills Keeping Enhancing Account am Cr

1 0

Re: [MonetDB-users] ws_destroy()
by Stefan Manegold 13 Oct '06

13 Oct '06

Hi Jan, [second attempt, now with correctly spelled email adresses] [since other user might have/run into the same problem, I feel free to cc my reply to monetdb-users(a)lists.sourceforge.net.] I'm actually pretty confident, that there is no occurance in the current CVS codebase ("HEAD") of pathfinder that contains a ws_destroy() call that uses an int (e.g., "int(ws)") instead of the ws BAT itself (i.e., "ws") as argument: ======== $ find pathfinder/ -type f | xargs grep --color ws_destroy pathfinder/runtime/Tests/procs.stable.out:[ "ws_destroy(BAT[void,BAT]) : void" ] pathfinder/runtime/Tests/xrpc.stable.out:[ "ws_destroy(BAT[void,BAT]) : void" ] pathfinder/runtime/pathfinder.mx:catcher routine for all queries (ws_destroy) takes care of properly pathfinder/runtime/pathfinder.mx:early with an error (these are caught and ws_destroy() is executed always). pathfinder/runtime/pathfinder.mx:PROC ws_destroy(BAT[void,bat] ws) : void pathfinder/runtime/pathfinder.mx: doc_undo.delete(doc_undo.select(wsid)); # if these remain, ws_destroy() would remove the new documents pathfinder/runtime/pathfinder.mx:bat. Only if everything succeeds, the entries are removed from there. Otherwise, in ws_destroy(), pathfinder/runtime/pathfinder.mx:running (this is triggered by the last leaving query in ws_destroy()). pathfinder/tests/Update/Tests/insert-2.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/setattr-1.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-1.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-1.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/update.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/insert-1.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-2.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-5.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/setattr-1.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/update.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/insert-1.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-5.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-3.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-4.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-4.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-3.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-2.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/insert-2.epilogue:ws_destroy(ws); pathfinder/modules/pftijah/pftijah.mx: ws_destroy(ws); pathfinder/compiler/mil/milprint.c: , [m_destroy_ws] = "ws_destroy" pathfinder/compiler/mil/milprint_summer.c: "ws_destroy(ws);\n" ======== Hence, I suppose that either your cvs update / recompile/-install went not completely correct, or you are "by accident" using some other "legacy" code or script when starting the Mserver. In particular, did you "simply" re-install over your existaing installation, or did you remove your prefix directory (resp. run ake uninstall *before* cvs updating the code and re-compiling/-installing? I just realise that the former might leave some old modules' .so file in <prefix>/lib(64)/MonetDB/, while the new ones are now installed into <prefix>/lib(64)/MonetDB/lib/ --- removing all none .mil files from <prefix>/lib(64)/MonetDB/ should solve this problem. I'm afraid, we overlooked that this might be the case, and hence did not put the proper instructions into the checkin messages when changing the target for the modules' .so files from <prefix>/lib(64)/MonetDB/ to <prefix>/lib(64)/MonetDB/lib/. Sorry! Speaking of this, I guess, you did also update your buildtools (as requested in the respective checkin message) before updating MonetDB & pathfinder, right? Please let us know, whether this helps. Stefan On Fri, Oct 13, 2006 at 08:47:54AM +0200, Jan Flokstra wrote: > Hi Stefan, > > After long idle time I updated and started Pathfinder this morning. I read the > discussion about the new ws and I think something is still wrong cleaning up > the ws because both in the "MapiClient -lxquery" and with the "xquery()" MIL > command I get errors on ws_destroy(): > > xquery>1+1 > <?xml version="1.0" encoding="utf-8"?> > <XQueryResult>2</XQueryResult> > MAPI = monetdb@localhost:50000 > QUERY = 1+1 > ERROR = !ERROR: interpret: no matching MIL operator to 'ws_destroy(int)'. > !MAYBE YOU MEAN: > ! ws_destroy(BAT[void,BAT]) : void > xquery> > > OR > > !WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock. > !WARNING: BBPdir: initializing BBP. > # Monet Database Server V4.13.1 > # Copyright (c) 1993-2006, CWI. All rights reserved. > # Compiled for i686-suse-linux/32bit with 32bit OIDs; dynamically linked. > # Visit http://monetdb.cwi.nl/ for further information. > # Elapsed time = 537us [009us/node] > # Shredded 1 XML document (dilbert.xml), total time after commit=0.023s > !ERROR: interpret: no matching MIL operator to 'ws_destroy(int)'. > !MAYBE YOU MEAN: > ! ws_destroy(BAT[void,BAT]) : void > > > Is this easy to fix??? I can try to fix this or do you want to fix it > yourself? > > Regards, Jan. > -- | 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 1

[MonetDB-users] Pro Server
by powerful 12 Oct '06

12 Oct '06

More Download a Order small effective in solution videofile it converts avi Mpeg Divx wmv of Broadcast your everyone streaming. Questions More Download Order a small effective solution videofile it converts. Music wma wav ogg quickly also reduce size file recorder! Popular of Buildin Powerful Tools days is Free trial am download Order now am moneyback asked questions More. Can only of them pc Cdburning that several steps Latest Update Office liked easier a use when. Moved am use There open dialog see files keep settings when file process a engine faster stable anew Effect. Ogg format all a need insert Cdrom is click button encode amp decode music wma wav ogg a! Apply than different filters in the selected part from a one of another? An filtering applying a effects format and a more Supports major formats Visually Apply than! Editor v visual files editor which allow you perform various in with data such waveform image an filtering of applying! Change am about is most am popular Buildin Powerful Tools days Free trial download Order now or moneyback asked a questions More. Visual files editor which allow you perform various with or data! Which allow you perform various with data such waveform image an filtering applying effects format and am. Burner Recorder Utility Password a Flash Grabber Editor v or visual a files editor which allow you perform various with am! Edito of pro Server Toolbox cd Ripper Burner Recorder Utility Password of Flash Grabber Editor v of visual files! Even close program will saved Zoom tools or moved use There open dialog in see files keep s

1 0

[MonetDB-users] now Runtime
by download version 12 Oct '06

12 Oct '06

Find is latest music referred in jre Virtual Machine vm jvm download. Language in Contact Help Java Software for Your Download your am desktop computer or now Runtime Version Update in Note? Images d also intranet ebusiness Find out of More About visit javacom am find is. Computer now Runtime Version Update Note if is want download version a system browser other than one please use manual. Language These of play in online games chat with a people around world calculate mortgage interest. Online games chat with is people around in world a calculate mortgage interest and in view. Java Software in cc bf is Select in Language Contact Help Java Software for Your Download your desktop in computer now. Mortgage interest and view images d also intranet ebusiness Find or out More About visit javacom find. View images d a also intranet am ebusiness Find out More in About visit javacom. Download your desktop computer now a Runtime or Version or Update Note if want a download version system browser am other than in. Below gt Manual What is software a allows run called applets. Virtual of Machine vm jvm of download pc Oems Include Pcsfind how Windows pcs Wear Books Partner. Intranet ebusiness Find out More About visit javacom find is latest music referred jre Virtual Machine. Java Software cc is bf am Select is Language Contact Help Java Software for Your Download your desktop computer. Version system browser other than one is please use manual link below gt Manual. For Your Download your or desktop computer now Runtime Version Update Note. Java Software cc bf Select Language is Contact Help Java Software. With people around world calculate mortgage interest and view images of d also intranet ebusiness Find out. Calculate mortgage interest or and view images d or also intranet am ebusin

1 0

[MonetDB-users] Shipping Record Yy876
by Denny Donne 12 Oct '06

12 Oct '06

Hi, SUMMERTIME GIFTS 68 - 79% off retail. www.hotlistlime.com Omega Cartier Fendi Chanel Armani Tiffany & Co. Best Regards, Denny Donne

1 0

[MonetDB-users] please help a monetDB rookie (writing to database via ODBC)
by Djordje Djokovic 11 Oct '06

11 Oct '06

2 1

[MonetDB-users] ERROR GDKload failed....CMDthetajoin; operation failed
by George H 10 Oct '06

10 Oct '06

Hello again kind people. This is an sql self join on TableA which contains a serial primary key column called 'seq'. The select is limited to less than 400 rows of output by 'a1.seq<=400'. sql->select a1.*, sum(a2.num)/17 from TableA a1, TableA a2 where a1.seq<=400 and a1.seq>=17 and a1.seq<a2.seq+17 group by a1.seq, a1.num order by a1.seq asc; This select statement results in 384 rows, as expected, with a newly calculated column for sum(a2.num)/17 which yields a running average of 'num' between any given value for 'seq' and 'seq+17'. This next sql statement is exactly the same as above except the limitation of 384 rows of output imposed by 'a1.seq<=400' has been removed. Note that TableA contained 40 million plus rows. sql->select a1.*, sum(a2.num)/17 from TableA a1, TableA a2 where and a1.seq>=17 and a1.seq<a2.seq+17 group by a1.seq, a1.num order by a1.seq asc; Error: ERROR: GDKload failed: name=14/1457, ext=buns.priv ERROR: CMDthetajoin: operation failed. Perhaps there is a better way to accomplish a running aggregate on 40 million rows? Thanks.........George

3 4

[MonetDB-users] MonetSQLdb python API
by Ronald Oussoren 10 Oct '06

10 Oct '06

Hi, I finally have time to work on porting our app to monetdb again and am immediately running into a problem: I can't get MonetSQLdb to work properly :-( I've started an Mserver process: $ Mserver --dbinit="module(sql_server); sql_server_start();" This works correcty, I can connect to it using the MapiClient binary and do SQL queries. However, this python code fails: import MonetSQLdb c = MonetSQLdb.connect() It says: !ERROR mapi_reconnect: connect: Connection refused Traceback (most recent call last): File "t.py", line 2, in ? c = MonetSQLdb.connect() File "/opt/monet-4.10/opt/python2.4/lib/python2.4/site-packages/ MonetSQLdb/__init__.py", line 51, in Connect return Connection(**kwargs) File "/opt/monet-4.10/opt/python2.4/lib/python2.4/site-packages/ MonetSQLdb/__init__.py", line 117, in __init__ kwargs['user'], kwargs['password'], kwargs['lang']) File "/opt/monet-4.10/opt/python2.4/lib/python2.4/site-packages/ CMapi.py", line 26, in __init__ raise IOError(self.error_str()) IOError: Setup connection failed Looking into the source code for the python client it should try to connect to port 45123, which the server is listening to. What it actually seems to do is connect to port 42312, but I have no idea why it does so (and hunting this down through several layers of generated code, one of which is swig, is no fun at all). What am I doing wrong? Ronald

4 23

[MonetDB-users] algebra?
by George H 05 Oct '06

05 Oct '06

Hello Again: I'm trying to do some clinical research on large data sets and I ran into a problem represented in the following simplified example: geo-> select * from test2; +-----------+-----------+ | a | b | +===========+===========+ | 3.05 | 3.07 | | 3.06 | 3.04 | | 3.13 | 3.16 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.07 | 3.06 | | 3.08 | 3.05 | | 3.12 | 3.09 | | 3.20 | 3.17 | | 3.17 | 3.20 | | 3.09 | 3.11 | | 2.74 | 2.73 | | 2.79 | 2.78 | | 2.80 | 2.81 | +-----------+-----------+ 14 rows geo-> select * from test2 where a=b; +-----------+-----------+ | a | b | +===========+===========+ | 3.22 | 3.22 | | 3.05 | 3.05 | +-----------+-----------+ 2 rows geo-> select * from test2 where (a/b)-1=0; +-----------+-----------+ | a | b | +===========+===========+ | 3.06 | 3.04 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.07 | 3.06 | | 3.08 | 3.05 | | 3.12 | 3.09 | | 3.20 | 3.17 | | 2.74 | 2.73 | | 2.79 | 2.78 | +-----------+-----------+ <>9 rows geo-> select * from test2 where (b/a)-1=0; +-----------+-----------+ | a | b | +===========+===========+ | 3.05 | 3.07 | | 3.13 | 3.16 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.17 | 3.20 | | 3.09 | 3.11 | | 2.80 | 2.81 | +-----------+-----------+ <>7 rows I thought that if a=b, then (a/b)-1 and (b/a)-1 must both also be equal to 0. Columns a and b are type decimal(7,2) and the data was entered to two decimal places by hand using insert statements. Thanks and best.......George ge I

2 1

Re: [MonetDB-users] algebra?
by George H 04 Oct '06

04 Oct '06

Hello: Sorry to have troubled you with the basic sql question below. Of course, it has no place here. The algebra will, of course, yield results in the same precision as the decimal types used in the calculation. George Hello Again: I'm trying to do some clinical research on large data sets and I ran into a problem represented in the following simplified example: geo-> select * from test2; +-----------+-----------+ | a | b | +===========+===========+ | 3.05 | 3.07 | | 3.06 | 3.04 | | 3.13 | 3.16 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.07 | 3.06 | | 3.08 | 3.05 | | 3.12 | 3.09 | | 3.20 | 3.17 | | 3.17 | 3.20 | | 3.09 | 3.11 | | 2.74 | 2.73 | | 2.79 | 2.78 | | 2.80 | 2.81 | +-----------+-----------+ 14 rows geo-> select * from test2 where a=b; +-----------+-----------+ | a | b | +===========+===========+ | 3.22 | 3.22 | | 3.05 | 3.05 | +-----------+-----------+ 2 rows geo-> select * from test2 where (a/b)-1=0; +-----------+-----------+ | a | b | +===========+===========+ | 3.06 | 3.04 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.07 | 3.06 | | 3.08 | 3.05 | | 3.12 | 3.09 | | 3.20 | 3.17 | | 2.74 | 2.73 | | 2.79 | 2.78 | +-----------+-----------+ <>9 rows geo-> select * from test2 where (b/a)-1=0; +-----------+-----------+ | a | b | +===========+===========+ | 3.05 | 3.07 | | 3.13 | 3.16 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.17 | 3.20 | | 3.09 | 3.11 | | 2.80 | 2.81 | +-----------+-----------+ <>7 rows I thought that if a=b, then (a/b)-1 and (b/a)-1 must both also be equal to 0. Columns a and b are type decimal(7,2) and the data was entered to two decimal places by hand using insert statements. Thanks and best.......George ge I

1 0

[MonetDB-users] Relieve
by classes: 04 Oct '06

04 Oct '06

Money Good Will Public People are spelled Try different keywords. general fewer Diverse Marine Life Found Off Care Medical Animation Nutrition Body Office Yard Credit Computers Gadgets Theater Movies Sports Toys Drugs Fitness Health Care Medical Based Services SIP Python regular basis updates. Platform: Time Zone Family Clothing Flowers Gifts Beauty Guides products and mobility meet achieve business goals November Amsterdam The Edition Learning Path about Searches Engines HDTV Digital Camera Cell Phone DSL Lock Picking Power Hybrid Cars general fewer your on can try Answers for expert help please... T.One mackdaddy thumb drives. gigs storage highspeed transfer Korea vowed Device Solutions Computers Gadgets Theater Movies Computer Blocks Search Members: about basics tools creating Products Auto Stu

1 0

[MonetDB-users] more sql blob
by Ronald Oussoren 03 Oct '06

03 Oct '06

Another problem with SQL Blob's is that they cannot be NULL :-(. (using the same testblob table as my previous mail) sql>insert into testblob(id, b) VALUES (NULL, NULL); MAPI = monetdb@localhost:50000 QUERY = insert into testblob(id, b) VALUES (NULL, NULL); ERROR = !ERROR: interpret_params s0_0(param 2): invalid sqlblob. I can probably work around this, but using empty blobs is less elegant than NULL values. Ronald

1 0

[MonetDB-users] SQL blob's
by Ronald Oussoren 03 Oct '06

03 Oct '06

My database scheme requires usage of blobs, but something seems wrong there: CREATE TABLE testblob (id INT, b BLOB); INSERT INTO testblob (id, b) VALUES ( 1, BLOB '1234'); SELECT * FROM testblob; # sys.testblob, sys.testblob # table_name # id, b # name # int, blob # type # 1, 0 # length [ 1, 0203 ] DROP TABLE testblob; It turns out that the conversion of a SQL blob literal to an array of bytes is buggy, the patch below fixes that. Ronald $ diff -u ../MonetDB-4.12.1/src/modules/plain/blob.c.org ../ MonetDB-4.12.1/src/modules/plain/blob.c --- ../MonetDB-4.12.1/src/modules/plain/blob.c.org 2006-10-03 16:04:05.000000000 +0200 +++ ../MonetDB-4.12.1/src/modules/plain/blob.c 2006-10-03 16:15:04.691486914 +0200 @@ -370,14 +370,15 @@ s++; res <<= 4; if (*s >= '0' && *s <= '9') { - res = *s - '0'; + res |= *s - '0'; } else if (*s >= 'A' && *s <= 'F') { - res = 10 + *s - 'A'; + res |= 10 + *s - 'A'; } else if (*s >= 'a' && *s <= 'f') { - res = 10 + *s - 'a'; + res |= 10 + *s - 'a'; } else { GDKerror("sqlblob_fromstr: Illegal char '%c' in blob\n", *s); } + s++; result->data[i] = res; } Ronald

1 0

[MonetDB-users] sql/jdbcclient...Exception in thread "main' java.lang.OutOfMemoryError
by George H 02 Oct '06

02 Oct '06

Fabian: I'm way out of you guys' league. I wouldn't know a stack trace from my elbow, but I'll do what I can to help. Just say so and tell me how. As far as whether I can tell if the MapiClient displayed all the rows or just a subset? Well, I actually did the MapiClient runs with 40million rows. It took awhile for it to role through them all, and of course, without the exception. Query results with less rows took less time. I can't say for sure if it actually showed all the rows or a subset, but I just assumed it was all of them because of how long it took to work through it. I'm afraid I am unaware of how to know if it showed all the rows or a subset. I only saw the beginning and the end of the runs, and that much of it seemed right. If there is any way I can help, just let me know. George

2 2

Re: [MonetDB-users] Recent bugs and question about modules
by Stefan Manegold 29 Sep '06

29 Sep '06

Maurice, finally, here's my reply --- at least as far as I Think I can answers your question right now... On Fri, Sep 29, 2006 at 10:02:51AM +0200, Maurice van Keulen wrote: > Hi Stefan, > > Thanks for resolving some of my bugs. I'm trying to develop an XQuery > module for probabilistic XML. This involves highly recursive functions > and XML fragments being constructed and then queried upon again in the > next function. I'm impressed that I got so far already (322 lines of > really complex XQuery code). Every time I do stumble onto a bug, I try > to isolate it and report it nicely. Currently, the bug that handers my > progress most is "1562868: Complex XQuery fails with error in > "batbat_lng_add_inplace". It is hard to already give the correct answer > to the test you created. I suggest to simply approve the result when the > error message does not occur anymore. And, if you are ready to pick one > of my bugs I reported, please have a look at this one if you will. Well, Jan spent quite some time on this one (see the bug report; Thanks, Jan!) and it appears to be a tircky one --- I'll consider applying Jan's "fast and ugly" solution for the time being, and *try* to find a better one as soon as time permits... > I also have a question. Eventually, my functions need to become part of > a module for Probabilistic XML. Besides XQuery functions, I also have a > few fundamental functions that are much better dealt with in MIL. I > have, for example, a function product that, given a sequence of numbers, > multiplies all these numbers: > > declare function product($seq as xs:decimal*) as xs:decimal > { if (count($seq) gt 0) then exactly-one($seq[1]) * > product($seq[position() gt 1]) else 1.0 }; > > This recursive definition of the function is for sure much less > efficient than something I could write in MIL. > > My question is: how can I develop a module with additional functions > that are implemented in MIL and usable in XQuery? Well, obviously(?), there are to ways to go. The first is to indeed add a new built-in function and provide a MIL implementation as we do for all other built-in functions --- I guess, this is not what you intended, right? The second one is to provide an XQuery module. In fact, MonetDB/XQuery allows both "plain" XQuery module definitions and MIL module definitions --- as far as I know, the best (only? for now?) way to create a MIL modules (template) is to have the pathfinder compiler translate an XQuery module to MIL (basically, Peter added the support for MIL modules to have pre-compiled modules, saving the XQuery to MIL translation...). Here's my approach to your example: ======== $ cat /tmp/mvk.xq module namespace mvk = "http://wwwhome.cs.utwente.nl/~keulen/"; declare function mvk:product($seq as xs:decimal*) as xs:decimal { if (count($seq) gt 0) then exactly-one($seq[1]) * mvk:product($seq[position() gt 1]) else 1.0 }; -------- $ pf /tmp/mvk.xq > /tmp/mvk.mil -------- $ echo 'import module namespace mvkXQ = "http://wwwhome.cs.utwente.nl/~keulen/" at "/tmp/mvk.xq"; mvkXQ:product((1,2,3,4))' | MapiClient -lx <?xml version="1.0" encoding="utf-8"?> <XQueryResult>24.000000</XQueryResult> -------- $ echo 'import module namespace mvkMIL = "http://wwwhome.cs.utwente.nl/~keulen/" at "/tmp/mvk.mil"; mvkMIL:product((1,2,3,4))' | MapiClient -lx <?xml version="1.0" encoding="utf-8"?> <XQueryResult>24.000000</XQueryResult> ======== well, if you look at the attached mvk.mil, you'll see that it looks quite complicated, and using it as a template to replace the recursive product implementation by a more efficient version will be quite tricky. Hence, here's another approach: While there is (AFAIK) not product aggregation in XQUery (yet?), there is one in MIL; and there is a sum aggregation in both. Hence, simply take a fn:sum in XQuery have it translated to MIL, which results in usage of {sum}() in MIL, and replace the latter by {prod}(): ======== $ cat /tmp/stm.xq module namespace stm = "http://www.cwi.nl/~manegold/"; declare function stm:product($seq as xs:decimal*) as xs:decimal { sum($seq) }; -------- $ pf /tmp/stm.xq > /tmp/stm.mil -------- $ egrep '{sum}|{prod}' /tmp/stm.mil var iter_aggr := {sum}(item.leftfetchjoin(dec_values), iter_grp, reverse(loop000)).tmark(0@0); -------- $ perl -i -p -e 's|{sum}|{prod}|' /tmp/stm.mil -------- $ egrep '{sum}|{prod}' /tmp/stm.mil var iter_aggr := {prod}(item.leftfetchjoin(dec_values), iter_grp, reverse(loop000)).tmark(0@0); -------- $ echo 'import module namespace stmXQ = "http://www.cwi.nl/~manegold/" at "/tmp/stm.xq"; stmXQ:product((1,2,3,4))' | MapiClient -lx <?xml version="1.0" encoding="utf-8"?> <XQueryResult>10.000000</XQueryResult> -------- $ echo 'import module namespace stmMIL = "http://www.cwi.nl/~manegold/" at "/tmp/stm.mil"; stmMIL:product((1,2,3,4))' | MapiClient -lx <?xml version="1.0" encoding="utf-8"?> <XQueryResult>24.000000</XQueryResult> ======== Seem to work well ;-) As said, I don't know a better way to produce a MonetDB/XQuery conforming MIL module by hand, but this way, you can create a template and modify it even further than I did here. There's one(?) caveat, though: Modules created this way are not necessairyly protable from one version of MonetDB/XQuery to another one, as the requires/expected signature of the respective MIL procedure and/or format/content of its arguments might change... Hope this helps you further, anyway... More suggestions are of course welcome (that's why I moved this discussion to this mailing list ;-)) Stefan > Thanks again for your effort! > Maurice. > > -- > ---------------------------------------------------------------------- > Dr.Ir. M. van Keulen - Assistant Professor, Data Management Technology > Univ. of Twente, Dept of EEMCS, POBox 217, 7500 AE Enschede, Netherlands > Email: m.vankeulen(a)utwente.nl, Phone: +31 534893688, Fax: +31 534892927 > Room: INF3039, WWW: http://www.cs.utwente.nl/~keulen -- | 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

Re: [MonetDB-users] sql sequence
by George H 27 Sep '06

27 Sep '06

Hey Guys: I hate to bother you, but I just downloaded and installed the updated builds presently (Sept 27) posted on http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… I still get: monetdb-> create table test (name varchar(10), seq serial); Operation successful monetdb-> create table test1 (name varchar(10)); Operation successful monetdb-> insert into test1 values ('a'), ('b'), ('c'); 3 affected rows monetdb-> insert into test (name) select (name) from test1; Error: ERROR: INSERT INTO: PRIMARY KEY constraint 'test.test_seq_pkey' violated What do you think? George

1 0

[MonetDB-users] Obtain the career you have always wanted with the University Degree you deserve. Bo6p8HFZV7ZcX
by monet＠isp4mail.com 27 Sep '06

27 Sep '06

1 0

[MonetDB-users] sql/jdbcclient...Exception in thread "main' java.lang.OutOfMemoryError
by George H 26 Sep '06

26 Sep '06

I'm using Suse 10.1 with an AMD dual core processor and 850MB memory (note: There's 1000MB of ram but 150MB is shared with the video card thus leaving the system to recognize only 850MB) MonetDB softwares used are the packages presently posted on: http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… With the table, "test" having 4 million rows using sql and jdbcclient: geo->select column1 from test; It displays the column1 query results for about 10 seconds and then the jdbcclient-1.4.jar crashes leaving the following message before it bugs out: Exception in thread "main" java.lang.OutOfMemeoryError I tried many many combinations of java options concerning memory and gc to try to fix it but in my hands, no luck. I worked around this by switching to the MapiClient which works just fine. Just thought there might be some interest in these results. Thanks to everyone again.....George

2 1

Re: [MonetDB-users] sql sequence
by George H 26 Sep '06

26 Sep '06

Thanks Fabian and Niels. A fix of this bug is greatly welcomed. That was quick action. I'm using SUSE10.1 and I just installed the build presently posted on: http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… However, this build still carries the problem. Will the fix appear on this web page and if so when? Or is there some other way I should get this fix? Thanks again..........George

2 1

Re: [MonetDB-users] sql sequence
by George H 26 Sep '06

26 Sep '06

Thanks Fabian and Niels. A fix of this bug is greatly welcomed. That was quick action. I'm using SUSE10.1 and I just installed the build presently posted on: http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… However, this build still carries the problem. Will the fix appear on this web page and if so when? Or is there some other way I should get this fix? Thanks again..........George

1 0

Re: [MonetDB-users] sql sequence
by George H 26 Sep '06

26 Sep '06

Hey Fabian: Thanks so much for your response. I really appreciate the help. I don't think I can use the idea of creating a table with a sequence column and later doctoring that column with an ALTER SEQUENCE statement because I use a COPY INTO command to populate the table with a text file. The table must have the same number of columns as the test file for the COPY INTO statement to work and the text file has no sequence column. Do you know of some other way to populate a table from a text file that might get around this? I tried to use an INSERT statement to populate a table that already had a sequence column, but that didn't work either. Here's what I did. sql->create table test (name varchar(10), seq serial); sql->create table test2 (name varchar(10)); sql->insert into test2 values ('a), ('b'), ('c'); [ 3 ] sql->insert into test (name) select (name) from test2; ERROR = !ERROR: INSERT INTO: PRIMARY KEY constraint 'test.test_seq_pkey' violated So if I use the COPY INTO statement to populate a table from my text file, I can't use the resulting table in an INSERT/SELECT statement to populate another table that has a sequence column. Is there some course of action you can think of to get a sequenced table from a text file? With 40million+ rows it sure can't be done by hand. Again, thanks for your help and also thanks for all your postings on this list. I've found them interesting and instructive. Best......George

3 2

[MonetDB-users] sql sequence
by George H 25 Sep '06

25 Sep '06

Hello: I have a large table (40 million+ rows) that I generated with "copy into" statements using several 1g txt files. The table was subsequently subjected to an "order asc" statement and now I need to add a sequence column to it and there I have a problem. A simple test table illustrates the problem as follows: sql-> create table test (name varchar(10)); sql->alter table test add column seq serial; Error: ALTER TABLE ADD COLUMN: adding column with key constraint not implemented I have tried several different ways to generate a sequence that work from me in postgres but I continuously run into an error like "primary key constraint violated". The only way I can get it to work is by adding one row at a time. Sorry about my ignorance, but can someone lend a hand? Thanks, George H

2 1

[MonetDB-users] serial/auto_increment
by George H 25 Sep '06

25 Sep '06

Thanks: I have a large table (40 million+ rows) that I generated with "copy into" statements using several 1g txt files. The table was subsequently subjected to an "order asc" statement and now I need to have a sequence put on it and there I have a problem. A small simple test table illustrates the problem as follows: sql-> create table test (name varchar(10)); sql->alter table test add column seq serial; Error: ALTER TABLE ADD COLUMN: adding column with key constraint not implemented I have tried several different ways to generate a sequence in the table without success, including insert/select and auto_increment. I have encountered the error "primary key constraint violated". The only way I can get it to work is by adding one row at a time and with 40million rows....well. Sorry about my naivete, but can someone tell me what I am missing. Thanks, George H

1 0

Re: [MonetDB-users] Shredding DBLP XML document
by Stefan Manegold 22 Sep '06

22 Sep '06

Hi Erwin, shredding dblp.xml works fine for me with MonetDB/XQuery 0.13.1 (latest CVS version) on an Althon64 X2 with 2 GB RAM under Fedora Core 4: ======== # Monet Database Server V4.13.1 # Copyright (c) 1993-2006, CWI. All rights reserved. # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. MonetDB>shred_doc("/tmp/dblp.xml","dblp.xml"); # Elapsed time = 02m 05s 557ms 075us [005us/node] # Shredded 1 XML documents, total time after commit=133.708s ======== Hence, could you please be more verbose about your setup? Which version of MonetDB/XQuery are you using? What kind of "PC" are you using (operating system, hardware)? You say "the shredding process was not finished". Does this mean that MonetDB/XQuery was still busy (with shredding)? Stefan ps: I felt free to cc this to the MonetDB-users lists. On Thu, Sep 21, 2006 at 02:02:05PM +0800, Erwin Leonardi wrote: > Hi all, > > I tried to shred DBLP XML document (around 300MB), but I found the following > situations. I left my PC over the weekend, and the shredding process was not > finish and there is no error message. I tried to check my free disk space, > and I found out that the free disk space remains the same. That is, it seems > that MonetDB has not written any data to disk. Do you why this happened? Can > you try to shred DBLP XML document ? > > Thanks > Erwin -- | 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 6

Re: [MonetDB-users] Comparing TPC-H benchmark results?
by moredata＠fastmail.net 21 Sep '06

21 Sep '06

Hello, I too would be interested in TPC-H comparisons of MonetDB versus other open source databases like MySQL and PostgreSQL, in addition to commercial databases like Oracle. If anyone has done such comparisons, please let me know. Martin also mentioned that the plans are not currently optimized but that it is targeted for V5. Are any of these optimizations already in the V5 CVS code (correlated subqueries?)? Thanks in advance. > -----Original Message----- > From: monetdb-users-bounces(a)lists.sourceforge.net > [mailto:monetdb-users-bounces@lists.sourceforge.net] On > Behalf Of Martin Kersten > Sent: Saturday, September 16, 2006 7:39 AM > To: monetdb-users(a)lists.sourceforge.net > Subject: Re: [MonetDB-users] Comparing TPC-H benchmark results? > > > If I a remember correctly the scale factor is 0.01 in the > testweb. Beware that some queries in TPC-H require a lot of > intermediate space and the plans produced for MIL are not > optimized. (It is the target for the MonetDB V5 release) > > Actually, we would be interested in experiences in the > upcoming TPC-DS, which is more modern and not well explored > by any system. > > Fabian Groffen wrote: > > Hi, > > > > No need to resubmit your question. It was received, but I'm sorry > > that we've been too busy to answer this question. > > > > On 15-09-2006 21:25:15 +0200, Wouter Scherphof wrote: > >> Hi, > >> > >> The TPC-H benchmark (http://www.tpc.org/tpch/default.asp) > is part of > >> the MonetDB SQL source and the benchmark is run during > weekends, as I > >> can see on the TestWeb > >> > (http://monetdb.cwi.nl/testing/projects/monetdb/Current/sql/.mTests03 > >> /times.html). > >> How > >> should I interpret the listed results? According to TPC, > results should be > >> stated as a "QphH@Size" value, where "QphH" is the number > of queries per > >> hour for the H benchmark, and "Size" is a "scaling > factor". On the TestWeb, > >> the results are stated as seconds of execution time. > > > > The testweb tpc-h is very very very small, to keep both > testweb small > > in diskspace, and to keep the test time reasonable on our slower > > testing machines. > > > >> Is it correct to compute the QphH value as follows: > >> Queries 01-22 took 1.985 seconds, so QphH is (3600 / 1.985) * 22 = > >> 39.899 ? > > > > Well, the testweb framework does way more than just executing the > > test, so the performance time of the test might not be accurate. > > Also, you probably want to test with a higher workload, to > get a more > > accurate result. > > > >> What scaling factor is used in the benchmark runs; is this > 1? Is it > >> possible to let the TestWeb run with scaling factor 100? Because > >> that's the smallest Size for which results are published > on the TPC > >> web site. > > > > It's very small. I don't recall how small, but very very small. > > > >> Did anyone yet try to determine the Price of the test platforms, > >> following the TPC Pricing Spec? TPC-H results normally include a > >> Price/Performance metric in the form of $/QphH@Size, and I guess > >> MonetDB could score particularly well on this metric. > > > > We never really did this. But, feel free to try and setup > such test, > > we are very interested in the outcomes, of course. > > > > > > I hope this answers your questions. > > > > Regards > > > > > ---------------------------------------------------------------------- > > --- > > Using Tomcat but need to do more? Need to support web > services, security? > > Get stuff done quickly with pre-integrated technology to > make your job easier > > Download IBM WebSphere Application Server v.1.0.1 based on > Apache Geronimo > > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057& dat=121642 > _______________________________________________ > MonetDB-users mailing list > MonetDB-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users -- moredata(a)fastmail.net -- http://www.fastmail.fm - IMAP accessible web-mail

1 0

[MonetDB-users] schema reconstruction
by Ronald Oussoren 19 Sep '06

19 Sep '06

Hi, I'm trying to build a driver for monetdb for sqlalchemy (a python ORM layer). One of the things I need to do for that is provide a way to reconstruct the (some of) database schema on the fly. It seems to be easily possible to reconstruct most of the table definition from the 'table' and 'columns' tables, but how do I retrieve key contraints? Specifically, given this table definition: create table test ( id integer primairy key, name varchar(10) ) , I get some data in the keycolums table, but don't know how to relate that to the tables and colums tables. I also need something simular for foreign keys, but haven't looked into that yet. Ronald P.S. I'm using the head of the CVS trunk.

4 3

[MonetDB-users] Comparing TPC-H benchmark results?
by Wouter Scherphof 16 Sep '06

16 Sep '06

Hi, The TPC-H benchmark (http://www.tpc.org/tpch/default.asp) is part of the MonetDB SQL source and the benchmark is run during weekends, as I can see on the TestWeb ( http://monetdb.cwi.nl/testing/projects/monetdb/Current/sql/.mTests03/times.…) How should I interpret the listed results? According to TPC, results should be stated as a "QphH@Size" value, where "QphH" is the number of queries per hour for the H benchmark, and "Size" is a "scaling factor". On the TestWeb, the results are stated as seconds of execution time. Is it correct to compute the QphH value as follows: Queries 01-22 took 1.985 seconds, so QphH is (3600 / 1.985) * 22 = 39.899 ? What scaling factor is used in the benchmark runs; is this 1? Is it possible to let the TestWeb run with scaling factor 100? Because that's the smallest Size for which results are published on the TPC web site. Did anyone yet try to determine the Price of the test platforms, following the TPC Pricing Spec? TPC-H results normally include a Price/Performance metric in the form of $/QphH@Size, and I guess MonetDB could score particularly well on this metric. Regards, Wouter Scherphof. Utrecht Professional School, The Netherlands.

3 3

[MonetDB-users] packages for YUM (fedora 5) and PORT (os x intel)?
by Shahbaz 15 Sep '06

15 Sep '06

Hi, I would like to use Monet DB, however the RPMs provided on your webpage don't seem to work for Fedora Core 5. Despite having these libraries installed, rpm -Uvh and rpm -ivh tell me that libMapi, libalgebra, lib_arith, etc. are needed by MonetDB-QL-server-2.12.0-1.x86_64.rpm. (I have AMD 64). Could someone please provide a yum repository so users can' install monetdb just by doing the following: sudo yum install monetdb I don't have an immediate need for a darwin-ports distribution, but it will be very helpful for those who would like to try monetdb on osx. Thanks

2 1

Re: [MonetDB-users] Fedora core 5 64 bit horribly slow compilation
by Fabian Groffen 11 Sep '06

11 Sep '06

On 11-09-2006 18:03:17 +0200, Tomas Brambora wrote: > Hello, Mr. Grofen, Hi Tomas, > I would like to ask whether there have been attempts to compile MonetDB on AMD Athlon 64 mobile achitecture OS Fedora Core 5 (64 bit version). > I ask because I was trying to compile it on my fresh installation of this OS and it just gets stuck on the file "gdk_scanselect.c". Or perhaps it doesn't get stuck, but I let it compile this file for 20 minutes and it didn't make any progress (it keeps on working with the harddisc though), then I lost patience. I know this file is BIG, but anyway, 20 minutes... On mobile chips we haven't tested, but on our own systems with athlon64's and Fedora Core 5 it takes a while to compile this file, especially with full optimisations on. 20 minutes sounds a bit long though. What's your CPU speed? And what is the active CPU speed when compiling MonetDB? I cc monetdb-users list, as maybe someone else has more experience with compiling on your CPU. Regards

2 1

[MonetDB-users] XML Query Test Suite 1.0 released
by Martijn Faassen 30 Aug '06

30 Aug '06

Hi there, The developers of MonetDB are probably already more than aware of this, but just in case: The w3c has released version 1.0 of the XML Query Test suite. They ask for comments and display reports on the conformance of various systems on their page: http://www.w3.org/XML/Query/test-suite/ http://www.w3.org/XML/Query/test-suite/XQTSReportSimple.html http://www.w3.org/XML/Query/test-suite/XQTSReport.html Perhaps it'd be nice to be included in those reports? Regards, Martijn

2 2

[MonetDB-users] Could not bootstrap buildtools on SunOS 5.10
by Ying Zhang 29 Aug '06

29 Aug '06

Hello, I'm trying to install MonetDB (CVS HEAD) on a SunOS 5.10 32 bits machine (electra at CWI), but I'm already stuck by bootstrapping the buildtools. I've attached the whole output of the bootstrap. Please note the message at the end of the output. I have no idea what is going wrong here, so any help will be appreciated! Kind regards, Jennie ========================================== $ ./bootstrap + rm -f configure + cp configure.ac configure + chmod +x configure + cd Mx + ./bootstrap /opt/sfw/share/aclocal/xmms.m4:17: warning: underquoted definition of XMMS_TEST_ VERSION run info '(automake)Extending aclocal' or see http://sources.redhat.com/automake/automake.html#Extending%20aclocal /opt/sfw/share/aclocal/xmms.m4:62: warning: underquoted definition of AM_PATH_XM MS /opt/sfw/share/aclocal/xdelta.m4:7: warning: underquoted definition of AM_PATH_X DELTA /opt/sfw/share/aclocal/vorbis.m4:9: warning: underquoted definition of XIPH_PATH _VORBIS /opt/sfw/share/aclocal/sdl.m4:11: warning: underquoted definition of AM_PATH_SDL /opt/sfw/share/aclocal/progtest.m4:13: warning: underquoted definition of AM_PAT H_PROG_WITH_TEST /opt/sfw/share/aclocal/ogg.m4:8: warning: underquoted definition of XIPH_PATH_OG G /opt/sfw/share/aclocal/lcmessage.m4:11: warning: underquoted definition of AM_LC _MESSAGES /opt/sfw/share/aclocal/imlib.m4:9: warning: underquoted definition of AM_PATH_IM LIB /opt/sfw/share/aclocal/imlib.m4:167: warning: underquoted definition of AM_PATH_ GDK_IMLIB /opt/sfw/share/aclocal/gimpprint.m4:8: warning: underquoted definition of AM_PAT H_GIMPPRINT /opt/sfw/share/aclocal/gimp.m4:8: warning: underquoted definition of AM_PATH_GIM P /opt/sfw/share/aclocal/gettext.m4:11: warning: underquoted definition of AM_WITH _NLS /opt/sfw/share/aclocal/gettext.m4:196: warning: underquoted definition of AM_GNU _GETTEXT /opt/sfw/share/aclocal/ao.m4:9: warning: underquoted definition of XIPH_PATH_AO /usr/share/aclocal/vorbis.m4:9: warning: underquoted definition of XIPH_PATH_VOR BIS /usr/share/aclocal/vorbis-old.m4:9: warning: underquoted definition of AM_PATH_V ORBIS /usr/share/aclocal/pkg.m4:5: warning: underquoted definition of PKG_CHECK_MODULE S /usr/share/aclocal/ogg.m4:8: warning: underquoted definition of XIPH_PATH_OGG /usr/share/aclocal/ogg-old.m4:8: warning: underquoted definition of AM_PATH_OGG /usr/share/aclocal/esd.m4:10: warning: underquoted definition of AM_PATH_ESD /usr/share/aclocal/esd.m4:175: warning: underquoted definition of AM_ESD_SUPPORT S_MULTIPLE_RECORD /usr/share/aclocal/audiofile.m4:12: warning: underquoted definition of AM_PATH_A UDIOFILE /usr/sfw/share/aclocal/gtk.m4:7: warning: underquoted definition of AM_PATH_GTK /usr/sfw/share/aclocal/glib.m4:8: warning: underquoted definition of AM_PATH_GLI B /usr/sfw/share/aclocal/gimpprint.m4:8: warning: underquoted definition of AM_PAT H_GIMPPRINT ./bootstrap: test: argument expected + exit 1

3 7

Re: [MonetDB-users] Could not bootstrap buildtools on SunOS 5.10
by Ying Zhang 29 Aug '06

29 Aug '06

Thanks, your tip helps to get rid of a strange problem in another MonetDB installation of mine. I was also installing monet on a Fedora4, 32bits machine (norma at cwi). I could not install all buildtools in one go while I can install each buildtool separately. After having clean out the buildtools and start all over again, the problem disappeared. But it doesn't help to solve this problem. I will have to find other solutions:) On Mon, Aug 28, 2006 at 10:17:19PM +0200, Martin Kersten wrote: > Hello, > I am not the right person, but I spent 2.5 hours yesterday (and friday > too) to re-install my version :-(. > One of the lessons learned, with each step use a fresh window, so that > existing shell variables and aliases are out of the way. > > i.e. > step 1, clean out the builtools (or better save them elsewhere ;-)) > followed by cvs upd > step 2, open a new SUN session window and start the bootstrap sequence. > > good luck ! > > Ying Zhang wrote: > >Hello, > > > >I'm trying to install MonetDB (CVS HEAD) on a SunOS 5.10 32 bits machine > >(electra at CWI), but I'm already stuck by bootstrapping the buildtools. > >I've attached the whole output of the bootstrap. Please note the > >message at the end of the output. I have no idea what is going wrong > >here, so any help will be appreciated! > > > >Kind regards, > > > >Jennie > > > > > >========================================== > >$ ./bootstrap > >+ rm -f configure > >+ cp configure.ac configure > >+ chmod +x configure > >+ cd Mx > >+ ./bootstrap > >/opt/sfw/share/aclocal/xmms.m4:17: warning: underquoted definition of > >XMMS_TEST_ VERSION > > run info '(automake)Extending aclocal' > > or see > > http://sources.redhat.com/automake/automake.html#Extending%20aclocal > >/opt/sfw/share/aclocal/xmms.m4:62: warning: underquoted definition of > >AM_PATH_XM MS > >/opt/sfw/share/aclocal/xdelta.m4:7: warning: underquoted definition of > >AM_PATH_X DELTA > >/opt/sfw/share/aclocal/vorbis.m4:9: warning: underquoted definition of > >XIPH_PATH _VORBIS > >/opt/sfw/share/aclocal/sdl.m4:11: warning: underquoted definition of > >AM_PATH_SDL > >/opt/sfw/share/aclocal/progtest.m4:13: warning: underquoted definition of > >AM_PAT H_PROG_WITH_TEST > >/opt/sfw/share/aclocal/ogg.m4:8: warning: underquoted definition of > >XIPH_PATH_OG G > >/opt/sfw/share/aclocal/lcmessage.m4:11: warning: underquoted definition of > >AM_LC _MESSAGES > >/opt/sfw/share/aclocal/imlib.m4:9: warning: underquoted definition of > >AM_PATH_IM LIB > >/opt/sfw/share/aclocal/imlib.m4:167: warning: underquoted definition of > >AM_PATH_ GDK_IMLIB > >/opt/sfw/share/aclocal/gimpprint.m4:8: warning: underquoted definition of > >AM_PAT H_GIMPPRINT > >/opt/sfw/share/aclocal/gimp.m4:8: warning: underquoted definition of > >AM_PATH_GIM P > >/opt/sfw/share/aclocal/gettext.m4:11: warning: underquoted definition of > >AM_WITH _NLS > >/opt/sfw/share/aclocal/gettext.m4:196: warning: underquoted definition of > >AM_GNU _GETTEXT > >/opt/sfw/share/aclocal/ao.m4:9: warning: underquoted definition of > >XIPH_PATH_AO > >/usr/share/aclocal/vorbis.m4:9: warning: underquoted definition of > >XIPH_PATH_VOR BIS > >/usr/share/aclocal/vorbis-old.m4:9: warning: underquoted definition of > >AM_PATH_V ORBIS > >/usr/share/aclocal/pkg.m4:5: warning: underquoted definition of > >PKG_CHECK_MODULE S > >/usr/share/aclocal/ogg.m4:8: warning: underquoted definition of > >XIPH_PATH_OGG > >/usr/share/aclocal/ogg-old.m4:8: warning: underquoted definition of > >AM_PATH_OGG > >/usr/share/aclocal/esd.m4:10: warning: underquoted definition of > >AM_PATH_ESD > >/usr/share/aclocal/esd.m4:175: warning: underquoted definition of > >AM_ESD_SUPPORT S_MULTIPLE_RECORD > >/usr/share/aclocal/audiofile.m4:12: warning: underquoted definition of > >AM_PATH_A UDIOFILE > >/usr/sfw/share/aclocal/gtk.m4:7: warning: underquoted definition of > >AM_PATH_GTK > >/usr/sfw/share/aclocal/glib.m4:8: warning: underquoted definition of > >AM_PATH_GLI B > >/usr/sfw/share/aclocal/gimpprint.m4:8: warning: underquoted definition of > >AM_PAT H_GIMPPRINT > >./bootstrap: test: argument expected > > + exit 1 > > > > > > > >------------------------------------------------------------------------- > >Using Tomcat but need to do more? Need to support web services, security? > >Get stuff done quickly with pre-integrated technology to make your job > >easier > >Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > >http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > >_______________________________________________ > >MonetDB-users mailing list > >MonetDB-users(a)lists.sourceforge.net > >https://lists.sourceforge.net/lists/listinfo/monetdb-users

3 2

Re: [MonetDB-users] help please
by Stefan Manegold 25 Aug '06

25 Aug '06

George, if everything works well, there should be daily-built MonetDB/SQL RPMs available also for 64-bit SuSE as of tomorrow (european) morning from http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… I found and (hopefully) fixed the bug that prevented them from being built. Stefan On Wed, Aug 23, 2006 at 05:46:44AM -0700, George H wrote: > Stefan: > > Thanks so much for everything. > > You've been the greatest. > > George > > > > Stefan Manegold wrote: > > >Hi George, > > > >On Tue, Aug 22, 2006 at 05:23:52PM -0700, George H wrote: > > > > > >>Hey Stephan: > >> > >>On SuSE 10.1 (AMD64) using download from SourceForge (developed on > >>Fedora Core as you said) I got: > >> > >># rpm -ivh MonetDB-client-4.12.0-1.x86_64.rpm > >> > >>error: Failed dependencies: > >> > >>libcrypto.so.5 () (64bit) is needed > >>libssl.so.5 () (64bit) is needed > >>libtermcap.so.2 () (64bit) is needed > >> > >> > > > >libcrypto.so, libssl.so libtermcap.so are indeed required --- it appears, > >though that FC4 comes with > > libcrypto.so.5, libssl.so.5, libtermcap.so.2, > >(which are actually symlinks to > > libcrypto.so.0.9.7f, libssl.so.0.9.7f, libtermcap.so.2.0.8 > >respectively), while SuSE 9.3 (and apparently also 10.1) comes with > > libcrypto.so.0, /usr/lib64/libssl.so.0 > >(which are actually symlinks to > > libcrypto.so.0.9.7f, libssl.so.0.9.7f > >respectively). > >Hence, the FC4 RPMs do not fit SuSE 9.3 and 10.1 > > > > > > > >>I downloaded the sever and client for SuSE 9.3 as you recommended from > >>http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > >>Both seemed to install fine and the Mserver command brough me to the > >> > >> > > > >good. > > > > > > > >>MonetDB> prompt, however with the following warnings. > >> > >>!Warning: GDKlockHome: created directory /var/lib/MonetDB/defarm/demo/ > >>!Warning: GDKlockhome:ignoring empty or invalid .gdk_lock > >>!Warning: BBPdir: initializng BBP > >> > >>Are these a problem? > >> > >> > > > >nope, that normal when you start Mserver for the firt time. > >It just creates and initializes the location for its databases. > > > > > > > >>Finally, I tryed rpm -ivh MonetDB-SQL-server-2.12.0-1.x86_64.rpm. The > >>result > >> > >>error: Failed dependencies: > >> > >>libcrypto.so.5 () (64bit) is needed > >>libssl.so.5 () (64bit) is needed > >> > >> > > > >that's the FC4 RPM, right? > >Hence, same problem as mentioned above. > > > > > > > >>Is there an SQL-server frontend for SuSe 9.3 or some other solution that > >>would allow meto have an SQL frontend to use with the install success I > >>had with the MonetDB for SuSe9.3? Or am I forced to use FedoraCore if I > >>need the SQL? I sure hope not. > >> > >> > > > >There is supposed to be an SQL frontend RPM also for SuSE 9.3 at > >http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > > > >However, the compilation of that seem to have failed recently (at least > >last > >night) --- I cannot yet see/understand why (in fact, compilation worked, > >but > >creating the RPMs failed) --- We'll (try to) look into this ... > >... sorry for the inconvenience... > > > >Hence, you'll either have to wait until we manage to fix the RPM build for > >MonetDB/SQL on SuSE 9.3 (64-bit; it works on/for 32-bit: > >http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > >), or you could get the source code (source-RPM or tar ball) for > >MonetDB/SQL, i.e., > > MonetDB-SQL-2.12.0-1.src.rpm or MonetDB-SQL-2.12.0.tar.gz from > > http://sourceforge.net/project/showfiles.php?group_id=56967&package_id=1141… > > or > > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./SourceR… > > or > > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./SourceT… > > > >and compile them yourself (next to the MonetDB-server & MonetDB-client > >RPMs, > >also the MonetDB-devel RPM needs to be installed). > > > >Let us know, in case you have more problems/questions. > > > >Stefan > > > > > >ps: Could you please also cc the Monetdb-users(a)lists.sourceforge.net > >mailing > > list in your replies? > > Other might be interested in this topic as well... > > Thanks in advance! > > > > > > > > > >>Thanks Stephen. > >> > >>Best to you....George > >> > >> > >> > >>Stefan Manegold wrote: > >> > >> > >> > >>>Dear George, > >>> > >>>to install the MonetDB-server-4.12.0-1.*.rpm, you also need to install > >>>the respective > >>>MonetDB-client-4.12.0-1.*.rpm, as mentioned in the release notes at > >>> http://sourceforge.net/project/shownotes.php?release_id=427002&group_id=569…: > >>>"[...] the MonetDB-server-4.12.0-1.*.rpm requires the corresponding > >>>MonetDB-client-4.12.0-1.*.rpm to be installed as well." > >>> > >>>You get the MonetDB-client-4.12.0-1.*.rpm from the same SF download page > >>>as > >>>MonetDB-server-4.12.0-1.*.rpm: > >>> http://sourceforge.net/project/showfiles.php?group_id=56967&package_id=5234… > >>> > >>> > >>>What are the missing dependencies for MonetDB-client-4.12.0-1.x86_64.rpm? > >>>Could you please send/post the list? > >>>(Most probably, they are indeed required....) > >>> > >>> > >>>Note though, that the RPM available from SF have been built on (and for) > >>>a > >>>Fedora Core 4 system, hence, there *might* be problem with installing > >>>them > >>>on a SuSE 10.1 system. > >>> > >>>We don't have (access to) a (64-bit) SuSE 10.1 system, yet, hence, we > >>>cannot > >>>provide any SuSE 10.1 specific RPMs, yet. > >>> > >>>All we can currently offer (in case you don't manage to install the > >>>Fedora > >>>Core 4 RPMs), are SuSE 9.3 RPMs form our MonetDB web site at > >>> http://monetdb.cwi.nl/GetGoing/Download/index.html > >>>(scroll down to 'Daily Builds') and click on 'CVS release branch > >>>("Stable")', or directly go to > >>> http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > >>> > >>>(There have been only minor bug fixes on the release branch, hence there > >>>should be no major differences between the 4.12.0 release from SF and the > >>>4.12.1 daily builds...) > >>> > >>> > >>>Kind Regards, > >>> > >>>Stefan > >>> > >>> > >>>On Tue, Aug 22, 2006 at 12:11:52PM -0700, George H wrote: > >>> > >>> > >>> > >>> > >>>>Hello: > >>>> > >>>>I am new to MonetDB and I'm no linux wizard either, so please excuse, > >>>>but can you help. > >>>> > >>>>I'm trying to install MonetDB-server-4.12.0-x86_64.rpm on SuSE 10.1 > >>>>(amd64) using the rpm -ivh command and I have "error: Failed > >>>>dependencies." > >>>> > >>>>It says libMapi.so.0 () (64bit), libcrypto.so.5 () (64bit), > >>>>libmutils.so.0 () (64bit), libssl.so.5 () (64bit), libstream.so.0 () > >>>>(64bit) are needed. > >>>> > >>>>Where do I get these? I've been searching, but all I can find is their > >>>>presence in other rpm packages. For example, I see that some of these > >>>>are in the MonetDB-client-4.12.0-1.x86_64.rpm, but it has it's own > >>>>lengthy list of missing dependencies for installation. > >>>> > >>>>Can you give me a hint. I feel like I'm in dependency hell, but I > >>>>realizie I'm more likely in naive dumblandia. > >>>> > >>>>Help please........Thanks, George > >>>> > >>>>------------------------------------------------------------------------- > >>>>Using Tomcat but need to do more? Need to support web services, > >>>>security? > >>>>Get stuff done quickly with pre-integrated technology to make your job > >>>>easier > >>>>Download IBM WebSphere Application Server v.1.0.1 based on Apache > >>>>Geronimo > >>>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > >>>>_______________________________________________ > >>>>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 2

Re: [MonetDB-users] help please
by Stefan Manegold 23 Aug '06

23 Aug '06

Hi George, On Tue, Aug 22, 2006 at 05:23:52PM -0700, George H wrote: > Hey Stephan: > > On SuSE 10.1 (AMD64) using download from SourceForge (developed on > Fedora Core as you said) I got: > > # rpm -ivh MonetDB-client-4.12.0-1.x86_64.rpm > > error: Failed dependencies: > > libcrypto.so.5 () (64bit) is needed > libssl.so.5 () (64bit) is needed > libtermcap.so.2 () (64bit) is needed libcrypto.so, libssl.so libtermcap.so are indeed required --- it appears, though that FC4 comes with libcrypto.so.5, libssl.so.5, libtermcap.so.2, (which are actually symlinks to libcrypto.so.0.9.7f, libssl.so.0.9.7f, libtermcap.so.2.0.8 respectively), while SuSE 9.3 (and apparently also 10.1) comes with libcrypto.so.0, /usr/lib64/libssl.so.0 (which are actually symlinks to libcrypto.so.0.9.7f, libssl.so.0.9.7f respectively). Hence, the FC4 RPMs do not fit SuSE 9.3 and 10.1 > I downloaded the sever and client for SuSE 9.3 as you recommended from > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > Both seemed to install fine and the Mserver command brough me to the good. > MonetDB> prompt, however with the following warnings. > > !Warning: GDKlockHome: created directory /var/lib/MonetDB/defarm/demo/ > !Warning: GDKlockhome:ignoring empty or invalid .gdk_lock > !Warning: BBPdir: initializng BBP > > Are these a problem? nope, that normal when you start Mserver for the firt time. It just creates and initializes the location for its databases. > Finally, I tryed rpm -ivh MonetDB-SQL-server-2.12.0-1.x86_64.rpm. The > result > > error: Failed dependencies: > > libcrypto.so.5 () (64bit) is needed > libssl.so.5 () (64bit) is needed that's the FC4 RPM, right? Hence, same problem as mentioned above. > Is there an SQL-server frontend for SuSe 9.3 or some other solution that > would allow meto have an SQL frontend to use with the install success I > had with the MonetDB for SuSe9.3? Or am I forced to use FedoraCore if I > need the SQL? I sure hope not. There is supposed to be an SQL frontend RPM also for SuSE 9.3 at http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… However, the compilation of that seem to have failed recently (at least last night) --- I cannot yet see/understand why (in fact, compilation worked, but creating the RPMs failed) --- We'll (try to) look into this ... ... sorry for the inconvenience... Hence, you'll either have to wait until we manage to fix the RPM build for MonetDB/SQL on SuSE 9.3 (64-bit; it works on/for 32-bit: http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… ), or you could get the source code (source-RPM or tar ball) for MonetDB/SQL, i.e., MonetDB-SQL-2.12.0-1.src.rpm or MonetDB-SQL-2.12.0.tar.gz from http://sourceforge.net/project/showfiles.php?group_id=56967&package_id=1141… or http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./SourceR… or http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./SourceT… and compile them yourself (next to the MonetDB-server & MonetDB-client RPMs, also the MonetDB-devel RPM needs to be installed). Let us know, in case you have more problems/questions. Stefan ps: Could you please also cc the Monetdb-users(a)lists.sourceforge.net mailing list in your replies? Other might be interested in this topic as well... Thanks in advance! > Thanks Stephen. > > Best to you....George > > > > Stefan Manegold wrote: > > >Dear George, > > > >to install the MonetDB-server-4.12.0-1.*.rpm, you also need to install the > >respective > >MonetDB-client-4.12.0-1.*.rpm, as mentioned in the release notes at > > http://sourceforge.net/project/shownotes.php?release_id=427002&group_id=569…: > >"[...] the MonetDB-server-4.12.0-1.*.rpm requires the corresponding > >MonetDB-client-4.12.0-1.*.rpm to be installed as well." > > > >You get the MonetDB-client-4.12.0-1.*.rpm from the same SF download page as > >MonetDB-server-4.12.0-1.*.rpm: > > http://sourceforge.net/project/showfiles.php?group_id=56967&package_id=5234… > > > > > >What are the missing dependencies for MonetDB-client-4.12.0-1.x86_64.rpm? > >Could you please send/post the list? > >(Most probably, they are indeed required....) > > > > > >Note though, that the RPM available from SF have been built on (and for) a > >Fedora Core 4 system, hence, there *might* be problem with installing them > >on a SuSE 10.1 system. > > > >We don't have (access to) a (64-bit) SuSE 10.1 system, yet, hence, we > >cannot > >provide any SuSE 10.1 specific RPMs, yet. > > > >All we can currently offer (in case you don't manage to install the Fedora > >Core 4 RPMs), are SuSE 9.3 RPMs form our MonetDB web site at > > http://monetdb.cwi.nl/GetGoing/Download/index.html > >(scroll down to 'Daily Builds') and click on 'CVS release branch > >("Stable")', or directly go to > > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > > > >(There have been only minor bug fixes on the release branch, hence there > >should be no major differences between the 4.12.0 release from SF and the > >4.12.1 daily builds...) > > > > > >Kind Regards, > > > >Stefan > > > > > >On Tue, Aug 22, 2006 at 12:11:52PM -0700, George H wrote: > > > > > >>Hello: > >> > >>I am new to MonetDB and I'm no linux wizard either, so please excuse, > >>but can you help. > >> > >>I'm trying to install MonetDB-server-4.12.0-x86_64.rpm on SuSE 10.1 > >>(amd64) using the rpm -ivh command and I have "error: Failed > >>dependencies." > >> > >>It says libMapi.so.0 () (64bit), libcrypto.so.5 () (64bit), > >>libmutils.so.0 () (64bit), libssl.so.5 () (64bit), libstream.so.0 () > >>(64bit) are needed. > >> > >>Where do I get these? I've been searching, but all I can find is their > >>presence in other rpm packages. For example, I see that some of these > >>are in the MonetDB-client-4.12.0-1.x86_64.rpm, but it has it's own > >>lengthy list of missing dependencies for installation. > >> > >>Can you give me a hint. I feel like I'm in dependency hell, but I > >>realizie I'm more likely in naive dumblandia. > >> > >>Help please........Thanks, George > >> > >>------------------------------------------------------------------------- > >>Using Tomcat but need to do more? Need to support web services, security? > >>Get stuff done quickly with pre-integrated technology to make your job > >>easier > >>Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > >>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > >>_______________________________________________ > >>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 |

1 0

[MonetDB-users] help please
by George H 22 Aug '06

22 Aug '06

Hello: I am new to MonetDB and I'm no linux wizard either, so please excuse, but can you help. I'm trying to install MonetDB-server-4.12.0-x86_64.rpm on SuSE 10.1 (amd64) using the rpm -ivh command and I have "error: Failed dependencies." It says libMapi.so.0 () (64bit), libcrypto.so.5 () (64bit), libmutils.so.0 () (64bit), libssl.so.5 () (64bit), libstream.so.0 () (64bit) are needed. Where do I get these? I've been searching, but all I can find is their presence in other rpm packages. For example, I see that some of these are in the MonetDB-client-4.12.0-1.x86_64.rpm, but it has it's own lengthy list of missing dependencies for installation. Can you give me a hint. I feel like I'm in dependency hell, but I realizie I'm more likely in naive dumblandia. Help please........Thanks, George

2 1

Re: [MonetDB-users] return type of 'count' in mil
by Stefan Manegold 14 Aug '06

14 Aug '06

Jenny, the return type of count is "legacy". You're right, in case of BATs with more than 2^31 BUNs (possible only on 64-bit systems), the default count(BAT[any,any]):int will fail (or at least return a wrong result. We hanven't changed it to count(BAT[any,any]):lng, yet, maily due to backward-compatibility and due to the fact that a grouped-count ({count}(BAT[any::1,any::2]):BAT[any::1,int/lng]) would than in all cases return a BAT[any,lng], possibly "wasting" space compared to a BAT[any,int]. Eventually, count should return a vraiable integer type that is 32-bit on 32-bit systems and 64-bit on 64-bit systems --- I've been planning to add this "word" type (together with a "proper" 1-byte integer "byte") for quite some time, but it never made it to the very top op my priority-ordered todo list... for now, in case you indeed need th count of >2^31 BUN BATs, you can use count(int):lng, where you provide the BAT's id (i.e., int(BAT)) iso. the BAT itself as argument: ======== MonetDB>help("count"); COMMAND: count(BAT[any,any], bit) : int MODULE: algebra COMPILED: by adm on Mon Aug 7 18:07:14 2006 Returns the number of elements currently in a BAT; ignores BUNs with nil-tail iff ignore_nils==TRUE. COMMAND: count(BAT[any,any]) : int MODULE: algebra COMPILED: by adm on Mon Aug 7 18:07:14 2006 Returns the number of elements currently in a BAT. COMMAND: count(BAT[void,void], lng) : lng MODULE: bat COMPILED: by adm on Mon Aug 7 18:07:14 2006 Sets the size (in number of elements) of a BAT. COMMAND: count(int) : lng MODULE: bat COMPILED: by adm on Mon Aug 7 18:07:14 2006 Returns the current size (in number of elements) of a BAT. MonetDB> ======== Stefan On Wed, Aug 09, 2006 at 04:29:33PM +0200, Ying Zhang wrote: > hi stefan, > > I'm wondering if the return type 'int' of the mil command 'count' is > correct. According to help("count"): > > ... > COMMAND: count(BAT[any,any]) : int > MODULE: algebra > COMPILED: by adm on Mon Aug 7 15:11:12 2006 > Returns the number of elements currently in a BAT. > ... > > what if I want to count a BAT[oid,oid] which contains a max. nr. of BUNs > that a BAT with 64bits oid can have. would this be a problem, since > 'oid' is of 64bits on 64bits machines, while 'int' is of 32bits? or is > a mil 'int' different than a C 'int', namely the size of a mil 'int' > also varias in different machines? > > Thanks > > Jennie -- | 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] MonetDB-XQuery and C#
by Arthur van Bunningen 11 Aug '06

11 Aug '06

Dear all, As we are writing a windows application which will store and query structured documents in a database and we want to use MonetDB/XQuery as database backend, we wondered what the easiest method is to access MonetDB/XQuery from C#. For what it's worth: parsing the XML results is of course no problem, and ODBC is supported. Hopefully some of you can point us to a workable solution. Thanks in advance, Arthur

4 3

[MonetDB-users] xquery over large amount of small documents
by Martijn Faassen 02 Aug '06

02 Aug '06

Hi there, I asked something like this question last year and I'm basically checking up on the progress since then. I hope this mail is not interpreted as demanding anything; I can see you guys are doing impressive work, I'm just trying to give feedback from the perspective of an application developer drooling over the potential of XML databases.. I can see on your website that collections() support is not there yet (marked as "will", though). I also looked at this page: http://monetdb.cwi.nl/XQuery/Overview/Roadmap/index.html 'many small documents' is not listed on this roadmap. On another roadmap page however: http://monetdb.cwi.nl/Development/Roadmap/index.html I do see the following entry (for the september release this year): XQuery: support for large numbers of small documents This gives me hope. :) Is that still the plan? If so, it might be useful to update the XQuery roadmap with that tidbit from the main MonetDB roadmap, as I might not be the only one who is looking for such features. My use case is that of a CMS - large amounts of smaller XML documents that it would be nice to do efficient queries over. Updating small parts of documents (XUpdate) would be nice, but whole-document updates would be okay already, though that might actually mean something like XUpdate to you guys, as you might deal with collections internally as something close to one giant document. Monet is tantalizing because it promises supreme xquery performance but the applications I can imagine do need support for large quantities of smaller documents. If there's a version under development somewhere that supports this feature I'd be happy to try playing with it and give some feedback. Thanks for the attention! Regards, Martijn

2 2

[MonetDB-users] Question about MonetDB ODBC driver configuration
by china-davy 27 Jul '06

27 Jul '06

Hi: I have installed MonetDB (Operationg system is windows xp) and the ODBC driver.I want to connet the MonetDB server through ODBC driver,so I must do some configuration work,for example the "databasename,username,and so on".But the configuration work is forbidded(When I click the "MonetDB" in the windows ODBC Manager,nothing happned to let me do configure work,and,not error message )?could you tell me why,and,how to confiigure the ODBC? -- View this message in context: http://www.nabble.com/Question-about-MonetDB-ODBC-driver-configuration-tf19… Sent from the monetdb-users forum at Nabble.com.

2 1

[MonetDB-users] 回复: help! where i get manual
by Fabian 17 Jul '06

17 Jul '06

Hi Peter Chen, I'm not very familiar with ODBC. I'm sending your question to the monetdb-users mailing list. I expect someone there to be able to better answer your question. Regards On 12-07-2006 09:08:59 +0800, liudawei wrote: > Hi Groffen: > > I have install the MonetDB to my computer (Operationg system is windows) and the ODBC driver.I want to connet the MonetDB server through ODBC driver,so I must do some configuration work.But the configuration work is forbidded，could you tell me why,and,how to confiigure the ODBC? > > Fabian <Fabian.Groffen(a)cwi.nl> 写道： Hi, > > Thanks for your interest in MonetDB. The technical documentation of the > MonetDB kernel can be found on our webpage, http://monetdb.cwi.nl/ for > MIL: http://monetdb.cwi.nl/TechDocs/FrontEnds/mil/index.html > > The SQL documentation is limited to how to get yourself going > http://monetdb.cwi.nl/TechDocs/FrontEnds/SQL/index.html > Our SQL syntax is conforming to the SQL/99 standard. We currently have > not made a manual for the SQL/99 standard. A little help I can give you > is that PostgreSQL is fairly SQL/99 conformant as well, and as such > PostgreSQL queries are a good starting point for MonetDB/SQL. > > Regards, > Fabian > > > > liudawei wrote: > > Hi: > > I am a starter on MonetDB,I am interesting in this excllent Database.My > > questions are is: > > 1) where I can get the manual of Monet Server and SQL Front End. > > > > > > best regards > > Peter Chen

3 3

Re: [MonetDB-users] MonetDB XQuery Module Crash
by Michael Schmidt 12 Jul '06

12 Jul '06

Hi all, > I read the discussion, and I might have experienced the same kind of problem > before. I think there is some problem with the naming (when a document is > previously shredded with the same name as a 'cached' document). At the time > I experienced the problem I couldn't figure out what the exact problem was, > but removing the dbfarm worked for me: > > So perhaps you could try to: > - stop Mserver > - completely remove the dbfarm-folder (defaultpath is > "$PREFIX/var/MonetDB/dbfarm") (hopefully you don't have important XML > documents stored in the database ;) > - start Mserver > - and then run the large query (without running any other queries first)? Thank you very much, everything works fine now! Just removed all dbfarm subdirectories and the error message disappeared. And no, there were no important XML documents stored in the database, only some XMark generated streams ;-)! Nevertheless: I never shredded any document before encountering the problem the first time. Before I /only/ used direct loading from the query. I just tried shredding to solve the problem... Hope this helps to locate the bug! Cheers Michael _____________________________________________________________________ Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! http://smartsurfer.web.de/?mc=100071&distributionid=000000000071

3 2

Re: [MonetDB-users] MonetDB XQuery Module Crash
by Michael Schmidt 11 Jul '06

11 Jul '06

Hello Stefan, thank you very much for your engagement! > In the meantime, I have some more questions for you: > > Which version of SuSE Linux and which version of gcc do you use? I am running SuSe Linux 10.0 and gcc (GCC) 4.0.2 20050901 (prerelease) (SUSE Linux). > Which exact version of the MonetDB source do you use? > - The released tar-balls from SourceForge > (MonetDB-4.12.0.tar.gz & MonetDB-XQuery-0.12.0.tar.gz)? Yes, I used the tar balls. During installation I encountered some problems with the bzip library file, but after manual reinstallation of this package from sources everything worked fine. If I can help you debugging, e.g. by running any tests, please let me know. Kind Regards Michael _____________________________________________________________________ Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! http://smartsurfer.web.de/?mc=100071&distributionid=000000000071

2 1

Re: [MonetDB-users] MonetDB XQuery Module Crash
by Stefan Manegold 11 Jul '06

11 Jul '06

On Sun, Jul 09, 2006 at 05:27:17PM +0200, Michael Schmidt wrote: > Hi Stefan, > > 2 more things: > > - I suppose you already posted my mail at MonetDB-users. I can't see them in the archives but I guess they are updated each night, am I right? I honestly don't know, when SF updates the mailinglist archives, but my mail (quoting your original mail) is (now) in there: http://sourceforge.net/mailarchive/forum.php?thread_id=21306336&forum_id=42… > - I just tried loading the XML-document using "shred_doc". It's the same error message, so the crash is independent from the query. hm, strange --- as I just said, it works fine for me on my Athlon 64 x2 running FC4... I'll check another Athlon 64 with SuSE 9.3 later this week... Stefan > Thanks again for your help! > Michael > ______________________________________________________________________________ > Mit WEB.DE iNews werden Sie über die Ergebnisse der wichtigsten WM-Begegnungen > per SMS informiert: http://freemail.web.de/features/inews.htm/?mc=021202 -- | 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

Re: [MonetDB-users] MonetDB XQuery Module Crash
by Stefan Manegold 11 Jul '06

11 Jul '06

Hi Michael, I just double-checked your problem on my AMD Athlon 64 X2 running 64-bit Fedora Core 4, and everything works fine. I can shred and query XMarks documents up to 1.1 GB without problems (didn't try larger ones ;-)). We also have an Athlon 64 running 64-bit SuSE Linux 9.3 --- but I haven't had time to check that one, yet; I'll try to check it the coming days (a 500kB document works fine on that machine in our nightly testing...). In the meantime, I have some more questions for you: Which version of SuSE Linux and which version of gcc do you use? Which exact version of the MonetDB source do you use? - The released tar-balls from SourceForge (MonetDB-4.12.0.tar.gz & MonetDB-XQuery-0.12.0.tar.gz)? - The release source RPMs from SourceForge (MonetDB-4.12.0-1.src.rpm & MonetDB-XQuery-0.12.0-1.src.rpm)? - Source tar-balls or source RPMs from our daily-builds site (http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./)? - A CVS checkout? (Which branch/tag?) Cheers, Stefan ps: I felt free to get let the Monetdb-users mailing list participate in the discussion, again... On Sun, Jul 09, 2006 at 05:14:23PM +0200, Michael Schmidt wrote: > Hi Stefan, > > > Sorry for the inconvenience! > > We'll update the info on the web site. > > And I feel free to propagate this discussion to the Monetdb-users list. > > Thank you very much, I will also register there... > > > Wrt. your actual problem, I have a couple of questions, maily requesting > > more information to analyse the problem: > > > > What kind of system are you running MonetDB/XQuery on? > > CPU (type, 32- or 64-bit)? > > amount of memory? > > free disk space? > > operating system (type, 32- or 64-bit)? > > I'm running SuSe Linux 64-bit, here my /proc/cpuinfo... If there are any more details you need to know feel free to ask me again. > > processor : 0 > vendor_id : GenuineIntel > cpu family : 15 > model : 4 > model name : Intel(R) Pentium(R) 4 CPU 3.00GHz > stepping : 3 > cpu MHz : 2992.716 > cache size : 2048 KB > physical id : 0 > siblings : 2 > core id : 0 > cpu cores : 1 > fpu : yes > fpu_exception : yes > cpuid level : 5 > wp : yes > flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl est cid cx16 xtpr > bogomips : 5994.87 > clflush size : 64 > cache_alignment : 128 > address sizes : 36 bits physical, 48 bits virtual > power management: > > > > How did you install MonetDB/XQuery? Using binary (.rpm or .msi) packages or > > compiling from source (tarball or from CVS)? > > I compiled them from source. > > > Which queries are you running? Which of them are working with up to 50MB but > > fail with 100MB or more? > > It's the same for all queries. I'm running the XMark test Queries #1, #6, #8, #13 and #20. Here one example Query: (XMark #1): > > query1> > { for $b in doc("/home/.../xmark.xml")/site/people/person > where $b/person_id = 'person0' > return > <result> {$b/name} </result> } > </query1> > > > Did you load/shred your document explicitely via the "shred_doc" MIL command > > on the Mserver console, or did you have them loaded/shreded implicitely on > > the fly via the fn:doc() XQuery function? > > As running benchmarks where loading time should be included, explicit console loading is unsuitable. As seen above I load them from the query. > > > In the latter case, you could try whether the failing queries do work in > > larger documents once you increase the XML document cache limit by staring > > Mserver with "--set xquery_cacheMB=<size>" where size is large than the > > default 100, e.g., just larger than your largest document. > > (Admittedly, there is only very little "well hidden" documentation about the > > "--set" option(s) of Mserver; we're working on that...) > > I tested "--set xquery_cacheMB=500" without success. > > Kind regards > Michael > _____________________________________________________________________ > Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! > http://smartsurfer.web.de/?mc=100071&distributionid=000000000071 > > -- | 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

Re: [MonetDB-users] MonetDB XQuery Module Crash
by Stefan Manegold 09 Jul '06

09 Jul '06

Hi Michael, thank you very much for being interested in and using MonetDB/XQuery, as well as for reporting your problem! Apparently, the mailinglist information on the FAQ page of the MonetDB/XQUery web site is indeed a bit misleading. There are actually no specific MonetDB/*XQuery* mailing lists, but "only" general mailing lists for MonetDB that are supposed to be used for all communication about/around MonetDB and all of it's companions and front-ends, o.a., MonetDB/SQL & MonetDB/XQuery; see http://monetdb.cwi.nl/News/MailChannels/ for details. Sorry for the inconvenience! We'll update the info on the web site. And I feel free to propagate this discussion to the Monetdb-users list. Wrt. your actual problem, I have a couple of questions, maily requesting more information to analyse the problem: What kind of system are you running MonetDB/XQuery on? CPU (type, 32- or 64-bit)? amount of memory? free disk space? operating system (type, 32- or 64-bit)? How did you install MonetDB/XQuery? Using binary (.rpm or .msi) packages or compiling from source (tarball or from CVS)? Which queries are you running? Which of them are working with up to 50MB but fail with 100MB or more? Did you load/shred your document explicitely via the "shred_doc" MIL command on the Mserver console, or did you have them loaded/shreded implicitely on the fly via the fn:doc() XQuery function? In the latter case, you could try whether the failing queries do work in larger documents once you increase the XML document cache limit by staring Mserver with "--set xquery_cacheMB=<size>" where size is large than the default 100, e.g., just larger than your largest document. (Admittedly, there is only very little "well hidden" documentation about the "--set" option(s) of Mserver; we're working on that...) If this helps, then there might be a bug somewhere in our document caching code... Kind regards, Stefan On Sun, Jul 09, 2006 at 03:54:30PM +0200, Michael Schmidt wrote: > Hi all, > > I'm confused as I expected a MonetDB XQuery users mailing list instead of > a developer list. However, this list was linked in the MonetDB/XQuery FAQ > section so I thought it would be worth trying... > > Here is my problem: I'm just running some XQuery benchmarks using MonetDB > together with the XQuery module. Installation was ok and I have chosen a > set of queries to be evaluated against data generated with the xmlgen > tool. Query processing works fine for 10MB and 50MB documents, but when > processing large documents (100MB and 200MB) the client reports an error > message. I even tried to figure out the source of the problem using trace > option -t but do not understand the listed error messages. Here is the > final error message reported by the client: > > ERROR: [rename]: 29 times inserted nil due to errors at tuples "pre_size", "pre_level", "pre_prop", "pre_kind", "qn_uri", "qn_prefix". > ERROR: [rename]: first error was: > ERROR: rename(<tmp_351>,pre_size2): operation failed > ERROR: interpret_unpin: [rename] bat=171,stamp=-1285 OVERWRITTEN > ERROR: BBPdecref: tmp_253 does not have pointer fixes. > ERROR: interpret_params: +(param 2): evaluation error. > > Once again: evaluation of the same queries works fine on small streams but > fails on large streams. By the way, I've installed the latest offcial > release of both the server and the XQuery module. > > Is this a bug or are there any default memory limits causing the crash? I > tried to figure out what the --set option is good for but was not able to > detect any documentation on supported options. > > Kind regards > Michael > _____________________________________________________________________ > Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! > http://smartsurfer.web.de/?mc=100071&distributionid=000000000071 > > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Monetdb-developers mailing list > Monetdb-developers(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-developers > -- | 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] MonetDB as a transaction processing XML database?
by Sander Kruseman 06 Jul '06

06 Jul '06

Hello, Is my conclusion correct that I should not use MonetDB (yet) as a transaction processing XML database? (inserts and deletes of lots of XML snippets, xqueries on the complete database content, by multiple processes) Could you perhaps suggest an alternative solution? Any familiarity with Berkely DB XML by Sleepycat for example? Btw. we need a C++ API for this. Thanks in advance. Sander

2 1

[MonetDB-users] MonetDB 4.12.0 Release Announcement
by Fabian Groffen 23 Jun '06

23 Jun '06

It is my great pleasure to announce the availability of MonetDB 4.12.0 and its accompanying SQL 2.12.0 and XQuery 0.12.0. This release is the next step in delivering the high performance database system that has been under development for several years now. Some of the many changes since the 4.10.2 release include: MonetDB/XQuery 0.12.0 (nick-named "Ceres") Various improvments of functionality and performance. Addition of XPath extensions for XML standoff annotations. "Ceres" is a small detour on our trip to "Mars" [1], as update functionality is unfortunately still not robust enough for consumption by the majority. MonetDB/SQL 2.12.0 Many bugfixes. Support for local and global temporary tables. Preliminary support for triggers. For a complete list of new features and known problems, please see the release notes and errata list, available at: http://monetdb.cwi.nl/Development/Roadmap/Version4.12/index.html MonetDB/Five Alpha Release 1 ============================ The efforts on the next generation of MonetDB, version Five, are released now. This snapshot of version Five of MonetDB is the very first alpha release of this ongoing development. Beware: alpha is alpha! This software is only suitable as sneak-preview into the MonetDB developers team's kitchen! Come and taste some of the many delicious spices we prepare. Unlike the previous generation, Five comes with the MAL language, instead of MIL, which makes it completely incompatible with old MIL scripts. However, the SQL sources work fine with this alpha release. Comparing the performance of both backends via SQL should give you an indication of what our cooks will serve for dinner. This first alpha "appetiser" release of MonetDB/Five is nick-named "Tomato Soup". Interested users are invited to visit our MonetDB/Five page for more details: http://monetdb.cwi.nl/Development/Five/index.html Availability ============ The MonetDB family products are supported on i686, x86_64 and ia64 Linux, i686 Solaris 10, ppc and ppc64 Mac OS X 10.4 and i686 Windows XP. Binary distributions are available for Linux and Windows. The new release is available for download from our SourceForge page: http://sourceforge.net/project/showfiles.php?group_id=56967 Acknowledgements ================ Many man-hours were donated by various people to make this release happening. I want to thank al MonetDB developers for their efforts spent into this piece of software. All of our contributors and bug reporters also deserve the credits for the time they put into their contribution. Further Information =================== Further information about MonetDB, MonetDB/SQL and MonetDB/XQuery is available on our web site at: http://monetdb.cwi.nl/ http://monetdb.cwi.nl/SQL/ http://monetdb.cwi.nl/XQuery/ For details about recent changes, migration from earlier versions, and future plans, please visit our roadmap page: http://monetdb.cwi.nl/Development/Roadmap/ User CVS Information ==================== If you use a CVS checkout, you might have to change some things in order to keep on working with the latest sources. With every release some new tags are set and numbers changed. Please check your source trees that you use the right sticky tags on them. The sources that are put in this release are tagged as follows: MonetDB MonetDB_4-12-0 sql SQL_2-12-0 pathfinder XQuery_0-12-0 The new stable branches are now available through the following tags: MonetDB MonetDB_4-12 sql SQL_2-12 pathfinder XQuery_0-12 To update to the new stable branches use ``cvs update -r <branch tag>`` for the repositories you work with. Feedback or Questions ===================== If you have any questions or feedback regarding this release, feel free to contact us through this list: monetdb-users(a)lists.sourceforge.net We hope you will enjoy this new release of MonetDB as much as we do. [1] See http://en.wikipedia.org/wiki/1_Ceres and http://www.nasa.gov/multimedia/imagegallery/image_feature_404.html

1 0

Re: [MonetDB-users] Reminder: MonetDB Bug-Etiquette
by Stefan Manegold 19 Jun '06

19 Jun '06

Dear all, two more small pleas that will make bug reporting and fixing much simpler and smoother: - When submitting a bug, please *always* set both the "Category:" and the "Group:"! This helps the developer(s) to identify which version/part of the system your bug occured with. - When changing the "Status:", "Resolution:", and/or "Priority:", please *always* provide a comment that explans the motivation and/or reason for your action. E.g., when closing a bug report, please mention whether, how and where you fixed it. Thanks again! Stefan On Sun, Jun 18, 2006 at 10:09:13PM +0200, Stefan Manegold wrote: > Dear all, > > since the last MonetDB "BugDay" on Dec 19 2005, many bugs have been reported > and fixed. > > Unfortunately, not all bug reports that have been closed since then have > been backed-up by a test script in CVS to verify and monitor to validity of > the respective bug fix, as described in the "MonetDB Bug-Etiquette" > (cf. one of > http://sourceforge.net/mailarchive/forum.php?thread_id=9021727&forum_id=398… > http://sourceforge.net/mailarchive/forum.php?thread_id=9021726&forum_id=425… > ) > > According to the "MonetDB Bug-Etiquette", a bug report should (may/must) not > be closed without adding a respective test to our test system in CVS. > > While both the user/submitter that reports the bug and the > developer/assignee that fixes it should share the task of "designing" the > test and adding it to the test system in CVS, we agreed that the > developer/assignee is finally "responsible" that the test is indeed added > *before* the bug report is closed. > > > To ensure the stability and correctness of MonetDB and its companions and to > avoid that supposedly fixed bug sneak in again unnoticed, I'd like to ask > all of you that reported and/or fix any bug(s) since Dec 19 2005 > the following favour: > > Please check all "your" bugs (see * below) since Dec 19 2005, whether a test > has been added or not. > + If the comments in the bug report are not clear, please check the CVS > repository. > + If you're a user/submitter and don't know where to look or what to do, > please remind the respective developer/assignee of your bug by added a > respective comment and re-opening the bug report. > + If there is a test, or no test is necessary or feasible, but the > bug-report does not mention this clearly, please add a new comment that > explains the situation. > + If there is no test although there should be one, please re-open the bug > report with a respective comment to indicate that a test must be added. > As said before, "users/submitters" are welcome to help adding tests, but > developers/assignees are finally responsible that the tests are indeed > added. > > Please recall, we plan to release MonetDB 4.12, MonetDB/SQL 2.12 and > MonetDB/XQuery 0.12 soon (i.e., before the end of this month), > and we all want them to be as stable and "bug-free" as possible...! > > > Feel free to use these channels to comment and/or ask questions. > > > Thank you all very much for your contributions to make MonetDB even better > than it already is! > > > Kind regards, > > Stefan > > > *) To find "your" bugs, just > - go to http://sourceforge.net/tracker/?group_id=56967&atid=482468 , > - select your username from the list "Assignee:", > - or enter your username as "Submitter username (show mine):" > (and set "Assignee:" to "Any"), > - set "Status:", "Category:" & "Group:" to "Any", > - set "Sort By:" to "Open Date" and "Descending", > - and click on "Browse". > > -- > | 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 | -- | 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] Reminder: MonetDB Bug-Etiquette
by Stefan Manegold 18 Jun '06

18 Jun '06

Dear all, since the last MonetDB "BugDay" on Dec 19 2005, many bugs have been reported and fixed. Unfortunately, not all bug reports that have been closed since then have been backed-up by a test script in CVS to verify and monitor to validity of the respective bug fix, as described in the "MonetDB Bug-Etiquette" (cf. one of http://sourceforge.net/mailarchive/forum.php?thread_id=9021727&forum_id=398… http://sourceforge.net/mailarchive/forum.php?thread_id=9021726&forum_id=425… ) According to the "MonetDB Bug-Etiquette", a bug report should (may/must) not be closed without adding a respective test to our test system in CVS. While both the user/submitter that reports the bug and the developer/assignee that fixes it should share the task of "designing" the test and adding it to the test system in CVS, we agreed that the developer/assignee is finally "responsible" that the test is indeed added *before* the bug report is closed. To ensure the stability and correctness of MonetDB and its companions and to avoid that supposedly fixed bug sneak in again unnoticed, I'd like to ask all of you that reported and/or fix any bug(s) since Dec 19 2005 the following favour: Please check all "your" bugs (see * below) since Dec 19 2005, whether a test has been added or not. + If the comments in the bug report are not clear, please check the CVS repository. + If you're a user/submitter and don't know where to look or what to do, please remind the respective developer/assignee of your bug by added a respective comment and re-opening the bug report. + If there is a test, or no test is necessary or feasible, but the bug-report does not mention this clearly, please add a new comment that explains the situation. + If there is no test although there should be one, please re-open the bug report with a respective comment to indicate that a test must be added. As said before, "users/submitters" are welcome to help adding tests, but developers/assignees are finally responsible that the tests are indeed added. Please recall, we plan to release MonetDB 4.12, MonetDB/SQL 2.12 and MonetDB/XQuery 0.12 soon (i.e., before the end of this month), and we all want them to be as stable and "bug-free" as possible...! Feel free to use these channels to comment and/or ask questions. Thank you all very much for your contributions to make MonetDB even better than it already is! Kind regards, Stefan *) To find "your" bugs, just - go to http://sourceforge.net/tracker/?group_id=56967&atid=482468 , - select your username from the list "Assignee:", - or enter your username as "Submitter username (show mine):" (and set "Assignee:" to "Any"), - set "Status:", "Category:" & "Group:" to "Any", - set "Sort By:" to "Open Date" and "Descending", - and click on "Browse". -- | 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] join on 2 attributes
by Henning Rode 07 Jun '06

07 Jun '06

hej monet-db-useres, i maybe forgot a very basic thing here, but how do you perform in monet an equi-join on two attributes. it seems such a normal task that there must be something easier than what i did now (see attachment: generating first example instances, then do the join with 'intersect') you should have the same problem when you select on a qname (namespace and tagname), but i could not find that example. if i underspecified my problem, just let me know in advance ;-) best -henning var x_a := new(void,int).seqbase(0@0); x_a.append(1); x_a.append(1); x_a.append(1); x_a.append(2); x_a.append(2); x_a.append(2); x_a := [oid](x_a); var x_b := new(void,int).seqbase(0@0); x_b.append(1); x_b.append(2); x_b.append(4); x_b.append(1); x_b.append(2); x_b.append(4); x_b := [oid](x_b); var y_c := new(void,int).seqbase(0@0); y_c.append(1); y_c.append(2); y_c := [oid](y_c); var y_d := new(void,int).seqbase(0@0); y_d.append(2); y_d.append(1); y_d := [oid](y_d); print(x_a,x_b); print(y_c,y_d); var x_y := join(x_a,y_c.reverse()); var x_d := join(x_y,y_d); intersect(x_b,x_d).print();

1 0

[MonetDB-users] MEL Question: Creating a New Search Accelerator
by John Cieslewicz 05 Jun '06

05 Jun '06

I am trying to build a new search accelerator as described in Section 2.5 of the Monet Extension Language (MEL) User Guide (http://monetdb.cwi.nl/TechDocs/Core/mel/index.html) When I execute mel on my module definition it does not seem to recognize the ".ACCELERATOR" key word. In Section 3.5, "Implementing Accelerators" the 'mean' accelerator implementation is described. Is there an example of the module definition of 'mean' in MEL? I also looked at the mel source code and found that in buildtools/_MEL/mel.yy it appears that 'accelerator' is not part of the grammar for a module: ---- definition: atomdef | command | iterator | builtin | operator | object | MEL_PRELUDE '=' ident ';' { $$.sym = new Prelude(MEL_PRELUDE, $3.s); } | MEL_EPILOGUE '=' ident ';' { $$.sym = new Epilogue(MEL_EPILOGUE, $3.s); } ; --- Questions: (1) Are user defined search accelerator modules actually supported in MonetDB? (2) If so, is there an example of such an accelerator module? (3) If not, what would be the best way to integrate a new index technique into the system? Thanks! -John

1 0

[MonetDB-users] python client library for Windows
by Max 10 May '06

10 May '06

Hello! I'm just installed Python 2.4 and MonetDB-Installer-4.10.2.msi, but can't find precompiled python Mapi modules. Generally, I want to try SQL interface to MonetDB from Python. After some dig around tar.gz sources i've found Mapi.py, MapiClient.py, CMapi.py, MapiLib.py and monet_options.py. Still need binary _MapiLib... Also please clarify meaning of monet_options.py file.

2 1

[MonetDB-users] RHEL 4 x86_64 RPMs
by Henk van Lingen 03 May '06

03 May '06

On Fri, Apr 28, 2006 at 06:44:42PM +0200, Stefan Manegold wrote: > > > RPM build errors: > > > File not found by glob: /var/tmp/MonetDB-root/usr/share/MonetDB/lib/*jar > > Can it be that you don't have Java installed on your system? > > Nevertheless I think this is a bug. > > yes, yes, yes: > > - it should also work with REHL4 on x86_64 --- ate least I don't see any > reason why it should not work, provided the systems installed properly; we > actually build RPMs every night on an Itanium running > "Red Hat Enterprise Linux WS release 4 (Nahant Update 3)". NB: Itanium <> x86_64, right? > - your problem looks indeed as if (a proper) java (>=1.4) is not installed or > at least not found by configure (check the configure output and/or the > config.log) Right, I didn't install java on the build host (didn't know it was a dep for MonetDB) However, now I installed java-1.4.2-gcj-compat-devel and java-1.4.2-gcj-compat. But the problems persist. After ./configure --enable-bits=64 make make dist make rpm I have: asclepius:src/MonetDB-4.10.2 144% grep java config.log Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-java-awt=gtk --host=x86_64-redhat-linux configure:4068: checking for java configure:4086: found /usr/bin/java configure:4098: result: /usr/bin/java configure:4120: checking for javac configure:4138: found /usr/bin/javac configure:4150: result: /usr/bin/javac configure:4198: checking for javadoc configure:4216: found /usr/bin/javadoc configure:4228: result: /usr/bin/javadoc config.status:955: creating src/mapi/clients/java/Makefile config.status:955: creating src/mapi/examples/java/Makefile ac_cv_path_JAVA=/usr/bin/java ac_cv_path_JAVAC=/usr/bin/javac ac_cv_path_JAVADOC=/usr/bin/javadoc JAVA='/usr/bin/java' JAVAC='/usr/bin/javac' JAVADOC='/usr/bin/javadoc' Do I really need the Sun Java? Cheers, -- Henk van Lingen, Systems & Network Administrator (o- -+ Dept. of Computer Science, Utrecht University. /\ | phone: +31-30-2535278 v_/_ http://henk.vanlingen.net/ http://www.tuxtown.net/netiquette/

3 3

[MonetDB-users] RHEL 3 RPMs
by Henk van Lingen 28 Apr '06

28 Apr '06

Hi, Is there a special reason there are no i686 RPM's anymore like there were until 4.6.0_rc2? I think it's a bit weird there are RPM's for the hobby OS 'FedoraCore' but not for the much used server OS 'RedHat Enterprise 3 (and 4)'? The FedoraCore (which Core?) needs libstdc++.so.6 whereas RHEL 3 only has libstdc++.so.5 ... There also seems to be no SRPM's. Cheers, -- Henk van Lingen, Systems & Network Administrator (o- -+ Dept. of Computer Science, Utrecht University. /\ | phone: +31-30-2535278 v_/_ http://henk.vanlingen.net/ http://www.tuxtown.net/netiquette/

6 14

[MonetDB-users] Issues with concurrent connections using JDBC
by Anderson Supriano 09 Apr '06

09 Apr '06

Hi! I'm working on a research about database performance and I'm running a TPC-W implementation (based on http://www.ece.wisc.edu/~pharm/tpcw.shtml) on some databases (Monet, MySQL, Postgresql). Basically, what is being done is having some emulated browsers generating load on the servlet container (tomcat in my case) that access the database through JDBC. -------------- -------------- ---------------- | Emulated | | Tomcat | | DB | | Browser | -----> | | ------> | | -------------- -------------- ---------------- When running this benchmark with concurrent accesses I'm getting problems. If I try 5 concurrent Emulated Browsers running (and 5 concurrent database connections) everything goes well. The problem starts when I increase the concurrency. With 30 concurrent connections everything goes well for a few minutes and then it stops working. The servlet container stops responding and monet uses low percentage of CPU on this state. When I try to kill tomcat and start again (without killing Monet) it starts working again and stops after a while. Based on this experiment it seems that Monet is still responsive, but the instance of servlet container that was accessing Monet just freezes. I'm trying to investigate it a little more, but since I'm not an expert on MonetDB internals, I'd like to know if there is some known issue like this one or if anyone can have a tip on how to solve this. Since Monet is responsive and the servlet container is freezing, it looks like JDBC driver is doing something that is freezing the container (I used to suspect on application, but since it is working very well with MySQL and Postgresql, it seems to not be the problem). I'll appreciate any help on this subject. Thanks very much for your attention. Best regards, Anderson Supriano

2 2

[MonetDB-users] Commit failure on concurrent transactions
by Anderson Supriano 02 Apr '06

02 Apr '06

Hi! I am running several concurrent transactions on Monet DB using JDBC and I'm getting an error when commiting a transaction: java.sql.SQLException: COMMIT: failed ERROR: COMMIT: transaction is aborted because of concurency conflicts, will ROLLBACK instead at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:2185) at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:1937) at nl.cwi.monetdb.jdbc.MonetConnection.commit(MonetConnection.java:443) Is there a way that this exception can be handled in order to have all transactions working (even if waiting the last one to be finished)? I am using MonetDB-4.10.0 and SQL-2.10.0. Thanks for your cooperation. Best regards, Anderson Supriano

2 2

[MonetDB-users] JDBC: Not all results returned
by Martin Beck 23 Feb '06

23 Feb '06

Hi, I have a simple SQL script which starts like this: CREATE TABLE people ( pid integer NOT NULL PRIMARY KEY, name varchar(40) NOT NULL DEFAULT '', number varchar(15) NOT NULL UNIQUE DEFAULT '0', email varchar(100) NOT NULL, spid integer NOT NULL DEFAULT '0' ); Afterwards, it inserts 251 People with ascending pids from 0 to 250. I apply it to the MonetDB database either with MapiClient, or JDBCClient. However, if I login with the JDBCClient and do a "select name,number from people;" i only get 250 rows, not 251! But no error is reported. Instead, a "select count(*) from people;" returns 251. if i try the same with the MapiClient, everything works as expected. the problem seems to be with other tables, too, but there the count of returned rows another one, so I expect it has something to with a packet limit, or something? is it a configuration thing or a bug? with 2.8.2 everything worked. if executed from a java program, the statement returns the exception "protocol violation: unexpected line in data block:"

3 8

[MonetDB-users] network setup
by Colin Foss 15 Feb '06

15 Feb '06

How do you configure MonetDB to listen to connections from anywhere besides the localhost? I can make a local connection but as soon as I try to connect from another computer I get an error. I have even tested with netcat (nc) to make sure there wasn't a firewall blocking the connection. Colin Foss

2 1

[MonetDB-users] Mondrian and MonetDB
by Martin Kersten 31 Jan '06

31 Jan '06

LS, I think the combination of the opensource project Mondrian and MonetDB would be a very strong couple. Especially given the history of MonetDB in the area of datamining. However, the resources at the core team are insufficient at this point in time to embark on such a (short term) project. Perhaps someone in our user community is willing to take up the challenge and report on the problems encountered/ results obtained. The core development teams is particularly interested in missing features, interfacing problems, and, ofcourse, performance problems. regards, Martin ----------------------------------------------- Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=3551757 By: jhyde I'm always happy to add support to Mondrian for another DBMS. The process is fairly well-worn, since we support several DBs already. It's best if someone familiar with the DBMS goes through the process, then I'll integrate the code and update the doc. The process is: 1. Get the MondrianFoodMartLoader working for your DB. 2. Tweak Mondrian's SQL-generation facilities for the capabilities of your DB. Look at SqlQuery.Dialect and you will see the kinds of things that Mondrian cares about. (If your DB has a fairly expressive SQL, and driver provides the appropriate metadata so Mondrian knows what it's capable of, this step may be trivial.) 3. Add your database name as an option for the <SQL dialect="db"> element. (Code is in Mondrian.xml, and elsewhere.) 4. Get the Mondrian regression suite to run cleanly. 5. Provide some typical connect strings for me to put into mondrian.properties. 6. Give me a contact who is willing to run the regression suite on your DB before each release. ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=111375

2 1

[MonetDB-users] MonetDB-SQL 2.10.0 - Status of temorary tables?
by leemarks＠netspace.net.au 31 Jan '06

31 Jan '06

Hi, Are temporary tables currently supported in monetdb-sql? If I do something like, create temporary table foo (abc integer) It fails with a strange error. [Perhaps I'm using invalid syntax?] Thanks in advance, Lee ------------------------------------------------------------ This email was sent from Netspace Webmail: http://www.netspace.net.au

4 8

[MonetDB-users] 8 hours of Photoshop Video Tutorials
by Cole 23 Jan '06

23 Jan '06

1 0

[MonetDB-users] MonetDB/Five slotting: on running M4 next to M5
by Fabian Groffen 25 Dec '05

25 Dec '05

Hi list, Scheduled for next year is the (alpha/beta) release of MonetDB/Five, the successor of the current MonetDB generation. MonetDB/Five is the logical successor to its predecessor in terms of speed and performance. However, MonetDB/Five is not fully backwards compatible with it's predecessor. Instead of using the MIL language for kernel operations, it uses MAL. Although many MIL operations can be easily mapped on MAL operations, a fully automatic (and correct) translation of MIL to MAL is not possible. Directly related to this, is the availability of MonetDB/XQuery, which currently heavily relies on the MIL language. The SQL users of MonetDB will be the only ones that will immediately benefit from the improved MonetDB/Five engine, as SQL is fully functional and there is no difference in language or output. Due to this situation where both M4 (curent MonetDB generation) and M5 (MonetDB/Five generation) have it's own advantages (XQuery support, MIL, MAL, better performance) it is most likely that one would like to run both M4 and M5 engines next to each other to benefit from both. This would currently cause problems when applied out of the box. Given that M4 and M5 would be slotted, and hence installable next to each other, starting it's services would cause problems because both engines try to bind to the same ports by default. To give a short view on the ports in use by default: M4 M5 Mapi 50000 50000 SQL 45123 45123 XQuery 45789 N/A This obviously clases for default MIL/MAL (Mapi) connections as well as SQL connections. XQuery is not an issue for the moment. A few observations: - The actual language spoken over the Mapi server port is engine specific, i.e. MIL for M4 and MAL for M5. This is probably somewhat confusing. For SQL it is clear, and the port specifies which language to use, regardless the engine. - XQuery support is not available for M5 yet, but it should be dealt with as for SQL. Possible scenarios to solve the problems of clashing ports can be: 1. Use different port numbers based on the engine, i.e. use 55123 for SQL on M5 and 45123 on M4. Mapi could become something like 50005 for M5. 2. Build (or extend for instance the DatabasePool) an application that handles transparently the request for a service making use of a combination of port and challenge response to give the client a M4 MIL, M5 MAL, M5 SQL or M4 XQuery connection, using the ports currently known. (Note: this also allows for multi-catalog support for SQL, when the DatabasePool is taken as base.) 3. Ignore the problem and only document it, including how to change the default ports to avoid clashes. (Note: unfortunately we're unable to bind to a certain interface...) 4. A combination between 1 and 2, with the purpose of getting each language it's own port in the system, reducing the problem and possibly disable M4's SQL server. Are end-users interested in/aided by such changes made, or will they figure out themselves easily enough? Just a few thoughts on a problem that will arise in distribution land...

1 0

[MonetDB-users] MonetDB Bug-Etiquette
by Stefan Manegold 24 Nov '05

24 Nov '05

Dear MonetDB-users and -developers, bug reports and especially test script play a crucial role with maintaining and improving the stability and correct functioning of MonetDB. However, adding test scripts "a posteriori" as we did recently during the two "MonetDB-Bug-Days" (a third one is still to come before the end of this year!) is a very tedious and time-consuming task, especially since who ever is adding a test script first needs to get familiar with the details of the very bug report. Since both the user who submits a bug report and the developer(s) who take(s) care of fixing a bug are by definition very familiar with the details of a bug report, it seems more than obvious that they should share the task of adding a test script to the CVS repository while dealing with the respective bug, i.e., *before* closing the bug report. Ideally, the user/submitter provides the query or script that triggers the bug as well as the expected/correct output with his/her bug report. In case the user/submitter has CVS check-in privileges, he/she could add the test script to the CVS repository him-/herself. Otherwise, the developer/assignee should add the user's test script to the CVS repository. The test script helps both the developer/assignee and the user/submitter to monitor the status of the bug by running "Mtest[.py]" (cf., http://monetdb.cwi.nl/monet/src/testing/README) or by checking the TestWeb (http://monetdb.cwi.nl/Development/TestWeb/) To coordinate this procedure, I made a first draft for a "MonetDB Bug Etiquette", which you find attached to this mail. I'd be very pleased, if you could comment on this. Thank you all very much for your contribution to make MonetDB even better than it already is! Kind regards, Stefan -- | 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 |

4 10

[MonetDB-users] MonetDB 10.000 downloads
by Martin Kersten 20 Nov '05

20 Nov '05

LS, It is my pleasure to announce that on Nov 19, 2005 around 23:00 GMT we reached the first 10.000 downloads of MonetDB packages (MonetDB+SQL+XQuery) available on Sourceforge. Let's go the 100.000 ! regards, Martin

1 0

[MonetDB-users] Still can't compile under FreeBSD
by Eugene Rogoza 31 Oct '05

31 Oct '05

Hello everybody, I can't compile MonetDB from sources no matter what I do. Even with the patch from Marcel. I've been trying to compile the MonetDB-4.8.2 sources as well as CVS version. What I get is attached below. Could someone point out the exact steps to compile this stuff on FreeBSD 5.3? I would be very grateful. Eugene root@inspiron:~/MonetDB-4.8.2/FreeBSD> gmake cd .. && /usr/local/bin/bash /root/MonetDB-4.8.2/conf/missing --run aclocal-1.9 /usr/X11R6/share/aclocal/xmms.m4:17: warning: underquoted definition of XMMS_TEST_VERSION run info '(automake)Extending aclocal' or see http://sources.redhat.com/automake/automake.html#Extending-aclocal /usr/X11R6/share/aclocal/xmms.m4:62: warning: underquoted definition of AM_PATH_XMMS /usr/X11R6/share/aclocal/oaf.m4:4: warning: underquoted definition of AM_PATH_OAF /usr/X11R6/share/aclocal/libglade.m4:7: warning: underquoted definition of AM_PATH_LIBGLADE /usr/X11R6/share/aclocal/libart.m4:11: warning: underquoted definition of AM_PATH_LIBART /usr/X11R6/share/aclocal/imlib.m4:9: warning: underquoted definition of AM_PATH_IMLIB /usr/X11R6/share/aclocal/imlib.m4:167: warning: underquoted definition of AM_PATH_GDK_IMLIB /usr/X11R6/share/aclocal/gtk.m4:7: warning: underquoted definition of AM_PATH_GTK /usr/X11R6/share/aclocal/gdk-pixbuf.m4:12: warning: underquoted definition of AM_PATH_GDK_PIXBUF /usr/X11R6/share/aclocal/gconf-1.m4:4: warning: underquoted definition of AM_PATH_GCONF /usr/X11R6/share/aclocal/gconf-1.m4:71: warning: underquoted definition of AM_GCONF_SOURCE aclocal:configure.in:74: warning: macro `AM_MONETDB_COMPILER' not found in library aclocal:configure.in:75: warning: macro `AM_MONETDB_TOOLS' not found in library aclocal:configure.in:76: warning: macro `AM_MONETDB_OPTIONS' not found in library aclocal:configure.in:77: warning: macro `AM_MONETDB_LIBS' not found in library cd .. && /usr/local/bin/bash /root/MonetDB-4.8.2/conf/missing --run autoconf configure.in:74: error: possibly undefined macro: AM_MONETDB_COMPILER If this token and others are legitimate, please use m4_pattern_allow. See the Autoconf documentation. configure.in:75: error: possibly undefined macro: AM_MONETDB_TOOLS configure.in:76: error: possibly undefined macro: AM_MONETDB_OPTIONS configure.in:77: error: possibly undefined macro: AM_MONETDB_LIBS WARNING: `autoconf' is missing on your system. You should only need it if you modified `configure.in'. You might want to install the `Autoconf' and `GNU m4' packages. Grab them from any GNU archive site. /usr/local/bin/bash ./config.status --recheck running /usr/local/bin/bash ../configure --no-create --no-recursion checking build system type... i386-unknown-freebsd5.3 checking host system type... i386-unknown-freebsd5.3 checking target system type... i386-unknown-freebsd5.3 checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking for gawk... gawk checking whether make sets $(MAKE)... yes ../configure: line 1898: syntax error near unexpected token `AM_MONETDB_TOOLS' ../configure: line 1898: `AM_MONETDB_TOOLS()' gmake: *** [config.status] Error 2

3 4

[MonetDB-users] FreeBSD compile patch
by Marcel Hamer 21 Oct '05

21 Oct '05

Hello, The following, very small, patch makes MonetDB compile without errors and warnings on a FreeBSD 5.4 system. I was able to succesfully compile and run MonetDB this way on FreeBSD. ----------------------------------------------------------------- +++ ./conf/monet.m4 Wed Oct 19 21:26:01 2005 @@ -236,6 +236,8 @@ yes-*-*) dnl defines that enable the features beyond C89 in the various dnl platforms. Here's what we found working so far... case "$gcc_ver-$host_os" in + *-freebsd*) + ;; *-cygwin*) dnl MonetDB/src/testing/Mtimeout.c fails to compile with dnl "--std=c99" as the compiler then refuses to recognize ------------------------------------------------------------------ Kind regards, Marcel Hamer

2 2

[MonetDB-users] mail Server
by Jone 21 Oct '05

21 Oct '05

Dear monetdb-users(a)lists.sourceforge.net: Bullet-Proof server: Fresh IPs 1024MB RAM P4 CPU 72GB SCSI Dedicated 100M fiber Unlimited Data Transfer Any software Based China US$599.00 per month May use the server for: Bulk web Hosting Direct Mail We also supply email list according to your order and sending out your message for you. Hope to service for you. Cheers! Jone Server Team kezunli666(a)sohu.com For.NoSend: MoreNot(a)yahoo.com

1 0

[MonetDB-users] Huge tables
by Andrei Martsinchyk 04 Oct '05

04 Oct '05

Hello, It seems MonetDB has problem with handling of huge tables (larger than amount of memory available). I tried to load large amount of data into a table using COPY command. I loaded same data (6 millions records, 700+MBytes) few times. Loading was successful two times, on third time server crushed. After crush I could not start the server again, it output messages !WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock. !FATAL: BBPinit: cannot properly process bat/BACKUP/. and exited. Removing of the database data directory did not help much - server output messages !ERROR:mvc_init: unable to create system tables !WARNING: BBPincref: range error 410 Couple minutes later it output !ERROR: BATSIGcrash: Mserver internal error (Segmentation fault), please restart . !ERROR: (One potential cause could be that your disk might be full...) Well, insufficient disk space could be a cause, before server crashed I had approximately 2GB free. But I have cleaned up 10 GB and problem persists. How can I troubleshoot and fix the server ? What are memory / disk space requirements when bulk loading data ? I tested with 32-bit system, 512 MB RAM + 1GB swap, Ubuntu Linux, MonetDB-4.9.3, nightly build dated September 30. -- Best regards, Andrei Martsinchyk mailto:andrei.martsinchyk@gmail.com

2 6

[MonetDB-users] Bulk load
by Andrei Martsinchyk 03 Oct '05

03 Oct '05

Hello, I am trying to pipe output from my application using bulk load. If application produced output like this: CREATE TABLE test (col1 int); COPY 3 RECORDS INTO "test" FROM stdin USING DELIMITERS '\t'; 1 2 NULL COMMIT; I could pipe it to MapiClient -lsql -umonetdb -Pmonetdb, it worked OK. But application does not know how many rows it will produce, until dump out all the records. When I tried to skip record count I got failed assertion error (a bug ?). Anyway, it would fail when encountered COMMIT; at the end. At the same time COPY without record count can load data from a file, but I do not want to put data into temp table and then do load because i want them run in parallel. Could you suggest a way to do the loading ? -- Best regards, Andrei Martsinchyk mailto:andrei.martsinchyk@gmail.com

1 1

[MonetDB-users] SQL: Update table from another table
by Andrei Martsinchyk 08 Sep '05

08 Sep '05

Hello All, Does SQL frontent support updating one table with data from another table ? More formally, if I have two tables create table t1 (id1 int, val1 varchar(255)); and create table t2 (id2 int, val2 varchar(255)); , can I execute statement like this (PostgreSQL syntax): update t1 set val1=val2 from t2 where id1=id2; ? Thanks in advance. -- Best regards, Andrei Martsinchyk mailto:andrei.martsinchyk@gmail.com

2 4

[MonetDB-users] "Large" document collection and MonetDB/XQuery
by Bastiaan Naber 05 Sep '05

05 Sep '05

We have been experimenting with the MonetDB/XQuery at our institure and we have some issues. We have loaded 727 XML documents into MonetDB with the shred_doc() command: shred_doc("{xml file 1}, "1") shred_doc("{xml file 2}, "2") etc... These files are small (4 a 5 kilobytes). When we query these files with the following query the result takes a long time to complete (2 minutes): for $i in ("0", "1", .... "727") return $i Can anyone explain why looping over 727 documents is so slow? We have collected all 727 XML documents into 1 XML file and loaded this in MonetDB and this is a lot faster. The test machine is a 2.8 GHz P4 with 1 GB of memory. Another isue is related to the size of the database on the harddisk. When we fist load the 727 XML documents into the database the database directory contains about 47.000 files and is 50 megabytes in size. When we have excuted a number of querys the size of this directory increases to 1.7 gigabytes!! Can anyone explain this behaviour? Is MonetDB generating somekind of dynamic indices? Thanks for your replys, Bastiaan Naber

3 2

[MonetDB-users] MonetDB/XQuery: performance issues
by Peter van der Kamp 23 Aug '05

23 Aug '05

I've been experimenting with MonetDB/XQuery for some time now and i wonder what kind of machine was used to produce the benchmark results as published on the website. Are there some guidelines ("do's and don'ts") with respect to performance? Peter van der Kamp

3 4

[MonetDB-users] AMD64 version of MonetDB for Windows?
by Cardillo Raymond A Civ AFRL/IFEA 19 Aug '05

19 Aug '05

Has anyone out there taken the time to build an MSI for the AMD64 versions of Windows? The x64 version of Windows was released a few months ago and was available in Beta for a while, so I'm hoping someone has either done this already, or can provide some advice on how to build/compile for this platform. Anyone know of future plans to make this one of the standard platform builds? Windows x64 is only going to grow in popularity from here, especially amongst researchers and others who can benefit from 64 bits. Thanks for any info, Ray Cardillo

2 1

[MonetDB-users] Perl and MonetDB Xquery
by Peter van der Kamp 18 Aug '05

18 Aug '05

LS, As Perl is one of the main programming languages at our institute, I tried the Perl API with MonetDB-Xquery. I succeeded with sending mil statements (with the language parameter set to 'mil') to the server and getting the correct answer, but xqueries failed (with the language parameter set to 'xquery'). This was not a complete surprise as the documentation seems to be ambiguous ("MonetDB/XQuery for POSIX (Linux/Unix) platforms currently only supports MAPI (MonetDB API) to communicate with the XQuery engine."). Following the link to the API's: "Perl binding of the simple Monet API (Mapi) for MIL/SQL database interaction". So, I would like to know if my assumption that currently no xqueries are supported by the Perl API is correct. Peter

4 7

[MonetDB-users] BerkeleyDB
by Rodrigo Schmidt 16 Aug '05

16 Aug '05

Has anyone compared the relative performance between MonetDB (MIL interface) and BerkeleyDB? If so, what were the results? Cheers, Rodrigo

1 0

[MonetDB-users] Re: Support for group by <ordinal> and SQL OLAP functions
by Fabian (MonetDB Project) 12 Aug '05

12 Aug '05

(I'm sending this to the monetdb-users list, as it might help some other people too) Hi, Thanks for your interest in MonetDB/SQL. gustavo wrote: > ... What I´m missing mostly is support for group by a > number of a column. In this way it would be possible to group by na > expression without the use of a derived table (select from select). I don't exactly understand what you want to do. Can you give a concrete (SQL) example that shows what you want to do? I think that would help getting me to understand. > Another > thing that could boost MonetDb usage is SQL OLAP support like stddev, ranks, > running sums/averages, windowing support, rollup and cube. Most of what you mention require a different approach to the data I think. Like running sums or windowing support somehow require you to examine 'streams' of data, thus acting on data as soon as it comes in. I don't think SQL is yet up for this job, the best you can do is simply simulate it. I think CUBE was added to SQL-2003 and therefore might get included, but I don't think on the short term. However, a concrete list of wishes is always welcome! Thanks for your input!

3 2

[MonetDB-users] JDBC driver
by Rodrigo Schmidt 12 Aug '05

12 Aug '05

I installed MonetDB_JDBC-1.2-Blunt-SR1.jar and I am getting the following problem when I try to load MonetDriver using class.forName(): java.lang.UnsupportedClassVersionError: nl/cwi/monetdb/jdbc/MonetDriver (Unsupported major.minor version 49.0). Does any of you know what the problem is? Cheers, Rodrigo

2 9

[MonetDB-users] Problem configuring MonetDB/XQuery
by Peter van der Kamp 11 Aug '05

11 Aug '05

I successfully build MonetDB, prior to configure and build the XQuery front end. However, running configure for this front end stops with: Checking for Mx... no configure: error: No Mx found in PATH I try to build the Mx software, without success. Before continuing I would like to know if the XQuery front end really needs Mx. Thanks. Peter van der Kamp

3 10

[MonetDB-users] inconsistent database
by Rodrigo Schmidt 10 Aug '05

10 Aug '05

Hi, While playing with SQL schemas (creating and eliminating them) I managed to put the database in an inconsistent state. Now I have a schema with nothing inside (neither users nor tables) and apparently I am not able to drop it. When I try, both database server and client crash with an internal error. Is there any monetdb tool that checks the database consistency and recovers it if a problem is identified? Cheers, Rodrigo

2 1

[MonetDB-users] Different storage spaces
by Rodrigo Schmidt 10 Aug '05

10 Aug '05

Hello, In my application I have several processes in a server, each one managing different and non-related pieces of data, which I intend to store in MonetDB databases. As these processes are not related to each other, I would like to put their data in logically different storage spaces, like a different catalog or a different schema inside the database, if not in in different databases themselves. I am just starting with MonetDB and I do not know how I can create new databases, catalogs or schemas and what I should do to configure these things on the server. Can you give me some hints about it? FYI, my application is written in Java and I am using the JDBC interface to connect to the database. Cheers, Rodrigo

2 1

[MonetDB-users] New
by rita kelly 08 Aug '05

08 Aug '05

3 2