Firestone Technical Resources

"Personal service for your impersonal technology."

News Articles

Articles posted here are for the use of our clients to get quick self help answers to questions and simple solutions to problems. News reports are not necessarily the opion of our company but for reference only. We don't provide any guarantee that solutions posted or referenced will work for your situation and that you should use them at your own risk. None of the information posted should be used for illegal practices.

VMware vCenter Server Appliance with embedded database fails due to full database partition

vCenter Server Appliance with an embedded vPostgres database may stop running with out any warning. After logging into the web user interface (web UI) of the appliance you may notice that, in the Storage Usage on the Summary tab, the database statistics are showing 100%. Attempting to start the vCenter Server services at this point will result in the service running for a brief moment before is automatically shuts down again. This occurs because a disk partition on the vPostgres database contains no free space.

VMware doesn't have any recommended preventative maintenance tasks at this time but it doesn't hurt to establish your own in order to prevent this sort of issue in the first place. There is a retention policy for the database and we will look at why that may not be adequate for some installations.

Continue reading
0
  2101 Hits
  0 Comments
2101 Hits
0 Comments

MySQL Import of SQL file fails with error 1064

On a number of occasions I have attempted to import an exported MySQL database file and received the following message.

/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?# -------------------------------------------------------- # Host:     ' at line 1 */ /* Error with snippets directory: The specified path was not found */ # -------------------------------------------------------- # Host:                         127.0.0.1# Server version:               5.5.40 - MySQL Community Server (GPL) # Server OS:                    Win32 # HeidiSQL version:             7.0.0.4053 # Date/time:                    2014-01-20 09:48:36 # --------------------------------------------------------

Continue reading
0
  1589 Hits
  0 Comments
1589 Hits
0 Comments