on 07-12-2011 12:20 AM
Used
# loadercli -n remotedbipaddress -d ECF3 -u xxx,yyy
loadercli>export schema ecf3 catalog outstream 'ecf3.catalog' data outstream 'ecf3.data'
to create the files in the db server where the import command has been later executed :
# loadercli -d ECF3 -u xxx,yyy
loadercli>import schema ecf3 catalog instream 'ecf3.catalog' data instream 'ecf3.data'
I got an SIGSEGV signal.
The destination server is a MaxDB 7.8 upgraded from MaxDB 7.7, running on linux. The source server is a MaxDB 7.7 running on linux.
Running the opposite, i.e. using the loadercli on the server with the 7.7 version worked.
I'm going to migrate our production server (the source server above) to MaxDB 7.8, on a new server with a fresh MaxDB 7.8 installation.
Is this problem a known issue that applies to fresh installs too ?
Thanks
Hi Andrea,
what is the exact version of the Loader that crashed (loadercli -v)?
I would be interested in the definition of the table the Loader failed at. To find the table you could do the following:
Checking the loader.log file you should find an entry for the import that looks like this (of course with a different GUID):
<your import command>
//
...
// M Import PACKAGE x'06000000AD7AFD020C1C000087210000B1B0833A6941FE66'
Knowing the package identifier run the following command as user xxx:
select tablename,restart from sysloader.transformationmodel where tabletype = 'TABLE' and
packageguid = x'<GUID>' and restart = true
(for my example it must therefore read:
select tablename,restart from sysloader.transformationmodel where tabletype = 'TABLE' and
packageguid = x'06000000AD7AFD020C1C000087210000B1B0833A6941FE66' and restart = true).
The first entry of the result is the table the Loader crashed at. Do you think it is possible to provide me with the definition of this table for reproducing the problem?
Thx and sorry for any inconvenience,
Steffen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Steffen,
sorry for the wrong title, the MaxDB version is 7.8.
loadercli -v
Version: 7.8.02.21
Since the loader.log is full of data, various retries and finally worked using RECORDS instead of PAGES, do you have any hint on how to find the info you're looking for in the whole log ?
I think they're probably these rows:
// M Loader 7.8.02 Build 021-121-242-175
// *
// M Loader instance started at bigboy for database ECF3
// *
// M Starting protocol at 2011071200121256
// *
// M START 20110712 00121256
// *
USE USER "ECF3" * SCHEMA ECF3 SERVERDB "ECF3"
// *
// M USER: 'ECF3' on DB: 'ECF3' ISOLATION LEVEL: 3
// *
// M START 20110712 00121308
// *
import schema ecf3 catalog instream 'ecf3.catalog' data instream 'ecf3.data'
// *
// M Execute PACKAGE to transform unlocked CATALOG
// *
// M Import PACKAGE x'04000000341E1C4E3B0F0000A524610F00017F0000000000'
// *
// M Number of TABLES transformed : 170
// *
// M NULL value representation used: '?'
// *
// M Execute PACKAGE to transform unlocked DATA
// *
// M Number of TABLES to transform: 0
// *
// E -25345: Definitions of source and target table CATONLINE_ORDINE do not match; default definitions differ for column "RIFINTERNO": source default value = ' 1', target default value = ''
Using that GUID I found the PROCESSO table is the first. Here's the definition. The table is EMPTY.The table was also excluded from export command.
CREATE TABLE ECF3.PROCESSO (
GID VARCHAR() ASCII(100) NOT NULL,
AZIONE VARCHAR() ASCII(100),
PARAMETRI VARCHAR() ASCII(5000),
PARAMBLOB BLOB,
PRIORITA INTEGER,
UTENTE VARCHAR() ASCII(50),
STATO CHAR() ASCII(1),
RISULTATO VARCHAR() ASCII(10),
DETTAGLIORISULTATO VARCHAR() ASCII(2000),
PATHRISULTATO VARCHAR() ASCII(250),
ID_AZIENDA INTEGER,
VID INTEGER DEFAULT 0,
DATA_INSERIMENTO TIMESTAMP,
DATA_ESECUZIONE TIMESTAMP,
DATA_RISULTATO TIMESTAMP,
PERC_ESECUZIONE FLOAT,
DESTINAZIONE CHAR() ASCII(1),
DETTAGLIODESTINAZIONE VARCHAR() ASCII(250),
CONTENTTYPERISULTATO VARCHAR() ASCII(100),
PRIMARY KEY (GID)
);
P.S. The error in the log cites another table, CATONLINE_ORDINE, this is the definition in case it's important. This table was included in the export.
CREATE TABLE ECF3.CATONLINE_ORDINE (
ID INTEGER,
ID_CATONLINE INTEGER,
DENOMINAZIONE VARCHAR() ASCII(50),
EMAIL VARCHAR() ASCII(50),
TELEFONO VARCHAR() ASCII(16),
NOTE VARCHAR() ASCII(250),
DATA DATE,
STATO INTEGER DEFAULT 1 NOT NULL,
RIFINTERNO VARCHAR() ASCII(50) NOT NULL,
NOTEINTERNE VARCHAR() ASCII(255)
);
Thank you
----> Emergency stack backtrace <----
Using 'backtrace' for stack tracing
(0):0x000000394740e540
(1):0x000000000063517e
(2):0x0000000000637dc0
(3):0x000000000063a473
(4):0x0000000000631bf9
(5):0x0000000000632ca3
(6):0x00000000005e968b
(7):0x00000000005ea0a1
(8):0x00000000005e20e8
(9):0x0000000000408f18
(10):0x00000000004092b0
(11):0x000000000040c4f5
(12):0x000000394681e074
(13):0x000000000040863a
----> Dump of siginfo contents <----
signal: 11(SIGSEGV)
code: 1(ILL_ILLOPC:illegal opcode)
errno: 0
value(int): 0(0x0)
value(ptr): (nil)
pid: 136
addr: 0x88
----> Register Dump <----
rax: 0x0000000000000000 rbx: 0x00000000013c1720
rcx: 0xffffffffffffffff rdx: 0x00000000013c4070
rsi: 0x00000000ffffffff rdi: 0x0000000000dd3268
rsp: 0x00007fffbbcf8080 rbp: 0x0000000000000000
r08: 0x726174202c273120 r09: 0x6166656420746567
r10: 0x756c617620746c75 r11: 0x0000000000000246
r12: 0x0000000000b97608 r13: 0x0000000000b97608
r14: 0x00000000013c0330 r15: 0x00000000013c2480
rip: 0x000000000063517e eflg: 0x0000000000010213
cs: 0x0000 gs: 0x0000
fs: 0x0000
omsk: 0x0000000000000000 cr2: 0x0000000000000088
trap: 0x000000000000000e err: 0x0000000000000004
----> Floating-point register dump <----
foper: 0x0000 frip: 0x0000000000000000 fdata: 0x0000000000000000
control: 0x0000 status: 0x0000 tag: 0x0000
mxcsr: 0x00000000 mxcr_mask: 0x00000000
fp[0]: 0x0.0000 0000 0000 0000 * 2^0x0000
fp[1]: 0x0.0000 0000 0000 0000 * 2^0x0000
fp[2]: 0x0.0000 0000 0000 0000 * 2^0x0000
fp[3]: 0x0.0000 0000 0000 0000 * 2^0x0000
fp[4]: 0x0.0000 0000 0000 0000 * 2^0x0000
fp[5]: 0x0.0000 0000 0000 0000 * 2^0x0000
fp[6]: 0x0.0000 0000 0000 0000 * 2^0x0000
fp[7]: 0x0.0000 0000 0000 0000 * 2^0x0000
xmm[00]: 0x00000000.00000000.00000000.00000000
xmm[01]: 0x00000000.00000000.00000000.00000000
xmm[02]: 0x00000000.00000000.00000000.00000000
xmm[03]: 0x00000000.00000000.00000000.00000000
xmm[04]: 0x00000000.00000000.00000000.00000000
xmm[05]: 0x00000000.00000000.00000000.00000000
xmm[06]: 0x00000000.00000000.00000000.00000000
xmm[07]: 0x00000000.00000000.00000000.00000000
xmm[08]: 0x00000000.00000000.00000000.00000000
xmm[09]: 0x00000000.00000000.00000000.00000000
xmm[10]: 0x00000000.00000000.00000000.00000000
xmm[11]: 0x00000000.00000000.00000000.00000000
xmm[12]: 0x00000000.00000000.00000000.00000000
xmm[13]: 0x00000000.00000000.00000000.00000000
xmm[14]: 0x00000000.00000000.00000000.00000000
xmm[15]: 0x00000000.00000000.00000000.00000000
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
----> Module List <----
|.text Start |.text End | Module File Name
----> Symbolic stack backtrace <----
0: tfind@@GLIBC_2.2.5 + 0xe540
SFrame: IP: 0x000000394740e540 (0x0000003947400000+0xe540)
Module: /lib64/libpthread-2.7.so
-----------------------------------------
1: ls28_CompareDefaultDefinitions(Tools_DynamicUTF8String&, tls00_DBInfo*, TableDef*, tls00_TloadRec*, tsp7_table_description*, ReadBuffer&, char*) + 0x41e
Symbol: _Z30ls28_CompareDefaultDefinitionsR23Tools_DynamicUTF8StringP12tls00_DBInfoP8TableDefP14tls00_TloadRecP22tsp7_table_descriptionR10ReadBufferPc
SFrame: IP: 0x000000000063517e (0x0000000000634d60+0x41e)
Module: /opt/sdb/MaxDB/bin/loadercli
-----------------------------------------
2: ls28_CompareTableDefinitions(tls00_DBInfo*, tls00_TloadRec*, TableDef*, ReadBuffer&, Tools_DynamicUTF8String&, char*) + 0xd20
Symbol: _Z28ls28_CompareTableDefinitionsP12tls00_DBInfoP14tls00_TloadRecP8TableDefR10ReadBufferR23Tools_DynamicUTF8StringPc
SFrame: IP: 0x0000000000637dc0 (0x00000000006370a0+0xd20)
Module: /opt/sdb/MaxDB/bin/loadercli
-----------------------------------------
3: ls28ImportTablePages(MetaDataDef*&, tls00_TloadRec*, ReadBuffer&, char*) + 0xc13
Symbol: _Z20ls28ImportTablePagesRP11MetaDataDefP14tls00_TloadRecR10ReadBufferPc
SFrame: IP: 0x000000000063a473 (0x0000000000639860+0xc13)
Module: /opt/sdb/MaxDB/bin/loadercli
-----------------------------------------
4: ls28ImportPackageTables(MetaDataDef*&, tls00_TloadRec*, char*) + 0xb99
Symbol: _Z23ls28ImportPackageTablesRP11MetaDataDefP14tls00_TloadRecPc
SFrame: IP: 0x0000000000631bf9 (0x0000000000631060+0xb99)
Module: /opt/sdb/MaxDB/bin/loadercli
-----------------------------------------
5: ImportPackageData(MetaDataDef*, tls00_DBInfo*, char*) + 0x973
Symbol: _Z17ImportPackageDataP11MetaDataDefP12tls00_DBInfoPc
SFrame: IP: 0x0000000000632ca3 (0x0000000000632330+0x973)
Module: /opt/sdb/MaxDB/bin/loadercli
-----------------------------------------
6: ExecuteTransformationPackage(tls00_Command*, tls00_DBInfo*) + 0x2db
Symbol: _Z28ExecuteTransformationPackageP13tls00_CommandP12tls00_DBInfo
SFrame: IP: 0x00000000005e968b (0x00000000005e93b0+0x2db)
Module: /opt/sdb/MaxDB/bin/loadercli
-----------------------------------------
7: ParseExecuteStatement(tls00_Command*&, tls00_DBInfo*) + 0x531
Symbol: _Z21ParseExecuteStatementRP13tls00_CommandP12tls00_DBInfo
SFrame: IP: 0x00000000005ea0a1 (0x00000000005e9b70+0x531)
Module: /opt/sdb/MaxDB/bin/loadercli
-----------------------------------------
8: ctrlservcommand + 0x398
SFrame: IP: 0x00000000005e20e8 (0x00000000005e1d50+0x398)
Module: /opt/sdb/MaxDB/bin/loadercli
-----------------------------------------
9: ls40_ServerCommand(tls40_Options*) + 0x158
Symbol: _Z18ls40_ServerCommandP13tls40_Options
SFrame: IP: 0x0000000000408f18 (0x0000000000408dc0+0x158)
Module: /opt/sdb/MaxDB/bin/loadercli
-----------------------------------------
10: ls40_ExecuteTaskInteractive(tls40_Options*) + 0x2e0
Symbol: _Z27ls40_ExecuteTaskInteractiveP13tls40_Options
SFrame: IP: 0x00000000004092b0 (0x0000000000408fd0+0x2e0)
Module: /opt/sdb/MaxDB/bin/loadercli
-----------------------------------------
11: main + 0xb15
SFrame: IP: 0x000000000040c4f5 (0x000000000040b9e0+0xb15)
Module: /opt/sdb/MaxDB/bin/loadercli
-----------------------------------------
12: _dl_tls_get_addr_soft@@GLIBC_PRIVATE + 0x1e074
SFrame: IP: 0x000000394681e074 (0x0000003946800000+0x1e074)
Module: /lib64/libc-2.7.so
-----------------------------------------
13: __gxx_personality_v0@@CXXABI_1.3 + 0x11a
SFrame: IP: 0x000000000040863a (0x0000000000408520+0x11a)
Source: start.S:116
Module: /opt/sdb/MaxDB/bin/loadercli
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.