Bugs item #2947749, was opened at 2010-02-08 11:16
Message generated for change (Tracker Item Submitted) made by vzzzbx
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2947749&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: Core
Group: SQL "candidate"
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Wouter Alink (vzzzbx)
Assigned to: Nobody/Anonymous (nobody)
Summary: constants optimizer
Initial Comment:
Using the default_pipe with the 'constants' optimizer, the following statement
crashes mserver. (Feb2010, checkout of last week):
CREATE TABLE x (id SERIAL, a VARCHAR(1000));
Leaving the 'constants' out of the pipeline, it seems to work fine.
This is what gdb tells me:
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7f3227a1a710 (LWP 19018)]
0x00007f3228dc069b in create_table_or_view (sql=0x7f3218005518,
sname=0x7f3218054538 "sys", t=0x7f32180bd898, temp=0)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/backends/monet5/sql.mx:1460
1460 sql_column *c = n->data;
(gdb) l
1455 return sql_message("CREATE TABLE: insufficient
privileges for user '%s' in schema '%s'", stack_get_string(sql,
"current_user"), s->base.name);
1456 }
1457
1458 /* first check default values */
1459 for (n = t->columns.set->h; n; n = n->next) {
1460 sql_column *c = n->data;
1461
1462 if (c->def) {
1463 char buf[BUFSIZ];
1464 sql_rel *r = NULL;
(gdb) p n
$1 = (node *) 0x135
(gdb) p n->data
Cannot access memory at address 0x13d
(gdb) p *n
Cannot access memory at address 0x135
(gdb) p t->columns.set
$2 = (struct list *) 0x7f321804d388
(gdb) p *t->columns.set
$3 = {sa = 0x7f3218000078, destroy = 0x20, h = 0x135, t = 0x108, cnt =
402653722}
(gdb) bt
#0 0x00007f3228dc069b in create_table_or_view (sql=0x7f3218005518,
sname=0x7f3218054538 "sys", t=0x7f32180bd898, temp=0)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/backends/monet5/sql.mx:1460
#1 0x00007f3228dc1f4a in SQLcatalog (cntxt=0x604e70, mb=0x7f321806fac8,
stk=0x7f3218080d98, pci=0x7f32180818b8)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/backends/monet5/sql.mx:1821
#2 0x00007f323fd01e2d in runMALsequence (cntxt=0x604e70, mb=0x7f321806fac8,
startpc=1, stoppc=0, stk=0x7f3218080d98, env=0x0, pcicaller=0x0)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/MonetDB5/src/mal/mal_interpreter.mx:1904
#3 0x00007f323fcf86e2 in callMAL (cntxt=0x604e70, mb=0x7f321806fac8,
env=0x7f3227a19b88, argv=0x7f3227a19bd0, debug=0 '\000')
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/MonetDB5/src/mal/mal_interpreter.mx:400
#4 0x00007f3228e0ab2a in SQLexecutePrepared (c=0x604e70, be=0x7f321803fdc8,
q=0x7f321804bd18)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/backends/monet5/sql_scenario.mx:1327
#5 0x00007f3228e0ada9 in SQLengineIntern (c=0x604e70, be=0x7f321803fdc8)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/backends/monet5/sql_scenario.mx:1380
#6 0x00007f3228e0b2e4 in SQLengine (c=0x604e70)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/backends/monet5/sql_scenario.mx:1490
#7 0x00007f323fd4190b in runPhase (c=0x604e70, phase=4)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/MonetDB5/src/mal/mal_scenario.mx:602
#8 0x00007f323fd41b01 in runScenarioBody (c=0x604e70) at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/MonetDB5/src/mal/mal_scenario.mx:654
#9 0x00007f323fd41cbe in runScenario (c=0x604e70) at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/MonetDB5/src/mal/mal_scenario.mx:679
#10 0x00007f323fcf6334 in MSserveClient (dummy=0x604e70)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/MonetDB5/src/mal/mal_session.mx:474
#11 0x00000039f6e06a3a in start_thread () from /lib64/libpthread.so.0
#12 0x00000039f62de67d in clone () from /lib64/libc.so.6
#13 0x0000000000000000 in ?? ()
(gdb) q
A debugging session is active.
Inferior 1 [process 18984] will be detached.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2947749&group_id=56967
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
