October 2011 - users-list

[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