Other important questions to ask when troubleshooting database issues

Asking the following might help:

•	Is the page seen when browsing Xinet drawn from the database or the file system?

You can check the page source for this information: most browsers allow you to search the page source when you’ve opened it. Try searching for the text db. If nothing matches this string, then the files on that page are coming directly from the file system, which will be marked with the notation fs (for file system) or gd (for globald).

•	Is dblogd(8) running?

To determine if the dblogd(8) daemon is running:

Unix: ps -ef | grep dblogd

Windows: Check for dblogd.exe in the Task Manager

•	Is the database running?

To determine if the mysql daemon is running, you can do the following:

Unix: ps -ef | grep mysqld
Windows: Check for mysqld-nt.exe in the Task Manager

Another clue is that if the Admin window contains only “undefined” values, then the database is not running, or is running but a connection to it from Xinet cannot be made.

•	Is the database accessible at all?

Try logging in on the command-line using:

Unix: /usr/etc/venture/bin/mysql -u root -p
Type the password at the prompt.
Type: use webnative;

Windows: \Program Files\Xinet\Venture\Bin\mysql -u root -p
Type the password at the prompt
Type: use webnative;

If this login succeeds, then the database is running and a connection can be made on the command-line, at least.

•	Is a synchronization process underway?

A synchronization process can take many forms (described in Syncs initiated using the Volume tab).

Here's how to look for a running sync process:

Unix: ps -ef | grep syncvoltodb
ps -ef | grep userperms
ps -ef | grep dblogd

Windows: Check for syncvolotdb.exe in the Task Manager.
Check for userperms.exe in the Task Manager.
Check for dblogd.exe in the Task Manager.

•	Is a database backup underway?

To determine if a backup process is running:

Unix: ps -ef | grep dbmgr
The dbmgr process will run with the flag -quickbackup
or -fullbackup.

Windows: Check for dbmgr.exe in the Task Manager.

 

•	Is FullText index creation underway?

Unix: ps -ef | grep dbmgr
The dbmgr process will run with the flag -addfilenameindex

Windows: Check for dbmgr.exe in the Task Manager.

You can also check for the presence of the file #sql_XXXXX.MYI in the Xinet data directory. This is the temporary file where the FullText index is being created.

•	Are files being added behind dblogd(8)’s back?

Check the venture.log file (described in The venture.log and venturelog.old files and The Database log) for messages about out of sync in directories that have been modified with files without using ksd(1M), any of the other Xinet “ks” utilities or Xinet.

If this is the case, and if you are regularly using shell scripts, FTP uploads, SMB or NFS mounts or any other method to get files onto your Xinet-enabled volumes not using ksd(1M), Xinet “ks” utilities or Xinet, then please see What to do if events are not getting into the database for more detail on using this kind of workflow with Xinet.