Bugs item #2935207, was opened at 2010-01-19 21:26
Message generated for change (Comment added) made by skinkie
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2935207&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: Clients CVS Head
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Stefan de Konink (skinkie)
Assigned to: Sjoerd Mullender (sjoerd)
>Summary: msqldump, export/import crashes
Initial Comment:
msqldump on an old database (old string format) results in a crashing server;
the server responds:
../../../../src/modules/atoms/str.mx:1647: strLength: Assertion `l <2147483647'
failed.
----------------------------------------------------------------------
>Comment By: Stefan de Konink (skinkie)
Date: 2010-01-21 17:50
Message:
So a second import run after removing the \015 stuff.
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7fffe487c710 (LWP 25358)]
0x00007ffff6c48d93 in GDKfree_ (blk=0x30500000000) at
../../../src/gdk/gdk_utils.mx:1121
1121 size = GDK_MEM_BLKSIZE(s);
(gdb) bt
#0 0x00007ffff6c48d93 in GDKfree_ (blk=0x30500000000) at
../../../src/gdk/gdk_utils.mx:1121
#1 0x00007ffff6c48f24 in GDKfree (blk=0x30500000000) at
../../../src/gdk/gdk_utils.mx:1167
#2 0x00007fffe4f0a933 in stmt_destroy (s=0x1531098) at
../../../src/server/sql_statement.mx:671
#3 0x00007fffe4f38812 in stack_pop_until (sql=0x1504458, top=9) at
../../../src/server/sql_mvc.mx:1540
#4 0x00007fffe4f35b53 in mvc_reset (m=0x1504458, rs=0x1500390,
ws=0x1ba77a0, debug=0, globalvars=9) at ../../../src/server/sql_mvc.mx:672
#5 0x00007fffe4eef0b3 in SQLinitClient (c=0x605a90) at
../../../../src/backends/monet5/sql_scenario.mx:427
#6 0x00007ffff7b099df in runPhase (c=0x605a90, phase=5) at
../../../src/mal/mal_scenario.mx:602
#7 0x00007ffff7b09aa2 in runScenarioBody (c=0x605a90) at
../../../src/mal/mal_scenario.mx:634
#8 0x00007ffff7b09d92 in runScenario (c=0x605a90) at
../../../src/mal/mal_scenario.mx:679
#9 0x00007ffff7abe7fc in MSserveClient (dummy=0x605a90) at
../../../src/mal/mal_session.mx:474
#10 0x00007ffff5797894 in start_thread (arg=<value optimized out>) at
pthread_create.c:297
#11 0x00007ffff48c4f9d in clone () at
../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#12 0x0000000000000000 in ?? ()
----------------------------------------------------------------------
Comment By: Stefan de Konink (skinkie)
Date: 2010-01-21 17:37
Message:
And to make it even more interesting; this is what msqldump exports:
230830920000 "Overjordaans B.V." "Noordzijde 67 A" "2977XB"
"Goudriaan" "Hoofdvestiging\015" 0
This is what I get from the current database in raw mode (seems to be an
extra \r maybe it was in the source data):
[ 1082163, 230830920000, "Overjordaans B.V.", "Noordzijde 67 A",
"2977XB", "Goudriaan", "Hoofdvestiging\015", 23083092,
0, 17, 15, 0 ]
And this is what I see if I import it again:
SQLException:sql:value 'Hoofdvestiging\015' from line 2414663 field 6 not
inserted, expecting type str
SQLException:importTable:failed to import table
----------------------------------------------------------------------
Comment By: Stefan de Konink (skinkie)
Date: 2010-01-21 17:29
Message:
Now the backup ran (produced output) but also ended in:
(gdb) bt
#0 0x00007ffff6ac5b88 in decref (i=97, logical=1, releaseShare=0) at
../../../src/gdk/gdk_bbp.mx:1830
#1 0x00007ffff6ac651d in BBPdecref (i=97, logical=1) at
../../../src/gdk/gdk_bbp.mx:1897
#2 0x00007fffe4f92492 in temp_destroy (b=97) at
../../../../src/storage/bat/bat_utils.mx:134
#3 0x00007fffe4f8f9f8 in destroy_delta (b=0x1348a28) at
../../../../src/storage/bat/bat_storage.mx:962
#4 0x00007fffe4f8faa3 in destroy_bat (tr=0x0, b=0x1348a28) at
../../../../src/storage/bat/bat_storage.mx:976
#5 0x00007fffe4f8fae8 in destroy_col (tr=0x0, c=0x1348998) at
../../../../src/storage/bat/bat_storage.mx:984
#6 0x00007fffe4f841f4 in reset_column (tr=0x1336d98, fc=0x1348998,
pfc=0x1087e38) at ../../../src/storage/store.mx:2750
#7 0x00007fffe4f83d15 in reset_changeset (tr=0x1336d98, fs=0x1348848,
pfs=0x1087cb8, b=0x13487f8, rf=0x7fffe4f8417d <reset_column>,
fd=0x7fffe4f80f1d <column_dup>)
at ../../../src/storage/store.mx:2673
#8 0x00007fffe4f8443e in reset_table (tr=0x1336d98, ft=0x13487f8,
pft=0x1087c68) at ../../../src/storage/store.mx:2796
#9 0x00007fffe4f83d15 in reset_changeset (tr=0x1336d98, fs=0x1336e38,
pfs=0x1085a48, b=0x1336e18, rf=0x7fffe4f84325 <reset_table>,
fd=0x7fffe4f81326 <table_dup>)
at ../../../src/storage/store.mx:2673
#10 0x00007fffe4f84688 in reset_schema (tr=0x1336d98, fs=0x1336e18,
pfs=0x1085a28) at ../../../src/storage/store.mx:2825
#11 0x00007fffe4f83d15 in reset_changeset (tr=0x1336d98, fs=0x1336dc0,
pfs=0x10859d0, b=0x10859a8, rf=0x7fffe4f84528 <reset_schema>,
fd=0x7fffe4f81ab7 <schema_dup>)
at ../../../src/storage/store.mx:2673
#12 0x00007fffe4f8480d in reset_trans (tr=0x1336d98, ptr=0x10859a8) at
../../../src/storage/store.mx:2853
#13 0x00007fffe4f8a9b3 in sql_trans_begin (s=0x1336d48) at
../../../src/storage/store.mx:4577
#14 0x00007fffe4f34b82 in mvc_trans (m=0x13347f8) at
../../../src/server/sql_mvc.mx:379
#15 0x00007fffe4eed9f5 in monet5_user_get_def_schema (m=0x13347f8, user=1)
at ../../../../src/backends/monet5/sql_user.mx:463
#16 0x00007fffe4eef0d6 in SQLinitClient (c=0x605a90) at
../../../../src/backends/monet5/sql_scenario.mx:431
#17 0x00007ffff7b099df in runPhase (c=0x605a90, phase=5) at
../../../src/mal/mal_scenario.mx:602
#18 0x00007ffff7b09aa2 in runScenarioBody (c=0x605a90) at
../../../src/mal/mal_scenario.mx:634
#19 0x00007ffff7b09d92 in runScenario (c=0x605a90) at
../../../src/mal/mal_scenario.mx:679
#20 0x00007ffff7abe7fc in MSserveClient (dummy=0x605a90) at
../../../src/mal/mal_session.mx:474
#21 0x00007ffff5797894 in start_thread (arg=<value optimized out>) at
pthread_create.c:297
#22 0x00007ffff48c4f9d in clone () at
../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#23 0x0000000000000000 in ?? ()
----------------------------------------------------------------------
Comment By: Stefan de Konink (skinkie)
Date: 2010-01-21 17:23
Message:
Interesting it breaks on the *second* run of msqldump the first one was
running with a problem. I broke it off and tried again.
[Switching to Thread 0x7fffe487c710 (LWP 28581)]
0x00007ffff6ac5b88 in decref (i=97, logical=1, releaseShare=0)
at ../../../src/gdk/gdk_bbp.mx:1830
1830 ../../../src/gdk/gdk_bbp.mx: No such file or directory.
in ../../../src/gdk/gdk_bbp.mx
(gdb) bt
#0 0x00007ffff6ac5b88 in decref (i=97, logical=1, releaseShare=0)
at ../../../src/gdk/gdk_bbp.mx:1830
#1 0x00007ffff6ac651d in BBPdecref (i=97, logical=1)
at ../../../src/gdk/gdk_bbp.mx:1897
#2 0x00007fffe4f92492 in temp_destroy (b=97)
at ../../../../src/storage/bat/bat_utils.mx:134
#3 0x00007fffe4f8f9f8 in destroy_delta (b=0x1348a28)
at ../../../../src/storage/bat/bat_storage.mx:962
#4 0x00007fffe4f8faa3 in destroy_bat (tr=0x0, b=0x1348a28)
at ../../../../src/storage/bat/bat_storage.mx:976
#5 0x00007fffe4f8fae8 in destroy_col (tr=0x0, c=0x1348998)
at ../../../../src/storage/bat/bat_storage.mx:984
#6 0x00007fffe4f841f4 in reset_column (tr=0x1336d98, fc=0x1348998,
pfc=0x1087e38) at ../../../src/storage/store.mx:2750
#7 0x00007fffe4f83d15 in reset_changeset (tr=0x1336d98, fs=0x1348848,
pfs=0x1087cb8, b=0x13487f8, rf=0x7fffe4f8417d <reset_column>,
fd=0x7fffe4f80f1d <column_dup>) at ../../../src/storage/store.mx:2673
#8 0x00007fffe4f8443e in reset_table (tr=0x1336d98, ft=0x13487f8,
pft=0x1087c68) at ../../../src/storage/store.mx:2796
#9 0x00007fffe4f83d15 in reset_changeset (tr=0x1336d98, fs=0x1336e38,
pfs=0x1085a48, b=0x1336e18, rf=0x7fffe4f84325 <reset_table>,
fd=0x7fffe4f81326 <table_dup>) at ../../../src/storage/store.mx:2673
#10 0x00007fffe4f84688 in reset_schema (tr=0x1336d98, fs=0x1336e18,
---Type <return> to continue, or q <return> to quit---
pfs=0x1085a28) at ../../../src/storage/store.mx:2825
#11 0x00007fffe4f83d15 in reset_changeset (tr=0x1336d98, fs=0x1336dc0,
pfs=0x10859d0, b=0x10859a8, rf=0x7fffe4f84528 <reset_schema>,
fd=0x7fffe4f81ab7 <schema_dup>) at ../../../src/storage/store.mx:2673
#12 0x00007fffe4f8480d in reset_trans (tr=0x1336d98, ptr=0x10859a8)
at ../../../src/storage/store.mx:2853
#13 0x00007fffe4f8a9b3 in sql_trans_begin (s=0x1336d48)
at ../../../src/storage/store.mx:4577
#14 0x00007fffe4f34b82 in mvc_trans (m=0x13347f8)
at ../../../src/server/sql_mvc.mx:379
#15 0x00007fffe4eed9f5 in monet5_user_get_def_schema (m=0x13347f8,
user=0)
at ../../../../src/backends/monet5/sql_user.mx:463
#16 0x00007fffe4eef0d6 in SQLinitClient (c=0x605a90)
at ../../../../src/backends/monet5/sql_scenario.mx:431
#17 0x00007ffff7b099df in runPhase (c=0x605a90, phase=5)
at ../../../src/mal/mal_scenario.mx:602
#18 0x00007ffff7b09aa2 in runScenarioBody (c=0x605a90)
at ../../../src/mal/mal_scenario.mx:634
#19 0x00007ffff7b09d92 in runScenario (c=0x605a90)
at ../../../src/mal/mal_scenario.mx:679
#20 0x00007ffff7abe7fc in MSserveClient (dummy=0x605a90)
at ../../../src/mal/mal_session.mx:474
#21 0x00007ffff5797894 in start_thread (arg=<value optimized out>)
---Type <return> to continue, or q <return> to quit---
at pthread_create.c:297
#22 0x00007ffff48c4f9d in clone ()
at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#23 0x0000000000000000 in ?? ()
----------------------------------------------------------------------
Comment By: Stefan de Konink (skinkie)
Date: 2010-01-21 14:17
Message:
1) I executed msqldump (first sentence of the initial comment);
2) CVS head of begin december
3) I can't dump because there is an error (CVS head of 19 January)
4) Client (CVS head of 19 January)
5) Execute msqldump
6) None.
----------------------------------------------------------------------
Comment By: Sjoerd Mullender (sjoerd)
Date: 2010-01-21 10:16
Message:
The ususal question:
WHAT DID YOU DO?
Version of server in which the database was created?
Version of server with which you dumped?
Version of client doing the dumping?
How can you reproduce the problem?
Any private patches to the software?
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2935207&group_id=56967
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
