Bugs item #1650469, was opened at 2007-02-02 11:19 Message generated for change (Comment added) made by mr-meltdown You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1650469&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: Fixed Priority: 7 Private: No Submitted By: Fabian (mr-meltdown) Assigned to: Niels Nes (nielsnes) Summary: SQL: Armada sinks MonetDB ships Initial Comment: Loading a "simple" armada script of 30MB with around 350 tables, succeeds fine. Querying one of the views afterwards crashes the M5/SQL server with these details: Starting program: /net/pegasus.ins.cwi.nl/export/scratch1/fabian/monetdb/current/program-x86_64/bin/mserver5 [Thread debugging using libthread_db enabled] [New Thread 46912530063648 (LWP 11126)] [New Thread 1082132832 (LWP 11152)] # MonetDB Server v5.0.0_beta2_1 # Copyright (c) 1993-2007 CWI, all rights reserved # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked # dbname:demo # Visit http://monetdb.cwi.nl/ for further information [New Thread 1090525536 (LWP 11154)] #warning: please don't forget to set your vault key! #(see /ufs/fabian/scratch/monetdb/current/program-x86_64/etc/monetdb5.conf) >include sql; >[New Thread 1098918240 (LWP 11159)] Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 1098918240 (LWP 11159)] 0x00002aaabce47781 in _dumpstmt (sql=Cannot access memory at address 0x3fffe838 ) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:430 430 { (gdb) bt #0 0x00002aaabce47781 in _dumpstmt (sql=Cannot access memory at address 0x3fffe838 ) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:430 #1 0x00002aaabce47cd1 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30aa708) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:499 #2 0x00002aaabce4f909 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30aa7b8) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:1413 #3 0x00002aaabce50b2f in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30aa868) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:1507 #4 0x00002aaabce4c0b0 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30aaab8) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:1034 #5 0x00002aaabce4c486 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30aab68) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:1055 #6 0x00002aaabce4aead in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30aac18) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:928 #7 0x00002aaabce47cd1 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30aaee8) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.m---Type <return> to continue, or q <return> to quit--- x:499 #8 0x00002aaabce50b2f in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30aa658) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:1507 #9 0x00002aaabce47cd1 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x2fe3f38) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:499 #10 0x00002aaabce46bb8 in dump_2 (sql=0x28d1e18, mb=0x33fc968, s=0x296cbb8, name=0x2aaabced5166 "markT") at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:261 #11 0x00002aaabce487fd in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x296cbb8) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:552 #12 0x00002aaabce4697c in dump_1 (sql=0x28d1e18, mb=0x33fc968, s=0x29af338, mod=0x66f758 "bat", name=0x66f778 "reverse") at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:248 #13 0x00002aaabce48860 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x29af338) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:560 #14 0x00002aaabce4aead in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x2fe4058) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.m---Type <return> to continue, or q <return> to quit--- x:928 #15 0x00002aaabce47cd1 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30ab0f8) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:499 #16 0x00002aaabce4f909 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30ab1c8) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:1413 #17 0x00002aaabce50b2f in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30ab278) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:1507 #18 0x00002aaabce4c0b0 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30ab4e8) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:1034 #19 0x00002aaabce4c486 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30ab598) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:1055 #20 0x00002aaabce4aead in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30ab648) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:928 #21 0x00002aaabce47cd1 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30ab918) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:499 #22 0x00002aaabce50b2f in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30ab048) ---Type <return> to continue, or q <return> to quit--- at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:1507 #23 0x00002aaabce47cd1 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x2fd2798) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:499 #24 0x00002aaabce46bb8 in dump_2 (sql=0x28d1e18, mb=0x33fc968, s=0x296c3c8, name=0x2aaabced5166 "markT") at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:261 #25 0x00002aaabce487fd in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x296c3c8) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:552 #26 0x00002aaabce4697c in dump_1 (sql=0x28d1e18, mb=0x33fc968, s=0x29ae9e8, mod=0x66f758 "bat", name=0x66f778 "reverse") at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:248 #27 0x00002aaabce48860 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x29ae9e8) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:560 #28 0x00002aaabce4aead in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x2fd28e8) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:928 #29 0x00002aaabce47cd1 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30abb28) ---Type <return> to continue, or q <return> to quit--- at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:499 #30 0x00002aaabce4f909 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30abbd8) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:1413 #31 0x00002aaabce50b2f in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30abc88) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:1507 #32 0x00002aaabce4c0b0 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30abed8) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:1034 #33 0x00002aaabce4c486 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30abf88) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:1055 #34 0x00002aaabce4aead in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30ac038) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:928 #35 0x00002aaabce47cd1 in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30ac308) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:499 #36 0x00002aaabce50b2f in _dumpstmt (sql=0x28d1e18, mb=0x33fc968, s=0x30aba78) at /ufs/fabian/scratch/monetdb/current/sql/src/backends/monet5/sql_gencode.mx:1507 ---Type <return> to continue, or q <return> to quit---q Quit (gdb) The executed query is select count(*) from s49__armada; It involves a little view with only 18 unions in nested subqueries. CWI people can find the file in ~fabian/files/paper6/asim/out.sql ---------------------------------------------------------------------- >Comment By: Fabian (mr-meltdown) Date: 2007-02-05 11:45 Message: Logged In: YES user_id=963970 Originator: YES on a related note, my smaller example is accepted by PostgreSQL, which it previously was not. Romulo fixed some dependency of views on views problem, so it might be that is/was related too. ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2007-02-05 11:43 Message: Logged In: YES user_id=963970 Originator: YES on smaller examples it doesn't crash. ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2007-02-04 19:30 Message: Logged In: YES user_id=43556 Originator: NO Fixed the problem (ie use less stack space per _dumpstmt call). I'm not closing the bug report as I didn't create a test for this. The given test file is way to big for adding to the cvs repo. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1650469&group_id=56967 ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
