I found a patch for the php extension here: https://issues.apache.org/jira/browse/THRIFT-1067
… this seemed to fix the issue. Thank you Jonathan and Aaron for taking time to provide me with some help! Regarding the compaction I would still love to hear your feedback on how to configure Cassandra accordingly. Here are my facts again: Data size on disk: ~1GB Data Volume: ~150GB free storage OS Volume: ~3GB free storage Tried: nodetool --host localhost compact The logfiles said: ERROR [CompactionExecutor:2] 2011-06-05 11:44:39,346 CompactionManager.java (line 510) insufficient space to compact even the two smallest files, aborting ERROR [CompactionExecutor:2] 2011-06-05 11:44:39,348 CompactionManager.java (line 510) insufficient space to compact even the two smallest files, aborting ERROR [CompactionExecutor:2] 2011-06-05 11:44:39,349 CompactionManager.java (line 510) insufficient space to compact even the two smallest files, aborting INFO [CompactionExecutor:2] 2011-06-05 11:44:39,366 CompactionManager.java (line 539) Compacting Major: [SSTableReader(path='/mnt/cassandra/data/system/LocationInfo-g-81-Data.db'), SSTableReader(path='/mnt/cassandra/data/system/LocationInfo-g-80-Data.db'), SSTableReader(path='/mnt/cassandra/data/system/LocationInfo-g-79-Data.db')] INFO [CompactionExecutor:2] 2011-06-05 11:44:39,502 CompactionIterator.java (line 186) Major@23231510(system, LocationInfo, 386/689) now compacting at 16777 bytes/ms. INFO [CompactionExecutor:2] 2011-06-05 11:44:39,713 CompactionManager.java (line 603) Compacted to /mnt/cassandra/data/system/LocationInfo-tmp-g-82-Data.db. 689 to 446 (~64% of original) bytes for 3 keys. Time: 346ms. ERROR [CompactionExecutor:2] 2011-06-05 11:44:39,726 CompactionManager.java (line 510) insufficient space to compact even the two smallest files, aborting ERROR [CompactionExecutor:2] 2011-06-05 11:44:39,726 CompactionManager.java (line 510) insufficient space to compact even the two smallest files, aborting # du -hs /mnt/cassandra/ 886M /mnt/cassandra/ # df -H Filesystem Size Used Avail Use% Mounted on /dev/sda1 8.5G 4.9G 3.6G 49% / /dev/sda2 158G 1.2G 149G 1% /mnt # nodetool --host localhost info 130915841875673808436922706546793999597 Gossip active : true Load : 1.48 MB Generation No : 1307273982 Uptime (seconds) : 383 Heap Memory (MB) : 89.59 / 822.00 Thank you, Mario 2011/6/5 Mario Micklisch <mario.mickli...@hpm-kommunikation.de> > I tracked down the timestamp submission and everything was fine within the > PHP Libraries. > > The thrift php extension however seems to have an overflow, because it was > now setting now timestamps with also negative values ( -1242277493 ). I > disabled the php extension and as a result I now got correct microsecond > timestamps: 1307270937122897 > > I was using the latest version from > http://www.apache.org/dist/thrift/0.6.1/ to build the extension without > using any special parameters (just ./configure --enable-gen-php=yes and > make install). > > Downloaded and re-compiled it, without any change. I can also see no > compile parameters to set which might help. > > > Any advise where to go from here? > > > Thanks so far! > > Mario > >
