Mysql got signal 10 when connecting with JDBC client to official MySQL binary on HP-UX 11.11
am 28.02.2003 17:52:35 von lars-goran.forsberg>Description:
When connecting to mysql-3.23.55-hp-hpux11.11-hppa2.0w from a java client
(through MySQL Connector/J 2.0.14 or 3.0.6) the mysql process is restarted
due to signal 10.
Connecting from the "mysql" client is no problem.
Connecting to mysql-3.23.55-hp-hpux10.20-hppa from the same java client
on the same machine seems to work correctly.
Since we are running HP-UX 11.11, we should run the 11.11 binary, right?
But why does it crash when connecting with the JDBC driver??
The machine is an HP rp2470 with 2*CPU and 2GB memory. We have tested on
several different HP-UX 11.11 machines, so it should not be a hardware
problem.
From the error log:
mysqld got signal 10;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail
key_buffer_size=8388600
record_buffer=131072
sort_buffer=2097144
max_used_connections=0
max_connections=200
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 443390 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation
030221 04:54:19 mysqld restarted
Some kernel paramters:
Parameter Current Dyn Planned Module
Version
============================================================ ================
===
NSTRBLKSCHED - - 2
NSTREVENT 50 - 50
NSTRPUSH 16 - 16
NSTRSCHED 0 - 0
STRCTLSZ 1024 - 1024
STRMSGSZ 65535 - 65535
acctresume 4 - 4
acctsuspend 2 - 2
aio_listio_max 256 - 256
aio_max_ops 2048 - 2048
aio_physmem_pct 10 - 10
aio_prio_delta_max 20 - 20
allocate_fs_swapmap 0 - 0
alwaysdump 1 - 1
bootspinlocks - - 256
bufcache_hash_locks 128 - 128
bufpages 0 - (NBUF*2)
chanq_hash_locks 256 - 256
core_addshmem_read 0 Y 0
core_addshmem_write 0 Y 0
create_fastlinks 0 - 0
dbc_max_pct 50 - 50
dbc_min_pct 5 - 5
default_disk_ir 0 - 0
desfree - - 0
disksort_seconds 0 - 0
dmp_rootdev_is_vol 0 - 0
dmp_swapdev_is_vol 0 - 0
dnlc_hash_locks 512 - 4*128
dontdump 0 - 0
dskless_node - - 0
dst 1 - 1
effective_maxpid - - ((NPROC<=30000)?30000:(NPROC*5/4))
eisa_io_estimate - - 0x300
enable_idds 0 - 0
eqmemsize 15 - 15
executable_stack 1 - 1
fcp_large_config 0 - 0
file_pad - - 10
fs_async 0 - 0
ftable_hash_locks 64 - 64
hdlpreg_hash_locks 128 - 128
hfs_max_ra_blocks 8 - 8
hfs_max_revra_blocks 8 - 8
hfs_ra_per_disk 64 - 64
hfs_revra_per_disk 64 - 64
hp_hfs_mtra_enabled 1 - 1
hpux_aes_override - - 0
initmodmax 50 - 50
io_ports_hash_locks 64 - 64
iomemsize - - 40000
ksi_alloc_max 16384 - (NPROC*8)
ksi_send_max 32 - 32
lotsfree - - 0
max_async_ports 50 - 50
max_fcp_reqs 512 - 512
max_mem_window 0 - 0
max_thread_proc 3000 - 3000
maxdsiz 2063835136 - 2063835136
maxdsiz_64bit 0x40000000 - 0x0000000040000000
maxfiles 2048 - 2048
maxfiles_lim 2048 Y 2048
maxqueuetime - - 0
maxssiz 0x800000 - 0x00800000
maxssiz_64bit 0x800000 - 0x00800000
maxswapchunks 2048 - 2048
maxtsiz 0x4000000 Y 0x04000000
maxtsiz_64bit 0x40000000 Y 0x0000000040000000
maxuprc 75 Y 75
maxusers 512 - 512
maxvgs 10 - 10
mesg 1 - 1
minfree - - 0
modstrmax 500 - 500
msgmap 42 - (2+MSGTQL)
msgmax 8192 Y 8192
msgmnb 16384 Y 16384
msgmni 50 - 50
msgseg 2048 - 2048
msgssz 8 - 8
msgtql 40 - 40
nbuf 0 - 0
ncallout 6000 - 6000
ncdnode 150 - 150
nclist 8292 - (100+16*MAXUSERS)
ncsize 7848 - (NINODE+VX_NCSIZE)+(8*DNLC_HASH_LOCKS)
ndilbuffers 30 - 30
netisr_priority - - -1
netmemmax - - 0
nfile 3000 - 3000
nflocks 200 - 200
nhtbl_scale 0 - 0
ninode 2728 - ((NPROC+16+MAXUSERS)+32+(2*NPTY))
nkthread 6000 - 6000
nni - - 2
no_lvm_disks 0 - 0
nproc 2048 - 2048
npty 60 - 60
nstrpty 60 - 60
nstrtel 60 - 60
nswapdev 10 - 10
nswapfs 10 - 10
nsysmap 4096 - ((NPROC)>800?2*(NPROC):800)
nsysmap64 4096 - ((NPROC)>800?2*(NPROC):800)
o_sync_is_o_dsync 0 - 0
page_text_to_local - - 0
pfdat_hash_locks 128 - 128
public_shlibs 1 - 1
region_hash_locks 128 - 128
remote_nfs_swap 0 - 0
rtsched_numpri 32 - 32
scroll_lines 100 - 100
scsi_max_qdepth 8 Y 8
scsi_maxphys 1048576 - 1048576
sema 1 - 1
semaem 16384 - 16384
semmap 66 - (SEMMNI+2)
semmni 64 - 64
semmns 128 - 128
semmnu 30 - 30
semmsl 2048 Y 2048
semume 10 - 10
semvmx 32767 - 32767
sendfile_max 0 - 0
shmem 1 - 1
shmmax 0x4000000 Y 0X4000000
shmmni 200 - 200
shmseg 120 Y 120
st_ats_enabled 0 - 0
st_fail_overruns 0 - 0
st_large_recs 0 - 0
streampipes 0 - 0
swapmem_on 1 - 1
swchunk 2048 - 2048
sysv_hash_locks 128 - 128
tcphashsz 0 - 0
timeslice 10 - (100/10)
timezone 420 - 420
unlockable_mem 0 - 0
vas_hash_locks 128 - 128
vnode_cd_hash_locks 128 - 128
vnode_hash_locks 128 - 128
vol_checkpt_default 10240 - 10240
vol_default_iodelay 50 - 50
vol_fmr_logsz 4 - 4
vol_max_bchain 32 - 32
vol_max_nconfigs 20 - 20
vol_max_nlogs 20 - 20
vol_max_nmpool_sz 4194304 - (4*1024*1024)
vol_max_prm_dgs 1024 - 1024
vol_max_rdback_sz 4194304 - (4*1024*1024)
vol_max_vol 8388608 - (8*1024*1024)
vol_maxio 256 - 256
vol_maxioctl 32768 - 32768
vol_maxkiocount 2048 - 2048
vol_maxparallelio 256 - 256
vol_maxspecialio 256 - 256
vol_maxstablebufsize 256 - 256
vol_min_lowmem_sz 524288 - (512*1024)
vol_mvr_maxround 256 - 256
vol_rootdev_is_vol 0 - 0
vol_subdisk_num 4096 - 4096
vol_swapdev_is_vol 0 - 0
vol_vvr_transport 1 - (1)
volcvm_cluster_size 16 - 16
volcvm_smartsync 1 - 1
voldrl_max_drtregs 2048 - 2048
voldrl_min_regionsz 512 - 512
voliomem_chunk_size 65536 - (64*1024)
voliomem_maxpool_sz 4194304 - (4*1024*1024)
voliot_errbuf_dflt 16384 - 16384
voliot_iobuf_default 8192 - 8192
voliot_iobuf_limit 131072 - 131072
voliot_iobuf_max 65536 - 65536
voliot_max_open 32 - 32
volraid_rsrtransmax 1 - 1
vps_ceiling 16 - 16
vps_chatr_ceiling 1048576 - 1048576
vps_pagesize 4 - 4
vx_fancyra_enable 0 - 0
vx_ncsize 1024 - 1024
vx_ninode - - 0
vxfs_max_ra_kbytes 1024 - 1024
vxfs_ra_per_disk 1024 - 1024
vxtask_max_monitors 32 - 32
>How-To-Repeat:
Connect with MySQL Connector/J.
>Fix:
?
>Submitter-Id:
>Originator:
>Organization: Incomit AB
>MySQL support: license
>Synopsis:
>Severity: critical
>Priority:
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.55 (Official MySQL binary)
>Environment:
System: HP-UX HP5 B.11.11 U 9000/800 940027831 unlimited-user license
Some paths: /usr/contrib/bin/perl /usr/bin/make /usr/bin/cc
Compilation info: CC='cc' CFLAGS='+DD64' CXX='aCC' CXXFLAGS='+DD64'
LDFLAGS=
''
LIBC:
lrwxr-xr-x 1 root root 8 Feb 19 09:12 /lib/libc.0 ->
../libc.
1
-r-xr-xr-x 1 bin bin 1867776 Dec 6 2001 /lib/libc.1
-r-xr-xr-x 1 bin bin 1806336 Nov 14 15:59 /lib/libc.2
-r--r--r-- 1 bin bin 2531264 Nov 14 15:59 /lib/libc.a
lrwxr-xr-x 1 root root 15 Feb 19 09:12 /lib/libc.sl ->
/usr/l
ib/libc.2
lrwxr-xr-x 1 root root 8 Feb 19 09:12 /usr/lib/libc.0 ->
../l
ibc.1
-r-xr-xr-x 1 bin bin 1867776 Dec 6 2001 /usr/lib/libc.1
-r-xr-xr-x 1 bin bin 1806336 Nov 14 15:59 /usr/lib/libc.2
-r--r--r-- 1 bin bin 2531264 Nov 14 15:59 /usr/lib/libc.a
lrwxr-xr-x 1 root root 15 Feb 19 09:12
/usr/lib/libc.sl -> /u
sr/lib/libc.2
Configure command: ./configure '--prefix=/usr/local/mysql'
'--with-comment=Offic
ial MySQL binary' '--with-extra-charsets=complex' '--with-server-suffix='
'--ena
ble-thread-safe-client' '--enable-local-infile' '--disable-shared'
'--without-in
nodb' 'CC=cc' 'CFLAGS=+DD64' 'CXXFLAGS=+DD64' 'CXX=aCC'
Perl: This is perl, version 5.005_02 built for PA-RISC1.1
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail bugs-thread13862@lists.mysql.com
To unsubscribe, e-mail