# WP7607 Libsqlite Error In Legato application **URL:** \ **Category:** Uncategorized\ **Created:** [July 17, 2026, 4:49am UTC](https://forum.legato.io/t/wp7607-libsqlite-error-in-legato-application/7017 "2026-07-17T04:49:13Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![elmanju07](https://avatars.discourse-cdn.com/v4/letter/e/b5e925/32.png) [@elmanju07](https://forum.legato.io/u/elmanju07)\ **Post date:** [July 17, 2026, 4:49am UTC](https://forum.legato.io/t/wp7607-libsqlite-error-in-legato-application/7017/1 "2026-07-17T04:49:14Z")
I am facing the an issue supervisor[1258]/supervisor T=main | app.c CreateFileLink() 2277 | **Failed to create link at ‘/usr/lib/libsqlite3.so.0’ in app ‘GPS’** I have also verified the SQLite library being used in our build environment. Please find the details below: \*\*SQLite Library Path: ~/.leaf/wp76-toolchain\_SWI9X07Y\_03.01.14.00-linux64/sysroots/armv7a-neon-poky-linux-gnueabi/usr/lib/libsqlite3.so SQLite Library Version: 3.31.1 \*\* harshalp@harshalp-VirtualBox:~/Documents/WP\_VSCODE$ ls -al total 134808 drwxrwxr-x 6 harshalp harshalp 4096 Jul 9 17:47 . drwxr-xr-x 35 harshalp harshalp 4096 Jul 7 12:01 .. drwxrwxr-x 3 harshalp harshalp 4096 Jul 5 09:55 \_build\_DataConnection drwxrwxr-x 3 harshalp harshalp 4096 Jul 9 17:47 \_build\_intangles\_vscode drwxrwx— 11 harshalp harshalp 4096 Jul 12 20:37 EdgePrime\_WP -rw-rw-r-- 1 harshalp harshalp 138007541 Jul 5 10:33 EdgePrime\_WP\_backup\_2026-07-05\_1033.tar.gz drwxrwxr-x 3 harshalp harshalp 4096 Jul 5 09:47 leaf-data -rw-rw-r-- 1 harshalp harshalp 317 Jul 5 09:47 leaf-workspace.json harshalp@harshalp-VirtualBox:~/Documents/WP\_VSCODE$ leaf shell Leaf Shell /bin/bash started in Leaf environment. (lsh:hp\_dev) harshalp@harshalp-VirtualBox:~/Documents/WP\_VSCODE$ leaf status ┌─────────────────────────────────────────────────────────────────────────────────────┐ │ Workspace: /home/harshalp/Documents/WP\_VSCODE │ ╞═════════════════════════════════════════════════════════════════════════════════════╡ │ Profile: hp\_dev [current] (sync) │ ├──────────┬───────────────────────────┬──────────────────────────────────────────────┤ │ Packages │ Identifier │ Description │ ├──────────┼───────────────────────────┼──────────────────────────────────────────────┤ │ Included │ swi-wp76\_7.0.0 │ SDK for WP76 (Release 17.1 + Legato 21.05.5) │ │ │ swi-vscode-support\_200624 │ VS Code features support for legacy SDKs │ └──────────┴───────────────────────────┴──────────────────────────────────────────────┘ (lsh:hp\_dev) harshalp@harshalp-VirtualBox:~/Documents/WP\_VSCODE$ Please find the Below FW information for your Reference: root@swi-mdm9x28-wp:~# cm info Device: WP7607-1 IMEI: 359780088395631 IMEISV: 15 FSN: EE440210671210 Firmware Version: SWI9X07Y\_02.37.06.25 f306c7 jenkins 2025/07/24 02:45:36 Bootloader Version: SWI9X07Y\_02.37.06.25 f306c7 jenkins 2025/07/24 02:45:36 MCU Version: 002.015 PRI Part Number (PN): 9911513 PRI Revision: 001.000 Carrier PRI Name: GENERIC-VD Carrier PRI Revision: 001.003\_000 SKU: 1105149 Last Reset Cause: Reset, User Requested Resets Count: Expected: 179 Unexpected: 1 root@swi-mdm9x28-wp:~# app status [stopped] FileUpload [running] MHN\_OBD\_MainApp [running] UART\_OBD [stopped] Upgrade [running] atAirVantage [running] atQmiLinker [running] atService [running] audioService [running] avcService [running] cellNetService [running] dataConnectionService [running] fwupdateService [running] gpioService [running] modemService [running] portService [running] positioningService [running] powerMgr [running] powerService [running] qmiAirVantage [running] secStore [stopped] smsInboxService [stopped] spiService [stopped] tools [stopped] voiceCallService [stopped] wifi [running] wifiService [running] GPS [running] SQLITE [running] Int\_MainApp root@swi-mdm9x28-wp:~# legato version 21.05.5\_e1c8d649d5d40ccffb5018edc0ad303f\_modified root@swi-mdm9x28-wp:~# cat /etc/legato/version Build created at 2025-08-06\_10:08:44 Yocto build version: SWI9X07Y\_03.01.14.00 Build host: jenkins Versions: - firmware: SWI9X07Y\_03.01.14.00 - poky: yocto-3.1.15-44-g38c55bd388 - meta-openembedded: 86b864a4d8 - meta-swi: 4c8281fa0 - meta-swi-extras: e41a336ef - linux-msm-4.14: 4.14.253 - Manu ---
**Author:** ![jyijyi](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.legato.io/jyijyi/32/822_2.png) [@jyijyi](https://forum.legato.io/u/jyijyi)\ **Post date:** [July 17, 2026, 5:39am UTC](https://forum.legato.io/t/wp7607-libsqlite-error-in-legato-application/7017/2 "2026-07-17T05:39:32Z")
do these help? > [@Undefined reference when using mksys, but not mkapp](https://forum.legato.io/t/undefined-reference-when-using-mksys-but-not-mkapp/6550/21): > > I found that the problem is in .cdef, you cannot add requires: { lib: { ../third-party/lib/libsqlite3.so } } Otherwise, it will have multiple definition problem during compilation in R16 package. (not quite understand the root cause as no problem is found for compilation in R13 package) As you mentioned above, you need to add “-L $(CURDIR)/…/third-party/lib/libsqlite3.so” in Makefile for mkapp. However, for mksys, I don’t know where to add such “-L $(CURDIR)/…/third-part… > **[Database Support](https://mangoh.discourse.group/t/database-support/93/15)** > > Hi Nila , Please download the Source code present https://sqlite.org/download.html i.e sqlite-amalgamation-3190300.zip Make a folder structure for Sqlite3 as mkdir third-party cd third-party mkdir inc mkdir src mkdir lib Copy... BTW, are you using unsandboxed application to create link in /usr/lib? ---
**Author:** ![elmanju07](https://avatars.discourse-cdn.com/v4/letter/e/b5e925/32.png) [@elmanju07](https://forum.legato.io/u/elmanju07)\ **Post date:** [July 17, 2026, 6:30am UTC](https://forum.legato.io/t/wp7607-libsqlite-error-in-legato-application/7017/3 "2026-07-17T06:30:25Z")
hI @jyijyi No ,I am using the Sandbox appplication to create an link in /usr/lib Thanks Manu ---
**Author:** ![jyijyi](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.legato.io/jyijyi/32/822_2.png) [@jyijyi](https://forum.legato.io/u/jyijyi)\ **Post date:** [July 17, 2026, 7:39am UTC](https://forum.legato.io/t/wp7607-libsqlite-error-in-legato-application/7017/4 "2026-07-17T07:39:29Z")
I don’t see problem in FW R16.3 with attached testsql.zip, you can try my application. [testsql.zip](https://forum.legato.io/uploads/short-url/aYKZFaSLmCAHrw6l02Jf2RWnbkW.zip) (2.4 MB) ```auto 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 ```