Re: Segmentation fault - Redhat Linux 64 Bit
Hi, I rebooted my RHEL and the segmentation fault is gone. regards. On Tue, Sep 28, 2010 at 1:58 PM, Sharath Babu Dodda sharath.do...@gmail.com wrote: Hi, Any more solutions on this please. Thanks, Sharath. On Mon, Sep 27, 2010 at 6:17 PM, Sharath Babu Dodda sharath.do...@gmail.com wrote: Hi there, I installed Apache, MySQL and PHP on Redhat Linux 64 bit. However, when I try to invoke MySQL, I'm getting the Segmentation fault error and I'm not able to see the mysql prompt. Begin of problem: ### [...@xyz123 bin]$ sudo ./mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.0.91 Source distribution Segmentation fault ### End of problem: Could you please suggest a solution for this? Thanks in advace for your help. regards, Sharath
Re: Segmentation fault - Redhat Linux 64 Bit
Hi, Any more solutions on this please. Thanks, Sharath. On Mon, Sep 27, 2010 at 6:17 PM, Sharath Babu Dodda sharath.do...@gmail.com wrote: Hi there, I installed Apache, MySQL and PHP on Redhat Linux 64 bit. However, when I try to invoke MySQL, I'm getting the Segmentation fault error and I'm not able to see the mysql prompt. Begin of problem: ### [...@xyz123 bin]$ sudo ./mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.0.91 Source distribution Segmentation fault ### End of problem: Could you please suggest a solution for this? Thanks in advace for your help. regards, Sharath -- I have come into the world as a light, so that *NO ONE* who believes in me should stay in darkness. (John 12:46)
Segmentation fault - Redhat Linux 64 Bit
This email may contain confidential information the use of which by an unintended recipient is unauthorized. For details please go to http://www.scotiabank.com/email_disclaimer/email_english.html Cette transmission peut contenir de l'information confidentielle et son utilisation par toute personne autre que la personne à laquelle cette transmission est destinée est interdite. Pour plus de détails, veuillez vous diriger vers http://www.scotiabank.com/email_disclaimer/email_francais.html Este correo electrónico puede contener información confidencial cuyo uso por parte de personas distintas de los destinatarios del mismo está prohibido. Para más detalles, por favor dirigirse a http://www.scotiabank.com/email_disclaimer/email_espanol.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Segmentation fault - Redhat Linux 64 Bit
Hi there, I installed Apache, MySQL and PHP on Redhat Linux 64 bit. However, when I try to invoke MySQL, I'm getting the Segmentation fault error and I'm not able to see the mysql prompt. Begin of problem: ### [...@xyz123 bin]$ sudo ./mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.0.91 Source distribution Segmentation fault ### End of problem: Could you please suggest a solution for this? Thanks in advace for your help. regards, Sharath
RE: Segmentation fault - Redhat Linux 64 Bit
Either 1. Use strace to find out where it's getting a segfault, or 2. Use gdb and get the backtrace where crashes. -Original Message- From: Sharath Babu Dodda [mailto:sharath.do...@gmail.com] Sent: Monday, September 27, 2010 3:17 PM To: mysql@lists.mysql.com Subject: Segmentation fault - Redhat Linux 64 Bit Hi there, I installed Apache, MySQL and PHP on Redhat Linux 64 bit. However, when I try to invoke MySQL, I'm getting the Segmentation fault error and I'm not able to see the mysql prompt. Begin of problem: ### [...@xyz123 bin]$ sudo ./mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.0.91 Source distribution Segmentation fault ### End of problem: Could you please suggest a solution for this? Thanks in advace for your help. regards, Sharath This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you are notified that reviewing, disseminating, disclosing, copying or distributing this e-mail is strictly prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any loss or damage caused by viruses or errors or omissions in the contents of this message, which arise as a result of e-mail transmission. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94089, USA, FriendFinder.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysql_real_query causing segmentation fault for binary select
I am trying top run these 2 SELECT queries using mysql_real_query in MySQL-C.
The only difference between them is changing the first hex value from 41 to 01.
It if is 41, the query runs fine. When I change it to 01 I get the following
segmentation fault.
segfault at 0 ip 00402be6 sp 7fff01e5bee0 error 4 in
apnsd[40+7000]
SELECT `id` FROM `apns`.`tblTokens` WHERE `token_id` =
0x01A161E6CEAC902311B2357792F6076A3CEA85FA9B0B071A77289FC450D7092E LIMIT 1
SELECT `id` FROM `apns`.`tblTokens` WHERE `token_id` =
0x41A161E6CEAC902311B2357792F6076A3CEA85FA9B0B071A77289FC450D7092E LIMIT 1
token_id is defines as: binary(32)
I also tried it a char(32) with the same results
Any insight on why this is happening?
code
/* Connect to database */
if (!mysql_real_connect(conn, db_host,
db_user, db_password, db_name, 0, NULL, 0)) {
/* log an error */
syslog(LOG_ERR,Unable to connect to DB. Error: %s,
mysql_error(conn));
mysql_close(conn);
/* Can't connect to DB... Bailing out */
return(ERROR);
}
if (mysql_real_query(conn, SELECT `id` FROM `apns`.`tblTokens` WHERE
`token_id` = 0x01A161E6CEAC902311B2357792F6076A3CEA85FA9B0B071A77289FC450D7092E
LIMIT 1, 129)) {
/* log an error */
syslog(LOG_ERR,Failed to SELECT, Error: %s,
mysql_error(conn));
syslog(LOG_ERR, Query: %s, query);
mysql_close(conn);
/* Failed to select from DB... Bailing out */
return(ERROR);
}
return(0);
/code
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MYSQL 5.1.35 Segmentation fault
Hi all, i am trying to install mysql 5.1.35 in my linux platform, i do it from source distribution, but there is a serious problem when i login it, the error message is bellow: *shell mysql -p -u root Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.1.35 Source distribution Segmentation fault* i can not get any helpfull message in the file:mysqld.log my configure command line is: ./configure --prefix=/export/data1/apps/local/mysql --bindir=/export/data1/apps/bin --sbindir=/export/data1/apps/sbin --sysconfdir=/export/data1/apps/etc/ --enable-local-infile --with-charset=utf8 --with-mysqld-user=mysql --with-named-curses-libs=/usr/lib64/libncursesw.so.5 my linux platform is: uname -m = x86_64 uname -r = 2.6.18-92.el5 uname -s = Linux uname -v = #1 SMP Tue Jun 10 18:51:06 EDT 2008 could anyone give some suggestions? thanks very much! -- Tianjing
Re: MYSQL 5.1.35 Segmentation fault
jing, Please modify your my.cnf file. 在 2009-7-16，下午2:56， TianJing 写道： Hi all, i am trying to install mysql 5.1.35 in my linux platform, i do it from source distribution, but there is a serious problem when i login it, the error message is bellow: *shell mysql -p -u root Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.1.35 Source distribution Segmentation fault* i can not get any helpfull message in the file:mysqld.log my configure command line is: ./configure --prefix=/export/data1/apps/local/mysql --bindir=/export/data1/apps/bin --sbindir=/export/data1/apps/sbin --sysconfdir=/export/data1/apps/etc/ --enable-local-infile --with-charset=utf8 --with-mysqld-user=mysql --with-named-curses-libs=/usr/lib64/libncursesw.so.5 my linux platform is: uname -m = x86_64 uname -r = 2.6.18-92.el5 uname -s = Linux uname -v = #1 SMP Tue Jun 10 18:51:06 EDT 2008 could anyone give some suggestions? thanks very much! -- Tianjing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MYSQL 5.1.35 Segmentation fault
thanks, my.cnf file is as follow: [client] #password = your_password port= 3306 socket = /export/data1/apps/local/mysql/mysql.sock # The MySQL server [mysqld] datadir=/export/data1/apps/local/mysql/data socket = /export/data1/apps/local/mysql/mysql.sock user=mysql [mysqld_safe] log-error=/export/data1/apps/local/mysql/logs/mysqld.log pid-file=/export/data1/apps/local/mysql/logs/mysqld.pid 2009/7/16 fire9 fire9di...@gmail.com jing, Please modify your my.cnf file. 在 2009-7-16，下午2:56， TianJing 写道： Hi all, i am trying to install mysql 5.1.35 in my linux platform, i do it from source distribution, but there is a serious problem when i login it, the error message is bellow: *shell mysql -p -u root Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.1.35 Source distribution Segmentation fault* i can not get any helpfull message in the file:mysqld.log my configure command line is: ./configure --prefix=/export/data1/apps/local/mysql --bindir=/export/data1/apps/bin --sbindir=/export/data1/apps/sbin --sysconfdir=/export/data1/apps/etc/ --enable-local-infile --with-charset=utf8 --with-mysqld-user=mysql --with-named-curses-libs=/usr/lib64/libncursesw.so.5 my linux platform is: uname -m = x86_64 uname -r = 2.6.18-92.el5 uname -s = Linux uname -v = #1 SMP Tue Jun 10 18:51:06 EDT 2008 could anyone give some suggestions? thanks very much! -- Tianjing -- Tianjing Bioinformatics Center, Beijing Genomics Institute,Shenzhen Tel:+86-755-25273851 MSN:tianjing...@hotmail.com msn%3atianjing...@hotmail.com
Re: MYSQL 5.1.35 Segmentation fault
Hi TianJing, all! TianJing wrote: Hi all, i am trying to install mysql 5.1.35 in my linux platform, i do it from source distribution, but there is a serious problem when i login it, the error message is bellow: *shell mysql -p -u root Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.1.35 Source distribution Segmentation fault* From your text, it seems mysql (the command line client) crashed. If it happens again, please type (as the next command) echo $? to get the exit code. With a segmentation fault, it should be either 11 or 139 (= 128 + 11). If it is anything above 128, you got a core file - please use your favorite debugger (on Linux, probably gdb) to get a stack backtrace and post it here. If it is anything below 128, especially 11, check man 7 signal whether it should have dumped a core. If so, but you didn't get one, then you have some setting that prevents core dumps - please correct that. i can not get any helpfull message in the file:mysqld.log Sure: The crash is happening with the client program, mysql, and not with the server, mysqld. my configure command line is: ./configure --prefix=/export/data1/apps/local/mysql --bindir=/export/data1/apps/bin --sbindir=/export/data1/apps/sbin --sysconfdir=/export/data1/apps/etc/ --enable-local-infile --with-charset=utf8 --with-mysqld-user=mysql --with-named-curses-libs=/usr/lib64/libncursesw.so.5 my linux platform is: uname -m = x86_64 uname -r = 2.6.18-92.el5 uname -s = Linux uname -v = #1 SMP Tue Jun 10 18:51:06 EDT 2008 could anyone give some suggestions? Not off-hand. I am somewhat surprised that you explicitly give a 64 bit curses library but do not give an option to build in 64 bit mode. Do you have CFLAGS and/or CXXFLAGS set in the environment? Also, those lines of the configure log that determine compiler flags might be interesting. As an alternative, publish those lines of your build log (from make) that show how mysql is linked, 10 lines before and 20 lines after that call. thanks very much! HTH, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysql_init segmentation fault
Hi, I am running an application that interfaces with MySQL from c++. When I try to run the application, I get a segmentation fault at the line where I call mysql_init. Here is part of the output from gdb #0 0x081a0e78 in elf_machine_rel.0 () at ../sysdeps/i386/dl-machine.h:333 #1 0x081a113a in elf_dynamic_do_rel.4 () at do-rel.h:100 #2 0x081a12db in _dl_relocate_object (l=0x821ec40, scope=0x821ed84, lazy=1, consider_profiling=0) at dl-reloc.c:158 #3 0x081984ee in dl_open_worker (a=0xbfa25380) at dl-open.c:294 #4 0x0817c4a4 in _dl_catch_error (objname=0xbfa2537c, errstring=0xbfa25378, operate=0x8198040 dl_open_worker, args=0xbfa25380) at dl-error.c:152 #5 0x08198606 in _dl_open (file=0xbfa254fc libnss_files.so.2, mode=1, caller=0x0) at dl-open.c:411 #6 0x0817cf4a in do_dlopen (ptr=0x1) at dl-libc.c:78 #7 0x0817c4a4 in _dl_catch_error (objname=0xbfa254d0, errstring=0xbfa254cc, operate=0x817cf30 do_dlopen, args=0xbfa254e0) at dl-error.c:152 #8 0x0817cf02 in dlerror_run (operate=0, args=0x40057930) at dl-libc.c:42 #9 0x0817cfd9 in __libc_dlopen ( __name=0x829eff0 Address 0x829eff0 out of bounds) at dl-libc.c:105 #10 0x0816e8ee in __nss_lookup_function (ni=0x821e798, fct_name=0x81cb6db getservbyname_r) at nsswitch.c:340 #11 0x0816e4f0 in __nss_lookup (ni=0x0, fct_name=0x82194ec , fctp=0xbfa254fc) at nsswitch.c:147 #12 0x0816fb04 in __getservbyname_r (name=0x81b2f3b mysql, proto=0x81aa9d6 tcp, resbuf=0x821a218, buffer=0x821e0e0 , buflen=1024, result=0x829eff0) at ../nss/getXXbyYY_r.c:168 #13 0x0816f965 in getservbyname (name=0x81b2f3b mysql, proto=0x81aa9d6 tcp) at ../nss/getXXbyYY.c:109 #14 0x080d3e80 in mysql_server_init (argc=0, argv=0x0, groups=0x0) at libmysql.c:138 #15 0x080e65f4 in mysql_init (mysql=0x0) at client.c:1418 #16 0x08048534 in DBMonitor (this=0x821c300, ---Type return to continue, or q return to quit--- fileName=0xbfa258bd monitor/parameters) at monitor/DBMonitor.cpp:10 Any help is greatly appreciated. Cheers, Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql_init segmentation fault
On 6/5/07, S Nassar [EMAIL PROTECTED] wrote: I didn't build libmysql.so myself. This was installed with mysql. The application code that calls mysql_init is built statically. I see this error when building on one machine and trying to use the code on a different machine. Knowing the operating system would help. Are the build machine and the target machine identical? Building portable binaries is an art unto itself and is way out of the scope of this list.. You may have built your program staically, but the stack dump tells me that libmysql has some dynamic dependancies. Thanks for all the help, Sam On 6/5/07, Michael Dykman [EMAIL PROTECTED] wrote: It looks like you application bailed while trying to resuolve the server address, but the nature of the dump looks to me like some kind of build error..did you build libmysql.so yourself or is this a binary download from a trusted source? - michael On 6/5/07, S Nassar [EMAIL PROTECTED] wrote: Hi, I am running an application that interfaces with MySQL from c++. When I try to run the application, I get a segmentation fault at the line where I call mysql_init. Here is part of the output from gdb #0 0x081a0e78 in elf_machine_rel.0 () at ../sysdeps/i386/dl-machine.h:333 #1 0x081a113a in elf_dynamic_do_rel.4 () at do-rel.h:100 #2 0x081a12db in _dl_relocate_object (l=0x821ec40, scope=0x821ed84, lazy=1, consider_profiling=0) at dl-reloc.c:158 #3 0x081984ee in dl_open_worker (a=0xbfa25380) at dl-open.c:294 #4 0x0817c4a4 in _dl_catch_error (objname=0xbfa2537c, errstring=0xbfa25378, operate=0x8198040 dl_open_worker, args=0xbfa25380) at dl-error.c:152 #5 0x08198606 in _dl_open (file=0xbfa254fc libnss_files.so.2, mode=1, caller=0x0) at dl-open.c:411 #6 0x0817cf4a in do_dlopen (ptr=0x1) at dl-libc.c:78 #7 0x0817c4a4 in _dl_catch_error (objname=0xbfa254d0, errstring=0xbfa254cc, operate=0x817cf30 do_dlopen, args=0xbfa254e0) at dl-error.c:152 #8 0x0817cf02 in dlerror_run (operate=0, args=0x40057930) at dl-libc.c:42 #9 0x0817cfd9 in __libc_dlopen ( __name=0x829eff0 Address 0x829eff0 out of bounds) at dl-libc.c:105 #10 0x0816e8ee in __nss_lookup_function (ni=0x821e798, fct_name=0x81cb6db getservbyname_r) at nsswitch.c:340 #11 0x0816e4f0 in __nss_lookup (ni=0x0, fct_name=0x82194ec , fctp=0xbfa254fc) at nsswitch.c:147 #12 0x0816fb04 in __getservbyname_r (name=0x81b2f3b mysql, proto=0x81aa9d6 tcp, resbuf=0x821a218, buffer=0x821e0e0 , buflen=1024, result=0x829eff0) at ../nss/getXXbyYY_r.c:168 #13 0x0816f965 in getservbyname (name=0x81b2f3b mysql, proto=0x81aa9d6 tcp) at ../nss/getXXbyYY.c:109 #14 0x080d3e80 in mysql_server_init (argc=0, argv=0x0, groups=0x0) at libmysql.c:138 #15 0x080e65f4 in mysql_init (mysql=0x0) at client.c:1418 #16 0x08048534 in DBMonitor (this=0x821c300, ---Type return to continue, or q return to quit--- fileName=0xbfa258bd monitor/parameters) at monitor/DBMonitor.cpp:10 Any help is greatly appreciated. Cheers, Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Segmentation Fault - core dumped
Description: ./mysql_install_db --user=mysql Installing all prepared tables Segmentation Fault - core dumped Installation of system tables failed! How-To-Repeat: run ./mysql_install_db --user=mysql Fix: please suggest. Submitter-Id: submitter ID Originator: Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-5.0.37 (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.19 Distrib 3.23.37, for sun-solaris2.8 on sparc Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 5.0.37 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 47 min 36 sec Threads: 1 Questions: 29 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Querie s per second avg: 0.010 C compiler:2.95.3 C++ compiler: 2.95.3 Environment: machine, os, target, libraries (multiple lines) System: SunOS sjc-web01-s28 5.8 Generic_117350-34 sun4u sparc SUNW,Sun-Fire-V240 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gmake /auto/sw/packages/gc c/c2.95.3a/bin//gcc /usr/ucb/cc GCC: Reading specs from /sw/packages/gcc/c2.95.3/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs gcc version 2.95.3 20010315 (cisco release) Compilation info: CC='gcc' CFLAGS='-D_REENTRANT' CXX='gcc' CXXFLAGS='-D_REENTRANT' LDFLAGS ='' ASFLAGS='' LIBC: -rw-r--r-- 1 root bin 1791728 Feb 7 2006 /lib/libc.a lrwxrwxrwx 1 root root 11 Jan 22 09:43 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1158072 Feb 7 2006 /lib/libc.so.1 -rw-r--r-- 1 root bin 1791728 Feb 7 2006 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jan 22 09:43 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1158072 Feb 7 2006 /usr/lib/libc.so.1 Configure command: ./configure '--prefix=/opt/nmtgre-tools/mysql' '--with-low-memory' '--enabl e-assemble' 'CC=gcc' 'CFLAGS=-D_REENTRANT' 'CXXFLAGS=-D_REENTRANT' 'CXX=gcc' -- Nadia Saifuddin NMTG Release Technology, Cisco 408-525-8767 [EMAIL PROTECTED]
Re: Segmentation fault error accrued when gcc -o test -L/usr/lib/mysql -lmysqlclient test.c
On Sunday 23 July 2006 10:26 pm, ali asghar torabi parizy wrote:
while ((row = mysql_fetch_row(res_set)) != NULL) {
while (row = mysql_fetch_row(res_set))
would do the same thing, NULL check shouldn't be necessary.
for (i=0; iltmysql_num_fields(res_set); i++) {
I hope your client is inserting that lt in there, that may be what's causing
your problem (not to mention it's lt;...)
printf(%s\n,row[i] != NULL ? row[i] : NULL);
}
}
--
Chris White
PHP Programmer/DBanned!
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Segmentation fault error accrued when gcc -o test -L/usr/lib/mysql -lmysqlclient test.c
hi to all.
thanks luiz and mike for response.
my code is compiled when i use -lmysqlclient option and executable file is now
exist but when i try to execute this file it prompts Segmentation fault
.what's the meaning of it and what i have to do?
##
gcc -o test -L/usr/lib/mysql -lmysqlclient test.c
##
The code is as fillows:
***
#include
#include
#define host localhost
#define username mysql
#define password
#define database test
MYSQL *conn;
int main() {
conn = mysql_init(NULL);
mysql_real_connect(conn,host,username,password,database,0,NULL,0);
MYSQL_RES *res_set;
MYSQL_ROW row;
unsigned int i;
mysql_query(conn,SELECT * FROM users WHERE userid=1);
res_set = mysql_store_result(conn);
unsigned int numrows = mysql_num_rows(res_set);
while ((row = mysql_fetch_row(res_set)) != NULL) {
for (i=0; iltmysql_num_fields(res_set); i++) {
printf(%s\n,row[i] != NULL ? row[i] : NULL);
}
}
mysql_close(conn);
return 0; }
*
Please help me
-
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail Beta.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
re:mysql client gets segmentation fault
Update. I downloaded the mysql-standard-4.1.18-pc-linux-gnu-i686.tar.gz and extracted mysql. The 4.1 mysql client does not get a segmentation fault when I do an up-arrow or anything else. It works just fine. The plot thickens. -- Barton L. Phillips Applied Technology Resources, Inc. Tel: (818)652-9850 Web: http://www.applitec.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql client gets segmentation fault
I just upgraded from 3.23 to 5.0. There server seems to be working just fine with all of my PHP and perl scripts. However, the mysql client is giving me problems. It starts up okay and I can do everything, but when I do an up arrow on the keyboard to get previous commands the second up arrow causes a segmentation fault. Also if I up arrow once and then press the right arrow a couple of times and then try to insert a character or delete a character I also get a segmentation fault. I looked through the archives and have not seen anything like this so I expect it may have something to do with my system specifically. I am running RedHat 9 on a 1.2 GHz Athelon with 512 meg of RAM and a 60 Gig hard drive. Can anyone lend a hand with some ideas? I haven't dug into it with the debugger yet but can. Thanks -- Barton L. Phillips Applied Technology Resources, Inc. Tel: (818)652-9850 Web: http://www.applitec.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql_ping() leads to Segmentation fault
Hello,
I am having issues with the MySQL C API. I have googled, and it seems
many other people are having this issue too, but unfortunately I have
yet to find a solution.
It seems that whenever anything calls mysql_ping(), it causes a
Segmentation fault. I am currently using MySQL 4.1.10a. I have tested on
a 4.0.24 version of MySQL and we don't seem to see any problems.
I wrote a quick test program to compare behavior on both systems (it is
in no way robust, just a quick check):
#include mysql.h
int main ()
{
MYSQL mysql_;
mysql_init(mysql_);
return mysql_ping(mysql_);
}
Compiled with GCC 2.96 and using MySQL 4.0.24 it returns and error code
of 255 as expected. Compiled with GCC 3.4.3 using MySQL 4.1.10a it
segfaults. Using gdb I have determined that it seg faults when trying to
run mysql_ping().
Can anyone shed any light onto this issue? Or is there a better place to
discuss problems like this?
Thanks,
Ash Christopher
Mysqldump segmentation fault(core dumped)
auto_increment, `TPais_idTPais` tinyint(3) unsigned NOT NULL, `estado` char(100) default NULL, `activo` char(1) default 'A', PRIMARY KEY (`idTEstado`), KEY `TEstado_FKIndex1` (`TPais_idTPais`), CONSTRAINT `TEstado_ibfk_1` FOREIGN KEY (`TPais_idTPais`) REFERENCES `TPais` (`idTPais`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `TEstado` -- /*!4 ALTER TABLE `TEstado` DISABLE KEYS */; LOCK TABLES `TEstado` WRITE; UNLOCK TABLES; /*!4 ALTER TABLE `TEstado` ENABLE KEYS */; -- -- Table structure for table `TPais` -- DROP TABLE IF EXISTS `TPais`; CREATE TABLE `TPais` ( `idTPais` tinyint(3) unsigned NOT NULL auto_increment, `pais` char(100) default NULL, `activo` char(1) default 'A', PRIMARY KEY (`idTPais`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `TPais` -- /*!4 ALTER TABLE `TPais` DISABLE KEYS */; LOCK TABLES `TPais` WRITE; UNLOCK TABLES; /*!4 ALTER TABLE `TPais` ENABLE KEYS */; -- -- Table structure for table `TRuta` -- DROP TABLE IF EXISTS `TRuta`; CREATE TABLE `TRuta` ( `idTRuta` int(10) unsigned NOT NULL auto_increment, `TCiudad_destino` int(10) unsigned NOT NULL, `TCiudad_origen` int(10) unsigned NOT NULL, `nombre` char(100) default NULL, `km` double(9,2) default NULL, PRIMARY KEY (`idTRuta`), KEY `TRuta_FKIndex1` (`TCiudad_origen`), KEY `TRuta_FKIndex2` (`TCiudad_destino`), CONSTRAINT `TRuta_ibfk_1` FOREIGN KEY (`TCiudad_origen`) REFERENCES `TCiudad` (`idTCiudad`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `TRuta_ibfk_2` FOREIGN KEY (`TCiudad_destino`) REFERENCES `TCiudad` (`idTCiudad`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `TRuta` -- /*!4 ALTER TABLE `TRuta` DISABLE KEYS */; LOCK TABLES `TRuta` WRITE; UNLOCK TABLES; /*!4 ALTER TABLE `TRuta` ENABLE KEYS */; -- -- Table structure for table `VRuta` -- DROP TABLE IF EXISTS `VRuta`; CREATE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY DEFINER VIEW `VRuta` AS select `a`.`idTRuta` AS `idTRuta`,`a`.`nombre` AS `nombre`,`a`.`km` AS `km`,concat(`c`.`estado`,_utf8', ',`b`.`ciudad`) AS `origen`,concat(`e`.`estado`,_utf8', ',`d`.`ciudad`) AS `Destino` from `TRuta` `a` join `TCiudad` `b`) join `TEstado` `c`) join `TCiudad` `d`) join `TEstado` `e`) where ((`a`.`TCiudad_origen` = `b`.`idTCiudad`) and (`b`.`TEstado_idTEstado` = `c`.`idTEstado`) and (`a`.`TCiudad_destino` = `d`.`idTCiudad`) and (`d`.`TEstado_idTEstado` = `e`.`idTEstado`)); Segmentation fault (core dumped) apps# uname -a FreeBSD apps.medel.com.mx 5.4-RELEASE FreeBSD 5.4-RELEASE #0: Sun May 8 10:21:06 UTC 2005 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/GENERIC i386 apps# tail -f apps.medel.com.mx.err Table status: Opened tables: 12 Open tables:6 Open files:12 Open streams: 0 Alarm status: Active alarms: 0 Max used alarms: 0 Next alarm time: 0 I've had a look at bugs.mysql.com but I wasn't able to find anything similar, What could be the problem? Regards! Tanks in advance. ++ | ISC Edwin Cruz [EMAIL PROTECTED]| | IT Manager | | Transportes Medel Rogero SA de CV | | Desk: 01 (449) 910 30 90 x3054| | MX Mobile: 01 (449) 111 29 03 | | Skype: softr8 | ++
Re: Mysqldump segmentation fault(core dumped)
In the last episode (Dec 08), ISC Edwin Cruz said: Hi all! Look: mysql select version(); +---+ | version() | +---+ | 5.0.13-rc | +---+ ... mysql quit Bye apps# mysqldump --databases test1 ... `d`.`idTCiudad`) and (`d`.`TEstado_idTEstado` = `e`.`idTEstado`)); Segmentation fault (core dumped) ... apps# uname -a FreeBSD apps.medel.com.mx 5.4-RELEASE FreeBSD 5.4-RELEASE #0: Sun May 8 10:21:06 UTC 2005 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/GENERIC i386 I can't reproduce this on my FreeBSD 5.4 machine, running mysql-*-5.0.16. Try updating the mysql ports and try again. You didn't see anything in the .err file because only mysqldump crashed, not the server. A stack trace would also help (run gdb mysqldump mysqldump.core, then enter bt). -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: segmentation fault using mysql
Ed Kasky wrote: Running MySql 4.1.14 on RedHat 7.2 I just upgraded from 4.1.13 to 4.1.14 and was am experiencing problems using the mysql client. # /usr/local/mysql/bin/mysql -h localhost -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 34 to server version: 4.1.14-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql \h Segmentation fault I had similar problems before. It was caused by older version of client. Once client is updated this problem goes away. This problem has also occured to me when I use InnoDB instead of the defaul table type. For later case, I make a copy of the innoDB into the regular type, then the problem seem to goes away. Hope my experience will help you. Kemin My searches have not resulted in any solutions at this point - just thought I'd throw it out to the list and see if anyone has had a similar experience. Ed Kasky ~ Randomly Generated Quote (324 of 486): I would have made this shorter, but I ran out of time. . .
Re: segmentation fault using mysql
At 10:15 AM Saturday, 8/27/2005, Kemin Zhou wrote -= Ed Kasky wrote: Running MySql 4.1.14 on RedHat 7.2 I just upgraded from 4.1.13 to 4.1.14 and was am experiencing problems using the mysql client. # /usr/local/mysql/bin/mysql -h localhost -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 34 to server version: 4.1.14-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql \h Segmentation fault I had similar problems before. It was caused by older version of client. Once client is updated this problem goes away. This problem has also occured to me when I use InnoDB instead of the defaul table type. For later case, I make a copy of the innoDB into the regular type, then the problem seem to goes away. Hope my experience will help you. Hmmm... I wonder why the client would not have been updated. I checked the version and could have sworn it was 4.1.14 as well. I have only converted a test table to InnoB - the rest are MyISAM. I will re-run the install (I use the src distro) and see if the client does not get updated. Ed Kasky ~ Randomly Generated Quote (462 of 487): We are born naked and hungry and it's down hill from there. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
segmentation fault using mysql
Running MySql 4.1.14 on RedHat 7.2 I just upgraded from 4.1.13 to 4.1.14 and was am experiencing problems using the mysql client. # /usr/local/mysql/bin/mysql -h localhost -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 34 to server version: 4.1.14-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql \h Segmentation fault My searches have not resulted in any solutions at this point - just thought I'd throw it out to the list and see if anyone has had a similar experience. Ed Kasky ~ Randomly Generated Quote (324 of 486): I would have made this shorter, but I ran out of time. . . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Re: use mysql and segmentation fault
Hi! I installed the same rpms on a SuSE 9.2 box and tried to reproduce that problem, but that problem didn't happen. It seems that this problem has something to do with RHEL3, right? Thanks. Hao Xu Hello. If you are able to reproduce this problem on another box with a similar configuration, I suggest you to report a bug. BTW mysql client has some problems already reported, see: http://bugs.mysql.com/bug.php?id=9870 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: use mysql and segmentation fault
Hello. You're sure that you are running an official binary? Xu Hao [EMAIL PROTECTED] wrote: Hi! I installed the same rpms on a SuSE 9.2 box and tried to reproduce that problem, but that problem didn't happen. It seems that this problem has something to do with RHEL3, right? Thanks. Hao Xu Hello. If you are able to reproduce this problem on another box with a similar configuration, I suggest you to report a bug. BTW mysql client has some problems already reported, see: http://bugs.mysql.com/bug.php?id=9870 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Re: use mysql and segmentation fault
Yes, I downloaded the 4.1 rpms from http://dev.mysql.com/downloads/mysql/4.1.html Hello. You're sure that you are running an official binary? Xu Hao [EMAIL PROTECTED] wrote: Hi! I installed the same rpms on a SuSE 9.2 box and tried to reproduce that problem, but that problem didn't happen. It seems that this problem has something to do with RHEL3, right? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
use mysql and segmentation fault
Hi everyone! I downloaded and installed the mysql 4.1 rpms on my RedHat Enterprise Linux 3 box and found a strange problem. If I invoke the client program by mysql -u root -p'mypassword' and then type use mysql, then segmentation fault happens, but if I invoke the client program by mysql -u root -p'mypassword' -A, then everything is ok. See below for details. [EMAIL PROTECTED] mysql]# mysql -u root -p** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 to server version: 4.1.11-standard Reading history-file /root/.mysql_history Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A segmentation fault [EMAIL PROTECTED] mysql]# mysql -u root -pphoenix -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 to server version: 4.1.11-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use mysql Database changed mysql Any help? Thanks! Hao Xu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: use mysql and segmentation fault
Hello. If you are able to reproduce this problem on another box with a similar configuration, I suggest you to report a bug. BTW mysql client has some problems already reported, see: http://bugs.mysql.com/bug.php?id=9870 Xu Hao [EMAIL PROTECTED] wrote: Hi everyone! I downloaded and installed the mysql 4.1 rpms on my RedHat Enterprise Linux 3 box and found a strange problem. If I invoke the client program by mysql -u root -p'mypassword' and then type use mysql, then segmentation fault happens, but if I invoke the client program by mysql -u root -p'mypassword' -A, then everything is ok. See below for details. [EMAIL PROTECTED] mysql]# mysql -u root -p** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 to server version: 4.1.11-standard Reading history-file /root/.mysql_history Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A segmentation fault [EMAIL PROTECTED] mysql]# mysql -u root -pphoenix -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 to server version: 4.1.11-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use mysql Database changed mysql Any help? Thanks! Hao Xu -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Segmentation fault while executing Mysql application.
Hello sir, I have written an application by using MySQL API for retrieving result of simple query select * from Table_Name but there are some modification in compilation process for getting desire results. Modification or Alteration are: 1. I have Installed full packages of MySQL-3.23.54-11during Linux RedHat (Shrike) installation. 2. I have written an application by using following MySQL API: i- mysql_init(mysql); ii- mysql_real_connect(mysql,host,user,pass,db,0,NULL,0) iii- mysql_real_query(mysql,query,50) iv- mysql_store_result(mysql) v- mysql_fetch_row(res) vi- mysql_num_fields(res) vii-mysql_free_result(res) viii- mysql_close(mysql); 3. I am using following files: i- mysql.h -- Header file for fucntion prototyping and use for Data-Type declaration. ii-mysql_com.h and mysql_version.h -- These header files are required for mysql.h file iii- libmysqlclient.a -- Use for required API and for compilation iv- Esql.c -- My own Application Note: mysql.h, mysql_com.h and mysql_version.h are belong to MySQL-3.23.54-11 package but libmysqlclient.a is belong to MySQL-4.1.10 package and all mentioned file are contains in a Folder 'Application'. 4. Compilation procedure: i- gcc -o App Esql.c -lz /path/to/Application/libmysqlclient.a 5. Execution procedure: i- Application ./App 6. Execution Error: i- I have retrieved desire result with respect to query. ii- But Following error occur after print desire result on screen at end: I- Segmentation fault. 7. Experiments: i- I have examined application behaviour with libmysqlclient.a file of same package MySQL-3.23.54-11. ii-I have gained all those result what i had expected. 8. Reason: i-Source distribution MySQL-3.23.54-11.tar.gz does not install properly even all requirement are met as describe in mannual. ii-Source distribution MySQL-4.1.10.tar.gz install properly iii- I required all those files which is required for creating libmysqlclient.a file; *.c and *.o of MySQL-3.23.54-11 package which install during linux installation. So, these were fact and figure which being happen in developing application. Kindly, suggest me. I 'll be very greatful to you. IMRAN SHABBIR Software Engineer Vibrant Wits Software Inc. Pakistan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie question: segmentation fault in mysql_init
At 19:32 +0100 12/13/04, Alina Bikowska wrote:
Description:
When I try to call mysql_init() several times in
my program it finishes with segmentation fault.
This happens in different places of my program but always in mysql_init().
This is the gdb output:
#0 0x007ba6ae in malloc_consolidate () from /lib/tls/libc.so.6
#1 0x007b9e6a in _int_malloc () from /lib/tls/libc.so.6
#2 0x007b925d in malloc () from /lib/tls/libc.so.6
#3 0x001716ae in my_malloc () from /usr/local/lib/mysql/libmysqlclient.so.12
#4 0x0016c648 in mysql_init () from /usr/local/lib/mysql/libmysqlclient.so.12
#5 0x0804dee2 in myconnect () at databaseFunctions.c:14
#6 0x0804dfc0 in give_geneValue_with_key
(table=0x8051fe8 \selfRoot_shell\, id=9463)
at databaseFunctions.c:37
#7 0x08049a27 in selfProfiler () at library.c:232
#8 0x0804952c in negativeSelection () at library.c:176
#9 0x0804a92d in negativeSelectionSentinel () at library.c:420
#10 0x0804edad in communicator (arg=0x755d00) at communicator.c:60
#11 0x08048cdf in main () at primary.c:169
Here are the functions I use.
The first function is only to make a connection to database:
MYSQL* myconnect()
{
MYSQL *my_connection=malloc(sizeof(MYSQL *));
my_connection=mysql_init (NULL);
I don't think this solves your problem, but I'm curious:
Why do you allocate memory and assign it to my_connection, and then
immediately throw that memory away by assigning my_connection the value
of mysql_init()? That's a memory leak right there.
if(mysql_real_connect (my_connection,
\130.225.16.5\, \ala\, \alaSdb\, \ala\,
0, NULL, 0))
{
return my_connection;
}
else
{
fprintf (stderr, \Connection failed !!!\\n\);
if (mysql_errno (my_connection))
{
fprintf (stderr,
\Connection error %d: %s\\n\, mysql_errno
(my_connection), mysql_error (my_connection));
return NULL;
}
}
return NULL;
}
This function and a couple of others similar are
to withdraw some data from database. All of them
use myconnection() function;
char* give_geneValue_with_key(char *table,int id)
{
MYSQL* my_connection=myconnect();
MYSQL_RES *result=malloc(sizeof(MYSQL_RES*));
MYSQL_ROW row;
char temp[1];
sprintf(temp,\SELECT geneValue FROM %s where id=\'%d\'\,table,id);
if(mysql_real_query (my_connection,temp,strlen(temp))) return \0\;
if(!(result=mysql_store_result(my_connection))) return \0\;
row=mysql_fetch_row(result);
mysql_free_result(result);
mysql_close(my_connection);
return row[0];
}
If you have any ideas what can be a problem, please let me know.
Alina Binkowska
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Newbie question: segmentation fault in mysql_init
Description:
When I try to call mysql_init() several times in my program it finishes with
segmentation fault.
This happens in different places of my program but always in mysql_init().
This is the gdb output:
#0 0x007ba6ae in malloc_consolidate () from /lib/tls/libc.so.6
#1 0x007b9e6a in _int_malloc () from /lib/tls/libc.so.6
#2 0x007b925d in malloc () from /lib/tls/libc.so.6
#3 0x001716ae in my_malloc () from /usr/local/lib/mysql/libmysqlclient.so.12
#4 0x0016c648 in mysql_init () from /usr/local/lib/mysql/libmysqlclient.so.12
#5 0x0804dee2 in myconnect () at databaseFunctions.c:14
#6 0x0804dfc0 in give_geneValue_with_key (table=0x8051fe8 \selfRoot_shell\,
id=9463)
at databaseFunctions.c:37
#7 0x08049a27 in selfProfiler () at library.c:232
#8 0x0804952c in negativeSelection () at library.c:176
#9 0x0804a92d in negativeSelectionSentinel () at library.c:420
#10 0x0804edad in communicator (arg=0x755d00) at communicator.c:60
#11 0x08048cdf in main () at primary.c:169
Here are the functions I use.
The first function is only to make a connection to database:
MYSQL* myconnect()
{
MYSQL *my_connection=malloc(sizeof(MYSQL *));
my_connection=mysql_init (NULL);
if(mysql_real_connect (my_connection, \130.225.16.5\, \ala\, \alaSdb\,
\ala\, 0, NULL, 0))
{
return my_connection;
}
else
{
fprintf (stderr, \Connection failed !!!\\n\);
if (mysql_errno (my_connection))
{
fprintf (stderr, \Connection error %d: %s\\n\,
mysql_errno (my_connection), mysql_error (my_connection));
return NULL;
}
}
return NULL;
}
This function and a couple of others similar are to withdraw some data from
database. All of them use myconnection() function;
char* give_geneValue_with_key(char *table,int id)
{
MYSQL* my_connection=myconnect();
MYSQL_RES *result=malloc(sizeof(MYSQL_RES*));
MYSQL_ROW row;
char temp[1];
sprintf(temp,\SELECT geneValue FROM %s where id=\'%d\'\,table,id);
if(mysql_real_query (my_connection,temp,strlen(temp))) return \0\;
if(!(result=mysql_store_result(my_connection))) return \0\;
row=mysql_fetch_row(result);
mysql_free_result(result);
mysql_close(my_connection);
return row[0];
}
If you have any ideas what can be a problem, please let me know.
Alina Binkowska
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Apache2.0.50 Segmentation fault when using PHP 4.3.8 + MySQL 4.0.20
Hi I'm brand new to this list, so please forgive me if I'm wasting everybodies time :-). I've used a couple of days tracking this one down and just thought I would share it if anyone is strugling with the same problem. Running : FreeBSD 4.9-RELEASE-p5 Apache 2.0.50 PHP 4.3.8 MySQL 4.0.20 ...and different (mainly newer) versions of the CMS called PostNuke, my apache childs died on index.php with this in the Apache error log: child pid x exit signal Segmentation fault (11). I tracked it to a PHP function call to MySQL (in some PostNuke database include) Tried: - older Apache - even 1.3 branch - older PHP - 4.3 and 4.2.3 - other server (100% different hardware) Solution (or work around if you like) is apparently to configure PHP using --with-mysql (was using --with-mysql=/usr/local/mysql before). Don't know if it is PHP or MySQL related... Hope this will make it to the list and archive and save some time for someone one day... Feel free to ask any further questions... If someone would like me to try different stuff it 100% reproduceable and I will have a test server with the correct setup for the next week or so (the production server will be around for longer, but I don't like messing around with it too much :-) ). By the way - thank You for a great product Regards Gert Lynge -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Segmentation Fault/Core dump
Any thoughts on what might be causing this error? I am runing both on cygwin under windows 2000 with 4.0.16 and using gcc to compile, linking using gcc sample.c -o sample.exe -I/usr/include/mysql -L/lib/mysql/opt/ -lmysqlclient -lmySQL -lz -lm I assume that something in the libraries may not be correct or that I need to check some other parameter but I am at a loss. Thanks Leif
Re: Segmentation Fault/Core dump
It will more easier if you post the sample.c. you can try compiling with -ggdb to debug Leif Johnston wrote: Any thoughts on what might be causing this error? I am runing both on cygwin under windows 2000 with 4.0.16 and using gcc to compile, linking using gcc sample.c -o sample.exe -I/usr/include/mysql -L/lib/mysql/opt/ -lmysqlclient -lmySQL -lz -lm I assume that something in the libraries may not be correct or that I need to check some other parameter but I am at a loss. Thanks Leif -- Aftab Jahan Subedar CEO/Software Engineer Subedar Technologies Subedar Baag Bibir Bagicha #1 North Jatrabari Dhaka 1204 Bangladesh http://www.SubedarTechnologies.com http://www.DhakaStockExchangeGame.com/ http://www.CEOBangladesh.com/ http://www.NYSEGame.com tel://+88027519050 EMail://[EMAIL PROTECTED] - Directly to my notebook -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Segmentation fault
I get this: /usr/local/mysql/bin/mysqld_safe: line 342: 23172 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 When attempting to do: Select n from table.n where field1='x' and field2='y' and (field3= or field3='z1' . . . field3='z8816'); Yes, there are 8816 values for z included in this select. Any ideas on how to correct for the seg fault? This is being run on Mysql 4.0.15 x86_64 on dual Opteron with 4GB on SUSE8.2 Any ideas? thanks, Santiago -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Segmentation fault using the C API
This is a rather long message but I am stuck and am really in a bind so I wanted anyone who might be willing to point me in the right direction to have the full picture. I recently installed MySql 4.0.13 on a Intel Linux box running Red Hat 9. I used the RPM that I found on the MySQL site. I had to remove the existing MySQL 3.23 installation prior to installing 4.0.13, which was kind of a pain but I got it to work, although it ended up in /usr/bin instead of /usr/local, as the MySQL manual suggests to put it. I then created a database, created some tables and populated them manually using sql statements. I am able perform all db operations as expected. Prior to installing MySQL using the provided RPM for my system, I also downloaded, unziped and untarred a binary distribution in /usr/local, as per the MySQL reference manual. Once I got the RPM install to work I never removed this. I thought this turned out to be a good thing as I could not locate the lib directory to link against from the RPM install so I used /usr/local/mysql-4.0.13-pc-linux-i686/lib to link against instead. In a separate directory I installed a copy of the source distribution so that I could mess around with the C API w/i affecting the good version of 4.0.13 that I installed using the RPM and already have populated manually with data. I proceeded to write a short '*.c' program that would accept command line args (database, user password) and then connect to the database using mysql_real_connect(), print a message to the console indicating it had connected successfully, then exit using mysql_close(). I saved the source file in the same directory that the example programs that came with the source distribution (../mysql-4.0.13/client) are stored. I compiled this program using the following (note I used the library that came with the RPM that I installed earlier: gcc -g -o mysql_connect_test mysql_connect_test.c -I ../include -L /usr/local/mysql-standard-4.0.13-pc-linux-i686/lib -lmysqlclient -lnsl -lz The program compiled fine but when I ran it I get a segmentation fault. Thought it might have been programmer's error so I reviewed my code and it is not. I then compiled 'insert_test.c', a program that came with the source distribution and it to compiled fine using the above make line. When I ran this executable it also seg faults. Is there something I am missing. Is it not OK to use the libraries from the standard RPM install? Thanks for anyone help in advance. Sean Mac Millan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Segmentation Fault in mysql_server_init() while using Embedded server
Hi All
I'm trying to create a new database using the embedded server (MySQL 4.0.13). I
compiled the source distribution on linux as follows:
./configure --prefix=/fs32/b/sgsubram/bin/MySQL-with-new-hash/LINUX --enable-assembler
--with-mysqld-ldflags=-all-static
--localstatedir=/fs32/b/sgsubram/bin/MySQL-with-new-hash/LINUX/data
--with-client-ldflags=-all-static -enable-thread-safe-client --enable-local-infile
--with-extra-charsets=complex
gmake; gmake install
The installation went smoothly without any problems. I tested the sample
test_libmysqld.c program and it went through fine.
Then I tried the following. I changed the code for the functions db_connect and main
in test_libmysqld.c to create a new database if there is no database by that name.
The changed code segment is as follows (changes are in bold):
int
main(int argc, char **argv)
{
MYSQL *one, *two;
mysql_server_init(argc, argv, (char **)server_groups);
one = db_connect(hello);
two = db_connect(NULL);
db_do_query(one, SHOW TABLE STATUS);
db_do_query(two, SHOW DATABASES);
mysql_close(two);
mysql_close(one);
/* This must be called after all other mysql functions */
mysql_server_end();
exit(EXIT_SUCCESS);
}
MYSQL *
db_connect(const char *dbname)
{
MYSQL *db = mysql_init(NULL);
if (!db)
die(db, mysql_init failed: no memory);
/*
* Notice that the client and server use separate group names.
* This is critical, because the server will not accept the
* client's options, and vice versa.
*/
mysql_options(db, MYSQL_READ_DEFAULT_GROUP, test_libmysqld_CLIENT);
if (!mysql_real_connect(db, NULL, NULL, NULL, dbname, 0, NULL, 0)) {
char query[1024];
sprintf(query, CREATE DATABASE %s, dbname);
if (mysql_query(db, query) != 0) {
die(db, mysql_real_connect failed: %s, mysql_error(db));
} else {
if (!mysql_real_connect(db, NULL, NULL, NULL, dbname, 0, NULL, 0)) {
die(db, mysql_real_connect failed: %s, mysql_error(db));
}
}
}
return db;
}
There is no database by name hello. The crash happens in mysql_server_init(). The
crash does not happen if I try to connect to an existing database by name test. The
stack trace that I get when I run it inside gdb is as follows:
(gdb) where
#0 0x0828c416 in __sigsuspend (set=0xbfffb870) at
../sysdeps/unix/sysv/linux/sigsuspend.c:45
#1 0x082804b5 in __pthread_wait_for_restart_signal (self=0x83c4900) at pthread.c:978
#2 0x08280591 in __pthread_create_2_1 (thread=0xbfffba10, attr=0xbfffba14,
start_routine=0x81eaa00 io_handler_thread, arg=0x841bba0) at restart.h:34
#3 0x081a171f in os_thread_create ()
#4 0x081ebecb in innobase_start_or_create_for_mysql ()
#5 0x08051672 in innobase_init ()
#6 0x08058f44 in ha_init ()
#7 0x080500b4 in mysql_server_init ()
#8 0x080481eb in main (argc=1, argv=0xbfffc434) at test_libmysqld.c:45
#9 0x082885f2 in __libc_start_main (main=0x80481d0 main at test_libmysqld.c:20,
argc=1, ubp_av=0xbfffc434, init=0x80480b4 _init, fini=0x82ff480 _fini,
rtld_fini=0, stack_end=0xbfffc42c) at ../sysdeps/generic/libc-start.c:129
Any help with this problem would be greatly appreciated.
Thanks
Satheesh
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005
Re: mysqlhotcopy generates a segmentation fault
On Wed, 2003-06-11 at 01:55, Danny Cron wrote:
I have three boxes. Mysqlhotcopy works on box1, but it generates a
segmentation fault on box2 and box3. I want it to work on all boxes.
I am prepared to upgrade them all to the level of box3 (but
mysqlhotcopy doesn't work with that configuration). Does anyone know
of a solution?
Hi,
I have had the same problem running mysqlhotcopy on the MySQL
installed with Woody. I think there is some problem with the
client library while it tries to parse the my.cnf file causing
a segmentation fault. I'm not sure if the problem is inside DBI
or the MySQL libs.
A quick solution is to remove the
mysql_read_default_group=mysqlhotcopy clause from the connection
string:
my $dbh =
DBI-connect(dbi:mysql:$dsn;mysql_read_default_group=mysqlhotcopy,
$opt{user}, $opt{password},
{
RaiseError = 1,
PrintError = 0,
AutoCommit = 1,
});
becomes:
my $dbh = DBI-connect(dbi:mysql:$dsn,
$opt{user}, $opt{password},
{
RaiseError = 1,
PrintError = 0,
AutoCommit = 1,
});
This loses the ability to use dedicated mysqlhotcopy sections
in your config file, but at least gets around the segfault.
regards,
Martin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlhotcopy generates a segmentation fault
I have three boxes. Mysqlhotcopy works on box1, but it generates a segmentation fault on box2 and box3. I want it to work on all boxes. I am prepared to upgrade them all to the level of box3 (but mysqlhotcopy doesn't work with that configuration). Does anyone know of a solution? Box 1: Debian Linux, 2.4.18. mysql 3.23.50, mysqlhotcopy 1.16, perl 5.6.1, libdbi-perl (1.21-2), libdbd-mysql-perl 1.2219-4 Box 2: Debian Linux, 2.4.18, mysql 3.23.49, mysqlhotcopy 1.14, perl 5.6.1, libdbi-perl (1.21-2), libdbd-mysql-perl 1.2219-4 Box 3: Debian Linux, 2.4.19. mysql 4.0.13, mysqlhotcopy 1.18, perl 5.8.0, libdbi-perl (1.35), libdbd-mysql-perl 2.1026 Danny. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
segmentation fault.
Dear list, I've installed mysql 3.32.55 And for some reason, I'm getting this error message on my screen: /usr/local/mysql/bin/safe_mysqld: line 280: 8207 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 Number of processes running now: 1 mysqld process hanging, pid 8210 - killed 030302 19:41:26 mysqld restarted I have configed mysql as following : ./configure \ --prefix=/usr/local/mysql \ --enable-large-files \ --with-innodb \ --with-mysqld-user=mysql \ --disable-maintainer-mode \ --without-docs \ --without-debug \ --without-bench \ --enable-assembler \ --with-named-z-libs=/usr/local/zlib/lib The only time I get this, is when cyrus wants to login to get some user data ( login data for mail user ) With 3.23.54 I didn't had any problems. I hope some one can help me with this. Thanks in advance. With kind regards, Richard Pijnenburg Klik-on Internet Solutions - 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: [Web-cyradm] mysql segmentation fault ( cyrus checking )
Nope all the tables are good. (Also just installed it) When I start cyrus I get the following error message in my messages log : Mar 2 21:19:06 dev tls_prune[836]: DBERROR db4: 4 lockers When trying to connect to the mail server I get these error's : maillog Mar 2 21:20:26 dev postfix/smtpd[841]: warning: dict_nis_init: NIS domain name not set - NIS lookups disabled Mar 2 21:20:27 dev postfix/smtpd[841]: connect from unknown[192.168.0.31] Mar 2 21:20:27 dev postfix/smtpd[841]: 743B828294: client=unknown[192.168.0.31] Mar 2 21:20:27 dev postfix/trivial-rewrite[844]: warning: connect to mysql server 192.168.0.32: Lost connection to MySQL server during query Mar 2 21:20:27 dev postfix/trivial-rewrite[844]: fatal: mysql:/etc/postfix/mysql-mydestination.cf: table lookup problem Mar 2 21:20:28 dev postfix/smtpd[841]: warning: premature end-of-input on private/rewrite socket while reading input attribute name Mar 2 21:20:28 dev postfix/smtpd[841]: warning: resolve_clnt_query: bad read: Success Mar 2 21:20:28 dev postfix/master[814]: warning: process /usr/libexec/postfix/trivial-rewrite pid 844 exit status 1 And on my mysql server I get : /usr/local/mysql/bin/safe_mysqld: line 280: 9375 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 Number of processes running now: 1 mysqld process hanging, pid 9385 - killed 030302 21:05:43 mysqld restarted I don't know what's wrong I hope some one can help me. Met vriendelijke groet, Richard Pijnenburg Klik-on Internet Solutions Mobiel : +31 (0)6 20 76 70 46 Web : www.klik-on.nl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Seifert Sent: Sunday, March 02, 2003 8:24 PM To: [EMAIL PROTECTED] Subject: Re: [Web-cyradm] mysql segmentation fault ( cyrus checking ) You may want to run mysqlcheck/check table ... maybe the table for cyrus is corrupted. Thomas On Sun, 2 Mar 2003 20:11:13 +0100 richard pijnenburg [EMAIL PROTECTED] wrote: Dear list, I've installed mysql 3.32.55 And for some reason, I'm getting this error message on my screen: /usr/local/mysql/bin/safe_mysqld: line 280: 8207 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 Number of processes running now: 1 mysqld process hanging, pid 8210 - killed 030302 19:41:26 mysqld restarted The only time I get this, is when cyrus wants to login to get some user data ( login data for mail user ) With 3.23.54 I didn't had any problems. I hope some one can help me with this. Met vriendelijke groet, Richard Pijnenburg Klik-on Internet Solutions Mobiel : +31 (0)6 20 76 70 46 Web : www.klik-on.nl ___ Web-cyradm mailing list [EMAIL PROTECTED] http://www.web-cyradm.org/mailman/listinfo/web-cyradm - 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
Segmentation Fault Closing Database
I am receiving a Segmentation Fault error when closing the connection to a
database. Using MySQL 4.0.10-0 on Redhat linux 7.3
static void closeDatabase( DBMS_STATE_INFO *dbmsInfo )
{
mysql_close( dbmsInfo-connection );
dbmsInfo-connection = NULL;
}
Thank you,
rcs
-
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
Segmentation fault
Hello, I am using Version : 3.23.40 under Linux and 3.23.51-Max under Windows XP I get the following error message while dumping my database. The segmentation fault is caused by the -c option. (It also occurs under Windows XP). Pierre-Yves Saumont Red Hat Linux release 6.2 (Zoot) Kernel 2.2.14-5.0smp on a 2-processor i686 login: volga Password: Last login: Fri Feb 7 06:11:45 from ASte-Genev-Bois-105-1-1-116.abo.wanadoo.fr [volga@s5 volga]$ mysqldump -uvolga -p -c volga_volga volga_volga_20030207_1520.sql Enter password: Segmentation fault (core dumped) - 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: Segmentation fault when scanning mysqld port
Manuel, Benjamin, /usr/local/mysql/3.23.55/bin/safe_mysqld: line 280: 1757 Segmentation fault And again, this looks like the SuSE bug to me. Here's my posting about an error like this on Red Hat: cite who=myself Synopsis: Server crashes on remote connection I'm not a Unix guru but I experienced the same sympton on SuSE Linux 8.0/8.1, and I heard of people reporting the same of Red Hat Linux 7.x/8.x. MySQL runs stable, you can connect from localhost via socket and tcp/ip, but as soon as you try a connect from some other machine, mysqld segfaults. In all cases I heard of, the problem was some glibc version that caused all the trouble. You say you use glibc-2.2.93-5 This version # looks a bit strange to me, well ... In a SuSE Linux Newsgroup I heard that everything's okay if you use = 2.2.5-151. We use glibc-2.2.5-164 on SuSE Linux 8.1, and with our 3.23.54, we've had no problems at all. /cite HTH, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Manuel Kiessling [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 9:44 PM Subject: Re: Segmentation fault when scanning mysqld port On Sat 2003-01-25 at 14:16:35 +0100, [EMAIL PROTECTED] wrote: Hello, i just installed MySQL 3.23.55 on a SuSE Linux 8.1 system (compiled myself), and after firing up mysqld and starting a scan (via nmap; my server has no firewall) from another server, i get the following message: /usr/local/mysql/3.23.55/bin/safe_mysqld: line 280: 1757 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 Number of processes running now: 1 mysqld process hanging, pid 1760 - killed 030125 15:06:29 mysqld restarted Hope someone can say something to this. Try a pre-compiled binary? Without testing, I simply presume that such an obvious bug would not stay long. So your binary looks shaky. Okay, I tested against the older 3.23.49 and cannot reproduce this. HTH, Benjamin. -- [EMAIL PROTECTED] - 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 - 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: Segmentation fault when scanning mysqld port
Hi, found some advise here (in german): http://groups.google.de/groups?q=suse+glibc+mysqlhl=delr=ie=UTF-8oe=UTF-8selm=apkaeo%242cspr%242%40ID-121729.news.dfncis.dernum=3 -- Manuel Kiessling - 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: Segmentation fault when scanning mysqld port
Manuel, And again, this looks like the SuSE bug to me. that's good news, at least now i know it's not just me. Anyone has a good tutorial about updating glibc? :-) If you're lucky, you might be able to use this RPM: ftp://ftp.suse.com/pub/suse/i386/update/8.1/rpm/i586/glibc-2.2.5-161.i58 Now, this seems like version ...-161 to me. On my linux box, I have ...-164 right now. No problem with MySQL. (I wonder why SuSE and - supposedly - Red Hat put old glibc's in their dists. There seems no good reason for doing this.) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Manuel Kiessling [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Cc: Benjamin Pflugmann [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, January 26, 2003 11:07 AM Subject: Re: Segmentation fault when scanning mysqld port hello, Stefan Hinz, iConnect (Berlin) wrote: Manuel, Benjamin, And again, this looks like the SuSE bug to me. that's good news, at least now i know it's not just me. Anyone has a good tutorial about updating glibc? :-) -- Manuel Kiessling - 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: Segmentation fault when scanning mysqld port
Hello, yep, this one fixed it: ftp://ftp.suse.com/pub/suse/i386/update/8.1/rpm/i586/glibc-2.2.5-161.i586.rpm mysql - gotta love that filter -- Manuel Kiessling - 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
Segmentation fault when scanning mysqld port
Hello, i just installed MySQL 3.23.55 on a SuSE Linux 8.1 system (compiled myself), and after firing up mysqld and starting a scan (via nmap; my server has no firewall) from another server, i get the following message: /usr/local/mysql/3.23.55/bin/safe_mysqld: line 280: 1757 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 Number of processes running now: 1 mysqld process hanging, pid 1760 - killed 030125 15:06:29 mysqld restarted Hope someone can say something to this. -- Manuel Kiessling - 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: Segmentation fault when scanning mysqld port
On Sat 2003-01-25 at 14:16:35 +0100, [EMAIL PROTECTED] wrote: Hello, i just installed MySQL 3.23.55 on a SuSE Linux 8.1 system (compiled myself), and after firing up mysqld and starting a scan (via nmap; my server has no firewall) from another server, i get the following message: /usr/local/mysql/3.23.55/bin/safe_mysqld: line 280: 1757 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 Number of processes running now: 1 mysqld process hanging, pid 1760 - killed 030125 15:06:29 mysqld restarted Hope someone can say something to this. Try a pre-compiled binary? Without testing, I simply presume that such an obvious bug would not stay long. So your binary looks shaky. Okay, I tested against the older 3.23.49 and cannot reproduce this. HTH, Benjamin. -- [EMAIL PROTECTED] - 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
Segmentation fault when using MySQL++
Hi all,
I am now writing an C++ application with the use of
MySQL. When I follow the tutorial in MySQL++ manual,
the application go into segmentation fault during
execution. What's the mistake I have made?
The followings are the codes and the error messages
during execution.
Codes:
#include iostream
#include iomanip
#include sqlplus.hh
using namespace std;
main()
{
cout Zeroth endl;
Connection con(db, host, name, password);
cout First endl;
Query query = con.query();
cout Second endl;
query select * from test;
cout Third endl;
Result res = query.store();
cout Fourth endl;
cout Query: query.preview() endl;
cout Fifth endl;
}
Error Message during Execution:
Zero
First
Second
Third
Segmentation fault
And the information from gdb about segmentation fault
is follow:
#0 0x4005f42f in SQLQuery::reset (this=0xbfffef48)
at sql_query1.hh:30
30 if (n = size()) insert(end(),(n+1) -
size(), );
I have tried both Red Hat 8.0 with g++ 3.2, MySQL
4.0, sqlplus 1.7.9, and Red Hat 7.3 with g++ 2.96,
MySQL 3.23, sqlplus 1.7.9
Thanks so much!
Regards,
Leo
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-
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
Segmentation fault
Hi all, I have two Linux Machine Redhat7.3 one for webserver and other for Database. first machine is loaded with apache1.3.27 with tomcat 4.1.12 and cummunicating using ajp13... my second machine is MySQL 3.23.43 DB Server... on my webserver I am using mm.mysql-2.0.9-bin.jar Driver Database is up and running.in my webserver I have written a java class that communicates with the DB server the code is able to Load and register the Driver and when the getConnection is executed the MySQL database is restarted ...the error message is below bin/safe_mysqld: line 273: 20449 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 Number of processes running now: 0 021216 14:42:05 mysqld restarted 021216 14:42:05 mysqld ended .how it can be solved thanks in advance Regards Laxmikanth M S Off : 91-80-6610330 extn 1256 http://www.sonata-software.com Coming together is the beginning, staying together is progress and working together is Success What lies behind us and what lies before us are tiny matters compared to what lies within us - Emerson * Disclaimer: The information in this e-mail and any attachments is confidential / privileged. It is intended solely for the addressee or addressees. If you are not the addressee indicated in this message, you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to Internet email for messages of this kind. * - 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
segmentation fault with mysql_num_rows - C API in Apache module
I am writing an Apache module that has to perform some queries against a
MySQL database. For the most part, it is working properly. However, when I
get an empty result set for my query (that is, the select returns no rows) I
get a segmentation fault when trying to call mysql_num_rows.
Here is the relevant part of my code:
if (mysql_query(mysql_handle, query) != 0) {
.bail out.
}
result=mysql_store_result(mysql_handle);
if (result) {
if (mysql_num_rows(result) == 1){
.process the row.
}
}
The segfault occurs during the call to mysql_num_rows.
I have also tried using mysql_affected_rows(mysql_handle) instead; this call
also segfaults.
Finally, I have tried mysql_use_result like this:
result = mysql_use_result(mysql_handle);
if (result) {
if (data = mysql_fetch_row(result)){
.process data.
}
}
And, you guessed it, the call to mysql_fetch_row segfaults.
If I isolate the MySQL code in a small test program (not an Apache module)
it works great. I'm guessing it has something to do with either Apache or
PHP, which I also have included as a DSO in Apache. I noticed the warning
about using the bundled MySQL support with PHP, so I re-compiled PHP using
the same libmysqlclient as my module - no change.
It seems as if mysql_[store/use]_result is returning a bad pointer when
there is an empty result set, but only inside an Apache module. If the
query returns rows, everything works fine - I can verify this by
inserting/deleting rows from the database and watching httpd either live or
die. I'm using 3.23.32-log on Linux. Any thoughts?
-
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
Segmentation Fault on remote connection
I have a few servers running MySQL and regularly (almost every web page!) connect from one to the other to update or query a remote database. I have never had any problems (love that mySQL) until I upgraded one of the systems and re-loaded the websites etc. Now, when I try to connect to the new system, from PHP or just using mySQL, I get a ang or a segmentation fault . Server - Mysql version 3.23.52-log - Suse 8.1 professional Client - Suse ?? - Mysql version 3.23.32 On server machine start up mysqld in the standard way ... mysql /etc/init.d/mysql start On client machine, try to connect mysql -h server -u user -pPassword Client hangs and server either kills all mysqld services or reports a segmentation fault Server /usr/bin/safe_mysqld: line 273: 28084 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 Number of processes running now: 3 mysqld process hanging, pid 28115 - killed mysqld process hanging, pid 28115 - killed mysqld process hanging, pid 28115 - killed 021121 17:14:06 mysqld restarted 021121 17:14:06 mysqld ended Any help gratefull receivd Regards Robert UK Theatre Web - www.uktw.co.uk Arts Archive- www.arts-archive.com DynamicListing - www.dynamiclisting.com A: New House, High Street, Fernham, Oxon, SN7 7NY T: 01367 820 828F: 01367 820 827 All information provided in good faith - 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
Segmentation fault when accessing mysql from non-local host
Description: I've installed mysql 3.23.52 from source on RedHat Linux 7.3 ... when I try to access the server from a non-local host, it gives the following error: /usr/local/mysql-3.23.52/bin/safe_mysqld: line 273: 5979 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 How-To-Repeat: That is a thing, that I don't know... Fix: It seems, that something is wrong with the dns query... I've put a line in /etc/hosts with the host from which I tried to access, and this solved the problem... This specific host had a real hostname, visible from the internet... Submitter-Id: submitter ID Originator:Lazics Organization: Bako-Szabo Laszlo SysAdmin SC. Nextra SRLhttp://www.nextra.ro Tel./Fax: 0266-171199, 0266-171200 MySQL support: none Synopsis: ... Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.52 (Source distribution) Environment: System: Linux lazics.nextra.ro 2.4.19 #5 Mon Oct 21 14:21:20 EEST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.3 2.96-112) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Oct 15 19:15 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x2 root root 1344152 Sep 9 17:02 /lib/libc-2.2.5.so -rw-r--r--1 root root 2312410 Sep 9 17:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 9 16:56 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql-3.23.52 - 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: Segmentation fault when accessing mysql from non-local host
Lazics, Tuesday, October 22, 2002, 10:03:25 AM, you wrote: Description: LI've installed mysql 3.23.52 from source on RedHat Linux 7.3 ... when I try to access the server from a non-local host, it gives the following error: L /usr/local/mysql-3.23.52/bin/safe_mysqld: line 273: 5979 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION L --pid-file=$pid_file --skip-locking $err_log 21 How-To-Repeat: LThat is a thing, that I don't know... Please, downgrade your glibc. glibc 2.2.5-40 is a cause of MySQL crashes. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Red Hat Network Updates cause segmentation fault in older versionsof MySQL 3.23
Red Hat Network users who have applied all recent critical updates will experience segmentation faults when accessing MySQL with remote clients (including MyODBC). Access from localhost seems to be OK. The solution is to upgrade to MySQL 3.23.53. At this time RedHat does not have updated 3.23.53 RPMS, so download the linux binaries from your nearest MySQL mirror. FYI, I have experienced this issue on RedHat 7.2 and 8.0 with the 2 most recent RedHat MySQL 3.23.xx RPMS. Hope this helps! Best, Lukas Bower - 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: Segmentation Fault when connecting via TCP/IP
clint, Wednesday, October 16, 2002, 1:14:08 AM, you wrote: caddn Recently the server had to be hard-booted... a safe shutdown was not possible. After the server came back up, mysql caddn has been acting very funny. When the server first boots, mysql wont respond to anything. I restart mysql and all works fine caddn when connecting to Localhost, however when you try to connect to the server via TCP/IP you get the following error on the caddn client : caddn [root@monitor bin]# ./mysqlshow -h www.dis.net -u root -p caddn Enter password: caddn ./mysqlshow: Lost connection to MySQL server during query caddn [root@monitor bin]# caddn At the same you do this on the client machine.. you get this on the host machine : caddn /usr/local/bin/safe_mysqld: line 269: 26209 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults caddn --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 caddn Number of processes running now: 1 caddn mysqld process hanging, pid 26212 - killed caddn 021015 14:54:14 mysqld restarted caddn I originally thought it may have something to do with the client.. but even a simple 'telnet www.host.com 3306' will produce caddn the same error on the server. caddn I tried starting mysql directly (without using safe_mysqld) by using /usr/local/libexec/mysqld --user=root. When I did this, caddn it caddn didnt spit out an error on the client side, but it does cause a segmentation fault on the server with no additional warnings caddn or logs. After that the server fails to respond to anything. caddn I have re-installed mysql from a secured distribution, so I know it doesnt have anything to do with any tampering. I have run caddn checks on all of the databases and they all seem fine. Also, everything works fine when connecting with a UNIX socket caddn (Localhost), the problem only appears when connecting with TCP/IP. What do you mean secured distribution? Re-intsall MySQL from binary distribution and let us know if it appears again. -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Segmentation Fault when connecting via TCP/IP
Description: Recently the server had to be hard-booted... a safe shutdown was not possible. After the server came back up, mysql has been acting very funny. When the server first boots, mysql wont respond to anything. I restart mysql and all works fine when connecting to Localhost, however when you try to connect to the server via TCP/IP you get the following error on the client : [root@monitor bin]# ./mysqlshow -h www.dis.net -u root -p Enter password: ./mysqlshow: Lost connection to MySQL server during query [root@monitor bin]# At the same you do this on the client machine.. you get this on the host machine : /usr/local/bin/safe_mysqld: line 269: 26209 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 Number of processes running now: 1 mysqld process hanging, pid 26212 - killed 021015 14:54:14 mysqld restarted I originally thought it may have something to do with the client.. but even a simple 'telnet www.host.com 3306' will produce the same error on the server. I tried starting mysql directly (without using safe_mysqld) by using /usr/local/libexec/mysqld --user=root. When I did this, it didnt spit out an error on the client side, but it does cause a segmentation fault on the server with no additional warnings or logs. After that the server fails to respond to anything. I have re-installed mysql from a secured distribution, so I know it doesnt have anything to do with any tampering. I have run checks on all of the databases and they all seem fine. Also, everything works fine when connecting with a UNIX socket (Localhost), the problem only appears when connecting with TCP/IP. How-To-Repeat: Connect to the server via TCP/IP Fix: No Clue. Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] Organization: Digital Internet Services Corporation MySQL support: none Synopsis: Server crashes on connect via TCP/IP. Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.41 (Source distribution) Environment: System: Linux www.dis.net 2.4.9-31 #1 Tue Feb 26 07:11:02 EST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-85) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Oct 7 09:33 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1285884 Sep 9 09:10 /lib/libc-2.2.4.so -rw-r--r--1 root root 27336078 Sep 9 08:48 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 9 08:48 /usr/lib/libc.so Configure command: ./configure - 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: mysqld --help - Segmentation fault
sitnikov, Friday, August 30, 2002, 8:34:03 PM, you wrote: Description: s Segmentation fault when starti mysqld with --help How-To-Repeat: s mysqld --help I tested it and mysqld --help worked without any problem. Today Michael Tam reported about crush if he used bind-address option. Did you use bind-address option? If no, could you provide contents of my.cnf file? s Server version: mysql-4.0.3-beta-pc-linux-gnu-i686 Environment: s System: Linux gap 2.4.18 #3 SMP Fri Mar 15 14:40:03 EET 2002 i686 unknown s Architecture: i686 s Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc s GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs s gcc version 2.95.3 20010315 (SuSE) s Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro ' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='-static' s LIBC: s -rwxr-xr-x1 root root 1384040 Jul 14 16:43 /lib/libc.so.6 s -rw-r--r--1 root root 25214756 Dec 18 2001 /usr/lib/libc.a s -rw-r--r--1 root root 178 Dec 18 2001 /usr/lib/libc.so s Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client s --enable-local-infile --enable-assembler --with-other-libc=/usr/local/mysql-glibc --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared 'CFLAGS=-O2 -mcpu=pentiumpro s ' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' CXX=gcc LDFLAGS=-static -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
mysqld --help - Segmentation fault
Description: Segmentation fault when starti mysqld with --help How-To-Repeat: mysqld --help Server version: mysql-4.0.3-beta-pc-linux-gnu-i686 Environment: System: Linux gap 2.4.18 #3 SMP Fri Mar 15 14:40:03 EET 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro ' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='-static' LIBC: -rwxr-xr-x1 root root 1384040 Jul 14 16:43 /lib/libc.so.6 -rw-r--r--1 root root 25214756 Dec 18 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Dec 18 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-local-infile --enable-assembler --with-other-libc=/usr/local/mysql-glibc --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared 'CFLAGS=-O2 -mcpu=pentiumpro ' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' CXX=gcc LDFLAGS=-static - 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: mysqlhotcopy problem - Segmentation fault
On Wed, Aug 28, 2002 at 04:50:22PM -0400, Mihail Manolov wrote: I have strange problem - I get Segmentation fault error when I am trying to execute mysqlhotcopy. When I remove the [mysqlhotcopy] section in my /etc/my.cnf configuration it works. Meanwhile, on another server it works just fine with the same configuration file. Do both servers have the same MySQL version installed? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 22 days, processed 469,104,809 queries (236/sec. avg) - 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: mysqlhotcopy problem - Segmentation fault
Yes, both run 3.23.49a - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Mihail Manolov [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 3:24 AM Subject: Re: mysqlhotcopy problem - Segmentation fault On Wed, Aug 28, 2002 at 04:50:22PM -0400, Mihail Manolov wrote: I have strange problem - I get Segmentation fault error when I am trying to execute mysqlhotcopy. When I remove the [mysqlhotcopy] section in my /etc/my.cnf configuration it works. Meanwhile, on another server it works just fine with the same configuration file. Do both servers have the same MySQL version installed? - 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
mysqlhotcopy problem - Segmentation fault
I have strange problem - I get Segmentation fault error when I am trying to execute mysqlhotcopy. When I remove the [mysqlhotcopy] section in my /etc/my.cnf configuration it works. Meanwhile, on another server it works just fine with the same configuration file. There is nothing fancy in the my.cnf file - I have the default configuration for mysqlhotcopy: [mysqlhotcopy] interactive-timeout Any ideas? Does anyone has had such problem? It's not critical, but it's strange. Mihail Manolov Government Liquidation, LLC 202 467 6868 x.227 [EMAIL PROTECTED] www.govliquidation.com sql query - 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
mysqlhotcopy problem - Segmentation fault
I have strange problem - I get Segmentation fault error when I am trying to execute mysqlhotcopy. When I remove the [mysqlhotcopy] and [client] sections in my /etc/my.cnf configuration it works. Meanwhile, on another server it works just fine with the same configuration file. There is nothing fancy in the my.cnf file - I have the default configuration for mysqlhotcopy: [mysqlhotcopy] interactive-timeout Any ideas? Does anyone has had such problem? It's not critical, but it's strange. Mihail Manolov Government Liquidation, LLC 202 467 6868 x.227 [EMAIL PROTECTED] www.govliquidation.com sql, query, mysql - 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
Segmentation Fault
Hello All, I m using linux and gcc complier. Myodbc driver and itz APIs working fine in my application to manipulate the database. I m having one problem. First i run query Select id...from ... then I use SQLBindCol to bind the columns after that i use SQLFetch to fetch the rowset. then i use SQLFreeStmt with SQL_UNBIND and SQL_CLOSE one by one. at the time of disconnect i use SQLFreeStmt with SQL_DROP. all the fuction in this sequence does work. but when i use query Select * from It does not work and gives Segmentation fault in the function SQLFreeStmt with SQL_CLOSE, if i comment this, it gives with SQLFreeStmt with SQL_DROP I m unable to catch the cause, can anyone help me to come out this problem. Thanx in advance. Rgds, Jenny __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - 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: Segmentation Fault on mysqladmin
On Friday 26 April 2002 08:19 pm, [EMAIL PROTECTED] wrote:
Description:
After installing MySQL on my RedHat Linux 7.2 server with
MySQL-3.23.49a-1.i386.rpm I can't run mysqladmin. mysqladmin with any
parameter results in a segmentation fault and core dump. I can run mysql and
connect to the test database just fine. Here is the output from strace
mysqladmin version:
strace mysqladmin version
execve(/usr/bin/mysqladmin, [mysqladmin, version], [/* 31 vars */]) =
0
fcntl64(0, F_GETFD) ? ? ? ? ? ? ? ? ? ? = 0
fcntl64(1, F_GETFD) ? ? ? ? ? ? ? ? ? ? = 0
fcntl64(2, F_GETFD) ? ? ? ? ? ? ? ? ? ? = 0
geteuid32() ? ? ? ? ? ? ? ? ? ? ? ? ? ? = 0
getuid32() ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?= 0
getegid32() ? ? ? ? ? ? ? ? ? ? ? ? ? ? = 0
getgid32() ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?= 0
brk(0) ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?= 0x80fc44c
brk(0x80fc46c) ? ? ? ? ? ? ? ? ? ? ? ? ?= 0x80fc46c
brk(0x80fd000) ? ? ? ? ? ? ? ? ? ? ? ? ?= 0x80fd000
open(/etc/nsswitch.conf, O_RDONLY) ? ?= 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=1782, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x4000
read(3, #\n# /etc/nsswitch.conf\n#\n# An ex..., 4096) = 1782
--- SIGSEGV (Segmentation fault) ---
+++ killed by SIGSEGV +++
Aaron:
Thanks for the bug report. We are aware of the problem - it is caused by a
bug in our glibc patch to avoid dynamic library loading for DNS resolution. A
workaround is to remove all names from /etc/nsswitch.conf that are not
files, dns and are less than 5 characters long (eg db, or nis)
--
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/?ref=mspa
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
___/
-
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
Segmentation Fault on mysqladmin
Description:
After installing MySQL on my RedHat Linux 7.2 server with MySQL-3.23.49a-1.i386.rpm I
can't run mysqladmin. mysqladmin with any parameter results in a segmentation fault
and core dump. I can run mysql and connect to the test database just fine. Here is the
output from strace mysqladmin version:
strace mysqladmin version
execve(/usr/bin/mysqladmin, [mysqladmin, version], [/* 31 vars */]) = 0
fcntl64(0, F_GETFD) = 0
fcntl64(1, F_GETFD) = 0
fcntl64(2, F_GETFD) = 0
geteuid32() = 0
getuid32() = 0
getegid32() = 0
getgid32() = 0
brk(0) = 0x80fc44c
brk(0x80fc46c) = 0x80fc46c
brk(0x80fd000) = 0x80fd000
open(/etc/nsswitch.conf, O_RDONLY)= 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=1782, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
0x4000
read(3, #\n# /etc/nsswitch.conf\n#\n# An ex..., 4096) = 1782
--- SIGSEGV (Segmentation fault) ---
+++ killed by SIGSEGV +++
How-To-Repeat:
just run mysqladmin with any options
Fix:
Submitter-Id: submitter ID
Originator:Aaron Newcomb
Organization:
MySQL support: none
Synopsis: mysqladmin causes segmentation fault
Severity: serious
Priority: medium
Category: mysql
Class: support
Release: mysql-3.23.49a (Official MySQL RPM)
Environment:
System: Linux ns2.newcombnet.com 2.4.9-31 #1 Tue Feb 26 06:25:35 EST 2002 i586 unknown
Architecture: i586
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-85)
Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc'
CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root 13 Nov 30 08:31 /lib/libc.so.6 - libc-2.2.4.so
-rwxr-xr-x2 root root 5723311 Dec 8 09:04 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27314296 Dec 8 09:02 /usr/lib/libc.a
-rw-r--r--1 root root 178 Dec 8 09:02 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc
--without-berkeley-db --without-innodb --enable-assembler --enable-local-infile
--with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man
'--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer
-mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' CXX=gcc
-
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
Segmentation Fault when connecting using DBI and option file
Description: When connecting to mysql database using Perl DBI AND specifying a mysql_read_default_file, this causes a Segmentation Fault. However if a mysql_read_default_file is not used then no error occurs. Linux version is 7.2 Redhat and DBI and DBD-mysql were installed from redhat.com and installed without errors. How-To-Repeat: #!/usr/local/bin/perl -w use DBI; my $dbh= DBI-connect(DBI:mysql:buxt;mysql_read_default_file=/home/buxton/main.cnf); main.cnf contains [client] user=test password=testpass Fix: put User and Password in connect statement Submitter-Id: submitter ID Originator: Ray Norrish, [EMAIL PROTECTED] Organization: Portjile Pty Ltd MySQL support: None Synopsis: Connect fails using DBI when a options file is specified (Core Dump) Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.49a (Official MySQL RPM) Environment: Pentium based server running Redhat 7.2 libraries: perl-Digest-MD5-2.13-1 perl-MIME-Base64-2.12-6 perl-libwww-perl-5.53-3 perl-libxml-perl-0.07-5 groff-perl-1.17.2-7.0.2 perl-CPAN-1.59_54-26.72.3 perl-DBI-1.14-10 perl-DateManip-5.39-5 perl-HTML-Tagset-3.03-3 perl-libnet-1.0703-6 perl-Parse-Yapp-1.04-3 perl-URI-1.12-5 perl-XML-Encoding-1.01-2 perl-XML-Parser-2.30-7 perl-libxml-enno-1.02-5 perl-XML-Twig-2.02-2 perl-DB_File-1.75-26.72.3 mod_perl-1.26-2 perl-DBD-MySQL-1.2215-1 perl-5.6.1-26.72.3 perl-CGI-2.752-26.72.3 perl-HTML-Parser-3.25-2 perl-Storable-0.6.11-6 perl-XML-Grove-0.46alpha-3 perl-XML-Dumper-0.4-5 perl-SGMLSpm-1.03ii-4 perl-NDBM_File-1.75-26.72.3 System: Linux amulet.com.au 2.4.18 #1 SMP Mon Mar 18 13:50:53 EST 2002 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jan 24 17:01 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1283964 Dec 9 01:14 /lib/libc-2.2.4.so -rw-r--r--1 root root 27314296 Dec 9 01:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Dec 9 01:02 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' CXX=gcc - 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: Segmentation Fault when connecting using DBI and option file
--- [EMAIL PROTECTED] wrote: Description: When connecting to mysql database using Perl DBI AND specifying a mysql_read_default_file, this causes a Segmentation Fault. However if a mysql_read_default_file is not used then no error occurs. Linux version is 7.2 Redhat and DBI and DBD-mysql were installed from redhat.com and installed without errors. How-To-Repeat: #!/usr/local/bin/perl -w use DBI; my $dbh= DBI-connect(DBI:mysql:buxt;mysql_read_default_file=/home/buxton/main.cnf); Why don't you try this: --- require 'database.cfg'; # Try to connect to the database or exit with message Can't create access to database $dbh = DBI-connect(DBI:mysql:$DSN, $mySQL_user, $mySQL_password) or die Can't create access to database: $DSN.BR\n; --- * database.cfg $DSN= buxt; $mySQL_user = test; $mySQL_password = testpass; --- main.cnf contains [client] user=test password=testpass Fix: put User and Password in connect statement Submitter-Id:submitter ID Originator: Ray Norrish, [EMAIL PROTECTED] Organization: Portjile Pty Ltd MySQL support: None Synopsis: Connect fails using DBI when a options file is specified (Core Dump) Severity: serious Priority: medium Category: mysql Class:sw-bug Release: mysql-3.23.49a (Official MySQL RPM) Environment: Pentium based server running Redhat 7.2 libraries: perl-Digest-MD5-2.13-1 perl-MIME-Base64-2.12-6 perl-libwww-perl-5.53-3 perl-libxml-perl-0.07-5 groff-perl-1.17.2-7.0.2 perl-CPAN-1.59_54-26.72.3 perl-DBI-1.14-10 perl-DateManip-5.39-5 perl-HTML-Tagset-3.03-3 perl-libnet-1.0703-6 perl-Parse-Yapp-1.04-3 perl-URI-1.12-5 perl-XML-Encoding-1.01-2 perl-XML-Parser-2.30-7 perl-libxml-enno-1.02-5 perl-XML-Twig-2.02-2 perl-DB_File-1.75-26.72.3 mod_perl-1.26-2 perl-DBD-MySQL-1.2215-1 perl-5.6.1-26.72.3 perl-CGI-2.752-26.72.3 perl-HTML-Parser-3.25-2 perl-Storable-0.6.11-6 perl-XML-Grove-0.46alpha-3 perl-XML-Dumper-0.4-5 perl-SGMLSpm-1.03ii-4 perl-NDBM_File-1.75-26.72.3 System: Linux amulet.com.au 2.4.18 #1 SMP Mon Mar 18 13:50:53 EST 2002 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jan 24 17:01 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1283964 Dec 9 01:14 /lib/libc-2.2.4.so -rw-r--r--1 root root 27314296 Dec 9 01:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Dec 9 01:02 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' CXX=gcc - 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 __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ - 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
Segmentation fault in MySQL database on Solaris2.8 for Intel.
Hi, After following the procedure on the web site for installing the MySQL database on Solaris machine we encountered Segmentation fault (during the Configuring mySQL for your machine step). Please help me with this. Regards, Prachi. - 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
Segmentation fault and core dump at daemon startup
Description: Whenever I try to start up the daemon it gives a 'Segmentation fault core dumped' message and shuts down. How-To-Repeat: Just try to start the daemon up Fix: ? Submitter-Id: [EMAIL PROTECTED] Originator: [EMAIL PROTECTED] Organization: none MySQL support: none Synopsis: Segmentation fault and core dump at daemon startup Severity: critical Priority: high Category: mysql Class:sw-bug Release: mysql-3.22.32 (Official MySQL RPM) Environment: Alpha noname, linux System: Linux 2.4.0 #3 Wed Mar 20 19:01:07 WET 2002 alpha unknown Architecture: alpha Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/local/bin/gcc GCC: Reading specs from /usr/local/lib/gcc-lib/alpha-unknown-linux-gnu/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='egcs' CFLAGS=' -O6 -fomit-frame-pointer' CXX='egcs' CXXFLAGS=' -O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' Perl: This is perl, version 5.004_04 built for alpha-linux - 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
Segmentation Fault at run-all-tests¹ script..
Hey all, Just did a compile and install of v4.01 for multiprocessor Sparc. Server has started, runs OK, have fiddled with privileges successfully... Naturally, next step: I¹d like to test everything. But now, I get a Segmentation Fault immediately at run-all-tests¹ script in sql-bench. Any ideas? Lou - 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
Segmentation fault - core dumped on Solaris 8 x86
Adolfo, Saturday, January 26, 2002, 6:52:20 PM, you wrote: AEZ I have instaled MYSQL on Solaris 2.8 on Intel plataform, and did this AEZ as says the manual, but when try to run it sends a message : AEZ Segmentation fault - core dumped AEZ # bin/safe_mysqld --user=mysql AEZ # Starting mysqld daemon with databases from /usr/local/mysql/data AEZ Segmentation Fault - core dumped AEZ 020126 09:43:39 mysqld ended AEZ # AEZ I found a mail similar to this in the mailing list, but did not found AEZ the answer. AEZ can you help me ? Have you compiled by yourself or you've got the binary distribution that is downloadable from MySQL website? Which version are you running? -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Segmentation fault - core dumped on Solaris 8 x86
I have instaled MYSQL on Solaris 2.8 on Intel plataform, and did this as says the manual, but when try to run it sends a message : Segmentation fault - core dumped # bin/safe_mysqld --user=mysql # Starting mysqld daemon with databases from /usr/local/mysql/data Segmentation Fault - core dumped 020126 09:43:39 mysqld ended # I found a mail similar to this in the mailing list, but did not found the answer. can you help me ? Thanks four your help. - 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
Segmentation fault on startup after fresh install
Hi, I've just installed MySQL 3.23 binary on Solaris. When I try: bin/safe_mysqld it crashes out like this: bash-2.03# bin/safe_mysqld [2] 9106 bash-2.03# Starting mysqld daemon with databases from /export/mysql-3.23.39-pc-solaris2.8-i386/data Segmentation Fault - core dumped 020122 14:18:52 mysqld ended [2]+ Donebin/safe_mysqld Any ideas?? (I followed the INSTALL-BINARY instructions, including using GNU's tar instead of Sun's) regards, - Kev ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Becta www.mimesweeper.com ** - 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: mysql client exits with core dump segmentation fault
Bill Kurland writes: Thanks for the reply. gcc and g++ are both version 2.95.3 I've tried installing three different binaries, one from the mysql site and two different versions from the Bull site. All failed with different problems on this machine so I tired them all on a different model machine, but running the same version of AIX. They failed with the same problems. So, I figured I'd try building it for the specific machine Bill Kurland Shakespeare Co. 138 Watts Street New York, NY 10013 212.965.9683 x814 212.965.9884 fax [EMAIL PROTECTED] Please follow my other advices: First CXX should be gcc with 2.95.*. Second, your CPU type might be wrong. You could leave up to GCC to discover a proper CPU type that you have. Other possible cause is misconfiguration of AIX. Either due to TCP/IP, running of file descriptors, sockets etc ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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: mysql client exits with core dump segmentation fault
[EMAIL PROTECTED] writes: Description: ##After building mysql and installing the GRANT tables I start the daemon ##and then try to run the mysql client to alter the GRANT tables to a ##useful configuration. Subcommands like connect and use seem to work ##ok, but if I try entering anything else, even a single character, I get ##a core dump. Following is screen output from a session run via gdb: watts:/usr/local/mysql/bin $ gdb mysql GNU gdb 5.0 Copyright 2000 Free Software Foundation, Inc. ... (gdb) run -uroot -p mysql Starting program: /usr/local/mysql/bin/mysql -uroot -p mysql Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A [skip] Hi! Problems that you are experiencing are most likely a consequence of the bad build. First CXX should be gcc with 2.95.*. Second, your CPU type might be wrong. You could leave up to GCC to discover a proper CPU type that you have. You would be better if you could find a binary for your OS / CPU. Other possible cause is misconfiguration of AIX. Either due to TCP/IP, running of file descriptors, sockets etc ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql client exits with core dump segmentation fault
Thanks for the reply. gcc and g++ are both version 2.95.3 I've tried installing three different binaries, one from the mysql site and two different versions from the Bull site. All failed with different problems on this machine so I tired them all on a different model machine, but running the same version of AIX. They failed with the same problems. So, I figured I'd try building it for the specific machine On Saturday, January 5, 2002, at 08:44 AM, Sinisa Milivojevic wrote: [EMAIL PROTECTED] writes: Description: ## After building mysql and installing the GRANT tables I start the daemon ## and then try to run the mysql client to alter the GRANT tables to a ## useful configuration. Subcommands like connect and use seem to work ## ok, but if I try entering anything else, even a single character, I get ## a core dump. Following is screen output from a session run via gdb: watts:/usr/local/mysql/bin $ gdb mysql GNU gdb 5.0 Copyright 2000 Free Software Foundation, Inc. ... (gdb) run -uroot -p mysql Starting program: /usr/local/mysql/bin/mysql -uroot -p mysql Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A [skip] Hi! Problems that you are experiencing are most likely a consequence of the bad build. First CXX should be gcc with 2.95.*. Second, your CPU type might be wrong. You could leave up to GCC to discover a proper CPU type that you have. You would be better if you could find a binary for your OS / CPU. Other possible cause is misconfiguration of AIX. Either due to TCP/IP, running of file descriptors, sockets etc ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com Bill Kurland Shakespeare Co. 138 Watts Street New York, NY 10013 212.965.9683 x814 212.965.9884 fax [EMAIL PROTECTED] - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql client exits with core dump segmentation fault
Description: ## After building mysql and installing the GRANT tables I start the daemon ## and then try to run the mysql client to alter the GRANT tables to a ## useful configuration. Subcommands like connect and use seem to work ## ok, but if I try entering anything else, even a single character, I get ## a core dump. Following is screen output from a session run via gdb: watts:/usr/local/mysql/bin $ gdb mysql GNU gdb 5.0 Copyright 2000 Free Software Foundation, Inc. ... (gdb) run -uroot -p mysql Starting program: /usr/local/mysql/bin/mysql -uroot -p mysql Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.47-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show table Program received signal SIGSEGV, Segmentation fault. 0xe0002fa0 in ?? () from (unknown load module) (gdb) q The program is running. Exit anyway? (y or n) y ## If I then try to shutdown the server, which is PID 46736: watts:/usr/local/mysql/bin $ ps PIDTTY TIME CMD 43818 pts/22 0:00 sh safe_mysqld --log 46736 pts/22 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql 53986 pts/22 0:00 -ksh 58540 pts/22 0:00 ps watts:/usr/local/mysql/bin $ mysqladmin -uroot -p shutdown Enter password: ## mysqladmin just sits at this point until I break out. ^CWarning; Aborted waiting on pid file: '/u/dev/mysql/watts.pid' after 54 seconds ## I then try shutting down again, this time apparently with success, but watts:/usr/local/mysql/bin $ mysqladmin -uroot -p shutdown Enter password: watts:/usr/local/mysql/bin $ watts:/usr/local/mysql/bin $ watts:/usr/local/mysql/bin $ ps PIDTTY TIME CMD 43818 pts/22 0:00 sh safe_mysqld --log 46736 pts/22 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql 53986 pts/22 0:00 -ksh 57260 pts/22 0:00 ps ## the process is still there. ## Following is the contents of the log file: /usr/local/mysql/libexec/mysqld, Version: 3.23.47-log, started with: Tcp port: 3306 Unix socket: /var/mysql/sock/mysql.sock Time Id CommandArgument 020104 19:37:23 1 Connect root@localhost on mysql 1 Query show databases 1 Query show tables 1 Field List columns_priv 1 Field List db 1 Field List func 1 Field List host 1 Field List tables_priv 1 Field List user 020104 19:39:28 2 Connect root@localhost on 2 Query SHOW VARIABLES LIKE 'pid_file' 2 Shutdown 020104 19:40:27 3 Connect root@localhost on 3 Query SHOW VARIABLES LIKE 'pid_file' 3 Shutdown ## ... and of the error log: 020104 19:36:59 mysqld started Warning: One can only use the --user switch if running as root /usr/local/mysql/libexec/mysqld: ready for connections 020104 19:40:27 mysqld: Got error 9 from select 020104 19:40:27 /usr/local/mysql/libexec/mysqld: Normal shutdown 020104 19:40:28 /usr/local/mysql/libexec/mysqld: Shutdown Complete How-To-Repeat: This happens consistently. You don't need to use an actual SQL command to crash the client any string that is not a subcommand of the client seems to do it Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator: Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.47 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: AIX watts 3 4 00600079C400 IBM rs/6000 7025-F30 AIX 4.3.3.0 Because I had read that there were problems with AIX's libc.a I tried applying the following fixes after first encountering the above problem. I did not rebuild after applying the fixes because I didn't know if it was necessary or useful. bos.rte.bind_cmds.4.3.3.75.bff bos.rte.libc.4.3.3.75.bff bos.rte.libc.4.3.3.79.bff bos.rte.libpthreads.4.3.3.75.bff bos.rte.libpthreads.4.3.3.77.bff Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gcc I used the GNU make program instead of IBM's - or thought I did. Does the above path indicate what was actually used
problem with starting mysql server + segmentation fault
hi, I have installed mysql3.23.39 on solaris2.8. but,when I try to run the server, I am getting segmentation fault.can anybody help me..? I have followed instructions as given in the php manual. shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip mysql-3.23.39-pc-solaris2.8-i386.tar.gz shell./gtar-i386 xvf mysql-3.23.39-pc-solaris2.8-i386.tar shell ln -s mysql-3.23.39-pc-solaris2.8-i386 mysql shell cd mysql shell scripts/mysql_install_db shell chown -R root /usr/local/mysql shell chown -R mysql /usr/local/mysql/data shell chgrp -R mysql /usr/local/mysql shell chown -R root /usr/local/mysql/bin shell bin/safe_mysqld --user=mysql 9800 shell Starting mysqld daemon with databases from /usr/local/mysql-3.23.39-pc-solaris2.8-i386/data Segmentation Fault - core dumped 011019 17:52:28 mysqld ended regards prasad - 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
segmentation fault post mysql server binary install for solaris-i386
I am getting a segmentation fault on a solaris i86pc when executing either with: ./bin/safe_mysqld ./bin/mysql -h active_mysql_host On this solaris i86pc, I got the following binary install: mysql-3.23.39-pc-solaris2.8-i386.tar.gz Then untarred it with GNU tar (gtar-i386). The uname -X output for my target machine is: System=SunOS Release=5.8 Kernel=Generic_108529-06 Machine=i86pc NumCPU=2 I have done a binary install before of MySQL onto a solaris-sparc. Did I get the wrong binary? Thanks Jeff Tanner Seattle, WA - 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
Segmentation fault with mysql_install_db
Hello I am trying to install the lastest version of mysql on Linux (Suse, uname -r = 2.2.14), without success. I have downloaded both the 3.23.38 and 3.23.40 binary tar balls, they crash the same way (I have tried on several machines with the same configuration, and got the same result): ./scripts/mysql_install_db Installing all prepared tables ./scripts/mysql_install_db: line 1: 2821 Segmentation fault ./bin/mysqld --bootstrap --skip-grant-tables --basedir=. --datadir=./data --skip-innodb --skip-gemini --skip-bdb Installation of grant tables failed! A 3.22 version of mysql runs fine on these machines. Also, I tried to copy the whole data directory from my 3.22 version to the new 3.23, and I have been able to launch safe_mysqld, but it crashed a bit later with segmentation fault. I have noticed several people having the same kind of problem (for example: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:67632) but could not get any solution. I hope one of you will able to give me a clue... Thanks a lot in advance! Bernard - 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: Segmentation fault with mysql_install_db
On Wednesday 01 August 2001 10:13, Bernard Bross wrote: Hello I am trying to install the lastest version of mysql on Linux (Suse, uname -r = 2.2.14), without success. I have downloaded both the 3.23.38 and 3.23.40 binary tar balls, they crash the same way (I have tried on several machines with the same configuration, and got the same result): ./scripts/mysql_install_db Installing all prepared tables ./scripts/mysql_install_db: line 1: 2821 Segmentation fault ./bin/mysqld --bootstrap --skip-grant-tables --basedir=. --datadir=./data --skip-innodb --skip-gemini --skip-bdb Installation of grant tables failed! A 3.22 version of mysql runs fine on these machines. Also, I tried to copy the whole data directory from my 3.22 version to the new 3.23, and I have been able to launch safe_mysqld, but it crashed a bit later with segmentation fault. I have noticed several people having the same kind of problem (for example: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:67632) but could not get any solution. This is a known problem. Solution is to upgrade the kernel to the one from a later SuSE distribution, or just use a virgin kernel from www.kernel.org. As you may already know, many distributions applies their own set of patches ( aka hacks) to the kernel that is release by Linus. So did SuSE with 2.2.14, and they decided that it would be a good idea to send SIGSEGV to every application that expands the stack in a way that makes it approach withing 512K of an already mapped page. Then they realized it was not such a good idea, and fixed it in later releases. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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
segmentation fault
Hi, I am a just a solaris newbie. I tried installing mySQL 3.23.39 on solaris 8 (intel). I followed these steps(I used GNU tar): #groupadd mysql #useradd -g mysql mysql #cd /usr/local #gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - #ln -s mysql-VERSION-OS mysql #cd mysql #scripts/mysql_install_db #chown -R root /usr/local/mysql #chown -R mysql /usr/local/mysql/data #chgrp -R mysql /usr/local/mysql #chown -R root /usr/local/mysql/bin #bin/safe_mysqld --user=mysql And this happened: 1759 # Starting mysqld daemon with databases from /usr/local/mysql-3.23.39-pc-solaris 2.8-i386/data Segmentation Fault - core dumped 010711 16:21:08 mysqld ended Can anybody help? Breugh __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - 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: segmentation fault
Maybe it's about time you stopped being a fuckwit and read the whole message dip shit. file://Kris -Original Message- From: Gerald Clark [EMAIL PROTECTED] To: Breughel Macabuhay [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, 12 July 2001 12:36 Subject: Re: segmentation fault I really don't believe you downloaded mysql-VERSION-OS.tar.gz. How can anyone help you if you hide what you are doing? Breughel Macabuhay wrote: Hi, I am a just a solaris newbie. I tried installing mySQL 3.23.39 on solaris 8 (intel). I followed these steps(I used GNU tar): #groupadd mysql #useradd -g mysql mysql #cd /usr/local #gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - #ln -s mysql-VERSION-OS mysql #cd mysql #scripts/mysql_install_db #chown -R root /usr/local/mysql #chown -R mysql /usr/local/mysql/data #chgrp -R mysql /usr/local/mysql #chown -R root /usr/local/mysql/bin #bin/safe_mysqld --user=mysql And this happened: 1759 # Starting mysqld daemon with databases from /usr/local/mysql-3.23.39-pc-solaris 2.8-i386/data Segmentation Fault - core dumped 010711 16:21:08 mysqld ended Can anybody help? Breugh __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - 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 -- Gerald L. Clark [EMAIL PROTECTED] - 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 - 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: segmentation fault
Should people without a clean mouth or hands be expelled from the list? A mouse (or anykind) shit can ruin a whole dinner! Kris Amy wrote: Maybe it's about time you stopped being a fuckwit and read the whole message dip shit. file://Kris -Original Message- From: Gerald Clark [EMAIL PROTECTED] To: Breughel Macabuhay [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, 12 July 2001 12:36 Subject: Re: segmentation fault I really don't believe you downloaded mysql-VERSION-OS.tar.gz. How can anyone help you if you hide what you are doing? Breughel Macabuhay wrote: Hi, I am a just a solaris newbie. I tried installing mySQL 3.23.39 on solaris 8 (intel). I followed these steps(I used GNU tar): #groupadd mysql #useradd -g mysql mysql #cd /usr/local #gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - #ln -s mysql-VERSION-OS mysql #cd mysql #scripts/mysql_install_db #chown -R root /usr/local/mysql #chown -R mysql /usr/local/mysql/data #chgrp -R mysql /usr/local/mysql #chown -R root /usr/local/mysql/bin #bin/safe_mysqld --user=mysql And this happened: 1759 # Starting mysqld daemon with databases from /usr/local/mysql-3.23.39-pc-solaris 2.8-i386/data Segmentation Fault - core dumped 010711 16:21:08 mysqld ended Can anybody help? Breugh __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - 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 -- Gerald L. Clark [EMAIL PROTECTED] - 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 - 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 - 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: segmentation fault
First, I'd like to say that it's great that a Solaris for Intel version of the binaries are now available (or was it my poor eyesight that hadn't seen it before). There's a possibility that the fact that you've used a 'symbolic' link for /usr/local/mysql is causing a problem (though it works on Linux, so I can keep multiple versions of mysql in /usr/local). The error statement is showing the actual directory for the MySQL installation, and perhaps there's a conflict over 'where' you've told it to start, and where it's finding the actual files... Just a hunch (try removing the symbolic link, and renaming your MySQL directory to mysql) - Original Message - From: Breughel Macabuhay [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 11, 2001 12:43 AM Subject: segmentation fault Hi, I am a just a solaris newbie. I tried installing mySQL 3.23.39 on solaris 8 (intel). I followed these steps(I used GNU tar): #groupadd mysql #useradd -g mysql mysql #cd /usr/local #gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - #ln -s mysql-VERSION-OS mysql #cd mysql #scripts/mysql_install_db #chown -R root /usr/local/mysql #chown -R mysql /usr/local/mysql/data #chgrp -R mysql /usr/local/mysql #chown -R root /usr/local/mysql/bin #bin/safe_mysqld --user=mysql And this happened: 1759 # Starting mysqld daemon with databases from /usr/local/mysql-3.23.39-pc-solaris 2.8-i386/data Segmentation Fault - core dumped 010711 16:21:08 mysqld ended Can anybody help? Breugh __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - 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 - 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: segmentation fault
What is mysql-VERSION-OS.tar.gz? Breughel, did you really type that exact thing on the command line, because if you did, I believe the instructions you followed intended for you to replace the VERSION-OS with your actual VERSION and OS. For example: gunzip mysql-3.23.39-pc-solaris.tar.gz | tar xvf Perhaps you could provide an EXACT listing of what you typed, instead of one where you just approximate what you typed. It does look on the surface however, assuming that you did type everything correctly, that there is a problem with your binary file. Without more information however, it is difficult to say. And Gerald Clark, why couldn't you have been a little more kind in the way you asked for clarification? And Kris Amy, why couldn't you have been less foul-mouthed in your attempting to correct Gerald, and further more, why couldn't you have tried to help Breughel (assuming you are able)? Sheesh people, everyone on here is trying to help others out, and WITHOUT CHARGE - IT IS FOR FREE - this is not our job, and nobody, I mean nobody is obligated to help anyone at all, so can we please try to stay civil, and patient, and treat others like we would like to be treated? Thank you very much. Sincerely, Ken At 12:41 AM 7/12/01 +1000, Kris Amy wrote: Maybe it's about time you stopped being a fuckwit and read the whole message dip shit. file://Kris -Original Message- From: Gerald Clark [EMAIL PROTECTED] To: Breughel Macabuhay [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, 12 July 2001 12:36 Subject: Re: segmentation fault I really don't believe you downloaded mysql-VERSION-OS.tar.gz. How can anyone help you if you hide what you are doing? Breughel Macabuhay wrote: Hi, I am a just a solaris newbie. I tried installing mySQL 3.23.39 on solaris 8 (intel). I followed these steps(I used GNU tar): #groupadd mysql #useradd -g mysql mysql #cd /usr/local #gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - #ln -s mysql-VERSION-OS mysql #cd mysql #scripts/mysql_install_db #chown -R root /usr/local/mysql #chown -R mysql /usr/local/mysql/data #chgrp -R mysql /usr/local/mysql #chown -R root /usr/local/mysql/bin #bin/safe_mysqld --user=mysql And this happened: 1759 # Starting mysqld daemon with databases from /usr/local/mysql-3.23.39-pc-solaris 2.8-i386/data Segmentation Fault - core dumped 010711 16:21:08 mysqld ended Can anybody help? Breugh __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - 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 -- Gerald L. Clark [EMAIL PROTECTED] - 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 - 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 - 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: segmentation fault
Kenneth, thanx. I also wanted to say the same. Sorry if I made all of you a bit confused but I would just like you people to know that this part: #groupadd mysql #useradd -g mysql mysql #cd /usr/local #gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - #ln -s mysql-VERSION-OS mysql #cd mysql #scripts/mysql_install_db #chown -R root /usr/local/mysql #chown -R mysql /usr/local/mysql/data #chgrp -R mysql /usr/local/mysql #chown -R root /usr/local/mysql/bin #bin/safe_mysqld --user=mysql from the manual that came with the mysql-3.23.39-pc-solaris2.8-i386.tar.gz. I assumed that it was pretty obvious since I believe that all of you guys have read the manual before and I assumed this part: 1759 # Starting mysqld daemon with databases from /usr/local/mysql-3.23.39-pc-solaris2.8-i386/data Segmentation Fault - core dumped 010711 16:21:08 mysqld ended have obviously shown the mysql-VERSION-OS part. I only said that I am a solaris newbie but I have several years in linux system administration experience and these things for me are very obvious. Sorry for assuming. By the way, I also have also installed mysql in linux using another package of course and the same procedure and had no problems. Now, I want to test it in solaris (intel) box even if the documentations and the manuals stated that I'll get a lot of errors running mysql on solaris. I just thought that maybe some of you guys had already done it, perhaps have the same problems, and now are running mysql happily on a solaris(intel) platform. Please help me. I am really sorry for causing all the troubles... Breughel --- Kenneth Kopelson [EMAIL PROTECTED] wrote: What is mysql-VERSION-OS.tar.gz? Breughel, did you really type that exact thing on the command line, because if you did, I believe the instructions you followed intended for you to replace the VERSION-OS with your actual VERSION and OS. For example: gunzip mysql-3.23.39-pc-solaris.tar.gz | tar xvf Perhaps you could provide an EXACT listing of what you typed, instead of one where you just approximate what you typed. It does look on the surface however, assuming that you did type everything correctly, that there is a problem with your binary file. Without more information however, it is difficult to say. And Gerald Clark, why couldn't you have been a little more kind in the way you asked for clarification? And Kris Amy, why couldn't you have been less foul-mouthed in your attempting to correct Gerald, and further more, why couldn't you have tried to help Breughel (assuming you are able)? Sheesh people, everyone on here is trying to help others out, and WITHOUT CHARGE - IT IS FOR FREE - this is not our job, and nobody, I mean nobody is obligated to help anyone at all, so can we please try to stay civil, and patient, and treat others like we would like to be treated? Thank you very much. Sincerely, Ken At 12:41 AM 7/12/01 +1000, Kris Amy wrote: Maybe it's about time you stopped being a fuckwit and read the whole message dip shit. file://Kris -Original Message- From: Gerald Clark [EMAIL PROTECTED] To: Breughel Macabuhay [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, 12 July 2001 12:36 Subject: Re: segmentation fault I really don't believe you downloaded mysql-VERSION-OS.tar.gz. How can anyone help you if you hide what you are doing? Breughel Macabuhay wrote: Hi, I am a just a solaris newbie. I tried installing mySQL 3.23.39 on solaris 8 (intel). I followed these steps(I used GNU tar): #groupadd mysql #useradd -g mysql mysql #cd /usr/local #gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - #ln -s mysql-VERSION-OS mysql #cd mysql #scripts/mysql_install_db #chown -R root /usr/local/mysql #chown -R mysql /usr/local/mysql/data #chgrp -R mysql /usr/local/mysql #chown -R root /usr/local/mysql/bin #bin/safe_mysqld --user=mysql And this happened: 1759 # Starting mysqld daemon with databases from /usr/local/mysql-3.23.39-pc-solaris 2.8-i386/data Segmentation Fault - core dumped 010711 16:21:08 mysqld ended Can anybody help? Breugh __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - 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 -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http
Re: segmentation fault (problem solved)
Hi, I just solved my problem. I just installed the solaris package version(the older one 3.23.37) which I downloaded from the site that my japanese friend had referred. Sorry again for the trouble I caused you guys... Breughel --- Breughel Macabuhay [EMAIL PROTECTED] wrote: Kenneth, thanx. I also wanted to say the same. Sorry if I made all of you a bit confused but I would just like you people to know that this part: #groupadd mysql #useradd -g mysql mysql #cd /usr/local #gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - #ln -s mysql-VERSION-OS mysql #cd mysql #scripts/mysql_install_db #chown -R root /usr/local/mysql #chown -R mysql /usr/local/mysql/data #chgrp -R mysql /usr/local/mysql #chown -R root /usr/local/mysql/bin #bin/safe_mysqld --user=mysql from the manual that came with the mysql-3.23.39-pc-solaris2.8-i386.tar.gz. I assumed that it was pretty obvious since I believe that all of you guys have read the manual before and I assumed this part: 1759 # Starting mysqld daemon with databases from /usr/local/mysql-3.23.39-pc-solaris2.8-i386/data Segmentation Fault - core dumped 010711 16:21:08 mysqld ended have obviously shown the mysql-VERSION-OS part. I only said that I am a solaris newbie but I have several years in linux system administration experience and these things for me are very obvious. Sorry for assuming. By the way, I also have also installed mysql in linux using another package of course and the same procedure and had no problems. Now, I want to test it in solaris (intel) box even if the documentations and the manuals stated that I'll get a lot of errors running mysql on solaris. I just thought that maybe some of you guys had already done it, perhaps have the same problems, and now are running mysql happily on a solaris(intel) platform. Please help me. I am really sorry for causing all the troubles... Breughel --- Kenneth Kopelson [EMAIL PROTECTED] wrote: What is mysql-VERSION-OS.tar.gz? Breughel, did you really type that exact thing on the command line, because if you did, I believe the instructions you followed intended for you to replace the VERSION-OS with your actual VERSION and OS. For example: gunzip mysql-3.23.39-pc-solaris.tar.gz | tar xvf Perhaps you could provide an EXACT listing of what you typed, instead of one where you just approximate what you typed. It does look on the surface however, assuming that you did type everything correctly, that there is a problem with your binary file. Without more information however, it is difficult to say. And Gerald Clark, why couldn't you have been a little more kind in the way you asked for clarification? And Kris Amy, why couldn't you have been less foul-mouthed in your attempting to correct Gerald, and further more, why couldn't you have tried to help Breughel (assuming you are able)? Sheesh people, everyone on here is trying to help others out, and WITHOUT CHARGE - IT IS FOR FREE - this is not our job, and nobody, I mean nobody is obligated to help anyone at all, so can we please try to stay civil, and patient, and treat others like we would like to be treated? Thank you very much. Sincerely, Ken At 12:41 AM 7/12/01 +1000, Kris Amy wrote: Maybe it's about time you stopped being a fuckwit and read the whole message dip shit. file://Kris -Original Message- From: Gerald Clark [EMAIL PROTECTED] To: Breughel Macabuhay [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, 12 July 2001 12:36 Subject: Re: segmentation fault I really don't believe you downloaded mysql-VERSION-OS.tar.gz. How can anyone help you if you hide what you are doing? Breughel Macabuhay wrote: Hi, I am a just a solaris newbie. I tried installing mySQL 3.23.39 on solaris 8 (intel). I followed these steps(I used GNU tar): #groupadd mysql #useradd -g mysql mysql #cd /usr/local #gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - #ln -s mysql-VERSION-OS mysql #cd mysql #scripts/mysql_install_db #chown -R root /usr/local/mysql #chown -R mysql /usr/local/mysql/data #chgrp -R mysql /usr/local/mysql #chown -R root /usr/local/mysql/bin #bin/safe_mysqld --user=mysql And this happened: 1759 # Starting mysqld daemon with databases from /usr/local/mysql-3.23.39-pc-solaris 2.8-i386/data Segmentation Fault - core dumped 010711 16:21:08 mysqld ended Can anybody help? Breugh __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - Before posting, please check
Segmentation Fault - core dumped
hello I am trying to run a mysql data base on a sparc20 running solaris 2.6. The data base loads and works fine, but when I load Msql-Mysql-modules. I get a Segmentation Fault - core dumped . when I run a cgi script from the command line the data is obtained from the data base, but again I get the Segmentation Fault which causes an error in the apache web server. I have tried several versions of mysql, perl and modules with the same problem. Can anyone tell me what version to run or how to solve the seg problem. Thankyou bob - 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
mysql segmentation fault on starting
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mysqld segmentation fault on starting Description: mysqld segmentation fault on starting How-To-Repeat: # mysqld Segmentation Fault # ldd mysqld ldd: mysqld: execution failed due to signal 11 Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator: Organization: The University of Hong Kong MySQL support: none Synopsis: mysqld segmentation fault Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.39 (Official MySQL binary) Environment: Solaris 8 (Intel), Pentium II 400MHz System: SunOS alumni2.hkucs.org 5.8 Generic_108529-07 i86pc i386 i86pc Architecture: i86pc Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.8/3.0/specs Configured with: ../configure --disable-nls --disable-libgcj --enable-languages=c++,f77,objc --with-gnu-as --with-gnu-ld Thread model: posix gcc version 3.0 Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1586076 Jan 24 23:07 /lib/libc.a lrwxrwxrwx 1 root root 11 Jun 16 16:22 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 938916 Jan 24 23:07 /lib/libc.so.1 -rw-r--r-- 1 root bin 1586076 Jan 24 23:07 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jun 16 16:22 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 938916 Jan 24 23:07 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --disable-shared Perl: This is perl, version 5.005_03 built for i86pc-solaris - 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: mysql segmentation fault on starting
Hung Hing Fai wrote: Description: mysqld segmentation fault on starting How-To-Repeat: # mysqld Segmentation Fault # ldd mysqld ldd: mysqld: execution failed due to signal 11 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --disable-shared Perl: This is perl, version 5.005_03 built for i86pc-solaris Weird. Official MySQL binaries are all passed our pretty big and mature testsuite, so it should work.I am not trying to say that you are wrong :) but I would like to hear results if you download some other MySQL older version and try to execute it. Is there are any differences? Are you sure that your hardware is OK? I do not have access to Solaris-x86 now to test myself for this bug. If you can't find problem yourself then I am also located in Hong Kong and can try to solve this problem myself on your system. But I really want to avoid this if you are able to debug this stuff yourself. Tõnu - 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
segmentation fault with g++/cygwin/mysql
Hi all, I hava a little problem for developping a windows mysql client program in C++. I compile it using cygwin. there is no problem during the compilation but when I execute it, it seems that when I execute a select query and retrieve the data, it access memory that it shouldn't. I tested my program under linux and no problem. So, if somebody have an explication... I use Win 98 and cygwin 1.1.8 - 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: AIX segmentation fault with PHP, Apache and MySQL
Thanks everyone - it now all goes ! The problem I think was due to using a precompiled binary release of Apache that (I guess) had an exports file pointing to a library in the wrong place... Anyway building everything from sources did the job. Dave At 23:36 20/05/01 -0400, you wrote: Hmm. Can you be a bit more specific how you upgraded your Apache? Typically I've had good luck with building the new Apache first, then building PHP (using the new apxs that it installs). You are installing these modules as .so, correct? And building everything from source code? The only thing I can think of here is that your earlier Apache had a broken lib somewhere and the new installs are not replacing it.. Z On Sunday, May 20, 2001, at 10:15 PM, Dave Brooks, BCS Systems wrote: MySQL 3.23.38 made no difference Well we now have Apache 1.3.19 and PHP 4.0.5 but still the same problem... Am about to upgrade MySQL to 3.23.38 to see if this changes things, but feel this is clutching at straws... Thanks, Dave On Thursday, May 17, 2001, at 08:59 AM, Matthew P. Marino wrote: Apache is up to 1.3.17 at least. I would update apache and see what gives. PHP4 wasn't coded until Apache 1.3.15 was out. Dave Brooks, BCS Systems wrote: Hello, I am trying to port a PHP/MySQL application that happily runs under Linux across to an AIX box. We have MySQL is running under AIX - using mysql we can create tables, insert rows, etc and even access data via a C program. PHP is running as an Apache module - a simple phpinfo() works. If our PHP scripts are invoked when mysqld is not active we get a database error Can't connect to server, as to be expected. If however, mysqld is started and then we attempt our script, Apache reports a segmentation fault (as shown in its error logs) and the client browser gets an unexpected network error. Any ideas, debugging clues, etc would be much appreciated. AIX 4.3.3 Apache 1.3.12 (IBM HTTP Server) MySQL 3.23.32 PHP 4.0.4 pl 1 Many thanks, Dave Brooks - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: AIX segmentation fault with PHP, Apache and MySQL
Well we now have Apache 1.3.19 and PHP 4.0.5 but still the same problem... Am about to upgrade MySQL to 3.23.38 to see if this changes things, but feel this is clutching at straws... Thanks, Dave On Thursday, May 17, 2001, at 08:59 AM, Matthew P. Marino wrote: Apache is up to 1.3.17 at least. I would update apache and see what gives. PHP4 wasn't coded until Apache 1.3.15 was out. Dave Brooks, BCS Systems wrote: Hello, I am trying to port a PHP/MySQL application that happily runs under Linux across to an AIX box. We have MySQL is running under AIX - using mysql we can create tables, insert rows, etc and even access data via a C program. PHP is running as an Apache module - a simple phpinfo() works. If our PHP scripts are invoked when mysqld is not active we get a database error Can't connect to server, as to be expected. If however, mysqld is started and then we attempt our script, Apache reports a segmentation fault (as shown in its error logs) and the client browser gets an unexpected network error. Any ideas, debugging clues, etc would be much appreciated. AIX 4.3.3 Apache 1.3.12 (IBM HTTP Server) MySQL 3.23.32 PHP 4.0.4 pl 1 Many thanks, Dave Brooks - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: AIX segmentation fault with PHP, Apache and MySQL
MySQL 3.23.38 made no difference Well we now have Apache 1.3.19 and PHP 4.0.5 but still the same problem... Am about to upgrade MySQL to 3.23.38 to see if this changes things, but feel this is clutching at straws... Thanks, Dave On Thursday, May 17, 2001, at 08:59 AM, Matthew P. Marino wrote: Apache is up to 1.3.17 at least. I would update apache and see what gives. PHP4 wasn't coded until Apache 1.3.15 was out. Dave Brooks, BCS Systems wrote: Hello, I am trying to port a PHP/MySQL application that happily runs under Linux across to an AIX box. We have MySQL is running under AIX - using mysql we can create tables, insert rows, etc and even access data via a C program. PHP is running as an Apache module - a simple phpinfo() works. If our PHP scripts are invoked when mysqld is not active we get a database error Can't connect to server, as to be expected. If however, mysqld is started and then we attempt our script, Apache reports a segmentation fault (as shown in its error logs) and the client browser gets an unexpected network error. Any ideas, debugging clues, etc would be much appreciated. AIX 4.3.3 Apache 1.3.12 (IBM HTTP Server) MySQL 3.23.32 PHP 4.0.4 pl 1 Many thanks, Dave Brooks - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 - 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: AIX segmentation fault with PHP, Apache and MySQL
Hmm. Can you be a bit more specific how you upgraded your Apache? Typically I've had good luck with building the new Apache first, then building PHP (using the new apxs that it installs). You are installing these modules as .so, correct? And building everything from source code? The only thing I can think of here is that your earlier Apache had a broken lib somewhere and the new installs are not replacing it.. Z On Sunday, May 20, 2001, at 10:15 PM, Dave Brooks, BCS Systems wrote: MySQL 3.23.38 made no difference Well we now have Apache 1.3.19 and PHP 4.0.5 but still the same problem... Am about to upgrade MySQL to 3.23.38 to see if this changes things, but feel this is clutching at straws... Thanks, Dave On Thursday, May 17, 2001, at 08:59 AM, Matthew P. Marino wrote: Apache is up to 1.3.17 at least. I would update apache and see what gives. PHP4 wasn't coded until Apache 1.3.15 was out. Dave Brooks, BCS Systems wrote: Hello, I am trying to port a PHP/MySQL application that happily runs under Linux across to an AIX box. We have MySQL is running under AIX - using mysql we can create tables, insert rows, etc and even access data via a C program. PHP is running as an Apache module - a simple phpinfo() works. If our PHP scripts are invoked when mysqld is not active we get a database error Can't connect to server, as to be expected. If however, mysqld is started and then we attempt our script, Apache reports a segmentation fault (as shown in its error logs) and the client browser gets an unexpected network error. Any ideas, debugging clues, etc would be much appreciated. AIX 4.3.3 Apache 1.3.12 (IBM HTTP Server) MySQL 3.23.32 PHP 4.0.4 pl 1 Many thanks, Dave Brooks - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
AIX segmentation fault with PHP, Apache and MySQL
Hello, I am trying to port a PHP/MySQL application that happily runs under Linux across to an AIX box. We have MySQL is running under AIX - using mysql we can create tables, insert rows, etc and even access data via a C program. PHP is running as an Apache module - a simple phpinfo() works. If our PHP scripts are invoked when mysqld is not active we get a database error Can't connect to server, as to be expected. If however, mysqld is started and then we attempt our script, Apache reports a segmentation fault (as shown in its error logs) and the client browser gets an unexpected network error. Any ideas, debugging clues, etc would be much appreciated. AIX 4.3.3 Apache 1.3.12 (IBM HTTP Server) MySQL 3.23.32 PHP 4.0.4 pl 1 Many thanks, Dave Brooks - 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: AIX segmentation fault with PHP, Apache and MySQL
1.3.19 actually, Matt :) I'm running .19 on both my Linux machine and the G4. And as far as I can remember, PHP4.0.4pl1 worked ok on 1.3.14, I was doing that for a while. Z On Thursday, May 17, 2001, at 08:59 AM, Matthew P. Marino wrote: Apache is up to 1.3.17 at least. I would update apache and see what gives. PHP4 wasn't coded until Apache 1.3.15 was out. Dave Brooks, BCS Systems wrote: Hello, I am trying to port a PHP/MySQL application that happily runs under Linux across to an AIX box. We have MySQL is running under AIX - using mysql we can create tables, insert rows, etc and even access data via a C program. PHP is running as an Apache module - a simple phpinfo() works. If our PHP scripts are invoked when mysqld is not active we get a database error Can't connect to server, as to be expected. If however, mysqld is started and then we attempt our script, Apache reports a segmentation fault (as shown in its error logs) and the client browser gets an unexpected network error. Any ideas, debugging clues, etc would be much appreciated. AIX 4.3.3 Apache 1.3.12 (IBM HTTP Server) MySQL 3.23.32 PHP 4.0.4 pl 1 Many thanks, Dave Brooks - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
