cancel
Showing results for 
Search instead for 
Did you mean: 

LoaderCli SIGSEGV MaxDB 7.9

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

steffen_schildberg
Active Participant
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos
----> 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
Former Member
0 Kudos

----> 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