Portal Home > Knowledgebase > Articles Database > Weird database errors after moving servers
Weird database errors after moving servers
| Posted by Owdy, 12-02-2012, 03:46 PM |
| After i moved server, i get these database errors:
Google says its full /tmp, but it isnt that:
I have Ubuntu server. How do i fix that?
|
| Posted by UNIXy, 12-02-2012, 03:52 PM |
| Without knowing about your database configuration, engines, etc, the fastest way would be to dump the DB and then load it back again (mysqldump).
Regards
|
| Posted by Dr_Michael, 12-02-2012, 04:14 PM |
| Have you perfomed a repair to your db?
|
| Posted by Owdy, 12-02-2012, 04:18 PM |
| Yes, but mysqlcheck -r says database is okay. Only with one table, it says" The storage engine for the table doesn't support repair" Table type is "MEMORY"
|
| Posted by UNIXy, 12-02-2012, 04:30 PM |
| The table /tmp/#sql_362_0.MYI is temporary (resulted from a query). Repair won't help. It's possible you're running out of disk space on /tmp so MySQL doesn't have enough storage to create the temporary table. But your DB is probably smaller than 1.5G. Even though it's small one or multiple queries can still lead to a temp disk table being created that's larger than your /tmp mount.
Change the tmpdir in my.cnf to /home/tmp instead. You have plenty of disk space available there. But you should be looking at why your queries need so much temp disk storage to complete.
Regards
|
| Posted by Owdy, 12-02-2012, 04:32 PM |
| tmp has 1.8G free space. It cant be that. Database is 600mb
Last edited by Owdy; 12-02-2012 at 04:37 PM.
|
| Posted by UNIXy, 12-02-2012, 04:35 PM |
| It's possible. /tmp size fluctuates up and down as temp disk bound queries are executed. If you have several queries 200MB each you'll run out of /tmp disk space.
Regards
|
| Posted by Owdy, 12-02-2012, 04:39 PM |
| Okay, is there way to look what creates so huge quoeries?
I didnt have this issue in my old server. It was smaller.
|
| Posted by UNIXy, 12-02-2012, 05:05 PM |
| A large temporary on-disk query will take long to run. So log queries that take longer than a second to run.
How often is this error happening?
|
| Posted by Owdy, 12-03-2012, 07:07 AM |
| Can i use /var/tmp ?
Hard to tell, im testing new server, it does that in there, N00b quoestion, but how do i log them?
Last edited by Owdy; 12-03-2012 at 07:14 AM.
|
| Posted by Owdy, 12-04-2012, 11:52 AM |
| Okay, tell me if this is possible. I moved server again. And again database started doing huge querys.
Okay. i dumped database and reimported it again. Seems everything is fine after that. Could this be some version error and reimporting fixed it?
|
| Posted by Owdy, 12-04-2012, 03:14 PM |
| I found issue. Its one of my scripts. IP.Content.
|
Add to Favourites 
Print this Article
Also Read
