Protein Production
293FT, 293E, CHO

Truly Functional Protein
95% Purity
1-10 mg in 2 weeks

GeneExpressoMax™
293Expresso™

Transfection Reagents
* 90% Efficiency
* 95% Viability
* No sera interference
* Simple protocol
* High-throughput
* Only $98/ml

Baculovirus
Functional Protein
95% Purity
Fast turnaround
1-10 mg from Sf9 cells

Adenovirus, AAV
& Lentivirus

ORF or shRNA
* High Titer
* Cre, FLP, ΦC31
* Protein Kinases
* Transcription Factors
* Luciferases, GFP, RFP
* Protein Production
* Stable Cell Line


Excellgen

MySQL InnoDB database recovery from crash due to disk-full

Cause of crash: Disk full.

when you try to start MySQL using this command:

/etc/rc.d/init.d/mysqld start

it failed to start.

So you check log file:

tail -100 /var/log/mysqld.log

and you see:

071120 18:36:06 mysqld started
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
071120 18:36:06 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...
InnoDB: Last MySQL binlog file position 0 110344596, file name ./mysql-bin.000082
071120 18:36:06 InnoDB: Started; log sequence number 0 3039427084
/usr/libexec/mysqld: File './mysql-bin.000082' not found (Errcode: 2)
071120 18:36:06 [ERROR] Failed to open log (file './mysql-bin.000082', errno 2)
071120 18:36:06 [ERROR] Could not open log file
071120 18:36:06 [ERROR] Can't init tc log
071120 18:36:06 [ERROR] Aborting

071120 18:36:06 InnoDB: Starting shutdown...
071120 18:36:09 InnoDB: Shutdown completed; log sequence number 0 3039427084
071120 18:36:09 [Note] /usr/libexec/mysqld: Shutdown complete

071120 18:36:09 mysqld ended

Easy fix: open mysql-bin.index, delete all content in the file and restart MySQL again.

Tags:

November 20, 2007 at 9:21 pm

Leave a Comment

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word


Sponsored Links Excellgen http://www.labsupplymall.com

Baculovirus Protein Expression
Fast turn around, >95% purity functional protein. No outsourcing to China or India. $5500, $3950
Recombinant Lentivirus & Adenovirus
High Yield and High Titer up to 1010 (lentivirus) and 1013 (adenovirus) for Guaranteed Expression of GOI. $3000, $2500
Transient Protein Expression in CHO and HEK293 Cells
Transient Expression, Truly Functional Protein, 95% purity, 1~20 mg, fast turnaround. $5500, $3950