 |
2010-03-11
|
#1 (permalink)
|
|
Ingres Community
Join Date: Sep 2009
Posts: 33
|
Database reorganization activity has rendered the query plan invalid.
Hi,
I'm using 9.3.0 w32/159, but I've also tried this on 9.3.0 lnx/151 as well.
I have some java code that is executing a prepared statement, but when it does I get the error: "Database reorganization activity has rendered the query plan invalid. Try again after the db activity is complete. In case of dynamic SQL, the statement must be prepared again."
If I run the same query in VisualSQL it executes fine.
I've done some digging and it seems this issue was fixed by patch#13605, but I think this patch was for an earlier version of ingres. I've tried searching the ESD site for it and cant find it.
I've also set the qsf_memory to large as this was another suggestion I found but that has not helped either.
So I'm now kind of stuck. Can anyone suggest what to try next?
The SQL being run is:
Code:
select count(*) as total
from ( select distinct tab1_id
from table1 left outer join table2 on tab2_tab1_id = tab1_id
left outer join table3 on tab3_tab2_id = tab2_id
left outer join table4 on tab4_tab2_id = tab2_id
left outer join table5 on tab5_id = tab3_tab5_id
left outer join table6 on tab6_id = tab5_tab6_id
left outer join table7 on tab7_id = tab6_tab7_id
left outer join table8 on tab8_id = tab4_tab8_id
left outer join table9 on tab9_id = tab8_tab9_id, table10, table11
where tab10_id = tab1_tab10_id
and tab11_id = tab10_datacol1
and tab1_forignkey1_id = tab4_forignkey1_id
and tab1_forignkey1_id = ' 000000161'
and tab6_forignkey2_id = ' 000000181'
and upper(tab1_name) = upper('test')) subselecttable
and the error log has this in it....
Code:
PC_NAME ::[A1\NMSVR\2210 , 8720 , 00000000]: Thu Mar 11 11:39:06 2010 E_GC0151_GCN_STARTUP Name Server normal startup.
PC_NAME ::[my_username , 000021f0]: Thu Mar 11 11:39:13 2010 E_CL2530_CS_PARAM active_limit = 5
PC_NAME ::[my_username , 000021f0]: Thu Mar 11 11:39:13 2010 E_CL2530_CS_PARAM connect_limit = 5
PC_NAME ::[my_username , 000021f0]: Thu Mar 11 11:39:13 2010 E_CL2530_CS_PARAM stack_size = 131072
PC_NAME ::[my_username , 000021f0]: Thu Mar 11 11:39:13 2010 E_CL2530_CS_PARAM security_auditing = OFF
PC_NAME ::[my_username , 000021f0]: Thu Mar 11 11:39:13 2010 E_CL2530_CS_PARAM level = C2
PC_NAME ::[my_username , 000021f0]: Thu Mar 11 11:39:13 2010 E_CL2530_CS_PARAM cp_timer = 0
PC_NAME ::[my_username , 000021f0]: Thu Mar 11 11:39:13 2010 E_CL2530_CS_PARAM database_limit = 32
PC_NAME ::[my_username , 000021f0]: Thu Mar 11 11:39:13 2010 E_CL2530_CS_PARAM event_limit = 0
PC_NAME ::[my_username , 000021f0]: Thu Mar 11 11:39:13 2010 E_CL2530_CS_PARAM log_writer = 1
PC_NAME ::[my_username , 000021f0]: Thu Mar 11 11:39:13 2010 E_CL2530_CS_PARAM name_service = ON
PC_NAME ::[my_username , 000021f0]: Thu Mar 11 11:39:13 2010 E_CL2530_CS_PARAM dmcm = OFF
PC_NAME ::[my_username , 000021f0]: Thu Mar 11 11:39:13 2010 E_CL2530_CS_PARAM date_alias = ANSIDATE
PC_NAME ::[A1\NMSVR\2210 , 8720 , 00000002]: Thu Mar 11 11:39:13 2010 E_GC0153_GCN_SRV_STARTUP Server Registration: class IUSVR, address A1\IUSVR\21f0
PC_NAME ::[A1\IUSVR\21f0 , 8688 , ffffffff, sc0e.c:352 ]: Thu Mar 11 11:39:18 2010 E_SC051D_LOAD_CONFIG Finished loading configuration parameters for configuration '(DMFRCP)' of server type 'RECOVERY'.
PC_NAME ::[A1\IUSVR\21f0 , 8688 , ffffffff, sc0e.c:352 ]: Thu Mar 11 11:39:18 2010 E_SC0129_SERVER_UP Ingres Release II 9.3.0 (int.w32/159) Server -- Normal Startup.
PC_NAME ::[II_ACP , 8364 , 00ab0100, uleformat.c:958 ]: Thu Mar 11 11:39:24 2010 E_SC0129_SERVER_UP Ingres Release II 9.3.0 (int.w32/159) Server -- Normal Startup.
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM active_limit = 32
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM connect_limit = 32
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM cpu_statistics = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM define_address = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM quantum_size = 1000
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM session_accounting = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM stack_size = 153600
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM server_class = INGRES
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM cache_sharing = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM cache_name = cach_def
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_cache_size = 10000
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_free_limit = 313
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_group_count = 1500
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_group_size = 8
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_tab8ify_limit = 7500
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_wb_end = 3000
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_wb_start = 5000
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_write_behind = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM p4k_status = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM p8k_status = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_cache_size = 6000
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_free_limit = 188
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_group_count = 750
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_group_size = 8
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_tab8ify_limit = 4500
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_wb_end = 1800
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_wb_start = 3000
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_separate = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_write_behind = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM p16k_status = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_cache_size = 3000
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_free_limit = 94
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_group_count = 375
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_group_size = 8
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_tab8ify_limit = 2250
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_wb_end = 900
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_wb_start = 1500
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_separate = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_write_behind = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM p32k_status = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_cache_size = 1500
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_free_limit = 47
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_group_count = 150
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_group_size = 8
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_tab8ify_limit = 1125
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_wb_end = 450
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_wb_start = 750
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_separate = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_write_behind = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM p64k_status = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_cache_size = 750
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_free_limit = 23
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_group_count = 50
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_group_size = 8
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_tab8ify_limit = 563
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_wb_end = 225
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_wb_start = 375
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_separate = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_write_behind = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM security_auditing = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM level = C2
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM cache_lock = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM cursor_limit = 128
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM database_limit = 33
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM database_list =
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM cursor_update_tab8e = DEFERRED
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM cursor_default_open = UPDATE
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_build_pages = 16
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_db_cache_size = 40
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_tbl_cache_size = 40
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_int_sort_size = 524288
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmf_tcb_limit = 5000
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM max_tuple_length = 32000
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM event_limit = 80
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM event_priority = 8
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM fast_commit = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM gc_interval = 20
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM gc_num_ticks = 5
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM gc_threshold = 1
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM log_writer = 15
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM name_service = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM default_journaling = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_active_limit = 6
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_old_jcard = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_old_cnf = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_old_idxorder = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_old_subsel = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_memory = 50000000
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_maxmemf = 50
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_timeout_factor = 1
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_stats_nostats_max = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_hash_join = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_new_enum = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_pq_dop = 8
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_pq_threshold = 1000
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_pq_partthreads = 8
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_greedy_factor = 1
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM psf_memory = 5832704
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM psf_maxmemf = 50
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM qef_dsh_memory = 65536000
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM qef_sort_mem = 1048576
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM qef_hash_mem = 20971520
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM qef_sorthash_memory = 111149056
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM qef_max_mem_sleep = 30
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM qflatten_aggregate = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM qflatten_singleton = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM query_flattening = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM qsf_memory = 104857600
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM rdf_max_tbls = 400
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM rdf_memory = 11489280
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM rdf_col_defaults = 50
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM rdf_tbl_synonyms = 50
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM result_structure = heap
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM rule_depth = 20
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM rule_upd_prefetch = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM scf_rows = 20
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM server_class = INGRES
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM sole_server = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM ulm_chunk_size = 524288
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM session_check_interval = 30
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM system_readlock = nolock
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM system_maxlocks = 10000
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM system_timeout = 0
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM system_isolation = read_committed
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM system_lock_level = row
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM log_readnolock = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM log_esc_lpr_sc = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM log_esc_lpr_ut = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM log_esc_lpt_sc = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM log_esc_lpt_ut = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM ambig_replace_64compat = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM rep_qman_threads = 1
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM rep_txq_size = 50
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM rep_sa_locktab8e = user
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM rep_iq_locktab8e = user
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM rep_dq_locktab8e = page
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM rep_dt_maxlocks = 0
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM dmcm = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM default_page_size = 8192
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM blob_etab_structure = BTREE
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM psort_bsize = 1000
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM psort_rows = 10000
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM psort_nthreads = 2
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM pindex_bsize = 5000
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM pindex_nbuffers = 3
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_joinop_timeout = 100
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM opf_timeout_abort = 0
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM blob_etab_page_size = 16384
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM rule_del_prefetch = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM date_alias = ANSIDATE
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM table_auto_structure = ON
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM cache_dynamic = OFF
PC_NAME ::[my_username , 0000225c]: Thu Mar 11 11:39:27 2010 E_CL2530_CS_PARAM qef_no_dependency_chk = OFF
PC_NAME ::[A1\NMSVR\2210 , 8720 , 00000001]: Thu Mar 11 11:39:27 2010 E_GC0153_GCN_SRV_STARTUP Server Registration: class INGRES, address A1\INGRES\225c
PC_NAME ::[A1\INGRES\225c , 8796 , ffffffff, sc0e.c:352 ]: Thu Mar 11 11:39:28 2010 E_SC051D_LOAD_CONFIG Finished loading configuration parameters for configuration '(DEFAULT)' of server type 'DBMS'.
PC_NAME ::[A1\INGRES\225c , 8796 , ffffffff, sc0e.c:352 ]: Thu Mar 11 11:39:28 2010 E_SC0129_SERVER_UP Ingres Release II 9.3.0 (int.w32/159) Server -- Normal Startup.
PC_NAME ::[A1\NMSVR\2210 , 8720 , 00000003]: Thu Mar 11 11:39:31 2010 E_GC0153_GCN_SRV_STARTUP Server Registration: class COMSVR, address A1\COMSVR\22d0
PC_NAME ::[A1\COMSVR\22d0 , 8912 , ffffffff]: Thu Mar 11 11:39:31 2010 E_GC2815_NTWK_OPEN Network open complete for protocol TCP_IP, port A1 (17288).
PC_NAME ::[A1\COMSVR\22d0 , 8912 , ffffffff]: Thu Mar 11 11:39:31 2010 E_GC2A10_LOAD_CONFIG Finished loading configuration parameters for configuration '(DEFAULT)' of server type 'GCC'.
PC_NAME ::[A1\COMSVR\22d0 , 8912 , ffffffff]: Thu Mar 11 11:39:31 2010 E_GC2006_STARTUP Communication Server normal startup: server rev. level II 9.3.
PC_NAME ::[A1\NMSVR\2210 , 8720 , 00000004]: Thu Mar 11 11:39:34 2010 E_GC0153_GCN_SRV_STARTUP Server Registration: class DASVR, address A1\DASVR\2298
PC_NAME ::[A1\DASVR\2298 , 8856 , 00000000]: Thu Mar 11 11:39:34 2010 E_GC4803_NTWK_OPEN Network open complete for protocol TCP_IP, port A17 (17295).
PC_NAME ::[A1\DASVR\2298 , 8856 , 00000000]: Thu Mar 11 11:39:34 2010 E_GC4802_LOAD_CONFIG Finished loading configuration parameters for configuration '(DEFAULT)' of server type 'GCD'.
PC_NAME ::[A1\DASVR\2298 , 8856 , 00000000]: Thu Mar 11 11:39:34 2010 E_GC4800_STARTUP Data Access Server normal startup.
PC_NAME ::[A1\NMSVR\2210 , 8720 , 00000005]: Thu Mar 11 11:39:35 2010 E_GC0153_GCN_SRV_STARTUP Server Registration: class RMCMD, address A1\RMCMD\2388
PC_NAME::[A1\RMCMD\2388 , 9096 , ffffffff]: Thu Mar 11 11:39:35 2010 E_RE0001_RMCMD_UP Visual DBA RMCMD Server -- Normal Startup.
...basically no errors after reporting a normal startup.
Thanks
|
|
|
|
2010-03-11
|
#2 (permalink)
|
|
Ingres Community
Join Date: Mar 2007
Location: Pittsburgh, PA
Posts: 1,230
|
I'd try giving qsf_memory another bump, maybe double it to see if you can make the problem go away.
|
|
|
|
|
2010-03-11
|
#3 (permalink)
|
|
Ingres Community
Join Date: Aug 2008
Location: Munich, Germany
Posts: 144
|
Is E_US1265 message which you get?
Not sure if this could be related to BUG 122625?
Did you also try using a java based sql tool, like squirrel?
|
|
|
|
|
2010-03-11
|
#4 (permalink)
|
|
Ingres Community
Join Date: Sep 2009
Posts: 33
|
Found it!
Entirely my own fault! D'oh! 
I tried upping the qsf memory with no change so I tried running the sql from iReports and it worked fine. So I downloaded Squirrel SQL, (interesting tool by the way - thanks for the introduction to that one), and started building the SQL in there when I spotted the Java app was adding too many parameter values to the prepared statement.
I deleted the unwanted parameter assignment and hey presto it works!! In my defense the error message didn't really point me in that direction.
Thanks for the responses guys.
....I'll get my coat!....
|
|
|
|
|
2010-03-11
|
#5 (permalink)
|
|
Ingres Community
Join Date: Mar 2007
Location: Pittsburgh, PA
Posts: 1,230
|
I would say that is a bug, an entirely inappropriate error message! If you have support, and can take the time, it would be nice to have an issue open on this.
By the way, you could express your query as "select count(distinct tab1_id) from ...." without the subselect. Ideally there would be no performance difference, but the count(distinct) is maybe a little clearer.
|
|
|
|
|
2010-03-12
|
#6 (permalink)
|
|
Ingres Community
Join Date: Sep 2009
Posts: 33
|
Thanks kschendel, I was unaware that I could use count(distinct).
When I came across the query I did think there must be a nicer way of writing it, but time constraints currently leave me with "if it aint broke don't fix it" as the only option when I think something could do with a bit of investigation!
I'll raise an issue on the error message.
|
|
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
Login
Register
Ingres.com
