Stored Function Stops MySQL Service
I'm using MySQL 5, Windows XP Home SP2 (ack, but only for the near future)... I have what appears to be a simple and straightforward need- execute a function for a column in each row of a result set: Code:
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
MySQL Automaticly Stops The Service
I've been MySQL for a view years now, without any problems. Until.... Last week I've formatted my PC and had to install MySQL again (no problems installing), but now, when I want to "Start the Service", immedialtly the service is stopped (the trafficlight turns from green to red within a second)
My SQL Service Stops With Error Code
I'm Developing a project on a Windows XP Pro/C# environment, and everything was looking good, until I created my tables using a program I downloaded from MySql.org. Anways, now when my computer restarts, the service traffic light shows red, and when I look in the log this is what I get: 050326 18:24:45 InnoDB: Started 050326 18:24:45 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050326 18:24:45 Aborting 050326 18:24:45 InnoDB: Starting shutdown... 050326 18:24:47 InnoDB: Shutdown completed 050326 18:24:47 MySql: Shutdown Complete Has anyone seen this before or can anyone please help? The Error code I get when I type in SC MySql is 1067.
Mysql Stored Function ...
I'm new to creating stored procedure - can someone tell me where i've gone wrong here - the below code refuses to execute. Essentially, all i want do it something like; INSERT INTO sometable(a,b,c) VALUE(12,'12',itypes('information')); if the category 'information' doesn't exist in the event_types table, it's create and the id return - else just returns the id CREATE FUNCTION .`itypes` ( _tname VARCHAR(45)) RETURNS INT BEGIN DECLARE tmp INT; SELECT id INTO tmp FROM event_types WHERE tname LIKE _tname; IF (id IS NULL) THEN INSERT INTO event_types ( tname ) VALUES ( _tname ); END IF; SELECT id INTO tmp FROM event_types WHERE tname LIKE _tname; RETURN tmp END
The MySQL Service Has Disappeared From Win XP Service List
I have been using MySQL for about 3 years now on Win XP Pro SP2 and had no real problems. Until today I went to start the service in windows service list (I start it manually) and it was gone! The MySQL install (MySQL 5.0) is still visible in add/remove programs and all the files and directories are present.
Stored Function
I managed to make a stored function 'IsEmpty' but when I use the function in a query like: select * from tblinre where isempty('') ; it will result in FALSE. when I use use isempty(null) it will result in TRUE. my stored function DELIMITER $$ DROP FUNCTION IF EXISTS `bridge`.`IsEmpty` $$ CREATE FUNCTION `IsEmpty`(p VARCHAR(1)) RETURNS tinyint(1) DETERMINISTIC BEGIN RETURN IF(TRIM(p)='' OR p IS NULL,TRUE,FALSE); END $$ DELIMITER ;
STORED FUNCTION
I need to create: CREATE OR REPLACE FUNCTION zap_firm(p_id_firm IN INTEGER) RETURNS INTEGER IS BEGIN DECLARE v_zaplacono NUMBER; FOR cur_fakt IN (SELECT id_fakt FROM Faktury WHERE id_firm = p_id_firm) LOOP FOR cur_wpl IN (SELECT * FROM Wplaty WHERE id_wplaty = cur_fakt.id_fakt) LOOP v_zaplacono = v_zaplacono + cur_wpl.kwota; END LOOP; END LOOP; END;
Stored Function Question
I working on my first attempt at creating a store function. It seems quite simple but I've run into a problem that I can' seem to figure out. I created a function that returns an integer. It's a basic Username/Password check. I Select from a table within the function and will base the return on values from that select. I wanted to build an error condition into the function to return an error value if there is no matching data found from the Select statement. I tried testing for NULL, but can't seem to get that to work. How can I test to make sure that the Select returned something before continuing into the rest of the function? Here is my code: create function authenticate (x varchar(20), y varchar(20)) RETURNS varchar(20) BEGIN DECLARE u varchar(20); DECLARE p varchar(20); SELECT UserName,PWord INTO u,p from user where UserName = x; IF u = NULL THEN RETURN -1; END IF; END|
Stored Procedure Vs. Function
What is the difference between a function and an stored procedure in MySQL? as i understood, SPs can do more things than functions and they can do functions tasks also, so why we use functions and why are them defined? can not we use SPs instead of them?
UPPER In Stored Function
why upper doesn't work properly in stored procedure like this at the buttom of the post. It just doesn't wont to capitalize letters. How to cope succesfully with that problem? DELIMITER $$ DROP FUNCTION IF EXISTS `telesales`.`ucfirst`$$ CREATE FUNCTION `telesales`.`ucfirst`(source CHAR(255)) RETURNS CHAR(255) BEGIN RETURN UPPER(source); END$$ DELIMITER ;
Using Select In Function / Stored Procedure
i've been using it for 4 months but i've only needed simple CRUD operations till now. I'm trying to write a query that checks if some records are in table1 and then does an update to table2 and a delete in table3 if the records are in table1. I then need true/false, 0/1 etc returned at the end. I've tried using a function but i've had real problems getting the data back in .Net via the .Net connector. I'd prefer to use a stored procedure but don't want to have the data from the first select returned to the client. Is there a way to "purge" the results of earlier queries? I don't know the mySQL feature set well enough to know what the best way of doing this would be.
Mysql Stops Processing
Has anyone ever had any problems with MySQL w/ all InnoDB tables just stop processing queries? There doesn't seem to be any pattern to it, it happens at times of relatively high load (load avg of 4 on a dual proc) but the CPUs still have plenty of idle time, and the disks aren't maxing out. It doesn't happen everytime there is a high load either. The box just stops processing every query, and we quickly hit the max connection limit. The only solution we've found is to shutdown mysql and restart it -- at which point it works fine for a couple days. We are running mysql 3.23.56 w/ redhat 7.3 and 2.4.20 kernel.
MYSQL Stops Responding
I've been running MySQL for about 3 months on a dedicated Win2003 server as a back in to a vbulletin forum with no problems. Over the last week I've had the database stop responding a couple of times. When I tried to cycle the service it would never stop. Now while I've been running MySQL for sometime I've not done much except make some tweaks to the config suggested on some forum I don't even remember. So I'm not expert, hence my post in the Newbie forum. So I have a somewhat busy forum, I guess, doing between 30000 and 40000 page views a day. Here are my details: Server OS: Windows 2003 Server Web Server: IIS6 PHP on web server: PHP 4.4.0 MySQL version: 4.1.14-nt Main database is about 500 Megs The first time it stopped responding was during the day during our busies time and the 2nd time was in the middle of the night during a backup. So now my question. I don't even know where to start to troubleshoot my problem.
MySQL Stops Responding
I am running a perl script which launches many processes simultaneously (using Parallel::ForkManager package), each fork gets data from a website and writes it to a MySQL database (there are usually 200+ simultaneous connections). It's very data intensive (I make roughly 3 million page requests per day). My problem is that after this program runs for a day or so, I am no longer able to write to the database. It basically locks itself! I cannot even properly shut it down (using mysqladmin -u root -p shutdown). I end up having to use "kill -9" as root user to shut it down and restart. The only thing I notice is that the table_locks_immediate is huge (around 4 million). I have set my max_connections to 800 and a "show status" usually has no more than 200 threads_connectes (as controlled by ForkManager).
Mysql Stops Responding
I am using mysql 3.*. I have several php scripts and java programs which access the mysql server. But from yesterday both my java and php programs keep on waiting for the mysql server. Everything worked well for about 2 days. All started yesterday. Mysql and my java and php programs are running on linux. Linux has glibc 2.2.*
MySQL Keeps Going Long After Code Stops
When some queries are executed on a server I have setup MySQL will continue to use up CPU cycles 5-10 minutes after the PHP code that executed the query has long since stopped. The browser page will be loaded and no further PHP code will be active on the entire server that could call MySQL into usage, yet MySQL will continue to use upwards of 80-90% of the available CPU processing power for that 5-10 minutes afterward. In fact, if the PHP page only takes a couple of seconds to load with next to no CPU usage then after it has finished loading MySQL will start utilizing the CPU for all it is worth as if it is trying to complete some task that only it knows about. This is on an isolated server so I know I am the only one using it. This seems to happen most often when a LEFT JOIN is executed, though the query itself is very quick and returns the data in less than a second. I am running MySQL 5.0.15 with Apache 2.0.54 and PHP 5.0.4 on Windows XP SP2. I know this is terribly obscure sounding, but if anyone has any ideas where I could start to look for the source of the problem I would appreciate it. I know it is not in the code because if I run the code on a Linux server this doesn't happen, not to mention the fact that, as I said, the PHP code itself finishes without a hitch.
Mysql Stops Running Queries After Approx 1 Day
I have a PHP script that runs 24x7 and reads then deletes from a table about once every couple of seconds. However, after about a day, I start getting the error "$result is not a valid mysql resource etc..". Looking in the query log, mysql has stopped logging the queries - so I presume they are not being run/received by the daemon. If I restart the script, it will work fine again for around a day. Does anybody know what would be causing this? Are there any logs than can help? Having run the script for about 5 minutes, I'm already up to "mysql resource id #180" so I guess by the time the script stops working, we could be up to the tens of thousands. Could mysql be running out of resource IDs? Once the query has been execute, I don't need to store it any more so can I somehow get it to start re-using some of the old resource IDs?
Server Almost Stops
I have MySQL database and PHP program working with it. When I call initial PHP page in the morning, MySQL gets very busy. Proc load on the server for mysqld process is above 50%, and I need to wait for several minutes till I can see the page in a browser. When I check MySQL thread in SQLYog, I see that it is "copying to tmp table" when executing "OPTIMIZE TABLE sometable". This sometable is about 1 mln records and certainly takes a lot of time to be optimized. But: this table is a dictionary and I NEVER modify it! So I don't need to optimize it at all. How can I convince MySQL not to optimize it
Mysqldump Stops
I get mysqldump (fedora 3) work until it founds this error: /usr/bin/mysqldump: Got error: 1033: Incorrect information in file: './mysql/help_category.frm' when using LOCK TABLES This is first mysql database installed itself. There are a lot of tables in mysql database that display the same error msg when I try to see their structure with phpMyAdmin. How may I fix this?
Database Stops Responding
I'm having a little problem where my mysql 4.0.21 for some reason stops "responding" until I do a flush-hosts. This is happening almost every day. It's a pretty heavy loaded server with at aprox 130 querys per second (it might not be that loaded for some of you :) ). I'm using the my-huge.cnf config, and allowing 350 max-connections. Code:
MySQL As Service
I have MySQL installed at D:mysql. I have put my.ini with correct basedir and datadir entried into D:Windows. When I attempt to run mysqld-max-nt --install I get the service installed but it will only show it as being installed on the C drive.
MySQL Service Crash
I have the following query which runs fine without the insert statment. INSERT INTO `db_x`.`attributes` (id, typeid, value, start_time, end_time) SELECT distincti.id, at.id AS typeid, d.megapixels AS value, NULL AS start_time, NULL AS end_time FROM `db_y`.`data` d, `db_x`.`attribute_types` at, `db_x`.`items` i WHERE at.name = 'megapixel' AND i.secondid = d.p_id AND d.megapixels is not null; When I run it without the insert statement it return 500 rows in about 90ms, when I add the insert statement the whole MySQL service stops. The `db_x`.`attributes` table furthermore contains a field 'yo' which is the primary key and an auto_increment field. I am running MySQL 4.1.9-nt. It is running on Windows Server 2003.
MySQL Service Cannot Start
I'm pretty much a newbie. So can you guyz please give thorough instruction when helping me? I installed mySQL using a PHP installation package, FoxServ. Until now, mySQL cannot start (red traffic light). Whenever I try to start it manually using Administrative Tools>>Services, I got a message saying "Could not start the MySql service on Local Computer. Error 1067: The process terminated unexpectedly". I've read through a previous post on this forum regarding the problem but none of the solutions worked. So I figured that it might be something wrong with Foxserv, instead of mySQL. So i uninstalled FoxServ and installed another package called XAMPP. However, I still encounter the same problem. I've tried several installation packages but mySQL still doesn't work. Is the computer blocking mySQL services or something? But I checked Windows Firewall and under the 'Exceptions' tab, all mysql-related stuff (mysqld, mysqld-max, mysqld-nt, mysqld-nt0 are ticked. Everyone else who uses these packages didn't get similar problems. And another thing, while installing mySQL using WinLAMP (another package), I got a message saying: "Port 3306 is already in used". Not understanding what it means, I proceed with port 3306 anyway. Could this be the root of the problem?
Re-setting Mysql As A Service
I installed mysql server 4.1 last month. When I installed it, I set it to run as a service to start automatically. However, for some reason, that no longer occurs. I can't even see the mysql service running from services viewer in win xp. I now have to manually start mysql server each time I reboot. Can someone please tell me how I can Re-set mysql to run as a service?? Or, if I re-install mysql, will it retain the db's already created??
Can't Remove MySQL Service On Win XP
I am trying to reinstall MySQL on a Win XP pro box. After uninstalling MySQL 3.x, a 'MySQL' service is left in the list of services. I can't figure out how to delete it, and installation of MySQL 4.1 fails during configuration. The old service may not be the problem, but can anyone suggest how to get rid of it?
MySQL Service Stopping
I'm experiencing a problem with MySQL. We're running version 5.0 on a Windows 2003 server and anytime I try to access our databases through MySQL Administrator or MySQL Query Browser, the MySQL service stops. When I logon to the server to restart the service I get a pop-up message asking if I want to send an error report to Microsoft. The error message says that MySQLD-NT.exe encountered a problem and needed to close. What would cause the executable to encounter a problem? I don't understand why I can run my application, which is called through ColdFusion MX7) can run against the database fine but going through MySQL Admin or MySQL Query Browser causes the service to shutdown.
MySql Service Will Not Start
I installed MySQL and MyODBC on a Win2k server, got it all working fine. Created a database and tables, pulled all information through ASP files. Just randomly MySQL stopped. I went to Services and tried to restart it... it attempts to start but fails. Event View gives no cause, just says MySql failed to start the (x) time. Any ideas on what this could be from? Nothing has changed on the server.
MySQL SERVICE KEEPS DIEING
I was having problems with phpmyadmin and decided to upgrade to MySQL 5.0 alpa because phpmyadmin docs say that 4.1 is not "fully" compatible so I thought I might fix some problems. Anyway, now the service keeps dieing, including when I try to log into phpmyadmin. I have it set to auto restart, but this cant remain like this. Why is it doing this? I am running on Window 2000 Server fully patched.
MySQL Service Crash
I have the following query which runs fine without the insert statment. INSERT INTO `db_x`.`attributes` (id, typeid, value, start_time, end_time) SELECT distinct i.id, at.id AS typeid, d.megapixels AS value, NULL AS start_time, NULL AS end_time FROM `db_y`.`data` d, `db_x`.`attribute_types` at, `db_x`.`items` i WHERE at.name = 'megapixel' AND i.secondid = d.p_id AND d.megapixels is not null; When I run it without the insert statement it return 500 rows in about 90ms, when I add the insert statement the whole MySQL service stops. The `db_x`.`attributes` table furthermore contains a field 'yo' which is the primary key and an auto_increment field. I am running MySQL 4.1.9-nt. It is running on Windows Server 2003. I found out it's the following error: 2013 Lost connection to MySQL server during query. It also happens when I execute a large batch file.
Mysql Service Will Not Stop
What does this problem mean and how can I solve it? net stop mysql The MySQL service is stopping......... (never stops) I am running Windows 2000 SP 4 with mysql 5.0.24a.
Uninstalling MySQL Service
I have an error that pops up in a prompt saying that "(null) was compiled with ... and PHP was compiled with... They must match." I don't remember the entire pargraph and couldn't copy it so I could paste it here. But part of it was "Thread Safety-1" This window pops up 16 times with OK Only during start up of my windows XP system. I can't tell if it is related to MySQL or PHP. I have a MySQL Service running that is associtated with a non-existant directory. It is the only one. I want to uninstall the service but don't know how. Windows Service Manager (or MMC) won't let me do anything but start or stop the service. I say the MySQL is associated with that folder because when I select properties it tells me the directory. How can I uninstall this so I can make a fresh start?
MYSQL SERVICE WILL NOT START
I run the instance configuration, then when i try to execute the operation, I get ERROR 0: Cannot "Start" Service. Now, before everyone sends me links to MikesServiceRemover, please know that the service is installed just fine, however there's no way that i can "start" it. I've actually tried mikesServiceRemover and it tells me that Mysql41 service exists, but that it's not running. I've tried going to the bin directory and running mysqld, mysql.exe, and almost all the other ones, and the same thing happens: a command line blips up, then disappears, and i know it's not running because it doesn't even show up in my task manager.
MySQL Service Error
I am trying to start MySQL as a service in Windows but it is not working. The error I am getting is below: "FATAL ERROR: Can't open priveledge tables: table 'msql.host' doesn't exist" I started the service before and it ran fine. After I rebooted the machine and tried to restart MySQL I got the error.
Can Not Start MySQL Service
When I tried to install MySQL 5 it gave me this: "Could not start the service MySQL5. Error: 0" durring configuration. I've tried everything I could find on the forums and nothing worked. Now I don't know what to do.
MySQL Service Disabling
I am running MySQL 5.0.16 on Windows XP Pro box w/ 320 MB RAM. All current updates. I have been running this version since about March and have not had any problems with it. Starting Aug. 1, at random times throughout the day the service will disable itself. It might have once a day, it might have 2-3 times a day. We have to go in and manually and restart the service. I set the recovery to automatically restart itself, but that is a whole different story. I checked the error log and it looks like MySQL is doing the disabling and not Windows or some other application. My tables are setup for InnoDB. I have tried to dig deeper into the logs to see if I can figure out why it's disabling but I can't seem to find anything. I was wondering if there was a query that was overloading it or something else that was causing this.
Windows Service For MySQL
Im trying to install MySQL on a XP Pro SP1a machine. It wont start the service from the installer. I go to start the service manually, and it fails as well. It says "Error 1067. The process terminated unexpectedly."
MySQL Service Won't Start And I Am Getting An Error 23
I have over 23 gig in a MySQL database that will now not start the service and gives me a error 23.. What can I do to get my data back? I have read everything I could find about restoring the database and nothing has worked. I am running on Windows and I have ran chkdsk on all volumes. ChkDsk did say it fixed bad clusters on the ibdata1 file. But the service will start for a few seconds and then shut down with the error 23. I have the ibdata1 and log files. Is there a way to get my database back? I know the data is in there since the ibdata1 file is so large..
Mysql As A Service And Root Password (-w W)
I have a few qeustions for some linux/mysql pros in here. Background: I've just built MySQL on Mandrake Linux 9.1 from source. I can get the mysql service running my: shell> /usr/local/mysql/bin/mysqld_safe --user=mysql & but I don't know how to keep it running, or how to make it start at every bootup. How do I do that? Also, I've made an alias to mysql: alias=/usr/local/mysql/bin/mysql but it won't span sessions, I think I need to export it, but I'm not sure how to. Also, via mysqladmin I set the root password to "password" which I don't want to keep :) how do I got about changeing it now? Thanks so much for your help. I know I probably should have installed via RPM, but I'm wanting to learn as much as I can about all of this.
Unable To Run Mysql Service On Windows98se
I am trying to set the username and password after installing mysql 5, I run an ms dos prompt, and type in mysqld but am met with an error msg: C:Program FilesMySQLMySQL Server 5.0in>mysqld~2 061026 10:09:20 [ERROR] Can't find messagefile 'C:Program FilesMySQLMySQL Ser ver 5.0shareenglisherrmsg.sys' 061026 10:09:20 [ERROR] Aborting I checked the above folder and there is an errmsg.sys file, does anyone know what could be wrong?
Mysql As A Service And Root Password (-w W)
Background: I've just built MySQL on Mandrake Linux 9.1 from source. I can get the mysql service running my: shell> /usr/local/mysql/bin/mysqld_safe --user=mysql & but I don't know how to keep it running, or how to make it start at every bootup. How do I do that? Also, I've made an alias to mysql: alias=/usr/local/mysql/bin/mysql but it won't span sessions, I think I need to export it, but I'm not sure how to. Also, via mysqladmin I set the root password to "password" which I don't want to keep :) how do I got about changeing it now? Thanks so much for your help. I know I probably should have installed via RPM, but I'm wanting to learn as much as I can about all of this.
Mysql Service Won't Start Error 1067
I am running coldfusion mx 6.1 windows platform. Yesterday everthing was working fine this morning nothing has changed but when I try 2 enter my login password in mysql command line it just closes. When I re-install it works again but I have 2 do this like every day. Some how after I reboot the mysql service is stopped and when I log back in it does not automatically start. I have tried to start it manually but no luck with that either I get the same error.
MySQL Administrator Install (service Already Exists)
I've installed MySQL 4.1 on a W2k machine and would now like to install MySQL Administrator. Whenever I try to do so, however, I get an error message saying that the specified service (which service is isn't specified!) already exists and the installation fails. I get the same error trying to install the Query Browser. It was suggested elsewhere that this may be due to my version of MSI being out of date, so I've updated to V2, de-installed MySQL (including removing all traces from the registry and HD) and re-installed using the latest MSI. Same result.
Mysql Nt Service Stopped Starting After 2 Years
i have been running mysql on windows server 2003 for the last almost 2 years (its a really early version of mysql 4 anyway) but now all of a sudden mysql service stopped starting, i can go to services, press start and then refresh and its off again! i have a feeling that someone deleted the core mysql table (mysql) as it is now totally empty. im not too good with my sql as i generally use mssql or whatever, infact mysql never really installed properly, the only user i could ever use was root but i didnt mind this so i just left it and it was fine for 2 years but now its just stopped all of a sudden and i cant get it back on. i have enabled the mssql php exension as a backup system but i cant transfer any databases across without enabling mysql.. but it wont turn on! i tried several exes in e:mysqlin but none got it on (well one of them made the little winmysqladmin light go on for half a second)
MySQL Service Keeps Shutting Down In Windows Server
Strange, MySQL has been running smoothly for almost a year on this server, and just recently it shuts down after boot up. Running Windows 2003 with all patches. Any attempts to restart MySQL results in shutdown of the service. This is the Event error message: "TCP/IP, --shared-memory, or --named-pipe should be configured on NT OS" Here is the log that shows the shutdown... Code:
Restarting MySQL Service Resets My Privelages
When i restart my MySQL service in Windows all my priveleges are reset for my Databases. I can then no longer access the database(s) in my scripting. I am using the GUI through Control Panel > Administration Tools > Services and not the command line 'net stop mysql'. Why would this occur?
Mysql Service Is Stopping Everyday At Same Time
Here is the situation: at about 10:45 am every work day (M-F) for the last two weeks, I am getting the following error, and the mysql service just stops (running on Windows 2003, using IIS). What's Up Gold catches that the service was stopped and restarts it automatically for me after about two minutes. But, I want to know what is causing this. Below is the error log entry, and below that is the explanation of error number 33 from the URL given in the error entry. Any ideas what could be causing this lock at the same time everyday? I have checked scheduled tasks, etc., but nothing obvious is standing out.
MySQL Service Problems (Not Error 1067!)
Been banging on this all day and I think I've hosed MySQL due to the number of uninstalls and reinstalls. Maybe there is a bug in the uninstall because I don't think it removes everything. For starters, the MySQL service is stuck in the Services window. Anyway, the new instance called "mysqlreinst" works from the comman line just fine with "mysqld-nt". But, we need a service, and the service will won't start. The error log looks like this: Quote: Originally Posted by MySQL error file InnoDB: Error: log file .ib_logfile0 is of different size 0 5242880 bytes InnoDB: then specified in the .cnf file 0... bytes blah blah... So it sounds like my fresh install is clashing with some old MySQL install, back fromt he grave to wreak havoc on my sanity, leaving nothing in its wake. I searched around on this forum (you guys are pretty good) but nothing helped. I tried to put the my.ini file in C:winnt but then nothing works, neither command line nor service. So, I deleted the file. My <MySQL root>my.ini says MySQL should listen on 3309. It actually listens on 3306. Does this mean the my.ini is being ignored? I searched the whole filesystem for files ending in .cnf. Nothing MySQL related was returned.
|
TRACKER
