csql-users Mailing List for CSQL Main Memory Database / Cache
Main Memory Database Cache
Brought to you by:
prabatuty
Menu
▾
▴
csql-users — Dedicated for CSQL Users
You can subscribe to this list here.
| 2008 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
(1) |
Jul
|
Aug
(1) |
Sep
(1) |
Oct
|
Nov
|
Dec
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2011 |
Jan
|
Feb
|
Mar
|
Apr
(6) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Barney, K. L <Ker...@us...> - 2011-04-28 15:42:51
|
After more testing let me redefine the problem: If I insert rows in Postgres tables these rows propagate to the corresponding CSQL table, and if I insert rows to the CSQL tables they do get propagated to the corresponding Postgres table BUT it only does this when I restart the csqlserver. While csqlserver is running inserts to do not get propagated in either direction. I have tried setting ENABLE_BIDIRECTIONAL_CACHE to true and I have tried setting it to false. Kerry Barney Database Administrator Platforms, United Space Alliance Kennedy Space Center, FL 321-861-7467 ________________________________ From: Barney, Kerry L Sent: Thursday, April 28, 2011 9:15 AM To: csq...@li... Subject: Newbie needs help with caching Postgres tables in CSQL Please help. I am new to CSQL. If I insert rows in Postgres tables these rows propagate to the corresponding CSQL table, but updates to the CSQL tables do not propagate to the corresponding Postgres table. The documentation suggests that this is the default behaviour and yet it does not appear to be working. I attached my csql.conf file. Kerry Barney Database Administrator Platforms, United Space Alliance Kennedy Space Center, FL 321-861-7467 |
|
From: Barney, K. L <Ker...@us...> - 2011-04-28 13:14:06
|
# CSQL System Configuration File #####################################Server Section######################## # Site ID for this CSQL server SITE_ID=1 #Important: For Server section parameters, make sure that the value is same for the # server process and all the csql client process which connects to it. otherwise, # behavior is undefined # Page size. Each database is logically divided into pages and allocation happens # in this unit of pages. Increasing this value will reduce frequent allocation of pages. PAGE_SIZE= 8192 #Total number of client process which can connect and work with the # database concurrently MAX_PROCS = 100 # Maximum size of the system database. MAX_SYS_DB_SIZE=1048576 #Maximum size of the user database file. MAX_DB_SIZE=10485760 #Shared memory key to be used by the system to create and locate system database. SYS_DB_KEY=2222 #Shared memory key to be used by the system to create and locate user database. USER_DB_KEY=3333 #Log level 0->no logging 1->Fine 2->Finer 3->Finest LOG_LEVEL=0 #Give full path for the log file where important system actions are stored. LOG_FILE=/tmp/csql/log/log.out #The virtual memory start address at which the shared memory segment # will be created and attached. MAP_ADDRESS=400000000 # Whether to enable durability DURABILITY=false # Whether to enable memory map architecture for user database MMAP=false # Specifies the durability mode for redo log generation # Valid values are # 1 ->uses standard redo logging with O_APPEND mode # 2 ->uses standard logging with serialization # 3 ->uses O_SYNC flag # 4 ->uses O_DIRECT flag DURABLE_MODE=1 #Give full path for the database file where table and record information will #be stored for durability DATABASE_FILE=/tmp/csql/db #Important: For Server section parameters, make sure that the value is same for the server process and all the csql client process which connects to it. otherwise, behavior is undefined # Give full path for the std error file to store all the errors during database operations STDERR_FILE=stderr #####################################Client Section######################## #Mutex timeout interval seconds MUTEX_TIMEOUT_SECS=0 MUTEX_TIMEOUT_USECS=5000 MUTEX_TIMEOUT_RETRIES=10 #Lock timeout interval seconds LOCK_TIMEOUT_SECS=0 LOCK_TIMEOUT_USECS=5000 LOCK_TIMEOUT_RETRIES=10 #Statement Cache Size STMT_CACHE_SIZE=10 #Enable statement cache for statements with no parameters STMT_CACHE_NOPARAM=false #####################################Cache Section######################## #Whether to enable caching of tables from target database CACHE_TABLE=true #DSN Name to connect to the target database. #This should be present in ~/odbc.ini file DSN=psql USER=postgres PASSWORD= # Whethere to enable bidirectional updates for cached tables. ENABLE_BIDIRECTIONAL_CACHE=false CACHE_RECEIVER_WAIT_SECS=10 #Mode of operation SYNC or ASYNC CACHE_MODE=SYNC ##########################SqlNetworkServer Section######################## # Whether to enable SqlNetwork server CSQL_SQL_SERVER=false #Set port for Network access PORT=5678 # Max number of seconds that the network layer waits to receive a pkt NETWORK_RESPONSE_TIMEOUT=3 # Max number of seconds that the network layer waits to connect to sql server NETWORK_CONNECT_TIMEOUT=5 #Give full path for the file where all the table information is stored TABLE_CONFIG_FILE=/tmp/csql/csqltable.conf #Give full path of the file where all the DSN information is stored DS_CONFIG_FILE=/tmp/csql/csqlds.conf # Give full path for conflict Resolution file CONFL_RESOL_FILE=/tmp/csql/conflResoFile.txt # MSGKEY for creating msg queue for MsgQueue Server MSG_KEY=2525 # Maximum message that the message queue server is able to handle for # asynchronous updates. This value is is default value of 'kernel.msgmax' # parameter. ASYNC_MSGMAX=8192 # Maximum number of messages that the message queue server will hold for a site # that is down in the replication group. MAX_QUEUE_LOGS=100 # Shared memory key for id generators ID_SHM_KEY=1947 #####################################End Section######################## |
|
From: Barney, K. L <Ker...@us...> - 2011-04-15 18:08:18
|
The problem was when running csql it would fail with: csql: symbol lookup error: /usr/lib/libreadline.so.5: undefined symbol: PC Kerry Barney Database Administrator Platforms, United Space Alliance Kennedy Space Center, FL 321-861-7467 ________________________________ From: Barney, Kerry L Sent: Friday, April 15, 2011 2:06 PM To: csq...@li... Subject: Re: [Csql-users] undefined symbol: PC It appears to be working! Solution was: Ran into Red Hat bug 499837(see https://bugzilla.redhat.com/show_bug.cgi?id=499837) The automake package wasn't installed right on my machine. That is why I couldn't use the "configure" command successfully before., so I had manually edited one of the makefiles adding -lncurses. Once the automake package was installed properly we could use the "configure: command to set LDFLAGS to -lncurses. I did not want to cloud the issue but part of what made this work was I changed 2 occurrences of _jstring to __jstring (2 underlines instead of 1) in csql3.0-src/src/jdbc/JSqlStatement.cxx. The error I had was: JSqlStatement.cxx:702: error: '_jstring' was not declared in this scope I am not sure how I figured this out but it seems like alot of people could have that problem too. Kerry Barney Database Administrator Platforms, United Space Alliance Kennedy Space Center, FL 321-861-7467 ________________________________ From: Barney, Kerry L Sent: Thursday, April 14, 2011 11:29 AM To: 'csq...@li...' Subject: undefined symbol: PC I am new to CSQL, and have installed csql3.0-linux-x86_64 on 64 bit linux. When I try to run csql it fails with the following- csql: symbol lookup error: /usr/lib64/libreadline.so.5: undefined symbol: PC csqlserver is running and I could successfully connect to the DSN with isql. My $HOME/.odbc.ini file looks like this: [psql] Description = Postgres ODBC Data source Driver = /usr/lib64/libodbcpsql.so Database = dev2 Servername = localhost UserName = myuser Password = mypassword Port = 5432 ReadOnly = No I built Postgres from the source code and I got the same error as shown below: g++ -O2 -I/home/nihar/jdk1.6.0_11/include -I/home/nihar/jdk1.6.0_11/include/linux -o .libs/csql isql.o -lr t -lpthread -lcrypt -lreadline ../../src/storage/.libs/libcsql.so ../../src/sql/.libs/libcsqlsql.so ../../s rc/sqllog/.libs/libcsqlsqllog.so ../../src/network/.libs/libcsqlnw.so ../../src/adapter/.libs/libcsqlodbcad apter.so ../../src/gateway/.libs/libcsqlgw.so ../../src/cache/.libs/libcacheload.so -lodbc ../../src/sqlnet work/.libs/libcsqlsqlnw.so -Wl,--rpath -Wl,/home/nihar/CSQLRELEASE/OPENSOURCE/csql3.2GA-src/install/lib /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `PC' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgetflag' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgetent' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `UP' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tputs' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgoto' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgetnum' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `BC' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgetstr' collect2: ld returned 1 exit status Kerry Barney Database Administrator Platforms, United Space Alliance Kennedy Space Center, FL 321-861-7467 |
|
From: Barney, K. L <Ker...@us...> - 2011-04-15 18:06:07
|
It appears to be working! Solution was: Ran into Red Hat bug 499837(see https://bugzilla.redhat.com/show_bug.cgi?id=499837) The automake package wasn't installed right on my machine. That is why I couldn't use the "configure" command successfully before., so I had manually edited one of the makefiles adding -lncurses. Once the automake package was installed properly we could use the "configure: command to set LDFLAGS to -lncurses. I did not want to cloud the issue but part of what made this work was I changed 2 occurrences of _jstring to __jstring (2 underlines instead of 1) in csql3.0-src/src/jdbc/JSqlStatement.cxx. The error I had was: JSqlStatement.cxx:702: error: '_jstring' was not declared in this scope I am not sure how I figured this out but it seems like alot of people could have that problem too. Kerry Barney Database Administrator Platforms, United Space Alliance Kennedy Space Center, FL 321-861-7467 ________________________________ From: Barney, Kerry L Sent: Thursday, April 14, 2011 11:29 AM To: 'csq...@li...' Subject: undefined symbol: PC I am new to CSQL, and have installed csql3.0-linux-x86_64 on 64 bit linux. When I try to run csql it fails with the following- csql: symbol lookup error: /usr/lib64/libreadline.so.5: undefined symbol: PC csqlserver is running and I could successfully connect to the DSN with isql. My $HOME/.odbc.ini file looks like this: [psql] Description = Postgres ODBC Data source Driver = /usr/lib64/libodbcpsql.so Database = dev2 Servername = localhost UserName = myuser Password = mypassword Port = 5432 ReadOnly = No I built Postgres from the source code and I got the same error as shown below: g++ -O2 -I/home/nihar/jdk1.6.0_11/include -I/home/nihar/jdk1.6.0_11/include/linux -o .libs/csql isql.o -lr t -lpthread -lcrypt -lreadline ../../src/storage/.libs/libcsql.so ../../src/sql/.libs/libcsqlsql.so ../../s rc/sqllog/.libs/libcsqlsqllog.so ../../src/network/.libs/libcsqlnw.so ../../src/adapter/.libs/libcsqlodbcad apter.so ../../src/gateway/.libs/libcsqlgw.so ../../src/cache/.libs/libcacheload.so -lodbc ../../src/sqlnet work/.libs/libcsqlsqlnw.so -Wl,--rpath -Wl,/home/nihar/CSQLRELEASE/OPENSOURCE/csql3.2GA-src/install/lib /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `PC' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgetflag' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgetent' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `UP' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tputs' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgoto' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgetnum' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `BC' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgetstr' collect2: ld returned 1 exit status Kerry Barney Database Administrator Platforms, United Space Alliance Kennedy Space Center, FL 321-861-7467 |
|
From: Gopal S. <go...@mg...> - 2011-04-15 04:13:57
|
Hi Kerry Barney, Mostly the libreadline.so on your system possible depend on ncurses. You can try installing ncurses-devel and link -lncurses and try. I believe this is not common error. Regards Gopal S -----Original Message----- From: Barney, Kerry L [mailto:Ker...@us...] Sent: Thu 4/14/2011 10:29 AM To: csq...@li... Subject: [Csql-users] undefined symbol: PC I am new to CSQL, and have installed csql3.0-linux-x86_64 on 64 bit linux. When I try to run csql it fails with the following- csql: symbol lookup error: /usr/lib64/libreadline.so.5: undefined symbol: PC csqlserver is running and I could successfully connect to the DSN with isql. My $HOME/.odbc.ini file looks like this: [psql] Description = Postgres ODBC Data source Driver = /usr/lib64/libodbcpsql.so Database = dev2 Servername = localhost UserName = myuser Password = mypassword Port = 5432 ReadOnly = No I built Postgres from the source code and I got the same error as shown below: g++ -O2 -I/home/nihar/jdk1.6.0_11/include -I/home/nihar/jdk1.6.0_11/include/linux -o .libs/csql isql.o -lr t -lpthread -lcrypt -lreadline ../../src/storage/.libs/libcsql.so ../../src/sql/.libs/libcsqlsql.so ../../s rc/sqllog/.libs/libcsqlsqllog.so ../../src/network/.libs/libcsqlnw.so ../../src/adapter/.libs/libcsqlodbcad apter.so ../../src/gateway/.libs/libcsqlgw.so ../../src/cache/.libs/libcacheload.so -lodbc ../../src/sqlnet work/.libs/libcsqlsqlnw.so -Wl,--rpath -Wl,/home/nihar/CSQLRELEASE/OPENSOURCE/csql3.2GA-src/install/lib /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `PC' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgetflag' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgetent' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `UP' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tputs' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgoto' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgetnum' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `BC' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgetstr' collect2: ld returned 1 exit status Kerry Barney Database Administrator Platforms, United Space Alliance Kennedy Space Center, FL 321-861-7467 |
|
From: Barney, K. L <Ker...@us...> - 2011-04-14 15:29:00
|
I am new to CSQL, and have installed csql3.0-linux-x86_64 on 64 bit linux. When I try to run csql it fails with the following- csql: symbol lookup error: /usr/lib64/libreadline.so.5: undefined symbol: PC csqlserver is running and I could successfully connect to the DSN with isql. My $HOME/.odbc.ini file looks like this: [psql] Description = Postgres ODBC Data source Driver = /usr/lib64/libodbcpsql.so Database = dev2 Servername = localhost UserName = myuser Password = mypassword Port = 5432 ReadOnly = No I built Postgres from the source code and I got the same error as shown below: g++ -O2 -I/home/nihar/jdk1.6.0_11/include -I/home/nihar/jdk1.6.0_11/include/linux -o .libs/csql isql.o -lr t -lpthread -lcrypt -lreadline ../../src/storage/.libs/libcsql.so ../../src/sql/.libs/libcsqlsql.so ../../s rc/sqllog/.libs/libcsqlsqllog.so ../../src/network/.libs/libcsqlnw.so ../../src/adapter/.libs/libcsqlodbcad apter.so ../../src/gateway/.libs/libcsqlgw.so ../../src/cache/.libs/libcacheload.so -lodbc ../../src/sqlnet work/.libs/libcsqlsqlnw.so -Wl,--rpath -Wl,/home/nihar/CSQLRELEASE/OPENSOURCE/csql3.2GA-src/install/lib /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `PC' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgetflag' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgetent' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `UP' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tputs' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgoto' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgetnum' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `BC' /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/libreadline.so: undefined reference to `tgetstr' collect2: ld returned 1 exit status Kerry Barney Database Administrator Platforms, United Space Alliance Kennedy Space Center, FL 321-861-7467 |
|
From: Zheng, W. (N. - CN/Beijing) <wen...@ns...> - 2008-09-15 20:07:24
|
Best regards, Zheng wenxing ----------------------------------------------------- Nokia Siemens Network TEL : 010-8435 8908 ADDR: A2074, 14# Jiuxianqiao Road, Chaoyang,Beijing,100016 |
|
From: prabakaran <pra...@ya...> - 2008-06-03 05:30:21
|
Hi Team, CSQL 2.0 GA released CSQL is open source updateable bi-directional table level caching solution to improve application performance by 20-100 times. It can also be used as stand alone ultra fast Main Memory Database. To know more about its capabilities, please go through this blog at http://csqlcache.wordpress.com/ This release includes 1.Primitive ODBC Driver 2.Updateable cache tables 3.Bi-Direction update propagation for cache tables 3.cachetable, cacheverify, csqldump tool 4.Recovery in case of gracefull shutdown 5.Transparent pass through to target database for non-cached tables. you can download your copy at http://sourceforge.net/projects/csql/ Hope you enjoy using csql. If you face any issues send an email to csq...@li.... Regards Prabakaran CSQL Team |
|
From: prabakaran <pra...@ya...> - 2008-05-20 04:26:10
|
Hi All,
CSQL2.0 Beta Released.
This release contains operation synchronous table
level caching, gateway, odbc driver, csqldump and
cachetable tool.
Regards
Prabakaran
|
1 message has been excluded from this view by a project administrator.
