February 2010 - discuss - lists.mariadb.org

[Maria-discuss] Why isn't SO_SNDTIMEO used?
by MARK CALLAGHAN 21 Mar '10

21 Mar '10

I describe how read/write is done for sockets in mysqld. http://www.facebook.com/note.php?note_id=122655300932 Can someone explain the history of this code? -- Mark Callaghan mdcallag(a)gmail.com

4 7

[Maria-discuss] Maria on Solaris X86
by Jim Grill 18 Mar '10

18 Mar '10

Hello, I’m having trouble getting MariaDB 5.1.42 working on Solaris 10x86. I’ve tried both the Binary package (mariadb-5.1.42-solaris11-i386) and building from source (mariadb-5.1.42). I don't know if it's something in the binary package or source code, something goofy on my system, or something goofy with how I'm building it. I'm assuming the latter, but thought I might bring it up anyway just in case it might help others running Solaris. :-) I can’t get the binary dist to startup. Here’s the error log from the binary dist (note the hostname missing from the error log name)… $ cat data/.err 100212 09:54:33 mysqld_safe Starting mysqld daemon with databases from /data01/mydata/mariadb-bin-tst/data ld.so.1: mysqld: fatal: relocation error: file bin/mysqld: symbol strnlen: referenced symbol not found 100212 09:54:33 mysqld_safe mysqld from pid file /data01/mydata/mariadb-bin-tst/mysql.pid ended I’m using SunStudio 12.1 to build from source. Here’s my configure and make: export PATH=/product01/sunstudio12.1/bin:${PATH} export LD_LIBRARY_PATH=/usr/lib:/usr/local/lib make distclean ASFLAGS="-m64" \ CC="cc-5.0" \ CFLAGS="-Xa -xstrconst -g -mt -D_FORTEC_ -m64" \ CXX="CC" \ CXXFLAGS="-noex -g -mt -D_FORTEC_ -m64" \ LIBS=-lmtmalloc \ ./configure \ --prefix=/product01/mysql/mariadb-5.1.42 \ --localstatedir=/product01/mysql/mariadb-5.1.42/data \ --libexecdir=/product01/mysql/mariadb-5.1.42/bin \ --with-extra-charsets=all \ --enable-thread-safe-client \ --enable-local-infile \ --with-zlib-dir=bundled \ --with-big-tables \ --with-readline \ --with-named-curses-libs=-lcurses \ --enable-assembler \ --enable-static \ --enable-shared /usr/sfw/bin/gmake [SNIP] gmake[1]: Entering directory `/home/mysql/jgrill/mariadb-5.1.42/dbug' source='dbug.c' object='dbug.o' libtool=no \ DEPDIR=.deps depmode=none /bin/bash ../depcomp \ cc-5.0 -DHAVE_CONFIG_H -I. -I. -I../include -I../include -I../include -Xa -xstrconst -g -mt -D_FORTEC_ -m64 -DHAVE_RWLOCK_T -DUNIV_SOLARIS -c dbug.c source='sanity.c' object='sanity.o' libtool=no \ DEPDIR=.deps depmode=none /bin/bash ../depcomp \ cc-5.0 -DHAVE_CONFIG_H -I. -I. -I../include -I../include -I../include -Xa -xstrconst -g -mt -D_FORTEC_ -m64 -DHAVE_RWLOCK_T -DUNIV_SOLARIS -c sanity.c rm -f libdbug.a ar cru libdbug.a dbug.o sanity.o ranlib libdbug.a source='my_main.c' object='my_main.o' libtool=no \ DEPDIR=.deps depmode=none /bin/bash ../depcomp \ cc-5.0 -DHAVE_CONFIG_H -I. -I. -I../include -I../include -I../include -Xa -xstrconst -g -mt -D_FORTEC_ -m64 -DHAVE_RWLOCK_T -DUNIV_SOLARIS -c my_main.c source='factorial.c' object='factorial.o' libtool=no \ DEPDIR=.deps depmode=none /bin/bash ../depcomp \ cc-5.0 -DHAVE_CONFIG_H -I. -I. -I../include -I../include -I../include -Xa -xstrconst -g -mt -D_FORTEC_ -m64 -DHAVE_RWLOCK_T -DUNIV_SOLARIS -c factorial.c /bin/bash ../libtool --preserve-dup-deps --tag=CC --mode=link cc-5.0 -Xa -xstrconst -g -mt -D_FORTEC_ -m64 -DHAVE_RWLOCK_T -DUNIV_SOLARIS -o factorial my_main.o factorial.o libdbug.a ../mysys/libmysys.a ../strings/libmystrings.a -lpthread -lthread -lposix4 -lsocket -lnsl -lm -lmtmalloc -lpthread -lthread libtool: link: cc-5.0 -Xa -xstrconst -g -mt -D_FORTEC_ -m64 -DHAVE_RWLOCK_T -DUNIV_SOLARIS -o factorial my_main.o factorial.o libdbug.a ../mysys/libmysys.a ../strings/libmystrings.a -lpthread -lthread -lposix4 -lsocket -lnsl -lm -lmtmalloc -lpthread -lthread -mt ld: warning: file libdbug.a ignored: unable to locate archive symbol table ld: warning: file ../mysys/libmysys.a ignored: unable to locate archive symbol table ld: warning: file ../strings/libmystrings.a ignored: unable to locate archive symbol table Undefined first referenced symbol in file my_thread_global_init my_main.o ld: fatal: Symbol referencing errors. No output written to factorial gmake[1]: *** [factorial] Error 1 gmake[1]: Leaving directory `/home/mysql/jgrill/mariadb-5.1.42/dbug' gmake: *** [all-recursive] Error 1 Here's my OS release information: # cat /etc/release Solaris 10 10/09 s10x_u8wos_08a X86 Copyright 2009 Sun Microsystems, Inc. All Rights Reserved. Use is subject to license terms. Assembled 16 September 2009 Thanks for taking the time to read this far. :-) Any help would be greatly appreciated. I've tried everything I can think of and have spent many hours doing so. I'm pretty excited to try out XtraDB, PBXT, and, of course, MariaDB. -- - Jim Grill

2 2

[Maria-discuss] askmonty.org moving to a new server this Thursday (25 Feb)
by Daniel Bartholomew 25 Feb '10

25 Feb '10

All, I'm sending this to both Maria Developers and Maria Discuss to make sure it gets to everyone, sorry for any duplicates. Just a heads up for everyone: I will be moving the askmonty.org website from its current home to a new server this Thursday, 25 Feb. If all goes according to plan, the website will remain up during the move but will be read-only during the actual switch. askmonty.org is the only domain/website that will be impacted by this move, websites on any other domain (such as buildbot.askmonty.org) are not part of this move and will continue to function normally. I will send a notice out on Thursday when I start the process, and a final one once the move is complete and I've tested that things are working properly. Thanks! -- Daniel Bartholomew Monty Program - http://askmonty.org

3 4

[Maria-discuss] MariaDB 5.1.42 has been released
by Colin Charles 18 Feb '10

18 Feb '10

Dear MariaDB users, MariaDB 5.1.42, a new branch of the MySQL database which includes all major open source storage engines, myriad bug fixes, and many community patches, has been released. We are very proud to have made our first final release, and we encourage you to test it out and use it on your systems. For an overview of what's new in MariaDB 5.1.42, please see: http://askmonty.org/wiki/index.php/Manual:MariaDB_5.1.42_Release_Notes For information on installing MariaDB 5.1.42 on new servers or upgrading to MariaDB 5.1.42 from previous releases, please see: http://askmonty.org/wiki/index.php/Manual:Installation MariaDB is available in source and binary form for a variety of platforms and is available from the download pages at: http://askmonty.org/wiki/index.php/MariaDB:Download:MariaDB_5.1.42 It is also our pleasure to announce that we have a partnership with Webyog to offer their tools for trial and at a discounted rate if purchased within 30 days. Find out more at: http://askmonty.org/downloads/links/webyog http://askmonty.org/wiki/index.php/MariaDB:Download#Software_Partner_Downlo… We welcome and appreciate your feedback, bug reports, bug fixes, patches, and participation on our mailing list. Find out more at: http://askmonty.org/wiki/index.php/MariaDB#How_can_I_participate_in_the_dev… Enjoy! -- Colin Charles, http://bytebot.net/blog/ "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

3 4

[Maria-discuss] Josh Berkus on community
by Kurt von Finck 16 Feb '10

16 Feb '10

Nice set of points on bad community management raised by Josh Berkus. http://lwn.net/SubscriberLink/370157/31a2534da9d465d3/ Do you disagree with any? Are there any things you would add? Do you think our projects suffer from any of these problems, and what constructive criticism do you have? Also, is there stuff you'd like to see the Maria community do? I think these points are a good jumping-off point to make sure we do things right. -- ./k kurt von finck http://www.mneptok.com public key: keyserver.ubuntu.com key id: 5229D26A fingerprint: 127A A484 ADBF A5AD E7FB 8CD2 8913 18F4 5229 D26A Music is the space between the notes. - Debussy

5 4

[Maria-discuss] virtual columns
by Federico Razzoli 05 Feb '10

05 Feb '10

I've read that MariaDB 5.2 will support virtual columns and I've read the virtual columns' specifications: http://forge.mysql.com/wiki/MySQL_virtual_columns_ref_manual I think there is a problem in that document. In CREATE TABLE and in ALTER TABLE commands you can create a virtual column. The syntax allows to specify that the column is STORED, if you wish. But it does not allow to specify that it's NOT STORED. This causes a little problem: one can not switch a STORED column to NOT STORED - one must to DROP and re-ADD the column. Also, I have a question: will virtual columns be able to use UDF's? Cheers, Federico

2 2

[Maria-discuss] FYI: askmonty.org/buildbot is moving to buildbot.askmonty.org/buildbot
by Daniel Bartholomew 04 Feb '10

04 Feb '10

All, This is an FYI for everyone that uses our buildbot web interface: Due to an upcoming server move I am in the process of moving our buildbot web interface from http://askmonty.org/buildbot to http://buildbot.askmonty.org/buildbot Both of the above currently work (and point at the same data), but as of Friday 5 Feb 2010 at approx 09:00 US Eastern time, http://askmonty.org/buildbot will turn into a redirect. The redirect will handle all of your old bookmarks (i.e. they should still work), but I thought I should at least let everyone know so that you aren't surprised by the move. I've already updated all of the links I could find on the askmonty.org wiki. And if you are wondering why I kept the /buildbot subdirectory in place on the new subdomain, well, it was easier and safer to keep it in place, so I did. If you connect directly to http://buildbot.askmonty.org you will automatically be redirected to the /buildbot subdir. Thanks! -- Daniel Bartholomew Monty Program - http://askmonty.org

1 0