Posts Tagged ‘error’

‘table_name . frm is locked against change’ MySQL Error and Recovery

Tuesday, January 19th, 2010

Each MySQL table is represented by an . frm file on disk, no matter which storage engine you use. An . frm file describes the table definition and possesses the same name as of table. The corruption of . frm file leads to table inconsistencies. It could happen due to improper locking of table, DLL file errors, system faults, disk issues, virus attack, unexpected shutdown etc. You need to use your recent data backup to restore data in such situations. However, if data backup exists in invalid state, or is not available at all, you need to use MySQL Database Recovery applications that prove to be safe tools for repairing damaged MySQL databases.

You might receive the following error message with MySQL database table(s):

“. frm is locked against change”

Cause

The primary cause for the occurrence of above error message is corruption of . frm file.

Solution

In order to correct such corruption errors, you require following these steps:

CHECK TABLE tablename [options]

If you are using MyISAM, you can alternatively run ‘mysqlcheck’ or ‘myisamchk’ command-line utilities.

REPAIR TABLE tablename [options]

For MyISAM tables, use of ‘mysqlcheck’ or ‘myisamchk’ is also applicable.

Stellar Phoenix Database Recovery For MySQL is a premier utility to repair and restore damaged MySQL tables. The software supports MySQL 5. x. It can recover database files for both InnoDB (. ibdata, . ibd and . frm) and MyISAM (. myd, . myi and . frm) database storage engines. It can restore all database objects, like tables, relations, primary key(s), and others. It can recover databases of Windows and Linux platforms and is compatible with Windows Vista, XP, 2003, and 2000.

Tags: , , , , , ,
Posted in mysql | No Comments »

‘Found key at pagethat points…’ MySQL Error

Friday, January 15th, 2010

Normal 0 false false false MicrosoftInternetExplorer4

MySQL Server organizes its data files as a single unit and their locations are allocated as per database instance. All MySQL instance data files are located in a single file system directory, usually called Data. These data files hold records. But sometimes, MySQL Server reports errors that it has found a key at a page which references a record lying outside the data file. Such kinds of errors generally indicate the specific table is corrupted and needs to be repaired. In critical situations (generally when MySQL repair utility fails to repair the database), you require using your recent database backup to restore. But many times, you don’t have clean database backup that could perform complete restoration. Such situations necessitate the use of MySQL Recovery products as the effective database repair solution.

As an example, you might receive the below error message with your MySQL Server database:

warning: clients are using or haven’t closed the table properly

error    : Found key at pagethat points to record outside datafile

error    : Corrupt

This error is specific to MyISAM database engine and is encountered when you run mysqlcheck -u {USERNAME} {DATABASE} [TABLE] command to check the consistency of the database table. Where, DATABASE and TABLE refers to the name of specific database and table, respectively.

Cause

MyISAM database table is corrupted. The most probable reason for this error to occur is unexpected shutdown. Another possibility is that database is opened at various users’ ends.

Solution

Before making any database repair action, make sure that the database is properly closed at all the ends. You also need to ensure that the server is shut down or in other words, all the tables are inactive. To perform MyISAM database table repair, issue the following command:

mysqlcheck -r -u {USERNAME} {DATABASE} [TABLE]

Next, rerun the mysqlcheck -u {USERNAME} {DATABASE} [TABLE] command to check if table corruption goes away. If the issue persists, restore from backup or make use of MySQL database recovery applications. Built with powerful database repair technology, these MySQL Recovery applications provide effective and safe recovery of damaged MySQL database and its objects.

Stellar Phoenix Database Recovery For MySQL is a comprehensive MySQL Database Recovery utility that provides safe and instant database repair. It supports MySQL Server 4. x and 5. x. It provides complete recovery for InnoDB (. ibdata, . ibd and . frm) and MyISAM (. myd, . myi and . frm) files. It can recover databases created on Windows and Linux platforms. The software is compatible with Windows Vista, XP, 2003 and 2000.

Tags: , , , ,
Posted in mysql | No Comments »

‘RT couldn’t store your session…. ’ MySQL Error

Friday, January 1st, 2010

For MySQL, RT (Request Tracker) is the ticket-tracking system that coordinates its tasks. It is also responsible for managing requests among several users. RT stores your MySQL session. But if you are getting errors that RT is not able to accomplish the task, a MySQL table might be corrupt that is preventing RT to store the session. You are recommended to check your database backup status as you might need to restore using it. However, in case backup fails to restore, you can repair it using advanced MySQL Repair solutions.

You might receive the below error message while accessing or using MySQL database:

“RT couldn’t store your session.   This may mean that that the directory isn’t writable or a database table is missing or corrupt. ”

Cause

The prime cause of such error messages to occur is MySQL table corruption that should be immediately repaired.

Solution

To correct such issues, you should consider following these steps:

mkdir /extra/var

mkdir /extra/var/lib

mv /var/lib/mysql /extra/var/lib/mysql

ln -sn /extra/var/lib/mysql /var/lib/mysql      

MySQL Repair software are well-built tools that can make safe and complete repair of your damaged MySQL database and its components. Such software are anchored with rich support to advanced features, interactive interface and read-only design. Thus, you can use them for getting safe and easy MySQL Recovery.

Stellar Phoenix Database Recovery For MySQL is a superior quality MySQL Repair tool that supports both InnoDB (. ibdata, . ibd and . frm) and MyISAM (. myd, . myi and . frm) database storage engines. It is an advanced tool to restore all database objects, such as tables, relations, table schemas, primary key(s) etc. It is compatible with Windows Vista, XP, 2003, and 2000 and can also recover databases installed on Linux platform. It supports MySQL 5. x.

Tags: , , , , ,
Posted in mysql | No Comments »

Linux and VLC error messages for help. ?

Monday, September 28th, 2009

I now have more than 10 fedora-install VLC media player. When I opened it, songs, two errors let me play, this song sounds really unstable. This is what is wrong, I run. . . How do I fix it?
  Summary:
SELinux is it possible to avoid loading vlc / usr/lib/sse2/libswscale.??. 0 6. One that
  Do you need to move the text.
  Detailed Description:
  Try to load the VLC application / usr/lib/sse2/libswscale.??. 0. 6th One that
  Do you need to move the text. This is a potential security risk. Most libraries
  Do not need this permission. Libraries are sometimes coded incorrectly
  Require this permission. SELinux memory protection tests
(Http: / / person. Red Hat. Com / Drepper / SELinux medium. HTML) Web page describes how
  Delete this provision. You can configure SELinux temporarily to allow
/ Usr/lib/sse2/libswscale.??. 0. 6. A move with a workaround until the
  The library is fixed. Please send an error report
(Http: / / bugzilla Hat. Red. Com / bugzilla / enter_bug. CGI) resistance to the program.
  Provides access to:
  If you trust / usr/lib/sse2/libswscale.??. 0. 6. A normal operation, you can
  Textrel_shlib_t As part of the document. "chcon – t textrel_shlib_t
'/ Usr/lib/sse2/libswscale.??. 0. 6. 1 ' "You also have to change the default file
  Into the system within the scope of documents to keep them even in the entire label.
"semanage fcontext – 1 – t textrel_shlib_t '/ usr/lib/sse2/libswscale. Sun 0.6. 1 ' "
  Repair command:
chcon – T textrel_shlib_t '/ usr/lib/sse2/libswscale.??. 0. 6. 1 '
  For more information:
  Source Context unconfined_u: unconfined_r: unconfined_exe …
  In the finish area system_u: object_r: lib_t: s0
  / Should usr/lib/sse2/libswscale.??. 0. 6. 1 [File]
  Source vlc
  Source Path / usr / bin / vlc in
  Port
  Moderator Andrew. Altizer
  Source RPM package vlc-core – 0 9. Article 8 a – 1 fc10
  FFmpeg package target speed – libs from – 0 4. 9-0. 52. 20080908. fc10
  Speed SELinux policy, politics, 3 5. 13-18. fc10
  SELinux is enabled true
  The nature of the policy specifically
  Enable Alliance, agrees
  Enforcement mode
  Plug-in name allow_execmod
  The host name Andrew. Altizer
  Andrew's Linux platform. Altizer 2nd 6. 27. 5117. fc10. # 1 SMP i686
  Tuesday at 12:19:59 on 18 November 2008 i686 Athlon Journal
  Alert 4
  Seen Monday at 13:43:28 on January 5, 2009 1 Transaminase
  Last look at Monday at 13:56:42 on January 5, 2009 AST
  Symbol 143b1d8e – 4C8F – 4189 – A377 – d97326d786c4
  LineNumber
  The original audit messages
  Node = Andrew. Altizer type = AVC MSG = (test 1231153002. 320:27): AVC: refusal (for Telecommunications Exhibition execmod PID = 3452) = "in vlc 'path =" / usr/lib/sse2/libswscale. So. 0. 6. 1 "dev = in Mark – 0 BAO = 2551557 scontext = unconfined_u: unconfined_r: uncontrolled … tcontext = system_u: object_r: lib_t: s0 tclass = file
  Node = Andrew. Altizer type = (system call MSG = audit 1231153002. 320:27): arch = 40,000,003 syscall = 125 success = no exit =- 13 Leia 21c000 cell A1 = 2C000 = ± 2 = 5 ± 3 = bfb3d1e0 item = 0 = 1 PPID other PID = 3452 = 500 AUID UID, GID = 500 euid = 500 = 500 = 500 fsuid the Egid = 500 suid = 500 set-group-id = 500 fsgid the tty = 500 = (No), Ministry of Economic Telecommunications Services Exhibition = = 1 "in vlc exe file =" / usr / bin / vlc in "subject = unconfined_u: unconfined_r: unconfine … key = (empty)
?. . . . . .
  Summary:
SELinux is to prevent loading to vlc / usr/lib/sse2/libpostproc.??. 51. 2. 0
  Do you need to move the text.
  Detailed Description:
  Try to load the VLC application / usr/lib/sse2/libpostproc.??. 51. 2. 0
  Do you need to move the text. This is a potential security risk. Most libraries
  Do not need this permission. Libraries are sometimes coded incorrectly
  Require this permission. SELinux memory protection tests
(Http: / / person. Red Hat. Com / Drepper / SELinux medium. HTML) Web page describes how
  Delete this provision. You can configure SELinux temporarily to allow
/ Usr/lib/sse2/libpostproc.??. 51. 2. 0 moving with a workaround until the
  The library is fixed. Please send an error report
(Http: / / bugzilla Hat. Red. Com / bugzilla / enter_bug. CGI) resistance to the program.
  Provides access to:
  If you trust / usr/lib/sse2/libpostproc.??. 51. 2. 0 normal operation, you can
  Change the file in the textrel_shlib_t. "chcon – t textrel_shlib_t
'/ Usr/lib/sse2/libpostproc.??. 51. 2. 0 ' "You also have to change the default file
  Into the system within the scope of documents to keep them even in the entire label.
"semanage fcontext – 1 – t textrel_shlib_t '/ usr/lib/sse2/libpostproc. Sun 51.2. 0 ' "
  Repair command:
chcon – T textrel_shlib_t '/ usr/lib/sse2/libpostproc.??. 51. 2. 0 '
  For more information:
  Source Context unconfined_u: unconfined_r: unconfined_exe …
  In the finish area system_u: object_r: lib_t: s0
  Audience / usr/lib/sse2/libpostp

Tags: , , ,
Posted in FFmpeg Hosts | 1 Comment »