Crazy HPL Error....
Posted in 2006
Topics: Migration, Import/Export & Data Conversion
Greetings,
Muddled my way through unloading a large IFX 10UC4 database and am trying to
work through the load process.
HPL is really amazing at unloading large amounts of data an I'm thoroughly
impressed..
When calling onpload to execute a load job I get the following:
plsig_segv(): received SIGSEGV
13:35:03 pl_main.c, line 593, thread 13, proc id 18673, Segmentation
Violation.
plsig_segv(): received SIGSEGV
13:35:03 pl_main.c, line 593, thread 1612725740, proc id 18835,Segmentation Violation.
plsig_segv(): received SIGSEGV
plsig_segv(): received SIGSEGV
3: 3: No such file or directory
13:35:03 semop: errno = 22
Not good.
The unload files were created by FASTUNLOAD jobs (the -n flag, express
mode ).
When I look at some of the data contained in the unload files it does not
appear to be ascii text.
Lots of strange characters.
The data was unloaded from a database with a 2K page size and I am
attempting to load it into a database with 8K pages (shouldn't make a
difference.....).
The unload file is residing on a drive physically attached to the server
containing the database I am unloading and has been mounted on the server I
wish to load (not using LDAP though....).
Does anyone have any idea as to what's going on here?
Thanks in advance for your help.
Tam.
Tam O'Shanter wrote:
> Greetings,
>
> Muddled my way through unloading a large IFX 10UC4 database and am trying to
> work through the load process.
>
> HPL is really amazing at unloading large amounts of data an I'm thoroughly
> impressed..
>
Yep.
> When calling onpload to execute a load job I get the following:
>
> plsig_segv(): received SIGSEGV
> 13:35:03 pl_main.c, line 593, thread 13, proc id 18673, Segmentation
> Violation.
> plsig_segv(): received SIGSEGV
> 13:35:03 pl_main.c, line 593, thread 1612725740, proc id 18835,> Segmentation Violation.
> plsig_segv(): received SIGSEGV
> plsig_segv(): received SIGSEGV
> 3: 3: No such file or directory
> 13:35:03 semop: errno = 22>
That a bug...it should never SEGV.
> Not good.
>
> The unload files were created by FASTUNLOAD jobs (the -n flag, express
> mode ).
>
> When I look at some of the data contained in the unload files it does not
> appear to be ascii text.
>
> Lots of strange characters.
>
> The data was unloaded from a database with a 2K page size and I am
> attempting to load it into a database with 8K pages (shouldn't make a
> difference.....).
>
-n is not express mode but a "no conversion" job.
This unloads in "internal Informix format" i.e. pages.
Therefore page size does matter.
Variable page sizes are new in V10 and the manual has not been updated.
Please file a documentation bug with IBM.
> The unload file is residing on a drive physically attached to the server
> containing the database I am unloading and has been mounted on the server I
> wish to load (not using LDAP though....).
>
> Does anyone have any idea as to what's going on here?
>
> Thanks in advance for your help.
>
> Tam.
"Tam O'Shanter" <tam@oshanter.com> wrote in message
news:PQCfh.426276$tl2.81137@fe10.news.easynews.com...
> Greetings,
>
> Muddled my way through unloading a large IFX 10UC4 database and am trying
> to work through the load process.
>
> HPL is really amazing at unloading large amounts of data an I'm thoroughly
> impressed..
>
> When calling onpload to execute a load job I get the following:
>
> plsig_segv(): received SIGSEGV
> 13:35:03 pl_main.c, line 593, thread 13, proc id 18673, Segmentation
> Violation.
> plsig_segv(): received SIGSEGV
> 13:35:03 pl_main.c, line 593, thread 1612725740, proc id 18835,> Segmentation Violation.
> plsig_segv(): received SIGSEGV
> plsig_segv(): received SIGSEGV
> 3: 3: No such file or directory
> 13:35:03 semop: errno = 22
An error 22 is a shortage of some OS resource. Are you sure you have the
kernel settings as per the release notes.
Also, which OS?