WP7607 Libsqlite Error In Legato application

[elmanju07]

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

  Thanks

• Manu

[jyijyi]

do these help?

Undefined reference when using mksys, but not mkapp

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

BTW, are you using unsandboxed application to create link in /usr/lib?

[elmanju07]

hI @jyijyi

No ,I am using the Sandbox appplication to create an link in /usr/lib

Thanks

Manu

[jyijyi]

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