Bugs item #2872421, was opened at 2009-10-04 02:50 Message generated for change (Tracker Item Submitted) made by skinkie You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2872421&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: SQL CVS Head Status: Open Resolution: None Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) Summary: SQL: Crash when trying to create function to read only db Initial Comment: gdb --args /opt/monetdb-head/bin/mserver5 --dbinit="include sql; sql.start();" --dbname=monitor --readonly --set mapi_port=50001 GNU gdb 6.8 Copyright (C) 2008 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "x86_64-pc-linux-gnu"... (gdb) r Starting program: /opt/monetdb-head/bin/mserver5 --dbinit=include\ sql\;\ sql.start\(\)\; --dbname=monitor --readonly --set mapi_port=50001 [Thread debugging using libthread_db enabled] [New Thread 0x7f352fe126f0 (LWP 26973)] [New Thread 0x7f35271ab910 (LWP 26976)] # MonetDB server v5.17.0, based on kernel v1.35.0 # Serving database 'monitor', using 4 threads # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked # Detected 3.856 GiB (4140695552 bytes) main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /opt/monetdb-head/etc/monetdb5.conf) [New Thread 0x7f351dd49910 (LWP 26977)] # Listening for connection requests on mapi:monetdb://127.0.0.1:50001/ # MonetDB/SQL module v2.35.0 loaded [New Thread 0x7f351d5b9910 (LWP 26981)] >create function "epoch"(sec INT) returns TIMESTAMP external name >timestamp."epoch"; Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 0x7f352fe126f0 (LWP 26973)] 0x0000000000000000 in ?? () (gdb) bt #0 0x0000000000000000 in ?? () #1 0x00007f351d8b33fd in table_insert (tr=0x22441e8, t=0x22cf768) at ../../../../src/storage/restrict/restrict_table.mx:152 #2 0x00007f351d8a6f4e in sql_trans_create_func (tr=0x22441e8, s=0x2293fd8, func=0x22bc8a8 "epoch", args=0x215c598, res=0x22bca10, sql=0 '\0', aggr=0 '\0', mod=0x22bca58 "timestamp", impl=0x22bca68 "epoch", is_func=1) at ../../../src/storage/store.mx:3266 #3 0x00007f351d863373 in mvc_create_func (sql=0x22ba738, s=0x2293fd8, name=0x22bc8a8 "epoch", args=0x215c598, res=0x22bca10, issql=0 '\0', aggr=0 '\0', mod=0x22bca58 "timestamp", impl=0x22bca68 "epoch", is_func=1) at ../../../src/server/sql_mvc.mx:999 #4 0x00007f351d869efa in create_func (sql=0x22ba738, qname=0x22bc8b8, params=0x22bc918, res=0x22bca38, ext_name=0x22bca78, body=0x0, is_func=1, is_aggr=0) at ../../../src/server/sql_psm.mx:662 #5 0x00007f351d86a843 in psm (sql=0x22ba738, s=0x22bcc08) at ../../../src/server/sql_psm.mx:814 #6 0x00007f351d8453ca in semantic (sql=0x22ba738, s=0x22bcc08) at ../../../src/server/sql_semantic.mx:1062 #7 0x00007f351d84544a in output_semantic (sql=0x22ba738, s=0x22bcc08) at ../../../src/server/sql_semantic.mx:1097 #8 0x00007f351d7e30c2 in sql_symbol2stmt (c=0x22ba738, sym=0x22bcc08) at ../../../../src/backends/monet5/sql.mx:1264 #9 0x00007f351d81e535 in SQLparser (c=0x605540) at ../../../../src/backends/monet5/sql_scenario.mx:1032 #10 0x00007f352f93c668 in runPhase (c=0x605540, phase=1) at ../../../src/mal/mal_scenario.mx:602 #11 0x00007f352f93c75f in runScenarioBody (c=0x605540) at ../../../src/mal/mal_scenario.mx:638 #12 0x00007f352f93c989 in runScenario (c=0x605540) at ../../../src/mal/mal_scenario.mx:672 #13 0x00007f352f8f773d in MSserveClient (dummy=0x605540) at ../../../src/mal/mal_session.mx:496 #14 0x00000000004031f5 in main (argc=6, av=0x7fffdeb55c28) at ../../../src/tools/mserver5.mx:636 I would not expect a segmentation fault when the database is in readonly state when a write action takes place. Rather an informed response such operation is not possible. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2872421&group_id=56967 ------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
