[Mod_log_sql] Connection errors

[peter]

Edward
Thanks for getting back to me on this. I was actually getting ready to
post another email on this topic.

I did considerable testing yesterday with this mod and have found a
solution. 1) I increased my allowed connections to mysql 2) I turned on
LogSQLMassVirtualHosting On

#2 seems to have fixed all of the connection errors as well as solving
the problem of manually creating tables for each host.

I now have another issue which I'll post in a new email.

Thanks again,
Peter


On Mon, 2007-16-07 at 08:56 -0400, Edward Rudd wrote:
> peter wrote:
> > Hi list
> > I'm running a Debian Etch amd64 server and have mod-log-sql and
> > mod-log-sql-mysql running. 
> > 
> > mysql server version: 5.0.32-Debian_7etch1-log
> > MySQL client version: 5.0.32
> > 
> > Apache 2.2
> > 
> > It all seems to be working okay but there are a tremendous amount of
> > connection errors occurring in my logs like the sample below. At the
> > same time of course my mod_log_sql-preserve is filling up as well. I've
> > tried changing my access_log table to MyISAM and InnoDB but it has not
> > helped.
> 
> Try verifying that the SQL queries placed in mod_log_sql-preserve are
> actually valid SQL queries.  As when the [error] mysql_query returned
> (1) shows up in the log file that means a SQL error occurred (table not
> found, field not found, invalid SQL, etc...)
> 
> I have changes in the mod_log_sql SVN trunk to mod_log_sql_mysql.c that
> produce much better logging of these mysql_query errors so it is easier
> to figure out the issue. You download the file from SVN and replace it
> in the 1.101 source distribution and rebuild.  But running the sql
> queries manually in the mysql query browser or mysql shell will give you
> the same information, ie. if there is something wrong w/ the query.
> 
> Also, paste the relevant LogSQL configuration options in your apache
> configuration to the mailing list (removing your password from the
> connect config option, of course) and it'll better help me diagnose the
> issue.
> 
> > Any hints to fix this would be appreciated. 
> > 
> > [Sat Jul 14 19:46:02 2007] [error] mysql_query returned (1)
> > [Sat Jul 14 19:46:02 2007] [notice] db reconnect successful
> > [Sat Jul 14 19:46:02 2007] [error] mysql_query returned (1)
> > [Sat Jul 14 19:46:02 2007] [error] second attempt failed
> > 
> > Regards,
> > Peter
> > 
> > _______________________________________________
> > Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/
> > 
> > To unsubscribe send an e-mail to 
> > mod_log_sql-unsubscribe at lists.outoforder.cc
> 
> 
> _______________________________________________
> Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/
> 
> To unsubscribe send an e-mail to 
> mod_log_sql-unsubscribe at lists.outoforder.cc