MySQL Client Crashes With Segmentation Fault On Red Hat Linux Enterprise IA64
I have an IA64 Red Hat Linux Enterprise Edition system and I tried to
install the binaries recommended on MySQL. However, when I run the
mysql client, I get simply:
Segmentation fault.
So I tried to do a basic source compile, which went fine, but when I
run mysql client, I get this:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 2 to server version: 4.1.12
Segmentation fault
When I try the flags recommended by MySQL
(--with-extra-charsets=complex among others), the make test fails on
ucs_binlog - something to do with charsets I believe?
The mysql user, group etc. are all set up. Strangely, the mysql client
works in batch mode so if you make a file that reads:
SHOW DATABASES;
Then type:
mysql < commandfile
It'll display
Database
mysql
test
Without any faults....
Anyone any ideas or suggestions?
View Complete Forum Thread with Replies
Related Forum Messages:
Segmentation Fault When Loading Mysql
I am configuring mysql, apache and php in linux operation system. i have configured the apache and php but while configureing the mysql or trying to execute mysql from konsole a "SEGEMENTATION FALULT" is shown instead showing the mysql screen.
View Replies !
Segmentation Fault On Redhat9
Machine : Pentium4 O/S : Redhat9 I newly installed MySQL-5.0.15 server and client. MySQL server starts perfectly, but I cannot get it throung the client. # mysql Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 5 to server version: 5.0.13-rc-nt Type 'help;' or 'h' for help. Type 'c' to clear the buffer. Segmentation failure # It just gets back to the shell prompt. It never gives me the mysql> prompt.
View Replies !
How Do You Install MySQL 5.0 Server And Administrator On Red Hat Enterprise Linux 3 WS
Could someone point me to instructions for installing MySQL 5.0 server and administrator on a Red Hat Enterprise Linux 3 WS system? I just freshly installed the system and deliberately did not select MySQL serveras part of the installation I downloaded the 5.0 rpm Community Server edition, and that installed fine. My problems came while trying to build the administrator. Basically, I got caught up in a loop of incompatable modules: # rpm -i mysql-3.23.58-16.RHEL3.1.i386.rpm warning: mysql-3.23.58-16.RHEL3.1.i386.rpm: V3 DSA signature: NOKEY, key ID 025e513b error: Failed dependencies: perl-DBD-MySQL is needed by mysql-3.23.58-16.RHEL3.1 MySQL conflicts with mysql-3.23.58-16.RHEL3.1 Suggested resolutions: /var/spool/up2date/perl-DBD-MySQL-2.1021-3.i386.rpm If up2date the suggested resolution, it says I need a library from mysql-3.23.58-16.RHEL3.1.i386.rpm. I will gladly read the "manual" or docs, and would love a pointer to them.
View Replies !
Integrating Mysql, @mail, And Suse Linux Enterprise Server 9
I have recently received a admin job at a small web hosting company (small) and the current platform is windows and I will be responsible for creating a linux based platform and eventually moving all information over to linux form the windows setup. The idea is like this run Suse Linux Enterprise Server 9 using 2 web server running apache, 2 email servers using @mail, and having 2 front end servers with 4 storage nodes clustered. This company also has some custom database query programs to retrieve information. I might be in a tad over my head at this point, but that is ok there isnt an immediate rush on integration. I am looking for any other admins that might be able to offer any opions regarding this basic setup or that might have this setup and offer any suggestions concerning the actual construction of this type of platform.
View Replies !
Segmentation Violation In MySQL Database
I am working on LINUX Enterprise Version-3.0 (Japanese Language). I am facing problem when i m trying to connect to MySQL 5.0.27 Server .It displays segmentation violation error,when i am using japanese os. It is running smoothly when i m using English OS .
View Replies !
Installation Problems On RedHat EL4 On Ia64
I'm running RedHat EL4 on an ia64 system. I've been using PostgreSQL for a while but I now have an app that I think requires MySQL so I wanted to try it out. I tried installing MySQL-server-standard-5.0.18-0.rhel4.ia64.rpm and I get an error that it conflicts with mysql-4.1.7-5.RHEL4.1, so apparently I've already got MySQL 4.1.7 on the system. I want use PHP with MySQL, which means I have to configure PHP and tell it where the MySQL headers are. But I don't seem to have headers, at least not that I can find. I tried uninstalling MySQL 4.1.7 first but it says that dovecot and perl depend on it. I tried installing the "headers" rpm for 4.1 but the only one I found was 4.1.18 and rpm says it conflicts with mysql-4.1.7-5.RHEL4.1. So, any suggestions? I don't think I'm currently using MySQL for anything, but I don't want to break perl. I'd like to get 5.0 running. I just don't know enough about Linux and RPMs to be confident that I can uninstall 4.1 and install 5.0 without screwing something up.
View Replies !
Mysql_connect(): Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client
I am having an awkward problem with my MySQL installation. I have a number of scripts that access the database from a few different web hosting sites. I have no problem accessing the database from the scripts that I host locally. The scripts that are on an outside server accessing the database gives me a mysql_connect() error. Locally I use MySQL 5.0 and PHP 5.0. I am assuming that the 3rd party web host uses an older version of PHP and thinking that may be the problem. Is this the possible problem and if so is there a way to fix it without ruining the scripts that are currently working?
View Replies !
MySQL Crashes During Request
I'm working on MySQL 5.0 on Windows XP. I've tested a request on MSAccess and it's working. But if I launch it under MySQL, the PC crashes and I have to restart server. this is the request : SELECT * From bd_resultat.Valeurs_Entree Where Ve_Pa_Id = 147 and Ve_Val ='NO_OUTIL' and Ve_Groupe IN (SELECT Ve_Groupe From bd_resultat.Valeurs_Entree Where Ve_Pa_Id = 148 and Ve_Val ='FIB' and Ve_Groupe IN (SELECT Ve_Groupe From bd_resultat.Valeurs_Entree Where Ve_Pa_Id = 149 and Ve_Val ='1.4732')); There are 3 requests. If I put 2 requests, it's running. But If I put more than 2 requests, it crashes. Have you an an idea about this problem ?
View Replies !
MySQL Crashes When 98% Load On Server
When mysql load reaches 98% it's totaly hanged. MySQL is not sending any error messages to php and all website is down. When i disconnect php from mysql it's not helping, all the time mysql is 98% and i need to kill the mysql process to get my website to work again.
View Replies !
Configuring MYSQL Enterprise Monitor
I was given the setup files for configuring the MYSQL Enterprise Monitor with dashboard for testing in Local. 1. I have installed MYSQL Server to my localhost [Windows]. MYSQL SERVER Version: 5.0.50sp1a-enterprise-gpl-nt. 2. I have installed the MYSQL Network Monitor to my local system [Windows] With all options like admin login, agent and other details. But my doubt is how to set my MYSQL DB Server for regular monitoring using the MYSQL Enterprise Monitor. I.e I just want to know about the Server setting like how to add my localhost server to the Mysql Enterprise Monitor. We have a Enterprise Subscription but as iam just a developer i dont have the login id so can i get help from here?
View Replies !
MySQL View Points From Enterprise DBAs
One of our companies clients has asked us about redoing one of their highly profitable web applications in PHP and MySQL (The had an outside consultant recommend it). Their current application is built in C#.NET and SQL and is not currently clustered or load-balanced. They want to rebuild it as they have learned a lot about what they want since the original design and they know they need to make significant changes to the application to get the new features they are after and also address functionality that their current customers don't like. The company contacted the original .NET author (who also happens to be an experienced Microsoft SQL DBA) to see about redoing the applciation in PHP and MySQL and the author panned MySQL and stated that their own company had attempted to migrate one of their applications to MySQL and that from his perspectives there were many things that causes A GREAT DEAL of extra DBA overhead. I was hoping that more experienced DBAs using MySQL would be able to confirm or deny some of the Microsoft SQL DBAs claims - I have never worked with anything except MySQL and I have not used it for very long or even very often, so I am unable to successfully evaluate the claims. By no means do I want to get into 'down with Microsoft' thread here. Here are his claims:You can not centralize stored procedures for multiple databases. If you do you have to open up a whole lot of permissions that expose the system too much?The use of stored procedures and triggers is really complicated and you have to get down to a very low level of coding to understand, create or edit them, which makes the DBA's job harder and even once experienced more time-consuming?It lacks quite a few advanced features that Microsoft SQL has (he didn't cite which ones)?The upgrade path (of MySQL) is not standardizes so features that worked in version x are not guaranteed to work in version x.5 or y?There is no standardized way to backup and restore the databases and between the different methods there is a lack of compatibility. This means that backing up a MySQL database in one way - say for example MySQLdump and trying to restore it using phpMyAdmin or the MySQL administrator will not work.For those of you that have worked with different Databases do you think that MySQL is as easy to administrate and update as other Databases and even more specifically Microsoft SQL?
View Replies !
C# Console (exe) Application Crashes On Open Command (MySql)
I have problem opening an MySql connection from an win console application. I am using SharpDevelop as IDE. Previously I've been working with MySql through C# aspx and am new to writing exe programs in C#, so I assume that I might be missing something in the IDE / project configuration. I am successfully opening a connection and reading data from the table using adapter (window panel application binding to a grid), but when trying the code below in an console application the program crashes when calling the MyConn.Open(); function. The error message being: Exception MySql.Data.MySqlClient.MySqlException was thrown in debuggee: Unable to connect to any of the specified MySQL hosts. Open() If I break before the MyConn.Open(); function is called, the MyConn variable is filled with lot's of info looking ok to me, though I am not capable of knowing if any of it can tell me what leads to the crash in the next function call. Ive added the MySql.Data.dll to the project from the GAC list in the add reference panel. Further, in addition to the references, I only have an AssemblyInfo.cs file and the Main.cs file with the code below in the project I've reinstalled the MySql database trying different configurations etc, but whatever I have tried does not work. Has anybody else encountered this problem and or know the solution?
View Replies !
MySQL Enterprise Server With InnoDB For Mission-critical Data?
However recently the company I work for has the requirement to upgrade their database system. The data here really is mission-critical and we can't afford to loose any of it, and we need 24-7 uptime, with good performance (we have lots of clients so there'll be heavy load), any downtime will cost us. What I'd like to hear is peoples own experiences with MySQL Enterprise, good or bad, and if it's up to the job. Looking around the net I've seen lots of supposed expert DBAs saying that there's no argument; you should go with one of the "big 3", these being DB2, Oracle or MSSQL. However I get the feeling Oracle and DB2 would be a massive task to configure, and MSSQL - well it runs on Windows, we can't have any downtime no matter how good people say it is these days. So my idea was; InnoDB on 3 servers - a master and 2 replication slaves, with one slave off-site down a 10Mb line (wide enough pipe?). We use the on-site slave to run our daily backups, and point our reporting web sites at it too. the off site is for worst-case scenario disaster recovery. How much would we be better off spending more £ on one of the "big 3"? Would our data be safer on these? Would we get better performance with these? Is there a better model I could use for the MySQL setup?
View Replies !
MySQL Enterprise And MySQL Monitor
I'm trying to figure out the actual benefits of the MySQL Enterprise subscription service, which includes MySQL Monitor, a so-called "Virtual DBA Assistant". Has anyone used any of the four service levels of the MySQL Enterprise subscription service? The MySQL site has a lot of glossy marketing info and happy testimonials, but I'm still trying to determine if it makes sense for a small business (i.e., not a mega corporation) to invest anywhere from $695 to $4,9995 for the service. Has anyone used MySQL Monitor? Does it live up to the claim of being a "Virtual DBA Assistant"?
View Replies !
Fault Tolerance
I have 2 dedicated SQL servers to power the backend of the site (for fault tolerance purposes).Does anyone have any tips and documentation to allow me to set up mysql 4.1 the best way to achieve minimal down time on the site should there need to be a database outage. I've come from an MSSQL background so I would have said log shipping. Is this possible to do in MySQL? or better still is there some way I can do transactional replication?
View Replies !
Trigger Fault
I have a table like: CREATE TABLE c ( ckey INT NOT NULL UNIQUE AUTO_INCREMENT, name VARCHAR (32) NOT NULL DEFAULT "", link INT NOT NULL DEFAULT 0 ); CREATE TABLE d ( dkey INT NOT NULL UNIQUE AUTO_INCREMENT, ckey INT NOT NULL, name VARCHAR (32) NOT NULL DEFAULT ""); I want to create a trigger like DELIMITER $$ CREATE TRIGGER newD AFTER INSERT ON d FOR EACH ROW BEGIN UPDATE c set c.link = c.link + 1 WHERE c.ckey = new.ckey; END$$ DELIMITER ; Then INSERT INTO c ( name ) values ( 'Foo1' ); INSERT INTO c ( name ) values ( 'Foo2' ); INSERT INTO d ( name, ckey ) values ( 'Bar1', (SELECT ckey FROM c WHERE c.ckey = new.ckey) ); I get the error message: Can't update table 'c' in stored function/trigger because it is already used by the statement which invoked this stored function/trigger. Is this a hard fast constraint. The calling function is a read only and the read occured before the trigger fired, and the read was for a field not involved in the update. Is this restriction ever going to be lifted?
View Replies !
Memory Fault (core Dumped)
I am getting this message when I try to connect to my recently upgraded MySQL ( I went from 3.21 to 4.1.7) on windows XP pro... I used the configuration wizard after the windows install wizard and have even tried to access mysql from the command line... this is not really a permissions issue because I can't even connect as root to set up the other permissions with the grant command.
View Replies !
Multithreded Program Getting Sagmentation Fault
In gdb back trace i am getting ----------------- #0 0x42073fe0 in _int_free () from /lib/i686/libc.so.6 #1 0x42074a2c in free () from /lib/i686/libc.so.6 #2 0x080efd02 in emb_advanced_command () #3 0x080f0224 in emb_stmt_execute () #4 0x080ead4c in mysql_stmt_execute () #5 0x080e592b in hlpd_Insert(st_mysql*) (MysqlConn=0x84946e0) at hlpd_insert.cpp:147 #6 0x080e534d in main (argc=1, argv=0xbffffa34) at hlpd_benchmark_main.cpp:136 #7 0x420158d4 in __libc_start_main () from /lib/i686/libc.so.6 The same Mysql database connection is used in both the threads.
View Replies !
5.0.22 Crashes
just upgraded my MySQL to 5.0.22 and found that the following statement: select DATE_ADD(made,INTERVAL payment_terms DAY) from processitem,document_files,processes,companies WHERE ref_no=pr_process_no AND pr_process_no=process_no AND processes.customer=companies.cust_no AND made>="2006-6-01" AND made<"2006-7-01" AND dtype="Invoice" GROUP by processitem.pr_invoice ORDER BY DATE_ADD(made,INTERVAL payment_terms DAY); will crash the database server. If I remove the order by statement it works. This has been working well since version 3.x and the previous 5.0.8 also handled it fine.
View Replies !
Enterprise Manager
I'm looking for a GUI manager tool like MSSQL Enterprise Manager for MySQL (free, if possible). I'm using XP. I'm especially interested in a GUI for creating views in which I can graphically manage INNER and OUTER join between objects Does anyone know a tool like the one I just described in my dream
View Replies !
5.0.2 Engine Crashes Always On W2K
I have an application supports ORACLE and MSSQL, and now I have to extend database support for MySQL. I need VIEW, STORED PROCEDURE. so I start my work with 5.0.2, but I can not use it, because the engine generates Window exceptions (MySQL installed on W2K). Engine crashes using all MySQL tools (Administrator, Query Browser, Control Center) too. I made some test with 4.x.x, and this was stable, but I need VIEW, STORED PROCEDURE. If they are not, I have to re-write my modules - I don't want if it is possible -. My question: I have to wait for next release? (I find that, 5.0.3 is fixed. Can I test it now?)
View Replies !
SQL Quesry Crashes DB
SELECT id,log_date,log_date_count,log_email,log_email_count,email,fname FROM app_track WHERE type = 'fed' ORDER BY log_date_count DESC LIMIT 0, 30 This crashes mysql. (win2000).
View Replies !
Query Crashes Database
The following query sometimes gives problems, can you see something that could upset the mysql database? SELECT DISTINCT t1 . * FROM cdb_producten AS t1, cdb_stijlen AS t2 WHERE ( ( t1.p_brutoprijs * 1.19 ) <=750 )
View Replies !
SQLConnect Crashes Internally
Configuration: C code XCode 1.5 (IDE 389.0, Core 387.0, ToolSupport 372.0) MacOSX 10.3.9 Program description: The program connects to ODBC driver and then to whatever database is described by the DSN. From there it does many simple tasks such as creating a table or inserting data. I connect to MySQL database and PostgreSQL database (I separately choose the one I will use before I compile and run the program). Problem: The program I am working on continually crashes inside the guts of SQLConnect. I haven't modified any MySQL code. I bring this issue to the MySQL forum because when I connect to a PostgreSQL server I NEVER have crashes/problems with connecting but the SQLConnect statement only fails when I connect to MySQL server. Also note that it doesn't crash on every call of SQLConnect, but rather only the 2nd time called or later being called. Code:
View Replies !
4.0.14 Install Problem: Mysqld Crashes
I've recently compiled mysql 4.0.14 on redhat 8.0. The installation fails, however, when running mysql_install_db. I've attached a transcript below. I gather from searching the 'net that this isn't an entirely unusual thing to happen, and is likely the result of some misconfiguration on my part, or perhaps a version incompatability with my libc. Unfortunately, I haven't seen any concrete suggestions on how to get past it. I've studied the installation instructions pretty closely, experimented with various compilation flags. I just keep getting the same results. Code: ....
View Replies !
Simultaniously Access Crashes Web Site
It still goes fast tho....faster then some single queries i used before...only this is on localhost... any idea how this is gonna hold when the website goes online and like..10 people come browsing it simultaniously (or 100!) or how i find it out to make sure before it crash...or even build it is 7 queries maybe acceptable or not for 1 website page?
View Replies !
Community To Enterprise Upgrade Path
We are a start-up business which has decided to use MySQL Community version but as we grow we dread the thought of redoing everything when we are ready for the Enterprise version. Is/will there be a utility/program that will simplify this process?
View Replies !
CREATE INDEX Crashes Server (Lost Connection...)
I'm having trouble with a table I created quite a while ago and now want to add an index to. Here's what I get if I try to add an index on the host field of my table: mysql> create index Index_host on uselog(host); ERROR 2013 (HY000): Lost connection to MySQL server during query Connection was lost because the server crashed. The Windows event log has an event that says "Faulting application mysqld-nt.exe, version 0.0.0.0, faulting module mysqld-nt.exe, version 0.0.0.0, fault address 0x0017dc06." I've also tried the allegedly identical "ALTER TABLE uselog ADD INDEX Index_host(host)", as well as trying to index a different column, all with the same outcome (server crash). Thing is, I had no trouble adding an index to the same table a week or so ago. The table was smaller then (and had only one index), but even now, it's not very big by DB standards, so I can't imagine that's the problem. (My table had ~900K rows earlier today, which I pruned down to 140K rows after my first failed attempt to add the index. Puny! Only 55MB data length, according to MySQL administrator.)
View Replies !
Mysqld-nt Crashes When Executing Batch File In 5.03 Beta
I'm quite new to mysql but I had installed the 5.0.1 and 5.0.0a alpha under windows XP, and designed a little database for managing cards. To make some backup of this database I dumped it in a batch file. This file was working perfectly with mysql 5.0.1 and 5.0.0a. When I try and execute my batch file, having previously created the database concerned, it crashes the mysqld-nt. On top of that the first table created in the database is listed but when a DROP DATABASE is issued it says that this table does not exist and then the command fails. The database uses UTF8 and SET FOREIGN_KEY_CHECKS=0; is set in the begining of the file. So I have two questions : 1- Can I force the database to be dropped or is it definitely corrupted? 2- Any clue on why the batch file crashes the server? (I'd be glad to send it is is a mere 250 ko when zipped)
View Replies !
VB And Mysql:client
i wanna conn VB 6 to a mysql 4.1 database using mysql odbc driver 3.51 on windows XP. this conn is done usin ADODB. however on executing i get the following error: "client does not recognise authentication protocol requested by server, please consider upgradin mysql." upgradin to 5.0 is senseless. it is a godown of bugs
View Replies !
Mysql Client V5.0.21
Basically if I type a command in mysql and then try to reuse it by pushing the up arrow, most of the time a segmentation violation will occur.
View Replies !
Table Rows Inserted By Embeddded MySQL Cannot Be Retrieved By MySQL Tcp Client
I have encountered a weird behavoir of embedded MySQL. Through a simple program I made (in Delphi 6), I can insert rows to a table through embedded MySQL and I can retrieve the rows from my program. But using mysql.exe which points to the same table (through 127.0.0.1, with the same basedir and datadir), I cannot see the rows I inserted using my embedded program. Another way around, the rows inserted by mysql.exe can be seen in my embedded program. But after a row is inserted by mysql.exe, the rows inserted by the embedde program are deleted (or cannot be queried). Can anybody explain why is this? Is there a way to fix it?
View Replies !
MySQL Client Side
Does mySQL have lite version? Similar to ms sql express, where it can be distributed without a full server version. I have program with many clients and i'm wanting to move away from access if i can.
View Replies !
Mysql Client On Win98 DOS
Is there any option of formatting the columns of tables so that for example only 5 characters of each column is displayed?(also is there any way to set no wrapping) That is in order to get a proper output of tables in a win98 DOS prompt. I know that Oracle SQL gives you such options.
View Replies !
Install MySQL Client
Is there any client tools available for mysql like sql server so that i can install server in one machine and client tool in a client machine that will connect to the mysql sever
View Replies !
MySQL GUI Client Tool
I am looking for a gui-based open source client tool for mysql. Does anybody have any suggestion besides those listed in the first few posts in the beginning of the forum?
View Replies !
MySQL Client Ran Out Of Memory
I'm using a mysql server with my own TCP/IP server on the same FreeBSD machine. MySQL stores a users database, like logins and passwords. It works fine for a couple of days, but after that my simple queries with one row of result stops working. It says "MySQL Client ran out of memory". If I connect to mysql using other tools or simply restart my server - it works fine again under the same queries. So please don't support I use a huge amount of data, whole database can be selected in one query under normal conditions, its pretty small. My Server Info: sr10# mysql --version mysql Ver 14.7 Distrib 4.1.16, for portbld-freebsd5.4 (i386) using 4.3
View Replies !
MySql Client 3.51 Through Proxy
OK I am working with an external company that has opened a DB for us to attach to. There documentation has you install My Sql 3.51 driver. I have all the login info and server address correct but it fails to connect. We do have a firewall here but I see no place in the System DSN to reference it. Do I need something else to make the work with a firewall?
View Replies !
Installing MySQL Client
I'm sure this is a really noob thing to be asking.... I have MySQL and PHP installed onto my web hosting server and it's running fine. Now, my problem is that I can't figure out how to access it from my computer. I'm mainly using Frontpage (because that's the program that everything was built on before I was hired) to build the websites. What is the easiest way to be able to start using this database?
View Replies !
|
TRACKER
