Repeated table corruption
All, We run mysql 3.23.58 on a Tru64 OSF 4.0F. There are 3 tables that are consitently corrupt; these tables are fixed using myisamchk and after a couple of hours they are corrupt again. The following are errors in mysql error log. /usr/local/mysql/bin/myisamchk: ISAM file /usr/local/mysql/data/duat_eng/REGISTRY_TABLE.MYI /usr/local/mysql/bin/myisamchk: error: Size of datafile is: 960 Should be: 10560 /usr/local/mysql/bin/myisamchk: error: record delete-link-chain corrupted /usr/local/mysql/bin/myisamchk: error: Found key at page 1024 that points to record outside datafile Thank you in advance for any help you may provide. -Teresa This is a PRIVATE message. If you ar not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL4.0.23 upgrade
Hello, I am trying to upgrade from MYSQL 3.23.58 to MYSQL 4.0.23 on a Tru64 alpha server. However, I am getting the error below at compile time. any ideas? Thanks in advance -teresa. Platform: Alpha Tru64 OSF 4.0F Configuration parameters: CC=cc -pthread \ CXX=cxx -pthread -O \ export CC CFLAGS CXX CXXFLAGS\ ./configure \ --with-named-thread-libs=-lpthread -lmach -lexc -lc\ --prefix=/usr/local/mysql-4.0.23 \ --enable-assembler \ --with-docs\ --enable-large-files \ --with-mysqld-ldflags=-all-static Error: cations -o .libs/libmysqlclient.so.12.0.0 /bin/ld: -pthread: Unknown flag /bin/ld: Usage: /bin/ld [options] file [...] gnumake[2]: *** [libmysqlclient.la] Error 1 gnumake[2]: Leaving directory `/data/users/builder/untar/mysql-4.0.23 a/libmysql' gnumake[1]: *** [all-recursive] Error 1 gnumake[1]: Leaving directory `/data/users/builder/untar/mysql-4.0.23a' gnumake: *** [all] Error 2 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql_fetch_lengths()
We were running mysql 3.22.30 on an Tru 64 Alpha server OSF 4.0F. We recently upgraded to mysql 3.23.58 on the same server. In the code fragment below, there is a memory leak at line 8 because mysql_fetch_lenghts returns an array of unsigned long integers representing the size of each column. So, has the retun value of mysql_fetch_lengths() been the same for mysql 3.22.30 and 3.23.58? Thank you , -Teresa -- 1. unsigned long *lengths; 2. unsigned int num_fields; 3. unsigned int i; 4. MYSQL_RES *result=NULL; 5. row = mysql_fetch_row(result); 6. if (row) 7. { 8. len = malloc(sizeof(unsigned long) * mysql_num_fields(result)); 9. num_fields = mysql_num_fields(result); 10.lengths = mysql_fetch_lengths(result); 11.for(i = 0; i num_fields; i++) 12.{ 13. printf(Column %u is %lu bytes in length.\n, i, lengths[i]); 14.} 15.free(len) 16.} -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql_fetch_lengths()
Thank you for the response. I completely agree with your response. The reason why I asked this question is because I remember seeing len(unsigned long *lengths;) dynamically allocated in the MYSQL manual some time ago(when I was running mysql 3.23.30). So, I wonder if there was a change in the return value of mysql_fetch_lenghts() in mysql 3.23.58. Otherwise, I made a mistake in dynamically allocating memory for len. I must have misunderstood. Thank you. -Teresa This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. Dan Nelson dnelson To: Teresa A Narvaez/FED/[EMAIL PROTECTED] @allantgroup.com cc: mysql@lists.mysql.com Subject: Re: mysql_fetch_lengths() 12/23/2004 12:19 PM In the last episode (Dec 23), Teresa A Narvaez said: We were running mysql 3.22.30 on an Tru 64 Alpha server OSF 4.0F. We recently upgraded to mysql 3.23.58 on the same server. In the code fragment below, there is a memory leak at line 8 because mysql_fetch_lenghts returns an array of unsigned long integers representing the size of each column. So, has the retun value of mysql_fetch_lengths() been the same for mysql 3.22.30 and 3.23.58? 1. unsigned long *lengths; 2. unsigned int num_fields; 3. unsigned int i; 4. MYSQL_RES *result=NULL; 5. row = mysql_fetch_row(result); 6. if (row) 7. { 8. len = malloc(sizeof(unsigned long) * mysql_num_fields(result)); 9. num_fields = mysql_num_fields(result); 10.lengths = mysql_fetch_lengths(result); 11.for(i = 0; i num_fields; i++) 12.{ 13. printf(Column %u is %lu bytes in length.\n, i, lengths[i]); 14.} 15.free(len) 16.} The memory allocated at line 8 is freed at line 15. In fact, it's never used at all. The array returned by mysql_fetch_lengths is an internal array that is freed by mysql_free_result(); you don't need to allocate it or free it. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql_fetch_lengths()
Thank you very much for your help! -Teresa This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. Dan Nelson dnelson To: Teresa A Narvaez/FED/[EMAIL PROTECTED] @allantgroup.com cc: mysql@lists.mysql.com Subject: Re: mysql_fetch_lengths() 12/23/2004 02:14 PM In the last episode (Dec 23), Teresa A Narvaez said: Dan wrote: In the last episode (Dec 23), Teresa A Narvaez said: We were running mysql 3.22.30 on an Tru 64 Alpha server OSF 4.0F. We recently upgraded to mysql 3.23.58 on the same server. In the code fragment below, there is a memory leak at line 8 because mysql_fetch_lenghts returns an array of unsigned long integers representing the size of each column. So, has the retun value of mysql_fetch_lengths() been the same for mysql 3.22.30 and 3.23.58? The memory allocated at line 8 is freed at line 15. In fact, it's never used at all. The array returned by mysql_fetch_lengths is an internal array that is freed by mysql_free_result(); you don't need to allocate it or free it. Thank you for the response. I completely agree with your response. The reason why I asked this question is because I remember seeing len(unsigned long *lengths;) dynamically allocated in the MYSQL manual some time ago(when I was running mysql 3.23.30). So, I wonder if there was a change in the return value of mysql_fetch_lenghts() in mysql 3.23.58. Otherwise, I made a mistake in dynamically allocating memory for len. I must have misunderstood. I don't think it has ever required the user to malloc or free the lengths array. I checked back as far as 3.20.32, and the mysql_fetch_lengths function is identical to 3.23.58, except for the change from int* to long*. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL 3.23.58 directory structure
Hello, I am upgrading from MYSQL 3.22.30 to 3.23.58 on a Tru64 Alpha 4.0F. The set of commands below are used to create a Make file. My problem is that I want include files to be placed under /usr/local/mysql/include; However, with the configuration below, they are placed under /usr/local/mysql/include/mysql. How could I change the configuration parameters so all include, lib and data are placed under /usr/local/mysql/include, /usr/local/mysql/lib and /usr/local/mysql/data respectively? CC=cc -pthread\ CXX=cxx -pthread -O\ export CC CFLAGS CXX CXXFLAGS\ ./configure \ --prefix=/usr/local/mysql-3.23.58 \ --with-low-memory \ --enable-large-files \ --enable-shared=yes \ --with-named-thread-libs=-lpthread -lmach -lexc -lc\ --localstatedir=/usr/local/mysql-3.23.58/data \ --libdir=/usr/local/mysql-3.23.58/lib \ --with-docs\ --includedir=/usr/local/mysql-3.23.58/include Thank you for any help, -Teresa This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL 3.22.30 data missing
Hello, We run MYSQL 3.22.30 on a TRU64 alpha server(4.0F). Our scripts found corruption on one of our tables. The script tried to automatically clear the corruption but failed. Then we cleared the corruption by manually running isamchk -r.Everything seemed okay until we tried to pull data for certain hours. The select count(*) stattement displays 830 records. However when I execute select * it only displays 150 records. Thanks for any help, -Teresa This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Install Question : DB does not start.
You may find the location of the log files by executing: % mysqladmin variables | grep datadir Under this directory you will find a fle named hostname.err. That file will give some info on what's happenning. Hope this helps you, -Teresa This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. Aleksei Wolff aleksei_wolff To: [EMAIL PROTECTED] @yahoo.com cc: Subject: Install Question : DB does not start. 12/22/2003 09:25 PM If there is a better place to post this question please advise. I am following the instructions from mysql.com. to start the server I type the following command as 'root' ./bin/safe_mysqld --user=mysql The following error displays: Starting mysqld daemon with databases from /usr/local/mysql/data 031222 21:48:50 mysql ended I cant find a log file or anything that can help me pinpoint the issue. Any help is appreciated. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]