778935 - 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

Status: RESOLVED WONTFIX

(Firefox for Android Graveyard :: General, defect, P5)

Description

[Scoobidiver (away)]

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

Comment 1

[Naoki Hirata :nhirata (please use needinfo instead of cc)]

URLSs:

1 	https://www.google.com/m?q=gta3+police+cheat&ie=utf-8&oe=utf-8&aq=t&rls=org.mozi
1 	https://www.google.com/m?q=dutch+electronic&ie=utf-8&oe=utf-8&aq=t&rls=org.mozil

Comment 2

[Scoobidiver (away)]

It's #9 top crasher in 18.0, #34 in 19.0b2, #32 in 20.0a2, and #24 in 21.0a1.

Comment 3

[Alex Keybl [:akeybl]]

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.

Comment 4

[Marcia Knous [:marcia]]

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/

Comment 5

[Scoobidiver (away)]

(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.

Comment 6

[bhavana bajaj [:bajaj]]

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 ?

Comment 7

[Kevin Brosnan [Ex-Mozilla]]

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

[Alex Keybl [:akeybl]]

needinfo on lucasr for the second part of comment 6.

Comment 9

[Alex Keybl [:akeybl]]

(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?

Comment 10

[Aaron Train [:aaronmt]]

Maybe Moz Japan has a couple of devices

CC'ing Brian, Makoto andMasayuki,

Comment 11

[Marcus Husar]

I added some information to bug #752828 (comment 31-33) related to this bug. Maybe it helps to solve this issue.

Comment 12

[Lukas Blakk [:lsblakk] use ?needinfo]

Masayuki - do you have devices to help test this and further the investigation here?

Comment 13

[Masayuki Nakano [:masayuki] (he/him)(JST, +0900)]

No, I don't have such device, I've never met crash Firefox for Android.

Kato-san might have some of them.

Comment 14

[Makoto Kato [:m_kato]]

We don't have listed devices.

Comment 15

[Alex Keybl [:akeybl]]

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.

Comment 16

[Robert Kaiser]

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

Comment 17

[Aaron Train [:aaronmt]]

Removing keyword as this isn't being actively investigated and is merely tracking no particular release.

Comment 18

[Scoobidiver (away)]

It's #70 crasher in 22.0 and #148 in 23.0b1 so no longer a top crash.

Comment 19

[Brad Lassey [:blassey] (use needinfo?)]

filter on [mass-p5]

Comment 20

[Richard Newman [:rnewman]]

I think I fixed this, but let me grab it to check.

Comment 21

[Richard Newman [:rnewman]]

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.

Comment 22

[BugBot [:suhaib / :marco/ :calixte]]

Closing because no crashes reported for 12 weeks.

Comment 23

[BugBot [:suhaib / :marco/ :calixte]]

Closing because no crashes reported for 12 weeks.

Comment 24

[jayabalpersonals]

yeah it's very helpful to my education thank you, everyone

https://www.tnpscrock.in/

Comment 25

[Chris Peterson [:cpeterson]]

Removing steps-wanted keyword because this bug has been resolved.