Dates after version upgrade
After I upgraded from 4.0.16 to 4.1.11 I have found that the date fields are being pre-formatted and are causing problems to back-ground programs. Is there a configuration or session setting that will force the date formatting to the standard in 4.0 and earlier to correct the program issues? Thanks, http://www.mtsu.edu/~itd Information Technology Division Jeff Hinds, ocp Database Specialist Middle Tennessee State University 001 Cope Administration Building Murfreesboro, TN 37132 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] tel: fax: (615) 898-5719 (615) 898-5720
Build problem
I am in the process of building MySQL version 4.1.11 as an upgrade from 4.0.16. This build is so we will be ready for 5.0 once out of beta. We are using the source distribution and when executing the make step I get the following error. Making all in mysql-test /usr/bin/rm -f mysql-test-run mysql-test-run-t /usr/bin/sed \ -e 's!@''testdir''@!/usr/local2/jhtest/mysql/mysql-test!g' \ -e 's!@''bindir''@!/usr/local2/jhtest/mysql/bin!g' \ -e 's!@''scriptdir''@!/usr/local2/jhtest/mysql/bin!g' \ -e 's!@''prefix''@!/usr/local2/jhtest/mysql!g' \ -e 's!@''datadir''@!/usr/local2/jhtest/mysql/share!g' \ -e 's!@''localstatedir''@!/usr/local2/jhtest/mysql/var!g' \ -e 's!@''libexecdir''@!/usr/local2/jhtest/mysql/libexec!g' \ -e 's!@''PERL''@!/opt/perl/bin/perl!' \ -e 's!@''VERSION''@!4.1.11!' \ -e 's!@''MYSQL_TCP_PORT''@!3307!' \ -e 's!@''MYSQL_BASE_VERSION''@!4.1!' \ -e 's!@''MYSQL_UNIX_ADDR''@!/tmp/jhmysql.sock!' \ -e 's!@''MYSQL_TCP_PORT''@!3307!' \ -e 's!@''MYSQL_NO_DASH_VERSION''@!4.1.11!' \ -e 's!@''MYSQL_SERVER_SUFFIX''@!-MTSU-MAX_TEST!' \ -e 's!@''USE_NDBCLUSTER''@!\\!g' \ mysql-test-run.sh mysql-test-run-t /usr/bin/chmod +x mysql-test-run-t /usr/bin/mv mysql-test-run-t mysql-test-run /usr/bin/rm -f install_test_db install_test_db-t /usr/bin/sed \ -e 's!@''testdir''@!/usr/local2/jhtest/mysql/mysql-test!g' \ -e 's!@''bindir''@!/usr/local2/jhtest/mysql/bin!g' \ -e 's!@''scriptdir''@!/usr/local2/jhtest/mysql/bin!g' \ -e 's!@''prefix''@!/usr/local2/jhtest/mysql!g' \ -e 's!@''datadir''@!/usr/local2/jhtest/mysql/share!g' \ -e 's!@''localstatedir''@!/usr/local2/jhtest/mysql/var!g' \ -e 's!@''libexecdir''@!/usr/local2/jhtest/mysql/libexec!g' \ -e 's!@''PERL''@!/opt/perl/bin/perl!' \ -e 's!@''VERSION''@!4.1.11!' \ -e 's!@''MYSQL_TCP_PORT''@!3307!' \ -e 's!@''MYSQL_BASE_VERSION''@!4.1!' \ -e 's!@''MYSQL_UNIX_ADDR''@!/tmp/jhmysql.sock!' \ -e 's!@''MYSQL_TCP_PORT''@!3307!' \ -e 's!@''MYSQL_NO_DASH_VERSION''@!4.1.11!' \ -e 's!@''MYSQL_SERVER_SUFFIX''@!-MTSU-MAX_TEST!' \ -e 's!@''USE_NDBCLUSTER''@!\\!g' \ install_test_db.sh install_test_db-t /usr/bin/chmod +x install_test_db-t /usr/bin/mv install_test_db-t install_test_db Make: Don't know how to make std_data/client-key.pem. Stop. *** Error exit code 1 Stop. *** Error exit code 1 Stop. *** Error exit code 1 Stop. $ Just for the fun of things, I executed the command make test and the process completed. However, I can not get around this point. Any suggestions on how to correct the issue and continue. Thanks, http://www.mtsu.edu/~itd Information Technology Division Jeff Hinds, ocp Database Specialist Middle Tennessee State University 001 Cope Administration Building Murfreesboro, TN 37132 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] tel: fax: (615) 898-5719 (615) 898-5720
Problem with 3.23.54a build
I am attempting to build the latest version of MySQL on a HP-UX 11.00 system but I have run into on problem over and over again. Once the service is built, I run the make test command and the process fails at the rpl01 step and the test ends with an error code. I go ahead and test the installed software and I keep receiving the following message when I issued the show variables command: ERROR 2013: Lost connection to MySQL server during query In my host.err log file I have the following information: /usr/local2/jhtest/mysql/libexec/mysqld: ready for connections 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=8384512 record_buffer=126976 sort_buffer=524280 max_used_connections=1 max_connections=300 threads_connected=2 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 198985 K bytes of memory Hope that's ok, if not, decrease some variables in the equation 021223 11:22:24 mysqld restarted Has anyone encounteded this and been able to correct the problem and if so, How? Thank You -- Jeff Hinds - Database Specialist Middle Tennessee State University Email: [EMAIL PROTECTED] Information Technology DivisionPhone: (615) 898-5719 Cope Admin. Building - Room 001 Fax: (615) 898-5720 Murfreesboro, Tn 37129 - 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
RE: Error on new connection socket: Invalid argument
-Original Message- From: Cindy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 5:49 PM To: MySQL List Subject: Re: Error on new connection socket: Invalid argument Jeff Hinds writes: I have an application that is developed in perl using dbi and mysql that has been working well for some time now. However, I have received emails and phone calls asking if the server is down. I look at the service and the system is up however, the mysql error log reports the following message: Error on new connection socket: Invalid argument Once I stop and restart the mysqld process all is well again. But I need to prevent the error from happening over and over. I could not find any mention of the message above in the documentation. Has anyone run into this problem and found out what is causing it, and how to correct it? Sometimes the file /tmp/mysql.sock is removed by a cron job clearing out /tmp. In which case you may want to redefine socket=/usr/local/mysql/mysql.sock or whatever to avoid that problem. Okay . . . This has been done. The mysql.sock file is in a dedicated area for MySQL on our system. We have been looking for problems with applications that may be terminating before close any connection it may have open. A short term fix of increasing the Max Connections has been considered, but we want to make this a final option. What else could be causing this problem? Thanks in advance. Jeff Hinds - 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
Error on new connection socket: Invalid argument
I have an application that is developed in perl using dbi and mysql that has been working well for some time now. However, I have received emails and phone calls asking if the server is down. I look at the service and the system is up however, the mysql error log reports the following message: Error on new connection socket: Invalid argument Once I stop and restart the mysqld process all is well again. But I need to prevent the error from happening over and over. I could not find any mention of the message above in the documentation. Has anyone run into this problem and found out what is causing it, and how to correct it? Thank You in advance Jeff Hinds - 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
Performance Benchmarks
Has anyone used MySQL with perl to create a web interface with a database that contains 100 or more tables that have 200,000 to 500,000 rows of data each? I am interested to know if any performance issues have been encountered and if any solutions were found. We are looking to create a new service that will display information only. The data will be loaded from non-web base applications. I'm concerned about the speed performance of selects and joins to create lookup type web applications and data sets of this size. Thank You Jeff Hinds - 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
Build problems with BerkeleyDB
While attempting to build MySQL from the source distribution, I have received the following message from the configuration utility. checking for BerkeleyDB... supplied configure: error: didn't find valid BerkeleyDB: invalid version 3.3.11 (must be version 3.2.3h or ) We want the BerkeleyDB support to be added to the MySQL service however, we do not want to support multiple versions of the product on the system. We need the 3.3.11 version for other products. However, the MySQL is having problems using this version. This version was downloaded from the sleepycat site for use with email applications. What do I need to do to use this version with MySQL? Thank You Jeff Hinds ~~~ _ # Jeff D. Hinds - Database Specialist# _ / )# Office of Information Technology #( \ _ / / # 001 Cope Administration Building # \ \ _ ( ( () # _ Murfreesboro, TN 37129 _ # () ) ) ( \ \ \)# / ) ( \ #(/ / / ) ( \ \ \ \_/ / Phone: (615) 898-5719 \ \_/ / / / ) \ / Fax: (615) 898-5720\ / \ /E-Mail: [EMAIL PROTECTED]\ / \ /~\ / [[[|]]] == MIDDLE TENNESSEE STATE UNIVERSITY == [[[|]]] [[[|]]]~[[[|]]] - 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
Building MySQL on HPUX with InnoBase support
I have had problems building the MySQL database server when I include support of InnoBase DB files. During the build process I must use the HP/ANSI compilers. This causes an error while building the mach0data.c file in the mach directory in the InnoBase directory structure. Has anyone on HP-UX 11.0.0 been able to build the MySQL server with both Berkeley DB and InnoBase DB support using the HP/ANSI compilers. If so, please give me some direction. Thank You Jeff Hinds ~~~ _ # Jeff D. Hinds - Database Specialist# _ / )# Office of Information Technology #( \ _ / / # 001 Cope Administration Building # \ \ _ ( ( () # _ Murfreesboro, TN 37129 _ # () ) ) ( \ \ \)# / ) ( \ #(/ / / ) ( \ \ \ \_/ / Phone: (615) 898-5719 \ \_/ / / / ) \ / Fax: (615) 898-5720\ / \ /E-Mail: [EMAIL PROTECTED]\ / \ /~\ / [[[|]]] == MIDDLE TENNESSEE STATE UNIVERSITY == [[[|]]] [[[|]]]~[[[|]]] - 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