xsql---Buffer too small for record data



The situation here is the inability of RSQL server to serializethe query’s response. The cause of the failure is that the size of the bufferRSQL uses for the serialization procedure is just not large enough to fit allthe data. In their query, Fiberhome requires all instances ofclass OltGlobalCfg. They have just one instance of this class (a kind ofsystem configuration structure) Analyzing the class we found that it’s huge.Moreover it has  a complicated structure. The largestfield onuApMacInfo is an array of structures. This structure of the classrequires even more buffer size, so RSQL failed to serialize the whole instanceof the class, but was able to return a partial request. 

 

To resolve this, our recommendation is to increase the buffersize. The size can be specified as one of SqlServer constructor parameters. Thedefault value is 64K, but we recommend specifying at least 256K. Here is theirRSQL initialization procedure (from db_common/src/sqlintf.cpp):

 

int start_sqlsvr(int isMst)

{

               int iPort = SERVER_PORT + (isMst?0:1000);

               

               server = new SqlServer(&engine, iPort);

 

               server->start();

               return 0;

}

 

 

Please add another parameter to the constructor call, like thefollowing:

 

               server = new SqlServer(&engine, iPort, 256 * 1025 );

 

 

And, of course, re-build their application.