mysqlhotcopy.pl abends the server

[Fribse]

Hi Guys

I need to back up a mysql database. The easiest thing to use is
mysqlhotcopy script that's in the MySQL package.

I'm using MySQL 4.14a on Netware 6.0 SP5 with LIBC 9.00.03 (22 Sept
2005).
The Perl I've downloaded from forge came in an archive called perl-
5.9.3-20102005-dev-netware-build, however the m perl* reports Perl
5.8.4???

I gave it the command:
perl sys:/mysql/scripts/mysqlhotcopy.pl --dryrun --user=root --
password=***** videodb

I get two output screens:
Interpreter:
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LC_ALL = (unset),
LANG = (unset)
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").

perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LC_ALL = (unset),
LANG = (unset)
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
Using copy suffix '_copy'
mkdir web:/mysqldb/videodb_copy, 0750
LOCK TABLES `videodb`.`actors` READ, `videodb`.`config` READ, `videodb`.
`genres`
READ, `videodb`.`lent` READ, `videodb`.`mediatypes` READ, `videodb`.
`permission
s` READ, `videodb`.`userconfig` READ, `videodb`.`users` READ, `videodb`.
`usersee
n` READ, `videodb`.`videodata` READ, `videodb`.`videogenre` READ
FLUSH TABLES /*!32323 `videodb`.`actors`, `videodb`.`config`, `videodb`.
`genres`
, `videodb`.`lent`, `videodb`.`mediatypes`, `videodb`.`permissions`,
`videodb`.`
userconfig`, `videodb`.`users`, `videodb`.`userseen`, `videodb`.
`videodata`, `vi
deodb`.`videogenre` */
Copying 34 files...
Copying indices for 0 files...
UNLOCK TABLES

As I've only done a dryrun, nothing is created.

The problem is I get an abend:

Server SPIFF halted Saturday, 22 October 2005 18.20.04,881
Abend 1 on P00: Server-5.60.05: Page Fault Processor Exception (Error
code 00000000)

Registers:
CS = 0060 DS = 007B ES = 007B FS = 007B GS = 007B SS = 0068
EAX = 00000000 EBX = 987A65D4 ECX = 987A6500 EDX = 00001FE4
ESI = 00000000 EDI = 8166D060 EBP = 99686B88 ESP = 99686B64
EIP = 99798F50 FLAGS = 00010246
99798F50 FF5604 CALL near ptr [ESI+04]=?
EIP in LIBMYSQL.NLM at code start +00008F50h
Access Location: 0x00000004

The violation occurred while processing the following instruction:
99798F50 FF5604 CALL near ptr [ESI+04]
99798F53 83C41C ADD ESP,0000001C
99798F56 53 PUSH EBX
99798F57 E8EDE6FFFF CALL 99797649
99798F5C 59 POP ECX
99798F5D 53 PUSH EBX
99798F5E E84BFEFFFF CALL 99798DAE
99798F63 59 POP ECX
99798F64 53 PUSH EBX
99798F65 E820FFFFFF CALL 99798E8A



Running process: PERL.NLM's main thread Process
Thread Owned by NLM: PERL.NLM
Stack pointer: 99686E80
OS Stack limit: 99607900
Scheduling priority: 67371008
Wait state: 3030070 Yielded CPU
Stack: --987A65D4 ?
--00000001 ?
--00000000 ?
--00000000 ?
--00000000 ?
--00000000 ?
--00000001 ?
--99697100 ?
--987A65D4 ?
--99686BB8 ?
996B9D11 (PMYSQL.NLM|***@mysql_db_disconnect+71)
--987A65D4 ?
-996C380D (PMYSQL.NLM|(Data Start)+180D)
--00000005 ?
--00180293 ?
--8166D060 (NWBSRVCM.NLM|BIsValidRequestClass+8FF4)
--996AF8A0 ?
--00000000 ?
--987A6580 ?
--8166D060 (NWBSRVCM.NLM|BIsValidRequestClass+8FF4)
--996AF8A0 ?
--99686BE8 ?
996BD873 (PMYSQL.NLM|***@XS_DBD__mysql__db_disconnect+D3)
--8166D060 (NWBSRVCM.NLM|BIsValidRequestClass+8FF4)
--996AF8A0 ?
--987A6580 ?
--99332D00 ?
--8E4AF6E0 ?
--00000001 ?
--995F4240 ?
--994D3DE0 ?
--00000000 ?
--00000001 ?
--99686E58 ?
9883BBE4 (DBI.NLM|***@XS_DBI_dispatch+24D4)
--8166D060 (NWBSRVCM.NLM|BIsValidRequestClass+8FF4)
--994D3DF0 ?
--9929FDC0 ?
--00000000 ?
--9975E5E0 ?
--99686C0C ?
CA33F4AC (COMN.NSS|BEASTHASH_enqNotInUseBeasts+3C)
--99686C20 ?
--00000246 ?
002690E6 (SERVER.NLM|FreeMemoryDefault+C2)
--87B0A044 ?
--00000246 ?
--00000018 ?
--00000000 ?
--994D3DE0 ?
--987A6580 ?
--00000C01 ?
--9929FDC0 ?
--00000000 ?
--00000000 ?
--00000001 ?
CCF5A591 (THREADS.NLM|__CHK+21)
--00000000 ?
--FFFFFFFF (LOADER.EXE|KernelTempAliasesEnd+FFF)
--00000000 ?
--00000000 ?
--00000000 ?
--00000000 ?
--00000000 ?
--00000000 ?
--87B0A044 ?
--994CA6D0 ?
--994D2DD0 ?
--99276A10 ?
--996AF8A0 ?
--988446A0 (DBI.NLM|***@boot_DBI+2E50)
--00000001 ?
--00000000 ?
--00000001 ?
--8E4AF6E4 ?
--00000018 ?
--99686D68 ?
--00000246 ?
002690E6 (SERVER.NLM|FreeMemoryDefault+C2)
--87B0A044 ?
--00000246 ?
--00000018 ?
--99686D90 ?
--00000018 ?
--00000020 ?
--996D3000 ?
00268FC8 (SERVER.NLM|Free+1E8)
--996D37D8 ?
002690E6 (SERVER.NLM|FreeMemoryDefault+C2)
--87B0A044 ?
--00000246 ?
--98604380 ?
--98604D20 ?
--00000246 ?
0026854F (SERVER.NLM|AllocMemoryDefault+11F)
--87B0A044 ?
--00000246 ?
--00000246 ?
--87B0A044 ?
--98604380 ?

Additional Information:
The CPU encountered a problem executing code in LIBMYSQL.NLM. The
problem may be in that module or in data passed to that module by a
process owned by PERL.NLM.

<module information cut out>

[Guenter Knauf, DevNet SysOp 32]

Ho Fribse,
yep - seems the libmysql is buggy.
I've added the mysql forum so the developers see that too....

Guenter.

Post by Fribse
Hi Guys
I need to back up a mysql database. The easiest thing to use is
mysqlhotcopy script that's in the MySQL package.
I'm using MySQL 4.14a on Netware 6.0 SP5 with LIBC 9.00.03 (22 Sept
2005).
The Perl I've downloaded from forge came in an archive called perl-
5.9.3-20102005-dev-netware-build, however the m perl* reports Perl
5.8.4???
perl sys:/mysql/scripts/mysqlhotcopy.pl --dryrun --user=root --
password=***** videodb
perl: warning: Setting locale failed.
LC_ALL = (unset),
LANG = (unset)
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
perl: warning: Setting locale failed.
LC_ALL = (unset),
LANG = (unset)
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
Using copy suffix '_copy'
mkdir web:/mysqldb/videodb_copy, 0750
LOCK TABLES `videodb`.`actors` READ,
`videodb`.`config` READ, `videodb`. `genres`
READ, `videodb`.`lent` READ, `videodb`.`mediatypes` READ, `videodb`.
`permission
s` READ, `videodb`.`userconfig` READ, `videodb`.`users` READ, `videodb`.
`usersee
n` READ, `videodb`.`videodata` READ, `videodb`.`videogenre` READ
FLUSH TABLES /*!32323 `videodb`.`actors`, `videodb`.`config`,
`videodb`. `genres`
, `videodb`.`lent`, `videodb`.`mediatypes`, `videodb`.`permissions`,
`videodb`.`
userconfig`, `videodb`.`users`, `videodb`.`userseen`, `videodb`.
`videodata`, `vi
deodb`.`videogenre` */
Copying 34 files...
Copying indices for 0 files...
UNLOCK TABLES
As I've only done a dryrun, nothing is created.
Server SPIFF halted Saturday, 22 October 2005 18.20.04,881
Abend 1 on P00: Server-5.60.05: Page Fault Processor Exception (Error
code 00000000)
CS = 0060 DS = 007B ES = 007B FS = 007B GS = 007B SS = 0068
EAX = 00000000 EBX = 987A65D4 ECX = 987A6500 EDX = 00001FE4
ESI = 00000000 EDI = 8166D060 EBP = 99686B88 ESP = 99686B64
EIP = 99798F50 FLAGS = 00010246
99798F50 FF5604 CALL near ptr [ESI+04]=?
EIP in LIBMYSQL.NLM at code start +00008F50h
Access Location: 0x00000004
99798F50 FF5604 CALL near ptr [ESI+04]
99798F53 83C41C ADD ESP,0000001C
99798F56 53 PUSH EBX
99798F57 E8EDE6FFFF CALL 99797649
99798F5C 59 POP ECX
99798F5D 53 PUSH EBX
99798F5E E84BFEFFFF CALL 99798DAE
99798F63 59 POP ECX
99798F64 53 PUSH EBX
99798F65 E820FFFFFF CALL 99798E8A
Running process: PERL.NLM's main thread Process
Thread Owned by NLM: PERL.NLM
Stack pointer: 99686E80
OS Stack limit: 99607900
Scheduling priority: 67371008
Wait state: 3030070 Yielded CPU
Stack: --987A65D4 ?
--00000001 ?
--00000000 ?
--00000000 ?
--00000000 ?
--00000000 ?
--00000001 ?
--99697100 ?
--987A65D4 ?
--99686BB8 ?
--987A65D4 ?
-996C380D (PMYSQL.NLM|(Data Start)+180D)
--00000005 ?
--00180293 ?
--8166D060 (NWBSRVCM.NLM|BIsValidRequestClass+8FF4)
--996AF8A0 ?
--00000000 ?
--987A6580 ?
--8166D060 (NWBSRVCM.NLM|BIsValidRequestClass+8FF4)
--996AF8A0 ?
--99686BE8 ?
--8166D060 (NWBSRVCM.NLM|BIsValidRequestClass+8FF4)
--996AF8A0 ?
--987A6580 ?
--99332D00 ?
--8E4AF6E0 ?
--00000001 ?
--995F4240 ?
--994D3DE0 ?
--00000000 ?
--00000001 ?
--99686E58 ?
--8166D060 (NWBSRVCM.NLM|BIsValidRequestClass+8FF4)
--994D3DF0 ?
--9929FDC0 ?
--00000000 ?
--9975E5E0 ?
--99686C0C ?
CA33F4AC (COMN.NSS|BEASTHASH_enqNotInUseBeasts+3C)
--99686C20 ?
--00000246 ?
002690E6 (SERVER.NLM|FreeMemoryDefault+C2)
--87B0A044 ?
--00000246 ?
--00000018 ?
--00000000 ?
--994D3DE0 ?
--987A6580 ?
--00000C01 ?
--9929FDC0 ?
--00000000 ?
--00000000 ?
--00000001 ?
CCF5A591 (THREADS.NLM|__CHK+21)
--00000000 ?
--FFFFFFFF (LOADER.EXE|KernelTempAliasesEnd+FFF)
--00000000 ?
--00000000 ?
--00000000 ?
--00000000 ?
--00000000 ?
--00000000 ?
--87B0A044 ?
--994CA6D0 ?
--994D2DD0 ?
--99276A10 ?
--996AF8A0 ?
--00000001 ?
--00000000 ?
--00000001 ?
--8E4AF6E4 ?
--00000018 ?
--99686D68 ?
--00000246 ?
002690E6 (SERVER.NLM|FreeMemoryDefault+C2)
--87B0A044 ?
--00000246 ?
--00000018 ?
--99686D90 ?
--00000018 ?
--00000020 ?
--996D3000 ?
00268FC8 (SERVER.NLM|Free+1E8)
--996D37D8 ?
002690E6 (SERVER.NLM|FreeMemoryDefault+C2)
--87B0A044 ?
--00000246 ?
--98604380 ?
--98604D20 ?
--00000246 ?
0026854F (SERVER.NLM|AllocMemoryDefault+11F)
--87B0A044 ?
--00000246 ?
--00000246 ?
--87B0A044 ?
--98604380 ?
The CPU encountered a problem executing code in LIBMYSQL.NLM. The
problem may be in that module or in data passed to that module by a
process owned by PERL.NLM.
<module information cut out>

[Fribse]

Post by Guenter Knauf, DevNet SysOp 32
yep - seems the libmysql is buggy.
I've added the mysql forum so the developers see that too....

Hi Guenter

Good idea, thanks :-)

[KMurugan]

Hi,

Thanks for trying developement version of Perl 5.9.3 and reporting the
issues here. Thanks again for this. As you reported , I have to change
the configuartion file to chage the Perl version from 5.8.4 to 5.9.3. It
is a bug. Just I over looked.

Fine, You can get the Perl modules for Perl 5.8.0 and Perl 5.8.4 from
the following URL,
http://forge.novell.com/modules/xfcontent/downloads.php/perl/Modules.

Since you are reporting this bug for Perl 5.9.3. (I have to test this.
It may be a issue with building with incompatabile mysql headers). I
will fix this issue and you will get the fix by friday ( 28/10/2005) as
these binaries will be uploaded to forge on weekly basis.

Regards
K.Murugan

Post by Fribse

Post by Guenter Knauf, DevNet SysOp 32
yep - seems the libmysql is buggy.
I've added the mysql forum so the developers see that too....

Hi Guenter
Good idea, thanks :-)

[KMurugan]

I forgot to update that Perl 5.9.3 and 5.8.4 is supported only on
NetWare 6.5 with SP3 or later.

Regards
K.Murugan

Post by KMurugan
Hi,
Thanks for trying developement version of Perl 5.9.3 and reporting the
issues here. Thanks again for this. As you reported , I have to change
the configuartion file to chage the Perl version from 5.8.4 to 5.9.3. It
is a bug. Just I over looked.
Fine, You can get the Perl modules for Perl 5.8.0 and Perl 5.8.4 from
the following URL,
http://forge.novell.com/modules/xfcontent/downloads.php/perl/Modules.
Since you are reporting this bug for Perl 5.9.3. (I have to test this.
It may be a issue with building with incompatabile mysql headers). I
will fix this issue and you will get the fix by friday ( 28/10/2005) as
these binaries will be uploaded to forge on weekly basis.
Regards
K.Murugan

Post by Fribse

yep - seems the libmysql is buggy. I've added the mysql forum so the
developers see that too....

Hi Guenter
Good idea, thanks :-)

[Fribse]

Post by KMurugan
I forgot to update that Perl 5.9.3 and 5.8.4 is supported only on
NetWare 6.5 with SP3 or later.

Thanks Murugan
I'll have to hold of the upgrade for a while, but 'isnt supported' isn't
the same as 'doesnt work' :-) But thanks for the heads up.
As soon as I feel confident that the system will keep working with 6.5,
it will get upgraded.

[Guenter Knauf, DevNet SysOp 32]

Hi Fribse,

Post by Fribse

Post by KMurugan
I forgot to update that Perl 5.9.3 and 5.8.4 is supported only on
NetWare 6.5 with SP3 or later.

Thanks Murugan
I'll have to hold of the upgrade for a while, but 'isnt supported' isn't
the same as 'doesnt work' :-) But thanks for the heads up.

nope! That isnt true! Apache2 also was never supported on NW6, and you're
running it fine! MySQL same!
So what Murugan wanted to say is that you're on your own with such upgrades,
and Novell Support refuses to help...
and that you probably run into problems at all with latest Perl versions
cause they may rely on fixes not present in your LibC.

Guenter.

[Fribse]

Post by Guenter Knauf, DevNet SysOp 32

Post by Fribse
I'll have to hold of the upgrade for a while, but 'isnt supported' isn't
the same as 'doesnt work' :-) But thanks for the heads up.

nope! That isnt true! Apache2 also was never supported on NW6, and you're
running it fine! MySQL same!

Hmm, wasn't that what I was saying :-)??
I know I might run into problems further on, and the upgrade is on it's
way, it's just a question of pulling a day out of the calendar and get
it done :-)

/Fribse

[Fribse]

Post by Fribse

Post by Guenter Knauf, DevNet SysOp 32

Post by Fribse
I'll have to hold of the upgrade for a while, but 'isnt supported' isn't
the same as 'doesnt work' :-) But thanks for the heads up.

nope! That isnt true! Apache2 also was never supported on NW6, and you're
running it fine! MySQL same!

Hmm, wasn't that what I was saying :-)??
I know I might run into problems further on, and the upgrade is on it's
way, it's just a question of pulling a day out of the calendar and get
it done :-)

So yesterday I finally got around to doing it, now my tomcat has gone
haywire, and neither imanager nor groupwise webaccess works, I just knew
it :-)

[Simon Flood]

Post by KMurugan
Thanks for trying developement version of Perl 5.9.3 and reporting the
issues here. Thanks again for this. As you reported , I have to change
the configuartion file to chage the Perl version from 5.8.4 to 5.9.3. It
is a bug. Just I over looked.
Fine, You can get the Perl modules for Perl 5.8.0 and Perl 5.8.4 from
the following URL,
http://forge.novell.com/modules/xfcontent/downloads.php/perl/Modules.

The updated modules for Perl 5.8.4 and MySQL 4.1.10 (I'm using 4.1.14a
and about to upgrade to 4.1.15a) appear to have fixed the abends I was
experiencing when attempting to use the mysqlhotcopy script.

Many thanks,

Simon

[Fribse]

Post by Simon Flood

Post by KMurugan
Thanks for trying developement version of Perl 5.9.3 and reporting the
issues here. Thanks again for this. As you reported , I have to change
the configuartion file to chage the Perl version from 5.8.4 to 5.9.3. It
is a bug. Just I over looked.
Fine, You can get the Perl modules for Perl 5.8.0 and Perl 5.8.4 from
the following URL,
http://forge.novell.com/modules/xfcontent/downloads.php/perl/Modules.

The updated modules for Perl 5.8.4 and MySQL 4.1.10 (I'm using 4.1.14a
and about to upgrade to 4.1.15a) appear to have fixed the abends I was
experiencing when attempting to use the mysqlhotcopy script.

I got it up to Netware 6.5, and I've just tried doing the backup, works
perfectly! Great Job Murugan, thank you VERY much.

Will the 5.9.3 have the fixes included in the package, or will there be
modules like the above for that as well?