MySQL client ran out of memory (mysql to MS-SQL)

• UltimateOne

  SSC Enthusiast

  Points: 115

  More actions

  July 1, 2010 at 2:29 pm

  #157049

  Hello Forum!

  I understnad this may be a mysql problem, but I am not sure; I hope the forum can help with this one...

  I am running mysql 5.0.45 on my Asterisk phone system. I have an automated job that runs on an open query from my MS-SQL Server 2005 to pull in call data on a nightly basis.

  A few days ago, I started experiencing a strange MS-SQL Server error, basically reporting that the "MySQL client ran out of memory". The error reported by MS-SQL Server is shown below:

  Executed as user: xxx\administrator. Cannot execute the query "SELECT * FROM asteriskcdrdb.cdr" against OLE DB provider "MSDASQL" for linked server "RKPHONE". [SQLSTATE 42000] (Error 7320) OLE DB provider "MSDASQL" for linked server "RKPHONE" returned message "[MySQL][ODBC 3.51 Driver][mysqld-5.0.45]MySQL client ran out of memory". [SQLSTATE 01000] (Error 7412). The step failed.

  Here is part of the query I'm trying to run:

  SELECT SUBSTRING(LTRIM(RTRIM(src)),LEN(LTRIM(RTRIM(src)))-9,10) as src, max(calldate) as last_date

  into tmp_dialer.dbo.tmp_dialer_src

  FROM OPENQUERY(RKPHONE, 'SELECT * FROM asteriskcdrdb.cdr')

  group by SUBSTRING(LTRIM(RTRIM(src)),LEN(LTRIM(RTRIM(src)))-9,10)

  Here is the strange part: If I run the job MS-SQL Server job manually, it runs perfectly fine.

  Does anyone have any ideas?