Bugs item #2914191, was opened at 2009-12-14 15:23
Message generated for change (Settings changed) made by mr-meltdown
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2914191&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 "stable"
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Fabian (mr-meltdown)
Assigned to: Martin Kersten (mlkersten)
>Summary: SQL: copy into crash (tablet_sql)
Initial Comment:
using ulimit to cause memory shortage on my system (1.3G real memory, 1G
virtual memory), the AVG_of_SQRT.SF-2757642.test (from
src/test/BugTracker-2009) quickly segfaults like this:
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 5 (LWP 5)]
0xfffffd7f4200f8cb in SQLload_file (cntxt=0x6061d8, as=0xfffffd7ffddfdde0,
b=0x1403e30, out=0x0, csep=0x123ca68 "|", rsep=0x123cb88 "\n",
quote=0 '\000', skip=-4220415, maxrow=100000000)
at
/export/scratch/mirror/fabian/monetdb/Nov2009/five/src/modules/mal/tablet_sql.mx:501
501 task->fields[0][task->next] = s;
(gdb) bt
#0 0xfffffd7f4200f8cb in SQLload_file (cntxt=0x6061d8, as=0xfffffd7ffddfdde0,
b=0x1403e30, out=0x0, csep=0x123ca68 "|", rsep=0x123cb88 "\n",
quote=0 '\000', skip=-4220415, maxrow=100000000)
at
/export/scratch/mirror/fabian/monetdb/Nov2009/five/src/modules/mal/tablet_sql.mx:501
#1 0xfffffd7e618737bf in mvc_import_table (cntxt=0x6061d8, m=0x1217428,
bs=0x1403e30, sname=0x71ab48 "sys", tname=0x71a868 "n8",
sep=0x123ca68 "|", rsep=0x123cb88 "\n", ssep=0x0, ns=0x123ca88 "null",
sz=100000000, offset=0)
at
/export/scratch/mirror/fabian/monetdb/Nov2009/sql/src/backends/monet5/sql_result.mx:502
#2 0xfffffd7e6182b0f3 in mvc_import_table_wrap (cntxt=0x6061d8, mb=0x1640c58,
stk=0xfffffd7ffddfed20, pci=0x1640fb8)
at
/export/scratch/mirror/fabian/monetdb/Nov2009/sql/src/backends/monet5/sql.mx:2508
#3 0xfffffd7f4c62b1f9 in runMALsequence (cntxt=0x6061d8, mb=0x1640c58,
startpc=1, stoppc=0, stk=0xfffffd7ffddfed20, env=0x121a128,
pcicaller=0x124b988)
at
/export/scratch/mirror/fabian/monetdb/Nov2009/five/src/mal/mal_interpreter.mx:1851
#4 0xfffffd7f4c621fb9 in runMAL (cntxt=0x6061d8, mb=0x1640c58, startpc=1,
mbcaller=0x121aa38, env=0x121a128, pcicaller=0x124b988)
at
/export/scratch/mirror/fabian/monetdb/Nov2009/five/src/mal/mal_interprete---Type
<return> to continue, or q <return> to quit---q
Quit
(gdb) l
496 }
497
498 if ((e != NULL && *e != 0) || ateof) {
499 /* found a complete record, or an
incomplete one at the end of the file */
500 if ( --skip < 0 ) {
501 task->fields[0][task->next] = s;
502 *e = '\0';
503 if ( SQLload_file_line(task,
as, s, csep,rsep) < 0) {
504 #ifdef _DEBUG_TABLET_
505
stream_printf(GDKout,"line failed:\n");
(gdb) p task
$1 = (READERtask *) 0x124bf68
(gdb) p task->fields
$2 = (char ***) 0x123cac8
(gdb) p task->fields[0]
$3 = (char **) 0xfffffd7ff8800010
(gdb) p task->fields[0][task->next]
Cannot access memory at address 0xfffffd7ffa833000
(gdb) p task->next
$4 = 4220414
(gdb)
----------------------------------------------------------------------
>Comment By: Fabian (mr-meltdown)
Date: 2009-12-15 11:44
Message:
same happens on a limited environment under Linux:
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7fc509933950 (LWP 32240)]
0x00007fc50e973345 in SQLload_file (cntxt=0x605788, as=0x7fc50992d650,
b=0x1a33a40, out=0x0, csep=0x1adfb08 "|", rsep=0x19eeb28 "\n",
quote=0 '\0', skip=-10610687, maxrow=100000000)
at
/ufs/fabian/scratch/monetdb/Nov2009/five/src/modules/mal/tablet_sql.mx:499
499
task->fields[0][task->next] = s;
(gdb) p task->next
$1 = 10610686
(gdb)
sql>copy 100000000 records into i8 from
'src/test/BugTracker-2009/parallel_bulk-load.SF-2771052.csv';
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2914191&group_id=56967
------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
