- users-list - monetdb.org

[MonetDB-users] Announcement: New Aug2011-SP2 Bugfix release of MonetDB suite
by MonetDB Release Engineer 26 Oct '11

26 Oct '11

The MonetDB team at CWI/MonetDB BV is pleased to announce the Aug2011-SP2 bugfix release of the MonetDB suite of programs. More information about MonetDB can be found on our website at http://www.monetdb.org/. For details on this release, please see the release notes at <http://www.monetdb.org/Downloads/ReleaseNotes>. As usual, the download location is <http://dev.monetdb.org/downloads/>. Aug 2011-SP2 bugfix release Client Package * ODBC: Implemented a workaround in SQLTables for bug 2908. * Small improvement to mclient's table rendering for tables without any rows. Previously, the column names in the header could be squeezed to very small widths, degrading readability. * Python DB API connect() function now supports PEP 249-style arguments user and host, bug #2901 * mclient now checks the result of encoding conversions using the iconv library. * Fixed a source of crashes in mclient when a query on the command line using the -s option is combined with input on standard input (e.g. in the construct mclient -s 'COPY INTO t FROM STDIN ...' < file.csv). * Fixed bug 2897 where slow (network) reads could cause blocks to not be fully read in one go, causing errors in the subsequent use of those blocks. With thanks to Rémy Chibois. * Fixed a bug in mclient where processing queries from files could result in ghost empty results to be reported in the output Merovingian * Resolved problem where monetdbd would terminate abnormally when databases named 'control', 'discovery' or 'merovingian' were stopped. * monetdbd get status now also reports the version of the running monetdbd * Improved response time of 'monetdb start' when the database fails to start. * Fixed a bug in monetdbd where starting a failing database could incorrectly be reported as a 'running but dead' database. * To avoid confusion, all occurrences of merovingian were changed into monetdbd for error messages sent to a client. Bug Fixes * 2346: mkey.bulk_rotate_xor_hash MAL exception * 2712: un-rolled-back savepoints cause crash upon scenario exit * 2774: COPY INTO of double (~1.0e-310) cannot be imported. * 2890: Slow execution of COUNT in combination with DISTINCT * 2894: No consistent behavior of implicit cast of integer to double * 2897: Mapi.pm: short reads not handled when reading blocks from server * 2898: order by for multiple (two) columns fails for large tables when second ordering is 'desc': "mat.refine_reverse' undefined" * 2900: rand(int) should not return NULL * 2901: Make keyword arguments in Python DB API connect() function more standard * 2904: TypeException after calling UDF in other than sys schema (when it is initialised) * 2906: "ALTER TABLE mytable SET READ ONLY" results in server segfault * 2908: SQL query produces error with MAL statements * 2909: query result is not displayed when history = true

1 0

[MonetDB-users] Newbie just joined this group :)
by Tony Bai 26 Oct '11

26 Oct '11

Hi guys, I just joined this amazing group, May I asking a stupid question about Monetdb if I haven't run out my 'ask stupid question' budget? My question are as following: * Regarding to the work cluster, Does Monetdb support smoothly expand while I have to add new server to the work cluster in necessary? How to add a new server to a work cluster? * Does Monetdb supply any analytical functions? Do we have any documents or materials related to what kind of analytical functions can be used? BTW: Any advices or suggestions regarding building data mart with Monetdb would be highly appreciated! Thanks in advance, Tony

1 0

[MonetDB-users] Examples of usage
by Jeremy O'Sullivan 25 Oct '11

25 Oct '11

Hello, I am presently evaluating MonetDB's performance for a client using big data sets. We are very happy with the impressive results. Something that is harder to evaluate is how wide spread is MonetDB's usage. There are some references on the home page, but as it says in the introductory passage, most usage applications are anonymous. Would anyone like to share examples of applications that are using MonetDB ? Regards, Jeremy

2 1

[MonetDB-users] Network unreachable errors in log
by Jeremy O'Sullivan 21 Oct '11

21 Oct '11

Hello, The log file, merovingian.log, contains many occurrences of the below: 2011-10-21 17:20:47 ERR discovery[4680]: error while sending broadcast message: Network is unreachable The database seems to be performing ok. What causes this issue, would this affect the performance of the database ? Regards, Jeremy

2 1

Re: [MonetDB-users] ODBC connection issues
by Jeremy O'Sullivan 20 Oct '11

20 Oct '11

Hi, I have downloaded the patch for the ODBC driver on windows 2003 32 bit (after uninstalling the existing odbc driver) and tried to view the schema from excel, through the excel odbc connection. I get the exact same error as before. Regards, Jeremy

3 2

Re: [MonetDB-users] ODBC connection issues
by Jeremy OSullivan 20 Oct '11

20 Oct '11

Hi, The dialogue comes back with the same error message. I tried it in access as well. I am not able to see the schema, not to mind query it. The log may be different, I have attached the output. I asked my colleague to download and try on his machine, he got the same issue. Regards, Jeremy MSACCESS f68-f54 ENTER SQLAllocConnect HENV 09E41788 HDBC * 00139820 MSACCESS f68-f54 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS) HENV 09E41788 HDBC * 0x00139820 ( 0x09e426b8) MSACCESS f68-f54 ENTER SQLSetConnectOption HDBC 09E426B8 SQLINTEGER 103 <SQL_LOGIN_TIMEOUT> SQLPOINTER 0x00000014 MSACCESS f68-f54 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS) HDBC 09E426B8 SQLINTEGER 103 <SQL_LOGIN_TIMEOUT> SQLPOINTER 0x00000014 (BADMEM) MSACCESS f68-f54 ENTER SQLSetConnectAttrW SQLHDBC 09E426B8 SQLINTEGER 30002 <unknown> SQLPOINTER [Unknown attribute 30002] SQLINTEGER -3 MSACCESS f68-f54 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 09E426B8 SQLINTEGER 30002 <unknown> SQLPOINTER [Unknown attribute 30002] SQLINTEGER -3 MSACCESS f68-f54 ENTER SQLDriverConnectW HDBC 09E426B8 HWND 0018019E WCHAR * 0x4BF77CD4 [ -3] "******\ 0" SWORD -3 WCHAR * 0x4BF77CD4 SWORD 2 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> MSACCESS f68-f54 EXIT SQLDriverConnectW with return code 1 (SQL_SUCCESS_WITH_INFO) HDBC 09E426B8 HWND 0018019E WCHAR * 0x4BF77CD4 [ -3] "******\ 0" SWORD -3 WCHAR * 0x4BF77CD4 SWORD 2 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0) MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 9 <SQL_ODBC_API_CONFORMANCE> PTR 0x0013981C SWORD 2 SWORD * 0x00139824 MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 9 <SQL_ODBC_API_CONFORMANCE> PTR 0x0013981C (1) SWORD 2 SWORD * 0x00139824 (2) MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 6 <SQL_DRIVER_NAME> PTR 0x00139828 SWORD 200 SWORD * 0x00139824 MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 6 <SQL_DRIVER_NAME> PTR 0x00139828 [ 28] "MonetDBODBClib" SWORD 200 SWORD * 0x00139824 (28) MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 46 <SQL_TXN_CAPABLE> PTR 0x001393DC SWORD 2 SWORD * 0x001393A0 MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 46 <SQL_TXN_CAPABLE> PTR 0x001393DC (2) SWORD 2 SWORD * 0x001393A0 (2) MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR> PTR 0x039C6138 SWORD 2 SWORD * 0x001393A0 MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR> PTR 0x039C6138 (0) SWORD 2 SWORD * 0x001393A0 (2) MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR> PTR 0x039C613A SWORD 2 SWORD * 0x001393A0 MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR> PTR 0x039C613A (0) SWORD 2 SWORD * 0x001393A0 (2) MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 1 <SQL_ACTIVE_STATEMENTS> PTR 0x001393E4 SWORD 2 SWORD * 0x001393B8 MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 1 <SQL_ACTIVE_STATEMENTS> PTR 0x001393E4 (0) SWORD 2 SWORD * 0x001393B8 (2) MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 17 <SQL_DBMS_NAME> PTR 0x001397E4 SWORD 200 SWORD * 0x001397E0 MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 17 <SQL_DBMS_NAME> PTR 0x001397E4 [ 14] "MonetDB" SWORD 200 SWORD * 0x001397E0 (14) MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 0 <SQL_ACTIVE_CONNECTIONS> PTR 0x001398E0 SWORD 2 SWORD * 0x001398E8 MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 0 <SQL_ACTIVE_CONNECTIONS> PTR 0x001398E0 (0) SWORD 2 SWORD * 0x001398E8 (2) MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 25 <SQL_DATA_SOURCE_READ_ONLY> PTR 0x001398EC SWORD 20 SWORD * 0x001398E8 MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 25 <SQL_DATA_SOURCE_READ_ONLY> PTR 0x001398EC [ 2] "N" SWORD 20 SWORD * 0x001398E8 (2) MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 46 <SQL_TXN_CAPABLE> PTR 0x001398E4 SWORD 2 SWORD * 0x001398C0 MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 46 <SQL_TXN_CAPABLE> PTR 0x001398E4 (2) SWORD 2 SWORD * 0x001398C0 (2) MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR> PTR 0x001398DC SWORD 2 SWORD * 0x001398C0 MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR> PTR 0x001398DC (0) SWORD 2 SWORD * 0x001398C0 (2) MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR> PTR 0x001398D8 SWORD 2 SWORD * 0x001398C0 MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR> PTR 0x001398D8 (0) SWORD 2 SWORD * 0x001398C0 (2) MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR> PTR 0x001398EC SWORD 20 SWORD * 0x001398E8 MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR> PTR 0x001398EC [ 2] """ SWORD 20 SWORD * 0x001398E8 (2) MSACCESS f68-f54 ENTER SQLAllocStmt HDBC 09E426B8 HSTMT * 00137C38 MSACCESS f68-f54 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS) HDBC 09E426B8 HSTMT * 0x00137C38 ( 0x09e41a28) MSACCESS f68-f54 ENTER SQLGetStmtOption HSTMT 09E41A28 UWORD 0 PTR 0x00137B40 MSACCESS f68-f54 EXIT SQLGetStmtOption with return code -1 (SQL_ERROR) HSTMT 09E41A28 UWORD 0 PTR 0x00137B40 DIAG [HYC00] [MonetDB][ODBC Driver 11.5.6]Optional feature not implemented (0) MSACCESS f68-f54 ENTER SQLErrorW HENV 09E41788 HDBC 09E426B8 HSTMT 09E41A28 WCHAR * 0x00137AEC (NYI) SDWORD * 0x00137AB8 WCHAR * 0x0374A000 SWORD 4095 SWORD * 0x00137AAC MSACCESS f68-f54 EXIT SQLErrorW with return code 0 (SQL_SUCCESS) HENV 09E41788 HDBC 09E426B8 HSTMT 09E41A28 WCHAR * 0x00137AEC (NYI) SDWORD * 0x00137AB8 (0) WCHAR * 0x0374A000 [ 61] "[MonetDB][ODBC Driver 11.5.6]Optional feature not implemented" SWORD 4095 SWORD * 0x00137AAC (61) MSACCESS f68-f54 ENTER SQLErrorW HENV 09E41788 HDBC 09E426B8 HSTMT 09E41A28 WCHAR * 0x00137AEC (NYI) SDWORD * 0x00137AB8 WCHAR * 0x0374A08C SWORD 4025 SWORD * 0x00137AAC MSACCESS f68-f54 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND) HENV 09E41788 HDBC 09E426B8 HSTMT 09E41A28 WCHAR * 0x00137AEC (NYI) SDWORD * 0x00137AB8 WCHAR * 0x0374A08C SWORD 4025 SWORD * 0x00137AAC MSACCESS f68-f54 ENTER SQLTablesW HSTMT 09E41A28 WCHAR * 0x00000000 SWORD 0 WCHAR * 0x00000000 SWORD 0 WCHAR * 0x00000000 SWORD 0 WCHAR * 0x09E42640 [ -3] "'TABLE','VIEW','SYSTEM TABLE','ALIAS','SYNONYM'\ 0" SWORD -3 MSACCESS f68-f54 EXIT SQLTablesW with return code -1 (SQL_ERROR) HSTMT 09E41A28 WCHAR * 0x00000000 SWORD 0 WCHAR * 0x00000000 SWORD 0 WCHAR * 0x00000000 SWORD 0 WCHAR * 0x09E42640 [ -3] "'TABLE','VIEW','SYSTEM TABLE','ALIAS','SYNONYM'\ 0" SWORD -3 DIAG [HY000] [MonetDB][ODBC Driver 11.5.6]TypeException:user.s2_2[34]:'algebra.markT' undefined in: _74:any := algebra.markT(_73:bit, _69:oid) TypeException:user.s2_2[56]:'algebra.kunion' undefined in: _102:any := algebra.kunion(_101:bat[:oid,:oid], _74:any) TypeException:user.s2_2[57]:'algebra.markT' undefined in: _103:any := algebra.markT(_102:any, _68:oid) TypeException:user.s2_2[62]:'algebra.markT' undefined in: _110:any := algebra.markT(_109:bit, _104:oid) TypeException:user.s2_2[63]:'algebra.kunion' undefined in: _111:any := algebra.kunion(_110:any, _103:any) TypeException:user.s2_2[80]:'algebra.semijoin' undefined in: _133:any := algebra.semijoin(_132:bat[:oid,:void], _111:any) TypeException:user.s2_2[81]:'algebra.markT' undefined in: _134:any := algebra.markT(_133:any, _67:oid) TypeException:user.s2_2[82]:'bat.reverse' undefined in: _135:any := bat.reverse(_134:any) TypeException:user.s2_2[83]:'algebra.leftjoin' undefined in: _136:any := algebra.leftjoin(_135:any, _64:bat[:oid,:int]) TypeException:user.s2_2[84]:'bat.reverse' undefined in: _137:any := bat.reverse(_136:any) TypeException:user.s2_2[96]:'algebra.join' undefined in: _156:any := algebra.join(_155:bat[:oid,:int], _137:any) TypeException:user.s2_2[97]:'algebra.markT' undefined in: _157:any := algebra.markT(_156:any, _58:oid) TypeException:user.s2_2[98]:'bat.reverse' undefined in: _158:any := bat.reverse(_157:any) TypeException:user.s2_2[99]:'algebra.leftjoin' undefined in: _159:any := algebra.leftjoin(_158:any, _57:bat[:oid,:str]) TypeException:user.s2_2[119]:'algebra.markT' undefined in: _185:any := algebra.markT(_184:bit, _180:oid) TypeException:user.s2_2[195]:'algebra.kunion' undefined in: _273:any := algebra.kunion(_272:bat[:oid,:oid], _185:any) TypeException:user.s2_2[196]:'algebra.markT' undefined in: _274:any := algebra.markT(_273:any, _179:oid) TypeException:user.s2_2[201]:'algebra.markT' undefined in: _281:any := algebra.markT(_280:bit, _275:oid) TypeException:user.s2_2[202]:'algebra.kunion' undefined (0) MSACCESS f68-f54 ENTER SQLErrorW HENV 09E41788 HDBC 09E426B8 HSTMT 09E41A28 WCHAR * 0x00137B00 (NYI) SDWORD * 0x00137ACC WCHAR * 0x0374A000 SWORD 4095 SWORD * 0x00137AC0 MSACCESS f68-f54 EXIT SQLErrorW with return code 0 (SQL_SUCCESS) HENV 09E41788 HDBC 09E426B8 HSTMT 09E41A28 WCHAR * 0x00137B00 (NYI) SDWORD * 0x00137ACC (0) WCHAR * 0x0374A000 [ 4095] "[MonetDB][ODBC Driver 11.5.6]TypeException:user.s2_2[34]:'algebra.markT' undefined in: _74:any := algebra.markT(_73:bit, _69:oid)\ aTypeException:user.s2_2[56]:'algebra.kunion' undefined in: _102:any := algebra.kunion(_101:bat[:oid,:oid], _74:any)\ aTypeException:user.s2_2[57]:'algebra.markT' undefined in: _103:any := algebra.markT(_102:any, _68:oid)\ aTypeException:user.s2_2[62]:'algebra.markT' undefined in: _110:any := algebra.markT(_109:bit, _104:oid)\ aTypeException:user.s2_2[63]:'algebra.kunion' undefined in:\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0..." SWORD 4095 SWORD * 0x00137AC0 (8055) MSACCESS f68-f54 ENTER SQLErrorW HENV 09E41788 HDBC 09E426B8 HSTMT 09E41A28 WCHAR * 0x00137B00 (NYI) SDWORD * 0x00137ACC WCHAR * 0x0374A410 SWORD 3575 SWORD * 0x00137AC0 MSACCESS f68-f54 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND) HENV 09E41788 HDBC 09E426B8 HSTMT 09E41A28 WCHAR * 0x00137B00 (NYI) SDWORD * 0x00137ACC WCHAR * 0x0374A410 SWORD 3575 SWORD * 0x00137AC0 MSACCESS f68-f54 ENTER SQLFreeStmt HSTMT 09E41A28 UWORD 1 <SQL_DROP> MSACCESS f68-f54 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 09E41A28 UWORD 1 <SQL_DROP> MSACCESS f68-f54 ENTER SQLDisconnect HDBC 09E426B8 MSACCESS f68-f54 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS) HDBC 09E426B8 MSACCESS f68-f54 ENTER SQLFreeConnect HDBC 09E426B8 MSACCESS f68-f54 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS) HDBC 09E426B8

1 0

[MonetDB-users] Problems with the query log
by Viktor Rosenfeld 20 Oct '11

20 Oct '11

Hi, I get errors, when I try to use the query history feature as described here: http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/History After history is set to true, I get the following error message every time I execute a query: invalid/unknown response from server, ignoring output ? = 0:0 profiler.setFootprintFlag(); ? = 0:0 profiler.setMemoryFlag(); ? = 0:0 inblock := profiler.getDiskReads(); ? = 0:0 oublock := profiler.getDiskWrites(); ? = 0:0 xtime := alarm.usec(); (remaining output omitted, use \fraw to examine in detail) This only stops if I set history back to false. I'm using the latest MonetDB 11.5.3 on OS X 10.6. Below is an example session. Cheers, Viktor -----8< sample session >8----- $ mclient -d demo -u monetdb password: Welcome to mclient, the MonetDB/SQL interactive terminal (Aug2011-SP1) Database: MonetDB v11.5.3, 'demo' Type \q to quit, \? for a list of available commands auto commit mode: on sql>set history=true; sql>select 1; invalid/unknown response from server, ignoring output ? = 0:0 profiler.setFootprintFlag(); ? = 0:0 profiler.setMemoryFlag(); ? = 0:0 inblock := profiler.getDiskReads(); ? = 0:0 oublock := profiler.getDiskWrites(); ? = 0:0 xtime := alarm.usec(); (remaining output omitted, use \fraw to examine in detail) sql>select * from queryHistory; invalid/unknown response from server, ignoring output ? = 0:0 profiler.setFootprintFlag(); ? = 0:0 profiler.setMemoryFlag(); ? = 0:0 inblock := profiler.getDiskReads(); ? = 0:0 oublock := profiler.getDiskWrites(); ? = 0:0 xtime := alarm.usec(); (remaining output omitted, use \fraw to examine in detail) sql>set history=false; invalid/unknown response from server, ignoring output ? = 0:0 profiler.setFootprintFlag(); ? = 0:0 profiler.setMemoryFlag(); ? = 0:0 inblock := profiler.getDiskReads(); ? = 0:0 oublock := profiler.getDiskWrites(); ? = 0:0 xtime := alarm.usec(); (remaining output omitted, use \fraw to examine in detail) sql>select * from queryHistory; +---------+----------------------------+---------+-----------------------------+-------+----------+ | id | defined | name | query | parse | optimize | +=========+============================+=========+=============================+=======+==========+ | 1035769 | 2011-10-18 15:51:36.000000 | monetdb | select 1; | 236 | 208 | | 1035885 | 2011-10-18 15:51:47.000000 | monetdb | select * from queryhistory; | 300 | 860 | | 1036047 | 2011-10-18 15:51:50.000000 | monetdb | set history=false; | 130 | 466 | +---------+----------------------------+---------+-----------------------------+-------+----------+ 3 tuples (1.613ms) sql>

2 2

Re: [MonetDB-users] ODBC connection issues
by Jeremy O'Sullivan 20 Oct '11

20 Oct '11

Hi, How do I get the patch, there is no attachment on the bug. Is there a new .msi ? Regards, Jeremy

2 1

[MonetDB-users] Problem with YEAR, MONTH, DAY functions
by Roula Avg 20 Oct '11

20 Oct '11

Hello, sorry to ask again but i have problem with YEAR, MONTH and DAY functions. According to the references YEAR for example can take as argument a date or a timestamp or a month_interval value. So if i run the query: sql> select year(current_timestamp); or sql> select year( '2002-03-21') it should return 2011 and 2002. Instead of this, i take: *syntax error,unexpected YEAR in: "select year". *What am i doing wrong? Thank you very much in advance

3 2

[MonetDB-users] MonetDB Temporary tables
by ultanocarroll 19 Oct '11

19 Oct '11

Hi, I'm trying to create an adapter for Apache Jena[1] to MonetDB[2]. Part of this process involves creating temporary tables in Monet. During the Jena db setup process these tables are created with SQL statements. For most RDBMS these take the form of CREATE GLOBAL TEMPORARY... However, with MonetDB (Aug 11 release on Ubuntu 11.04) I have been unable to use this statement form, or CREATE LOCAL, or CREATE TEMPORARY TABLE. Monet always returns "insufficient privileges", a la : sql>create global temporary table t (col1 int); CREATE TABLE: insufficient privileges for user 'jena' in schema 'tmp' sql>create local temporary table t (col1 int); CREATE TABLE: insufficient privileges for user 'jena' in schema 'tmp' sql>create temporary table t (col1 int); CREATE TABLE: insufficient privileges for user 'jena' in schema 'tmp' (Jena's table is a little more sophisticated but raises the same error ! :-) I have created the user for this operation, an accompanying schema with authorization and reset the users schema to this, as per Getting Started [3]. The only operation I can seem to get to work in place of temporary tables is to use CREATE TABLE. However, when I do this, Jena unit tests fail when it tries to re-create, for a second group of tests, these temp tables, with the exception java.sql.SQLException: CREATE TABLE: name 'nnodetriples' already in use Jena then tries to drop the tables (using execSilent) and create anew, but at this point gets another exception. Caused by: java.sql.SQLException: current transaction is aborted (please ROLLBACK) Any suggestions on this ? 1. It seems to me the root of the problem is that the global temp tables cannot be created, or that the 'already in use' exception is escalating to a transaction abort, incorrectly. 2. Do I need (can I) grant the user privileges to the tmp schema ? [1] http://incubator.apache.org/jena/ [2] https://issues.apache.org/jira/browse/JENA-134 [3] http://www.monetdb.org/Downloads/Tutorial

2 1

Re: [MonetDB-users] ODBC connection issues
by Jeremy O'Sullivan 19 Oct '11

19 Oct '11

Hello, Regarding the ODBC error, I tried connecting to MonetDB using excel and got the same error as I got from OBI EE, see log below: Regards, Jeremy MSQRY32 a18-890 ENTER SQLAllocEnv HENV * 3009DDD4 MSQRY32 a18-890 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS) HENV * 0x3009DDD4 ( 0x00aa1788) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 31 <unknown> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1C4 WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1B6 MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 31 <unknown> WCHAR * 0x00AA1830 [ 11] "dBASE" SWORD 34 SWORD * 0x0012F1C4 (11) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1B6 (51) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1C4 WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1B6 MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 11] "Excel" SWORD 34 SWORD * 0x0012F1C4 (11) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1B6 (54) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1C4 WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1B6 MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 18] "MS Access" SWORD 34 SWORD * 0x0012F1C4 (18) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1B6 (40) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1C4 WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1B6 MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 100 (SQL_NO_DATA_FOUND) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1C4 WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1B6 MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 32 <unknown> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 32 <unknown> WCHAR * 0x00AA1830 [ 12] "Analyt" SWORD 34 SWORD * 0x0012F1BC (12) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (16) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 20] "IncomeAndE" SWORD 34 SWORD * 0x0012F1BC (20) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (40) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 11] "Forec" SWORD 34 SWORD * 0x0012F1BC (11) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (40) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 17] "IncomeEx" SWORD 34 SWORD * 0x0012F1BC (17) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (40) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 10] "DFB F" SWORD 34 SWORD * 0x0012F1BC (10) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (54) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 10] "DFB F" SWORD 34 SWORD * 0x0012F1BC (10) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (54) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 16] "DFB_KPI_" SWORD 34 SWORD * 0x0012F1BC (16) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (54) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 5] "Wa" SWORD 34 SWORD * 0x0012F1BC (5) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (54) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 12] "Profit" SWORD 34 SWORD * 0x0012F1BC (12) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (30) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 7] "Mon" SWORD 34 SWORD * 0x0012F1BC (7) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (19) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 100 (SQL_NO_DATA_FOUND) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 ENTER SQLAllocConnect HENV 00AA1788 HDBC * 0012E698 MSQRY32 a18-890 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS) HENV 00AA1788 HDBC * 0x0012E698 ( 0x00aa1ba8) MSQRY32 a18-890 ENTER SQLSetConnectOption HDBC 00AA1BA8 SQLINTEGER 103 <SQL_LOGIN_TIMEOUT> SQLPOINTER 0x0000002D MSQRY32 a18-890 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 SQLINTEGER 103 <SQL_LOGIN_TIMEOUT> SQLPOINTER 0x0000002D (BADMEM) MSQRY32 a18-890 ENTER SQLDriverConnectW HDBC 00AA1BA8 HWND 0002019A WCHAR * 0x4BF77CD4 [ -3] "******\ 0" SWORD -3 WCHAR * 0x4BF77CD4 SWORD 2 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> MSQRY32 a18-890 EXIT SQLDriverConnectW with return code 1 (SQL_SUCCESS_WITH_INFO) HDBC 00AA1BA8 HWND 0002019A WCHAR * 0x4BF77CD4 [ -3] "******\ 0" SWORD -3 WCHAR * 0x4BF77CD4 SWORD 2 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 2 <SQL_DATA_SOURCE_NAME> PTR 0x00AA1CD8 SWORD 2048 SWORD * 0x0012E694 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 2 <SQL_DATA_SOURCE_NAME> PTR 0x00AA1CD8 [ 14] "MonetDB" SWORD 2048 SWORD * 0x0012E694 (14) MSQRY32 a18-890 ENTER SQLAllocStmt HDBC 00AA1BA8 HSTMT * 0012E68C MSQRY32 a18-890 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 HSTMT * 0x0012E68C ( 0x00aa25c8) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 1 <SQL_ACTIVE_STATEMENTS> PTR 0x0012E640 SWORD 2 SWORD * 0x0012E596 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 1 <SQL_ACTIVE_STATEMENTS> PTR 0x0012E640 (0) SWORD 2 SWORD * 0x0012E596 (2) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 25 <SQL_DATA_SOURCE_READ_ONLY> PTR 0x00AA3038 SWORD 2048 SWORD * 0x0012E694 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 25 <SQL_DATA_SOURCE_READ_ONLY> PTR 0x00AA3038 [ 2] "N" SWORD 2048 SWORD * 0x0012E694 (2) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 6 <SQL_DRIVER_NAME> PTR 0x00AA3038 SWORD 2048 SWORD * 0x0012E694 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 6 <SQL_DRIVER_NAME> PTR 0x00AA3038 [ 28] "MonetDBODBClib" SWORD 2048 SWORD * 0x0012E694 (28) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 14 <SQL_SEARCH_PATTERN_ESCAPE> PTR 0x00AA3038 SWORD 2048 SWORD * 0x0012E694 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 14 <SQL_SEARCH_PATTERN_ESCAPE> PTR 0x00AA3038 SWORD 2048 SWORD * 0x0012E694 (0) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 74 <SQL_CORRELATION_NAME> PTR 0x0012E680 SWORD 2 SWORD * 0x0012E694 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 74 <SQL_CORRELATION_NAME> PTR 0x0012E680 (2) SWORD 2 SWORD * 0x0012E694 (2) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 75 <SQL_NON_NULLABLE_COLUMNS> PTR 0x0012E680 SWORD 2 SWORD * 0x0012E694 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 75 <SQL_NON_NULLABLE_COLUMNS> PTR 0x0012E680 (1) SWORD 2 SWORD * 0x0012E694 (2) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 41 <SQL_CATALOG_NAME_SEPARATOR> PTR 0x00AA3038 SWORD 2048 SWORD * 0x0012E694 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 41 <SQL_CATALOG_NAME_SEPARATOR> PTR 0x00AA3038 SWORD 2048 SWORD * 0x0012E694 (0) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 84 <SQL_FILE_USAGE> PTR 0x0012E654 SWORD 2 SWORD * 0x0012E694 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 84 <SQL_FILE_USAGE> PTR 0x0012E654 (0) SWORD 2 SWORD * 0x0012E694 (2) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 14 <SQL_SEARCH_PATTERN_ESCAPE> PTR 0x00AA1D08 SWORD 130 SWORD * 0x0012DFE0 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 14 <SQL_SEARCH_PATTERN_ESCAPE> PTR 0x00AA1D08 SWORD 130 SWORD * 0x0012DFE0 (0) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 42 <SQL_CATALOG_TERM> PTR 0x00AA1D08 SWORD 130 SWORD * 0x0012E000 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 42 <SQL_CATALOG_TERM> PTR 0x00AA1D08 SWORD 130 SWORD * 0x0012E000 (0) MSQRY32 a18-890 ENTER SQLFreeStmt HSTMT 00AA25C8 UWORD 0 <SQL_CLOSE> MSQRY32 a18-890 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 UWORD 0 <SQL_CLOSE> MSQRY32 a18-890 ENTER SQLFreeStmt HSTMT 00AA25C8 UWORD 2 <SQL_UNBIND> MSQRY32 a18-890 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 UWORD 2 <SQL_UNBIND> MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 32 <SQL_MAX_SCHEMA_NAME_LEN> PTR 0x0012DFF0 SWORD 2 SWORD * 0x0012DFE0 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 32 <SQL_MAX_SCHEMA_NAME_LEN> PTR 0x0012DFF0 (255) SWORD 2 SWORD * 0x0012DFE0 (2) MSQRY32 a18-890 ENTER SQLTablesW HSTMT 00AA25C8 WCHAR * 0x00AA2590 SWORD 0 WCHAR * 0x00AA2550 [ -3] "%\ 0" SWORD -3 WCHAR * 0x00AA1DA0 SWORD 0 WCHAR * 0x00AA1DB8 SWORD 0 MSQRY32 a18-890 EXIT SQLTablesW with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 WCHAR * 0x00AA2590 SWORD 0 WCHAR * 0x00AA2550 [ -3] "%\ 0" SWORD -3 WCHAR * 0x00AA1DA0 SWORD 0 WCHAR * 0x00AA1DB8 SWORD 0 MSQRY32 a18-890 ENTER SQLBindCol HSTMT 00AA25C8 UWORD 2 SWORD 1 <SQL_C_CHAR> PTR 0x0012E01C SQLLEN 65 SQLLEN * 0x0012DFFC MSQRY32 a18-890 EXIT SQLBindCol with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 UWORD 2 SWORD 1 <SQL_C_CHAR> PTR 0x0012E01C SQLLEN 65 SQLLEN * 0x0012DFFC (11148488) MSQRY32 a18-890 ENTER SQLFetch HSTMT 00AA25C8 MSQRY32 a18-890 EXIT SQLFetch with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 MSQRY32 a18-890 ENTER SQLFetch HSTMT 00AA25C8 MSQRY32 a18-890 EXIT SQLFetch with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 MSQRY32 a18-890 ENTER SQLFetch HSTMT 00AA25C8 MSQRY32 a18-890 EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND) HSTMT 00AA25C8 MSQRY32 a18-890 ENTER SQLFreeStmt HSTMT 00AA25C8 UWORD 0 <SQL_CLOSE> MSQRY32 a18-890 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 UWORD 0 <SQL_CLOSE> MSQRY32 a18-890 ENTER SQLFreeStmt HSTMT 00AA25C8 UWORD 2 <SQL_UNBIND> MSQRY32 a18-890 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 UWORD 2 <SQL_UNBIND> MSQRY32 a18-890 ENTER SQLTablesW HSTMT 00AA25C8 WCHAR * 0x00000000 [ -3] <empty string> SWORD -3 WCHAR * 0x00000000 [ -3] <empty string> SWORD -3 WCHAR * 0x00000000 [ -3] <empty string> SWORD -3 WCHAR * 0x00AA1DA0 [ 24] "'TABLE','VIEW','SYNONYM'" SWORD 24 MSQRY32 a18-890 EXIT SQLTablesW with return code -1 (SQL_ERROR) HSTMT 00AA25C8 WCHAR * 0x00000000 [ -3] <empty string> SWORD -3 WCHAR * 0x00000000 [ -3] <empty string> SWORD -3 WCHAR * 0x00000000 [ -3] <empty string> SWORD -3 WCHAR * 0x00AA1DA0 [ 24] "'TABLE','VIEW','SYNONYM'" SWORD 24 DIAG [HY000] [MonetDB][ODBC Driver 11.5.3]TypeException:user.s3_2[50]:'algebra.markT' undefined in: _96:any := algebra.markT(_95:bit, _90:oid) TypeException:user.s3_2[51]:'algebra.kunion' undefined in: _97:any := algebra.kunion(_96:any, _89:bat[:oid,:oid]) TypeException:user.s3_2[52]:'algebra.markT' undefined in: _98:any := algebra.markT(_97:any, _82:oid) TypeException:user.s3_2[53]:'algebra.semijoin' undefined in: _99:any := algebra.semijoin(_98:any, _81:bat[:oid,:void]) TypeException:user.s3_2[73]:'algebra.kunion' undefined in: _127:any := algebra.kunion(_126:bat[:oid,:oid], _99:any) TypeException:user.s3_2[74]:'algebra.markT' undefined in: _128:any := algebra.markT(_127:any, _66:oid) TypeException:user.s3_2[75]:'bat.reverse' undefined in: _129:any := bat.reverse(_128:any) TypeException:user.s3_2[76]:'algebra.leftjoin' undefined in: _130:any := algebra.leftjoin(_129:any, _63:bat[:oid,:int]) TypeException:user.s3_2[77]:'bat.reverse' undefined in: _131:any := bat.reverse(_130:any) TypeException:user.s3_2[89]:'algebra.join' undefined in: _147:any := algebra.join(_146:bat[:oid,:int], _131:any) TypeException:user.s3_2[90]:'algebra.markT' undefined in: _148:any := algebra.markT(_147:any, _57:oid) TypeException:user.s3_2[91]:'bat.reverse' undefined in: _149:any := bat.reverse(_148:any) TypeException:user.s3_2[92]:'algebra.leftjoin' undefined in: _150:any := algebra.leftjoin(_149:any, _56:bat[:oid,:str]) TypeException:user.s3_2[140]:'algebra.markT' undefined in: _213:any := algebra.markT(_212:bit, _208:oid) TypeException:user.s3_2[141]:'algebra.kunion' undefined in: _214:any := algebra.kunion(_213:any, _207:bat[:oid,:oid]) TypeException:user.s3_2[142]:'algebra.markT' undefined in: _215:any := algebra.markT(_214:any, _194:oid) TypeException:user.s3_2[143]:'algebra.semijoin' undefined in: _216:any := algebra.semijoin(_215:any, _193:bat[:oid,:void]) TypeException:user.s3_2[173]:'algebra.kunion' undefined in: _257:any := algebra.kunion(_256:bat[:oid,:oid], _216:any) TypeException:user.s3 (0) MSQRY32 a18-890 ENTER SQLErrorW HENV 00AA1788 HDBC 00AA1BA8 HSTMT 00AA25C8 WCHAR * 0x0012E4E0 (NYI) SDWORD * 0x0012E564 WCHAR * 0x0012E0E0 SWORD 512 SWORD * 0x0012E56C MSQRY32 a18-890 EXIT SQLErrorW with return code 0 (SQL_SUCCESS) HENV 00AA1788 HDBC 00AA1BA8 HSTMT 00AA25C8 WCHAR * 0x0012E4E0 (NYI) SDWORD * 0x0012E564 (0) WCHAR * 0x0012E0E0 [ 512] "[MonetDB][ODBC Driver 11.5.3]TypeException:user.s3_2[50]:'algebra.markT' undefined in: _96:any := algebra.markT(_95:bit, _90:oid)\ aTypeException:user.s3_2[51]:'algebra.kunion' undefined in: _97:any := algebra.kunion(_96:any, _89:bat[:oid,:oid])\ aTypeException:user.s3_2[52]:'algebra.markT' undefined in: _98:any := algebra.markT(_97:any, _82:oid)\ aTypeException:user.s3_2[53]:'algebra.semijoin' undefined in: _99:any := algebra.semijoin(_98:any, _81:bat[:oid,:void])\ aTypeException:user.s3_2[73]:'algebra.kunion' un\ 0" SWORD 512 SWORD * 0x0012E56C (7860) MSQRY32 a18-890 ENTER SQLErrorW HENV 00AA1788 HDBC 00AA1BA8 HSTMT 00AA25C8 WCHAR * 0x0012E4E0 (NYI) SDWORD * 0x0012E564 WCHAR * 0x0012E0E0 SWORD 512 SWORD * 0x0012E56C MSQRY32 a18-890 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND) HENV 00AA1788 HDBC 00AA1BA8 HSTMT 00AA25C8 WCHAR * 0x0012E4E0 (NYI) SDWORD * 0x0012E564 WCHAR * 0x0012E0E0 SWORD 512 SWORD * 0x0012E56C MSQRY32 a18-890 ENTER SQLFreeStmt HSTMT 00AA25C8 UWORD 1 <SQL_DROP> MSQRY32 a18-890 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 UWORD 1 <SQL_DROP> MSQRY32 a18-890 ENTER SQLDisconnect HDBC 00AA1BA8 MSQRY32 a18-890 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 MSQRY32 a18-890 ENTER SQLFreeConnect HDBC 00AA1BA8 MSQRY32 a18-890 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 MSQRY32 a18-890 ENTER SQLFreeEnv HENV 00AA1788 MSQRY32 a18-890 EXIT SQLFreeEnv with return code 0 (SQL_SUCCESS) HENV 00AA1788

2 2

[MonetDB-users] Bulk-importing boolean columns
by Viktor Rosenfeld 19 Oct '11

19 Oct '11

Hi, I need to bulk-import data that was bulk-exported from PostgreSQL. I have only limited control over the raw data. I'm using the following command: COPY INTO table FROM '/path/to/filename' USING DELIMITERS '\t','\n',''; This generally works. The problem is boolean data which is exported by PostgreSQL using the values "t" and "f" (unquoted). MonetDB expects "true" and "false" here. My current work-around is opening the file in Vim and substituting the values (%s/\tt\t/\ttrue\t/g and %s/\tf\t/\tfalse\t/g). Is there a way to make MonetDB accept the original PostgreSQL data? Cheers, Viktor

4 6

[MonetDB-users] Date and time Functions
by Roula Avg 19 Oct '11

19 Oct '11

Hello, i am looking for a manual about all the date and time functions supported in Monetdb. In the official site there is no such manual, can anyone help me please? Thank you very much

3 3

[MonetDB-users] test - ignore <eom>
by nat lu 19 Oct '11

19 Oct '11

1 0

[MonetDB-users] ODBC connection issues
by Jeremy OSullivan 19 Oct '11

19 Oct '11

Hello, I have issues connecting to monetdb using the supplied odbc driver via Oracle's OBI EE admin tool. I am on Windows 2008, 32 bit. When I connect, I get the attached error. I have also attached the odbc configuration. Any help would be greatly appreciated ! Regards, Jeremy

4 4

[MonetDB-users] Insert query into second database
by Seleen 17 Oct '11

17 Oct '11

Hello, I have two databases "mydb" and "test". I want to get a sub-set of values from 'mydb' into 'test'. My code: "insert into test.result select sum(chargfeeprepaid) from mydb.data where callingpartyno = 200 union select sum(chargefeeprepaid) from mydb.sms where callingpartyno = 300;" This works fine in MySQL...but in Monetdb i get the error: INSERT INTO: no such scheme 'test'. Where did i go wrong and what is the correct syntax to do this in monetdb? Greetings Seleen -- View this message in context: http://old.nabble.com/Insert-query-into-second-database-tp32667556p32667556… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] JDBC: Problem with PreparedStatement parameter in Buffer
by George Garbis 10 Oct '11

10 Oct '11

Hi all, I am trying to use PreparedStatement to get a buffer of a geometry invoking the commands bellow PreparedStatement st = con.prepareStatement("CREATE TABLE geom (g > geometry)"); > st.execute(); > st = con.prepareStatement("INSERT INTO geom VALUES(GeomFromText('POINT(1 > 1)', 2100))"); > st.execute(); > st = con.prepareStatement("SELECT Buffer(t.g, ?) AS buffer, t.g AS point > FROM geom AS t"); // This line throws an SQLException > st.setFloat(1, (float)1.0); > ResultSet results = st.executeQuery(); > However the fifth line throws an SQLException with this message: > types geometry(0,0) and double(53,0) are not equal > Replacing the question mark with a number (e.g. 1.0) the program executes properly. Why is this exception thrown? Is something wrong in my code? Thanks in advance, George Garbis

2 2

[MonetDB-users] Monetdb installation on Debian(lenny) doesn't work
by Benji07 05 Oct '11

05 Oct '11

System information : Debian GNU/Linux 5.0.8 (lenny) Hardware Platform : x86_64 GNU/Linux(amd64) I followed the next steps to install Monetdb : 1 - Add next lines in /etc/apt/sources.list : deb http://dev.monetdb.org/downloads/deb/ lenny monetdb deb-src http://dev.monetdb.org/downloads/deb/ lenny monetdb 2 - Install the MonetDB GPG public key 3 - Install the MonetDB packages sudo apt-get update But I get the next message : Failed to fetch http://dev.monetdb.org/downloads/deb/dists/lenny/Release Unable to find expected entry monetdb/binary-amd64/Packages in Meta-index file (malformed Release file?) The file 'Packages' seem to be missing (among others) in this directory, I think the error is related to that. http://dev.monetdb.org/downloads/deb/dists/lenny/monetdb/binary-amd64/ For install of Debian Squeeze, I didn't have any problem. Thanks for you help. -- View this message in context: http://old.nabble.com/Monetdb-installation-on-Debian%28lenny%29-doesn%27t-w… Sent from the monetdb-users mailing list archive at Nabble.com.

2 2

[MonetDB-users] Trigger definitions - ambiguous identifier error
by Benji07 04 Oct '11

04 Oct '11

I've the following table on my database : \d sys.subscriber_data CREATE TABLE "sys"."subscriber_data" ( "subs_id" BIGINT, "imsi" VARCHAR(16), "mccmnc" INTEGER, "msisdn" VARCHAR(16), "imei" VARCHAR(16), "time_idx_print" BIGINT, "time_idx_lastmodified" BIGINT, "time_idx_purge" BIGINT, "merge_subs_id" BIGINT ); I want to create a specific trigger to delete old data in table before insert new data. create trigger oninsert_subscriber before insert on subscriber_data referencing NEW ROW AS new_ident for each row begin atomic delete from subscriber_data where subscriber_data.subs_id = new_ident.subs_id; end; When I executed the statement, I get this error message : SELECT: identifier 'subs_id' ambiguous I don't understand how to use alias in this case to reference old and new data. I wrote the statement according to the documentation: http://www.monetdb.org/Documentation/SQLreference/Triggers However, I found this line in feature overview (unsupported) page T211 Basic trigger capability http://www.monetdb.org/Documentation/Manuals/SQLreference/Features/unsuppor… Does it mean triggers are not yet entirely supported by Monetdb? Thanks for your help. -- View this message in context: http://old.nabble.com/Trigger-definitions---ambiguous-identifier-error-tp32… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] SQL-MAL correlation
by Liang Bing 30 Sep '11

30 Sep '11

Hallo MonetDB-Team, I have been trying to understand MonetDB-MAL better. I have prepared a table called TEST1. sql>SELECT * FROM TEST1; +-----+ | een | +=====+ +-----+ 0 tuples (1.452ms) In order to see the internal process I use the command EXPLAIN. sql>EXPLAIN SELECT * FROM TEST1; +---------------------------------------------------------------------------------------------------+ | mal | +===================================================================================================+ | function user.s3_2{autoCommit=true}():void; | | barrier _32 := language.dataflow(); | | _2 := sql.mvc(); | | _12:bat[:oid,:str] := sql.bind(_2,"sys","test1","een",0); | | _10:bat[:oid,:str] := sql.bind(_2,"sys","test1","een",2); | | _14 := algebra.kdifference(_12,_10); | | _15 := algebra.kunion(_14,_10); | | _9:bat[:oid,:str] := sql.bind(_2,"sys","test1","een",1); | | _16 := algebra.kunion(_15,_9); | | _5:bat[:oid,:oid] := sql.bind_dbat(_2,"sys","test1",1); | | _8 := bat.reverse(_5); | | _17 := algebra.kdifference(_16,_8); | | exit _32; | | _18 := sql.resultSet(1,1,_17); | | sql.rsColumn(_18,"sys.test1","een","char",2,0,_17); | | _22 := io.stdout(); | | sql.exportResult(_22,_18); | | end s3_2; | +---------------------------------------------------------------------------------------------------+ 18 tuples (1.240ms) Then I have tried to run the command from the lower level. Basically it is almost a copy of the above result. mal>function user.abc{autoCommit=true}():void; mal>barrier _32 := language.dataflow(); mal>_2 := sql.mvc(); mal>_12:bat[:oid,:str] := sql.bind(_2,"sys","test1","een",0); mal>_10:bat[:oid,:str] := sql.bind(_2,"sys","test1","een",2); mal>_14 := algebra.kdifference(_12,_10); mal>_15 := algebra.kunion(_14,_10); mal>_9:bat[:oid,:str] := sql.bind(_2,"sys","test1","een",1); mal>_16 := algebra.kunion(_15,_9); mal>_5:bat[:oid,:oid] := sql.bind_dbat(_2,"sys","test1",1); mal>_8 := bat.reverse(_5); mal>_17 := algebra.kdifference(_16,_8); mal>exit _32; mal>_18 := sql.resultSet(1,1,_17); mal>sql.rsColumn(_18,"sys.test1","een","char",2,0,_17); mal>_22 := io.stdout(); mal>sql.exportResult(_22,_18); mal>end abc; MAPI = (monetdb) /tmp/.s.monetdb.50000 QUERY = end abc; ERROR = !TypeException:user.abc[13]:'X17' may not be used before being initialized !TypeException:user.abc[14]:'X17' may not be used before being initialized I expected to get a result like this: +-----+ | een | +=====+ +-----+ But instead, I got an error message. Is there probably anyone who could tell me what the error message means and what I need to change in the MAL-syntax? Another question: Maybe you could give a hint where I can find good references about SQL-MAL correlation. Thank you in advance! Kind regards, Liang Bing -- View this message in context: http://old.nabble.com/SQL-MAL-correlation-tp32557812p32557812.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] Announcement: New Aug2011-SP1 bugfix release of MonetDB suite
by Fabian Groffen 30 Sep '11

30 Sep '11

The MonetDB team at CWI/MonetDB BV is pleased to announce the Aug2011-SP1 bugfix release of the MonetDB suite of programs. More information about MonetDB can be found on our website at http://www.monetdb.org/. For details on this release, please see the release notes at <http://www.monetdb.org/Downloads/ReleaseNotes>. As usual, the download location is <http://dev.monetdb.org/downloads/>. Aug 2011-SP1 bugfix release SQL * Fixed a bug when using default values for interval columns. Bug 2877. * A bug was fixed where deleted rows weren't properly accounted for in all operations. This was bug 2882. * A bug was fixed which caused an update to an internal table to happen too soon. The bug could be observed on a multicore system with a query INSERT INTO t (SELECT * FROM t) when the table t is "large enough". This was bug 2883. Client Package * Fixed Perl DBD rowcount for larger results, bug #2889 * Perl: We now distinguish properly between TABLE and GLOBAL TEMPORARY (the latter are recognized by being in the "tmp" schema). * Perl: fixed a bunch of syntax errors. This fixes bug 2884. With thanks to Rémy Chibois. * Perl: Fixed DBD::monetdb table_info and tabletype_info. This fixes bug 2885. With thanks to Rémy Chibois. * mclient: fix display of varchar columns with only NULL values. * Fixed a bug in mclient/msqldump where an internal error occurred during dump when there are GLOBAL TEMPORARY tables. MonetDB5 Server * Fixed a problem where MAL variables weren't properly cleared before reuse of the data strucutre. This problem could cause the data flow scheduler to generate dependencies between instructions that didn't actually exist, which in turn could cause circular dependencies among instructions with deadlock as a result. Bugs 2865 and 2888. Bug Fixes * 2865: mserver5 --set gdk_nr_threads=2 --forcemito: deadlock during first SQL client connect on virgin (empty) DB * 2877: assertion failed when creating table with default interval * 2879: A SELECT query fails to produce some results * 2882: Delete of some records don't work on Monetdb * 2883: insert into t (select * from t) bogus in multithreaded execution * 2884: Mapi.pm and GetInfo.pm syntax fixes for array usage * 2885: DBD::monetdb table_info error * 2887: Division by zero error, when should not divide at 0 * 2888: test/null/null_in_case.sql hangs server * 2889: Mapi::getBlock is erasing query count on second call

1 0

[MonetDB-users] copy ... from stdin in perl script
by Eugene Prokopiev 28 Sep '11

28 Sep '11

Hi, I have table t1(f1 integer) I can copy to it by executing this file via mclient: $ cat /tmp/f1.sql copy into t1 from stdin; 1 2 3 But I can't copy to it by this perl script: $ cat /tmp/f1.pl #!/usr/bin/perl -w use DBI; my $dbh = DBI->connect('dbi:monetdb:database=db', 'dbadmin', "dbpwd"); $dbh->do("copy into t1 from stdin;\n1\n2\n3\n"); I got: Missing argument in sprintf at /usr/lib64/perl5/DBD/monetdb/GetInfo.pm line 25. No query result at /usr/lib64/perl5/MonetDB/CLI/MapiLib.pm line 80. Use of uninitialized value in die at /usr/lib64/perl5/MonetDB/CLI/MapiLib.pm line 180. (in cleanup) Died at /usr/lib64/perl5/MonetDB/CLI/MapiLib.pm line 180. Why can it be? -- Thanks, Eugene Prokopiev

2 9

[MonetDB-users] CSV Data Fault still used ?
by Stéphane NOUHAUD 26 Sep '11

26 Sep '11

Hi, I try to use CSV Data Fault (Documented here http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/CSVvault) without great succes... Just quick question is CSV Data Fault function still included in last version of MonetDB ? Except that MonetDB is really fantastic software. Thanks for sharing it ! Regards, -- *Stéphane NOUHAUD* * *

1 0

[MonetDB-users] Parallel COPY INTO
by zack_pcd 22 Sep '11

22 Sep '11

I have a large table with about 50 billion records. The files to be loaded are not in CSV format. The files are processed in java and the data uploaded to the database using COPY INTO through the MapiSocket interface. I do not have the record count readily available. My question is this: If I open multiple MapiSockets and upload multiple streams of data at the same time to the same table, is this supported and stable? I am asking because the database appears to become unresponsive after the bulk load. (mclient seems to hang on connect) If I stop and the start the database after the bulk load, I get: "failed to fork mserver: database 'test_db' has inconsistent state (sabaoth administration reports running, but process seems gone)" -- View this message in context: http://old.nabble.com/Parallel-COPY-INTO-tp32503834p32503834.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] Partitioning on Monetdb
by Benji07 21 Sep '11

21 Sep '11

Does Monetdb supports basic table partitioning using MAPI? I need to split one large table into smaller physical pieces and improve query performance. I didn't find help in documentation. Thanks for help -- View this message in context: http://old.nabble.com/Partitioning-on-Monetdb-tp32493404p32493404.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 3