Title: Intermittently crashes when sqlite3_prepare_v2 called with sqlite version 3.15.2 · Issue #976 · sqlitebrowser/sqlitebrowser · GitHub
Open Graph Title: Intermittently crashes when sqlite3_prepare_v2 called with sqlite version 3.15.2 · Issue #976 · sqlitebrowser/sqlitebrowser
X Title: Intermittently crashes when sqlite3_prepare_v2 called with sqlite version 3.15.2 · Issue #976 · sqlitebrowser/sqlitebrowser
Description: Details for the issue I am using sqlite in multi-threaded environment where multiple applications use sqlite queries to perform get/set operations on attributes available in sqlite db tables. Intermittently i am seeing applications crash...
Open Graph Description: Details for the issue I am using sqlite in multi-threaded environment where multiple applications use sqlite queries to perform get/set operations on attributes available in sqlite db tables. Inter...
X Description: Details for the issue I am using sqlite in multi-threaded environment where multiple applications use sqlite queries to perform get/set operations on attributes available in sqlite db tables. Inter...
Mail addresses
sqlite-users@mailinglists.sqlite.org
Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/976
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Intermittently crashes when sqlite3_prepare_v2 called with sqlite version 3.15.2","articleBody":"### Details for the issue\r\nI am using sqlite in multi-threaded environment where multiple applications use sqlite queries to perform get/set operations on attributes available in sqlite db tables. Intermittently i am seeing applications crashing when get operation is performed which intern call sqlite3_prepare_v2.\r\nCrash is not frequent. I rarely see this issue. One thing to notice that, I never hit this issue when i was using 3.8.10.2. First time i hit the issue only after updating 3.15.2. \r\nFollowing is the GDB back trace for the same. Please let me know if this is a known issue and if its fixed in latest sqlite version.\r\n#0 0x4ffc9494 in __aeabi_memcpy8 () at ../sysdeps/arm/armv7/multiarch/memcpy_impl.S:352\r\n#1 0x4194d514 in whereLoopXfer (pFrom=0x19a560, pTo=0x1c14d0, db=\u003coptimized out>) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:129646\r\n#2 whereLoopInsert (pTemplate=pTemplate@entry=0x19a560, pBuilder=0x1c2858, pBuilder=0x1c2858) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:64414\r\n#3 0x419700f0 in whereLoopAddBtree (pBuilder=0x1c2858, pBuilder@entry=0x0, mPrereq=7281790634533488) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:130653\r\n#4 0x419892fc in whereLoopAddAll (pBuilder=0x0) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:131229\r\n#5 sqlite3WhereBegin (pParse=pParse@entry=0xbec43e68, pTabList=0x0, pTabList@entry=0x1c2850, pWhere=pWhere@entry=0xbec43cd0, pOrderBy=\u003coptimized out>, pDistinctSet=0x1c2e50,\r\n wctrlFlags=48760, iAuxArg=320) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:1283\r\n#6 0x4198d8e0 in sqlite3Select (pParse=pParse@entry=0xbec43e68, p=\u003coptimized out>, pDest=0x0, pDest@entry=0xbec43e08)\r\n at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:119546\r\n#7 0x419b8358 in yy_reduce (yyruleno=\u003coptimized out>, yypParser=0x1b2990) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:135340\r\n#8 sqlite3Parser (pParse=0xbec43e68, yyminor=..., yymajor=\u003coptimized out>, yyp=\u003coptimized out>) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:5377\r\n#9 sqlite3RunParser (pParse=pParse@entry=0xbec43e68, zSql=0xe8 \u003cerror: Cannot access memory at address 0xe8>,\r\n zSql@entry=0x198248 \"SELECT \u003cCOLUMNS> FROM \u003cTABLE> WHERE \u003cCONDITIONS>\"..., pzErrMsg=0x1c1dd0, pzErrMsg@entry=0xbec43e58) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:6324\r\n#10 0x419bdae8 in sqlite3Prepare (db=db@entry=0x19be78,\r\n zSql=zSql@entry=0x198248 \"SELECT \u003cCOLUMNS> FROM \u003cTABLE> WHERE \u003cCONDITIONS>\"..., nBytes=nBytes@entry=233, saveSqlFlag=-1094435176, saveSqlFlag@entry=1, pReprepare=pReprepare@entry=0x0, ppStmt=ppStmt@entry=0xbec440d8,\r\n pzTail=pzTail@entry=0x0) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:114126\r\n#11 0x419bdfb4 in sqlite3LockAndPrepare (db=0x19be78,\r\n zSql=0x198248 \"SELECT \u003cCOLUMNS> FROM \u003cTABLE> WHERE \u003cCONDITIONS>\"..., nBytes=233, saveSqlFlag=1, pOld=0x0, ppStmt=0xbec440d8, pzTail=0x0) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:114217\r\n#12 0x419be27c in sqlite3_prepare_v2 (db=\u003coptimized out>,\r\n zSql=zSql@entry=0x198248 \"SELECT \u003cCOLUMNS> FROM \u003cTABLE> WHERE \u003cCONDITIONS>\"..., nBytes=\u003coptimized out>, ppStmt=ppStmt@entry=0xbec440d8, pzTail=pzTail@entry=0x0)\r\n at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:114293\r\n\u003c!--\r\nI am using sqlite in multi-threaded environment where multiple applications use sqlite queries to perform get/set operations on attributes available in sqlite db tables. Intermittently i am seeing applications crashing when get operation is performed which intern call sqlite3_prepare_v2.\r\nCrash is not frequent. I rarely see this issue. One thing to notice that, I never hit this issue when i was using 3.8.10.2. First time i hit the issue only after updating 3.15.2. \r\nFollowing is the GDB back trace for the same. Please let me know if this is a known issue and if its fixed in latest sqlite version.\r\n#0 0x4ffc9494 in __aeabi_memcpy8 () at ../sysdeps/arm/armv7/multiarch/memcpy_impl.S:352\r\n#1 0x4194d514 in whereLoopXfer (pFrom=0x19a560, pTo=0x1c14d0, db=\u003coptimized out>) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:129646\r\n#2 whereLoopInsert (pTemplate=pTemplate@entry=0x19a560, pBuilder=0x1c2858, pBuilder=0x1c2858) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:64414\r\n#3 0x419700f0 in whereLoopAddBtree (pBuilder=0x1c2858, pBuilder@entry=0x0, mPrereq=7281790634533488) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:130653\r\n#4 0x419892fc in whereLoopAddAll (pBuilder=0x0) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:131229\r\n#5 sqlite3WhereBegin (pParse=pParse@entry=0xbec43e68, pTabList=0x0, pTabList@entry=0x1c2850, pWhere=pWhere@entry=0xbec43cd0, pOrderBy=\u003coptimized out>, pDistinctSet=0x1c2e50,\r\n wctrlFlags=48760, iAuxArg=320) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:1283\r\n#6 0x4198d8e0 in sqlite3Select (pParse=pParse@entry=0xbec43e68, p=\u003coptimized out>, pDest=0x0, pDest@entry=0xbec43e08)\r\n at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:119546\r\n#7 0x419b8358 in yy_reduce (yyruleno=\u003coptimized out>, yypParser=0x1b2990) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:135340\r\n#8 sqlite3Parser (pParse=0xbec43e68, yyminor=..., yymajor=\u003coptimized out>, yyp=\u003coptimized out>) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:5377\r\n#9 sqlite3RunParser (pParse=pParse@entry=0xbec43e68, zSql=0xe8 \u003cerror: Cannot access memory at address 0xe8>,\r\n zSql@entry=0x198248 \"SELECT COLUMN_X FROM TABLE WHERE CONDITIONS\"..., pzErrMsg=0x1c1dd0, pzErrMsg@entry=0xbec43e58) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:6324\r\n#10 0x419bdae8 in sqlite3Prepare (db=db@entry=0x19be78,\r\n zSql=zSql@entry=0x198248 \"SELECT COLUMNS FROM TABLE WHERE CONDITIONS\", nBytes=nBytes@entry=233, saveSqlFlag=-1094435176, saveSqlFlag@entry=1, pReprepare=pReprepare@entry=0x0, ppStmt=ppStmt@entry=0xbec440d8,\r\n pzTail=pzTail@entry=0x0) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:114126\r\n#11 0x419bdfb4 in sqlite3LockAndPrepare (db=0x19be78,\r\n zSql=0x198248 \"SELECT COLUMNS FROM TABLE WHERE CONDITIONS\"..., nBytes=233, saveSqlFlag=1, pOld=0x0, ppStmt=0xbec440d8, pzTail=0x0) at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:114217\r\n#12 0x419be27c in sqlite3_prepare_v2 (db=\u003coptimized out>,\r\n zSql=zSql@entry=0x198248 \"SELECT COLUMNS FROM TABLE WHERE CONDITIONS\"..., nBytes=\u003coptimized out>, ppStmt=ppStmt@entry=0xbec440d8, pzTail=pzTail@entry=0x0)\r\n at /usr/src/debug/sqlite3/3_3.15.2.0-r0/sqlite-autoconf-3150200/sqlite3.c:114293\r\n\r\n-->\r\n\r\n\r\n\r\n### Useful extra information\r\n\r\n\u003c!-- The info below often helps, please fill it out if you're able to. :) -->\r\n\r\n#### I'm opening this issue because:\r\n\r\n- [x] DB4S is crashing\r\n- [ ] DB4S has a bug\r\n- [ ] DB4S needs a feature\r\n- [ ] DB4S has another problem\r\n\r\n#### I'm using DB4S on:\r\n\r\n- [ ] Windows: ( _version:_ ___ )\r\n- [x] Linux: ( _distro:_ ___ )\r\n- [ ] Mac OS: ( _version:_ ___ )\r\n- [ ] Other: ___\r\n\r\n#### I'm using DB4S version:\r\n\r\n- [ ] 3.9.1\r\n- [ ] 3.9.0\r\n- [x] Other: ___\r\n\r\n#### I have also:\r\n\r\n- [ ] Tried out the nightly version: https://github.com/sqlitebrowser/sqlitebrowser#windows\r\n- [x] Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20\r\n","author":{"url":"https://github.com/romio102","@type":"Person","name":"romio102"},"datePublished":"2017-03-08T11:54:46Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/976"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:95a1492b-e0a8-d9d4-dae4-69a18312fbac |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | B854:30AF58:249CDC4:32E0619:6AFD3574 |
| html-safe-nonce | 0958d11a260fbf1399240e96074fe9733112d0ffc22658f65fbb9fb451d405ca |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCODU0OjMwQUY1ODoyNDlDREM0OjMyRTA2MTk6NkFGRDM1NzQiLCJ2aXNpdG9yX2lkIjoiNTM5MDU4NTI1NDI0OTMxMzY1MiIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 50823170e19974a519949ff7abf08a9a80d4d2746178774a8459506f0070fa38 |
| hovercard-subject-tag | issue:212714040 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/976/issue_layout |
| twitter:image | https://opengraph.githubassets.com/770d17e42a3e6a09c2ef369e8d1761f443d3bcd2368d485adcbae57a02709779/sqlitebrowser/sqlitebrowser/issues/976 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/770d17e42a3e6a09c2ef369e8d1761f443d3bcd2368d485adcbae57a02709779/sqlitebrowser/sqlitebrowser/issues/976 |
| og:image:alt | Details for the issue I am using sqlite in multi-threaded environment where multiple applications use sqlite queries to perform get/set operations on attributes available in sqlite db tables. Inter... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | romio102 |
| hostname | github.com |
| expected-hostname | github.com |
| None | 065128366c233a9d57ff68ab6c96e25b99dd1b0ab70d23b70873d3dd6b5e4f19 |
| turbo-cache-control | no-preview |
| go-import | github.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git |
| octolytics-dimension-user_id | 7454271 |
| octolytics-dimension-user_login | sqlitebrowser |
| octolytics-dimension-repository_id | 19416551 |
| octolytics-dimension-repository_nwo | sqlitebrowser/sqlitebrowser |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 19416551 |
| octolytics-dimension-repository_network_root_nwo | sqlitebrowser/sqlitebrowser |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 941021edf0c2ec58298f4a2c8f27ae507d129c92 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width