From owner-freebsd-questions@FreeBSD.ORG Wed Feb 1 06:46:45 2006 Return-Path: X-Original-To: freebsd-questions@FreeBSD.ORG Delivered-To: freebsd-questions@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id EFD9516A420 for ; Wed, 1 Feb 2006 06:46:45 +0000 (GMT) (envelope-from mcrogerm@stjohn.ac.th) Received: from stjohn.ac.th (ns.stjohn.ac.th [202.21.144.1]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1E36E43D46 for ; Wed, 1 Feb 2006 06:46:42 +0000 (GMT) (envelope-from mcrogerm@stjohn.ac.th) Received: from tulip.stjohn.ac.th [203.151.134.104] by stjohn.ac.th with ESMTP (SMTPD-8.21) id A950037C; Wed, 01 Feb 2006 13:46:40 +0700 Message-Id: <5.2.0.9.0.20060201133247.00aae860@127.0.0.1> X-Sender: 2-server.international.stjohn.ac.th:mcrogerm@127.0.0.1 X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Wed, 01 Feb 2006 13:47:30 +0700 To: freebsd-questions@FreeBSD.ORG From: Roger Merritt Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Cc: Subject: Unable to compile mysql50-server X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 01 Feb 2006 06:46:46 -0000 I've been having some strange problems trying to upgrade my mysql-server on a Freebsd6.0-STABLE machine. When compiling mysql* I have a problem with the machine running out of swap space and stalling in some kind of infinite loop. I solved it for mysql50-client by going to the /usr/ports/databases/mysql50-client directory and running "make", rebooting to get out of the loop, and running make again. The second time it ran to completion and I was able to run "make install" without further problem. When I tried the same strategy with mysql50-server, after rebooting, make stopped on an error message: >c++ -DDBUG_OFF -O -pipe -fconserve-space -O -pipe -felide-constructors >-fno-rtti -fno-exceptions -fno-implicit-templates -fno-exceptions >-fno-rtti -DMYSQLD_NET_RETRY_COUNT=1000000 -o mysqld sql_lex.o >sql_handler.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o >item_strfunc.o item_timefunc.o thr_malloc.o item_create.o item_subselect.o >item_row.o item_geofunc.o field.o strfunc.o key.o sql_class.o sql_list.o >net_serv.o protocol.o sql_state.o lock.o my_lock.o sql_string.o >sql_manager.o sql_map.o mysqld.o password.o hash_filo.o hostname.o >set_var.o sql_parse.o sql_yacc.o sql_base.o table.o sql_select.o >sql_insert.o sql_prepare.o sql_error.o sql_update.o sql_delete.o uniques.o >sql_do.o procedure.o item_uniq.o sql_test.o log.o log_event.o init.o >derror.o sql_acl.o unireg.o des_key_file.o discover.o time.o opt_range.o >opt_sum.o records.o filesort.o handler.o ha_heap.o ha_myisam.o >ha_myisammrg.o ha_berkeley.o ha_innodb.o ha_ndbcluster.o sql_db.o >sql_table.o sql_rename.o sql_crypt.o sql_load.o mf_iocache.o field_conv.o >sql_show.o sql_udf.o sql_analyse.o sql_cache.o slave.o sql_repl.o >sql_union.o sql_derived.o client.o sql_client.o mini_client_errors.o >pack.o stacktrace.o repl_failsafe.o sql_olap.o sql_view.o gstream.o >spatial.o sql_help.o sql_cursor.o tztime.o my_time.o my_decimal.o >sp_head.o sp_pcontext.o sp_rcontext.o sp.o sp_cache.o parse_file.o >sql_trigger.o ha_example.o ha_archive.o ha_tina.o ha_blackhole.o >ha_federated.o -pthread >-pthread >-L/usr/ports/databases/mysql50-server/work/mysql-5.0.18/bdb/build_unix >-ldb ../innobase/usr/libusr.a ../innobase/srv/libsrv.a >../innobase/dict/libdict.a ../innobase/que/libque.a >../innobase/srv/libsrv.a ../innobase/ibuf/libibuf.a >../innobase/row/librow.a ../innobase/pars/libpars.a >../innobase/btr/libbtr.a ../innobase/trx/libtrx.a >../innobase/read/libread.a ../innobase/usr/libusr.a >../innobase/buf/libbuf.a ../innobase/ibuf/libibuf.a >../innobase/eval/libeval.a ../innobase/log/liblog.a >../innobase/fsp/libfsp.a ../innobase/fut/libfut.a ../innobase/fil/libfil.a >../innobase/lock/liblock.a ../innobase/mtr/libmtr.a >../innobase/page/libpage.a ../innobase/rem/librem.a >../innobase/thr/libthr.a ../innobase/sync/libsync.a >../innobase/data/libdata.a ../innobase/mach/libmach.a >../innobase/ha/libha.a ../innobase/dyn/libdyn.a ../innobase/mem/libmem.a >../innobase/sync/libsync.a ../innobase/ut/libut.a ../innobase/os/libos.a >../innobase/ut/libut.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a >../heap/libheap.a ../vio/libvio.a ../mysys/libmysys.a ../dbug/libdbug.a >../regex/libregex.a ../strings/libmystrings.a -lz -lwrap -pthread -pthread >-lcrypt -lm -pthread -pthread >sp_rcontext.o: file not recognized: File truncated >*** Error code 1 > >Stop in /usr/ports/databases/mysql50-server/work/mysql-5.0.18/sql. >*** Error code 1 > >Stop in /usr/ports/databases/mysql50-server/work/mysql-5.0.18/sql. >*** Error code 1 > >Stop in /usr/ports/databases/mysql50-server/work/mysql-5.0.18/sql. >*** Error code 1 > >Stop in /usr/ports/databases/mysql50-server/work/mysql-5.0.18. >*** Error code 1 The first time this happened I deleted mysql-5.0.18.tar.gz from /usr/ports/distfiles and fetched the port again, but got exactly the same message in exactly the same place. I don't see how the file can be damaged, since the MD5 signature checks. It must not be a common problem, because I haven't seen a lot of questions here or in the ports list. I'm not sure what the problem is. After the first few times of running out of swap space I enlarged my swap file from 128MB to 512MB. I don't really see why that's not enough swap space, but I don't think that's the real problem. Incidentally, I was getting the same problem with mysql41, but I wanted to upgrade to 5.0 anyway for the new features. Luckily, this is not a production maching, but it does act as the internet gateway for half a dozen other machines, so I would not want it down for long periods. Any suggestions would be appreciated. -- Roger