What is the difference between a Linked Server retruning the message "Out
of memory" and "MySQL client ran out of memory"
we have a Microsoft SQL Server running a bunch of jobs every hour, half
the jobs call local stored procedures while the other half calls stored
procedures on a MySQL Database
in the past we normally get
[SQLSTATE 01000] (Error 0) OLE DB provider "MSDASQL" for linked server
"LNKSVR" returned message "Out of memory.".
when we get these we can't can't run any code that relies on the Linked
Server, to fix this we normally reset the server, not too much of a
problem as it's a testing server
recently, we got this error
[SQLSTATE 01000] (Error 0) OLE DB provider "MSDASQL" for linked server
"LNKSVR" returned message "[######][#######][###############]MySQL client
ran out of memory".
now according the jobs, one job fired off the top error, 1 hour later it
worked fine then the hour after that it returned the second error, now
none of the jobs will suceed because they can't seem to open the tables on
the linked server, also when i try and do a SELECT * FROM LNKSVR...table
in Microsoft SQL Server Management Studio it says it can't open the table
however if i go into the MySQL Database using phpmyadmin and run the same
query (minus the LNKSVR...) i get the table fine
now to me, the solution to this would be to just do like we always do and
reset the MSSQL Server however it's that second message that's bugging me,
so i am wondering, is there a difference between these two errors and if
so what is it?
No comments:
Post a Comment