>Description: When connecting to mysql from a java client the mysql process is restarted. Connecting from the "mysql" client is no problem. The machine is an HP rp2470 with 2*CPU and 2GB memory.
Note that I don't have gcc installed on the machine, is this a requirement? >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: <code/input/activities to reproduce the problem (multiple lines)> >Fix: <how to correct or work around the problem, if known (multiple lines)> >Submitter-Id: <submitter ID> >Originator: >Organization: Incomit >MySQL support: [none | licence | email support | extended email support ] License serial number: 27744-27753 >Synopsis: >Severity: critical >Priority: >Category: mysql >Class: <[ sw-bug | doc-bug | change-request | support ] (one line)> >Release: mysql-3.23.55 (Official MySQL binary) >Environment: <machine, os, target, libraries (multiple lines)> 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php