Posts

Showing posts from November 24, 2018

Random hardware issues and hard crashes

Image
up vote 1 down vote favorite So. I have had a battle going on with my aging desktop and stability. Here is the original specs: CPU: Intel i5 2500k , No overclock. RAM: Corsair Vengance 1600MHz 16GB (4x4GB) Running at 1333 MHz. Motherboard: AsRock P67 Extreme4 Gen3 manual Graphics: Nvidia 570GTX ( MSI OEM design ) OS: Windows 10 Events up until now: So a little over a week ago, my rig would not boot all of a sudden. Got the post code 32 for "CPU post-memory initialization is started". Okay. Time to check memory. Started systematically to check to see if it was the sockets, memory module, or the controller. While going through all the different configurations, except single module, I got shifting error codes, including not being able to detect the graphics card. Now when I install all four DIMMs, I ju

What should I change to avoid Aurora MySQL Error 1034 when executing this INSERT statement?

Image
up vote 0 down vote favorite I consistently get this error ( Error Code: 1034. Incorrect key file for table '/rdsdbdata/tmp/#sql_1709_0'; try to repair it ) in Amazon Web Services (AWS) Aurora MySQL 5.7 when I run the following INSERT statement (or run the SELECT clause in the INSERT statement as a separate SELECT statement). What do I need to change about the INSERT statement (or the AWS Aurora MySQL 5.7 instance or other AWS ecosystem components) so that I don't get this error? (I'm not primarily interested in how to repair the temp table that is referenced in the error message - I want to avoid getting the error in the first place, since this INSERT statement will run as part of a larger script). The INSERT statement is as follows: INSERT INTO GEO_AREA ( Geo_Area_Nm, Geo_Area_Abrv, Geo_Area_Full_