android.database.sqlite.SQLiteException: cannot start a transaction within a transaction at android.database.sqlite.SQLiteStatement.native_executeSql(Native Method) on devices with Adreno 2.. GPUs running ICS

NEW
Unassigned

Status

()

Firefox for Android
General
P5
critical
6 years ago
2 years ago

People

(Reporter: Scoobidiver (away), Unassigned)

Tracking

({crash, steps-wanted})

Trunk
ARM
Android
crash, steps-wanted
Points:
---

Firefox Tracking Flags

(firefox16 affected, firefox17 affected, firefox18 affected, firefox19+ wontfix, firefox20- affected, firefox21 affected, fennec+)

Details

(Whiteboard: [native-crash], crash signature)

(Reporter)

Description

6 years ago
There are 136 crashes across all Firefox versions. Here is a crash report: bp-3a5a05d8-4062-4481-82b9-15c3d2120730.
It's similar to bug 752828 except the exception type.

android.database.sqlite.SQLiteException: cannot start a transaction within a transaction
	at android.database.sqlite.SQLiteStatement.native_executeSql(Native Method)
	at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:90)
	at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:2032)
	at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1972)
	at android.database.sqlite.SQLiteDatabase.beginTransaction(SQLiteDatabase.java:695)
	at android.database.sqlite.SQLiteDatabase.beginTransaction(SQLiteDatabase.java:586)
	at org.mozilla.fennec.db.BrowserProvider.update(BrowserProvider.java:1479)
	at android.content.ContentProvider$Transport.update(ContentProvider.java:219)
	at android.content.ContentResolver.update(ContentResolver.java:862)
	at org.mozilla.gecko.db.LocalBrowserDB.updateVisitedHistory(LocalBrowserDB.java:209)
	at org.mozilla.gecko.db.BrowserDB.updateVisitedHistory(BrowserDB.java:105)
	at org.mozilla.gecko.GlobalHistory.add(GlobalHistory.java:122)
	at org.mozilla.gecko.Tab$10.run(Tab.java:538)
	at android.os.Handler.handleCallback(Handler.java:605)
	at android.os.Handler.dispatchMessage(Handler.java:92)
	at android.os.Looper.loop(Looper.java:137)
	at org.mozilla.gecko.GeckoBackgroundThread.run(GeckoBackgroundThread.java:31)

More reports at:
https://crash-stats.mozilla.com/report/list?signature=android.database.sqlite.SQLiteException%3A+cannot+start+a+transaction+within+a+transaction+at+android.database.sqlite.SQLiteStatement.native_executeSql%28Native+Method%29
(Reporter)

Updated

5 years ago
status-firefox16: --- → affected
status-firefox17: --- → affected
status-firefox19: --- → affected
(Reporter)

Updated

5 years ago
status-firefox18: --- → affected
status-firefox20: --- → affected
status-firefox21: --- → affected
(Reporter)

Comment 2

5 years ago
It's #9 top crasher in 18.0, #34 in 19.0b2, #32 in 20.0a2, and #24 in 21.0a1.
tracking-fennec: --- → ?
tracking-firefox19: --- → ?
Keywords: topcrash

Comment 3

5 years ago
Has this jumped up in volume to a topcrash with FF18's release, or has this just happened gradually over time? https://crash-stats.mozilla.com/topcrasher/byversion/FennecAndroid/17.0/14 shows this is a top crash in FF17 over the last 14 days as well.

We'll grab device correlations and URLs in the meantime, in preparation for QA testing.
Assignee: nobody → lucasr.at.mozilla
Flags: needinfo?(kairo)
Keywords: needURLs, qawanted, steps-wanted
23 	about:blank
7 	about:home
3 	http://www.google.com/mobile/
3 	http://www.desert-operations.com.pt/game.html
2 	http://www.google.com/search?q=zongshen+cyclone+125&tbm=isch&gs_l=mobile-heirloo
1 	http://m.baidu.com/ssid=0/from=844b/bd_page_type=1/uid=BC8BB3078D32E288BE109A7F6
1 	http://maps.google.com/intl/en/help/maps/streetview/#utm_campaign=en&utm_medium=
1 	https://twitter.com/WahyuNovery
1 	https://play.google.com/store/apps/details?id=net.lepeng.batterydoctor&hl=en
1 	http://www.setsunan.ac.jp/s/family/
1 	http://dvikzz.forumid.net/f1-twitter
1 	http://m.macys.com/?cm_mmc=wifi-_-publicwifi-_-ME003-_-ALL
1 	http://de.slideshare.net/affiliateboy/betrug-im-affiliatemarketing
1 	http://m.detik.com/inet/read/2013/01/23/093239/2150292/654/ini-dia-bocoran-panas
1 	https://www.google.com/search?q=holly+haston+stand+cumshot&hl=en&safe=off&tbm=is
1 	http://instagram.com/p/U6p2N3DmxD/
1 	http://tempsreel.nouvelobs.com/l-histoire-du-soir/20130119.OBS5954/elle-est-accu
1 	http://www.google.hu/search?q=olasz+esk%C3%BCv%C5%91i+ruha+budapest+olcs%C3%B3t&
1 	http://www.sneakersnstuff.com/en/341/xmassale?utm_source=RuleMailer&utm_medium=E
1 	https://www.google.com/search?q=sunye+wonder+girls&ie=utf-8&oe=utf-8&aq=t&rls=or
1 	http://www.synology.com/products/vs240hd.php?lang=ita
1 	http://www.google.ca/
1 	http://www.tnpsc.gov.in/new_index.html
1 	https://www.google.com/search?q=alumina+s+i776%2C+Internet+gratis%21%21%21%21%21
1 	http://www.desert-operations.it/game.html
1 	http://www.bear411.com/mobmenu.php
1 	https://www.google.com/search?q=wwe+the+rock+butt&ie=utf-8&oe=utf-8&aq=t&rls=org
1 	http://www.liverpoolsky.net/
1 	https://www.google.com/search?q=wanted+Hollywood+fzmovies.net&oe=utf-8&rls=org.m
1 	http://www.appiator.com/
1 	http://m.accuweather.com/en/gb/winsford/cw7-3/hourly-weather-forecast/322260?p=s
1 	https://www.4shared.com/
1 	http://priaoncam.blogspot.com/2012/07/indonesian-sex-party-series-fucking.html?m
1 	http://daniel-bouhs.de/2013/01/22/gunther-jauch-setzt-die-6-tage-regel-durch/
1 	http://cara-membuat.net/kerajinan-tangan-dari-botol-aqua
1 	https://www.google.com/search?q=audrey+bitoni&hl=id&safe=off&tbm=isch&ei=qasCUZf
1 	http://s.tabelog.com/fukuoka/A4004/A400401/40028373/dtlrvwlst/4402535/?srt=&rvw_
1 	http://m.youtube.com/#/watch?v=syZDDICccFg&desktop_uri=%2Fwatch%3Fv%3DsyZDDICccF
1 	http://instagram.com/p/U4HoI7jmxU/
1 	http://game.desert-operations.com.pt/world1/kt.php
1 	http://api.mastterfollow.com/massfollow.php
1 	http://auctions.search.yahoo.co.jp/search?p=%E3%83%87%E3%83%83%E3%83%89%E3%82%B9
1 	https://www.google.com/search?q=jenaveve+indian&hl=id&safe=off&tbm=isch&ei=AE37U
1 	http://www.kariyer.net/WebSite/Kariyerim/cv/showcv.aspx?refnumber=3%2bOP7B5F4Vey
1 	https://addons.mozilla.org/en-US/android/themes/
1 	http://www.glk.edu.pl/
1 	http://m.facebook.com/?refsrc=http%3A%2F%2Fwww.facebook.com%2F&_rdr
1 	http://bensoutlet.com/products/battery-set
1 	http://www.vedlap.eoldal.hu/cikkek/kozerdeku-infok/egyenruharazi-bolt-arlistaja.
1 	http://archiveofourown.org/works/333072?view_full_work=true
1 	http://www.jet2.com/
1 	http://www.angel-live.com/sphone_top.html
1 	https://www.google.com/search?q=ca&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:
1 	http://www.yahoo.co.jp/
1 	https://m.facebook.com/1832612724/timeline/story?ut=2&hash=4786923707378667762&w
1 	http://www.google.pt/
1 	https://www.google.com/search?q=cara+memasak+babi+kecap&ie=utf-8&oe=utf-8&aq=t&r
1 	http://www.globe7.com/downloadg7.php
1 	http://my.xertive.com/index.php?timeout=1&redir=/tab.php
1 	http://www.myspace.com/jymponter/music/songs?filter=featured#
1 	https://www.google.com/search?q=www.google.com&ie=utf-8&oe=utf-8&aq=t&rls=org.mo
1 	http://www.billa.cz/Layouts/dd_bi_startseite.aspx?folderId=138212&pageId=1172321
1 	http://www.edbozarthlasvegas.com/
1 	https://www.google.com/search?q=audrey+bitoni+party&hl=id&safe=off&tbm=isch&ei=-
1 	http://nh.craigslist.org/csr/
1 	http://babylon-translator.software.informer.com/9.0/download/
(Reporter)

Comment 5

5 years ago
(In reply to Alex Keybl [:akeybl] from comment #3)
> Has this jumped up in volume to a topcrash with FF18's release, or has this
> just happened gradually over time?
The second. It was around #13 top crasher in 16.0.2 and 17.0. If it has entered the top 10 (threshold for mobile top crashes), it's because some other top-10 crashers have been fixed.

> We'll grab device correlations
Here they are:
android.database.sqlite.SQLiteException: cannot start a transaction within a transaction at android.database.sqlite.SQLiteStatement.native_executeSql(Native Method) 	202
Sony ST21i 	40
Sony ST23i 	20
Kyocera C5155 	11
Hisense AD683G 	11
HUAWEI U8815 	8
Sony ST21a 	8
Samsung SGH-I727 	7
Hisense E860 	6
Sony ST21i2 	5
NEC N-07D 	4
Samsung SGH-T989 	4
HUAWEI U8860 	4
SHARP SBM106SH 	4
Samsung SGH-I747 	3
Sony ST26i 	3
Samsung SGH-I727R 	3
Kyocera Rise 	3
HUAWEI U8666E 	3
ZTE Blade III 	3
Sony ST21a2 	3
Sony ST23a 	2
NEC N-05D 	2
PANTECH PantechP9070 	2
SHARP SH-09D 	2
ZTE ZTE BLADE III 	2
FUJITSU F-11D 	2
Asus PadFone 	2
ZTE Turkcell Maxi Plus 5 	2
HUAWEI C8812 	2
Motorola MB886 	2
SHARP SH-07D 	2
Motorola XT925 	2
Unknown Cross A2 	1
ZTE ZTE T22 	1
Zte V8000_USA_Cricket 	1
Unknown S100 	1
Unknown Q-Smart S18 	1
Unknown GP501 	1
Samsung SGH-I747M 	1
PANTECH IM-T100K 	1
HUAWEI Ascend G300 	1
HUAWEI U8950N-51 	1
KYOCERA URBANO PROGRESSO 	1
GIGABYTE GSmart G1342 	1
FUJITSU MOBILE COMMUNICATIONS LIMITED 101F 	1
Basewin T1Ci 	1
FUJITSU F-09D 	1
Micromax A100 	1
Motorola DROID RAZR HD 	1
Anpei N10 	1
SHARP ISW16SH 	1
SHARP SBM107SH 	1
PANTECH IM-A830L 	1
PANTECH ADR910L 	1
NEC N-04D 	1
PANASONIC P-07D 	1
SHARP SH-01E 	1

Almost every devices use an Adreno 200 serie GPU.

Note that JB is unaffected.
Flags: needinfo?(kairo)
Keywords: needURLs
Summary: android.database.sqlite.SQLiteException: cannot start a transaction within a transaction at android.database.sqlite.SQLiteStatement.native_executeSql(Native Method) on ICS → android.database.sqlite.SQLiteException: cannot start a transaction within a transaction at android.database.sqlite.SQLiteStatement.native_executeSql(Native Method) on devices with Adreno 2.. GPUs running ICS
Kevin, can you please give some of these urls a shot to check if it is reproducible ?

Lucas, you have helped with similar database crashes recently.Passing on to you to check if you have any ideas ?
QA Contact: kbrosnan
1. This does not seem to be a content crash so URLs seem unlikely to reproduce. 

2. All of these phones seem to be released in Asian countries. The specific OS customizations that ship with these phones might be a good path to investigate.

Comment 8

5 years ago
needinfo on lucasr for the second part of comment 6.
Flags: needinfo?(lucasr.at.mozilla)

Comment 9

5 years ago
(In reply to Kevin Brosnan [:kbrosnan] from comment #7)
> 2. All of these phones seem to be released in Asian countries. The specific
> OS customizations that ship with these phones might be a good path to
> investigate.

Who is in a better position than QA to investigate?
Maybe Moz Japan has a couple of devices

CC'ing Brian, Makoto andMasayuki,

Updated

5 years ago
tracking-firefox19: ? → +
tracking-firefox20: --- → +

Updated

5 years ago
status-firefox19: affected → wontfix

Comment 11

5 years ago
I added some information to bug #752828 (comment 31-33) related to this bug. Maybe it helps to solve this issue.
tracking-fennec: ? → +
Masayuki - do you have devices to help test this and further the investigation here?
Flags: needinfo?(masayuki)
QA Contact: kbrosnan → masayuki
No, I don't have such device, I've never met crash Firefox for Android.

Kato-san might have some of them.
Flags: needinfo?(masayuki) → needinfo?(m_kato)
QA Contact: masayuki
We don't have listed devices.
Flags: needinfo?(m_kato)
Flags: needinfo?(lucasr.at.mozilla)

Updated

5 years ago
QA Contact: kbrosnan
We're going to treat this bug in the same way we've treated bug 752828. We'll take a low risk uplift once found, but tracking for specific releases is doing little to help reproduce or move the needle on this.
tracking-firefox20: + → -

Comment 16

5 years ago
This is #8 on 20.0.1 now, here's a split of devices from 20.0.1 in yesterday's data:

android.database.sqlite.SQLiteException: cannot start a transaction within a transaction at android.database.sqlite.SQLiteStatement.native_executeSql(Native Method) 	370
Hisense AD683G 	49
Hisense E860 	33
Sony ST21i 	30
HUAWEI U8815 	29
HUAWEI U8860 	21
Kyocera C5155 	20
Sony ST21a 	18
KYOCERA URBANO PROGRESSO 	13
Kyocera C5170 	13
HUAWEI U8666E 	12
PANASONIC P-07D 	10
Sony ST23i 	9
SHARP IS17SH 	8
HUAWEI U8815N 	5
ZTE Turkcell Maxi Plus 5 	5
ZTE Blade III 	5
ZTE Acqua 	5
NEC N-07D 	4
HUAWEI C8812 	4
FUJITSU F-11D 	4
SHARP SBM106SH 	4
Micromax A100 	3
ZTE ZTE V880E 	3
NEC N-04D 	3
FUJITSU T-02D 	3
ZTE ZTE BLADE III 	3
Samsung SHV-E110S 	3
Basewin T1Ci 	3
SHARP IS15SH 	2
SHARP SH-07D 	2
Sony ST21i2 	2
ZTE ZTE Blade III 	2
Sony C1605 	2
HUAWEI U8950-1 	2
SHARP SH-09D 	2
Sony ST23a 	2
Unknown S100 	2
TCT ALCATEL ONE TOUCH 993D 	1
ZTE N9100 	1
ZTE ZTE R22 	1
Zte V8000_USA_Cricket 	1
ZTE Skate Pro 	1
Unknown Karbonn A21 	1
Unknown A15 	1
Unknown A21 	1
TCT MTC_968 	1
PANTECH IM-A760S 	1
HUAWEI U8825D 	1
KTTech KM-E100 	1
Kyocera Hydro 	1
Lenovo SmartTabII10 	1
HUAWEI U8825-1 	1
HUAWEI U8818 	1
CityTab CityTab 	1
HUAWEI Ascend G 300 	1
HUAWEI U8666E-51 	1
MLW Telecom SpeedUp S3 	1
Manufacturer A10 	1
Samsung SGH-T989D 	1
Samsung SHV-E120S 	1
Sony C1604 	1
Samsung SGH-T989 	1
Acer E330 	1
Medion P4013 	1
Motorola XT897 	1
NEC N-05D 	1
Sony ST21a2 	1
Removing keyword as this isn't being actively investigated and is merely tracking no particular release.
Keywords: qawanted
(Reporter)

Comment 18

5 years ago
It's #70 crasher in 22.0 and #148 in 23.0b1 so no longer a top crash.
Keywords: topcrash
filter on [mass-p5]
Priority: -- → P5
I think I fixed this, but let me grab it to check.
Assignee: lucasr.at.mozilla → rnewman
Status: NEW → ASSIGNED
This was *mostly* fixed, but there's still a very low crash rate with this stack:

android.database.sqlite.SQLiteException: cannot start a transaction within a transaction
	at android.database.sqlite.SQLiteStatement.native_executeSql(Native Method)
	at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:90)
	at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1899)
	at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1839)
	at android.database.sqlite.SQLiteDatabase.beginTransaction(SQLiteDatabase.java:661)
	at android.database.sqlite.SQLiteDatabase.beginTransaction(SQLiteDatabase.java:552)
	at org.mozilla.gecko.db.AbstractTransactionalProvider.beginWrite(AbstractTransactionalProvider.java:121)
	at org.mozilla.gecko.db.BrowserProvider.deleteInTransaction(BrowserProvider.java:407)
	at org.mozilla.gecko.db.AbstractTransactionalProvider.delete(AbstractTransactionalProvider.java:189)
	at android.content.ContentProvider$Transport.delete(ContentProvider.java:215)
	at android.content.ContentResolver.delete(ContentResolver.java:822)
	at org.mozilla.gecko.db.LocalBrowserDB.clearHistory(LocalBrowserDB.java:724)
	at org.mozilla.gecko.GeckoApp$2.run(GeckoApp.java:530)
	at android.os.Handler.handleCallback(Handler.java:605)
	at android.os.Handler.dispatchMessage(Handler.java:92)
	at android.os.Looper.loop(Looper.java:137)
	at org.mozilla.gecko.util.GeckoBackgroundThread.run(GeckoBackgroundThread.java:43)


Should be straightforwardish to find out the cause by code reading.
Assignee: rnewman → nobody
Status: ASSIGNED → NEW

Updated

2 years ago
Crash Signature: [@ android.database.sqlite.SQLiteException: cannot start a transaction within a transaction at android.database.sqlite.SQLiteStatement.native_executeSql(Native Method)] → [@ android.database.sqlite.SQLiteException: cannot start a transaction within a transaction at android.database.sqlite.SQLiteStatement.native_executeSql(Native Method)] [@ android.database.sqlite.SQLiteException: cannot start a transaction within …
You need to log in before you can comment on or make changes to this bug.