Page MenuHomePhabricator

Airflow DAG mediawiki_history_denormalize failed with NPE
Closed, ResolvedPublic

Description

DAG: mediawiki_history_denormalize

Run: 2023-11-01, 00:00:00 UTC

Stack:

Exception in thread "main" org.apache.spark.SparkException: Job aborted due to stage failure: Task 0 in stage 377.0 failed 4 times, most recent failure: Lost task 0.3 in stage 377.0 (TID 68176) (an-worker1105.eqiad.wmnet executor 83): java.lang.NullPointerException: Value at index 2 is null
	at org.apache.spark.sql.Row.getAnyValAs(Row.scala:523)
	at org.apache.spark.sql.Row.getInt(Row.scala:245)
	at org.apache.spark.sql.Row.getInt$(Row.scala:245)
	at org.apache.spark.sql.catalyst.expressions.GenericRow.getInt(rows.scala:166)
	at org.wikimedia.analytics.refinery.job.mediawikihistory.page.PageHistoryRunner.$anonfun$run$1(PageHistoryRunner.scala:74)
	at scala.collection.Iterator$$anon$10.next(Iterator.scala:459)
	at scala.collection.Iterator.foreach(Iterator.scala:941)
	at scala.collection.Iterator.foreach$(Iterator.scala:941)
	at scala.collection.AbstractIterator.foreach(Iterator.scala:1429)
	at scala.collection.generic.Growable.$plus$plus$eq(Growable.scala:62)
	at scala.collection.generic.Growable.$plus$plus$eq$(Growable.scala:53)
	at scala.collection.mutable.ArrayBuffer.$plus$plus$eq(ArrayBuffer.scala:105)
	at scala.collection.mutable.ArrayBuffer.$plus$plus$eq(ArrayBuffer.scala:49)
	at scala.collection.TraversableOnce.to(TraversableOnce.scala:315)
	at scala.collection.TraversableOnce.to$(TraversableOnce.scala:313)
	at scala.collection.AbstractIterator.to(Iterator.scala:1429)
	at scala.collection.TraversableOnce.toBuffer(TraversableOnce.scala:307)
	at scala.collection.TraversableOnce.toBuffer$(TraversableOnce.scala:307)
	at scala.collection.AbstractIterator.toBuffer(Iterator.scala:1429)
	at scala.collection.TraversableOnce.toArray(TraversableOnce.scala:294)
	at scala.collection.TraversableOnce.toArray$(TraversableOnce.scala:288)
	at scala.collection.AbstractIterator.toArray(Iterator.scala:1429)
	at org.apache.spark.rdd.RDD.$anonfun$collect$2(RDD.scala:1030)
	at org.apache.spark.SparkContext.$anonfun$runJob$5(SparkContext.scala:2236)
	at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:90)
	at org.apache.spark.scheduler.Task.run(Task.scala:131)
	at org.apache.spark.executor.Executor$TaskRunner.$anonfun$run$3(Executor.scala:497)
	at org.apache.spark.util.Utils$.tryWithSafeFinally(Utils.scala:1439)
	at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:500)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:750)

You can get full logs via:

$ hostname -f
an-launcher1002.eqiad.wmnet
$ sudo -u analytics yarn logs -appOwner analytics -applicationId application_1695896957545_215566

Details

TitleReferenceAuthorSource BranchDest Branch
Update jobs that need refinery-job jar at 0.2.24repos/data-engineering/airflow-dags!535milimetricbump-mw-history-jobmain
Customize query in GitLab

Event Timeline

Perhaps related to recent changes on mediawikihistory to pickup more info from Dumps?

CC @Milimetric

Perhaps related to recent changes on mediawikihistory to pickup more info from Dumps?

CC @Milimetric

More context: I was referring to work from T348767. However, it looks like that code has not been merged yet, so this may be a red herring.

Change 971978 had a related patch set uploaded (by Milimetric; author: Milimetric):

[analytics/refinery/source@master] Update project namespace map view

https://gerrit.wikimedia.org/r/971978

Change 971978 merged by Milimetric:

[analytics/refinery/source@master] Update project namespace map view

https://gerrit.wikimedia.org/r/971978