- users-list - monetdb.org

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

18 Jun '07

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

3 3

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

18 Jun '07

1 0

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

16 Jun '07

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

1 0

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

15 Jun '07

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

1 0

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

14 Jun '07

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

2 2

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

14 Jun '07

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

2 1

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

14 Jun '07

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

1 0

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

12 Jun '07

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

3 3

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

08 Jun '07

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

1 0

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

08 Jun '07

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

3 6