InnoDB: Page Directory Corruption: Supremum Not Pointed To
I was prompted to use the "Stop/Start Service" feature in MySQL Administrator and could not re-start the MySQL Server. I have been given a bunch of advice on how to get it started again like using the command prompt in XP Pro. I did and input "mysqld --standalone", it didn't get MySQL Server started. I was told to check the error log, this is what I found...
050515 11:08:37 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050515 11:08:37 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 47130.
InnoDB: Doing recovery: scanned up to log sequence number 0 47130
InnoDB: Page directory corruption: supremum not pointed to
050515 11:08:37 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex
It seems that the "sepremum" is not pointed to the file it should be pointed to. I don't know what the "sepremum" or if it's preventing MySQL Server from starting.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
InnoDB Corruption
My MySQL crashed this morning which lead me to look into my server to see what was up. Upon inspection it seems I may have made a mistake. Back on June 25th 2006 I upgraded MySQL from 4.1.12 to 4.1.20 and I copied over the data folder (or so I thought) and got it up and running and happy. However when I looked today it seems that I may have not copied over the log files! The following error shows up in the error log: 060808 10:48:44 InnoDB: Error: page 531 log sequence number 0 266909086 InnoDB: is in the future! Current system log sequence number 0 62488108. InnoDB: Your database may be corrupt. 060808 10:48:44 InnoDB: Error: page 532 log sequence number 0 266926873 InnoDB: is in the future! Current system log sequence number 0 62488108. InnoDB: Your database may be corrupt. a bunch of them! I have a feeling that it is because I failed to drop in the log files after the upgrade. What is the easiest way to remedy this situation? I do have the old log file. Is there anyway to append the two logs togehter?
Blank Page In Php Page With Mysql Query
I've installed PHP 5.1.2 manually, along with MySQL 4.1.18. Any php page that contains a mysql function displays a blank page . I read many article on mysql and php configuration and did not find any issue ... I copied the libmysql.dll to the system32 directory I set the extension_dir in php.ini to the extension directory of my PHP installation directory I enabled the MySQL extension in php.ini by uncommenting the line extension=php_mysqli.dll I tested the mysql connection from a dos prompt it worked , i can check ith a show database the list of the databse . But each time i put come synatc mysql in a php page the resultis a blank page . I read that we neee in php5 mysqli.dll but I found only mysql.dll do i have just to renme it..?
PHP Page Displaying When First Hit, Page Not Found On Refresh.
I have installed MYSQL sucessfully and PHP. I usually code in ASP (I know, I know) & SQL Server (Yes OK). And have recently turned to the light! When I load a page for the first time (On IIS) it looks fine and new data change in the database is displayed and it looks great. When I click a link to another page with links to the DB then I get Page Cannot be found, if I go back to the URL for the site (thus index.php) Refresh and then click the link it works??!
Data Corruption
I run a small online business and have recently found something shocking and difficult to explain in my database. A customer placed an order in early October, for three items, one of each item. We are certain that it was one of each item, as confirmed by the PayPal payment, as well as the internal email order notification which listed the quantities. However, in revisiting that order today, the database reports the following quantities: 13, 5, 3 What? I have looked through our (rather sporadic) database backups and found the following numbers: October 5, a day after the order, those quantities are correct (1, 1, 1) October 22, those quantities are skewed, but not all the way!? (12, 4, 3) October 31, it's the same as before (12,4,3) November 11, it's changed (12, 5, 3) November 18, it's changed again (13, 5, 3) Here is the relevant table schema: mysql> describe cart_products; +-----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+-------+ | cart_id | int(11) | NO | MUL | 0 | | | prod_id | int(11) | NO | | 0 | | | quantity | smallint(6) | YES | | 1 | | | extra_part_name | varchar(255) | YES | | NULL | | | prod_type | smallint(6) | NO | | 0 | | +-----------------+--------------+------+-----+---------+-------+ There are 4088 rows in the table. Could this be a case of data corruption? I"m particularly weirded out by the incremental increases in the quantities. I have found one other order which is affected in a similar manner.
Table Corruption On 4.0.14
Are there any known issues with table corrouption on 4.0.14-standard-log? I'm getting recurring problems with a single table becoming corrupted, does mysql handle disk full problems gracefully or could that cause something like this? Code:
Database Corruption
Just want to report that mysql compiled with gcc 3.3.4 also seems to create problems with corrupting the database.
Frequent Table Corruption
Since we upgraded to MySQL 4.0.13 from 3.23, we have been getting table corruption often. It happens about twice per week (with about 500 queries per second average). I have even set up a cron to run mysqlcheck every hour to try to do some damage control. The biggest problem is that once the table is corrupted, it seems to be locked. Well, no clients can read from it. Once repaired, just one record is usually lost for each time the corruption occurs. I am not sure if this is a MySQL bug or even how to reproduce it, but I was hoping that someone here could help. Code:
CONSTANT Corruption On MyISAM (4.0.20a W32)
mySQL (4.0.20a win32), dual amd2200 machine, 4 gigs of DDR ECC memory. I have a series of 33 tables, identical in structure : (field names shortened) CREATE TABLE `dbtable1` ( `FS` varchar(254) NOT NULL default '', `NAM` varchar(254) NOT NULL default '', `H` int(11) NOT NULL default '0', `SIZ` int(11) default NULL, `R` char(1) default NULL, `CI` varchar(254) default NULL, `AV` char(1) default NULL, `CL` int(11) default NULL, `BW` int(11) default NULL, `TS` timestamp(14) NOT NULL, `CO` blob, `AT` varchar(254) default '', `NS` varchar(254) default '', `NL` varchar(254) default NULL, PRIMARY KEY (`FS`), KEY `IDX_TS` (`TS`), KEY `IDX_H` (`H`), KEY `IDX_R` (`R`,`FS`) ) TYPE=MyISAM MAX_ROWS=100000000; The tables are constantly going corrupt at random, IE : 'Can't open file *.MYI (errno : 145)' My understanding is that if the server is shut down incorrectly it can cause this. The server has remained up and stable the whole time. Also, if the table is closed incorrectly..? Is there any way to tell from logs IF and WHEN this may be happening so I can figure out the source of this constant corruption. When using ado/odbc do I have to tell the connection to wait for anything??? My suspicion is it is happening on deleting 1 record... not completely sure though... HINT : Whenever I repair extended on a table, it nearly always says 'Duplicate key records' and it fixed the number of rows to 2 or 3 less (-) than what it thought.... I did increase my key buffer to 1000, and sort buffer size = 2, other than that the ONLY thing I changed was the network simultaneous connections to 200, are there other parameters I need to change to accommodate more memory and more connections?
Constant Table Corruption.
I have to repair my table every single time... Or the data doesn't match up... I look in phpMyAdmin, and it shows a different email address in phpMyAdmin versus the page once I change it. Then I click "repair tables" and they both match. I have no idea whats going on..?
Table Corruption Problem On 4.0.14
cause something like this? # myisamchk -c jobs Checking MyISAM file: jobs Data records: 53484 Deleted blocks: 37182 myisamchk: warning: Table is marked as crashed - check file-size - check key delete-chain - check record delete-chain myisamchk: warning: Not used space is supposed to be: 29749896 but is: 29749108 myisamchk: error: record delete-link-chain corrupted - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 - check data record references index: 4 - check data record references index: 5 - check data record references index: 6 - check data record references index: 7 - check data record references index: 8 - check data record references index: 9 - check record links myisamchk: warning: Found 37181 deleted blocks Should be: 37182 myisamchk: warning: Found 139912 parts Should be: 139913 parts MyISAM-table 'jobs' is corrupted Fix it using switch "-r" or "-o"
What Directory For Basedir ?
What should i set my basedir to ? I thought /var/lib/mysql would work. I am trying to run /mysql_upgrade script but it keeps on bitching about the basedir - can't find the mysql command line client. Which file does this refer to ? Code:
NAS Vs SAN For Data Directory
I am trying to decide which storage I should use for the "Data Directory". My application has lots of 'SELECT's (80%) and fewer UPDATEs/INSERTs(20 %). I have the following choices of Data storage 1) Xiotech SAN (66 Mhz FCAL) 2) NAS 3) Internal SCSI 3 RAID 5 Will I achieve any better performance using one storage vs the other storage? In the past (for about 2 years), I have I used SAN with 33Mhz FCAL, and the performance has been quite exceptional. And I have encountered no problems.
Directory Name Invalid
For testing purposes I have PHP installed and I have MySQL installed on my local laptop. Windows XP Pro I am just learning both of them. I have read quite a few chapters in the MySQL Manual. Enough to allow me to get around in MySQL and directly create tables an view information in them, upload .txt files into the tables, etc etc. I am receiving an error when I try to connect to MySQL via a PHP script. I have no problem connecting to MySQL via Command Line. The error I receive is "The directory name is invalid." Here is my code... I am not sure where to put the directory name or where to put the directory path in order to make it valid. I am not sure what directory it is talking about. <html> <head><title>Connect to MySQL</title></head> <body> <?php //connecting to the mysql server uses a mysql_connect command. $link = mysql_connect("locoalhost",$_POST['username'],$_POST['password']) or die("Connect Error: ", . mysql_error()); echo 'Successfully Connected. '; mysql_close($link); ?> </body> </html> Where exactly would I put the path to the directory or where would I name the directory?
Filerights To Certain Directory
How can I give(grant?) the mysql database rights to write in directory /opt/guide/www.domain.com/HTML/upload/test How should I set my rights. A local user 'userA' should have the rights. How should I set these privaliges without opening the gate for everybody?
Membership Directory
I know this is probably a dumb question for all the experts out there. But I have to ask because I'm trying diligently to work at home and want to be successful. How difficult is it for someone with an Access background and pretty fair understanding of differing programming lagnuages to build a member directory that currently house 16,000+ members. The client wants it done by 8/1. I have yet to sink my teeth into a real web database, shall I take the chance? I'm a quick study and have taught myself most of what I know. I've basically gone to school to learn little things I've missed to Ace a class on something I already know, but is mandatory for my degree.
Working In A Windows Directory...over The Web
Is there a way to set up a database so it reads a windows directory? Like the W:/ drive? Or have a function that moves files from W:/ to C:/? and then have this functionality over the web? Where do I start? I want this to be simple but all the resources I find are complex or more toward website stuff. I’d like to develop the frontend with PHP and have it interact with VB as well.
Using INSERT To Write To A Directory
I have a problem that I'm not sure if it can be done. I'm trying to use the MySQL C API to be able to use a normal sql insert statement that will send the data or file to a directory and NOT the database. I'm not sure if there is anything out there that will allow this, but I've searched everywhere, and I have found no solution.
Errcode 17 In Temporary Directory
I run a web server (on IIS) with a big site on it. It has php5, mysql 5 and odbc 3.51 It has 640MB of ram. at random times I get this error (not always the same file, but similar): [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-log]Can't create/write to file 'C:EasyPHP mp#sql_3fc0_0.MYD' (Errcode: 17) If I go to that directory and delete that file, the problem disappears. But until I do this the pages display a mysql/odbc error and nothin works. So if it happens at night or when I'm out, my website will remain down for a lot. Really annoying problem!! I googled the errcode 17 and found out that it can be caused by: - directory permission problem > this is not my case, I've given correct permissions - an antivirus performing a scan in the temp directory > this is not my case So what is this?! Code:
Create A Directory-search
I'd like to create a form to search in my database that is a directory. It contains an important list of persons with their names, firstnames, telephone numbers etc. Do you know where I could find a script to help me? I'd like to create a multi-criterions form.
MySQL Or Directory Tree?
I'm working on a project where I have about 5 different data structures (objects) consisting of about 15-30 fields each. The size of each object is about 2-4 kB. The maximum number of objects will be in the range 5000-100000 for each object. I need possibility to search, add, delete, update and get these objects by ID, NAME, DATE and VERSION only. I have no need for the individual fields of the objects only complete objects as binary files. When I work with the objects I need access to roughly 5-10% of the objects at a time. Right now I have all these files in a directory tree under Windows XP with ID, NAME, DATE and VERSION included in the file name. I can do all I need but it becomes too slow sometimes. Now to my question: Can I benefit something from moving to a MySQL database when it comes to performance and speed and how should I set up the datbase to make it as fast as possible?
Change Database Directory
I have a linux server and i installed mysql . it's working fine. But i want to change the mysql database dirctory from /var/lib/mysql to /db/ how can i do that.
Creating A Community Directory
The goal is to create entries for a Community Directory: Smith John Sally 8786 Regional Way Somewhere, OR 97224 Child1 Child2 Child3 Using the following code I've been able to get close, but the records are repeated for each entry in the fam table: select concat(hld.l,' ', hld.f,' ', hld.sp,' ', hld.ad,' ',hld.city,' ', hld.st,' ', hld.zip,' ',hld.ph,' ', fam.ff,' ', fam.rel,' ') from hld, fam where k = fk order by hld.l, fam.rel Smith John Sally 8786 Regional Way Somewhere, OR 97224 Child1 Smith John Sally 8786 Regional Way Somewhere, OR 97224 Child2 Smith John Sally 8786 Regional Way Somewhere, OR 97224 Child3 Obviously, I need a way to collect these multiple records into one record like the initial sample above.
Arrays And Altering Directory
I am new to this forum. I intend to share my knowledge of MySQL wid everyone here and also gain more than wat i can share. My queries are: 1.Does MySQL provide arrays. 2.Can i change the directory which stores the databases that are created by the user. Besides Pls check www.mysql.com homepage abt a security alert regardin MySQL on Windows. there is sum worm call UDF........anyways i hope to obtain a reply soon.
Change Database Directory
I have a linux server and i installed mysql . it's working fine. But i want to change the mysql database dirctory from /var/lib/mysql to /db/ how can i do that
Accessing Mysql/bin Directory Problem
This may be very basic question, that I hope some of you can answer very quickly for me. I'm running mysql 4.1 on windows xp just to learn the database, and I'm in a need to run .exe in the bin directory. The problem I'm having is accessing this directory. The path is C:/Program Files/Mysql/Mysql server 4.1/bin but when I get to C:/cd "Program Files/..." I get an error message saying (parameter format not correct - "program) i have tried several things, as well as following a user guide for changing directories that states that if the folder name has spaces use " to access that subfolder...maybe there is a simple tip ...
Optimizing A Large Phone Directory
I have a table with names and contact information for a bunch of people (we'll call it a phone directory -- it's not, but confidentiality prevails ). To get twenty people to display on a single page, I'm using this query: SELECT * FROM people ORDER BY lastName LIMIT 20 Pretty straightforward, but for some reason, with a few hundred thousand rows, this is taking a very long time (and I do have an index on lastName, which doesn't seem to help). Is there anything I can do to speed this up? Also, would it be quicker to have separate firstName and lastName lookup tables with firstNameId and lastNameId columns, using this query: SELECT p.*, f.name as firstname, l.name as lastName FROM people p LEFT JOIN firstNames f ON f.id = p.firstNameId LEFT JOIN lastNames l ON l.id = p.lastNameId ORDER BY l.name LIMIT 20 Unless there's some obvious problem or solution I'm overlooking, the only other thing I can imagine is having ANOTHER table with the alphabetical order of the last names, which might speed things up but seems somewhat unwieldly (though doable, if necessary, since I won't be adding people too often). Hopefully there's some simple problem I'm not seeing (which may be, since it seems like MySQL should scale better than this).
Dropped A Database, But It's Still Showing Up In The Directory
I dropped a database used for practice. Although all the tables are gone, the empty database itself is still there. Is this correct? How do I get use of this empty db? Note: I'm using Mysql version 3.23.49 -nt and I also use mysqlfront although I generally use the command line to work with the dbs.
Storing A Directory Type Structure
I have a requirment to store a directory/group type of structure in a database I have an existing table of items for which i need to be able to store group information in the manner similar to the following: group 1 subgroup 1 subsubgroup1 item1 item2 item3 subsubgroup2 item4 item5 item6 subgroup 2 item 7 item 8 item 9 group 2 item 10 item 11 item 12 The problem i am having is that an item can be in any level of subgrouping and the total level of subroups is undefined.
Move Database In Windows To Different Directory
How do I move a database on a Windows 2000 server box. I have MySQL and found where to point the database in the MY.ini file but I cant seem to move it to another partition. If I change the path in the my.ini file the mysql service fails to start. Any help would be greatly appreciated. I have seen how to do this in unix and linux on this forum but could not find a thread on how to do it in Windows.
Change MySQl Data Directory
I moved the data dirctory to a network drive.... this is why it's not working Is there a way to house the data directory off a networked drive/share?
Moving Data Base From / Var To Home Directory
I'm successfully running MySql under Debian with the data files in /var/lib/mysql. I would like to move the data base files to my home directory and have mysql use them from there. How do I do it? Can I just copy them to my home directory and start mysql with a parameter which point to the new locaion? Can I do that with mysql starting at boot time? I just looked at /etc/init.d/mysql and see that it appears to starts mysql by calling /usr/bin/mysql_safe but there is no such file. As an alternative to putting it in my home directory, I would be happy putting the files in /usr/local. Can I do that without rebuilding mysql? The reason I want to do this is that I want to install a new version of Knoppix and that will format and clean out the / partition and I don't want to loose the data I have in /var/lib/mysql. Could I just save /var/lib/mysql and restore it after installing the new version of the system?
How Can I Protect Databases Externally In The Data Directory
My question is how can i protct databases in the data directory externally? Anyone can copy data from the data directory in mysql server and paste it to another system where another mysql server with same version is loaded. If network security is tightened, still this problem will be there. Because hard disk can be removed and data can be stolen very easily in that case. So is there any solution for this?
Cannot Start Database After Relocating The Data Directory
an error after I have relocated my data directory.I found the pid error-log file "bsd19.err" in the previous data directory and it wrote the following every time when I tried to start my database. [Error]/usr/local/libexec/mysqld: Can't create/write to file: /usr/local/db2 (Errcode: 21) [Error]Can't start server: can't create PID file: Is a Directory I also have "chown" the user as mysql on that directory /usr/local/db2 before I start my database.
Home Directory For Load Data Local Infile?
i have mysql installed in the following directory: C:Program FilesMySQLMySQL Server 4.1 i wish to import a file using this command: load data local infile 'Data_Nov06CG1.X001' into table Nov07_File FIELDS TERMINATED BY ' ' LINES TERMINATED BY ' '; but i keep getting this error: ERROR 2 (HY000): File 'Data_Nov06CG1.X001' not found (Errcode: 2) i tried putting this file in the 'data' folder and the install directory. What am i doing wrong? I have a database called 'all' that i'm using for these tables, should i put it in that database folder?
Import A Directory Of Text Files Into A Mysql Database With Php?
I have a directory of text files that i'd like to import into a msql table... I was wondering if there's an easier way to do this with php/mysql, I'd like to avoid copy/pasting the entire directory (thousands of files) into the database if i can. The directory structure of the text files resembles... somepath/A/Aerosmith/Song Name.txt - (extention varies) What i'd like to do is use php to scan the directory and input the file path information and the content from each file into a table like... Dir Artist Song Text Type ------------------------------------------------------------------------ A Aerosmith Song Name Fa La La La La (example text) File Ext B Beatles Song Name Fa La La La La (example text) File Ext
Which Is The Right Directory To Backup MySQL Database On Linux Opearing System?
Implemented web application using MySQL to maintain inventory of the office PC's/laptops/Routers/hubs and other stuff, here we are using MySQL as back-end Database on Linux Operating system. I need to backp all these Inventory database into CD/Tape/Floppy, which is the right directory (MySQL database) to backup (incase if the current MySQL server crashes, then I should be able keep copy of my inventory),
Web Page
i want to see a web page that contains a list of SQL commands with explanition.
Page Counter
i challenged myself to make a Page Counter (simple i know) but i got an error i can not figure out, it probably something simple like a quote in wrong place, but i cant get it working.... here is my problem: using the code below, i manually enter a number into my MySQL table, and when the page loads, i want the counter to increment, however the PHP program changes the data to "$counu" i think this is because i have set the length of the field to max at 6, and when it increments a string, it changes the t in counter to a u.. dunno... Code:
Web Admin Page?
is there a web admin interface that is included when installing MySQL? If so, what is the url (e.g. http://localhost/mysqladmin)?? I am getting into programming in PHP and want to use MySQL on my development machine (they will both be on the same box to run concurrently). It's a Windows machine running IIS 5.0
Page Numeration
I am looking for a script snippet that will write out a number of pages with prev and next. I already have a numeration function, but I have more than 150 pages in my database, and for this the page numbers are all shown : ex: <prev 1 2 3 4 5 6 7 8 9 10 12 ....etc etc you get the picture....until 149 150 next > I would like a snippet that only writes out 10 page numbers at a time ex: <prev 1 2 3 4 5 6 7 8 9 10 next> ..and after clicking 10 or next> the ten next numbers should be shown: <prev 11 12 13 14 15 16 17 18 19 20 next> Anybody out there who has an idea as how to do that? Code:
Front Page
I am currently working on a site with SMF boards, i have downloaded TP (tinyportal) and i am trying to do a php code so all the threads from a certain board will go on the front page,help me with this code?
Many Page Hits
I would like to chart the number of times a page has been view for the past 40 days. Whenever the page gets a hit, a timestamp is recorded for that page. The following query returns all the hits in the past 40 days (statDuration): CODESELECT * FROM Stats WHERE ListingFk = #URL.ad# AND DATE(timeStampStats) > #statDuration# ORDER BY timeStampStats DESC
Queries Pr.page
I use php/mysql for website, I am on novice level, - meaning I do not write php classes and such. I keep it real simple, with a simple db, full of records. question is; how many queries is normally run on a complexed site? take DevShed and imagine it was run on mysql, how many queries aprox does it need to get loaded? I am currenlty doing about 10 different queries pr. page to bring out some user details and different records of the user using 3-4 different db-tables.. and I wonder if this is normal, or if it's extremly bad programming / db design..? it loads fast enough, but it just seems alot.
|
TRACKER
