Closed zifeishan closed 10 years ago
Will look into it.
I can run on madmax1 09:41:50 [profiler] INFO ext_people SUCCESS [38500 ms] 09:41:50 [profiler] INFO ext_has_spouse_candidates SUCCESS [13672 ms] 09:41:50 [profiler] INFO ext_has_spouse_features SUCCESS [68510 ms] 09:41:50 [profiler] INFO inference_grounding SUCCESS [5617 ms] 09:41:50 [profiler] INFO inference SUCCESS [10198 ms] 09:41:50 [profiler] INFO calibration plot written to /lfs/madmax/0/feiran/deepdive/out/2014-05-05T093932/calibration/has_spouse.is_true.png [0 ms] 09:41:50 [profiler] INFO calibration SUCCESS [926 ms]
seems to me it's assigning id problem, i'll test again
Test using rokcy's database, it runs...
10:05:24 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO Writing grounding queries to file="/tmp/grounding3399495869192337498.sql"
10:05:24 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO Using Greenplum = true
10:05:24 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO Executing grounding query...
10:05:24 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO Executing: "/tmp/assignId5585274005363230742.sh"
10:05:24 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO NOTICE: drop cascades to function _fast_seqassign(character varying,bigint)
10:05:24 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO NOTICE: drop cascades to function fast_seqassign(character varying,bigint)
10:05:24 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO NOTICE: drop cascades to function updateid(bigint,integer,integer[],bigint[],bigint[])
10:05:24 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO NOTICE: drop cascades to function clear_count_1(integer)
10:05:24 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO CREATE FUNCTION
10:05:24 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO NOTICE: table "tmp_gpsid_count" does not exist, skipping
10:05:24 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO CONTEXT: SQL statement "drop table if exists tmp_gpsid_count cascade;"
10:05:24 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO PL/pgSQL function "fast_seqassign" line 2 at execute statement
10:05:24 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO NOTICE: table "tmp_gpsid_count_noagg" does not exist, skipping
10:05:24 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO CONTEXT: SQL statement "drop table if exists tmp_gpsid_count_noagg cascade;"
10:05:24 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO PL/pgSQL function "fast_seqassign" line 3 at execute statement
10:05:25 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO NOTICE: EXECUTING _fast_seqassign()...
10:05:26 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO fast_seqassign
10:05:26 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO ----------------
10:05:26 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO
10:05:26 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO (1 row)
will push again
Fixed in d47f817a6e9f352528a2f70216ca22603c4a4498
Works now!