I don’t see problem in FW R16.3 with attached testsql.zip, you can try my application.
testsql.zip (2.4 MB)
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c app_Create() 3258 | Creating app 'testsql'
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | proc.c GetFaultAction() 326 | No fault action specified for process 'testsql'. Assuming 'ignore'.
Jan 6 08:15:15 swi-mdm9x28-wp user.warn Legato: -WRN- | supervisor[1027]/supervisor T=main | proc.c GetWatchdogAction() 362 | testsql watchdogAction '' in proc section
Jan 6 08:15:15 swi-mdm9x28-wp user.warn Legato: -WRN- | supervisor[1027]/supervisor T=main | proc.c GetWatchdogAction() 362 | testsql watchdogAction '' in proc section
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c app_Start() 3471 | Starting app 'testsql'
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/dev/log' to '/legato/systems/current/appsWriteable/testsql/dev/log'.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/dev/null' to '/legato/systems/current/appsWriteable/testsql/dev/null'.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/dev/zero' to '/legato/systems/current/appsWriteable/testsql/dev/zero'.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/dev/urandom' to '/legato/systems/current/appsWriteable/testsql/dev/urandom'.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/legato/systems/current/lib/liblegato.so' to '/legato/systems/current/appsWriteable/testsql/lib/liblegato.so'.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/lib/ld-linux.so.3' to '/legato/systems/current/appsWriteable/testsql/lib/ld-linux.so.3'.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/lib/libc.so.6' to '/legato/systems/current/appsWriteable/testsql/lib/libc.so.6'.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/lib/libpthread.so.0' to '/legato/systems/current/appsWriteable/testsql/lib/libpthread.so.0'.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/lib/librt.so.1' to '/legato/systems/current/appsWriteable/testsql/lib/librt.so.1'.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/lib/libdl.so.2' to '/legato/systems/current/appsWriteable/testsql/lib/libdl.so.2'.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/lib/libgcc_s.so.1' to '/legato/systems/current/appsWriteable/testsql/lib/libgcc_s.so.1'.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/lib/libm.so.6' to '/legato/systems/current/appsWriteable/testsql/lib/libm.so.6'.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/usr/lib/libstdc++.so.6' to '/legato/systems/current/appsWriteable/testsql/lib/libstdc++.so.6'.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/legato/systems/current/apps/testsql/read-only/lib/libsqlite3.so.0' to '/legato/systems/current/appsWriteable/testsql/lib/libsqlite3.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/legato/systems/current/apps/testsql/read-only/lib/libComponent_testsqlComponent.so' to '/legato/systems/current/appsWriteable/testsq
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/legato/systems/current/apps/testsql/read-only/lib/libsqlite3.so' to '/legato/systems/current/appsWriteable/testsql/lib/libsqlite3.so
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/legato/systems/current/apps/testsql/read-only/bin/testsql' to '/legato/systems/current/appsWriteable/testsql/bin/testsql'.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2084 | Skipping file link '/legato/systems/current/apps/testsql/read-only/lib/libsqlite3.so' to '/legato/systems/current/appsWriteable/testsql/lib/libsqlite3.s
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2084 | Skipping file link '/legato/systems/current/apps/testsql/read-only/lib/libsqlite3.so.0' to '/legato/systems/current/appsWriteable/testsql/lib/libsqlite3
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateTmpFs() 1788 | Mounted tmpfs at /legato/systems/current/appsWriteable/testsql/tmp.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/tmp/legato/serviceDirectoryServer' to '/legato/systems/current/appsWriteable/testsql/tmp/legato/serviceDirectoryServer'.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | app.c CreateFileLink() 2154 | Created file link '/tmp/legato/serviceDirectoryClient' to '/legato/systems/current/appsWriteable/testsql/tmp/legato/serviceDirectoryClient'.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | resourceLimits.c GetCfgResourceLimit() 207 | Configured resource limit maxStackBytes is not available. Using the default value 0.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | proc.c proc_Start() 1403 | Starting process 'testsql' with pid 4276
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[1027]/supervisor T=main | supervisor.c SigChildHandler() 899 | Reaping unconfigured child process 4272.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[4276]/supervisor T=main | proc.c proc_Start() 1363 | Execing 'testsql'
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[4276]/supervisor T=main | resourceLimits.c SetRLimitValue() 301 | Setting resource limit maxCoreDumpFileBytes to value 524288.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[4276]/supervisor T=main | resourceLimits.c SetRLimitValue() 301 | Setting resource limit maxFileBytes to value 524288.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[4276]/supervisor T=main | resourceLimits.c SetRLimitValue() 301 | Setting resource limit maxLockedMemoryBytes to value 8192.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[4276]/supervisor T=main | resourceLimits.c SetRLimitValue() 301 | Setting resource limit maxFileDescriptors to value 256.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[4276]/supervisor T=main | resourceLimits.c SetRLimitValue() 301 | Setting resource limit maxMQueueBytes to value 512.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[4276]/supervisor T=main | resourceLimits.c SetRLimitValue() 301 | Setting resource limit maxThreads to value 20.
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | supervisor[4276]/supervisor T=main | resourceLimits.c SetRLimitValue() 301 | Setting resource limit maxQueuedSignals to value 100.
Jan 6 00:15:15 swi-mdm9x28-wp user.debug Legato: DBUG | UNKNOWN[4276]/framework T=main | mem.c InitPool() 400 | Memory pool name 'framework.PositionalCallbackRecPool' is truncated to 'framework.PositionalCallbackRec'
Jan 6 00:15:15 swi-mdm9x28-wp user.debug Legato: DBUG | UNKNOWN[4276]/framework T=main | mem.c InitPool() 400 | Memory pool name 'framework.MessagingClientInterfaces' is truncated to 'framework.MessagingClientInterf'
Jan 6 00:15:15 swi-mdm9x28-wp user.debug Legato: DBUG | UNKNOWN[4276]/framework T=main | mem.c InitPool() 400 | Memory pool name 'framework.hashMap_MessagingServices' is truncated to 'framework.hashMap_MessagingServ'
Jan 6 00:15:15 swi-mdm9x28-wp user.debug Legato: DBUG | UNKNOWN[4276]/framework T=main | mem.c InitPool() 400 | Memory pool name 'framework.hashMap_MessagingClients' is truncated to 'framework.hashMap_MessagingClie'
Jan 6 00:15:15 swi-mdm9x28-wp user.debug Legato: DBUG | UNKNOWN[4276]/framework T=main | fs.c fs_Init() 916 | FS prefix path "/data/le_fs/"
Jan 6 00:15:15 swi-mdm9x28-wp user.debug Legato: DBUG | UNKNOWN[4276]/ T=main | _componentMain.c _testsqlComponent_Init() 30 | Initializing testsqlComponent component library.
Jan 6 00:15:15 swi-mdm9x28-wp user.debug Legato: DBUG | testsql[4276]/framework T=main | mem.c InitPool() 400 | Memory pool name 'framework.msgs-LogControlProtocol' is truncated to 'framework.msgs-LogControlProtoc'
Jan 6 00:15:15 swi-mdm9x28-wp user.debug Legato: DBUG | testsql[4276]/framework T=main | messagingSession.c le_msg_SetSessionRecvHandler() 2078 | SetSessionRecv: Unix socket session
Jan 6 00:15:15 swi-mdm9x28-wp user.debug Legato: DBUG | testsql[4276]/framework T=main | mem.c le_mem_ForceAlloc() 1172 | Memory pool 'framework.SigMonitor' overflowed. Expanded to 1 blocks.
Jan 6 00:15:15 swi-mdm9x28-wp user.debug Legato: DBUG | testsql[4276]/framework T=main | mem.c le_mem_ForceAlloc() 1172 | Memory pool 'framework.SigHandler' overflowed. Expanded to 1 blocks.
Jan 6 00:15:15 swi-mdm9x28-wp user.debug Legato: DBUG | testsql[4276]/testsql_exe T=main | _main.c main() 59 | == Starting Event Processing Loop ==
Jan 6 00:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276]/testsqlComponent T=main | testsqlComponent.c _testsqlComponent_COMPONENT_INIT() 136 | Component SQLAppComponent started.
Jan 6 00:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276]/testsqlComponent T=main | testsqlComponent.c createDb() 24 | Successfully Created
Jan 6 00:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276]/testsqlComponent T=main | testsqlComponent.c Create_Table() 65 | InitOperations Command For Table Creation
Jan 6 00:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276]/testsqlComponent T=main | testsqlComponent.c Create_Table() 78 | Executed Command For Table Creation
Jan 6 00:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276]/testsqlComponent T=main | testsqlComponent.c insertData() 89 | Insert Command
Jan 6 00:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276]/testsqlComponent T=main | testsqlComponent.c insertData() 103 | !!!rc value : 0
Jan 6 00:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276]/testsqlComponent T=main | testsqlComponent.c insertData() 107 | Record created successfully
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] | ID = 5
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] | NAME = XXXX
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] | AGE = 30
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] | ADDRESS = India
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] | SALARY = 30000.0
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] |
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] | ID = 6
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] | NAME = YYYY
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] | AGE = 34
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] | ADDRESS = India
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] | SALARY = 30000.0
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] |
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] | ID = 7
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] | NAME = ZZZZ
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] | AGE = 32
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] | ADDRESS = India
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] | SALARY = 30000.0
Jan 6 08:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276] |
Jan 6 00:15:15 swi-mdm9x28-wp user.info Legato: INFO | testsql[4276]/testsqlComponent T=main | testsqlComponent.c View_Table() 127 | !!! Tabled viewed Successfully
Jan 6 08:15:15 swi-mdm9x28-wp user.notice kernel: [ 912.082131] audit: type=1400 audit(315965715.221:5): lsm=SMACK fn=smack_inode_getattr action=denied subject="app.testsql" object="admin" requested=r pid=4276 comm="testsql" path="pipe:[14570]" dev="pipefs" ino=14570