- developers-list - monetdb.org

[Monetdb-developers] Cannot get perl talking to monetdb5 nightly stable
by Rt Ibmer 17 Jun '08

17 Jun '08

I am using the nightly stable build of monetdb5. All outside of perl->monetdb seems to be working just fine. I just can't get perl to talk to the db. Here's what I did: - installed from nightly stable source on Fedora 8 - copied the source from http://homepages.cwi.nl/~mk/MonetDB/The-Perl-Library.html into mytest.pl - tried running: perl /tmp/mytest.pl but it came back complaining about missing libs in @INC. So then I added these steps: - /var/tmp/MonetDB-1213632062/MonetDB-client/clients/src/perl - make install and also ran make instlal in the various subdirs like MonetDB-CLI and others (not sure if this step was necessar) Then I tried running the script and this time it executed without the @INC errors. So this was progress. However all I get is this: ------- Start a simple Monet MIL interaction data sources: dbi:monetdb: -------- and then nothing. It just sits there indefinitely. In playing with the source of the .pl I see that it is the "my $dbh = DBI->connect( $dsn, ..." that execution stops at. I have merovingian running and the db is started. I also tried with merovigan stopped and just using mserver5 --dbinit="include sql;" but I had the same result. Am I doing something wrong? Thanks.

1 0

[Monetdb-developers] arrow keys not working in mclient in stable nightly
by Rt Ibmer 16 Jun '08

16 Jun '08

Hi - I use a SSH client to access my Fedora 8 core box. When I was using the RELEASE built I was able to use left/right/up/down/home/end keys within mclient to edit the line. For instance I could push up arrow to have it automatically cycle through the previous lines, and then use left arrow to move over to a part of the line and process to change it. That all worked fine under the RELEASE build. However now that I have built from source the nightly stable (as of a couple nights ago) I can no longer use these keys. For instance when I press UP arrow it simply adds "^[[A" to the line. Other arrow keys / home /end do something similar. Not sure but I think something broke regarding this at some point between the released build and the stable nightly. Thanks.

2 1

[Monetdb-developers] Does monetdb support limit x,y syntax?
by Rt Ibmer 16 Jun '08

16 Jun '08

To get a median I want to use this: select myIntCol from mytable order by myIntCol limit half_table_size,1; This works in mySQL. However I get an error when I use limit with x,y params. If I just use limit x then it limits the return results to just x rows. But what I need to do is tell it to start with row x and only give me 1 row (i.e. "... limit 5000, 1;" when I have 10000 rows in the table. Does MonetDB support this format? If not is there a work around?? Thanks.

2 1

[Monetdb-developers] JDBC connection error: Max number of redirects reached
by Rt Ibmer 15 Jun '08

15 Jun '08

OK I have a strange problem that I have FINALLY narrowed down and hoping someone can help me resolve please. I am using the latest stable nightly MonetDB5 with SQL on Fedora core 8. If I run merovingian and then try to connect to my database using JDBC through my Java app, I get this error returned by JDBC: "Maximum number of redirects reached, aborting connection attempt. Sorry." However, if instead of running merovingian I run this from the shell: mserver5 --dbinit="include sql;" Then my JDBC connection works perfectly!! However, I need to start MonetDB in the background and use merovingian at boot time, so I am stuck. What does this 'maximum number of redirects reached' mean exactly? Why would I get this problem when using merovingian but not when using MonetDB? How can I resolve this or troubleshoot things further? I tried searching the web for this error message but didn't come up with anything related to monetdb. Thank you!!

3 6

[Monetdb-developers] Bad SQL query causes mclient to terminate
by Rt Ibmer 14 Jun '08

14 Jun '08

When working with RELEASE version of MonetDB5 every once in a while I would enter in a bad query into mclient and it would crash the entire server hard - it would not even reboot. I did notice, however, that in the nightly stable release this same issue is handled better, in that it no longer crashes the server (very good news!). However it does result in mclient terminating the connection and closing. Here is how you can reproduce this: 1) run merovingian 2) mclient -lsql --time --database=demo 3) enter this query: sql>select avg(1); and you will get this: MAPI = monetdb@localhost:50000 ACTION= read_line QUERY = select avg(1); ERROR = Connection terminated Timer 3.049 msec <mclient exits> [bash ~] # Am I correct to assume this is not expected behavior? Thanks.

1 0

[Monetdb-developers] Support for stdev() and var() ?
by Rt Ibmer 14 Jun '08

14 Jun '08

Does the very latest version of MonetDB support built-in queries for the mathematical standard deviation and variance functions stdev() and var()? When I try these queries it returns "no such unary operator". I was under the impression that these were fairly standard in the SQL syntax so I am surprised to find this. If this is not supported, can you please let me know if there are any plans to add this and if so in what approximate timeframe? These functions are critical to our use of the db. Thank you.

1 0

Re: [Monetdb-developers] Works fine once, then get Invalid credentials for user monetdb
by Rt Ibmer 14 Jun '08

14 Jun '08

>Probably you aren't but the binpkgs you use are. You'll probably have >less frustrations at this point if you just compile from source, using >the monetdb-install.sh script. What seems wrong here is that the >default path is set to the builddir instead of the target dir. Thanks for the suggestion. My results were mixed. The good news is that in the latest nightly stable build the problems with the intermitant bad passwords and with the server failing to reboot have been fixed! So that is great! However the not-so-good news is that now my JDBC connection is no longer working properly. Do I need to use a newer version of the JDBC driver in conjunction with this latest stable nightly build? If so I could not find it - where do I get it? The problem with the JDBC driver is that when running with merovingian I get: Maximum number of redirects reached, aborting connection attempt. Sorry. then instead of running withmerovingian, as a test I ran with: mserver5 --dbinit="include sql;" and when running that way I get InvalidCredentialsException:checkCredentials:Invalid credentials for user 'monetdb' However I am using the default username and password of monetdb for both and haven't changed this. Furthermore If I run mclient with -umonetdb and specify monetdb as the password it accepts it there just fine. So I assume monetdb is still the default valid username/password for this stable nightly. But for some reason when I pass this as the user name and password in my JDBC connection it won't accept it. As mentioned earlier, this part was working just fine under the released version of MonetDB5. Can someone please help? I am running out of time to get this implemented so I am hoping to close this loop today. Thank you so much!!

2 17

[Monetdb-developers] Did something with Copy Into and nulls change in nightly stable?
by Rt Ibmer 14 Jun '08

14 Jun '08

I found that the nightly stable build of MonetDB5/sql apparently does not like empty values in tbl text records for importing when using Copy Into, even though the field is defined to allow nulls. This is different behavior compared to the RELEASE version, which did allow this. Please allow me to explain... I have a text file like this: field1|field2|| My db has defined field 1 and 2 as varchar null, and field 3 as INT null. When I run the Copy Into command on the nightly stable, it errors out with this: ' from line 0 field 3 not inserted, expecting type int !SQLException:importTable:failed to import table As a quick test I edited the first line of my text file to insert a fake integer into the 3rd field like this: field1|field2|12345| Then I reran the Copy Into command, this time it errored out on the SECOND line (even those it says line 1 it is really 0 index based so its line 2): ' from line 1 field 3 not inserted, expecting type int !SQLException:importTable:failed to import table So it was happy when I inserted the fake data for the field and does not like rows that are empty. Again, this column is defined as int NULL. Was this change intentional? If not I think there is a bug there. How can I important my text file that has many nulls in it, short of going back to the released version, which I cannot do due to problems with that earlier version. Thank you.

2 1

[Monetdb-developers] server locks up on reboot attempt anytime after running mclient
by Rt Ibmer 13 Jun '08

13 Jun '08

I am running a server instance under Amazon EC2 with MonetDB 5 (latest released version) installed. If I boot up the instance and do NOT start or use Monetdb, then I can issue a reboot command at any time, and the system reboots just fine and comes back up. However if I issue the commands: mkdir -p /mnt/MonetDB5/dbfarm merovingian monetdb create demo monetdb start demo mclient -lsql --time --database=demo sql> \q Then when I go to reboot I get the following output in the console and then things hang, and the instance never reboots. Here is the console output I get (more notes on the issue following this output): INIT: Switching to runlevel: 6 INIT: Sending processes the TERM signal Stopping ConsoleKit: [ OK ] Stopping sshd: [ OK ] Stopping crond: [ OK ] Stopping system message bus: [ OK ] Shutting down kernel logger: [ OK ] Shutting down system logger: [ OK ] Shutting down interface eth0: [ OK ] Shutting down loopback interface: [ OK ] iptables: Flushing firewall rules: [ OK ] iptables: Setting chains to policy ACCEPT: filter [ OK ] iptables: Unloading modules: [ OK ] Starting killall: [ OK ] Sending all processes the TERM signal... ------------[ cut here ]------------ kernel BUG at include/linux/tracehook.h:369! invalid opcode: 0000 [#1] SMP last sysfs file: /class/net/sit0/address Modules linked in: sit(U) tunnel4(U) fuse(U) ipv6(U) dm_mirror(U) dm_multipath(U) dm_mod(U) pcspkr(U) ext3(U) jbd(U) mbcache(U) uhci_hcd(U) ohci_hcd(U) ehci_hcd(U) xenblk(U) xennet(U) CPU: 0 EIP: 0061:[<c10254df>] Not tainted VLI EFLAGS: 00210087 (2.6.21.7-2.fc8xen #1) EIP is at release_task+0x38/0x2f1 eax: c12ff000 ebx: c2b9f450 ecx: f5416000 edx: 00000000 esi: c2b9f450 edi: 00000000 ebp: 00000001 esp: ed207e68 ds: 007b es: 007b fs: 00d8 gs: 0000 ss: 0069 Process mserver5 (pid: 1124, ti=ed207000 task=c1404910 task.ti=ed207000) Stack: 00000020 c1404910 00000000 ed7c15b0 c1026918 00000009 00000008 0007b6c0 c1404d64 c1404d64 c14049c4 00000000 c14f30e4 c188bac0 00000000 ed207fb8 c10269fb c14f30e4 00000009 b438a364 c102dcb2 00000000 00000000 00000000 Call Trace: [<c1026918>] do_exit+0x6d6/0x730 [<c10269fb>] sys_exit_group+0x0/0xd [<c102dcb2>] get_signal_to_deliver+0x3d2/0x414 [<c1004be7>] do_notify_resume+0x8c/0x6e6 [<c12038ae>] do_page_fault+0x7a1/0xc24 [<c10e48a8>] copy_to_user+0x3c/0x50 [<c107d766>] sys_select+0x161/0x187 [<c1005765>] work_notifysig+0x13/0x1a ======================= Code: 98 04 00 00 00 74 07 89 f0 e8 e6 98 02 00 8b 86 80 01 00 00 90 ff 48 04 b8 00 f0 2f c1 e8 c5 c7 1d 00 83 be 90 00 00 00 20 74 04 <0f> 0b eb fe 83 be 98 04 00 00 00 74 27 8d 86 a8 04 00 00 e8 ee EIP: [<c10254df>] release_task+0x38/0x2f1 SS:ESP 0069:ed207e68 Fixing recursive fault but reboot is needed! --------------------------------------------------- Note that if I run these same commands mkdir -p /mnt/MonetDB5/dbfarm merovingian monetdb create demo monetdb start demo # OMIT THIS TIME mclient -lsql --time --database=demo But if I DO NOT run mclient, then the problem does not occur and it will reboot fine. However once I run mclient then I am guaranteed to lock up on a reboot with the console output as shown above. What is really bad about this issue in particular is that on EC2 if an instance will not reboot it needs to be terminated. And when terminated all data on the instance is completely detroyed! So I do not get a second chance - once the server is locked out like this it has to be destroyed and a new one built. This is running on 32 bit Fedora Core 8. What is causing this and how can I fix it? Thanks.

2 2

Re: [Monetdb-developers] [MonetDB-users] MonetDB Server dies on connect
by Martin Kersten 13 Jun '08

13 Jun '08

Sjoerd, I was planning to try out the installers on my Vista machine. The previous version is v5.4.0 installed Uninstalling it gives the following error: There is a problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor. You want specific information, or should i manually remove the C:\Program Files\CWI/MonetDB5 Sjoerd Mullender wrote: > Niels Nes wrote: > >> On Fri, Jun 13, 2008 at 09:41:50AM +0200, Robert Schumacher wrote: >> >>> I am using MonetDB server v5.4.0, based on kernel v1.22.0. >>> >>> Deleting those directories worked, thanks. >>> >> We are very interested in learning if this bug is fixed in >> the (tobe released) version (MonetDB v5.6.0 / sql 2.24 / kernel 1.24). >> >> Sjoerd are there allready windows installers for XP x64 to be tested? >> > > The following files are available for download. Note that these > installers are *completely untested*. > > Since the 64-bit version has a new so-called Upgrade Code (the code that > Windows uses to determine whether a package is an upgrade of an already > installed package), you need to first uninstall the old version and then > install the new. > > Note that the ODBC driver is no longer packaged in the MonetDB5-SQL > installer but only as a separate installer. Also note that you should > install both 32-bit and 64-bit versions of the ODBC installer on a > 64-bit platform. > > http://homepages.cwi.nl/~sjoerd/downloads/MonetDB5-SQL-Installer-x86_64-200… > http://homepages.cwi.nl/~sjoerd/downloads/MonetDB5-SQL-Installer-i386-20080… > http://homepages.cwi.nl/~sjoerd/downloads/MonetDB-ODBC-Installer-x86_64-200… > http://homepages.cwi.nl/~sjoerd/downloads/MonetDB-ODBC-Installer-i386-20080… > > The files with x86_64 in the names are 64-bit, the files with i386 in > the names are 32 bit. > > >> Niels >> >>> Robert >>> >>> -----Ursprüngliche Nachricht----- >>> Von: monetdb-users-bounces(a)lists.sourceforge.net [mailto:monetdb-users-bounces@lists.sourceforge.net] Im Auftrag von Niels Nes >>> Gesendet: Freitag, 13. Juni 2008 09:37 >>> An: Communication channel for MonetDB users >>> Betreff: Re: [MonetDB-users] MonetDB Server dies on connect >>> >>> On Tue, Jun 10, 2008 at 02:51:22PM +0200, Robert Schumacher wrote: >>> >>>> Hello, >>>> >>>> i was evaluating MonetDB. Got the Server running finr on Windows XP x64. I created about 12 Tabled by using a JDBC Client, then the Server died instantly. Since then when I start the Server it dies asap when I either start the Windows Client or perform a JDBC connection. I get no error log, no message, nothing. Has anybody an idea how to get MonetDB to stop crashing on connect? >>>> >>>> >>> Which version of MonetDB are you using? As you seem to have hit a bug, >>> the only solution out of the crash seems to be to remove the dbfarm (and >>> xquery_logs/sql_logs) directories. >>> >>> Niels >>> >>>> Thanks, >>>> Robert >>>> >>>> Robert Schumacher, Senior Software Developer >>>> >>>> prevero Systems GmbH >>>> Landsberger Straße 154 >>>> 80339 München >>>> >>>> Tel +49 89 455 77 - 0 >>>> Fax +49 89 455 77 - 200 >>>> >>>> Registergericht: Amtsgericht München, HRB 143809 -- Geschäftsführer: Matthias Thurner >>>> >>>> Bitte beachten Sie unsere Veranstaltungshinweise unter www.prevero.de >>>> >>>> >>>> >>>> ------------------------------------------------------------------------- >>>> Check out the new SourceForge.net Marketplace. >>>> It's the best place to buy or sell services for >>>> just about anything Open Source. >>>> http://sourceforge.net/services/buy/index.php >>>> _______________________________________________ >>>> MonetDB-users mailing list >>>> MonetDB-users(a)lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/monetdb-users >>>> >>> -- >>> >>> 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 >>> >>> ------------------------------------------------------------------------- >>> Check out the new SourceForge.net Marketplace. >>> It's the best place to buy or sell services for >>> just about anything Open Source. >>> http://sourceforge.net/services/buy/index.php >>> _______________________________________________ >>> MonetDB-users mailing list >>> MonetDB-users(a)lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/monetdb-users >>> >>> ------------------------------------------------------------------------- >>> Check out the new SourceForge.net Marketplace. >>> It's the best place to buy or sell services for >>> just about anything Open Source. >>> http://sourceforge.net/services/buy/index.php >>> _______________________________________________ >>> MonetDB-users mailing list >>> MonetDB-users(a)lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/monetdb-users >>> > > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > ------------------------------------------------------------------------ > > _______________________________________________ > MonetDB-users mailing list > MonetDB-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users >

2 1